bigmac
400 rows where "date" is on date 2006-05-01 sorted by local_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price ▼ | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
244 | 244 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
1574 | 1574 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
2904 | 2904 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
4234 | 4234 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
5564 | 5564 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
6894 | 6894 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
8224 | 8224 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
9554 | 9554 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
10884 | 10884 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
12214 | 12214 | 2006-05-01 | GBP | Britain | 1.94 | 0.531801744 | 3.64797600212458 |
243 | 243 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
1573 | 1573 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
2903 | 2903 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
4233 | 4233 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
5563 | 5563 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
6893 | 6893 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
8223 | 8223 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
9553 | 9553 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
10883 | 10883 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
12213 | 12213 | 2006-05-01 | EUR | Euro area | 2.939573529 | 0.780365992 | 3.76691649704796 |
268 | 268 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
1598 | 1598 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
2928 | 2928 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
4258 | 4258 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
5588 | 5588 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
6918 | 6918 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
8248 | 8248 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
9578 | 9578 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
10908 | 10908 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
12238 | 12238 | 2006-05-01 | USD | United States | 3.1 | 1.0 | 3.1 |
232 | 232 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
1562 | 1562 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
2892 | 2892 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
4222 | 4222 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
5552 | 5552 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
6882 | 6882 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
8212 | 8212 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
9542 | 9542 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
10872 | 10872 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
12202 | 12202 | 2006-05-01 | AUD | Australia | 3.25 | 1.33253 | 2.43896947911116 |
234 | 234 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
1564 | 1564 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
2894 | 2894 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
4224 | 4224 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
5554 | 5554 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
6884 | 6884 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
8214 | 8214 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
9544 | 9544 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
10874 | 10874 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
12204 | 12204 | 2006-05-01 | CAD | Canada | 3.52 | 1.12045 | 3.1415948949083 |
261 | 261 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
1591 | 1591 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
2921 | 2921 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
4251 | 4251 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
5581 | 5581 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
6911 | 6911 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
8241 | 8241 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
9571 | 9571 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
10901 | 10901 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
12231 | 12231 | 2006-05-01 | SGD | Singapore | 3.6 | 1.5873 | 2.2680022680022702 |
264 | 264 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
1594 | 1594 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
2924 | 2924 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
4254 | 4254 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
5584 | 5584 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
6914 | 6914 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
8244 | 8244 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
9574 | 9574 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
10904 | 10904 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
12234 | 12234 | 2006-05-01 | TRY | Turkey | 4.2 | 1.5415 | 2.7246188777165097 |
254 | 254 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
1584 | 1584 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
2914 | 2914 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
4244 | 4244 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
5574 | 5574 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
6904 | 6904 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
8234 | 8234 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
9564 | 9564 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
10894 | 10894 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
12224 | 12224 | 2006-05-01 | NZD | New Zealand | 4.45 | 1.62101 | 2.74520206537899 |
252 | 252 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
1582 | 1582 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
2912 | 2912 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
4242 | 4242 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
5572 | 5572 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
6902 | 6902 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
8232 | 8232 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
9562 | 9562 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
10892 | 10892 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
12222 | 12222 | 2006-05-01 | MYR | Malaysia | 5.5 | 3.6295 | 1.5153602424576398 |
235 | 235 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
1565 | 1565 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
2895 | 2895 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
4225 | 4225 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
5555 | 5555 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
6885 | 6885 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
8215 | 8215 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
9545 | 9545 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
10875 | 10875 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
12205 | 12205 | 2006-05-01 | CHF | Switzerland | 6.3 | 1.20885 | 5.211564710261821 |
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 );