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
236 kB across 1 part, newest sealed 14 November 2026 at 04:55 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 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.
Where the cause came from: regulator subject list, or model.
The model's probability for its label, between 0 and 1. Null when the cause came from the regulator's list.
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:31 UTC
| Passed | Freshness | Latest event 32 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 |