bigmac
420 rows where "date" is on date 2011-07-01 sorted by dollar_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex | dollar_price ▼ |
---|---|---|---|---|---|---|---|
531 | 531 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
1861 | 1861 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
3191 | 3191 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
4521 | 4521 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
5851 | 5851 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
7181 | 7181 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
8511 | 8511 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
9841 | 9841 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
11171 | 11171 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
12501 | 12501 | 2011-07-01 | INR | India | 84.0 | 44.4 | 1.8918918918918897 |
528 | 528 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
1858 | 1858 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
3188 | 3188 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
4518 | 4518 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
5848 | 5848 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
7178 | 7178 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
8508 | 8508 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
9838 | 9838 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
11168 | 11168 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
12498 | 12498 | 2011-07-01 | HKD | Hong Kong | 15.1 | 7.7918 | 1.93793475191868 |
551 | 551 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
1881 | 1881 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
3211 | 3211 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
4541 | 4541 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
5871 | 5871 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
7201 | 7201 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
8531 | 8531 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
9861 | 9861 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
11191 | 11191 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
12521 | 12521 | 2011-07-01 | UAH | Ukraine | 16.5 | 7.994 | 2.06404803602702 |
520 | 520 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
1850 | 1850 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
3180 | 3180 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
4510 | 4510 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
5840 | 5840 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
7170 | 7170 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
8500 | 8500 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
9830 | 9830 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
11160 | 11160 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
12490 | 12490 | 2011-07-01 | CNY | China | 14.65 | 6.445 | 2.27307990690458 |
548 | 548 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
1878 | 1878 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
3208 | 3208 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
4538 | 4538 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
5868 | 5868 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
7198 | 7198 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
8528 | 8528 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
9858 | 9858 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
11188 | 11188 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
12518 | 12518 | 2011-07-01 | THB | Thailand | 70.0 | 29.75 | 2.35294117647059 |
525 | 525 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
1855 | 1855 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
3185 | 3185 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
4515 | 4515 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
5845 | 5845 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
7175 | 7175 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
8505 | 8505 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
9835 | 9835 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
11165 | 11165 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
12495 | 12495 | 2011-07-01 | EGP | Egypt | 14.09 | 5.962000000000001 | 2.36330090573633 |
540 | 540 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
1870 | 1870 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
3200 | 3200 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
4530 | 4530 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
5860 | 5860 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
7190 | 7190 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
8520 | 8520 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
9850 | 9850 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
11180 | 11180 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
12510 | 12510 | 2011-07-01 | PKR | Pakistan | 205.13 | 86.345 | 2.37570212519544 |
537 | 537 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
1867 | 1867 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
3197 | 3197 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
4527 | 4527 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
5857 | 5857 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
7187 | 7187 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
8517 | 8517 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
9847 | 9847 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
11177 | 11177 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
12507 | 12507 | 2011-07-01 | MYR | Malaysia | 7.2 | 2.9730000000000003 | 2.4217961654894102 |
535 | 535 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
1865 | 1865 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
3195 | 3195 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
4525 | 4525 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
5855 | 5855 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
7185 | 7185 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
8515 | 8515 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
9845 | 9845 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
11175 | 11175 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
12505 | 12505 | 2011-07-01 | LKR | Sri Lanka | 280.0 | 109.475 | 2.55766156656771 |
550 | 550 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
1880 | 1880 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
3210 | 3210 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
4540 | 4540 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
5870 | 5870 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
7200 | 7200 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
8530 | 8530 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
9860 | 9860 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
11190 | 11190 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
12520 | 12520 | 2011-07-01 | TWD | Taiwan | 75.0 | 28.834 | 2.60109592841784 |
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 );