locations_expanded (view)

Data source: Vaccinate The States

9 rows where county = "Marion" and state = "KY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, full_address, city, zip_code, 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
13479 Southall Pharmacy PLLC KY Pharmacy 270-692-3111 325 W Walnut St Ste 500, Lebanon, KY 40033 Lebanon Marion 40033 
{
    "unstructured": "10:00 AM - 06:00 PM Mon-Fri, 10:00 AM - 01:00 PM Sat,  Sun"
}
 https://healthmartcovidvaccine.com 
[]
 
[
    "vaccinefinder:adcb9aa0-6d25-458e-9083-3f9f7e566e2d"
]
   https://www.vaccinatethestates.com/?lng=-85.25988&lat=37.57011#lgdtk lgdtk <Binary: 60 bytes> 37.57011 -85.25988
14980 Kroger Pharmacy #02400730 KY Pharmacy (270) 692-2123 705 E Main St, Lebanon, KY 40033 Lebanon Marion 40033 
{
    "unstructured": "8:00 AM - 9:00 PM Mon-Fri, 9:00 AM - 6:00 PM Sat, 11:00 AM - 6:00 PM Sun"
}
 www.krogerhealth.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:cd6afd6e-9e0b-4b27-bcfe-979e0d34937e",
    "ky_govstatus:422",
    "ky_govstatus:183",
    "vaccinefinder_org:cd6afd6e-9e0b-4b27-bcfe-979e0d34937e",
    "kroger:2400730",
    "vaccinespotter_org:9104283"
]
   https://www.vaccinatethestates.com/?lng=-85.23440&lat=37.57631#lgpqk lgpqk <Binary: 60 bytes> 37.57631 -85.2344
16820 Southall Pharmacy KY Pharmacy   325 W Walnut St Ste 500, Lebanon, KY 40033 Lebanon Marion 40033 
{
    "unstructured": ""
}
   
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:4a5a0213-2e85-45bb-a9cf-0d2cea1a2af0"
]
   https://www.vaccinatethestates.com/?lng=-85.25988&lat=37.57011#lgzww lgzww <Binary: 60 bytes> 37.57011 -85.25988
29965 Walgreens Co. #12076 KY Pharmacy 270-692-0471 512 W Main St, Lebanon, KY 40033-1339 Lebanon Marion 40033-1339 
{
    "unstructured": "09:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Moderna",
    "Pfizer"
]
 
[
    "walgreens:12076",
    "vaccinefinder:7d2baa6f-5a59-4b22-a66a-e0918664638d",
    "vaccinefinder_org:7d2baa6f-5a59-4b22-a66a-e0918664638d",
    "_tag_provider:walgreens",
    "us_carbon_health:ba577fe1-292e-4462-b675-e7c1b514ac41"
]
   https://www.vaccinatethestates.com/?lng=-85.26210&lat=37.56476#lpfhp lpfhp <Binary: 60 bytes> 37.56476 -85.2621
33442 Walmart Inc #10-1675 KY Pharmacy 2706921880 2136 Campbellsville Rd, Lebanon, KY 40033-8466 Lebanon Marion 40033-8466 
{
    "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/1675 
[
    "Moderna"
]
 
[
    "vaccinefinder:054cc389-08dd-48c5-9713-4ee11f6ef28a",
    "us_carbon_health:7c3757d1-96bc-4e1e-b1e8-1ff6315bf2b5",
    "walmart:1675",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-85.28324&lat=37.55468#lqbyz lqbyz <Binary: 60 bytes> 37.55468 -85.28324
41449 Pat's Pharmacy KY Unknown (270) 692-4950 498 West Main St Lebanon, KY 40033 Lebanon Marion 40033 
{
    "unstructured": null
}
   
[]
 
[
    "ky_govstatus:401"
]
   https://www.vaccinatethestates.com/?lng=-85.26153&lat=37.56520#ltcbm ltcbm <Binary: 60 bytes> 37.5652 -85.26153
43500 HealthCare for Kids & Teens, PLLC KY Unknown (270) 692-9015 54 Miller Pike Lebanon, KY 40033 Lebanon Marion 40033 
{
    "unstructured": null
}
   
[]
 
[
    "vaccinefinder_org:374d8af4-4552-450f-8a16-7c9178543d80"
]
   https://www.vaccinatethestates.com/?lng=-85.29560&lat=37.55207#ltqfq ltqfq <Binary: 60 bytes> 37.55207 -85.2956
50312 Walmart Supercenter KY Unknown   2136 Campbellsville Rd Calvary, KY 40033 Calvary Marion 40033 
{
    "unstructured": null
}
 https://www.walmart.com/cp/1228330 
[]
 
[
    "ky_govstatus:202"
]
   https://www.vaccinatethestates.com/?lng=-85.26057&lat=37.50848#lxhgx lxhgx <Binary: 60 bytes> 37.50848 -85.26057
57038 ADAMS PHARMACY KY Unknown   125 W Main St Lebanon, KY 40033 Lebanon Marion 40033 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141715068"
]
   https://www.vaccinatethestates.com/?lng=-85.25332&lat=37.56965#lyzyt lyzyt <Binary: 60 bytes> 37.56965 -85.25332

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;