Data source: · About: vaccinate-ca-datasette

13 rows where Affiliation = "Adventist Health" and Latest report yes? = 1

View and edit SQL

Suggested facets: County, Location Type, Appointment scheduling instructions, Availability Info, Latest report notes, Latest report (date)

Latest report yes?


  • Adventist Health · 13
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
ldkcq Adventist Health Ridgecrest (Mobile Clinic) Kern County 117 N. Alvord Street, Ridgecrest, CA 93555 35.62323 -117.67566 Mobile clinic 1 ["Yes: appointment required", "Yes: vaccinating 18+"] 2021-04-20T22:57:24.000Z [null] 1 Adventist Health      
ldkmc Adventist Health Tehachapi Valley - Rosamond Mobile Clinic Public Library Kern County 3611 Rosamond Blvd, Rosamond, CA 93560 34.86544 -118.19528 Mobile clinic 1 661-771-8400 ["Yes: appointment required", "Yes: restricted to county residents"] 2021-05-20T18:12:09.000Z ["May 20: mobile clinic, call to make an appointment and for the current location/hours.\u00a0"] 1 Adventist Health      
lqxyd Adventist Health Medical Office - Reedley Fresno County 811 East 11th Street Reedley, CA 93654 36.60349 -119.44033 Hospital / Clinic 1 (559) 391-3120 ["Yes: appointment required"] 2021-05-20T18:55:22.000Z [null] 1 Adventist Health      
lqxyy Adventist Health and Rideout (Yuba City) - Conference Center Sutter County 989 Plumas Street, Yuba City, CA, 95991 39.14398 -121.61694 Hospital / Clinic 1 ["Yes: appointment required", "Yes: appointments available"] 2021-05-17T03:03:37.000Z ["May 16: Vaccine varies. Once arriving at your appointment, you will be told which vaccine you are going to get. To schedule an appointment, you must answer the questions in the chat box that pops up once opening up the website."] 1 Adventist Health      
lqygb Jewel City Vaccination Clinic in Glendale Los Angeles County Jewel City Vaccination Clinic in Glendale 1500 N Verdugo Road Glendale CA 91208 34.16748 -118.2286 Mobile clinic 1 ["Yes: appointment required", "Yes: vaccinating 16+"] 2021-04-25T00:29:01.000Z ["Apr 24: At last check (Apr 24) appointments available. You do not need to be an Adventist Health patient to receive a vaccine."] 1 Adventist Health      
lqygc Adventist Health White Memorial Los Angeles County 401 N State St. Los Angeles, CA 90033 34.05035 -118.21621 Hospital / Clinic 1 ["Yes: appointment required", "Yes: appointments available"] 2021-05-05T22:28:57.000Z ["\n"] 1 Adventist Health      
rec7CBUG2vZp9lZTE Adventist Health Tehachapi - Mobile Kern County 3240 Erskine Creek Rd, Lake Isabella, CA 93240 35.61208 -118.46741 Mobile clinic 1 661-771-8400 ["Yes: appointment required"] 2021-05-20T18:05:55.000Z ["May 20: Currently, the mobile health unit will be providing COVID-19 vaccinations to the community. Please call to see if you qualify for a vaccination, and to schedule an appointment"] 1 Adventist Health ChIJkzcW19MzjoARtmC3SB-ByEk    
rec7USI2rfhqJliz9 Adventist Health Lodi Memorial Pharmacy West San Joaquin County 2415 W VINE ST ST 104-B, LODI, CA 95242 38.12263 -121.30476 Pharmacy 1   ["Yes: appointment calendar currently full", "Yes: appointment required"] 2021-05-21T21:53:28.000Z [null] 1 Adventist Health ChIJW50Kl2GgmoARsdey4Qrg22k    
rec84jxnGAAj4hT7F Adventist Health Tehachapi Valley - Mojave Mobile Clinic Kern County 15580 O Street, Mojave, CA 93501 35.04891 -118.16714 Mobile clinic 1 ["Yes: appointment required", "Yes: restricted to county residents"] 2021-05-20T18:02:23.000Z [null] 1 Adventist Health ChIJU5V28uYkwoARIEM9uC8dfIQ    
recRteNxFBTmpw0yt Adventist Health Bakersfield Kern County 2615 Chester Avenue Bakersfield, CA 93301 35.38374 -119.02007 Hospital / Clinic 1 ["Yes: appointment required"] 2021-05-07T21:09:08.000Z [null] 1 Adventist Health ChIJNWHj9pJp6oARxeDDd9xrV4g    
recmXeTLMwsDIt01Q Adventist Health Tehachapi Valley (1100 Magellan Drive) Kern County 1100 Magellan Drive, Tehachapi, CA 93561 35.14744 -118.45044 Hospital / Clinic 1 (661) 771-8401 ["Yes: appointment required", "Yes: appointments available"] 2021-05-17T18:27:02.000Z ["May 17: This number is for a mobile clinic, the location changes daily."] 1 Adventist Health ChIJvwE_JM_3wYARK1ycsDsxu9E    
recnIqRnOxT1n45Qz Adventist Health Delano Kern County 1401 Garces Hwy, Delano, CA 93215 35.76229 -119.23925 Hospital / Clinic 1 ["Yes: appointment required", "Yes: appointments available"] 2021-05-17T17:30:33.000Z [null] 1 Adventist Health ChIJx8b1IiPl6oARW85EyjZp3vQ    
recsNKDJPL6dTfEVS Adventist Health Ukiah Valley Mendocino County 275 Hospital Dr, Ukiah, CA 95482 39.15307 -123.20289 Hospital / Clinic 1 (833) 249-3556 ["Yes: appointment required", "Yes: must be a current patient"] 2021-05-12T22:20:39.000Z [null] 1 Adventist Health ChIJC6SItfpkgYAR59odu5tMtAs    

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