bigmac
400 rows where "date" is on date 2005-06-01 sorted by local_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price ▼ | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
173 | 173 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
1503 | 1503 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
2833 | 2833 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
4163 | 4163 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
5493 | 5493 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
6823 | 6823 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
8153 | 8153 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
9483 | 9483 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
10813 | 10813 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
12143 | 12143 | 2005-06-01 | GBP | Britain | 1.88 | 0.546448087 | 3.44040000271792 |
172 | 172 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
1502 | 1502 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
2832 | 2832 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
4162 | 4162 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
5492 | 5492 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
6822 | 6822 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
8152 | 8152 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
9482 | 9482 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
10812 | 10812 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
12142 | 12142 | 2005-06-01 | EUR | Euro area | 2.92 | 0.814929509 | 3.58313199823029 |
197 | 197 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
1527 | 1527 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
2857 | 2857 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
4187 | 4187 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
5517 | 5517 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
6847 | 6847 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
8177 | 8177 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
9507 | 9507 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
10837 | 10837 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
12167 | 12167 | 2005-06-01 | USD | United States | 3.06 | 1.0 | 3.06 |
161 | 161 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
1491 | 1491 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
2821 | 2821 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
4151 | 4151 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
5481 | 5481 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
6811 | 6811 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
8141 | 8141 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
9471 | 9471 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
10801 | 10801 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
12131 | 12131 | 2005-06-01 | AUD | Australia | 3.25 | 1.3015 | 2.4971187091817098 |
163 | 163 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
1493 | 1493 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
2823 | 2823 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
4153 | 4153 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
5483 | 5483 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
6813 | 6813 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
8143 | 8143 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
9473 | 9473 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
10803 | 10803 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
12133 | 12133 | 2005-06-01 | CAD | Canada | 3.28 | 1.2494 | 2.6252601248599303 |
190 | 190 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
1520 | 1520 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
2850 | 2850 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
4180 | 4180 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
5510 | 5510 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
6840 | 6840 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
8170 | 8170 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
9500 | 9500 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
10830 | 10830 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
12160 | 12160 | 2005-06-01 | SGD | Singapore | 3.6 | 1.6607 | 2.16776058288673 |
193 | 193 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
1523 | 1523 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
2853 | 2853 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
4183 | 4183 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
5513 | 5513 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
6843 | 6843 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
8173 | 8173 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
9503 | 9503 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
10833 | 10833 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
12163 | 12163 | 2005-06-01 | TRY | Turkey | 4.0 | 1.369 | 2.9218407596786 |
183 | 183 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
1513 | 1513 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
2843 | 2843 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
4173 | 4173 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
5503 | 5503 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
6833 | 6833 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
8163 | 8163 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
9493 | 9493 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
10823 | 10823 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
12153 | 12153 | 2005-06-01 | NZD | New Zealand | 4.45 | 1.4023 | 3.1733580546245497 |
160 | 160 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
1490 | 1490 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
2820 | 2820 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
4150 | 4150 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
5480 | 5480 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
6810 | 6810 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
8140 | 8140 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
9470 | 9470 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
10800 | 10800 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
12130 | 12130 | 2005-06-01 | ARS | Argentina | 4.75 | 2.897 | 1.6396272005522998 |
181 | 181 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
1511 | 1511 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
2841 | 2841 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
4171 | 4171 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
5501 | 5501 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
6831 | 6831 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
8161 | 8161 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
9491 | 9491 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
10821 | 10821 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
12151 | 12151 | 2005-06-01 | MYR | Malaysia | 5.25 | 3.8 | 1.38157894736842 |
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 );