locations_expanded (view)

Data source: Vaccinate The States

2 rows where county = "Leslie" and state = "KY"

✎ 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
30857 Walgreens Co. #17162 KY Pharmacy 606-672-3811 21287 Highway 421, Hyden, KY 41749-8554 Hyden Leslie 41749-8554 
{
    "unstructured": "08:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Moderna"
]
 
[
    "walgreens:17162",
    "vaccinefinder:68b2f491-3810-408e-98f8-b48f776a73d3",
    "vaccinefinder_org:68b2f491-3810-408e-98f8-b48f776a73d3",
    "_tag_provider:walgreens",
    "us_carbon_health:2a0492a1-48c6-4dd7-b3f4-57f15653f8b7"
]
   https://www.vaccinatethestates.com/?lng=-83.37324&lat=37.16093#lpkxg lpkxg <Binary: 60 bytes> 37.16093 -83.37324
57079 Mary Breckinridge ARH Hospital KY Unknown (855) 274-2273 130 Kate Ireland Drive Hyden, KY 41749 Hyden Leslie 41749 
{
    "unstructured": null
}
   
[]
 
[
    "ky_govstatus:22"
]
   https://www.vaccinatethestates.com/?lng=-83.37871&lat=37.16389#lzbch lzbch <Binary: 60 bytes> 37.16389 -83.37871

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;