bigmac
420 rows where "date" is on date 2013-07-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
693 | 693 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
2023 | 2023 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
3353 | 3353 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
4683 | 4683 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
6013 | 6013 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
7343 | 7343 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
8673 | 8673 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
10003 | 10003 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
11333 | 11333 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
12663 | 12663 | 2013-07-01 | GBP | Britain | 2.69 | 0.669142494 | 4.02007049936362 |
692 | 692 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
2022 | 2022 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
3352 | 3352 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
4682 | 4682 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
6012 | 6012 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
7342 | 7342 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
8672 | 8672 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
10002 | 10002 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
11332 | 11332 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
12662 | 12662 | 2013-07-01 | EUR | Euro area | 3.623870489 | 0.777756173 | 4.65939148386547 |
684 | 684 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
2014 | 2014 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
3344 | 3344 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
4674 | 4674 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
6004 | 6004 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
7334 | 7334 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
8664 | 8664 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
9994 | 9994 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
11324 | 11324 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
12654 | 12654 | 2013-07-01 | CHF | Switzerland | 6.5 | 0.9674 | 6.7190407277238 |
719 | 719 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
2049 | 2049 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
3379 | 3379 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
4709 | 4709 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
6039 | 6039 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
7369 | 7369 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
8699 | 8699 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
10029 | 10029 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
11359 | 11359 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
12689 | 12689 | 2013-07-01 | USD | United States | 4.556666667 | 1.0 | 4.556666667 |
683 | 683 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
2013 | 2013 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
3343 | 3343 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
4673 | 4673 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
6003 | 6003 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
7333 | 7333 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
8663 | 8663 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
9993 | 9993 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
11323 | 11323 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
12653 | 12653 | 2013-07-01 | CAD | Canada | 5.53 | 1.05125 | 5.260404280618309 |
681 | 681 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
2011 | 2011 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
3341 | 3341 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
4671 | 4671 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
6001 | 6001 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
7331 | 7331 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
8661 | 8661 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
9991 | 9991 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
11321 | 11321 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
12651 | 12651 | 2013-07-01 | AUD | Australia | 5.035 | 1.089858863 | 4.61986425117506 |
712 | 712 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
2042 | 2042 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
3372 | 3372 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
4702 | 4702 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
6032 | 6032 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
7362 | 7362 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
8692 | 8692 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
10022 | 10022 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
11352 | 11352 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
12682 | 12682 | 2013-07-01 | SGD | Singapore | 4.7 | 1.2747 | 3.68714207264454 |
705 | 705 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
2035 | 2035 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
3365 | 3365 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
4695 | 4695 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
6025 | 6025 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
7355 | 7355 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
8685 | 8685 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
10015 | 10015 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
11345 | 11345 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
12675 | 12675 | 2013-07-01 | NZD | New Zealand | 5.5 | 1.279344975 | 4.29907500125211 |
715 | 715 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
2045 | 2045 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
3375 | 3375 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
4705 | 4705 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
6035 | 6035 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
7365 | 7365 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
8695 | 8695 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
10025 | 10025 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
11355 | 11355 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
12685 | 12685 | 2013-07-01 | TRY | Turkey | 8.5 | 1.95745 | 4.34238422437355 |
682 | 682 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
2012 | 2012 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
3342 | 3342 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
4672 | 4672 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
6002 | 6002 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
7332 | 7332 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
8662 | 8662 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
9992 | 9992 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
11322 | 11322 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
12652 | 12652 | 2013-07-01 | BRL | Brazil | 12.0 | 2.27065 | 5.28483033492612 |
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 );