locations_expanded (view)
Data source: Vaccinate The States
9 rows where county = "Marion" and state = "KY"
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
CREATE VIEW locations_expanded AS select locations.rowid, locations.*, y(locations.geometry) as latitude, x(locations.geometry) as longitude from locations;