locations_expanded (view)

Data source: Vaccinate The States

5 rows where county = "Daviess" and state = "IN"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, hours, vaccines_offered, 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
13231 ODON PHARMACY LLC IN Pharmacy 812 636-4609 200 W Main St, Odon, IN 47562 Odon Daviess 47562 
{
    "unstructured": "10:00 AM - 04:00 PM Mon-Fri"
}
 https://healthmartcovidvaccine.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:c0945804-d4b0-4d06-9f4f-1e06f09f08a4",
    "arcgis:cf610088-3bd2-473a-9934-c38313775041",
    "in_arcgis:cf610088-3bd2-473a-9934-c38313775041",
    "vaccinefinder_org:c0945804-d4b0-4d06-9f4f-1e06f09f08a4",
    "vaccinespotter_org:141723166"
]
   https://www.vaccinatethestates.com/?lng=-86.99220&lat=38.84313#lgctk lgctk <Binary: 60 bytes> 38.84313 -86.9922
14119 Daviess County Health Department IN Hospital / Clinic 8122548667 300 E. Hefron Street, Government Center Health Dept., Washington, IN 47501-0000 Washington Daviess 47501-0000 
{
    "unstructured": ""
}
 https://vaccine.coronavirus.in.gov/ 
[
    "Moderna"
]
 
[
    "vaccinefinder:917fbc36-8ff3-4a9e-958e-fa2151fc4ced"
]
   https://www.vaccinatethestates.com/?lng=-87.17186&lat=38.65943#lghfq lghfq <Binary: 60 bytes> 38.65943 -87.17186
32989 Walmart Inc #10-1162 IN Pharmacy 8122546681 1801 S State Road 57, Washington, IN 47501-4326 Washington Daviess 47501-4326 
{
    "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 - 6:00 PM Sat, 11:00 AM - 1:30PM, 2:00 PM - 5:00 PM Sun"
}
 https://www.walmart.com/store/1162 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:6f311588-26b5-4264-8e36-ae0a87fb3984",
    "us_carbon_health:c317f599-a9e3-4dea-ac14-05a30e321c53",
    "walmart:1162",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-87.18373&lat=38.63199#lpzdr lpzdr <Binary: 60 bytes> 38.63199 -87.18373
42777 Williams Brothers Pharmacy IN Unknown   10 Williams Brothers Dr Washington, IN 47501 Washington Daviess 47501 
{
    "unstructured": null
}
 https://vaccine.coronavirus.in.gov 
[]
 
[
    "in_arcgis:4750e351-780e-459b-b8ce-5d3481a8b4c8"
]
   https://www.vaccinatethestates.com/?lng=-87.15317&lat=38.65381#ltkhp ltkhp <Binary: 60 bytes> 38.65381 -87.15317
56835 CVS Pharmacy IN Unknown   307 East National Highway Washington, IN 47501 Washington Daviess 47501 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "us_giscorps_vaccine_providers:b6e0ef5b-005b-4125-b8e0-c144af365857",
    "vaccinespotter_org:270142803",
    "vaccinefinder_org:55147483-989d-4278-8773-b109d4cbcf99",
    "cvs:6874"
]
   https://www.vaccinatethestates.com/?lng=-87.17135&lat=38.65191#lyzcx lyzcx <Binary: 60 bytes> 38.65191 -87.17135

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;