locations_expanded (view)
Data source: Vaccinate The States
3 rows where county = "Elmore" and state = "ID"
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7197 | Sav-On Pharmacy #165 | ID | Pharmacy | 208-587-3365 | 528 North Main St, Mountain Home, ID 83647 | Mountain Home | Elmore | 83647 | {
"unstructured": "08:00AM - 07:00PM Mon-Fri, 09:00AM - 07:00PM Sat, 10:00AM - 06:00PM Sun"
} |
https://www.albertsons.com/pharmacy/covid-19.html | [] |
[
"vaccinefinder:b1a9671d-d963-4eff-b52f-ddfde6776042",
"vaccinefinder_org:b1a9671d-d963-4eff-b52f-ddfde6776042",
"sav_on:165",
"us_giscorps_vaccine_providers:b150cc40-2a7d-4033-80ea-35caad541a13",
"vaccinespotter_org:1046471",
"_tag_provider:sav_on",
"us_carbon_health:43215df7-2a36-4431-abf2-acfec17de886"
] |
https://www.vaccinatethestates.com/?lng=-115.69704&lat=43.13463#ldrbd | ldrbd | <Binary: 60 bytes> | 43.13463 | -115.69704 | |
| 13205 | Sav Mor Drug | ID | Pharmacy | 208 587-3346 | 490 North 2Nd East, Mountain Home, ID 83647 | Mountain Home | Elmore | 83647 | {
"unstructured": "10:00 AM - 06:00 PM Mon-Fri"
} |
https://healthmartcovidvaccine.com | [
"Moderna",
"Johnson & Johnson"
] |
[
"vaccinefinder:57de3d88-4a35-4a9f-ad53-697479d3b99b",
"vaccinefinder_org:57de3d88-4a35-4a9f-ad53-697479d3b99b",
"vaccinespotter_org:141816093"
] |
https://www.vaccinatethestates.com/?lng=-115.69551&lat=43.13453#lgcqt | lgcqt | <Binary: 60 bytes> | 43.13453 | -115.69551 | |
| 34222 | Walmart Inc #10-2782 | ID | Pharmacy | 2085870601 | 2745 American Legion Blvd, Mountain Home, ID 83647-3185 | Mountain Home | Elmore | 83647-3185 | {
"unstructured": "9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Mon, 6:00 AM - 1:30PM, 2:00 PM - 7:00 PM Tue, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Wed, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Thrus, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Fri, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Sat, 10:00 AM - 1:30PM, 2:00 PM - 6:00 PM Sun"
} |
https://www.walmart.com/store/2782 | [
"Moderna"
] |
[
"vaccinefinder:33363b6e-9375-4641-aed1-cb8a29405250",
"us_carbon_health:34e52e81-f07a-4068-a7e3-33b2077090ad",
"walmart:2782",
"_tag_provider:walmart"
] |
https://www.vaccinatethestates.com/?lng=-115.66798&lat=43.13671#lqfzt | lqfzt | <Binary: 60 bytes> | 43.13671 | -115.66798 |
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;