locations
Data source: www.vaccinateca.com · About: vaccinate-ca-datasette
16 rows where Affiliation = "Pavilions" and Latest report yes? = 1
This data as json, CSV (advanced)
Suggested facets: County, Appointment scheduling instructions, Availability Info, Latest report notes, Latest report (date)
Availability Info (array) ✖
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| rec6vAy9gGi1ML45o | PAVILIONS PHARMACY #2989 | Los Angeles County | 14845 Ventura Blvd, Sherman Oaks, CA 91403 | 34.15238 | -118.45654 | Pharmacy | 1 | ["Yes: walk-ins accepted"] | 2021-05-13T18:46:33.000Z | ["May 13: Vaccinating ages 12+ Monday through Friday from 10AM to 5PM."] | 1 | Pavilions | ChIJ00cEjriXwoARR9VUbIfo-Vw | 670affe0-5c51-4405-8116-fd2f6cd1d43c | 1048248 | |
| rec7V3HSIDR05x0MD | PAVILIONS PHARMACY #2508 | Orange County | 27320 ALICIA PARKWAY, LAGUNA NIGUEL, CA 92656 | 33.56609 | -117.71278 | Pharmacy | 1 | https://local.pharmacy.pavilions.com/ca/laguna-niguel/27320-alicia-pkwy.html | ["Yes: appointment required"] | 2021-05-07T18:40:10.000Z | [null] | 1 | Pavilions | ChIJZyTBakfv3IARA8Kc_cc1SqY | e0a4913e-f9fc-457a-8da2-3f13f066acc0 | 1047821 |
| recB2xSHDlf5EvcXS | PAVILIONS PHARMACY #2214 | Los Angeles County | 1110 ALAMEDA AVE, BURBANK, CA 91506 | 34.16179 | -118.31388 | Pharmacy | 1 | https://www.pavilions.com/pharmacy/covid-19.html | ["Yes: appointments available", "Yes: appointments or walk-ins accepted"] | 2021-05-13T17:52:16.000Z | ["May 13: The Pfizer vaccine is available for ages 12+. Walk-ins are available during pharmacy hours before 5 pm, with the exception of a lunch break from 12-1 pm. "] | 1 | Pavilions | ChIJw-Rpfu-_woARDl92-I4XIE8 | a3236e42-6e81-46e9-adb0-74b69e203644 | |
| recE5KV4AROuY1ZAJ | PAVILIONS PHARMACY #2119 | San Diego County | 3850 VALLEY CENTRE DR, SAN DIEGO, CA 92130 | 32.93899 | -117.23116 | Pharmacy | 1 | https://www.pavilions.com/pharmacy/covid-19.html | ["Yes: appointment required", "Yes: appointments available"] | 2021-05-13T17:09:12.000Z | ["May 13: Pfizer offered to 12+"] | 1 | Pavilions | ChIJlSZH8C8G3IARPFc_fkE8cJU | e205eead-e0c1-4d1b-83d5-4556e03076c0 | 1047809 |
| recKLZFcv37Md069m | PAVILIONS PHARMACY #2229 | Los Angeles County | 727 N VINE ST, LOS ANGELES, CA 90038 | 34.08428 | -118.32679 | Pharmacy | 1 | https://myturn.ca.gov/ | ["Yes: appointment required", "Yes: restricted to county residents"] | 2021-05-07T00:25:01.000Z | [null] | 1 | Pavilions | ChIJ7d9Zlcu4woARbecu5TnbMQ0 | 0c9edc4b-ad5e-4646-bc5c-04a331c4bde4 | 1047818 |
| recRCBbOwuL7x0DHZ | PAVILIONS PHARMACY #2228 | Los Angeles County | 1213 FAIR OAKS AVE, SOUTH PASADENA, CA 91030 | 34.11157 | -118.15117 | Pharmacy | 1 | https://www.pavilions.com/pharmacy/covid-19.html | ["Yes: appointment required", "Yes: restricted to county residents"] | 2021-05-12T22:32:40.000Z | ["May 12: They are offering walk-ins if they have any extra doses"] | 1 | Pavilions | ChIJZ6_51ozEwoARMKokBqe02RU | 16031188-58d2-4af4-8d4d-150b860fcc5b | |
| recT6waDBPx4KH15u | PAVILIONS PHARMACY #2217 | Orange County | 22451 ANTONIO PARKWAY, RANCHO SANTA MARGARITA, CA 92688 | 33.63452 | -117.59159 | Pharmacy | 1 | https://www.pavilions.com/pharmacy/covid-19.html | ["Yes: appointment calendar currently full", "Yes: appointment required"] | 2021-05-12T22:36:31.000Z | ["May 12: Walk-ins are accepted when are are cancellations. If you are interested, the phamracist recommends checking at 4:30PM."] | 1 | Pavilions | ChIJ-4QuExDr3IARNlTHM8pr4xE | dafd044a-9f5c-4ed7-be2b-7249223b738b | 1047816 |
| recUGltvVRcRTBjsS | PAVILIONS PHARMACY #2212 | Los Angeles County | 11030 W JEFFERSON BLVD, CULVER CITY, CA 90230 | 33.9969 | -118.39426 | Pharmacy | 1 | https://www.pavilions.com/pharmacy/covid-19.html | ["Yes: appointment required"] | 2021-05-12T21:52:14.000Z | [null] | 1 | Pavilions | ChIJr3hXVgK6woAR3L_iGh3Ir90 | fac21237-c300-4b8c-ab6a-233f4ad956e6 | 1047812 |
| recWW0gyKoxS9zV0a | Vons Pharmacy #2216 | Orange County | 8010 E SANTA ANA CANYON, ANAHEIM HILLS, CA 92808 | 33.86694 | -117.75146 | Pharmacy | 1 | https://www.vons.com/vaccinations/home?icmpid=von_yxt_r1h2_cvhc_ih | ["Yes: appointment required"] | 2021-05-07T18:00:46.000Z | [null] | 1 | Pavilions | ChIJBQ4PXM7R3IARCX_QHRAkVpE | ac2008a3-735d-4822-bccf-ce840afd6568 | 1047815 |
| recXkCJTk51qAWWvS | Pavilions Pharmacy #2412 | Orange County | 3901 Portola Pkwy, Irvine, CA 92602 | 33.73502 | -117.76072 | Pharmacy | 1 | https://myturn.ca.gov/ | ["Yes: appointment required"] | 2021-05-12T18:39:52.000Z | [null] | 1 | Pavilions | ChIJ_aBYB2Db3IAR7yk1XArrbFQ | 7aa37fbc-7efb-466b-9d61-782bf34a1e68 | 1047820 |
| recbuvJl6zaLob2Ly | PAVILIONS PHARMACY #2210 | Orange County | 26022 MARGUERITE PKY, MISSION VIEJO, CA 92692 | 33.58586 | -117.66027 | Pharmacy | 1 | https://www.mhealthappointments.com/covidappt | ["Yes: appointment required"] | 2021-05-03T18:22:03.000Z | [null] | 1 | Pavilions | ChIJbcVpWbDu3IARB7wMtIgMmzQ | 2f3028a6-3c68-45eb-b318-e6c74603e36e | 1047811 |
| recfdsIRdTp1shWSg | PAVILIONS PHARMACY #2215 | Ventura County | 1135 LINDERO CANYON RD, THOUSAND OAKS, CA 91362 | 34.18428 | -118.78808 | Pharmacy | 1 | https://www.pavilions.com/pharmacy/covid-19.html | ["Yes: appointment required"] | 2021-05-13T16:53:51.000Z | ["May 13: Pfizer is now offered for those ages 12+."] | 1 | Pavilions | ChIJRZKgA8kl6IARePAaTqzbTEk | 6e13ae24-86cb-44ff-969b-87baad3d55fb | 1047814 |
| reckLkPKWl3yipUnV | PAVILIONS PHARMACY #2203 | Los Angeles County | 5949 E SPRING ST, LONG BEACH, CA 90808 | 33.81161 | -118.1158 | Pharmacy | 1 | https://www.pavilions.com/pharmacy/covid-19.html | ["Yes: appointment required"] | 2021-05-17T17:18:33.000Z | ["May 17: This location offers Pfizer to ages 12 and above. "] | 1 | Pavilions | ChIJ90Vdcf8x3YAR9zXio6QKLTo | 6604c90f-0faa-41e7-810b-9336abd66f6e | 1047810 |
| reclxxMQWUjO4nAqV | PAVILIONS PHARMACY #1911 | Orange County | 21181 NEWPORT COAST DR, NEWPORT COAST, CA 92657 | 33.60698 | -117.82762 | Pharmacy | 1 | https://www.mhealthappointments.com/covidappt | ["Yes: appointment required", "Yes: appointments available"] | 2021-04-30T22:14:32.000Z | ["\n"] | 1 | Pavilions | ChIJhZZjUTLn3IARRLPjv5_Rf68 | 021b7425-3034-4c21-b159-b74196ad413c | 1047807 |
| recnTT78Ui6DVHL5w | PAVILIONS PHARMACY #2233 | Los Angeles County | 7 Peninsula Center, Rolling Hills Estates, CA 90274 | 33.77582 | -118.37776 | Pharmacy | 1 | https://www.pavilions.com/pharmacy/covid-19.html | ["Yes: appointment required", "Yes: appointments available"] | 2021-05-17T16:18:37.000Z | [null] | 1 | Pavilions | ChIJC0aE_JBL3YARgWwyMA1_X64 | f29330fd-6f9d-4318-9987-ace3ea30b1d7 | |
| rect3p2Q9RLjX8MSM | PAVILIONS PHARMACY #2089 | Orange County | 600 NORTH COAST HWY, LAGUNA BEACH, CA 92651 | 33.54565 | -117.79274 | Pharmacy | 1 | https://www.pavilions.com/pharmacy/covid-19.html | ["Yes: appointment required"] | 2021-05-12T22:09:53.000Z | [null] | 1 | Pavilions | ChIJ7_3TGSXl3IARSwzsMo3c3hs | 6a972e45-f8f6-487d-a46a-8f085c1c1027 | 1047808 |
Advanced export
JSON shape: default, array, newline-delimited, object
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 );