Municipal Money website

9 views
Skip to first unread message

Adi Eyal

unread,
Oct 26, 2016, 9:53:04 AM10/26/16
to od...@googlegroups.com, hackshacke...@googlegroups.com, hackshackers-johannesburg
Hi All

The Minister of Finance just launched Municipal Money, a website which provides information on local government budgets and expenditure. It is also backed by an api for anyone who wants to write code against it. 

See here:


and the press release


--
Adi Eyal
Director
Code for South Africa
Promoting informed decision-making

skype: adieyalcas
twitter: @soapsudtycoon

Follow us on twitter at @code4sa
Sign up for Naked Data, our weekly round-up of what's happening locally and internationally in data journalism and data visualisation. Register here: http://www.code4sa.org/newsletter

Siyabonga Africa

unread,
Oct 26, 2016, 9:53:59 AM10/26/16
to od...@googlegroups.com
Hey Adi

Is there anyone in your team we can interview about this? Would be nice to run a story on it on our site.

Best

Siya

--
You received this message because you are subscribed to the Google Groups "Open Data and Democracy Initiative (ODADI)" group.
To unsubscribe from this group and stop receiving emails from it, send an email to odadi+unsubscribe@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.



--
Siyabonga Africa
Ford Foundation Fellow 2010/2011
Hacks/Hackers Community Coordinator
School of Data Fellow 2014
South Africa

Luke Jordan

unread,
Oct 28, 2016, 2:25:15 AM10/28/16
to HacksHackers Johannesburg, od...@googlegroups.com, hackshacke...@googlegroups.com
HI Adi,

This looks fantastic. One question is that the municipal money website shows a sector breakdown of expenses (health/housing/etc), but I don't see line items for those in the API docs (e.g., here : https://municipaldata.treasury.gov.za/docs#cube-incexp), which look like the cubes only split into the line items such as service contracts etc. Is there a way to get the sectoral breakdowns via the API?

Best, Luke

Adi Eyal

unread,
Oct 28, 2016, 2:38:50 AM10/28/16
to hackshackers-johannesburg, od...@googlegroups.com, hackshacke...@googlegroups.com

Thanks Luke

I have cc-ed JD who has intimate knowledge of the system.  The site was built using the api so I'm certain it's possible.

Adi


--
You received this message because you are subscribed to the Google Groups "HacksHackers Johannesburg" group.
To unsubscribe from this group and stop receiving emails from it, send an email to hackshackers-johannesburg+unsub...@googlegroups.com.
To post to this group, send email to hackshackers-johannesburg@googlegroups.com.
To view this discussion on the web, visit https://groups.google.com/d/msgid/hackshackers-johannesburg/9e87ee6b-82c4-4d87-8c47-6f8663a7b7e3%40googlegroups.com.

JD Bothma

unread,
Mar 20, 2017, 2:40:04 AM3/20/17
to Open Data and Democracy Initiative (ODADI), hackshackers...@googlegroups.com, hackshacke...@googlegroups.com
Hi Luke

So sorry about the extremely late reply. I hope this is still useful.

I suspect what you call sector is what we call Government Function in the API docs.

You can get breakdown by government function by "drilling down" on the function dimensions function.code and function.label:

https://municipaldata.treasury.gov.za/api/cubes/incexp/aggregate?drilldown=function.code%7Cdemarcation.code%7Cdemarcation.label%7Citem.code%7Citem.label%7Citem.return_form_structure&cut=financial_year_end.year%3A2015%7Camount_type.code%3AAUDA%7Cfinancial_period.period%3A2015%7Cfunction.code%3A%221202%22%3B%221201%22%3B%221204%22%7Cdemarcation.code%3A%22TSH%22&aggregates=amount.sum

Be careful not to sum together all line items for a government function by drilling down only on function code without filtering on specific item codes. That would sum together debit and credit lines, as well as subtotals which sometimes have their own item codes. That is almost certainly never what you want.


Best
JD
Reply all
Reply to author
Forward
0 new messages