The Economist's Big Mac Index
27 countries Big Mac Index from 2000 - 2022
@kaggle.joebeachcapital_the_economists_big_mac_index
27 countries Big Mac Index from 2000 - 2022
@kaggle.joebeachcapital_the_economists_big_mac_index
The Economist's Big Mac Index for 27 countries from 2000 - 2022.
variable definition source
date Date of observation
iso_a3 Three-character ISO 3166-1 country code
currency_code Three-character ISO 4217 currency code
name Country name
local_price Price of a Big Mac in the local currency McDonalds; The Economist
dollar_ex Local currency units per dollar Reuters
dollar_price Price of a Big Mac in dollars
USD_raw Raw index, relative to the US dollar
EUR_raw Raw index, relative to the Euro
GBP_raw Raw index, relative to the British pound
JPY_raw Raw index, relative to the Japanese yen
CNY_raw Raw index, relative to the Chinese yuan
GDP_dollar GDP per person, in dollars IMF
adj_price GDP-adjusted price of a Big Mac, in dollars
USD_adjusted Adjusted index, relative to the US dollar
EUR_adjusted Adjusted index, relative to the Euro
GBP_adjusted Adjusted index, relative to the British pound
JPY_adjusted Adjusted index, relative to the Japanese yen
CNY_adjusted Adjusted index, relative to the Chinese yuan
CREATE TABLE big_mac_adjusted_index (
"date" TIMESTAMP,
"iso_a3" VARCHAR,
"currency_code" VARCHAR,
"name" VARCHAR,
"local_price" DOUBLE,
"dollar_ex" DOUBLE,
"dollar_price" DOUBLE,
"gdp_bigmac" DOUBLE,
"adj_price" DOUBLE,
"usd" DOUBLE,
"eur" DOUBLE,
"gbp" DOUBLE,
"jpy" DOUBLE,
"cny" DOUBLE
);CREATE TABLE big_mac_full_index (
"date" TIMESTAMP,
"iso_a3" VARCHAR,
"currency_code" VARCHAR,
"name" VARCHAR,
"local_price" DOUBLE,
"dollar_ex" DOUBLE,
"dollar_price" DOUBLE,
"usd_raw" DOUBLE,
"eur_raw" DOUBLE,
"gbp_raw" DOUBLE,
"jpy_raw" DOUBLE,
"cny_raw" DOUBLE,
"gdp_bigmac" DOUBLE,
"adj_price" DOUBLE,
"usd_adjusted" DOUBLE,
"eur_adjusted" DOUBLE,
"gbp_adjusted" DOUBLE,
"jpy_adjusted" DOUBLE,
"cny_adjusted" DOUBLE
);CREATE TABLE big_mac_raw_index (
"date" TIMESTAMP,
"iso_a3" VARCHAR,
"currency_code" VARCHAR,
"name" VARCHAR,
"local_price" DOUBLE,
"dollar_ex" DOUBLE,
"dollar_price" DOUBLE,
"usd" DOUBLE,
"eur" DOUBLE,
"gbp" DOUBLE,
"jpy" DOUBLE,
"cny" DOUBLE
);Anyone who has the link will be able to view this.