locations_expanded (view)

Data source: Vaccinate The States

1 row where county = "Lewis" 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
47605 Arnzen Super Drug-Kamiah ID Unknown (208) 935-2301 318 Main St. Kamiah, ID 83536 Kamiah Lewis 83536 
{
    "unstructured": null
}
 http://www.kamiahdrug.com 
[]
 
[
    "vaccinefinder_org:d4b8684d-0dfc-4b7b-b4f8-c5b204ca0b48"
]
   https://www.vaccinatethestates.com/?lng=-116.02931&lat=46.22712#lwqqk lwqqk <Binary: 60 bytes> 46.22712 -116.02931

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;