What problem is your project aimed at solving? Alternatively, why would someone want to use what you are making in your project?
The first immediate goal of the American Recovery and Reinvestment Act of 2009 is to “create new jobs as well as save existing ones.”
While Emily’s initial project idea was to compare jobs created and saved vs. unemployment, some initial research proved that the exact number of jobs created per grant or contract is difficult to determine with the level of regularity and reliability needed for creating a machine-readable, automated data mashup. A good example is the problem of bulk grants. The Regents of the University of California have been earmarked to receive a grant of $716 million dollars
which will save some 38,923.98 jobs, but the distribution of those jobs within the state of California is not clearly delineated, and furthermore, the number of jobs is a combination of full-time employees, part-time employees, sub-contractors, and vendor hours, again unspecified by county placement.
Due to these problems–the lack of consistency and specificity needed to achieve this initial project goal, we will be focusing on a slightly different question within the manageable scope of Alameda County, California: How has the ARRA affected (or not affected) unemployment in Alameda County, California? If the ARRA has been “effective,” we would hope to see the level of employment decreasing or remaining steady over time as funds are dispersed. Of course it is difficult if not impossible to make any causal conclusions by comparing this data as opposed to examining job-for-job data (and taking into account other indices of the recovering economy), which I have already mentioned is an intractable problem until more granular data can be reliable extracted.
Is your project doable given the constraints of time, our starting knowledge, etc?
Yes, we think so. We’ve narrowed the geographic scope from the entire U.S. to Alameda County and will only be needing two sources of data:
- Month-by-month unemployment data in Alameda County from January 2009 to the present
- The start date of all ARRA grants/contracts dispersed in Alameda County to date
The visualization portion will be tricky, but I am confident that we have the resourcefulness necessary to complete this part of the project.
What interface are you imagining? Is it a web, desktop, or mobile application? What platform are you running?
We want to build a web visualization which can be viewed with the Firefox web browser.
What data or services are planning to bring together?
- Unemployment data from the Bureau of Labor Statistics (http://www.bls.gov/lau/#tables)
- ARRA Project award start dates and amounts from http://www.recovery.ca.gov/HTML/RecoveryImpact/map.shtml?county=Alameda
- ClearMaps or Tableau or Google Visualization API
What’s your plan for getting the data? Often the data you might want might not be easily available.
Downloading the latest unemployment and ARRA files available and filtering for Alameda county.
Do the APIs you plan to use actually support the functionality that you need in your application?
No, we are not using any APIs, except for maybe the Google Visualization API, but that is not a data source.
What programming language do you plan to use?
Either Python or PHP, depending upon which one is easier to use with the data.
- Download and examine unemployment and ARRA data files.
- Filter the files by Alameda County.
- Find zip codes for Alameda County and extract relevant ARRA data from master file.
- Investigate best mapping/visualization tool, hopefully one which will allow us to make monthly step-wise comparisons in unemployment, new project contract start dates, and the percentage of ARRA money spent out of the total currently slated for Alameda County.
- Integrate the data sets with the visualization utility.
Risk Areas/Mitigation Plan:
Right now our biggest risk is scrubbing the ARRA data. We imagine that not every award will have listed its zip code, zip codes may span more than just Alameda County, or that field may be blank.
Our best mitigation plan might actually be to expand the scope of the project to include all of California, since the award’s state is a more reliable data point.