World's Biggest Companies Dataset

Data on world's biggest companies.

@kaggle.marshuu_worlds_biggest_companies_dataset

Table List

4 tables(161.43 KB)

Biggest Companies Noe Nof

Cleaned Biggest Companies

Raw Biggest Companies

Tsla

Raw Biggest Companies

@kaggle.marshuu_worlds_biggest_companies_dataset.raw_biggest_companies

22.13 KB
274 rows
10 columns

company_name Company Name	country_founded Country Founded	year_founded Year Founded	revenue_2018 Revenue 2018	revenue_2019 Revenue 2019	revenue_2020 Revenue 2020	net_income_2018 Net Income 2018	net_income_2019 Net Income 2019	net_income_2020 Net Income 2020	industry Industry
Amazon	United States	1994	$232.9 billion	$280.5 billion	$386.1 billion	$21.3 billion	$21.3 billion	$21.3 billion	Retail
Apple	United States	1976	$265.6 billion	$260.2 billion	$274.5 billion	$59.5 billion	$55.2 billion	$111.4 billion	Technology
Google	United States	1998	$136.8 billion	$161.9 billion	$182.3 billion	$30.7 billion	$34.3 billion	$46.2 billion	Technology
Microsoft	United States	1975	$110.4 billion	$130.9 billion	$143.0 billion	$16.6 billion	$44.3 billion	$53.0 billion	Technology
Alibaba	China	1999	$39.9 billion	$56.1 billion	$70.2 billion	$12.9 billion	$14.9 billion	$11.9 billion	Retail
Facebook	United States	2004	$55.8 billion	$70.7 billion	$84.2 billion	$22.1 billion	$18.5 billion	$25.9 billion	Technology
Berkshire Hathaway	United States	1839	$242.1 billion	$254.2 billion	$245.5 billion	$24.1 billion	$29.1 billion	$29.9 billion	Investment
JP Morgan Chase	United States	2000	$110.2 billion	$106.6 billion	$111.5 billion	$32.0 billion	$36.4 billion	$31.2 billion	Banking
Exxon Mobil	United States	1870	$290.2 billion	$265.6 billion	$221.9 billion	$20.8 billion	$14.3 billion	$3.1 billion	Oil
Johnson & Johnson	United States	1886	$81.6 billion	$82.1 billion	$82.0 billion	$16.3 billion	$15.5 billion	$16.4 billion	Healthcare


CREATE TABLE raw_biggest_companies (
  "company_name" VARCHAR,
  "country_founded" VARCHAR,
  "year_founded" VARCHAR,
  "revenue_2018" VARCHAR,
  "revenue_2019" VARCHAR,
  "revenue_2020" VARCHAR,
  "net_income_2018" VARCHAR,
  "net_income_2019" VARCHAR,
  "net_income_2020" VARCHAR,
  "industry" VARCHAR
);