bigmac
310 rows where "date" is on date 2006-01-01 sorted by local_price
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 |
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 |
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 |
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 |
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 |
199 | 199 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
1529 | 1529 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
2859 | 2859 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
4189 | 4189 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
5519 | 5519 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
6849 | 6849 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
8179 | 8179 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
9509 | 9509 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
10839 | 10839 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
12169 | 12169 | 2006-01-01 | ARS | Argentina | 4.75 | 3.0638 | 1.5503622951889802 |
217 | 217 | 2006-01-01 | MYR | Malaysia | 5.5 | 3.7488 | 1.46713615023474 |
1547 | 1547 | 2006-01-01 | MYR | Malaysia | 5.5 | 3.7488 | 1.46713615023474 |
2877 | 2877 | 2006-01-01 | MYR | Malaysia | 5.5 | 3.7488 | 1.46713615023474 |
4207 | 4207 | 2006-01-01 | MYR | Malaysia | 5.5 | 3.7488 | 1.46713615023474 |
5537 | 5537 | 2006-01-01 | MYR | Malaysia | 5.5 | 3.7488 | 1.46713615023474 |
6867 | 6867 | 2006-01-01 | MYR | Malaysia | 5.5 | 3.7488 | 1.46713615023474 |
8197 | 8197 | 2006-01-01 | MYR | Malaysia | 5.5 | 3.7488 | 1.46713615023474 |
9527 | 9527 | 2006-01-01 | MYR | Malaysia | 5.5 | 3.7488 | 1.46713615023474 |
10857 | 10857 | 2006-01-01 | MYR | Malaysia | 5.5 | 3.7488 | 1.46713615023474 |
12187 | 12187 | 2006-01-01 | MYR | Malaysia | 5.5 | 3.7488 | 1.46713615023474 |
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 );