About this dataset
MDRM Tooltip is a Public dataset in the Reference & Catalog group of the BankRegReports Data API. The response carries 20 documented fields, sourced from FFIEC MDRM.
Single-MDRM lookup with enriched metadata: official FFIEC item_name + description, reporting forms, XBRL concept_type/period_type/balance, official UBPR formula syntax + narrative (if applicable), derived value_kind (DOLLAR/PERCENT/COUNT/BOOLEAN/TEXT/DATE/RATE/STRUCTURE/DECIMAL), is_used flag, and bi-temporal validity window. Optional `as_of=YYYY-MM-DD` selects the window covering that date (defaults to today). Cached 24h, reference data near-static.
Endpoint
GET /api/v1/reference/mdrm/{code}/ Parameters
| Name | Required | Description |
|---|---|---|
| code | required | MDRM column code. e.g. RCFD2170 |
| as_of | optional | Definition as of this date, YYYY-MM-DD. Default: latest. e.g. 2026-06-30 |
Response fields
| Field | Type | Description |
|---|---|---|
| mdrm | string, nullable | |
| mnemonic | string, nullable | |
| item_code | string, nullable | |
| item_name | string, nullable | |
| description | string, nullable | |
| item_type | string, nullable | |
| item_type_explain | string, nullable | |
| series_glossary | string, nullable | |
| reporting_forms | string, nullable | |
| is_conf | boolean, nullable | |
| start_date | string (date), nullable | |
| end_date | string (date), nullable | |
| concept_type | string, nullable | |
| period_type | string, nullable | |
| balance | string, nullable | |
| ubpr_formula | string, nullable | |
| ubpr_narrative | string, nullable | |
| ubpr_title | string, nullable | |
| value_kind | string, nullable | |
| is_used | boolean, nullable |
Example request
curl "https://api.bankregreports.com/api/v1/reference/mdrm/RCFD2170/" \ -H "Authorization: Bearer $BANKREG_API_TOKEN"
Responses are JSON in a {"data": ..., "meta": {...}} envelope. Get a token on the setup page.
Example response shape
A successful call returns HTTP 200 with a JSON body. Each row in data carries the fields below, shown with their documented types rather than sample values.
{
"data": [
{
"mdrm": "string",
"mnemonic": "string",
"item_code": "string",
"item_name": "string",
"description": "string",
"item_type": "string",
"item_type_explain": "string",
"series_glossary": "string"
... 12 more fields
}
],
"meta": { ... }
} When to use it
MDRM Tooltip sits in the Reference & Catalog group of the Data API. Reach for it when your work needs this data straight from the API: it comes back as JSON you can load into a notebook, a spreadsheet or a scheduled pipeline, with the dataset key reference_mdrm naming it the same way in the REST path, the Python SDK and the OpenAPI document.
Access and authentication
This dataset is in the Public tier. Send your API token in the Authorization header as a Bearer token, using a GET request to the endpoint above. The Free plan is the first plan that includes it. Check the plan comparison for request limits, and the data update schedule for when new filings reach the API.
Related datasets
- Watchlist: The authenticated user's watchlist, list or add banks (GET/POST).
- Watchlist Remove: Remove a bank from the authenticated user's watchlist.
- Watchlist Alerts: Threshold metric alerts for banks the user is watching (GET/POST).
- Watchlist Alert Detail: Toggle or delete one watchlist alert (PATCH/DELETE).
Keep going
Browse every dataset, follow the setup walkthrough to make a first call, use the Excel add-in for formulas, or connect an assistant through the MCP server.
Python SDK
Install with pip install bankregreports and set BANKREG_API_TOKEN to your key.
import bankregreports
brr = bankregreports.BankReg() # reads BANKREG_API_TOKEN
code = "RCON2170" # MDRM code for total assets
result = brr.dataset("reference_mdrm", code=code)