Open main menu

Devec β

Total Economy Database

Revision as of 20:44, 20 October 2017 by Issa Rice (talk | contribs) (Versions)

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]

Contents

Summary

Versions

As of October 2017, there have been nine releases of the Total Economy Database. Each release of the database comes in the form of two or three spreadsheets (and sometimes release notes and supplementary data files). 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/version 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

Devec database

The Total Economy Database has been imported into the devec database.[4]

In the devec database, use name = 'Total Economy Database' to find releases of the Total Economy Database:

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

[5]

Methods of estimation

Reception

Person Affiliation Qualification Opinion
Paul Krugman[6] 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[7]

Usage in debates

See also

External links

References

  1. "About the Total Economy Database". Retrieved October 17, 2017. 
  2. "Total Economy Database Archive". Retrieved October 17, 2017. 
  3. "Total Economy Database Data". Retrieved October 18, 2017. 
  4. "riceissa/total-economy-database". GitHub. Retrieved October 20, 2017. 
  5. "Sources and Methods used to construct the Total Economy Database". Retrieved October 18, 2017. 
  6. Paul Krugman (April 26, 2013). "Debt and Growth Data". Paul Krugman Blog. Retrieved October 20, 2017. 
  7. ""Total Economy Database" site:krugman.blogs.nytimes.com". Google Search. Retrieved October 20, 2017.