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.Governonor
       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