Name: World's Biggest Companies Dataset
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

World's Biggest Companies Dataset

The dataset contains information about world's biggest companies.

Among them you can find companies founded in the US, the UK, Europe, Asia, South America, South Africa, Australia.

The dataset contains information about the year the company was founded, its' revenue and net income in years 2018 - 2020, and the industry.

I have included 2 csv files: the raw csv file if you want to practice cleaning the data, and the clean csv ready to be analyzed.

The third dataset includes the name of all the companies included in the previous datasets and 2 additional columns: number of employees and name of the founder.

In addition there's tesla.csv file containing shares prices for Tesla.

Tables

Biggest Companies Noe Nof

@kaggle.marshuu_worlds_biggest_companies_dataset.biggest_companies_noe_nof

10.13 kB
236 rows
3 columns

CREATE TABLE biggest_companies_noe_nof (
  "company_name" VARCHAR,
  "number_of_employees" BIGINT,
  "founder" VARCHAR
);

Cleaned Biggest Companies

@kaggle.marshuu_worlds_biggest_companies_dataset.cleaned_biggest_companies

21.54 kB
274 rows
10 columns

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
);

Raw Biggest Companies

@kaggle.marshuu_worlds_biggest_companies_dataset.raw_biggest_companies

22.66 kB
274 rows
10 columns

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
);

Tsla

@kaggle.marshuu_worlds_biggest_companies_dataset.tsla

110.96 kB
2,416 rows
7 columns

CREATE TABLE tsla (
  "date" TIMESTAMP,
  "open" DOUBLE,
  "high" DOUBLE,
  "low" DOUBLE,
  "close" DOUBLE,
  "adj_close" DOUBLE,
  "volume" BIGINT
);