bigmac
420 rows where "date" is on date 2011-07-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
527 | 527 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
1857 | 1857 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
3187 | 3187 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
4517 | 4517 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
5847 | 5847 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
7177 | 7177 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
8507 | 8507 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
9837 | 9837 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
11167 | 11167 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
12497 | 12497 | 2011-07-01 | GBP | Britain | 2.39 | 0.614137444 | 3.8916369997462703 |
526 | 526 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
1856 | 1856 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
3186 | 3186 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
4516 | 4516 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
5846 | 5846 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
7176 | 7176 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
8506 | 8506 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
9836 | 9836 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
11166 | 11166 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
12496 | 12496 | 2011-07-01 | EUR | Euro area | 3.437660401 | 0.697520315 | 4.92840183586624 |
518 | 518 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
1848 | 1848 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
3178 | 3178 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
4508 | 4508 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
5838 | 5838 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
7168 | 7168 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
8498 | 8498 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
9828 | 9828 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
11158 | 11158 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
12488 | 12488 | 2011-07-01 | CHF | Switzerland | 6.5 | 0.80615 | 8.06301556782237 |
515 | 515 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
1845 | 1845 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
3175 | 3175 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
4505 | 4505 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
5835 | 5835 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
7165 | 7165 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
8495 | 8495 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
9825 | 9825 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
11155 | 11155 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
12485 | 12485 | 2011-07-01 | AUD | Australia | 4.56 | 0.922381589 | 4.9437240014121695 |
517 | 517 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
1847 | 1847 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
3177 | 3177 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
4507 | 4507 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
5837 | 5837 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
7167 | 7167 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
8497 | 8497 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
9827 | 9827 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
11157 | 11157 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
12487 | 12487 | 2011-07-01 | CAD | Canada | 4.73 | 0.94585 | 5.00079293756938 |
553 | 553 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
1883 | 1883 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
3213 | 3213 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
4543 | 4543 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
5873 | 5873 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
7203 | 7203 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
8533 | 8533 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
9863 | 9863 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
11193 | 11193 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
12523 | 12523 | 2011-07-01 | USD | United States | 4.065 | 1.0 | 4.065 |
539 | 539 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
1869 | 1869 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
3199 | 3199 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
4529 | 4529 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
5859 | 5859 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
7189 | 7189 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
8519 | 8519 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
9849 | 9849 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
11179 | 11179 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
12509 | 12509 | 2011-07-01 | NZD | New Zealand | 5.1 | 1.1560693640000002 | 4.41150000061761 |
546 | 546 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
1876 | 1876 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
3206 | 3206 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
4536 | 4536 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
5866 | 5866 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
7196 | 7196 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
8526 | 8526 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
9856 | 9856 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
11186 | 11186 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
12516 | 12516 | 2011-07-01 | SGD | Singapore | 4.41 | 1.20705 | 3.65353547906052 |
516 | 516 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
1846 | 1846 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
3176 | 3176 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
4506 | 4506 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
5836 | 5836 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
7166 | 7166 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
8496 | 8496 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
9826 | 9826 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
11156 | 11156 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
12486 | 12486 | 2011-07-01 | BRL | Brazil | 9.5 | 1.5416 | 6.1624286455630495 |
549 | 549 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
1879 | 1879 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
3209 | 3209 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
4539 | 4539 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
5869 | 5869 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
7199 | 7199 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
8529 | 8529 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
9859 | 9859 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
11189 | 11189 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
12519 | 12519 | 2011-07-01 | TRY | Turkey | 6.5 | 1.72285 | 3.77281829526656 |
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 );