You are browsing the archive for Uncategorized.

Public Procurement Data in the Philippines and Where to Find It

- March 6, 2019 in Fellowship, Reflections From The Field, Uncategorized

Ben Hur Pintor, our fellow from the class of 2018, here shares his thoughts and research on public procurement data in the Philippines.

During the selection process for the 2018 School of Data Fellowship here in the Philippines, I was informed that the selected Fellow will be working with data related to public procurement. As I wasn’t a public procurement expert, I did a little research on the topic. Here, I’d like to share some of the interesting observations that I noticed:

Public Procurement Data in the Philippines

In theory, we expect public procurement in the Philippines to produce a lot of data considering how the process is defined by RA 9184 or the Government Procurement Reform Act.

Under the law, public procurement includes all “acquisition of Goods, Consulting Services, and the contracting for Infrastructure Projects by any branch, department, office, agency, or instrumentality of the government” including procurement for projects that are wholly or partly funded by Foreign Loans or Grants pursuant to a Treaty or International or Executive Agreement unless different procurement procedures and guidelines are expressly stated or if the foreign loan and grant is classified as Official Development Assistance (ODA) under RA 8182 or the Official Development Assistance Act.

From this definition alone, we can see that almost all government spending falls under public procurement and, thus, it is logical to assume that whenever the government spends, public procurement data should be produced.

Aside from the definition of public procurement, the law also provides, as a general rule, that all procurement shall undergo Competitive Bidding except for specific cases when Alternative Methods of Procurement such as Limited Source Bidding, Direct Contracting, Repeat Order, Shopping, and Negotiated Procurement are allowed. These specific cases are subject to the prior approval of the Head of the Procuring Entity (HOPE) and should be justified by the conditions provided by the Act.

Most of the time, Competitive Bidding which has the following steps — advertisement, pre-bid conference, eligibility screening of prospective bidders, receipt and opening of bids, evaluation of bids, post-qualification, and award of contract — is followed.

Steps in Public Procurement by Competitive Bidding

Each step in the public procurement process produces its own data — bid posts, pre-procurement and pre-bid conference proceedings, submitted bids, winning bids, information on the bidders, and the awarded contracts to name a few. There are also monitoring and evaluation documents and reports that are regularly created during the implementation of a government project and even after its completion.

So with all this public procurement data supposedly being produced, where can it be found?

Where to Find It

The Government Procurement Reform Act or RA 9184 enacted in 2003 is the comprehensive law governing public procurement in the Philippines that put together all procurement rules and procedures covering all forms of government purchases from goods, to consulting, to infrastructure services. It sought to address the complexity and vagueness of public procurement and its susceptibility to abuse and corruption due to multiple procurement laws by simplifying and standardizing the procedures with a focus on transparency and accountability.

The law added two interesting features to ensure transparency and accountability:

  1. the creation of an electronic portal which shall serve as the primary and definitive source of information on government procurement (PhilGEPS); and
  2. the establishment of the Government Procurement Policy Board (GPPB).

The PhilGEPS (Philippine Government Electronic Procurement System) is the country’s single, centralized electronic portal that serves as the primary and definitive source of information on government procurement. Government agencies, as well as suppliers, contractors, manufacturers, distributors and consultants, are mandated to register and use the system in the conduct of procurement of goods, civil works, and consulting services.

On the website, the government can publish what goods, consulting services, and civil works projects it needs while suppliers, private contractors, and companies can search and view  these procurement opportunities. It features an Electronic Bulletin Board where all procurement opportunities, results of bidding, and related information are posted; a Registry of Manufacturers, Suppliers, Distributors, Contractors and Consultants; and an Electronic Catalogue of common and non-common use goods, supplies, materials and equipment. When fully implemented, the system is also intended have a Virtual Store, Electronic Payment System, and Electronic Bid Submission. The system is managed by the Procurement Service of the Department of Budget and Management.

The PhilGEPS website (version 1.5)

PhilGEPS also releases public procurement data published by different government agencies as mandated by the Government Procurement Reform Act together with other infographics and reports.

Some datasets available in PhilGEPS

 

Standard Reports and Datasets

 

Sample data (Number of Registered Organizations per Year)

Reports, Notices, and Infographics

 

The GPPB, as established by the Government Procurement Reform Act, is an independent inter-agency body with private sector representation envisioned as the policy making entity and the governing body overseeing the implementation of procurement reform in the country. Its objectives include the preparation of a generic procurement manual and standard bidding forms for procurement; establishing a sustainable training program to develop the capacity of Government procurement officers and employees; and ensuring the conduct of regular procurement training programs by the procuring entities.

It also stores and displays public procurement data submitted to it by procuring entities and regulatory bodies. These include information on Annual Procurement Plans, Procurement Monitoring Reports, List of Blacklisted Suppliers and Constructors, Constructors Performance Evaluation Summaries, Pre-Selected Suppliers and Consultants, List of Observers, and Status of Protests.

GPPB Website and Monitoring Data

Sample data (PDF format)

