bigmac
430 rows where "date" is on date 2015-01-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
820 | 820 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
2150 | 2150 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
3480 | 3480 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
4810 | 4810 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
6140 | 6140 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
7470 | 7470 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
8800 | 8800 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
10130 | 10130 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
11460 | 11460 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
12790 | 12790 | 2015-01-01 | GBP | Britain | 2.89 | 0.6615944429999999 | 4.36823499740308 |
811 | 811 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
2141 | 2141 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
3471 | 3471 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
4801 | 4801 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
6131 | 6131 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
7461 | 7461 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
8791 | 8791 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
10121 | 10121 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
11451 | 11451 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
12781 | 12781 | 2015-01-01 | CHF | Switzerland | 6.5 | 0.86165 | 7.54366622178379 |
819 | 819 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
2149 | 2149 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
3479 | 3479 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
4809 | 4809 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
6139 | 6139 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
7469 | 7469 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
8799 | 8799 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
10129 | 10129 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
11459 | 11459 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
12789 | 12789 | 2015-01-01 | EUR | Euro area | 3.68 | 0.8630734040000001 | 4.26383200194175 |
846 | 846 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
2176 | 2176 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
3506 | 3506 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
4836 | 4836 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
6166 | 6166 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
7496 | 7496 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
8826 | 8826 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
10156 | 10156 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
11486 | 11486 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
12816 | 12816 | 2015-01-01 | USD | United States | 4.79 | 1.0 | 4.79 |
808 | 808 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
2138 | 2138 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
3468 | 3468 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
4798 | 4798 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
6128 | 6128 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
7458 | 7458 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
8788 | 8788 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
10118 | 10118 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
11448 | 11448 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
12778 | 12778 | 2015-01-01 | AUD | Australia | 5.3 | 1.227219734 | 4.31870499892076 |
810 | 810 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
2140 | 2140 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
3470 | 3470 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
4800 | 4800 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
6130 | 6130 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
7460 | 7460 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
8790 | 8790 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
10120 | 10120 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
11450 | 11450 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
12780 | 12780 | 2015-01-01 | CAD | Canada | 5.7 | 1.22855 | 4.63961580725245 |
832 | 832 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
2162 | 2162 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
3492 | 3492 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
4822 | 4822 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
6152 | 6152 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
7482 | 7482 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
8812 | 8812 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
10142 | 10142 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
11472 | 11472 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
12802 | 12802 | 2015-01-01 | NZD | New Zealand | 5.9 | 1.313283866 | 4.49255500105261 |
839 | 839 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
2169 | 2169 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
3499 | 3499 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
4829 | 4829 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
6159 | 6159 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
7489 | 7489 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
8819 | 8819 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
10149 | 10149 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
11479 | 11479 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
12809 | 12809 | 2015-01-01 | SGD | Singapore | 4.7 | 1.33315 | 3.5254847541537004 |
842 | 842 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
2172 | 2172 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
3502 | 3502 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
4832 | 4832 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
6162 | 6162 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
7492 | 7492 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
8822 | 8822 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
10152 | 10152 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
11482 | 11482 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
12812 | 12812 | 2015-01-01 | TRY | Turkey | 9.25 | 2.33345 | 3.964087509910221 |
809 | 809 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
2139 | 2139 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
3469 | 3469 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
4799 | 4799 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
6129 | 6129 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
7459 | 7459 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
8789 | 8789 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
10119 | 10119 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
11449 | 11449 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
12779 | 12779 | 2015-01-01 | BRL | Brazil | 13.5 | 2.59275 | 5.20682672837721 |
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 );