locations_expanded (view)

Data source: Vaccinate The States

21 rows where county = "Madison" and state = "KY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: name, location_type, city, zip_code, hours, website, 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
9420 McCay's Total Care Pharmacy #183536 KY Pharmacy (859) 623-4216 260 Boggs Ln, Richmond, KY 40475 Richmond Madison 40475 
{
    "unstructured": "9:00 AM - 6:00 PM Mon-Fri, 9:00 AM - 1:00 PM Sat, Closed Sun"
}
 http://mccayspharmacy.com 
[]
 
[
    "vaccinefinder:7ffd427a-16ed-4095-8729-f8a71e7d6c03",
    "vaccinefinder_org:7ffd427a-16ed-4095-8729-f8a71e7d6c03",
    "us_carbon_health:2e1e01fa-fc56-4423-933c-911a597b3644"
]
   https://www.vaccinatethestates.com/?lng=-84.28627&lat=37.73197#lfdtr lfdtr <Binary: 60 bytes> 37.73197 -84.28627
11183 CVS Pharmacy, Inc. #06346 KY Pharmacy (859) 623-7481 409 East Main Street, Richmond, KY 40475 Richmond Madison 40475 
{
    "unstructured": "08:00AM-09:00PM Mon-Fri, 09:00AM-09:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/006346 
[
    "Pfizer"
]
 
[
    "cvs:06346",
    "vaccinefinder:82e3e866-0ad2-42d4-a487-1041ebc9a58e",
    "us_giscorps_vaccine_providers:c918f6ce-b3e6-4290-9b83-e7bf6e076fdd",
    "vaccinespotter_org:270110867"
]
   https://www.vaccinatethestates.com/?lng=-84.29072&lat=37.74633#lfqrk lfqrk <Binary: 60 bytes> 37.74633 -84.29072
14682 The Little Clinic #18202 KY Pharmacy 859-623-5155 890 Richmond Plaza, Richmond, KY 40475-2564 Richmond Madison 40475-2564 
{
    "unstructured": ""
}
 Thelittleclinic.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:05294e2b-dd38-48d6-9391-0617b4843995"
]
   https://www.vaccinatethestates.com/?lng=-84.27495&lat=37.73204#lgmkw lgmkw <Binary: 60 bytes> 37.73204 -84.27495
14966 Kroger Pharmacy #02400705 KY Pharmacy (859) 624-1093 890 Richmond Plz, Richmond, KY 40475 Richmond Madison 40475 
{
    "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:74782335-1043-457f-b2c0-d377dcebd71c",
    "ky_govstatus:321",
    "vaccinefinder_org:74782335-1043-457f-b2c0-d377dcebd71c",
    "kroger:2400705"
]
   https://www.vaccinatethestates.com/?lng=-84.27495&lat=37.73204#lgppp lgppp <Binary: 60 bytes> 37.73204 -84.27495
16657 White House Clinics - Berea KY Pharmacy 8599862323 104 Legacy Drive, Berea, KY 40403 Berea Madison 40403 
{
    "unstructured": "8:00 AM - 5:00 PM Mon-Fri, Closed Sat-Sun"
}
 http://www.whitehouseclinics.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:df4bbe3e-7bcd-479a-96a8-3b541e249ee7",
    "vaccinefinder_org:df4bbe3e-7bcd-479a-96a8-3b541e249ee7"
]
   https://www.vaccinatethestates.com/?lng=-84.31677&lat=37.60534#lgzdp lgzdp <Binary: 60 bytes> 37.60534 -84.31677
16658 White House Clinics - Richmond KY Pharmacy 8596267700 401 Highland Park Drive, Richmond, KY 40475 Richmond Madison 40475 
{
    "unstructured": "8:00 AM - 5:00 PM Mon-Fri, Closed Sat-Sun"
}
 http://www.whitehouseclinics.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:f46d2c97-f44c-4b50-b15a-695572db311d",
    "vaccinefinder_org:f46d2c97-f44c-4b50-b15a-695572db311d"
]
   https://www.vaccinatethestates.com/?lng=-84.26545&lat=37.73990#lgzdq lgzdq <Binary: 60 bytes> 37.7399 -84.26545
16702 Madison County Health Department KY Pharmacy (859) 623-7312 216 Boggs Lane, Pob 1208, Richmond, KY 40476 Richmond Madison 40476 
{
    "unstructured": "8:00 AM - 6:00 PM Mon, 8:00 AM - 4:30 PM Tue, 8:00 AM - 4:30 PM Wed, 8:00 AM - 4:30 PM Thrus, 8:00 AM - 12:00 PM Fri, Closed Sat, Closed Sun"
}
 http://madisoncountyhealthdept.org 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:c26f4398-efe6-4d38-8a24-54107902f833",
    "vaccinefinder_org:c26f4398-efe6-4d38-8a24-54107902f833"
]
   https://www.vaccinatethestates.com/?lng=-84.28495&lat=37.73671#lgzhh lgzhh <Binary: 60 bytes> 37.73671 -84.28495