Aside from the PhilGEPS and GPPB, the different government agencies also publish procurement records on their respective websites in compliance with National Budget Circular No. 542. This Circular is more commonly known in the Philippines as the Transparency Seal Circular because it directs government agencies to have a Transparency Seal visible on their websites where the public can access information related to their agency.

Some of the data that the circular requires to be released are: annual reports, approved budget and corresponding targets, major programs and projects, program and project beneficiaries, status of implementation and program/project evaluation and/or assessment reports, annual procurement plans, contracts awarded, and the name of contractors/suppliers/consultants.

For example, the Department of Public Works and Highways has a Civil Works page on their website that shows key documents related to the public procurement of civil works projects.

DPWH Civil Works page

Is it Enough?

As highlighted by the Philippine Center for Investigative Journalism (PCIJ) on their report “Public Contracting in the Philippines: Breakthroughs and Barriers” about the infrastructure projects of the Department of Public Works and Highways (DPWH), there are challenges in terms of the completeness and accessibility of public procurement data in the country. Tracking the process from planning to implementation is difficult because not all the documents related to the procurement of infrastructure projects are published. This is compounded by the weak organization of files in agency websites which can confuse those unfamiliar with the procurement process. For example, even though the different documents related to one infrastructure project are available in the DPWH site, they are located on different web pages and are not linked to one another thus preventing users from easily understanding how documents might connect to each other. Aside from this, even though PhilGEPS and the GPPB are good sources of public procurement data, they are only repositories and are dependent on the data submitted to them by procuring entities. This becomes problematic when the procuring entities themselves fail or even refuse to submit their data.

Another important thing I noticed about public procurement data in the Philippines is this: Publishing public procurement data in machine-readable formats is not (yet) the norm in the Philippines. If you look at the Government Procurement Reform Act, there is no mention about releasing or publishing procurement data and documents in machine-readable formats. The training programs by the GPPB designed to develop the capacity of procurement officers and employees for both the private sector and the national government agencies, government-owned and controlled corporations, etc do not include parts on working with or publishing machine-readable data. As a result, procuring entities and agencies release data without considering the implications of the format they are releasing it in.

In fact, aside from those found in PhilGEPS, most of the public procurement data in the country are in non-machine-readable formats — as PDFs, documents, or even scanned images. Now, the procuring entities releasing the data might not consider this as a problem since compliance with the law only requires them to release the data but from the point of view of a data practitioner analysing public procurement data, a civil society organization creating visualizations in support of its advocacy, a journalist investigating government infrastructure projects, or even just a citizen trying to look for possible evidence of corruption in the procurement process, this adds a lot of extra steps to convert and standardize the data before any meaningful work can be done on it. Steps that could have been skipped had the data been released in a machine-readable format such as a spreadsheet, a comma-separated value  (CSV) file, or JavaScript Object Notation (JSON) file.

One of the positive things pointed out by the PCIJ report was the opportunity to standardize, link, and publish more contracting data given by the current trend of government agencies creating or upgrading their information-management systems. This should be supported by efforts to raise awareness and convince the procuring entities, journalists, CSOs, and citizens of the benefits of releasing machine-readable data.

Public procurement data should not be released just for the sake of releasing it. It should be released for the purpose of ensuring transparency, accountability, and equitability in the procurement process. To do this, it is imperative that the documents and information for each step in the procurement process, from planning to implementation, should be released in an open, transparent, and timely manner. Public procurement data should also serve the purpose of encouraging citizens, individuals, and organizations to keep themselves informed and engaged in how public money is spent. Towards this end, it is important to release data in formats such as spreadsheets, CSV, or JSON that make it easier for stakeholders to analyse, share, and re-use the data. One of the ways to ensure that data is easily shareable, analysable, and reusable is by following a standard like the Open Contracting Data Standard (OCDS). Of course, simply following a standard is not enough and could even be counterproductive when done without the right preparation. It is equally important to study how a standard complements the process and how it can be integrated with the current system.

Sources

Civil Works – Department of Public Works and Highways. http://www.dpwh.gov.ph/dpwh/business/procurement/civil_works/awarded_contracts

Open Contracting Data Standard. Open Contracting Partnership. http://standard.open-contracting.org/latest/en/

Philippine Transparency Seal – Department of Budget and Management. https://www.dbm.gov.ph/index.php/about-us/philippine-transparency-seal

Public Contracting in the Philippines: Breakthroughs and Barriers. Philippine Center for Investigative Journalism (PCIJ) with support from Hivos and Article 19. http://pcij.org/wp-content/uploads/2018/01/PCIJ.-Open-Contracting-in-Philippines-Report_01102018_b.pdf

RA 9184 (Government Procurement Reform Act). https://www.gppb.gov.ph/laws/laws/RA_9184.pdf

The 2016 Revised Implementing Rules and Regulations of RA 9184. https://www.gppb.gov.ph/laws/laws/RevisedIRR.RA9184.pdf

The Government Procurement Policy Board. https://www.gppb.gov.ph/

