bigmac
310 rows where "date" is on date 2006-01-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
210 | 210 | 2006-01-01 | GBP | Britain | 1.88 | 0.566925563 | 3.3161319980909 |
1540 | 1540 | 2006-01-01 | GBP | Britain | 1.88 | 0.566925563 | 3.3161319980909 |
2870 | 2870 | 2006-01-01 | GBP | Britain | 1.88 | 0.566925563 | 3.3161319980909 |
4200 | 4200 | 2006-01-01 | GBP | Britain | 1.88 | 0.566925563 | 3.3161319980909 |
5530 | 5530 | 2006-01-01 | GBP | Britain | 1.88 | 0.566925563 | 3.3161319980909 |
6860 | 6860 | 2006-01-01 | GBP | Britain | 1.88 | 0.566925563 | 3.3161319980909 |
8190 | 8190 | 2006-01-01 | GBP | Britain | 1.88 | 0.566925563 | 3.3161319980909 |
9520 | 9520 | 2006-01-01 | GBP | Britain | 1.88 | 0.566925563 | 3.3161319980909 |
10850 | 10850 | 2006-01-01 | GBP | Britain | 1.88 | 0.566925563 | 3.3161319980909 |
12180 | 12180 | 2006-01-01 | GBP | Britain | 1.88 | 0.566925563 | 3.3161319980909 |
209 | 209 | 2006-01-01 | EUR | Euro area | 2.91 | 0.82815735 | 3.5138249995607698 |
1539 | 1539 | 2006-01-01 | EUR | Euro area | 2.91 | 0.82815735 | 3.5138249995607698 |
2869 | 2869 | 2006-01-01 | EUR | Euro area | 2.91 | 0.82815735 | 3.5138249995607698 |
4199 | 4199 | 2006-01-01 | EUR | Euro area | 2.91 | 0.82815735 | 3.5138249995607698 |
5529 | 5529 | 2006-01-01 | EUR | Euro area | 2.91 | 0.82815735 | 3.5138249995607698 |
6859 | 6859 | 2006-01-01 | EUR | Euro area | 2.91 | 0.82815735 | 3.5138249995607698 |
8189 | 8189 | 2006-01-01 | EUR | Euro area | 2.91 | 0.82815735 | 3.5138249995607698 |
9519 | 9519 | 2006-01-01 | EUR | Euro area | 2.91 | 0.82815735 | 3.5138249995607698 |
10849 | 10849 | 2006-01-01 | EUR | Euro area | 2.91 | 0.82815735 | 3.5138249995607698 |
12179 | 12179 | 2006-01-01 | EUR | Euro area | 2.91 | 0.82815735 | 3.5138249995607698 |
228 | 228 | 2006-01-01 | USD | United States | 3.15 | 1.0 | 3.15 |
1558 | 1558 | 2006-01-01 | USD | United States | 3.15 | 1.0 | 3.15 |
2888 | 2888 | 2006-01-01 | USD | United States | 3.15 | 1.0 | 3.15 |
4218 | 4218 | 2006-01-01 | USD | United States | 3.15 | 1.0 | 3.15 |
5548 | 5548 | 2006-01-01 | USD | United States | 3.15 | 1.0 | 3.15 |
6878 | 6878 | 2006-01-01 | USD | United States | 3.15 | 1.0 | 3.15 |
8208 | 8208 | 2006-01-01 | USD | United States | 3.15 | 1.0 | 3.15 |
9538 | 9538 | 2006-01-01 | USD | United States | 3.15 | 1.0 | 3.15 |
10868 | 10868 | 2006-01-01 | USD | United States | 3.15 | 1.0 | 3.15 |
12198 | 12198 | 2006-01-01 | USD | United States | 3.15 | 1.0 | 3.15 |
202 | 202 | 2006-01-01 | CAD | Canada | 3.52 | 1.1704 | 3.00751879699248 |
1532 | 1532 | 2006-01-01 | CAD | Canada | 3.52 | 1.1704 | 3.00751879699248 |
2862 | 2862 | 2006-01-01 | CAD | Canada | 3.52 | 1.1704 | 3.00751879699248 |
4192 | 4192 | 2006-01-01 | CAD | Canada | 3.52 | 1.1704 | 3.00751879699248 |
5522 | 5522 | 2006-01-01 | CAD | Canada | 3.52 | 1.1704 | 3.00751879699248 |
6852 | 6852 | 2006-01-01 | CAD | Canada | 3.52 | 1.1704 | 3.00751879699248 |
8182 | 8182 | 2006-01-01 | CAD | Canada | 3.52 | 1.1704 | 3.00751879699248 |
9512 | 9512 | 2006-01-01 | CAD | Canada | 3.52 | 1.1704 | 3.00751879699248 |
10842 | 10842 | 2006-01-01 | CAD | Canada | 3.52 | 1.1704 | 3.00751879699248 |
12172 | 12172 | 2006-01-01 | CAD | Canada | 3.52 | 1.1704 | 3.00751879699248 |
203 | 203 | 2006-01-01 | CHF | Switzerland | 6.3 | 1.2776 | 4.931120851596741 |
1533 | 1533 | 2006-01-01 | CHF | Switzerland | 6.3 | 1.2776 | 4.931120851596741 |
2863 | 2863 | 2006-01-01 | CHF | Switzerland | 6.3 | 1.2776 | 4.931120851596741 |
4193 | 4193 | 2006-01-01 | CHF | Switzerland | 6.3 | 1.2776 | 4.931120851596741 |
5523 | 5523 | 2006-01-01 | CHF | Switzerland | 6.3 | 1.2776 | 4.931120851596741 |
6853 | 6853 | 2006-01-01 | CHF | Switzerland | 6.3 | 1.2776 | 4.931120851596741 |
8183 | 8183 | 2006-01-01 | CHF | Switzerland | 6.3 | 1.2776 | 4.931120851596741 |
9513 | 9513 | 2006-01-01 | CHF | Switzerland | 6.3 | 1.2776 | 4.931120851596741 |
10843 | 10843 | 2006-01-01 | CHF | Switzerland | 6.3 | 1.2776 | 4.931120851596741 |
12173 | 12173 | 2006-01-01 | CHF | Switzerland | 6.3 | 1.2776 | 4.931120851596741 |
200 | 200 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
1530 | 1530 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
2860 | 2860 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
4190 | 4190 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
5520 | 5520 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
6850 | 6850 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
8180 | 8180 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
9510 | 9510 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
10840 | 10840 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
12170 | 12170 | 2006-01-01 | AUD | Australia | 3.25 | 1.3308 | 2.4421400661256403 |
226 | 226 | 2006-01-01 | TRY | Turkey | 4.1 | 1.3365 | 3.06771417882529 |
1556 | 1556 | 2006-01-01 | TRY | Turkey | 4.1 | 1.3365 | 3.06771417882529 |
2886 | 2886 | 2006-01-01 | TRY | Turkey | 4.1 | 1.3365 | 3.06771417882529 |
4216 | 4216 | 2006-01-01 | TRY | Turkey | 4.1 | 1.3365 | 3.06771417882529 |
5546 | 5546 | 2006-01-01 | TRY | Turkey | 4.1 | 1.3365 | 3.06771417882529 |
6876 | 6876 | 2006-01-01 | TRY | Turkey | 4.1 | 1.3365 | 3.06771417882529 |
8206 | 8206 | 2006-01-01 | TRY | Turkey | 4.1 | 1.3365 | 3.06771417882529 |
9536 | 9536 | 2006-01-01 | TRY | Turkey | 4.1 | 1.3365 | 3.06771417882529 |
10866 | 10866 | 2006-01-01 | TRY | Turkey | 4.1 | 1.3365 | 3.06771417882529 |
12196 | 12196 | 2006-01-01 | TRY | Turkey | 4.1 | 1.3365 | 3.06771417882529 |
218 | 218 | 2006-01-01 | NZD | New Zealand | 4.45 | 1.4467 | 3.07596599156701 |
1548 | 1548 | 2006-01-01 | NZD | New Zealand | 4.45 | 1.4467 | 3.07596599156701 |
2878 | 2878 | 2006-01-01 | NZD | New Zealand | 4.45 | 1.4467 | 3.07596599156701 |
4208 | 4208 | 2006-01-01 | NZD | New Zealand | 4.45 | 1.4467 | 3.07596599156701 |
5538 | 5538 | 2006-01-01 | NZD | New Zealand | 4.45 | 1.4467 | 3.07596599156701 |
6868 | 6868 | 2006-01-01 | NZD | New Zealand | 4.45 | 1.4467 | 3.07596599156701 |
8198 | 8198 | 2006-01-01 | NZD | New Zealand | 4.45 | 1.4467 | 3.07596599156701 |
9528 | 9528 | 2006-01-01 | NZD | New Zealand | 4.45 | 1.4467 | 3.07596599156701 |
10858 | 10858 | 2006-01-01 | NZD | New Zealand | 4.45 | 1.4467 | 3.07596599156701 |
12188 | 12188 | 2006-01-01 | NZD | New Zealand | 4.45 | 1.4467 | 3.07596599156701 |
223 | 223 | 2006-01-01 | SGD | Singapore | 3.6 | 1.6353 | 2.2014309301045696 |
1553 | 1553 | 2006-01-01 | SGD | Singapore | 3.6 | 1.6353 | 2.2014309301045696 |
2883 | 2883 | 2006-01-01 | SGD | Singapore | 3.6 | 1.6353 | 2.2014309301045696 |
4213 | 4213 | 2006-01-01 | SGD | Singapore | 3.6 | 1.6353 | 2.2014309301045696 |
5543 | 5543 | 2006-01-01 | SGD | Singapore | 3.6 | 1.6353 | 2.2014309301045696 |
6873 | 6873 | 2006-01-01 | SGD | Singapore | 3.6 | 1.6353 | 2.2014309301045696 |
8203 | 8203 | 2006-01-01 | SGD | Singapore | 3.6 | 1.6353 | 2.2014309301045696 |
9533 | 9533 | 2006-01-01 | SGD | Singapore | 3.6 | 1.6353 | 2.2014309301045696 |
10863 | 10863 | 2006-01-01 | SGD | Singapore | 3.6 | 1.6353 | 2.2014309301045696 |
12193 | 12193 | 2006-01-01 | SGD | Singapore | 3.6 | 1.6353 | 2.2014309301045696 |
201 | 201 | 2006-01-01 | BRL | Brazil | 6.2 | 2.2615 | 2.74154322352421 |
1531 | 1531 | 2006-01-01 | BRL | Brazil | 6.2 | 2.2615 | 2.74154322352421 |
2861 | 2861 | 2006-01-01 | BRL | Brazil | 6.2 | 2.2615 | 2.74154322352421 |
4191 | 4191 | 2006-01-01 | BRL | Brazil | 6.2 | 2.2615 | 2.74154322352421 |
5521 | 5521 | 2006-01-01 | BRL | Brazil | 6.2 | 2.2615 | 2.74154322352421 |
6851 | 6851 | 2006-01-01 | BRL | Brazil | 6.2 | 2.2615 | 2.74154322352421 |
8181 | 8181 | 2006-01-01 | BRL | Brazil | 6.2 | 2.2615 | 2.74154322352421 |
9511 | 9511 | 2006-01-01 | BRL | Brazil | 6.2 | 2.2615 | 2.74154322352421 |
10841 | 10841 | 2006-01-01 | BRL | Brazil | 6.2 | 2.2615 | 2.74154322352421 |
12171 | 12171 | 2006-01-01 | BRL | Brazil | 6.2 | 2.2615 | 2.74154322352421 |
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 );