locations_expanded (view)

Data source: Vaccinate The States

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

✎ View and edit SQL

This data as json, CSV (advanced)

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
8972 Bray Family Medicine AR Pharmacy (870) 464-1515 303 Professional Park Drive, Arkadelphia, AR 71923 Arkadelphia Clark 71923 
{
    "unstructured": "8:00 AM - 5:00 PM Mon-Fri, Closed Sat-Sun"
}
 http://www.brayfamilymed.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:b38d9f9f-e30a-47e2-8812-df71c64b7479",
    "vaccinefinder_org:b38d9f9f-e30a-47e2-8812-df71c64b7479",
    "us_carbon_health:74e929f7-fa56-4fdd-87d6-97b89f4dc1ff"
]
   https://www.vaccinatethestates.com/?lng=-93.09030&lat=34.12059#lfbzh lfbzh <Binary: 60 bytes> 34.12059 -93.0903
32245 Walmart Inc #10-0318 AR Pharmacy 8702462459 109 Malone Dr, Arkadelphia, AR 71923-8111 Arkadelphia Clark 71923-8111 
{
    "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/318 
[
    "Moderna"
]
 
[
    "vaccinefinder:006b1b35-eab2-4e1d-8757-e225c2daf6b3",
    "_tag_provider:walmart",
    "us_carbon_health:a384aefc-dbbb-45b6-9221-72099709d46a",
    "walmart:318"
]
   https://www.vaccinatethestates.com/?lng=-93.09648&lat=34.11978#lpwgd lpwgd <Binary: 60 bytes> 34.11978 -93.09648
40059 Brookshire Pharmacy #96 #163868 AR Pharmacy 870-246-2015 2800 Pine St #5 Pine Plaza, Brookshire Pharmacy #96, Arkadelphia, AR 71923 Arkadelphia Clark 71923 
{
    "unstructured": "9:00 AM - 7:00 PM Mon-Fri, 10:00 AM - 5:00 PM Sat,  Sun"
}
 https://www.brookshires.com/covid-19-screening-form 
[]
 
[
    "vaccinefinder_org:21ed71bf-3f21-4673-9b89-3feb94c4f494",
    "brookshire:163868"
]
   https://www.vaccinatethestates.com/?lng=-93.08502&lat=34.12242#lrtfy lrtfy <Binary: 60 bytes> 34.12242 -93.08502
43621 Walgreens Co. #10715 AR Unknown 870-230-1809 131 N 26TH ST ARKADELPHIA, AR 71923 ARKADELPHIA Clark 71923 
{
    "unstructured": null
}
 https://www.walgreens.com/findcare/vaccination/covid-19 
[
    "Moderna"
]
 
[
    "vaccinefinder_org:4232229d-16df-4b67-af87-f30170889528",
    "walgreens:10715",
    "vaccinespotter_org:2728926"
]
   https://www.vaccinatethestates.com/?lng=-93.08102&lat=34.12243#ltqtd ltqtd <Binary: 60 bytes> 34.12243 -93.08102
53832 AllCare Pharmacy #13 Correctional AR Unknown   624 CLAY STREET ARKADELPHIA, AR 71923 ARKADELPHIA Clark 71923 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141577002"
]
   https://www.vaccinatethestates.com/?lng=-93.05466&lat=34.11907#lyffm lyffm <Binary: 60 bytes> 34.11907 -93.05466
53897 AllCare Pharmacy #29 AR Unknown   521 MAIN STREET ARKADELPHIA, AR 71923 ARKADELPHIA Clark 71923 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141576998"
]
   https://www.vaccinatethestates.com/?lng=-93.05345&lat=34.11934#lyfmp lyfmp <Binary: 60 bytes> 34.11934 -93.05345
53909 AllCare Pharmacy #32 ALF AR Unknown   515 MAIN STREET ARKADELPHIA, AR 71923 ARKADELPHIA Clark 71923 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141576996"
]
   https://www.vaccinatethestates.com/?lng=-93.05315&lat=34.11934#lyfpg lyfpg <Binary: 60 bytes> 34.11934 -93.05315

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;