search_cmbs_resolutions

io.github.Capital-W-Holdings/us-property-parcel-real-estate-debt · Verify this server

Every conduit CMBS loan whose servicer reported a foreclosure, REO or deed in lieu workout (SEC ABS-EE), with how it ended: resolved or still pending, the SEC liquidation code decoded (disposition/liquidation, discounted payoff, payoff, repurchase), the liquidation date, the balance before resolution, the last reported realized loss and loss severity, the special servicer, and the trust filing that reported the resolution. Plus a summary by resolution and the total loss reported. The answer to 'which CMBS loans went to foreclosure and how were they resolved'. A zero realized loss is stored as absent, so 'not reported' is never 'no loss'. For live loans and their current status use search_cmbs_loans. 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, 3 days for $1 at https://dfxintel.com/data-factory/plans.