locations_expanded (view)

Data source: Vaccinate The States

6 rows where county = "Randolph" and state = "AR"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: full_address, zip_code, website, vaccines_offered, geometry, longitude, 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
9096 Pocahontas Medical Clinic, PA AR Pharmacy   2901 Medical Center Drive, Pocahontas, AR 72455 Pocahontas Randolph 72455 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:88d81fd8-6c3d-438d-a139-48ca88b7de08",
    "vaccinefinder_org:88d81fd8-6c3d-438d-a139-48ca88b7de08",
    "us_carbon_health:92fa6007-8d0a-449c-b935-c81fcfdfd049"
]
   https://www.vaccinatethestates.com/?lng=-90.99802&lat=36.29016#lfcmd lfcmd <Binary: 60 bytes> 36.29016 -90.99802
9098 Futrell Pharmacy Inc AR Pharmacy (870) 892-5615 115 East Broadway Street, Pocahontas, AR 72455 Pocahontas Randolph 72455 
{
    "unstructured": "8:00 AM - 6:00 PM Mon-Fri, 8:00 AM - 1:00 PM Sat, Closed Sun"
}
 http://www.futrellpharmacy.com 
[]
 
[
    "vaccinefinder:ff0ddade-5fe3-4f1a-a4df-8773aec58410"
]
   https://www.vaccinatethestates.com/?lng=-90.97027&lat=36.26090#lfcmg lfcmg <Binary: 60 bytes> 36.2609 -90.97027
9734 Futrell Pharmacy Inc #405743 AR Pharmacy 870-892-5615 115 East Broadway Street, Pocahontas, AR 72455 Pocahontas Randolph 72455 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:fe3cebb3-bbb3-4f39-bd3c-691385e4ffdc"
]
   https://www.vaccinatethestates.com/?lng=-90.97027&lat=36.26090#lffzm lffzm <Binary: 60 bytes> 36.2609 -90.97027
12103 City Pharmacy #0411001 AR Pharmacy (870) 892-5517 606 South Park Street, Pocahontas, AR 72455 Pocahontas Randolph 72455 
{
    "unstructured": "8:30 AM - 5:30 PM Mon-Fri, 8:30 AM - 1:00 PM Sat, Closed Sun"
}
   
[]
 
[
    "vaccinefinder:1b76850e-0231-40f1-aee8-c4b63db2812c",
    "vaccinefinder_org:1b76850e-0231-40f1-aee8-c4b63db2812c"
]
   https://www.vaccinatethestates.com/?lng=-90.98359&lat=36.25867#lfxgc lfxgc <Binary: 60 bytes> 36.25867 -90.98359
32024 Walmart Inc #10-0071 AR Pharmacy 8708927703 1415 Highway 67 S, Pocahontas, AR 72455-4000 Pocahontas Randolph 72455-4000 
{
    "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/71 
[
    "Moderna"
]
 
[
    "vaccinefinder:c4053fb4-9513-4846-84d5-dd1b54de0418",
    "walmart:71",
    "us_carbon_health:56f3b62e-4a7d-4fee-9035-8c610ae0c173",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-90.96325&lat=36.24872#lptkh lptkh <Binary: 60 bytes> 36.24872 -90.96325
64380 Randolph County Drug AR Unknown (870) 202-2536 567 Highway 67 South Pocahontas Pocahontas, AR 72455 Pocahontas Randolph 72455 
{
    "unstructured": null
}
 https://www.mygnp.com/pharmacies/programs/covid-19-vaccine/ 
[]
 
[
    "us_giscorps_vaccine_providers:f5132920-bb2b-466e-8500-6734ba98c15f"
]
   https://www.vaccinatethestates.com/?lng=-90.97278&lat=36.25770#lcbwwg lcbwwg <Binary: 60 bytes> 36.2577 -90.97278

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;