locations_expanded (view)

Data source: Vaccinate The States

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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: zip_code, hours, 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
12150 Wayne Drug Company #1111044 GA Pharmacy (912) 427-4288 192 North First Street, Jesup, GA 31545 Jesup Wayne 31545 
{
    "unstructured": "8:00 AM - 7:00 PM Mon-Fri, 9:00 AM - 6:00 PM Sat, Closed Sun"
}
   
[]
 
[
    "vaccinefinder:55547530-62e9-40a3-8169-1e018cdb5406",
    "vaccinefinder_org:55547530-62e9-40a3-8169-1e018cdb5406"
]
   https://www.vaccinatethestates.com/?lng=-81.88413&lat=31.60784#lfxmb lfxmb <Binary: 60 bytes> 31.60784 -81.88413
29852 Walgreens Co. #11792 GA Pharmacy 912-588-1035 102 S 1St St, Jesup, GA 31545-1171 Jesup Wayne 31545-1171 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:11792",
    "vaccinefinder:bfb4a009-fcc5-4b11-bccc-27216dc4c8a9",
    "vaccinefinder_org:bfb4a009-fcc5-4b11-bccc-27216dc4c8a9",
    "_tag_provider:walgreens",
    "us_carbon_health:7f0a2c18-946b-4a99-a4ac-76c45a9f82d4"
]
   https://www.vaccinatethestates.com/?lng=-81.88607&lat=31.60714#lpdym lpdym <Binary: 60 bytes> 31.60714 -81.88607
34114 Walmart Inc #10-2630 GA Pharmacy 9125306335 1100 N 1St St, Jesup, GA 31545-0046 Jesup Wayne 31545-0046 
{
    "unstructured": "9:00 AM - 7:00 PM Mon, 6:00 AM - 7:00 PM Tue, 9:00 AM - 7:00 PM Wed, 9:00 AM - 7:00 PM Thrus, 9:00 AM - 7:00 PM Fri, 9:00 AM - 1:30PM, 2:00 PM - 7:00 PM Sat, 10:00 AM - 1:30PM, 2:00 PM - 6:00 PM Sun"
}
 https://www.walmart.com/store/2630 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:f792e832-8c48-426d-95f4-0aa71e3f5107",
    "walmart:2630",
    "us_carbon_health:124d667f-70e7-4234-afd9-4c98d638399f",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-81.87178&lat=31.61575#lqfpz lqfpz <Binary: 60 bytes> 31.61575 -81.87178
51384 CVS Pharmacy GA Unknown   348 West Pine Street Jesup, GA 31545 Jesup Wayne 31545 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "us_giscorps_vaccine_providers:b4ab4bb4-cce0-414d-8607-6d5fea624849",
    "vaccinespotter_org:270396476"
]
   https://www.vaccinatethestates.com/?lng=-81.88317&lat=31.60997#lxqpm lxqpm <Binary: 60 bytes> 31.60997 -81.88317
51792 Diversity Health Center, Inc. GA Unknown (912) 385-2453 244 Peachtree Street Jesup, GA 31545 Jesup Wayne 31545 
{
    "unstructured": null
}
 https://dph.georgia.gov/locations/diversity-health-center-wayne 
[]
 
[
    "us_giscorps_vaccine_providers:f8d93abf-0ef2-43af-add8-802cfdcf83eb"
]
   https://www.vaccinatethestates.com/?lng=-81.89892&lat=31.60010#lxtdh lxtdh <Binary: 60 bytes> 31.6001 -81.89892

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;