Detailed value distributions and statistics for each field in the principals endpoint.
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| City for the principal mailing address. | text | ?address_city=eq.New%20York | 0.0% | 0 of 92,708 | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Country for the principal address. | text | ?address_country=eq.US | 0.0% | 0 of 92,708 | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| State or province for the principal address. | text | ?address_state=eq.NY | 0.0% | 0 of 92,708 | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Direct email captured for the principal. | text | ?contact_email=ilike.%40gmail.com | 17.1% | 15,879 of 92,708 | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Phone number formatted in E.164. | text | ?contact_phone_e164=ilike.+1% | 0.0% | 0 of 92,708 | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| True when the person is flagged as a control person. | bool | ?control_person_flag=is.true | 97.8% | 90,631 of 92,708 | - |
| Value | Count | % of Total |
|---|
| TRUE | 75,403 | 81.3% |
| FALSE | 15,228 | 16.4% |
| MISSING | 2,077 | 2.2% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Confidence score returned by the validation vendor. | numeric | ?email_confidence=gte.0.8 | 17.1% | 15,834 of 92,708 | - |
| Value | Count | % of Total |
|---|
| 0.70 | 5,062 | 5.46% |
| 0.85 | 692 | 0.75% |
| 0.90 | 999 | 1.08% |
| 0.95 | 8,321 | 8.98% |
| Unknown | 76,874 | 82.92% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Indicates that the email passed verification. | bool | ?email_is_validated=is.true | 10.0% | 9,293 of 92,708 | - |
| Value | Count | % of Total |
|---|
| TRUE | 9,293 | 10% |
| FALSE | 9,005 | 9.7% |
| MISSING | 74,410 | 80.3% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Entity type (individual vs organization). | text | ?entity_type=eq.individual | 100.0% | 92,708 of 92,708 | - |
| Value | Count | % of Total |
|---|
| Individual | 74,338 | 80.2% |
| Institution | 18,370 | 19.8% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Business key for the parent firm. | text | ?firm_business_key=eq.FIRM-123456 | 100.0% | 92,708 of 92,708 | 24,081 |
| Value | Count | % of Total |
|---|
| e.g. CRD:10091 | - | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| CRD number for the parent firm. | text | ?firm_crd_number=eq.123456 | 100.0% | 92,708 of 92,708 | - |
| Value | Count | % of Total |
|---|
| e.g. 10091 | - | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| UUID for the parent firm in api.firms. | uuid | ?firm_id=eq.<firm_uuid> | 100.0% | 92,708 of 92,708 | 23,747 |
| Value | Count | % of Total |
|---|
| e.g. 0004547c-db9c-5ad6-a1b0-12d82dc9f12f | - | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Legal name of the advisory firm. | text | ?firm_legal_name=ilike.capital | 100.0% | 92,708 of 92,708 | - |
| Value | Count | % of Total |
|---|
| e.g. a16z Capital Management, L.L.C. | - | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| SEC registration number for the parent firm. | text | ?firm_sec_number=eq.801-123456 | 100.0% | 92,686 of 92,708 | - |
| Value | Count | % of Total |
|---|
| e.g. 801-100337 | - | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Full name of the principal or control person. | text | ?full_name=ilike.smith | 100.0% | 92,708 of 92,708 | - |
| Value | Count | % of Total |
|---|
| e.g. Marc Andreesen | - | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| LinkedIn profile URL when available. | text | ?linkedin_url=ilike.linkedin.com/in | 0.0% | 0 of 92,708 | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Ingestion month for the principal record. | date | ?load_month=eq.2024-09-01 | 100.0% | 92,708 of 92,708 | 22 |
| Value | Count | % of Total |
|---|
| 2024-03 | 45,769 | 49.4% |
| 2024-01 | 9,330 | 10.1% |
| 2024-02 | 8,697 | 9.4% |
| 2025-03 | 8,188 | 8.8% |
| 2025-10 | 2,392 | 2.6% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Ownership percentage disclosed in Schedule A/B. | numeric | ?ownership_percent=gte.5 | 55.8% | 51,759 of 92,708 | - |
| Value | Count | % of Total |
|---|
| 50. | 19,812 | 21.4% |
| 10. | 10,763 | 11.6% |
| 25. | 9,071 | 9.8% |
| 5. | 6,870 | 7.4% |
| 75. | 5,243 | 5.7% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Business key for the principal/control person. | text | ?person_business_key=eq.PERSON-123456 | 100.0% | 92,708 of 92,708 | 91,484 |
| Value | Count | % of Total |
|---|
| e.g. PERSON:010118MANAGEMENTLLC | - | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| UUID for the principal/control person. | uuid | ?person_id=eq.<person_uuid> | 100.0% | 92,708 of 92,708 | 91,484 |
| Value | Count | % of Total |
|---|
| e.g. 00007f62-f84e-51ec-976a-47133bed4b6a | - | - |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Ingestion source that produced the record. | text | ?primary_data_source=eq.sec | 100.0% | 92,708 of 92,708 | - |
| Value | Count | % of Total |
|---|
| adv_part1 | 92,708 | 100% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Raw role text from the SEC filing. | text | ?raw_role=ilike.director | 100.0% | 92,704 of 92,708 | - |
| Value | Count | % of Total |
|---|
| executive | 16,855 | 18.2% |
| compliance | 14,161 | 15.3% |
| partner | 10,460 | 11.3% |
| director | 9,861 | 10.6% |
| member | 7,753 | 8.4% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Relationship type (owner, executive, etc.). | text | ?relationship_role=eq.owner | 100.0% | 92,704 of 92,708 | - |
| Value | Count | % of Total |
|---|
| MEMBER | 7,753 | 8.4% |
| CHIEF COMPLIANCE OFFICER | 5,484 | 5.9% |
| MANAGING MEMBER | 5,066 | 5.5% |
| SHAREHOLDER | 4,766 | 5.1% |
| DIRECTOR | 4,111 | 4.4% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Normalized role category assigned by Mythmaker. | text | ?role_category=eq.management | 79.8% | 74,019 of 92,708 | - |
| Value | Count | % of Total |
|---|
| Owner | 25,600 | 27.6% |
| Executive | 23,858 | 25.7% |
| Compliance Officer | 16,517 | 17.8% |
| Board Member | 8,044 | 8.7% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Schedule (A or B) derived from the filing. | text | ?schedule_section=eq.Schedule%20A | 100.0% | 92,708 of 92,708 | - |
| Value | Count | % of Total |
|---|
| Schedule A | 73,100 | 78.8% |
| Schedule B | 19,608 | 21.2% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Source label for the principal row (e.g., form_adv). | text | ?source=eq.form_adv | 100.0% | 92,708 of 92,708 | - |
| Value | Count | % of Total |
|---|
| adv_part1 | 92,708 | 100% |
| Description | Data Type | Usage Notes | Fill Rate | Records | Distinct Values |
|---|
| Title reported in Schedule A/B. | text | ?title=ilike.partner | 97.8% | 90,627 of 92,708 | - |
| Value | Count | % of Total |
|---|
| MEMBER | 7,787 | 8.4% |
| CHIEF COMPLIANCE OFFICER | 5,278 | 5.7% |
| MANAGING MEMBER | 4,719 | 5.1% |
| SHAREHOLDER | 4,602 | 5% |
| DIRECTOR | 4,087 | 4.4% |
