Avatar of the person chatting

Take the following data set which includes 100 banks that have failed since 2000, organize them in categories by region, only displaying the three most recent bank failures from each respective region: Signature Bank New York NY 57053 Flagstar Bank, N.A. March 12, 2023 10540 Silicon Valley Bank Santa Clara CA 24735 First–Citizens Bank & Trust Company March 10, 2023 10539 Almena State Bank Almena KS 15426 Equity Bank October 23, 2020 10538 First City Bank of Florida Fort Walton Beach FL 16748 United Fidelity Bank, fsb October 16, 2020 10537 The First State Bank Barboursville WV 14361 MVB Bank, Inc. April 3, 2020 10536 Ericson State Bank Ericson NE 18265 Farmers and Merchants Bank February 14, 2020 10535 City National Bank of New Jersey Newark NJ 21111 Industrial Bank November 1, 2019 10534 Resolute Bank Maumee OH 58317 Buckeye State Bank October 25, 2019 10533 Louisa Community Bank Louisa KY 58112 Kentucky Farmers Bank Corporation October 25, 2019 10532 The Enloe State Bank Cooper TX 10716 Legend Bank, N. A. May 31, 2019 10531 Washington Federal Bank for Savings Chicago IL 30570 Royal Savings Bank December 15, 2017 10530 The Farmers and Merchants State Bank of Argonia Argonia KS 17719 Conway Bank October 13, 2017 10529 Fayette County Bank Saint Elmo IL 1802 United Fidelity Bank, fsb May 26, 2017 10528 Guaranty Bank, (d/b/a BestBank in Georgia & Michigan) Milwaukee WI 30003 First-Citizens Bank & Trust Company May 5, 2017 10527 First NBC Bank New Orleans LA 58302 Whitney Bank April 28, 2017 10526 Proficio Bank Cottonwood Heights UT 35495 Cache Valley Bank March 3, 2017 10525 Seaway Bank and Trust Company Chicago IL 19328 State Bank of Texas January 27, 2017 10524 Harvest Community Bank Pennsville NJ 34951 First-Citizens Bank & Trust Company January 13, 2017 10523 Allied Bank Mulberry AR 91 Today's Bank September 23, 2016 10522 The Woodbury Banking Company Woodbury GA 11297 United Bank August 19, 2016 10521 First CornerStone Bank King of Prussia PA 35312 First-Citizens Bank & Trust Company May 6, 2016 10520 Trust Company Bank Memphis TN 9956 The Bank of Fayette County April 29, 2016 10519 North Milwaukee State Bank Milwaukee WI 20364 First-Citizens Bank & Trust Company March 11, 2016 10518 Hometown National Bank Longview WA 35156 Twin City Bank October 2, 2015 10517 The Bank of Georgia Peachtree City GA 35259 Fidelity Bank October 2, 2015 10516 Premier Bank Denver CO 34112 United Fidelity Bank, fsb July 10, 2015 10515 Edgebrook Bank Chicago IL 57772 Republic Bank of Chicago May 8, 2015 10514 Doral Bank En Español San Juan PR 32102 Banco Popular de Puerto Rico February 27, 2015 10513 Capitol City Bank & Trust Company Atlanta GA 33938 First-Citizens Bank & Trust Company February 13, 2015 10512 Highland Community Bank Chicago IL 20290 United Fidelity Bank, fsb January 23, 2015 10511 First National Bank of Crestview Crestview FL 17557 First NBC Bank January 16, 2015 10510 Northern Star Bank Mankato MN 34983 BankVista December 19, 2014 10509 Frontier Bank, FSB D/B/A El Paseo Bank Palm Desert CA 34738 Bank of Southern California, N.A. November 7, 2014 10508 The National Republic Bank of Chicago Chicago IL 916 State Bank of Texas October 24, 2014 10507 NBRS Financial Rising Sun MD 4862 Howard Bank October 17, 2014 10506 GreenChoice Bank, fsb Chicago IL 28462 Providence Bank, LLC July 25, 2014 10505 Eastside Commercial Bank Conyers GA 58125 Community & Southern Bank July 18, 2014 10504 The Freedom State Bank Freedom OK 12483 Alva State Bank & Trust Company June 27, 2014 10503 Valley Bank Fort Lauderdale FL 21793 Landmark Bank, National Association June 20, 2014 10501 Valley Bank Moline IL 10450 Great Southern Bank June 20, 2014 10502 Slavie Federal Savings Bank Bel Air MD 32368 Bay Bank, FSB May 30, 2014 10500 Columbia Savings Bank Cincinnati OH 32284 United Fidelity Bank, fsb May 23, 2014 10499 AztecAmerica Bank En Español Berwyn IL 57866 Republic Bank of Chicago May 16, 2014 10498 Allendale County Bank Fairfax SC 15062 Palmetto State Bank April 25, 2014 10497 Vantage Point Bank Horsham PA 58531 First Choice Bank February 28, 2014 10496 Millennium Bank, National Association Sterling VA 35096 WashingtonFirst Bank February 28, 2014 10495 Syringa Bank Boise ID 34296 Sunwest Bank January 31, 2014 10494 The Bank of Union El Reno OK 17967 BancFirst January 24, 2014 10493 DuPage National Bank West Chicago IL 5732 Republic Bank of Chicago January 17, 2014 10492 Texas Community Bank, National Association The Woodlands TX 57431 Spirit of Texas Bank, SSB December 13, 2013 10491 Bank of Jackson County Graceville FL 14794 First Federal Bank of Florida October 30, 2013 10490 First National Bank also operating as The National Bank of El Paso En Español Edinburg TX 14318 PlainsCapital Bank September 13, 2013 10488 The Community's Bank Bridgeport CT 57041 No Acquirer September 13, 2013 10489 Sunrise Bank of Arizona Phoenix AZ 34707 First Fidelity Bank, National Association August 23, 2013 10487 Community South Bank Parsons TN 19849 CB&S Bank, Inc. August 23, 2013 10486 Bank of Wausau Wausau WI 35016 Nicolet National Bank August 9, 2013 10485 First Community Bank of Southwest Florida (also operating as Community Bank of Cape Coral) Fort Myers FL 34943 C1 Bank August 2, 2013 10484 Mountain National Bank Sevierville TN 34789 First Tennessee Bank, National Association June 7, 2013 10483 1st Commerce Bank North Las Vegas NV 58358 Plaza Bank June 6, 2013 10482 Banks of Wisconsin d/b/a Bank of Kenosha Kenosha WI 35386 North Shore Bank, FSB May 31, 2013 10478 Central Arizona Bank Scottsdale AZ 34527 Western State Bank May 14, 2013 10479 Sunrise Bank Valdosta GA 58185 Synovus Bank May 10, 2013 10481 Pisgah Community Bank Asheville NC 58701 Capital Bank, N.A. May 10, 2013 10480 Douglas County Bank Douglasville GA 21649 Hamilton State Bank April 26, 2013 10476 Parkway Bank Lenoir NC 57158 CertusBank, National Association April 26, 2013 10477 Chipola Community Bank Marianna FL 58034 First Federal Bank of Florida April 19, 2013 10473 Heritage Bank of North Florida Orange Park FL 26680 FirstAtlantic Bank April 19, 2013 10475 First Federal Bank Lexington KY 29594 Your Community Bank April 19, 2013 10474 Gold Canyon Bank Gold Canyon AZ 58066 First Scottsdale Bank, National Association April 5, 2013 10472 Frontier Bank LaGrange GA 16431 HeritageBank of the South March 8, 2013 10471 Covenant Bank Chicago IL 22476 Liberty Bank and Trust Company February 15, 2013 10470 1st Regents Bank Andover MN 57157 First Minnesota Bank January 18, 2013 10469 Westside Community Bank University Place WA 33997 Sunwest Bank January 11, 2013 10468 Community Bank of the Ozarks Sunrise Beach MO 27331 Bank of Sullivan December 14, 2012 10467 Hometown Community Bank Braselton GA 57928 CertusBank, National Association November 16, 2012 10466 Citizens First National Bank Princeton IL 3731 Heartland Bank and Trust Company November 2, 2012 10464 Heritage Bank of Florida Lutz FL 35009 Centennial Bank November 2, 2012 10465 NOVA Bank Berwyn PA 27148 No Acquirer October 26, 2012 10463 Excel Bank Sedalia MO 19189 Simmons First National Bank October 19, 2012 10460 First East Side Savings Bank Tamarac FL 28144 Stearns Bank N.A. October 19, 2012 10461 GulfSouth Private Bank Destin FL 58073 SmartBank October 19, 2012 10462 First United Bank Crete IL 20685 Old Plank Trail Community Bank, National Association September 28, 2012 10459 Truman Bank St. Louis MO 27316 Simmons First National Bank September 14, 2012 10458 First Commercial Bank Bloomington MN 35246 Republic Bank & Trust Company September 7, 2012 10457 Waukegan Savings Bank Waukegan IL 28243 First Midwest Bank August 3, 2012 10456 Jasper Banking Company Jasper GA 16240 Stearns Bank N.A. July 27, 2012 10455 Second Federal Savings and Loan Association of Chicago Chicago IL 27986 Hinsdale Bank & Trust Company July 20, 2012 10453 Heartland Bank Leawood KS 1361 Metcalf Bank July 20, 2012 10452 First Cherokee State Bank Woodstock GA 32711 Community & Southern Bank July 20, 2012 10450 Georgia Trust Bank Buford GA 57847 Community & Southern Bank July 20, 2012 10451 The Royal Palm Bank of Florida Naples FL 57096 First National Bank of the Gulf Coast July 20, 2012 10454 Glasgow Savings Bank Glasgow MO 1056 Regional Missouri Bank July 13, 2012 10449 Montgomery Bank & Trust Ailey GA 19498 Ameris Bank July 6, 2012 10448 The Farmers Bank of Lynchburg Lynchburg TN 1690 Clayton Bank and Trust June 15, 2012 10447 Security Exchange Bank Marietta GA 35299 Fidelity Bank June 15, 2012 10446 Putnam State Bank Palatka FL 27405 Harbor Community Bank June 15, 2012 10445 Waccamaw Bank Whiteville NC 34515 First Community Bank June 8, 2012 10444 Farmers' and Traders' State Bank Shabbona IL 9257 First State Bank June 8, 2012 10442 Carolina Federal Savings Bank Charleston SC 35372 Bank of North Carolina June 8, 2012 10441 First Capital Bank Kingfisher OK 416 F & M Bank June 8, 2012 10443

