bigmac
560 rows where "date" is on date 2019-07-09
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
2593 | 2593 | 2019-07-09 | RUB | Russia | 130.0 | 63.83875 | 2.03638072487322 |
2594 | 2594 | 2019-07-09 | SAR | Saudi Arabia | 13.0 | 3.75035 | 3.46634314130681 |
2595 | 2595 | 2019-07-09 | SGD | Singapore | 5.8 | 1.3613 | 4.26063321824726 |
2596 | 2596 | 2019-07-09 | SEK | Sweden | 51.0 | 9.47505 | 5.38255734798233 |
2597 | 2597 | 2019-07-09 | THB | Thailand | 119.0 | 30.8275 | 3.86018976563134 |
2598 | 2598 | 2019-07-09 | TRY | Turkey | 13.99 | 5.722 | 2.44494931842013 |
2599 | 2599 | 2019-07-09 | TWD | Taiwan | 72.0 | 31.172 | 2.3097651738739904 |
2600 | 2600 | 2019-07-09 | UAH | Ukraine | 57.0 | 25.6475 | 2.2224388341943704 |
2601 | 2601 | 2019-07-09 | UYU | Uruguay | 164.0 | 35.1695 | 4.66313140647436 |
2602 | 2602 | 2019-07-09 | USD | United States | 5.74 | 1.0 | 5.74 |
2603 | 2603 | 2019-07-09 | VND | Vietnam | 65000.0 | 23231.0 | 2.79798545047566 |
2604 | 2604 | 2019-07-09 | ZAR | South Africa | 31.0 | 14.175 | 2.18694885361552 |
3879 | 3879 | 2019-07-09 | AED | United Arab Emirates | 14.75 | 3.67315 | 4.01562691422893 |
3880 | 3880 | 2019-07-09 | ARS | Argentina | 120.0 | 41.8045 | 2.87050437153895 |
3881 | 3881 | 2019-07-09 | AUD | Australia | 6.15 | 1.4436263894904 | 4.260105 |
3882 | 3882 | 2019-07-09 | AZN | Azerbaijan | 3.95 | 1.6965 | 2.3283230179781897 |
3883 | 3883 | 2019-07-09 | BHD | Bahrain | 1.4 | 0.377 | 3.7135278514588896 |
3884 | 3884 | 2019-07-09 | BRL | Brazil | 17.5 | 3.8073 | 4.59643316786174 |
3885 | 3885 | 2019-07-09 | CAD | Canada | 6.77 | 1.31305 | 5.1559346559537 |
3886 | 3886 | 2019-07-09 | CHF | Switzerland | 6.5 | 0.99355 | 6.54219717175784 |
3887 | 3887 | 2019-07-09 | CLP | Chile | 2640.0 | 689.75 | 3.82747372236318 |
3888 | 3888 | 2019-07-09 | CNY | China | 21.0 | 6.8846 | 3.0502861458908304 |
3889 | 3889 | 2019-07-09 | COP | Colombia | 11900.0 | 3227.0 | 3.6876355748373104 |
3890 | 3890 | 2019-07-09 | CRC | Costa Rica | 2290.0 | 581.935 | 3.93514739618686 |
3891 | 3891 | 2019-07-09 | CZK | Czech Republic | 85.0 | 22.7993 | 3.72818463724764 |
3892 | 3892 | 2019-07-09 | DKK | Denmark | 30.0 | 6.6593 | 4.50497800069076 |
3893 | 3893 | 2019-07-09 | EGP | Egypt | 42.0 | 16.615 | 2.52783629250677 |
3894 | 3894 | 2019-07-09 | EUR | Euro area | 4.08 | 0.892339267389462 | 4.572252 |
3895 | 3895 | 2019-07-09 | GBP | Britain | 3.29 | 0.8021819348628271 | 4.101314 |
3896 | 3896 | 2019-07-09 | GTQ | Guatemala | 25.0 | 7.6802 | 3.2551235644905097 |
3897 | 3897 | 2019-07-09 | HKD | Hong Kong | 20.5 | 7.8105 | 2.6246719160105 |
3898 | 3898 | 2019-07-09 | HNL | Honduras | 86.0 | 24.4834 | 3.5125840365308703 |
3899 | 3899 | 2019-07-09 | HRK | Croatia | 22.0 | 6.5981 | 3.3342932056198 |
3900 | 3900 | 2019-07-09 | HUF | Hungary | 900.0 | 290.5412 | 3.0976673876200698 |
3901 | 3901 | 2019-07-09 | IDR | Indonesia | 32000.0 | 14130.0 | 2.26468506723284 |
3902 | 3902 | 2019-07-09 | INR | India | 183.0 | 68.5544 | 2.66941290420454 |
3903 | 3903 | 2019-07-09 | ILS | Israel | 17.0 | 3.5667 | 4.76631059522808 |
3904 | 3904 | 2019-07-09 | JOD | Jordan | 2.3 | 0.7090000000000001 | 3.24400564174894 |
3905 | 3905 | 2019-07-09 | JPY | Japan | 390.0 | 108.765 | 3.58571231554268 |
3906 | 3906 | 2019-07-09 | KRW | South Korea | 4500.0 | 1180.55 | 3.81178264368303 |
3907 | 3907 | 2019-07-09 | KWD | Kuwait | 1.1 | 0.3045 | 3.61247947454844 |
3908 | 3908 | 2019-07-09 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
3909 | 3909 | 2019-07-09 | LKR | Sri Lanka | 640.0 | 175.675 | 3.64309093496513 |
3910 | 3910 | 2019-07-09 | MDL | Moldova | 43.0 | 17.8142 | 2.41380471758485 |
3911 | 3911 | 2019-07-09 | MXN | Mexico | 50.0 | 18.89525 | 2.6461676876463702 |
3912 | 3912 | 2019-07-09 | MYR | Malaysia | 8.85 | 4.1425 | 2.1363910681955303 |
3913 | 3913 | 2019-07-09 | NIO | Nicaragua | 110.0 | 33.1621 | 3.3170396325926297 |
3914 | 3914 | 2019-07-09 | NOK | Norway | 42.0 | 8.65275 | 4.853948166767791 |
3915 | 3915 | 2019-07-09 | NZD | New Zealand | 6.4 | 1.5134317063942502 | 4.2288 |
3916 | 3916 | 2019-07-09 | OMR | Oman | 1.21 | 0.385 | 3.14285714285714 |
3917 | 3917 | 2019-07-09 | PKR | Pakistan | 480.0 | 157.45 | 3.0485868529692 |
3918 | 3918 | 2019-07-09 | PEN | Peru | 10.5 | 3.2868 | 3.19459656809054 |
3919 | 3919 | 2019-07-09 | PHP | Philippines | 142.0 | 51.3175 | 2.76708725093779 |
3920 | 3920 | 2019-07-09 | PLN | Poland | 10.8 | 3.80775 | 2.83632066180815 |
3921 | 3921 | 2019-07-09 | QAR | Qatar | 13.0 | 3.64175 | 3.5697123635614707 |
3922 | 3922 | 2019-07-09 | RON | Romania | 9.3 | 4.2192 | 2.20420932878271 |
3923 | 3923 | 2019-07-09 | RUB | Russia | 130.0 | 63.83875 | 2.03638072487322 |
3924 | 3924 | 2019-07-09 | SAR | Saudi Arabia | 13.0 | 3.75035 | 3.46634314130681 |
3925 | 3925 | 2019-07-09 | SGD | Singapore | 5.8 | 1.3613 | 4.26063321824726 |
3926 | 3926 | 2019-07-09 | SEK | Sweden | 51.0 | 9.47505 | 5.38255734798233 |
3927 | 3927 | 2019-07-09 | THB | Thailand | 119.0 | 30.8275 | 3.86018976563134 |
3928 | 3928 | 2019-07-09 | TRY | Turkey | 13.99 | 5.722 | 2.44494931842013 |
3929 | 3929 | 2019-07-09 | TWD | Taiwan | 72.0 | 31.172 | 2.3097651738739904 |
3930 | 3930 | 2019-07-09 | UAH | Ukraine | 57.0 | 25.6475 | 2.2224388341943704 |
3931 | 3931 | 2019-07-09 | UYU | Uruguay | 164.0 | 35.1695 | 4.66313140647436 |
3932 | 3932 | 2019-07-09 | USD | United States | 5.74 | 1.0 | 5.74 |
3933 | 3933 | 2019-07-09 | VND | Vietnam | 65000.0 | 23231.0 | 2.79798545047566 |
3934 | 3934 | 2019-07-09 | ZAR | South Africa | 31.0 | 14.175 | 2.18694885361552 |
5209 | 5209 | 2019-07-09 | AED | United Arab Emirates | 14.75 | 3.67315 | 4.01562691422893 |
5210 | 5210 | 2019-07-09 | ARS | Argentina | 120.0 | 41.8045 | 2.87050437153895 |
5211 | 5211 | 2019-07-09 | AUD | Australia | 6.15 | 1.4436263894904 | 4.260105 |
5212 | 5212 | 2019-07-09 | AZN | Azerbaijan | 3.95 | 1.6965 | 2.3283230179781897 |
5213 | 5213 | 2019-07-09 | BHD | Bahrain | 1.4 | 0.377 | 3.7135278514588896 |
5214 | 5214 | 2019-07-09 | BRL | Brazil | 17.5 | 3.8073 | 4.59643316786174 |
5215 | 5215 | 2019-07-09 | CAD | Canada | 6.77 | 1.31305 | 5.1559346559537 |
5216 | 5216 | 2019-07-09 | CHF | Switzerland | 6.5 | 0.99355 | 6.54219717175784 |
5217 | 5217 | 2019-07-09 | CLP | Chile | 2640.0 | 689.75 | 3.82747372236318 |
5218 | 5218 | 2019-07-09 | CNY | China | 21.0 | 6.8846 | 3.0502861458908304 |
5219 | 5219 | 2019-07-09 | COP | Colombia | 11900.0 | 3227.0 | 3.6876355748373104 |
5220 | 5220 | 2019-07-09 | CRC | Costa Rica | 2290.0 | 581.935 | 3.93514739618686 |
5221 | 5221 | 2019-07-09 | CZK | Czech Republic | 85.0 | 22.7993 | 3.72818463724764 |
5222 | 5222 | 2019-07-09 | DKK | Denmark | 30.0 | 6.6593 | 4.50497800069076 |
5223 | 5223 | 2019-07-09 | EGP | Egypt | 42.0 | 16.615 | 2.52783629250677 |
5224 | 5224 | 2019-07-09 | EUR | Euro area | 4.08 | 0.892339267389462 | 4.572252 |
5225 | 5225 | 2019-07-09 | GBP | Britain | 3.29 | 0.8021819348628271 | 4.101314 |
5226 | 5226 | 2019-07-09 | GTQ | Guatemala | 25.0 | 7.6802 | 3.2551235644905097 |
5227 | 5227 | 2019-07-09 | HKD | Hong Kong | 20.5 | 7.8105 | 2.6246719160105 |
5228 | 5228 | 2019-07-09 | HNL | Honduras | 86.0 | 24.4834 | 3.5125840365308703 |
5229 | 5229 | 2019-07-09 | HRK | Croatia | 22.0 | 6.5981 | 3.3342932056198 |
5230 | 5230 | 2019-07-09 | HUF | Hungary | 900.0 | 290.5412 | 3.0976673876200698 |
5231 | 5231 | 2019-07-09 | IDR | Indonesia | 32000.0 | 14130.0 | 2.26468506723284 |
5232 | 5232 | 2019-07-09 | INR | India | 183.0 | 68.5544 | 2.66941290420454 |
5233 | 5233 | 2019-07-09 | ILS | Israel | 17.0 | 3.5667 | 4.76631059522808 |
5234 | 5234 | 2019-07-09 | JOD | Jordan | 2.3 | 0.7090000000000001 | 3.24400564174894 |
5235 | 5235 | 2019-07-09 | JPY | Japan | 390.0 | 108.765 | 3.58571231554268 |
5236 | 5236 | 2019-07-09 | KRW | South Korea | 4500.0 | 1180.55 | 3.81178264368303 |
5237 | 5237 | 2019-07-09 | KWD | Kuwait | 1.1 | 0.3045 | 3.61247947454844 |
5238 | 5238 | 2019-07-09 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
5239 | 5239 | 2019-07-09 | LKR | Sri Lanka | 640.0 | 175.675 | 3.64309093496513 |
5240 | 5240 | 2019-07-09 | MDL | Moldova | 43.0 | 17.8142 | 2.41380471758485 |
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 );