Skip to content

Instantly share code, notes, and snippets.

@dharmatech

dharmatech/cre-loans.csv

Created March 27, 2023 04:33
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save dharmatech/2e0a7f1eff89505f406d3e7198cf2a22 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save dharmatech/2e0a7f1eff89505f406d3e7198cf2a22 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
cre-loans.csv
IDRSSD NAME deposits uninsured_deposits uninsured_deposits_percent tier_1_capital htm_unrealized_loss afs_unrealized_loss htm_afs_ul_t1c cre_loans avg_tangible_eq_for_cal_qtr cre_loans_pct_avg_tan_eq
595869 CATHAY BANK 18336332 9207120 50.21 2276830 0 148826 6.54 8828591 2260216 391
83638 AMERANT BANK, NATIONAL ASSOCIATION 7103749 3329105 46.86 837970 24492 111956 16.28 2612240 840305 311
208244 OLD NATIONAL BANK 35436005 11985337 33.82 3817402 445463 997706 37.81 10910414 3742967 291
491224 FIRST-CITIZENS BANK & TRUST COMPANY 89536663 29133533 32.54 10186073 1484730 971802 24.12 24375541 10123318 241
197478 EAST WEST BANK 53225764 35051904 65.86 6252421 546697 844232 22.25 13919368 6158998 226
980661 FIRST HAWAIIAN BANK 19932845 11073575 55.55 1895693 505817 398466 47.70 4132309 1866670 221
795968 BANK OF HAWAII 19474651 10789602 55.40 1704570 798504 327614 66.06 3725542 1689949 220
501105 MANUFACTURERS AND TRADERS TRUST COMPANY 165947339 79357151 47.82 16673578 1154549 443274 9.58 36617521 16687676 219
4114567 FIRST REPUBLIC BANK 176436706 119470758 67.71 17552503 4771404 469998 29.86 33492556 17426936 192
936855 UMB BANK, NATIONAL ASSOCIATION 32829617 24657778 75.11 3184837 580940 771604 42.47 6092330 3167029 192
2193616 RAYMOND JAMES BANK 38461530 2378097 6.18 3188667 0 1025969 32.18 5815052 3122207 186
761806 WEBSTER BANK, NATIONAL ASSOCIATION 54363251 22546130 41.47 6661504 803426 864458 25.04 11411782 6529027 175
60143 COMERICA BANK 72806000 45492000 62.48 7801000 0 3033000 38.88 13306000 7799000 171
510871 FIRSTBANK PUERTO RICO 15980677 7605113 47.59 2190832 10422 798677 36.93 3112583 2154059 144
722777 SANTANDER BANK, NATIONAL ASSOCIATION 76009038 27873261 36.67 10888687 1183245 881714 18.96 14081337 10645738 132
12311 HUNTINGTON NATIONAL BANK, THE 151720663 84586841 55.75 15334191 2297384 4529055 44.52 17930670 14559089 123
3303298 CITIZENS BANK, NATIONAL ASSOCIATION 182871182 88882682 48.60 20669014 792352 2451525 15.69 23631676 20452223 116
940311 BANCO POPULAR DE PUERTO RICO 52802000 28091000 53.20 4231000 86000 1670000 41.50 4597000 4185000 110
280110 KEYBANK NATIONAL ASSOCIATION 145991717 75563348 51.76 16801412 596738 6436507 41.86 16352397 16710150 98
3783313 CROSS RIVER BANK 5726757 2384761 41.64 1069781 7025 5790 1.20 987692 1090128 91
233031 REGIONS BANK 133792000 49317000 36.86 13509000 50000 3433000 25.78 11813000 13257000 89
451965 WELLS FARGO BANK, NATIONAL ASSOCIATION 1399274000 721102000 51.53 140644000 41623000 7543000 34.96 124488000 140776000 88
1917301 LAKE FOREST BANK & TRUST COMPANY, NATIONAL ASSOCIATION 5699287 2877980 50.50 689320 108640 66528 25.41 532766 685045 78
817824 PNC BANK, NATIONAL ASSOCIATION 441663089 200038825 45.29 43657609 4903650 4547051 21.65 30259062 43509571 70
504713 U.S. BANK NATIONAL ASSOCIATION 453331532 234335742 51.69 47126871 10847669 8397884 40.84 29827582 46004149 65
723112 FIFTH THIRD BANK, NATIONAL ASSOCIATION 169348160 88345349 52.17 18952302 0 6026806 31.80 10545297 18683303 56
852320 TRUIST BANK 424773000 189579000 44.63 45237000 9922000 12231000 48.97 22676000 44737000 51
2489805 MORGAN STANLEY PRIVATE BANK, NATIONAL ASSOCIATION 192265000 57280000 29.79 15546000 5410000 1339000 43.41 6414000 15721000 41
1456501 MORGAN STANLEY BANK, N.A. 177356000 54005000 30.45 20043000 3648000 3058000 33.46 8035000 19515000 41
852218 JPMORGAN CHASE BANK, NATIONAL ASSOCIATION 2014513000 1057867000 52.51 269672000 36725000 10312000 17.44 100686000 265484000 38
210434 NORTHERN TRUST COMPANY, THE 50357882 41851771 83.11 10111200 2156763 1060244 31.82 3878785 10371168 37
480228 BANK OF AMERICA, NATIONAL ASSOCIATION 1929333000 909261000 47.13 181089000 108563000 3918000 62.11 60344000 184525000 33
413208 HSBC BANK USA, NATIONAL ASSOCIATION 129790483 94150714 72.54 17992150 454961 2989973 19.15 5659895 19285458 29
3284070 ALLY BANK 156058000 18881000 12.10 17011000 177000 4759000 29.02 4910000 16827000 29
934329 BNY MELLON, NATIONAL ASSOCIATION 26434000 17851000 67.53 2177000 0 15000 0.69 492000 2256000 22
802866 SILICON VALLEY BANK 161479000 151592000 93.88 16995000 15159000 2526000 104.06 3595000 17120000 21
541101 BANK OF NEW YORK MELLON, THE 181486000 175097000 96.48 20221000 6200000 6064000 60.65 3767000 20017000 19
2182786 GOLDMAN SACHS BANK USA 352005000 167986000 47.72 46845000 215000 2000000 4.73 7741000 46341000 17
35301 STATE STREET BANK AND TRUST COMPANY 163284000 148917000 91.20 18273000 6788000 1280000 44.15 2985000 18905000 16
476810 CITIBANK, N.A. 777024000 598195000 76.99 151720000 24953000 5060000 19.78 17746000 150275000 12
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment