bigmac
420 rows where "date" is on date 2012-01-01 sorted by dollar_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex | dollar_price ▼ |
---|---|---|---|---|---|---|---|
573 | 573 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
1903 | 1903 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
3233 | 3233 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
4563 | 4563 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
5893 | 5893 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
7223 | 7223 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
8553 | 8553 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
9883 | 9883 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
11213 | 11213 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
12543 | 12543 | 2012-01-01 | INR | India | 84.0 | 51.905 | 1.61834120026972 |
593 | 593 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
1923 | 1923 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
3253 | 3253 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
4583 | 4583 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
5913 | 5913 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
7243 | 7243 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
8573 | 8573 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
9903 | 9903 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
11233 | 11233 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
12563 | 12563 | 2012-01-01 | UAH | Ukraine | 17.0 | 8.0405 | 2.11429637460357 |
570 | 570 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
1900 | 1900 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
3230 | 3230 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
4560 | 4560 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
5890 | 5890 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
7220 | 7220 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
8550 | 8550 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
9880 | 9880 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
11210 | 11210 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
12540 | 12540 | 2012-01-01 | HKD | Hong Kong | 16.5 | 7.76735 | 2.12427661943906 |
579 | 579 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
1909 | 1909 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
3239 | 3239 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
4569 | 4569 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
5899 | 5899 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
7229 | 7229 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
8559 | 8559 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
9889 | 9889 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
11219 | 11219 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
12549 | 12549 | 2012-01-01 | MYR | Malaysia | 7.35 | 3.13955 | 2.34109983914892 |
562 | 562 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
1892 | 1892 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
3222 | 3222 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
4552 | 4552 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
5882 | 5882 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
7212 | 7212 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
8542 | 8542 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
9872 | 9872 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
11202 | 11202 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
12532 | 12532 | 2012-01-01 | CNY | China | 15.4 | 6.3155 | 2.43844509540021 |
596 | 596 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
1926 | 1926 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
3256 | 3256 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
4586 | 4586 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
5916 | 5916 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
7246 | 7246 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
8576 | 8576 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
9906 | 9906 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
11236 | 11236 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
12566 | 12566 | 2012-01-01 | ZAR | South Africa | 19.95 | 8.1304 | 2.45375381285054 |
590 | 590 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
1920 | 1920 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
3250 | 3250 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
4580 | 4580 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
5910 | 5910 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
7240 | 7240 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
8570 | 8570 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
9900 | 9900 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
11230 | 11230 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
12560 | 12560 | 2012-01-01 | THB | Thailand | 78.0 | 31.75 | 2.4566929133858304 |
572 | 572 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
1902 | 1902 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
3232 | 3232 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
4562 | 4562 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
5892 | 5892 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
7222 | 7222 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
8552 | 8552 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
9882 | 9882 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
11212 | 11212 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
12542 | 12542 | 2012-01-01 | IDR | Indonesia | 22534.0 | 9160.0 | 2.46004366812227 |
592 | 592 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
1922 | 1922 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
3252 | 3252 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
4582 | 4582 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
5912 | 5912 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
7242 | 7242 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
8572 | 8572 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
9902 | 9902 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
11232 | 11232 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
12562 | 12562 | 2012-01-01 | TWD | Taiwan | 75.0 | 29.9795 | 2.50170950149269 |
577 | 577 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
1907 | 1907 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
3237 | 3237 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
4567 | 4567 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
5897 | 5897 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
7227 | 7227 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
8557 | 8557 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
9887 | 9887 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
11217 | 11217 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
12547 | 12547 | 2012-01-01 | LKR | Sri Lanka | 290.0 | 113.93 | 2.5454226279294305 |
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 );