locations_expanded (view)

Data source: Vaccinate The States

2 rows where county = "Ness" 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
13283 G & L Pharmacy KS Pharmacy 785 798-2897 207 S Pennsylvania, Ness City, KS 67560 Ness City Ness 67560 
{
    "unstructured": "10:00 AM - 04:00 PM Mon-Fri"
}
 https://healthmartcovidvaccine.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:8f22a90f-72b9-4743-b854-2eeef1791b01",
    "vaccinefinder_org:8f22a90f-72b9-4743-b854-2eeef1791b01"
]
   https://www.vaccinatethestates.com/?lng=-99.90544&lat=38.45259#lgcyr lgcyr <Binary: 60 bytes> 38.45259 -99.90544
16481 Ness County Health Department KS Pharmacy (785) 798-3388 202 W Sycamore, Ness City, KS 67560 Ness City Ness 67560 
{
    "unstructured": "8:00 AM - 5:00 PM Mon-Fri, Closed Sat-Sun"
}
   
[]
 
[
    "vaccinefinder:34b08b7c-3184-42e7-a11a-19e0e442dc36",
    "vaccinefinder_org:34b08b7c-3184-42e7-a11a-19e0e442dc36",
    "us_carbon_health:ba7ec213-dce3-43e3-945d-97087f58d93e"
]
   https://www.vaccinatethestates.com/?lng=-99.90716&lat=38.45341#lgymf lgymf <Binary: 60 bytes> 38.45341 -99.90716

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;