Streams

Group Project: Help Test Gov't Transparency

Tuesday, February 09, 2010 - 05:38 PM

from neilsphotoalbum on Flickr

from neilsphotoalbum on Flickr

Help us test the government's new transparency initiatives. How easy is the system? How useful is the information?


The Obama administration requested that government agencies post data online in an easily searchable format by last Saturday, February 6th. In order to test the effectiveness and accessibility of this 'data dump,' we want you to help search through the USA Spending Contracts Database, which contains data on all government contracts from the last 10 years. Follow the instructions below and report on your user experience.

Step 1: Go to the USA Spending Contract Database: Click Here

Step 2: Enter your home zipcode into the 'Place Zipcode' field about 1/3 of the way down the page. (eg if you are from Del Mar, Ca enter '92014'; if you from Nelson County, VA enter '22938')

Step 3: Press the 'Submit Query' button at the bottom of the page.

Step 4: Now, report your results! In the comments section below, tell us what you find.


+ How was your experience? Was the tool easy to use? Does this feel like a step forward for transparency?


Also cut and paste:
+ Zipcode you searched
+ Total dollars awarded (result is on the top left of page)
+ Total number of contractors (just below top dollars)
+ Total number of transactions (just below top contractors)
+ Top Three Contracting Agencies (these are the top government agencies that awarded contracts to the area; find this number on the right column of the page)
+ Top Three Contractors (these are the top private agencies that were awarded contracts; find this number on the right column of the page)


Feel free to post anything else of interest you discovered! Any surprises in the numbers? Any advice to make these tools easier to use? Post your report below!

Tags:

More in:

Comments [63]

BushwickBK.com » Tracing Federal Dollars in

[...] so far, the state and local data sets on the data.gov aggregator are few. Taking the cue of WNYC’s Brian Lehrer, we entered the four zip codes that make up Bushwick [...]

Mar. 01 2010 03:29 PM
Ardyth Eisenberg

This is in addition to my Feb. 11 comment: I get very different results when I search by Congressional district and by zip code. In the 7th District, IL, we have:
Total dollars: $6,834,654,470
Total number of contractors: 5,201
Total number of transactions: 80,159

In zip code 60305 (which is in the 7th Dist.), we have:
Total dollars: $742,219
Total number of contractors: 3
Total number of transactions: 5

I can guess the reason for this, but users should be made aware that differences exist for various search terms.

Feb. 15 2010 12:34 PM
Rob W.

The tool was easy to use, but a little more information would be helpful.

I was surprised that a private software company (Mathworks) and a natural gas provider (Nstar) got much more contract funding than two defense contractors in my top 10 list. My town has been in a little spat with Mathworks over employee parking and traffic concerns and it's interesting to see how important this company is. I'd hate for us to drive them out of town. The natural gas company is baffling to me.

Zipcode: 01760, Natick, MA

Total dollars awarded: $240,549,614

Total number of contractors: 491

Total number of transactions: 4,777

Top three contracting agencies:
ARMY, Department of the (except Corps of Engineers Civil Program Financing): $129,454,986
Federal Technology Service: $28,562,450
AIR FORCE, Department of the (Headquarters, USAF): $22,448,398

Top three contractors:
The Mathworks Inc. $30,988,413
Saic, Inc. $19,407,142
Nstar: $16,942,289

Feb. 12 2010 01:21 PM
Ardyth Eisenberg

+ How was your experience? Was the tool easy to use? Does this feel like a step forward for transparency? It was the easiest govt-based research I've ever done. But I couldn't determine what the grants/contracts were awarded for.

Also cut and paste:
+ Zipcode you searched - 60305
+ Total dollars awarded (result is on the top left of page)$742,219
+ Total number of contractors (just below top dollars) - 3
+ Total number of transactions (just below top contractors)- 5
+ Top Three Contracting Agencies (these are the top government agencies that awarded contracts to the area; find this number on the right column of the page) - Army and Nasa
+ Top Three Contractors (these are the top private agencies that were awarded contracts; find this number on the right column of the page)
Lund & Company Invention LLC $728,244
Dan Waterloo $10,225
Dominican University $3,750

Feel free to post anything else of interest you discovered! Any surprises in the numbers? Any advice to make these tools easier to use? Post your report below!
In a perfect world, we should be able to click on the contractors' names and get more information about them.

Feb. 11 2010 03:32 PM
Craig Newmark: You can help with gov’t accou

[...] what’s been spent at your zipcode. Brian Lehrer at WNYC, a really good public radio station, is getting a few people to participate, and to see what the results are. Help us test the government’s new transparency initiatives. [...]

Feb. 11 2010 01:16 PM
A.J.

Zip Code 10552
Total dollars: $80,213
Total number of contractors: 3
Total number of transactions: 9

Top 5 Contracting Agencies Purchasing from Contractor(s)
AIR FORCE, Department of the (Headquarters, USAF) $48,000
VETERANS AFFAIRS, Department of $25,259
Bureau of Prisoners/Federal Prison System $6,954
NAVY, Department of the $0

Top 10 Contractors
Real Time Systems Inc $48,000
Wartburg Home of The Evangelical Lutheran Church $24,667
The Reliable Automatic Sprinkler Co Inc $7,546

