locations_expanded (view)

Data source: Vaccinate The States

3 rows where county = "Boise" and state = "ID"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: city, zip_code, geometry, latitude, longitude, 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
13910 Garden Valley Family Medicine ID Pharmacy 208-809-1492 102 Quinn St, Horseshoe Bend, ID 83629 Horseshoe Bend Boise 83629 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:45ea8450-1228-4b6c-b2bf-0c3cc2d32a10",
    "vaccinefinder_org:45ea8450-1228-4b6c-b2bf-0c3cc2d32a10"
]
   https://www.vaccinatethestates.com/?lng=-116.19698&lat=43.91391#lggkk lggkk <Binary: 60 bytes> 43.91391 -116.19698
13955 Medicap Pharmacy #8427 ID Pharmacy 208-901-8006 284 Village Cir, Ste #100, Garden Valley, ID 83622 Garden Valley Boise 83622 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:4f0430d7-f687-48e6-a505-6d0255b5d3f3",
    "vaccinefinder_org:4f0430d7-f687-48e6-a505-6d0255b5d3f3"
]
   https://www.vaccinatethestates.com/?lng=-115.96963&lat=44.11598#lggqf lggqf <Binary: 60 bytes> 44.11598 -115.96963
19075 Medicap Pharmacy #8427 #Ms1000930 ID Pharmacy 208-571-6434 284 Village Circle Ste 100, Garden Valley, ID 83622 Garden Valley Boise 83622 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:7e626491-99f5-410d-b786-85e743f64675",
    "vaccinefinder_org:7e626491-99f5-410d-b786-85e743f64675"
]
   https://www.vaccinatethestates.com/?lng=-115.96963&lat=44.11598#lhprr lhprr <Binary: 60 bytes> 44.11598 -115.96963

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;