/total-economy-database

No description, website, or topics provided.
  1. Python 99.6%
  2. Makefile 0.4%
Switch branches/tags
Nothing to show
Find file
Clone or download

Clone with HTTPS

Use Git or checkout with SVN using the web URL.

Download ZIP

Launching GitHub Desktop...

If nothing happens, download GitHub Desktop and try again.

Launching GitHub Desktop...

If nothing happens, download GitHub Desktop and try again.

Launching Xcode...

If nothing happens, download Xcode and try again.

Launching Visual Studio...

If nothing happens, download the GitHub extension for Visual Studio and try again.

Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Type Name Latest commit message Commit time
Failed to load latest commit information.
.gitignore
Makefile
README.md
check.py
print_footer.py
print_header.py
proc_Growth_Accounting_and_Total_Factor_Productivity_1990_2009.py
proc_Growth_Accounting_and_Total_Factor_Productivity_1990_20111.py
proc_Growth_Accounting_and_Total_Factor_Productivity_1990_20121.py
proc_Growth_Accounting_and_Total_Factor_Productivity_1990_2013.py
proc_Output_Labor_and_Labor_Productivity_1950_2010.py
proc_Output_Labor_and_Labor_Productivity_1950_20111.py
proc_Output_Labor_and_Labor_Productivity_1950_2012.py
proc_Output_Labor_and_Labor_Productivity_1950_2013.py
proc_Regional_Aggregates_1990_2011.py
proc_Regional_Aggregates_1990_2012.py
proc_Regional_Aggregates_1990_2013.py
proc_Regional_Aggregates_1990_2014.py
proc_TED_1_MAY20171_adjusted.py
proc_TED_1_MAY20171_original.py
proc_TED_1_NOV20161_adjusted.py
proc_TED_1_NOV20161_original.py
proc_TED_2_MAY20171_adjusted.py
proc_TED_2_MAY20171_original.py
proc_TED_2_NOV20161_adjusted.py
proc_TED_2_NOV20161_original.py
proc_TED_GrowthAccountingTotalFactorProductivity1990_2014.py
proc_TED_Growth_Accounting_and_Total_Factor_Productivity_1990_2014.py
proc_TED_OutputLaborLabor_Productivity1950_2015.py
proc_TED_Output_Labor_and_Labor_Productivity_1950_2015.py
proc_TED_Output_Labor_and_Labor_Productivity_1950_2016.py
proc_TED_REGIONS_MAY20171_adjusted.py
proc_TED_REGIONS_MAY20171_original.py
proc_TED_REGIONS_NOV20161_adjusted.py
proc_TED_REGIONS_NOV20161_original.py
proc_TED_Regional_Aggregates_1990_2015.py
proc_TED_Regional_Aggregates_1990_2016.py
urls

README.md

total-economy-database

To produce the SQL file (ted.sql), do:

make clean  # remove file from old run in case it exists
make

To generate the SQL files, the scripts in this repository require the devec_sql_common Python package. To install, run:

git clone https://github.com/riceissa/devec_sql_common
cd devec_sql_common
pip3 install -e .

License

CC0.

The data is apparently copyrighted and there's a scary disclaimer so I won't add it to this repo. Steps to reproduce the CSVs:

  1. Get the data from the Data page or the Archive page
  2. Open the spreadsheet in LibreOffice.
  3. Navigate to the relevant sheet.
  4. Do "File" → "Save As…" and save as a CSV.
  5. Remove the top few lines from the CSV (which just describe the dataset) and sometimes also the bottom few lines (which contain citation information) so that the line containing the column names is on top.