locations_expanded (view)

Data source: Vaccinate The States

8 rows where county = "Effingham" and state = "GA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: location_type, city, zip_code, 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
14387 Kroger Pharmacy #01100625 GA Pharmacy (912) 826-7665 461 S Columbia Ave, Rincon, GA 31326 Rincon Effingham 31326 
{
    "unstructured": "8:00 AM - 8:00 PM Mon-Fri, 9:00 AM - 6:00 PM Sat, 11:00 AM - 6:00 PM Sun"
}
 www.krogerhealth.com 
[
    "Moderna"
]
 
[
    "vaccinefinder:5a8b1db4-b7b3-4225-9d7d-ab15f3978ac0",
    "vaccinefinder_org:5a8b1db4-b7b3-4225-9d7d-ab15f3978ac0",
    "kroger:1100625",
    "us_giscorps_vaccine_providers:729f4660-93d5-4795-9c74-08135bd4a500",
    "vaccinespotter_org:9102996"
]
   https://www.vaccinatethestates.com/?lng=-81.23089&lat=32.27512#lgkgh lgkgh <Binary: 60 bytes> 32.27512 -81.23089
19322 Medicap Pharmacy #Ms1002211 GA Pharmacy 912-772-9100 #1 Hidden Creek Drive, Guyton, GA 31312 Guyton Effingham 31312 
{
    "unstructured": ""
}
   
[]
 
[
    "vaccinefinder:cc8b4fd2-ff8f-43e1-b6bf-a0527d366da5"
]
   https://www.vaccinatethestates.com/?lng=-81.38406&lat=32.33321#lhqrg lhqrg <Binary: 60 bytes> 32.33321 -81.38406
29427 Walgreens Co. #10799 GA Pharmacy 912-826-7350 409 S Columbia Ave, Rincon, GA 31326-9080 Rincon Effingham 31326-9080 
{
    "unstructured": "08:00AM - 10:00PM"
}
 https://www.walgreens.com 
[
    "Pfizer"
]
 
[
    "walgreens:10799",
    "vaccinefinder:a9ba7327-0887-4917-ade8-ace21074d009",
    "vaccinefinder_org:a9ba7327-0887-4917-ade8-ace21074d009",
    "_tag_provider:walgreens",
    "us_carbon_health:c380752b-251a-4eda-9395-20b11ae7d505"
]
   https://www.vaccinatethestates.com/?lng=-81.22862&lat=32.27341#lpcfy lpcfy <Binary: 60 bytes> 32.27341 -81.22862
32854 Walmart Inc #10-1011 GA Pharmacy 9128264030 434 S Columbia Ave, Rincon, GA 31326-9079 Rincon Effingham 31326-9079 
{
    "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/1011 
[
    "Johnson & Johnson"
]
 
[
    "vaccinefinder:7b487d8b-fc28-48f3-a1fd-9793ebd4111e",
    "walmart:1011",
    "us_carbon_health:fc758137-6b81-46c8-97f1-aec2c71bcbaa",
    "_tag_provider:walmart"
]
   https://www.vaccinatethestates.com/?lng=-81.22593&lat=32.27460#lpyrf lpyrf <Binary: 60 bytes> 32.2746 -81.22593
51535 CVS Pharmacy GA Unknown (912) 826-2296 410 South Columbia Avenue Rincon, GA 31326 Rincon Effingham 31326 
{
    "unstructured": null
}
 https://www.cvs.com/immunizations/covid-19-vaccine 
[
    "Johnson & Johnson"
]
 
[
    "us_giscorps_vaccine_providers:9d3c9614-aeba-482f-b809-8fa4c79534d4",
    "vaccinespotter_org:270170984"
]
   https://www.vaccinatethestates.com/?lng=-81.22813&lat=32.27704#lxrcz lxrcz <Binary: 60 bytes> 32.27704 -81.22813
51759 Quick Rx Drugs Springfield Health Mart Pharmacy GA Unknown   504 LAUREL STREET SPRINGFIELD, GA 31329 SPRINGFIELD Effingham 31329 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[
    "Moderna"
]
 
[
    "vaccinespotter_org:141553187"
]
   https://www.vaccinatethestates.com/?lng=-81.31412&lat=32.37144#lxtbf lxtbf <Binary: 60 bytes> 32.37144 -81.31412
52077 Quick Rx Drugs Rincon Health Mart Pharmacy GA Unknown   100 GOSHEN ROAD RINCON, GA 31326 RINCON Effingham 31326 
{
    "unstructured": null
}
 https://www.healthmartcovidvaccine.com/ 
[]
 
[
    "vaccinespotter_org:141553186"
]
   https://www.vaccinatethestates.com/?lng=-81.21247&lat=32.25148#lxwgm lxwgm <Binary: 60 bytes> 32.25148 -81.21247
65964 Effingham County Health Department (COVID Vaccine) GA Unknown (912) 754-6484 802 Highway 119 South Springfield, GA 31329 Springfield Effingham 31329 
{
    "unstructured": null
}
   
[]
 
[
    "us_carbon_health:7976978c-9874-41b9-95e1-89dc4d02bfb0"
]
   https://www.vaccinatethestates.com/?lng=-81.33130&lat=32.36175#lccdzk lccdzk <Binary: 60 bytes> 32.36175 -81.3313

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;