locations_expanded (view)

Data source: Vaccinate The States

4 rows where county = "Union" and state = "IA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
13526 Hy-Vee Inc. #1095 IA Pharmacy 6417828417 600 Sheldon, Creston, IA 50801 Creston Union 50801 
{
    "unstructured": "8:00 am - 7:00 pm Mon-Fri, 8:00 am - 4:00 pm Sat,  Sun"
}
   
[]
 
[
    "vaccinefinder:9a2f0fd7-9f4f-4700-9ac3-e337c44faa93",
    "vaccinefinder_org:9a2f0fd7-9f4f-4700-9ac3-e337c44faa93",
    "hyvee:1095",
    "us_carbon_health:058092c1-4202-41eb-8a6d-350417bcfd9a"
]
   https://www.vaccinatethestates.com/?lng=-94.37348&lat=41.05227#lgdyh lgdyh <Binary: 60 bytes> 41.05227 -94.37348
13828 Greater Regional Medical Center IA Pharmacy 641-782-3545 1700 W. Townline Street, Creston, IA 50801 Creston Union 50801 
{
    "unstructured": ""
}
 https://www.greaterregional.org/ 
[
    "Moderna"
]
 
[
    "vaccinefinder:2daf7e09-1752-4ab2-9b90-5dd618ba3f84",
    "vaccinefinder_org:2daf7e09-1752-4ab2-9b90-5dd618ba3f84"
]
   https://www.vaccinatethestates.com/?lng=-94.38391&lat=41.07026#lggcg lggcg <Binary: 60 bytes> 41.07026 -94.38391
13895 Medicap Pharmacy-Creston #8034 IA Pharmacy 641-782-6558 405 S. Sumner Ave., Creston, IA 50801 Creston Union 50801 
{
    "unstructured": ""
}
 https://creston.medicap.com 
[]
 
[
    "vaccinefinder:e04e83ee-0260-4882-8a27-52c40ab30825",
    "vaccinefinder_org:e04e83ee-0260-4882-8a27-52c40ab30825",
    "us_carbon_health:e276d97a-2489-4cdb-a299-086e31d4e367"
]
   https://www.vaccinatethestates.com/?lng=-94.37141&lat=41.05301#lgghm lgghm <Binary: 60 bytes> 41.05301 -94.37141
33236 Walmart Inc #10-1435 IA Pharmacy 6417826954 806 Laurel St, Creston, IA 50801-3554 Creston Union 50801-3554 
{
    "unstructured": "9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Mon, 6:00 AM - 1:30PM, 2:00 PM - 7:00 PM Tue, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Wed, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Thrus, 9: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/1435 
[]
 
[
    "vaccinefinder:6056d025-6ca6-4a64-9da2-be950bb6c687",
    "us_carbon_health:7acfd9ec-7d55-4d64-be4e-29d5078a05d0",
    "_tag_provider:walmart",
    "walmart:1435"
]
   https://www.vaccinatethestates.com/?lng=-94.37273&lat=41.04529#lqbdc lqbdc <Binary: 60 bytes> 41.04529 -94.37273

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;