bigmac
400 rows where "date" is on date 2012-07-01 sorted by dollar_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex | dollar_price ▼ |
---|---|---|---|---|---|---|---|
614 | 614 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
1944 | 1944 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
3274 | 3274 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
4604 | 4604 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
5934 | 5934 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
7264 | 7264 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
8594 | 8594 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
9924 | 9924 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
11254 | 11254 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
12584 | 12584 | 2012-07-01 | INR | India | 89.0 | 56.165 | 1.58461675420636 |
633 | 633 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
1963 | 1963 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
3293 | 3293 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
4623 | 4623 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
5953 | 5953 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
7283 | 7283 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
8613 | 8613 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
9943 | 9943 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
11273 | 11273 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
12603 | 12603 | 2012-07-01 | UAH | Ukraine | 15.0 | 8.0855 | 1.85517284026962 |
611 | 611 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
1941 | 1941 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
3271 | 3271 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
4601 | 4601 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
5931 | 5931 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
7261 | 7261 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
8591 | 8591 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
9921 | 9921 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
11251 | 11251 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
12581 | 12581 | 2012-07-01 | HKD | Hong Kong | 16.5 | 7.75815 | 2.126795692272 |
618 | 618 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
1948 | 1948 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
3278 | 3278 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
4608 | 4608 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
5938 | 5938 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
7268 | 7268 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
8598 | 8598 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
9928 | 9928 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
11258 | 11258 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
12588 | 12588 | 2012-07-01 | LKR | Sri Lanka | 290.0 | 131.0 | 2.2137404580152698 |
626 | 626 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
1956 | 1956 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
3286 | 3286 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
4616 | 4616 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
5946 | 5946 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
7276 | 7276 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
8606 | 8606 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
9936 | 9936 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
11266 | 11266 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
12596 | 12596 | 2012-07-01 | RUB | Russia | 75.0 | 32.76525 | 2.28901046077781 |
620 | 620 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
1950 | 1950 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
3280 | 3280 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
4610 | 4610 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
5940 | 5940 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
7270 | 7270 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
8600 | 8600 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
9930 | 9930 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
11260 | 11260 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
12590 | 12590 | 2012-07-01 | MYR | Malaysia | 7.4 | 3.1735 | 2.33181030408067 |
636 | 636 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
1966 | 1966 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
3296 | 3296 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
4626 | 4626 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
5956 | 5956 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
7286 | 7286 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
8616 | 8616 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
9946 | 9946 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
11276 | 11276 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
12606 | 12606 | 2012-07-01 | ZAR | South Africa | 19.95 | 8.4683 | 2.35584473861342 |
604 | 604 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
1934 | 1934 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
3264 | 3264 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
4594 | 4594 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
5924 | 5924 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
7254 | 7254 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
8584 | 8584 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
9914 | 9914 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
11244 | 11244 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
12574 | 12574 | 2012-07-01 | CNY | China | 15.65 | 6.3885 | 2.449714330437509 |
632 | 632 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
1962 | 1962 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
3292 | 3292 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
4622 | 4622 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
5952 | 5952 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
7282 | 7282 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
8612 | 8612 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
9942 | 9942 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
11272 | 11272 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
12602 | 12602 | 2012-07-01 | TWD | Taiwan | 75.0 | 30.1955 | 2.4838138133165497 |
613 | 613 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
1943 | 1943 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
3273 | 3273 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
4603 | 4603 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
5933 | 5933 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
7263 | 7263 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
8593 | 8593 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
9923 | 9923 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
11253 | 11253 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
12583 | 12583 | 2012-07-01 | IDR | Indonesia | 24200.0 | 9482.5 | 2.55206960189823 |
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 );