locations_expanded (view)

Data source: Vaccinate The States

2 rows where county = "Fremont" 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
50521 Eastern Idaho Public Health St. Anthony ID Unknown (208) 533-3223 45 South 2nd West St Anthony, ID 83445 St Anthony Fremont 83445 
{
    "unstructured": null
}
 http://www.EIPH.Idaho.gov 
[]
 
[
    "vaccinefinder_org:6d1d0772-2c0c-4796-a9eb-59f2e14b21c8"
]
   https://www.vaccinatethestates.com/?lng=-111.68569&lat=43.96571#lxkdb lxkdb <Binary: 60 bytes> 43.96571 -111.68569
50978 Broulim's Pharmacy - St. Anthony Location ID Unknown (208) 624-3035 301 Aspen Square Saint Anthony, ID 83445 Saint Anthony Fremont 83445 
{
    "unstructured": null
}
 https://broulims.com/covid-19_vaccine 
[]
 
[
    "us_giscorps_vaccine_providers:fa4d063d-2ebc-43c3-9a42-9af1fcdc0c97",
    "vaccinefinder_org:25c2f1ba-fdb8-4a9a-b35d-9311c625c505"
]
   https://www.vaccinatethestates.com/?lng=-111.67707&lat=43.97239#lxmyw lxmyw <Binary: 60 bytes> 43.97239 -111.67707

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;