locations_expanded (view)

Data source: Vaccinate The States

28 rows where county = "Elmore" 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
6422 Mainstreet Family Care - Millbrook AL Pharmacy   1401 Highway 14, Millbrook, AL 36054 Millbrook Elmore 36054 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:e3ecd1e3-fcf1-48f3-8ecd-f2d3f05f6a84",
    "vaccinefinder_org:e3ecd1e3-fcf1-48f3-8ecd-f2d3f05f6a84",
    "us_carbon_health:7b38fc54-cacb-4b62-92db-6597d86dbfda"
]
   https://www.vaccinatethestates.com/?lng=-86.40424&lat=32.49420#ldkyp ldkyp <Binary: 60 bytes> 32.4942 -86.40424
6423 Jones Drugs AL Pharmacy (334) 523-8921 4117 Highway 14, Millbrook, AL 36054 Millbrook Elmore 36054 
{
    "unstructured": "10:00 AM - 6:00 PM Mon-Fri, 10:00 AM - 1:00 PM Sat,  Sun"
}
   
[]
 
[
    "vaccinefinder:94d46690-b417-42c7-a6bf-3fa8c03373cd",
    "vaccinefinder_org:94d46690-b417-42c7-a6bf-3fa8c03373cd",
    "us_carbon_health:70a2ca66-902e-47d3-8e60-f2d3cd118ac6"
]
   https://www.vaccinatethestates.com/?lng=-86.36877&lat=32.52022#ldkyq ldkyq <Binary: 60 bytes> 32.52022 -86.36877
6712 Wetumpka Pharmacy Llc #Ms1001910 AL Pharmacy 334-567-5442 277 Huntress St Suite 101, Wetumpka, AL 36093 Wetumpka Elmore 36093 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:137c2625-d389-46e5-aece-f1460b2a4b81"
]
   https://www.vaccinatethestates.com/?lng=-86.21740&lat=32.50654#ldpcm ldpcm <Binary: 60 bytes> 32.50654 -86.2174
6798 Winn-Dixie #428 AL Pharmacy 334-567-2420 5326 Highway 231 South, Wetumpka, AL 36092 Wetumpka Elmore 36092 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 6:00PM Sat, 11:00AM - 5:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:3d44aa92-dfd1-4aa3-8268-458d01511c36",
    "vaccinefinder_org:3d44aa92-dfd1-4aa3-8268-458d01511c36",
    "winn_dixie:428",
    "us_giscorps_vaccine_providers:72a84e60-29f3-441c-bb47-d21c6a07edb2",
    "vaccinespotter_org:54273747",
    "us_carbon_health:3a7f1135-2eaf-49c2-9ee8-9bd8a7b9693c",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-86.20958&lat=32.51811#ldpmb ldpmb <Binary: 60 bytes> 32.51811 -86.20958
6806 Winn-Dixie #451 AL Pharmacy 334-285-8335 3625 Hwy 14, Milbrook, AL 36054 Milbrook Elmore 36054 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 5:00PM Sat, 12:00PM - 5:00PM Sun"
}
 https://www.winndixie.com/pharmacy/covid-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:71735f04-6858-4314-ba39-483d68ecdaef",
    "vaccinefinder_org:71735f04-6858-4314-ba39-483d68ecdaef",
    "winn_dixie:451",
    "us_carbon_health:267765b8-72c5-4b18-9ae0-7d6882308608",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-86.37707&lat=32.51760#ldpmp ldpmp <Binary: 60 bytes> 32.5176 -86.37707
6891 Walgreens Co. #10664 AL Pharmacy 334-514-7135 795 Wilson St, Wetumpka, AL 36092-2901 Wetumpka Elmore 36092-2901 
{
    "unstructured": "09:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:10664",
    "vaccinefinder:23b439a1-e663-4f08-9bdc-93a9de74afd3",
    "vaccinefinder_org:23b439a1-e663-4f08-9bdc-93a9de74afd3"
]
   https://www.vaccinatethestates.com/?lng=-86.20561&lat=32.52646#ldpwx ldpwx <Binary: 60 bytes> 32.52646 -86.20561
6906 Walgreens Co. #11389 AL Pharmacy 334-285-1450 3720 Highway 14, Millbrook, AL 36054-1959 Millbrook Elmore 36054-1959 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:11389",
    "vaccinefinder:f40a22e4-d05f-4966-b631-272ba7aae8e0",
    "vaccinefinder_org:f40a22e4-d05f-4966-b631-272ba7aae8e0"
]
   https://www.vaccinatethestates.com/?lng=-86.37466&lat=32.51625#ldpxw ldpxw <Binary: 60 bytes> 32.51625 -86.37466
