locations_expanded (view)

Data source: Vaccinate The States

4 rows where county = "Fleming" 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
12275 Total Care Pharmacy #1 #1820554 KY Pharmacy (606) 845-2101 209 South Main Cross Street, Flemingsburg, KY 41041 Flemingsburg Fleming 41041 
{
    "unstructured": "9:00 AM - 7:00 PM Mon-Fri, 9:00 AM - 3:30 PM Sat, Closed Sun"
}
 www.totalcarepharmacy.com 
[]
 
[
    "vaccinefinder:66531dfd-260c-4055-a61e-486c51a111bb",
    "vaccinefinder_org:66531dfd-260c-4055-a61e-486c51a111bb"
]
   https://www.vaccinatethestates.com/?lng=-83.73428&lat=38.42071#lfxyz lfxyz <Binary: 60 bytes> 38.42071 -83.73428
12276 Total Care Pharmacy #2 #1820566 KY Pharmacy (606) 845-3421 118 Clark Street, Flemingsburg, KY 41041 Flemingsburg Fleming 41041 
{
    "unstructured": "9:00 AM - 7:00 PM Mon-Fri, 9:00 AM - 3:30 PM Sat, Closed Sun"
}
 http://totalcarepharmacy.com 
[]
 
[
    "vaccinefinder:868a0efe-9783-40a8-aaae-b0222d3b8738",
    "vaccinefinder_org:868a0efe-9783-40a8-aaae-b0222d3b8738"
]
   https://www.vaccinatethestates.com/?lng=-83.73774&lat=38.41796#lfxzb lfxzb <Binary: 60 bytes> 38.41796 -83.73774
57151 J&R Pharmacy of Draffenville KY Unknown (270) 527-3135 34 US HWY 68 East Benton, KY 42025 Benton Fleming 42025 
{
    "unstructured": null
}
 http://jrpharmacyky.com 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:41fe2c17-c92d-4b0d-8669-6b8b4db313ac"
]
   https://www.vaccinatethestates.com/?lng=-83.95841&lat=38.45388#lzbhy lzbhy <Binary: 60 bytes> 38.45388 -83.95841
61180 Flemingsburg Family Health Ctr RX #1832890 KY Unknown (606) 845-0402 520 ELIZAVILLE AVE Flemingsburg, KY 41041 Flemingsburg Fleming 41041 
{
    "unstructured": null
}
 http://www.primaryplus.net 
[
    "Moderna"
]
 
[
    "vaccinefinder_org:7f4dbe34-2e55-44a2-8105-2bb38125a0b9"
]
   https://www.vaccinatethestates.com/?lng=-83.74446&lat=38.42017#lcbbft lcbbft <Binary: 60 bytes> 38.42017 -83.74446

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;