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

2 rows where Affiliation = "None / Unknown / Unimportant", Availability Info contains "Vaccinating high-risk individuals" and Latest report yes? = 1

View and edit SQL

Suggested facets: Latest report (date)

Latest report yes?

Affiliation

  • None / Unknown / Unimportant · 2
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
rec2ZFbpHfEU7Sa5k AltaMed Pharmacy 3 Los Angeles County 5427 Whittier Blvd, Los Angeles, CA 90022 34.01983 -118.15338 Pharmacy 1 888-909-5232 ["Yes: appointment required", "Yes: restricted to county residents", "Yes: vaccinating 50+", "Vaccinating agriculture and food workers", "Vaccinating education and childcare workers", "Vaccinating emergency services workers", "Vaccinating high-risk individuals"] 2021-04-15T00:54:34.000Z [null] 1 None / Unknown / Unimportant ChIJ3_Mw4KXPwoARX0bcbUOp-Jw    
recTxuRJLLG7J5zlb South Central Family Health Center Los Angeles County 4425 S. Central Ave., Los Angeles, CA 90011 34.00312 -118.25676 Hospital / Clinic 1 http://www.scfhc.org/ ["Yes: appointment calendar currently full", "Yes: appointment required", "Yes: vaccinating 65+", "Vaccinating agriculture and food workers", "Vaccinating education and childcare workers", "Vaccinating emergency services workers", "Vaccinating high-risk individuals"] 2021-03-27T00:31:25.000Z ["If you are not a patient here,\u00a0call 323-905-5810\u00a0to make an appointment or go online to the url above.\u00a0"] 1 None / Unknown / Unimportant ChIJvReKIF7IwoARljBG9gCvtbk    

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