locations_expanded (view)

Data source: Vaccinate The States

7 rows where county = "Harrison" and state = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, hours, website, vaccines_offered, last_verified_by_vts (date), 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
14136 Harrison County Health Department IN Hospital / Clinic 8127383237 241 Atwood Street, Ste 105, Corydon, IN 47112-0000 Corydon Harrison 47112-0000 
{
    "unstructured": ""
}
 https://vaccine.coronavirus.in.gov/ 
[]
 
[
    "vaccinefinder:9b48bd7c-19ce-4e82-b41e-277f3200453c"
]
   https://www.vaccinatethestates.com/?lng=-86.12430&lat=38.20426#lghgr lghgr <Binary: 60 bytes> 38.20426 -86.1243
29327 Walgreens Co. #10559 IN Pharmacy 812-738-1078 1716 Highway 337 Nw, Corydon, IN 47112-2028 Corydon Harrison 47112-2028 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Johnson & Johnson"
]
 
[
    "walgreens:10559",
    "vaccinefinder:d8c7e0ae-3ccb-4a67-acfd-d6391bc22cc7",
    "vaccinefinder_org:d8c7e0ae-3ccb-4a67-acfd-d6391bc22cc7"
]
   https://www.vaccinatethestates.com/?lng=-86.13440&lat=38.22930#lpbxr lpbxr <Binary: 60 bytes> 38.2293 -86.1344
31053 Walgreens Co. #17690 IN Pharmacy 812-347-3188 1673 Highway 64 Ne, New Salisbury, IN 47161-8439 New Salisbury Harrison 47161-8439 
{
    "unstructured": "08:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Moderna",
    "Pfizer"
]
 
[
    "walgreens:17690",
    "vaccinefinder:5c39a99e-2d88-4842-83c3-6f747b36aab2",
    "vaccinefinder_org:5c39a99e-2d88-4842-83c3-6f747b36aab2"
]
   https://www.vaccinatethestates.com/?lng=-86.09413&lat=38.31618#lpmqp lpmqp <Binary: 60 bytes> 38.31618 -86.09413
32774 Walmart Inc #10-0922 IN Pharmacy 8127384551 2363 Highway 135 Nw, Corydon, IN 47112-2153 Corydon Harrison 47112-2153 
{
    "unstructured": "9:00 AM - 7:00 PM Mon, 6:00 AM - 7:00 PM Tue, 9:00 AM - 7:00 PM Wed, 9:00 AM - 7:00 PM Thrus, 9: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/922 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:fe1b9050-a569-464d-8282-ae66eb990aea",
    "walmart:922",
    "us_carbon_health:75103461-20bc-4849-a9ec-a7bf08442699",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-86.13081&lat=38.23538#lpyhf lpyhf <Binary: 60 bytes> 38.23538 -86.13081
44703 CVS Pharmacy IN Unknown (812) 738-7191 255 Old Capital Plaza Northwest Corydon, IN 47112 Corydon Harrison 47112 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "us_giscorps_vaccine_providers:3b233a98-b79f-44d3-8166-204fb1823a1b"
]
 2021-05-14T21:09:06.965554+00:00 https://www.vaccinatethestates.com/?lng=-86.13510&lat=38.22740#ltybt ltybt <Binary: 60 bytes> 38.2274 -86.1351
52919 Butt Drugs IN Unknown   115 East Chestnut St. Corydon, IN 47112 Corydon Harrison 47112 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141560262"
]
   https://www.vaccinatethestates.com/?lng=-86.12571&lat=38.21027#lxzqp lxzqp <Binary: 60 bytes> 38.21027 -86.12571
60582 Harrison County Local Health Department IN Unknown   305 Oliver St Corydon, IN 47112 Corydon Harrison 47112 
{
    "unstructured": null
}
 https://vaccine.coronavirus.in.gov 
[]
 
[
    "in_arcgis:85129fda-e401-4e40-8f5c-9105a0e85764"
]
   https://www.vaccinatethestates.com/?lng=-86.12110&lat=38.19858#lzxyh lzxyh <Binary: 60 bytes> 38.19858 -86.1211

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;