Listing · PROPRAVEN_LENDING

PropRaven Lending

Banking corp-dev intelligence: who lent what, where, and what's at risk.

Banks · CMBS · Risk teamsRefreshed monthly
Loans
4.29M
Canonical lenders
399,681
Loan-attached parcels
908K
Resolved owners
673K

Description

PropRaven Lending is the first vertical bundle for banks, CMBS investors, mortgage analysts, and bank corp-dev teams. We combine raw loan-level data extracted from county deed records nationally with per-lender exposure rollups, ownership context, and distress signals — pre-joined to the parcel collateral.

What's included

  • 4.29M loans extracted from deed records (mortgage / DOT / HELOC / commercial / construction).
  • 399,681 canonical lenders with NA / FA / N.A. / INC / CORP / LLC / LP suffix collapsed (e.g. "JPMorgan Chase Bank, N.A." merged with "JPMORGAN CHASE BANK").
  • LENDER_EXPOSURE rollup: per-lender originated UPB, parcel count, primary state, loan-type mix, average loan vintage.
  • 908K loan-attached parcels with full property + owner + tax context pre-joined.
  • PARCEL_DISTRESS and PARCEL_RECENT_TRANSFER signals pre-joined to the loan cohort.
  • Geographic hierarchy for portfolio segmentation (county / CBSA / state).

Use cases

  • Bank corp-dev / M&A: "Show every CRE loan held by [Target Bank] in [Target Geography] to size an acquisition."
  • CMBS investors: validate loan-collateral attributes against issuer disclosures.
  • Risk teams: quantify concentration risk ("our top-50 borrower entities own this much value across these states").
  • Mortgage analytics: track portfolio shifts from MERS-as-nominee to direct beneficiary, by lender.

Sample query — top lenders by state

SELECT
  lender_name_canonical,
  primary_state,
  loan_count,
  ROUND(originated_upb_total / 1e9, 2) AS total_upb_b,
  parcel_count,
  ROUND(mers_nominee_share, 3) AS mers_share
FROM PROPRAVEN_LENDING.LENDING.LENDER_EXPOSURE
WHERE primary_state = 'CA'
  AND loan_count >= 1000
ORDER BY originated_upb_total DESC
LIMIT 25;

Top originators by UPB

As of Q1 2026 (sample, sourced from county deed records nationally):

LenderOriginated UPB
MERS (nominee)$152.7B
JPMorgan Chase$54.7B
Bank of America$40.6B
Wells Fargo$37.0B
Citibank$31.4B

MERS is a nominee-of-record holder for many loans; PropRaven flags MERS-nominated loans via the is_mers_nominee boolean so portfolio queries can attribute exposure to the actual beneficiary lender where deed-derivable.

Refresh cadence

Refreshed monthly. Loan and transaction data refresh as county deed records are scraped — monthly batch refreshes, with major-county feeds updated more frequently in our internal pipeline. Lender canonicalization version stamped per row. Per-row _LOADED_AT and _SOURCE_AS_OF columns expose the actual freshness for any row in your query result.

Upgrade path

Lending is the vertical bundle for finance buyers; for the same loan data exposed wide-row alongside other parcel attributes, see Parcel Intelligence. For graph traversal across owner-loan-transaction relationships, layer in Ontology.

Try before you buy

Subscribe to PropRaven Preview for a free 10K-parcel Mecklenburg County NC sample with the same schema. Once you've validated your queries against the sample, subscribe to PROPRAVEN_LENDING for full national data.

Questions? hello@propraven.com — or browse the data dictionary and sample queries.