bigmac
410 rows where "date" is on date 2010-07-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
486 | 486 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
1816 | 1816 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
3146 | 3146 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
4476 | 4476 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
5806 | 5806 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
7136 | 7136 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
8466 | 8466 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
9796 | 9796 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
11126 | 11126 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
12456 | 12456 | 2010-07-01 | GBP | Britain | 2.29 | 0.657375756 | 3.48354799990525 |
485 | 485 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
1815 | 1815 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
3145 | 3145 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
4475 | 4475 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
5805 | 5805 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
7135 | 7135 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
8465 | 8465 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
9795 | 9795 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
11125 | 11125 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
12455 | 12455 | 2010-07-01 | EUR | Euro area | 3.3800310710000003 | 0.78015291 | 4.33252382664316 |
511 | 511 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
1841 | 1841 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
3171 | 3171 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
4501 | 4501 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
5831 | 5831 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
7161 | 7161 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
8491 | 8491 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
9821 | 9821 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
11151 | 11151 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
12481 | 12481 | 2010-07-01 | USD | United States | 3.733333333 | 1.0 | 3.733333333 |
476 | 476 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
1806 | 1806 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
3136 | 3136 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
4466 | 4466 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
5796 | 5796 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
7126 | 7126 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
8456 | 8456 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
9786 | 9786 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
11116 | 11116 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
12446 | 12446 | 2010-07-01 | CAD | Canada | 4.17 | 1.04235 | 4.000575622391709 |
477 | 477 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
1807 | 1807 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
3137 | 3137 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
4467 | 4467 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
5797 | 5797 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
7127 | 7127 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
8457 | 8457 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
9787 | 9787 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
11117 | 11117 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
12447 | 12447 | 2010-07-01 | CHF | Switzerland | 6.5 | 1.05085 | 6.185468906123611 |
474 | 474 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
1804 | 1804 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
3134 | 3134 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
4464 | 4464 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
5794 | 5794 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
7124 | 7124 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
8454 | 8454 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
9784 | 9784 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
11114 | 11114 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
12444 | 12444 | 2010-07-01 | AUD | Australia | 4.35 | 1.133722578 | 3.8369175002881497 |
504 | 504 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
1834 | 1834 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
3164 | 3164 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
4494 | 4494 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
5824 | 5824 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
7154 | 7154 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
8484 | 8484 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
9814 | 9814 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
11144 | 11144 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
12474 | 12474 | 2010-07-01 | SGD | Singapore | 4.23 | 1.3742 | 3.0781545626546403 |
497 | 497 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
1827 | 1827 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
3157 | 3157 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
4487 | 4487 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
5817 | 5817 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
7147 | 7147 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
8477 | 8477 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
9807 | 9807 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
11137 | 11137 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
12467 | 12467 | 2010-07-01 | NZD | New Zealand | 5.0 | 1.39275766 | 3.5900000004308 |
507 | 507 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
1837 | 1837 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
3167 | 3167 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
4497 | 4497 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
5827 | 5827 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
7157 | 7157 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
8487 | 8487 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
9817 | 9817 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
11147 | 11147 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
12477 | 12477 | 2010-07-01 | TRY | Turkey | 5.95 | 1.5293 | 3.89066893349899 |
475 | 475 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
1805 | 1805 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
3135 | 3135 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
4465 | 4465 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
5795 | 5795 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
7125 | 7125 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
8455 | 8455 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
9785 | 9785 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
11115 | 11115 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
12445 | 12445 | 2010-07-01 | BRL | Brazil | 8.71 | 1.77495 | 4.907180483957299 |
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 );