{"help": "https://ckan0.cf.opendata.inter.prod-toronto.ca/ne/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "79405f18-e0f6-4fda-9183-c83b34ce9992", "total_estimation_threshold": null, "records": [{"_id":1,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Benefits","Amount":541316.92},{"_id":2,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Equipment","Amount":4008.17},{"_id":3,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Materials & Supplies","Amount":14974.2},{"_id":4,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Premium Pay","Amount":102386.32},{"_id":5,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Salaries","Amount":3632049.43},{"_id":6,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Services","Amount":135536.54},{"_id":7,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Benefits","Amount":5740888.5},{"_id":8,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Equipment","Amount":1011709.5},{"_id":9,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Materials & Supplies","Amount":793618.5},{"_id":10,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Premium Pay","Amount":1063141.79},{"_id":11,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Revenues","Amount":-7822311.09},{"_id":12,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Salaries","Amount":37989837.44},{"_id":13,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Services","Amount":21379572.24},{"_id":14,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Benefits","Amount":null},{"_id":15,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Equipment","Amount":null},{"_id":16,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Materials & Supplies","Amount":null},{"_id":17,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Premium Pay","Amount":null},{"_id":18,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Salaries","Amount":null},{"_id":19,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Services","Amount":null},{"_id":20,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Specialized Operations Command","Category":"Benefits","Amount":25280667.19},{"_id":21,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Specialized Operations Command","Category":"Equipment","Amount":1556626.29},{"_id":22,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Specialized Operations Command","Category":"Materials & Supplies","Amount":1369167.4},{"_id":23,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Specialized Operations Command","Category":"Premium Pay","Amount":14496065.9},{"_id":24,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Specialized Operations Command","Category":"Revenues","Amount":-51327370.87},{"_id":25,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Specialized Operations Command","Category":"Salaries","Amount":163297474.7},{"_id":26,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Specialized Operations Command","Category":"Services","Amount":5355689.55},{"_id":27,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"2 - Toronto Police Services Board","Command_Name":"TPS Board","Category":"Benefits","Amount":135661.56},{"_id":28,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"2 - Toronto Police Services Board","Command_Name":"TPS Board","Category":"Equipment","Amount":1417.99},{"_id":29,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"2 - Toronto Police Services Board","Command_Name":"TPS Board","Category":"Materials & Supplies","Amount":3340.17},{"_id":30,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"2 - Toronto Police Services Board","Command_Name":"TPS Board","Category":"Premium Pay","Amount":218.86},{"_id":31,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"2 - Toronto Police Services Board","Command_Name":"TPS Board","Category":"Revenues","Amount":-629755.91},{"_id":32,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"2 - Toronto Police Services Board","Command_Name":"TPS Board","Category":"Salaries","Amount":865004.5},{"_id":33,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"2 - Toronto Police Services Board","Command_Name":"TPS Board","Category":"Services","Amount":1884260.78},{"_id":34,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"3 - Parking Enforcement","Command_Name":"Parking Enforcement","Category":"Benefits","Amount":6921080.29},{"_id":35,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"3 - Parking Enforcement","Command_Name":"Parking Enforcement","Category":"Equipment","Amount":3009.31},{"_id":36,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"3 - Parking Enforcement","Command_Name":"Parking Enforcement","Category":"Materials & Supplies","Amount":1246010.07},{"_id":37,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"3 - Parking Enforcement","Command_Name":"Parking Enforcement","Category":"Premium Pay","Amount":2490136.74},{"_id":38,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"3 - Parking Enforcement","Command_Name":"Parking Enforcement","Category":"Revenues","Amount":-1085060.59},{"_id":39,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Benefits","Amount":85812916.01},{"_id":40,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"3 - Parking Enforcement","Command_Name":"Parking Enforcement","Category":"Salaries","Amount":27672527.74},{"_id":41,"Year":2018,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"3 - Parking Enforcement","Command_Name":"Parking Enforcement","Category":"Services","Amount":5551630.98},{"_id":42,"Year":2018,"Type_of_Metric":"Approved Budget","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Benefits","Amount":95966100},{"_id":43,"Year":2018,"Type_of_Metric":"Approved Budget","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Equipment","Amount":1139100},{"_id":44,"Year":2018,"Type_of_Metric":"Approved Budget","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Materials & Supplies","Amount":14813000},{"_id":45,"Year":2018,"Type_of_Metric":"Approved Budget","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Premium Pay","Amount":2771900},{"_id":46,"Year":2018,"Type_of_Metric":"Approved Budget","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Revenues","Amount":-71084900},{"_id":47,"Year":2018,"Type_of_Metric":"Approved Budget","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Salaries","Amount":31706900},{"_id":48,"Year":2018,"Type_of_Metric":"Approved Budget","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Services","Amount":81987500},{"_id":49,"Year":2018,"Type_of_Metric":"Approved Budget","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Chief of Police","Category":"Benefits","Amount":2458800},{"_id":50,"Year":2018,"Type_of_Metric":"Approved Budget","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Chief of Police","Category":"Equipment","Amount":60700},{"_id":51,"Year":2018,"Type_of_Metric":"Approved Budget","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Chief of Police","Category":"Materials & Supplies","Amount":60800},{"_id":52,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Equipment","Amount":830103.39},{"_id":53,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Materials & Supplies","Amount":13626789.1},{"_id":54,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Premium Pay","Amount":-1029471.76},{"_id":55,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Revenues","Amount":-58332444.53},{"_id":56,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Salaries","Amount":34393675.77},{"_id":57,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Centralized and Grants","Category":"Services","Amount":69427198.08},{"_id":58,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Chief of Police","Category":"Benefits","Amount":2141925.17},{"_id":59,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Chief of Police","Category":"Equipment","Amount":96934.15},{"_id":60,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Chief of Police","Category":"Materials & Supplies","Amount":56213.5},{"_id":61,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Chief of Police","Category":"Premium Pay","Amount":380915.56},{"_id":62,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Chief of Police","Category":"Revenues","Amount":-28052.04},{"_id":63,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Chief of Police","Category":"Salaries","Amount":13779292.58},{"_id":64,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Chief of Police","Category":"Services","Amount":451964.85},{"_id":65,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Community Safety Command","Category":"Benefits","Amount":71945397.74},{"_id":66,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Community Safety Command","Category":"Equipment","Amount":92947.5},{"_id":67,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Community Safety Command","Category":"Materials & Supplies","Amount":767341.91},{"_id":68,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Community Safety Command","Category":"Premium Pay","Amount":36152607.38},{"_id":69,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Community Safety Command","Category":"Revenues","Amount":-19381895.16},{"_id":70,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Community Safety Command","Category":"Salaries","Amount":462151500.1},{"_id":71,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Community Safety Command","Category":"Services","Amount":1931091.08},{"_id":72,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Corporate Services Command","Category":"Benefits","Amount":6148104.18},{"_id":73,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Corporate Services Command","Category":"Equipment","Amount":60381.01},{"_id":74,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Corporate Services Command","Category":"Materials & Supplies","Amount":269861.11},{"_id":75,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Corporate Services Command","Category":"Premium Pay","Amount":590935.34},{"_id":76,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Corporate Services Command","Category":"Revenues","Amount":-1048466.67},{"_id":77,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Corporate Services Command","Category":"Salaries","Amount":40665793.58},{"_id":78,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Corporate Services Command","Category":"Services","Amount":2416050.67},{"_id":79,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Benefits","Amount":472309.84},{"_id":80,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Equipment","Amount":-0.01},{"_id":81,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Materials & Supplies","Amount":10232.55},{"_id":82,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Premium Pay","Amount":41386.27},{"_id":83,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Salaries","Amount":3241056.66},{"_id":84,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Human Resources Command","Category":"Services","Amount":66766.28},{"_id":85,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Benefits","Amount":5899780.28},{"_id":86,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Equipment","Amount":1629488.92},{"_id":87,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Materials & Supplies","Amount":811799.35},{"_id":88,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Premium Pay","Amount":706052.62},{"_id":89,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Revenues","Amount":-7965332.14},{"_id":90,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Salaries","Amount":39126917.36},{"_id":91,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Information&Technology Command","Category":"Services","Amount":18490104.8},{"_id":92,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Benefits","Amount":22680.08},{"_id":93,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Equipment","Amount":null},{"_id":94,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Materials & Supplies","Amount":228.55},{"_id":95,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Premium Pay","Amount":null},{"_id":96,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Salaries","Amount":311855.03},{"_id":97,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Operational Support Command","Category":"Services","Amount":8550.55},{"_id":98,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Specialized Operations Command","Category":"Benefits","Amount":25722061.58},{"_id":99,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Specialized Operations Command","Category":"Equipment","Amount":1761003.11},{"_id":100,"Year":2016,"Type_of_Metric":"Actual Expenditures","Organizational_Entity":"1 - Toronto Police Service","Command_Name":"Specialized Operations Command","Category":"Materials & Supplies","Amount":1121339.19}], "fields": [{"id": "_id", "type": "int"}, {"id": "Year", "type": "int4"}, {"id": "Type_of_Metric", "type": "text"}, {"id": "Organizational_Entity", "type": "text"}, {"id": "Command_Name", "type": "text"}, {"id": "Category", "type": "text"}, {"id": "Amount", "type": "float8"}], "_links": {"start": "/api/action/datastore_search?resource_id=79405f18-e0f6-4fda-9183-c83b34ce9992", "next": "/api/action/datastore_search?resource_id=79405f18-e0f6-4fda-9183-c83b34ce9992&offset=100"}, "total": 1161, "total_was_estimated": false}}