Data source: · About: vaccinate-ca-datasette

1 row where Affiliation = "None / Unknown / Unimportant", Availability Info contains "Vaccinating essential workers" and Latest report yes? = 1 sorted by Latest report

View and edit SQL

Suggested facets: Latest report (date), Latest report notes (array)

Availability Info (array)

Latest report yes?


  • None / Unknown / Unimportant · 1
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
recaeKR6mQLTqp8i8 LA CLINICA DE LA RAZA PHARMACY Alameda County 3451 EAST 12TH STREET, OAKLAND, CA 94601 37.77549 -122.22354 Pharmacy 1 510-535-3050 ["Yes: appointment required", "Yes: must be a current patient", "Yes: vaccinating 65+", "Vaccinating essential workers"] 2021-02-11T22:59:07.000Z ["Feb 11 Moderna; must be 65+ or essential worker. Current patients are prioritized, but they are also keeping a waitlist for others."] 1 None / Unknown / Unimportant ChIJDXBY2vSGj4ARnQKefonQ174    

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