Explore a specific Census dataset on business and job dynamics

codeforsanjose / Project-Ideas

Hey have an idea for a Project? Post it here! See the Waffle version here:

https://waffle.io/codeforsanjose/Project-Ideas

31 stars 7 forks source link

Explore a specific Census dataset on business and job dynamics #56

Open mthong opened 8 years ago

mthong commented 8 years ago

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).

arichen commented 8 years ago

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

mthong commented 8 years ago

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)

golgistudio commented 8 years ago

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/

ghost commented 6 years ago

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.