Explore

Want to check a number yourself?

The warehouse's published marts load into DuckDB running in your browser. Nothing is sent anywhere: the queries run on this machine against the same aggregates the pages are drawn from. No customer level table is published.

Tables

36 rows
- month string
- month_index int32
- quarter string
- year int64
- cash double
- securities double
- loans_installment double
- loans_card double
- loans_mortgage double
- total_loans double
- allowance double
- total_assets double
- deposits_checking double
- deposits_savings double
- deposits_time double
- total_deposits double
- borrowings double
- total_liabilities double
- total_equity double
- earning_assets double
- interest_income_loans double
- interest_income_securities double
- interest_expense_deposits double
- interest_expense_borrowings double
- noninterest_income double
- provision double
- noninterest_expense double
- tax double
- net_income double
- nonperforming_loans double
235 rows
- vintage string
- months_on_book int64
- loans int64
- principal double
- cumulative_defaults double
- cumulative_default_rate double
379 rows
- month string
- from_bucket string
- to_bucket string
- loans int64
- balance double
- rate double
108 rows
- product string
- month string
- month_index int32
- open_loans int64
- balance double
- balance_30_plus double
- balance_90_plus double
- charge_offs double
- recoveries double
- interest double
108 rows
- product string
- month string
- month_index int32
- accounts int64
- balance double
- opened int64
- closed int64
5,871 rows
- cert int64
- name string
- state string
- report_date date32[day]
- quarter string
- total_assets_thousands int64
- deposits_thousands int64
- net_loans_thousands int64
- equity_thousands int64
- nim_pct double
- efficiency_ratio_pct double
- roa_pct double
- roe_pct double
- noncurrent_loans_pct double
- net_charge_offs_pct double
- allowance_to_loans_pct double
- total_risk_based_capital_pct double
- tier1_to_average_assets_pct double
- loans_to_deposits double
792 rows
- gl_account string
- month string
- month_index int32
- postings int64
- posted double
- balance_from_postings double
- reported_balance double
116 rows
- month string
- unemployment_us double
- cpi_u double
- unemployment_nj double
- treasury_3m double
- treasury_2y double
- treasury_10y double
- fed_funds_effective double
- hpi_us_sa double
70 rows
- scenario string
- quarter string
- unemployment_rate double
- real_gdp_growth double
- house_price_index double
- treasury_3m double
- treasury_10y double
- mortgage_rate double
- bbb_yield double
- cpi_inflation double

SQL, DuckDB dialect. Ctrl or Cmd and Enter runs it.

Loading DuckDB in your browser…