{"total_cell_count": 74, "cells": [{"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0101", "function.label": "Executive & Council/Mayor and Council", "item.return_form_structure": "subtotal", "amount.sum": 0.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0102", "function.label": "Executive & Council/Municipal Manager", "item.return_form_structure": "subtotal", "amount.sum": 178470560.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0191", "function.label": "Budget & Treasury Office/Not Required", "item.return_form_structure": "subtotal", "amount.sum": 7965699428.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0202", "function.label": "Corporate Services/Human Resources", "item.return_form_structure": "subtotal", "amount.sum": 25104114.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0203", "function.label": "Corporate Services/Information Technology", "item.return_form_structure": "subtotal", "amount.sum": 43717.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0204", "function.label": "Corporate Services/Property Services", "item.return_form_structure": "subtotal", "amount.sum": 81595461.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0205", "function.label": "Corporate Services/Other Admin", "item.return_form_structure": "subtotal", "amount.sum": 148759659.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0301", "function.label": "Planning and Development/Economic Development/Planning", "item.return_form_structure": "subtotal", "amount.sum": 32885093.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0302", "function.label": "Planning and Development/Town Planning/Building Enforcement", "item.return_form_structure": "subtotal", "amount.sum": 195564547.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0401", "function.label": "Health/Clinics", "item.return_form_structure": "subtotal", "amount.sum": 88023715.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0402", "function.label": "Health/Ambulance", "item.return_form_structure": "subtotal", "amount.sum": 65922725.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0501", "function.label": "Community & Social Services/Libraries and Archives", "item.return_form_structure": "subtotal", "amount.sum": 5560756.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0502", "function.label": "Community & Social Services/Museums & Art Galleries etc", "item.return_form_structure": "subtotal", "amount.sum": 251426.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0503", "function.label": "Community & Social Services/Community Halls and Facilities", "item.return_form_structure": "subtotal", "amount.sum": 3407.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0504", "function.label": "Community & Social Services/Cemeteries & Crematoriums", "item.return_form_structure": "subtotal", "amount.sum": 24927819.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0506", "function.label": "Community & Social Services/Aged Care", "item.return_form_structure": "subtotal", "amount.sum": 33230.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0507", "function.label": "Community & Social Services/Other Community", "item.return_form_structure": "subtotal", "amount.sum": 1584077.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0601", "function.label": "Housing/Not Required", "item.return_form_structure": "subtotal", "amount.sum": 799270624.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0701", "function.label": "Public Safety/Police", "item.return_form_structure": "subtotal", "amount.sum": 6150976.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0702", "function.label": "Public Safety/Fire", "item.return_form_structure": "subtotal", "amount.sum": 6642922.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0703", "function.label": "Public Safety/Civil Defence", "item.return_form_structure": "subtotal", "amount.sum": 176513027.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0801", "function.label": "Sport And Recreation/Not Required", "item.return_form_structure": "subtotal", "amount.sum": 24990766.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0901", "function.label": "Environmental Protection/Pollution Control", "item.return_form_structure": "subtotal", "amount.sum": 4618890.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0902", "function.label": "Environmental Protection/Biodiversity & Landscape", "item.return_form_structure": "subtotal", "amount.sum": 0.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "0903", "function.label": "Environmental Protection/Other", "item.return_form_structure": "subtotal", "amount.sum": 0.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1001", "function.label": "Waste Water Management/Sewerage", "item.return_form_structure": "subtotal", "amount.sum": 1013793034.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1002", "function.label": "Waste Water Management/Storm Water Management", "item.return_form_structure": "subtotal", "amount.sum": 0.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1011", "function.label": "Waste Management/Solid Waste", "item.return_form_structure": "subtotal", "amount.sum": 1023860945.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1101", "function.label": "Road Transport/Roads", "item.return_form_structure": "subtotal", "amount.sum": 259882980.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1102", "function.label": "Road Transport/Public Buses", "item.return_form_structure": "subtotal", "amount.sum": 939159925.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1104", "function.label": "Road Transport/Vehicle licensing and Testing", "item.return_form_structure": "subtotal", "amount.sum": 125093770.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1201", "function.label": "Water/Water Distribution", "item.return_form_structure": "subtotal", "amount.sum": 2894624962.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1202", "function.label": "Water/Water Storage", "item.return_form_structure": "subtotal", "amount.sum": 0.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1301", "function.label": "Electricity /Electricity Distribution", "item.return_form_structure": "subtotal", "amount.sum": 9369577537.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1401", "function.label": "Other/Air Transport", "item.return_form_structure": "subtotal", "amount.sum": 29354888.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1403", "function.label": "Other/Tourism", "item.return_form_structure": "subtotal", "amount.sum": 0.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "2800", "item.label": "Total Operating Revenue", "function.code": "1405", "function.label": "Other/Markets", "item.return_form_structure": "subtotal", "amount.sum": 162013355.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0101", "function.label": "Executive & Council/Mayor and Council", "item.return_form_structure": "subtotal", "amount.sum": 519387296.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0102", "function.label": "Executive & Council/Municipal Manager", "item.return_form_structure": "subtotal", "amount.sum": 701599713.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0191", "function.label": "Budget & Treasury Office/Not Required", "item.return_form_structure": "subtotal", "amount.sum": 1030474765.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0202", "function.label": "Corporate Services/Human Resources", "item.return_form_structure": "subtotal", "amount.sum": 305146372.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0203", "function.label": "Corporate Services/Information Technology", "item.return_form_structure": "subtotal", "amount.sum": 735180634.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0204", "function.label": "Corporate Services/Property Services", "item.return_form_structure": "subtotal", "amount.sum": 1098999994.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0205", "function.label": "Corporate Services/Other Admin", "item.return_form_structure": "subtotal", "amount.sum": 709300673.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0301", "function.label": "Planning and Development/Economic Development/Planning", "item.return_form_structure": "subtotal", "amount.sum": 498989280.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0302", "function.label": "Planning and Development/Town Planning/Building Enforcement", "item.return_form_structure": "subtotal", "amount.sum": 273917130.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0401", "function.label": "Health/Clinics", "item.return_form_structure": "subtotal", "amount.sum": 379756655.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0402", "function.label": "Health/Ambulance", "item.return_form_structure": "subtotal", "amount.sum": 167674380.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0501", "function.label": "Community & Social Services/Libraries and Archives", "item.return_form_structure": "subtotal", "amount.sum": 69980183.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0502", "function.label": "Community & Social Services/Museums & Art Galleries etc", "item.return_form_structure": "subtotal", "amount.sum": 14074827.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0503", "function.label": "Community & Social Services/Community Halls and Facilities", "item.return_form_structure": "subtotal", "amount.sum": 22063049.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0504", "function.label": "Community & Social Services/Cemeteries & Crematoriums", "item.return_form_structure": "subtotal", "amount.sum": 34791877.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0506", "function.label": "Community & Social Services/Aged Care", "item.return_form_structure": "subtotal", "amount.sum": 2179534.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0507", "function.label": "Community & Social Services/Other Community", "item.return_form_structure": "subtotal", "amount.sum": 58484219.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0601", "function.label": "Housing/Not Required", "item.return_form_structure": "subtotal", "amount.sum": 549914190.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0701", "function.label": "Public Safety/Police", "item.return_form_structure": "subtotal", "amount.sum": 163407650.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0702", "function.label": "Public Safety/Fire", "item.return_form_structure": "subtotal", "amount.sum": 339907522.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0703", "function.label": "Public Safety/Civil Defence", "item.return_form_structure": "subtotal", "amount.sum": 1356455549.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0801", "function.label": "Sport And Recreation/Not Required", "item.return_form_structure": "subtotal", "amount.sum": 243218130.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0901", "function.label": "Environmental Protection/Pollution Control", "item.return_form_structure": "subtotal", "amount.sum": 129089652.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0902", "function.label": "Environmental Protection/Biodiversity & Landscape", "item.return_form_structure": "subtotal", "amount.sum": 9533247.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "0903", "function.label": "Environmental Protection/Other", "item.return_form_structure": "subtotal", "amount.sum": 1654593.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1001", "function.label": "Waste Water Management/Sewerage", "item.return_form_structure": "subtotal", "amount.sum": 725672969.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1002", "function.label": "Waste Water Management/Storm Water Management", "item.return_form_structure": "subtotal", "amount.sum": 16008786.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1011", "function.label": "Waste Management/Solid Waste", "item.return_form_structure": "subtotal", "amount.sum": 1042988261.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1101", "function.label": "Road Transport/Roads", "item.return_form_structure": "subtotal", "amount.sum": 783922650.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1102", "function.label": "Road Transport/Public Buses", "item.return_form_structure": "subtotal", "amount.sum": 736378934.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1104", "function.label": "Road Transport/Vehicle licensing and Testing", "item.return_form_structure": "subtotal", "amount.sum": 84715759.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1201", "function.label": "Water/Water Distribution", "item.return_form_structure": "subtotal", "amount.sum": 2416428091.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1202", "function.label": "Water/Water Storage", "item.return_form_structure": "subtotal", "amount.sum": 24859370.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1301", "function.label": "Electricity /Electricity Distribution", "item.return_form_structure": "subtotal", "amount.sum": 9456319945.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1401", "function.label": "Other/Air Transport", "item.return_form_structure": "subtotal", "amount.sum": 95578731.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1403", "function.label": "Other/Tourism", "item.return_form_structure": "subtotal", "amount.sum": 19102675.0}, {"demarcation.code": "TSH", "demarcation.label": "City of Tshwane", "item.code": "5200", "item.label": "Total Operating Expenditure", "function.code": "1405", "function.label": "Other/Markets", "item.return_form_structure": "subtotal", "amount.sum": 66689697.0}], "summary": {"amount.sum": 50533825317.0}, "cell": [{"ref": "financial_year_end.year", "operator": ":", "value": [2015]}, {"ref": "amount_type.code", "operator": ":", "value": ["AUDA"]}, {"ref": "financial_period.period", "operator": ":", "value": [2015]}, {"ref": "demarcation.code", "operator": ":", "value": ["TSH"]}, {"ref": "item.code", "operator": ":", "value": ["2800", "5200"]}], "aggregates": ["amount.sum"], "attributes": ["demarcation.code", "demarcation.label", "item.code", "item.label", "function.code", "function.label", "item.return_form_structure"], "order": [], "page": 1, "page_size": 10000, "status": "ok"}