The Philippine Government Electronic Procurement System. https://www.philgeps.gov.ph/

The Procurement Service. http://main.ps-philgeps.gov.ph/

 

Flattr this!

2018 Fellowship – Deadline Extension for Indonesia

- May 10, 2018 in Uncategorized

Note: the application window is now closed!

We have been made aware that a lot of the potential applicants in Indonesia weren’t aware of the Fellowship opportunity. Consequently we’re extending the application deadline for Indonesia only for one week, until Wednesday May 17th, GMT+0.

Apply now

As a reminder, the Fellowship in Indonesia will be focused on public procurement data through the Open Contracting Programme. For this position, School of Data is looking for someone with: experience with delivering technical and data-driven projects, experience with facilitating training activities and ideally experience with working with government systems or data.

Candidates with the following optional interests and experience will be appreciated: experience with explaining complex topics to varied audiences, experience with user design methodologies, experience with community development

Don’t miss your chance and apply now!

Flattr this!

How do you become data literate? Part 2

- May 29, 2017 in Uncategorized

What does it mean to become ‘data literate’? Where do you start and how can you use data within your work and projects? To explore these questions, we would like to introduce some of our community members and data activists from around the world, who ended up working with data at some point in their lives. We were curious about how they actually got started and – looking back now – what they would recommend to data newbies.

Each month we will publish a new interview, this is no. #2. Got feedback? Have questions? Feel free to get in touch: [email protected]

Oludotun Babayemi

Co-founder of Connected Development, Follow The Money Nigeria, data trainer at School of Data, from Nigeria

Topics: government spending, international aid, rural communities

Tweets: @dotunbabayemi

 

Introduce yourself.

My name is Oludotun Babayemi and I was a School of Data fellow in 2014. I co-founded an NGO called Connected Development in Nigeria three years ago and I run the project “Follow the Money”.

What topics and projects are you currently working on?

Well, I have a background in information management. And for the past nine years I’ve been involved in monitoring and evaluation of government programs, policies and projects, through multilateral and bilateral agencies. Data is getting more and more relevant in the non-profit sector and in the projects I run, which is called Follow the Money, that started in 2012. To follow the money we needed financial data, budget data and also we needed to look for baseline indicators of our target communities. Follow the Money tracks funds that are meant for capital projects and rural communities in the area of health, education and environment. So for us to make decisions on communities we want to create stories from, we needed these datasets. Data remains the core of our work. It became very important for us to leverage on data. For sustainability reasons as well, we needed to create a community of citizens who know how to use data. We have been offering trainings since 2013 to enhance data literacy skills in Nigeria to journalists and activists interested in the social sector. For every training that we ran we got great feedback and this showed us, that many people want to become data savvy. Data literacy helps us to get more people involved in our transparency project.

When was the first time you came across data and when did you start to use data in your work?

My story with data didn’t just start now. My mum is a teacher and when I was  8 years old, we used to compile result sheets of her student’s tests. Everytime she came home, she would give me spreadsheets on student’s test paper and ask me do to subtractions, additions, multiplications of the student’s results. So I was making remarks on their papers and would help in compiling the weighted average that determines their position. We would do this at the end of each term and I was helping her out on the spreadsheets. I started relating to data since then and that’s like 20 years ago.

How would you explain data literacy?

Data literacy is about empowering citizens on the use of data. That’s what it means to us. There is a lot of data available, but most people do not know, how to relate to it or how data does resonate with them. So it is our duty to connect the dots with them, to let them know, where they can find data and what they can use it for. You can use it to educate yourself, to create compelling stories and also to do effective advocacy. When you have the data and you know what the data is about, we say it is an evidence and with that evidence you can ask the right questions. So we say evidence is power.

What would you recommend to someone interested in data, but who does not know where to start?

If you want to start relating to data, I think it’s nice to find a community around you that works with data. There are also several Open Knowledge organisations in different countries you can join and be part of. One is working on Datenschule and there is schoolofdata.org also, so this should be one place to look out for. If you are in Africa, you can join the community of citizens holding their government accountable via the ifollowthemoney platform. This would at least encourage you and get you ready to start working with data.

Links:

Connected Development’s Work

Follow the Money Nigeria

ifollowthemoney

Flattr this!

Research Results Part 6: Data Literacy Research References and Resources

- February 11, 2016 in Uncategorized

Even though work in the field of data literacy can feel a bit lonely at times, truth is it is not entirely new and undocumented. During the research process that has been described over these blog posts, we have been lucky to come across valuable sources of information on the topic – researchers and practitioners have devoted writing time to data literacy in civil society and in academia.

To close off the blog posts sharing our main findings, we found it suitable to share a bit of information about the resources that informed the process.

A quick dive into the history of data literacy

Even though data literacy efforts in civil society might seem recent, they fit into a much longer history of numeracy, statistical literacy (and, of course, literacy in general). When looking into the broader literature, we found articles devoting time to narrow and define this field, especially as compared to others. We recommend taking a look at:

