View gist:53006539f9358667018406e0ef47dc22
region
12 W. Europe
14 small WEC
15 L. America
15 W. Asia
16 E. Asia
21 Caribbean
24 Sm. E. Asia
3 Small Afr.
30 E. Asia
View gist:55a78ba2f406d38621d94b69a30b3d39
pwt56.sql: 'Germany' not found
pwt56.sql: 'Russia' not found
pwt56.sql: 'Vietnam' not found
pwt56.sql: 'Czech Republic' not found
pwt56.sql: 'Kazakhstan' not found
pwt56.sql: 'Ukraine' not found
pwt56.sql: 'Slovakia' not found
pwt56.sql: 'Uzbekistan' not found
pwt56.sql: 'Lebanon' not found
pwt56.sql: 'Croatia' not found
View dump.tsv
region
(Centre- North) Italy Center-North Italy
12 W. Europe
14 small WEC
15 L. America
15 W. Asia
16 E. Asia
21 Caribbean
24 Sm. E. Asia
3 Small Afr.
View dump.tsv
region group_concat(distinct (select shortname from datasets where datasets.url=database_url))
(Centre- North) Italy maddison2013
12 W. Europe maddison2013
14 small WEC maddison2013
15 L. America maddison2013
15 W. Asia maddison2013
16 E. Asia maddison2013
21 Caribbean maddison2013
24 Sm. E. Asia maddison2013
3 Small Afr. maddison2013
View gist:55373c3e33d5683449454edc20a6746a
mysql> select count(*),metric,units from t1 group by metric,units having count(*) >1;
+----------+---------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------+
| count(*) | metric | units |
+----------+---------------------------------------------------------------------------------------------------------------------+------------------------------------------------------------------+
| 2 | Average depreciation rate of the capital stock | Unitless |
| 2 | Capital stock at constant 2005 national prices | 2005 international dollar |
| 2 | Capital stock at current PPPs | 2005 international dollar
View gist:3ec08bf75ada9f3d77a7fb4a46f884b9
mysql> select count(*),metric from t1 group by metric having count(*) > 1;
+----------+---------------------------------------------------------------------------------------------------------------------+
| count(*) | metric |
+----------+---------------------------------------------------------------------------------------------------------------------+
| 3 | Adjusted net national income |
| 3 | Adjusted net national income per capita |
| 2 | Adjusted net savings, excluding particulate emission damage |
| 2 | Adjusted net savings, including particulate emission damage |
| 2 | Adjusted savings: carbon dioxide damage |
| 2 | Adjusted savings: consumption of fixed capital
View gist:039b8b0bdb4eb5d7c2c1cc23055b1510
mysql> select odate,boolean from t2 where metric='Adjusted net national income per capita' and units='annual % growth';
+----------+---------+
| odate | boolean |
+----------+---------+
| 19710000 | 0 |
| 19720000 | 0 |
| 19730000 | 0 |
| 19740000 | 0 |
| 19750000 | 0 |
| 19760000 | 0 |
View dump.tsv
We can make this file beautiful and searchable if this error is corrected: It looks like row 9 should actually have 9 columns, instead of 8.
metric units shortname (min, 1) (max, 1) (min, 0) (max, 0) start end
Adjusted net national income per capita annual % growth wdi201709 19840000 19840000 19710000 20150000 19710000 20150000
Adjusted net savings, excluding particulate emission damage current US dollar wdi201709 19720000 20150000 19700000 19710000 19700000 20150000
Adjusted savings: carbon dioxide damage current US dollar wdi201709 19780000 20140000 19700000 19770000 19700000 20140000
Adjusted savings: energy depletion current US dollar wdi201709 19740000 20140000 19700000 20150000 19700000 20150000
Adjusted savings: energy depletion Unitless wdi201709 19740000 19850000 19700000 20150000 19700000 20150000
Adjusted savings: mineral depletion current US dollar wdi201709 20060000 20150000 19700000 20050000 19700000 20150000
Adjusted savings: natural resources depletion Unitless wdi201709 19740000 19840000 19700000 20150000 19700000 20150000
Adjusted savings: net national savings current US dollar wdi201709 19780000 20150000 19700000 20110000 197000
View gist:01bfb66cc93ec65302eb34bc918fefda
mysql> select odate,boolean from t2 where metric='Adjusted net national income';
+----------+---------+
| odate | boolean |
+----------+---------+
| 19710000 | 0 |
| 19720000 | 0 |
| 19730000 | 0 |
| 19740000 | 0 |
| 19750000 | 0 |
| 19760000 | 0 |
View dump.tsv
(Centre- North) Italy
12 W. Europe
14 small WEC
15 L. America
15 W. Asia
16 E. Asia
21 Caribbean
24 Sm. E. Asia
3 Small Afr.
30 E. Asia