locations_expanded (view)

Data source: Vaccinate The States

2 rows where county = "Custer" and state = "ID"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
43260 Eastern Idaho Public Health Challis ID Unknown (208) 533-3223 610 Clinic Road Ste A Challis, ID 83226 Challis Custer 83226 
{
    "unstructured": null
}
 http://www.EIPH.Idaho.gov 
[]
 
[
    "vaccinefinder_org:55083126-1099-45c7-94a1-330c24c29032"
]
   https://www.vaccinatethestates.com/?lng=-114.22456&lat=44.51229#ltpgp ltpgp <Binary: 60 bytes> 44.51229 -114.22456
50494 Salmon River Clinic ID Unknown (208) 774-3565 335 East Main St St. Anthony Stanley, ID 83445 Stanley Custer 83445 
{
    "unstructured": null
}
   
[]
 
[
    "us_giscorps_vaccine_providers:4d23db6d-4536-466e-ae6f-b7482f47f8b0"
]
   https://www.vaccinatethestates.com/?lng=-114.93888&lat=44.21718#lxkbg lxkbg <Binary: 60 bytes> 44.21718 -114.93888

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;