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

The New York City Comptroller Built a Fiscal Transparency Website, and Now It's Open Source

BY Miranda Neubauer | Thursday, June 6 2013

Comptroller John Liu Photo: Esty Stein / Personal Democracy Media

The source code of New York City's Checkbook NYC platform is now available for other governments to download, modify and reuse, New York City Comptroller John Liu announced during Thursday's Personal Democracy Forum.

Checkbook NYC is a web application that presents data from the city's financial management systems online. Users can view or download information about city spending, broken down by agency or vendor, for example. In addition, information about contracts, payroll and disbursements is linked together, rather than existing in separate silos. It also offers API access that developers can use to build other applications on top of raw data about city spending, as well as bulk data downloads. The comptroller's office has also promised to make city income data available on the platform soon.

Liu also announced that the information technology companies Oracle and CGI had agreed to develop automated data feeds known as adapters between their financial management systems and the Checkbook NYC system. Oracle and CGI's support means cities that use their software to manage finances could also adapt Checkbook NYC for their use.

REI Systems, which has worked with the city on developing Checkbook NYC and making it available in open-source format, also volunteered to provide technological expertise and tools to Oracle and CGI to test the automated data feeds and host so-called sandbox development sites for a small number of the companies' state and city financial management system clients.

Altogether, Oracle, CGI and REI have invested over $1 million in resources to help make the platform available to other cities, according to a press release.

Plans are under way to organize a "Checkbook NYC" hackathon in the fall to bring together civic activists, software developers and entrepreneurs to develop applications based on the platform, according to the press release. In addition, discussions are under way to form a consortium of governments to collaboratively manage the source code and jointly share costs of future enhancements.

The code is available under the AGPL 3.0 license at Github.

At Thursday's PDF event, Deputy Comptroller Ari Hoffnung gave a demonstration of the platform, which first launched in 2010 and was revamped earlier this year.

Hoffnung said Liu was very much interested in setting up a system would be just as easy for the public to interact with as buying a book on Amazon or checking a banking statement online.

"How many New Yorkers know what an API is?" Hoffnung asked.

With Checkbook NYC, he said, at a cost of less than $3 million, information from the city's financial management system for 4,000 users within city agencies, a system supported by CGI, is now potentially accessible to all 8 million New Yorkers and beyond.

In his remarks, Liu, also a candidate for mayor, emphasized that Checkbook NYC not only puts pressure on city agencies to spend tax money more efficiently, but also shows city contractors how much their competitors are charging, putting pressure on them to bring down costs. He emphasized that the expansion of Checkbook to other cities would benefit New York City as well.

"If the city of L.A. decides to adopt Checkbook, and then builds a mapping app, NYC can benefit from that," he said.

In theory, New Yorkers could enter their zip code and see investments in their neighborhood. The data feeds offered by the companies would lower the barrier for other governments to adopt the system because they allow the governments "with the flip of a switch to feed their financial data into checkbook. "

Noting the large amount of money state and local governments spend on information technology, "in an era of scarce resources, we have to invest dollars more strategically," he said.

In a statement, Socrata said it would support Checkbook by offering it as a turnkey cloud service, and enhancing the platform with open APIs for developers and data analysis and visualization tools for the public.

Hoffnung said the Comptroller's Office has been in many conversations with other cities and states about adopting the platform, and noted that the availability of the data feeds meant other governments wouldn't have to spend resources on data extraction and data mapping, services that would instead be provided to governments "at no cost to jump start the process."

In the city's press release, several cities and civic groups praised the new open source nature of the platform and expressed interest in it.

"New York has provided a very easy-to-use transparency portal to gain access to budget, payroll and departmental expenditures, to the point that not only will the citizens of New York benefit, but internal departments will benefit by having easy access to their own information for better management and accountability,” Steve Reneker, general manager and CTO of the City of Los Angeles Information Technology Agency said in the statement. “The City of Los Angeles will be looking into leveraging this open source solution to provide similar benefits.”

“We applaud New York City and Oracle for the work they are doing to promote financial transparency,” Maryland's Montgomery County Controller Lenny Moore said in the statement. “Montgomery County is a leader in open data and is always working to make government spending more accessible and easier to understand for our taxpayers. We are intrigued by the possibility of deploying an open Checkbook.

“Checkbook NYC is by far the most sophisticated city-budget transparency app to date," Adam Stiles, co-creator of Open Budget Oakland added in the statement. “By making Checkbook available to cities nationwide, NYC is enabling a common framework to understand city spending that could one day allow, for example, apples-to-apples comparisons of spending across cities.”

