Top 2000 Companies Globally

Top 2000 Companies Globally based on revenue, profit, assets, and marketcap.

@kaggle.joebeachcapital_top_2000_companies_globally

Table List

1 table(65.44 KB)

Top2000companiesglobally

@kaggle.joebeachcapital_top_2000_companies_globally.top2000companiesglobally

65.44 KB
1924 rows
10 columns

global_rank Global Rank	company Company	sales_billion Sales ($billion)	profits_billion Profits ($billion)	assets_billion Assets ($billion)	market_value_billion Market Value ($billion)	country Country	continent Continent	latitude Latitude	longitude Longitude
1	ICBC	134.8	37.8	2813.5	237.3	China	Asia	35.86166	104.195397
2	China Construction Bank	113.1	30.6	2241	202	China	Asia	35.86166	104.195397
3	JPMorgan Chase	108.2	21.3	2359.1	191.4	USA	North America	37.09024	-95.712891
4	General Electric	147.4	13.6	685.3	243.7	USA	North America	37.09024	-95.712891
5	Exxon Mobil	420.7	44.9	333.8	400.4	USA	North America	37.09024	-95.712891
6	HSBC Holdings	104.9	14.3	2684.1	201.3	UK	Europe	55.378051	-3.435973
7	Royal Dutch Shell	467.2	26.6	360.3	213.1	The Netherlands	Europe	52.132633	5.291266
8	Agricultural Bank of China	103	23	2124.2	150.8	China	Asia	35.86166	104.195397
9	PetroChina	308.9	18.3	347.8	261.2	China	Asia	35.86166	104.195397
9	Berkshire Hathaway	162.5	14.8	427.5	252.8	USA	North America	37.09024	-95.712891


CREATE TABLE top2000companiesglobally (
  "global_rank" BIGINT,
  "company" VARCHAR,
  "sales_billion" DOUBLE,
  "profits_billion" DOUBLE,
  "assets_billion" DOUBLE,
  "market_value_billion" DOUBLE,
  "country" VARCHAR,
  "continent" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);