locations_expanded (view)

Data source: Vaccinate The States

14 rows where county = "Russell" and state = "AL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, zip_code, website, vaccines_offered (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
6276 Chattahoochee Valley CC AL Super Site   2602 College Drive, Phenix City, AL 36869   Russell   
{
    "unstructured": null
}
 https://www.alabamapublichealth.gov/covid19vaccine/ng-clinics.html 
[]
 
[]
   https://www.vaccinatethestates.com/?lng=-85.03141&lat=32.42393#ldkdp ldkdp <Binary: 60 bytes> 32.42393 -85.03141
6545 Phenix City Childrens & Family Clinic AL Pharmacy (334) 664-0463 3700 S Railroad St Ste A, Phenix City, AL 36867-2994 Phenix City Russell 36867-2994 
{
    "unstructured": "8:00 AM - 5:00 PM Mon, 8:00 AM - 5:00 PM Tue, 8:00 AM - 5:00 PM Wed, 8:00 AM - 7:00 PM Thrus, 8:00 AM - 4:00 PM Fri, 9:00 AM - 1:00 PM Sat, Closed Sun"
}
 https://preferredmedgroup.com/ 
[
    "Moderna"
]
 
[
    "vaccinefinder:e3eec552-ccff-4f68-a156-b674ae22d41e",
    "us_carbon_health:e05a84d9-cc73-47ca-abed-70fb67a57691"
]
   https://www.vaccinatethestates.com/?lng=-85.04144&lat=32.49805#ldmkr ldmkr <Binary: 60 bytes> 32.49805 -85.04144
6546 Fort Mitchell Clinic Pc AL Pharmacy (334) 664-0463 2 Gilmore Rd, Fort Mitchell, AL 36856 Fort Mitchell Russell 36856 
{
    "unstructured": "8:00 AM - 5:00 PM Mon, 8:00 AM - 5:00 PM Tue, 8:00 AM - 5:00 PM Wed, 8:00 AM - 5:00 PM Thrus, 8:00 AM - 4:00 PM Fri, Closed Sat, Closed Sun"
}
 https://preferredmedgroup.com/ 
[
    "Moderna"
]
 
[
    "vaccinefinder:89cf6a9b-075e-4a02-b126-dca3127001ad",
    "vaccinefinder_org:89cf6a9b-075e-4a02-b126-dca3127001ad",
    "us_carbon_health:c1faaf84-87c5-46eb-a2ec-715948f7083d"
]
   https://www.vaccinatethestates.com/?lng=-85.01435&lat=32.31492#ldmkt ldmkt <Binary: 60 bytes> 32.31492 -85.01435
6634 CVS Pharmacy, Inc. #04934 AL Pharmacy (334) 297-6498 1430 Hwy 280 & 431 N, Phenix City, AL 36867 Phenix City Russell 36867 
{
    "unstructured": "08:00AM-10:00PM Mon-Fri, 09:00AM-07:00PM Sat-Sun"
}
 https://www.cvs.com/store-locator/details-directions/004934 
[
    "Pfizer"
]
 
[
    "cvs:04934",
    "vaccinefinder:b763d862-3536-4c38-812a-ee0ae9ff7015"
]
   https://www.vaccinatethestates.com/?lng=-85.02905&lat=32.47612#ldmwh ldmwh <Binary: 60 bytes> 32.47612 -85.02905
6742 Publix Super Markets Inc. #1086 AL Pharmacy (334) 291-8533 5408 Summerville Road Ste 200, Phenix City, AL 36867 Phenix City Russell 36867 
{
    "unstructured": ""
}
 https://www.publix.com/pharmacy/pharmacy-services/vaccinations 
[]
 
[
    "vaccinefinder:48a806b8-2f69-41a3-a440-456dd04922b7",
    "vaccinefinder_org:48a806b8-2f69-41a3-a440-456dd04922b7",
    "publix:1086",
    "vaccinespotter_org:206729556",
    "_tag_provider:publix",
    "us_carbon_health:df2dcfb4-6df2-4afd-b3ae-83af2f28a46e"
]
   https://www.vaccinatethestates.com/?lng=-85.02846&lat=32.52138#ldpfp ldpfp <Binary: 60 bytes> 32.52138 -85.02846