Top 5 Products or Services Sold
ADP Input/Output and Storage Devices $48,000
Nursing Home Care Contracts $24,667
Plumbing Fixtures and Accessories $6,954
Miscellaneous Construction Materials $592
Electrical and Electronic Properties Measuring and Testing Instruments $0

Feb. 10 2010 11:28 PM
Alex

I find the tool interesting as a baseline. Its hard to connect the basic quantitative data with what the actual projects actually funded. I wouldn't say it is extremely transparent in any way, but it is an ok start. I'm sure if you delve further into any of the districts, it can lead to a lot of interesting stories.

Feb. 10 2010 10:58 PM
Craig Newmark

zip: 94117
Total dollars: $1,363,741
Total number of contractors: 27
Total number of transactions: 112

Agencies:
Defense Logistics Agency $735,616
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $408,841
Public Buildings Service $62,325

contractors:
Berkeley Exotech, Inc. $372,279
Califashions $273,569
Washington Vegetable Company $186,676

Feb. 10 2010 09:48 PM
Joanne

Zip code: 07005 Boonton, NJ
Total dollars: $27,090,880
Total number of contractors: 42
Total number of transactions: 642

Top3 Products/Services Sold
Chemicals $20,284,903
Office Furniture $2,577,086
Engine Instruments $963,605

Top 3 Contracting Agencies:
NAVY, Department of the $18,968,063
Defense Logistics Agency $1,913,290
Maritime Administration $1,541,138

Top 3 Contractors:
Ashland Inc. $20,431,519
Daco Limited Partnership $2,707,433
Instrument Specialties Company $1,115,365

Interesting for what seems to be a sleepy little town.

Feb. 10 2010 04:42 PM
Sam Clayton

zip: 10012

Total dollars: $22,106,530
Total number of contractors: 28
Total number of transactions: 513

Top 5 Products or Services Sold
Books and Pamphlets $8,291,714
Other Defense -- Applied Research and Exploratory Development (R&D) $2,993,302
Biomedical -- Basic Research (R&D) $2,497,433
Other Management Support Services $1,498,534
Tuition, Registration, and Membership Fees $1,002,753

Top 5 Contracting Agencies Purchasing from Contractor(s)
Department of Defense Education Activity $7,001,679
National Institutes of Health $4,037,547
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $3,195,253
AIR FORCE, Department of the (Headquarters, USAF) $2,570,163
NAVY, Department of the $2,026,597

Top 10 Contractors
Scholastic Corporation $12,798,113
Reservoir Labs Inc $6,262,598
New York University (inc) $1,341,615
Howcast Media Inc $449,500
Thinkmap, Inc $382,545
Stephen Figlewski, Inc $224,110
C E Goshow-I LLC $119,934
Andrew Davidson & Co., Inc. $78,000
Alpert Newspaper Delivery Service Inc $71,655
Honeybee Robotics Ltd $69,764

Feb. 10 2010 04:39 PM
neille

In my neighborhood, 90291, Venice, CA., apparently over $300K has been spent on guns!

Top 5 Products or Services Sold
Aeronautics and Space Technology -- Basic Research (R&D) $675,553
Services -- Applied Research and Exploratory Development (R&D) $364,740
Guns, through 30 mm $321,345
Other Professional Services $149,340
Ophthalmology Services $143,940

Feb. 10 2010 02:27 PM
Margaret

Easy to use
Zip code used - 08876 (central Jersey)
Total dollars: $14,666,266
Total number of contractors: 65
Total number of transactions: 2,131
Top 3 contracting agencies:
Defense Logistics Agency $3,527,725
AIR FORCE, Department of the (Headquarters, USAF) $2,089,459
Federal Supply Service $2,048,642
Top 3 contractors:
Robert Mc Keown Co Inc $2,816,578
Taylor Oil Co. Inc. $2,620,699
Linde AG $1,624,827

Fuels and lubricants to the Dept of Justice? It seems to raise more questions as to where our money is going! I like that I can look up a company and see what it gets from our tax dollars.

Feb. 10 2010 01:56 PM
Cyn

Total dollars: $19,433
Total number of contractors: 3
Total number of transactions: 5

Top 5 Products or Services Sold
Other Architect and Engineering Services $18,858
Real Property Appraisals Services (SIC 6531) $575

Top 5 Contracting Agencies Purchasing from Contractor(s)
Natural Resources Conservation Service $18,858
Rural Housing Service $575

Top 10 Contractors
Hawk Land Surveying PC $18,858
Egan Appraisals Inc $300
Comparables Are US Inc $275

Top 5 Known Congressional Districts where Work is Performed
Known congressional district
New York 21 (Michael R. McNulty / Paul D. Tonko) $19,433

$18,858 was attributed to 2004!

Feb. 10 2010 01:45 PM
Fletcher

+ Zip: 14456 Geneva NY - N end of Seneca Lake in Finger Lakes
+ Total $: 4,058,313 - wow!
+ # contractors: 22
+ # transactions: 114
+ Top 3 Contracting Agencies: Agricultural Research Service $1.9M, Agricultural Marketing Service $981K, Public Buildings Service $926K
+ Top 3 Contractors: Ewingcole Inc $1.5M, Seneca Foods Corporation $981K, Massa Family LLC $671K

I found the site easy to use & enjoyable, and it does seem like step forward for transparency.

