Recently, Drugmonkey put up a post with the understated title Federal RePORTER!!!!!!!!!!!!! He noted to a new project from the Star Metrics program with a version of the NIH RePORTER website that now has data from NSF, USDA, and EPA, in addition NIH. Needless to say, I could not resist having a look.
One question that occurred to me right away is how many NIH funded investigators also have NSF funding. A quick download from Federal RePORTER and I had an answer (given my previous work on NIH data).
25361 investigators had R-mechanism funding from NIH
11440 awards were listed on Federal RePORTER from NSF corresponding to 10260 unique investigators (with some uncertainty due to potential name overlap)
196 individuals were on both lists.
This strikes me as a surprisingly low number, corresponding to a few investigators per institution. However, I grew up in chemistry departments which is likely an area where funding from both NIH and NSF is most common.
Suggestions about other questions are welcome although the data available from Federal RePORTER is still limited (e.g. only back to 2004).