locations_expanded (view)

Data source: Vaccinate The States

3 rows where county = "Ballard" and state = "KY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type

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
12266 MedCare Pharmacy & Home Medical #1812886 KY Pharmacy 270-335-3172 409 Court Street, Wickliffe, KY 42087 Wickliffe Ballard 42087 
{
    "unstructured": ""
}
 http://www.medcare-inc.com/MedCare-Pharmacy-and-Home-Medical-Wickliffe 
[]
 
[
    "vaccinefinder:8dc4c185-4f71-4156-ab92-a5c8cf346d1f",
    "vaccinefinder_org:8dc4c185-4f71-4156-ab92-a5c8cf346d1f"
]
   https://www.vaccinatethestates.com/?lng=-89.08891&lat=36.96440#lfxyk lfxyk <Binary: 60 bytes> 36.9644 -89.08891
16824 Sutton Drugs Of La Center KY Pharmacy (270) 665-5192 234 Broadway, La Center, KY 42056 La Center Ballard 42056 
{
    "unstructured": "8:00 AM - 6:00 PM Mon-Fri, 8:00 AM - 12:00 PM Sat, Closed Sun"
}
   
[]
 
[
    "vaccinefinder:280c354d-a40a-4e69-ad72-d50a4302f6f5",
    "vaccinefinder_org:280c354d-a40a-4e69-ad72-d50a4302f6f5"
]
   https://www.vaccinatethestates.com/?lng=-88.97375&lat=37.07496#lgzxb lgzxb <Binary: 60 bytes> 37.07496 -88.97375
48470 Ballard County Health Center KY Unknown (270) 665-5432 198 Bluegrass Drive LaCenter, KY 42056 LaCenter Ballard 42056 
{
    "unstructured": null
}
   
[]
 
[
    "ky_govstatus:367"
]
   https://www.vaccinatethestates.com/?lng=-88.97375&lat=37.07090#lwxmp lwxmp <Binary: 60 bytes> 37.0709 -88.97375

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;