For a shorter (but comprehensive) account of broader research in this field, we found Data Pop Alliance’s Beyond Data Literacy: Reinventing Community Engagement and Empowerment in the Age of Data to be illuminating.

The origins of School of Data

If you were around in School of Data in 2012, the information in tis section might be redundant for you… but many of the newer School of Data community members haven’t had the chance to learn how it all started.

We also want to point out to Sam Leon’s blog post talking about his embedded fellowship in Global Witness – one of School of Data’s first experiments with longer term processes.

Academic research meets data literacy work

Data literacy training efforts in civil society are similar to some of those documented by academic researchers, and that’s why we decided to take a look at how they are being discussed in the literature. Sources that we recommend:

Data literacy in civil society

Perhaps not in journal articles, but civil society organizations and individuals around the world have also devoted efforts to the documentation of their work in the field. Some of the highlights:

Thank you for participating and following the data literacy research process we underwent! Our blog post series has now been completed and we encourage you to take a look at it. If you want to send feedback or get in touch, please do so at dataliteracy [at] fabriders.net.

Flattr this!

Improve Your Data Literacy: 16 Blogs to Follow in 2016

- January 22, 2016 in Uncategorized

Learning data literacy is a never-ending process. Going to workshops and hands-on practice are important, but to really become acquainted with the “culture” of data literacy, you’ll have to do a lot of reading. Don’t worry, we’ve got your back: below is a curated list of 16 blogs to follow in 2016 if you want to: improve your data-visualisation skills; see the best examples of data journalism; discover the methodology behind the best data-driven projects; and pick-up some essential tips for working with data.

Using Feedly as your RSS Reader? Check out our shared collection which includes the blogs mentioned below plus other blogs!

#Datavisualisation

Data Viz Done Right

This website, by Andy Kriebel, curates good examples of dataviz around the web, highlighting what was great, and also what could have been done better. Each post is quick and easy to read, and they add up to form a set of good practices to keep in mind when doing a data-visualisation.

Website link: http://www.datavizdoneright.com/

Frequency: 1 article/week

Flowing Data

Flowing Data is Nathan Yau’s full-time job, and it shows. Regularly updated with great original or curated content about data-visualisation, this blog is a good way to keep track of the major trends and events in the field. Other sections of the website feature tutorials for purchase and guides.

Website link: http://flowingdata.com

Twitter: @flowingdata

Frequency: 9 articles/week

Google Maps Mania

Do you like maps? Everybody likes maps. Managed by map-addict Keir Clarke for more than 10 years, this blog is the go-to resource for following the development of digital cartography. Don’t be fooled by the name, all digital maps are featured, not only Google ones.

Website link: http://googlemapsmania.blogspot.co.za/

Twitter: @gmapsmania

Frequency: 24 articles/week

Junk Charts

Prominent data-visualisation expert Kaiser Fung set out to become the web’s first data-visualisation critic. The result is a website which regularly deconstructs dataviz work, even from top publications, often proposing an alternative visualisation. The articles on Junk Charts regularly make ripples through the web, attracting praise, criticism, but most importantly, prompting discussion.

Website link: http://junkcharts.typepad.com/

Twitter: @junkcharts

Frequency: 2 articles/week

Visual Loop

Visual Loop is the ultimate datavisualisation web repository. Founded as simple blog in 2010 by Tiago Veloso, it grew to become the most active and up-to-date curation space for datavisualisation, in all formats. Featuring interviews with designers along with event announcements, this is the blog to follow to get inspiration.

Website link: http://visualoop.com/

Twitter: @visualoop

Frequency: 3 articles/week

#Data In the News

FiveThirtyEight

Rather than simply having data journalists, FiveThirtyEight is data journalism. Founded by Nate Silver, a renowned statistician who reached stardom after predicting the 2008 and 2012 elections while blogging for the New York Times, FiveThirtyEight represents the boldest attempt to do pure data journalism. It works remarkably well, and is an inspiration for all data journalists, seasoned and aspiring ones alike.

Website link: https://fivethirtyeight.com/

Twitter: @FiveThirtyEight

Frequency: 40 articles/week

NYT – The Upshot

Website link: http://www.nytimes.com/upshot/

Twitter: @UpshotNYT

Frequency: 21 articles/week

After the departure of Nate Silver, the New York Times decided to aim even higher by starting The Upshot, a data journalism corner dedicated to politics, policy and economic analysis. It’s an ambitious and high-quality take on data journalism, with approachable articles on social issues (politics, nutrition…) mixed with innovative interactive data-visualisations.

Washington Post Information Graphics

The Washing Post Information Graphics blog is an unadulterated look at the data journalism articles produced by the « WaPo ». It is not only a great source of inspiration for anyone interested in dataviz, but a great source of quality articles, without all the fluff of the main website.

Website link: http://postgraphics.tumblr.com/

Twitter: @PostGraphics

Frequency: 4 articles/week

Understanding Uncertainty

