§ Snowflake Marketplace
One share into your Snowflake account.
The full PropRaven dataset — including the larger source-side coverage that hasn't yet been promoted to the public API (building permits, deed transactions, entity resolution, FEMA flood polygons) — lives in our Snowflake Marketplace listing.
One-click share into your Snowflake account. No data movement, no ETL. Pay through your existing Snowflake contract.
Listing in review
Our Snowflake Marketplace listing is currently in review. We'll email you when it goes live — or contact us directly to request early access.
In the share
- • 191.3M parcels with 620 enrichment columns (129.0M carry coordinates)
- • 180M+ building permits
- • 10M+ title transfers
- • Entity resolution (73K+ entities, officers, parents)
- • FEMA flood polygons (5.5M)
- • ACS demographics, FEMA risk, climate scoring
- • CMBS loans + properties
Pricing
Per-row consumption metered through your Snowflake contract. No per-seat license. Refresh cadence: weekly for parcels, varies by dataset (see /data for per-source freshness).
Nine listings, one truth
What is in the share
The catalog ships as nine Snowflake listings with three access modes: a wide table for engineers integrating a single feature, a knowledge graph for analysts who traverse ownership, and pre-filtered vertical cohorts for specific buyers. Every listing is cut from the same underlying tables, so a subscriber to Parcel Intelligence can layer in the Ontology share or any vertical bundle without redundant ingestion, and queries written against the free Preview run unchanged against any paid share — swap PROPRAVEN_PREVIEW for the paid share name.
| Listing | Share name | Contents | Refresh |
|---|---|---|---|
| Parcel Intelligence | PROPRAVEN_PARCEL_INTELLIGENCE | Marquee wide table — 191.3M parcels × 620 fields. AVM, FEMA NRI, demographics, HMDA, crime, climate, permits, deeds, owner-entity resolution. One row per parcel. | Monthly |
| Ontology | PROPRAVEN_ONTOLOGY | Resolved knowledge graph — 12 canonical entities, 166M+ ownership edges, confidence-scored signals. Same truth as Parcel Intelligence, different access shape. | Monthly |
| Lending | PROPRAVEN_LENDING | 4.3M loans + 400K canonical lenders + per-lender exposure rollup with distress overlay, pre-joined to property and owner context. | Monthly |
| Insurance | PROPRAVEN_INSURANCE | Per-parcel multi-peril risk vector — FEMA NRI rated (~92% coverage), NFIP claim history, NOAA storms, USGS seismic, CDC SVI, wildfire. | Quarterly |
| Banking Marketplace | PROPRAVEN_BANKING_MARKETPLACE | Every U.S. bank branch with deposits, ownership chain, geocoded location. Pre-computed branch stability scores, MSA market share, antitrust HHI. | Monthly |
| SFR | PROPRAVEN_SFR | Residential parcels (SFR / MF_SMALL / CONDO / MOBILE) with absentee classification, institutional flag, recent transfer. | Monthly |
| CRE | PROPRAVEN_CRE | Commercial / industrial / multifamily / mixed-use parcels with owner graph and intelligence signals. | Monthly |
| GovTech | PROPRAVEN_GOVTECH | 191.3M parcels with addresses, property attributes, multi-year tax history, permits, full Census geographic hierarchy. No owner data. | Monthly |
| Preview (Free) | PROPRAVEN_PREVIEW | Free 10K-parcel Mecklenburg County NC sample of every entity. Same schema as the paid catalog. No commitment required to evaluate. | Monthly |
Per-listing positioning is on the listing catalog; the refresh table and the stable-ID / confidence model are on methodology & versioning.
Schemas
How the share is laid out
Each share exposes the same three schemas. SILVER holds the normalized entities — PARCEL, PROPERTY, TAX_RECORD, PERMIT, OWNER, GEOGRAPHY — under stable, deterministic PropRaven IDs (prpv_*) that survive county refreshes and APN re-issuance. GOLD_GRAPH carries the resolved ownership edges (EDGE_OWNER_PARCEL). GOLD_INTELLIGENCE ships the pre-computed signals — PARCEL_ABSENTEE, PARCEL_INSTITUTIONAL_OWNED, PARCEL_RECENT_TRANSFER, OWNER_PORTFOLIO — so you subscribe to the insight rather than re-deriving it. Parcel Intelligence adds the single wide view, CURATED.V_MARKETPLACE_NATIONAL. Per-row _LOADED_AT and _SOURCE_AS_OF columns expose actual freshness for any row in a query result, and every column on every entity is defined in the data dictionary.
The sample below is the Preview listing's own — top owners in Mecklenburg County by assessed value. Point it at a paid share name for the national answer.
SELECT
o.name_normalized AS owner,
o.entity_type,
op.parcel_count,
ROUND(op.total_assessed_value / 1e6, 1) AS total_av_m
FROM PROPRAVEN_PREVIEW.SILVER.OWNER o
JOIN PROPRAVEN_PREVIEW.GOLD_INTELLIGENCE.OWNER_PORTFOLIO op USING (prpv_owner_id)
WHERE op.parcel_count >= 5
ORDER BY op.total_assessed_value DESC
LIMIT 25;More ready-to-run SQL across parcels, owners, signals and the vertical bundles is on sample queries.
Getting the share
How to request access
- Browse the Snowflake Marketplace and search “PropRaven”.
- Subscribe to a listing. The recommended starting point is Preview (free) — a 10,000-parcel Mecklenburg County, NC sample with 100% schema parity — or Parcel Intelligence for the wide table.
- Run the sample queries against the share in Snowsight, then layer in Ontology or a vertical bundle as needed.
While the listing is in review, the same shares can be provisioned directly: request early access and tell us which listings and which states you need. Custom share requests, or coverage requirements that do not fit a published listing, go to the same address. Not on Snowflake? The Databricks Delta Sharing share, Parquet on Cloudflare R2 and CSV export are compared on bulk parcel data, and the Property Data API serves the same records one parcel at a time.