Loading dataset
Data viewTableSummary
Data viewTableSummary
Updated

240 kB across 1 part, newest sealed 12 November 2026 at 21:23 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

rule_cause

string

Main reason for the action, derived by rule from the OCC's own subject list. Null where the regulator lists none.

  • consumer protection or fair lending37%
  • capital, asset quality or liquidity30%
  • money laundering or sanctions25%
Valid
616 · 14.6%
Missing
3,594 · 85.4%
Missing over timeMissing share of rule_cause over time, 33% to 100%.
Distinct
5 · 0.8% of valid

document_id

string

The regulator's identifier of the order or press release, used to fetch its text.

3,323 distinct values, no chart

Valid
3,688 · 87.6%
Missing
522 · 12.4%
Missing over timeMissing share of document_id over time, 0% to 66%.
Distinct
3,323 · 90.1% of valid

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:35 UTC

PassedFreshnessLatest event 31 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…