bigmac
420 rows where "date" is on date 2014-01-01
This data as json, CSV (advanced)
Link | rowid ▼ | date | currency_code | name | local_price | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
3397 | 3397 | 2014-01-01 | HUF | Hungary | 860.0 | 223.09705 | 3.8548246155652897 |
3398 | 3398 | 2014-01-01 | IDR | Indonesia | 27939.0 | 12140.0 | 2.30140032948929 |
3399 | 3399 | 2014-01-01 | INR | India | 95.0 | 61.845 | 1.5360983102918602 |
3400 | 3400 | 2014-01-01 | ILS | Israel | 17.5 | 3.4882 | 5.01691416776561 |
3401 | 3401 | 2014-01-01 | JPY | Japan | 310.0 | 104.245 | 2.97376372967528 |
3402 | 3402 | 2014-01-01 | KRW | South Korea | 3700.0 | 1067.3 | 3.46669165183173 |
3403 | 3403 | 2014-01-01 | LKR | Sri Lanka | 350.0 | 130.8 | 2.67584097859327 |
3404 | 3404 | 2014-01-01 | MXN | Mexico | 37.0 | 13.33275 | 2.77512141156176 |
3405 | 3405 | 2014-01-01 | MYR | Malaysia | 7.4 | 3.3235 | 2.2265683767113 |
3406 | 3406 | 2014-01-01 | NOK | Norway | 48.0 | 6.15745 | 7.79543479849613 |
3407 | 3407 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
3408 | 3408 | 2014-01-01 | PKR | Pakistan | 320.0 | 105.415 | 3.03562111653939 |
3409 | 3409 | 2014-01-01 | PEN | Peru | 10.0 | 2.8065 | 3.56315695706396 |
3410 | 3410 | 2014-01-01 | PHP | Philippines | 135.0 | 45.23 | 2.98474463851426 |
3411 | 3411 | 2014-01-01 | PLN | Poland | 9.2 | 3.0684 | 2.99830530569678 |
3412 | 3412 | 2014-01-01 | RUB | Russia | 89.0 | 33.93925 | 2.62233255007108 |
3413 | 3413 | 2014-01-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
3414 | 3414 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
3415 | 3415 | 2014-01-01 | SEK | Sweden | 40.7 | 6.47315 | 6.287510717347809 |
3416 | 3416 | 2014-01-01 | THB | Thailand | 96.0 | 32.875 | 2.92015209125475 |
3417 | 3417 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
3418 | 3418 | 2014-01-01 | TWD | Taiwan | 79.0 | 30.161 | 2.6192765491860404 |
3419 | 3419 | 2014-01-01 | UAH | Ukraine | 19.0 | 8.379 | 2.2675736961451203 |
3420 | 3420 | 2014-01-01 | UYU | Uruguay | 105.0 | 21.38 | 4.911131898971 |
3421 | 3421 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
3422 | 3422 | 2014-01-01 | ZAR | South Africa | 23.5 | 10.87765 | 2.16039309961251 |
4711 | 4711 | 2014-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
4712 | 4712 | 2014-01-01 | ARS | Argentina | 21.0 | 6.92125 | 3.03413400758534 |
4713 | 4713 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
4714 | 4714 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
4715 | 4715 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
4716 | 4716 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
4717 | 4717 | 2014-01-01 | CLP | Chile | 2000.0 | 541.95 | 3.6903773410831295 |
4718 | 4718 | 2014-01-01 | CNY | China | 16.6 | 6.0513 | 2.74321220233669 |
4719 | 4719 | 2014-01-01 | COP | Colombia | 8600.0 | 1982.795 | 4.33731172410663 |
4720 | 4720 | 2014-01-01 | CRC | Costa Rica | 2150.0 | 501.92 | 4.2835511635320405 |
4721 | 4721 | 2014-01-01 | CZK | Czech Republic | 70.45 | 20.2838 | 3.47321507804258 |
4722 | 4722 | 2014-01-01 | DKK | Denmark | 28.5 | 5.5014 | 5.18049950921584 |
4723 | 4723 | 2014-01-01 | EGP | Egypt | 16.93 | 6.961 | 2.43212182157736 |
4724 | 4724 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
4725 | 4725 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
4726 | 4726 | 2014-01-01 | HKD | Hong Kong | 18.0 | 7.75785 | 2.32023047622731 |
4727 | 4727 | 2014-01-01 | HUF | Hungary | 860.0 | 223.09705 | 3.8548246155652897 |
4728 | 4728 | 2014-01-01 | IDR | Indonesia | 27939.0 | 12140.0 | 2.30140032948929 |
4729 | 4729 | 2014-01-01 | INR | India | 95.0 | 61.845 | 1.5360983102918602 |
4730 | 4730 | 2014-01-01 | ILS | Israel | 17.5 | 3.4882 | 5.01691416776561 |
4731 | 4731 | 2014-01-01 | JPY | Japan | 310.0 | 104.245 | 2.97376372967528 |
4732 | 4732 | 2014-01-01 | KRW | South Korea | 3700.0 | 1067.3 | 3.46669165183173 |
4733 | 4733 | 2014-01-01 | LKR | Sri Lanka | 350.0 | 130.8 | 2.67584097859327 |
4734 | 4734 | 2014-01-01 | MXN | Mexico | 37.0 | 13.33275 | 2.77512141156176 |
4735 | 4735 | 2014-01-01 | MYR | Malaysia | 7.4 | 3.3235 | 2.2265683767113 |
4736 | 4736 | 2014-01-01 | NOK | Norway | 48.0 | 6.15745 | 7.79543479849613 |
4737 | 4737 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
4738 | 4738 | 2014-01-01 | PKR | Pakistan | 320.0 | 105.415 | 3.03562111653939 |
4739 | 4739 | 2014-01-01 | PEN | Peru | 10.0 | 2.8065 | 3.56315695706396 |
4740 | 4740 | 2014-01-01 | PHP | Philippines | 135.0 | 45.23 | 2.98474463851426 |
4741 | 4741 | 2014-01-01 | PLN | Poland | 9.2 | 3.0684 | 2.99830530569678 |
4742 | 4742 | 2014-01-01 | RUB | Russia | 89.0 | 33.93925 | 2.62233255007108 |
4743 | 4743 | 2014-01-01 | SAR | Saudi Arabia | 11.0 | 3.7504 | 2.9330204778157003 |
4744 | 4744 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
4745 | 4745 | 2014-01-01 | SEK | Sweden | 40.7 | 6.47315 | 6.287510717347809 |
4746 | 4746 | 2014-01-01 | THB | Thailand | 96.0 | 32.875 | 2.92015209125475 |
4747 | 4747 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
4748 | 4748 | 2014-01-01 | TWD | Taiwan | 79.0 | 30.161 | 2.6192765491860404 |
4749 | 4749 | 2014-01-01 | UAH | Ukraine | 19.0 | 8.379 | 2.2675736961451203 |
4750 | 4750 | 2014-01-01 | UYU | Uruguay | 105.0 | 21.38 | 4.911131898971 |
4751 | 4751 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
4752 | 4752 | 2014-01-01 | ZAR | South Africa | 23.5 | 10.87765 | 2.16039309961251 |
6041 | 6041 | 2014-01-01 | AED | UAE | 12.0 | 3.673 | 3.26708412741628 |
6042 | 6042 | 2014-01-01 | ARS | Argentina | 21.0 | 6.92125 | 3.03413400758534 |
6043 | 6043 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
6044 | 6044 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
6045 | 6045 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
6046 | 6046 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
6047 | 6047 | 2014-01-01 | CLP | Chile | 2000.0 | 541.95 | 3.6903773410831295 |
6048 | 6048 | 2014-01-01 | CNY | China | 16.6 | 6.0513 | 2.74321220233669 |
6049 | 6049 | 2014-01-01 | COP | Colombia | 8600.0 | 1982.795 | 4.33731172410663 |
6050 | 6050 | 2014-01-01 | CRC | Costa Rica | 2150.0 | 501.92 | 4.2835511635320405 |
6051 | 6051 | 2014-01-01 | CZK | Czech Republic | 70.45 | 20.2838 | 3.47321507804258 |
6052 | 6052 | 2014-01-01 | DKK | Denmark | 28.5 | 5.5014 | 5.18049950921584 |
6053 | 6053 | 2014-01-01 | EGP | Egypt | 16.93 | 6.961 | 2.43212182157736 |
6054 | 6054 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
6055 | 6055 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
6056 | 6056 | 2014-01-01 | HKD | Hong Kong | 18.0 | 7.75785 | 2.32023047622731 |
6057 | 6057 | 2014-01-01 | HUF | Hungary | 860.0 | 223.09705 | 3.8548246155652897 |
6058 | 6058 | 2014-01-01 | IDR | Indonesia | 27939.0 | 12140.0 | 2.30140032948929 |
6059 | 6059 | 2014-01-01 | INR | India | 95.0 | 61.845 | 1.5360983102918602 |
6060 | 6060 | 2014-01-01 | ILS | Israel | 17.5 | 3.4882 | 5.01691416776561 |
6061 | 6061 | 2014-01-01 | JPY | Japan | 310.0 | 104.245 | 2.97376372967528 |
6062 | 6062 | 2014-01-01 | KRW | South Korea | 3700.0 | 1067.3 | 3.46669165183173 |
6063 | 6063 | 2014-01-01 | LKR | Sri Lanka | 350.0 | 130.8 | 2.67584097859327 |
6064 | 6064 | 2014-01-01 | MXN | Mexico | 37.0 | 13.33275 | 2.77512141156176 |
6065 | 6065 | 2014-01-01 | MYR | Malaysia | 7.4 | 3.3235 | 2.2265683767113 |
6066 | 6066 | 2014-01-01 | NOK | Norway | 48.0 | 6.15745 | 7.79543479849613 |
6067 | 6067 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
6068 | 6068 | 2014-01-01 | PKR | Pakistan | 320.0 | 105.415 | 3.03562111653939 |
6069 | 6069 | 2014-01-01 | PEN | Peru | 10.0 | 2.8065 | 3.56315695706396 |
6070 | 6070 | 2014-01-01 | PHP | Philippines | 135.0 | 45.23 | 2.98474463851426 |
6071 | 6071 | 2014-01-01 | PLN | Poland | 9.2 | 3.0684 | 2.99830530569678 |
6072 | 6072 | 2014-01-01 | RUB | Russia | 89.0 | 33.93925 | 2.62233255007108 |
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 );