locations_expanded (view)

Data source: Vaccinate The States

10 rows where county = "Nelson" and state = "KY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, website, vaccines_offered, geometry, longitude, 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
9411 Medica Pharmacy & Wellness Center #181332 KY Pharmacy 502-348-6623 202 W Stephen Foster Ave, Bardstown, KY 40004 Bardstown Nelson 40004 
{
    "unstructured": ""
}
 http://www.medicapharmacy.net 
[]
 
[
    "vaccinefinder:25820636-248a-448e-befd-5e398c57b327",
    "vaccinespotter_org:141715072",
    "vaccinefinder_org:25820636-248a-448e-befd-5e398c57b327",
    "us_carbon_health:5d3fc7a1-4dc7-45dd-9b9b-839263f228d1"
]
   https://www.vaccinatethestates.com/?lng=-85.46886&lat=37.80995#lfdtc lfdtc <Binary: 60 bytes> 37.80995 -85.46886
9417 Medica Pharmacy Bloomfield #183436 KY Pharmacy (502) 252-8242 204 Chaplin Rd, Bloomfield, KY 40008 Bloomfield Nelson 40008 
{
    "unstructured": "9:00 AM - 6:00 PM Mon-Fri, 9:00 AM - 1:00 PM Sat,  Sun"
}
 http://www.medicapharmacy.net 
[]
 
[
    "vaccinefinder:27eb8ed8-e193-4ba5-b774-65f3938031b8",
    "vaccinefinder_org:27eb8ed8-e193-4ba5-b774-65f3938031b8",
    "us_carbon_health:7bee2dbd-8944-4cbc-a957-718cf607309d"
]
   https://www.vaccinatethestates.com/?lng=-85.31772&lat=37.91210#lfdtm lfdtm <Binary: 60 bytes> 37.9121 -85.31772
14677 The Little Clinic #18118 KY Pharmacy 502-348-7880 102 W John Rowan Blvd, Bardstown, KY 40004-2663 Bardstown Nelson 40004-2663 
{
    "unstructured": ""
}
 Thelittleclinic.com 
[]
 
[
    "vaccinefinder:441415e6-3a8b-4ce5-91dd-6c991188fd5b"
]
   https://www.vaccinatethestates.com/?lng=-85.46489&lat=37.82823#lgmkm lgmkm <Binary: 60 bytes> 37.82823 -85.46489
14959 Kroger Pharmacy #02400408 KY Pharmacy (502) 348-3062 102 W John Rowan Blvd, Bardstown, KY 40004 Bardstown Nelson 40004 
{
    "unstructured": "8:00 AM - 9:00 PM Mon-Fri, 8:00 AM - 6:00 PM Sat, 9:00 AM - 6:00 PM Sun"
}
 www.krogerhealth.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:5f1ce4ee-7734-477f-b9f1-5e2cb208c5bb",
    "ky_govstatus:562",
    "ky_govstatus:178",
    "vaccinefinder_org:441415e6-3a8b-4ce5-91dd-6c991188fd5b",
    "little_clinic:18118",
    "vaccinefinder_org:5f1ce4ee-7734-477f-b9f1-5e2cb208c5bb",
    "kroger:2400408",
    "vaccinespotter_org:121808866",
    "vaccinespotter_org:9104269"
]
   https://www.vaccinatethestates.com/?lng=-85.46489&lat=37.82823#lgppc lgppc <Binary: 60 bytes> 37.82823 -85.46489
29665 Walgreens Co. #11307 KY Pharmacy 502-348-2985 824 N 3Rd St, Bardstown, KY 40004-1747 Bardstown Nelson 40004-1747 
{
    "unstructured": "07:00AM - 11:59PM"
}
 https://www.walgreens.com 
[
    "Moderna"
]
 
[
    "walgreens:11307",
    "vaccinefinder:cde46fff-9f82-4aa7-a9a9-b21d632e6348",
    "vaccinefinder_org:cde46fff-9f82-4aa7-a9a9-b21d632e6348",
    "_tag_provider:walgreens",
    "us_carbon_health:991df7a6-5457-4558-bf83-7af298861be9"
]
   https://www.vaccinatethestates.com/?lng=-85.46262&lat=37.82515#lpddw lpddw <Binary: 60 bytes> 37.82515 -85.46262
32602 Walmart Inc #10-0729 KY Pharmacy 5023496007 3795 E John Rowan Blvd, Bardstown, KY 40004-3214 Bardstown Nelson 40004-3214 
{
    "unstructured": "8:00 AM - 7:00 PM Mon, 6:00 AM - 7:00 PM Tue, 8:00 AM - 7:00 PM Wed, 8:00 AM - 7:00 PM Thrus, 8:00 AM - 7:00 PM Fri, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Sat, 10:00 AM - 1:30PM, 2:00 PM - 6:00 PM Sun"
}
 https://www.walmart.com/store/729 
[
    "Moderna"
]
 
[
    "vaccinefinder:6f8fdc92-b72f-4145-a742-f16c6983ed75",
    "us_carbon_health:0fd8a50f-0200-47af-94b7-4aa3271bc1da",
    "walmart:729",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-85.43659&lat=37.79989#lpxrm lpxrm <Binary: 60 bytes> 37.79989 -85.43659
53632 Crume Drug Store KY Unknown   111 WEST FLAGET STREET BARDSTOWN, KY 40004 BARDSTOWN Nelson 40004 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141715071"
]
   https://www.vaccinatethestates.com/?lng=-85.46719&lat=37.81049#lydky lydky <Binary: 60 bytes> 37.81049 -85.46719
54546 First Care Urgent Care KY Unknown (502) 337-7409 110 W John Rowan Blvd Bardstown, KY 40004 Bardstown Nelson 40004 
{
    "unstructured": null
}
 https://www.clockwisemd.com/hospitals/3481/visits/new 
[
    "Moderna"
]
 
[
    "ky_govstatus:573",
    "vaccinefinder_org:0a5ea58f-58ac-4d39-bd43-86ba2ec34f29"
]
   https://www.vaccinatethestates.com/?lng=-85.46523&lat=37.82708#lykbq lykbq <Binary: 60 bytes> 37.82708 -85.46523
55993 Hurst Discount KY Unknown   102 N THIRD ST Bardstown, KY 40004 Bardstown Nelson 40004 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141715070"
]
   https://www.vaccinatethestates.com/?lng=-85.46670&lat=37.80966#lytwk lytwk <Binary: 60 bytes> 37.80966 -85.4667
57036 SCRIPTS PHARMACY KY Unknown   101 BLAKENROD BLVD COXS CREEK, KY 40013 COXS CREEK Nelson 40013 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141560302"
]
   https://www.vaccinatethestates.com/?lng=-85.54491&lat=37.88183#lyzyq lyzyq <Binary: 60 bytes> 37.88183 -85.54491

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;