locations

Table actions

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

13 rows where Availability Info contains "Scheduling second dose only" and Latest report yes? = 1

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: County, Location Type, Availability Info, Latest report notes, 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
lqyhd Rosemead Community Recreation Center and Park Los Angeles County 3936 Muscatel Avenue Rosemead, CA 91770 34.07949 -118.07685 Mobile clinic 1 https://www.cityofalhambra.org/resources/covid-vaccination-hchc-partnership ["Yes: appointment required", "Scheduling second dose only", "Yes: vaccinating 18+"] 2021-04-25T02:42:04.000Z ["Apr 24: A second-dose clinic will be held on May 21 for people who were vaccinated here on May 23."] 1 Herald Christian Health Center      
recHH3i2Iq5LzmcxB OneMedical - Financial District - Clay San Francisco 559 Clay Street 1st Floor, San Francisco, CA 94111 37.7945 -122.40252 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/559clay/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:51:31.000Z [null] 1 One Medical ChIJo4tDkoqAhYARD-cFk1hjw0s    
recJhsB86RinRnZ1W OneMedical - Financial District - Sutter San Francisco 110 Sutter Street 6th Floor, San Francisco, CA 94104 37.79024 -122.40271 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/110sutter/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:46:54.000Z [null] 1 One Medical ChIJfbdFwImAhYARxsMI-y_wW1A    
recP1p1C3mKuCvSpL OneMedical - Hayes Valley San Francisco 98 Gough Street, San Francisco, CA 94102 37.77398 -122.42217 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/hayesvalley/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:45:18.000Z [null] 1 One Medical ChIJNSm-DZ-AhYARTqWLVvtLO7A    
reca5bAww0NB3FFQl OneMedical - Noe Valley - 24th St San Francisco 3885 24th Street, San Francisco, CA 94114 37.75142 -122.4293 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/noe24th/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:44:11.000Z [null] 1 One Medical ChIJK5jXixN-j4ARIxj-HFUioEo    
recdAFtGeESBw9dVg Sutter Care - West Sacramento Yolo County 2055 Town Center Plaza G130, West Sacramento, CA 95691 38.54956 -121.53731 Hospital / Clinic 1 844-987-6115 ["Yes: appointment required", "Yes: must be a current patient", "Scheduling second dose only"] 2021-03-18T22:42:24.000Z [null] 1 Sutter Health ChIJz7ogCojTmoARhwtFsgOi7Hk    
receFWYmXPhhJy11r OneMedical - Mission - Valencia San Francisco 580 Valencia Street, San Francisco, CA 94110 37.76367 -122.42206 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/mission/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:48:46.000Z [null] 1 One Medical ChIJLSk_8CJ-j4AREXJnMaasc-A    
rechcaZsqpWMdLVfs OneMedical - SoMa - South Park San Francisco 501 2nd Street Suite 415, San Francisco, CA 94107 37.78307 -122.39324 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/501second/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:45:53.000Z [null] 1 One Medical ChIJW3eNBXmAhYARMfO0QjzjCSg    
reciHyYIZrfFWbKzw OneMedical - Inner Sunset San Francisco 840 Irving Street, San Francisco, CA 94122 37.76419 -122.46726 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/innersunset/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:42:55.000Z [null] 1 One Medical ChIJ0xjAr12HhYAR40e5adLNVCQ    
recipMSyaoR3LooEm OneMedical - Laurel Heights San Francisco 3490 California Street Suite 203, San Francisco, CA 94118 37.78684 -122.45157 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/3490california/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:43:23.000Z [null] 1 One Medical ChIJJegV7zOHhYARUAPBAwZnC6U    
recoNqfepUL3DLAg3 OneMedical - Two Embarcadero Center San Francisco Two Embarcadero Center Lobby Level, San Francisco, CA 94111 37.79479 -122.39848 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/2ec/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:48:13.000Z [null] 1 One Medical ChIJZ76fAGGAhYARX3kjrSwKu8Q    
recu946I7abrfZbYn OneMedical - Spear Street San Francisco 201 Spear Street Suite 230, San Francisco, CA 94105 37.79126 -122.39202 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/201spear/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:46:18.000Z [null] 1 One Medical ChIJeQJyF2WAhYARAFIJoEzU-Wg    
recuTUUBEDqbKmPFJ OneMedical - Castro San Francisco 595 Castro Street, San Francisco, CA 94114 37.75949 -122.43456 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/595castro/ ["Yes: must be a current patient", "Scheduling second dose only"] 2021-03-26T21:44:45.000Z [null] 1 One Medical ChIJj98iihN-j4ARjSrdw9AT4qo    

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