locations_expanded (view)

Data source: Vaccinate The States

33 rows where county = "Etowah" and state = "AL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
6426 Anderson Pharmacy AL Pharmacy 205-589-6557 7101 Etowah St, Altoona, AL 35952 Altoona Etowah 35952 
{
    "unstructured": "9:00 AM - 5:00 PM Mon-Fri, 9:00 AM - 12:00 PM Sat, Closed Sun"
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:419e6953-8b7c-4410-863e-edcb1ca8caa0",
    "vaccinespotter_org:141557192",
    "vaccinefinder_org:419e6953-8b7c-4410-863e-edcb1ca8caa0",
    "us_giscorps_vaccine_providers:109f9648-8929-48fa-95fb-9548b9a15f48",
    "us_carbon_health:3d835a6f-05bb-4ac6-86ef-082195d13767"
]
   https://www.vaccinatethestates.com/?lng=-86.32562&lat=34.02611#ldkyw ldkyw <Binary: 60 bytes> 34.02611 -86.32562
6427 Physicians Apothecary AL Pharmacy (256) 547-8631 1011 Forrest Ave, Gadsden, AL 35901-3539 Gadsden Etowah 35901-3539 
{
    "unstructured": "9:00 AM - 9:00 PM Mon-Fri, 9:00 AM - 7:00 PM Sat, 1:00 PM - 7:00 PM Sun"
}
 http://www.yourphysiciansapothecary.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:8fbfc714-e356-4742-8520-6dd2544ae1ed",
    "us_carbon_health:7122cf3c-33aa-42d5-9ccf-32fe16904db5"
]
   https://www.vaccinatethestates.com/?lng=-86.01547&lat=34.01752#ldkyx ldkyx <Binary: 60 bytes> 34.01752 -86.01547
6428 Mountain View Hospital Gadsden AL Pharmacy   3001 Scenic Hwy, Gadsden, AL 35904-3047 Gadsden Etowah 35904-3047 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:018d388e-adc0-482d-befe-184064761e9d",
    "us_carbon_health:516eb716-1d38-402e-b60e-17a2dc8c69db"
]
   https://www.vaccinatethestates.com/?lng=-86.01969&lat=34.07240#ldkyy ldkyy <Binary: 60 bytes> 34.0724 -86.01969
6429 Super Bee Pharmacy AL Pharmacy   3354 Rainbow Dr, Rainbow City, AL 35906 Rainbow City Etowah 35906 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:d35c4898-9eaa-4af0-b0da-75cbc9c4edd9",
    "vaccinefinder_org:d35c4898-9eaa-4af0-b0da-75cbc9c4edd9",
    "vaccinespotter_org:141707936",
    "us_carbon_health:d542e329-9153-4289-b57e-d10f1b18f2b8"
]
   https://www.vaccinatethestates.com/?lng=-86.03882&lat=33.95706#ldkyz ldkyz <Binary: 60 bytes> 33.95706 -86.03882
6430 Southside Family Pharmacy AL Pharmacy (256) 413-4473 1250 Highway 77, Southside, AL 35907-0405 Southside Etowah 35907-0405 
{
    "unstructured": "9:00 AM - 6:00 PM Mon-Fri, 9:00 AM - 2:00 PM Sat, Closed Sun"
}
 http://www.southsiderx.com 
[]
 
[
    "vaccinefinder:28958850-593c-4953-a151-82944ad65311",
    "us_carbon_health:54459855-7d32-4642-b9e9-a4a68ceb843c"
]
   https://www.vaccinatethestates.com/?lng=-86.02499&lat=33.93501#ldkzb ldkzb <Binary: 60 bytes> 33.93501 -86.02499
6431 Gadsden Eye Associates AL Pharmacy   310 South Fifth Street, Gadsden, AL 35901 Gadsden Etowah 35901 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:444996c6-224d-4d86-b5bf-73fec900c857",
    "vaccinefinder_org:444996c6-224d-4d86-b5bf-73fec900c857",
    "us_carbon_health:11ec977f-9a0b-4db8-9807-08bf8847cd25"
]
   https://www.vaccinatethestates.com/?lng=-86.00698&lat=34.00973#ldkzc ldkzc <Binary: 60 bytes> 34.00973 -86.00698
6432 Corporate Pharmacy Services Inc. AL Pharmacy 256-439-1455 319 Broad Street, Gadsden, AL 35901 Gadsden Etowah 35901 
{
    "unstructured": "9:00 AM - 5:00 PM Mon-Fri, Closed Sat-Sun"
}
 http://www.corporatepharmacy.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:f31599c8-2b40-41eb-8c05-d670d3ee674b",
    "vaccinefinder_org:f31599c8-2b40-41eb-8c05-d670d3ee674b",
    "us_carbon_health:93d32a49-46df-4afe-ab5f-02f9569ba989"
]
   https://www.vaccinatethestates.com/?lng=-86.00268&lat=34.01281#ldkzd ldkzd <Binary: 60 bytes> 34.01281 -86.00268
