Bulk Data Feed - Family Tree / Legal Entity
A BrightQuery dataset with 81 fields. View the BrightQuery profile.
Product details
| API type | BulkFeed |
|---|---|
| Match keys | bq_id, company_name, domain |
| Geo coverage | US |
| Refresh cadence | Monthly |
| Historical depth | Point-in-time + MR/TS/TSQ/TSM time-series |
| PII sensitivity | Firmographic |
| Compliance | Government-filing-sourced (IRS/SEC/SoS/SBA/DOT/CMS); public record |
| Delivery | Bulk file (S3/Snowflake) |
| Lifecycle | GA |
| Pricing model | bulk_flat - Flat bulk licence (uncredited) |
| Last verified | 2026-07-18 |
Bulk Data Feed - Family Tree / Legal Entity fields
| Field | API name | Category | Type | Fill rate | Description |
|---|---|---|---|---|---|
| Company ID | bq_id | Identity & Identifiers | Number (Integer) | 100% | ZoomInfo ID of the prior company. |
| Legal Entity Corporation Flag | bq_legal_entity_corporation_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity is a corporation (relevant since corporations authorize and issue stock). |
| Company Website | bq_website | Social & Web Presence | String | 18% | Website of the prior company. |
| Company Ticker | bq_ticker | Financial | String | 7% | Public stock exchange ticker. |
| Legal Entity Company Number | bq_legal_entity_company_number | Legal Entity & Registration | Number (Integer) | 100% | Unique number issued by the jurisdiction with which the Legal Entity is registered. |
| EIN (Tax ID) | bq_legal_entity_ein | Identity & Identifiers | Number (Integer) | 22% | Unique number issued by the IRS given to the Organization which is used to identify the business and certain other related entities. An organization may have multiple EINs; this is the primary EIN. |
| Parent Company ID | bq_legal_entity_parent_id | Corporate Hierarchy & Linkage | Number (Decimal) | 27% | ZoomInfo ID of the immediate parent company. |
| Legal Entity Status | bq_legal_entity_parent_status | Legal Entity & Registration | Number (Decimal) | 100% | Legal status of the Legal Entity as reported by the jurisdiction (e.g., Dissolved, Delinquent, etc.). There are 690 distinct possible values for legal status. |
| EIN (Tax ID) | bq_legal_entity_ein_level | Identity & Identifiers | String | 22% | Unique number issued by the IRS given to the Organization which is used to identify the business and certain other related entities. An organization may have multiple EINs; this is the primary EIN. |
| EIN (Tax ID) | bq_legal_entity_eins_related | Identity & Identifiers | String | 4% | Unique number issued by the IRS given to the Organization which is used to identify the business and certain other related entities. An organization may have multiple EINs; this is the primary EIN. |
| IRS Tax Lien Flag | bq_legal_entity_irs_taxlien_indicator | Compliance & Privacy | Boolean | 100% | Indicator that equals 1 if the Organization has a tax lien issued by the IRS, and 0 otherwise. |
| Legal Entity ID | bq_legal_entity_id | Identity & Identifiers | String | 100% | Unique ID of the Legal Entity. A Legal Entity is part of an Organization and is registered with the Secretary of State of a jurisdiction. |
| Registration Jurisdiction | bq_legal_entity_jurisdiction_code | Legal Entity & Registration | String | 100% | Jurisdiction code (2-digit state name) in which the Legal Entity is registered, typically with the Secretary of State. |
| Legal Entity Status | bq_legal_entity_current_status | Legal Entity & Registration | String | 91% | Legal status of the Legal Entity as reported by the jurisdiction (e.g., Dissolved, Delinquent, etc.). There are 690 distinct possible values for legal status. |
| Address State | bq_legal_entity_address1_state_name | Location & Geography | String | 88% | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address Zip | bq_legal_entity_address1_zip9 | Location & Geography | String | 87% | 5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address Zip | bq_legal_entity_address1_postal_code | Location & Geography | String | - | 5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Year Founded | bq_legal_entity_year_founded | Firmographic | Number (Integer) | 99% | Year the company was founded. |
| Address Country | bq_legal_entity_address1_country_code2 | Location & Geography | Number (Integer) | - | Two digit ISO country code of the Legal Entity's address. |
| Company Name | bq_company_name | Firmographic | String | 100% | Company name. |
| Active Status Flag | bq_legal_entity_active_indicator | Data Quality & Metadata | Boolean | 100% | An indicator that equals 1 if the Organization is Active and 0 if otherwise. An Organization is deemed Active if it has filed in the past 2 years with one or more regulatory agencies, with preference given to the IRS. |
| Legal Entity Has Immediate Foreign Child Flag | bq_legal_entity_immediate_foreign_child_indicator | Legal Entity & Registration | Boolean | 88% | Flag indicating the legal entity has an immediate child entity with a foreign presence. |
| Address State | bq_legal_entity_address1_administrative_area | Location & Geography | String | - | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address Foreign Country | bq_legal_entity_fgn_address1_cntry | Location & Geography | String | 100% | The country of a non-U.S. address, populated when the entity's address is located outside the United States. |
| Address Zip | bq_legal_entity_address1_postal_code_ext | Location & Geography | String | - | 5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Legal Entity Has Signatory Officer Flag | bq_legal_entity_officer_signatory_indicator | Legal Entity & Registration | Boolean | 79% | Flag indicating the legal entity has an officer with signatory authority. |
| Address Valid Indicator Flag | bq_legal_entity_address1_valid_indicator | Location & Geography | Boolean | 100% | Whether the address was successfully validated/standardized against USPS records. |
| Record Date Attribute | bq_legal_entity_date_founded | Data Quality & Metadata | Date | 94% | Date on which the Legal Entity was registered with the Secretary of State . |
| Address Line 2 | bq_legal_entity_address1_secondary_number | Location & Geography | String | 23% | Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated. |
| Legal Entity Foreign Child IDs | bq_legal_entity_foreign_child_ids | Legal Entity & Registration | String | 1% | Legal entity IDs of foreign entities associated with this legal entity and/or within its family. |
| Address Zip Type (USPS) | bq_legal_entity_address1_zip_type | Location & Geography | String | 87% | Zip code classification of an address indicating whether it is a P.O. Box or not. |
| Address County | bq_legal_entity_address1_county_name | Location & Geography | Number (Integer) | 87% | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Parent Company Name | bq_legal_entity_officer_parent_children_count | Corporate Hierarchy & Linkage | Number (Integer) | 85% | Name of the immediate parent company. |
| Address Geo-Coordinates | bq_legal_entity_address1_latitude | Location & Geography | Number (Decimal) | 93% | Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Legal Entity Immediate Foreign Child Count | bq_legal_entity_immediate_foreign_child_count | Legal Entity & Registration | Number (Integer) | 1% | Number of immediate children of the legal entity that have a foreign presence. |
| Legal Entity Children IDs | bq_legal_entity_children_ids | Legal Entity & Registration | String | 10% | Legal entity IDs of all children (including grandchildren, etc.), if this legal entity is a parent. |
| Legal Entity Minority Officer Presence Flag | bq_legal_entity_minority_in_officer_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity has one or more minority officers. |
| Address Type | bq_legal_entity_address1_type | Location & Geography | String | 93% | Classification of the address record by type (e.g. residential, commercial, PO Box). |
| Legal Entity Establishment Count | bq_legal_entity_establishment_count | Legal Entity & Registration | Number (Integer) | 10% | Count of establishments (including those of children entities) operated by this legal entity. |
| Legal Form of Organization | bq_legal_entity_lfo | Legal Entity & Registration | String | 100% | Classification system for the Organization based on whether it is a Single Entity or Multi Entity Organization. A Single Entity Organization has one legal entity associated with it, while a Multi Entity Organization… |
| Parent Company ID | bq_legal_entity_officer_parent_children_ids | Corporate Hierarchy & Linkage | Number (Decimal) | 77% | ZoomInfo ID of the immediate parent company. |
| Address Country | bq_legal_entity_address1_country_code3 | Location & Geography | Number (Integer) | - | Two digit ISO country code of the Legal Entity's address. |
| Dissolution Date | bq_legal_entity_date_dissoluted | Legal Entity & Registration | Date | 23% | Date in which the primary underlying Legal Entity of the Organization was dissolved. |
| Legal Entity Women-Owned Flag | bq_legal_entity_womenowned_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity is women-owned, based on self-reporting or majority-women officers. |
| Legal Entity Immediate Foreign Child IDs | bq_legal_entity_immediate_foreign_child_ids | Legal Entity & Registration | String | 1% | Legal entity IDs of immediate children of the legal entity that have a foreign presence. |
| Address Geo-Coordinates | bq_legal_entity_address1_longitude | Location & Geography | Number (Decimal) | 93% | Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address Line 1 | bq_legal_entity_address1_line_1 | Location & Geography | String | 93% | The street address line 1 (primary street/building address) of an entity's address, distinct from address line 2, city, state, and ZIP. |
| Legal Entity Immediate Establishment Count | bq_legal_entity_immediate_establishment_count | Legal Entity & Registration | Number (Integer) | 100% | Count of immediate establishments operated by the legal entity. |
| Address State | bq_legal_entity_address1_state | Location & Geography | String | 88% | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address Congressional District | bq_legal_entity_address1_congressional_district | Location & Geography | String | 84% | The U.S. congressional district associated with an address, as determined by USPS-standardized address matching. |
| Legal Entity Has Foreign Child Flag | bq_legal_entity_foreign_child_indicator | Legal Entity & Registration | Boolean | 88% | Flag indicating the legal entity has a child within its family with a foreign presence. |
| Legal Entity Officer-Parent Flag | bq_legal_entity_officerparent_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity is itself an officer entity serving as an officer of other legal entities. |
| Address Building Default Indicator (USPS) | bq_legal_entity_address1_building_default_indicator | Location & Geography | Boolean | 10% | Indicates whether an address is the "default" address for a building (e.g. the main lobby). |
| Address Mailability Summary (USPS) | bq_legal_entity_address1_summary | Location & Geography | String | 93% | Classification indicating whether an address is Match-Mailable or Non-Mailable per USPS reporting. |
| Address DPV Match Code (USPS) | bq_legal_entity_address1_dpv_match_code | Location & Geography | String | 84% | Indicates whether an address is verified deliverable per USPS Delivery Point Validation (DPV). |
| Address Residential Delivery Indicator (RDI) | bq_legal_entity_address1_rdi | Location & Geography | String | 93% | Indicates whether an address is Residential, Commercial, P.O. Box, or Unknown, per USPS reporting. |
| Legal Entity Immediate Children IDs | bq_legal_entity_immediate_children_ids | Legal Entity & Registration | String | 10% | Legal entity IDs of the immediate children of this legal entity, if it is a parent. |
| Legal Entity Children Count | bq_legal_entity_children_count | Legal Entity & Registration | Number (Integer) | 10% | Count of children (and grandchildren, etc.) legal entities, if this legal entity is a parent. |
| Legal Entity Name | bq_legal_entity_name | Legal Entity & Registration | String | 100% | Legal name of the legal entity. |
| Legal Entity Immediate Children Count | bq_legal_entity_immediate_children_count | Legal Entity & Registration | Number (Integer) | 10% | Count of immediate children legal entities, if this legal entity is a parent. |
| Address City | bq_legal_entity_address1_city | Location & Geography | String | 88% | City of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Legal Entity Establishment IDs | bq_legal_entity_establishment_ids | Legal Entity & Registration | String | 10% | IDs of all establishments operated by the legal entity and its children. |
| Legal Entity Women Officer Presence Flag | bq_legal_entity_women_in_officer_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity has one or more women officers. |
| Legal Entity Hispanic-Owned Flag | bq_legal_entity_hispanicowned_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity is Hispanic-owned, based on self-reporting or majority-Hispanic officers. |
| Legal Entity Black Officer Presence Flag | bq_legal_entity_black_in_officer_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity has one or more Black officers. |
| Legal Entity Nonprofit Flag | bq_legal_entity_nonprofit_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity is a non-profit. |
| Legal Entity Minority-Owned Flag | bq_legal_entity_minorityowned_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity is minority-owned. |
| Legal Entity Registered Agent Flag | bq_legal_entity_agent_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity is registered as an agent. |
| Legal Entity Veteran-Owned Flag | bq_legal_entity_veteranowned_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity is veteran-owned, based on self-reporting or majority-veteran officers. |
| Legal Entity Immediate Establishment IDs | bq_legal_entity_immediate_establishment_ids | Legal Entity & Registration | String | 100% | IDs of the immediate establishments operated by the legal entity. |
| CBSA Type | bq_legal_entity_address1_cbsa_type | Location & Geography | String | 75% | Metro vs. Micro classification of the Core-Based Statistical Area (CBSA) in which an address lies, according to USPS. Entity-differentiated (Company, Legal Entity, Contact, Executive, Officer, Location, Franchise… |
| CBSA Name | bq_legal_entity_address1_cbsa_name | Location & Geography | String | 75% | Name of the Core-Based Statistical Area (CBSA) — the Metropolitan or Micropolitan Statistical Area — in which an address lies, according to USPS. Entity-differentiated (Company, Legal Entity, Contact, Executive… |
| Parent Company ID | bq_legal_entity_ultimate_parent_id | Corporate Hierarchy & Linkage | Number (Decimal) | 27% | ZoomInfo ID of the immediate parent company. |
| Address Line 2 | bq_legal_entity_address1_line_2 | Location & Geography | String | 1% | Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated. |
| CBSA Code | bq_legal_entity_address1_cbsa_code | Location & Geography | Number (Integer) | 75% | The Core-Based Statistical Area (CBSA) 5-digit numeric code which identifies the Metropolitan Statistical Area or Micropolitan Statistical Area in which an address lies, according to USPS. Entity-differentiated… |
| Address Zip | bq_legal_entity_address1_zip5 | Location & Geography | Number (Integer) | 87% | 5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Legal Entity Black-Owned Flag | bq_legal_entity_blackowned_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity is Black-owned, based on self-reporting or majority-Black officers. |
| Legal Entity Foreign Child Count | bq_legal_entity_foreign_child_count | Legal Entity & Registration | Number (Integer) | 1% | Number of foreign entities associated with this legal entity and/or within its family. |
| Address County | bq_legal_entity_address1_county_fips | Location & Geography | Number (Integer) | 87% | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Parent Company ID | bq_legal_entity_officer_parent_id | Corporate Hierarchy & Linkage | Number (Decimal) | 1% | ZoomInfo ID of the immediate parent company. |
| Legal Entity Hispanic Officer Presence Flag | bq_legal_entity_hispanic_in_officer_indicator | Legal Entity & Registration | Boolean | 100% | Flag indicating the legal entity has one or more Hispanic officers. |
More from BrightQuery
- Bulk Data Feed - Organization Executives
- Bulk Data Feed - Organization Contacts
- Bulk Data Feed - Franchise: Franchisor Affiliates
- Bulk Data Feed - Stock Filings: Legal Entity
- Bulk Data Feed - Healthcare: Provider Individuals
- Bulk Data Feed - Dept. of Transportation
- Bulk Data Feed - Organization All Names
- Bulk Data Feed - Firmographics
- Bulk Data Feed - Legal Entity Officers & Directors
- Bulk Data Feed - Financials & Employment (Most Recent)
- Bulk Data Feed - Franchise: Franchisee / Controlled Entity
- Bulk Data Feed - Address Universe: Building Unit Address
- Bulk Data Feed - Establishments
- Bulk Data Feed - Organization Locations
- Bulk Data Feed - Stock Filings: Transaction Filing Types
- Bulk Data Feed - Stock Filings: Class Series (Time Series)
- Bulk Data Feed - Stock Filings: Corporate Status & Fees
- Bulk Data Feed - Healthcare: Provider Organization Firmographics
- Bulk Data Feed - Stock Filings: Stock Events
- Bulk Data Feed - Employment (Monthly Time Series)
- Bulk Data Feed - Stock Filings: Classes of Stock Issued
- Bulk Data Feed - Stock Filings: Stock Group (Time Series)
- Bulk Data Feed - Franchise: Franchisor / Controlling Entity
- Bulk Data Feed - Franchise: Brand & Franchisor Parent
- Bulk Data Feed - Healthcare: Provider Location
- Bulk Data Feed - Healthcare: Individual Details
- Bulk Data Feed - SBA 7(a) & 504 Loans
- Bulk Data Feed - Franchise: Brands
- Bulk Data Feed - Address Universe: Building Address
- Bulk Data Feed - Organization Mapping
- Bulk Data Feed - Stock Filings: Event Timeline
- Bulk Data Feed - Franchise: Affiliates Mapping
- Bulk Data Feed - Address Universe: Unit-Organization Mapping
- Bulk Data Feed - Address Universe: Unit-Location Mapping
- Bulk Data Feed - Healthcare: Group-Individual Mapping
- Bulk Data Feed - Address Universe: Unit-Legal Entity Mapping
- Bulk Data Feed - Healthcare: Group Practice
- Bulk Data Feed - Healthcare: Org-Individual Mapping
Bulk Data Feed - Family Tree / Legal Entity FAQ
What fields are in Bulk Data Feed - Family Tree / Legal Entity?
Bulk Data Feed - Family Tree / Legal Entity from BrightQuery has 81 fields across identity & identifiers, legal entity & registration, social & web presence, financial and corporate hierarchy & linkage, including Company ID, Legal Entity Corporation Flag and Legal Entity Company Number. Average fill rate: 70%.
What do I need to match against Bulk Data Feed - Family Tree / Legal Entity?
Bulk Data Feed - Family Tree / Legal Entity matches on bq_id, company_name and domain.
How is Bulk Data Feed - Family Tree / Legal Entity priced?
bulk_flat - Flat bulk licence (uncredited). Request a quote or a sample on SpringDB.