David Spiegelhalter is the maestro behind this ever-useful website, which regularly takes on news articles (but not exclusively) which make a bad job of reporting on the risk/probability/chance of something happening. It is a great read to cut through sensationalist claims, as well as a source of examples on how to deal with uncertainty in reporting.

Website link: http://understandinguncertainty.org/

Frequency: Less than 1 article/week

Global Journalism Investigative Network

The GJIN, as a whole, is an extensive resource for journalists, but their series of curated top 10 data journalism links of the week is a great way of tracking the « #ddj” articles or news that made the rounds on Twitter for any particular week.

Website link: http://gijn.org/series/top-10-data-journalism-links/

Twitter: @gijn

Frequency: 1 article/week

#Behind The Scenes

NPR Visuals Team Blog

A nerdier pick than the rest of the selection, the NPR Visual Teams blog is still an amazing place to see the methodology behind outstanding data journalism projects. Additionally, the NPR Team maintains several open source tools for data journalism which are described on the blog.

Website link: http://blog.apps.npr.org/

Twitter: @nprviz

Frequency: Less than 1 article/week

Source

No less nerdy than the NPR blog, the Source blog (a Mozilla/Open News project) is more varied in its content, thanks to regular blog posts by top data journalists from a wide variety of newsrooms. Alternating behind-the-scenes articles, guides, tutorials and event round-ups, this blog is a must-have in the RSS reader of every data journalist.

Website link: https://source.opennews.org

Twitter: @source

Frequency: 2 articles/week

Storybench

Storybench is a collaboration between the Media Innovation track at Northeastern University’s School of Journalism and Esquire magazine. A relative newcomer in the sphere of data journalism blogs, it features high quality articles, providing an « under the hood » look at examples of digital journalism, accompanied by interviews with the journalists who make them.

Website link: http://www.storybench.org/

Twitter: @storybench

Frequency: 2 articles/week

#Learning to work with Data

Chandoo

Data journalists love spreadsheets. And why wouldn’t they? They’re so flexible! Chandoo.org is the place to go if you want to maximise this potential flexibility, or just pick some nice tricks that will make your work faster. Chandon focuses on Excel, but thankfully most of the tricks of use to data journalists will be available in other, similar software.

Website link: http://chandoo.org/wp/

Twitter: @r1c1

Frequency: 2 articles/week

HelpMeViz

HelpMeViz’s tagline is « helping people with everyday data visualization ». Whilst submitting your dataviz issue to the community can be really helpful, the real value of the website is in the aggregation of all the posts, each representing a small dataviz challenge. If you ever wondered in how many ways you could tackle a data-visualisation problem, HelpMeViz is there for inspiration.

Website link: http://helpmeviz.com/

Twitter: @HelpMeViz

Frequency: Less than 1 article/week

Journalist’s Resource

The Journalist’s Resource tackles a niche aspect of data literacy: understanding research papers. Mixing regular round-ups of research around specific topics with quality guides about understanding research terms or working with numbers (check out their amazing tip sheets), this blog from the Shorenstein Center of Harvard Kennedy School is a resource all journalists (and especially North American ones) should follow.

Website link: http://journalistsresource.org/

Frequency: 6 articles/week

Do you believe that some obvious blogs are missing? Tweet them to us at @Schoolofdata or on Facebook. And check out our Feedly shared collection, which includes more than the blogs mentioned above!

Flattr this!

Data visualisation or Data narration? Data in Radio Stories

- January 18, 2016 in Uncategorized

For an outsider looking at Nigeria’s news media lately, it would seem that the only things in the mind of Nigerians are politics or security-related. Breaking news are aplenty while more involved stories, either investigative or reporting on community issues, are scarce.

This is a problem, but what can we do about it? Development Watch, an initiative by Journalist for Social Development Initiative, hopes to solve this problem. They have plans for a different kind of journalism, providing objective analysis of social development issues and promoting inclusive growth across Africa. And to live up to their goal of creating quality journalism, they decided to facilitate a data journalism session on November 30, 2015, at the occasion of the launch of the main part of their web platform.

Data Journalism AbujaMore than 20 journalists were present: 15 from the broadcast, 5 from the print and the others from the new media. Beyond Google Alerts, most of them had little knowledge of the useful tools for digital journalism, and even less about where to find available data in Nigeria. This was expected: we hear this from 80% of the participants to datajournalism trainings. Luckily, the point of those trainings is to familiarize them with the available tools and sources.

“To find data for my reports, I only depend on references from other works, or request a meeting with concerned organizations, as I do not know where to go to, I find this difficult for my work”  said Sam Adeko of Punch Newspapers.

 According to a recent poll by NOI Polls, a polling organisation in Nigeria, most people in the country access daily news via the radio (67%), followed by television, social media and newsprint. With this information in mind, we try to tailor our datajournalism trainings to take into account stories for radio and television, in addition to the use of tools like Infogr.am, essentially useful for print and social media.

