Dataset: World's Biggest Companies Dataset

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

9.9 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.04 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.13 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

108.36 KB
2416 rows
7 columns


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