bigmac
430 rows where "date" is on date 2017-07-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
1035 | 1035 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
2365 | 2365 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
3695 | 3695 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
5025 | 5025 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
6355 | 6355 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
7685 | 7685 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
9015 | 9015 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
10345 | 10345 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
11675 | 11675 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
13005 | 13005 | 2017-07-01 | GBP | Britain | 3.19 | 0.775885479 | 4.11143150160695 |
1034 | 1034 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
2364 | 2364 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
3694 | 3694 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
5024 | 5024 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
6354 | 6354 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
7684 | 7684 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
9014 | 9014 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
10344 | 10344 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
11674 | 11674 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
13004 | 13004 | 2017-07-01 | EUR | Euro area | 3.91 | 0.875695083 | 4.4650244998577895 |
1026 | 1026 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
2356 | 2356 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
3686 | 3686 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
5016 | 5016 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
6346 | 6346 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
7676 | 7676 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
9006 | 9006 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
10336 | 10336 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
11666 | 11666 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
12996 | 12996 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
1061 | 1061 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
2391 | 2391 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
3721 | 3721 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
5051 | 5051 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
6381 | 6381 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
7711 | 7711 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
9041 | 9041 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
10371 | 10371 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
11701 | 11701 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
13031 | 13031 | 2017-07-01 | USD | United States | 5.3 | 1.0 | 5.3 |
1025 | 1025 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
2355 | 2355 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
3685 | 3685 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
5015 | 5015 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
6345 | 6345 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
7675 | 7675 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
9005 | 9005 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
10335 | 10335 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
11665 | 11665 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
12995 | 12995 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
1023 | 1023 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
2353 | 2353 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
3683 | 3683 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
5013 | 5013 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
6343 | 6343 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
7673 | 7673 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
9003 | 9003 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
10333 | 10333 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
11663 | 11663 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
12993 | 12993 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
1047 | 1047 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
2377 | 2377 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
3707 | 3707 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
5037 | 5037 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
6367 | 6367 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
7697 | 7697 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
9027 | 9027 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
10357 | 10357 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
11687 | 11687 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
13017 | 13017 | 2017-07-01 | NZD | New Zealand | 6.1 | 1.376273053 | 4.43225999862689 |
1054 | 1054 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
2384 | 2384 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
3714 | 3714 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
5044 | 5044 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
6374 | 6374 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
7704 | 7704 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
9034 | 9034 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
10364 | 10364 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
11694 | 11694 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
13024 | 13024 | 2017-07-01 | SGD | Singapore | 5.6 | 1.3777 | 4.06474559047688 |
1024 | 1024 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
2354 | 2354 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
3684 | 3684 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
5014 | 5014 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
6344 | 6344 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
7674 | 7674 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
9004 | 9004 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
10334 | 10334 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
11664 | 11664 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
12994 | 12994 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
1049 | 1049 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
2379 | 2379 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
3709 | 3709 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
5039 | 5039 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
6369 | 6369 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
7699 | 7699 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
9029 | 9029 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
10359 | 10359 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
11689 | 11689 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
13019 | 13019 | 2017-07-01 | PEN | Peru | 10.5 | 3.2515 | 3.2292787944025805 |
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 );