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

23 rows where Affiliation = "One Medical" and Latest report yes? = 1

View and edit SQL

Suggested facets: County, Latitude, Longitude, Appointment scheduling instructions, Availability Info, Latest report notes, google_places_id, Latest report (date)

Latest report yes?

Affiliation

  • One Medical · 23
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
rec4qnYiEvwWTwOo7 One Medical - 21034 Pacific Coast Hwy Orange County 21034 Pacific Coast Hwy Level 2, Suite C230, Huntington Beach, CA 92648 33.65496 -117.99747 Hospital / Clinic 1 https://myturn.ca.gov/ ["Yes: appointment required", "Yes: appointments available"] 2021-05-17T00:15:28.000Z ["May 16: Appointments available on May 18-21"] 1 One Medical ChIJY2AoxEEh3YARsPfcsP5H9MQ    
rec6Su3T8KPhFnxuz One Medical, 12301 Wilshire Blvd Los Angeles County 12301 Wilshire Blvd, Los Angeles, CA 90025 34.06724 -118.40706 Hospital / Clinic 1 https://myturn.ca.gov/ ["Yes: appointment required", "Yes: coming soon", "Yes: restricted to county residents"] 2021-05-06T03:19:20.000Z [null] 1 One Medical ChIJKa5vzfe7woARGUc5NkdrWs8    
rec9phzMGdEBinnb5 OneMedical - Duboce Triangle San Francisco 2175 Market Street, San Francisco, CA 94114 37.76633 -122.43001 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/dubocetriangle/ ["Yes: coming soon"] 2021-04-07T04:57:43.000Z ["Apr 5: Currently working with local health officials to get additional vaccines as quickly as possible. "] 1 One Medical ChIJh23A4ip_j4ARW3m3F01wRwc    
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    
recHyBiRSbHVNZTHN One Medical - 1230 Columbia St San Diego County 1230 Columbia St Suite 100 San Diego, CA 92101 32.71815 -117.1677 Hospital / Clinic 1 (619) 232-3500 ["Yes: appointment required"] 2021-04-27T23:52:18.000Z [null] 1 One Medical ChIJ005ZWMJV2YARuucgy-AqT20    
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    
recL2V2hn1OPPc3fx OneMedical - Transbay Center San Francisco 535 Mission St. Suite 100, San Francisco, CA 94105 37.78905 -122.39829 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/transbaycenter/ ["Yes: coming soon"] 2021-04-07T05:00:15.000Z ["Apr 6: Currently working with local health officials to get additional vaccines as quickly as possible. "] 1 One Medical ChIJLwiwJWOAhYARGaOiwPOYeJo    
recL3JsTADGRH9GDd One Medical - 3850 Barranca Pkwy Orange County 3850 Barranca Pkwy Suite KL, Irvine, CA 92606 33.68412 -117.81189 Hospital / Clinic 1 https://myturn.ca.gov/ ["Yes: appointment calendar currently full", "Yes: appointment required"] 2021-05-17T00:19:42.000Z [null] 1 One Medical ChIJUzF5tgfd3IARV0K7jyQHI-0    
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    
recVRdBUrdNvPFy6b One Medical - 7740 El Camino Real Carlsbad San Diego County 7740 El Camino Real Suite F, Carlsbad, CA 92009 33.08303 -117.26692 Hospital / Clinic 1 https://www.onemedical.com/ ["Yes: appointment calendar currently full", "Yes: appointment required", "Yes: must be a current patient"] 2021-04-27T23:54:00.000Z ["Apr 27: Only offering the second vaccine to patients that have received their fist dose with One Medical."] 1 One Medical ChIJx0KoLvkL3IARpFKubm3xPsc    
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    
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    
recgpy4c0wG67mJz0 OneMedical - Mission Bay San Francisco 1285 4th Street, San Francisco, CA 94158 37.77204 -122.39109 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/mission-bay/ ["Yes: coming soon"] 2021-04-07T04:58:28.000Z ["Apr 5: Currently working with local health officials to get additional vaccines as quickly as possible. "] 1 One Medical ChIJPw1qD_V_j4AR_dSI4J3SO2g    
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    
recmGK65urhl9FCOi One Medical - 350 Bon Air Center Marin County 350 Bon Air Center suite 200, greenbrae, CA 94904 37.94527 -122.52169 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/bonair/?utm_source=google&utm_medium=organic&utm_campaign=localseo ["Yes: coming soon"] 2021-04-07T05:00:58.000Z ["Apr 5: Currently working with local health officials to get additional vaccines as quickly as possible. "] 1 One Medical ChIJX8ufZ22ahYARShU9agpSnlA    
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    
recon8QpBdPp5jybb OneMedical - Cow Hollow - Union Street San Francisco 1823 Union Street, San Francisco, CA 94123 37.79772 -122.42928 Hospital / Clinic 1 https://www.onemedical.com/locations/sf/unionstreet/ ["Yes: coming soon"] 2021-04-06T23:31:20.000Z ["Apr 5: Currently working with local health officials to get additional vaccines as quickly as possible. "] 1 One Medical ChIJIZ5frNyAhYARFkZva7pVX5g    
rectUSGseu99ExORH One Medical - 9725 Wilshire Blvd Los Angeles County 9725 Wilshire Blvd, Beverly Hills, CA 90212 34.06724 -118.40706 Hospital / Clinic 1 https://myturn.ca.gov/ ["Yes: appointment required", "Yes: coming soon", "Yes: must be a current patient", "Yes: restricted to county residents"] 2021-05-06T03:33:54.000Z ["May 5: At this location, Covid vaccines are given during a trial membership."] 1 One Medical ChIJKa5vzfe7woARGUc5NkdrWs8    
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    
recuPegJxr8eMcTWv One Medical - 4 Embarcadero Center San Francisco 4 Embarcadero Center Lobby level, San Francisco, CA 94111 37.79498 -122.39652 Hospital / Clinic 1 https://myturn.ca.gov/ ["Yes: appointment required", "Yes: appointments available"] 2021-05-11T19:25:00.000Z [null] 1 One Medical ChIJpRm_M2GAhYAREu3rUbBzhac    
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
);