Data source: · About: vaccinate-ca-datasette

9 rows where Affiliation = "The Medicine Shoppe", Availability Info contains "Yes: appointments available" and Latest report yes? = 1

View and edit SQL

Suggested facets: County, Availability Info, Latest report notes, Latest report (date)

Availability Info (array)

Latest report yes?


  • The Medicine Shoppe · 9
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
rec4coZ1RFGsfto2w The Medicine Shoppe Pharmacy (3507 W Walnut Avenue) Tulare County 3507 W WALNUT AVENUE, VISALIA, CA 93277 36.31269 -119.32957 Pharmacy 1 559-625-5015 ["Yes: appointment required", "Yes: appointments available"] 2021-05-13T18:59:25.000Z [null] 1 The Medicine Shoppe ChIJ7zgJ97MolYARmR5HyCEjkoo 277cd6f7-cd5c-4c15-b512-f419c0fa400f  
rec98J9jAwwtDwff1 The Medicine Shoppe (1477 South San Jacinto Ave.) Riverside County 1477 South San Jacinto Ave., San Jacinto, CA 92583 33.7704 -116.95861 Pharmacy 1 951-654-2791 ["Yes: appointment required", "Yes: appointments available"] 2021-05-21T21:51:53.000Z [null] 1 The Medicine Shoppe ChIJA99Jrcdo24ARf8eq3mEPYEo    
recB6MR6NIizXUFwe The Medicine Shoppe (1121 South State Street) Riverside County 1121 SOUTH STATE STREET, HEMET, CA 92543 33.72897 -116.97168 Pharmacy 1 951-652-5988 ["Yes: appointment required", "Yes: appointments available"] 2021-05-13T18:05:26.000Z [null] 1 The Medicine Shoppe ChIJz6blu29v24ARAy1sZ5rZHP0    
recH99X5ow4TgrNqX Medicine Shoppe (960 E Ojai Ave) Ventura County 960 E Ojai Ave, OJAI, CA 93023 34.44875 -119.23563 Pharmacy 1 805-646-0106 ["Yes: appointment required", "Yes: appointments available"] 2021-05-07T17:29:31.000Z ["May 7: Monday and Friday from 10AM-6PM the Moderna is offered. Tuesday-Thursday from 10AM-6PM the Johnson & Johnson is offered"] 1 The Medicine Shoppe ChIJWfddpTWl6YARou48MAk4zAY be60f39d-3240-4a04-91e7-db6cff3b9a71  
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  
recga1sMy9JNqKytQ The Medicine Shoppe Pharmacy (2196 S Saviers Rd Mission Village Shopping Center) Ventura County 2196 S SAVIERS RD MISSION VILLAGE SHOPPING CENTER, OXNARD, CA 93033 34.17857 -119.17702 Pharmacy 1 805-487-6303 ["Yes: appointment required", "Yes: appointments available"] 2021-05-19T01:00:01.000Z ["May 18: Moderna is only offered on Friday."] 1 The Medicine Shoppe ChIJFS7x3IxO6IARrql2NwV6n0Y    
recpF8sHcLM51J80i The Medicine Shoppe (31946 Mission Trail Ste. A1) Riverside County 31946 Mission Trail Ste. A1, Lake Elsinore, CA 92530 33.65527 -117.29733 Pharmacy 1 (951) 245-1373 ["Yes: appointment required", "Yes: appointments available"] 2021-05-12T22:53:37.000Z [null] 1 The Medicine Shoppe ChIJifinXt2b3IAR7nm2fIEvONw f9ba55d9-7827-4895-86fb-651960dee1f8  
recpuGhOd28VJnObW The Medicine Shoppe Pharmacy (195 West Shaw Ave 101A) Fresno County 195 WEST SHAW AVE 101A, CLOVIS, CA 93612 36.80907 -119.71341 Pharmacy 1 559-297-0251 ["Yes: appointment required", "Yes: appointments available"] 2021-05-03T21:59:10.000Z [null] 1 The Medicine Shoppe ChIJHS_QL2RclIARNb8AMySH0Qc    
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