Source: Republican Caucus, California Assembly. For the grisly details, read this dismal story.
If a similar analysis were done for the federal government, it would show the same pattern: millions of jobs lost in the private sector, and hundreds of thousands added in the federal government, at all levels. Here is an instructive graph that compares unemployment trends in the current recession with all previous recessions since World War II (click to enlarge):
And here is a graph that shows the trend in federal government jobs from 1990 to 2010 (the red peaks show the impact of census hiring every ten years; the black line is the trend without those impacts -- click to enlarge):
As always, the bureaucrats take care of their own, even as the ship itself sinks.