But before talking about visualising data, we had to cover some basic techniques. In this training, as is the case in many other ones, 90% of the participants used Google search to look up information, but few of them really knew how to search effectively. For example, you can search for specific content on a website by adding ‘site:example.com’ to your search phrase, which will prompt Google to only return results from the site you’ve specified. You can even narrow it down further by using ‘site:example.com/pages/’, and you’ll only see results that match that pattern.

Another useful tool that was introduced was Google Trends, which allow to find which search terms are trending on Google. “I really want to know how much people are interested in President Muhammadu Buhari of Nigeria compared to the President of Rwanda, Paul Kagame. Especially in recent times, this can give me an insight on how important Nigeria is over Rwanda” explained Roluke Ogundele of the Africa Independent Television. All you need do is to enter a couple of common search phrases and you will get how this has been trending over time. We also talked about Twitter, a micro-blogging service that is becoming more widely used in Nigeria. To discover public conversations about a link, you just paste the URL you’re interested in into the search box, and then possibly hit ‘more tweets’ to see the full set of results.

When the datavisualisation session eventually came, we asked the question of whether to visualize or not, and how. Tools like Google Fusion Tables, Tableau, Dipity and others make it easier than ever to create maps, charts, graphs useful for newsprint, social media, and television. But what happens when you broadcast on the radio? Because people only listen, the need of getting a story out of the data, rather than just a visualisation, is more obvious. Stories can be told in a captivating way on radio, and they can come from data. “So if you are a broadcast journalist in the radio – you have no excuse, dive in by looking at the problem you want to solve first, via the radio (also works for other media), then find and get the data, and tell your story to the world” said Gloria Ogbaki of Ray Power FM

In Nigeria, data journalism is nascent, and opportunities abound. As more new journalists get into the field, thinking of which sector to dive into, there is a need for newsrooms to innovate by, for example, embedding data analysts and Information technology experts with producers of news.

As you can see, most of us never knew what data journalism is, but at the end of this training, we were all excited, and can now go back to incorporate this into our work. We hope this is not a one -time training, we need more of it in our newsrooms” said Okoye Ginka of the News Agency of Nigeria

 

Flattr this!

Forbes Philippines & BlogWatch win best story award as Data Journalism PH wraps up

- December 15, 2015 in Uncategorized

At the end of November, Open Knowledge, School of Data and the Philippine Center for Investigative Journalism (PCIJ) wrapped-up their six-month data journalism training for media organisations in the Philippines, the first of its kind.

Over 100 journalists and civil servants gathered at the Cocoon Hotel in Quezon City to see the twelve participating media teams present their work and listen to keynotes from The Guardian’s Caelainn Barr, Undersecretary Richard Moya (Open Data Task Force Philippines), Kenneth Abante (Department of Finance) and Rogier Van Den Brink (World Bank) on the interplay between government open data and public integrity journalism.

2015-11-27 12.01.58

Kenneth Abante from the Department of Finance speaking at the wrap-up event of Data Journalism PH 2015

The World Bank funded programme equipped participating newsrooms with the tools and techniques for mining the ever increasing volumes of public data being published by Philippine government departments via their national government data portal, data.gov.ph. After an initial intensive three-day training in July 2015 the teams received regular remote training sessions on data skills from Open Knowledge and editorial support from PCIJ as they progressed with their proposed data stories. Teams worked on diverse topics from probing who really benefits from the the Philippines’ Bottom Up Budgeting initiative to following where money allocated to the reconstruction effort after Typhoon Yolanda actually went.

Five of the twelve participating teams were able to publish their stories before the event with a number of teams finalising their articles for print publications in the new year. Forbes Philippines and BlogWatch were awarded prizes for best story by PCIJ and Open Knowledge based on the originality of their stories, their approach to data collection and the strength of their narrative. Forbes Philippines collected data from the SEC on independent directors and correlated this with company performance to give a unique view on corporate accountability in the Philippines. BlogWatch persevered with a range of large publicly available datasets on aid and reconstruction. The team also took to social media to crowdsource information that was missing in order to follow the money that was plugged into various projects in the wake of the devastation caused by Typhoon Yolanda.

2015-11-27 16.06.08 copy

Winning teams BlogWatch (Jane Uymatiao & Noemi Lardizabal-Dado) and Forbes Philippines (Lala Rimando & Lorenxo Subido) with Sam Leon (Open Knowledge) and Malou Mangahas (PCIJ)

Philippine Star ran an analysis of data published by the Department for Education on how many new schools were being built that would not have access to electricity and water. Business World looked at new trends in investment amongst Filipino citizens and summarised their results in an infographic. Calbayog Post investigated how projects approved under the Bottom Up Budgeting scheme in Samar Province had performed. The Financial Times produced a visual slideshow on the Philippines’ dependence on renewables and the opportunities for hydro power using data published by the Department of Energy. You can read the published stories below with the exception of Forbes Philippines’ which will be published in their January 2016 editions. Other participating teams including Rappler, PCIJ, Interaksyon, ABS-CBN, Bloomberg, Inquirer were not able to publish in time for the deadline, but hope to publish their stories in the coming weeks.

