Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

236 kB across 1 part, newest sealed 14 November 2026 at 04:55 UTC. The first build wrote 1 part and 4,210 rows.

All 2 checks passed.
  • One row per action passed.
  • Rows present passed.

action_id

string

Stable identifier of the action, a hash of the regulator, institution, action type, date and docket.

4,210 distinct values, no chart

Valid
4,210 · 100%
Missing
0 · 0%
Distinct
4,210 · 100% of valid

regulator

string

The agency that took the action: OCC or Federal Reserve.

  • OCC63%
  • Federal Reserve37%
Valid
4,210 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

institution_name

string

The bank or holding company named in the action.

3,020 distinct values, no chart

Valid
4,210 · 100%
Missing
0 · 0%
Distinct
3,020 · 71.7% of valid

city

string

City of the institution as the regulator wrote it.

1,624 distinct values, no chart

Valid
4,169 · 99%
Missing
41 · 1%
Missing over timeMissing share of city over time, 0% to 16%.
Distinct
1,624 · 39% of valid

state

string

Two-letter state of the institution.

  • TX9%
  • CA8%
  • FL7%
  • Other (41)
Valid
3,616 · 85.9%
Missing
594 · 14.1%
Missing over timeMissing share of state over time, 0% to 62%.
Distinct
53 · 1.5% of valid

cert

integer

FDIC certificate number of the bank, joining to bank_quarter_financials. Null for holding companies and unmatched names.

1,513 distinct values, no chart

Valid
2,510 · 59.6%
Missing
1,700 · 40.4%
Missing over timeMissing share of cert over time, 0% to 76%.
Distinct
1,513 · 60.3% of valid
Min
91
25%
6335
Median
22092
75%
29577
Max
91280

cert_match_method

string

How the certificate was found: OCC charter number, savings association docket number, or exact name, city and state.

  • OCC charter number86%
  • name, city and state7%
  • savings association docket number6%
Valid
2,510 · 59.6%
Missing
1,700 · 40.4%
Missing over timeMissing share of cert_match_method over time, 0% to 76%.
Distinct
3 · 0.1% of valid

action_type_code

string

OCC's short code for the action type.

10 distinct values, no chart

Valid
2,649 · 62.9%
Missing
1,561 · 37.1%
Missing over timeMissing share of action_type_code over time, 0% to 66%.
Distinct
10 · 0.4% of valid

action_type

string

Type of action, such as cease and desist order, written agreement, formal agreement or civil money penalty.

  • Formal Agreement30%
  • Written Agreement22%
  • Cease-and-Desist Order (C&D) or Personal Cease-and-Desist Order (PC&D)20%
  • Other (215)
Valid
4,210 · 100%
Missing
0 · 0%
Distinct
227 · 5.4% of valid

penalty_usd

integer

Civil money penalty in US dollars, zero or null when the action carried none.

Histogram: 0 to 140931657, 2,810; 140931658 to 281863315, 19; 281863316 to 422794973, 13; 422794974 to 563726630, 5; 563726631 to 704658288, 0; 704658289 to 845589946, 2; 845589947 to 986521604, 0; 986521605 to 1127453261, 1
01127453261
Valid
2,850 · 67.7%
Missing
1,360 · 32.3%
Missing over timeMissing share of penalty_usd over time, 0% to 54%.
Distinct
312 · 10.9% of valid
Min
0
25%
0
Median
0
75%
0
Max
1127453261

started_on

date

Date the action took effect.

2,580 distinct values, no chart

Valid
4,210 · 100%
Missing
0 · 0%
Distinct
2,580 · 61.3% of valid

terminated_on

date

Date the regulator terminated the action. Null while it is open.

2,341 distinct values, no chart

Valid
3,430 · 81.5%
Missing
780 · 18.5%
Missing over timeMissing share of terminated_on over time, 0% to 85%.
Distinct
2,341 · 68.3% of valid

is_open

boolean

Whether the action has no termination date.

  • false81%
  • true19%
Valid
4,210 · 100%
Missing
0 · 0%
Distinct
2 · 0% of valid

docket_number

string

OCC docket number of the action.

715 distinct values, no chart

Valid
880 · 20.9%
Missing
3,330 · 79.1%
Missing over timeMissing share of docket_number over time, 33% to 100%.
Distinct
715 · 81.3% of valid

stated_subjects

