SpringDB Data Exchange Search data fieldsData vendorsAI Data ConsultantList your data

Bulk Data Feed - Franchise: Franchisor Affiliates

A BrightQuery dataset with 60 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 - Franchise: Franchisor Affiliates fields

FieldAPI nameCategoryTypeFill rateDescription
Address Countybq_franchisor_affiliates_address1_county_nameLocation & GeographyNumber (Integer)-County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Company Namebq_franchisor_affiliates_address1_country_nameFirmographicNumber (Integer)-Company name.
Address Geo-Coordinatesbq_franchisor_affiliates_address1_latitudeLocation & GeographyNumber (Decimal)-Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Company Namebq_franchisor_affiliate_address1_country_nameFirmographicNumber (Integer)-Company name.
Franchise Network Attributebq_franchisor_affiliates_idFranchise & Brand NetworkNumber (Integer)-[Inferred from field name - not in online data dictionary] Franchisor affiliates id.
Company Namebq_franchisor_affiliates_nameFirmographicString-Company name.
Company Namebq_franchisor_affiliate_nameFirmographicString-Company name.
Address Line 2bq_franchisor_affiliate_address1_secondary_numberLocation & GeographyString-Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated.
Address Building Default Indicator (USPS)bq_franchisor_affiliates_address1_building_default_indicatorLocation & GeographyBoolean-Indicates whether an address is the "default" address for a building (e.g. the main lobby).
Address Geo-Coordinatesbq_franchisor_affiliate_address1_latitudeLocation & GeographyNumber (Decimal)-Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Address Line 1bq_franchisor_affiliates_address1_line_1Location & GeographyString-The street address line 1 (primary street/building address) of an entity's address, distinct from address line 2, city, state, and ZIP.
Address Statebq_franchisor_affiliate_address1_state_nameLocation & GeographyString-State of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Statebq_franchisor_affiliates_address1_state_nameLocation & GeographyString-State of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Statebq_franchisor_affiliates_address1_stateLocation & GeographyString-State of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Congressional Districtbq_franchisor_affiliates_address1_congressional_districtLocation & GeographyString-The U.S. congressional district associated with an address, as determined by USPS-standardized address matching.
Franchise Network Attributebq_franchisor_affiliate_idFranchise & Brand NetworkString-Unique ID assigned by BQ to each Affiliate. Affiliates refer to companies or entities that are related to the franchisor by ownership or control often throught common ownership or a parent company.
Legal Entity IDbq_legal_entity_idIdentity & IdentifiersString-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.
Address Congressional Districtbq_franchisor_affiliate_address1_congressional_districtLocation & GeographyString-The U.S. congressional district associated with an address, as determined by USPS-standardized address matching.
Address Valid Indicator Flagbq_franchisor_affiliates_address1_valid_indicatorLocation & GeographyBoolean-Whether the address was successfully validated/standardized against USPS records.
Address CMRA Indicator (USPS)bq_franchisor_affiliates_address1_dpv_cmraLocation & GeographyString-Indicates whether an address is associated with a Commercial Mail Receiving Agency (CMRA), also known as a private mailbox (PMB) operator.
Address Geo-Coordinatesbq_franchisor_affiliate_address1_longitudeLocation & GeographyNumber (Decimal)-Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Company IDbq_idIdentity & IdentifiersNumber (Integer)-ZoomInfo ID of the prior company.
Address DPV Footnotes (USPS)bq_franchisor_affiliate_address1_dpv_footnotesLocation & GeographyString-Additional footnote details related to USPS Delivery Point Validation of an address.
Address Countrybq_franchisor_affiliates_address1_countryLocation & GeographyNumber (Integer)-Two digit ISO country code of the Legal Entity's address.
Address Countybq_franchisor_affiliate_address1_county_nameLocation & GeographyNumber (Integer)-County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Address Countrybq_franchisor_affiliate_address1_countryLocation & GeographyNumber (Integer)-Two digit ISO country code of the Legal Entity's address.
Address Residential Delivery Indicator (RDI)bq_franchisor_affiliates_address1_rdiLocation & GeographyString-Indicates whether an address is Residential, Commercial, P.O. Box, or Unknown, per USPS reporting.
Address Line 2bq_franchisor_affiliates_address1_secondary_numberLocation & GeographyString-Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated.
Address Countybq_franchisor_affiliates_address1_county_fipsLocation & GeographyNumber (Integer)-County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Address Zipbq_franchisor_affiliate_address1_zip5Location & GeographyString-5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Citybq_franchisor_affiliates_address1_cityLocation & GeographyString-City of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Zipbq_franchisor_affiliates_address1_zip5Location & GeographyNumber (Integer)-5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Geo-Coordinatesbq_franchisor_affiliates_address1_longitudeLocation & GeographyNumber (Decimal)-Latitude of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Address Line 2bq_franchisor_affiliate_address1_line_2Location & GeographyString-Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated.
Address Statebq_franchisor_affiliate_address1_stateLocation & GeographyString-State of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Valid Indicator Flagbq_franchisor_affiliate_address1_valid_indicatorLocation & GeographyBoolean-Whether the address was successfully validated/standardized against USPS records.
Address Zipbq_franchisor_affiliates_address1_zip9Location & GeographyString-5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Countybq_franchisor_affiliate_address1_county_fipsLocation & GeographyNumber (Integer)-County-level FIPS code of the Organization's headquarters address. Addresses are cleaned and standardized using USPS.
Address Zipbq_franchisor_affiliate_address1_zip9Location & GeographyString-5-digit Zip Code of the Legal Entity's address. Addresses are cleaned and standardized using USPS.
Address Building Default Indicator (USPS)bq_franchisor_affiliate_address1_building_default_indicatorLocation & GeographyBoolean-Indicates whether an address is the "default" address for a building (e.g. the main lobby).
Address Mailability Summary (USPS)bq_franchisor_affiliate_address1_summaryLocation & GeographyString-Classification indicating whether an address is Match-Mailable or Non-Mailable per USPS reporting.
Address Mailability Summary (USPS)bq_franchisor_affiliates_address1_summaryLocation & GeographyString-Classification indicating whether an address is Match-Mailable or Non-Mailable per USPS reporting.
Address Zip Type (USPS)bq_franchisor_affiliate_address1_zip_typeLocation & GeographyString-Zip code classification of an address indicating whether it is a P.O. Box or not.
Address DPV Match Code (USPS)bq_franchisor_affiliate_address1_dpv_match_codeLocation & GeographyString-Indicates whether an address is verified deliverable per USPS Delivery Point Validation (DPV).
Address DPV Match Code (USPS)bq_franchisor_affiliates_address1_dpv_match_codeLocation & GeographyString-Indicates whether an address is verified deliverable per USPS Delivery Point Validation (DPV).
Address CMRA Indicator (USPS)bq_franchisor_affiliate_address1_dpv_cmraLocation & GeographyString-Indicates whether an address is associated with a Commercial Mail Receiving Agency (CMRA), also known as a private mailbox (PMB) operator.
Address DPV Footnotes (USPS)bq_franchisor_affiliates_address1_dpv_footnotesLocation & GeographyString-Additional footnote details related to USPS Delivery Point Validation of an address.
Address Active Indicator (USPS)bq_franchisor_affiliates_address1_active_indicatorLocation & GeographyBoolean-Indicates whether an address is currently active per USPS address verification.
Address Active Indicator (USPS)bq_franchisor_affiliate_address1_active_indicatorLocation & GeographyBoolean-Indicates whether an address is currently active per USPS address verification.
Address Line 2bq_franchisor_affiliates_address1_line_2Location & GeographyString-Secondary address line (e.g., suite, floor, unit) for a company, contact, or facility's address. Entity-differentiated.
CBSA Typebq_franchisor_affiliate_address1_cbsa_typeLocation & GeographyString-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 Typebq_franchisor_affiliates_address1_cbsa_typeLocation & GeographyString-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_franchisor_affiliates_address1_cbsa_nameLocation & GeographyString-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…
CBSA Namebq_franchisor_affiliate_address1_cbsa_nameLocation & GeographyString-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…
CBSA Codebq_franchisor_affiliate_address1_cbsa_codeLocation & GeographyString-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…
CBSA Codebq_franchisor_affiliates_address1_cbsa_codeLocation & GeographyNumber (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…
Address Residential Delivery Indicator (RDI)bq_franchisor_affiliate_address1_rdiLocation & GeographyString-Indicates whether an address is Residential, Commercial, P.O. Box, or Unknown, per USPS reporting.
Address Line 1bq_franchisor_affiliate_address1_line_1Location & GeographyString-The street address line 1 (primary street/building address) of an entity's address, distinct from address line 2, city, state, and ZIP.
Address Zip Type (USPS)bq_franchisor_affiliates_address1_zip_typeLocation & GeographyString-Zip code classification of an address indicating whether it is a P.O. Box or not.
Address Citybq_franchisor_affiliate_address1_cityLocation & GeographyString-City of the Legal Entity's address. Addresses are cleaned and standardized using USPS.

More from BrightQuery

Bulk Data Feed - Franchise: Franchisor Affiliates FAQ

What fields are in Bulk Data Feed - Franchise: Franchisor Affiliates?

Bulk Data Feed - Franchise: Franchisor Affiliates from BrightQuery has 60 fields across location & geography, firmographic, franchise & brand network and identity & identifiers, including Address County, Company Name and Address Geo-Coordinates.

What do I need to match against Bulk Data Feed - Franchise: Franchisor Affiliates?

Bulk Data Feed - Franchise: Franchisor Affiliates matches on bq_id, company_name and domain.

How is Bulk Data Feed - Franchise: Franchisor Affiliates priced?

bulk_flat - Flat bulk licence (uncredited). Request a quote or a sample on SpringDB.