Municipal Money website

[Adi Eyal]

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:

http://municipalmoney.gov.za

and the press release

http://www.gov.za/speeches/treasury-launches-open-local-government-financial-data-portal-%E2%80%93-%E2%80%9Cmunicipal-money%E2%80%9D-26-oct

municipalmoney.gov.za

--

Adi Eyal

Director

Code for South Africa

Promoting informed decision-making

phone: +27 78 014 2469

skype: adieyalcas

linkedin: http://za.linkedin.com/pub/dir/Adi/Eyal

web: http://www.code4sa.org

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]

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]

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]

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]

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.

You can explore drilling down into function codes here as well https://municipaldata.treasury.gov.za/table/incexp/?year=2015&municipalities=TSH&amountType=AUDA&functions=1202%2C1201%2C1204

Best

JD