On Thursday Recovery.gov released its first hard data on stimulus jobs.  They provided an interactive map of the U.S. 

Hover over the map to see 209 jobs were created in Kansas:

 Click on Kansas on the map to see more detail.  Below is the resulting map showing the locations of recovery jobs in Kansas:

Recovery Information for Kansas from Recovery.Gov, 10/14/2009 - 
 

The legend on Recovery.gov map above shows 215  jobs were created in Kansas. The reason for that number not matching the earlier 209 figure is not known.

Yesterday ProPublica published an article, We Made Recovery.gov’s New Stimulus Data Easier to Download.  ProPublica downloaded 183 separate files from recovery.gov, cleaned them up a bit, and made them available for analysis.  After studying the Recovery.gov data, I was convinced the ProPublica data was far easier to use. 

I downloaded both the Contractor and Subcontractor Excel files and loaded the data into a database for manipulation.  I extracted the data for Kansas using four database queries.

The first set of data I extracted was the set of prime contractors doing work in Kansas.  Click below on the “Full Screen” button to view this table:

Eye on the Stimulus: Prime Contractors With Work in Kansas - 
 
Summary information at the bottom of this table almost matched the original data for Kansas given at the beginning of this article: 

• 209.46 jobs
• $20,752,682 in total federal ARRA funds

The majority of the jobs, 169, were for the U.S. Army or the U.S. Army Corps of Engineers in Manhattan, Ft. Leavenworth, Overland Park, and Wichita.

Some prime contractors in Kansas received contracts for work in other states:

• BABCOCK CONSTRUCTION COMPANY, LLC, 1 contract, 5 new jobs in Georgia
• BLACK & VEATCH SPECIAL PROJECTS CORP, 3 contracts, 2.47 new jobs in Georgia
• CROSSLAND CONSTRUCTION COMPANY, INC., 1 contract, 0 new jobs in Missouri
• ENVIRONMENTAL MANAGEMENT RESOURCES, INC., 3 contracts, 0 new jobs in New York and Florida
• RESOURCE MANAGEMENT GROUP INC, 1 contract, 0 new jobs in Alabama
• TERRACON CONSULTANTS, INC., 4 contracts, 18.16 jobs in Colorado, Florida, and Wisconsin
• WESTERN AIR MAPS, INC., 5 contracts, 0 new jobs in Illinois, Missouri and Maryland

These subcontractors received work in Kansas, but it’s not immediately clear from the data how many jobs were involved in their work in Kansas:

• A & H Electric, Inc.
• American Boiler Services, Inc.
• Applied Ecological Services Inc
• Arrowhead Contracting, Inc
• Atlas Electric, LLC
• Bayer Construction Company, Inc.
• Blueville Nursery, Inc.
• Chief Heating & Cooling, Inc.
• Coffman Construction (2 contracts)
• Construction Management Resources LLC (2)
• Control Service Co., Inc.
• Corporate Lodging Consultants, Inc. (2)
• D Hoover Construction Co Inc
• Esi Contracting, Corp.
• Harvest Productions South, Inc.
• Hws Consulting Group Inc.
• Infinite Energy Construction, Inc
• Insco Industries, Inc.
• International Electric, Inc
• J&S Construction
• Lafarge North America, Inc
• Lamberti Usa, Incorporated
• Mechanical Systems, Inc.
• Mid-American Water & Plumbing, Inc.
• Preferred Lightning Protection
• Randall White Consulting
• Rti Consultants Inc
• Sellers & Marquis Roofing Company
• Smith & Boucher Inc (2)
• Thomas Industrial Coatings, Inc.
• Western Fireproofing Company of Kansas, Inc.

Some Kansas subcontractors received work in other states, including

• Apex Government Solutions L.L.C.
• Layne Christensen Company
• Terracon Consultants, Inc. (7 contracts)
• The Judy Company Inc

All statistics above were for 3rd quarter 2009 work.  Much of the work has not yet begun so stats next quarter may look better.