locations_expanded (view)

Data source: Vaccinate The States

3 rows where county = "Telfair" and state = "GA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, zip_code, vaccines_offered

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
13110 Ryals Drug Store GA Pharmacy 229 868-6735 12 South 2Nd Ave, Mc Rae, GA 31055 Mc Rae Telfair 31055 
{
    "unstructured": "10:00 AM - 06:00 PM Mon-Fri, 10:00 AM - 01:00 PM Sat,  Sun"
}
 https://healthmartcovidvaccine.com 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:694af5e6-0943-43d0-9ce9-c68843903408",
    "vaccinefinder_org:694af5e6-0943-43d0-9ce9-c68843903408",
    "vaccinespotter_org:141690864"
]
   https://www.vaccinatethestates.com/?lng=-82.89972&lat=32.06809#lgcfh lgcfh <Binary: 60 bytes> 32.06809 -82.89972
23699 Harvey's #1656 GA Pharmacy 229-868-6120 120 W. Oak St., Mcrae, GA 31055 Mcrae Telfair 31055 
{
    "unstructured": "8:00AM - 8:00PM Mon-Fri, 9:00AM - 5:00PM Sat, 11:00AM - 5:00PM Sun"
}
 https://www.harveyssupermarkets.com/pharmacy/covid-vaccine 
[]
 
[
    "vaccinefinder:9a0f16bb-1883-4ca3-ba88-2c703d1db744",
    "vaccinefinder_org:9a0f16bb-1883-4ca3-ba88-2c703d1db744",
    "us_carbon_health:051164ea-c4c3-4c49-acd0-aebf7ae7fb05"
]
   https://www.vaccinatethestates.com/?lng=-82.90771&lat=32.07051#lkrxb lkrxb <Binary: 60 bytes> 32.07051 -82.90771
51999 Lumber City Drugs GA Unknown   3316 E. GOLDEN ISLES HWY LUMBER CITY, GA 31549 LUMBER CITY Telfair 31549 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141553790"
]
   https://www.vaccinatethestates.com/?lng=-82.67967&lat=31.92914#lxtzm lxtzm <Binary: 60 bytes> 31.92914 -82.67967

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;