Aggregate State Budget

Project Goal
The goal of this project is to combine the Fiscal Year 2010 state expenditures of the 50 US States into a single easy to use data-set.

The Problem
Every state publishes some version of their budget broken down by agency, program or purpose. Unfortunately, most states lock this data in lengthy PDF documents. A researcher who wants to compare state-level spending around the country faces a daunting task.

Project Steps
1. Gathering the Data - Where possible I will use data published on State Websites. If the data is not easily available, I will reach out directly to the relevant state agency. As data is gathered, it will be posted on this page in TXT, CSV, XLS or other easy to use formats. I encourage others to add data and to verify the accuracy of posted data.

2.Organizing Data - To facilitate cross-state comparisons, a common classification hierarchy will be applied to every state's budget entries.

Project Time-line
All data will be collected in an easy to use format by 5/31/2010. The final data-set will be available by 6/30/2010.

State Expenditure Hierarchy
I.Administration A.Legislature B.Executive i.Governor ii.Lieutenant Governor iii.Secretary of State C.Public Finance i.Public Finance ii.Debt Service D.Human Resources E.Oversight F.Elections II.Education A.K-12 i.Local School Districts ii.State Initiatives iii.Special Education iv.Teachers B.Universities i.General Funds ii.Scholarships C.Community Colleges D.Research III.Social Services A.Health B.Poverty C.Social Services i.Child Services ii.Elderly Services iii.Women Services iv.Family Services D.Emergency Management E.Disability i.Disability ii.Mental Health F.Veterans IV.Law/Justice/Safety A.Courts B.Attorney General C.Law Enforcement D.Consumer Protection i.Alcohol/Tobacco ii.Banking/Finance/Insurance/Real Estate iii.Services E.Corrections i.Corrections ii.Reentry F.Criminal Trials i.Prosecutors ii.Public Defenders iii.Victims G.Defense i.National Guard ii.Homeland Security iii.Military Support V.Economic Development/Commerce A.Business Promotion B.Community Development C.Tourism Promotion D.Employment i.Workforce Development ii.Labor Law iii. Unemployment E.Agriculture F.Infrastructure i.Transportation ii.Water Resources iii.Capital Improvements iv.Communications G.Natural Resource Management i.Mineral Resources ii.Forestry iii. Parks iv.Environmental Protection v.Land Management

State Data
Alabama

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dEN4OTBGR0ZpUjRYdGlqVW9IYV9lYWc&hl=en

Alaska

Arizona

Arkansas

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dFFiQ2JldGZ4WkJOSVIzMkswZ3hpQmc&hl=en

Data from: budget@dfa.arkansas.gov

California

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dFpZNHNMei1TV0lYMWVUN0VReGJYTVE&hl=en

Data From: http://www.ebudget.ca.gov/agencies.html

Colorado

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dE5LUDNNbjhueWRPZmlaR1VwUEFzaEE&hl=en

Data From: http://tops.state.co.us/toprpt/top_deptsearchmain.htm

Connecticut

Delaware

Florida

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dG9NMUp3cGk2M3Y0eDlrNHNlR0VBdXc&hl=en

Data From: http://www.ebudget.state.fl.us/bdagencies.aspx

Georgia

http://spreadsheets.google.com/ccc?key=tF-N12a8PaF4xDTKz-tTpag&hl=en#gid=0

Data From: http://www.opb.state.ga.us/media/12303/state_of_georgia_budget_amended_fy_2010.pdf (Summary of Appropriations)

Hawaii

Idaho

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dHBUaFhMcVRNemFpMEtPbnhDd1poOUE&hl=en

Data From: http://efficiency.idaho.gov/

Illinois

Indiana

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dHQwQmZVTUxpM3NTSXhaaGV0alI4MXc&hl=en

Data From: http://www.in.gov/sba/2543.htm (Detailed Budget Data)

Iowa

Kansas

Kentucky

Louisiana

Maine

Maryland

Massachusetts

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dFFlSmZPaS1ZZDJLU0hNNF9EdHNmMGc&hl=en

Data From: http://www.mass.gov/bb/gaa/fy2010/app_10/ga_10/hdefault.htm

Michigan

Minnesota

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dEN3OFJtT0o2d29udGJaNm5CSUhkY0E&hl=en

Data From: http://www.mmb.state.mn.us/tap

Mississippi

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dGtaRjdNOEFUblZaS0ZPSS1LcWFvd2c&hl=en

Data from: https://merlin.state.ms.us/merlin/predef.nsf/BudgetByAgency?OpenForm

Missouri

Montana

Nebraska

Nevada

New Hampshire

New Jersey

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dFh1YnRfRTIxeHc1RWZqUEpLeEV1NEE&hl=en

Data From:

New Mexico

New York

North Carolina

North Dakota

Ohio

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dE92MXlmMFFMRS04bmRsRzBaS0xnUFE&hl=en

Data From: http://obm.ohio.gov/SectionPages/Budget/FY1011/Appropriations.aspx?Link=1

Oklahoma

Oregon

Pennsylvania

Rhode Island

South Carolina

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dGNnTWxtczh3ZnZ2amNZSnYyZks0NWc&hl=en

Data From: http://www.budget.sc.gov/OSB-index.phtm

South Dakota

Tennessee

Texas

Utah

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dFhwaVdvUkRxQzJiWUI5V0xwZHhYSUE&hl=en

Data From:

Vermont

Virginia

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dF9haV9wbk5pM0p4RFRjX1p3SzNYOWc&hl=en

Data From: http://dpb.virginia.gov/budget/buddoc10/index.cfm

Washington

West Virginia

Wisconsin

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dExvenFnbG9aSW83QVFiekttY3pZelE&hl=en

Data from: http://www.doa.state.wi.us/debf/execbudget.asp

Wyoming

http://spreadsheets.google.com/ccc?key=0AhGXGUT8Y6y-dG1QUVVQOGtTWllUdzlnUzZJbElCYXc&hl=en

Data From: http://ai.state.wy.us/budget/pdf/11-12-BienAngnAppr/11-12%20WEBPAGE%20AGENCIES.pdf