6433 Etowah Family Medical AL Pharmacy   1405A Rainbow Dr, Gadsden, AL 35901-5319 Gadsden Etowah 35901-5319 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:700e67ce-37c8-4813-b263-b6a62b12cfe7",
    "us_carbon_health:65ee9416-deb6-466e-bd2c-630902e2ed17"
]
   https://www.vaccinatethestates.com/?lng=-86.00606&lat=33.98662#ldkzf ldkzf <Binary: 60 bytes> 33.98662 -86.00606
6554 Etowah Pediatrics Pc AL Pharmacy (256) 413-1467 170 Independent Dr, Rainbow City, AL 35906-3286 Rainbow City Etowah 35906-3286 
{
    "unstructured": "9:00 AM - 5:00 PM Mon-Fri, Closed Sat-Sun"
}
   
[]
 
[
    "vaccinefinder:6ebdde3a-d162-482a-9882-2525b19583fa",
    "us_carbon_health:e3b8fdbd-0433-4a8e-8f5d-bca838878cb7"
]
   https://www.vaccinatethestates.com/?lng=-86.04193&lat=33.95751#ldmmf ldmmf <Binary: 60 bytes> 33.95751 -86.04193
6610 CVS Pharmacy, Inc. #04845 AL Pharmacy (256) 492-4807 806 Hoke St., Gadsden, AL 35903 Gadsden Etowah 35903 
{
    "unstructured": "08:30AM-09:00PM Mon-Fri, 09:00AM-06:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/004845 
[
    "Pfizer"
]
 
[
    "cvs:04845",
    "vaccinefinder:fca53fc8-7980-4afe-9d62-b3fa6353a7a8",
    "us_giscorps_vaccine_providers:0f63ec77-54b5-4693-9c51-bc916b517c4e"
]
   https://www.vaccinatethestates.com/?lng=-85.96981&lat=34.00330#ldmrx ldmrx <Binary: 60 bytes> 34.0033 -85.96981
6774 Publix Super Markets Inc. #1476 AL Pharmacy (256) 442-2581 128 West Grand Ave, Rainbow City, AL 35906 Rainbow City Etowah 35906 
{
    "unstructured": ""
}
 https://www.publix.com/pharmacy/pharmacy-services/vaccinations 
[]
 
[
    "vaccinefinder:242e8c97-7644-479e-8fc4-bb0b4ad6172b",
    "vaccinefinder_org:242e8c97-7644-479e-8fc4-bb0b4ad6172b",
    "publix:1476",
    "vaccinespotter_org:206729544",
    "us_carbon_health:ce2b639a-1262-41e0-b2f7-a585ab67e4aa",
    "_tag_provider:publix"
]
   https://www.vaccinatethestates.com/?lng=-86.04396&lat=33.95527#ldphp ldphp <Binary: 60 bytes> 33.95527 -86.04396
6802 Winn-Dixie #442 AL Pharmacy 256-442-7275 3331 Rainbow Drive, Rainbow City, AL 35906 Rainbow City Etowah 35906 
{
    "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:0c1deadd-0876-44a1-b9d6-664db02eee87",
    "vaccinefinder_org:0c1deadd-0876-44a1-b9d6-664db02eee87",
    "winn_dixie:442",
    "us_giscorps_vaccine_providers:859edc79-f968-4ce9-b18a-3d67749f7b48",
    "vaccinespotter_org:54273765",
    "us_carbon_health:8de6ffe5-9052-4d51-a552-c0b563c0efab",
    "_tag_provider:winn_dixie"
]
   https://www.vaccinatethestates.com/?lng=-86.03719&lat=33.96036#ldpmg ldpmg <Binary: 60 bytes> 33.96036 -86.03719
6867 Walgreens Co. #7716 AL Pharmacy 256-413-1767 3434 Rainbow Dr, Rainbow City, AL 35906-6240 Rainbow City Etowah 35906-6240 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:7716",
    "vaccinefinder:8cf96632-de74-42e8-929a-994c724f4927",
    "vaccinefinder_org:8cf96632-de74-42e8-929a-994c724f4927"
]
   https://www.vaccinatethestates.com/?lng=-86.04061&lat=33.95482#ldpth ldpth <Binary: 60 bytes> 33.95482 -86.04061
6868 Walgreens Co. #7717 AL Pharmacy 256-547-4719 107 E Meighan Blvd, Gadsden, AL 35903-1044 Gadsden Etowah 35903-1044 
{
    "unstructured": "07:00AM - 10:00PM Mon-Fri, 08:00AM - 10:00PM Sat-Sun"
}
 https://www.walgreens.com 
