locations_expanded (view)

Data source: Vaccinate The States

5 rows where county = "Jackson" and state = "AR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, hours, vaccines_offered, 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
9038 iCareRx Pharmacy AR Pharmacy   1117 Mclain St, Ste 400, Newport, AR 72112 Newport Jackson 72112 
{
    "unstructured": ""
}
 http://icarerx.com 
[
    "Moderna",
    "Pfizer"
]
 
[
    "vaccinefinder:383f7838-b24b-46c1-a5a3-25757f377b31",
    "vaccinefinder_org:383f7838-b24b-46c1-a5a3-25757f377b31"
]
   https://www.vaccinatethestates.com/?lng=-91.26579&lat=35.60857#lfcfp lfcfp <Binary: 60 bytes> 35.60857 -91.26579
9039 Bryant, Holifield and Davis Pharmacy dba Norman & B AR Pharmacy (870) 523-9472 2200 Malcolm Avenue, D, Newport, AR 72112 Newport Jackson 72112 
{
    "unstructured": "8:30 AM - 5:30 PM Mon-Fri, 8:30 AM - 12:00 PM Sat, Closed Sun"
}
 http://normanbakerrx.com 
[]
 
[
    "vaccinefinder:efe345fb-da0b-4893-a6a5-2bac44b91d3a",
    "vaccinefinder_org:efe345fb-da0b-4893-a6a5-2bac44b91d3a"
]
   https://www.vaccinatethestates.com/?lng=-91.25398&lat=35.60433#lfcfq lfcfq <Binary: 60 bytes> 35.60433 -91.25398
31972 Walmart Inc #10-0018 AR Pharmacy 8705232500 1211 Highway 367 N, Newport, AR 72112-3674 Newport Jackson 72112-3674 
{
    "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/18 
[
    "Moderna"
]
 
[
    "vaccinefinder:358df181-667d-41fc-96c2-baccbe23956f",
    "us_carbon_health:a2995f65-2c21-4add-9cec-6867f0dacd0b",
    "walmart:18",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-91.25496&lat=35.61791#lptfc lptfc <Binary: 60 bytes> 35.61791 -91.25496
53860 Walgreens Co. #11161 AR Unknown 870-217-0170 2401 MALCOLM AVE NEWPORT, AR 72112 NEWPORT Jackson 72112 
{
    "unstructured": null
}
 https://www.walgreens.com/findcare/vaccination/covid-19 
[
    "Moderna"
]
 
[
    "vaccinefinder_org:93ac91fa-b902-4482-8ec3-13f97eef7e30",
    "walgreens:11161",
    "vaccinespotter_org:2728966"
]
   https://www.vaccinatethestates.com/?lng=-91.25248&lat=35.60708#lyfhf lyfhf <Binary: 60 bytes> 35.60708 -91.25248
53919 Darling Pharmacu AR Unknown   1303 MCLAIN ST NEWPORT, AR 72112 NEWPORT Jackson 72112 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141577239"
]
   https://www.vaccinatethestates.com/?lng=-91.26357&lat=35.60838#lyfpy lyfpy <Binary: 60 bytes> 35.60838 -91.26357

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;