Data source: www.vaccinateca.com · About: vaccinate-ca-datasette

1 row where Availability Info contains "Vaccinating essential workers" and Latest report yes? = 1 sorted by Latest report notes

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] (
   [id] TEXT PRIMARY KEY,
   [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
);