locations_expanded (view)
Data source: Vaccinate The States
9 rows where county = "Yuba" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: last_verified_by_vts (date), vaccines_offered (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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 684 | Sutter Medical Foundation- Brownsville FP | CA | Hospital / Clinic | (530) 675-0466 | 16911 Willow Glen Rd, Challenge-Brownsville, CA 95919 | Yuba | {
"unstructured": "Monday - Friday: 8:00 AM \u2013 5:00 PM; Saturday - Sunday: Closed"
} |
https://www.sutterhealth.org/find-location/facility/sutter-medical-plaza-brownsville | [] |
[
"google_places:ChIJb5uAS4yinIARi4xxy2EIWOI"
] |
https://www.vaccinatethestates.com/?lng=-121.28250&lat=39.46125#rec9b5xH2BPeBS7cj | rec9b5xH2BPeBS7cj | <Binary: 60 bytes> | 39.46125 | -121.2825 | |||
| 706 | WALMART PHARMACY 10-5136 | CA | Pharmacy | 530-634-9760 | 1131 N Beale Rd, MARYSVILLE, CA 95901 | Yuba | {
"unstructured": "Monday: 9:00 AM \u2013 7:00 PM\nTuesday: 6:00 AM \u2013 7:00 PM\nWednesday - Saturday: 9:00 AM \u2013 7:00 PM\nSunday: 10:00 AM \u2013 6:00 PM"
} |
[] |
[
"google_places:ChIJS6_e1KxTm4ARHGmV3uaR13M",
"vaccinefinder:6b63510c-3b84-4fb8-8d67-f949ee1d6cde",
"vaccinespotter_org:799423",
"vaccinefinder_org:6b63510c-3b84-4fb8-8d67-f949ee1d6cde",
"walmart:5136",
"us_carbon_health:8d9ad2f7-5294-4f8f-b0be-772074be0ce5",
"_tag_provider:walmart",
"us_carbon_health:d70f964b-7d63-4990-b4d9-f8df05445286"
] |
2021-05-13T18:27:37.870851+00:00 | https://www.vaccinatethestates.com/?lng=-121.57377&lat=39.12691#rec9xAik3l04haRzU | rec9xAik3l04haRzU | <Binary: 60 bytes> | 39.12691 | -121.57377 | |||
| 1017 | Harmony Health Medical Clinica and Family Resource Center | CA | Hospital / Clinic | (530) 743-6888 | 1908 N. Beale Road, Marsyville, CA 95901 | Yuba | {
"unstructured": "Monday - Friday: 8:00 AM \u2013 7:00 PM; Saturday - Sunday: 9:00 AM \u2013 2:00 PM"
} |
http://www.myharmonyhealth.org/ | [] |
[
"google_places:ChIJUfZDJxpTm4ARcmBuKujziLU"
] |
2021-05-13T17:07:54.688444+00:00 | https://www.vaccinatethestates.com/?lng=-121.54573&lat=39.12753#recDyCOyJqUhQCVBR | recDyCOyJqUhQCVBR | <Binary: 60 bytes> | 39.12753 | -121.54573 | ||
| 2277 | Village Pharmacy (414 Main St) | CA | Pharmacy | 530-633-2819 | 414 MAIN ST, WHEATLAND, CA 95692 | Yuba | {
"unstructured": "Monday - Friday: 9:30 AM \u2013 5:30 PM\nSaturday: 9:00 AM \u2013 2:00 PM\nSunday: Closed"
} |
[
"Moderna"
] |
[
"google_places:ChIJq6FEgbhHm4ARV2msdl86_As",
"vaccinefinder_org:2ad490b1-d6da-47a8-8335-b662389f9e6d",
"us_carbon_health:b3e4ffbb-2107-4a9e-9e83-af481683e5b0"
] |
2021-05-12T21:32:34.078858+00:00 | https://www.vaccinatethestates.com/?lng=-121.42226&lat=39.01028#recVWIE7QYaFQocWL | recVWIE7QYaFQocWL | <Binary: 60 bytes> | 39.01028 | -121.42226 | |||
| 2453 | CVS Pharmacy® & Drug Store at 906 E St. Marysville, CA 95901 | CA | Pharmacy | 530-742-5103 | 906 E St., Marysville CA, 95901 | Yuba | {
"unstructured": "Mo-Fr 07:00:00-00:00:00 | Sa 07:00:00-00:00:00 | Su 07:00:00-00:00:00"
} |
https://www.cvs.com/store-locator/details-directions/9691 | [
"Moderna"
] |
[
"google_places:ChIJkYXaNHJTm4ARjPl60aHAIDE",
"vaccinefinder:9cef8aa3-e6dc-491a-9798-c40a6bca818a"
] |
2021-05-12T17:27:29.912772+00:00 | https://www.vaccinatethestates.com/?lng=-121.59200&lat=39.14530#recYBII96GLq7Na6h | recYBII96GLq7Na6h | <Binary: 60 bytes> | 39.1453 | -121.592 | ||
| 2483 | Ampla Health: Lindhurst Medical, Dental & Xpress Care | CA | Hospital / Clinic | (530) 743-4611 | 4941 Olivehurst Ave Olivehurst, CA 95961 | Yuba | {
"unstructured": "Monday \u2013 Friday 8:00am \u2013 5:00pm"
} |
https://www.amplahealth.org/health-centers/lindhurst-medical-dental/ | [] |
[
"google_places:ChIJG1P6MQhSm4ARgVrLqESQRKU",
"us_carbon_health:fc856095-bf3c-4d07-bda2-5cbd068ffefd"
] |
2021-05-12T18:23:02.025282+00:00 | https://www.vaccinatethestates.com/?lng=-121.55143&lat=39.09761#recYbAfHxB5kpwji6 | recYbAfHxB5kpwji6 | <Binary: 60 bytes> | 39.09761 | -121.55143 | ||
| 2563 | WALGREENS #2277 | CA | Pharmacy | 530-743-2594 | 602 10TH STREET, MARYSVILLE, CA 95901 | Yuba | {
"unstructured": "Monday - Friday: 8:00 AM \u2013 9:00 PM\nSaturday: 9:00am - 6:00pm (lunch 1:30 - 2:00pm)\nSunday: 10:00am - 6:00pm (lunch 1:30 - 2:00pm)"
} |
[
"Pfizer"
] |
[
"google_places:ChIJo29NgHFTm4AR2XsYRSQOctU",
"vaccinefinder:a45eff0f-0bad-4acf-b543-48a7e90832a3",
"walgreens:2277",
"vaccinespotter_org:2736973",
"vaccinefinder_org:a45eff0f-0bad-4acf-b543-48a7e90832a3",
"_tag_provider:walgreens",
"us_carbon_health:4fa2ab2f-f2cb-427a-8ffc-613620de29cc",
"us_carbon_health:ed59b22b-5d6b-4ac8-89d8-8edfd6dab77d"
] |
2021-05-12T00:55:59.543310+00:00 | https://www.vaccinatethestates.com/?lng=-121.59293&lat=39.14543#recZnd5BV0wX9UWQW | recZnd5BV0wX9UWQW | <Binary: 60 bytes> | 39.14543 | -121.59293 | |||
| 3445 | RITE AID PHARMACY 06557 | CA | Pharmacy | 530-634-9970 | 5075 OLIVEHURST AVENUE, OLIVEHURST, CA 95961 | Yuba | {
"unstructured": "Monday - Sunday: 8:00 AM \u2013 10:00 PM"
} |
[
"Johnson & Johnson"
] |
[
"google_places:ChIJz0SLHglSm4ARhOIHaYd7kDs",
"vaccinefinder:a46bc40e-1a45-40c4-8f16-f410d0f97b2b",
"vaccinespotter_org:7384756",
"vaccinefinder_org:a46bc40e-1a45-40c4-8f16-f410d0f97b2b",
"rite_aid:106557",
"us_carbon_health:859e3f50-bac8-4073-988d-3c6e7811e137",
"_tag_provider:rite_aid"
] |
2021-05-08T23:34:48.907248+00:00 | https://www.vaccinatethestates.com/?lng=-121.55044&lat=39.10094#recmTErk4n98s4NeH | recmTErk4n98s4NeH | <Binary: 60 bytes> | 39.10094 | -121.55044 | |||
| 36751 | Harmony Health | CA | Hospital / Clinic | (530)743-6888 | 1908 N Beale Rd, Marysville, CA 95901 | Marysville | Yuba | 95901 | {
"unstructured": ""
} |
https://www.myharmonyhealth.org/covid-19-vaccine | [] |
[] |
2021-05-17T03:39:37.497307+00:00 | https://www.vaccinatethestates.com/?lng=-121.54564&lat=39.12770#lqxyz | lqxyz | <Binary: 60 bytes> | 39.1277 | -121.54564 |
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;