locations_expanded (view)
Data source: Vaccinate The States
8 rows where county = "Lake" and state = "CA"
This data as json, CSV (advanced)
Suggested facets: hours, 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 154 | Lake County Health Services Dept. ~ Public Health Division | CA | Health department | (707) 263-1090 | 922 Bevins Ct, Lakeport, CA 95453 | Lake | {
"unstructured": "Monday - Friday: 8:00 AM \u2013 5:00 PM; Saturday - Sunday: Closed"
} |
http://health.co.lake.ca.us/ | [] |
[
"google_places:ChIJk8uyt8Llg4ARA4NsapbUSP8",
"us_carbon_health:bec69f9f-f2db-478b-92de-bd61a3217df8"
] |
2021-05-05T22:13:29.489207+00:00 | https://www.vaccinatethestates.com/?lng=-122.92265&lat=39.03810#rec2EeopgB7ZWuz6X | rec2EeopgB7ZWuz6X | <Binary: 60 bytes> | 39.0381 | -122.92265 | ||
| 904 | WALMART PHARMACY 10-1979 | CA | Pharmacy | 707-994-1671 | 15960 Dam Rd, Clearlake, CA 95422 | Lake | {
"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:ChIJL90oKPCJg4ARY1LmPKFiXCQ",
"vaccinefinder:8f468557-bb1c-4cc8-af48-f01d2d47f104",
"vaccinespotter_org:799419",
"vaccinefinder_org:8f468557-bb1c-4cc8-af48-f01d2d47f104",
"walmart:1979",
"us_carbon_health:000697b6-47ea-4996-9433-4d95b7008b01",
"_tag_provider:walmart",
"us_carbon_health:5515dc6e-c4ce-47af-aa75-4e657bb410a5"
] |
2021-05-13T17:24:23.900014+00:00 | https://www.vaccinatethestates.com/?lng=-122.61652&lat=38.93118#recCQoA9sDoTOrSsl | recCQoA9sDoTOrSsl | <Binary: 60 bytes> | 38.93118 | -122.61652 | |||
| 1451 | North Lake Medical Pharmacy #1 | CA | Pharmacy | 707-263-6192 | 5136 HILL RD E, Lakeport, CA 95453 | Lake | {
"unstructured": "Monday - Friday: 9:00 AM \u2013 6:00 PM\nSaturday - Sunday: Closed"
} |
[] |
[
"google_places:ChIJ_SBqU9vng4ARroteWXxXzdQ"
] |
2021-05-13T00:34:00.645337+00:00 | https://www.vaccinatethestates.com/?lng=-122.90621&lat=39.10771#recJlOKkAAwdcDxTF | recJlOKkAAwdcDxTF | <Binary: 60 bytes> | 39.10771 | -122.90621 | |||
| 2010 | North Lake Medical Pharmacy #2 | CA | Pharmacy | 707-263-1328 | 347 LAKEPORT BLVD, LAKEPORT, CA 95453 | Lake | {
"unstructured": "Monday - Friday: 9:00 AM \u2013 7:00 PM\nSaturday: 9:00 AM \u2013 1:00 PM\nSunday: Closed"
} |
[] |
[
"google_places:ChIJSyKuS-rlg4ARmdB49Dga5Qo",
"vaccinefinder_org:8684dad0-251d-4c8c-bc89-ed391cf24766",
"us_carbon_health:44632a4d-80c5-4a3a-945d-d755d4b5f165"
] |
2021-05-12T22:22:12.468246+00:00 | https://www.vaccinatethestates.com/?lng=-122.91849&lat=39.03384#recRwJMLQVznCIUsk | recRwJMLQVznCIUsk | <Binary: 60 bytes> | 39.03384 | -122.91849 | |||
| 2285 | RITE AID PHARMACY 06026 | CA | Pharmacy | 707-994-8677 | 15025 OLYMPIC DRIVE, CLEARLAKE, CA 95422 | Lake | {
"unstructured": "Monday - Sunday: 8:00 AM \u2013 9:00 PM"
} |
[
"Johnson & Johnson"
] |
[
"google_places:ChIJu0HxPtqLg4ARwVEeSArf8aQ",
"vaccinefinder:7cf6a364-f34f-4cd0-89f8-4795f01aaa19",
"vaccinespotter_org:7384725",
"vaccinefinder_org:7cf6a364-f34f-4cd0-89f8-4795f01aaa19",
"rite_aid:106026",
"us_carbon_health:f4dfde7e-2aa6-457c-9069-c4ea7a5b9b18",
"_tag_provider:rite_aid"
] |
2021-05-07T22:11:07.257472+00:00 | https://www.vaccinatethestates.com/?lng=-122.63036&lat=38.96135#recVdvgQlejxfe2pj | recVdvgQlejxfe2pj | <Binary: 60 bytes> | 38.96135 | -122.63036 | |||
| 2630 | SAFEWAY PHARMACY #0983 | CA | Pharmacy | 707-263-8779 | 1071 11TH ST, LAKEPORT, CA 95453 | Lake | {
"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:ChIJHX-BzHXmg4AR1RDW3Qfaqn0",
"vaccinefinder:9fd1920b-aaa9-4fbd-841d-611f380b08b0",
"vaccinefinder_org:9fd1920b-aaa9-4fbd-841d-611f380b08b0",
"safeway:983",
"us_giscorps_vaccine_providers:ab0e94e6-2f1f-453d-990f-b2514f8d4cd5",
"vaccinespotter_org:1046838",
"us_carbon_health:c5e29f61-6b3e-4c3a-af23-ae47ed12b116",
"_tag_provider:safeway",
"us_carbon_health:f94d6b70-8558-4993-9465-699c5fa3391f"
] |
2021-03-18T23:15:33+00:00 | https://www.vaccinatethestates.com/?lng=-122.92623&lat=39.04892#recacO2zEx8QkDd1A | recacO2zEx8QkDd1A | <Binary: 60 bytes> | 39.04892 | -122.92623 | |||
| 5983 | Clearlake VA Clinic | CA | Hospital / Clinic | (707) 995-7200 | 15145 Lakeshore Dr, Clearlake, CA 95422 | Lake | {
"unstructured": null
} |
[] |
[] |
2021-05-16T16:13:24.003387+00:00 | https://www.vaccinatethestates.com/?lng=-122.62857&lat=38.94966#rec6DVVAxEAMUQ7HT | rec6DVVAxEAMUQ7HT | <Binary: 60 bytes> | 38.94966 | -122.62857 | |||
| 64370 | North Lake Medical Pharmacy | CA | Unknown | (707) 263-6192 | 5136 Hill Road 3 Lakeport Lakeport, CA 95453 | Lakeport | Lake | 95453 | {
"unstructured": null
} |
https://www.mygnp.com/pharmacies/programs/covid-19-vaccine/ | [] |
[
"us_giscorps_vaccine_providers:e27abdd0-8e5d-4063-9fb5-8f7d19946400"
] |
https://www.vaccinatethestates.com/?lng=-122.90678&lat=39.10379#lcbwtq | lcbwtq | <Binary: 60 bytes> | 39.10379 | -122.90678 |
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;