action_id
stringStable 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
240 kB across 1 part, newest sealed 12 November 2026 at 21:23 UTC. The first build wrote 1 part and 4,210 rows.
Stable identifier of the action, a hash of the regulator, institution, action type, date and docket.
4,210 distinct values, no chart
The agency that took the action: OCC or Federal Reserve.
The bank or holding company named in the action.
3,020 distinct values, no chart
City of the institution as the regulator wrote it.
1,624 distinct values, no chart
Two-letter state of the institution.
FDIC certificate number of the bank, joining to bank_quarter_financials. Null for holding companies and unmatched names.
1,513 distinct values, no chart
How the certificate was found: OCC charter number, savings association docket number, or exact name, city and state.
OCC's short code for the action type.
10 distinct values, no chart
Type of action, such as cease and desist order, written agreement, formal agreement or civil money penalty.
Civil money penalty in US dollars, zero or null when the action carried none.
Date the action took effect.
2,580 distinct values, no chart
Date the regulator terminated the action. Null while it is open.
2,341 distinct values, no chart
Whether the action has no termination date.
OCC docket number of the action.
715 distinct values, no chart
Subject matters the OCC itself lists for the action, separated by semicolons.
407 distinct values, no chart
Main reason for the action, derived by rule from the OCC's own subject list. Null where the regulator lists none.
The regulator's identifier of the order or press release, used to fetch its text.
3,323 distinct values, no chart
Address of the order or press release.
3,507 distinct values, no chart
Profile of the served version, all rows, computed 16 Nov 2026, 17:35 UTC
| Passed | Freshness | Latest event 31 d before this version |
|---|---|---|
| Warning | Gaps | 1 empty year, 1988 |
| Warning | Anomalies | Gap on 1988, 0 rows against about 86, and 5 more |
| Passed | Unique keys | Every action_id is unique |