bigmac
430 rows where "date" is on date 2015-07-01 sorted by local_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price ▼ | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
863 | 863 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
2193 | 2193 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
3523 | 3523 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
4853 | 4853 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
6183 | 6183 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
7513 | 7513 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
8843 | 8843 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
10173 | 10173 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
11503 | 11503 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
12833 | 12833 | 2015-07-01 | GBP | Britain | 2.89 | 0.640450877 | 4.512446002943019 |
862 | 862 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
2192 | 2192 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
3522 | 3522 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
4852 | 4852 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
6182 | 6182 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
7512 | 7512 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
8842 | 8842 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
10172 | 10172 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
11502 | 11502 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
12832 | 12832 | 2015-07-01 | EUR | Euro area | 3.7 | 0.912700224 | 4.05390499827466 |
882 | 882 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
2212 | 2212 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
3542 | 3542 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
4872 | 4872 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
6202 | 6202 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
7532 | 7532 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
8862 | 8862 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
10192 | 10192 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
11522 | 11522 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
12852 | 12852 | 2015-07-01 | SGD | Singapore | 4.7 | 1.3664 | 3.4396955503512903 |
889 | 889 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
2219 | 2219 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
3549 | 3549 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
4879 | 4879 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
6209 | 6209 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
7539 | 7539 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
8869 | 8869 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
10199 | 10199 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
11529 | 11529 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
12859 | 12859 | 2015-07-01 | USD | United States | 4.79 | 1.0 | 4.79 |
851 | 851 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
2181 | 2181 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
3511 | 3511 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
4841 | 4841 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
6171 | 6171 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
7501 | 7501 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
8831 | 8831 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
10161 | 10161 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
11491 | 11491 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
12821 | 12821 | 2015-07-01 | AUD | Australia | 5.3 | 1.35126005 | 3.9222649999901895 |
853 | 853 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
2183 | 2183 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
3513 | 3513 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
4843 | 4843 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
6173 | 6173 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
7503 | 7503 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
8833 | 8833 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
10163 | 10163 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
11493 | 11493 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
12823 | 12823 | 2015-07-01 | CAD | Canada | 5.85 | 1.2897 | 4.53593859036985 |
875 | 875 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
2205 | 2205 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
3535 | 3535 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
4865 | 4865 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
6195 | 6195 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
7525 | 7525 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
8855 | 8855 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
10185 | 10185 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
11515 | 11515 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
12845 | 12845 | 2015-07-01 | NZD | New Zealand | 5.9 | 1.509092281 | 3.90963499998182 |
854 | 854 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
2184 | 2184 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
3514 | 3514 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
4844 | 4844 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
6174 | 6174 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
7504 | 7504 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
8834 | 8834 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
10164 | 10164 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
11494 | 11494 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
12824 | 12824 | 2015-07-01 | CHF | Switzerland | 6.5 | 0.9528 | 6.82199832073888 |
873 | 873 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
2203 | 2203 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
3533 | 3533 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
4863 | 4863 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
6193 | 6193 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
7523 | 7523 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
8853 | 8853 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
10183 | 10183 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
11513 | 11513 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
12843 | 12843 | 2015-07-01 | MYR | Malaysia | 7.65 | 3.8065 | 2.00972021542099 |
879 | 879 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
2209 | 2209 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
3539 | 3539 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
4869 | 4869 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
6199 | 6199 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
7529 | 7529 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
8859 | 8859 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
10189 | 10189 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
11519 | 11519 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
12849 | 12849 | 2015-07-01 | PLN | Poland | 9.6 | 3.7736 | 2.5439898240407004 |
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 );