locations_expanded (view)

Data source: Vaccinate The States

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: city, 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
12163 Blackshear Drug Co #1132389 GA Pharmacy 912-449-6616 3487 Us Highway 84, Blackshear, GA 31516 Blackshear Pierce 31516 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:43af6426-db1e-4d03-b7d0-7cc097d881dc",
    "vaccinefinder_org:43af6426-db1e-4d03-b7d0-7cc097d881dc"
]
   https://www.vaccinatethestates.com/?lng=-82.24416&lat=31.30394#lfxmx lfxmx <Binary: 60 bytes> 31.30394 -82.24416
19386 Patterson Pharmacare #Ms1002561 GA Pharmacy (912) 647-0777 6460 Highway 84, Patterson, GA 31557 Patterson Pierce 31557 
{
    "unstructured": "9:00 AM - 6:00 PM Mon-Fri, 9:00 AM - 12:00 PM Sat, Closed Sun"
}
   
[]
 
[
    "vaccinefinder:7d05c294-9dcf-44e3-a38c-b8fdd2a0e145",
    "vaccinefinder_org:7d05c294-9dcf-44e3-a38c-b8fdd2a0e145"
]
   https://www.vaccinatethestates.com/?lng=-82.14142&lat=31.38705#lhqyh lhqyh <Binary: 60 bytes> 31.38705 -82.14142
31086 Walgreens Co. #17795 GA Pharmacy 912-449-0811 3537 Us Highway 84, Blackshear, GA 31516-2237 Blackshear Pierce 31516-2237 
{
    "unstructured": "08:00AM - 10:00PM Mon-Fri, 08:00AM - 10:00PM Sat, 08:00AM - 9:00PM Sun"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:17795",
    "vaccinefinder:0e1ccbdb-bc4c-434d-b9e9-09fce59132fd",
    "vaccinefinder_org:0e1ccbdb-bc4c-434d-b9e9-09fce59132fd",
    "_tag_provider:walgreens",
    "us_carbon_health:895b3bbd-a56c-4575-bf6b-7c3a0fd8fb9e"
]
   https://www.vaccinatethestates.com/?lng=-82.24255&lat=31.30538#lpmtq lpmtq <Binary: 60 bytes> 31.30538 -82.24255

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;