Commercial real estate debt by sponsor, lender or servicer in a maturity window
get_re_debt_exposureCMBS debt grouped by who carries it (latest reading per loan on the SEC ABS-EE tape): group=sponsor (the prospectus annex's sponsor or carve-out guarantor, by normalised name family), lender (the originator, folded to its parent where an SEC prospectus links them), servicer or special_servicer. Filters: within_months (default 24), property_type, state, distress (special_servicing, not_current, any), min_balance on the group's total, name (one family). Sorted by balance, with loans, properties, special servicing and the largest notes. A co-sponsored note counts in full to each named sponsor and is flagged. Conduit CMBS only. ACCESS: without a paid DFX plan on the vertical, a list returns its first 5 rows in full and a count of the rest by type (locked.count, locked.by_type), never the rows; a record names its subject and the first 3 related names per section; contact values (email, phone, profile URLs) and decision-maker names are never returned, only their types and counts. Every answer says what it withheld in entitlement and locked. Full access: DFX Intelligence, 7 days free at https://dfxintel.com/data-factory/plans.
Input Schema
| Name | Required | Description | Default |
|---|---|---|---|
| name | No | One sponsor or lender name family. | |
| group | No | sponsor | |
| limit | No | ||
| state | No | Two-letter US state code. | |
| distress | No | ||
| min_balance | No | USD floor on the group's total in the window. | |
| property_type | No | ||
| within_months | No |