bigmac
430 rows where "date" is on date 2018-01-01 sorted by local_price
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 |
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 |
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 |
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 |
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 |
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 |
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 |
1088 | 1088 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
2418 | 2418 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
3748 | 3748 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
5078 | 5078 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
6408 | 6408 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
7738 | 7738 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
9068 | 9068 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
10398 | 10398 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
11728 | 11728 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
13058 | 13058 | 2018-01-01 | MYR | Malaysia | 9.0 | 3.954 | 2.27617602427921 |
1094 | 1094 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
2424 | 2424 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
3754 | 3754 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
5084 | 5084 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
6414 | 6414 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
7744 | 7744 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
9074 | 9074 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
10404 | 10404 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
11734 | 11734 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
13064 | 13064 | 2018-01-01 | PLN | Poland | 10.1 | 3.40575 | 2.96557292813624 |
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 );