[
    "Pfizer",
    "Johnson & Johnson"
]
 
[
    "walgreens:7717",
    "vaccinefinder:831e676d-9514-469a-9ec1-dda4cef0157b",
    "vaccinefinder_org:831e676d-9514-469a-9ec1-dda4cef0157b"
]
   https://www.vaccinatethestates.com/?lng=-85.99150&lat=34.01044#ldptk ldptk <Binary: 60 bytes> 34.01044 -85.9915
6969 Walmart Inc #10-0301 AL Pharmacy 2565472637 340 E Meighan Blvd, Gadsden, AL 35903-1049 Gadsden Etowah 35903-1049 
{
    "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/301 
[
    "Moderna"
]
 
[
    "vaccinefinder:53e2bd55-62c9-4ad9-859f-01ddb4e92138",
    "us_carbon_health:284d2aa2-bf05-49a5-8850-e6a4d0752aee",
    "walmart:301",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-85.98712&lat=34.01265#ldqct ldqct <Binary: 60 bytes> 34.01265 -85.98712
6972 Walmart Inc #10-0316 AL Pharmacy 2565383811 973 Gilbert Ferry Rd Se, Attalla, AL 35954-3339 Attalla Etowah 35954-3339 
{
    "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:25PM, 2:15PM - 7:00 PM Sat, 10:00 AM - 1:25PM, 2:15PM - 6:00 PM Sun"
}
 https://www.walmart.com/store/316 
[
    "Moderna"
]
 
[
    "vaccinefinder:36c6ab1d-05e2-431b-aece-555e287d44a5",
    "walmart:316",
    "us_carbon_health:cbaa0385-179b-40d3-ab25-ff486369b805",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-86.09309&lat=33.99466#ldqcy ldqcy <Binary: 60 bytes> 33.99466 -86.09309
37423 American Family Care - Gadsden AL Pharmacy (256) 485-0982 366 East Meighan Blvd, Gadsden, AL 35903-1049 Gadsden Etowah 35903-1049 
{
    "unstructured": "8:00 AM - 6:00 PM"
}
   
[]
 
[
    "us_carbon_health:39d54e5a-f75c-4b80-8d9e-a0f87194ec54"
]
   https://www.vaccinatethestates.com/?lng=-85.98692&lat=34.01025#lrbwt lrbwt <Binary: 60 bytes> 34.01025 -85.98692
41042 Etowah County Health Department AL Hospital / Clinic   709 East Broad St. Gadsden, AL 35903 Gadsden Etowah 35903 
{
    "unstructured": ""
}
 https://al-telegov.egov.com/alabamavaccine/CustomerCreateAppointments/SelectLocation?appointmentTypeid=1 
[]
 
[]
 2021-04-29T02:43:23.933629+00:00 https://www.vaccinatethestates.com/?lng=-85.98560&lat=34.00312#lrzdr lrzdr <Binary: 60 bytes> 34.00312 -85.9856
41917 Jerry'S Discount Pharmacy AL Unknown   300 Wall St, Gadsden, Alabama, 35904 Gadsden, AL 35904 Gadsden Etowah 35904 
{
    "unstructured": null
}
   
[
    "Moderna"
]
 
[
    "al_arcgis:22592"
]
   https://www.vaccinatethestates.com/?lng=-86.04592&lat=34.01850#ltdym ltdym <Binary: 60 bytes> 34.0185 -86.04592
42036 Gadsden Regional Medical Ctr AL Unknown   1007 Goodyear Ave, Gadsden, Alabama, 35903 Gadsden, AL 35903 Gadsden Etowah 35903 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22551"
]
   https://www.vaccinatethestates.com/?lng=-85.96782&lat=34.00934#ltfkd ltfkd <Binary: 60 bytes> 34.00934 -85.96782
42640 Riverview Reg Medical Ctr AL Unknown   600 S 3rd St, Gadsden, Alabama, 35901 Gadsden, AL 35901 Gadsden Etowah 35901 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21896"
]
   https://www.vaccinatethestates.com/?lng=-86.00407&lat=34.00341#lthwy lthwy <Binary: 60 bytes> 34.00341 -86.00407
42749 Hugh'S Pharmacy, Inc. AL Unknown   100 Medical Center Dr, Gadsden, Alabama, 35903 Gadsden, AL 35903 Gadsden Etowah 35903 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22171"
]
   https://www.vaccinatethestates.com/?lng=-85.96666&lat=34.00873#ltkfw ltkfw <Binary: 60 bytes> 34.00873 -85.96666
