2022 Ray Dalio Country Power Index

Which country is the most powerful in the world according to Ray Dalio?

@kaggle.alexcaldarone_2022_ray_dalio_country_power_index

Table List

2 tables(37.68 KB)

Country Rankings

@kaggle.alexcaldarone_2022_ray_dalio_country_power_index.country_rankings

19.07 KB
24 rows
24 columns

country Country	rank Rank	empire_score Empire Score	financial_position Financial Position	debt_burden Debt Burden	expect_growth Expect Growth	internal_order Internal Order	wealth_gap Wealth Gap	internal_conflict Internal Conflict	education Education	innovation Innovation	cost_competitiveness Cost Competitiveness	miltary_strength Miltary Strength	trade Trade	economic_output Economic Output	markets_and_finance Markets And Finance	reserve_currency_status Reserve Currency Status	geology Geology	resource_efficiency Resource Efficiency	acts_of_nature Acts Of Nature	infrastructure_investment Infrastructure Investment	character Character	rule_of_law Rule Of Law
USA	1	0.89	23	24	12	10	19	10	1	1	1	1	1	1	3	14	1	2	4	6	9	14
CHN	2	0.76	7	11	3	6	8	5	1	2	2	2	2	3	3	5	1	2	3	6	13	12
EUR	3	0.58	17	17	20	5	9	4	2	2	2	3	3	3	4	19	3	12	18	19	21	9
DEU	4	0.38	11	4	19	3	4	3	4	6	6	6	6	14	20		2	8	10	16	21	6
JPN	5	0.33	21	20	22	1	2	2	3	4	4	5	5	5	8	12	5	6	6	9	24	2
KOR	6	0.31	9	7	10		12		4	5	9	9	11	13	15	15	4	7	11	16	21	1
IND	7	0.28	2	6	1		16		1	4	5	12	16	17	19	19	3	8	9	9	15	24
GBR	8	0.27	24	23	13	8	15	7	4	5	6	7	8	8	8	13	3	13	15	16	22	8
FRA	9	0.26	19	19	18	4	1	6	6	7	7	9	10	11	21		8	10	14	22	23	10
RUS	10	0.26	5	3	7	9	18	9	3	7	7	8	9	14	17	17	1	9	10	20	21	11


CREATE TABLE country_rankings (
  "country" VARCHAR,
  "rank" BIGINT,
  "empire_score" DOUBLE,
  "financial_position" BIGINT,
  "debt_burden" BIGINT,
  "expect_growth" DOUBLE,
  "internal_order" DOUBLE,
  "wealth_gap" BIGINT,
  "internal_conflict" DOUBLE,
  "external_order" VARCHAR,
  "education" BIGINT,
  "innovation" BIGINT,
  "cost_competitiveness" BIGINT,
  "miltary_strength" BIGINT,
  "trade" BIGINT,
  "economic_output" BIGINT,
  "markets_and_finance" BIGINT,
  "reserve_currency_status" DOUBLE,
  "geology" BIGINT,
  "resource_efficiency" BIGINT,
  "acts_of_nature" BIGINT,
  "infrastructure_investment" DOUBLE,
  "character" DOUBLE,
  "rule_of_law" BIGINT
);