Latest news

Share:

Learning how to use pivot tables is a milestone in your ability to wrangle data. It is a key tool for basic analysis of data. What happens if your data has already been pivoted and you want to unpivot? This brief tutorial shows you how using OpenRefine.

Data training Civic Technology

I continue to learn more about how to use OpenRefine in new and interesting ways. In this tutorial explain how to emulate the SQL grouping functions.

Data training Civic Technology

OpenUp has partnered with Cape Agulhas Municiaplity to put the municipality's by-laws online, helping to make them easier to find, read and share.

Open By-laws Co-governance Citizen Empowerment Data Liberation

We need more technologists to enter the world of civic tech but beware that your tech skills will only get you so far. Social issues cannot be solved from behind a keyboard.

Civic Technology

What we did when we realised that frustration and confusion in the organisation was caused by lack of understanding of our chosen project management methodology.

Civic Technology

How to use feature detection to ensure that styling from the frontiers of front-end development do not break older browsers.

Civic Technology

Scary, crazy, upside-down truths for the insecure and perfectionistic, found in the practice of Lean UX.

Civic Technology

What we learnt collaborating with Romania and Poland on civic tech for open legislation.

Indigo Open By-laws Active Citizenry Data Liberation Civic Technology

A non-technical solution for populating and duplicating application forms.

Data training Data Literacy

A key ability for anyone who wants to communicate insights through data storytelling is to be able to find, extract and transform relevant data into machine readable format.

Data training Data Literacy

As part of our open intake, we've concluded our training in Johannesburg. Hear what participants had to say about their experience of learning how to begin telling stories with data.

Data training Data Literacy

It's the civic that decides whether and how the tech will work.

Medicine Price Registry Civic Technology

Dates confirmed for Introduction to Data Storytelling in Durban & Applications close today for Johannesburg Intake!

Data training Data Literacy

As we wrap up our work in corporate, we decided to reflect on a few of the lessons learnt along the way.

TRACE Data Literacy

As part of OpenUp's Transparent Corporates project, we've got some tips on how to investigate private entities using open data.

TRACE Data Literacy

OpenUp's short training courses teach Learners the value and impact numbers have, once contextualised in the situations that affect our daily living

Data training Data Literacy

The enormous impact of cloud computing on the pace of business innovation over the last ten years bears an important lesson for the law and the government: the significant value of shared, re-usable resources.

Indigo Open By-laws Co-governance

When it comes to open data we have learnt that data just being open, available and accessible is not enough. Whilst we don’t have all the answers, we do have some learnings to share.

Active Citizenry Data Liberation Civic Technology

Youth Explorer is an indispensible tool for youth-oriented municipalities, government departments and civil society organisations.

Youth Explorer Data Liberation

OpenUp re-structures short course training offering

Data training Data Literacy

How does the Corporate Tax Income rate affects the average taxpayer and what are the ways in which we can start to curb tax evasion?

TRACE Data Literacy

In this next article we look at beneficial ownership and the need for global improved transparency, as well as a registry here in South Africa.

TRACE Data Literacy

In this next article we’re going back to the beginning and will look at why we’re branching out to corporate data.

TRACE Data Liberation

In 2016, 29 municipalities in South Africa were created and 40 were disestablished. At OpenUp, we handle these changes by following the principle of “making the common easy, and making the not-so-common possible”.

Municipal Money Wazimap Civic Technology

Wazimap now has 2016 Municipal Election results and uses the municipalities and ward boundaries used for the elections.

Wazimap Data Liberation

Unpacking the joy of doing live customer support at OpenUp

Data Literacy

Dear friends, I want to share an important announcement with you.

For Open Data Day 2017, we asked the OpenUp staff to weigh in on why Open Data is important and what it means to them.

Data Literacy

What is tax evasion and what does it actually mean to call somewhere a tax haven?

TRACE Data Literacy

The state of transparency within company ownership and how the law facilitates access to this type of information.

TRACE Data Literacy

The most innocuous dataset can tell such interesting stories by leaking information that you never expected it held.

Data Liberation

Code for South Africa and SAFLII need your help to build the largest digital collection of freely available gazettes.

Open Gazettes

