bigmac
560 rows where "date" is on date 2019-01-01 sorted by dollar_ex
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▼ | dollar_price |
---|---|---|---|---|---|---|---|
1191 | 1191 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
2521 | 2521 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
3851 | 3851 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
5181 | 5181 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
6511 | 6511 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
7841 | 7841 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
9171 | 9171 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
10501 | 10501 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
11831 | 11831 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
13161 | 13161 | 2019-01-01 | KWD | Kuwait | 1.05 | 0.3031 | 3.46420323325635 |
1167 | 1167 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
2497 | 2497 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
3827 | 3827 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
5157 | 5157 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
6487 | 6487 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
7817 | 7817 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
9147 | 9147 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
10477 | 10477 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
11807 | 11807 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
13137 | 13137 | 2019-01-01 | BHD | Bahrain | 1.2 | 0.377 | 3.18302387267905 |
1200 | 1200 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
2530 | 2530 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
3860 | 3860 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
5190 | 5190 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
6520 | 6520 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
7850 | 7850 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
9180 | 9180 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
10510 | 10510 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
11840 | 11840 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
13170 | 13170 | 2019-01-01 | OMR | Oman | 1.05 | 0.3849 | 2.7279812938425603 |
1188 | 1188 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
2518 | 2518 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
3848 | 3848 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
5178 | 5178 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
6508 | 6508 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
7838 | 7838 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
9168 | 9168 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
10498 | 10498 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
11828 | 11828 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
13158 | 13158 | 2019-01-01 | JOD | Jordan | 1.95 | 0.7096 | 2.74802705749718 |
1179 | 1179 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
2509 | 2509 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
3839 | 3839 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
5169 | 5169 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
6499 | 6499 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
7829 | 7829 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
9159 | 9159 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
10489 | 10489 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
11819 | 11819 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
13149 | 13149 | 2019-01-01 | GBP | Britain | 3.19 | 0.783208020050125 | 4.072992 |
1178 | 1178 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
2508 | 2508 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
3838 | 3838 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
5168 | 5168 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
6498 | 6498 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
7828 | 7828 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
9158 | 9158 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
10488 | 10488 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
11818 | 11818 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
13148 | 13148 | 2019-01-01 | EUR | Euro area | 4.05 | 0.87248614928238 | 4.641907499999999 |
1170 | 1170 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
2500 | 2500 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
3830 | 3830 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
5160 | 5160 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
6490 | 6490 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
7820 | 7820 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
9150 | 9150 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
10480 | 10480 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
11810 | 11810 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
13140 | 13140 | 2019-01-01 | CHF | Switzerland | 6.5 | 0.98165 | 6.621504609585901 |
1216 | 1216 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
2546 | 2546 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
3876 | 3876 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
5206 | 5206 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
6536 | 6536 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
7866 | 7866 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
9196 | 9196 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
10526 | 10526 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
11856 | 11856 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
13186 | 13186 | 2019-01-01 | USD | United States | 5.58 | 1.0 | 5.58 |
1169 | 1169 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
2499 | 2499 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
3829 | 3829 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
5159 | 5159 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
6489 | 6489 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
7819 | 7819 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
9149 | 9149 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
10479 | 10479 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
11809 | 11809 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
13139 | 13139 | 2019-01-01 | CAD | Canada | 6.77 | 1.3314 | 5.08487306594562 |
1209 | 1209 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
2539 | 2539 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
3869 | 3869 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
5199 | 5199 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
6529 | 6529 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
7859 | 7859 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
9189 | 9189 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
10519 | 10519 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
11849 | 11849 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
13179 | 13179 | 2019-01-01 | SGD | Singapore | 5.8 | 1.3559 | 4.27760159303783 |
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 );