Fortune 500 Companies

Contains data from 1996 to 2023 on Fortune 500 companies (e.g. market value).

@kaggle.rm1000_fortune_500_companies

Table List

1 table(298.77 KB)

Fortune 500 Companies

@kaggle.rm1000_fortune_500_companies.fortune_500_companies

298.77 KB
13940 rows
16 columns

name Name	rank Rank	year Year	industry Industry	sector Sector	headquarters_state Headquarters State	headquarters_city Headquarters City	revenue_mil Revenue Mil	founder_is_ceo Founder Is Ceo	female_ceo Female Ceo	newcomer_to_fortune_500 Newcomer To Fortune 500	global_500 Global 500
General Motors Corporation	1	1996	Motor Vehicles & Parts	nan	MI	nan	168828.6	nan	nan	nan	nan
Ford Motor Company	2	1996	Motor Vehicles & Parts	nan	MI	nan	137137	nan	nan	nan	nan
Exxon Corporation	3	1996	Petroleum Refining	nan	TX	nan	110009	nan	nan	nan	nan
Wal-Mart Stores, Inc.	4	1996	General Merchandisers	nan	AR	nan	93627	nan	nan	nan	nan
AT&T Corp.	5	1996	Telecommunications	nan	NY	nan	79609	nan	nan	nan	nan
International Business Machines Corporation	6	1996	Computers, Office Equipment	nan	NY	nan	71940	nan	nan	nan	nan
General Electric Company	7	1996	Electronics, Electrical Equipment	nan	CT	nan	70028	nan	nan	nan	nan
Mobil Corporation	8	1996	Petroleum Refining	nan	VA	nan	66724	nan	nan	nan	nan
Chrysler Corporation	9	1996	Motor Vehicles & Parts	nan	MI	nan	53195	nan	nan	nan	nan
Philip Morris Companies	10	1996	Tobacco	nan	NY	nan	53139	nan	nan	nan	nan


CREATE TABLE fortune_500_companies (
  "name" VARCHAR,
  "rank" BIGINT,
  "year" BIGINT,
  "industry" VARCHAR,
  "sector" VARCHAR,
  "headquarters_state" VARCHAR,
  "headquarters_city" VARCHAR,
  "market_value_mil" DOUBLE,
  "revenue_mil" DOUBLE,
  "profit_mil" DOUBLE,
  "asset_mil" DOUBLE,
  "employees" DOUBLE,
  "founder_is_ceo" VARCHAR,
  "female_ceo" VARCHAR,
  "newcomer_to_fortune_500" VARCHAR,
  "global_500" VARCHAR
);