Data source: · About: vaccinate-ca-datasette

2 rows where Availability Info contains "No: only vaccinating staff" and Latest report yes? = 1

View and edit SQL

Suggested facets: Latest report (date)

Availability Info (array)

Latest report yes?

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
recv9z3j8ojICkeop Pharmacy for Living Well Orange County 1313 S Harbor Blvd 2nd Level HB, Anaheim, CA 92802 33.80639 -117.9165 Pharmacy 1 657-208-5485 ["Yes: appointment required", "No: only vaccinating staff"] 2021-05-17T16:55:12.000Z ["May 17: This location only provides vaccines to employees of Disney"] 1 None / Unknown / Unimportant ChIJa56JXIms3IARAsgySCXEPZ4    
recxoi8WNS27qxLFv Wonderful Center for Health Innovation - Lost Hills Kern County 13646 Highway 33, Lost Hills, CA 93249 35.65523 -119.89164 Hospital / Clinic 1 (661) 797-6607 ["Yes: appointment required", "Yes: appointments available", "No: only vaccinating staff"] 2021-05-06T21:08:15.000Z [null] 1 None / Unknown / Unimportant ChIJuRyy9Hlp64ARr6vHuMhZQdw    

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