bigmac
430 rows where "date" is on date 2017-01-01 sorted by local_price
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 |
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 |
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 |
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 |
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 |
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 |
1002 | 1002 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
2332 | 2332 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
3662 | 3662 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
4992 | 4992 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
6322 | 6322 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
7652 | 7652 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
8982 | 8982 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
10312 | 10312 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
11642 | 11642 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
12972 | 12972 | 2017-01-01 | MYR | Malaysia | 8.0 | 4.4715 | 1.78910880017891 |
1008 | 1008 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
2338 | 2338 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
3668 | 3668 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
4998 | 4998 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
6328 | 6328 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
7658 | 7658 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
8988 | 8988 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
10318 | 10318 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
11648 | 11648 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
12978 | 12978 | 2017-01-01 | PLN | Poland | 9.6 | 4.17215 | 2.30097192095203 |
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 );