The Philippines has made substantial progress in recent years in government transparency. Launching a national government open data portal in 2014 and setting up an Open Data Task Force within the civil service to catalyse further open data releases across national and local government. The programme demonstrated the promise of open data by enabling participating journalists to shed light on issues of critical national importance to the broader public. It also put into sharp focus areas that needed more work from publishing government departments. Too many critical datasets were incomplete, not maintained actively, contained inconsistencies that made them difficult to analyse and were not available for free.

A selection of the online tutorials, data recipes and training material have been made available for all to use on the project website including guides to using a range of tools such as Infogr.am, CartoDB, Import.io and DocumentCloud.

###Data-driven articles produced as part of the programme

Forbes Philippines and BlogWatch were awarded prizes for best story by PCIJ and Open Knowledge based on the originality of their stories, their approach to data collection and the strength of their narrative.

###Testimonials from some of the participant journalists

“The workshop allowed me to be braver in pursuing irregularities and anomalies with the help of data, but also to be careful in making conclusions. It’s a nice intro to data journalism.” – Michael Joseph Bueza, Rappler

“Data Journalism PH 2015 is a workshop every serious journalist should take. More than teaching me practical skills – how to create maps, infographics, and spreadsheets – it made me realize how important it is to use hard facts, as opposed to merely relying on statements, to create a public that is more informed and more critical.” – Patricia Aquino, Interaksyon

“A great program! PCIJ has always set the standard for investigative journalism. Open Knowledge did a great job teaching us data journalism and the different skills it requires. Looking forward to continuing to work with the whole PCIJ team. The reports of the other teams were informative as well. Thumbs up to the whole group.” – Nestor Corrales, Inquirer

“The best journalism program ever that united my writing and analysis skills.” – Rommel Rutor, Calbayog Post

“It was a great chance to know how and why consumers and processors of data (i.e. the journalists) are seeking more from the producers of data (government, private sector). “ – Lala Rimando, Forbes Philippines

“It was a great opportunity to be part of this programme. I’m really interested in improving my technical and editorial skills on data mining and thanks to PCIJ and Open Knowledge, I’ve really learned a lot.” – Kia Obang, BusinessWorld Publishing

“Open data seems like an issue reserved for a select number of people, but it’s a subject that so many people need to be familiar with. Learning more about it through the programme can give you the right tools to turn open data into powerful analysis.” – Kyle Subido, Forbes Philippines

“If you want to learn how to dig into huge data, you gotta take this training. “ – Jose Gerwin Babob, Calbayog Post

“As a reporter covering different beats, including survey results, the training helped me learn new skills that would make me more effective in writing investigative stories by correctly analyzing and interpreting datasets. I really appreciate the efforts of the PCIJ and the Open Knowledge in coming up with such training for journalists like us. This will be a very good addition to our resumes. :-)” – Helen Flores, Philippine Star

“Had a grand time. Learned about the existence of free online tools which could potentially take off about 25% of my previous workload.” – Dan Paurom, Inquirer

“The Data Journalism Philippines 2015 is a timely program for Filipino journalists who are interested in making sense of the huge amount of data that are readily available online. The things that we have learned during the duration of the program equipped us with the necessary skills needed to produce quality data-driven articles for our respective organizations.” – Jan Victor Mateo, Philippine Star

Flattr this!

School of Data is part of the 19 million project!

- November 2, 2015 in Fellowship, Uncategorized

How can a diverse team of people, with different backgrounds from around the world, work together to find new ways to tell the story of hundreds of thousands of refugees that are migrating to Europe? How can they build new narratives that can help this people make a safer, better journey? How can they articulate possible solutions using technology?

Those are the questions that the 19 million project, and initiative of  Chicas Poderosas and La Coalizione Italiana Liberta e Diritti (CILD), will try to address the next two weeks in Rome.   The project will bring together journalists, programmers, designers and human right activists from different countries to work in teams from November 2 to the 13.

19mp

School of Data  fellow from Costa Rica, Camila Salazar, representing School of Data, is present in Rome to try to help with the discussion, bring new ideas and work on specific data projects related to the refugee crisis.  So we invite you to follow the project and involve in this initiative! You can follow the activities and help with fresh ideas on Twitter (@19mmproject) or Facebook.

Flattr this!

Data journalism in the Philippines: changing the open data landscape in the country

- July 13, 2015 in Uncategorized

IMG_2343
Transparency, accountability and open data in the Philippines have just become more palpable to citizens and journalists alike. Open Knowledge/School of Data joined forces with the World Bank and the Philippine Center for Investigative Journalism (PCIJ) to launch a five-month training program for 34 journalists from 12 media organisations in the country. The program was kickstarted this morning in a convention in Manila, with strong support of the Philippine government.

The event gathered 87 people from all over the country and discussed the challenges and the potential collaboration efforts between civil society and the government to make the Philippines more transparent and accountable through open data. The panel was lead by Malou Mangahas, executive director of the PCIJ, who reflected on the timing and relevance of the program to the Philippines, because of the coming elections. “We’re facing big changes in leadership in the country and we need to think about the way we do conversations around public policies”, she said. “Data could be the narrative that binds us all”.

