bigmac
420 rows where "date" is on date 2012-01-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
569 | 569 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
1899 | 1899 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
3229 | 3229 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
4559 | 4559 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
5889 | 5889 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
7219 | 7219 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
8549 | 8549 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
9879 | 9879 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
11209 | 11209 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
12539 | 12539 | 2012-01-01 | GBP | Britain | 2.49 | 0.651253663 | 3.82339500177214 |
568 | 568 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
1898 | 1898 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
3228 | 3228 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
4558 | 4558 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
5888 | 5888 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
7218 | 7218 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
8548 | 8548 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
9878 | 9878 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
11208 | 11208 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
12538 | 12538 | 2012-01-01 | EUR | Euro area | 3.49245637 | 0.788239467 | 4.43070477464433 |
560 | 560 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
1890 | 1890 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
3220 | 3220 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
4550 | 4550 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
5880 | 5880 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
7210 | 7210 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
8540 | 8540 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
9870 | 9870 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
11200 | 11200 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
12530 | 12530 | 2012-01-01 | CHF | Switzerland | 6.5 | 0.9551 | 6.805570097372001 |
557 | 557 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
1887 | 1887 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
3217 | 3217 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
4547 | 4547 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
5877 | 5877 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
7207 | 7207 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
8537 | 8537 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
9867 | 9867 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
11197 | 11197 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
12527 | 12527 | 2012-01-01 | AUD | Australia | 4.8 | 0.972337012 | 4.9365600000424505 |
595 | 595 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
1925 | 1925 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
3255 | 3255 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
4585 | 4585 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
5915 | 5915 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
7245 | 7245 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
8575 | 8575 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
9905 | 9905 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
11235 | 11235 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
12565 | 12565 | 2012-01-01 | USD | United States | 4.19722 | 1.0 | 4.19722 |
559 | 559 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
1889 | 1889 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
3219 | 3219 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
4549 | 4549 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
5879 | 5879 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
7209 | 7209 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
8539 | 8539 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
9869 | 9869 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
11199 | 11199 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
12529 | 12529 | 2012-01-01 | CAD | Canada | 4.73 | 1.02095 | 4.63293990890837 |
581 | 581 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
1911 | 1911 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
3241 | 3241 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
4571 | 4571 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
5901 | 5901 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
7231 | 7231 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
8561 | 8561 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
9891 | 9891 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
11221 | 11221 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
12551 | 12551 | 2012-01-01 | NZD | New Zealand | 5.1 | 1.26000126 | 4.04761500000405 |
588 | 588 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
1918 | 1918 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
3248 | 3248 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
4578 | 4578 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
5908 | 5908 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
7238 | 7238 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
8568 | 8568 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
9898 | 9898 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
11228 | 11228 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
12558 | 12558 | 2012-01-01 | SGD | Singapore | 4.85 | 1.2928 | 3.7515470297029694 |
558 | 558 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
1888 | 1888 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
3218 | 3218 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
4548 | 4548 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
5878 | 5878 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
7208 | 7208 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
8538 | 8538 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
9868 | 9868 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
11198 | 11198 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
12528 | 12528 | 2012-01-01 | BRL | Brazil | 10.25 | 1.805 | 5.6786703601108 |
591 | 591 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
1921 | 1921 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
3251 | 3251 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
4581 | 4581 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
5911 | 5911 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
7241 | 7241 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
8571 | 8571 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
9901 | 9901 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
11231 | 11231 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
12561 | 12561 | 2012-01-01 | TRY | Turkey | 6.6 | 1.86295 | 3.54276819023592 |
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 );