bigmac
430 rows where "date" is on date 2017-01-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
992 | 992 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
2322 | 2322 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
3652 | 3652 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
4982 | 4982 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
6312 | 6312 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
7642 | 7642 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
8972 | 8972 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
10302 | 10302 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
11632 | 11632 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
12962 | 12962 | 2017-01-01 | GBP | Britain | 3.09 | 0.82877507 | 3.72839400200588 |
991 | 991 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
2321 | 2321 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
3651 | 3651 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
4981 | 4981 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
6311 | 6311 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
7641 | 7641 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
8971 | 8971 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
10301 | 10301 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
11631 | 11631 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
12961 | 12961 | 2017-01-01 | EUR | Euro area | 3.88 | 0.955246692 | 4.06177800194884 |
1018 | 1018 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
2348 | 2348 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
3678 | 3678 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
5008 | 5008 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
6338 | 6338 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
7668 | 7668 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
8998 | 8998 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
10328 | 10328 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
11658 | 11658 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
12988 | 12988 | 2017-01-01 | USD | United States | 5.06 | 1.0 | 5.06 |
983 | 983 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
2313 | 2313 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
3643 | 3643 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
4973 | 4973 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
6303 | 6303 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
7633 | 7633 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
8963 | 8963 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
10293 | 10293 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
11623 | 11623 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
12953 | 12953 | 2017-01-01 | CHF | Switzerland | 6.5 | 1.0236 | 6.350136772176629 |
982 | 982 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
2312 | 2312 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
3642 | 3642 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
4972 | 4972 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
6302 | 6302 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
7632 | 7632 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
8962 | 8962 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
10292 | 10292 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
11622 | 11622 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
12952 | 12952 | 2017-01-01 | CAD | Canada | 5.98 | 1.3259999999999998 | 4.50980392156863 |
980 | 980 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
2310 | 2310 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
3640 | 3640 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
4970 | 4970 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
6300 | 6300 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
7630 | 7630 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
8960 | 8960 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
10290 | 10290 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
11620 | 11620 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
12950 | 12950 | 2017-01-01 | AUD | Australia | 5.8 | 1.356668023 | 4.27518000105469 |
1004 | 1004 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
2334 | 2334 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
3664 | 3664 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
4994 | 4994 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
6324 | 6324 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
7654 | 7654 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
8984 | 8984 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
10314 | 10314 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
11644 | 11644 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
12974 | 12974 | 2017-01-01 | NZD | New Zealand | 6.0 | 1.43358899 | 4.1853000001067295 |
1011 | 1011 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
2341 | 2341 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
3671 | 3671 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
5001 | 5001 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
6331 | 6331 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
7661 | 7661 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
8991 | 8991 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
10321 | 10321 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
11651 | 11651 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
12981 | 12981 | 2017-01-01 | SGD | Singapore | 5.6 | 1.43875 | 3.89226759339705 |
981 | 981 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
2311 | 2311 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
3641 | 3641 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
4971 | 4971 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
6301 | 6301 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
7631 | 7631 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
8961 | 8961 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
10291 | 10291 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
11621 | 11621 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
12951 | 12951 | 2017-01-01 | BRL | Brazil | 16.5 | 3.22395 | 5.11794537756479 |
1006 | 1006 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
2336 | 2336 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
3666 | 3666 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
4996 | 4996 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
6326 | 6326 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
7656 | 7656 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
8986 | 8986 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
10316 | 10316 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
11646 | 11646 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
12976 | 12976 | 2017-01-01 | PEN | Peru | 11.0 | 3.3929 | 3.2420643107666005 |
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 );