locations_expanded (view)

Data source: Vaccinate The States

7 rows where county = "Carroll" and state = "AR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, 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
8970 Mercy Hospital Berryville AR Pharmacy (833) 364-6777 214 Carter St., Berryville, AR 72616 Berryville Carroll 72616 
{
    "unstructured": ""
}
 http://Mercy.net/BerryvilleVaccine 
[]
 
[
    "vaccinefinder:443d7d4f-a6c1-4f49-b11f-733a31a1fd79",
    "vaccinefinder_org:443d7d4f-a6c1-4f49-b11f-733a31a1fd79",
    "us_carbon_health:195bf3c4-f6b3-4f71-a43c-bdf594eba988"
]
   https://www.vaccinatethestates.com/?lng=-93.55170&lat=36.35897#lfbzf lfbzf <Binary: 60 bytes> 36.35897 -93.5517
8971 Holiday Island Pharmacy AR Pharmacy   2 Forest Park Drive, Suite A, Holiday Island, AR 72631 Holiday Island Carroll 72631 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:faa8d8dd-b716-421c-82b3-74e9b9b194fc",
    "vaccinefinder_org:faa8d8dd-b716-421c-82b3-74e9b9b194fc"
]
   https://www.vaccinatethestates.com/?lng=-93.72217&lat=36.45440#lfbzg lfbzg <Binary: 60 bytes> 36.4544 -93.72217
32029 Walmart Inc #10-0076 AR Pharmacy 8704234636 1000 W Trimble Ave, Berryville, AR 72616-4603 Berryville Carroll 72616-4603 
{
    "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: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/76 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:ecd751d6-95ec-4b2d-8c9f-b8d3b6d6da41",
    "us_carbon_health:1a8c0240-014f-486b-8686-62d01a01eaa6",
    "walmart:76",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-93.58740&lat=36.37849#lptkr lptkr <Binary: 60 bytes> 36.37849 -93.5874
53851 Poynor Drug LLC AR Unknown   408 PUBLIC SQUARE BERRYVILLE, AR 72616 BERRYVILLE Carroll 72616 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141577306",
    "us_carbon_health:0b6ceb4f-ebc3-4727-8bb1-afded17a56ab"
]
   https://www.vaccinatethestates.com/?lng=-93.56820&lat=36.36467#lyfgr lyfgr <Binary: 60 bytes> 36.36467 -93.5682
66086 Harps Pharmacy #103 AR Unknown (870) 438-5614 703 West Main Street Green Forest, AR 72638 Green Forest Carroll 72638 
{
    "unstructured": null
}
 https://www.harpsfood.com 
[]
 
[
    "_tag_provider:harps",
    "harps:103",
    "us_carbon_health:bf04e068-1599-4422-80bf-47bad0efefb0"
]
   https://www.vaccinatethestates.com/?lng=-93.44622&lat=36.33526#lccfmc lccfmc <Binary: 60 bytes> 36.33526 -93.44622
66133 Smith Drug And Co AR Unknown (479) 253-9175 133 E Van Buren Eureka Springs, AR 72632 Eureka Springs Carroll 72632 
{
    "unstructured": null
}
   
[]
 
[
    "us_carbon_health:21708917-e321-49f0-8c27-7e989c1cad1c"
]
   https://www.vaccinatethestates.com/?lng=-93.73742&lat=36.39243#lccfrb lccfrb <Binary: 60 bytes> 36.39243 -93.73742
66217 Economy Drug AR Unknown (870) 423-2094 1006 W Trimble Ave Berryville, AR 72616 Berryville Carroll 72616 
{
    "unstructured": null
}
 https://www.economydrug.net 
[]
 
[
    "us_carbon_health:87434fd4-ed8e-4635-a3c1-1b3b6c6856fd"
]
   https://www.vaccinatethestates.com/?lng=-93.58874&lat=36.37921#lccfzg lccfzg <Binary: 60 bytes> 36.37921 -93.58874

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;