bigmac
400 rows where "date" is on date 2007-01-01 sorted by local_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price ▼ | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
284 | 284 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
1614 | 1614 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
2944 | 2944 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
4274 | 4274 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
5604 | 5604 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
6934 | 6934 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
8264 | 8264 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
9594 | 9594 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
10924 | 10924 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
12254 | 12254 | 2007-01-01 | GBP | Britain | 1.94 | 0.506034461 | 3.83373099959688 |
283 | 283 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
1613 | 1613 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
2943 | 2943 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
4273 | 4273 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
5603 | 5603 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
6933 | 6933 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
8263 | 8263 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
9593 | 9593 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
10923 | 10923 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
12253 | 12253 | 2007-01-01 | EUR | Euro area | 2.94 | 0.771813376 | 3.80921099765962 |
308 | 308 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
1638 | 1638 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
2968 | 2968 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
4298 | 4298 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
5628 | 5628 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
6958 | 6958 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
8288 | 8288 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
9618 | 9618 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
10948 | 10948 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
12278 | 12278 | 2007-01-01 | USD | United States | 3.22 | 1.0 | 3.22 |
272 | 272 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
1602 | 1602 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
2932 | 2932 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
4262 | 4262 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
5592 | 5592 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
6922 | 6922 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
8252 | 8252 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
9582 | 9582 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
10912 | 10912 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
12242 | 12242 | 2007-01-01 | AUD | Australia | 3.45 | 1.266865 | 2.72325780568569 |
301 | 301 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
1631 | 1631 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
2961 | 2961 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
4291 | 4291 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
5621 | 5621 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
6951 | 6951 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
8281 | 8281 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
9611 | 9611 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
10941 | 10941 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
12271 | 12271 | 2007-01-01 | SGD | Singapore | 3.6 | 1.53795 | 2.34077830878767 |
274 | 274 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
1604 | 1604 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
2934 | 2934 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
4264 | 4264 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
5594 | 5594 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
6924 | 6924 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
8254 | 8254 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
9584 | 9584 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
10914 | 10914 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
12244 | 12244 | 2007-01-01 | CAD | Canada | 3.63 | 1.17485 | 3.0897561390815897 |
304 | 304 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
1634 | 1634 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
2964 | 2964 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
4294 | 4294 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
5624 | 5624 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
6954 | 6954 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
8284 | 8284 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
9614 | 9614 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
10944 | 10944 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
12274 | 12274 | 2007-01-01 | TRY | Turkey | 4.55 | 1.40975 | 3.22752261039191 |
294 | 294 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
1624 | 1624 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
2954 | 2954 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
4284 | 4284 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
5614 | 5614 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
6944 | 6944 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
8274 | 8274 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
9604 | 9604 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
10934 | 10934 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
12264 | 12264 | 2007-01-01 | NZD | New Zealand | 4.6 | 1.42796 | 3.2213787501050497 |
292 | 292 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
1622 | 1622 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
2952 | 2952 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
4282 | 4282 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
5612 | 5612 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
6942 | 6942 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
8272 | 8272 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
9602 | 9602 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
10932 | 10932 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
12262 | 12262 | 2007-01-01 | MYR | Malaysia | 5.5 | 3.502 | 1.57053112507139 |
275 | 275 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
1605 | 1605 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
2935 | 2935 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
4265 | 4265 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
5595 | 5595 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
6925 | 6925 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
8255 | 8255 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
9585 | 9585 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
10915 | 10915 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
12245 | 12245 | 2007-01-01 | CHF | Switzerland | 6.3 | 1.2485 | 5.04605526631958 |
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 );