id |
string |
Company ID |
true |
true |
true |
info.organization_name |
string |
Business name |
true |
true |
true |
company.duns_number |
string |
DUNS number |
true |
true |
true |
info.phone_country_code |
string |
Country access code |
false |
true |
false |
info.phone_number |
string |
Phone number |
true |
true |
true |
info.website |
string |
URL |
true |
true |
false |
location |
string |
Location |
true |
false |
false |
location.address1 |
string |
Street address 1 |
false |
true |
true |
location.address2 |
string |
Street address 2 |
false |
true |
true |
location.city |
string |
City |
true |
true |
true |
location.country |
string |
Country |
true |
true |
true |
location.county |
string |
County |
false |
true |
false |
location.full_state |
string |
State name |
false |
true |
false |
location.geocd_accr |
string |
GEO code accuracy |
false |
true |
false |
location.latitude |
string |
Latitude |
true |
true |
false |
location.latitude2 |
string |
Latitude short |
false |
true |
false |
location.longitude |
string |
Longitude |
true |
true |
false |
location.longitude2 |
string |
Longitude short |
false |
true |
false |
location.mailing_address1 |
string |
Mailing address 1 |
false |
true |
false |
location.mailing_address2 |
string |
Mailing address 2 |
false |
true |
false |
location.mailing_city |
string |
Mailing city |
false |
true |
false |
location.mailing_state |
string |
Mailing state |
false |
true |
false |
location.mailing_zip |
string |
Mailing full postal code |
false |
true |
false |
location.postal_code |
string |
Full postal code |
true |
true |
true |
location.state |
string |
State |
true |
true |
true |
name.display_name |
string |
Business name |
true |
false |
false |
name.tradename |
string |
Trade style name |
true |
true |
false |
name.tradename2 |
string |
Trade style name 2 |
true |
true |
false |
name.tradename3 |
string |
Trade style name 3 |
true |
true |
false |
name.tradename4 |
string |
Trade style name 4 |
true |
true |
false |
name.tradename5 |
string |
Trade style name 5 |
true |
true |
false |
company.an_sles_cc |
string |
Sales volume local currency reliability code |
true |
true |
false |
company.an_sles_cr |
long |
Sales volume local currency |
true |
true |
false |
company.aseticker |
string |
ASE ticker |
true |
true |
false |
company.cen_fips_county_cd |
string |
Census FIPS county code |
true |
true |
false |
company.cen_fips_trt_cd |
string |
Census FIPS territory code |
true |
true |
false |
company.deliquency_risk |
string |
Delinquency risk |
true |
true |
false |
company.dm_ult_bus |
string |
Domestic ultimate business name |
false |
true |
false |
company.dm_ult_cc |
string |
Domestic ultimate D&B country code |
false |
true |
false |
company.dm_ult_dun |
string |
Domestic ultimate DUNS number |
false |
true |
false |
company.dm_ult_fip |
string |
Domestic ultimate FIPS country code |
false |
true |
false |
company.dm_ult_sta |
string |
Domestic ultimate state province abbreviation |
false |
true |
false |
company.ees_here |
long |
Employees here |
false |
true |
false |
company.ees_hre_cd |
string |
Employees here reliability code |
false |
true |
false |
company.ees_total |
long |
Employees total |
true |
true |
false |
company.ees_total_code |
string |
Employees total reliability code |
true |
true |
false |
company.fed_tax_id |
string |
Federal tax ID number |
true |
true |
false |
company.foundation |
string |
Year started |
false |
true |
false |
company.gl_ult_cc |
string |
Global ultimate D&B country code |
false |
true |
false |
company.gl_ult_dun |
string |
Global ultimate DUNS number |
true |
true |
false |
company.gl_ult_fip |
string |
Global ultimate FIPS country code |
false |
true |
false |
company.gl_ult_ind |
string |
Global ultimate indicator |
true |
true |
false |
company.gl_ult_nam |
string |
Global ultimate business name |
true |
true |
false |
company.gl_ult_sta |
string |
Global ultimate state province abbreviation |
false |
true |
false |
company.hier_code |
string |
Hierarchy code |
false |
true |
false |
company.hq_duns |
string |
Headquarter DUNS number |
true |
true |
false |
company.in_ex_code |
string |
ImportExportAgent code |
false |
true |
false |
company.labor_surplus_ind |
string |
Labor surplus indicator |
true |
true |
false |
company.legal_status |
string |
Legal status code |
false |
true |
false |
company.maj_ind_cg |
string |
Major industry category code |
true |
true |
false |
company.marketable_indicator |
string |
Marketable indicator |
true |
true |
false |
company.min_ow_ind |
string |
Minority owned indicator |
false |
true |
false |
company.minority_class |
string |
Minority owned type |
true |
true |
false |
company.naics1_1_cd |
string |
NAICS class code1_1 |
false |
true |
false |
company.naics1_2_cd |
string |
NAICS class code1_2 |
false |
true |
false |
company.naics1_3_cd |
string |
NAICS class code1_3 |
false |
true |
false |
company.naics1_4_cd |
string |
NAICS class code1_4 |
false |
true |
false |
company.naics2_1_cd |
string |
NAICS class code2_1 |
false |
true |
false |
company.naics2_2_cd |
string |
NAICS class code2_2 |
false |
true |
false |
company.naics2_3_cd |
string |
NAICS class code2_3 |
false |
true |
false |
company.naics2_4_cd |
string |
NAICS class code2_4 |
false |
true |
false |
company.naics3_1_cd |
string |
NAICS class code3_1 |
false |
true |
false |
company.naics3_2_cd |
string |
NAICS class code3_2 |
false |
true |
false |
company.naics3_3_cd |
string |
NAICS class code3_3 |
false |
true |
false |
company.naics3_4_cd |
string |
NAICS class code3_4 |
false |
true |
false |
company.naics4_1_cd |
string |
NAICS class code4_1 |
false |
true |
false |
company.naics4_2_cd |
string |
NAICS class code4_2 |
false |
true |
false |
company.naics4_3_cd |
string |
NAICS class code4_3 |
false |
true |
false |
company.naics4_4_cd |
string |
NAICS class code4_4 |
false |
true |
false |
company.naics5_1_cd |
string |
NAICS class code5_1 |
false |
true |
false |
company.naics5_2_cd |
string |
NAICS class code5_2 |
false |
true |
false |
company.naics5_3_cd |
string |
NAICS class code5_3 |
false |
true |
false |
company.naics5_4_cd |
string |
NAICS class code5_4 |
false |
true |
false |
company.naics6_1_cd |
string |
NAICS class code6_1 |
false |
true |
false |
company.naics6_2_cd |
string |
NAICS class code6_2 |
false |
true |
false |
company.naics6_3_cd |
string |
NAICS class code6_3 |
false |
true |
false |
company.naics6_4_cd |
string |
NAICS class code6_4 |
false |
true |
false |
company.nas_ticker |
string |
NAS ticker |
true |
true |
false |
company.nms_ticker |
string |
NMS ticker |
true |
true |
false |
company.number_family_members |
string |
Number of business family members |
false |
true |
false |
company.nyse_ticker |
string |
NYSE stock exchange |
true |
true |
false |
company.oob_ind |
string |
Out of business indicator |
true |
true |
false |
company.op_residence_ind |
string |
Operates From residence indicator |
true |
true |
false |
company.otc_stock_ex |
string |
Over the Counter stock exchange |
true |
true |
false |
company.owns_rents |
string |
OwnsRents code |
false |
true |
false |
company.parent_duns |
string |
Parent DUNS number |
true |
true |
false |
company.pct_gr_ee3 |
string |
3 year growth percentage on employees |
false |
true |
false |
company.pct_gr_sl3 |
string |
3 year growth percentage on sales volume |
false |
true |
false |
company.pr_hq_name |
string |
Parent headquarter business name |
false |
true |
false |
company.pub_pr_ind |
string |
PublicPrivate indicator |
true |
true |
false |
company.sales_volume |
long |
Sales volume (US Dollars) |
true |
true |
false |
company.sales_volume_code |
string |
Sales volume (US Dollars) reliability code |
true |
true |
false |
company.sic1 |
string |
US 1987 SIC 1 |
true |
true |
false |
company.sic2 |
string |
US 1987 SIC 2 |
true |
true |
false |
company.sic3 |
string |
US 1987 SIC 3 |
true |
true |
false |
company.sic4 |
string |
US 1987 SIC 4 |
true |
true |
false |
company.sic5 |
string |
US 1987 SIC 5 |
true |
true |
false |
company.sic6 |
string |
US 1987 SIC 6 |
true |
true |
false |
company.small_business_ind |
string |
Small business indicator |
false |
true |
false |
company.status_ind |
string |
Location type |
true |
true |
false |
company.street_ticker |
string |
Stock symbol |
true |
true |
false |
company.subsidiary_status |
string |
Subsidiary status |
true |
true |
false |
company.women_own_ind |
string |
Woman owned |
true |
true |
false |
info.currency_code |
string |
Currency code |
false |
true |
false |
info.fax_number |
string |
Facsimile number |
false |
true |
false |
info.line_of_business |
string |
Line of business |
true |
true |
false |
info.nat_id_no |
string |
National identification number |
false |
true |
false |
company.primary_competitor_1 |
string |
Primary competitor 1 |
false |
true |
false |
company.primary_competitor_2 |
string |
Primary competitor 2 |
false |
true |
false |
company.primary_competitor_3 |
string |
Primary competitor 3 |
false |
true |
false |
company.secondary_competitor_1 |
string |
Secondary competitor 1 |
false |
true |
false |
company.secondary_competitor_2 |
string |
Secondary competitor 2 |
false |
true |
false |
company.primary_competitors |
string |
Primary competitors |
true |
false |
false |
company.secondary_competitors |
string |
Secondary competitors |
true |
false |
false |
company.primary_competitor_1_desc |
string |
Primary competitor |
true |
false |
false |
company.primary_competitor_2_desc |
string |
Second competitor |
true |
false |
false |
company.primary_competitor_3_desc |
string |
Third competitor |
true |
false |
false |
company.secondary_competitor_1_desc |
string |
First secondary competitor |
true |
false |
false |
company.secondary_competitor_2_desc |
string |
Second secondary competitor |
true |
false |
false |
company.global_stock_symbol |
string |
Global stock symbol |
false |
true |
false |
company.global_exchange_name |
string |
Global exchange name |
false |
true |
false |
company.primary_ticker_ind |
string |
Primary indicator |
false |
true |
false |
company.national_id_code |
string |
National identification code |
false |
true |
false |
location.fips_ms_cd |
string |
FIPS MSA code |
true |
true |
false |
company.new_duns_number |
string |
New DUNS number |
true |
true |
false |
company.merge_reason |
string |
Merge reason |
false |
true |
false |
company.merge_date |
string |
Merge date |
false |
true |
false |
company.doing_business_as |
string |
Doing Business As |
false |
true |
false |
company.primary_sic_code |
string |
Primary SIC code |
true |
false |
false |
company.sic_code |
string |
SIC code |
true |
false |
false |
company.primary_naics_cd |
string |
Primary NAICS code |
true |
false |
false |
company.naics_code |
string |
NAICS code |
true |
false |
false |
company.defunct_ind |
string |
Record status |
true |
true |
false |
company.sic1_desc |
string |
US 1987 SIC 1 description |
false |
true |
false |
company.sic2_desc |
string |
US 1987 SIC 2 description |
false |
true |
false |
company.sic3_desc |
string |
US 1987 SIC 3 description |
false |
true |
false |
company.sic4_desc |
string |
US 1987 SIC 4 description |
false |
true |
false |
company.sic5_desc |
string |
US 1987 SIC 5 description |
false |
true |
false |
company.sic6_desc |
string |
US 1987 SIC 6 description |
false |
true |
false |
company.naics1_1_desc |
string |
NAICS class description1_1 |
false |
true |
false |
company.naics1_2_desc |
string |
NAICS class description1_2 |
false |
true |
false |
company.naics1_3_desc |
string |
NAICS class description1_3 |
false |
true |
false |
company.naics1_4_desc |
string |
NAICS class description1_4 |
false |
true |
false |
company.naics2_1_desc |
string |
NAICS class description2_1 |
false |
true |
false |
company.naics2_2_desc |
string |
NAICS class description2_2 |
false |
true |
false |
company.naics2_3_desc |
string |
NAICS class description2_3 |
false |
true |
false |
company.naics2_4_desc |
string |
NAICS class description2_4 |
false |
true |
false |
company.naics3_1_desc |
string |
NAICS class description3_1 |
false |
true |
false |
company.naics3_2_desc |
string |
NAICS class description3_2 |
false |
true |
false |
company.naics3_3_desc |
string |
NAICS class description3_3 |
false |
true |
false |
company.naics3_4_desc |
string |
NAICS class description3_4 |
false |
true |
false |
company.naics4_1_desc |
string |
NAICS class description4_1 |
false |
true |
false |
company.naics4_2_desc |
string |
NAICS class description4_2 |
false |
true |
false |
company.naics4_3_desc |
string |
NAICS class description4_3 |
false |
true |
false |
company.naics4_4_desc |
string |
NAICS class description4_4 |
false |
true |
false |
company.naics5_1_desc |
string |
NAICS class description5_1 |
false |
true |
false |
company.naics5_2_desc |
string |
NAICS class description5_2 |
false |
true |
false |
company.naics5_3_desc |
string |
NAICS class description5_3 |
false |
true |
false |
company.naics5_4_desc |
string |
NAICS class description5_4 |
false |
true |
false |
company.naics6_1_desc |
string |
NAICS class description6_1 |
false |
true |
false |
company.naics6_2_desc |
string |
NAICS class description6_2 |
false |
true |
false |
company.naics6_3_desc |
string |
NAICS class description6_3 |
false |
true |
false |
company.naics6_4_desc |
string |
NAICS class description6_4 |
false |
true |
false |
company.max_ees_total |
long |
Max employee total |
true |
true |
false |
company.max_sales_volume |
long |
Max ARR |
true |
true |
false |
company.pr_hq_cc |
string |
Parent headquarter D&B country code |
false |
true |
false |
company.ticker |
string |
Stock symbol |
true |
true |
false |
company.description |
string |
Company description |
false |
true |
false |