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

2 rows where Availability Info contains "Vaccinating high-risk individuals", Availability Info contains "Yes: must be a current patient" and Latest report yes? = 1

View and edit SQL

Suggested facets: Latest report (date)

Latest report yes?

Affiliation

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
recRDR8GAdbP9La3o Sutter Maternity and Surgery Hospital – Santa Cruz Santa Cruz County 2900 Chanticleer Avenue Santa Cruz, CA 95065 36.98773 -121.97867 Hospital / Clinic 1 (831) 423-4111 ["Yes: appointment required", "Yes: must be a current patient", "Yes: vaccinating 65+", "Vaccinating agriculture and food workers", "Vaccinating education and childcare workers", "Vaccinating emergency services workers", "Vaccinating high-risk individuals"] 2021-03-26T21:59:13.000Z [null] 1 Sutter Health ChIJv0WRtOM_joAR_XKVKwPeEFc    
recqUX8ztRUre8GeZ Sutter Care - Petaluma Sonoma County 411 N McDowell Blvd Unit 41, Suite 10, Petaluma, CA 94954 38.25346 -122.63493 Hospital / Clinic 1 https://myhealthonline.sutterhealth.org/ ["Yes: appointment calendar currently full", "Yes: appointment required", "Yes: must be a current patient", "Yes: vaccinating 65+", "Vaccinating agriculture and food workers", "Vaccinating education and childcare workers", "Vaccinating emergency services workers", "Vaccinating high-risk individuals"] 2021-03-25T21:39:09.000Z [null] 1 Sutter Health ChIJ10JE3Qu0hYARAQgblfezmFM    

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