A wiki/mashup layer would be really great - links to greater category detail, contractor/agency info, etc; and network data, linking corporations, director board members, congress reps etc. I say "wiki" because this data enrichment is labor-intensive and might best be handled via crowdsourcing; and and "layer" because it would be desirable to keep the site in its original form, but add an invokable layer of links and additional data that would "lie on top of" the site. This sort of layer doesn't exist yet, to my knowledge, but might developed in the future. Speaking of links, see www.fedspending.org (OMB Watch).

Feb. 10 2010 01:39 PM
janemercaldi

wish I could click on the contractors to find out more about them.

10606 (white Plains,ny)
Total dollars: $4,779,373
Total number of contractors: 7
Total number of transactions: 378

Top 5 Products or Services Sold
Other ADP and Telecommunications Services (includes data storage on tapes, compact disks, etc.) $2,930,000
Books and Pamphlets $1,669,422
Other Professional Services $98,000
Aircraft Maintenance and Repair Shop Specialized Equipment $16,933
Aircraft Ground Servicing Equipment $11,700

Top 5 Contracting Agencies Purchasing from Contractor(s)
Office of the Comptroller of the Currency $2,930,000
Department of Defense Education Activity $1,677,422
Federal Aviation Administration $90,000
NAVY, Department of the $39,754
STATE, Department of $17,650

Top 10 Contractors
Argus Information and Advisory Services, LLC $2,930,000
Pearson PLC $1,677,422
Marsh & McLlennan Companies, Inc. $98,000
Easton Machine Corp $46,395
S & H Uniform Corp. $22,417
City of White Plains $5,000
Officescapes LLC $140

Feb. 10 2010 01:08 PM
julia

Easy tool to use, and I suppose it is a step toward transparency, but it raised more questions than it answered. The lion’s share of the total went to purchase ADP Central Processing Unit (CPU, Computer), Hybrid.

Zip code: 10516
Total dollars awarded $2,011,703
Total number of contractors 7
Total number of transactions 39
Top Three Contracting Agencies NAVY, Department of the $1,955,007
United States Mint $51,870
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $4,550
Top Three Contractors C-Systems Corporation $1,659,825
Syslink Consulting LLC $291,472
George G Polich $51,870

Feb. 10 2010 01:04 PM
MsLadyLib

Zipcode 08840 (suburban Metuchen, NJ -- a small town)
Total dollars: $26,782,622
Total number of contractors: 20
Total number of transactions: 235

ARMY, Department of the (except Corps of Engineers Civil Program Financing) $24,038,084
NAVY, Department of the $1,931,491
U.S. Special Operations Command $281,924

Say what? Military expenditures? Not a uniform in sight!

Ace Electronics Inc. $23,869,513
Hdr, Inc. $1,027,800
Berkeley Varitronics Systems Inc $849,496

Also, over $25 million were fixed-price bids. My question is, who sets the prices?

The site was easy to use, lots of ways to slice and dice the data, too. I tried various permutations, which is how I found the YMCA getting money in 2009. Yes, this is a real step forward in transparency --- now I have to speak to my Congressional Rep. and find out why the military gets so much spent here!

One little bit of money spent at the local YMCA, about 7 grand, by the EPA.

Gives one pause. What is important here?

Feb. 10 2010 12:54 PM
Mike F

I decided to compare my home zip from Staten Island (10303), a somewhat poor but nice and diverse suburban area with a large amount of city bus/ferry commuters, to a zip in Westchester (10591, Tarrytown) which is also, I assume, prosperous mainly because of its easy access to Manhattan via Metro North, nice houses and, uh, homogeneous population.

I don't completely understand the breakdowns, but the sheer contrast in total numbers is telling-

10303, Staten Island:
Total dollars: $1,709,050
Total number of contractors: 7
Total number of transactions: 37
Almost all of that seems to be for Navy contracts, which I never even knew about growing up there.

10591, Tarrytown, Westchester, NY
Total dollars: $71,127,107
Total number of contractors: 25
Total number of transactions: 374
And $56 MILLION of that is for "Bakery and Cereal Products"?!?!

"The forgotten borough" indeed.

Feb. 10 2010 12:54 PM
Matt

Zip code: 10004 (TIP OF MANHATTAN, NYC)

Total dollars: $101,648,630
Total number of contractors: 373
Total number of transactions: 1,991

TOP 3 AGENCIES:
National Park Service $33,095,889
Public Buildings Service $31,035,076
Smithsonian Institution, except units under separate Board of Trustees $9,848,489

TOP 5 AGENCIES:
Phoenix Marine Co. Inc. $7,674,649
Tri-S Security Corporation $7,039,060
Broad Financial Center LLC $6,931,019
Consolidated Edison, Inc. $6,694,689
Urban Engineers, Inc. $6,000,000

Feb. 10 2010 12:42 PM
Ann