string

Subject matters the OCC itself lists for the action, separated by semicolons.

407 distinct values, no chart

Valid
636 · 15.1%
Missing
3,574 · 84.9%
Missing over timeMissing share of stated_subjects over time, 32% to 100%.
Distinct
407 · 64% of valid

cause

string

Main reason for the action in one of six groups, or other or unclear when the model found none fits. Taken from the regulator's subject list where it has one, otherwise a label from the model gemini-decision-1 reading the order or press release.

  • other or unclear35%
  • capital, asset quality or liquidity33%
  • consumer protection or fair lending12%
Valid
2,683 · 63.7%
Missing
1,527 · 36.3%
Missing over timeMissing share of cause over time, 0% to 100%.
Distinct
7 · 0.3% of valid

cause_source

string

Where the cause came from: regulator subject list, or model.

  • model77%
  • regulator subject list23%
Valid
2,683 · 63.7%
Missing
1,527 · 36.3%
Missing over timeMissing share of cause_source over time, 0% to 100%.
Distinct
2 · 0.1% of valid

cause_probability

decimal

The model's probability for its label, between 0 and 1. Null when the cause came from the regulator's list.

Histogram: 0.313 to 0.3979625, 19; 0.3979625 to 0.48292499999999999, 70; 0.48292499999999999 to 0.56788749999999999, 158; 0.56788749999999999 to 0.65284999999999993, 161; 0.65284999999999993 to 0.73781249999999998, 136; 0.73781249999999998 to 0.82277500000000003, 154; 0.82277500000000003 to 0.90773749999999986, 427; 0.90773749999999986 to 0.99269999999999992, 942
0.31300.9927
Valid
2,067 · 49.1%
Missing
2,143 · 50.9%
Missing over timeMissing share of cause_probability over time, 0% to 100%.
Distinct
1,347 · 65.2% of valid
Min
0.3130
25%
0.7197
Median
0.9006
75%
0.9360
Max
0.9927

document_url

string

Address of the order or press release.

3,507 distinct values, no chart

Valid
3,899 · 92.6%
Missing
311 · 7.4%
Missing over timeMissing share of document_url over time, 0% to 62%.
Distinct
3,507 · 89.9% of valid

Table profile

Profile of the served version, all rows, computed 16 Nov 2026, 17:31 UTC

PassedFreshnessLatest event 32 d before this version
WarningGaps1 empty year, 1988
WarningAnomaliesGap on 1988, 0 rows against about 86, and 5 more
PassedUnique keysEvery action_id is unique
Rows per year
Rows per year, 40 buckets from 1 Jan 1987 to 1 Jan 2026, at most 492 rows, 1 empty, 6 marked as anomalies.6001 Jan 1987: 1 row1 Jan 1988: 0 rows, gap, about 86 expected1 Jan 1989: 22 rows1 Jan 1990: 100 rows1 Jan 1991: 305 rows, spike, about 45 expected1 Jan 1992: 359 rows, spike, about 51 expected1 Jan 1993: 130 rows1 Jan 1994: 71 rows1 Jan 1995: 28 rows1 Jan 1996: 29 rows1 Jan 1997: 39 rows1 Jan 1998: 51 rows1 Jan 1999: 69 rows1 Jan 2000: 76 rows1 Jan 2001: 78 rows1 Jan 2002: 86 rows1 Jan 2003: 114 rows1 Jan 2004: 91 rows1 Jan 2005: 96 rows1 Jan 2006: 69 rows1 Jan 2007: 63 rows1 Jan 2008: 153 rows1 Jan 2009: 376 rows, spike, about 103 expected1 Jan 2010: 492 rows, spike, about 103 expected1 Jan 2011: 273 rows, spike, about 96 expected1 Jan 2012: 212 rows1 Jan 2013: 159 rows1 Jan 2014: 95 rows1 Jan 2015: 109 rows1 Jan 2016: 61 rows1 Jan 2017: 64 rows1 Jan 2018: 55 rows1 Jan 2019: 38 rows1 Jan 2020: 47 rows1 Jan 2021: 38 rows1 Jan 2022: 24 rows1 Jan 2023: 39 rows1 Jan 2024: 70 rows1 Jan 2025: 15 rows1 Jan 2026: 13 rows19901995200020052010201520202025

Support

Talk to Mostly Right

Loading chat…