locations_expanded (view)

Data source: Vaccinate The States

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, hours, website, vaccines_offered, 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
12175 Lee and Pickels Drugstore #1161518 GA Pharmacy 229-263-4061 302 East Screven Street, Quitman, GA 31643 Quitman Brooks 31643 
{
    "unstructured": ""
}
   
[
    "Moderna"
]
 
[
    "vaccinefinder:451e7e5f-f1f2-455f-9233-510e14dea240",
    "vaccinefinder_org:451e7e5f-f1f2-455f-9233-510e14dea240"
]
   https://www.vaccinatethestates.com/?lng=-83.55794&lat=30.78514#lfxpq lfxpq <Binary: 60 bytes> 30.78514 -83.55794
51804 Primary Care of Southwest Georgia Quitman GA Unknown 229-263-4531 907 North Court Street Quitman, GA 31643 Quitman Brooks 31643 
{
    "unstructured": null
}
 http://nowebsite.nothing.com 
[
    "Moderna"
]
 
[
    "vaccinefinder_org:4b02aae6-74b0-486d-8882-9544df3ffdf4"
]
   https://www.vaccinatethestates.com/?lng=-83.55901&lat=30.79544#lxtfc lxtfc <Binary: 60 bytes> 30.79544 -83.55901
51938 BROOKS COUNTY HEALTH DEPARTMENT GA Unknown 229-263-7585 500 E Courtland Ave Quitman, GA 31643 Quitman Brooks 31643 
{
    "unstructured": null
}
 http://nowebsite.nothing.com 
[
    "Moderna",
    "Johnson & Johnson"
]
 
[
    "vaccinefinder_org:b271d093-efd7-4a64-b442-836433a54bb0"
]
   https://www.vaccinatethestates.com/?lng=-83.55502&lat=30.79811#lxttq lxttq <Binary: 60 bytes> 30.79811 -83.55502

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;