locations_expanded (view)

Data source: Vaccinate The States

1 row where county = "Montgomery" and state = "GA"

✎ View and edit SQL

This data as json, CSV (advanced)

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
66154 Montgomery County Health Department (COVID Vaccine) GA Unknown (478) 275-6570 218 West Broad Street Mt. Vernon, GA 30455 Mt. Vernon Montgomery 30455 
{
    "unstructured": null
}
   
[]
 
[
    "us_carbon_health:7cd5e2ef-ee5f-43d4-95bc-61c6894bd768"
]
   https://www.vaccinatethestates.com/?lng=-82.59686&lat=32.17567#lccfth lccfth <Binary: 60 bytes> 32.17567 -82.59686

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;