locations_expanded (view)
Data source: Vaccinate The States
7 rows where county = "Amador" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: location_type, hours, vaccines_offered, last_verified_by_vts (date), vaccines_offered (array), concordances (array)
| rowid | name | state | location_type | phone_number | full_address | city | county | zip_code | hours | website | vaccines_offered | concordances | last_verified_by_vts | vts_url | id | geometry | latitude | longitude |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14 | CVS Pharmacy® & Drug Store at 515 S State Highway 49 Jackson, CA 95642 | CA | Pharmacy | 209-223-3784 | 515 S State Highway 49, Jackson CA, 95642 | Amador | {
"unstructured": "Mo-Fr 08:00:00-22:00:00 | Sa 08:00:00-23:00:00 | Su 08:00:00-23:00:00"
} |
https://www.cvs.com/store-locator/details-directions/9233 | [
"Moderna"
] |
[
"google_places:ChIJgQ8P0Nl7moAR0Mzc7trH1f4",
"vaccinefinder:e5b11628-41ea-4c85-b0aa-e61cd0493f31"
] |
2021-05-11T22:39:47.734709+00:00 | https://www.vaccinatethestates.com/?lng=-120.77020&lat=38.34370#rec0CUIubvZwdWl7G | rec0CUIubvZwdWl7G | <Binary: 60 bytes> | 38.3437 | -120.7702 | ||
| 303 | Amador County Public Health and Human Services | CA | Health department | (209) 223-6407 | 10877 Conductor Blvd. Ste 400, Sutter Creek, CA 95685 | Amador | {
"unstructured": "Monday - Friday: 8:00 AM \u2013 5:00 PM; Saturday - Sunday: Closed"
} |
https://www.amadorgov.org/services/public-health | [] |
[
"google_places:ChIJqUF9iGJ8moARlW6Kl29DSuU"
] |
2021-05-05T18:39:42.472378+00:00 | https://www.vaccinatethestates.com/?lng=-120.81795&lat=38.36485#rec4HLaQXFl1BHdHE | rec4HLaQXFl1BHdHE | <Binary: 60 bytes> | 38.36485 | -120.81795 | ||
| 449 | Walgreens #12528 | CA | Pharmacy | 209-267-5128 | 475 State Highway 49, Sutter Creek, CA 95685 | Amador | {
"unstructured": "Monday - Friday: 8:00 AM \u2013 9:00 PM\r\nSaturday: 9:00am - 6:00pm (lunch 1:30 - 2:00pm)\r\nSunday: 10:00am - 6:00pm (lunch 1:30 - 2:00pm)"
} |
[
"Pfizer",
"Johnson & Johnson"
] |
[
"walgreens:12528",
"google_places:ChIJlRnBE317moARWTcdagFnSD4",
"vaccinefinder:b02c7b80-b663-4191-b4e3-433cb5d6af3b",
"vaccinespotter_org:2736945",
"vaccinefinder_org:b02c7b80-b663-4191-b4e3-433cb5d6af3b",
"us_giscorps_vaccine_providers:21da66f2-3746-4ec8-a965-0592810b1bc6",
"_tag_provider:walgreens",
"us_carbon_health:0e78cd80-5d54-4b40-9883-42ca914a49c2",
"us_carbon_health:3c90ead1-c7e1-4d7e-aa6e-c08331c772b8"
] |
2021-05-12T17:02:31.137019+00:00 | https://www.vaccinatethestates.com/?lng=-120.80348&lat=38.38070#rec6GpwGpHL0gANQh | rec6GpwGpHL0gANQh | <Binary: 60 bytes> | 38.3807 | -120.80348 | |||
| 909 | SAFEWAY PHARMACY #2778 | CA | Pharmacy | 209-257-0786 | 12110 INDUSTRY BLVD, JACKSON, CA 95642 | Amador | {
"unstructured": "Monday - Friday: 8:00 AM \u2013 1:00 PM, 1:45 \u2013 7:00 PM\nSaturday: 9:00 AM \u2013 1:00 PM, 1:45 \u2013 5:00 PM\nSunday: 10:00 AM \u2013 1:00 PM, 1:45 \u2013 5:00 PM"
} |
[
"Moderna"
] |
[
"google_places:ChIJnxSXkF17moAR4P50578cYX0",
"vaccinefinder:31e8e399-61d6-42ab-80ab-4488ddf4a7df",
"vaccinespotter_org:1046936",
"safeway:2778",
"vaccinefinder_org:31e8e399-61d6-42ab-80ab-4488ddf4a7df",
"us_giscorps_vaccine_providers:e8ae8009-2d94-42c2-b293-f421375d6c88",
"us_carbon_health:9d9f46bb-74e4-470d-b005-13b05177d707",
"_tag_provider:safeway",
"us_carbon_health:db8c6dae-5a56-4255-adde-6bf321ef60d8"
] |
2021-05-05T00:45:18.046425+00:00 | https://www.vaccinatethestates.com/?lng=-120.79881&lat=38.36794#recCUn5iNZOawET11 | recCUn5iNZOawET11 | <Binary: 60 bytes> | 38.36794 | -120.79881 | |||
| 2631 | Sutter Health Jackson Family Medicine | CA | Hospital / Clinic | (209) 223-2034 | 815 Court St Suite 5, Jackson, CA 95642 | Amador | {
"unstructured": "Monday - Friday: 8:00 AM \u2013 5:00 PM; Saturday - Sunday: Closed"
} |
https://www.sutterhealth.org/find-location/facility/sutter-family-medicine-jackson | [] |
[
"google_places:ChIJV9kXR897moAR35uaqw_s7Wo"
] |
https://www.vaccinatethestates.com/?lng=-120.76575&lat=38.35343#recadfPAgKFJZM0na | recadfPAgKFJZM0na | <Binary: 60 bytes> | 38.35343 | -120.76575 | |||
| 3518 | WALMART PHARMACY 10-2054 | CA | Pharmacy | 209-223-5193 | 10355 WICKLOW WAY, Jackson, CA 95642 | Amador | {
"unstructured": "Monday: 9:00 AM \u2013 7:00 PM\nTuesday: 6:00 AM \u2013 7:00 PM\nWednesday - Friday: 9:00 AM \u2013 7:00 PM\nSaturday: 9:00 AM \u2013 6:00 PM\nSunday: 10:00 AM \u2013 5:00 PM"
} |
[] |
[
"google_places:ChIJWWNXlnd8moAR97j29t8HWZU",
"vaccinefinder:e145615b-3a3b-4664-b1d3-28821efee11a",
"vaccinespotter_org:799400",
"vaccinefinder_org:e145615b-3a3b-4664-b1d3-28821efee11a",
"walmart:2054",
"us_carbon_health:0ef7ae63-ff43-4560-824b-defe9dc291e4",
"_tag_provider:walmart",
"us_carbon_health:a44ebd3b-83e8-48c5-9761-5edbeebbb3e6"
] |
2021-05-06T23:23:12.660986+00:00 | https://www.vaccinatethestates.com/?lng=-120.80733&lat=38.36010#recnTXdu6KMmy85aA | recnTXdu6KMmy85aA | <Binary: 60 bytes> | 38.3601 | -120.80733 | |||
| 3795 | Sutter Amador Hospital – Jackson | CA | Hospital / Clinic | 209-223-7500 | 200 Mission Blvd, Jackson, CA 95642, USA | Amador | {
"unstructured": "Monday - Sunday: Open 24 hours"
} |
[] |
[
"google_places:ChIJiX8Ok9F7moARzebPQsVvWu4"
] |
2021-03-25T21:09:15+00:00 | https://www.vaccinatethestates.com/?lng=-120.76447&lat=38.35048#recrTArP5FqxY6kRK | recrTArP5FqxY6kRK | <Binary: 60 bytes> | 38.35048 | -120.76447 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE VIEW locations_expanded AS select locations.rowid, locations.*, y(locations.geometry) as latitude, x(locations.geometry) as longitude from locations;