locations_expanded (view)

Data source: Vaccinate The States

7 rows where county = "Hart" and state = "KY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, phone_number, city, zip_code, hours, vaccines_offered

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
12253 Clark Drugs #1802998 KY Pharmacy (270) 524-3669 500 Main Street, Munfordville, KY 42765 Munfordville Hart 42765 
{
    "unstructured": "8:00 AM - 5:00 PM Mon-Fri, 8:30 AM - 2:00 PM Sat, Closed Sun"
}
 http://www.Clarkdrugs.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:d4995f62-8759-49c8-a186-aa1b3fa035ff",
    "vaccinefinder_org:d4995f62-8759-49c8-a186-aa1b3fa035ff"
]
   https://www.vaccinatethestates.com/?lng=-85.89294&lat=37.27339#lfxxq lfxxq <Binary: 60 bytes> 37.27339 -85.89294
30835 Walgreens Co. #17135 KY Pharmacy 270-524-3081 600 North Main Street, Munfordville, KY 42765-9424 Munfordville Hart 42765-9424 
{
    "unstructured": "08:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:17135",
    "vaccinefinder:ff322088-4d11-491a-b86c-17bd9d345068",
    "vaccinefinder_org:ff322088-4d11-491a-b86c-17bd9d345068",
    "_tag_provider:walgreens",
    "us_carbon_health:0e52bb17-965a-4fc8-be51-b144594c3084"
]
   https://www.vaccinatethestates.com/?lng=-85.89385&lat=37.27413#lpkty lpkty <Binary: 60 bytes> 37.27413 -85.89385
30969 Walgreens Co. #17438 KY Pharmacy 270-786-1147 394 North Dixie Street, Horse Cave, KY 42749 Horse Cave Hart 42749 
{
    "unstructured": "08:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:17438",
    "vaccinefinder:5d8dceaf-2663-446f-b1af-965c60f2a6f4",
    "ky_govstatus:249",
    "vaccinefinder_org:5d8dceaf-2663-446f-b1af-965c60f2a6f4",
    "vaccinespotter_org:2720758",
    "us_carbon_health:318464f3-c996-423d-8d0d-ee55244724e5",
    "_tag_provider:walgreens"
]
   https://www.vaccinatethestates.com/?lng=-85.90262&lat=37.18307#lpmgg lpmgg <Binary: 60 bytes> 37.18307 -85.90262
43090 Walgreens Pharmacy KY Unknown   600 NORTH MAIN STREET Munfordville, KY 42765 Munfordville Hart 42765 
{
    "unstructured": null
}
 https://www.walgreens.com/findcare/vaccination/covid-19?ban=covid_vaccine_landing_schedule 
[]
 
[
    "ky_govstatus:256",
    "vaccinespotter_org:2720759"
]
   https://www.vaccinatethestates.com/?lng=-85.90794&lat=37.29756#ltmqx ltmqx <Binary: 60 bytes> 37.29756 -85.90794
55951 Hart County Health Department KY Unknown (270) 524-2511 500 A.A. Whitman Lane Munfordville, KY 42765 Munfordville Hart 42765 
{
    "unstructured": null
}
 http://barrenriverhealth.org 
[]
 
[
    "vaccinefinder_org:c655b99a-9b46-4a96-aba5-2db9fe65a458"
]
   https://www.vaccinatethestates.com/?lng=-85.88982&lat=37.27565#lytqr lytqr <Binary: 60 bytes> 37.27565 -85.88982
56906 Jane's Pharmacy KY Unknown   950 MAIN ST, STE 100 MUNFORDVILLE, KY 42765 MUNFORDVILLE Hart 42765 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141558656"
]
   https://www.vaccinatethestates.com/?lng=-85.89717&lat=37.27670#lyzkk lyzkk <Binary: 60 bytes> 37.2767 -85.89717
64378 Clark Drugs KY Unknown (270) 524-3669 232 Main Street Munfordville Munfordville, KY 42765 Munfordville Hart 42765 
{
    "unstructured": null
}
 https://www.mygnp.com/pharmacies/programs/covid-19-vaccine/?state=ky 
[]
 
[
    "us_giscorps_vaccine_providers:21fdd688-cea6-4183-8a7b-8497348041fb"
]
   https://www.vaccinatethestates.com/?lng=-85.90268&lat=37.28393#lcbwwd lcbwwd <Binary: 60 bytes> 37.28393 -85.90268

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;