bigmac
410 rows where "date" is on date 2010-01-01 sorted by local_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price ▼ | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
445 | 445 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
1775 | 1775 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
3105 | 3105 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
4435 | 4435 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
5765 | 5765 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
7095 | 7095 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
8425 | 8425 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
9755 | 9755 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
11085 | 11085 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
12415 | 12415 | 2010-01-01 | GBP | Britain | 2.29 | 0.623752495 | 3.671328000058741 |
444 | 444 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
1774 | 1774 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
3104 | 3104 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
4434 | 4434 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
5764 | 5764 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
7094 | 7094 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
8424 | 8424 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
9754 | 9754 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
11084 | 11084 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
12414 | 12414 | 2010-01-01 | EUR | Euro area | 3.36 | 0.693649638 | 4.84394399698368 |
470 | 470 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
1800 | 1800 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
3130 | 3130 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
4460 | 4460 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
5790 | 5790 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
7120 | 7120 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
8450 | 8450 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
9780 | 9780 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
11110 | 11110 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
12440 | 12440 | 2010-01-01 | USD | United States | 3.58 | 1.0 | 3.58 |
435 | 435 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
1765 | 1765 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
3095 | 3095 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
4425 | 4425 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
5755 | 5755 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
7085 | 7085 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
8415 | 8415 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
9745 | 9745 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
11075 | 11075 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
12405 | 12405 | 2010-01-01 | CAD | Canada | 4.12 | 1.0368 | 3.9737654320987694 |
433 | 433 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
1763 | 1763 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
3093 | 3093 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
4423 | 4423 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
5753 | 5753 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
7083 | 7083 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
8413 | 8413 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
9743 | 9743 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
11073 | 11073 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
12403 | 12403 | 2010-01-01 | AUD | Australia | 4.35 | 1.09355 | 3.97787023912944 |
463 | 463 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
1793 | 1793 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
3123 | 3123 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
4453 | 4453 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
5783 | 5783 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
7113 | 7113 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
8443 | 8443 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
9773 | 9773 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
11103 | 11103 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
12433 | 12433 | 2010-01-01 | SGD | Singapore | 4.45 | 1.39555 | 3.18870696141306 |
456 | 456 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
1786 | 1786 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
3116 | 3116 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
4446 | 4446 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
5776 | 5776 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
7106 | 7106 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
8436 | 8436 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
9766 | 9766 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
11096 | 11096 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
12426 | 12426 | 2010-01-01 | NZD | New Zealand | 4.9 | 1.35685 | 3.611305597523681 |
466 | 466 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
1796 | 1796 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
3126 | 3126 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
4456 | 4456 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
5786 | 5786 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
7116 | 7116 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
8446 | 8446 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
9776 | 9776 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
11106 | 11106 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
12436 | 12436 | 2010-01-01 | TRY | Turkey | 5.65 | 1.47455 | 3.83167746092028 |
436 | 436 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
1766 | 1766 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
3096 | 3096 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
4426 | 4426 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
5756 | 5756 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
7086 | 7086 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
8416 | 8416 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
9746 | 9746 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
11076 | 11076 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
12406 | 12406 | 2010-01-01 | CHF | Switzerland | 6.5 | 1.03115 | 6.30364156524269 |
432 | 432 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
1762 | 1762 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
3092 | 3092 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
4422 | 4422 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
5752 | 5752 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
7082 | 7082 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
8412 | 8412 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
9742 | 9742 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
11072 | 11072 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
12402 | 12402 | 2010-01-01 | ARS | Argentina | 7.0 | 3.7985 | 1.84283269711728 |
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 );