locations_expanded (view)

Data source: Vaccinate The States

2 rows where county = "Wilkinson" and state = "GA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vaccines_offered (array), 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
42850 Wilkinson County Health Department GA Unknown (844) 987-0099 123 High Hill Street Irwinton Irwinton, GA 31042 Irwinton Wilkinson 31042 
{
    "unstructured": null
}
 https://dph.georgia.gov/locations/wilkinson-county-health-department-irwinton-covid-vaccine 
[]
 
[
    "us_giscorps_vaccine_providers:7273b7ad-79bc-4892-a2dc-9de7d965acd0"
]
   https://www.vaccinatethestates.com/?lng=-83.16833&lat=32.81499#ltkrh ltkrh <Binary: 60 bytes> 32.81499 -83.16833
52011 Gordon Drugs, Inc GA Unknown (478) 628-2425 240 Milledgeville Hwy Gordon, GA 31031 Gordon Wilkinson 31031 
{
    "unstructured": null
}
 http://nowebsite.nothing.com 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:15d1cf91-a0f9-423a-b971-b517cc12de3a"
]
   https://www.vaccinatethestates.com/?lng=-83.33015&lat=32.88262#lxwbg lxwbg <Binary: 60 bytes> 32.88262 -83.33015

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;