bigmac
410 rows where "date" is on date 2009-07-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
404 | 404 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
1734 | 1734 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
3064 | 3064 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
4394 | 4394 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
5724 | 5724 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
7054 | 7054 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
8384 | 8384 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
9714 | 9714 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
11044 | 11044 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
12374 | 12374 | 2009-07-01 | GBP | Britain | 2.29 | 0.620886626 | 3.6882740006063504 |
403 | 403 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
1733 | 1733 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
3063 | 3063 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
4393 | 4393 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
5723 | 5723 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
7053 | 7053 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
8383 | 8383 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
9713 | 9713 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
11043 | 11043 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
12373 | 12373 | 2009-07-01 | EUR | Euro area | 3.31 | 0.7168972690000001 | 4.6171189975617 |
429 | 429 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
1759 | 1759 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
3089 | 3089 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
4419 | 4419 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
5749 | 5749 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
7079 | 7079 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
8409 | 8409 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
9739 | 9739 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
11069 | 11069 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
12399 | 12399 | 2009-07-01 | USD | United States | 3.57 | 1.0 | 3.57 |
395 | 395 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
1725 | 1725 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
3055 | 3055 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
4385 | 4385 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
5715 | 5715 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
7045 | 7045 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
8375 | 8375 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
9705 | 9705 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
11035 | 11035 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
12365 | 12365 | 2009-07-01 | CHF | Switzerland | 6.5 | 1.08605 | 5.98499148289674 |
394 | 394 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
1724 | 1724 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
3054 | 3054 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
4384 | 4384 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
5714 | 5714 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
7044 | 7044 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
8374 | 8374 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
9704 | 9704 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
11034 | 11034 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
12364 | 12364 | 2009-07-01 | CAD | Canada | 3.89 | 1.16085 | 3.3509928069948702 |
392 | 392 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
1722 | 1722 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
3052 | 3052 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
4382 | 4382 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
5712 | 5712 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
7042 | 7042 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
8372 | 8372 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
9702 | 9702 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
11032 | 11032 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
12362 | 12362 | 2009-07-01 | AUD | Australia | 4.34 | 1.2869 | 3.37244541145388 |
422 | 422 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
1752 | 1752 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
3082 | 3082 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
4412 | 4412 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
5742 | 5742 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
7072 | 7072 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
8402 | 8402 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
9732 | 9732 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
11062 | 11062 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
12392 | 12392 | 2009-07-01 | SGD | Singapore | 4.22 | 1.4645 | 2.8815295322635697 |
425 | 425 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
1755 | 1755 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
3085 | 3085 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
4415 | 4415 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
5745 | 5745 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
7075 | 7075 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
8405 | 8405 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
9735 | 9735 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
11065 | 11065 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
12395 | 12395 | 2009-07-01 | TRY | Turkey | 5.65 | 1.55005 | 3.64504370826748 |
415 | 415 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
1745 | 1745 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
3075 | 3075 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
4405 | 4405 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
5735 | 5735 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
7065 | 7065 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
8395 | 8395 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
9725 | 9725 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
11055 | 11055 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
12385 | 12385 | 2009-07-01 | NZD | New Zealand | 4.9 | 1.59235 | 3.07721292429428 |
393 | 393 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
1723 | 1723 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
3053 | 3053 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
4383 | 4383 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
5713 | 5713 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
7043 | 7043 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
8373 | 8373 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
9703 | 9703 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
11033 | 11033 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
12363 | 12363 | 2009-07-01 | BRL | Brazil | 8.03 | 1.9971 | 4.0208302037955 |
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 );