vaccinateca

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

Custom SQL query returning 1 row (hide)

select 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 from locations where rowid in ( select locations.rowid from locations, json_each([locations].[Availability Info]) j where j.value = :p0 ) and rowid in ( select locations.rowid from locations, json_each([locations].[Availability Info]) j where j.value = :p1 ) and "Latest report yes?" = :p2 order by id limit 101

Query parameters

This data as json, CSV

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