Live counts straight from production Postgres. Refreshed every five minutes. No marketing inflation — these are the rows that exist right now.
One tile per state — equal weight, no projection drama. Hover for parcel count, fill-rate index, and last refresh. 51 states + DC, ~3,200 counties.
Search, drill, copy. Same schema you get from the API. 63 curated fields shown of 229 total
Stable PropRaven parcel UUID. Primary key for joins.
Percentage of records populated for every marquee field. If it isn't there, this table will tell you.
| Field | Type | Fill rate ↓ | Records populated | Source | Last refresh |
|---|---|---|---|---|---|
| is_entity_owned | BOOL | 255,923,671 | parcels | live | |
| is_pe_aggregator | BOOL | 255,923,671 | parcels | live | |
| year_built | NUMERIC | 254,862,848 | parcels | live | |
| latitude / longitude | FLOAT | 254,332,436 | parcels | live | |
| census_tract | VARCHAR | 252,741,201 | parcels | live | |
| median_household_income | NUMERIC | 251,149,966 | parcels | live | |
| is_absentee | BOOL | 249,293,524 | parcels | live | |
| broadband_max_down_mbps | NUMERIC | 241,867,760 | parcels | live | |
| avm_value | NUMERIC | 232,320,348 | parcels | live | |
| flood_zone | VARCHAR | 227,281,437 | parcels | live | |
| address | VARCHAR | 225,690,201 | parcels | live | |
| parcel_geometry | GEOMETRY | 207,921,408 | parcels | live | |
| climate_composite_score | FLOAT | 204,473,731 | parcels | live | |
| owner_name | VARCHAR | 196,252,349 | parcels | live | |
| ownership_type | VARCHAR | 190,417,820 | parcels | live | |
| building_sqft | NUMERIC | 185,909,320 | parcels | live | |
| total_assessed_value | NUMERIC | 184,052,879 | parcels | live | |
| estimated_monthly_rent | NUMERIC | 181,135,614 | parcels | live | |
| lot_size_sqft | NUMERIC | 173,975,055 | parcels | live | |
| rent_yield_pct | FLOAT | 166,549,291 | parcels (derived) | live | |
| property_type | VARCHAR | 152,758,585 | parcels | live | |
| land_use_code | VARCHAR | 106,877,968 | parcels | live | |
| last_sale_price | NUMERIC | 90,169,998 | parcels | live | |
| last_sale_date | DATE | 86,191,910 | parcels | live | |
| owner_address | VARCHAR | 64,710,234 | parcels | live | |
| deed_count | INT | 52,245,558 | parcels | live | |
| pe_parent_group | VARCHAR | 48,267,470 | parcels | live | |
| bedrooms | NUMERIC | 32,089,911 | parcels | live | |
| bathrooms | NUMERIC | 31,294,293 | parcels | live | |
| tax_amount | NUMERIC | 22,807,705 | parcels | live |
This is exactly what the API returns. Reroll for a different example.
Refresh cadence and recent activity for every dataset that ships with the parcel record.
Each dataset ships with stable join keys to the parcel record. Rows marked ROADMAP are in Snowflake today and on the path to the public API — see Marketplace if you need them now.
Slim parcel projection optimized for fuzzy address / owner / APN search. Backs the /search/full endpoint.
Pre-computed nearest-neighbor comparables, scored by similarity and recency. Joins to parcel_id.
Bank branch locations with deposit data for retail-finance use cases.
Curated bank branch table joined to parcels via address + lat/lng.
Properties and loans cross-referenced to PropRaven parcel IDs. Sourced from SEC EDGAR CMBS prospectus filings.
Operating car-wash facilities (chain + independent) joined to parcels by lat/lng + address.
Resolved contractor entities derived from permit history, with license numbers + project counts.
Parcels with ≥2 transactions within a profitable holding period. Includes profit, hold-days, ROI.
ROADMAP — construction, renovation, and demolition permits. In Snowflake today; Neon promotion in progress.
ROADMAP — recorded transfers with sale price, deed type, grantor / grantee. In Snowflake today; Neon promotion in progress.
ROADMAP — joins to parcels via lat/lng spatial overlay. Today exposed only as flood_zone column on parcel records.
ROADMAP — resolved owner entities with officers, formation states, and parent links. Snowflake-only today.
Vertical-specific layers we maintain for storage, OOH, and tower investors. Tier-2 datasets — small slices on Neon today, fuller coverage in Snowflake.
Facility-level inventory + operator across the three largest national chains plus independents. Promoted to public API once propzilla loads storage_facilities at scale.
Permitted billboard structures with location, panel count, and authority. Cross-referenced against state DOT registries and OSM.
FCC-registered tall structures with antenna count, height AGL, and tower-owner entity. Joined to parcel by lat/lng.
Get a real API key in 60 seconds. Free tier: 100 calls / month, no credit card required.
Sign up with Google or Apple, get a pz_* key on the next screen. Free tier: 100 calls/month, no credit card. Paid tiers unlock 10K – 1M calls/month with overage billing.
One-click share into your Snowflake account — full source coverage including building permits (45M), deeds (20M), entity resolution, and more. Pay through your existing Snowflake contract.
View listingDocsEndpoint reference, code samples, full schema export, rate limits, and SLAs.
Open docs