locations_expanded (view)

Data source: Vaccinate The States

7 rows where county = "Hale" and state = "AL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, hours, 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
6257 Boys and Girls Club (Old National Guard Armory AL Mobile clinic   515 Greene Street, Greensboro, 36744 Greensboro Hale 36744 
{
    "unstructured": ""
}
   
[]
 
[]
 2021-04-11T11:51:42.704195+00:00 https://www.vaccinatethestates.com/?lng=-87.58716&lat=32.69466#ldkcd ldkcd <Binary: 60 bytes> 32.69466 -87.58716
6337 Hale County Health Department AL Hospital / Clinic (334) 624-3018 670 Hall St, Greensboro, AL 36744-2516 Greensboro Hale 36744-2516 
{
    "unstructured": "7:30 AM - 5:00 PM Mon-Fri, Closed Sat-Sun"
}
 https://alcovidvaccine.gov/ 
[
    "Moderna"
]
 
[
    "vaccinefinder:f302c3d3-493b-4d3a-ada9-dec8c3411491",
    "us_carbon_health:342e6d8b-9421-48a6-858f-247736e3e9d9"
]
 2021-04-29T02:48:07.634170+00:00 https://www.vaccinatethestates.com/?lng=-87.58973&lat=32.69289#ldkpx ldkpx <Binary: 60 bytes> 32.69289 -87.58973
6587 Kc Drug AL Pharmacy 205-371-8755 40870 Al Highway 69 Ste D, Moundville, AL 35474-4367 Moundville Hale 35474-4367 
{
    "unstructured": "8:00 AM - 6:00 PM Mon-Fri, 8:00 AM - 12:00 PM Sat, Closed Sun"
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:dd871cc5-5c39-4f78-bef4-9b0d682a3de2",
    "us_carbon_health:de785c3c-dc32-4736-a8c5-3149865c8430"
]
   https://www.vaccinatethestates.com/?lng=-87.61950&lat=33.00150#ldmqh ldmqh <Binary: 60 bytes> 33.0015 -87.6195
6631 CVS Pharmacy, Inc. #04917 AL Pharmacy (334) 624-8874 675 Tuscaloosa Street, Greensboro, AL 36744 Greensboro Hale 36744 
{
    "unstructured": "08:00AM-07:00PM Mon-Fri, 09:00AM-06:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/004917 
[
    "Pfizer"
]
 
[
    "cvs:04917",
    "vaccinefinder:195b4a61-cf14-4270-893d-767cef9608e2",
    "vaccinespotter_org:270221477",
    "us_giscorps_vaccine_providers:878f2b34-cc43-4519-896b-029b27f02fe8",
    "us_carbon_health:ad2bf394-4b32-4d19-a3ae-781be4bc9228"
]
   https://www.vaccinatethestates.com/?lng=-87.59462&lat=32.70082#ldmwd ldmwd <Binary: 60 bytes> 32.70082 -87.59462
42730 Hale County Hospital AL Unknown   508 Greene St, Greensboro, Alabama, 36744 Greensboro, AL 36744 Greensboro Hale 36744 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22565"
]
   https://www.vaccinatethestates.com/?lng=-87.58692&lat=32.69479#ltkdp ltkdp <Binary: 60 bytes> 32.69479 -87.58692
50542 BOONE'S PHARMACY AL Unknown   850 D TUSCALOOSA ST GREENSBORO, AL 36744 GREENSBORO Hale 36744 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[
    "Johnson & Johnson"
]
 
[
    "vaccinespotter_org:141708292"
]
   https://www.vaccinatethestates.com/?lng=-87.59535&lat=32.70079#lxkfk lxkfk <Binary: 60 bytes> 32.70079 -87.59535
54847 Hale County Hospital Clinic AL Unknown   400 1st St, Greensboro, Alabama, 36744 Greensboro, AL 36744 Greensboro Hale 36744 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21342"
]
   https://www.vaccinatethestates.com/?lng=-87.58795&lat=32.69494#lymfm lymfm <Binary: 60 bytes> 32.69494 -87.58795

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;