18269 Meijer #258 KY Pharmacy 859-575-5010 2013 Lantern Ridge Dr, Richmond, KY 40475 Richmond Madison 40475 
{
    "unstructured": "08:00AM - 09:00PM Mon-Fri, 08:00AM - 06:00PM Sat, 10:00AM - 06:00PM Sun"
}
 https://www.meijer.com/services/pharmacy.html 
[]
 
[
    "vaccinefinder_org:d4e1e6ac-e019-4393-947a-474773007093",
    "meijer:258",
    "vaccinefinder:d4e1e6ac-e019-4393-947a-474773007093",
    "us_carbon_health:8669e7ed-7213-4f48-910a-49d454f2a73b",
    "_tag_provider:meijer"
]
   https://www.vaccinatethestates.com/?lng=-84.33383&lat=37.73720#lhhmp lhhmp <Binary: 60 bytes> 37.7372 -84.33383
19300 Med-Save Berea Medicine Shoppe 2069 #Ms1002089 KY Pharmacy 859-985-7283 102 Prince Royal Dr Suite-2, Berea, KY 40403 Berea Madison 40403 
{
    "unstructured": ""
}
   
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:182fb5d8-562e-4d2f-a4d7-eb2cb2280ee3",
    "vaccinefinder_org:182fb5d8-562e-4d2f-a4d7-eb2cb2280ee3"
]
   https://www.vaccinatethestates.com/?lng=-84.31061&lat=37.56954#lhqpy lhqpy <Binary: 60 bytes> 37.56954 -84.31061
29856 Walgreens Co. #11796 KY Pharmacy 859-986-1494 220 Richmond Rd N, Berea, KY 40403-1319 Berea Madison 40403-1319 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Moderna"
]
 
[
    "walgreens:11796",
    "vaccinefinder:fb083330-ab75-4dae-b31d-899ff9a37a51",
    "vaccinefinder_org:fb083330-ab75-4dae-b31d-899ff9a37a51",
    "_tag_provider:walgreens",
    "us_carbon_health:4c53040a-7d52-4dd8-b215-cc2aa2946c98"
]
   https://www.vaccinatethestates.com/?lng=-84.28343&lat=37.58520#lpdyt lpdyt <Binary: 60 bytes> 37.5852 -84.28343
30632 Walgreens Co. #15561 KY Pharmacy 859-353-3309 501 Caperton Dr, Richmond, KY 40475-6508 Richmond Madison 40475-6508 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Moderna",
    "Pfizer"
]
 
[
    "walgreens:15561",
    "vaccinefinder:43895652-b00f-4e9e-83d7-f060823f2895",
    "vaccinefinder_org:43895652-b00f-4e9e-83d7-f060823f2895",
    "_tag_provider:walgreens",
    "us_carbon_health:428b15f9-aa16-4d49-b53e-3c2d7b322b28"
]
   https://www.vaccinatethestates.com/?lng=-84.27576&lat=37.73422#lphzf lphzf <Binary: 60 bytes> 37.73422 -84.27576
31445 Walgreens Co. #19411 KY Pharmacy 859-623-7326 654 University Shopping Center, Richmond, KY 40475 Richmond Madison 40475 
{
    "unstructured": "08:00AM - 9:00PM Mon-Fri, 08:00AM - 9:00PM Sat, 09:00AM - 9:00PM Sun"
}
 https://www.walgreens.com 
[
    "Moderna"
]
 
[
    "walgreens:19411",
    "vaccinefinder:9bca5047-b42b-4635-a404-5f73301c5753",
    "ky_govstatus:102",
    "vaccinefinder_org:9bca5047-b42b-4635-a404-5f73301c5753",
    "vaccinespotter_org:2720634",
    "_tag_provider:walgreens",
    "us_carbon_health:a4c06076-ac0f-4537-bd61-4a63055e1409"
]
   https://www.vaccinatethestates.com/?lng=-84.30800&lat=37.73506#lpqdb lpqdb <Binary: 60 bytes> 37.73506 -84.308
