bigmac
430 rows where "date" is on date 2016-07-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
12947 | 12947 | 2016-07-01 | ZAR | South Africa | 30.0 | 14.27375 | 2.10176022418776 |
12946 | 12946 | 2016-07-01 | VND | Vietnam | 60000.0 | 22300.0 | 2.69058295964126 |
12945 | 12945 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
12944 | 12944 | 2016-07-01 | UYU | Uruguay | 123.0 | 30.165 | 4.07757334659373 |
12943 | 12943 | 2016-07-01 | UAH | Ukraine | 39.0 | 24.8 | 1.5725806451612905 |
12942 | 12942 | 2016-07-01 | TWD | Taiwan | 69.0 | 32.029 | 2.1542976677386103 |
12941 | 12941 | 2016-07-01 | TRY | Turkey | 10.75 | 3.04305 | 3.53263995005011 |
12940 | 12940 | 2016-07-01 | THB | Thailand | 119.0 | 34.965 | 3.4034034034034 |
12939 | 12939 | 2016-07-01 | SEK | Sweden | 44.94 | 8.59485 | 5.228712542976321 |
12938 | 12938 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
12937 | 12937 | 2016-07-01 | SAR | Saudi Arabia | 12.0 | 3.7505 | 3.19957339021464 |
12936 | 12936 | 2016-07-01 | RUB | Russia | 130.0 | 63.40755 | 2.05022903423961 |
12935 | 12935 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
12934 | 12934 | 2016-07-01 | PHP | Philippines | 133.0 | 47.115 | 2.82288018677704 |
12933 | 12933 | 2016-07-01 | PEN | Peru | 10.0 | 3.30585 | 3.02494063554003 |
12932 | 12932 | 2016-07-01 | PKR | Pakistan | 375.0 | 104.82 | 3.57756153405839 |
12931 | 12931 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
12930 | 12930 | 2016-07-01 | NOK | Norway | 46.8 | 8.49355 | 5.51006351878779 |
12929 | 12929 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
12928 | 12928 | 2016-07-01 | MXN | Mexico | 44.0 | 18.535 | 2.37388724035608 |
12927 | 12927 | 2016-07-01 | LKR | Sri Lanka | 530.0 | 146.2 | 3.6251709986320098 |
12926 | 12926 | 2016-07-01 | KRW | South Korea | 4400.0 | 1140.95 | 3.85643542661817 |
12925 | 12925 | 2016-07-01 | JPY | Japan | 370.0 | 106.725 | 3.46685406418365 |
12924 | 12924 | 2016-07-01 | ILS | Israel | 16.9 | 3.85875 | 4.37965662455458 |
12923 | 12923 | 2016-07-01 | INR | India | 162.0 | 67.2 | 2.41071428571429 |
12922 | 12922 | 2016-07-01 | IDR | Indonesia | 31000.0 | 13112.5 | 2.36415633937083 |
12921 | 12921 | 2016-07-01 | HUF | Hungary | 900.0 | 285.6397 | 3.15082252221943 |
12920 | 12920 | 2016-07-01 | HKD | Hong Kong | 19.2 | 7.7554 | 2.4756943549011 |
12919 | 12919 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
12918 | 12918 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
12917 | 12917 | 2016-07-01 | EGP | Egypt | 23.0 | 8.87995 | 2.5901046740128 |
12916 | 12916 | 2016-07-01 | DKK | Denmark | 30.0 | 6.75715 | 4.43974160703847 |
12915 | 12915 | 2016-07-01 | CZK | Czech Republic | 75.0 | 24.54655 | 3.0554191933285897 |
12914 | 12914 | 2016-07-01 | CRC | Costa Rica | 2250.0 | 546.39 | 4.11793773678142 |
12913 | 12913 | 2016-07-01 | COP | Colombia | 8900.0 | 2929.0 | 3.0385797200409703 |
12912 | 12912 | 2016-07-01 | CNY | China | 18.6 | 6.678 | 2.7852650494159903 |
12911 | 12911 | 2016-07-01 | CLP | Chile | 2300.0 | 651.12 | 3.53237498464185 |
12910 | 12910 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
12909 | 12909 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
12908 | 12908 | 2016-07-01 | BRL | Brazil | 15.5 | 3.24145 | 4.78181060944948 |
12907 | 12907 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
12906 | 12906 | 2016-07-01 | ARS | Argentina | 50.0 | 14.935 | 3.3478406427854 |
12905 | 12905 | 2016-07-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
11617 | 11617 | 2016-07-01 | ZAR | South Africa | 30.0 | 14.27375 | 2.10176022418776 |
11616 | 11616 | 2016-07-01 | VND | Vietnam | 60000.0 | 22300.0 | 2.69058295964126 |
11615 | 11615 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
11614 | 11614 | 2016-07-01 | UYU | Uruguay | 123.0 | 30.165 | 4.07757334659373 |
11613 | 11613 | 2016-07-01 | UAH | Ukraine | 39.0 | 24.8 | 1.5725806451612905 |
11612 | 11612 | 2016-07-01 | TWD | Taiwan | 69.0 | 32.029 | 2.1542976677386103 |
11611 | 11611 | 2016-07-01 | TRY | Turkey | 10.75 | 3.04305 | 3.53263995005011 |
11610 | 11610 | 2016-07-01 | THB | Thailand | 119.0 | 34.965 | 3.4034034034034 |
11609 | 11609 | 2016-07-01 | SEK | Sweden | 44.94 | 8.59485 | 5.228712542976321 |
11608 | 11608 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
11607 | 11607 | 2016-07-01 | SAR | Saudi Arabia | 12.0 | 3.7505 | 3.19957339021464 |
11606 | 11606 | 2016-07-01 | RUB | Russia | 130.0 | 63.40755 | 2.05022903423961 |
11605 | 11605 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
11604 | 11604 | 2016-07-01 | PHP | Philippines | 133.0 | 47.115 | 2.82288018677704 |
11603 | 11603 | 2016-07-01 | PEN | Peru | 10.0 | 3.30585 | 3.02494063554003 |
11602 | 11602 | 2016-07-01 | PKR | Pakistan | 375.0 | 104.82 | 3.57756153405839 |
11601 | 11601 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
11600 | 11600 | 2016-07-01 | NOK | Norway | 46.8 | 8.49355 | 5.51006351878779 |
11599 | 11599 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
11598 | 11598 | 2016-07-01 | MXN | Mexico | 44.0 | 18.535 | 2.37388724035608 |
11597 | 11597 | 2016-07-01 | LKR | Sri Lanka | 530.0 | 146.2 | 3.6251709986320098 |
11596 | 11596 | 2016-07-01 | KRW | South Korea | 4400.0 | 1140.95 | 3.85643542661817 |
11595 | 11595 | 2016-07-01 | JPY | Japan | 370.0 | 106.725 | 3.46685406418365 |
11594 | 11594 | 2016-07-01 | ILS | Israel | 16.9 | 3.85875 | 4.37965662455458 |
11593 | 11593 | 2016-07-01 | INR | India | 162.0 | 67.2 | 2.41071428571429 |
11592 | 11592 | 2016-07-01 | IDR | Indonesia | 31000.0 | 13112.5 | 2.36415633937083 |
11591 | 11591 | 2016-07-01 | HUF | Hungary | 900.0 | 285.6397 | 3.15082252221943 |
11590 | 11590 | 2016-07-01 | HKD | Hong Kong | 19.2 | 7.7554 | 2.4756943549011 |
11589 | 11589 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
11588 | 11588 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
11587 | 11587 | 2016-07-01 | EGP | Egypt | 23.0 | 8.87995 | 2.5901046740128 |
11586 | 11586 | 2016-07-01 | DKK | Denmark | 30.0 | 6.75715 | 4.43974160703847 |
11585 | 11585 | 2016-07-01 | CZK | Czech Republic | 75.0 | 24.54655 | 3.0554191933285897 |
11584 | 11584 | 2016-07-01 | CRC | Costa Rica | 2250.0 | 546.39 | 4.11793773678142 |
11583 | 11583 | 2016-07-01 | COP | Colombia | 8900.0 | 2929.0 | 3.0385797200409703 |
11582 | 11582 | 2016-07-01 | CNY | China | 18.6 | 6.678 | 2.7852650494159903 |
11581 | 11581 | 2016-07-01 | CLP | Chile | 2300.0 | 651.12 | 3.53237498464185 |
11580 | 11580 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
11579 | 11579 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
11578 | 11578 | 2016-07-01 | BRL | Brazil | 15.5 | 3.24145 | 4.78181060944948 |
11577 | 11577 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
11576 | 11576 | 2016-07-01 | ARS | Argentina | 50.0 | 14.935 | 3.3478406427854 |
11575 | 11575 | 2016-07-01 | AED | UAE | 13.0 | 3.6731 | 3.5392447796139503 |
10287 | 10287 | 2016-07-01 | ZAR | South Africa | 30.0 | 14.27375 | 2.10176022418776 |
10286 | 10286 | 2016-07-01 | VND | Vietnam | 60000.0 | 22300.0 | 2.69058295964126 |
10285 | 10285 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
10284 | 10284 | 2016-07-01 | UYU | Uruguay | 123.0 | 30.165 | 4.07757334659373 |
10283 | 10283 | 2016-07-01 | UAH | Ukraine | 39.0 | 24.8 | 1.5725806451612905 |
10282 | 10282 | 2016-07-01 | TWD | Taiwan | 69.0 | 32.029 | 2.1542976677386103 |
10281 | 10281 | 2016-07-01 | TRY | Turkey | 10.75 | 3.04305 | 3.53263995005011 |
10280 | 10280 | 2016-07-01 | THB | Thailand | 119.0 | 34.965 | 3.4034034034034 |
10279 | 10279 | 2016-07-01 | SEK | Sweden | 44.94 | 8.59485 | 5.228712542976321 |
10278 | 10278 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
10277 | 10277 | 2016-07-01 | SAR | Saudi Arabia | 12.0 | 3.7505 | 3.19957339021464 |
10276 | 10276 | 2016-07-01 | RUB | Russia | 130.0 | 63.40755 | 2.05022903423961 |
10275 | 10275 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
10274 | 10274 | 2016-07-01 | PHP | Philippines | 133.0 | 47.115 | 2.82288018677704 |
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 );