Total Economy Database: Difference between revisions
| Line 125: | Line 125: | ||
==Reception== | ==Reception== | ||
{| class="sortable wikitable" | {| class="sortable wikitable" | ||
Revision as of 20:30, 20 October 2017
The Total Economy Database describes itself as "a comprehensive database with annual data covering GDP, population, employment, hours, labor quality, capital services, labor productivity, and Total Factor Productivity for 123 countries in the world".[1]
Summary
Versions
Each release of the database comes in the form of two or three spreadsheets. These are "Output, Labor, and Labor Productivity", "Growth Accounting and Total Factor Productivity", and "Regional Aggregates". The following spreadsheets are listed in the archive or available through the "Data" page:[2][3]
| Spreadsheet | Publication date | Years covered |
|---|---|---|
| Output, Labor, and Labor Productivity | January 2011 | 1950–2010 |
| Growth Accounting and Total Factor Productivity | January 2011 | 1990–2009 |
| Regional Aggregates | January 2011 | 1990–2011 |
| Output, Labor, and Labor Productivity | January 2012 | 1950–2011 |
| Growth Accounting and Total Factor Productivity | January 2012 | 1990–2011 |
| Regional Aggregates | January 2012 | 1990–2012 |
| Output, Labor, and Labor Productivity | January 2013 | 1950–2012 |
| Growth Accounting and Total Factor Productivity | January 2013 | 1990–2012 |
| Regional Aggregates | January 2013 | 1990–2013 |
| Output, Labor, and Labor Productivity | January 2014 | 1950–2013 |
| Growth Accounting and Total Factor Productivity | January 2014 | 1990–2013 |
| Regional Aggregates | January 2014 | 1990–2014 |
| Output, Labor, and Labor Productivity | May 2015 | 1950–2015 |
| Growth Accounting and Total Factor Productivity | May 2015 | 1990–2014 |
| Regional Aggregates | May 2015 | 1990–2015 |
| Output, Labor, and Labor Productivity | September 2015 | 1950–2015 |
| Growth Accounting and Total Factor Productivity | September 2015 | 1990–2014 |
| Output, Labor, and Labor Productivity | May 2016 | 1950–2016 |
| Regional Aggregates | May 2016 | 1990–2016 |
| Output, Labor, and Labor Productivity | November 2016 | 1950–2016 |
| Growth Accounting and Total Factor Productivity | November 2016 | 1995–2015 |
| Regional Aggregates | November 2016 | 1990–2016 |
| Output, Labor, and Labor Productivity | May 2017 | 1950–2017 |
| Growth Accounting and Total Factor Productivity | May 2017 | 1990–2016 |
| Regional Aggregates | May 2017 | 1990–2017 |
In the devec database, use name = 'Total Economy Database' to find these:
mysql> select shortname,release_date,version from datasets
-> where name = 'Total Economy Database';
+----------------+--------------+----------------+
| shortname | release_date | version |
+----------------+--------------+----------------+
| ted201705ollp | 2017-05-01 | May 2017 |
| ted201705gatfp | 2017-05-01 | May 2017 |
| ted201705ra | 2017-05-01 | May 2017 |
| ted201611ollp | 2016-11-01 | November 2016 |
| ted201611gatfp | 2016-11-01 | November 2016 |
| ted201611ra | 2016-11-01 | November 2016 |
| ted201605ollp | 2016-05-01 | May 2016 |
| ted201605ra | 2016-05-01 | May 2016 |
| ted201509ollp | 2015-09-01 | September 2015 |
| ted201509gatfp | 2015-09-01 | September 2015 |
| ted201505ollp | 2015-05-01 | May 2015 |
| ted201505gatfp | 2015-05-01 | May 2015 |
| ted201505ra | 2015-05-01 | May 2015 |
| ted201401ollp | 2014-01-01 | January 2014 |
| ted201401gatfp | 2014-01-01 | January 2014 |
| ted201401ra | 2014-01-01 | January 2014 |
| ted201301ollp | 2013-01-01 | January 2013 |
| ted201301gatfp | 2013-01-01 | January 2013 |
| ted201301ra | 2013-01-01 | January 2013 |
| ted201201ollp | 2012-01-01 | January 2012 |
| ted201201gatfp | 2012-01-01 | January 2012 |
| ted201201ra | 2012-01-01 | January 2012 |
| ted201101ollp | 2011-01-01 | January 2011 |
| ted201101gatfp | 2011-01-01 | January 2011 |
| ted201101ra | 2011-01-01 | January 2011 |
+----------------+--------------+----------------+
25 rows in set (0.01 sec)
Here is a sample query that uses the shortnames in order to avoid typing the full database URL:
mysql> select metric,year,value from data where
-> database_url in (
-> select url from datasets where shortname = 'ted201705ollp'
-> ) and region = 'Algeria' limit 5;
+--------------------+------+----------------------+
| metric | year | value |
+--------------------+------+----------------------+
| GDP EKS (adjusted) | 1950 | 46727.00000000000000 |
| GDP EKS (adjusted) | 1951 | 47054.00000000000000 |
| GDP EKS (adjusted) | 1952 | 49156.00000000000000 |
| GDP EKS (adjusted) | 1953 | 50231.00000000000000 |
| GDP EKS (adjusted) | 1954 | 53175.00000000000000 |
+--------------------+------+----------------------+
5 rows in set (0.19 sec)
Data description
Data sources
Methods of estimation
Reception
| Person | Affiliation | Qualification | Opinion |
|---|---|---|---|
| Paul Krugman[5] | New York Times | Economist, columnist | Calls it "the easy source for 1950 onwards" for obtaining GDP data, and cites the database several times in blog posts[6] |
Usage in debates
See also
External links
References
Script error: No such module "Check for unknown parameters".