Personal Democracy Plus Our premium content network. LEARN MORE You are not logged in. LOG IN NOW >

A New York City Transparency Project Will Open-Source a Look Inside the City's Checkbook

BY Nick Judd | Thursday, February 9 2012

An early rendition of what the next NYC Checkbook website might look like. Courtesy NYC Comptroller's Office

The office of the New York City Comptroller has begun coding up a revamp to a site that already gives a comprehensive look, updated daily, at nearly every check issued by the city.

For the first time, the city will also offer software developers direct, programmatic access to a comprehensive trove of information about New York's fiscal health. And within a few weeks after the updated site launches, city officials say, the source code will be released online under an open-source license.

Several states and cities around the country have started releasing their check registers online. But the New York website, called Checkbook NYC and launched in 2010, is about to get a massive upgrade that promises a new level of access to information. A new version of the site expected to launch this year will grant access to detailed information about the contracts related to each individual payment, city vendors and the contracts they're working on, and how payments made to date stack up against each agency's budget. The site will also include information about incoming revenues and should also play host to a collection of audits, budget reports and other analysis produced by the network of entities responsible for poring over the city's finances.

"Our goal is to make New York City the most financially transparent government in the United States," said Ari Hoffnung, who is now the city's deputy comptroller for public affairs but had been involved in launching the original Checkbook project while working in another part of the Comptroller's office.

Open-sourcing the project was "very interesting" to the comptroller, Hoffnung said, as a way to "end predatory vendor lock-in" and to create something that other cities might be willing to share the cost of maintaining and improving.

An early rendition of what the new Checkbook 2.0 might look like.

The new version of the site, which Hoffnung is calling Checkbook 2.0, is expected to have an application programming interface at launch. In theory, this could enable third-party developers to pull raw data from the city and use them to build anything from a site that tracks how much the city spends on pizza parties for employees to one that provides a daily look at how tax revenues are sizing up against expectations.

Checkbook 2.0 is modeled off of and is being built by REI Systems, the same team that built the Federal IT Dashboard. Civic Commons, an organization that works to increase adoption of open-source software in government and to help governments open-source their projects, has been consulting on the project from the beginning to help guide the eventual release of the revamped site's source code. was criticized for having inaccurate data; Hoffnung says that the way the city tracks its finances will prevent the same issue, but more on that later.

"Here we're getting a chance to get in on the project earlier and make sure that things are set up in an open-sourceable way," Fogel said. Civic Commons has also helped open-source the Federal IT Dashboard; San Francisco's enterprise addressing system; and the ChangeByUS platform for pitching and sharing civic projects, among others, but the partnership with the comptroller's office is a rare opportunity to get involved at the start of a project rather than the end.

Checkbook 2.0's expected cost is $1.5 million — a hefty sum, but not as much as the city spent on CityTime, a boondoggle project to build a streamlined payroll system for city employees that was supposed to cost $63 million but instead cost New York over $628 million — thanks in part to alleged fraud and kickbacks that became the centerpiece of a federal investigation and have led to at least one guilty plea.

And Hoffnung says the city's Financial Management System, a centralized database that all city entities use to record and track transactions, has cost $315 million so far. With the Checkbook beta release and other software that's already been developed, the whole Checkbook project's estimated price tag is $2.87 million — less than 1 percent of what FMS costs. Hoffnung says the comptroller is comfortable with that ratio.

FMS — which resides in a server farm at the headquarters of the city's Financial Information Services Agency — is the unique asset that makes this theoretically possible. FISA was created in response to the city's fiscal crisis of the 1970s and tasked with implementing a centralized system for budget, accounting, and payroll. Through FMS, the agency tracks every payment the city makes. You can go here, for example, and search for how much the city has spent at Staples in the past month, if you want. (Payee information is withheld about 20 percent of the time for reasons of privacy or security, Hoffnung says.) But the amount that will be made available online is just a fraction of what FMS tracks: Of an estimated 2,100 gigabytes of data in the system, Hoffnung told me, only 51 gigabytes are now accessible online. Checkbook 2.0 will make a larger sliver of data available, but it will still be just a sliver.

Hoffnung contacted techPresident about this project partly in the hopes that it will generate feedback from our readers. For instance, Hoffnung gets that the site should have an API, but said it's unclear exactly how that interface will be structured, what data will be made available through it, and so on. The idea of making available bulk financial data about the city has not entered the discussion.

News Briefs

RSS Feed today >

Transparency and Public Shaming: Pakistan Tackles Tax Evasion