32594 Walmart Inc #10-0719 KY Pharmacy 8596244330 820 Eastern Byp, Richmond, KY 40475-2512 Richmond Madison 40475-2512 
{
    "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/719 
[
    "Moderna"
]
 
[
    "vaccinefinder:baab1550-23d6-4b24-a251-7530b6b33fec",
    "us_carbon_health:300b7f77-0a09-40b8-b395-0332683886c8",
    "walmart:719",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-84.28302&lat=37.72862#lpxqz lpxqz <Binary: 60 bytes> 37.72862 -84.28302
33014 Walmart Inc #10-1190 KY Pharmacy 8599862324 120 Jill Dr, Berea, KY 40403-1677 Berea Madison 40403-1677 
{
    "unstructured": "8:00 AM - 1:30PM, 2:00 PM - 7:00 PM Mon, 6:00 AM - 1:30PM, 2:00 PM - 7:00 PM Tue, 8:00 AM - 1:30PM, 2:00 PM - 7:00 PM Wed, 8:00 AM - 1:30PM, 2:00 PM - 7:00 PM Thrus, 8:00 AM - 1:30PM, 2:00 PM - 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/1190 
[]
 
[
    "vaccinefinder:3d730457-c55c-43bb-836b-2a6f88873dd8"
]
   https://www.vaccinatethestates.com/?lng=-84.31254&lat=37.56528#lpzgf lpzgf <Binary: 60 bytes> 37.56528 -84.31254
38705 Madison Drug KY Pharmacy (859) 624-1565 110 Big Hill Avenue, Richmond, KY 40475 Richmond Madison 40475 
{
    "unstructured": "8:30 AM - 6:30 PM Mon-Fri, 9:00 AM - 3:00 PM Sat, Closed Sun"
}
 http://www.madisondrug.com 
[]
 
[
    "vaccinefinder_org:4ddb61ef-568e-4517-a474-9101605cf354"
]
   https://www.vaccinatethestates.com/?lng=-84.28637&lat=37.74309#lrhxq lrhxq <Binary: 60 bytes> 37.74309 -84.28637
42006 Walmart Supercenter KY Unknown   120 JILL DR Berea, KY 40403 Berea Madison 40403 
{
    "unstructured": null
}
 https://www.walmart.com/cp/1228310 
[
    "Moderna"
]
 
[
    "ky_govstatus:167",
    "vaccinefinder_org:3d730457-c55c-43bb-836b-2a6f88873dd8",
    "walmart:1190",
    "vaccinespotter_org:779884"
]
   https://www.vaccinatethestates.com/?lng=-84.43063&lat=37.76727#ltfgf ltfgf <Binary: 60 bytes> 37.76727 -84.43063
44883 Walmart Supercenter KY Unknown   820 EASTERN BYP Richmond, KY 40475 Richmond Madison 40475 
{
    "unstructured": null
}
 https://www.walmart.com/cp/1228309 
[]
 
[
    "ky_govstatus:166"
]
   https://www.vaccinatethestates.com/?lng=-84.35350&lat=37.76124#ltywm ltywm <Binary: 60 bytes> 37.76124 -84.3535
54140 Berea Drug #1803661 KY Unknown (859) 986-4521 402 RICHMOND RD N STE A Berea, KY 40403 Berea Madison 40403 
{
    "unstructured": null
}
 http://www.bereadrug.com 
[
    "Moderna"
]
 
[
    "vaccinefinder_org:290e062e-2c8d-48ae-a4fd-26773400d1cb"
]
   https://www.vaccinatethestates.com/?lng=-84.28327&lat=37.58891#lygkx lygkx <Binary: 60 bytes> 37.58891 -84.28327
55764 Baptist Health Richmond at Eastern Kentucky University Perkins Building KY Unknown 800.444.0310 4436 Kit Carson Dr. Richmond, KY 40475 Richmond Madison 40475 
{
    "unstructured": "Monday-Friday: 8am - 6pm \r\nSaturday and Sunday: Closed"
}
 https://www.baptisthealth.com/vaccine/schedule-now/locations/richmond 
[]
 
[
    "ky_govstatus:363"
]
   https://www.vaccinatethestates.com/?lng=-84.30208&lat=37.73084#lyrxk lyrxk <Binary: 60 bytes> 37.73084 -84.30208
57016 Baptist Health Richmond KY Unknown (000) 000-0000 801 Eastern Bypass Richmond, KY 40475 Richmond Madison 40475 
{
    "unstructured": null
}
 http://scheduleyourvaccine.com/ 
[
    "Pfizer"
]
 
[
    "vaccinefinder_org:f4df1fd8-1af9-4714-bfa7-4babbb9b5c1c"
]
   https://www.vaccinatethestates.com/?lng=-84.29256&lat=37.73074#lyzxh lyzxh <Binary: 60 bytes> 37.73074 -84.29256
57086 BLUEGRASS FAMILY PHARMACY KY Unknown   2187 LEXINGTON RD # 1 RICHMOND, KY 40475 RICHMOND Madison 40475 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141558465"
]
   https://www.vaccinatethestates.com/?lng=-84.32003&lat=37.77650#lzbcw lzbcw <Binary: 60 bytes> 37.7765 -84.32003

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;