Data source: · About: vaccinate-ca-datasette

1 row where Affiliation = "Safeway", Availability Info contains "Vaccinating high-risk individuals" and Latest report yes? = 1

View and edit SQL

Suggested facets: Latest report (date)

Availability Info (array)

Latest report yes?


  • Safeway · 1
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
recacO2zEx8QkDd1A SAFEWAY PHARMACY #0983 Lake County 1071 11TH ST, LAKEPORT, CA 95453 39.04892 -122.92623 Pharmacy 1 ["Yes: appointment required", "Yes: vaccinating 65+", "Vaccinating high-risk individuals"] 2021-03-18T23:15:33.000Z [null] 1 Safeway ChIJHX-BzHXmg4AR1RDW3Qfaqn0 9fd1920b-aaa9-4fbd-841d-611f380b08b0  

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