locations_expanded (view)

Data source: Vaccinate The States

1 row where county = "Ouray" and state = "CO"

✎ 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
58837 Ouray County Public Health CO Unknown   302 2nd Street Ouray, CO 81427 Ouray Ouray 81427 
{
    "unstructured": null
}
 https://ouraycountyco.gov/396/Coronavirus-COVID-19-Updates-and-Resourc 
[]
 
[
    "us_giscorps_vaccine_providers:ee2606ff-b84a-40d3-8b05-f3d19cff289c"
]
   https://www.vaccinatethestates.com/?lng=-107.67245&lat=38.01966#lzmbr lzmbr <Binary: 60 bytes> 38.01966 -107.67245

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;