Every open spending data site in the US ranked and listed

The Follow the Money 2012 report has this week revealed the good news that more US states are being open about their public spending by publishing their transactions on their websites. It has also exposed the states of Arkansas, Idaho, Iowa, Montana and Wyoming that are keeping their finances behind a password protected wall or are just not publishing at all.

A network of US Public Interest Research Groups (US PIRGs) which produced the report, revealed that 46 states now “allow residents to access checkbook-level information about government expenditures online”.

The checkbook means a digital copy of who receives state money, how much, and for what purpose. Perhaps to make sense of this ‘checkbook’ concept it’s useful to compare US and UK public finance transparency.

In the UK councils have been publishing lists of their spending over £500 for just over a year. This is mostly monthly, mostly in spreadsheets, and the data can be anything from a list of suppliers and amount paid on a particular date to much more detailed accounts of spending.

The government site Direct Gov provides a service to look up your local council’s spending data. Websites like Openly Local and Open Spending gather and are making sense of the UK council spending collectively.

There are sticky difficulties interpreting the data though: it’s often not clear if it is payment in advance and repayments will be made at a future date and it’s often not clear what a payment is for. We detailed these problems in this datablog post shortly after the first wave of local council transparency. This is not to diminish the potential of this data.

This is just the UK way.

In the US the best states are producing a checkbook tool which gives users the ability to monitor state spending in almost real-time because the data is updated nightly.

But more than that the checkbook allows users to see the exact amounts paid to the vendor, without mixing in contracts that are in the form of pre-purchase orders or term contracts.

The Follow the Money 2012 report found Texas and Kentucky to be leading examples of states who are accountable to their citizens. Kentucky lost some points in the grading as checkbook-level spending information is not downloadable, but aggregate expenditure by department or type of goods or service was.

The value of good transparency is illustrated by some nice examples in the report.

when Minnesota began to require agencies to submit reports on the performance of subsidized projects, the reports revealed that numerous projects were receiving assistance from two or more funding sources—that is, Minnesota tax-payers were sometimes double- and triple- paying for the creation of the same jobs. After the centralized publication of those reports, the double-dipping stopped.

Here’s the key data from the report with links to all the states’ websites. Let us know what you think to the ranking and what you’d like to see in the UK.

Data summary

Follow the Money 2012 grading system

Click heading to sort

Source: U.S. PIRG

Alabama

State Comptroller’s Office, Dept. of Finance

website

C

74

Alaska

Division of Finance, Dept. of Administration

website

D-

47

Arizona

General Accounting Office, Department of Administration

website

A-

92

Arkansas

Department of Finance and Administration

website

F

28

California

Governor’s Office

website

D+

62

Colorado

Office of the State Controller, Department of Personnel and Administration

website

C

70

Connecticut

Department of Administrative Services

website

F

39

Delaware

Cooperation of Office of Management and Budget, Department of Finance, and the Government Information Center

website

D+

61

Florida

Department of Financial Services

website

D

59

Georgia

Department of Audits and Accounts

website

C

74

Hawaii

State Procurement Office, Department of Accounting and General Services

website

C

72

Idaho

Division of Purchasing, Department of Administration

website

F

6

Illinois

Department of Central Management Services

website

C

73

Indiana

State Auditor’s Office

website

A-

93

Iowa

Department of Administrative Services, Procurement Services Division

website

F

32

Kansas

Department of Administration

website

C

73

Kentucky

Governor’s Office: E-Transparency Task Force, a multi-agency effort led by officials of the Finance and Administration Cabinet

website

A

96

Louisiana

Division of Administration

website

A-

92

Maine

Department of Administrative and Financial Services, Division of Purchases

website

F

0

Maryland

Department of Budget and Management

website

C

71

Massachusetts

Executive Office for Administration and Finance

website then click “Massachusetts Transparency” link

B+

87

Michigan

Office of Financial Management, State Budget Office, Department of Technology, Management and Budget

website

C

70

Minnesota

Minnesota Management and Budget

website

C

73

Mississippi

Department of Finance and Administration

website

C

70

Missouri

Office of Administration

website

C+

76

Montana

Department of Administration, General Services Division, State Procurement Bureau

website

F

16

Nebraska

State Treasurer’s Office

website

C

71

Nevada

Budget and Planning Division, Department of Administration

website

C

74

New Hampshire

Department of Administrative Services and the Department of Information Technology

website

F

7

New Jersey

Governor’s Office

website

C+

78

New Mexico

Cooperation of the General Services Department, the Department of Finance and Administration, the Department of Transportation, and the Department of Information Technology

website

D+

61

New York

Office of the State Comptroller

website

C

73

North Carolina

Office of State Budget and Management (OSBM) with substantial help from the Department of Administration (DOA), the Office of the State Controller (OSC), and the Office of Information Technology Services (ITS)

website

B

85

North Dakota

Office of Management and Budget, State Procurement Office

website

F

6

Ohio

Treasurer of State

website

B-

82

Oklahoma

Office of State Finance

website

C-

66

Oregon

Department of Administrative Services

website

B-

82

Pennsylvania

Pennsylvania Treasury Department

website

C+

78

Rhode Island

State Controller’s Office, Office of Accounts and Controls, Department of Administration

website

C-

66

South Carolina

Comptroller General’s Office

website

D+

61

South Dakota

Bureau of Finance and Management

website

D+

63

Tennessee

Department of Finance and Administration

website

D-

49

Texas

Comptroller of Public Accounts’ Office

website

A

96

Utah

Division of Finance, Department of Administrative Services

website

C

70

Vermont

Department of Finance and Management

website

D

55

Virginia

Auditor of Public Accounts

website

C+

77

Washington

Legislative Evaluation and Accountability Program and the Office of Financial Management

website

F

22

West Virginia

Department of Administration, Purchasing Division

website

F

28

Wisconsin

Wisconsin Government Accountability Board

website

D+

61

Wyoming

Department of Adminstration and Information

website

D-

50


Download the data

DATA: download the full spreadsheet

More data

Data journalism and data visualisations from the Guardian

World government data

Search the world’s government data with our gateway

Development and aid data

Search the world’s global development data with our gateway

Can you do something with this data?

Flickr Please post your visualisations and mash-ups on our Flickr group
• Contact us at data@guardian.co.uk

Get the A-Z of data
More at the Datastore directory

Follow us on Twitter
Like us on Facebook

Open bundled references in tabs: