locations_expanded (view)

Data source: Vaccinate The States

4 rows where county = "Valley" and state = "ID"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: city, zip_code, vaccines_offered, 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
8046 Sav-On Pharmacy #3360 ID Pharmacy 208-634-2433 132 East Lake St., Mccall, ID 83638 Mccall Valley 83638 
{
    "unstructured": "08:00AM - 08:00PM Mon-Fri, 09:00AM - 06:00PM Sat, 10:00AM - 06:00PM Sun"
}
 https://www.albertsons.com/pharmacy/covid-19.html 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:e8c7f4fb-1f5f-4148-9afd-f01a15ddada5",
    "vaccinefinder_org:e8c7f4fb-1f5f-4148-9afd-f01a15ddada5",
    "sav_on:3360",
    "us_giscorps_vaccine_providers:faa87df4-5d7a-4fdc-886a-c25915d10e17",
    "vaccinespotter_org:1046496",
    "_tag_provider:sav_on",
    "us_carbon_health:9548c8c1-ba4e-4095-9fb0-76e0a75e9bb3"
]
   https://www.vaccinatethestates.com/?lng=-116.10218&lat=44.90993#ldxhg ldxhg <Binary: 60 bytes> 44.90993 -116.10218
13193 Watkins Pharmacy ID Pharmacy 208 382-4204 104 N. Main Street, Cascade, ID 83611 Cascade Valley 83611 
{
    "unstructured": "10:00 AM - 06:00 PM Mon-Fri"
}
 https://healthmartcovidvaccine.com 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:347fc2fa-7a97-405a-9bc0-7869b04d232e",
    "vaccinefinder_org:347fc2fa-7a97-405a-9bc0-7869b04d232e",
    "vaccinespotter_org:141815941"
]
   https://www.vaccinatethestates.com/?lng=-116.04170&lat=44.51627#lgcpz lgcpz <Binary: 60 bytes> 44.51627 -116.0417
13911 Cascade Family Practice ID Pharmacy 208-382-4285 402 Lake Cascade Pkwy, Po Box 1330, Cascade, ID 83611 Cascade Valley 83611 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:357da32b-6cc8-49ed-ab0d-fe4325252bbf",
    "vaccinefinder_org:357da32b-6cc8-49ed-ab0d-fe4325252bbf"
]
   https://www.vaccinatethestates.com/?lng=-116.04952&lat=44.51837#lggkm lggkm <Binary: 60 bytes> 44.51837 -116.04952
22873 Rite Aid #RA105410 ID Pharmacy 208-634-4929 451 Deinhard Lane, Mccall, ID 83638-4800 Mccall Valley 83638-4800 
{
    "unstructured": "09:00 AM-9:00 PM Mon-Fri, 09:00 AM-5:00 PM Sat, 10:00 AM-6:00 PM Sun"
}
 https://www.riteaid.com 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:e41b38d2-2d77-4de8-8608-3ac94a3a16b0"
]
   https://www.vaccinatethestates.com/?lng=-116.09415&lat=44.89897#lkmqb lkmqb <Binary: 60 bytes> 44.89897 -116.09415

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW locations_expanded AS 
select
  locations.rowid,
  locations.*,
  y(locations.geometry) as latitude,
  x(locations.geometry) as longitude
from
  locations;