Read a CSV

We're going to use built-in Python modules - programs really - to download a csv file from the Internet and save it locally.

CSV stands for comma-separated values. It's a common file format a file format that resembles a spreadsheet or database table in a text file.

So first, let's import two built-in Python modules: urllib and csv.

  • urllib is a module that allows Python to make http requests to URLs on the web to fetch HTML. It contains a submodule called request. And inside there we want a specific method called urlretrieve

  • csv is a module that helps Python work with tabular data extracted from spreadsheets and databases


In [34]:
from urllib.request import urlretrieve
import csv

We're going to download a csv file. What should we name it?


In [35]:
downloaded_file = "banklist.csv"

Now we need a URL to a CSV file out on the Internet.

For this project we're going to download a CSV file that the FDIC compiles of all the banks that have failed since October 1, 2000.

The file we want is at https://s3.amazonaws.com/datanicar/banklist.csv.

If the internet is uncooperative, we can also use the local version of the file in the project1/data/ directory, and structure out code a little differently.

To do this, we use that program within the urllib module to download the file and save it to our project folder. It's called urlretrieve and for our purposes starting out think of it as a way to download a file from the Internet.

urlretrieve takes two arguments to download a file. First specify our target URL, and then we give it a name for the file we want to create.


In [36]:
urlretrieve("https://s3.amazonaws.com/datanicar/banklist.csv", downloaded_file)


Out[36]:
('banklist.csv', <http.client.HTTPMessage at 0x10fd58860>)

The output shows we successfully downloaded the file and saved it

Now we want to go ahead and use python's csv reader to open the file and see what is inside.

We specify the name of the file we just created, and we add a setting so we can open and read almost any CSV file.


In [37]:
# open the downloaded file
with open(downloaded_file, 'r') as file:

    # use python's csv reader to access the contents
    # and create an object that represents the data
    csv_data = csv.reader(file)
    
    # loop through each row of the csv
    for row in csv_data:
        
        # and print the row to the terminal
        print(row)
        
        # print the data type to the terminal
        print(type(row))
        
        # print the length of the row to the terminal
        print(len(row))
        
        print(if len(row) != 7)


