locations_expanded (view)

Data source: Vaccinate The States

3 rows where county = "Ellsworth" and state = "KS"

✎ 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
16464 Ellsworth County Health Department KS Pharmacy   1603 N Aylward Ave, Ellsworth, KS 67439 Ellsworth Ellsworth 67439 
{
    "unstructured": ""
}
   
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:d77c4fbb-28ea-4bd0-8322-f6dbb60386f4",
    "vaccinefinder_org:d77c4fbb-28ea-4bd0-8322-f6dbb60386f4",
    "us_carbon_health:70431f79-559a-46f9-8a61-0f0bc3373edf"
]
   https://www.vaccinatethestates.com/?lng=-98.21886&lat=38.74340#lgykd lgykd <Binary: 60 bytes> 38.7434 -98.21886
61716 Ellsworth County Rural Health Clinic - Ellsworth KS Unknown (785) 810-1177 1602 Aylward Ave Ellsworth Ellsworth, KS 67439 Ellsworth Ellsworth 67439 
{
    "unstructured": null
}
 http://www.ewmed.com/?fbclid=IwAR1EMMRh072g0LAzyXT5P_3I1Sa5oZ_PgFRpt1NbVSKbQyebMEN0Cou7qCA 
[]
 
[
    "us_giscorps_vaccine_providers:3e8e1ca4-cf5d-4ee5-8e3d-a4b2b2ee14af"
]
   https://www.vaccinatethestates.com/?lng=-98.21898&lat=38.74195#lcbdhh lcbdhh <Binary: 60 bytes> 38.74195 -98.21898
61726 F & M Health Mart KS Unknown   209 North Douglas Ellsworth, KS 67439 Ellsworth Ellsworth 67439 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141573208"
]
   https://www.vaccinatethestates.com/?lng=-98.23058&lat=38.72984#lcbdhz lcbdhz <Binary: 60 bytes> 38.72984 -98.23058

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;