locations_expanded (view)

Data source: Vaccinate The States

8 rows where county = "Choctaw" and state = "AL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, hours, website, vaccines_offered, last_verified_by_vts (date), 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
6273 Butler-Choctaw County Airport Aeroportul AL Super Site   Airport Road - State Route 10, Butler, Alabama   Choctaw   
{
    "unstructured": null
}
 https://www.alabamapublichealth.gov/covid19vaccine/ng-clinics.html 
[]
 
[]
   https://www.vaccinatethestates.com/?lng=-88.12305&lat=32.11423#ldkdh ldkdh <Binary: 60 bytes> 32.11423 -88.12305
6401 Choctaw Health And Wellness AL Pharmacy (205) 459-2043 813 West Pushmataha Street, Butler, AL 36904 Butler Choctaw 36904 
{
    "unstructured": "9:00 AM - 3:00 PM Mon-Fri, Closed Sat-Sun"
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:4ac0d16b-2196-46f6-9c5e-8125d6df61e9",
    "vaccinefinder_org:4ac0d16b-2196-46f6-9c5e-8125d6df61e9",
    "us_carbon_health:af6ad9f7-2dcf-4993-ad1c-59dde0aa30e4"
]
   https://www.vaccinatethestates.com/?lng=-88.22614&lat=32.09026#ldkxf ldkxf <Binary: 60 bytes> 32.09026 -88.22614
6579 Choctaw County Health Department AL Pharmacy   1001 S Mulberry Ave, Butler, AL 36904-2813 Butler Choctaw 36904-2813 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:c342fa72-43ee-4957-b6e4-a81dc7198e38",
    "us_carbon_health:01d5fb46-7b18-4a64-9354-cb3b577cb27d"
]
 2021-05-04T03:04:18.031989+00:00 https://www.vaccinatethestates.com/?lng=-88.22607&lat=32.07977#ldmpw ldmpw <Binary: 60 bytes> 32.07977 -88.22607
41402 Fphc - Gilbertown Medical Center AL Unknown   140 Front St, Gilbertown, Alabama, 36908 Gilbertown, AL 36908 Gilbertown Choctaw 36908 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21323",
    "al_arcgis:22544"
]
   https://www.vaccinatethestates.com/?lng=-88.32203&lat=31.87728#ltbxp ltbxp <Binary: 60 bytes> 31.87728 -88.32203
41741 Willard's Medical Arts Pharmacy AL Unknown   313 E Pushmataha St, Butler, Alabama, 36904 Butler, AL 36904 Butler Choctaw 36904 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "al_arcgis:22785",
    "vaccinespotter_org:141558035"
]
   https://www.vaccinatethestates.com/?lng=-88.21883&lat=32.08990#ltdff ltdff <Binary: 60 bytes> 32.0899 -88.21883
42090 Choctaw General Hospital AL Unknown   401 Vanity Fair Ave, Butler, Alabama, 36904 Butler, AL 36904 Butler Choctaw 36904 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21645",
    "al_arcgis:22459"
]
   https://www.vaccinatethestates.com/?lng=-88.21283&lat=32.10037#ltfqq ltfqq <Binary: 60 bytes> 32.10037 -88.21283
43283 Hometown Pharmacy, Llc AL Unknown   69 W Main St, Gilbertown, Alabama, 36908 Gilbertown, AL 36908 Gilbertown Choctaw 36908 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22572"
]
   https://www.vaccinatethestates.com/?lng=-88.32177&lat=31.87694#ltphz ltphz <Binary: 60 bytes> 31.87694 -88.32177
56271 Mr Discount Health Mart Pharmacy Butler AL Unknown   604 E. Pushmataha St Butler, AL 36904 Butler Choctaw 36904 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141558034"
]
   https://www.vaccinatethestates.com/?lng=-88.21650&lat=32.08966#lywyg lywyg <Binary: 60 bytes> 32.08966 -88.2165

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;