“Checkbook NYC is a flagship example of the emerging ecosystem of interoperable, useful, and reusable civic tools," said Code for America Chief of Staff Abhi Nemani. "This is the kind of project Code for America hopes to support in city after city.”

News Briefs

RSS Feed thursday >

Civic Hackers Call on de Blasio to Fill Technology Vacancies

New York City technology advocates on Wednesday called on the de Blasio administration to fill vacancies in top technology policy positions, expressing some frustration at the lack of a leadership team to implement a cohesive technology strategy for the city. GO

China's Porn Purge Has Only Just Begun, And Already Sina Is Stripped of Publication License

It seems that China is taking spring cleaning pretty seriously. On April 13 they launched their most recent online purge, “Cleaning the Web 2014,” which will run until November. The goal is to rid China's Internet of pornographic text, pictures, video, and ads in order to “create a healthy cyberspace.” More than 100 websites and thousands of social media accounts have already been closed, after less than a month. Today the official Xinhua news agency reported that the authorities have stripped the Internet giant Sina (of Sina Weibo, the popular microblogging site) of its online publication license. This crackdown on porn comes on the heels of a crackdown on “rumors.” Clearly, this spring cleaning isn't about pornography, it's about censorship and control.


wednesday >

Another Co-Opted Hashtag: #MustSeeIran

The Twitter hashtag #MustSeeIran was created to showcase Iran's architecture, landscapes, and would-be tourist destinations. It was then co-opted by activists to bring attention to human rights abuses and infringements. Now Twitter is home to two starkly different portraits of a country. GO

What Has the EU Ever Done For Us?: Countering Euroskepticism with Viral Videos and Monty Python

Ahead of the May 25 European Elections, the most intense campaigning may not be by the candidates or the political parties. Instead, some of the most passionate campaigns are more grassroots efforts focused on for a start stirring up the interest of the European electorate. GO

At NETmundial Brazil: Is "Multistakeholderism" Good for the Internet?

Today and tomorrow Brazil is hosting NETmundial, a global multi-stakeholder meeting on the future of Internet governance. GO

Brazilian President Signs Internet Bill of Rights Into Law at NetMundial

Earlier today Brazil's President Dilma Rousseff sanctioned Marco Civil, also called the Internet bill of rights, during the global Internet governance event, NetMundial, in Brazil.


tuesday > Reboots As a Candidate Digital Toolkit That's a Bit Too Like launched with big ambitions and star appeal, hoping to crack the code on how to get millions of people to pool their political passions through their platform. When that ambition stalled, its founder Nathan Daschle--son of the former Senator--decided to pivot to offering political candidates an easy-to-use free web platform for organizing and fundraising. Now the new is out from stealth mode, entering a field already being served by competitors like NationBuilder, Salsa Labs and And strangely enough, seems to want its early users to ask for help. GO

Armenian Legislators: You Can Be As Anonymous on the 'Net As You Like—Until You Can't

A proposed bill in Armenia would make it illegal for media outlets to include defamatory remarks by anonymous or fake sources, and require sites to remove libelous comments within 12 hours unless they identify the author.


monday >

The Good Wife Looks for the Next Snowden and Outwits the NSA

Even as the real Edward Snowden faces questions over his motives in Russia, another side of his legacy played out for the over nine million viewers of last night's The Good Wife, which concluded its season long storyline exploring NSA surveillance. In the episode titled All Tapped Out, one young NSA worker's legal concerns lead him to becoming a whistle-blower, setting off a chain of events that allows the main character, lawyer Alicia Florrick (Julianna Margulies), and her husband, Illinois Governor Peter Florrick (Chris Noth), to turn the tables on the NSA using its own methods. GO

The Expanding Reach of China's Crowdsourced Environmental Monitoring Site, Danger Maps

Last week billionaire businessman Jack Ma, founder of the e-commerce company Alibaba, appealed to his “500 million-strong army” of consumers to help monitor water quality in China. Inexpensive testing kits sold through his company can be used to measure pH, phosphates, ammonia, and heavy metal levels, and then the data can be uploaded via smartphone to the environmental monitoring site Danger Maps. Although the initiative will push the Chinese authorities' tolerance for civic engagement and activism, Ethan Zuckerman has high hopes for “monitorial citizenship” in China.


The 13 Worst Bits of Russia's Current and Maybe Future Internet Legislation

It appears that Russia is on the brink of passing still more repressive Internet regulations. A new telecommunications bill that would require popular blogs—those with 3,000 or more visits a day—to join a government registry and conform to government-mandated standards is expected to pass this week. What follows is a list of the worst bits of both proposed and existing Russian Internet law. Let us know in the comments or on Twitter if we missed anything.