Summary statistics on completeness and quality of the database.
Last updated Feb 18, 2026
Last updated Feb 18, 2026
Last updated Feb 18, 2026
Last updated Feb 18, 2026
Last updated Feb 18, 2026
Last updated Feb 18, 2026
Last updated Feb 18, 2026
Last updated Feb 18, 2026
| Issue | Description | Affected | Total | Status |
|---|---|---|---|---|
| Companies without a domain | Companies that have no associated domain record | 542 | 33,951 | 2% |
| Companies with website but no domain | Companies where companies.website is populated but domains has no rows for that company | 230 | 33,635 | 1% |
| Companies without a primary domain | Companies with >=1 domains row but no is_primary=true domain | 49 | 33,409 | 0% |
| Companies with multiple primary domains | Companies with more than one domains row marked is_primary=true | 13 | 33,409 | 0% |
| Domains with invalid patterns | Domains where domain_name contains a protocol, path, or whitespace (should be a bare host) | 3 | 34,343 | 0% |
| Transactions without a property | Transactions where property_id is null | 80 | 7,489,788 | 0% |
| Roles without a company | Active roles where company_id is null | 893 | 64,745 | 1% |
| Roles without a person | Active roles not linked to a persons identity row | 0 | 64,745 | Clean |
| Quarantined roles | Active roles flagged as non-person/company-inbox contacts | 13 | 64,758 | 0% |
| Metric | Current | Target | Status |
|---|---|---|---|
Companies with a domain Percent of companies that have at least one domains row | 98% (33,409/33,951) | 95% | On track |
Website present but no domain Percent of companies with website set but no domains row | 1% (230/33,635) | 5% | On track |
Companies with domains but no primary Companies that have domains but none marked is_primary=true | 49 | 0 | Gap |
Companies with multiple primaries Companies where >1 domain is marked is_primary=true | 13 | 0 | Gap |
Domains with invalid patterns Domain rows that include protocol/path/whitespace (should be a bare host) | 3 | 0 | Gap |
Primary-domain companies with city+state Among companies with a primary domain, percent with both city and state | 76% (25,479/33,360) | 60% | On track |
Primary-domain companies with description Among companies with a primary domain, percent with description filled | 96% (32,097/33,360) | 25% | On track |
Primary-domain companies with logo Among companies with a primary domain, percent with logo_url filled | 100% (33,342/33,360) | 60% | On track |
| Metric | Current | Target | Status |
|---|---|---|---|
Current roles with title Percent of current roles with title filled | 41% (26,466/64,745) | 70% | Gap |
Current roles with direct phone Percent of current roles with direct_phone filled | 44% (28,774/64,745) | 15% | On track |
Persons with mobile phone Percent of persons with mobile_phone filled | 42% (27,287/64,548) | 5% | On track |
Persons with bio Percent of persons with bio filled | 10% (6,279/64,548) | 15% | Gap |
Generic inbox share (role emails) Among current roles with email, percent that look like generic inboxes | 3% (1,873/63,760) | 10% | On track |
| Metric | Current | Target | Status |
|---|---|---|---|
Properties with full location Percent of properties with city, state, and postal_code | 83% (2,615,656/3,149,813) | 99% | Gap |
Properties with square feet Percent of properties with square_feet filled | 20% (629,740/3,149,813) | 30% | Gap |
Properties with year built Percent of properties with year_built filled | 29% (921,617/3,149,813) | 30% | Gap |
Properties with zoning Percent of properties with zoning filled | 13% (398,305/3,149,813) | 20% | Gap |
CompStak identifier coverage CompStak property_id identifier rows as a percent of total properties (assumes 1 row per property) | 17% (520,536/3,149,813) | 95% | Gap |
Non-CompStak identifier share Percent of property_identifiers rows where identifier_type != compstak_property_id | 86% (3,075,092/3,595,628) | 10% | On track |
| Metric | Current | Target | Status |
|---|---|---|---|
Financing share Percent of transactions where transaction_type=financing | 46% (3,462,265/7,489,789) | 95% | On track |
Sale share Percent of transactions where transaction_type=sale | 30% (2,267,092/7,489,789) | 3% | On track |
Lease share Percent of transactions where transaction_type=lease | 24% (1,760,432/7,489,789) | 2% | On track |
Transactions linked to property Percent of transactions where property_id is present | 100% (7,489,709/7,489,789) | 99% | On track |
Lender roles linked to companies Among deal_roles where role=lender, percent with company_id filled | 49% (1,670,187/3,422,298) | 80% | Gap |
| Field | Filled | Total | Completeness |
|---|---|---|---|
| Average Property Price | 0 | 33,951 | 0% |
| Average Deals Per Year | 0 | 33,951 | 0% |
| Number Of Properties | 182 | 33,951 | 1% |
| AUM | 4,499 | 33,951 | 13% |
| Deal Size Range | 5,591 | 33,951 | 16% |
| Source ID | 8,105 | 33,951 | 24% |
| Year Founded | 20,474 | 33,951 | 60% |
| Business Functions | 20,206 | 33,951 | 60% |
| Phone | 23,284 | 33,951 | 69% |
| Zipcode | 23,635 | 33,951 | 70% |
| Address | 24,551 | 33,951 | 72% |
| State | 25,783 | 33,951 | 76% |
| City | 28,888 | 33,951 | 85% |
| Geographic Focus | 30,096 | 33,951 | 89% |
| Description | 32,254 | 33,951 | 95% |
| Logo URL | 33,615 | 33,951 | 99% |
| Website | 33,635 | 33,951 | 99% |
| Field | Filled | Total | Completeness |
|---|---|---|---|
| Commercial Units | 103,193 | 3,149,813 | 3% |
| Lot Depth | 139,931 | 3,149,813 | 4% |
| Lot Frontage | 156,925 | 3,149,813 | 5% |
| Residential Units | 221,015 | 3,149,813 | 7% |
| Units In Building | 365,070 | 3,149,813 | 12% |
| Zoning | 398,305 | 3,149,813 | 13% |
| Neighborhood | 482,897 | 3,149,813 | 15% |
| Existing Floor Area Ratio | 545,443 | 3,149,813 | 17% |
| Square Feet | 629,740 | 3,149,813 | 20% |
| Year Renovated | 622,250 | 3,149,813 | 20% |
| Number Of Buildings | 639,764 | 3,149,813 | 20% |
| Floors | 648,479 | 3,149,813 | 21% |
| Legal | 661,044 | 3,149,813 | 21% |
| Metropolitan Statistical Area | 696,812 | 3,149,813 | 22% |
| Municipality | 701,227 | 3,149,813 | 22% |
| Lot Area SF | 801,452 | 3,149,813 | 25% |
| Lot Area Acres | 802,933 | 3,149,813 | 25% |
| Census Tract | 812,067 | 3,149,813 | 26% |
| Opportunity Zone | 815,397 | 3,149,813 | 26% |
| County | 819,551 | 3,149,813 | 26% |
| Minor Civil Division | 811,996 | 3,149,813 | 26% |
| Year Built | 921,617 | 3,149,813 | 29% |
| Property Type | 1,298,256 | 3,149,813 | 41% |
| City | 2,628,233 | 3,149,813 | 83% |
| Postal Code | 2,625,508 | 3,149,813 | 83% |
| State | 2,651,077 | 3,149,813 | 84% |
| Field | Filled | Total | Completeness |
|---|---|---|---|
| Title | 26,467 | 64,758 | 41% |
| Direct Phone | 28,774 | 64,758 | 44% |
| 63,772 | 64,758 | 98% | |
| Company ID | 63,864 | 64,758 | 99% |
| Person ID | 64,758 | 64,758 | 100% |
| Contact Name | 64,635 | 64,758 | 100% |
| Field | Filled | Total | Completeness |
|---|---|---|---|
| Transaction Amount | 5,219,633 | 7,489,788 | 70% |
| Transaction Date | 5,728,244 | 7,489,788 | 76% |
| Property ID | 7,489,708 | 7,489,788 | 100% |
| Transaction Type | 7,489,788 | 7,489,788 | 100% |
| Document Type | 7,489,694 | 7,489,788 | 100% |
| Document Number | 7,489,694 | 7,489,788 | 100% |