David, you can actually search on Blackwater [Security] and get data on how much the contracts were in which years, extent of bidding ("not competed for allowable reason"), product or service ("other professional services) congressional districts where work is performed ("unknown districts, probably outside US"). Would be funny if it weren't so scary. At least they didn't get any Recovery money!

Feb. 10 2010 12:40 PM
Taylor

10522 (Dobbs Ferry, NY)
Total dollars: $2,119,675
Total number of contractors: 11
Total number of transactions: 140

+ How was your experience?
Easy and interestgng
Was the tool easy to use? Super easy
Does this feel like a step forward for transparency? More than I knew befopre! Yes a good source of info

+ Top Three Contracting Agencies (these are the top government agencies that awarded contracts to the area; find this number on the right column of the page)
NAVY, Department of the $619,296
ARMY, Department of the $521,839
AIR FORCE, Department of the $243,120

+ Top Three Contractors
Books & Research, Inc. $1,807,877
Ariel Aviation, Inc $176,900
Archive Power Systems Inc $38,670

Given one contractor made up most of the contracts, it is clear that (Books & Research, Inc. $1,807,877) is doing a lot of military work. Now I wonder about them and will look.

Feb. 10 2010 12:39 PM
Dave Rittinger

11218
#1. Brooms, Brushes, Mops, and Sponges $4,003,278.

Feb. 10 2010 12:39 PM
Matt

Zip code: 10005 (WALL STREET, NYC)
Total dollars: $32,730,218
Total number of contractors: 96
Total number of transactions: 369

TOP 3 AGENCIES:
Commodity Futures Trading Commission $13,874,266
Public Buildings Service $9,741,292
National Park Service $2,708,123

TOP 6 CONTRACTORS (Over $1 Million):
Brown Brothers Harriman & Co. $13,025,134
Old Slip Property $7,431,248
Dah Consulting Inc. $2,049,197
Degw North America Limited, LLC $1,849,102
Lumus Construction, Inc. $1,595,000
Whitestone Capital Group Inc $1,502,820

Feb. 10 2010 12:39 PM
Erica

Googled Volmar, the top contracting agency in 11201. Here's the results
Volmar's major client agencies
Department of the Army
Department of the Navy
Department of the Air Force
United States General Services Administration
US Army Corps of Engineers
United States Coast Guard
United States Postal Service
Dormitory Authority of the State of New York
New York State Office of General Services
New York City School Construction Authority
New York City Department of Education
New York City Department of Design and Construction
New York City Department of Environmental Protection

Feb. 10 2010 12:37 PM
Dennis Maher

Easy to use; not much spent here and I want to ask at the town hall what it was about:
Lake Luzerne NY 12846
Total dollars: $5,822
Total number of contractors: 6
Total number of transactions: 12
Top 5 Contracting Agencies Purchasing from Contractor(s)
Rural Housing Service $5,822
Top 10 Contractors
Gore Electrical Services $2,674
Egan Appraisals Inc $1,300
Comparables Are US Inc $975
Marvin & Company $525
Louisiana Press Association Inc $297
Let's Get Creative Lawn and Landscape $50

Feb. 10 2010 12:34 PM
Erica

Zip code: 11201
Total dollars: $461,142,581
Total number of contractors: 209
Total number of transactions: 2,080
Top 3 Contracting agencies:
Public Buildings Service$364,041,910 ARMY, Department of the (except Corps of Engineers Civil Program Financing)$57,753,297
Defense Logistics Agency$11,582,007
Top 3 Contractors:
Volmar Construction Inc.$122,319,550  The Pike Company Inc $56,422,234  Nicholson & Galloway, Inc $53,120,000

Sizable dollars! Who new.
Site was very easy to use

Feb. 10 2010 12:27 PM
Alison

For Brooklyn 11238:
Total dollars: $1,342,740
Total number of contractors: 9
Total number of transactions: 33
Top 3 Contracting Agencies Purchasing from Contractor(s)
Office of Policy, Management and Budget/Chief Financial Officer $1,194,961
NAVY, Department of the $92,548
Internal Revenue Service $19,193
Top 3 Contractors
Stg International, Inc. $1,194,961
Startech Holdings LLC $81,568
E.T. Computer Supplies & Service Inc., of NY $19,193

Feb. 10 2010 12:25 PM
Nicole L. Karczewski

Zip Code: 11216 (Crown Heights, Brooklyn, NY)
Total dollars: $1,100,073
Total number of contractors: 6
Total number of transactions: 30
Top 5 Contracting Agencies Purchasing from Contractor(s: Public Buildings Service $1,100,073
Top 10 Contractors:
Briguglio Consulting Corp-$883,156
Constellation Energy Group, Inc.-$185,999
Fox RPM Corp-$23,618
National Grid PLC-$3,700
Consolidated Edison, Inc.-$3,600
Nortel Networks Corporation-$0

**All $1,100,073 spent in this zip code was in Congressional District NY 10. An earlier search, limited to the NY District 11, where I live in zip code 11216, produced no results.

Feb. 10 2010 12:24 PM
Jessie

Zip:10580 (Rye, NY)
Total dollars: $345,336
Total number of contractors: 4
Total number of transactions: 26

Top Three Contracting Agencies:
Defense Logistics Agency $335,361
VETERANS AFFAIRS, Department of $9,975
Federal Trade Commission $0

Top Three Contractors:
Allstate Apple Exchange, Inc. $335,361
Novamed, LLC $7,532
Novamed $2,443

I googled Allstate Apple Exchange and am still not sure what they do?

Feb. 10 2010 12:21 PM
Alison

It's interesting, but cumbersome and wonkish. A bit more plain English would be good, describing what services these contracts are actually providing.

For example, for my ZIP code 11238 in Prospect Heights, the best description I can find of the biggest contracts by dollar value awarded in 2009 (To VA-based STG INTERNATIONAL, INC.) is:

"The contractor shall provide State Based Training and Technical Assistance Services to NY Head Start and Early Head Start Grantees in accordance with the Performance Work Statement."

Not very specific! (Incidentally, if it is State-based training, why a VA contractor? Does anyone care about that?)

My preliminary conclusion is that this is an interesting source, but I wonder who it will be most useful for.

Feb. 10 2010 12:20 PM
Steve

Zipcode: 12484 (Stone Ridge, Ulster County, NY)
All Data covers 2000-2009
Total dollars: $377,169
Total number of contractors: 4
Total number of transactions: 38

TOP 3 AGENCIES:
NASA: $110,445
NAVY: $99,594
Agricultural Research Service: $86,211

TOP 3 CONTRACTORS:
Riverlake Partners LLC $324,501
Design Principles Artwork & Accessories, Inc $50,538
Robert A Werner $1,780

The top contractor is actually an Oregon based company that owns a Pennsylvania based company that bought a company in Stone Ridge in 2006 that makes thermal laboratory technology. (I had to find that our through Google; it wasn't "transparent")

Feb. 10 2010 12:19 PM
Bill Mullen

Nice tool, how about someone developing a similar tool that shows where the money comes from?

Feb. 10 2010 12:19 PM
Sue

Total dollars: $14,867,533
Total number of contractors: 14
Total number of transactions: 94

Top 5 Contracting Agencies Purchasing from Contractor(s)
Bureau of Immigration and Customs Enforcement $12,174,491
Public Buildings Service $1,870,540
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $431,897
SOCIAL SECURITY ADMINISTRATION $117,759
NAVY, Department of the $115,061

Top 10 Contractors
Hwa Inc. $10,009,804
Fjc Security Services, Inc. $2,164,686
West Realty Associates LLC $1,534,990
Vandell Foodservice Equipment and Supplies, Corporation $561,553
Hess Corporation $128,676
Consolidated Edison, Inc. $125,532
Prudential Financial, Inc. $104,473
Beltran Associates, Inc. $99,961
Constellation Energy Group, Inc. $81,342
All Veterans, LLC $27,375

found this site interesting

Feb. 10 2010 12:16 PM
Julie

Zip code - 11050 (Port Washington, NY)
Total $ - $7,020,867
Total # of Contractors - 37
Total # of transactions - 338

5 Products - Bearings, Maintenance, Valves, non-food itemes, other defense

Agencies Purchasing - Defense Logistics, Veterans Affairs, Army, Navy, Defense Commisary

Feb. 10 2010 12:15 PM
Helen Northmore

Is a step towards transparency.

Zip Code searched: 10301 Staten Island, NYC

Total dollars: $18,616,292
Total number of contractors: 22
Total number of transactions: 112

Top 5 Contracting Agencies Purchasing from Contractor(s)
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $16,623,574
National Park Service $832,233
U.S. Coast Guard $536,987
Public Buildings Service $453,188
Defense Logistics Agency $88,329

Top 10 Contractors
Great Lakes Dredge & Dock Corporation $15,994,605
Cutting Edge Group, LLC $832,233
Northstar Technology Systems $521,987
Emteque Corp $399,126
Camaci Enterprises Inc $346,138
Strock Enterprises Ltd. $135,800
Dataware Systems Lease Inc $95,514
Battelle Memorial Institute Inc $94,043
United States Postal Service $72,004
Harbor Plaza Associates $54,796

Feb. 10 2010 12:14 PM
Matt in Ridgewood

11385 (Ridgewood, Queens)
Total dollars: $6,567,506
Total number of contractors: 21
Total number of transactions: 702

Top three contracting agencies:
Federal Supply Service $3,894,428
Defense Logistics Agency $2,197,290
Public Buildings Service $266,731

Top three contractors:
Paradise Pillow Inc. $3,883,049
Infoserve Technologies Corp. $2,184,484
Jericho Travel Inc. $194,378

Of interest:
Top expenditure $3,562,512 for "household furnishings", which is apparently mostly pillows.
$181,228 for night-vision equipment

Feb. 10 2010 12:13 PM
ilana

zip 11218 (Kensington, Brooklyn)
Total dollars: $9,919,846
Total number of contractors: 20
Total number of transactions: 1,586
Top 5 Contracting Agencies Purchasing from Contractor(s)
Federal Supply Service $4,735,102
Defense Logistics Agency $3,168,384
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $935,711
Bureau of Prisoners/Federal Prison System $417,998
American Forces Information Service $223,084
Top 10 Contractors
National Industries For The Blind $4,650,586
New York City Industries For The Blind, Inc. $2,480,129
Chief Energy Corp. $990,516
Kimball International, Inc. $471,079
Nyc American Inc $405,000
Focus Camera, Inc $365,183
Dirtt Environmental Solutions, Inc. $197,892
Star Creations Inc. $106,926
Ito, Kazuhiko $70,180
Berkshire Hathaway Inc. $48,201
Top 5 Known Congressional Districts where Work is Performed
Known congressional district help link
New York 8 (Jerrold Nadler) $8,920,804
New York 11 (Major R. Owens / Yvette D. Clarke) $993,042
New York 12 (Nydia M. Velazquez) $6,000

Feb. 10 2010 12:12 PM
Regina Heater

V. easy to use - and intriguing.

Total dollars: $506,613
Total number of contractors: 11
Total number of transactions: 27

Top Three Contracting Agencies
ENVIRONMENTAL PROTECTION AGENCY
$224,928
AIR FORCE, Department of the (Headquarters, USAF)
$99,877
NAVY, Department of the
$77,470

Top Three Contractors
The Shipley Group Inc
$224,928
Bem Systems, Inc.
$99,877
National Manufacturing Co., Inc.
$72,876

Feb. 10 2010 12:12 PM
Hayley

Zip: 11104 (Sunnyside in Queens)
Total dollars: $55,000
Total number of contractors: 1
Total number of transactions: 2

Top 5 Products or Services Sold
Lease or Rental of Facilities -- Miscellaneous Buildings $55,000

Top 5 Contracting Agencies Purchasing from Contractor(s)
VETERANS AFFAIRS, Department of $55,000

Top 10 Contractors
H I M Queens Boulevard Properties $55,000

Feb. 10 2010 12:11 PM
ML

zip: 11221
Bushwick, Brooklyn NY
Total dollars: $14,930
Total number of contractors: 3
Total number of transactions: 5

Top 3 Contracting Agencies:
Bureau of Prisoners/Federal Prison System $8,690
U.S. Special Operations Command $6,240
Federal Emergency Management Agency $0

Top 3 Contractors
Pro Service Pest Control $8,690
Computech International, Inc. $6,240
Free and Ben Inc $0

Very confusing.....

Feb. 10 2010 12:07 PM
David Dlugosz

Philadelphia: 19114

Zipcode you searched
+Total dollars: $52,251,963
Total number of contractors: 156
Total number of transactions: 2,016

Defense Logistics Agency $28,557,615
Farm Service Agency $12,148,760
Defense Commissary Agency $7,653,977

Keystone Aerial Surveys, Inc. $12,154,460
Interstate Bakeries Corporation $7,653,977
Northeast Plastic Supply Co Inc $2,656,865

I definately felt it was a step forward towards transparency. Now I hope people use it and contact their elected officials. I wonder if I find the zip code for Walter Reede Hospital or other military installations, Xe / Blackwater will be at the top of the list :(

Feb. 10 2010 12:07 PM
Daphne

Zip: 10037 (Harlem)
Total dollars: $19,799
Total number of contractors: 4
Total number of transactions: 5
---
$0 Available for everyone for competition
$0 Everyone could compete, but only one bid or offer was received
$19,799 Competition within a limited pool
$0 Actions necessary to continue existing competitive contracts for continuity (until the next one could be competed)
$0 Available only for groups such as disabled persons, prisoners, and regulated utilities
$0 Not competed for an allowable reason
$0 Not identified, soon to be addressed

---

2000 $0
2001 $0
2002 $0
2003 $0
2004 $0
2005 $0
2006 $0
2007 $16,159
2008 $0
2009 Agencies started sending Recovery data $3,640
---


Top 5 Products or Services Sold
Food Services $14,321
Military Personnel Recruitment $5,478

Top 5 Contracting Agencies Purchasing from Contractor(s)
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $19,799

Top 10 Contractors
Massa Family Deli Inc $6,655
Paramount Hotel Group L.L.C. $5,478
Rising Sun Motel Corp. $4,026
Arrochar Meat Inc $3,640

Top 5 Known Congressional Districts where Work is Performed
Known congressional district help link
New York 15 (Charles B. Rangel) $19,799

Feb. 10 2010 12:06 PM
Knits In Public

For my hometown, 10543 (Mamaroneck, NY):
Total dollars: $5,157,470
Total number of contractors: 11
Total number of transactions: 300
Top Three Contracting Agencies:
Defense Logistics Agency - $2,839,549
ARMY, Department of the (except Corps of Engineers Civil Program Financing)- $843,879
STATE, Department of - $712,064
Top Three Contractors:
Inflation Systems, Inc. - $3,699,028
Koninklijke Philips Electronics N.V. - $729,444
Agency Construction Corp. - $583,369

It is interesting to me to note the enormous difference in spending between the town in which I grew up (Mamaroneck), and where I live now (Peekskill). I bought a beautiful home here, even though I feel that Mamaroneck is one of the most beautiful places on earth. The price paid for the house and attendant taxes would have been three if not four times more down county. Every generation strives to become more successful that that which went before, but very few of my childhood friends remain in the Larchmont/Mamaroneck area; we grew up much more well off than we are now.

Feb. 10 2010 12:00 PM
Ann

I think it's great.

My only quibble is a missing "new query" button. Maybe it's me, but the only way I could figure out to do one was to come back to the BL page and go from there...

Really like the ability to search by place work done or by location of contractor - two very different things!

It would also be nice to have a little more detail, even if it wasn't standardized text, on what the actual work it, e.g. cleaning contract for Grand Central post office.

And to Jonathan Jeffries:
This discrepancy is not surprising, and you should be cheering that this provides the tools and knowledge to highlight those discrepancies! How long would it have taken to get that info in the past?

Feb. 10 2010 11:58 AM
Jersey Jeff

ZIP: 07065 (Rahway, NJ)
Total dollars awarded: $7,813,988
Total number of contractors 18
Total number of transactions 219
Top Three Contracting Agencies: Dept of the Navy ($3,167,814), Animal and Plant Health Inspection Service ($2,125,496), Dept. of the Air Force ($928,683)
Top Three Contractors: Lc Engineers, Inc. ($4,464,909), Trugreen Land Care ($2,071,047), Electronic Marine Systems Inc. ($431,638)

I would bet that the $2.1 million spent by APHIS is due to the ongoing Asian Longhorned Beetle eradication project that has been ongoing in my area since 2004 or so.

Feb. 10 2010 11:56 AM
Matt

Zipcode: 15217 (Pittsburgh, PA)

Total dollars: $4,360,795
Total number of contractors: 16
Total number of transactions: 61

TOP 3 AGENCIES:
U.S. AIR FORCE, Headquarters: $1,599,923
U.S. NAVY: $919,973
NASA: $874,944

TOP 3 CONTRACTORS:
Blade Diagnostics Corp. $2,449,896
Protoinnovations, LLC $776,472
Ridgeline Technology $530,595

Feb. 10 2010 11:55 AM
BrettG

ZIP: 11102 -Astoria Queens
Total dollars: $239,927
Total number of contractors: 6
Total number of transactions: 42
Defense Logistics Agency $162,779
Bureau of Prisoners/Federal Prison System $43,150
Public Buildings Service $25,533
Globalhvacr Supply LLC $162,779
Empire Fasteners Inc $43,150
Constellation Energy Group, Inc. $25,533

Feb. 10 2010 11:54 AM
ellen dulberger

zipcode 10541

Top 5 Products or Services Sold
$14,826
Construction of Structures and Facilities -- Other Administrative Facilities and Service Buildings $13,565
Hazardous Substance Removal, Cleanup, and Disposal Services and Operational Support $12,192
Combination and Miscellaneous Instruments $8,995
Laboratory Equipment and Supplies $5,968

Top 5 Contracting Agencies Purchasing from Contractor(s)
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $29,477
NATIONAL AERONAUTICS AND SPACE ADMINISTRATION $20,184
National Institute of Standards and Technology $11,324
Natl. Oceanic and Atmospheric Admin. / Under Sec. Oceans and Atmosphere $3,740

Top 10 Contractors
Kamis Inc $32,919
Enviro Waste Oil Recovery, LLC $29,477
Corpuscular Inc $2,329

Top 5 Known Congressional Districts where Work is Performed

New York 19 (Sue W. Kelly / John J. Hall) $64,725

Feb. 10 2010 11:52 AM
Patrick

+ 02474 (Arlington, MA)

+ Total dollars: $1,496,852

+ Total number of contractors: 12

+ Total number of transactions: 25

+ Top Three Contracting Agencies
Patent and Trademark Office/Under Secretary for Intellectual Property $747,719
AIR FORCE, Department of the (Headquarters, USAF) $605,412
National Park Service $49,550

+ Top Three Contractors
Aai Federal, LLC $747,719
Armstrong Ambulance Service, Inc. $605,412
Boreal Renewable Energy Development $49,550

Feb. 10 2010 11:51 AM
Matt

Zipcode: 10025 (Upper West Side, Manhattan)
Total dollars: $22,656,344
Total number of contractors: 24
Total number of transactions: 118

TOP 3 AGENCIES:
NASA: $15,802,144
NIH: $3,962,242
U.S. NAVY: $1,079,091

TOP 3 CONTRACTORS:
Sigma Space Partners, LLC $9,736,278
Sgt, Inc. $6,014,988
Columbia University $3,736,417

BONUS: Top Known Congressional Districts where Work is Performed:
New York 15 (Charles B. Rangel) $22,372,689
New York 14 (Carolyn B. Maloney) $283,655

Feb. 10 2010 11:47 AM
Emily

zip: 44272
Total dollars: $597,824
Total number of contractors: 2
Total number of transactions: 27

I noticed that the Congressional district box still has James Traficant's name in it even though he was in prison for the majority of the years covered by this info (2000-2009.)

+ How was your experience? Was the tool easy to use? Does this feel like a step forward for transparency?

Also cut and paste:
+ Zipcode you searched
+ Total dollars awarded (result is on the top left of page)
+ Total number of contractors (just below top dollars)
+ Total number of transactions (just below top contractors)
+ Top Three Contracting Agencies (these are the top government agencies that awarded contracts to the area; find this number on the right column of the page)
+ Top Three Contractors (these are the top private agencies that were awarded contracts; find this number on the right column of the page)

Feb. 10 2010 11:40 AM
Matt

+ 11225
+ $79,900
+ 3
+ 4
+ Bureau of the Census
U.S. Secret Service
National Institutes of Health
+ West Indian Day Carnival Associates
Autotech Inc
The City University of New York

+ Very easy to use, and I appreciate the transparency, although under "products or services sold" i see a couple of "miscellaneous" listings. Not so helpful.

Feb. 10 2010 11:32 AM
Knits In Public

10566 searched (Peekskill, NY)
Total dollars: $1,155,452
Total number of contractors: 19
Total number of transactions: 83
Top Three Contracting Agencies:
ARMY, Department of the (except Corps of Engineers Civil Program Financing) - $441,291
Public Buildings Service - $343,316
VETERANS AFFAIRS, Department of - $165,996
Top Three Contractors:
BNS I, LLC - $326,968
Seth & Sami Fud Co Ltd - $203,423
On-Site Dental Care, Inc. - $161,225

The seventh top contractor is something called Tecknowledgey Inc., with $62,908. I can imagine the brainstorming session that produced that company's name. Frightening.

Feb. 10 2010 11:30 AM
Jonathan Jeffries

10033 Washington Heights, New York City
Total dollars: $3,123,141
Total number of contractors: 10
Total number of transactions: 52

10010 Gramercy Park, New York City
Total dollars: $285,287,488
Total number of contractors: 1,804
Total number of transactions: 30,349

That about says it.
--J

Feb. 10 2010 11:27 AM
tony

zip: 11354
Flushing, NY
Total dollars: $1,130,752
Total number of contractors: 13
Total number of transactions: 81

Top 3 Contracting Agencies Purchasing from Contractor(s)

Defense Logistics Agency $628,074
Public Buildings Service $243,398
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $120,102

Top 3 Contractors
S&L Aerospace Metals, LLC $630,074
Consolidated Edison, Inc. $160,460
Mensch Mill & Lumber Corp. $147,005

The military industrial complex is alive and well in Queens. I would not have thought that.

Feb. 10 2010 11:26 AM
joseph goodrich

zip: 11231 (Carroll Gardens, Brooklyn, NY)

Total dollars: $12,410,901
Total number of contractors: 26
Total number of transactions: 399

Feb. 10 2010 11:17 AM
Anne

61336, Magnolia, IL
No results found for search criteria. But they can only afford one police officer on duty for the entire county at any given moment so I'm not surprised there are no government contracts.

Feb. 10 2010 11:17 AM
John Asbury

Zip: 71901 (Hot Springs, AR)
Total Spent: $67,089,234

Interesting... This site shows what contractors are getting the money and how much each is receiving. Plus, it shows the Congressman now representing the district.

Feb. 10 2010 11:14 AM
uberVU - social comments

Social comments and analytics for this post...

This post was mentioned on Twitter by BrianLehrer: talking tmrw with obama cto Aneesh Chopra on gov't transparency. Help test the new tools, we'll bring him the results! http://bit.ly/9XQmBP...

Feb. 10 2010 09:37 AM
Christian

06851 norwalk, ct
Total dollars: $105,439,511
Total number of contractors: 29
Total number of transactions: 911

Defense Commissary Agency $56,846,938

a lot of soup being eaten by the military.

Very cool. hope the GOP doesn't use this information to feed the tea party scare campaign.
Federal Bureau of Investigation $15,766,617
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $9,436,969

Campbell Soup Company $56,777,371
Life Technologies Corporation $46,615,636
Teel Inc $493,615

Feb. 10 2010 01:39 AM
Ryan S

Zip: 14606 (Rochester)
Total $ awarded: $41,059,916
Total # of contractors: 24
Total # of transactions: 955

Top 3 Contracting Agencies:
Air Force ($29,092,173)
Defense Logistics Agency ($4,045,781)
Army ($3,768,523)

Top 3 Contractors:
ITT Corporation ($28,278,825)
Rogers Associates Machine Tool Corp. ($3,390,108)
Vision Associates of Rochester Inc ($2,962,452)

Surprised at how much of the competition was "within a limited pool" (83%). Our dear old Kodak was the #5 contractor.

Feb. 09 2010 06:36 PM
Roger Abraham

Zip: 20910 (Maryland)
Total dollars: $2,842,161,805
Total number of contractors: 1,808
Total number of transactions: 17,001

Top 3 Agencies:
Natl. Oceanic and Atmospheric Admin. / Under Sec. Oceans and Atmosphere $1,138,058,268
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $282,928,567
National Institutes of Health $186,077,184

Top 3 Contractors:
The Aerospace Corporation $175,743,872
Raytheon Company $137,053,410
Coda Research, Inc $116,623,60

I know that NOAA is in my home town, so it's not that surprising that it blew other agencies out of the water. I did notice that, when it comes to the bidding process, almost a 20% were no-bid contracts and almost another quarter (23%) of the contracts were "Not identified, soon to be addressed"...

I like the system, it is a lot of data and it's better than it sitting in a file cabinet in a basement, but I still feel like if I didn't know what I was looking for, it'd be easily missed.

Feb. 09 2010 06:21 PM
Jeff

Zip: 10003
Total dollars: $124,048,804
Total number of contractors: 65
Total number of transactions: 342
Top 3 Agencies:
ARMY, Department of the (except Corps of Engineers Civil Program Financing) $72,705,684
Federal Transit Administration $20,378,582
Drug Enforcement Administration $10,431,788

Top 3 contractors:
Donjon Marine Co Inc
$68,629,390
Stv Group Inc
$20,465,806
Miller Advertising Agency Inc $13,533,392

Nothing unusual to report, except that there is a $48 mil gap between the first and second contractor.

Feb. 09 2010 05:53 PM

Leave a Comment

Email addresses are required but never displayed.

Get the WNYC Morning Brief in your inbox.
We'll send you our top 5 stories every day, plus breaking news and weather.

Sponsored

About Huh. (The Brian Lehrer Show Blog)

It's the Brian Lehrer Show's blog. Stuff that will hopefully make you say "Huh."

Feeds

Supported by