Total Economy Database
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
Glossary
Various acronyms and terms are used in the Total Economy Database documentation. Since there seems to be no unified place for these on the Conference Board website, we collect them here.
| Term | Expansion | Meaning | Examples |
|---|---|---|---|
| EKS | |||
| ICT | |||
| Original | |||
| Adjusted | |||
| gr | Growth |
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, available through the "Data" page, or available on the Internet Archive:[2][3][4]
| Spreadsheet | Publication date/version | Years covered |
|---|---|---|
| Output, Labor, and Labor Productivity Country Details | January 2010 | 1950–2009 |
| Growth Accounting and Total Factor Productivity Country Details | January 2010 | 1980–2008 |
| Regional Aggregates | January 2010 | 1990–2010 |
| 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 |
The Conference Board claims the Total Economy Database began in the early 1990s and ownership transferred to the Conference Board in 2007,[5] so there are likely older spreadsheets that are no longer available online.
Devec database
All versions of the Total Economy Database available on the Conference Board website as of October 2017 have been imported into the devec database.[6]
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 dimensions and metrics
The data presented in the Total Economy Database are a partial function where:
- The inputs (the dimensions) are region (country or aggregate region) and year.
- The metrics include:
- Population
- GDP
- GDP per capita
- Total annual hours worked
Year dimension
Each spreadsheet has a year range that it covers. The start year is 1950, 1980, or 1990 in most cases, and the end year is the publication year or 1–2 years prior to publication. Even if a year is covered in the spreadsheet, some values may be missing depending on the region and metric.
Region dimension
The region dimension includes most modern countries. For China, there are "official" and "alternative" versions.
Other information
Data sources
Methods of estimation
People
The Total Economy Database section of the Conference Board website does not list the names of the people who work on the database, nor does it make any acknowledgments other than for the data sources it uses.
Perhaps the authors of [8] have something to do with TED.
From the biography for Klaas de Vries: "De Vries is part of the productivity and growth research team and manages various database revisions and updates, such as the annual update of the Total Economy Database™, which covers indicators that measure the current and historical performance of labor and capital productivity for over 120 countries."[9]
Abdul A. Erumban is listed as a contact on the TED part of the Conference Board website.
The "Global Economy" experts listed on the Conference Board website are also possible.[10] Bart van Ark in particular has ties to the University of Groningen.
A press release lists Bart van Ark as a contact.[11]
Wikipedia lists 250 employees for the Conference Board (but does not give a citation), which might be useful in determining an upper bound of the person-hours spent preparing the database per year.
Reception
| Person | Affiliation | Qualification | Opinion |
|---|---|---|---|
| Paul Krugman[12] | 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[13] |
| Martin Wolf[14] | Financial Times | Economics commentator[15] | Calls the database "invaluable". |
| Max Roser[16] | Our World in Data | Economist | Lists the database as one of the data sources for GDP. |
Usage in debates
See also
External links
References
- ↑ "About the Total Economy Database". Retrieved October 17, 2017.
- ↑ "Total Economy Database Archive". Retrieved October 17, 2017.
- ↑ "Total Economy Database Data". Retrieved October 18, 2017.
- ↑ "The Conference Board Total Economy Database". The Conference Board. Archived from the original on July 8, 2010.
- ↑ "About the Total Economy Database". Retrieved October 21, 2017.
TED was developed by the Groningen Growth and Development Centre (University of Groningen, The Netherlands) in the early 1990s, and starting in the late 1990s, it was produced in partnership with The Conference Board. As of 2007, the database was transferred from the University of Groningen to The Conference Board, which has maintained and extended the database since then.
- ↑ "riceissa/total-economy-database". GitHub. Retrieved October 20, 2017.
- ↑ "Sources and Methods used to construct the Total Economy Database". Retrieved October 18, 2017.
- ↑ Chen, Vivian; Gupta, Abhay; Therrien, Andre; Levanon, Gad; van Ark, Bart. "Recent Productivity Developments in the World Economy: An Overview from The Conference Board Total Economy Database" (PDF). Retrieved October 21, 2017.
- ↑ "Klaas de Vries". Retrieved October 21, 2017.
- ↑ "Our Experts: Bringing your issues into focus". Retrieved October 21, 2017.
- ↑ "Global Productivity: Decade-Long Decline Comes to a Halt". May 17, 2017. Retrieved October 21, 2017.
- ↑ Paul Krugman (April 26, 2013). "Debt and Growth Data". Paul Krugman Blog. Retrieved October 20, 2017.
- ↑ ""Total Economy Database" site:krugman.blogs.nytimes.com". Google Search. Retrieved October 20, 2017.
- ↑ Martin Wolf (September 29, 2016). "Economic ills of the UK extend well beyond Brexit". Financial Times. Retrieved October 21, 2017.
- ↑ "Martin Wolf". Financial Times. Retrieved October 21, 2017.
- ↑ "Economic Growth § Data Sources". Our World in Data. 2017. Retrieved October 21, 2017.
