MoneyPolitics now online: Surf on!

TODAY, World Press Freedom Day, PCIJ welcomes you all to MoneyPolitics.PCIJ.org, a citizen’s resource, research, and analysis tool on elections, public funds, and governance in the Philippines.

MoneyPolitics, the boldest venture yet of PCIJ into the realm of the unknown and the intractable — big data, open data, and data journalism — started with a simple dream.

Few big, serial donors betting on poll bets since ’98
Check out our latest report on MoneyPolitics Online!

The pool of donors of the national candidates in the Philippines remains an exclusive club of a few big donors who come from old elite families, big business entities, affluent law firms, and even some parties who have secured contracts and appointive positions with the government, a PCIJ review of public records on the last five elections reveals.

Even fewer still are the repeat donors and families of donors who may be called the frequent spenders or high rollers in national elections since 1998.

In contrast, the number of citizens donating small amounts to the candidates — either out of faith in the politics or policies that the latter espouse, or for benign or self-serving reasons — remains negligible.

Five years ago PCIJ had wished: Could we build an online platform of all the stories, source documents, and data files, the vertical and the horizontal, in hard and soft copies, and from both public and private sources, that the PCIJ has amassed through the years?

Could we develop a more layered, more interactive, more current i-site.ph, one bigger by depth and breadth of source documents, and with relevant hyper local data on all our towns and cities?

Could we put in an online databank all the editorial, research, training, and multimedia portfolio of the PCIJ and offer it as possibly a good journalistic record of politics and governance since 1989, the year PCIJ was born?

And so, as is usual with the PCIJ’s multitude of 11 staff personnel, we set down to hard work.

Step 1 involved auditing and organizing our content so we know what we could upload, and by what order of priority.

Step 2 led us to long hours of scanning, digitizing, and aggregating our content by time period, format, source, and policy focus.

Step 3 prompted us to acquire more source documents to bridge gaps in data. That meant repeated visits to and multiple requests filed with many public agencies so they would to give us more documents.

Step 4 entailed encoding and repurposing raw source documents into datasets in excel or spreadsheet formats that allow analysis, sorting, and stringing up with other datasets.

Step 5 required the entry of tech and platform architects who could help scrape, script, and render the datasets in an online platform.

Our initial harvest, of which only a small portion is now uploaded on MoneyPolitics, is a massive cache of documents — 57 gigabytes of unique datasets on about 6,500 public officials, and on public finance, governance, and elections, dating as far back as 1998.

Many more steps later, MoneyPolitics is now online. It is a project that has tested the limits of our patience and skills, and in the case of some staff members, put on hold or on second priority, relationships with lovers and loved ones; or in the case of one, the search for a boyfriend; and for another, plans to have a baby.

MoneyPolitics is not the story of the PCIJ, however. It is the story of Philippine government and politics, in the last two decades told in data, digits, and documents.

It is big data on an online platform that the PCIJ hopes could serve all citizens a resource, research, and analysis tool.

It is an online tracker, roadmap, and virtual archive of the public records most vital to promoting transparency, accountability, and integrity in government.

Just as important, PCIJ built MoneyPolitics to promote the Filipino citizen’s right to information and meaningful participation in governance.

MoneyPolitics connects the dots, loops in the stats, and the backward and the forward links, of stories that form the core of PCIJ’s work — how government spends public funds; the wealth of elective and appointive officials; campaign finance and elections; public contracts and contractors; politics and political families; and progress and regress in the national household. In gist, how money drives and defines policy and governance in the country.

Why is PCIJ so hinged on data and documents, you might ask.

In truth, PCIJ is obsessed with them because we believe they could help foster a few public goals we deem important for good journalism, good citizenship, and good governance to take firm root.

The first is numeracy. We like to boast that the literacy rate of Filipinos — simple, not functional, literacy — is among the highest in the world.

Many of us are not as numerate, however. We generally scorn or stay away from numbers. We write stories swimming in sound bytes and with just a dab of context data. A majority of us journalists would readily admit that we went into J school because it requires only one Math class, or sometimes none at all

But the most critical issues that impede good governance and development in the Philippines are issues writ large in numbers. Through MoneyPolitics, PCIJ hopes to vest numbers with more value and meaning when we write about our people.

The second goal we wish to promote is good recordkeeping in all our public agencies. Good recordkeeping, it is said, is a pillar of good governance. MoneyPolitics afforded us ground-level interaction with the people and agencies holding public records, and from these, a few observations have emerged.

