bigmac
420 rows where "date" is on date 2013-01-01 sorted by local_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price ▼ | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
651 | 651 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
1981 | 1981 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
3311 | 3311 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
4641 | 4641 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
5971 | 5971 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
7301 | 7301 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
8631 | 8631 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
9961 | 9961 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
11291 | 11291 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
12621 | 12621 | 2013-01-01 | GBP | Britain | 2.69 | 0.633211968 | 4.248182498028839 |
650 | 650 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
1980 | 1980 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
3310 | 3310 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
4640 | 4640 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
5970 | 5970 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
7300 | 7300 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
8630 | 8630 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
9960 | 9960 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
11290 | 11290 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
12620 | 12620 | 2013-01-01 | EUR | Euro area | 3.594849572 | 0.7369468290000001 | 4.878031128620269 |
677 | 677 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
2007 | 2007 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
3337 | 3337 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
4667 | 4667 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
5997 | 5997 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
7327 | 7327 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
8657 | 8657 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
9987 | 9987 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
11317 | 11317 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
12647 | 12647 | 2013-01-01 | USD | United States | 4.367395833 | 1.0 | 4.367395833 |
670 | 670 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
2000 | 2000 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
3330 | 3330 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
4660 | 4660 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
5990 | 5990 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
7320 | 7320 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
8650 | 8650 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
9980 | 9980 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
11310 | 11310 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
12640 | 12640 | 2013-01-01 | SGD | Singapore | 4.5 | 1.23485 | 3.64416730777017 |
639 | 639 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
1969 | 1969 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
3299 | 3299 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
4629 | 4629 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
5959 | 5959 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
7289 | 7289 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
8619 | 8619 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
9949 | 9949 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
11279 | 11279 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
12609 | 12609 | 2013-01-01 | AUD | Australia | 4.7 | 0.959094615 | 4.90045499838408 |
663 | 663 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
1993 | 1993 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
3323 | 3323 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
4653 | 4653 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
5983 | 5983 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
7313 | 7313 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
8643 | 8643 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
9973 | 9973 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
11303 | 11303 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
12633 | 12633 | 2013-01-01 | NZD | New Zealand | 5.2 | 1.202428906 | 4.32458000140592 |
641 | 641 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
1971 | 1971 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
3301 | 3301 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
4631 | 4631 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
5961 | 5961 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
7291 | 7291 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
8621 | 8621 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
9951 | 9951 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
11281 | 11281 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
12611 | 12611 | 2013-01-01 | CAD | Canada | 5.41 | 1.0029 | 5.394356366537041 |
642 | 642 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
1972 | 1972 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
3302 | 3302 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
4632 | 4632 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
5962 | 5962 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
7292 | 7292 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
8622 | 8622 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
9952 | 9952 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
11282 | 11282 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
12612 | 12612 | 2013-01-01 | CHF | Switzerland | 6.5 | 0.9123 | 7.12484928203442 |
661 | 661 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
1991 | 1991 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
3321 | 3321 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
4651 | 4651 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
5981 | 5981 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
7311 | 7311 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
8641 | 8641 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
9971 | 9971 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
11301 | 11301 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
12631 | 12631 | 2013-01-01 | MYR | Malaysia | 7.95 | 3.083 | 2.5786571521245496 |
673 | 673 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
2003 | 2003 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
3333 | 3333 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
4663 | 4663 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
5993 | 5993 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
7323 | 7323 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
8653 | 8653 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
9983 | 9983 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
11313 | 11313 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
12643 | 12643 | 2013-01-01 | TRY | Turkey | 8.45 | 1.76875 | 4.7773851590106 |
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 );