Dataset: The Economist's Big Mac Index

About this Dataset

The Economist's 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

Tables

Big Mac Adjusted Index

@kaggle.joebeachcapital_the_economists_big_mac_index.big_mac_adjusted_index

124.92 KB
1386 rows
14 columns


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

Big Mac Full Index

@kaggle.joebeachcapital_the_economists_big_mac_index.big_mac_full_index

206.39 KB
1631 rows
19 columns


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

Big Mac Raw Index

@kaggle.joebeachcapital_the_economists_big_mac_index.big_mac_raw_index

113.84 KB
1631 rows
12 columns


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