bank.id,bank.ts,bank.title,bank.name,bank.street_address,bank.locality,bank.region,bank.postal_code,bank.county,bank.phone,bank.fdic_cert,bank.established,bank.concentration,bank.fdic_insurance,bank.holden_by,bank.charter_class,bank.website,bank.total_assets,bank.total_deposits,bank.total_equity_capital,bank.total_domestic_office_deposits,bank.net_income,bank.quarterly_net_income,bank.return_on_assets,bank.quarterly_return_on_assets,bank.return_on_equity,bank.quarterly_return_on_equity,bank.category_1_x_bank_id
21,"2017-07-31 04:19:15","1st Bank Yuma, Yuma Branch","1st Bank Yuma, Yuma Branch","1800 S 4th Ave",Yuma,AZ,85364,"Yuma County",928-344-8822,#57298,2007-09-04,"Commercial Lending Specialization",2001-09-04,"Western Arizona Bancorp, Inc.","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",http://www.1stbankyuma.com,"$301,049,000","$267,347,000","$31,843,000","$267,347,000","$1,007,000","$1,007,000",1%,1%,13%,13%,"{
    ""21"": {
        ""category_1_x_bank.id"": 21,
        ""category_1.id"": 7,
        ""category_1.ts"": ""2017-07-30 23:28:40"",
        ""category_1.title"": ""1st Bank Yuma""
    }
}"
22,"2017-07-31 04:19:16","1st Cameron State Bank","1st Cameron State Bank","124 South Walnut",Cameron,MO,64429,"Clinton County",816-632-7272,#32487,1986-08-11,"All Other Specialization < 1 Billion",1986-08-11,"C & M Bancshares, Inc.","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stcameron.com,"$63,865,000","$44,837,000","$4,888,000","$44,837,000","$25,000","$25,000",,,2%,2%,"{
    ""22"": {
        ""category_1_x_bank.id"": 22,
        ""category_1.id"": 8,
        ""category_1.ts"": ""2017-07-30 23:28:47"",
        ""category_1.title"": ""1st Cameron State Bank""
    }
}"
23,"2017-07-31 04:19:21","1st Cameron State Bank, Platte-Clay Way Branch","1st Cameron State Bank, Platte-Clay Way Branch","515 East Platte Clay Way",Cameron,MO,64429,"Clinton County",816-632-5232,#32487,1997-10-06,"All Other Specialization < 1 Billion",1986-08-11,"C & M Bancshares, Inc.","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stcameron.com,"$63,865,000","$44,837,000","$4,888,000","$44,837,000","$25,000","$25,000",,,2%,2%,"{
    ""23"": {
        ""category_1_x_bank.id"": 23,
        ""category_1.id"": 8,
        ""category_1.ts"": ""2017-07-30 23:28:47"",
        ""category_1.title"": ""1st Cameron State Bank""
    }
}"
24,"2017-07-31 04:19:22","1st Capital Bank","1st Capital Bank","5 Harris Court, Building N, Suite #3",Monterey,CA,93940,"Monterey County",831-264-4000,#58485,2007-04-16,"Commercial Lending Specialization",2007-04-16,,"Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stcapital.bank,"$553,488,000","$503,419,000","$48,785,000","$503,419,000","$787,000","$787,000",1%,1%,7%,7%,"{
    ""24"": {
        ""category_1_x_bank.id"": 24,
        ""category_1.id"": 9,
        ""category_1.ts"": ""2017-07-30 23:28:52"",
        ""category_1.title"": ""1st Capital Bank""
    }
}"
25,"2017-07-31 04:19:27","1st Capital Bank, King City Branch","1st Capital Bank, King City Branch","432 Broadway","King City",CA,93930,"Monterey County",831-385-8900,#58485,2008-11-03,"Commercial Lending Specialization",2007-04-16,,"Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stcapital.bank,"$553,488,000","$503,419,000","$48,785,000","$503,419,000","$787,000","$787,000",1%,1%,7%,7%,"{
    ""25"": {
        ""category_1_x_bank.id"": 25,
        ""category_1.id"": 9,
        ""category_1.ts"": ""2017-07-30 23:28:52"",
        ""category_1.title"": ""1st Capital Bank""
    }
}"
26,"2017-07-31 04:19:34","1st Capital Bank, Monterey Branch","1st Capital Bank, Monterey Branch","300 Bonifacio Place",Monterey,CA,93940,"Monterey County",831-264-4070,#58485,2007-04-16,"Commercial Lending Specialization",2007-04-16,,"Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stcapital.bank,"$553,488,000","$503,419,000","$48,785,000","$503,419,000","$787,000","$787,000",1%,1%,7%,7%,"{
    ""26"": {
        ""category_1_x_bank.id"": 26,
        ""category_1.id"": 9,
        ""category_1.ts"": ""2017-07-30 23:28:52"",
        ""category_1.title"": ""1st Capital Bank""
    }
}"
27,"2017-07-31 04:19:40","1st Capital Bank, San Luis Obispo Branch","1st Capital Bank, San Luis Obispo Branch","142 Cross Street, Suite 130","San Luis Obispo",CA,93401,"San Luis Obispo County",,#58485,2015-06-02,"Commercial Lending Specialization",2007-04-16,,"Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stcapital.bank,"$553,488,000","$503,419,000","$48,785,000","$503,419,000","$787,000","$787,000",1%,1%,7%,7%,"{
    ""27"": {
        ""category_1_x_bank.id"": 27,
        ""category_1.id"": 9,
        ""category_1.ts"": ""2017-07-30 23:28:52"",
        ""category_1.title"": ""1st Capital Bank""
    }
}"
28,"2017-07-31 04:19:45","1st Capital Bank, South Main Street Branch","1st Capital Bank, South Main Street Branch","1097 South Main Street",Salinas,CA,93901,"Monterey County",831-540-4080,#58485,2007-04-16,"Commercial Lending Specialization",2007-04-16,,"Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stcapital.bank,"$553,488,000","$503,419,000","$48,785,000","$503,419,000","$787,000","$787,000",1%,1%,7%,7%,"{
    ""28"": {
        ""category_1_x_bank.id"": 28,
        ""category_1.id"": 9,
        ""category_1.ts"": ""2017-07-30 23:28:52"",
        ""category_1.title"": ""1st Capital Bank""
    }
}"
29,"2017-07-31 04:19:46","1st Colonial Community Bank","1st Colonial Community Bank","1040 Haddon Avenue",Collingswood,NJ,08108,"Camden County",856-858-1100,#35456,2000-06-29,"Commercial Lending Specialization",2000-06-29,"1st Colonial Bancorp, Inc.","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",http://www.1stcolonial.com,"$503,368,000","$463,319,000","$34,765,000","$463,319,000","$1,014,000","$1,014,000",1%,1%,12%,12%,"{
    ""29"": {
        ""category_1_x_bank.id"": 29,
        ""category_1.id"": 10,
        ""category_1.ts"": ""2017-07-30 23:28:58"",
        ""category_1.title"": ""1st Colonial Community Bank""
    }
}"
30,"2017-07-31 04:19:50","1st Colonial Community Bank, 1st Colonial Messenger Branch","1st Colonial Community Bank, 1st Colonial Messenger Branch","1040 Haddon Avenue",Camden,NJ,08103,"Camden County",856-858-1100,#35456,2003-08-04,"Commercial Lending Specialization",2000-06-29,"1st Colonial Bancorp, Inc.","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",http://www.1stcolonial.com,"$503,368,000","$463,319,000","$34,765,000","$463,319,000","$1,014,000","$1,014,000",1%,1%,12%,12%,"{
    ""30"": {
        ""category_1_x_bank.id"": 30,
        ""category_1.id"": 10,
        ""category_1.ts"": ""2017-07-30 23:28:58"",
        ""category_1.title"": ""1st Colonial Community Bank""
    }
}"
31,"2017-07-31 04:20:00","1st Colonial Community Bank, Westville Branch","1st Colonial Community Bank, Westville Branch","321 Broadway",Westville,NJ,08093,"Gloucester County",856-456-7899,#35456,2003-01-17,"Commercial Lending Specialization",2000-06-29,"1st Colonial Bancorp, Inc.","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",http://www.1stcolonial.com,"$503,368,000","$463,319,000","$34,765,000","$463,319,000","$1,014,000","$1,014,000",1%,1%,12%,12%,"{
    ""31"": {
        ""category_1_x_bank.id"": 31,
        ""category_1.id"": 10,
        ""category_1.ts"": ""2017-07-30 23:28:58"",
        ""category_1.title"": ""1st Colonial Community Bank""
    }
}"
32,"2017-07-31 04:20:06","1st Community Bank","1st Community Bank","407 Third Street",Sherrard,IL,61281,"Mercer County",309-593-2117,#11706,1910-01-01,"Agricultural Specialization",1934-01-01,"Illinois Holding Co.","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",http://www.1stcommunitybanks.com,"$64,944,000","$58,628,000","$6,160,000","$58,628,000","$53,000","$53,000",,,3%,3%,"{
    ""32"": {
        ""category_1_x_bank.id"": 32,
        ""category_1.id"": 11,
        ""category_1.ts"": ""2017-07-30 23:29:02"",
        ""category_1.title"": ""1st Community Bank""
    }
}"
33,"2017-07-31 04:20:16","1st Community Bank, Aledo Facility","1st Community Bank, Aledo Facility","East Route 17 And Highways 94 And 17",Aledo,IL,61231,"Mercer County",309-582-3531,#11706,1988-03-10,"Agricultural Specialization",1934-01-01,"Illinois Holding Co.","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",http://www.1stcommunitybanks.com,"$64,944,000","$58,628,000","$6,160,000","$58,628,000","$53,000","$53,000",,,3%,3%,"{
    ""33"": {
        ""category_1_x_bank.id"": 33,
        ""category_1.id"": 11,
        ""category_1.ts"": ""2017-07-30 23:29:02"",
        ""category_1.title"": ""1st Community Bank""
    }
}"
34,"2017-07-31 04:20:23","1st Constitution Bank","1st Constitution Bank","2650 Route 130",Cranbury,NJ,08512,"Middlesex County",609-655-4500,#27552,1989-07-24,"Commercial Lending Specialization",1989-07-24,"1st Constitution Bancorp","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stconstitution.com,"$1,009,864,000","$869,315,000","$122,097,000","$869,315,000","$2,028,000","$2,028,000",1%,1%,7%,7%,"{
    ""34"": {
        ""category_1_x_bank.id"": 34,
        ""category_1.id"": 12,
        ""category_1.ts"": ""2017-07-30 23:29:10"",
        ""category_1.title"": ""1st Constitution Bank""
    }
}"
35,"2017-07-31 04:20:24","1st Constitution Bank, Asbury Park Branch","1st Constitution Bank, Asbury Park Branch","511 Cookman Avenue","Asbury Park",NJ,07712,"Monmouth County",732-775-1079,#27552,2009-01-30,"Commercial Lending Specialization",1989-07-24,"1st Constitution Bancorp","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stconstitution.com,"$1,009,864,000","$869,315,000","$122,097,000","$869,315,000","$2,028,000","$2,028,000",1%,1%,7%,7%,"{
    ""35"": {
        ""category_1_x_bank.id"": 35,
        ""category_1.id"": 12,
        ""category_1.ts"": ""2017-07-30 23:29:10"",
        ""category_1.title"": ""1st Constitution Bank""
    }
}"
36,"2017-07-31 04:20:28","1st Constitution Bank, Cranbury Village Branch","1st Constitution Bank, Cranbury Village Branch","74 North Main Street",Cranbury,NJ,08512,"Middlesex County",609-395-0605,#27552,1927-01-01,"Commercial Lending Specialization",1989-07-24,"1st Constitution Bancorp","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stconstitution.com,"$1,009,864,000","$869,315,000","$122,097,000","$869,315,000","$2,028,000","$2,028,000",1%,1%,7%,7%,"{
    ""36"": {
        ""category_1_x_bank.id"": 36,
        ""category_1.id"": 12,
        ""category_1.ts"": ""2017-07-30 23:29:10"",
        ""category_1.title"": ""1st Constitution Bank""
    }
}"
37,"2017-07-31 04:20:30","1st Constitution Bank, Fair Haven Branch","1st Constitution Bank, Fair Haven Branch","636 River Road","Fair Haven",NJ,07704,"Monmouth County",732-345-1100,#27552,2002-01-29,"Commercial Lending Specialization",1989-07-24,"1st Constitution Bancorp","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stconstitution.com,"$1,009,864,000","$869,315,000","$122,097,000","$869,315,000","$2,028,000","$2,028,000",1%,1%,7%,7%,"{
    ""37"": {
        ""category_1_x_bank.id"": 37,
        ""category_1.id"": 12,
        ""category_1.ts"": ""2017-07-30 23:29:10"",
        ""category_1.title"": ""1st Constitution Bank""
    }
}"
38,"2017-07-31 04:20:31","1st Constitution Bank, Fort Lee Branch","1st Constitution Bank, Fort Lee Branch","180 Main Street","Fort Lee",NJ,07024,"Bergen County",201-944-9300,#27552,2004-01-01,"Commercial Lending Specialization",1989-07-24,"1st Constitution Bancorp","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stconstitution.com,"$1,009,864,000","$869,315,000","$122,097,000","$869,315,000","$2,028,000","$2,028,000",1%,1%,7%,7%,"{
    ""38"": {
        ""category_1_x_bank.id"": 38,
        ""category_1.id"": 12,
        ""category_1.ts"": ""2017-07-30 23:29:10"",
        ""category_1.title"": ""1st Constitution Bank""
    }
}"
39,"2017-07-31 04:20:36","1st Constitution Bank, Hamilton Branch","1st Constitution Bank, Hamilton Branch","3659 Nottingham Way",Trenton,NJ,08690,"Mercer County",609-631-0400,#27552,1999-07-19,"Commercial Lending Specialization",1989-07-24,"1st Constitution Bancorp","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stconstitution.com,"$1,009,864,000","$869,315,000","$122,097,000","$869,315,000","$2,028,000","$2,028,000",1%,1%,7%,7%,"{
    ""39"": {
        ""category_1_x_bank.id"": 39,
        ""category_1.id"": 12,
        ""category_1.ts"": ""2017-07-30 23:29:10"",
        ""category_1.title"": ""1st Constitution Bank""
    }
}"
40,"2017-07-31 04:20:38","1st Constitution Bank, Hightstown Branch","1st Constitution Bank, Hightstown Branch","140 Mercer Street",Hightstown,NJ,08520,"Mercer County",609-918-1283,#27552,2007-02-27,"Commercial Lending Specialization",1989-07-24,"1st Constitution Bancorp","Commercial bank, state charter and Fed nonmember, supervised by the FDIC",www.1stconstitution.com,"$1,009,864,000","$869,315,000","$122,097,000","$869,315,000","$2,028,000","$2,028,000",1%,1%,7%,7%,"{
    ""40"": {
        ""category_1_x_bank.id"": 40,
        ""category_1.id"": 12,
        ""category_1.ts"": ""2017-07-30 23:29:10"",
        ""category_1.title"": ""1st Constitution Bank""
    }
}"