Bigmac Prices

Mcdonalds' Bigmac price for every country in the world from 2000 to 2022

@kaggle.vittoriogiatti_bigmacprice

Table List

1 table(20.01 KB)

Bigmacprice

@kaggle.vittoriogiatti_bigmacprice.bigmacprice

20.01 KB
1946 rows
6 columns

date Date	currency_code Currency Code	name Name	local_price Local Price	dollar_ex Dollar Ex	dollar_price Dollar Price
Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	ARS	Argentina	2.5	1	2.5
Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	AUD	Australia	2.59	1	2.59
Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	BRL	Brazil	2.95	1	2.95
Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	GBP	Britain	1.9	1	1.9
Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CAD	Canada	2.85	1	2.85
Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CLP	Chile	1260	514	2.45
Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CNY	China	9.9	8	1.24
Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	CZK	Czech Republic	54.37	39	1.39
Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	DKK	Denmark	24.75	8	3.09
Sat Apr 01 2000 00:00:00 GMT+0000 (Coordinated Universal Time)	EUR	Euro area	2.56	1	2.56


CREATE TABLE bigmacprice (
  "date" TIMESTAMP,
  "currency_code" VARCHAR,
  "name" VARCHAR,
  "local_price" DOUBLE,
  "dollar_ex" BIGINT,
  "dollar_price" DOUBLE
);