bigmac
560 rows where "date" is on date 2019-01-01 sorted by rowid descending
This data as json, CSV (advanced)
Link | rowid ▲ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
13188 | 13188 | 2019-01-01 | ZAR | South Africa | 31.0 | 13.8675 | 2.23544258157563 |
13187 | 13187 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
13186 | 13186 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
13185 | 13185 | 2019-01-01 | UYU | Uruguay | 140.0 | 32.51 | 4.30636727160874 |
13184 | 13184 | 2019-01-01 | UAH | Ukraine | 54.0 | 27.8 | 1.94244604316547 |
13183 | 13183 | 2019-01-01 | TWD | Taiwan | 69.0 | 30.803 | 2.24004155439405 |
13182 | 13182 | 2019-01-01 | TRY | Turkey | 10.75 | 5.3834 | 1.99687929561244 |
13181 | 13181 | 2019-01-01 | THB | Thailand | 119.0 | 32.0075 | 3.71787862219792 |
13180 | 13180 | 2019-01-01 | SEK | Sweden | 52.0 | 8.90625 | 5.838596491228071 |
13179 | 13179 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
13178 | 13178 | 2019-01-01 | SAR | Saudi Arabia | 12.0 | 3.75115 | 3.1990189675166296 |
13177 | 13177 | 2019-01-01 | RUB | Russia | 110.17 | 66.685 | 1.65209567368974 |
13176 | 13176 | 2019-01-01 | RON | Romania | 9.3 | 4.06695 | 2.2867259248331098 |
13175 | 13175 | 2019-01-01 | QAR | Qatar | 12.0 | 3.64125 | 3.29557157569516 |
13174 | 13174 | 2019-01-01 | PLN | Poland | 10.5 | 3.74845 | 2.8011578118955804 |
13173 | 13173 | 2019-01-01 | PHP | Philippines | 140.0 | 52.3925 | 2.6721381877177097 |
13172 | 13172 | 2019-01-01 | PEN | Peru | 10.5 | 3.3485 | 3.1357324175003702 |
13171 | 13171 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
13170 | 13170 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
13169 | 13169 | 2019-01-01 | NZD | New Zealand | 6.2 | 1.4792899408284 | 4.191200000000009 |
13168 | 13168 | 2019-01-01 | NOK | Norway | 50.0 | 8.5329 | 5.85967256149726 |
13167 | 13167 | 2019-01-01 | NIO | Nicaragua | 103.0 | 32.3607 | 3.18287305280788 |
13166 | 13166 | 2019-01-01 | MYR | Malaysia | 9.05 | 4.1175 | 2.19793564055859 |
13165 | 13165 | 2019-01-01 | MXN | Mexico | 49.0 | 19.30875 | 2.53770958762219 |
13164 | 13164 | 2019-01-01 | MDL | Moldova | 40.0 | 17.262999999999998 | 2.31709436366796 |
13163 | 13163 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
13162 | 13162 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
13161 | 13161 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
13160 | 13160 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
13159 | 13159 | 2019-01-01 | JPY | Japan | 390.0 | 108.44 | 3.59645887126522 |
13158 | 13158 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
13157 | 13157 | 2019-01-01 | ILS | Israel | 17.0 | 3.70785 | 4.584867241123559 |
13156 | 13156 | 2019-01-01 | INR | India | 178.0 | 69.685 | 2.55435172562244 |
13155 | 13155 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
13154 | 13154 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
13153 | 13153 | 2019-01-01 | HRK | Croatia | 21.0 | 6.47885 | 3.2413159742855604 |
13152 | 13152 | 2019-01-01 | HNL | Honduras | 85.0 | 24.3391 | 3.4923230522081803 |
13151 | 13151 | 2019-01-01 | HKD | Hong Kong | 20.0 | 7.83435 | 2.55286016070255 |
13150 | 13150 | 2019-01-01 | GTQ | Guatemala | 25.0 | 7.7283 | 3.23486407101174 |
13149 | 13149 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
13148 | 13148 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
13147 | 13147 | 2019-01-01 | EGP | Egypt | 40.0 | 17.91 | 2.23338916806253 |
13146 | 13146 | 2019-01-01 | DKK | Denmark | 30.0 | 6.51545 | 4.60444021518084 |
13145 | 13145 | 2019-01-01 | CZK | Czech Republic | 85.0 | 22.31165 | 3.80966893976913 |
13144 | 13144 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
13143 | 13143 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
13142 | 13142 | 2019-01-01 | CNY | China | 20.9 | 6.8497 | 3.05122852095712 |
13141 | 13141 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
13140 | 13140 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
13139 | 13139 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
13138 | 13138 | 2019-01-01 | BRL | Brazil | 16.9 | 3.71795 | 4.545515673960111 |
13137 | 13137 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
13136 | 13136 | 2019-01-01 | AZN | Azerbaijan | 3.95 | 1.6965 | 2.3283230179781897 |
13135 | 13135 | 2019-01-01 | AUD | Australia | 6.1 | 1.4016399187048798 | 4.352045000000009 |
13134 | 13134 | 2019-01-01 | ARS | Argentina | 75.0 | 37.455 | 2.00240288346015 |
13133 | 13133 | 2019-01-01 | AED | United Arab Emirates | 14.0 | 3.67315 | 3.81144249486136 |
11858 | 11858 | 2019-01-01 | ZAR | South Africa | 31.0 | 13.8675 | 2.23544258157563 |
11857 | 11857 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
11856 | 11856 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
11855 | 11855 | 2019-01-01 | UYU | Uruguay | 140.0 | 32.51 | 4.30636727160874 |
11854 | 11854 | 2019-01-01 | UAH | Ukraine | 54.0 | 27.8 | 1.94244604316547 |
11853 | 11853 | 2019-01-01 | TWD | Taiwan | 69.0 | 30.803 | 2.24004155439405 |
11852 | 11852 | 2019-01-01 | TRY | Turkey | 10.75 | 5.3834 | 1.99687929561244 |
11851 | 11851 | 2019-01-01 | THB | Thailand | 119.0 | 32.0075 | 3.71787862219792 |
11850 | 11850 | 2019-01-01 | SEK | Sweden | 52.0 | 8.90625 | 5.838596491228071 |
11849 | 11849 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
11848 | 11848 | 2019-01-01 | SAR | Saudi Arabia | 12.0 | 3.75115 | 3.1990189675166296 |
11847 | 11847 | 2019-01-01 | RUB | Russia | 110.17 | 66.685 | 1.65209567368974 |
11846 | 11846 | 2019-01-01 | RON | Romania | 9.3 | 4.06695 | 2.2867259248331098 |
11845 | 11845 | 2019-01-01 | QAR | Qatar | 12.0 | 3.64125 | 3.29557157569516 |
11844 | 11844 | 2019-01-01 | PLN | Poland | 10.5 | 3.74845 | 2.8011578118955804 |
11843 | 11843 | 2019-01-01 | PHP | Philippines | 140.0 | 52.3925 | 2.6721381877177097 |
11842 | 11842 | 2019-01-01 | PEN | Peru | 10.5 | 3.3485 | 3.1357324175003702 |
11841 | 11841 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
11840 | 11840 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
11839 | 11839 | 2019-01-01 | NZD | New Zealand | 6.2 | 1.4792899408284 | 4.191200000000009 |
11838 | 11838 | 2019-01-01 | NOK | Norway | 50.0 | 8.5329 | 5.85967256149726 |
11837 | 11837 | 2019-01-01 | NIO | Nicaragua | 103.0 | 32.3607 | 3.18287305280788 |
11836 | 11836 | 2019-01-01 | MYR | Malaysia | 9.05 | 4.1175 | 2.19793564055859 |
11835 | 11835 | 2019-01-01 | MXN | Mexico | 49.0 | 19.30875 | 2.53770958762219 |
11834 | 11834 | 2019-01-01 | MDL | Moldova | 40.0 | 17.262999999999998 | 2.31709436366796 |
11833 | 11833 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
11832 | 11832 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
11831 | 11831 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
11830 | 11830 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
11829 | 11829 | 2019-01-01 | JPY | Japan | 390.0 | 108.44 | 3.59645887126522 |
11828 | 11828 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
11827 | 11827 | 2019-01-01 | ILS | Israel | 17.0 | 3.70785 | 4.584867241123559 |
11826 | 11826 | 2019-01-01 | INR | India | 178.0 | 69.685 | 2.55435172562244 |
11825 | 11825 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
11824 | 11824 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
11823 | 11823 | 2019-01-01 | HRK | Croatia | 21.0 | 6.47885 | 3.2413159742855604 |
11822 | 11822 | 2019-01-01 | HNL | Honduras | 85.0 | 24.3391 | 3.4923230522081803 |
11821 | 11821 | 2019-01-01 | HKD | Hong Kong | 20.0 | 7.83435 | 2.55286016070255 |
11820 | 11820 | 2019-01-01 | GTQ | Guatemala | 25.0 | 7.7283 | 3.23486407101174 |
11819 | 11819 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
11818 | 11818 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
11817 | 11817 | 2019-01-01 | EGP | Egypt | 40.0 | 17.91 | 2.23338916806253 |
11816 | 11816 | 2019-01-01 | DKK | Denmark | 30.0 | 6.51545 | 4.60444021518084 |
11815 | 11815 | 2019-01-01 | CZK | Czech Republic | 85.0 | 22.31165 | 3.80966893976913 |
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 );