locations_expanded (view)

Data source: Vaccinate The States

5 rows where county = "Tattnall" and state = "GA"

✎ View and edit SQL

This data as json, CSV (advanced)

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
18967 Central Pharmacy #Ms1000503 GA Pharmacy (912) 654-3031 703 N Veterans Blvd, Glennville, GA 30427 Glennville Tattnall 30427 
{
    "unstructured": "8:30 AM - 6:30 PM Mon-Fri, 8:00 AM - 2:00 PM Sat,  Sun"
}
   
[]
 
[
    "vaccinefinder:a61c98e0-2678-49ff-a35b-cb242ecaef28",
    "vaccinefinder_org:a61c98e0-2678-49ff-a35b-cb242ecaef28"
]
   https://www.vaccinatethestates.com/?lng=-81.92591&lat=31.94396#lhpfq lhpfq <Binary: 60 bytes> 31.94396 -81.92591
31204 Walgreens Co. #18185 GA Pharmacy 912-654-9647 402 S Veterans Blvd, Glennville, GA 30427-1772 Glennville Tattnall 30427-1772 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:18185",
    "vaccinefinder:c7bcdcc3-6b06-40ab-b8ce-b46fcc90b01d",
    "vaccinefinder_org:c7bcdcc3-6b06-40ab-b8ce-b46fcc90b01d",
    "_tag_provider:walgreens",
    "us_carbon_health:ff3de6e9-579b-40a9-abe0-689e7c464db1"
]
   https://www.vaccinatethestates.com/?lng=-81.93088&lat=31.93229#lppdz lppdz <Binary: 60 bytes> 31.93229 -81.93088
51360 CVS Pharmacy in CLAYTON, GA GA Unknown   308 SOUTH US HIGHWAY 441 CLAYTON, GA 30525 CLAYTON Tattnall 30525 
{
    "unstructured": null
}
 https://www.cvs.com/vaccine/intake/store/cvd-schedule 
[]
 
[
    "vaccinespotter_org:270204950"
]
   https://www.vaccinatethestates.com/?lng=-81.92907&lat=31.93945#lxqkz lxqkz <Binary: 60 bytes> 31.93945 -81.92907
52055 Strickland's Pharmacy GA Unknown   111 E Barnard Street Glennville, GA 30427 Glennville Tattnall 30427 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141690810",
    "us_carbon_health:ae4cb66e-29bb-463c-b589-7bb3bf8536d4"
]
   https://www.vaccinatethestates.com/?lng=-81.92708&lat=31.93600#lxwfc lxwfc <Binary: 60 bytes> 31.936 -81.92708
52126 East Georgia Healthcare Center, Inc. - Reidsville Clinic GA Unknown (912) 557-3300 117 Memorial Drive Reidsville, GA 30453 Reidsville Tattnall 30453 
{
    "unstructured": null
}
 https://dph.georgia.gov/locations/east-georgia-healthcare-center 
[]
 
[
    "us_giscorps_vaccine_providers:6117b66f-fe7b-4556-97f4-5b3beb8f00d2",
    "us_carbon_health:56aefcd4-27ed-4dc9-9de7-af6fe7205de5"
]
   https://www.vaccinatethestates.com/?lng=-82.10991&lat=32.08128#lxwmp lxwmp <Binary: 60 bytes> 32.08128 -82.10991

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;