armollica / qcew-data Public

Download QCEW data and import it into a database

Name		Name	Last commit message	Last commit date
Latest commit History 7 Commits
data		data
.gitignore		.gitignore
Pipfile		Pipfile
README.md		README.md
agglevel_titles.csv		agglevel_titles.csv
area_titles.csv		area_titles.csv
import-data.py		import-data.py
import-lookups.sh		import-lookups.sh
industry_titles.csv		industry_titles.csv
ownership_titles.csv		ownership_titles.csv
query.sh		query.sh
size_titles.csv		size_titles.csv

Repository files navigation

QCEW Data Loader

Imports the entire Bureau of Labor Statistics Quarterly Census of Employement (1990 - current) and Wages into a Postgres database.

The database created by this process will be about 80GB. Make sure you have enough space before you start!

./download_data.sh
createdb qcew
./import_data.sh
./import_lookups.sh