bigmac
320 rows where "date" is on date 2002-04-01 sorted by local_price
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price ▼ | dollar_ex | dollar_price |
---|---|---|---|---|---|---|---|
67 | 67 | 2002-04-01 | GBP | Britain | 1.99 | 0.689655172 | 2.8855000017313 |
1397 | 1397 | 2002-04-01 | GBP | Britain | 1.99 | 0.689655172 | 2.8855000017313 |
2727 | 2727 | 2002-04-01 | GBP | Britain | 1.99 | 0.689655172 | 2.8855000017313 |
4057 | 4057 | 2002-04-01 | GBP | Britain | 1.99 | 0.689655172 | 2.8855000017313 |
5387 | 5387 | 2002-04-01 | GBP | Britain | 1.99 | 0.689655172 | 2.8855000017313 |
6717 | 6717 | 2002-04-01 | GBP | Britain | 1.99 | 0.689655172 | 2.8855000017313 |
8047 | 8047 | 2002-04-01 | GBP | Britain | 1.99 | 0.689655172 | 2.8855000017313 |
9377 | 9377 | 2002-04-01 | GBP | Britain | 1.99 | 0.689655172 | 2.8855000017313 |
10707 | 10707 | 2002-04-01 | GBP | Britain | 1.99 | 0.689655172 | 2.8855000017313 |
12037 | 12037 | 2002-04-01 | GBP | Britain | 1.99 | 0.689655172 | 2.8855000017313 |
87 | 87 | 2002-04-01 | USD | United States | 2.49 | 1.0 | 2.49 |
1417 | 1417 | 2002-04-01 | USD | United States | 2.49 | 1.0 | 2.49 |
2747 | 2747 | 2002-04-01 | USD | United States | 2.49 | 1.0 | 2.49 |
4077 | 4077 | 2002-04-01 | USD | United States | 2.49 | 1.0 | 2.49 |
5407 | 5407 | 2002-04-01 | USD | United States | 2.49 | 1.0 | 2.49 |
6737 | 6737 | 2002-04-01 | USD | United States | 2.49 | 1.0 | 2.49 |
8067 | 8067 | 2002-04-01 | USD | United States | 2.49 | 1.0 | 2.49 |
9397 | 9397 | 2002-04-01 | USD | United States | 2.49 | 1.0 | 2.49 |
10727 | 10727 | 2002-04-01 | USD | United States | 2.49 | 1.0 | 2.49 |
12057 | 12057 | 2002-04-01 | USD | United States | 2.49 | 1.0 | 2.49 |
57 | 57 | 2002-04-01 | ARS | Argentina | 2.5 | 3.13 | 0.7987220447284351 |
1387 | 1387 | 2002-04-01 | ARS | Argentina | 2.5 | 3.13 | 0.7987220447284351 |
2717 | 2717 | 2002-04-01 | ARS | Argentina | 2.5 | 3.13 | 0.7987220447284351 |
4047 | 4047 | 2002-04-01 | ARS | Argentina | 2.5 | 3.13 | 0.7987220447284351 |
5377 | 5377 | 2002-04-01 | ARS | Argentina | 2.5 | 3.13 | 0.7987220447284351 |
6707 | 6707 | 2002-04-01 | ARS | Argentina | 2.5 | 3.13 | 0.7987220447284351 |
8037 | 8037 | 2002-04-01 | ARS | Argentina | 2.5 | 3.13 | 0.7987220447284351 |
9367 | 9367 | 2002-04-01 | ARS | Argentina | 2.5 | 3.13 | 0.7987220447284351 |
10697 | 10697 | 2002-04-01 | ARS | Argentina | 2.5 | 3.13 | 0.7987220447284351 |
12027 | 12027 | 2002-04-01 | ARS | Argentina | 2.5 | 3.13 | 0.7987220447284351 |
66 | 66 | 2002-04-01 | EUR | Euro area | 2.67 | 1.123595506 | 2.37629999919206 |
1396 | 1396 | 2002-04-01 | EUR | Euro area | 2.67 | 1.123595506 | 2.37629999919206 |
2726 | 2726 | 2002-04-01 | EUR | Euro area | 2.67 | 1.123595506 | 2.37629999919206 |
4056 | 4056 | 2002-04-01 | EUR | Euro area | 2.67 | 1.123595506 | 2.37629999919206 |
5386 | 5386 | 2002-04-01 | EUR | Euro area | 2.67 | 1.123595506 | 2.37629999919206 |
6716 | 6716 | 2002-04-01 | EUR | Euro area | 2.67 | 1.123595506 | 2.37629999919206 |
8046 | 8046 | 2002-04-01 | EUR | Euro area | 2.67 | 1.123595506 | 2.37629999919206 |
9376 | 9376 | 2002-04-01 | EUR | Euro area | 2.67 | 1.123595506 | 2.37629999919206 |
10706 | 10706 | 2002-04-01 | EUR | Euro area | 2.67 | 1.123595506 | 2.37629999919206 |
12036 | 12036 | 2002-04-01 | EUR | Euro area | 2.67 | 1.123595506 | 2.37629999919206 |
58 | 58 | 2002-04-01 | AUD | Australia | 3.0 | 1.86 | 1.61290322580645 |
1388 | 1388 | 2002-04-01 | AUD | Australia | 3.0 | 1.86 | 1.61290322580645 |
2718 | 2718 | 2002-04-01 | AUD | Australia | 3.0 | 1.86 | 1.61290322580645 |
4048 | 4048 | 2002-04-01 | AUD | Australia | 3.0 | 1.86 | 1.61290322580645 |
5378 | 5378 | 2002-04-01 | AUD | Australia | 3.0 | 1.86 | 1.61290322580645 |
6708 | 6708 | 2002-04-01 | AUD | Australia | 3.0 | 1.86 | 1.61290322580645 |
8038 | 8038 | 2002-04-01 | AUD | Australia | 3.0 | 1.86 | 1.61290322580645 |
9368 | 9368 | 2002-04-01 | AUD | Australia | 3.0 | 1.86 | 1.61290322580645 |
10698 | 10698 | 2002-04-01 | AUD | Australia | 3.0 | 1.86 | 1.61290322580645 |
12028 | 12028 | 2002-04-01 | AUD | Australia | 3.0 | 1.86 | 1.61290322580645 |
82 | 82 | 2002-04-01 | SGD | Singapore | 3.3 | 1.82 | 1.81318681318681 |
1412 | 1412 | 2002-04-01 | SGD | Singapore | 3.3 | 1.82 | 1.81318681318681 |
2742 | 2742 | 2002-04-01 | SGD | Singapore | 3.3 | 1.82 | 1.81318681318681 |
4072 | 4072 | 2002-04-01 | SGD | Singapore | 3.3 | 1.82 | 1.81318681318681 |
5402 | 5402 | 2002-04-01 | SGD | Singapore | 3.3 | 1.82 | 1.81318681318681 |
6732 | 6732 | 2002-04-01 | SGD | Singapore | 3.3 | 1.82 | 1.81318681318681 |
8062 | 8062 | 2002-04-01 | SGD | Singapore | 3.3 | 1.82 | 1.81318681318681 |
9392 | 9392 | 2002-04-01 | SGD | Singapore | 3.3 | 1.82 | 1.81318681318681 |
10722 | 10722 | 2002-04-01 | SGD | Singapore | 3.3 | 1.82 | 1.81318681318681 |
12052 | 12052 | 2002-04-01 | SGD | Singapore | 3.3 | 1.82 | 1.81318681318681 |
60 | 60 | 2002-04-01 | CAD | Canada | 3.33 | 1.57 | 2.12101910828025 |
1390 | 1390 | 2002-04-01 | CAD | Canada | 3.33 | 1.57 | 2.12101910828025 |
2720 | 2720 | 2002-04-01 | CAD | Canada | 3.33 | 1.57 | 2.12101910828025 |
4050 | 4050 | 2002-04-01 | CAD | Canada | 3.33 | 1.57 | 2.12101910828025 |
5380 | 5380 | 2002-04-01 | CAD | Canada | 3.33 | 1.57 | 2.12101910828025 |
6710 | 6710 | 2002-04-01 | CAD | Canada | 3.33 | 1.57 | 2.12101910828025 |
8040 | 8040 | 2002-04-01 | CAD | Canada | 3.33 | 1.57 | 2.12101910828025 |
9370 | 9370 | 2002-04-01 | CAD | Canada | 3.33 | 1.57 | 2.12101910828025 |
10700 | 10700 | 2002-04-01 | CAD | Canada | 3.33 | 1.57 | 2.12101910828025 |
12030 | 12030 | 2002-04-01 | CAD | Canada | 3.33 | 1.57 | 2.12101910828025 |
59 | 59 | 2002-04-01 | BRL | Brazil | 3.6 | 2.34 | 1.53846153846154 |
77 | 77 | 2002-04-01 | NZD | New Zealand | 3.6 | 2.24 | 1.60714285714286 |
1389 | 1389 | 2002-04-01 | BRL | Brazil | 3.6 | 2.34 | 1.53846153846154 |
1407 | 1407 | 2002-04-01 | NZD | New Zealand | 3.6 | 2.24 | 1.60714285714286 |
2719 | 2719 | 2002-04-01 | BRL | Brazil | 3.6 | 2.34 | 1.53846153846154 |
2737 | 2737 | 2002-04-01 | NZD | New Zealand | 3.6 | 2.24 | 1.60714285714286 |
4049 | 4049 | 2002-04-01 | BRL | Brazil | 3.6 | 2.34 | 1.53846153846154 |
4067 | 4067 | 2002-04-01 | NZD | New Zealand | 3.6 | 2.24 | 1.60714285714286 |
5379 | 5379 | 2002-04-01 | BRL | Brazil | 3.6 | 2.34 | 1.53846153846154 |
5397 | 5397 | 2002-04-01 | NZD | New Zealand | 3.6 | 2.24 | 1.60714285714286 |
6709 | 6709 | 2002-04-01 | BRL | Brazil | 3.6 | 2.34 | 1.53846153846154 |
6727 | 6727 | 2002-04-01 | NZD | New Zealand | 3.6 | 2.24 | 1.60714285714286 |
8039 | 8039 | 2002-04-01 | BRL | Brazil | 3.6 | 2.34 | 1.53846153846154 |
8057 | 8057 | 2002-04-01 | NZD | New Zealand | 3.6 | 2.24 | 1.60714285714286 |
9369 | 9369 | 2002-04-01 | BRL | Brazil | 3.6 | 2.34 | 1.53846153846154 |
9387 | 9387 | 2002-04-01 | NZD | New Zealand | 3.6 | 2.24 | 1.60714285714286 |
10699 | 10699 | 2002-04-01 | BRL | Brazil | 3.6 | 2.34 | 1.53846153846154 |
10717 | 10717 | 2002-04-01 | NZD | New Zealand | 3.6 | 2.24 | 1.60714285714286 |
12029 | 12029 | 2002-04-01 | BRL | Brazil | 3.6 | 2.34 | 1.53846153846154 |
12047 | 12047 | 2002-04-01 | NZD | New Zealand | 3.6 | 2.24 | 1.60714285714286 |
75 | 75 | 2002-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
1405 | 1405 | 2002-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
2735 | 2735 | 2002-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
4065 | 4065 | 2002-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
5395 | 5395 | 2002-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
6725 | 6725 | 2002-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
8055 | 8055 | 2002-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
9385 | 9385 | 2002-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
10715 | 10715 | 2002-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
12045 | 12045 | 2002-04-01 | MYR | Malaysia | 5.04 | 3.8 | 1.32631578947368 |
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 );