bigmac
430 rows where "date" is on date 2018-01-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
1078 | 1078 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
2408 | 2408 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
3738 | 3738 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
5068 | 5068 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
6398 | 6398 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
7728 | 7728 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
9058 | 9058 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
10388 | 10388 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
11718 | 11718 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
13048 | 13048 | 2018-01-01 | GBP | Britain | 3.19 | 0.72285673 | 4.41304599875552 |
1077 | 1077 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
2407 | 2407 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
3737 | 3737 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
5067 | 5067 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
6397 | 6397 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
7727 | 7727 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
9057 | 9057 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
10387 | 10387 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
11717 | 11717 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
13047 | 13047 | 2018-01-01 | EUR | Euro area | 3.95 | 0.816826629 | 4.8357874973246 |
1069 | 1069 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
2399 | 2399 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
3729 | 3729 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
5059 | 5059 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
6389 | 6389 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
7719 | 7719 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
9049 | 9049 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
10379 | 10379 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
11709 | 11709 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
13039 | 13039 | 2018-01-01 | CHF | Switzerland | 6.5 | 0.96085 | 6.76484362803768 |
1104 | 1104 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
2434 | 2434 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
3764 | 3764 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
5094 | 5094 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
6424 | 6424 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
7754 | 7754 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
9084 | 9084 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
10414 | 10414 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
11744 | 11744 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
13074 | 13074 | 2018-01-01 | USD | United States | 5.28 | 1.0 | 5.28 |
1068 | 1068 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
2398 | 2398 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
3728 | 3728 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
5058 | 5058 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
6388 | 6388 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
7718 | 7718 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
9048 | 9048 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
10378 | 10378 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
11708 | 11708 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
13038 | 13038 | 2018-01-01 | CAD | Canada | 6.55 | 1.2459 | 5.257243759531259 |
1066 | 1066 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
2396 | 2396 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
3726 | 3726 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
5056 | 5056 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
6386 | 6386 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
7716 | 7716 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
9046 | 9046 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
10376 | 10376 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
11706 | 11706 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
13036 | 13036 | 2018-01-01 | AUD | Australia | 5.9 | 1.253682693 | 4.70613499966375 |
1097 | 1097 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
2427 | 2427 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
3757 | 3757 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
5087 | 5087 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
6417 | 6417 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
7747 | 7747 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
9077 | 9077 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
10407 | 10407 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
11737 | 11737 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
13067 | 13067 | 2018-01-01 | SGD | Singapore | 5.8 | 1.32255 | 4.38546746814865 |
1090 | 1090 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
2420 | 2420 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
3750 | 3750 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
5080 | 5080 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
6410 | 6410 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
7740 | 7740 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
9070 | 9070 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
10400 | 10400 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
11730 | 11730 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
13060 | 13060 | 2018-01-01 | NZD | New Zealand | 6.2 | 1.374664925 | 4.51019000139252 |
1092 | 1092 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
2422 | 2422 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
3752 | 3752 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
5082 | 5082 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
6412 | 6412 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
7742 | 7742 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
9072 | 9072 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
10402 | 10402 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
11732 | 11732 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
13062 | 13062 | 2018-01-01 | PEN | Peru | 10.5 | 3.212 | 3.26899128268991 |
1067 | 1067 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
2397 | 2397 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
3727 | 3727 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
5057 | 5057 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
6387 | 6387 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
7717 | 7717 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
9047 | 9047 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
10377 | 10377 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
11707 | 11707 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
13037 | 13037 | 2018-01-01 | BRL | Brazil | 16.5 | 3.2279 | 5.11168251804579 |
Advanced export
JSON shape: default, array, newline-delimited
CREATE TABLE "bigmac" ( "date" TEXT, "currency_code" TEXT, "name" TEXT, "local_price" REAL, "dollar_ex" REAL, "dollar_price" REAL );