| key |
id |
string* |
= |
PK - unique KeyBusinessListing, Unique identifier for the business |
|
affGlbUltParentBusListingId |
long |
|
Key of affiliate global ultimate parent business listing |
|
bankruptcyFiled |
boolean |
|
Indicates that the company has either a current or historical bankruptcy on file |
| link |
batch |
Batch* |
= |
The batch that provided the data |
| link |
batchRun |
BatchRun* |
= |
The batchRun that provided the data |
|
blCompanyName |
string |
|
Name of company |
|
blPhone |
string |
|
Business phone number |
|
blYearEstablished |
long |
|
Year Established |
|
businessAddress |
boolean |
|
Indicates that the business is located at an address identified by the US Postal Service (USPS) as commercial or business |
|
businessLegalStatus |
string |
|
Business defined legal structure full description |
|
businessLegalStructure |
string |
|
Business legal structure |
|
businessListingType |
string |
|
Business listing type |
|
businessSizeDescription |
string |
|
Description of the business size |
|
businessWebsite |
string |
|
Business website |
|
changeDatetime |
dateTime |
|
Last modification date and time of a physical row. |
|
cmraAddress |
boolean |
|
Indicates that the customer of a Commercial Mail Receiving Agency (CMRA) address can receive mail and other deliveries at the street address of the CMRA rather than the customer's own street address |
|
consolidatedMsaCode |
long |
|
Consolidated metropolitan statistical area (CMSA) of the business location. |
|
consolidatedMsaDescription |
string |
|
Consolidated metropolitan statistical area (CMSA) of the business location, only populates if the business is in a metro area |
|
corporateAsOfYear |
string |
|
Year for which the corporate amount reported to equifax |
|
countryTelephoneAccessCode |
long |
|
International dialing prefix of the primary address country that must be dialed before the telephone number. It is synonymous with international access code or exit code. |
|
countyId |
string |
|
Government code used to identify U.S. counties and other first-order subdivisions of states. Codes are pursuant to U.S. FIPS 6-4. |
| filter_list |
countyName |
string |
= |
Name of the county, parish, or independent city |
|
countyState |
string |
|
State postal code, as defined by U.S. FIPS 5-2 |
|
countyType |
string |
|
U.S. counties are classified into different types, or use different nomenclature, based on differences in state constitutions |
|
discontinuedBusiness |
boolean |
|
Indicates that this location is highly likely to go out of business. Information such as a disconnected phone, vacancy information from the USPS, bankruptcy, and direct research are used as basis for this indicator. |
|
discontinuedBusinessDate |
dateTime |
|
Date when Equifax initially identified this site as highly likely to go out of business |
|
doingBusinessAsName |
string |
|
'Does Business as' (DBA) name associated with this specific site location or business |
|
educationalInstitution |
boolean |
|
Indicates that the business is an educational institute |
|
employees |
long |
|
Employees |
|
estimatedEmployees |
string |
|
Employee Range |
|
ethnicityDescription |
string |
|
ethnicity_description |
|
federalGovernmentEntity |
boolean |
|
Indicates that the business is a federal government entity |
|
femaleOwned |
boolean |
|
Female Owned? |
|
foreignOwnedCompany |
boolean |
|
Indicates that the location of the business is legally owned outside of the United States |
|
franchise |
boolean |
|
Indicates the location is a franchise |
|
governmentEntity |
boolean |
|
Indicates that the business is a government entity |
|
homeBased |
boolean |
|
Indicates that the business is home-based |
|
latitude |
decimal |
|
Latitude |
|
legalBusinessName |
string |
|
Legal name of the business, cascaded for legally corporate family sites if the site is not collected independently |
|
legalEntity |
boolean |
|
Indicates that the business is a legal entity |
|
legalGlbUltParentBusListingId |
long |
|
Key of legal global ultimate parent business listing |
|
longitude |
decimal |
|
Longitude |
| filter_list |
mailingAddIso3CountryCode |
string |
= |
Standard ISO 3 digit alpha country name |
|
mailingAddressLatitude |
decimal |
|
Angular distance of the secondary address from the equator |
|
mailingAddressLongitude |
decimal |
|
Angular distance of the secondary address from the Greenwich meridian |
|
mailingCity |
string |
|
Mailing City |
|
mailingCountryDescription |
string |
|
Country where the secondary business address is located in |
| filter_list |
mailingState |
string |
= |
Mailing State |
|
mailingStateFipsCode |
string |
|
Secondary two digit FIPS (Federal Information Processing Standards) state code |
|
mailingStreet |
string |
|
Mailing Street Address |
|
mailingUnisoCountryId |
long |
|
Standard UN or ISO numeric country number identification |
| filter_list |
mailingZip |
string |
= |
Mailing Zip |
|
mailingZipPlus4 |
string |
|
Mailing Zip+4 |
|
marketabilityCategory |
string |
|
Category of the overall marketability score |
|
marketabilityScore |
string |
|
Overall score to indicate if a business is a good candidate for marketing purposes. A higher value indicates better marketability of the business. |
|
minorityBusinessEnterprise |
boolean |
|
Indicates that the business is a Minority Business Enterprise (MBE). MBE businesses are at least 51% owned and controlled by one or more U.S. citizens belonging to certain ethnic minority groups. For publicly owned businesses, at least 51% of the stock must be owned by one or more minorities and they must control the management and daily business operations. 'Ethnic minority groups' are people of Asian Pacific American, Asian Subcontinent American, African American, Hispanic American and Native American descent. |
|
msaName |
string |
|
Name of the assigned Metro- or Micropolitan area in which the branch is located pursuant to the OMB definitions. These are collectively called the Core Based Statistical Areas (CBSA). |
|
msaPublishId |
long |
|
MSA Code as designated by the U.S. Office of Management and Budget (OMB) for Metropolitan, Micropolitan and Consolidated Statistical Areas |
|
msaType |
string |
|
MSA Type |
|
nonprofit |
boolean |
|
Indicates the business listing is a nonprofit association |
|
parentBusinessListingId |
long |
|
Key of Parent Business Listing |
|
phoneTeleverified |
boolean |
|
Indicates that the phone numbers are tele-verified |
|
physicalCity |
string |
|
City in which the business is physically located |
|
physicalCountryDescription |
string |
|
Country of the business location |
| filter_list |
physicalIso3CountryCode |
string |
= |
Standard ISO 3 - byte alpha country name |
|
physicalRegion |
string |
|
Primary region of the business location |
| filter_list |
physicalState |
string |
= |
State in which the business is physically located |
|
physicalStateFipsCode |
string |
|
Two digit FIPS (Federal Information Processing Standards) state code |
|
physicalStreet |
string |
|
Physical street address of the business |
|
physicalUnisoCountryId |
long |
|
Standard UN or ISO numeric county number identification |
| filter_list |
physicalZip |
string |
= |
ZIP code in which the business is physically located |
|
physicalZipPlus4 |
string |
|
ZIP+4 code in which the business is physically located |
|
publicCompanyDescription |
string |
|
Description of the public company |
|
recordExtractedDate |
dateTime |
|
Date when records were extracted from the database |
|
residential |
boolean |
|
Indicates that this business is located at an address identified by the US Postal Service (USPS) as residential |
|
salesLevel |
string |
|
Estimated annual sales range based on the industry and number of employee |
|
seasonalAddress |
boolean |
|
Indicates if the address is a seasonal address |
|
stockTickerSymbol |
string |
|
Unique identifier determined by a ticker or symbol used to publicly trade shares of the stock in a stock market |
|
telemarketScore |
string |
|
Score to indicate if a business is a good candidate for telemarketing purposes |
|
ultParentBusinessListingId |
long |
|
Key of Ultimate Parent Business Listing |
|
vacantAddress |
boolean |
|
Indicates that a given address is vacant for some period of the year |
|
veteranBusinessEnterprise |
boolean |
|
Indicates that the business is a Veteran Business Enterprise (VBE). VBE businesses are a least 51% owned and controlled by one or more U.S. citizens who are veterans of the U.S. Armed Forces. For publicly owned businesses, at least 51% of the stock must be owned by one or more veterans and they must control the management and daily business operations. The term 'veteran' means a person who served in the active military, naval, or air service, and who was discharged or released there from under conditions other than dishonorable. |