Skip to content
Listing · PROPRAVEN_LENDING

PropRaven Lending

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

Banks · CMBS · Risk teamsRefreshed per parcel build (weekly from 2026-10-04)
Loans
12,612
Canonical lenders
399,681
Loan-attached parcels (pre-rebuild)
908K
Resolved owners
673K

Access today

  • Listing status (2026-10-15). The Snowflake Marketplace listing is in review, so it cannot be subscribed to yet.
  • Access today. Access is a direct share by request: email sales@propraven.com with your Snowflake account identifier and the listings and states you need. It is not self-serve yet.
  • Requirements. The provider account runs on AWS (region on request). To accept the share you need a role with IMPORT SHARE and CREATE DATABASE (standard Snowflake share acceptance), so you can create a database from the share.
  • Cost. Snowflake delivery is sold as a Data License; see /pricing.

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

  • 12,612 recorded loans in SILVER.LOAN today (mortgage / DOT / HELOC / commercial / construction). The recorded-mortgage feed is being re-expanded; the earlier 4.29M figure predates the current rebuild (see the data dictionary).
  • 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.
  • Loan-attached parcels with full property + owner + tax context pre-joined (908K before the rebuild).
  • 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 (historical)

Historical: measured on the pre-rebuild loan table (Q1 2026), not today's 12,612-row feed:

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 per parcel build (weekly from 2026-10-04). 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. Most enrichment columns come from an April 2026 reference snapshot; the build currently served is shown on /data/live.

Freshness as of 2026-10-15. PROPRAVEN_PARCEL_INTELLIGENCE (the 620-column parcels table) was refreshed on 2026-10-15 from the parcels gateway's current per-state builds (most states 2026-10-12; ID 2026-10-11; CT 2026-10-04-rw1; WI 2026-10-18), loaded by serverless Snowpipe. The Ontology share's silver tables were refreshed the same day from silver built on that per-state map; its derived graph and intelligence tables (owner portfolio, ownership edges, distress, value-add, institutional ownership, lender exposure) are from the 2026-08-28 build. 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

Ask for PropRaven Preview, a free 10K-parcel Mecklenburg County NC sample with the same schema, as a direct share. Once you've validated your queries against the sample, request PROPRAVEN_LENDING for full national data. Both are direct shares by request until the Marketplace listing is live.

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