Bulk Data Feed - Establishments
A BrightQuery dataset with 34 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 - Establishments fields
| Field | API name | Category | Type | Fill rate | Description |
|---|---|---|---|---|---|
| Company ID | bq_id | Identity & Identifiers | Number (Integer) | - | ZoomInfo ID of the prior company. |
| Company Ticker | bq_ticker | Financial | String | - | Public stock exchange ticker. |
| Legal Entity ID | bq_legal_entity_id | Identity & Identifiers | String | - | 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. |
| CBSA Name | bq_establishment_address1_cbsa_name | Location & Geography | String | - | 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… |
| Address County | bq_establishment_address1_county_fips | Location & Geography | Number (Integer) | - | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address County | bq_establishment_address1_county_name | Location & Geography | Number (Integer) | - | County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address Geo-Coordinates | bq_establishment_address1_longitude | Location & Geography | Number (Decimal) | - | Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Registration Jurisdiction | bq_establishment_jurisdiction_code | Legal Entity & Registration | String | - | Jurisdiction code (2-digit state name) in which the Legal Entity is registered, typically with the Secretary of State. |
| Address City | bq_establishment_address1_city | Location & Geography | String | - | City of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address State | bq_establishment_address1_state | Location & Geography | String | - | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Registration Jurisdiction | bq_establishment_jurisdiction_company_number | Legal Entity & Registration | String | - | Jurisdiction code (2-digit state name) in which the Legal Entity is registered, typically with the Secretary of State. |
| Address Zip | bq_establishment_address1_zip9 | Location & Geography | String | - | 5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address Foreign Country | bq_establishment_fgn_address1_cntry | Location & Geography | String | - | The country of a non-U.S. address, populated when the entity's address is located outside the United States. |
| Company Website | bq_website | Social & Web Presence | String | - | Website of the prior company. |
| Address Residential Delivery Indicator (RDI) | bq_establishment_address1_rdi | Location & Geography | String | - | Indicates whether an address is Residential, Commercial, P.O. Box, or Unknown, per USPS reporting. |
| Establishment Name | bq_establishment_name | Location & Geography | String | - | Name of the establishment. |
| Company Name | bq_company_name | Firmographic | String | - | Company name. |
| Address Valid Indicator Flag | bq_establishment_address1_valid_indicator | Location & Geography | Boolean | - | Whether the address was successfully validated/standardized against USPS records. |
| Address Type | bq_establishment_address1_type | Location & Geography | String | - | Classification of the address record by type (e.g. residential, commercial, PO Box). |
| Address Congressional District | bq_establishment_address1_congressional_district | Location & Geography | String | - | The U.S. congressional district associated with an address, as determined by USPS-standardized address matching. |
| Address Line 1 | bq_establishment_address1_line_1 | Location & Geography | String | - | The street address line 1 (primary street/building address) of an entity's address, distinct from address line 2, city, state, and ZIP. |
| Address Building Default Indicator (USPS) | bq_establishment_address1_building_default_indicator | Location & Geography | Boolean | - | Indicates whether an address is the "default" address for a building (e.g. the main lobby). |
| Address Mailability Summary (USPS) | bq_establishment_address1_summary | Location & Geography | String | - | Classification indicating whether an address is Match-Mailable or Non-Mailable per USPS reporting. |
| Address Zip Type (USPS) | bq_establishment_address1_zip_type | Location & Geography | String | - | Zip code classification of an address indicating whether it is a P.O. Box or not. |
| Address DPV Match Code (USPS) | bq_establishment_address1_dpv_match_code | Location & Geography | String | - | Indicates whether an address is verified deliverable per USPS Delivery Point Validation (DPV). |
| Address Zip | bq_establishment_address1_zip5 | Location & Geography | Number (Integer) | - | 5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Establishment ID | bq_establishment_id | Location & Geography | String | - | Unique identifier of the establishment. |
| CBSA Code | bq_establishment_address1_cbsa_code | Location & Geography | Number (Integer) | - | 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… |
| Parent Company ID | bq_establishment_parent_id | Corporate Hierarchy & Linkage | Number (Decimal) | - | ZoomInfo ID of the immediate parent company. |
| CBSA Type | bq_establishment_address1_cbsa_type | Location & Geography | String | - | 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… |
| Address Line 2 | bq_establishment_address1_line_2 | Location & Geography | String | - | Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated. |
| Address Geo-Coordinates | bq_establishment_address1_latitude | Location & Geography | Number (Decimal) | - | Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS. |
| Address State | bq_establishment_address1_state_name | Location & Geography | String | - | State of the Legal Entity's address. Addresses are cleaned and standardized using USPS. |
| Address Line 2 | bq_establishment_address1_secondary_number | Location & Geography | String | - | Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated. |
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 - Family Tree / Legal Entity
- Bulk Data Feed - Address Universe: Building Unit Address
- 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 - Establishments FAQ
What fields are in Bulk Data Feed - Establishments?
Bulk Data Feed - Establishments from BrightQuery has 34 fields across identity & identifiers, financial, location & geography, legal entity & registration and social & web presence, including Company ID, Company Ticker and Legal Entity ID.
What do I need to match against Bulk Data Feed - Establishments?
Bulk Data Feed - Establishments matches on bq_id, company_name and domain.
How is Bulk Data Feed - Establishments priced?
bulk_flat - Flat bulk licence (uncredited). Request a quote or a sample on SpringDB.