Sunday, July 18, 2010

Update to State and Local Data: FY 2008

On July 18, 2010, usgovernmentspending.com updated its database with the latest data release on State and Local Government Spending and Revenue from the US Census Bureau. The latest data is for fiscal year 2008. Previously the state data displayed for 2008 was reported, and local data was "guesstimated" based on a crude projection of spending and revenue levels from 2007.
The update includes data for individual states and data and aggregate spending and revenue data for all states.
State tax data has been updated for FY 2009 using quarterly tax reports from the US Census Bureau. State tax data has been updated for FY 2010, using data for the final quarter, calendar 2010 second quarter, from the same quarter in 2009.
Here is the current status of state and local government spending and revenue data.
  • Data up to and including 2008 is actual data reported to and published by the Census Bureau.
  • State tax data for 2009 is actual data reported to and published by the Census Bureau in State Government Tax Collections.
  • State tax data for 2010 is actual data reported to and published by the Census Bureau in State Government Tax Collections for Q1, Q2, and Q3. Q4 uses FY 2009 data from the Census Bureau. Q4 data will be available at the end of September 2010.
  • Data for 2009 (except state tax data for 2009 and 2010) and subsequent years is "guesstimated" by projecting the change in each spending or revenue item between 2007 and 2008 forward. Maximum change is 15 percent. Minimum change is zero percent.
Caveat on "Guesstimated" Data
The crude "guesstimation" that usgovernmentspending.com applies to data after 2008 (the last year for which the US Census Bureau provides data) is a way to get a rough look at total government spending in the present year and the near future.
But in the current recession state and local spending is probably higher than "guesstimated" and revenue is probably significantly lower than "guesstimated."
Upcoming Data Updates
The Census Bureau will report state tax revenues for calendar 2010 Q2 on September 30, 2010.
The Census Bureau will release State Government Finances for 2009 (i.e. spending and revenue) in late Fall 2010.
The Census Bureau will next update State and Local Government Finances (i.e. spending and revenue data) in July 2011.

Monday, April 5, 2010

Improved Display of Data Source Type

For years usgovernmentspending.com and usgovernmentrevenue.com have shown on the Numbers tab the data source type for the spending and revenue numbers. The data source type for each number is shown by color code as follows, in decreasing order of reliability, as follows: Actual, Interpolated, Budgeted, Estimated, or "Guesstimated."

Now we are showing the data source for each number on the home page and on the Charts tab. Bar chart values are show in blue for "actual" and red for "estimated" (including budgeted, estimated, and "guesstimated"). In addition, values shown as numbers on the Charts tab are tagged with their data source, a-i-b-e-g, as appropriate.

Typically, the values that you see on the site are "rolled up" from individual spending items into broad functional categories. The rolled-up values may include, e.g., actual and guesstimated. When rolled-up values have different data source types, the type displayed is always the less reliable one. For example, if any component of the rolled-up value was sourced as "guesstimated" then the rolled-up value will display as "guesstimated."

Saturday, February 6, 2010

Federal Budget Update: FY 2011

On February 1, 2010, the president released the federal budget for fiscal year 2011. The numbers on usgovernmentspending.com and usgovernmentrevenue.com now reflect the new budget.
Spending numbers at the subfunction level have been updated from Table 3.2 in the Historical Tables. Fiscal year 2009 has been updated with actual numbers for the fiscal year that ended 9/30/2009, and Fiscal year 2010 thru 2014 have been updated with the new estimates. Fiscal year 2015 estimates appear for the first time.
Spending numbers at the agency account level have been updated from outlays.csv in the Public Budget Database.
Revenue numbers have been updated from Table 2.1 Table 2.4, and Table 2.5 in the Historical Tables. Fiscal year 2009 has been updated with actual numbers, and Fiscal year 2010 thru 2014 with the new estimates. Fiscal year 2015 estimates appear for the first time.
Projected GDP numbers have been updated from Table 10.1 in the Historical Tables. GDP for 2009 through 2014 has been updated. GDP for 2015 appears for the first time.
Federal Debt numbers have been updated from Table 7.1 in the Historical Tables. Debt for 2009 and projected through 2014 have been updated. Debt for 2015 appears for the first time.