The Philippines has made remarkable efforts in recent years to open its data. In 2010 the government made a commitment to characterise itself by transparency and accountability, leading to its participation in the foundation of the Open Government Partnership in 2011 with seven other countries, including Brazil and the United States. Within the country, the most visible impact of that commitment was seen two years later with the creation of the Open Data Philippines and its Open Data Portal in the 2014. “The goal is to have more than 2000 datasets published by the end of this year”, said Usec Bon Moya, who leads the Open Data Task Force. Moya admits the number is still “a drop in the ocean of Philippine data” and welcomed the contribution of journalists and civil society activists to help the government find the data that is relevant to all stakeholders. “We need your input to make our data more consistent and publish more datasets”, he said.

One of the issues acknowledged by the panel is the hard time professionals and citizens have to understand and work with data. A lot of times stakeholders don’t have a clear grasp of how the government works. Commissioner Heidi Mendoza, from the Commission on Audit, said one way to tackle this problem is to engage citizens to work with the government in a participatory process, like the Civil Participatory Audits. “When citizens work together with auditors, they feel stimulated to get to know more the government and its programs”, she said.

“The first step to achieve transparency is to show everybody we have nothing to hide”
Keneth Abante, Department of Finance, Philippines

It goes a long way if the government itself is willing to open its data, regardless of public pressure. Kenneth Abante, from the Department of Finance knows that and showed the audience ways journalists can help the office identify frauds and get smuggles just by analysing the data they publish. “The first step to achieve transparency is to show everybody we have nothing to hide”, he said. “We release every week and month important data that can be mined by journalists and activists.” To have a taste of how to take Mr. Abante’s invitation seriously and actually find stories in data that is already published in the Philippines, Kai Kaiser, senior economist from the World Bank, walked through a mini-data investigation. Using open data about tobacco, Kaiser raised questions about components that are imported to the Philippines and the relationship between the values declared by importing companies and the actual prices in the market. “That’s how you can find holes and corruption in the system”, he said.

Kaiser’s example was picked up by Rogier van den Brink, also from the World Bank, to show how the concept of Open Government can lead to better democracies and better relationships between governments and its citizens. Nevertheless, Mr. Brink reminded the audience that transparency is not enough. “The idea of open data is potentially transformative, but more needs to be done”, he said. “We need to collect and give feedback at all times and we also need to follow up on our initiatives.”

After the conference, the 34 journalists will participate in a 3-day hands on training about data analysis, cleaning, scraping and visualisation. The workshop will be lead by our own Sam Leon, School of Data trainer and data analyst. The training is just the beginning of a 5 month process in which the journalists will have conference calls with Open Knowledge/School of Data to help on their data investigations. Ideally each group of journalists will have produced a data driven investigation by the end of the program using the skills and tools presented during the workshops and mentoring sessions. “We are very excited and looking forward to see which stories are hidden in the Philippine open data landscape”, said Sam.

Flattr this!

Call for applications for Data Journalism Philippines 2015

- May 27, 2015 in Uncategorized

Screen Shot 2015-05-27 at 08.14.32

The Open Knowledge Foundation in partnership with the Philippine Center for Investigative Journalism is pleased to announce the launch of Data Journalism Ph 2015. Supported by the World Bank, the program will train journalists and citizen media in producing high-quality, data-driven stories.

In recent years, government and multilateral agencies in the Philippines have published large amounts of data such as the government’s recently launched Open Data platform. These were accompanied by other platforms that track the implementation and expenditure of flagship programs such as Bottom-Up-Budgeting via OpenBUB.gov.ph, Infrastructure via OpenRoads.ph and reconstruction platforms including the Foreign Aid Transparency Hub. The training aims to encourage more journalists to use these and other online resources to produce compelling investigative stories.

Data Journalism Ph 2015 will train journalists on the tools and techniques required to gain and communicate insight from public data, including web scraping, database analysis and interactive visualization. The program will support journalists in using data to back their stories, which will be published by their media organization over a period of five months.

Participating teams will benefit from the following:

  • A 3-day data journalism training workshop by the Open Knowledge Foundation and PCIJ in July 2015 in Manila
  • A series of online tutorials on a variety of topics from digital security to online mapping
  • Technical support in developing interactive visual content to accompany their published stories

##Apply now!

Teams of up to three members working with the same print, TV, or online media agencies in the Philippines are invited to submit an application here.

Participants will be selected on the basis of the data story projects they pitch focused on key datasets including infrastructure, reconstruction, participatory budgeting, procurement and customs. Through Data Journalism Ph 2015 and its trainers, these projects will be developed into data stories to be published by the participants’ media organizations.

Join the launch

Open Knowledge and PCIJ will host a half-day public event for those interested in the program in July in Quezon City. If you would like to receive full details about the event, please sign up here.

To follow the programme as it progresses go to the Data Journalism 2015 Ph project website.

Flattr this!