Data source: · About: vaccinate-ca-datasette

1 row where Availability Info contains "Vaccinating agriculture and food workers", Availability Info contains "Yes: restricted to city residents" and Latest report yes? = 1 sorted by vaccinefinder_location_id

View and edit SQL

Suggested facets: Latest report (date)

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
recbK3aMWBScuPA7h Excelsior Strong Vaccine Site San Francisco 20 Norton Street, San Francisco, CA 94112 37.72487 -122.43537 Super Site 1 (415) 562-8638 ["Yes: appointment required", "Yes: restricted to city residents", "Yes: vaccinating 16+", "Vaccinating agriculture and food workers", "Vaccinating education and childcare workers", "Vaccinating emergency services workers", "Vaccinating high-risk individuals"] 2021-04-15T15:44:30.000Z [null] 1 County      

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options:

CREATE TABLE [locations] (
   [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