42908 Gadsden City Pharmacy AL Unknown   911 Rainbow Dr, Gadsden, Alabama, 35901 Gadsden, AL 35901 Gadsden Etowah 35901 
{
    "unstructured": null
}
   
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "al_arcgis:21736"
]
   https://www.vaccinatethestates.com/?lng=-86.00449&lat=33.99922#ltkyb ltkyb <Binary: 60 bytes> 33.99922 -86.00449
53075 ALACO DISCOUNT PHARMACY #7 AL Unknown (256) 492-4900 544 W MAIN ST GLENCOE, AL 35905 GLENCOE Etowah 35905 
{
    "unstructured": null
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder_org:094c76f5-a6aa-48f5-b322-6ae6f4142764"
]
   https://www.vaccinatethestates.com/?lng=-85.94162&lat=33.96418#lybfr lybfr <Binary: 60 bytes> 33.96418 -85.94162
54305 Ricks Discount Health Mart Pharmacy AL Unknown   1433 Third Street SW Attalla, AL 35954 Attalla Etowah 35954 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141707930"
]
   https://www.vaccinatethestates.com/?lng=-86.11207&lat=34.00553#lyhch lyhch <Binary: 60 bytes> 34.00553 -86.11207
54738 Etowah Center For Internal Medicine AL Unknown   207 E Grand Ave, Rainbow City, Alabama, 35906 Rainbow City, AL 35906 Rainbow City Etowah 35906 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21705"
]
   https://www.vaccinatethestates.com/?lng=-86.03782&lat=33.95270#lykwr lykwr <Binary: 60 bytes> 33.9527 -86.03782
54777 Hokes Bluff Shoppe AL Unknown   5702 US HWY 278 Hokes Bluff, AL 35903 Hokes Bluff Etowah 35903 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141557379"
]
   https://www.vaccinatethestates.com/?lng=-85.86492&lat=33.98544#lykzc lykzc <Binary: 60 bytes> 33.98544 -85.86492
54814 CVS Pharmacy in ATTALLA, AL AL Unknown   315 THIRD STREET NW ATTALLA, AL 35954 ATTALLA Etowah 35954 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[
    "Johnson & Johnson"
]
 
[
    "vaccinespotter_org:270191677",
    "us_carbon_health:26116ad6-1e31-440e-bd92-b3f6282e9d4f"
]
   https://www.vaccinatethestates.com/?lng=-86.08939&lat=34.02052#lymck lymck <Binary: 60 bytes> 34.02052 -86.08939
54821 CVS Pharmacy in RAINBOW CITY, AL AL Unknown   3403 RAINBOW DR. RAINBOW CITY, AL 35906 RAINBOW CITY Etowah 35906 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[]
 
[
    "vaccinespotter_org:270138040"
]
   https://www.vaccinatethestates.com/?lng=-86.03991&lat=33.95728#lymcx lymcx <Binary: 60 bytes> 33.95728 -86.03991
54909 CVS Pharmacy in GADSDEN, AL AL Unknown   2608 W. MEIGHAN BLVD GADSDEN, AL 35904 GADSDEN Etowah 35904 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[
    "Johnson & Johnson"
]
 
[
    "vaccinespotter_org:270297291",
    "us_carbon_health:6950b1af-b90d-4b4c-9948-150074dde7a1"
]
   https://www.vaccinatethestates.com/?lng=-86.04499&lat=34.02239#lymmm lymmm <Binary: 60 bytes> 34.02239 -86.04499
55137 Gadsden City High School AL Unknown   1917 Black Creek Pkwy Gadsden, AL 35904 Gadsden Etowah 35904 
{
    "unstructured": null
}
   
[]
 
[
    "us_giscorps_vaccine_providers:cae82208-37f5-41de-b14f-6bd6bd45e2b5"
]
   https://www.vaccinatethestates.com/?lng=-86.03806&lat=33.99375#lyphz lyphz <Binary: 60 bytes> 33.99375 -86.03806
56010 CORNERSTONE FAMILY PHARMACY AL Unknown (256) 456-5850 851 GOODYEAR AVE GADSDEN, AL 35903 GADSDEN Etowah 35903 
{
    "unstructured": null
}
 http://www.cornerstonefamilypharmacy.com 
[]
 
[
    "vaccinefinder_org:7fe8b092-e3c7-42aa-a73d-1a19be09ca71"
]
   https://www.vaccinatethestates.com/?lng=-85.96604&lat=34.00758#lytxm lytxm <Binary: 60 bytes> 34.00758 -85.96604
56304 Midtown Pharmacy LLC AL Unknown   278 NORTH THIRD ST GADSDEN, AL 35901 GADSDEN Etowah 35901 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141707942"
]
   https://www.vaccinatethestates.com/?lng=-85.99975&lat=34.01562#lyxbh lyxbh <Binary: 60 bytes> 34.01562 -85.99975

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;