dharmatech · March 28, 2023 23:25
diff --git a/output.txt b/output.txt
 IDRSSD  NAME                                                   total_assets deposits  ui_dep ui_dep_pct     t1c ur_htm_afs_pct_t1c
 ------  ----                                                   ------------ --------  ------ ----------     --- ------------------
 37640   GERMAN AMERICAN BANK                                        6150272  5397813 2366667      43.84  651327                 51
 58243   JOHNSON BANK                                                6057275  5044657 2371907      47.02  793262                 12
 83638   AMERANT BANK, NATIONAL ASSOCIATION                          9101588  7103749 3329105      46.86  837970                 16
 114260  FIRST NATIONAL BANK ALASKA                                  5337737  4224857 1950610      46.17  553829                 37
 200378  BANC OF CALIFORNIA, NATIONAL ASSOCIATION                    9191646  7146819 4498347      62.94 1121049                 10
 229913  MIZUHO BANK (USA)                                           7003100  4538897 2599100      57.26 1511893                  0
 245276  ORIENTAL BANK                                               9709667  8580409 3497761      40.76  933494                 19
 260055  ALPINE BANK                                                 6312363  5538449 2326633      42.01  585358                 36
 317342  STOCK YARDS BANK & TRUST COMPANY                            7488838  6399935 2893446      45.21  667777                 29
 353555  AMARILLO NATIONAL BANK                                      8454890  7465642 3611216      48.37  790276                  5
 354310  UNIVEST BANK AND TRUST CO.                                  7207694  6043449 3306276      54.71  673256                 11
 361167  SOUTHSIDE BANK                                              7554150  6218269 2591578      41.68  823323                 32
 474254  BROADWAY NATIONAL BANK                                      5323235  4602097 2501339      54.35  514526                 51
 474759  SUNFLOWER BANK, NATIONAL ASSOCIATION                        7415263  5782542 2399424      41.49  748105                  9
 557858  INTRUST BANK, NATIONAL ASSOCIATION                          7454262  6726582 2770238      41.18  654062                 76
 599764  AMERICAN NATIONAL BANK OF TEXAS, THE                        5539254  4783454 2448617      51.19  457539                 88
 657365  HANMI BANK                                                  7348419  6178629 2653009      42.94  797608                 16
 661308  AMALGAMATED BANK                                            7856868  6609480 4522649      68.43  668864                 39
 663834  OCEAN BANK                                                  5916905  4791325 2009451      41.94  571192                 11
 667757  ORIGIN BANK                                                 9631077  7882619 4806379      60.97  952579                 21
 673440  FIRST SECURITY BANK                                         7517872  6201948 2713346      43.75 1313312                 25
 697763  WESTAMERICA BANK                                            6909609  6227401 2930183      47.05  592804                 68
 736206  CAMBRIDGE TRUST COMPANY                                     5559387  4831123 2500501      51.76  450305                 43
 739560  FREMONT BANK                                                5446634  4906788 2658097      54.17  424138                 15
 766164  TBK BANK, SSB                                               5331967  4263868 2009246      47.12  697022                  1
 783648  CENTIER BANK                                                6722761  5457761 2359073      43.22  692007                 16
 808260  FARMERS & MERCHANTS BANK OF CENTRAL CALIFORNIA              5328781  4762849 2324022      48.79  502838                 37
 811046  BANKERS TRUST COMPANY                                       6104235  4784715 3193060      66.73  605834                 21
 850036  FIRST AMERICAN BANK                                         6105252  4547802 2278479      50.10  432588                 52
 874845  LAKE CITY BANK                                              6412535  5461007 3068892      56.20  732966                 32
 932978  FIRSTRUST SAVINGS BANK                                      5175518  4211723 2038513      48.40  526139                 12
 991340  1ST SOURCE BANK                                             8334906  6928768 3302485      47.66  971294                 20
 1216321 REPUBLIC FIRST BANK DBA REPUBLIC BANK                       6034456  5013842 3204783      63.92  341442                126
 1883321 FIRST AMERICAN TRUST, FSB                                   6685012  6639061 6464015      97.36  613146                135
 1917301 LAKE FOREST BANK & TRUST COMPANY, NATIONAL ASSOCIATION      7602722  5699287 2877980      50.50  689320                 25
 1918344 PREFERRED BANK                                              6425969  5558803 4449015      80.04  656658                  6
 2209553 HERITAGE BANK OF COMMERCE                                   5152676  4410578 2831613      64.20  492725                 24
 2239288 WINTRUST BANK, NATIONAL ASSOCIATION                         9659979  8366530 4514569      53.96 1004271                  9
 2654911 PRINCIPAL BANK                                              8389661  8100092 3603843      44.49  629843                115
 2705895 METROPOLITAN COMMERCIAL BANK                                6265921  5302821 2166223      40.85  628823                 26
 3232204 POPPY BANK                                                  5315215  4063140 1753722      43.16  520641                 13
 3317932 CONNECTONE BANK                                             9640575  7473783 4000000      53.52  996013                  9
 3465226 HTLF BANK                                                   9178296  7965003 3757163      47.17  762103                 39
 3594005 CROSSFIRST BANK                                             6596702  5654988 2449506      43.32  643837                 13
 3783313 CROSS RIVER BANK                                            9155151  5726757 2384761      41.64 1069781                  1
	IDRSSD NAME total_assets deposits ui_dep ui_dep_pct t1c ur_htm_afs_pct_t1c
	------ ---- ------------ -------- ------ ---------- --- ------------------
	37640 GERMAN AMERICAN BANK 6150272 5397813 2366667 43.84 651327 51
	58243 JOHNSON BANK 6057275 5044657 2371907 47.02 793262 12
	83638 AMERANT BANK, NATIONAL ASSOCIATION 9101588 7103749 3329105 46.86 837970 16
	114260 FIRST NATIONAL BANK ALASKA 5337737 4224857 1950610 46.17 553829 37
	200378 BANC OF CALIFORNIA, NATIONAL ASSOCIATION 9191646 7146819 4498347 62.94 1121049 10
	229913 MIZUHO BANK (USA) 7003100 4538897 2599100 57.26 1511893 0
	245276 ORIENTAL BANK 9709667 8580409 3497761 40.76 933494 19
	260055 ALPINE BANK 6312363 5538449 2326633 42.01 585358 36
	317342 STOCK YARDS BANK & TRUST COMPANY 7488838 6399935 2893446 45.21 667777 29
	353555 AMARILLO NATIONAL BANK 8454890 7465642 3611216 48.37 790276 5
	354310 UNIVEST BANK AND TRUST CO. 7207694 6043449 3306276 54.71 673256 11
	361167 SOUTHSIDE BANK 7554150 6218269 2591578 41.68 823323 32
	474254 BROADWAY NATIONAL BANK 5323235 4602097 2501339 54.35 514526 51
	474759 SUNFLOWER BANK, NATIONAL ASSOCIATION 7415263 5782542 2399424 41.49 748105 9
	557858 INTRUST BANK, NATIONAL ASSOCIATION 7454262 6726582 2770238 41.18 654062 76
	599764 AMERICAN NATIONAL BANK OF TEXAS, THE 5539254 4783454 2448617 51.19 457539 88
	657365 HANMI BANK 7348419 6178629 2653009 42.94 797608 16
	661308 AMALGAMATED BANK 7856868 6609480 4522649 68.43 668864 39
	663834 OCEAN BANK 5916905 4791325 2009451 41.94 571192 11
	667757 ORIGIN BANK 9631077 7882619 4806379 60.97 952579 21
	673440 FIRST SECURITY BANK 7517872 6201948 2713346 43.75 1313312 25
	697763 WESTAMERICA BANK 6909609 6227401 2930183 47.05 592804 68
	736206 CAMBRIDGE TRUST COMPANY 5559387 4831123 2500501 51.76 450305 43
	739560 FREMONT BANK 5446634 4906788 2658097 54.17 424138 15
	766164 TBK BANK, SSB 5331967 4263868 2009246 47.12 697022 1
	783648 CENTIER BANK 6722761 5457761 2359073 43.22 692007 16
	808260 FARMERS & MERCHANTS BANK OF CENTRAL CALIFORNIA 5328781 4762849 2324022 48.79 502838 37
	811046 BANKERS TRUST COMPANY 6104235 4784715 3193060 66.73 605834 21
	850036 FIRST AMERICAN BANK 6105252 4547802 2278479 50.10 432588 52
	874845 LAKE CITY BANK 6412535 5461007 3068892 56.20 732966 32
	932978 FIRSTRUST SAVINGS BANK 5175518 4211723 2038513 48.40 526139 12
	991340 1ST SOURCE BANK 8334906 6928768 3302485 47.66 971294 20
	1216321 REPUBLIC FIRST BANK DBA REPUBLIC BANK 6034456 5013842 3204783 63.92 341442 126
	1883321 FIRST AMERICAN TRUST, FSB 6685012 6639061 6464015 97.36 613146 135
	1917301 LAKE FOREST BANK & TRUST COMPANY, NATIONAL ASSOCIATION 7602722 5699287 2877980 50.50 689320 25
	1918344 PREFERRED BANK 6425969 5558803 4449015 80.04 656658 6
	2209553 HERITAGE BANK OF COMMERCE 5152676 4410578 2831613 64.20 492725 24
	2239288 WINTRUST BANK, NATIONAL ASSOCIATION 9659979 8366530 4514569 53.96 1004271 9
	2654911 PRINCIPAL BANK 8389661 8100092 3603843 44.49 629843 115
	2705895 METROPOLITAN COMMERCIAL BANK 6265921 5302821 2166223 40.85 628823 26
	3232204 POPPY BANK 5315215 4063140 1753722 43.16 520641 13
	3317932 CONNECTONE BANK 9640575 7473783 4000000 53.52 996013 9
	3465226 HTLF BANK 9178296 7965003 3757163 47.17 762103 39
	3594005 CROSSFIRST BANK 6596702 5654988 2449506 43.32 643837 13
	3783313 CROSS RIVER BANK 9155151 5726757 2384761 41.64 1069781 1
No results found