Some public agencies are better and smarter at keeping records, and more open about sharing these on request of the media. Some public agencies have tons of time-series datasets kept up to date but other public agencies are not even aware these exist.

Archiving, organizing, updating, and sharing data between and among public agencies, and with the citizens and the media — these open government practices have few excellent practitioners for now.

While some national agencies deserve good marks for voluntarily uploading documents online, these are typically in html, PDF or flat, and thus unsearchable or unconnected, formats. They overwhelm citizens with numbers often bereft of meaning, or hardly given to sorting and analysis. In most other agencies, however, especially those on the regional and local levels, getting documents is an activity akin to pulling molars from a toothless tiger.

PCIJ developed MoneyPolitics to serve the personal need for data of individual citizens and journalists, but not the commercial purposes of corporate and other entities. (Please read Terms of Use).

Just as important, MoneyPolitics does not intend to replace the work of government or strip its agencies of their mandate and duty in law to uphold transparency and to respect the people’s right to know.

To be sure, MoneyPolitics is a project with many conspirators.

They include all the writers, editors, researchers, fellows, and support staff who had served with PCIJ from its birth in 1989.

PCIJ could not acknowledge enough the work of its founding executive director, Sheila S. Coronel (now director of the Tony Stabille Center for Investigative Reporting at Columbia University in New York); the late Alecks Pabico, PCIJ’s “self-taught” and first multimedia director; former PCIJ deputy executive director Jaileen Jimeno and former PCIJ librarian Ogie Sarmiento, who took the first steps in building the PCIJ digital library; and Cecile C. A. Balgos, whose razor-sharp pen never fails to lend polish to PCIJ’s editorial work.

PCIJ’s current team works hard and well precisely to deserve their legacy. Through MoneyPolitics, we wish to honor their work.

Credit for what MoneyPolitics is today goes singly and together to Karol Ilagan, PCIJ research director; Markku Seguerra, PCIJ platform architect; Rowena Caronan, PCIJ researcher-writer; Ed Lingao, PCIJ multimedia director; Miguel Gamara, PCIJ librarian; Fernando Cabigao Jr., PCIJ researcher-writer; and Charmaine Manay and Rosemarie Corpin, PCIJ part-time researchers.

MoneyPolitics would not have been born without the appropriate provisions budgeted by PCIJ admin manager Dona Lopez and her deputy, Yoly Nicolas.

The work of our training and writing fellows continues to inform MoneyPolitics. In turn, MoneyPolitics could further inform the seminar-workshops that PCIJ conducts through its training director Che de los Reyes, and her deputy, Edz de la Cruz.

PCIJ multimedia producer Cong Corrales and his partner Ed Lingao have also produced a video documentary on the making of MoneyPolitics.

Most important of all, PCIJ would like to thank the Open Society Foundations (OSF) for believing in our dream, and for being gracious enough to help make it happen. In 2011, the OSF extended a $100,000-grant across three years for PCIJ to develop MoneyPolitics, the online resource tool.

What next? MoneyPolitics is a work in progress. We are proceeding on to Stages 2 and 3 to assure a steady fresh harvest of data sets, full profiles of local elective officials, and more hyper local content on all the provinces, towns, and cities of the Philippines.

A demand-driven access to information initiative, an experiment in ground-up development of an online database of public records, a data journalism project — that is PCIJ’s MoneyPolitics Online.

We hope to share the experience and help replicate it in public agencies that are repositories of documents, in agencies vested with integrity and good governance mandates, and among civil society groups or schools with advocacies and practice hinged on data and documents.

A fuller, deeper MoneyPolitics 2.0 or even 3.0 in 2016? We could not stop dreaming of better things to come. Please help us make it happen again.

For now, happy surfing, everyone!

Take a quiz, journey back in time

TAKE a quick quiz and trace the steps we took as a nation.

Data in chunks are among the featured content of MoneyPolitics, a citizen’s information, research, and analysis tool on elections, public funds, and governance in the Philippines.

A data journalism project of the PCIJ, MoneyPolitics promotes twin goals: uphold the citizen’s right to know and to access documents in the custody of public agencies, and help foster transparency and accountability in government.

Anytime soon, MoneyPolitics will go online.

But first, take a QUICK QUIZ from MoneyPolitics:

Question: Who is the longest serving member of the Senate since the 1986 EDSA People Power Revolt?

a. Joker P. Arroyo
b. Edgardo J. Angara
c. Juan Ponce Enrile
d. Franklin M. Drilon

