US Business Data attributes

holding_id

Holding ID

BusinessID of the holding company for the business - Linkage.

Varchar

sub_hq_id

Sub headquarter ID

BusinessID of the immediate (Sub-Parent) for the business - Linkage.

Varchar

linkage_indicator

Linkage indicator

Indicates if the company at this location is part of a linked entity.

Varchar

linkage_company_name

Linkage company name

Indicates the linked company name.

Varchar

holding_company_name

Holding company name

Holding parent company name.

Varchar

holding_state_abbreviation

Holding state abbreviation

The two-letter state abbreviation for the holding parent.

Varchar

hq_city_name

Headquarter city name

Headquarter parent city name.

Varchar

hq_number_of_companies

Headquarter number of companies

Number of companies a headquarter parent owns.

Numeric

sub_hq_city_name

Sub headquarter city name

Subsidiary parent city name.

Varchar

sub_hq_number_of_companies

Sub headquarter number of companies

Number of companies a subsidiary parent owns.

Numeric

foreign_parent_city_name

Foreign parent city name

Foreign parent city name.

Varchar

company_name

Company name

Name of the company.

Varchar

contact_full_name

Contact full name

Full name of the contact.

Varchar

contact_first_name

Contact first name

First name of the contact.

Varchar

contact_last_name

Contact last name

Last name of the contact.

Varchar

contact_professional_title

Contact professional title

Professional title of the contact.

Varchar

standardized_title

Standardized title

Executive titles standardized by the source. This field contains the title of the highest ranking executive within the company.

Varchar

source_title

Source title

Unstandardized executive title recorded from business cards. This business card title is then standardized in the standardized_title field.

Varchar

primary_executive_indicator

Primary executive indicator

Indicates if the primary executive of the company is present.

Varchar

executive_verification_type

Executive verification type

Indicates the level of acquisition or current verification status for the executive within the company.

Varchar

phone_secondary

Phone secondary

Secondary or alternative phone number of the company.

Varchar

phone_toll_free

Phone toll free

10-digit toll-free phone number for the company.

Varchar

email

Email

Email associated with the contact.

Varchar

webmail_indicator

Webmail indicator

Indicates if an executive email has a webmail domain (@gmail.com, etc.).

Varchar

url_facebook

URL Facebook

URL of the company's Facebook page.

Varchar

url_instagram

URL Instagram

URL of the company's Instagram page.

Varchar

url_twitter

URL Twitter

URL of the company's Twitter page.

Varchar

business_type

Business type

Indicates the type of business.

Varchar

ticker_symbol

Ticker symbol

Ticker symbol for publicly traded companies.

Varchar

fortune_1000_indicator

Fortune 1000 indicator

Indicates if the headquarters of a company is listed on the Fortune 1000 list.

Varchar

fortune_1000_branches

Fortune 1000 branches

Indicates the ranking on the Fortune 1000 list that has been carried over to a branch at this location.

Varchar

operating_hours_tuesday

Operating hours Tuesday

Hours of operation for Tuesday.

Varchar

operating_hours_thursday

Operating hours Thursday

Hours of operation for Thursday.

Varchar

operating_hours_saturday

Operating hours Saturday

Hours of operation for Saturday.

Varchar

rdi

Residential delivery indicator

Residential delivery indicator is a USPS data point designed to indicate whether an address is residential or commercial.

Note: PO Boxes are always returned as "Residential".

Varchar

city_name

City name

The USPS-preferred city name for this particular address, or an acceptable alternate if provided by the user.

Varchar

zipcode

ZIP Code

The 5-digit ZIP Code.

Varchar

carrier_route

Carrier route

The postal carrier route for the address. Consists of a one-letter prefix followed by a three-digit route designator.
(e.g., C007, R123)

C — Carrier Route (commonly termed "City Route")
R — Rural Route
H — Highway Contract Route
B — Post Office Box Section
G — General Delivery Unit

Routes C770 through C779 pertain to PO Box Street Addresses.

Varchar

delivery_point_check_digit

Delivery point check digit

Correction character, or check digit, for the 11-digit barcode.

Varchar

mailing_city_name

Mailing city name

The USPS-preferred city name of the mailing address, or an acceptable alternate if provided by the user.

Varchar

mailing_zipcode

Mailing ZIP Code

The 5-digit ZIP Code of the mailing address.

Varchar

mailing_carrier_route

Mailing carrier route

The postal carrier route for the mailing address. Consists of a one-letter prefix followed by a three-digit route designator.
(e.g., C007, R123)

