{"id":767,"date":"2012-09-20T13:55:39","date_gmt":"2012-09-20T20:55:39","guid":{"rendered":"http:\/\/www.constructonomics.com\/blog\/?p=767"},"modified":"2012-09-20T13:55:39","modified_gmt":"2012-09-20T20:55:39","slug":"construction-stimulus-funds-the-importance-of-data-reporting","status":"publish","type":"post","link":"https:\/\/constructonomics.com\/blog\/2012\/09\/20\/construction-stimulus-funds-the-importance-of-data-reporting\/","title":{"rendered":"Construction Stimulus Funds: The Importance of Data Reporting"},"content":{"rendered":"

In 2012, stimulus funds from the American Recovery and Reinvestment Act (ARRA)<\/a> are coming to a close. Since the construction industry was promised roughly $131 billion<\/a> of those stimulus funds, I thought it\u2019d be a good idea to check up on the effectiveness of the funding. I had a simple question: did construction stimulus funds help create (or retain) jobs?<\/p>\n

Since I\u2019m a Texas resident, and because Texas has a relatively strong construction economy, I decided to focus on jobs created or retained in Texas, specifically. Luckily, a website called Recovery.gov<\/a>–the website devoted to helping the public track the flow of stimulus funds–aggregates a host of information for the public to access and analyze.<\/p>\n

Unfortunately, the way the data is collected and distributed makes it next to impossible for the average person to answer my simple question. I\u2019d like to share a few of the issues that I came across while trying to determine whether construction stimulus funds were a boon to Texas construction employment.<\/p>\n

State-level Data is Not Detailed Enough<\/h2>\n

The first issue that I ran across was that state-level data was not detailed enough to come up with a good answer. For instance, while the total number of jobs created is reported by the fund recipient (either a state, city, agency or company), the type of job is not. So while we may know the number of jobs that were created, we have no idea if they were educations jobs, construction jobs or some other type of jobs.<\/p>\n

As an example, the Texas Department of Transportation reported that they received roughly $2 billion<\/a> in funds and created or retained 33,800 jobs, and surely some of them involved construction projects. However, since there is no coding for the type of job, there\u2019s no way to tell how many of the 33,800 jobs were construction jobs.<\/p>\n

Since state-level data didn\u2019t have the needed information, I decided to access national statistics. Unfortunately, that information proved cumbersome to work with as well.<\/p>\n

National Level Data is Too Difficult to Manipulate<\/h2>\n

After I did a bit more research, I noticed that national data has a North American Industry Classification System (NAICS)<\/a> code\u2013a code used to classify statistical data by industry\u2013attached to each project. Since the construction industry is classified as 23, I could theoretically filter out Texas projects with code 23.<\/p>\n

I tried this, but the spreadsheet of nationwide data is 320 megabytes and contains 587,150 rows of data. Because of this, every attempt to filter out this information crashed my computer. I was left with a set of state-level data that was incomplete and a set of nationwide data that was more complete, but one that I could never filter to produce a reasonable answer to my question.<\/p>\n

A Lesson in Data Reporting<\/h2>\n

The difficulty that I had in finding an answer to this question actually teaches a good lesson: data in and of itself isn\u2019t enough to answer your questions. In order to answer the important questions, it\u2019s necessary to plan ahead for how you\u2019ll classify and report data. Because, after all, data is meaningless if it\u2019s not reported in the right way.<\/p>\n

If Recovery.gov had better planned out what questions they\u2019d like to answer, they likely would have required data to be reported in a more efficient and accessible manner. As a business, it’s important to think ahead and determine how your data will be used, what questions you’ll want answers, and how the data will have to be classified to derive those answers.<\/p>\n

What are your thoughts? What are your best practices for data reporting? Stop by Software Advice<\/a> to leave me your thoughts at: Did Construction Stimulus Funds Create Jobs? Good Question.<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

In 2012, stimulus funds from the American Recovery and Reinvestment Act (ARRA)<\/a> are coming to a close. Since the construction industry was promised roughly $131 billion<\/a> of those stimulus funds, I thought it\u2019d be a good idea to check up on the effectiveness of the funding. I had a simple question: did construction […]<\/p>\n","protected":false},"author":50,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-767","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"https:\/\/constructonomics.com\/blog\/wp-json\/wp\/v2\/posts\/767","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/constructonomics.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/constructonomics.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/constructonomics.com\/blog\/wp-json\/wp\/v2\/users\/50"}],"replies":[{"embeddable":true,"href":"https:\/\/constructonomics.com\/blog\/wp-json\/wp\/v2\/comments?post=767"}],"version-history":[{"count":6,"href":"https:\/\/constructonomics.com\/blog\/wp-json\/wp\/v2\/posts\/767\/revisions"}],"predecessor-version":[{"id":773,"href":"https:\/\/constructonomics.com\/blog\/wp-json\/wp\/v2\/posts\/767\/revisions\/773"}],"wp:attachment":[{"href":"https:\/\/constructonomics.com\/blog\/wp-json\/wp\/v2\/media?parent=767"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/constructonomics.com\/blog\/wp-json\/wp\/v2\/categories?post=767"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/constructonomics.com\/blog\/wp-json\/wp\/v2\/tags?post=767"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}