locations_expanded (view)

Data source: Vaccinate The States

10 rows where county = "Barbour" and state = "AL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, website, 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
6284 Baker Hill School AL Super Site   24 Bakerhill School Road, Eufaula, AL 36027   Barbour   
{
    "unstructured": null
}
 https://www.alabamapublichealth.gov/covid19vaccine/ng-clinics.html 
[]
 
[]
   https://www.vaccinatethestates.com/?lng=-85.30536&lat=31.77969#ldkfb ldkfb <Binary: 60 bytes> 31.77969 -85.30536
6382 Mainstreet Family Care - Eufaula AL Pharmacy   1026 S Eufaula Ave, Eufaula, AL 36027 Eufaula Barbour 36027 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:213f14e6-bfc3-47e6-a61b-602029b57a0c",
    "vaccinefinder_org:213f14e6-bfc3-47e6-a61b-602029b57a0c",
    "us_carbon_health:8468b6df-32d4-4f1e-8ddd-f2bbd9f99cb8"
]
   https://www.vaccinatethestates.com/?lng=-85.14836&lat=31.87960#ldkwb ldkwb <Binary: 60 bytes> 31.8796 -85.14836
6570 Barbour County Health Department - Eufaula AL Hospital / Clinic (334) 687-4808 634 School St, Eufaula, AL 36027-2430 Eufaula Barbour 36027-2430 
{
    "unstructured": " Mon, 8:00 AM - 12:30 PM Tue,  Wed,  Thrus,  Fri,  Sat,  Sun"
}
 https://al-telegov.egov.com/alabamavaccine 
[
    "Moderna"
]
 
[
    "vaccinefinder:bfddc9f6-156c-42c6-95c5-87374c0f0bf3",
    "us_carbon_health:165a4180-370c-4393-ad9c-5beca5796d87"
]
 2021-04-29T01:19:08.529582+00:00 https://www.vaccinatethestates.com/?lng=-85.14040&lat=31.88186#ldmpf ldmpf <Binary: 60 bytes> 31.88186 -85.1404
6677 Buy Rite Drugs #14 AL Pharmacy 229-435-4571 146 E Broad St, Eufaula, AL 36027 Eufaula Barbour 36027 
{
    "unstructured": "10:00 AM - 04:00 PM Mon-Fri"
}
 https://healthmartcovidvaccine.com 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:a3a8cd16-8648-49aa-9205-b6bad469e00a",
    "vaccinefinder_org:a3a8cd16-8648-49aa-9205-b6bad469e00a",
    "vaccinespotter_org:141711489"
]
   https://www.vaccinatethestates.com/?lng=-85.14415&lat=31.89341#ldmzc ldmzc <Binary: 60 bytes> 31.89341 -85.14415
6685 Buy Rite Drugs #13 AL Pharmacy 334-687-0021 542 S Eufaula, Eufaula, AL 36027 Eufaula Barbour 36027 
{
    "unstructured": "10:00 AM - 04:00 PM Mon-Fri"
}
 https://healthmartcovidvaccine.com 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:208c992e-997b-42b2-ac64-5884153a6902",
    "vaccinefinder_org:208c992e-997b-42b2-ac64-5884153a6902",
    "vaccinespotter_org:141711490"
]
   https://www.vaccinatethestates.com/?lng=-85.14581&lat=31.88625#ldmzq ldmzq <Binary: 60 bytes> 31.88625 -85.14581
6812 Winn-Dixie #478 AL Pharmacy 334-687-8781 1055 S. Eufaula Ave., Eufaula, AL 36027 Eufaula Barbour 36027 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 5:00PM Sat, 11:00AM - 5:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:6656aead-1b03-430b-acb7-738fd9835d68",
    "vaccinefinder_org:6656aead-1b03-430b-acb7-738fd9835d68",
    "winn_dixie:478",
    "us_giscorps_vaccine_providers:ae42786b-d1a9-4ae6-9ba0-66e21e86a415",
    "vaccinespotter_org:54273721",
    "us_carbon_health:fd86ad41-f2c3-41d2-bc34-e265042691e2",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-85.14684&lat=31.87801#ldpmy ldpmy <Binary: 60 bytes> 31.87801 -85.14684
6963 Walgreens Co. #19668 AL Pharmacy 334-687-7144 130 South Eufaula Avenue, Eufaula, AL 36027-2026 Eufaula Barbour 36027-2026 
{
    "unstructured": "08:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer",
    "Johnson & Johnson"
]
 
[
    "walgreens:19668",
    "vaccinefinder:fdea9f4c-41b0-4493-bd24-9e9a781baaf8",
    "vaccinefinder_org:fdea9f4c-41b0-4493-bd24-9e9a781baaf8"
]
   https://www.vaccinatethestates.com/?lng=-85.14636&lat=31.89192#ldqch ldqch <Binary: 60 bytes> 31.89192 -85.14636
7035 Walmart Inc #10-1638 AL Pharmacy 3346872218 3176 S Eufaula Ave, Eufaula, AL 36027-4406 Eufaula Barbour 36027-4406 
{
    "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/1638 
[
    "Moderna"
]
 
[
    "vaccinefinder:689ef304-752c-45fa-9b36-e4b726b8de5b",
    "walmart:1638",
    "us_carbon_health:0fa9b787-c5ac-493a-b642-080639d8b77b",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-85.17106&lat=31.84355#ldqhx ldqhx <Binary: 60 bytes> 31.84355 -85.17106
42332 Medical Center Barbour AL Unknown   820 W Washington St, Eufaula, Alabama, 36027 Eufaula, AL 36027 Eufaula Barbour 36027 
{
    "unstructured": null
}
   
[
    "Moderna",
    "Pfizer"
]
 
[
    "al_arcgis:22647"
]
   https://www.vaccinatethestates.com/?lng=-85.15606&lat=31.88802#ltgqd ltgqd <Binary: 60 bytes> 31.88802 -85.15606
56176 Sarha-Clayton Family Health Center AL Unknown   7 Western Byp, Clayton, Alabama, 36016 Clayton, AL 36016 Clayton Barbour 36016 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21494"
]
   https://www.vaccinatethestates.com/?lng=-85.46051&lat=31.87036#lywpb lywpb <Binary: 60 bytes> 31.87036 -85.46051

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;