6852 Walgreens Co. #6483 AL Pharmacy 334-297-3722 2515 Crawford Rd, Phenix City, AL 36867-3629 Phenix City Russell 36867-3629 
{
    "unstructured": "07:00AM - 11:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:6483",
    "vaccinefinder:c1c5fc0c-3a5c-4b2f-a252-9b1b217e0222",
    "vaccinefinder_org:c1c5fc0c-3a5c-4b2f-a252-9b1b217e0222"
]
   https://www.vaccinatethestates.com/?lng=-85.02915&lat=32.47448#ldprk ldprk <Binary: 60 bytes> 32.47448 -85.02915
7030 Walmart Inc #10-1284 AL Pharmacy 3342911700 3700 Us Highway 431 N, Phenix City, AL 36867-2362 Phenix City Russell 36867-2362 
{
    "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:20PM, 2:10PM - 7:00 PM Sat, 10:00 AM - 1:20PM, 2:10PM - 6:00 PM Sun"
}
 https://www.walmart.com/store/1284 
[
    "Moderna"
]
 
[
    "vaccinefinder:f68814a4-b92c-42d5-b289-03242dd7027b",
    "us_carbon_health:fd050785-fb03-40b6-b56d-87cbb7a6f608",
    "walmart:1284",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-85.04341&lat=32.50132#ldqhp ldqhp <Binary: 60 bytes> 32.50132 -85.04341
41811 Jacksons Point Of Light Family Medicine AL Unknown   1810 Stadium Dr, Phenix City, Alabama, 36867 Phenix City, AL 36867 Phenix City Russell 36867 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22184",
    "al_arcgis:22591"
]
   https://www.vaccinatethestates.com/?lng=-85.01840&lat=32.49621#ltdmq ltdmq <Binary: 60 bytes> 32.49621 -85.0184
42009 Rehabilitation Hospital Of Phenix City Llc AL Unknown   3715 Highway 280 431 N, Phenix City, Alabama, 36867 Phenix City, AL 36870 Phenix City Russell 36870 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22702"
]
   https://www.vaccinatethestates.com/?lng=-85.04529&lat=32.49902#ltfgk ltfgk <Binary: 60 bytes> 32.49902 -85.04529
43054 Russell County Health Department AL Unknown   1850 Crawford Rd, Phenix City, Alabama, 36867 Phenix City, AL 36867 Phenix City Russell 36867 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21488"
]
   https://www.vaccinatethestates.com/?lng=-85.01938&lat=32.47375#ltmmk ltmmk <Binary: 60 bytes> 32.47375 -85.01938
54763 Jack Hughston Memorial Hospital AL Unknown   4401 Riverchase Dr, Phenix City, Alabama, 36867 Phenix City, AL 36867 Phenix City Russell 36867 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21773"
]
   https://www.vaccinatethestates.com/?lng=-85.00577&lat=32.50910#lykyf lykyf <Binary: 60 bytes> 32.5091 -85.00577
55039 CVS Pharmacy in PHENIX CITY, AL AL Unknown   2514 CRAWFORD ROAD PHENIX CITY, AL 36867 PHENIX CITY Russell 36867 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[]
 
[
    "vaccinespotter_org:270327314"
]
   https://www.vaccinatethestates.com/?lng=-85.02698&lat=32.47520#lymzw lymzw <Binary: 60 bytes> 32.4752 -85.02698
55117 JONES DRUGS 006 AL Unknown (334) 500-4695 3482 CROSSWIND DR PHENIX CITY, AL 36869 PHENIX CITY Russell 36869 
{
    "unstructured": null
}
 http://www.jonesdrugs.com 
[]
 
[
    "vaccinefinder_org:ee970f6a-4e5d-45bb-80b9-69efa7edee5a"
]
   https://www.vaccinatethestates.com/?lng=-85.04815&lat=32.43655#lypgt lypgt <Binary: 60 bytes> 32.43655 -85.04815
59830 U SAVE IT #18 AL Unknown   1108 13TH STREET PHENIX CITY, AL 36867 PHENIX CITY Russell 36867 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141692508"
]
   https://www.vaccinatethestates.com/?lng=-85.00856&lat=32.47244#lzryz lzryz <Binary: 60 bytes> 32.47244 -85.00856

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;