bigmac
430 rows where "date" is on date 2017-07-01 sorted by currency_code
This data as json, CSV (advanced)
Link | rowid | date | currency_code ▼ | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
1021 | 1021 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
2351 | 2351 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
3681 | 3681 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
5011 | 5011 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
6341 | 6341 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
7671 | 7671 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
9001 | 9001 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
10331 | 10331 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
11661 | 11661 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
12991 | 12991 | 2017-07-01 | AED | UAE | 14.0 | 3.673 | 3.81159814865233 |
1022 | 1022 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
2352 | 2352 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
3682 | 3682 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
5012 | 5012 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
6342 | 6342 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
7672 | 7672 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
9002 | 9002 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
10332 | 10332 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
11662 | 11662 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
12992 | 12992 | 2017-07-01 | ARS | Argentina | 70.0 | 16.9675 | 4.12553410932665 |
1023 | 1023 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
2353 | 2353 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
3683 | 3683 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
5013 | 5013 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
6343 | 6343 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
7673 | 7673 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
9003 | 9003 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
10333 | 10333 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
11663 | 11663 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
12993 | 12993 | 2017-07-01 | AUD | Australia | 5.9 | 1.303016483 | 4.52795500055083 |
1024 | 1024 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
2354 | 2354 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
3684 | 3684 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
5014 | 5014 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
6344 | 6344 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
7674 | 7674 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
9004 | 9004 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
10334 | 10334 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
11664 | 11664 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
12994 | 12994 | 2017-07-01 | BRL | Brazil | 16.5 | 3.2343 | 5.10156757258139 |
1025 | 1025 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
2355 | 2355 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
3685 | 3685 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
5015 | 5015 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
6345 | 6345 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
7675 | 7675 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
9005 | 9005 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
10335 | 10335 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
11665 | 11665 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
12995 | 12995 | 2017-07-01 | CAD | Canada | 5.97 | 1.2823 | 4.655696794821809 |
1026 | 1026 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
2356 | 2356 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
3686 | 3686 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
5016 | 5016 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
6346 | 6346 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
7676 | 7676 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
9006 | 9006 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
10336 | 10336 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
11666 | 11666 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
12996 | 12996 | 2017-07-01 | CHF | Switzerland | 6.5 | 0.96415 | 6.74168957112483 |
1027 | 1027 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
2357 | 2357 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
3687 | 3687 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
5017 | 5017 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
6347 | 6347 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
7677 | 7677 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
9007 | 9007 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
10337 | 10337 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
11667 | 11667 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
12997 | 12997 | 2017-07-01 | CLP | Chile | 2550.0 | 663.355 | 3.84409554461789 |
1028 | 1028 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
2358 | 2358 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
3688 | 3688 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
5018 | 5018 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
6348 | 6348 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
7678 | 7678 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
9008 | 9008 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
10338 | 10338 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
11668 | 11668 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
12998 | 12998 | 2017-07-01 | CNY | China | 19.8 | 6.7875 | 2.9171270718232 |
1029 | 1029 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
2359 | 2359 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
3689 | 3689 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
5019 | 5019 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
6349 | 6349 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
7679 | 7679 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
9009 | 9009 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
10339 | 10339 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
11669 | 11669 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
12999 | 12999 | 2017-07-01 | COP | Colombia | 9900.0 | 3052.16 | 3.24360452925142 |
1030 | 1030 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
2360 | 2360 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
3690 | 3690 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
5020 | 5020 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
6350 | 6350 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
7680 | 7680 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
9010 | 9010 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
10340 | 10340 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
11670 | 11670 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
13000 | 13000 | 2017-07-01 | CRC | Costa Rica | 2290.0 | 572.495 | 4.00003493480292 |
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 );