Property Records Suite
176 million property records: sales, liens, valuations, and NYC ACRIS parties. The owner-and-asset side of the permit graph.
Property records turn permits into decisions. Owner names, sale prices, lien histories, and assessed valuations make every permit row actionable as a sales lead or distress signal.
Four tables form the property side of the platform: property_sales (97M rows, 23 GB), property_liens (37M rows), acris_parties (33M NYC ACRIS records), and property_valuations (9M rows). All four are the join targets for the enrich_norm_addr.sql and enrich_with_sales.sql cron jobs that hydrate hot_leads with owner and price data each morning.
Original acquisition was a mix of BatchData purchases, county assessor scrapes, and the NYC ACRIS public bulk feed. The combined suite means any permit address in the platform can be enriched with a real owner name, last sale price, lien status, and assessed value in milliseconds.
- > 97M property sales records
- > 37M property lien records
- > 33M NYC ACRIS party records
- > 9M property valuation records
- > Joined nightly to permits + hot_leads via enrichment SQL
- → Add owner-phone enrichment via contractor_licenses join
- → NYC mortgage-doc subset for distressed-property cohort
- → Public API tier with usage caps