Data source: www.vaccinateca.com · About: vaccinate-ca-datasette
1 row where Availability Info contains "Vaccinating essential workers" and Availability Info contains "Yes: appointment required"
✎ View and edit SQL
Suggested facets: Latest report (date), Latest report notes (array)
Availability Info (array) ✖
|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|
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 );