Answer: b
Senator Edgardo J. Angara is the longest serving senator in the post-EDSA Senate. He has been elected to four six-year terms. In 1998, he ran for vice president but lost.

Or, retrace the past in TRACKBACK:

Question: What do Elpidio R. Quirino, Ramon F. Magsaysay, Carlos P. Garcia, Diosdado P. Macapagal, and Ferdinand E. Marcos all have in common?

Answer: All five were elected in the month of November. From 1947 to 1971 — after the recognition of Philippine independence and before the proclamation of Martial Law — Filipinos voted on the second Tuesday of November of the election year.

The 1973 Constitution ruled, however, that the regular election of members of the national assembly was to be held on the second Monday of May. But it was only after the 1986 EDSA People Power Revolt when general elections started to be held on the second Monday of May. It continued on in the 1987 Constitution.

‘A Data A Day’ could help keep the crooks away…

MASTER OUR DATA, master our story as a people.

This is the spirit behind MoneyPolitics.PCIJ.org, a citizen’s online resource, research, and analysis tool on elections, public funds, and governance in the Philippines.

A project of the Philippine Center for Investigative Journalism, MoneyPolitics enrolls over three gigabytes (of the 57 GB now in the PCIJ Library) of unique files on the asset records, career history, and social networks of elective and appointive officials; public finance records (budget, pork barrel, etc), and election and socio-economic statistics for the provinces, towns, and cities of the Philippines.

You better not miss it: With a few more nips and tucks, MoneyPolitics will go online in a while.

But first, we introduce you to bite sizes of information that we could discern from the big data that MoneyPolitics offers — A Data A Day.

In gist, the meaning of the numbers.

A Data A Day is possibly good for body, mind, and soul.

A Data A Day could help grow better informed and thus, more empowered, citizens.

A Data A Day promotes our right to know and to access documents in the custody of public agencies.

Most important of all — we hope and pray — because voters would know better than politicians, A Data A Day could help keep the crooks away.

Here’s today’s A Data A Day (BY THE NUMBERS):

53

Fifty-three is the mean age of the candidates running for senator in the May 13, 2013 elections.

Who are the youngest and oldest?

The youngest are Greco B. Belgica of the Democratic Party of the Philippines, who will turn 35 years old, and Paolo Benigno ‘Bam’ A. Aquino IV, who will be 36 before the day of the vote.

Samson S. Alcantara of the Social Justice Society and Ernesto M. Maceda of the United Nationalist Alliance, are the oldest. Both are 77 years old.

The average age of the 23 incumbent senators, meanwhile, is 59. But re-electionist senators Antonio F. Trillanes IV (41) and Alan Peter S. Cayetano (42) are the youngest. They are the only two of the 23 senators who were born in the 1970s.

Senators Joker P. Arroyo (86) and Juan Ponce Enrile (89) are the oldest. They are also the only two born in the 1920s. — Reference: 2013 senatorial candidates’ Certificates of Candidacy, Commission on Elections

And another…

11

Only 11 of the 33 candidates for senator in the May 2013 elections were born outside Metro Manila.

They are Samson S. Alcantara of Abra, Teodoro ‘Teddy’ A. Casino of Davao City, Baldomero C. Falcone of Leyte, Richard ‘Dick’ J. Gordon of Zambales, Gregorio ‘Gringo’ B. Honasan II of Benguet, Marwil N. Llasos of Albay, Ernesto ‘Ernie’ M. Maceda of Laguna, Ramon E. Montaño of Cebu City, Aquilino Martin ‘Koko’ L. Pimentel III of Misamis Oriental, Mary Grace Poe-Llamanzares of Iloilo, and Eduardo ‘Eddie’ C. Villanueva of Bocaue, Bulacan.

The remaining 23 were all born in Metro Manila, according to the Certificates of Candidacy they filed with the Commission on Elections.

Less than half or 10 of the 23 incumbent senators were born outside Metro Manila.

They are Senators Edgardo J. Angara of Aurora, Joker P. Arroyo of Naga, Franklin M. Drilon of Iloilo, Juan Ponce Enrile of Cagayan, Gregorio B. Honasan II of Baguio, Panfilo M. Lacson of Cavite, Manuel M. Lapid of Pampanga, Aquilino Martin L. Pimentel III of Cagayan de Oro City, and Miriam D. Santiago of Iloilo. Senator Pilar Juliana S. Cayetano was born in Michigan, USA.

PCIJ launches MoneyPolitics online

screenshot_182

