bigmac
420 rows where "date" is on date 2014-01-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
735 | 735 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
2065 | 2065 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
3395 | 3395 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
4725 | 4725 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
6055 | 6055 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
7385 | 7385 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
8715 | 8715 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
10045 | 10045 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
11375 | 11375 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
12705 | 12705 | 2014-01-01 | GBP | Britain | 2.79 | 0.603009015 | 4.62679649988317 |
734 | 734 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
2064 | 2064 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
3394 | 3394 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
4724 | 4724 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
6054 | 6054 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
7384 | 7384 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
8714 | 8714 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
10044 | 10044 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
11374 | 11374 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
12704 | 12704 | 2014-01-01 | EUR | Euro area | 3.657962724 | 0.737218475 | 4.96184353491684 |
726 | 726 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
2056 | 2056 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
3386 | 3386 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
4716 | 4716 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
6046 | 6046 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
7376 | 7376 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
8706 | 8706 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
10036 | 10036 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
11366 | 11366 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
12696 | 12696 | 2014-01-01 | CHF | Switzerland | 6.5 | 0.91005 | 7.14246469974177 |
761 | 761 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
2091 | 2091 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
3421 | 3421 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
4751 | 4751 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
6081 | 6081 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
7411 | 7411 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
8741 | 8741 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
10071 | 10071 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
11401 | 11401 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
12731 | 12731 | 2014-01-01 | USD | United States | 4.624166667 | 1.0 | 4.624166667 |
725 | 725 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
2055 | 2055 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
3385 | 3385 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
4715 | 4715 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
6045 | 6045 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
7375 | 7375 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
8705 | 8705 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
10035 | 10035 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
11365 | 11365 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
12695 | 12695 | 2014-01-01 | CAD | Canada | 5.54 | 1.1051 | 5.0131209845262905 |
723 | 723 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
2053 | 2053 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
3383 | 3383 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
4713 | 4713 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
6043 | 6043 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
7373 | 7373 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
8703 | 8703 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
10033 | 10033 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
11363 | 11363 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
12693 | 12693 | 2014-01-01 | AUD | Australia | 5.05 | 1.128859288 | 4.473542498770669 |
747 | 747 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
2077 | 2077 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
3407 | 3407 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
4737 | 4737 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
6067 | 6067 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
7397 | 7397 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
8727 | 8727 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
10057 | 10057 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
11387 | 11387 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
12717 | 12717 | 2014-01-01 | NZD | New Zealand | 5.5 | 1.203007519 | 4.5718749992285 |
754 | 754 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
2084 | 2084 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
3414 | 3414 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
4744 | 4744 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
6074 | 6074 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
7404 | 7404 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
8734 | 8734 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
10064 | 10064 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
11394 | 11394 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
12724 | 12724 | 2014-01-01 | SGD | Singapore | 4.6 | 1.27885 | 3.59698166321304 |
757 | 757 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
2087 | 2087 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
3417 | 3417 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
4747 | 4747 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
6077 | 6077 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
7407 | 7407 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
8737 | 8737 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
10067 | 10067 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
11397 | 11397 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
12727 | 12727 | 2014-01-01 | TRY | Turkey | 8.5 | 2.26155 | 3.75848422542062 |
724 | 724 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
2054 | 2054 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
3384 | 3384 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
4714 | 4714 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
6044 | 6044 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
7374 | 7374 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
8704 | 8704 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
10034 | 10034 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
11364 | 11364 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
12694 | 12694 | 2014-01-01 | BRL | Brazil | 12.4 | 2.36305 | 5.247455618797741 |
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 );