Explore a specific Census dataset on business and job dynamics
Opened this issue · 4 comments
The Dataset:
Business Dynamics Statistics (BDS) is a dataset from the US Census Bureau that measures business openings/closings and job gains/losses by firm size, age, and industrial sector, and several other variables. These data provide insight into the constant churn of the economy in terms of business growth and decline.
http://www.census.gov/ces/dataproducts/bds/
How to Get the Data
- Download the files in Excel, CSV (comma separated values) or SAS format.
- OR access the dataset via API from the US Census Bureau
The Challenge
- Learn about the dataset
- Explore the data for the San Jose Metropolitan Area
- Create a visualization that tells an interesting story about our local economy
Tips and Suggestions
- Visualization Examples and Tools provided by the US Census Bureau
- US Census Developers page.
- Ask Michelle Thong (mthong@gmail.com) if you have general questions about economic data and terminology (industry classifications, etc).
Job creations by States
Compare number of job creation data of three states to national wide: CA, NY, and WA. For most of the years, change in job creation of each states are conform with national change. Yet, it's interesting that in 2013, CA had a growth in job creation while it was declining national wide.
Companies established less than 1 year
I use the number of companies established less than 1 year to observe the growth trend of startup companies. There is a sharp growth of new companies ever since 2010
I believe this is the code for the San Jose Metropolitan Statistical Area (MSA): 41940
See the full list here:http://www2.census.gov/econ/susb/data/msa_codes_2007_to_2011.txt
(And here is background info on what an MSA is: https://en.wikipedia.org/wiki/Metropolitan_statistical_area)
Bureau of Labor Statistics for San Jose - Sunnyvale - Santa Clara
http://www.bls.gov/eag/eag.ca_sanjose_msa.htm
Santa Clara County Real Estate Indicators
http://journal.firsttuesday.us/santa-clara-county-regional-housing-indicators/37473/
Venture Capital Investment
http://nvca.org/pressreleases/u-s-venture-capital-investment-spanned-133-msas-in-2015/
Cost of Living - Forbes (data source - Data is for the metro area
Sources: Moody's Analytics; Sperling's BestPlaces; U.S. Census.
Numbers as of July 2015)
http://www.forbes.com/places/ca/san-jose/
I used https://data.sanjoseca.gov//home and provided the following analysis on job dynamics (unemployment and labor force changes) with housing prices:
https://github.com/aakashhdesai/sj-data-analysis
@mthong - any questions you'd like to have answered? Happy to investigate and do the due diligence.