bigmac
430 rows where "date" is on date 2014-07-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
777 | 777 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
2107 | 2107 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
3437 | 3437 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
4767 | 4767 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
6097 | 6097 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
7427 | 7427 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
8757 | 8757 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
10087 | 10087 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
11417 | 11417 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
12747 | 12747 | 2014-07-01 | GBP | Britain | 2.89 | 0.586785589 | 4.92513799618893 |
776 | 776 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
2106 | 2106 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
3436 | 3436 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
4766 | 4766 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
6096 | 6096 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
7426 | 7426 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
8756 | 8756 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
10086 | 10086 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
11416 | 11416 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
12746 | 12746 | 2014-07-01 | EUR | Euro area | 3.67923829 | 0.7427489140000001 | 4.95354246993891 |
768 | 768 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
2098 | 2098 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
3428 | 3428 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
4758 | 4758 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
6088 | 6088 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
7418 | 7418 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
8748 | 8748 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
10078 | 10078 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
11408 | 11408 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
12738 | 12738 | 2014-07-01 | CHF | Switzerland | 6.16 | 0.9024 | 6.826241134751769 |
803 | 803 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
2133 | 2133 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
3463 | 3463 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
4793 | 4793 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
6123 | 6123 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
7453 | 7453 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
8783 | 8783 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
10113 | 10113 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
11443 | 11443 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
12773 | 12773 | 2014-07-01 | USD | United States | 4.795 | 1.0 | 4.795 |
765 | 765 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
2095 | 2095 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
3425 | 3425 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
4755 | 4755 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
6085 | 6085 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
7415 | 7415 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
8745 | 8745 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
10075 | 10075 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
11405 | 11405 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
12735 | 12735 | 2014-07-01 | AUD | Australia | 5.1 | 1.059378145 | 4.81414500013119 |
767 | 767 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
2097 | 2097 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
3427 | 3427 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
4757 | 4757 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
6087 | 6087 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
7417 | 7417 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
8747 | 8747 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
10077 | 10077 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
11407 | 11407 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
12737 | 12737 | 2014-07-01 | CAD | Canada | 5.64 | 1.07405 | 5.25115218099716 |
789 | 789 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
2119 | 2119 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
3449 | 3449 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
4779 | 4779 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
6109 | 6109 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
7439 | 7439 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
8769 | 8769 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
10099 | 10099 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
11429 | 11429 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
12759 | 12759 | 2014-07-01 | NZD | New Zealand | 5.7 | 1.152737752 | 4.94475000069227 |
796 | 796 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
2126 | 2126 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
3456 | 3456 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
4786 | 4786 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
6116 | 6116 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
7446 | 7446 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
8776 | 8776 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
10106 | 10106 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
11436 | 11436 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
12766 | 12766 | 2014-07-01 | SGD | Singapore | 4.7 | 1.238 | 3.79644588045234 |
799 | 799 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
2129 | 2129 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
3459 | 3459 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
4789 | 4789 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
6119 | 6119 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
7449 | 7449 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
8779 | 8779 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
10109 | 10109 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
11439 | 11439 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
12769 | 12769 | 2014-07-01 | TRY | Turkey | 9.25 | 2.09125 | 4.42319187089062 |
766 | 766 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
2096 | 2096 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
3426 | 3426 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
4756 | 4756 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
6086 | 6086 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
7416 | 7416 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
8746 | 8746 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
10076 | 10076 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
11406 | 11406 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
12736 | 12736 | 2014-07-01 | BRL | Brazil | 13.0 | 2.22025 | 5.855196486882111 |
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 );