locations_expanded (view)

Data source: Vaccinate The States

13 rows where county = "Autauga" 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
6606 CVS Pharmacy, Inc. #04838 AL Pharmacy (334) 365-0661 708 E. Main St., Prattville, AL 36067 Prattville Autauga 36067 
{
    "unstructured": "08:00AM-09:00PM Mon-Fri, 09:00AM-06:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/004838 
[
    "Pfizer"
]
 
[
    "cvs:04838",
    "vaccinefinder:91f02b61-1d15-422a-9681-ccf689879e1f",
    "us_giscorps_vaccine_providers:1875082f-6fd0-4806-b395-a665a398e533",
    "vaccinespotter_org:270042884"
]
   https://www.vaccinatethestates.com/?lng=-86.45470&lat=32.45972#ldmrq ldmrq <Binary: 60 bytes> 32.45972 -86.4547
6753 Publix Super Markets Inc. #1228 AL Pharmacy (334) 285-0623 2451 Cobbs Ford Rd., Prattville, AL 36066 Prattville Autauga 36066 
{
    "unstructured": ""
}
 https://www.publix.com/pharmacy/pharmacy-services/vaccinations 
[]
 
[
    "vaccinefinder:4e2b3587-fe0b-4b6f-b77d-4604d0c01a3a",
    "publix:1228",
    "vaccinefinder_org:4e2b3587-fe0b-4b6f-b77d-4604d0c01a3a",
    "vaccinespotter_org:206729572",
    "_tag_provider:publix",
    "us_carbon_health:95532231-4de9-4291-8e68-abfc38a0b413"
]
   https://www.vaccinatethestates.com/?lng=-86.39832&lat=32.46138#ldpgf ldpgf <Binary: 60 bytes> 32.46138 -86.39832
6817 Winn-Dixie #527 AL Pharmacy 334-361-9950 701 East Main St, Prattville, AL 36067 Prattville Autauga 36067 
{
    "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:c3e06fd6-47eb-449c-9338-cd3cc1592276",
    "vaccinefinder_org:c3e06fd6-47eb-449c-9338-cd3cc1592276",
    "winn_dixie:527",
    "us_giscorps_vaccine_providers:16519e7b-46c4-4b32-856a-1b7662a0b39f",
    "vaccinespotter_org:54273754",
    "us_carbon_health:2ee4cbca-2f79-449c-89ea-8299faef58a5",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-86.45534&lat=32.46220#ldppf ldppf <Binary: 60 bytes> 32.4622 -86.45534
6856 Walgreens Co. #6800 AL Pharmacy 334-361-2261 703 S Memorial Dr, Prattville, AL 36067-5711 Prattville Autauga 36067-5711 
{
    "unstructured": "09:00AM - 9:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:6800",
    "vaccinefinder:3ce1f0c6-76a4-4f4b-8040-cf9697630632",
    "vaccinefinder_org:3ce1f0c6-76a4-4f4b-8040-cf9697630632"
]
   https://www.vaccinatethestates.com/?lng=-86.44976&lat=32.45996#ldprr ldprr <Binary: 60 bytes> 32.45996 -86.44976
6988 Walmart Inc #10-0483 AL Pharmacy 3343612135 1903 Cobbs Ford Rd, Prattville, AL 36066-7230 Prattville Autauga 36066-7230 
{
    "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/483 
[
    "Moderna"
]
 
[
    "vaccinefinder:857db4ba-0490-483a-8346-a5049e53b13c",
    "us_carbon_health:b79fdeef-2c8f-42d3-bfda-c000995d28ff",
    "walmart:483",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-86.41636&lat=32.46295#ldqdy ldqdy <Binary: 60 bytes> 32.46295 -86.41636
41031 Autauga County Health Department AL Hospital / Clinic   219 North Court Street Prattville 36067 Prattville Autauga 36067 
{
    "unstructured": ""
}
 https://al-telegov.egov.com/alabamavaccine/CustomerCreateAppointments/SelectLocation?appointmentTypeid=1 
[]
 
[]
 2021-04-29T01:22:39.412426+00:00 https://www.vaccinatethestates.com/?lng=-86.47563&lat=32.46568#lrzcz lrzcz <Binary: 60 bytes> 32.46568 -86.47563
41864 American Family Care - Prattville AL Unknown   1965 Cobbs Ford Rd, Prattville, Alabama, 36066 Prattville, AL 36066 Prattville Autauga 36066 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21190",
    "al_arcgis:22411"
]
   https://www.vaccinatethestates.com/?lng=-86.41322&lat=32.45995#ltdrz ltdrz <Binary: 60 bytes> 32.45995 -86.41322
42196 Wybenga Family Healthcare AL Unknown   564 N Memorial Dr, Prattville, Alabama, 36067 Prattville, AL 36067 Prattville Autauga 36067 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22380",
    "al_arcgis:22787"
]
   https://www.vaccinatethestates.com/?lng=-86.45194&lat=32.47463#ltgbm ltgbm <Binary: 60 bytes> 32.47463 -86.45194
44541 Adams Drugs-Prattville AL Unknown   103 S MEMORIAL DR PRATTVILLE, AL 36066 PRATTVILLE Autauga 36066 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141708971"
]
   https://www.vaccinatethestates.com/?lng=-86.45014&lat=32.46485#ltxkh ltxkh <Binary: 60 bytes> 32.46485 -86.45014
54807 CVS Pharmacy AL Unknown (334) 365-7606 1904 Cobb's Ford Road Prattville, AL 36066 Prattville Autauga 36066 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[]
 
[
    "us_giscorps_vaccine_providers:6bc2a4e2-a36d-463f-9ee8-11422542b1bd",
    "us_carbon_health:b35fbb54-5100-4076-a4ee-e6c492472fd5"
]
   https://www.vaccinatethestates.com/?lng=-86.41770&lat=32.46020#lymbz lymbz <Binary: 60 bytes> 32.4602 -86.4177
56382 Adams Drugs-Pine Level AL Unknown   2175 B HIGHWAY 31 N DEATSVILLE, AL 36022 DEATSVILLE Autauga 36022 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141708149"
]
   https://www.vaccinatethestates.com/?lng=-86.46582&lat=32.59986#lyxhh lyxhh <Binary: 60 bytes> 32.59986 -86.46582
64647 CVS Pharmacy in PRATTVILLE, AL AL Unknown   2754 LEGENDS PKWY PRATTVILLE, AL 36066 PRATTVILLE Autauga 36066 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[]
 
[
    "vaccinespotter_org:434904960"
]
   https://www.vaccinatethestates.com/?lng=-86.44088&lat=32.50919#lcbxwz lcbxwz <Binary: 60 bytes> 32.50919 -86.44088
66100 AUTAUGA PHARMACY #MS1001882 AL Unknown (334) 358-1774 209 S WASHINGTON ST AUTAUGAVILLE, AL 36003 AUTAUGAVILLE Autauga 36003 
{
    "unstructured": null
}
 http://www.autaugapharmacy.com 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:6d89cffa-f747-4a5a-aae9-d42d27ddf709"
]
   https://www.vaccinatethestates.com/?lng=-86.65496&lat=32.43164#lccfmz lccfmz <Binary: 60 bytes> 32.43164 -86.65496

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;