bigmac
400 rows where "date" is on date 2012-07-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
610 | 610 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
1940 | 1940 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
3270 | 3270 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
4600 | 4600 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
5930 | 5930 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
7260 | 7260 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
8590 | 8590 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
9920 | 9920 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
11250 | 11250 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
12580 | 12580 | 2012-07-01 | GBP | Britain | 2.69 | 0.646266197 | 4.1623715002999 |
609 | 609 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
1939 | 1939 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
3269 | 3269 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
4599 | 4599 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
5929 | 5929 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
7259 | 7259 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
8589 | 8589 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
9919 | 9919 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
11249 | 11249 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
12579 | 12579 | 2012-07-01 | EUR | Euro area | 3.5834822410000005 | 0.8248443109999999 | 4.3444346929611095 |
599 | 599 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
1929 | 1929 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
3259 | 3259 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
4589 | 4589 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
5919 | 5919 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
7249 | 7249 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
8579 | 8579 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
9909 | 9909 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
11239 | 11239 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
12569 | 12569 | 2012-07-01 | AUD | Australia | 4.56 | 0.974326497 | 4.68015599908292 |
602 | 602 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
1932 | 1932 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
3262 | 3262 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
4592 | 4592 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
5922 | 5922 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
7252 | 7252 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
8582 | 8582 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
9912 | 9912 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
11242 | 11242 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
12572 | 12572 | 2012-07-01 | CHF | Switzerland | 6.5 | 0.9906 | 6.56167979002625 |
635 | 635 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
1965 | 1965 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
3295 | 3295 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
4625 | 4625 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
5955 | 5955 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
7285 | 7285 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
8615 | 8615 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
9945 | 9945 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
11275 | 11275 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
12605 | 12605 | 2012-07-01 | USD | United States | 4.3275 | 1.0 | 4.3275 |
601 | 601 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
1931 | 1931 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
3261 | 3261 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
4591 | 4591 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
5921 | 5921 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
7251 | 7251 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
8581 | 8581 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
9911 | 9911 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
11241 | 11241 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
12571 | 12571 | 2012-07-01 | CAD | Canada | 5.12 | 1.01945 | 5.02231595468145 |
628 | 628 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
1958 | 1958 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
3288 | 3288 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
4618 | 4618 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
5948 | 5948 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
7278 | 7278 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
8608 | 8608 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
9938 | 9938 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
11268 | 11268 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
12598 | 12598 | 2012-07-01 | SGD | Singapore | 4.4 | 1.2585 | 3.49622566547477 |
622 | 622 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
1952 | 1952 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
3282 | 3282 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
4612 | 4612 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
5942 | 5942 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
7272 | 7272 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
8602 | 8602 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
9932 | 9932 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
11262 | 11262 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
12592 | 12592 | 2012-07-01 | NZD | New Zealand | 5.1 | 1.273560876 | 4.004520000659951 |
631 | 631 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
1961 | 1961 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
3291 | 3291 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
4621 | 4621 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
5951 | 5951 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
7281 | 7281 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
8611 | 8611 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
9941 | 9941 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
11271 | 11271 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
12601 | 12601 | 2012-07-01 | TRY | Turkey | 8.25 | 1.8269 | 4.51584651595599 |
600 | 600 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
1930 | 1930 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
3260 | 3260 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
4590 | 4590 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
5920 | 5920 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
7250 | 7250 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
8580 | 8580 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
9910 | 9910 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
11240 | 11240 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
12570 | 12570 | 2012-07-01 | BRL | Brazil | 10.08 | 2.04215 | 4.935974340768309 |
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 );