locations_expanded (view)

Data source: Vaccinate The States

6 rows where county = "Conecuh" and state = "AL"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, zip_code, hours, vaccines_offered, concordances, 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
6285 Liberty Hills Shopping Center AL Super Site   78 Liberty Hill Place, Evergreen, AL 36401   Conecuh   
{
    "unstructured": null
}
 https://www.alabamapublichealth.gov/covid19vaccine/ng-clinics.html 
[]
 
[]
   https://www.vaccinatethestates.com/?lng=-86.96233&lat=31.45743#ldkfc ldkfc <Binary: 60 bytes> 31.45743 -86.96233
6407 Pharmacare Evergreen AL Pharmacy   451 W Front St, Evergreen, AL 36401 Evergreen Conecuh 36401 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:5eb3c412-b7b8-441c-9cf1-1074e3d913b6",
    "vaccinefinder_org:5eb3c412-b7b8-441c-9cf1-1074e3d913b6",
    "us_carbon_health:8a70f4c0-627c-4837-8431-d0d0a97019f9"
]
   https://www.vaccinatethestates.com/?lng=-86.96060&lat=31.42924#ldkxq ldkxq <Binary: 60 bytes> 31.42924 -86.9606
6611 CVS Pharmacy, Inc. #04847 AL Pharmacy (251) 578-1811 210 W Front St, Evergreen, AL 36401 Evergreen Conecuh 36401 
{
    "unstructured": "08:00AM-08:00PM Mon-Fri, 09:00AM-08:00PM Sat, 10:00AM-06:00PM Sun"
}
 https://www.cvs.com/store-locator/details-directions/004847 
[
    "Pfizer"
]
 
[
    "cvs:04847",
    "vaccinefinder:0a829037-3ad0-445f-a141-705fb3db8752",
    "vaccinespotter_org:270204931",
    "us_giscorps_vaccine_providers:eaca3b32-5f2f-43e1-bbd3-d97ac8d1c90b",
    "us_carbon_health:8484cf4f-20cc-4d6c-bec5-df18f9cf3f3e"
]
   https://www.vaccinatethestates.com/?lng=-86.95734&lat=31.43246#ldmry ldmry <Binary: 60 bytes> 31.43246 -86.95734
41038 Conecuh County Health Department AL Hospital / Clinic   102 Wild Avenue Evergreen, AL 36401 Evergreen Conecuh 2640 
{
    "unstructured": ""
}
 https://al-telegov.egov.com/alabamavaccine/CustomerCreateAppointments/SelectLocation?appointmentTypeid=1 
[]
 
[]
 2021-05-04T03:07:06.000067+00:00 https://www.vaccinatethestates.com/?lng=-86.96838&lat=31.42981#lrzdk lrzdk <Binary: 60 bytes> 31.42981 -86.96838
41629 Evergreen Medical Center AL Unknown   101 Crestview Ave, Evergreen, Alabama, 36401 Evergreen, AL 36401 Evergreen Conecuh 36401 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:21709",
    "al_arcgis:22523"
]
   https://www.vaccinatethestates.com/?lng=-86.94127&lat=31.43106#ltcwb ltcwb <Binary: 60 bytes> 31.43106 -86.94127
42882 Roberts Clinic AL Unknown   106 Edwina St, Evergreen, Alabama, 36401 Evergreen, AL 36401 Evergreen Conecuh 36401 
{
    "unstructured": null
}
   
[]
 
[
    "al_arcgis:22705"
]
   https://www.vaccinatethestates.com/?lng=-86.94195&lat=31.43112#ltkwh ltkwh <Binary: 60 bytes> 31.43112 -86.94195

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;