locations_expanded (view)

Data source: Vaccinate The States

8 rows where county = "Union" and state = "GA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, hours, 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
12169 Brasstown Professional RX, Inc. #1150034 GA Pharmacy (706) 745-2303 23B Murphy Highway, Blairsville, GA 30512 Blairsville Union 30512 
{
    "unstructured": "9:00 AM - 6:00 PM Mon-Fri, 9:00 AM - 2:00 PM Sat, Closed Sun"
}
 https://www.brasstown.biz 
[]
 
[
    "vaccinefinder:1affdc50-039a-4a28-8c75-7fb1349d26d3",
    "vaccinefinder_org:1affdc50-039a-4a28-8c75-7fb1349d26d3"
]
   https://www.vaccinatethestates.com/?lng=-83.96413&lat=34.87124#lfxpf lfxpf <Binary: 60 bytes> 34.87124 -83.96413
24699 Ingles Pharmacy #098 #444425 GA Pharmacy 706-745-1700 207 B Hwy 515, Ingles Pharmacy #098, Blairsville, GA 30512 Blairsville Union 30512 
{
    "unstructured": "9:00 AM - 9:00 PM Mon-Fri, 9:00 AM - 6:00 PM Sat-Sun"
}
 http://www.ingles-markets.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:ab8e2cc3-523c-4624-a1fd-2f183bd452df",
    "vaccinefinder_org:ab8e2cc3-523c-4624-a1fd-2f183bd452df",
    "ingles:444425",
    "us_carbon_health:17c8a5f0-0c89-4a16-8220-0a39da9801c1",
    "_tag_provider:ingles"
]
   https://www.vaccinatethestates.com/?lng=-83.95778&lat=34.88216#lkyty lkyty <Binary: 60 bytes> 34.88216 -83.95778
31133 Walgreens Co. #17943 GA Pharmacy 706-745-6954 363 Blue Ridge Street, Blairsville, GA 30512-3574 Blairsville Union 30512-3574 
{
    "unstructured": "07:00AM - 10:00PM Mon-Fri, 07:00AM - 10:00PM Sat, 08:00AM - 10:00PM Sun"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:17943",
    "vaccinefinder:ff0d1060-5c98-4922-92ab-f6d6b769f3eb",
    "vaccinefinder_org:ff0d1060-5c98-4922-92ab-f6d6b769f3eb",
    "us_carbon_health:eea309f7-6b4c-4e12-89b5-7b6639a9018a",
    "_tag_provider:walgreens"
]
   https://www.vaccinatethestates.com/?lng=-83.96262&lat=34.87121#lpmyp lpmyp <Binary: 60 bytes> 34.87121 -83.96262
38474 King's Hometown Pharmacy #1172636 GA Pharmacy (706) 400-5043 178 Bracketts Way Suite 7, Blairsville, GA 30512 Blairsville Union 30512 
{
    "unstructured": "8:30 AM - 6:00 PM Mon-Fri, 9:00 AM - 12:00 PM Sat, Closed Sun"
}
 http://kingsrxandwellness.com 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:5ac091cd-8210-463c-933a-c133d3c30071"
]
   https://www.vaccinatethestates.com/?lng=-83.96852&lat=34.87120#lrgzb lrgzb <Binary: 60 bytes> 34.8712 -83.96852
51292 Blairsville Supercenter GA Unknown   2257 Hwy 515 Blairsville, GA 30512 Blairsville Union 30512 
{
    "unstructured": null
}
 https://www.walmart.com/pharmacy/clinical-services/immunization/scheduled?imzType=covid 
[]
 
[
    "vaccinespotter_org:776981"
]
   https://www.vaccinatethestates.com/?lng=-83.99801&lat=34.86392#lxqdr lxqdr <Binary: 60 bytes> 34.86392 -83.99801
51356 CVS Pharmacy GA Unknown (706) 745-9601 208 Highway 515 East Blairsville, GA 30512 Blairsville Union 30512 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "us_giscorps_vaccine_providers:dc7a4ac1-e942-413b-a423-cdaa582e9880"
]
 2021-05-14T17:24:41.437160+00:00 https://www.vaccinatethestates.com/?lng=-83.95598&lat=34.87923#lxqkt lxqkt <Binary: 60 bytes> 34.87923 -83.95598
51603 CVS Pharmacy in BLAIRSVILLE, GA GA Unknown   208 HWY 515 E BLAIRSVILLE, GA 30512 BLAIRSVILLE Union 30512 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[]
 
[
    "vaccinespotter_org:270425055"
]
   https://www.vaccinatethestates.com/?lng=-83.88761&lat=34.90713#lxrkh lxrkh <Binary: 60 bytes> 34.90713 -83.88761
52128 Union County Health Department GA Unknown (888) 426-5073 67 Chase Drive ~ Blairsville Blairsville, GA 30512 Blairsville Union 30512 
{
    "unstructured": null
}
 https://dph.georgia.gov/locations/union-county-health-department-covid-vaccine 
[
    "Pfizer",
    "Johnson & Johnson"
]
 
[
    "us_giscorps_vaccine_providers:8ea07eed-317a-4810-b8a6-8beb94f2508b"
]
   https://www.vaccinatethestates.com/?lng=-83.94805&lat=34.87732#lxwmr lxwmr <Binary: 60 bytes> 34.87732 -83.94805

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;