bigmac
430 rows where "date" is on date 2016-07-01 sorted by local_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price ▼ | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
949 | 949 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
2279 | 2279 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
3609 | 3609 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
4939 | 4939 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
6269 | 6269 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
7599 | 7599 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
8929 | 8929 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
10259 | 10259 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
11589 | 11589 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
12919 | 12919 | 2016-07-01 | GBP | Britain | 2.99 | 0.758840492 | 3.94022199859098 |
948 | 948 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
2278 | 2278 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
3608 | 3608 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
4938 | 4938 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
6268 | 6268 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
7598 | 7598 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
8928 | 8928 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
10258 | 10258 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
11588 | 11588 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
12918 | 12918 | 2016-07-01 | EUR | Euro area | 3.82 | 0.908306463 | 4.20562899815015 |
975 | 975 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
2305 | 2305 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
3635 | 3635 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
4965 | 4965 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
6295 | 6295 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
7625 | 7625 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
8955 | 8955 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
10285 | 10285 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
11615 | 11615 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
12945 | 12945 | 2016-07-01 | USD | United States | 5.04 | 1.0 | 5.04 |
968 | 968 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
2298 | 2298 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
3628 | 3628 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
4958 | 4958 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
6288 | 6288 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
7618 | 7618 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
8948 | 8948 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
10278 | 10278 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
11608 | 11608 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
12938 | 12938 | 2016-07-01 | SGD | Singapore | 5.45 | 1.3577 | 4.01414156293732 |
937 | 937 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
2267 | 2267 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
3597 | 3597 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
4927 | 4927 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
6257 | 6257 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
7587 | 7587 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
8917 | 8917 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
10247 | 10247 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
11577 | 11577 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
12907 | 12907 | 2016-07-01 | AUD | Australia | 5.75 | 1.335737661 | 4.3047375003975406 |
939 | 939 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
961 | 961 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
2269 | 2269 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
2291 | 2291 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
3599 | 3599 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
3621 | 3621 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
4929 | 4929 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
4951 | 4951 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
6259 | 6259 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
6281 | 6281 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
7589 | 7589 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
7611 | 7611 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
8919 | 8919 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
8941 | 8941 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
10249 | 10249 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
10271 | 10271 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
11579 | 11579 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
11601 | 11601 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
12909 | 12909 | 2016-07-01 | CAD | Canada | 6.0 | 1.3030000000000002 | 4.60475825019187 |
12931 | 12931 | 2016-07-01 | NZD | New Zealand | 6.0 | 1.4213630869999998 | 4.221300000595839 |
940 | 940 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
2270 | 2270 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
3600 | 3600 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
4930 | 4930 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
6260 | 6260 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
7590 | 7590 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
8920 | 8920 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
10250 | 10250 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
11580 | 11580 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
12910 | 12910 | 2016-07-01 | CHF | Switzerland | 6.5 | 0.9861 | 6.59162356758949 |
959 | 959 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
2289 | 2289 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
3619 | 3619 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
4949 | 4949 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
6279 | 6279 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
7609 | 7609 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
8939 | 8939 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
10269 | 10269 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
11599 | 11599 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
12929 | 12929 | 2016-07-01 | MYR | Malaysia | 8.0 | 4.027 | 1.9865905140303 |
965 | 965 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
2295 | 2295 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
3625 | 3625 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
4955 | 4955 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
6285 | 6285 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
7615 | 7615 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
8945 | 8945 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
10275 | 10275 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
11605 | 11605 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
12935 | 12935 | 2016-07-01 | PLN | Poland | 9.6 | 3.96565 | 2.42078852142776 |
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 );