bigmac
400 rows where "date" is on date 2007-06-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
324 | 324 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
1654 | 1654 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
2984 | 2984 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
4314 | 4314 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
5644 | 5644 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
6974 | 6974 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
8304 | 8304 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
9634 | 9634 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
10964 | 10964 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
12294 | 12294 | 2007-06-01 | GBP | Britain | 1.99 | 0.496610632 | 4.0071635034990605 |
323 | 323 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
1653 | 1653 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
2983 | 2983 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
4313 | 4313 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
5643 | 5643 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
6973 | 6973 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
8303 | 8303 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
9633 | 9633 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
10963 | 10963 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
12293 | 12293 | 2007-06-01 | EUR | Euro area | 3.057482443 | 0.7337564659999999 | 4.1668899487422 |
348 | 348 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
1678 | 1678 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
3008 | 3008 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
4338 | 4338 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
5668 | 5668 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
6998 | 6998 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
8328 | 8328 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
9658 | 9658 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
10988 | 10988 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
12318 | 12318 | 2007-06-01 | USD | United States | 3.41 | 1.0 | 3.41 |
314 | 314 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
1644 | 1644 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
2974 | 2974 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
4304 | 4304 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
5634 | 5634 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
6964 | 6964 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
8294 | 8294 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
9624 | 9624 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
10954 | 10954 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
12284 | 12284 | 2007-06-01 | CAD | Canada | 3.88 | 1.05345 | 3.6831363614789514 |
312 | 312 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
1642 | 1642 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
2972 | 2972 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
4302 | 4302 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
5632 | 5632 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
6962 | 6962 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
8292 | 8292 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
9622 | 9622 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
10952 | 10952 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
12282 | 12282 | 2007-06-01 | AUD | Australia | 3.45 | 1.17 | 2.94871794871795 |
315 | 315 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
1645 | 1645 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
2975 | 2975 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
4305 | 4305 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
5635 | 5635 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
6965 | 6965 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
8295 | 8295 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
9625 | 9625 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
10955 | 10955 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
12285 | 12285 | 2007-06-01 | CHF | Switzerland | 6.3 | 1.2112 | 5.2014531043593095 |
334 | 334 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
1664 | 1664 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
2994 | 2994 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
4324 | 4324 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
5654 | 5654 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
6984 | 6984 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
8314 | 8314 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
9644 | 9644 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
10974 | 10974 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
12304 | 12304 | 2007-06-01 | NZD | New Zealand | 4.6 | 1.2797 | 3.59459248261311 |
344 | 344 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
1674 | 1674 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
3004 | 3004 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
4334 | 4334 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
5664 | 5664 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
6994 | 6994 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
8324 | 8324 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
9654 | 9654 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
10984 | 10984 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
12314 | 12314 | 2007-06-01 | TRY | Turkey | 4.75 | 1.2981 | 3.6591942069178 |
341 | 341 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
1671 | 1671 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
3001 | 3001 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
4331 | 4331 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
5661 | 5661 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
6991 | 6991 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
8321 | 8321 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
9651 | 9651 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
10981 | 10981 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
12311 | 12311 | 2007-06-01 | SGD | Singapore | 3.95 | 1.52375 | 2.5922887612797405 |
313 | 313 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
1643 | 1643 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
2973 | 2973 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
4303 | 4303 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
5633 | 5633 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
6963 | 6963 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
8293 | 8293 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
9623 | 9623 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
10953 | 10953 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
12283 | 12283 | 2007-06-01 | BRL | Brazil | 6.9 | 1.913 | 3.60690015682175 |
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 );