7019 Walmart Inc #10-1057 AL Pharmacy 3342836841 2190 Gilmer Ave, Tallassee, AL 36078-7123 Tallassee Elmore 36078-7123 
{
    "unstructured": "9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Mon, 6:00 AM - 1:30PM, 2:00 PM - 7:00 PM Tue, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Wed, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Thrus, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Fri, 9:00 AM - 1:30PM, 2:00 PM - 6:00 PM Sat, 10:00 AM - 1:30PM, 2:00 PM - 5:00 PM Sun"
}
 https://www.walmart.com/store/1057 
[
    "Moderna"
]
 
[
    "vaccinefinder:aff7dc1a-6d8f-4820-b8f2-82c393f51106",
    "walmart:1057",
    "us_carbon_health:fc91fadd-9682-436a-8a51-8d64170b5f41",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-85.93133&lat=32.56592#ldqgx ldqgx <Binary: 60 bytes> 32.56592 -85.93133
7023 Walmart Inc #10-1101 AL Pharmacy 3345673066 4538 Us Highway 231, Wetumpka, AL 36092-3333 Wetumpka Elmore 36092-3333 
{
    "unstructured": "9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Mon, 6:00 AM - 1:30PM, 2:00 PM - 7:00 PM Tue, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Wed, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Thrus, 9:00 AM - 1:30PM, 2:00 PM - 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/1101 
[
    "Moderna"
]
 
[
    "vaccinefinder:353c732c-1940-4188-bd4a-76226129ec3f",
    "walmart:1101",
    "us_carbon_health:f86ad745-8655-4ff4-ad00-af077c215708",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-86.21236&lat=32.50698#ldqhc ldqhc <Binary: 60 bytes> 32.50698 -86.21236
7055 Walmart Inc #10-4318 AL Pharmacy 3342850311 145 Kelley Blvd, Millbrook, AL 36054-2200 Millbrook Elmore 36054-2200 
{
    "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/4318 
[
    "Moderna"
]
 
[
    "vaccinefinder:fe2f283e-07f2-44d9-8fe0-44f6cc1736f5",
    "us_carbon_health:fa549c83-1ca4-4b52-9558-e0d87d013477",
    "walmart:4318",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-86.39816&lat=32.49405#ldqmc ldqmc <Binary: 60 bytes> 32.49405 -86.39816
41041 Elmore County Health Department AL Hospital / Clinic   6501 U.S. Highway 231 Wetumpka, AL 36092 Wetumpka Elmore 36092 
{
    "unstructured": ""
}
 https://al-telegov.egov.com/alabamavaccine/CustomerCreateAppointments/SelectLocation?appointmentTypeid=1 
[]
 
[]
 2021-04-29T02:41:42.933316+00:00 https://www.vaccinatethestates.com/?lng=-86.20426&lat=32.53414#lrzdq lrzdq <Binary: 60 bytes> 32.53414 -86.20426
41441 Wetumpka Family Rural Health Clinic AL Unknown   815 Jackson Trace Rd, Wetumpka, Alabama, 36092 Wetumpka, AL 36092 Wetumpka Elmore 36092 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21559",
    "al_arcgis:22780"
]
   https://www.vaccinatethestates.com/?lng=-86.19062&lat=32.55212#ltbzz ltbzz <Binary: 60 bytes> 32.55212 -86.19062
42145 Community Hosp Inc Tallassee AL Unknown   805 Friendship Rd, Tallassee, Alabama, 36078 Tallassee, AL 36078 Tallassee Elmore 36078 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21660",
    "al_arcgis:22474"
]
   https://www.vaccinatethestates.com/?lng=-85.90649&lat=32.53549#ltfxf ltfxf <Binary: 60 bytes> 32.53549 -85.90649
42301 River Region Family Medicine AL Unknown   36092, Wetumpka, Alabama Wetumpka, AL 36092 Wetumpka Elmore 36092 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22296"
]
   https://www.vaccinatethestates.com/?lng=-86.21070&lat=32.53981#ltgmf ltgmf <Binary: 60 bytes> 32.53981 -86.2107
43186 Covington Healthcare, Llc AL Unknown   1608A Gilmer Ave, Tallassee, Alabama, 36078 Tallassee, AL 36078 Tallassee Elmore 36078 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22481"
]
   https://www.vaccinatethestates.com/?lng=-85.92594&lat=32.55677#ltmzy ltmzy <Binary: 60 bytes> 32.55677 -85.92594
43943 Elmore Community Hospital AL Unknown   500 Hospital Dr, Wetumpka, Alabama, 36092 Wetumpka, AL 36092 Wetumpka Elmore 36092 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22512"
]
   https://www.vaccinatethestates.com/?lng=-86.18704&lat=32.55226#ltrzq ltrzq <Binary: 60 bytes> 32.55226 -86.18704
51289 Tallassee Supercenter AL Unknown   2190 Gilmer Avenue Tallassee, AL 36078 Tallassee Elmore 36078 
{
    "unstructured": null
}
 https://www.walmart.com/pharmacy/clinical-services/immunization/scheduled?imzType=covid 
