bigmac
560 rows where "date" is on date 2019-01-01 sorted by dollar_ex descending
This data as json, CSV (advanced)
Link | rowid | date | currency_code | name | local_price | dollar_ex ▲ | dollar_price |
---|---|---|---|---|---|---|---|
1217 | 1217 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
2547 | 2547 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
3877 | 3877 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
5207 | 5207 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
6537 | 6537 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
7867 | 7867 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
9197 | 9197 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
10527 | 10527 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
11857 | 11857 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
13187 | 13187 | 2019-01-01 | VND | Vietnam | 65000.0 | 23199.0 | 2.801844907108069 |
1185 | 1185 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
2515 | 2515 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
3845 | 3845 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
5175 | 5175 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
6505 | 6505 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
7835 | 7835 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
9165 | 9165 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
10495 | 10495 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
11825 | 11825 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
13155 | 13155 | 2019-01-01 | IDR | Indonesia | 33000.0 | 14090.0 | 2.34208658623137 |
1173 | 1173 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
2503 | 2503 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
3833 | 3833 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
5163 | 5163 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
6493 | 6493 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
7823 | 7823 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
9153 | 9153 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
10483 | 10483 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
11813 | 11813 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
13143 | 13143 | 2019-01-01 | COP | Colombia | 11900.0 | 3191.5 | 3.72865423781921 |
1192 | 1192 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
2522 | 2522 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
3852 | 3852 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
5182 | 5182 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
6512 | 6512 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
7842 | 7842 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
9172 | 9172 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
10502 | 10502 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
11832 | 11832 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
13162 | 13162 | 2019-01-01 | LBP | Lebanon | 6500.0 | 1507.0 | 4.31320504313205 |
1190 | 1190 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
2520 | 2520 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
3850 | 3850 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
5180 | 5180 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
6510 | 6510 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
7840 | 7840 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
9170 | 9170 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
10500 | 10500 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
11830 | 11830 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
13160 | 13160 | 2019-01-01 | KRW | South Korea | 4500.0 | 1118.6 | 4.0228857500447 |
1171 | 1171 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
2501 | 2501 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
3831 | 3831 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
5161 | 5161 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
6491 | 6491 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
7821 | 7821 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
9151 | 9151 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
10481 | 10481 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
11811 | 11811 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
13141 | 13141 | 2019-01-01 | CLP | Chile | 2640.0 | 678.99 | 3.8881279547563294 |
1174 | 1174 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
2504 | 2504 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
3834 | 3834 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
5164 | 5164 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
6494 | 6494 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
7824 | 7824 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
9154 | 9154 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
10484 | 10484 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
11814 | 11814 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
13144 | 13144 | 2019-01-01 | CRC | Costa Rica | 2290.0 | 606.975 | 3.77280777626756 |
1184 | 1184 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
2514 | 2514 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
3844 | 3844 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
5174 | 5174 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
6504 | 6504 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
7834 | 7834 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
9164 | 9164 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
10494 | 10494 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
11824 | 11824 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
13154 | 13154 | 2019-01-01 | HUF | Hungary | 850.0 | 280.26875 | 3.0328033360836697 |
1193 | 1193 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
2523 | 2523 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
3853 | 3853 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
5183 | 5183 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
6513 | 6513 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
7843 | 7843 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
9173 | 9173 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
10503 | 10503 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
11833 | 11833 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
13163 | 13163 | 2019-01-01 | LKR | Sri Lanka | 580.0 | 182.245 | 3.18252901314165 |
1201 | 1201 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
2531 | 2531 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
3861 | 3861 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
5191 | 5191 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
6521 | 6521 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
7851 | 7851 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
9181 | 9181 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
10511 | 10511 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
11841 | 11841 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
13171 | 13171 | 2019-01-01 | PKR | Pakistan | 460.0 | 138.88 | 3.3122119815668194 |
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 );