We don’t know enough about who owns what in corporates, which allows corruption, theft and dodgy dealings to happen. That’s why we’re going after the data.

TRACE Data Liberation

The Western Cape Youth Explorer provides data on demographics, education, unemployment, health, access to basic services and more, down to ward level, for youth across the Western Cape.

Youth Explorer Data Liberation

Announcing MunicipalMoney.gov.za, a website that makes municipal financial performance and budgets more transparent.

Municipal Money Co-governance Data Liberation

By building a series of programs used to source, scrape and index government gazettes, we now have a growing collection of over 20,000 free and searchable publications.

Open Gazettes Civic Technology

Meet Pocket Reporter, a new Android app for journalists, activists and anyone interested in storytelling that guides you through the newsgathering process.

Pocket Reporter Citizen Empowerment

Open Gazettes changes the way journalists use government gazettes to do stories, by allowing users to search and track important public information.

Open Gazettes Citizen Empowerment

We've made official government gazettes available online and searchable, so you no longer have to sift through them to source important, public information.

Open Gazettes Data Liberation

We've posted population estimates for Police Districts around the country to make working with crime rates simpler.

Open Data Portal Data Liberation

Taking shortcuts and outright cheating is the hallmark of a great developer. I like creating graphics, both visualisations and pretty maps but I often don’t have the time to spend hours making one from scratch.

It's now much easier to build your own Wazimap and help more people find the story behind the data.

Wazimap Civic Technology

Hear Jason Norwood-Young talk about school pregnancies, unfair access to APIs and BeautifulSoup

Data Literacy Civic Technology

All too often powerful, simple-to-use data tools for journalists are built and, after an initial buzz, they end up hardly being used by the very users they target.

Active Citizenry

Developing Open Data Resources for South African Women

Open Data Portal Data Liberation

The Indigo Legislation Platform now powers Open By-laws South Africa, a big jump forward for re-use, free access to law, and open source legislation software.

Open By-laws Civic Technology

They say that love knows no age. Does the data agree? Have a look at a weird cross-section of our society as seen through the 2012 civil marriages dataset.

Data Literacy

The surgeon general has been warning us for year. I took a look the at Causes of Death data from 2012. Yep - turns out that it's true.

Data Liberation

In this day and age, gender should be completely irrelevant. But is it?

Data Liberation

Speed traps often seem to be engineered to trick drivers instead of aiming to reduce road deaths. I decided to investigate whether municipalities are cynically using fines as an excuse to raise revenue

Data Liberation

We've been waiting for this for a long time. Cape Town is the first government entity to embrace open data. It is time to rejoice? I don't think so.

Co-governance Data Liberation

Sometimes you can't anticipate how your work is going to be used. Here is a story that really motivates me to continue doing what we do.

Medicine Price Registry Active Citizenry

Over 90 of South Africa’s open data experts from government, civic organisations and private enterprise met at the #OpenDataNow Unconference in Cape Town last week to take the first steps in creating an open data society

Co-governance Data Liberation

PoplusCon in Santiago, Chile, was a recent push to try and increase collaboration between the different civic-coding organizations around the world

Civic Technology

People legally change their names all the time. Sometimes what they choose for themselves is very amusing.

Data Liberation

Open Data for the win! How to save on your medicines bill using open data.

Medicine Price Registry Citizen Empowerment

February 22nd is International Open Data Day. Code for South Africa is hosting a data party. Come through and roll up your sleeves

Data Liberation

Occasionally I wonder why our work matters. How does it make our lives easier and promote better engagement with government. I have a sad tale to tell about a garden that I planted which was subsequently destroyed by the council and how I plan to get to the bottom of it.

Open By-laws Citizen Empowerment

Many of us don't know our neighborhood, although the data exists. We hosted a mini-hackathon with the Open Democracy Advice centre to explore our hood.

Civic Technology

Did you know that medicine prices are regulated in South Africa? Most people don't. We've built an application that makes price comparisons between branded medicines and their generic equivalents easier.

Medicine Price Registry Citizen Empowerment Data Liberation

In a time where 'open' has become the new mantra of the socially conscious everywhere, the department of Basic Education is embracing 'closed'.

Civic Technology

OpenUp is proud to be a winner of the African News Innovation Challenge