As stated in the note from the Sunlight Foundation′s Board Chair, as of September 2020 the Sunlight Foundation is no longer active. This site is maintained as a static archive only.

Follow Us

Tag Archive: financial transparency

OpenGov Voices: Local Government Financial Transparency: Scaling It Up


Disclaimer: The opinions expressed by the guest blogger and those providing comments are theirs alone and do not reflect the opinions of the Joffe_Headshot_1Sunlight Foundation or any employee thereof. Sunlight Foundation is not responsible for the accuracy of any of the information within the guest blog.

Marc Joffe is the founder of Public Sector Credit Solutions (PSCS) which applies open data and analytics to rating government bonds. Before starting PSCS, Marc was a Senior Director at Moody’s Analytics. You can contact him at

Groups like OpenOakland and Open City have done some great work in making local government financial data more accessible. Machine readable data sets and visualizations help citizens better understand how their tax money is being used.

Because these efforts typically require volunteers and/or visionary political leaders, they tend to focus on individual governmental units. Since the U.S. has some 80,000 local governments, it is unlikely that these standalone projects will give us anything like nationwide transparency of local government fiscal data. Building a nationwide open data set would be very beneficial because it would allow users to compare their city or county to comparable units across the country. It could answer such questions as “how does our public safety spending stack up against other cities with similar population and crime rate?” It could also allow us to compare the fiscal condition of cities in order to see which are headed in the direction of Detroit, Harrisburg, San Bernardino and Stockton – toward bankruptcy.

ca_credit_scoring_mapA Mountain View California based company,, is working with several local governments to place their fiscal data online, in graphical form. If successful, this firm could greatly increase the amount of open government financial data – for those governments that are willing to subscribe to their transparency service.

But what about situations in which a local government is unwilling to cooperate and volunteers are unavailable? This universe is likely to include some of the more fiscally irresponsible governments in places that lack tech-savvy, engaged citizens.

In these cases, we can collect and report data on behalf of those governments. Recently, my group, Public Sector Credit Solutions, collected legally mandated financial reports from 260 city governments in California. We extracted standardized data from these reports and placed the information online for free here. We’d love to work with other groups to roll out this type of fiscal transparency to other types of local governments (like counties and regional transportation districts) and to the rest of the country.

Continue reading Data Quality — Still Bad?


We at the labs have written about several times now. We’ve recently been able to make use of their bulk data downloads to regularly populate some of our webapps with federal grants and contracts data. However, we also have an old snapshot of the data that we received in April of 2010. This snapshot was received on a hard drive that we shipped to USASpending engineers -- before the bulk data downloads existed. Thankfully, we don’t have to go through that process anymore. I wondered how the data has changed over the past year. Last year, the USASpending team took a lot of flak for their data quality issues. Has it been improved? I thought I’d take a look back and see how two data snapshots from April 2010 and December 2010 compare.

Continue reading

CFC (Combined Federal Campaign) Today 59063

Charity Navigator