C — Carrier Route (commonly termed "City Route")
R — Rural Route
H — Highway Contract Route
B — Post Office Box Section
G — General Delivery Unit

Routes C770 through C779 pertain to PO Box Street Addresses.

Varchar

mailing_delivery_point_check_digit

Mailing delivery point check digit

Correction character, or check digit, for the 11-digit barcode.

Varchar

mail_score_description

Mail score description

Indicates the level of deliverability for this location.

Varchar

street_predirection

Street predirection

Directional information before a street name (N, SW, etc.).

Varchar

street_suffix

Street suffix

Abbreviated value describing the street (St, Ave, Blvd, etc.).

Varchar

secondary_designator

Secondary designator

Describes location within a complex/building (Ste, Apt, etc.).

Varchar

county_fips

County FIPS

The 5-digit county FIPS (Federal Information Processing Standards) code. It is a combination of a 2-digit state FIPS code and a 3-digit county code assigned by the NIST (National Institute of Standards and Technology).

Varchar

core_based_stat_area_code

Core based stat area code

Refers collectively to metropolitan statistical areas and micropolitan statistical areas. CBSAs consist of the county or counties (or equivalent entities) associated with at least one core (urban area) with a population of at least 10,000, plus adjacent counties having a high degree of social and economic integration with the core as measured through commuting ties.

A 5-digit unique ID of the CBSA (e.g., 39340).

Varchar

precision

Precision

Indicates the precision of the latitude and longitude values.

Unknown — Coordinates not known. Reasons could include: address is invalid, military address (APO or FPO), lat/lon coordinates not available.
ZIP5 — Accurate to a 5-digit ZIP Code level (least precise)
ZIP6 — Accurate to a 6-digit ZIP Code level
ZIP7 — Accurate to a 7-digit ZIP Code level
ZIP8 — Accurate to an 8-digit ZIP Code level
ZIP9 — Accurate to a 9-digit ZIP Code level
Street — Accurate to a position along the street proportional to the house/building number.
Parcel — Accurate to the centroid of a property parcel. (most precise)

Note: Concerning addresses for which the ZIP9 precision is not available, the ZIP# precision is interpolated based on neighboring addresses. Thus, ZIP7 is an average of all the lat/long coordinates of nearby ZIP Codes that share those first 7 digits.

Varchar

longitude

Longitude

The vertical component used for geographic positioning. It is the angle between 0° (the Prime Meridian) and ±180° (westward or eastward). It is the second number in an ordered pair of (latitude, longitude). A negative number indicates a location west of Greenwich, England; a positive number east. Combining lat/long values enables you to pinpoint addresses on a map.

Varchar

time_zone

Time zone

Indicates the common name of the time zone associated with the address.

Varchar

census_block

Census block

An ID of up to 15 characters that identifies a geographical area for statistical analysis.

Varchar

primary_sic_code

Primary SIC Code

Code indicating the primary Standard Industrial Classification (SIC). This code indicates the line of business. The first four digits are provided by the US government, and the three additional digits are provided by the data source.

Varchar

primary_sic_2digit_code

Primary SIC 2-digit Code

Code indicating the primary 2-digit Standard Industrial Classification.

Varchar

primary_sic_4digit_code

Primary SIC 4-digit Code

Code indicating the primary 4-digit Standard Industrial Classification.

Varchar

secondary_01_sic_7digit_code

Secondary 01 SIC 7-digit Code

Code indicating a secondary 7-digit Standard Industrial Classification.

Varchar

secondary_02_sic_7digit_code

Secondary 02 SIC 7-digit Code

Code indicating a secondary 7-digit Standard Industrial Classification.

Varchar

secondary_03_sic_7digit_code

Secondary 03 SIC 7-digit Code

Code indicating a secondary 7-digit Standard Industrial Classification.

Varchar

secondary_04_sic_7digit_code

Secondary 04 SIC 7-digit Code

Code indicating a secondary 7-digit Standard Industrial Classification.

Varchar

secondary_05_sic_7digit_code

Secondary 05 SIC 7-digit Code

Code indicating a secondary 7-digit Standard Industrial Classification.

Varchar

naics_01_code

NAICS 01 Code

6-digit North American Industry Classification System (NAICS) code.

Varchar

naics_02_code

NAICS 02 Code

6-digit North American Industry Classification System (NAICS) code.

Varchar

naics_03_code

NAICS 03 Code

6-digit North American Industry Classification System (NAICS) code.

Varchar

naics_04_code

NAICS 04 Code

6-digit North American Industry Classification System (NAICS) code.

Varchar

naics_05_code

NAICS 05 Code

6-digit North American Industry Classification System (NAICS) code.

Varchar

naics_06_code

NAICS 06 Code

6-digit North American Industry Classification System (NAICS) code.

Varchar

pass_01_code

PASS 01 Code

4-digit Point of Interest, Amenity, Specialty and Service (PASS) code.

Varchar

pass_02_code

PASS 02 Code

4-digit Point of Interest, Amenity, Specialty and Service (PASS) code.

Varchar

pass_03_code

PASS 03 Code

4-digit Point of Interest, Amenity, Specialty and Service (PASS) code.

Varchar

pass_04_code

PASS 04 Code

4-digit Point of Interest, Amenity, Specialty and Service (PASS) code.

Varchar

pass_05_code

PASS 05 Code

4-digit Point of Interest, Amenity, Specialty and Service (PASS) code.

Varchar

pass_06_code

PASS 06 Code

4-digit Point of Interest, Amenity, Specialty and Service (PASS) code.

Varchar

pass_07_code

PASS 07 Code

4-digit Point of Interest, Amenity, Specialty and Service (PASS) code.

Varchar

pass_08_code

PASS 08 Code

4-digit Point of Interest, Amenity, Specialty and Service (PASS) code.

Varchar

pass_09_code

PASS 09 Code

4-digit Point of Interest, Amenity, Specialty and Service (PASS) code.

Varchar

pass_10_code

PASS 10 Code

4-digit Point of Interest, Amenity, Specialty and Service (PASS) code.

Varchar

location_employee_count

Location employee count

The number of employees for the company at this location.

Numeric

location_sales_total

Location sales total

The modeled estimated total annual sales for the company at this location.

Numeric

corporate_employee_count_total

Corporate employee count total

The number of employees for the entire corporate family tree.

Numeric

year_established

Year established

The year the company was established at this location.

Numeric

number_of_years_in_business_range

Number of years in business range

Indicates the range for the number of years the company has been in business.

Varchar

square_footage_range

Square footage range

Indicates the range for the modeled square footage of this location.

Varchar

credit_score_code

Credit score code

Code indicating the modeled credit score range for the company.
A+ — Excellent
A — Excellent
B+ — Very Good
B — Very Good
C+ — Good
C — Good
I — Institution
P — Professional

Varchar

credit_capacity

Credit capacity

The modeled value of recommended credit capacity for the company.

Numeric

number_of_pcs_total

Total number of PCs

The modeled number of PCs for the company.

Numeric

female_owned_indicator

Female owned indicator

Indicates if the company is owned by a woman.

Varchar

minority_type

Minority type

Ethnicity description of minority.

Asian
Black/African American
Hispanic
Native American
Hawaiian/Pacific Islander

Varchar

small_business_indicator

Small business indicator

Indicates if the company is a small business. This is determined based on the Small Business Administration (SBA) criteria.

Varchar

public_indicator

Public indicator

Indicates if the company is part of a public family.

Varchar

domestic_foreign_owner_indicator

Domestic foreign owner indicator

Indicates if the company at this location is owned by a foreign entity.

Varchar

advertising_expense_total

Advertising expense total

The modeled advertising expense total value for the company.

Numeric

technology_expense_total

Technology expense total

The modeled technology expense total value for the company.

Numeric

office_equipment_expense_total

Office equipment expense total

The modeled office equipment expense total value for the company.

Numeric

rent_expense_total

Rent expense total

The modeled rent expense total value for the company.

Numeric

telecom_expense_total

Telecom expense total

The modeled telecom expense total value for the company.

Numeric

accounting_expense_total

Accounting expense total

The modeled accounting expense total value for the company.

Numeric

business_insurance_expense_total

Business insurance expense total

The modeled business insurance expense total value for the company.

Numeric

legal_expense_total

Legal expense total

The modeled legal expense total value for the company.

Numeric

utilities_expense_total

Utilities expense total

The modeled utilities expense total value for the company.

Numeric

year_current

Year current

The current year.

Numeric

year_one_prior

Year one prior

The previous year.

Numeric

year_one_prior_employee_growth

Year one prior employee growth

The percentage of employee growth between the previous year and the current year.

Numeric

year_two_prior_employee_count

Year two prior employee count

The number of employees at this location in January 2 years prior.

Numeric

year_three_prior

Year three prior

3 years prior.

Numeric

year_three_prior_employee_growth

Year three prior employee growth

The percentage of employee growth from 3 years prior through the current year.

Numeric

year_four_prior_employee_count

Year four prior employee count

The number of employees at this location in January 4 years prior.

Numeric

date_of_last_update

Date of last update

The date the record was last updated.

Date