Data source: · About: vaccinate-ca-datasette

2 rows where Availability Info contains "Yes: vaccinating 75+" 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
rec23unqcrIdHq08p KAISER HEALTH PLAN EAST PHARMACY 583 Sonoma County 401 BICENTENNIAL WAY, SANTA ROSA, CA 95403 38.47162 -122.72598 Pharmacy 1   ["Yes: appointment required", "Yes: must be a current patient", "Yes: vaccinating 75+"] 2021-02-10T05:03:49.000Z [null] 1 Kaiser Permanente ChIJxfkOn304hIARA6MHKpxLCHs 72f4dc7f-3a3a-409d-891b-ca8e159af0fc  
recpBRsZp3BRolTbb KAISER PERMANENTE PHARMACY NO 516 Riverside County 2055 KELLOGG AVE 1ST FLOOR, CORONA, CA 92879 33.85622 -117.55537 Pharmacy 1 Kaiser members can sign in at ["Yes: appointment required", "Yes: must be a current patient", "Yes: vaccinating 75+"] 2021-02-08T02:05:38.000Z ["Feb 07 - Only scheduling appointments for Kaiser members 75+ and healthcare workers. "] 1 Kaiser Permanente ChIJgabHUPfH3IARFkLAlFsh1-o    

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