Data source: · About: vaccinate-ca-datasette

4 rows where Affiliation = "The Medicine Shoppe", Availability Info contains "Yes: appointments or walk-ins accepted" and Latest report yes? = 1

View and edit SQL

Suggested facets: Availability Info, Latest report (date)

Availability Info (array)

Latest report yes?


  • The Medicine Shoppe · 4
id ▼ Name County Address Latitude Longitude Location Type Has Report Appointment scheduling instructions Availability Info Latest report Latest report notes Latest report yes? Affiliation google_places_id vaccinefinder_location_id vaccinespotter_location_id
recAn6pbF9j1WUKaq The Medicine Shoppe (9194 Magnolia Ave) Riverside County 9194 Magnolia Ave, Riverside, CA 92503 33.92336 -117.4407 Pharmacy 1 ["Yes: appointments or walk-ins accepted"] 2021-05-13T18:15:27.000Z ["May 13: Walk-ins welcome Monday-Saturday from 9AM-6PM. Bring a valid ID. "] 1 The Medicine Shoppe ChIJX1nfQnCx3IARLEPhRqfxM60 bd8dce45-34bc-4fb4-876e-a431697822b7  
recK62ARujQ1DQ6Tc The Medicine Shoppe (282 Village Square) Contra Costa County 282 VILLAGE SQUARE, ORINDA, CA 94563 37.88322 -122.19054 Pharmacy 1 ["Yes: appointments or walk-ins accepted"] 2021-05-13T00:28:52.000Z ["May 12: Walk-ins welcome Monday-Friday from 12:30PM-5:30PM. Must have a valid ID."] 1 The Medicine Shoppe ChIJhWIJO9l8hYARbuH00fqKzFE 4d3dfe4f-cf44-4020-bbb0-cb0e0dd2f869  
recWh4tSjPjZDbOQy The Medicine Shoppe Pharmacy (3605 State Street) Santa Barbara County 3605 STATE STREET, SANTA BARBARA, CA 93105 34.44026 -119.74018 Pharmacy 1 805-687-1376 ["Yes: appointments available", "Yes: appointments or walk-ins accepted"] 2021-05-17T16:50:10.000Z [null] 1 The Medicine Shoppe ChIJd8uHLd8U6YAR8lOytQmAcGI 19248683-835b-4ad0-9cc6-bb0131f1288f  
recvnJPwcljtkyQsQ The Medicine Shoppe Pharmacy (9308 B Telephone Rd) Ventura County 9308 B TELEPHONE RD, VENTURA, CA 93004 34.27069 -119.17119 Pharmacy 1 805-647-1133 ["Yes: appointments available", "Yes: appointments or walk-ins accepted"] 2021-05-12T21:34:12.000Z ["May 12: Walk-ins available between 10am-2pm only. "] 1 The Medicine Shoppe ChIJy0i4k89M6IARDbdq68uw9Qs b20f2cac-535f-4cfb-9c35-c84d31c567f9  

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [locations] (
   [Name] TEXT,
   [County] TEXT,
   [Address] TEXT,
   [Latitude] FLOAT,
   [Longitude] FLOAT,
   [Location Type] TEXT,
   [Has Report] INTEGER,
   [Appointment scheduling instructions] TEXT,
   [Availability Info] TEXT,
   [Latest report] TEXT,
   [Latest report notes] TEXT,
   [Latest report yes?] INTEGER,
   [Affiliation] TEXT,
   [google_places_id] TEXT,
   [vaccinefinder_location_id] TEXT,
   [vaccinespotter_location_id] TEXT