locations_expanded (view)

Data source: Vaccinate The States

6 rows where county = "Estill" and state = "KY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: phone_number, hours, vaccines_offered, geometry, latitude, longitude, 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
12282 Irvine Health Care Pharmacy #1823827 KY Pharmacy (606) 723-5446 1325 Richmond Road, Irvine, KY 40336 Irvine Estill 40336 
{
    "unstructured": "9:00 AM - 6:00 PM Mon, 9:00 AM - 6:00 PM Tue, 9:00 AM - 6:00 PM Wed, 9:00 AM - 6:30 PM Thrus, 9:00 AM - 6:00 PM Fri, 9:00 AM - 2:00 PM Sat, Closed Sun"
}
 https://irvinehealthcarepharmacy.com/ 
[]
 
[
    "vaccinefinder:3d5f7c7f-db22-41b8-8bd9-4b6eda890e12",
    "vaccinefinder_org:3d5f7c7f-db22-41b8-8bd9-4b6eda890e12"
]
   https://www.vaccinatethestates.com/?lng=-83.99410&lat=37.69904#lfxzk lfxzk <Binary: 60 bytes> 37.69904 -83.9941
12293 Estill Clinic Pharmacy #1829576 KY Pharmacy (606) 723-0044 275 North Court Street, Irvine, KY 40336 Irvine Estill 40336 
{
    "unstructured": "9:00 AM - 5:00 PM Mon-Fri, 9:00 AM - 1:00 PM Sat, Closed Sun"
}
 https://estillclinic.com/ 
[]
 
[
    "vaccinefinder:3eea72dd-78ff-406e-a9ee-86558858dab5"
]
   https://www.vaccinatethestates.com/?lng=-83.97478&lat=37.70540#lfybc lfybc <Binary: 60 bytes> 37.7054 -83.97478
16659 White House Clinics- Irvine KY Pharmacy 6067230665 30 Stacy Lane Road, Irvine, KY 40336 Irvine Estill 40336 
{
    "unstructured": "8:00 AM - 5:00 PM Mon-Fri, Closed Sat-Sun"
}
 http://www.whitehouseclinics.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:e25688dd-a861-45b1-95d0-ab6efb20e400",
    "vaccinefinder_org:e25688dd-a861-45b1-95d0-ab6efb20e400"
]
   https://www.vaccinatethestates.com/?lng=-84.00108&lat=37.70357#lgzdr lgzdr <Binary: 60 bytes> 37.70357 -84.00108
16781 Estill Clinic Pharmacy KY Pharmacy (606) 723-0044 275 N Court St, Irvine, KY 40336 Irvine Estill 40336 
{
    "unstructured": "9:00 AM - 5:00 PM Mon-Fri, 9:00 AM - 1:00 PM Sat, Closed Sun"
}
 http://estillclinic.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:c4281c2a-e1eb-4da7-913a-277f2841e8df"
]
   https://www.vaccinatethestates.com/?lng=-83.97478&lat=37.70540#lgzrg lgzrg <Binary: 60 bytes> 37.7054 -83.97478
16782 Irvine Health Care Pharmacy KY Pharmacy (606) 723-5446 1325 Richmond Road, Suite 1, Irvine, KY 40336 Irvine Estill 40336 
{
    "unstructured": "9:00 AM - 6:00 PM Mon-Fri, 9:00 AM - 2:00 PM Sat, Closed Sun"
}
   
[]
 
[
    "vaccinefinder:ed539eb7-7acf-4117-971c-5101b7928073",
    "vaccinefinder_org:ed539eb7-7acf-4117-971c-5101b7928073"
]
   https://www.vaccinatethestates.com/?lng=-83.99410&lat=37.69904#lgzrh lgzrh <Binary: 60 bytes> 37.69904 -83.9941
30972 Walgreens Co. #17445 KY Pharmacy 606-723-2146 110 Richmond Road, Irvine, KY 40336 Irvine Estill 40336 
{
    "unstructured": "08:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Moderna"
]
 
[
    "walgreens:17445",
    "vaccinefinder:5ecd1e51-7095-4092-8dc1-7c9c0ad995ec",
    "ky_govstatus:244",
    "vaccinefinder_org:5ecd1e51-7095-4092-8dc1-7c9c0ad995ec",
    "us_giscorps_vaccine_providers:d71b6945-8755-4fc9-943f-54830a89b759",
    "vaccinespotter_org:2720643"
]
   https://www.vaccinatethestates.com/?lng=-83.97930&lat=37.69638#lpmgm lpmgm <Binary: 60 bytes> 37.69638 -83.9793

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;