locations_expanded (view)

Data source: Vaccinate The States

4 rows where county = "Butler" 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
16765 Express Rx of Morgantown KY Pharmacy (270) 526-3332 211 South Main Street, Morgantown, KY 42261 Morgantown Butler 42261 
{
    "unstructured": "8:30 AM - 6:00 PM Mon-Fri, 9:00 AM - 1:00 PM Sat, Closed Sun"
}
 http://www.expressrx.net 
[]
 
[
    "vaccinefinder:6f3ababa-a1e3-4615-9554-35e10954c24e",
    "vaccinefinder_org:6f3ababa-a1e3-4615-9554-35e10954c24e",
    "us_carbon_health:fcdca069-ad3e-4e16-8835-92231071c6aa"
]
   https://www.vaccinatethestates.com/?lng=-86.68531&lat=37.22353#lgzqg lgzqg <Binary: 60 bytes> 37.22353 -86.68531
31516 Walgreens Co. #19620 KY Pharmacy 270-526-5615 205 West Gl Smith St, Morgantown, KY 42261-9413 Morgantown Butler 42261-9413 
{
    "unstructured": "08:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:19620",
    "vaccinefinder:a47f8a1c-19f7-4638-af5d-9160b6664e80",
    "vaccinefinder_org:a47f8a1c-19f7-4638-af5d-9160b6664e80",
    "_tag_provider:walgreens",
    "us_carbon_health:4dea85b1-bb3b-4cf8-9667-5a83e6c769e7"
]
   https://www.vaccinatethestates.com/?lng=-86.68562&lat=37.22588#lpqkm lpqkm <Binary: 60 bytes> 37.22588 -86.68562
43087 Walgreens Pharmacy KY Unknown   205 West GL Smith St Morgantown, KY 42261 Morgantown Butler 42261 
{
    "unstructured": null
}
 https://www.walgreens.com/findcare/vaccination/covid-19?ban=covid_vaccine_landing_schedule 
[]
 
[
    "ky_govstatus:252",
    "vaccinespotter_org:2720765"
]
   https://www.vaccinatethestates.com/?lng=-86.68590&lat=37.20020#ltmqr ltmqr <Binary: 60 bytes> 37.2002 -86.6859
43702 Butler County Health Department KY Unknown (270) 526-3221 104 N. Warren Street Morgantown, KY 42261 Morgantown Butler 42261 
{
    "unstructured": null
}
 http://www.barrenriverhealth.org 
[
    "Moderna"
]
 
[
    "vaccinefinder_org:535b27d1-670b-495d-9a59-d811282b5ff9"
]
   https://www.vaccinatethestates.com/?lng=-86.68247&lat=37.22470#ltrbh ltrbh <Binary: 60 bytes> 37.2247 -86.68247

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;