Data source: · About: vaccinate-ca-datasette

1 row where Availability Info contains "Vaccinating essential workers", Availability Info contains "Yes: appointment required" and Latest report yes? = 1 sorted by google_places_id

View and edit SQL

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

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
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