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

Cleaned Biggest Companies

@kaggle.marshuu_worlds_biggest_companies_dataset.cleaned_biggest_companies

21.04 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	280.5	386.1	21.3	21.3	21.3	Retail
Apple	United States	1976	265.6	260.2	274.5	59.5	55.2	111.4	Technology
Google	United States	1998	136.8	161.9	182.3	30.7	34.3	46.2	Technology
Microsoft	United States	1975	110.4	130.9	143	16.6	44.3	53	Technology
Alibaba	China	1999	39.9	56.1	70.2	12.9	14.9	11.9	Retail
Facebook	United States	2004	55.8	70.7	84.2	22.1	18.5	25.9	Technology
Berkshire Hathaway	United States	1839	242.1	254.2	245.5	24.1	29.1	29.9	Investment
JP Morgan Chase	United States	2000	110.2	106.6	111.5	32	36.4	31.2	Banking
Exxon Mobil	United States	1870	290.2	265.6	221.9	20.8	14.3	3.1	Oil
Johnson & Johnson	United States	1886	81.6	82.1	82	16.3	15.5	16.4	Healthcare


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