bigmac
430 rows where "date" is on date 2016-01-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
906 | 906 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
2236 | 2236 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
3566 | 3566 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
4896 | 4896 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
6226 | 6226 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
7556 | 7556 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
8886 | 8886 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
10216 | 10216 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
11546 | 11546 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
12876 | 12876 | 2016-01-01 | GBP | Britain | 2.89 | 0.684532977 | 4.22185650232012 |
905 | 905 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
2235 | 2235 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
3565 | 3565 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
4895 | 4895 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
6225 | 6225 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
7555 | 7555 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
8885 | 8885 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
10215 | 10215 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
11545 | 11545 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
12875 | 12875 | 2016-01-01 | EUR | Euro area | 3.72 | 0.930232558 | 3.9990000005998496 |
932 | 932 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
2262 | 2262 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
3592 | 3592 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
4922 | 4922 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
6252 | 6252 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
7582 | 7582 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
8912 | 8912 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
10242 | 10242 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
11572 | 11572 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
12902 | 12902 | 2016-01-01 | USD | United States | 4.93 | 1.0 | 4.93 |
897 | 897 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
2227 | 2227 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
3557 | 3557 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
4887 | 4887 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
6217 | 6217 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
7547 | 7547 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
8877 | 8877 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
10207 | 10207 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
11537 | 11537 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
12867 | 12867 | 2016-01-01 | CHF | Switzerland | 6.5 | 1.0088 | 6.4432989690721705 |
896 | 896 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
2226 | 2226 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
3556 | 3556 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
4886 | 4886 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
6216 | 6216 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
7546 | 7546 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
8876 | 8876 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
10206 | 10206 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
11536 | 11536 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
12866 | 12866 | 2016-01-01 | CAD | Canada | 5.84 | 1.4092 | 4.14419528810673 |
894 | 894 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
2224 | 2224 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
3554 | 3554 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
4884 | 4884 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
6214 | 6214 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
7544 | 7544 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
8874 | 8874 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
10204 | 10204 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
11534 | 11534 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
12864 | 12864 | 2016-01-01 | AUD | Australia | 5.3 | 1.415728746 | 3.7436550009842096 |
925 | 925 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
2255 | 2255 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
3585 | 3585 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
4915 | 4915 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
6245 | 6245 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
7575 | 7575 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
8905 | 8905 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
10235 | 10235 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
11565 | 11565 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
12895 | 12895 | 2016-01-01 | SGD | Singapore | 4.7 | 1.43725 | 3.27013393633675 |
918 | 918 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
2248 | 2248 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
3578 | 3578 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
4908 | 4908 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
6238 | 6238 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
7568 | 7568 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
8898 | 8898 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
10228 | 10228 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
11558 | 11558 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
12888 | 12888 | 2016-01-01 | NZD | New Zealand | 5.9 | 1.508068165 | 3.91228999917255 |
928 | 928 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
2258 | 2258 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
3588 | 3588 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
4918 | 4918 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
6248 | 6248 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
7578 | 7578 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
8908 | 8908 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
10238 | 10238 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
11568 | 11568 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
12898 | 12898 | 2016-01-01 | TRY | Turkey | 10.25 | 3.0096 | 3.40576820839979 |
920 | 920 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
2250 | 2250 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
3580 | 3580 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
4910 | 4910 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
6240 | 6240 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
7570 | 7570 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
8900 | 8900 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
10230 | 10230 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
11560 | 11560 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
12890 | 12890 | 2016-01-01 | PEN | Peru | 10.0 | 3.418 | 2.9256875365710897 |
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 );