[]
 
[
    "vaccinespotter_org:778760"
]
   https://www.vaccinatethestates.com/?lng=-85.91671&lat=32.55178#lxqdm lxqdm <Binary: 60 bytes> 32.55178 -85.91671
53082 Ivy Creek Family Care Of Tallassee AL Unknown   2256 Gilmer Ave, Tallassee, Alabama, 36078 Tallassee, AL 36078 Tallassee Elmore 36078 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22176"
]
   https://www.vaccinatethestates.com/?lng=-85.93380&lat=32.56600#lybgd lybgd <Binary: 60 bytes> 32.566 -85.9338
53083 Adams Drugs-Millbrook AL Unknown   185 ASHTON PLAZA ST MILLBROOK, AL 36054 MILLBROOK Elmore 36054 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141708046"
]
   https://www.vaccinatethestates.com/?lng=-86.38160&lat=32.51583#lybgf lybgf <Binary: 60 bytes> 32.51583 -86.3816
54894 CVS Pharmacy AL Unknown (334) 285-3041 3680 Highway 14 Millbrook, AL 36054 Millbrook Elmore 36054 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "us_giscorps_vaccine_providers:9b8bdfba-7789-46df-8b2a-2cbbf7f9616a",
    "vaccinespotter_org:270331758",
    "us_carbon_health:6f0b13ae-0352-4ce5-9b0b-aa178e2c3acf"
]
 2021-05-14T01:36:44.553589+00:00 https://www.vaccinatethestates.com/?lng=-86.37590&lat=32.51570#lymkp lymkp <Binary: 60 bytes> 32.5157 -86.3759
54929 Adams Drugs - Wetumpka AL Unknown   5268 US Highway 231, Wetumpka, Alabama, 36092 Wetumpka, AL 36092 Wetumpka Elmore 36092 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21985"
]
   https://www.vaccinatethestates.com/?lng=-86.21118&lat=32.51817#lympt lympt <Binary: 60 bytes> 32.51817 -86.21118
54931 Herren Hill Health Mart Pharmacy AL Unknown   24 Herren Hill Road Tallassee, AL 36078 Tallassee Elmore 36078 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141557411"
]
   https://www.vaccinatethestates.com/?lng=-85.91454&lat=32.53506#lympx lympx <Binary: 60 bytes> 32.53506 -85.91454
55048 Spring View Health Mart Pharmacy AL Unknown   4810 MAIN STREET, P O Box 722 Millbrook, AL 36054 Millbrook Elmore 36054 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141708047"
]
   https://www.vaccinatethestates.com/?lng=-86.36930&lat=32.50000#lypbh lypbh <Binary: 60 bytes> 32.5 -86.3693
55096 Eclectic Family Health Mart Pharmacy AL Unknown   575 Claud Rd., Ste. 2000 Eclectic, AL 36024 Eclectic Elmore 36024 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141557413"
]
   https://www.vaccinatethestates.com/?lng=-86.05096&lat=32.58004#lypfk lypfk <Binary: 60 bytes> 32.58004 -86.05096
56028 CVS Pharmacy, Inc. #04943 AL Unknown (334) 283-3637 10 GILMER AVE. TALLASSEE, AL 36078 TALLASSEE Elmore 36078 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:bcb03d01-46e1-4ee9-993e-d750f33c8c97",
    "cvs:4943",
    "vaccinespotter_org:270184730",
    "us_carbon_health:9966e9ef-468f-4f5b-b4a4-65c7fb44df86"
]
   https://www.vaccinatethestates.com/?lng=-85.89857&lat=32.53765#lytyr lytyr <Binary: 60 bytes> 32.53765 -85.89857
56277 Lake Health Mart Pharmacy AL Unknown   95 LIGHTWOOD RD HWY 23 Deatsville, AL 36022 Deatsville Elmore 36022 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141708044"
]
   https://www.vaccinatethestates.com/?lng=-86.39581&lat=32.60819#lywyr lywyr <Binary: 60 bytes> 32.60819 -86.39581
56387 The Apothecary AL Unknown   1405 Gilmer Ave Tallassee, AL 36078 Tallassee Elmore 36078 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141557412"
]
   https://www.vaccinatethestates.com/?lng=-85.91339&lat=32.54837#lyxhr lyxhr <Binary: 60 bytes> 32.54837 -85.91339
64656 CVS Pharmacy in WETUMPKA, AL AL Unknown   763 WILSON ST. WETUMPKA, AL 36092 WETUMPKA Elmore 36092 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[]
 
[
    "vaccinespotter_org:434861972"
]
   https://www.vaccinatethestates.com/?lng=-86.20535&lat=32.52771#lcbxxp lcbxxp <Binary: 60 bytes> 32.52771 -86.20535

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;