SpringDB Data Exchange Search data fieldsData vendorsAI Data ConsultantList your data

Bulk Data Feed - Family Tree / Legal Entity

A BrightQuery dataset with 81 fields. View the BrightQuery profile.

Product details

API typeBulkFeed
Match keysbq_id, company_name, domain
Geo coverageUS
Refresh cadenceMonthly
Historical depthPoint-in-time + MR/TS/TSQ/TSM time-series
PII sensitivityFirmographic
ComplianceGovernment-filing-sourced (IRS/SEC/SoS/SBA/DOT/CMS); public record
DeliveryBulk file (S3/Snowflake)
LifecycleGA
Pricing modelbulk_flat - Flat bulk licence (uncredited)
Last verified2026-07-18

Bulk Data Feed - Family Tree / Legal Entity fields

FieldAPI nameCategoryTypeFill rateDescription
Company IDbq_idIdentity & IdentifiersNumber (Integer)100%ZoomInfo ID of the prior company.
Legal Entity Corporation Flagbq_legal_entity_corporation_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity is a corporation (relevant since corporations authorize and issue stock).
Company Websitebq_websiteSocial & Web PresenceString18%Website of the prior company.
Company Tickerbq_tickerFinancialString7%Public stock exchange ticker.
Legal Entity Company Numberbq_legal_entity_company_numberLegal Entity & RegistrationNumber (Integer)100%Unique number issued by the jurisdiction with which the Legal Entity is registered.
EIN (Tax ID)bq_legal_entity_einIdentity & IdentifiersNumber (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 IDbq_legal_entity_parent_idCorporate Hierarchy & LinkageNumber (Decimal)27%ZoomInfo ID of the immediate parent company.
Legal Entity Statusbq_legal_entity_parent_statusLegal Entity & RegistrationNumber (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_levelIdentity & IdentifiersString22%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_relatedIdentity & IdentifiersString4%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 Flagbq_legal_entity_irs_taxlien_indicatorCompliance & PrivacyBoolean100%Indicator that equals 1 if the Organization has a tax lien issued by the IRS, and 0 otherwise.
Legal Entity IDbq_legal_entity_idIdentity & IdentifiersString100%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 Jurisdictionbq_legal_entity_jurisdiction_codeLegal Entity & RegistrationString100%Jurisdiction code (2-digit state name) in which the Legal Entity is registered, typically with the Secretary of State.
Legal Entity Statusbq_legal_entity_current_statusLegal Entity & RegistrationString91%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 Statebq_legal_entity_address1_state_nameLocation & GeographyString88%State of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Zipbq_legal_entity_address1_zip9Location & GeographyString87%5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Zipbq_legal_entity_address1_postal_codeLocation & GeographyString-5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Year Foundedbq_legal_entity_year_foundedFirmographicNumber (Integer)99%Year the company was founded.
Address Countrybq_legal_entity_address1_country_code2Location & GeographyNumber (Integer)-Two digit ISO country code of the Legal Entity's address.
Company Namebq_company_nameFirmographicString100%Company name.
Active Status Flagbq_legal_entity_active_indicatorData Quality & MetadataBoolean100%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 Flagbq_legal_entity_immediate_foreign_child_indicatorLegal Entity & RegistrationBoolean88%Flag indicating the legal entity has an immediate child entity with a foreign presence.
Address Statebq_legal_entity_address1_administrative_areaLocation & GeographyString-State of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Foreign Countrybq_legal_entity_fgn_address1_cntryLocation & GeographyString100%The country of a non-U.S. address, populated when the entity's address is located outside the United States.
Address Zipbq_legal_entity_address1_postal_code_extLocation & GeographyString-5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Legal Entity Has Signatory Officer Flagbq_legal_entity_officer_signatory_indicatorLegal Entity & RegistrationBoolean79%Flag indicating the legal entity has an officer with signatory authority.
Address Valid Indicator Flagbq_legal_entity_address1_valid_indicatorLocation & GeographyBoolean100%Whether the address was successfully validated/standardized against USPS records.
Record Date Attributebq_legal_entity_date_foundedData Quality & MetadataDate94%Date on which the Legal Entity was registered with the Secretary of State .
Address Line 2bq_legal_entity_address1_secondary_numberLocation & GeographyString23%Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated.
Legal Entity Foreign Child IDsbq_legal_entity_foreign_child_idsLegal Entity & RegistrationString1%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_typeLocation & GeographyString87%Zip code classification of an address indicating whether it is a P.O. Box or not.
Address Countybq_legal_entity_address1_county_nameLocation & GeographyNumber (Integer)87%County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Parent Company Namebq_legal_entity_officer_parent_children_countCorporate Hierarchy & LinkageNumber (Integer)85%Name of the immediate parent company.
Address Geo-Coordinatesbq_legal_entity_address1_latitudeLocation & GeographyNumber (Decimal)93%Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Legal Entity Immediate Foreign Child Countbq_legal_entity_immediate_foreign_child_countLegal Entity & RegistrationNumber (Integer)1%Number of immediate children of the legal entity that have a foreign presence.
Legal Entity Children IDsbq_legal_entity_children_idsLegal Entity & RegistrationString10%Legal entity IDs of all children (including grandchildren, etc.), if this legal entity is a parent.
Legal Entity Minority Officer Presence Flagbq_legal_entity_minority_in_officer_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity has one or more minority officers.
Address Typebq_legal_entity_address1_typeLocation & GeographyString93%Classification of the address record by type (e.g. residential, commercial, PO Box).
Legal Entity Establishment Countbq_legal_entity_establishment_countLegal Entity & RegistrationNumber (Integer)10%Count of establishments (including those of children entities) operated by this legal entity.
Legal Form of Organizationbq_legal_entity_lfoLegal Entity & RegistrationString100%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 IDbq_legal_entity_officer_parent_children_idsCorporate Hierarchy & LinkageNumber (Decimal)77%ZoomInfo ID of the immediate parent company.
Address Countrybq_legal_entity_address1_country_code3Location & GeographyNumber (Integer)-Two digit ISO country code of the Legal Entity's address.
Dissolution Datebq_legal_entity_date_dissolutedLegal Entity & RegistrationDate23%Date in which the primary underlying Legal Entity of the Organization was dissolved.
Legal Entity Women-Owned Flagbq_legal_entity_womenowned_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity is women-owned, based on self-reporting or majority-women officers.
Legal Entity Immediate Foreign Child IDsbq_legal_entity_immediate_foreign_child_idsLegal Entity & RegistrationString1%Legal entity IDs of immediate children of the legal entity that have a foreign presence.
Address Geo-Coordinatesbq_legal_entity_address1_longitudeLocation & GeographyNumber (Decimal)93%Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Address Line 1bq_legal_entity_address1_line_1Location & GeographyString93%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 Countbq_legal_entity_immediate_establishment_countLegal Entity & RegistrationNumber (Integer)100%Count of immediate establishments operated by the legal entity.
Address Statebq_legal_entity_address1_stateLocation & GeographyString88%State of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Congressional Districtbq_legal_entity_address1_congressional_districtLocation & GeographyString84%The U.S. congressional district associated with an address, as determined by USPS-standardized address matching.
Legal Entity Has Foreign Child Flagbq_legal_entity_foreign_child_indicatorLegal Entity & RegistrationBoolean88%Flag indicating the legal entity has a child within its family with a foreign presence.
Legal Entity Officer-Parent Flagbq_legal_entity_officerparent_indicatorLegal Entity & RegistrationBoolean100%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_indicatorLocation & GeographyBoolean10%Indicates whether an address is the "default" address for a building (e.g. the main lobby).
Address Mailability Summary (USPS)bq_legal_entity_address1_summaryLocation & GeographyString93%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_codeLocation & GeographyString84%Indicates whether an address is verified deliverable per USPS Delivery Point Validation (DPV).
Address Residential Delivery Indicator (RDI)bq_legal_entity_address1_rdiLocation & GeographyString93%Indicates whether an address is Residential, Commercial, P.O. Box, or Unknown, per USPS reporting.
Legal Entity Immediate Children IDsbq_legal_entity_immediate_children_idsLegal Entity & RegistrationString10%Legal entity IDs of the immediate children of this legal entity, if it is a parent.
Legal Entity Children Countbq_legal_entity_children_countLegal Entity & RegistrationNumber (Integer)10%Count of children (and grandchildren, etc.) legal entities, if this legal entity is a parent.
Legal Entity Namebq_legal_entity_nameLegal Entity & RegistrationString100%Legal name of the legal entity.
Legal Entity Immediate Children Countbq_legal_entity_immediate_children_countLegal Entity & RegistrationNumber (Integer)10%Count of immediate children legal entities, if this legal entity is a parent.
Address Citybq_legal_entity_address1_cityLocation & GeographyString88%City of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Legal Entity Establishment IDsbq_legal_entity_establishment_idsLegal Entity & RegistrationString10%IDs of all establishments operated by the legal entity and its children.
Legal Entity Women Officer Presence Flagbq_legal_entity_women_in_officer_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity has one or more women officers.
Legal Entity Hispanic-Owned Flagbq_legal_entity_hispanicowned_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity is Hispanic-owned, based on self-reporting or majority-Hispanic officers.
Legal Entity Black Officer Presence Flagbq_legal_entity_black_in_officer_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity has one or more Black officers.
Legal Entity Nonprofit Flagbq_legal_entity_nonprofit_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity is a non-profit.
Legal Entity Minority-Owned Flagbq_legal_entity_minorityowned_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity is minority-owned.
Legal Entity Registered Agent Flagbq_legal_entity_agent_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity is registered as an agent.
Legal Entity Veteran-Owned Flagbq_legal_entity_veteranowned_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity is veteran-owned, based on self-reporting or majority-veteran officers.
Legal Entity Immediate Establishment IDsbq_legal_entity_immediate_establishment_idsLegal Entity & RegistrationString100%IDs of the immediate establishments operated by the legal entity.
CBSA Typebq_legal_entity_address1_cbsa_typeLocation & GeographyString75%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 Namebq_legal_entity_address1_cbsa_nameLocation & GeographyString75%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 IDbq_legal_entity_ultimate_parent_idCorporate Hierarchy & LinkageNumber (Decimal)27%ZoomInfo ID of the immediate parent company.
Address Line 2bq_legal_entity_address1_line_2Location & GeographyString1%Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated.
CBSA Codebq_legal_entity_address1_cbsa_codeLocation & GeographyNumber (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 Zipbq_legal_entity_address1_zip5Location & GeographyNumber (Integer)87%5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Legal Entity Black-Owned Flagbq_legal_entity_blackowned_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity is Black-owned, based on self-reporting or majority-Black officers.
Legal Entity Foreign Child Countbq_legal_entity_foreign_child_countLegal Entity & RegistrationNumber (Integer)1%Number of foreign entities associated with this legal entity and/or within its family.
Address Countybq_legal_entity_address1_county_fipsLocation & GeographyNumber (Integer)87%County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Parent Company IDbq_legal_entity_officer_parent_idCorporate Hierarchy & LinkageNumber (Decimal)1%ZoomInfo ID of the immediate parent company.
Legal Entity Hispanic Officer Presence Flagbq_legal_entity_hispanic_in_officer_indicatorLegal Entity & RegistrationBoolean100%Flag indicating the legal entity has one or more Hispanic officers.

More from BrightQuery

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.