locations_expanded (view)

Data source: Vaccinate The States

9 rows where county = "Independence" and state = "AR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, zip_code, website, 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
9030 Econo-Mart Pharmacy AR Pharmacy   1595 Harrison Street, Batesville, AR 72501 Batesville Independence 72501 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:584d9ad6-0670-4dea-b03a-7a611be6d985",
    "vaccinefinder_org:584d9ad6-0670-4dea-b03a-7a611be6d985",
    "us_carbon_health:2d3e2889-76e9-4849-a020-29195e1ed6e6",
    "us_carbon_health:46edf56f-8940-4387-aa63-a115f259925a"
]
   https://www.vaccinatethestates.com/?lng=-91.63704&lat=35.76985#lfcfb lfcfb <Binary: 60 bytes> 35.76985 -91.63704
9031 Newark Pharmacy AR Pharmacy (870) 799-3411 503 Vine St, Newark, AR 72562 Newark Independence 72562 
{
    "unstructured": "8:30 AM - 5:30 PM Mon-Fri, Closed Sat-Sun"
}
 http://WWW.NEWARKPHARMACYAR.COM 
[]
 
[
    "vaccinefinder:88e4a1f2-6250-42a4-8420-af8706c1eab9",
    "vaccinefinder_org:88e4a1f2-6250-42a4-8420-af8706c1eab9",
    "us_carbon_health:3f5b4745-7e4a-471a-9d64-a2b294dddd92",
    "us_carbon_health:401c630f-5283-4055-aae9-f54d1beef40c"
]
   https://www.vaccinatethestates.com/?lng=-91.44840&lat=35.70233#lfcfc lfcfc <Binary: 60 bytes> 35.70233 -91.4484
9032 Bryant's Pharmacy & Health Care Center AR Pharmacy (870) 793-3999 2000 Harrison St, Suite A, Batesville, AR 72501 Batesville Independence 72501 
{
    "unstructured": "8:30 AM - 6:00 PM Mon-Fri, 9:00 AM - 2:00 PM Sat,  Sun"
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:5252dbdd-8d99-4db5-9f29-1ff44064a36d",
    "vaccinefinder_org:5252dbdd-8d99-4db5-9f29-1ff44064a36d"
]
   https://www.vaccinatethestates.com/?lng=-91.63111&lat=35.76912#lfcfd lfcfd <Binary: 60 bytes> 35.76912 -91.63111
9033 Sav-On Pharmacy AR Pharmacy (870) 793-4770 1610 Harrison St, Batesville, AR 72501 Batesville Independence 72501 
{
    "unstructured": "8:30 AM - 5:30 PM Mon-Fri, 8:30 AM - 12:00 PM Sat, Closed Sun"
}
 http://www.savonpharmacybatesville.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:0e1f19a7-91f3-45fd-bd60-6edd779e9ddb",
    "vaccinefinder_org:0e1f19a7-91f3-45fd-bd60-6edd779e9ddb",
    "us_carbon_health:72b73e1e-0944-4d2d-9b78-4dcd784d749b"
]
   https://www.vaccinatethestates.com/?lng=-91.63665&lat=35.76929#lfcff lfcff <Binary: 60 bytes> 35.76929 -91.63665
9034 White River Medical Center AR Pharmacy (870) 613-0491 1710 Harrison St, Batesville, AR 72501 Batesville Independence 72501 
{
    "unstructured": "8:00 AM - 4:00 PM"
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:693a2a6b-9020-4577-bea4-ba74d52cf650",
    "vaccinefinder_org:693a2a6b-9020-4577-bea4-ba74d52cf650",
    "us_carbon_health:86a3180b-dbcd-4ab6-a94c-b544fc7cb85d"
]
   https://www.vaccinatethestates.com/?lng=-91.63433&lat=35.76767#lfcfg lfcfg <Binary: 60 bytes> 35.76767 -91.63433
15103 Kroger Pharmacy #02500687 AR Pharmacy (870) 793-3000 303 S St Louis St, Batesville, AR 72501 Batesville Independence 72501 
{
    "unstructured": "8:00 AM - 8:00 PM Mon-Fri, 9:00 AM - 7:00 PM Sat, 11:00 AM - 6:00 PM Sun"
}
 www.krogerhealth.com 
[]
 
[
    "vaccinefinder:c10d2065-1b36-487c-be51-90c13235e013",
    "vaccinefinder_org:c10d2065-1b36-487c-be51-90c13235e013",
    "kroger:2500687"
]
   https://www.vaccinatethestates.com/?lng=-91.63979&lat=35.77612#lgqcc lgqcc <Binary: 60 bytes> 35.77612 -91.63979
32069 Walmart Inc #10-0119 AR Pharmacy 8707939004 3150 Harrison St, Batesville, AR 72501-7515 Batesville Independence 72501-7515 
{
    "unstructured": "8:00 AM - 7:00 PM Mon, 6:00 AM - 7:00 PM Tue, 8:00 AM - 7:00 PM Wed, 8:00 AM - 7:00 PM Thrus, 8:00 AM - 7:00 PM Fri, 9:00 AM - 1:29PM, 2:02PM - 7:00 PM Sat, 10:00 AM - 1:29PM, 2:02PM - 6:00 PM Sun"
}
 https://www.walmart.com/store/119 
[
    "Moderna"
]
 
[
    "vaccinefinder:21877f3e-cc73-4435-a89f-6e9e44a4e91f",
    "us_carbon_health:cdb8c51e-96a6-4bc4-9856-060143514211",
    "_tag_provider:walmart",
    "walmart:119"
]
   https://www.vaccinatethestates.com/?lng=-91.61431&lat=35.76282#lptqd lptqd <Binary: 60 bytes> 35.76282 -91.61431
49824 Walgreens AR Unknown   1045 S SAINT LOUIS ST BATESVILLE, AR 72501 BATESVILLE Independence 72501 
{
    "unstructured": null
}
 https://www.walgreens.com/covid19vac 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "us_giscorps_vaccine_providers:5655356f-424b-4643-af2e-47c8221376f0",
    "vaccinespotter_org:2728967"
]
   https://www.vaccinatethestates.com/?lng=-91.64044&lat=35.76911#lxfhz lxfhz <Binary: 60 bytes> 35.76911 -91.64044
51640 Wilson Wil-sav Mart AR Unknown   5 Allen Chapel Batesville, AR 72501 Batesville Independence 72501 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141577240"
]
   https://www.vaccinatethestates.com/?lng=-91.63867&lat=35.73745#lxrpt lxrpt <Binary: 60 bytes> 35.73745 -91.63867

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;