THE PHILIPPINE CENTER FOR INVESTIGATIVE JOURNALISM (PCIJ) is proud to announce the launch of its MoneyPolitics website, a new rich database meant to enable citizens with an online resource, research, and analysis tool on elections, public funds, and governance in the Philippines.

The website, MoneyPolitics.PCIJ.org, was developed with a three-year grant from the Open Society Foundation (OSF). It will go online next week.

The site aggregates the cache of documents and databases that the PCIJ has amassed in its 24-year existence on public finance records; statements of assets, liabilities, and net worth (SALN); election spending reports; civil works contracts; graft and corruption cases; profiles of elective and appointive officials; data on elections and political families; and socio-economic statistics across the Philippines.

211_6941

PCIJ’s Malou Mangahas explains the concept behind the Money Politics site

MoneyPolitics is designed to serve as a ready-to-access tool for citizens, journalists, civil society groups, policy analysts, scholars, and public agencies and regulators. The site links and loops information enrolled in public documents to allow readers to discern how money in politics drives and defines policy and governance in the country.

PCIJ Executive Director Malou Mangahas said that the PCIJ Library has 57 gigabytes of digital information, with more than 6,400 unique files on elective and appointive officials from mayor to the Presidents, dating to as far back as 1998.

The 57 gigabytes of digital files of the PCIJ represent just a small portion of the total cache of raw source documents that the PCIJ has collected in the course of the work on investigative reports, books, video documentaries, and training seminars by its writers, editors, researchers, and fellows.

Using the OSF grant, the PCIJ in 2011 started digitizing, aggregating, and organizing datasets for MoneyPolitics using as backbone the cache of documents that it has gathered from its birth in 1989.

More public documents were acquired to bridge the gaps in data, as well as to collect information on local elective officials and appointive officials from the other branches.

Some of the files featured in MoneyPolitics come from documents that are no longer publicly available, or had been lost over the years.

Some election spending reports, for example, had been burned in the fire that gutted the old office of the Commission on Elections in Intramuros, Manila, years ago. However, the PCIJ had managed to keep copies of these files in its library.

A work in progress, MoneyPolitics will feature a steady harvest of new and more datasets in the coming years, or in time for the synchronized national and local elections in 2016.

PCIJ Research Director Karol Ilagan said MoneyPolitcs features four content categories.

Public Profiles offers information on elective and appointed officials  from mayors, vice mayors, and councilors on the local level, up to President and Vice President, as well as from the judiciary, the constitutional commissions, the armed services, and some government-owned and -controlled corporations.

The datasets include time-series information on the career, wealth, and election donors and expenditures of public officials.

Also featured under this tab is the Social Network of the official, or data on his/her business interests and financial connections, family ties, and election donors.

A page under the Public Profiles tab is Public Spending, which focuses on pork barrel releases and disbursement by the senators and congressmen, and internal revenue allotment for the local government officials.

Campaign Finance, the second tab, uploads the statements of election contributions and expenditures (SECE) that elective officials had submitted to the Commission on Elections since 1998. This tab will allow the public a peek into how much officials spend just to bag their positions in government.

The third tab, Public Funds, presents information on how government raises revenues and spends public funds. These include data on the yearly budgets, allocations by departments, lump-sum items in the national budget such as special purpose funds and pork barrel allocations.

The fourth tab, Elections and Governance, offers data on governance indicators, political clans, and elections and socio-economic statistics for provinces, towns, and cities of the country.

Ilagan added that the PCIJ would also like to encourage the public to be more proactive by donating or uploading documents, especially on the local level.

PCIJ Researcher Rowena Caronan said development work on MoneyPolitics involved months of haunting the halls of the Commission on Elections, Office of the President, the Office of the Ombudsman, among many other public agencies that are repositories of documents, to request and photocopy official records.

At times, Caronan said, the PCIJ staff had to spend entire weeks just photocopying documents. This, however, was only the first step. The PCIJ have had to scan, digitize, organize, and aggregate the data enrolled in the documents in Excel, spreadsheet, CSV, and other formats to allow for sorting and analysis as datasets.

Interestingly, Caronan also gave everyone an idea of just how inaccessible some public documents are to the public, not just because of a culture of secrecy in some agencies but also because of the prohibitive costs of reproducing the documents.

For example, Caronan said the Office of the President charges five pesos per photocopied page, while the Civil Service Commission charges P30 per page. In some other agencies though, she said public records are available online and at no cost at all on requesting parties.

The PCIJ also had to do scraping and scripting of the data available on government websites to develop some of the pages of MoneyPolitics.