Here are the most recent three bank failures from each region:

Northeast Region:

  • Signature Bank, New York, NY, 57053, Flagstar Bank, N.A., March 12, 2023
  • City National Bank of New Jersey, Newark, NJ, 21111, Industrial Bank, November 1, 2019
  • Harvest Community Bank, Pennsville, NJ, 34951, First-Citizens Bank & Trust Company, January 13, 2017

West Region:

  • Silicon Valley Bank, Santa Clara, CA, 24735, First–Citizens Bank & Trust Company, March 10, 2023
  • Frontier Bank, FSB D/B/A El Paseo Bank, Palm Desert, CA, 34738, Bank of Southern California, N.A., November 7, 2014
  • Premier Bank, Denver, CO, 34112, United Fidelity Bank, fsb, July 10, 2015

Midwest Region:

  • Almena State Bank, Almena, KS, 15426, Equity Bank, October 23, 2020
  • The Farmers and Merchants State Bank of Argonia, Argonia, KS, 17719, Conway Bank, October 13, 2017
  • Allied Bank, Mulberry, AR, 91, Today's Bank, September 23, 2016

South Region:

  • First City Bank of Florida, Fort Walton Beach, FL, 16748, United Fidelity Bank, fsb, October 16, 2020
  • Louisa Community Bank, Louisa, KY, 58112, Kentucky Farmers Bank Corporation, October 25, 2019
  • First NBC Bank, New Orleans, LA, 58302, Whitney Bank, April 28, 2017

Mid-Atlantic Region:

  • The First State Bank, Barboursville, WV, 14361, MVB Bank, Inc., April 3, 2020
  • Trust Company Bank, Memphis, TN, 9956, The Bank of Fayette County, April 29, 2016
  • Capitol City Bank & Trust Company, Atlanta, GA, 33938, First-Citizens Bank & Trust Company, February 13, 2015

Great Lakes Region:

  • Resolute Bank, Maumee, OH, 58317, Buckeye State Bank, October 25, 2019
  • Seaway Bank and Trust Company, Chicago, IL, 19328, State Bank of Texas, January 27, 2017
  • North Milwaukee State Bank, Milwaukee, WI, 20364, First-Citizens Bank & Trust Company, March 11, 2016

Puerto Rico and Virgin Islands Region:

  • Doral Bank, San Juan, PR, 32102, Banco Popular de Puerto Rico, February 27, 2015
  • None
  • None