['Bank Name', 'City', 'ST', 'CERT', 'Acquiring Institution', 'Closing Date', 'Updated Date']
<class 'list'>
7
['Washington Federal Bank for Savings', 'Chicago', 'IL', '30570', 'Royal Savings Bank', '15-Dec-17', '1-Feb-19']
<class 'list'>
7
['The Farmers and Merchants State Bank of Argonia', 'Argonia', 'KS', '17719', 'Conway Bank', '13-Oct-17', '21-Feb-18']
<class 'list'>
7
['Fayette County Bank', 'Saint Elmo', 'IL', '1802', 'United Fidelity Bank, fsb', '26-May-17', '29-Jan-19']
<class 'list'>
7
['Guaranty Bank, (d/b/a BestBank in Georgia & Michigan) ', 'Milwaukee', 'WI', '30003', 'First-Citizens Bank & Trust Company', '5-May-17', '22-Mar-18']
<class 'list'>
7
['First NBC Bank', 'New Orleans', 'LA', '58302', 'Whitney Bank', '28-Apr-17', '29-Jan-19']
<class 'list'>
7
['Proficio Bank', 'Cottonwood Heights', 'UT', '35495', 'Cache Valley Bank', '3-Mar-17', '29-Jan-19']
<class 'list'>
7
['Seaway Bank and Trust Company', 'Chicago', 'IL', '19328', 'State Bank of Texas', '27-Jan-17', '29-Jan-19']
<class 'list'>
7
['Harvest Community Bank', 'Pennsville', 'NJ', '34951', 'First-Citizens Bank & Trust Company', '13-Jan-17', '18-May-17']
<class 'list'>
7
['Allied Bank', 'Mulberry', 'AR', '91', "Today's Bank", '23-Sep-16', '29-Jan-19']
<class 'list'>
7
['The Woodbury Banking Company', 'Woodbury', 'GA', '11297', 'United Bank', '19-Aug-16', '13-Dec-18']
<class 'list'>
7
['First CornerStone Bank', 'King of Prussia', 'PA', '35312', 'First-Citizens Bank & Trust Company', '6-May-16', '13-Nov-18']
<class 'list'>
7
['Trust Company Bank', 'Memphis', 'TN', '9956', 'The Bank of Fayette County', '29-Apr-16', '14-Sep-18']
<class 'list'>
7
['North Milwaukee State Bank', 'Milwaukee', 'WI', '20364', 'First-Citizens Bank & Trust Company', '11-Mar-16', '29-Jan-19']
<class 'list'>
7
['Hometown National Bank', 'Longview', 'WA', '35156', 'Twin City Bank', '2-Oct-15', '19-Feb-18']
<class 'list'>
7
['The Bank of Georgia', 'Peachtree City', 'GA', '35259', 'Fidelity Bank', '2-Oct-15', '9-Jul-18']
<class 'list'>
7
['Premier Bank', 'Denver', 'CO', '34112', 'United Fidelity Bank, fsb', '10-Jul-15', '20-Feb-18']
<class 'list'>
7
['Edgebrook Bank', 'Chicago', 'IL', '57772', 'Republic Bank of Chicago', '8-May-15', '29-Jan-19']
<class 'list'>
7
['Doral Bank', 'San Juan', 'PR', '32102', 'Banco Popular de Puerto Rico', '27-Feb-15', '29-Jan-19']
<class 'list'>
7
['Capitol City Bank & Trust Company', 'Atlanta', 'GA', '33938', 'First-Citizens Bank & Trust Company', '13-Feb-15', '29-Jan-19']
<class 'list'>
7
['Highland Community Bank', 'Chicago', 'IL', '20290', 'United Fidelity Bank, fsb', '23-Jan-15', '15-Nov-17']
<class 'list'>
7
['First National Bank of Crestview ', 'Crestview', 'FL', '17557', 'First NBC Bank', '16-Jan-15', '15-Nov-17']
<class 'list'>
7
['Northern Star Bank', 'Mankato', 'MN', '34983', 'BankVista', '19-Dec-14', '3-Jan-18']
<class 'list'>
7
['Frontier Bank, FSB D/B/A El Paseo Bank', 'Palm Desert', 'CA', '34738', 'Bank of Southern California, N.A.', '7-Nov-14', '10-Nov-16']
<class 'list'>
7
['The National Republic Bank of Chicago', 'Chicago', 'IL', '916', 'State Bank of Texas', '24-Oct-14', '6-Jan-16']
<class 'list'>
7
['NBRS Financial', 'Rising Sun', 'MD', '4862', 'Howard Bank', '17-Oct-14', '29-Jan-19']
<class 'list'>
7
['GreenChoice Bank, fsb', 'Chicago', 'IL', '28462', 'Providence Bank, LLC', '25-Jul-14', '12-Dec-16']
<class 'list'>
7
['Eastside Commercial Bank', 'Conyers', 'GA', '58125', 'Community & Southern Bank', '18-Jul-14', '6-Oct-17']
<class 'list'>
7
['The Freedom State Bank ', 'Freedom', 'OK', '12483', 'Alva State Bank & Trust Company', '27-Jun-14', '21-Feb-18']
<class 'list'>
7
['Valley Bank', 'Fort Lauderdale', 'FL', '21793', 'Landmark Bank, National Association', '20-Jun-14', '29-Jan-19']
<class 'list'>
7
['Valley Bank', 'Moline', 'IL', '10450', 'Great Southern Bank', '20-Jun-14', '29-Jan-19']
<class 'list'>
7
['Slavie Federal Savings Bank', 'Bel Air', 'MD', '32368', 'Bay Bank, FSB', '30-May-14', '12-Dec-16']
<class 'list'>
7
['Columbia Savings Bank', 'Cincinnati', 'OH', '32284', 'United Fidelity Bank, fsb', '23-May-14', '10-Nov-16']
<class 'list'>
7
['AztecAmerica Bank ', 'Berwyn', 'IL', '57866', 'Republic Bank of Chicago', '16-May-14', '20-Oct-16']
<class 'list'>
7
['Allendale County Bank', 'Fairfax', 'SC', '15062', 'Palmetto State Bank', '25-Apr-14', '29-Jan-19']
<class 'list'>
7
['Vantage Point Bank', 'Horsham', 'PA', '58531', 'First Choice Bank', '28-Feb-14', '7-Jan-18']
<class 'list'>
7
['Millennium Bank, National Association ', 'Sterling', 'VA', '35096', 'WashingtonFirst Bank', '28-Feb-14', '10-Jul-18']
<class 'list'>
7
['Syringa Bank', 'Boise', 'ID', '34296', 'Sunwest Bank', '31-Jan-14', '12-Apr-16']
<class 'list'>
7
['The Bank of Union', 'El Reno', 'OK', '17967', 'BancFirst', '24-Jan-14', '29-Jan-19']
<class 'list'>
7
['DuPage National Bank', 'West Chicago', 'IL', '5732', 'Republic Bank of Chicago', '17-Jan-14', '20-Oct-16']
<class 'list'>
7
['Texas Community Bank, National Association', 'The Woodlands', 'TX', '57431', 'Spirit of Texas Bank, SSB', '13-Dec-13', '13-Feb-18']
<class 'list'>
7
['Bank of Jackson County', 'Graceville', 'FL', '14794', 'First Federal Bank of Florida', '30-Oct-13', '20-Oct-16']
<class 'list'>
7
['First National Bank also operating as The National Bank of El Paso', 'Edinburg', 'TX', '14318', 'PlainsCapital Bank', '13-Sep-13', '27-May-15']
<class 'list'>
7
["The Community's Bank", 'Bridgeport', 'CT', '57041', 'No Acquirer', '13-Sep-13', '7-Dec-15']
<class 'list'>
7
['Sunrise Bank of Arizona', 'Phoenix', 'AZ', '34707', 'First Fidelity Bank, National Association', '23-Aug-13', '3-May-17']
<class 'list'>
7
['Community South Bank', 'Parsons', 'TN', '19849', 'CB&S Bank, Inc.', '23-Aug-13', '29-Jan-19']
<class 'list'>
7
['Bank of Wausau', 'Wausau', 'WI', '35016', 'Nicolet National Bank', '9-Aug-13', '21-Feb-18']
<class 'list'>
7
['First Community Bank of Southwest Florida (also operating as Community Bank of Cape Coral)', 'Fort Myers', 'FL', '34943', 'C1 Bank', '2-Aug-13', '9-Feb-17']
<class 'list'>
7
['Mountain National Bank', 'Sevierville', 'TN', '34789', 'First Tennessee Bank, National Association', '7-Jun-13', '4-Feb-16']
<class 'list'>
7
['1st Commerce Bank', 'North Las Vegas', 'NV', '58358', 'Plaza Bank', '6-Jun-13', '8-Aug-18']
<class 'list'>
7
['Banks of Wisconsin d/b/a Bank of Kenosha', 'Kenosha', 'WI', '35386', 'North Shore Bank, FSB', '31-May-13', '29-Jan-19']
<class 'list'>
7
['Central Arizona Bank', 'Scottsdale', 'AZ', '34527', 'Western State Bank', '14-May-13', '7-Dec-15']
<class 'list'>
7
['Sunrise Bank', 'Valdosta', 'GA', '58185', 'Synovus Bank', '10-May-13', '29-Jan-19']
<class 'list'>
7
['Pisgah Community Bank', 'Asheville', 'NC', '58701', 'Capital Bank, N.A.', '10-May-13', '8-Aug-16']
<class 'list'>
7
['Douglas County Bank', 'Douglasville', 'GA', '21649', 'Hamilton State Bank', '26-Apr-13', '25-Apr-14']
<class 'list'>
7
['Parkway Bank', 'Lenoir', 'NC', '57158', 'CertusBank, National Association', '26-Apr-13', '6-Oct-17']
<class 'list'>
7
['Chipola Community Bank', 'Marianna', 'FL', '58034', 'First Federal Bank of Florida', '19-Apr-13', '21-Sep-15']
<class 'list'>
7
['Heritage Bank of North Florida', 'Orange Park', 'FL', '26680', 'FirstAtlantic Bank', '19-Apr-13', '29-Jan-19']
<class 'list'>
7
['First Federal Bank', 'Lexington', 'KY', '29594', 'Your Community Bank', '19-Apr-13', '12-Dec-16']
<class 'list'>
7
['Gold Canyon Bank', 'Gold Canyon', 'AZ', '58066', 'First Scottsdale Bank, National Association', '5-Apr-13', '6-Oct-17']
<class 'list'>
7
['Frontier Bank', 'LaGrange', 'GA', '16431', 'HeritageBank of the South', '8-Mar-13', '13-Nov-17']
<class 'list'>
7
['Covenant Bank', 'Chicago', 'IL', '22476', 'Liberty Bank and Trust Company', '15-Feb-13', '21-Sep-15']
<class 'list'>
7
['1st Regents Bank', 'Andover', 'MN', '57157', 'First Minnesota Bank', '18-Jan-13', '12-Jul-16']
<class 'list'>
7
['Westside Community Bank', 'University Place', 'WA', '33997', 'Sunwest Bank', '11-Jan-13', '8-Aug-16']
<class 'list'>
7
['Community Bank of the Ozarks', 'Sunrise Beach', 'MO', '27331', 'Bank of Sullivan', '14-Dec-12', '29-Jan-19']
<class 'list'>
7
['Hometown Community Bank', 'Braselton', 'GA', '57928', 'CertusBank, National Association', '16-Nov-12', '6-Oct-17']
<class 'list'>
7
['Citizens First National Bank', 'Princeton', 'IL', '3731', 'Heartland Bank and Trust Company', '2-Nov-12', '13-Feb-18']
<class 'list'>
7
['Heritage Bank of Florida', 'Lutz', 'FL', '35009', 'Centennial Bank', '2-Nov-12', '29-Jan-19']
<class 'list'>
7
['NOVA Bank', 'Berwyn', 'PA', '27148', 'No Acquirer', '26-Oct-12', '29-Jan-19']
<class 'list'>
7
['Excel Bank', 'Sedalia', 'MO', '19189', 'Simmons First National Bank', '19-Oct-12', '7-Aug-18']
<class 'list'>
7
['First East Side Savings Bank', 'Tamarac', 'FL', '28144', 'Stearns Bank N.A.', '19-Oct-12', '6-Jan-16']
<class 'list'>
7
['GulfSouth Private Bank', 'Destin', 'FL', '58073', 'SmartBank', '19-Oct-12', '29-Jan-19']
<class 'list'>
7
['First United Bank', 'Crete', 'IL', '20685', 'Old Plank Trail Community Bank, National Association', '28-Sep-12', '12-Oct-18']
<class 'list'>
7
['Truman Bank', 'St. Louis', 'MO', '27316', 'Simmons First National Bank', '14-Sep-12', '11-Dec-18']
<class 'list'>
7
['First Commercial Bank', 'Bloomington', 'MN', '35246', 'Republic Bank & Trust Company', '7-Sep-12', '10-Jul-18']
<class 'list'>
7
['Waukegan Savings Bank', 'Waukegan', 'IL', '28243', 'First Midwest Bank', '3-Aug-12', '7-Dec-15']
<class 'list'>
7
['Jasper Banking Company', 'Jasper', 'GA', '16240', 'Stearns Bank N.A.', '27-Jul-12', '29-Jan-19']
<class 'list'>
7
['Second Federal Savings and Loan Association of Chicago', 'Chicago', 'IL', '27986', 'Hinsdale Bank & Trust Company', '20-Jul-12', '3-Jan-18']
<class 'list'>
7
['Heartland Bank', 'Leawood', 'KS', '1361', 'Metcalf Bank', '20-Jul-12', '29-Jan-19']
<class 'list'>
7
['First Cherokee State Bank', 'Woodstock', 'GA', '32711', 'Community & Southern Bank', '20-Jul-12', '6-Oct-17']
<class 'list'>
7
['Georgia Trust Bank', 'Buford', 'GA', '57847', 'Community & Southern Bank', '20-Jul-12', '6-Feb-19']
<class 'list'>
7
['The Royal Palm Bank of Florida', 'Naples', 'FL', '57096', 'First National Bank of the Gulf Coast', '20-Jul-12', '21-Mar-14']
<class 'list'>
7
['Glasgow Savings Bank', 'Glasgow', 'MO', '1056', 'Regional Missouri Bank', '13-Jul-12', '19-Aug-14']
<class 'list'>
7
['Montgomery Bank & Trust', 'Ailey', 'GA', '19498', 'Ameris Bank', '6-Jul-12', '29-Jan-19']
<class 'list'>
7
['The Farmers Bank of Lynchburg', 'Lynchburg', 'TN', '1690', 'Clayton Bank and Trust', '15-Jun-12', '8-Aug-16']
<class 'list'>
7
['Security Exchange Bank', 'Marietta', 'GA', '35299', 'Fidelity Bank', '15-Jun-12', '26-Nov-18']
<class 'list'>
7
['Putnam State Bank', 'Palatka', 'FL', '27405', 'Harbor Community Bank', '15-Jun-12', '13-Feb-18']
<class 'list'>
7
['Waccamaw Bank', 'Whiteville', 'NC', '34515', 'First Community Bank', '8-Jun-12', '29-Jan-19']
<class 'list'>
7
["Farmers' and Traders' State Bank", 'Shabbona', 'IL', '9257', 'First State Bank', '8-Jun-12', '29-Jan-19']
<class 'list'>
7
['Carolina Federal Savings Bank', 'Charleston', 'SC', '35372', 'Bank of North Carolina', '8-Jun-12', '29-Jan-19']
<class 'list'>
7
['First Capital Bank', 'Kingfisher', 'OK', '416', 'F & M Bank', '8-Jun-12', '5-Feb-15']
<class 'list'>
7
['Alabama Trust Bank, National Association', 'Sylacauga', 'AL', '35224', 'Southern States Bank', '18-May-12', '21-Sep-15']
<class 'list'>
7
['Security Bank, National Association', 'North Lauderdale', 'FL', '23156', 'Banesco USA', '4-May-12', '12-Apr-16']
<class 'list'>
7
['Palm Desert National Bank', 'Palm Desert', 'CA', '23632', 'Pacific Premier Bank', '27-Apr-12', '7-Dec-15']
<class 'list'>
7
['Plantation Federal Bank', 'Pawleys Island', 'SC', '32503', 'First Federal Bank', '27-Apr-12', '10-Nov-16']
<class 'list'>
7
['Inter Savings Bank, fsb D/B/A InterBank, fsb', 'Maple Grove', 'MN', '31495', 'Great Southern Bank', '27-Apr-12', '10-Dec-18']
<class 'list'>
7
['HarVest Bank of Maryland', 'Gaithersburg', 'MD', '57766', 'Sonabank', '27-Apr-12', '21-Sep-15']
<class 'list'>
7
['Bank of the Eastern Shore', 'Cambridge', 'MD', '26759', 'No Acquirer', '27-Apr-12', '29-Jan-19']
<class 'list'>
7
['Fort Lee Federal Savings Bank, FSB', 'Fort Lee', 'NJ', '35527', 'Alma Bank', '20-Apr-12', '29-Jan-19']
<class 'list'>
7
['Fidelity Bank', 'Dearborn', 'MI', '33883', 'The Huntington National Bank', '30-Mar-12', '10-Jul-18']
<class 'list'>
7
['Premier Bank', 'Wilmette', 'IL', '35419', 'International Bank of Chicago', '23-Mar-12', '29-Jan-19']
<class 'list'>
7
['Covenant Bank & Trust', 'Rock Spring', 'GA', '58068', 'Stearns Bank, N.A.', '23-Mar-12', '29-Jan-19']
<class 'list'>
7
['New City Bank', 'Chicago', 'IL', '57597', 'No Acquirer', '9-Mar-12', '29-Jan-19']
<class 'list'>
7
['Global Commerce Bank', 'Doraville', 'GA', '34046', 'Metro City Bank', '2-Mar-12', '29-Jan-19']
<class 'list'>
7
['Home Savings of America', 'Little Falls', 'MN', '29178', 'No Acquirer', '24-Feb-12', '29-Jan-19']
<class 'list'>
7
['Central Bank of Georgia', 'Ellaville', 'GA', '5687', 'Ameris Bank', '24-Feb-12', '29-Jan-19']
<class 'list'>
7
['SCB Bank', 'Shelbyville', 'IN', '29761', 'First Merchants Bank, National Association', '10-Feb-12', '29-Jan-19']
<class 'list'>
7
['Charter National Bank and Trust', 'Hoffman Estates', 'IL', '23187', 'Barrington Bank & Trust Company, National Association', '10-Feb-12', '29-Jan-19']
<class 'list'>
7
['BankEast', 'Knoxville', 'TN', '19869', 'U.S. Bank, N.A.', '27-Jan-12', '7-Dec-15']
<class 'list'>
7
['Patriot Bank Minnesota', 'Forest Lake', 'MN', '34823', 'First Resource Bank', '27-Jan-12', '13-Nov-17']
<class 'list'>
7
['Tennessee Commerce Bank', 'Franklin', 'TN', '35296', 'Republic Bank & Trust Company', '27-Jan-12', '29-Jan-19']
<class 'list'>
7
['First Guaranty Bank and Trust Company of Jacksonville', 'Jacksonville', 'FL', '16579', 'CenterState Bank of Florida, N.A.', '27-Jan-12', '11-Jul-16']
<class 'list'>
7
['American Eagle Savings Bank', 'Boothwyn', 'PA', '31581', 'Capital Bank, N.A.', '20-Jan-12', '21-Feb-18']
<class 'list'>
7
['The First State Bank', 'Stockbridge', 'GA', '19252', 'Hamilton State Bank', '20-Jan-12', '29-Jan-19']
<class 'list'>
7
['Central Florida State Bank', 'Belleview', 'FL', '57186', 'CenterState Bank of Florida, N.A.', '20-Jan-12', '6-Jun-16']
<class 'list'>
7
['Western National Bank', 'Phoenix', 'AZ', '57917', 'Washington Federal', '16-Dec-11', '5-Feb-15']
<class 'list'>
7
['Premier Community Bank of the Emerald Coast', 'Crestview', 'FL', '58343', 'Summit Bank', '16-Dec-11', '19-Feb-18']
<class 'list'>
7
['Central Progressive Bank', 'Lacombe', 'LA', '19657', 'First NBC Bank', '18-Nov-11', '5-Feb-15']
<class 'list'>
7
['Polk County Bank', 'Johnston', 'IA', '14194', 'Grinnell State Bank', '18-Nov-11', '15-Aug-12']
<class 'list'>
7
['Community Bank of Rockmart', 'Rockmart', 'GA', '57860', 'Century Bank of Georgia', '10-Nov-11', '29-Jan-19']
<class 'list'>
7
['SunFirst Bank', 'Saint George', 'UT', '57087', 'Cache Valley Bank', '4-Nov-11', '9-Aug-17']
<class 'list'>
7
['Mid City Bank, Inc.', 'Omaha', 'NE', '19397', 'Premier Bank', '4-Nov-11', '16-Apr-18']
<class 'list'>
7
['All American Bank', 'Des Plaines', 'IL', '57759', 'International Bank of Chicago', '28-Oct-11', '21-Feb-18']
<class 'list'>
7
['Community Banks of Colorado', 'Greenwood Village', 'CO', '21132', 'Bank Midwest, N.A.', '21-Oct-11', '29-Jan-19']
<class 'list'>
7
['Community Capital Bank', 'Jonesboro', 'GA', '57036', 'State Bank and Trust Company', '21-Oct-11', '6-Jan-16']
<class 'list'>
7
['Decatur First Bank', 'Decatur', 'GA', '34392', 'Fidelity Bank', '21-Oct-11', '21-Mar-14']
<class 'list'>
7
['Old Harbor Bank', 'Clearwater', 'FL', '57537', '1st United Bank', '21-Oct-11', '29-Jan-19']
<class 'list'>
7
['Country Bank', 'Aledo', 'IL', '35395', 'Blackhawk Bank & Trust', '14-Oct-11', '29-Jan-19']
<class 'list'>
7
['First State Bank', 'Cranford', 'NJ', '58046', 'Northfield Bank', '14-Oct-11', '23-Oct-17']
<class 'list'>
7
['Blue Ridge Savings Bank, Inc.', 'Asheville', 'NC', '32347', 'Bank of North Carolina', '14-Oct-11', '11-Oct-18']
<class 'list'>
7
['Piedmont Community Bank', 'Gray', 'GA', '57256', 'State Bank and Trust Company', '14-Oct-11', '21-Mar-14']
<class 'list'>
7
['Sun Security Bank', 'Ellington', 'MO', '20115', 'Great Southern Bank', '7-Oct-11', '8-May-17']
<class 'list'>
7
['The RiverBank', 'Wyoming', 'MN', '10216', 'Central Bank', '7-Oct-11', '9-May-18']
<class 'list'>
7
['First International Bank', 'Plano', 'TX', '33513', 'American First National Bank', '30-Sep-11', '5-Feb-15']
<class 'list'>
7
['Citizens Bank of Northern California', 'Nevada City', 'CA', '33983', 'Tri Counties Bank', '23-Sep-11', '7-Jan-18']
<class 'list'>
7
['Bank of the Commonwealth', 'Norfolk', 'VA', '20408', 'Southern Bank and Trust Company', '23-Sep-11', '29-Jan-19']
<class 'list'>
7
['The First National Bank of Florida', 'Milton', 'FL', '25155', 'CharterBank', '9-Sep-11', '21-Mar-14']
<class 'list'>
7
['CreekSide Bank', 'Woodstock', 'GA', '58226', 'Georgia Commerce Bank', '2-Sep-11', '23-Jun-17']
<class 'list'>
7
['Patriot Bank of Georgia', 'Cumming', 'GA', '58273', 'Georgia Commerce Bank', '2-Sep-11', '28-Jun-17']
<class 'list'>
7
['First Choice Bank', 'Geneva', 'IL', '57212', 'Inland Bank & Trust', '19-Aug-11', '5-Feb-15']
<class 'list'>
7
['First Southern National Bank', 'Statesboro', 'GA', '57239', 'Heritage Bank of the South', '19-Aug-11', '19-Feb-18']
<class 'list'>
7
['Lydian Private Bank', 'Palm Beach', 'FL', '35356', 'Sabadell United Bank, N.A.', '19-Aug-11', '29-Jan-19']
<class 'list'>
7
['Public Savings Bank', 'Huntingdon Valley', 'PA', '34130', 'Capital Bank, N.A.', '18-Aug-11', '12-Feb-18']
<class 'list'>
7
['The First National Bank of Olathe', 'Olathe', 'KS', '4744', 'Enterprise Bank & Trust', '12-Aug-11', '8-Jun-18']
<class 'list'>
7
['Bank of Whitman', 'Colfax', 'WA', '22528', 'Columbia State Bank', '5-Aug-11', '29-Jan-19']
<class 'list'>
7
['Bank of Shorewood', 'Shorewood', 'IL', '22637', 'Heartland Bank and Trust Company', '5-Aug-11', '20-Oct-16']
<class 'list'>
7
['Integra Bank National Association', 'Evansville', 'IN', '4392', 'Old National Bank', '29-Jul-11', '16-Aug-12']
<class 'list'>
7
['BankMeridian, N.A.', 'Columbia', 'SC', '58222', 'SCBT National Association', '29-Jul-11', '29-Jan-19']
<class 'list'>
7
['Virginia Business Bank', 'Richmond', 'VA', '58283', 'Xenith Bank', '29-Jul-11', '9-Oct-12']
<class 'list'>
7
['Bank of Choice', 'Greeley', 'CO', '2994', 'Bank Midwest, N.A.', '22-Jul-11', '29-Jan-19']
<class 'list'>
7
['LandMark Bank of Florida', 'Sarasota', 'FL', '35244', 'American Momentum Bank', '22-Jul-11', '21-Mar-14']
<class 'list'>
7
['Southshore Community Bank', 'Apollo Beach', 'FL', '58056', 'American Momentum Bank', '22-Jul-11', '5-Feb-15']
<class 'list'>
7
['Summit Bank', 'Prescott', 'AZ', '57442', 'The Foothills Bank', '15-Jul-11', '19-Aug-14']
<class 'list'>
7
['First Peoples Bank', 'Port St. Lucie', 'FL', '34870', 'Premier American Bank, N.A.', '15-Jul-11', '12-Jul-16']
<class 'list'>
7
['High Trust Bank', 'Stockbridge', 'GA', '19554', 'Ameris Bank', '15-Jul-11', '29-Jan-19']
<class 'list'>
7
['One Georgia Bank', 'Atlanta', 'GA', '58238', 'Ameris Bank', '15-Jul-11', '29-Jan-19']
<class 'list'>
7
['Signature Bank', 'Windsor', 'CO', '57835', 'Points West Community Bank', '8-Jul-11', '26-Oct-12']
<class 'list'>
7
['Colorado Capital Bank', 'Castle Rock', 'CO', '34522', 'First-Citizens Bank & Trust Company', '8-Jul-11', '10-Nov-16']
<class 'list'>
7
['First Chicago Bank & Trust', 'Chicago', 'IL', '27935', 'Northbrook Bank & Trust Company', '8-Jul-11', '29-Jan-19']
<class 'list'>
7
['Mountain Heritage Bank', 'Clayton', 'GA', '57593', 'First American Bank and Trust Company', '24-Jun-11', '9-Feb-17']
<class 'list'>
7
['First Commercial Bank of Tampa Bay', 'Tampa', 'FL', '27583', 'Stonegate Bank', '17-Jun-11', '12-Sep-16']
<class 'list'>
7
['McIntosh State Bank', 'Jackson', 'GA', '19237', 'Hamilton State Bank', '17-Jun-11', '29-Jan-19']
<class 'list'>
7
['Atlantic Bank and Trust', 'Charleston', 'SC', '58420', 'First Citizens Bank and Trust Company, Inc.', '3-Jun-11', '29-Jan-19']
<class 'list'>
7
['First Heritage Bank', 'Snohomish', 'WA', '23626', 'Columbia State Bank', '27-May-11', '23-Oct-17']
<class 'list'>
7
['Summit Bank', 'Burlington', 'WA', '513', 'Columbia State Bank', '20-May-11', '23-Oct-17']
<class 'list'>
7
['First Georgia Banking Company', 'Franklin', 'GA', '57647', 'CertusBank, National Association', '20-May-11', '29-Jan-19']
<class 'list'>
7
['Atlantic Southern Bank', 'Macon', 'GA', '57213', 'CertusBank, National Association', '20-May-11', '29-Jan-19']
<class 'list'>
7
['Coastal Bank', 'Cocoa Beach', 'FL', '34898', 'Florida Community Bank, a division of Premier American Bank, N.A.', '6-May-11', '21-Sep-15']
<class 'list'>
7
['Community Central Bank', 'Mount Clemens', 'MI', '34234', 'Talmer Bank & Trust', '29-Apr-11', '20-Feb-18']
<class 'list'>
7
['The Park Avenue Bank', 'Valdosta', 'GA', '19797', 'Bank of the Ozarks', '29-Apr-11', '29-Jan-19']
<class 'list'>
7
['First Choice Community Bank', 'Dallas', 'GA', '58539', 'Bank of the Ozarks', '29-Apr-11', '21-Sep-15']
<class 'list'>
7
['Cortez Community Bank', 'Brooksville', 'FL', '57625', 'Florida Community Bank, a division of Premier American Bank, N.A.', '29-Apr-11', '8-Aug-16']
<class 'list'>
7
['First National Bank of Central Florida', 'Winter Park', 'FL', '26297', 'Florida Community Bank, a division of Premier American Bank, N.A.', '29-Apr-11', '4-May-16']
<class 'list'>
7
['Heritage Banking Group', 'Carthage', 'MS', '14273', 'Trustmark National Bank', '15-Apr-11', '29-Jan-19']
<class 'list'>
7
['Rosemount National Bank', 'Rosemount', 'MN', '24099', 'Central Bank', '15-Apr-11', '7-Dec-15']
<class 'list'>
7
['Superior Bank', 'Birmingham', 'AL', '17750', 'Superior Bank, National Association', '15-Apr-11', '29-Jan-19']
<class 'list'>
7
['Nexity Bank', 'Birmingham', 'AL', '19794', 'AloStar Bank of Commerce', '15-Apr-11', '29-Jan-19']
<class 'list'>
7
['New Horizons Bank', 'East Ellijay', 'GA', '57705', 'Citizens South Bank', '15-Apr-11', '13-Nov-17']
<class 'list'>
7
['Bartow County Bank', 'Cartersville', 'GA', '21495', 'Hamilton State Bank', '15-Apr-11', '29-Jan-19']
<class 'list'>
7
['Nevada Commerce Bank', 'Las Vegas', 'NV', '35418', 'City National Bank', '8-Apr-11', '29-Jan-19']
<class 'list'>
7
['Western Springs National Bank and Trust', 'Western Springs', 'IL', '10086', 'Heartland Bank and Trust Company', '8-Apr-11', '17-Apr-18']
<class 'list'>
7
['The Bank of Commerce', 'Wood Dale', 'IL', '34292', 'Advantage National Bank Group', '25-Mar-11', '13-Apr-18']
<class 'list'>
7
['Legacy Bank', 'Milwaukee', 'WI', '34818', 'Seaway Bank and Trust Company', '11-Mar-11', '29-Jan-19']
<class 'list'>
7
['First National Bank of Davis', 'Davis', 'OK', '4077', 'The Pauls Valley National Bank', '11-Mar-11', '29-Jan-19']
<class 'list'>
7
['Valley Community Bank', 'St. Charles', 'IL', '34187', 'First State Bank', '25-Feb-11', '5-Feb-15']
<class 'list'>
7
['San Luis Trust Bank, FSB', 'San Luis Obispo', 'CA', '34783', 'First California Bank', '18-Feb-11', '12-Sep-16']
<class 'list'>
7
['Charter Oak Bank', 'Napa', 'CA', '57855', 'Bank of Marin', '18-Feb-11', '29-Jan-19']
<class 'list'>
7
['Citizens Bank of Effingham', 'Springfield', 'GA', '34601', 'Heritage Bank of the South', '18-Feb-11', '10-May-18']
<class 'list'>
7
['Habersham Bank', 'Clarkesville', 'GA', '151', 'SCBT National Association', '18-Feb-11', '29-Jan-19']
<class 'list'>
7
['Canyon National Bank', 'Palm Springs', 'CA', '34692', 'Pacific Premier Bank', '11-Feb-11', '19-Aug-14']
<class 'list'>
7
['Badger State Bank', 'Cassville', 'WI', '13272', 'Royal Bank', '11-Feb-11', '12-Sep-12']
<class 'list'>
7
['Peoples State Bank', 'Hamtramck', 'MI', '14939', 'First Michigan Bank', '11-Feb-11', '20-Feb-18']
<class 'list'>
7
['Sunshine State Community Bank', 'Port Orange', 'FL', '35478', 'Premier American Bank, N.A.', '11-Feb-11', '8-Aug-16']
<class 'list'>
7
['Community First Bank Chicago', 'Chicago', 'IL', '57948', 'Northbrook Bank & Trust Company', '4-Feb-11', '13-Apr-18']
<class 'list'>
7
['North Georgia Bank', 'Watkinsville', 'GA', '35242', 'BankSouth', '4-Feb-11', '19-Sep-17']
<class 'list'>
7
['American Trust Bank', 'Roswell', 'GA', '57432', 'Renasant Bank', '4-Feb-11', '29-Jan-19']
<class 'list'>
7
['First Community Bank', 'Taos', 'NM', '12261', 'U.S. Bank, N.A.', '28-Jan-11', '29-Jan-19']
<class 'list'>
7
['FirsTier Bank', 'Louisville', 'CO', '57646', 'No Acquirer', '28-Jan-11', '29-Jan-19']
<class 'list'>
7
['Evergreen State Bank', 'Stoughton', 'WI', '5328', 'McFarland State Bank', '28-Jan-11', '29-Jan-19']
<class 'list'>
7
['The First State Bank', 'Camargo', 'OK', '2303', 'Bank 7', '28-Jan-11', '13-Nov-17']
<class 'list'>
7
['United Western Bank', 'Denver', 'CO', '31293', 'First-Citizens Bank & Trust Company', '21-Jan-11', '29-Jan-19']
<class 'list'>
7
['The Bank of Asheville', 'Asheville', 'NC', '34516', 'First Bank', '21-Jan-11', '29-Jan-19']
<class 'list'>
7
['CommunitySouth Bank & Trust', 'Easley', 'SC', '57868', 'CertusBank, National Association', '21-Jan-11', '6-Jun-16']
<class 'list'>
7
['Enterprise Banking Company', 'McDonough', 'GA', '19758', 'No Acquirer', '21-Jan-11', '29-Jan-19']
<class 'list'>
7
['Oglethorpe Bank', 'Brunswick', 'GA', '57440', 'Bank of the Ozarks', '14-Jan-11', '13-Nov-17']
<class 'list'>
7
['Legacy Bank', 'Scottsdale', 'AZ', '57820', 'Enterprise Bank & Trust', '7-Jan-11', '12-Apr-16']
<class 'list'>
7
['First Commercial Bank of Florida', 'Orlando', 'FL', '34965', 'First Southern Bank', '7-Jan-11', '6-Jun-16']
<class 'list'>
7
['Community National Bank', 'Lino Lakes', 'MN', '23306', 'Farmers & Merchants Savings Bank', '17-Dec-10', '10-Nov-16']
<class 'list'>
7
['First Southern Bank', 'Batesville', 'AR', '58052', 'Southern Bank', '17-Dec-10', '29-Jan-19']
<class 'list'>
7
['United Americas Bank, N.A.', 'Atlanta', 'GA', '35065', 'State Bank and Trust Company', '17-Dec-10', '17-Oct-15']
<class 'list'>
7
['Appalachian Community Bank, FSB', 'McCaysville', 'GA', '58495', 'Peoples Bank of East Tennessee', '17-Dec-10', '29-Jan-19']
<class 'list'>
7
['Chestatee State Bank', 'Dawsonville', 'GA', '34578', 'Bank of the Ozarks', '17-Dec-10', '21-Sep-15']
<class 'list'>
7
['The Bank of Miami,N.A.', 'Coral Gables', 'FL', '19040', '1st United Bank', '17-Dec-10', '29-Jan-19']
<class 'list'>
7
['Earthstar Bank', 'Southampton', 'PA', '35561', 'Polonia Bank', '10-Dec-10', '29-Jan-19']
<class 'list'>
7
['Paramount Bank', 'Farmington Hills', 'MI', '34673', 'Level One Bank', '10-Dec-10', '21-Sep-15']
<class 'list'>
7
['First Banking Center', 'Burlington', 'WI', '5287', 'First Michigan Bank', '19-Nov-10', '29-Jan-19']
<class 'list'>
7
['Allegiance Bank of North America', 'Bala Cynwyd', 'PA', '35078', 'VIST Bank', '19-Nov-10', '26-Jul-17']
<class 'list'>
7
['Gulf State Community Bank', 'Carrabelle', 'FL', '20340', 'Centennial Bank', '19-Nov-10', '12-Dec-16']
<class 'list'>
7
['Copper Star Bank', 'Scottsdale', 'AZ', '35463', 'Stearns Bank, N.A.', '12-Nov-10', '29-Jan-19']
<class 'list'>
7
['Darby Bank & Trust Co.', 'Vidalia', 'GA', '14580', 'Ameris Bank', '12-Nov-10', '29-Jan-19']
<class 'list'>
7
['Tifton Banking Company', 'Tifton', 'GA', '57831', 'Ameris Bank', '12-Nov-10', '29-Jan-19']
<class 'list'>
7
['First Vietnamese American Bank', 'Westminster', 'CA', '57885', 'Grandpoint Bank', '5-Nov-10', '29-Jan-19']
<class 'list'>
7
['Pierce Commercial Bank', 'Tacoma', 'WA', '34411', 'Heritage Bank', '5-Nov-10', '19-Oct-15']
<class 'list'>
7
['Western Commercial Bank', 'Woodland Hills', 'CA', '58087', 'First California Bank', '5-Nov-10', '12-Sep-16']
<class 'list'>
7
['K Bank', 'Randallstown', 'MD', '31263', 'Manufacturers and Traders Trust Company (M&T Bank)', '5-Nov-10', '29-Jan-19']
<class 'list'>
7
['First Arizona Savings, A FSB', 'Scottsdale', 'AZ', '32582', 'No Acquirer', '22-Oct-10', '29-Jan-19']
<class 'list'>
7
['Hillcrest Bank', 'Overland Park', 'KS', '22173', 'Hillcrest Bank, N.A.', '22-Oct-10', '29-Jan-19']
<class 'list'>
7
['First Suburban National Bank', 'Maywood', 'IL', '16089', 'Seaway Bank and Trust Company', '22-Oct-10', '21-Feb-18']
<class 'list'>
7
['The First National Bank of Barnesville', 'Barnesville', 'GA', '2119', 'United Bank', '22-Oct-10', '17-Oct-15']
<class 'list'>
7
['The Gordon Bank', 'Gordon', 'GA', '33904', 'Morris Bank', '22-Oct-10', '29-Jan-19']
<class 'list'>
7
['Progress Bank of Florida', 'Tampa', 'FL', '32251', 'Bay Cities Bank', '22-Oct-10', '4-Feb-16']
<class 'list'>
7
['First Bank of Jacksonville', 'Jacksonville', 'FL', '27573', 'Ameris Bank', '22-Oct-10', '29-Jan-19']
<class 'list'>
7
['Premier Bank', 'Jefferson City', 'MO', '34016', 'Providence Bank', '15-Oct-10', '29-Jan-19']
<class 'list'>
7
['WestBridge Bank and Trust Company', 'Chesterfield', 'MO', '58205', 'Midland States Bank', '15-Oct-10', '9-Feb-17']
<class 'list'>
7
['Security Savings Bank, F.S.B.', 'Olathe', 'KS', '30898', 'Simmons First National Bank', '15-Oct-10', '29-Jan-19']
<class 'list'>
7
['Shoreline Bank', 'Shoreline', 'WA', '35250', 'GBC International Bank', '1-Oct-10', '29-Jan-19']
<class 'list'>
7
['Wakulla Bank', 'Crawfordville', 'FL', '21777', 'Centennial Bank', '1-Oct-10', '29-Jan-19']
<class 'list'>
7
['North County Bank', 'Arlington', 'WA', '35053', 'Whidbey Island Bank', '24-Sep-10', '6-Oct-17']
<class 'list'>
7
['Haven Trust Bank Florida', 'Ponte Vedra Beach', 'FL', '58308', 'First Southern Bank', '24-Sep-10', '11-Jul-16']
<class 'list'>
7
['Maritime Savings Bank', 'West Allis', 'WI', '28612', 'North Shore Bank, FSB', '17-Sep-10', '29-Jan-19']
<class 'list'>
7
['Bramble Savings Bank', 'Milford', 'OH', '27808', 'Foundation Bank', '17-Sep-10', '20-Aug-12']
<class 'list'>
7
['The Peoples Bank', 'Winder', 'GA', '182', 'Community & Southern Bank', '17-Sep-10', '6-Oct-17']
<class 'list'>
7
['First Commerce Community Bank', 'Douglasville', 'GA', '57448', 'Community & Southern Bank', '17-Sep-10', '6-Oct-17']
<class 'list'>
7
['Bank of Ellijay', 'Ellijay', 'GA', '58197', 'Community & Southern Bank', '17-Sep-10', '6-Oct-17']
<class 'list'>
7
['ISN Bank', 'Cherry Hill', 'NJ', '57107', 'Customers Bank', '17-Sep-10', '28-Jun-17']
<class 'list'>
7
['Horizon Bank', 'Bradenton', 'FL', '35061', 'Bank of the Ozarks', '10-Sep-10', '13-Feb-18']
<class 'list'>
7
['Sonoma Valley Bank', 'Sonoma', 'CA', '27259', 'Westamerica Bank', '20-Aug-10', '8-Aug-18']
<class 'list'>
7
['Los Padres Bank', 'Solvang', 'CA', '32165', 'Pacific Western Bank', '20-Aug-10', '29-Jan-19']
<class 'list'>
7
['Butte Community Bank', 'Chico', 'CA', '33219', 'Rabobank, N.A.', '20-Aug-10', '29-Jan-19']
<class 'list'>
7
['Pacific State Bank', 'Stockton', 'CA', '27090', 'Rabobank, N.A.', '20-Aug-10', '29-Jan-19']
<class 'list'>
7
['ShoreBank', 'Chicago', 'IL', '15640', 'Urban Partnership Bank', '20-Aug-10', '29-Jan-19']
<class 'list'>
7
['Imperial Savings and Loan Association', 'Martinsville', 'VA', '31623', 'River Community Bank, N.A.', '20-Aug-10', '29-Jan-19']
<class 'list'>
7
['Independent National Bank', 'Ocala', 'FL', '27344', 'CenterState Bank of Florida, N.A.', '20-Aug-10', '20-Oct-16']
<class 'list'>
7
['Community National Bank at Bartow', 'Bartow', 'FL', '25266', 'CenterState Bank of Florida, N.A.', '20-Aug-10', '11-Jul-16']
<class 'list'>
7
['Palos Bank and Trust Company', 'Palos Heights', 'IL', '17599', 'First Midwest Bank', '13-Aug-10', '29-Jan-19']
<class 'list'>
7
['Ravenswood Bank', 'Chicago', 'IL', '34231', 'Northbrook Bank & Trust Company', '6-Aug-10', '29-Jan-19']
<class 'list'>
7
['LibertyBank', 'Eugene', 'OR', '31964', 'Home Federal Bank', '30-Jul-10', '29-Jan-19']
<class 'list'>
7
['The Cowlitz Bank', 'Longview', 'WA', '22643', 'Heritage Bank', '30-Jul-10', '29-Jan-19']
<class 'list'>
7
['Coastal Community Bank', 'Panama City Beach', 'FL', '9619', 'Centennial Bank', '30-Jul-10', '9-Feb-17']
<class 'list'>
7
['Bayside Savings Bank', 'Port Saint Joe', 'FL', '57669', 'Centennial Bank', '30-Jul-10', '12-Dec-16']
<class 'list'>
7
['Northwest Bank & Trust', 'Acworth', 'GA', '57658', 'State Bank and Trust Company', '30-Jul-10', '21-Sep-15']
<class 'list'>
7
['Home Valley Bank', 'Cave Junction', 'OR', '23181', 'South Valley Bank & Trust', '23-Jul-10', '10-Sep-18']
<class 'list'>
7
['SouthwestUSA Bank', 'Las Vegas', 'NV', '35434', 'Plaza Bank', '23-Jul-10', '31-Jan-19']
<class 'list'>
7
['Community Security Bank', 'New Prague', 'MN', '34486', 'Roundbank', '23-Jul-10', '4-Feb-16']
<class 'list'>
7
['Thunder Bank', 'Sylvan Grove', 'KS', '10506', 'The Bennington State Bank', '23-Jul-10', '13-Sep-12']
<class 'list'>
7
['Williamsburg First National Bank', 'Kingstree', 'SC', '17837', 'First Citizens Bank and Trust Company, Inc.', '23-Jul-10', '20-Oct-16']
<class 'list'>
7
['Crescent Bank and Trust Company', 'Jasper', 'GA', '27559', 'Renasant Bank', '23-Jul-10', '29-Jan-19']
<class 'list'>
7
['Sterling Bank', 'Lantana', 'FL', '32536', 'IBERIABANK', '23-Jul-10', '22-Feb-18']
<class 'list'>
7
['Mainstreet Savings Bank, FSB', 'Hastings', 'MI', '28136', 'Commercial Bank', '16-Jul-10', '21-Feb-18']
<class 'list'>
7
['Olde Cypress Community Bank', 'Clewiston', 'FL', '28864', 'CenterState Bank of Florida, N.A.', '16-Jul-10', '11-Jul-16']
<class 'list'>
7
['Turnberry Bank', 'Aventura', 'FL', '32280', 'NAFH National Bank', '16-Jul-10', '12-Sep-16']
<class 'list'>
7
['Metro Bank of Dade County', 'Miami', 'FL', '25172', 'NAFH National Bank', '16-Jul-10', '8-Aug-16']
<class 'list'>
7
['First National Bank of the South', 'Spartanburg', 'SC', '35383', 'NAFH National Bank', '16-Jul-10', '31-Jan-19']
<class 'list'>
7
['Woodlands Bank', 'Bluffton', 'SC', '32571', 'Bank of the Ozarks', '16-Jul-10', '21-Sep-15']
<class 'list'>
7
['Home National Bank', 'Blackwell', 'OK', '11636', 'RCB Bank', '9-Jul-10', '12-Dec-16']
<class 'list'>
7
['USA Bank', 'Port Chester', 'NY', '58072', 'New Century Bank', '9-Jul-10', '31-Jan-19']
<class 'list'>
7
['Ideal Federal Savings Bank', 'Baltimore', 'MD', '32456', 'No Acquirer', '9-Jul-10', '31-Jan-19']
<class 'list'>
7
['Bay National Bank', 'Baltimore', 'MD', '35462', 'Bay Bank, FSB', '9-Jul-10', '15-Jan-13']
<class 'list'>
7
['High Desert State Bank', 'Albuquerque', 'NM', '35279', 'First American Bank', '25-Jun-10', '8-Jun-18']
<class 'list'>
7
['First National Bank', 'Savannah', 'GA', '34152', 'The Savannah Bank, N.A.', '25-Jun-10', '31-Jan-19']
<class 'list'>
7
['Peninsula Bank', 'Englewood', 'FL', '26563', 'Premier American Bank, N.A.', '25-Jun-10', '11-May-18']
<class 'list'>
7
['Nevada Security Bank', 'Reno', 'NV', '57110', 'Umpqua Bank', '18-Jun-10', '23-Aug-12']
<class 'list'>
7
['Washington First International Bank', 'Seattle', 'WA', '32955', 'East West Bank', '11-Jun-10', '22-Feb-18']
<class 'list'>
7
['TierOne Bank', 'Lincoln', 'NE', '29341', 'Great Western Bank', '4-Jun-10', '31-Jan-19']
<class 'list'>
7
['Arcola Homestead Savings Bank', 'Arcola', 'IL', '31813', 'No Acquirer', '4-Jun-10', '31-Jan-19']
<class 'list'>
7
['First National Bank', 'Rosedale', 'MS', '15814', 'The Jefferson Bank', '4-Jun-10', '20-Feb-18']
<class 'list'>
7
['Sun West Bank', 'Las Vegas', 'NV', '34785', 'City National Bank', '28-May-10', '31-Jan-19']
<class 'list'>
7
['Granite Community Bank, NA', 'Granite Bay', 'CA', '57315', 'Tri Counties Bank', '28-May-10', '7-Sep-17']
<class 'list'>
7
['Bank of Florida - Tampa', 'Tampa', 'FL', '57814', 'EverBank', '28-May-10', '8-Aug-16']
<class 'list'>
7
['Bank of Florida - Southwest', 'Naples', 'FL', '35106', 'EverBank', '28-May-10', '8-Aug-16']
<class 'list'>
7
['Bank of Florida - Southeast', 'Fort Lauderdale', 'FL', '57360', 'EverBank', '28-May-10', '8-Aug-16']
<class 'list'>
7
['Pinehurst Bank', 'Saint Paul', 'MN', '57735', 'Coulee Bank', '21-May-10', '26-Oct-12']
<class 'list'>
7
['Midwest Bank and Trust Company', 'Elmwood Park', 'IL', '18117', 'FirstMerit Bank, N.A.', '14-May-10', '31-Jan-19']
<class 'list'>
7
['Southwest Community Bank', 'Springfield', 'MO', '34255', 'Simmons First National Bank', '14-May-10', '4-Feb-16']
<class 'list'>
7
['New Liberty Bank', 'Plymouth', 'MI', '35586', 'Bank of Ann Arbor', '14-May-10', '31-Jan-19']
<class 'list'>
7
['Satilla Community Bank', 'Saint Marys', 'GA', '35114', 'Ameris Bank', '14-May-10', '31-Jan-19']
<class 'list'>
7
['1st Pacific Bank of California', 'San Diego', 'CA', '35517', 'City National Bank', '7-May-10', '31-Jan-19']
<class 'list'>
7
['Towne Bank of Arizona', 'Mesa', 'AZ', '57697', 'Commerce Bank of Arizona', '7-May-10', '31-Jan-19']
<class 'list'>
7
['Access Bank', 'Champlin', 'MN', '16476', 'PrinsBank', '7-May-10', '5-Feb-15']
<class 'list'>
7
['The Bank of Bonifay', 'Bonifay', 'FL', '14246', 'First Federal Bank of Florida', '7-May-10', '31-Jan-19']
<class 'list'>
7
['Frontier Bank', 'Everett', 'WA', '22710', 'Union Bank, N.A.', '30-Apr-10', '31-Jan-19']
<class 'list'>
7
['BC National Banks', 'Butler', 'MO', '17792', 'Community First Bank', '30-Apr-10', '7-Aug-18']
<class 'list'>
7
['Champion Bank', 'Creve Coeur', 'MO', '58362', 'BankLiberty', '30-Apr-10', '6-Jun-16']
<class 'list'>
7
['CF Bancorp', 'Port Huron', 'MI', '30005', 'First Michigan Bank', '30-Apr-10', '31-Jan-19']
<class 'list'>
7
['Westernbank Puerto Rico', 'Mayaguez', 'PR', '31027', 'Banco Popular de Puerto Rico', '30-Apr-10', '31-Jan-19']
<class 'list'>
7
['R-G Premier Bank of Puerto Rico', 'Hato Rey', 'PR', '32185', 'Scotiabank de Puerto Rico', '30-Apr-10', '31-Jan-19']
<class 'list'>
7
['Eurobank', 'San Juan', 'PR', '27150', 'Oriental Bank and Trust', '30-Apr-10', '31-Jan-19']
<class 'list'>
7
['Wheatland Bank', 'Naperville', 'IL', '58429', 'Wheaton Bank & Trust', '23-Apr-10', '31-Jan-19']
<class 'list'>
7
['Peotone Bank and Trust Company', 'Peotone', 'IL', '10888', 'First Midwest Bank', '23-Apr-10', '31-Jan-19']
<class 'list'>
7
['Lincoln Park Savings Bank', 'Chicago', 'IL', '30600', 'Northbrook Bank & Trust Company', '23-Apr-10', '31-Jan-19']
<class 'list'>
7
['New Century Bank', 'Chicago', 'IL', '34821', 'MB Financial Bank, N.A.', '23-Apr-10', '31-Jan-19']
<class 'list'>
7
['Citizens Bank and Trust Company of Chicago', 'Chicago', 'IL', '34658', 'Republic Bank of Chicago', '23-Apr-10', '31-Jan-19']
<class 'list'>
7
['Broadway Bank', 'Chicago', 'IL', '22853', 'MB Financial Bank, N.A.', '23-Apr-10', '31-Jan-19']
<class 'list'>
7
['Amcore Bank, National Association', 'Rockford', 'IL', '3735', 'Harris N.A.', '23-Apr-10', '31-Jan-19']
<class 'list'>
7
['City Bank', 'Lynnwood', 'WA', '21521', 'Whidbey Island Bank', '16-Apr-10', '31-Jan-19']
<class 'list'>
7
['Tamalpais Bank', 'San Rafael', 'CA', '33493', 'Union Bank, N.A.', '16-Apr-10', '31-Jan-19']
<class 'list'>
7
['Innovative Bank', 'Oakland', 'CA', '23876', 'Center Bank', '16-Apr-10', '31-Jan-19']
<class 'list'>
7
['Butler Bank', 'Lowell', 'MA', '26619', "People's United Bank", '16-Apr-10', '31-Jan-19']
<class 'list'>
7
['Riverside National Bank of Florida', 'Fort Pierce', 'FL', '24067', 'TD Bank, N.A.', '16-Apr-10', '31-Jan-19']
<class 'list'>
7
['AmericanFirst Bank', 'Clermont', 'FL', '57724', 'TD Bank, N.A.', '16-Apr-10', '31-Jan-19']
<class 'list'>
7
['First Federal Bank of North Florida', 'Palatka', 'FL', '28886', 'TD Bank, N.A.', '16-Apr-10', '31-Jan-19']
<class 'list'>
7
['Lakeside Community Bank', 'Sterling Heights', 'MI', '34878', 'No Acquirer', '16-Apr-10', '31-Jan-19']
<class 'list'>
7
['Beach First National Bank', 'Myrtle Beach', 'SC', '34242', 'Bank of North Carolina', '9-Apr-10', '13-Feb-18']
<class 'list'>
7
['Desert Hills Bank', 'Phoenix', 'AZ', '57060', 'New York Community Bank', '26-Mar-10', '31-Jan-19']
<class 'list'>
7
['Unity National Bank', 'Cartersville', 'GA', '34678', 'Bank of the Ozarks', '26-Mar-10', '21-Sep-15']
<class 'list'>
7
['Key West Bank', 'Key West', 'FL', '34684', 'Centennial Bank', '26-Mar-10', '9-Feb-17']
<class 'list'>
7
['McIntosh Commercial Bank', 'Carrollton', 'GA', '57399', 'CharterBank', '26-Mar-10', '11-Jul-16']
<class 'list'>
7
['State Bank of Aurora', 'Aurora', 'MN', '8221', 'Northern State Bank', '19-Mar-10', '8-Aug-16']
<class 'list'>
7
['First Lowndes Bank', 'Fort Deposit', 'AL', '24957', 'First Citizens Bank', '19-Mar-10', '21-Mar-14']
<class 'list'>
7
['Bank of Hiawassee', 'Hiawassee', 'GA', '10054', 'Citizens South Bank', '19-Mar-10', '31-Jan-19']
<class 'list'>
7
['Appalachian Community Bank', 'Ellijay', 'GA', '33989', 'Community & Southern Bank', '19-Mar-10', '31-Jan-19']
<class 'list'>
7
['Advanta Bank Corp.', 'Draper', 'UT', '33535', 'No Acquirer', '19-Mar-10', '31-Jan-19']
<class 'list'>
7
['Century Security Bank', 'Duluth', 'GA', '58104', 'Bank of Upson', '19-Mar-10', '31-Jan-19']
<class 'list'>
7
['American National Bank', 'Parma', 'OH', '18806', 'The National Bank and Trust Company', '19-Mar-10', '21-Sep-15']
<class 'list'>
7
['Statewide Bank', 'Covington', 'LA', '29561', 'Home Bank', '12-Mar-10', '31-Jan-19']
<class 'list'>
7
['Old Southern Bank', 'Orlando', 'FL', '58182', 'Centennial Bank', '12-Mar-10', '9-Feb-17']
<class 'list'>
7
['The Park Avenue Bank', 'New York', 'NY', '27096', 'Valley National Bank', '12-Mar-10', '31-Jan-19']
<class 'list'>
7
['LibertyPointe Bank', 'New York', 'NY', '58071', 'Valley National Bank', '11-Mar-10', '31-Jan-19']
<class 'list'>
7
['Centennial Bank', 'Ogden', 'UT', '34430', 'No Acquirer', '5-Mar-10', '31-Jan-19']
<class 'list'>
7
['Waterfield Bank', 'Germantown', 'MD', '34976', 'No Acquirer', '5-Mar-10', '31-Jan-19']
<class 'list'>
7
['Bank of Illinois', 'Normal', 'IL', '9268', 'Heartland Bank and Trust Company', '5-Mar-10', '31-Jan-19']
<class 'list'>
7
['Sun American Bank', 'Boca Raton', 'FL', '27126', 'First-Citizens Bank & Trust Company', '5-Mar-10', '31-Jan-19']
<class 'list'>
7
['Rainier Pacific Bank', 'Tacoma', 'WA', '38129', 'Umpqua Bank', '26-Feb-10', '7-Jun-18']
<class 'list'>
7
['Carson River Community Bank', 'Carson City', 'NV', '58352', 'Heritage Bank of Nevada', '26-Feb-10', '31-Jan-19']
<class 'list'>
7
['La Jolla Bank, FSB', 'La Jolla', 'CA', '32423', 'OneWest Bank, FSB', '19-Feb-10', '31-Jan-19']
<class 'list'>
7
['George Washington Savings Bank', 'Orland Park', 'IL', '29952', 'FirstMerit Bank, N.A.', '19-Feb-10', '31-Jan-19']
<class 'list'>
7
['The La Coste National Bank', 'La Coste', 'TX', '3287', 'Community National Bank', '19-Feb-10', '19-Aug-14']
<class 'list'>
7
['Marco Community Bank', 'Marco Island', 'FL', '57586', 'Mutual of Omaha Bank', '19-Feb-10', '20-Jul-17']
<class 'list'>
7
['1st American State Bank of Minnesota', 'Hancock', 'MN', '15448', 'Community Development Bank, FSB', '5-Feb-10', '1-Nov-13']
<class 'list'>
7
['American Marine Bank', 'Bainbridge Island', 'WA', '16730', 'Columbia State Bank', '29-Jan-10', '22-Feb-18']
<class 'list'>
7
['First Regional Bank', 'Los Angeles', 'CA', '23011', 'First-Citizens Bank & Trust Company', '29-Jan-10', '31-Jan-19']
<class 'list'>
7
['Community Bank and Trust', 'Cornelia', 'GA', '5702', 'SCBT National Association', '29-Jan-10', '31-Jan-19']
<class 'list'>
7
['Marshall Bank, N.A.', 'Hallock', 'MN', '16133', 'United Valley Bank', '29-Jan-10', '1-Feb-19']
<class 'list'>
7
['Florida Community Bank', 'Immokalee', 'FL', '5672', 'Premier American Bank, N.A.', '29-Jan-10', '31-Jan-19']
<class 'list'>
7
['First National Bank of Georgia', 'Carrollton', 'GA', '16480', 'Community & Southern Bank', '29-Jan-10', '22-Feb-18']
<class 'list'>
7
['Columbia River Bank', 'The Dalles', 'OR', '22469', 'Columbia State Bank', '22-Jan-10', '10-May-18']
<class 'list'>
7
['Evergreen Bank', 'Seattle', 'WA', '20501', 'Umpqua Bank', '22-Jan-10', '12-Jul-18']
<class 'list'>
7
['Charter Bank', 'Santa Fe', 'NM', '32498', 'Charter Bank', '22-Jan-10', '1-Feb-19']
<class 'list'>
7
['Bank of Leeton', 'Leeton', 'MO', '8265', 'Sunflower Bank, N.A.', '22-Jan-10', '1-Feb-19']
<class 'list'>
7
['Premier American Bank', 'Miami', 'FL', '57147', 'Premier American Bank, N.A.', '22-Jan-10', '21-Sep-15']
<class 'list'>
7
['Barnes Banking Company', 'Kaysville', 'UT', '1252', 'No Acquirer', '15-Jan-10', '1-Feb-19']
<class 'list'>
7
['St. Stephen State Bank', 'St. Stephen', 'MN', '17522', 'First State Bank of St. Joseph', '15-Jan-10', '8-Aug-16']
<class 'list'>
7
['Town Community Bank & Trust', 'Antioch', 'IL', '34705', 'First American Bank', '15-Jan-10', '1-Feb-19']
<class 'list'>
7
['Horizon Bank', 'Bellingham', 'WA', '22977', 'Washington Federal Savings and Loan Association', '8-Jan-10', '1-Feb-19']
<class 'list'>
7
['First Federal Bank of California, F.S.B.', 'Santa Monica', 'CA', '28536', 'OneWest Bank, FSB', '18-Dec-09', '1-Feb-19']
<class 'list'>
7
['Imperial Capital Bank', 'La Jolla', 'CA', '26348', 'City National Bank', '18-Dec-09', '1-Feb-19']
<class 'list'>
7
["Independent Bankers' Bank", 'Springfield', 'IL', '26820', 'The Independent BankersBank (TIB)', '18-Dec-09', '1-Feb-19']
<class 'list'>
7
['New South Federal Savings Bank', 'Irondale', 'AL', '32276', 'Beal Bank', '18-Dec-09', '1-Feb-19']
<class 'list'>
7
['Citizens State Bank', 'New Baltimore', 'MI', '1006', 'No Acquirer', '18-Dec-09', '1-Feb-19']
<class 'list'>
7
['Peoples First Community Bank', 'Panama City', 'FL', '32167', 'Hancock Bank', '18-Dec-09', '15-Oct-18']
<class 'list'>
7
['RockBridge Commercial Bank', 'Atlanta', 'GA', '58315', 'No Acquirer', '18-Dec-09', '1-Feb-19']
<class 'list'>
7
['SolutionsBank', 'Overland Park', 'KS', '4731', 'Arvest Bank', '11-Dec-09', '3-Jan-18']
<class 'list'>
7
['Valley Capital Bank, N.A.', 'Mesa', 'AZ', '58399', 'Enterprise Bank & Trust', '11-Dec-09', '20-Oct-16']
<class 'list'>
7
['Republic Federal Bank, N.A.', 'Miami', 'FL', '22846', '1st United Bank', '11-Dec-09', '1-Feb-19']
<class 'list'>
7
['Greater Atlantic Bank', 'Reston', 'VA', '32583', 'Sonabank', '4-Dec-09', '1-Feb-19']
<class 'list'>
7
['Benchmark Bank', 'Aurora', 'IL', '10440', 'MB Financial Bank, N.A.', '4-Dec-09', '1-Feb-19']
<class 'list'>
7
['AmTrust Bank', 'Cleveland', 'OH', '29776', 'New York Community Bank', '4-Dec-09', '1-Feb-19']
<class 'list'>
7
['The Tattnall Bank', 'Reidsville', 'GA', '12080', 'Heritage Bank of the South', '4-Dec-09', '21-Mar-14']
<class 'list'>
7
['First Security National Bank', 'Norcross', 'GA', '26290', 'State Bank and Trust Company', '4-Dec-09', '17-Oct-15']
<class 'list'>
7
['The Buckhead Community Bank', 'Atlanta', 'GA', '34663', 'State Bank and Trust Company', '4-Dec-09', '1-Feb-19']
<class 'list'>
7
['Commerce Bank of Southwest Florida', 'Fort Myers', 'FL', '58016', 'Central Bank', '20-Nov-09', '21-Dec-17']
<class 'list'>
7
['Pacific Coast National Bank', 'San Clemente', 'CA', '57914', 'Sunwest Bank', '13-Nov-09', '10-Apr-17']
<class 'list'>
7
['Orion Bank', 'Naples', 'FL', '22427', 'IBERIABANK', '13-Nov-09', '1-Feb-19']
<class 'list'>
7
['Century Bank, F.S.B.', 'Sarasota', 'FL', '32267', 'IBERIABANK', '13-Nov-09', '1-Feb-19']
<class 'list'>
7
['United Commercial Bank', 'San Francisco', 'CA', '32469', 'East West Bank', '6-Nov-09', '1-Feb-19']
<class 'list'>
7
['Gateway Bank of St. Louis', 'St. Louis', 'MO', '19450', 'Central Bank of Kansas City', '6-Nov-09', '22-Aug-12']
<class 'list'>
7
['Prosperan Bank', 'Oakdale', 'MN', '35074', 'Alerus Financial, N.A.', '6-Nov-09', '1-Feb-19']
<class 'list'>
7
['Home Federal Savings Bank', 'Detroit', 'MI', '30329', 'Liberty Bank and Trust Company', '6-Nov-09', '1-Feb-19']
<class 'list'>
7
['United Security Bank', 'Sparta', 'GA', '22286', 'Ameris Bank', '6-Nov-09', '1-Feb-19']
<class 'list'>
7
['North Houston Bank', 'Houston', 'TX', '18776', 'U.S. Bank N.A.', '30-Oct-09', '1-Feb-19']
<class 'list'>
7
['Madisonville State Bank', 'Madisonville', 'TX', '33782', 'U.S. Bank N.A.', '30-Oct-09', '1-Feb-19']
<class 'list'>
7
['Citizens National Bank', 'Teague', 'TX', '25222', 'U.S. Bank N.A.', '30-Oct-09', '1-Feb-19']
<class 'list'>
7
['Park National Bank', 'Chicago', 'IL', '11677', 'U.S. Bank N.A.', '30-Oct-09', '1-Feb-19']
<class 'list'>
7
['Pacific National Bank', 'San Francisco', 'CA', '30006', 'U.S. Bank N.A.', '30-Oct-09', '1-Feb-19']
<class 'list'>
7
['California National Bank', 'Los Angeles', 'CA', '34659', 'U.S. Bank N.A.', '30-Oct-09', '1-Feb-19']
<class 'list'>
7
['San Diego National Bank', 'San Diego', 'CA', '23594', 'U.S. Bank N.A.', '30-Oct-09', '1-Feb-19']
<class 'list'>
7
['Community Bank of Lemont', 'Lemont', 'IL', '35291', 'U.S. Bank N.A.', '30-Oct-09', '1-Feb-19']
<class 'list'>
7
['Bank USA, N.A.', 'Phoenix', 'AZ', '32218', 'U.S. Bank N.A.', '30-Oct-09', '1-Feb-19']
<class 'list'>
7
['First DuPage Bank', 'Westmont', 'IL', '35038', 'First Midwest Bank', '23-Oct-09', '1-Feb-19']
<class 'list'>
7
['Riverview Community Bank', 'Otsego', 'MN', '57525', 'Central Bank', '23-Oct-09', '21-Dec-17']
<class 'list'>
7
['Bank of Elmwood', 'Racine', 'WI', '18321', 'Tri City National Bank', '23-Oct-09', '22-Aug-12']
<class 'list'>
7
['Flagship National Bank', 'Bradenton', 'FL', '35044', 'First Federal Bank of Florida', '23-Oct-09', '5-Feb-15']
<class 'list'>
7
['Hillcrest Bank Florida', 'Naples', 'FL', '58336', 'Stonegate Bank', '23-Oct-09', '1-Feb-19']
<class 'list'>
7
['American United Bank', 'Lawrenceville', 'GA', '57794', 'Ameris Bank', '23-Oct-09', '16-Jul-18']
<class 'list'>
7
['Partners Bank', 'Naples', 'FL', '57959', 'Stonegate Bank', '23-Oct-09', '5-Feb-15']
<class 'list'>
7
['San Joaquin Bank', 'Bakersfield', 'CA', '23266', 'Citizens Business Bank', '16-Oct-09', '1-Feb-19']
<class 'list'>
7
['Southern Colorado National Bank', 'Pueblo', 'CO', '57263', 'Legacy Bank', '2-Oct-09', '12-Dec-16']
<class 'list'>
7
['Jennings State Bank', 'Spring Grove', 'MN', '11416', 'Central Bank', '2-Oct-09', '15-Nov-17']
<class 'list'>
7
['Warren Bank', 'Warren', 'MI', '34824', 'The Huntington National Bank', '2-Oct-09', '1-Feb-19']
<class 'list'>
7
['Georgian Bank', 'Atlanta', 'GA', '57151', 'First Citizens Bank and Trust Company, Inc.', '25-Sep-09', '1-Feb-19']
<class 'list'>
7
['Irwin Union Bank, F.S.B.', 'Louisville', 'KY', '57068', 'First Financial Bank, N.A.', '18-Sep-09', '1-Feb-19']
<class 'list'>
7
['Irwin Union Bank and Trust Company', 'Columbus', 'IN', '10100', 'First Financial Bank, N.A.', '18-Sep-09', '1-Feb-19']
<class 'list'>
7
['Venture Bank', 'Lacey', 'WA', '22868', 'First-Citizens Bank & Trust Company', '11-Sep-09', '1-Feb-19']
<class 'list'>
7
['Brickwell Community Bank', 'Woodbury', 'MN', '57736', 'CorTrust Bank N.A.', '11-Sep-09', '20-Oct-16']
<class 'list'>
7
['Corus Bank, N.A.', 'Chicago', 'IL', '13693', 'MB Financial Bank, N.A.', '11-Sep-09', '1-Feb-19']
<class 'list'>
7
['First State Bank', 'Flagstaff', 'AZ', '34875', 'Sunwest Bank', '4-Sep-09', '5-Feb-15']
<class 'list'>
7
['Platinum Community Bank', 'Rolling Meadows', 'IL', '35030', 'No Acquirer', '4-Sep-09', '1-Feb-19']
<class 'list'>
7
['Vantus Bank', 'Sioux City', 'IA', '27732', 'Great Southern Bank', '4-Sep-09', '1-Feb-19']
<class 'list'>
7
['InBank', 'Oak Forest', 'IL', '20203', 'MB Financial Bank, N.A.', '4-Sep-09', '17-Oct-15']
<class 'list'>
7
['First Bank of Kansas City', 'Kansas City', 'MO', '25231', 'Great American Bank', '4-Sep-09', '21-Aug-12']
<class 'list'>
7
['Affinity Bank', 'Ventura', 'CA', '27197', 'Pacific Western Bank', '28-Aug-09', '1-Feb-19']
<class 'list'>
7
['Mainstreet Bank', 'Forest Lake', 'MN', '1909', 'Central Bank', '28-Aug-09', '21-Feb-18']
<class 'list'>
7
['Bradford Bank', 'Baltimore', 'MD', '28312', 'Manufacturers and Traders Trust Company (M&T Bank)', '28-Aug-09', '1-Feb-19']
<class 'list'>
7
['Guaranty Bank', 'Austin', 'TX', '32618', 'BBVA Compass', '21-Aug-09', '1-Feb-19']
<class 'list'>
7
['CapitalSouth Bank', 'Birmingham', 'AL', '22130', 'IBERIABANK', '21-Aug-09', '20-Feb-18']
<class 'list'>
7
['First Coweta Bank', 'Newnan', 'GA', '57702', 'United Bank', '21-Aug-09', '7-Dec-15']
<class 'list'>
7
['ebank', 'Atlanta', 'GA', '34682', 'Stearns Bank, N.A.', '21-Aug-09', '1-Feb-19']
<class 'list'>
7
['Community Bank of Nevada', 'Las Vegas', 'NV', '34043', 'No Acquirer', '14-Aug-09', '1-Feb-19']
<class 'list'>
7
['Community Bank of Arizona', 'Phoenix', 'AZ', '57645', 'MidFirst Bank', '14-Aug-09', '1-Feb-19']
<class 'list'>
7
['Union Bank, National Association', 'Gilbert', 'AZ', '34485', 'MidFirst Bank', '14-Aug-09', '1-Feb-19']
<class 'list'>
7
['Colonial Bank', 'Montgomery', 'AL', '9609', 'Branch Banking & Trust Company, (BB&T)', '14-Aug-09', '1-Feb-19']
<class 'list'>
7
['Dwelling House Savings and Loan Association', 'Pittsburgh', 'PA', '31559', 'PNC Bank, N.A.', '14-Aug-09', '1-Feb-19']
<class 'list'>
7
['Community First Bank', 'Prineville', 'OR', '23268', 'Home Federal Bank', '7-Aug-09', '6-Jun-18']
<class 'list'>
7
['Community National Bank of Sarasota County', 'Venice', 'FL', '27183', 'Stearns Bank, N.A.', '7-Aug-09', '1-Feb-19']
<class 'list'>
7
['First State Bank', 'Sarasota', 'FL', '27364', 'Stearns Bank, N.A.', '7-Aug-09', '1-Feb-19']
<class 'list'>
7
['Mutual Bank', 'Harvey', 'IL', '18659', 'United Central Bank', '31-Jul-09', '1-Feb-19']
<class 'list'>
7
['First BankAmericano', 'Elizabeth', 'NJ', '34270', 'Crown Bank', '31-Jul-09', '1-Feb-19']
<class 'list'>
7
['Peoples Community Bank', 'West Chester', 'OH', '32288', 'First Financial Bank, N.A.', '31-Jul-09', '10-Sep-18']
<class 'list'>
7
['Integrity Bank', 'Jupiter', 'FL', '57604', 'Stonegate Bank', '31-Jul-09', '31-Jan-19']
<class 'list'>
7
['First State Bank of Altus', 'Altus', 'OK', '9873', 'Herring Bank', '31-Jul-09', '1-Feb-19']
<class 'list'>
7
['Security Bank of Jones County', 'Gray', 'GA', '8486', 'State Bank and Trust Company', '24-Jul-09', '20-Aug-12']
<class 'list'>
7
['Security Bank of Houston County', 'Perry', 'GA', '27048', 'State Bank and Trust Company', '24-Jul-09', '17-Oct-15']
<class 'list'>
7
['Security Bank of Bibb County', 'Macon', 'GA', '27367', 'State Bank and Trust Company', '24-Jul-09', '31-Jan-19']
<class 'list'>
7
['Security Bank of North Metro', 'Woodstock', 'GA', '57105', 'State Bank and Trust Company', '24-Jul-09', '6-Jan-16']
<class 'list'>
7
['Security Bank of North Fulton', 'Alpharetta', 'GA', '57430', 'State Bank and Trust Company', '24-Jul-09', '20-Aug-12']
<class 'list'>
7
['Security Bank of Gwinnett County', 'Suwanee', 'GA', '57346', 'State Bank and Trust Company', '24-Jul-09', '23-Oct-17']
<class 'list'>
7
['Waterford Village Bank', 'Williamsville', 'NY', '58065', 'Evans Bank, N.A.', '24-Jul-09', '1-Nov-13']
<class 'list'>
7
['Temecula Valley Bank', 'Temecula', 'CA', '34341', 'First-Citizens Bank & Trust Company', '17-Jul-09', '20-Oct-16']
<class 'list'>
7
['Vineyard Bank', 'Rancho Cucamonga', 'CA', '23556', 'California Bank & Trust', '17-Jul-09', '14-Sep-18']
<class 'list'>
7
['BankFirst', 'Sioux Falls', 'SD', '34103', 'Alerus Financial, N.A.', '17-Jul-09', '15-Jul-18']
<class 'list'>
7
['First Piedmont Bank', 'Winder', 'GA', '34594', 'First American Bank and Trust Company', '17-Jul-09', '8-Aug-16']
<class 'list'>
7
['Bank of Wyoming', 'Thermopolis', 'WY', '22754', 'Central Bank & Trust', '10-Jul-09', '12-Jul-18']
<class 'list'>
7
['Founders Bank', 'Worth', 'IL', '18390', 'The PrivateBank and Trust Company', '2-Jul-09', '31-Jan-19']
<class 'list'>
7
['Millennium State Bank of Texas', 'Dallas', 'TX', '57667', 'State Bank of Texas', '2-Jul-09', '26-Oct-12']
<class 'list'>
7
['First National Bank of Danville', 'Danville', 'IL', '3644', 'First Financial Bank, N.A.', '2-Jul-09', '1-Feb-19']
<class 'list'>
7
['The Elizabeth State Bank', 'Elizabeth', 'IL', '9262', 'Galena State Bank and Trust Company', '2-Jul-09', '10-May-18']
<class 'list'>
7
['Rock River Bank', 'Oregon', 'IL', '15302', 'The Harvard State Bank', '2-Jul-09', '9-May-18']
<class 'list'>
7
['First State Bank of Winchester', 'Winchester', 'IL', '11710', 'The First National Bank of Beardstown', '2-Jul-09', '1-Feb-19']
<class 'list'>
7
['John Warner Bank', 'Clinton', 'IL', '12093', 'State Bank of Lincoln', '2-Jul-09', '20-Aug-12']
<class 'list'>
7
['Mirae Bank', 'Los Angeles', 'CA', '57332', 'Wilshire State Bank', '26-Jun-09', '21-Feb-18']
<class 'list'>
7
['MetroPacific Bank', 'Irvine', 'CA', '57893', 'Sunwest Bank', '26-Jun-09', '5-Feb-15']
<class 'list'>
7
['Horizon Bank', 'Pine City', 'MN', '9744', 'Stearns Bank, N.A.', '26-Jun-09', '5-Feb-15']
<class 'list'>
7
['Neighborhood Community Bank', 'Newnan', 'GA', '35285', 'CharterBank', '26-Jun-09', '7-Dec-15']
<class 'list'>
7
['Community Bank of West Georgia', 'Villa Rica', 'GA', '57436', 'No Acquirer', '26-Jun-09', '31-Jan-19']
<class 'list'>
7
['First National Bank of Anthony', 'Anthony', 'KS', '4614', 'Bank of Kansas', '19-Jun-09', '21-Sep-15']
<class 'list'>
7
['Cooperative Bank', 'Wilmington', 'NC', '27837', 'First Bank', '19-Jun-09', '12-Mar-18']
<class 'list'>
7
['Southern Community Bank', 'Fayetteville', 'GA', '35251', 'United Community Bank', '19-Jun-09', '21-Sep-15']
<class 'list'>
7
['Bank of Lincolnwood', 'Lincolnwood', 'IL', '17309', 'Republic Bank of Chicago', '5-Jun-09', '31-Jan-19']
<class 'list'>
7
['Citizens National Bank', 'Macomb', 'IL', '5757', 'Morton Community Bank', '22-May-09', '1-Feb-19']
<class 'list'>
7
['Strategic Capital Bank', 'Champaign', 'IL', '35175', 'Midland States Bank', '22-May-09', '1-Feb-19']
<class 'list'>
7
['BankUnited, FSB', 'Coral Gables', 'FL', '32247', 'BankUnited', '21-May-09', '1-Feb-19']
<class 'list'>
7
['Westsound Bank', 'Bremerton', 'WA', '34843', 'Kitsap Bank', '8-May-09', '1-Feb-19']
<class 'list'>
7
['America West Bank', 'Layton', 'UT', '35461', 'Cache Valley Bank', '1-May-09', '1-Feb-19']
<class 'list'>
7
['Citizens Community Bank', 'Ridgewood', 'NJ', '57563', 'North Jersey Community Bank', '1-May-09', '1-Feb-19']
<class 'list'>
7
['Silverton Bank, NA', 'Atlanta', 'GA', '26535', 'No Acquirer', '1-May-09', '1-Feb-19']
<class 'list'>
7
['First Bank of Idaho', 'Ketchum', 'ID', '34396', 'U.S. Bank, N.A.', '24-Apr-09', '1-Feb-19']
<class 'list'>
7
['First Bank of Beverly Hills', 'Calabasas', 'CA', '32069', 'No Acquirer', '24-Apr-09', '31-Jan-19']
<class 'list'>
7
['Michigan Heritage Bank', 'Farmington Hills', 'MI', '34369', 'Level One Bank', '24-Apr-09', '31-Jan-19']
<class 'list'>
7
['American Southern Bank', 'Kennesaw', 'GA', '57943', 'Bank of North Georgia', '24-Apr-09', '1-Feb-19']
<class 'list'>
7
['Great Basin Bank of Nevada', 'Elko', 'NV', '33824', 'Nevada State Bank', '17-Apr-09', '10-Jul-18']
<class 'list'>
7
['American Sterling Bank', 'Sugar Creek', 'MO', '8266', 'Metcalf Bank', '17-Apr-09', '1-Feb-19']
<class 'list'>
7
['New Frontier Bank', 'Greeley', 'CO', '34881', 'No Acquirer', '10-Apr-09', '31-Jan-19']
<class 'list'>
7
['Cape Fear Bank', 'Wilmington', 'NC', '34639', 'First Federal Savings and Loan Association', '10-Apr-09', '10-Apr-17']
<class 'list'>
7
['Omni National Bank', 'Atlanta', 'GA', '22238', 'No Acquirer', '27-Mar-09', '31-Jan-19']
<class 'list'>
7
['TeamBank, NA', 'Paola', 'KS', '4754', 'Great Southern Bank', '20-Mar-09', '12-Sep-16']
<class 'list'>
7
['Colorado National Bank', 'Colorado Springs', 'CO', '18896', 'Herring Bank', '20-Mar-09', '12-Dec-16']
<class 'list'>
7
['FirstCity Bank', 'Stockbridge', 'GA', '18243', 'No Acquirer', '20-Mar-09', '1-Feb-19']
<class 'list'>
7
['Freedom Bank of Georgia', 'Commerce', 'GA', '57558', 'Northeast Georgia Bank', '6-Mar-09', '31-Jan-19']
<class 'list'>
7
['Security Savings Bank', 'Henderson', 'NV', '34820', 'Bank of Nevada', '27-Feb-09', '7-Sep-12']
<class 'list'>
7
['Heritage Community Bank', 'Glenwood', 'IL', '20078', 'MB Financial Bank, N.A.', '27-Feb-09', '17-Aug-12']
<class 'list'>
7
['Silver Falls Bank', 'Silverton', 'OR', '35399', 'Citizens Bank', '20-Feb-09', '1-Feb-19']
<class 'list'>
7
['Pinnacle Bank of Oregon', 'Beaverton', 'OR', '57342', 'Washington Trust Bank of Spokane', '13-Feb-09', '7-Dec-15']
<class 'list'>
7
['Corn Belt Bank & Trust Co.', 'Pittsfield', 'IL', '16500', 'The Carlinville National Bank', '13-Feb-09', '1-Feb-19']
<class 'list'>
7
['Riverside Bank of the Gulf Coast', 'Cape Coral', 'FL', '34563', 'TIB Bank', '13-Feb-09', '31-Jan-19']
<class 'list'>
7
['Sherman County Bank', 'Loup City', 'NE', '5431', 'Heritage Bank', '13-Feb-09', '17-Aug-12']
<class 'list'>
7
['County Bank', 'Merced', 'CA', '22574', 'Westamerica Bank', '6-Feb-09', '1-Feb-19']
<class 'list'>
7
['Alliance Bank', 'Culver City', 'CA', '23124', 'California Bank & Trust', '6-Feb-09', '8-Aug-18']
<class 'list'>
7
['FirstBank Financial Services', 'McDonough', 'GA', '57017', 'Regions Bank', '6-Feb-09', '1-Feb-19']
<class 'list'>
7
['Ocala National Bank', 'Ocala', 'FL', '26538', 'CenterState Bank of Florida, N.A.', '30-Jan-09', '31-Jan-19']
<class 'list'>
7
['Suburban FSB', 'Crofton', 'MD', '30763', 'Bank of Essex', '30-Jan-09', '4-Feb-16']
<class 'list'>
7
['MagnetBank', 'Salt Lake City', 'UT', '58001', 'No Acquirer', '30-Jan-09', '31-Jan-19']
<class 'list'>
7
['1st Centennial Bank', 'Redlands', 'CA', '33025', 'First California Bank', '23-Jan-09', '1-Feb-19']
<class 'list'>
7
['Bank of Clark County', 'Vancouver', 'WA', '34959', 'Umpqua Bank', '16-Jan-09', '31-Jan-19']
<class 'list'>
7
['National Bank of Commerce', 'Berkeley', 'IL', '19733', 'Republic Bank of Chicago', '16-Jan-09', '12-Mar-18']
<class 'list'>
7
['Sanderson State Bank', 'Sanderson', 'TX', '11568', 'The Pecos County State Bank', '12-Dec-08', '31-Jan-19']
<class 'list'>
7
['Haven Trust Bank', 'Duluth', 'GA', '35379', 'Branch Banking & Trust Company, (BB&T)', '12-Dec-08', '1-Feb-19']
<class 'list'>
7
['First Georgia Community Bank', 'Jackson', 'GA', '34301', 'United Bank', '5-Dec-08', '31-Jan-19']
<class 'list'>
7
['PFF Bank & Trust', 'Pomona', 'CA', '28344', 'U.S. Bank, N.A.', '21-Nov-08', '31-Jan-19']
<class 'list'>
7
['Downey Savings & Loan', 'Newport Beach', 'CA', '30968', 'U.S. Bank, N.A.', '21-Nov-08', '1-Feb-19']
<class 'list'>
7
['Community Bank', 'Loganville', 'GA', '16490', 'Bank of Essex', '21-Nov-08', '31-Jan-19']
<class 'list'>
7
['Security Pacific Bank', 'Los Angeles', 'CA', '23595', 'Pacific Western Bank', '7-Nov-08', '1-Feb-19']
<class 'list'>
7
['Franklin Bank, SSB', 'Houston', 'TX', '26870', 'Prosperity Bank', '7-Nov-08', '31-Jan-19']
<class 'list'>
7
['Freedom Bank', 'Bradenton', 'FL', '57930', 'Fifth Third Bank', '31-Oct-08', '31-Jan-19']
<class 'list'>
7
['Alpha Bank & Trust', 'Alpharetta', 'GA', '58241', 'Stearns Bank, N.A.', '24-Oct-08', '1-Feb-19']
<class 'list'>
7
['Meridian Bank', 'Eldred', 'IL', '13789', 'National Bank', '10-Oct-08', '31-May-12']
<class 'list'>
7
['Main Street Bank', 'Northville', 'MI', '57654', 'Monroe Bank & Trust', '10-Oct-08', '1-Aug-13']
<class 'list'>
7
['Washington Mutual Bank (Including its subsidiary Washington Mutual Bank FSB)', 'Henderson', 'NV', '32633', 'JP Morgan Chase Bank', '25-Sep-08', '1-Feb-19']
<class 'list'>
7
['Ameribank', 'Northfork', 'WV', '6782', 'The Citizens Savings Bank, Pioneer Community Bank, Inc.', '19-Sep-08', '21-Sep-15']
<class 'list'>
7
['Silver State Bank', 'Henderson', 'NV', '34194', 'Nevada State Bank', '5-Sep-08', '1-Feb-19']
<class 'list'>
7
['Integrity Bank', 'Alpharetta', 'GA', '35469', 'Regions Bank', '29-Aug-08', '31-Jan-19']
<class 'list'>
7
['Columbian Bank & Trust', 'Topeka', 'KS', '22728', 'Citizens Bank & Trust', '22-Aug-08', '31-Jan-19']
<class 'list'>
7
['First Priority Bank', 'Bradenton', 'FL', '57523', 'SunTrust Bank', '1-Aug-08', '12-Dec-16']
<class 'list'>
7
['First Heritage Bank, NA', 'Newport Beach', 'CA', '57961', 'Mutual of Omaha Bank', '25-Jul-08', '12-Sep-16']
<class 'list'>
7
['First National Bank of Nevada', 'Reno', 'NV', '27011', 'Mutual of Omaha Bank', '25-Jul-08', '31-Jan-19']
<class 'list'>
7
['IndyMac Bank', 'Pasadena', 'CA', '29730', 'OneWest Bank, FSB', '11-Jul-08', '1-Feb-19']
<class 'list'>
7
['First Integrity Bank, NA', 'Staples', 'MN', '12736', 'First International Bank and Trust', '30-May-08', '20-Oct-16']
<class 'list'>
7
['ANB Financial, NA', 'Bentonville', 'AR', '33901', 'Pulaski Bank and Trust Company', '9-May-08', '1-Feb-19']
<class 'list'>
7
['Hume Bank', 'Hume', 'MO', '1971', 'Security Bank', '7-Mar-08', '31-Jan-19']
<class 'list'>
7
['Douglass National Bank', 'Kansas City', 'MO', '24660', 'Liberty Bank and Trust Company', '25-Jan-08', '26-Oct-12']
<class 'list'>
7
['Miami Valley Bank', 'Lakeview', 'OH', '16848', 'The Citizens Banking Company', '4-Oct-07', '12-Sep-16']
<class 'list'>
7
['NetBank', 'Alpharetta', 'GA', '32575', 'ING DIRECT', '28-Sep-07', '31-Jan-19']
<class 'list'>
7
['Metropolitan Savings Bank', 'Pittsburgh', 'PA', '35353', 'Allegheny Valley Bank of Pittsburgh', '2-Feb-07', '27-Oct-10']
<class 'list'>
7
['Bank of Ephraim', 'Ephraim', 'UT', '1249', 'Far West Bank', '25-Jun-04', '9-Apr-08']
<class 'list'>
7
['Reliance Bank', 'White Plains', 'NY', '26778', 'Union State Bank', '19-Mar-04', '9-Apr-08']
<class 'list'>
7
['Guaranty National Bank of Tallahassee', 'Tallahassee', 'FL', '26838', 'Hancock Bank of Florida', '12-Mar-04', '17-Apr-18']
<class 'list'>
7
['Dollar Savings Bank', 'Newark', 'NJ', '31330', 'No Acquirer', '14-Feb-04', '9-Apr-08']
<class 'list'>
7
['Pulaski Savings Bank', 'Philadelphia', 'PA', '27203', 'Earthstar Bank', '14-Nov-03', '6-Oct-17']
<class 'list'>
7
['First National Bank of Blanchardville', 'Blanchardville', 'WI', '11639', 'The Park Bank', '9-May-03', '5-Jun-12']
<class 'list'>
7
['Southern Pacific Bank', 'Torrance', 'CA', '27094', 'Beal Bank', '7-Feb-03', '20-Oct-08']
<class 'list'>
7
['Farmers Bank of Cheneyville', 'Cheneyville', 'LA', '16445', 'Sabine State Bank & Trust', '17-Dec-02', '20-Oct-04']
<class 'list'>
7
['Bank of Alamo', 'Alamo', 'TN', '9961', 'No Acquirer', '8-Nov-02', '18-Mar-05']
<class 'list'>
7
['AmTrade International Bank', 'Atlanta', 'GA', '33784', 'No Acquirer', '30-Sep-02', '11-Sep-06']
<class 'list'>
7
['Universal Federal Savings Bank', 'Chicago', 'IL', '29355', 'Chicago Community Bank', '27-Jun-02', '6-Oct-17']
<class 'list'>
7
['Connecticut Bank of Commerce', 'Stamford', 'CT', '19183', 'Hudson United Bank', '26-Jun-02', '14-Feb-12']
<class 'list'>
7
['New Century Bank', 'Shelby Township', 'MI', '34979', 'No Acquirer', '28-Mar-02', '18-Mar-05']
<class 'list'>
7
['Net 1st National Bank', 'Boca Raton', 'FL', '26652', 'Bank Leumi USA', '1-Mar-02', '9-Apr-08']
<class 'list'>
7
['NextBank, NA', 'Phoenix', 'AZ', '22314', 'No Acquirer', '7-Feb-02', '5-Feb-15']
<class 'list'>
7