In Pakistan, where only one in 200 citizens files their income tax return, authorities published a directory of taxpayers' details for the first time. Officials explained the decision as an attempt to shame defaulters into paying up.


wednesday >

Facebook Seeks Approval as Financial Service in Ireland. Is the Developing World Next?

On April 13 the Financial Times reported that Facebook is only weeks away from being approved as a financial service in Ireland. Is this foray into e-money motivated by Facebook's desire to conquer the developing world before other corporate Internet giants do? Maybe.


The Rise and Fall of Iran's “Blogestan”

The robust community of Iranian bloggers—sometimes nicknamed “Blogestan”—has shrunk since its heyday between 2002 – 2010. “Whither Blogestan,” a recent report from the University of Pennsylvania's Iran Media Program sought to find out how and why. The researchers performed a web crawling analysis of Blogestan, survey 165 Persian blog users, and conducted 20 interviews with influential bloggers in the Persian community. They found multiple causes of the decline in blogging, including increased social media use and interference from authorities.


tuesday >

Weekly Readings: What the Govt Wants to Know

A roundup of interesting reads and stories from around the web. GO

Russia to Treat Bloggers Like Mass Media Because "the F*cking Journalists Won't Stop Writing"

The worldwide debate over who is and who isn't a journalist has raged since digital media made it much easier for citizen journalists and other “amateurs” to compete with the big guys. In the United States, journalists are entitled to certain protections under the law, such as the right to confidential sources. As such, many argue that blogging should qualify as journalism because independent writers deserve the same legal protections as corporate employees. In Russia, however, earning a place equal to mass media means additional regulations and obligations, which some say will lead to the repression of free speech.


Politics for People: Demanding Transparent and Ethical Lobbying in the EU

Today the Alliance for Lobbying Transparency and Ethics Regulation (ALTER-EU) launched a campaign called Politics for People that asks candidates for the European Parliament to pledge to stand up to secretive industry lobbyists and to advocate for transparency. The Politics for People website connects voters with information about their MEP candidates and encourages them to reach out on Facebook, Twitter or by email to ask them to sign the pledge.


monday >

Security Agencies Given Full Access to Telecom Data Even Though "All Lebanese Can Not Be Suspects"

In late March, Lebanese government ministers granted security agencies unrestricted access to telecommunications data in spite of some ministers objections that it violates privacy rights. Global Voices reports that the policy violates Lebanon's existing surveillance and privacy law, Law 140, but has gotten little coverage from the country's mainstream media.


friday >

In Google Hangout, NYC Mayor de Blasio Talks Tech and Outer Borough Potential

New York City Mayor Bill de Blasio followed the lead of President Obama and New York City Council member Ben Kallos Friday by participating in a Google Hangout to help mark his first 100 days in office, in which the conversation focused on expanding access to technology opportunities through education and ensuring that the needs of the so-called "outer boroughs" aren't overlooked. GO

thursday >

In Pakistan, A Hypocritical Gov't Ignores Calls To End YouTube Ban

YouTube has been blocked in Pakistan by executive order since September 2012, after the “blasphemous” video Innocence of Muslims started riots in the Middle East. Since then, civil society organizations and Internet rights advocacy groups like Bolo Bhi and Bytes for All have been working to lift the ban. Last August the return of YouTube seemed imminent—the then-new IT Minister Anusha Rehman spoke optimistically and her party, which had won the majority a few months before, was said to be “seriously contemplating” ending the ban. And yet since then, Rehman and her party, the conservative Pakistan Muslim League (PML-N), have done everything in their power to maintain the status quo.


The #NotABugSplat Campaign Aims to Give Drone Operators Pause Before They Strike

In the #NotABugSplat campaign that launched this week, a group of American, French and Pakistani artists sought to raise awareness of the effects of drone strikes by placing a field-sized image of a young girl, orphaned when a drone strike killed her family, in a heavily targeted region of Pakistan’s Khyber-Pakhtunkhwa Province. Its giant size is visible to those who operate drone strikes as well as in satellite imagery. GO

Boston and Cambridge Move Towards More Open Data

The Boston City Council is now considering an ordinance which would require Boston city agencies and departments to make government data available online using open standards. Boston City Councilor At Large Michelle Wu, who introduced the legislation Wednesday, officially announced her proposal Monday, the same day Boston Mayor Martin Walsh issued an executive order establishing an open data policy under which all city departments are directed to publish appropriate data sets under established accessibility, API and format standards. GO