{"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": "86509cde-be45-4f22-9158-48ad4b88aa32", "total_estimation_threshold": null, "records": [{"_id":1,"YEAR":2014,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Breach of Confidence","COUNT_":"1"},{"_id":2,"YEAR":2014,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Corrupt practice","COUNT_":"0"},{"_id":3,"YEAR":2014,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Deceit","COUNT_":"0"},{"_id":4,"YEAR":2014,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Discreditable Conduct","COUNT_":"147"},{"_id":5,"YEAR":2014,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Insubordination","COUNT_":"1"},{"_id":6,"YEAR":2014,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Neglect of Duty","COUNT_":"25"},{"_id":7,"YEAR":2014,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Unlawful/Unecessary Exercise of Authority","COUNT_":"70"},{"_id":8,"YEAR":2014,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Policy","COUNT_":"3"},{"_id":9,"YEAR":2014,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Service","COUNT_":"25"},{"_id":10,"YEAR":2015,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Breach of Confidence","COUNT_":"0"},{"_id":11,"YEAR":2015,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Corrupt practice","COUNT_":"74"},{"_id":12,"YEAR":2015,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Deceit","COUNT_":"13"},{"_id":13,"YEAR":2015,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Discreditable Conduct","COUNT_":"0"},{"_id":14,"YEAR":2015,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Insubordination","COUNT_":"3"},{"_id":15,"YEAR":2015,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Neglect of Duty","COUNT_":"5"},{"_id":16,"YEAR":2015,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Unlawful/Unecessary Exercise of Authority","COUNT_":"148"},{"_id":17,"YEAR":2015,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Policy","COUNT_":"51"},{"_id":18,"YEAR":2015,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Service","COUNT_":"0"},{"_id":19,"YEAR":2016,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Breach of Confidence","COUNT_":"1"},{"_id":20,"YEAR":2016,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Corrupt practice","COUNT_":"1"},{"_id":21,"YEAR":2016,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Deceit","COUNT_":"2"},{"_id":22,"YEAR":2016,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Discreditable Conduct","COUNT_":"161"},{"_id":23,"YEAR":2016,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Insubordination","COUNT_":"5"},{"_id":24,"YEAR":2016,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Neglect of Duty","COUNT_":"49"},{"_id":25,"YEAR":2016,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Unlawful/Unecessary Exercise of Authority","COUNT_":"86"},{"_id":26,"YEAR":2016,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Policy","COUNT_":"3"},{"_id":27,"YEAR":2016,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Service","COUNT_":"31"},{"_id":28,"YEAR":2017,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Breach of Confidence","COUNT_":"1"},{"_id":29,"YEAR":2017,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Consuming Drugs or Alcohol","COUNT_":"0"},{"_id":30,"YEAR":2017,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Corrupt practice","COUNT_":"4"},{"_id":31,"YEAR":2017,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Deceit","COUNT_":"0"},{"_id":32,"YEAR":2017,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Discreditable Conduct","COUNT_":"176"},{"_id":33,"YEAR":2017,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Insubordination","COUNT_":"5"},{"_id":34,"YEAR":2017,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Neglect of Duty","COUNT_":"46"},{"_id":35,"YEAR":2017,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Policy","COUNT_":"6"},{"_id":36,"YEAR":2017,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Service","COUNT_":"24"},{"_id":37,"YEAR":2017,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Unlawful/Unecessary Exercise of Authority","COUNT_":"62"},{"_id":38,"YEAR":2018,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Breach of Confidence","COUNT_":"3"},{"_id":39,"YEAR":2018,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Consuming Drugs or Alcohol","COUNT_":"0"},{"_id":40,"YEAR":2018,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Corrupt practice","COUNT_":"3"},{"_id":41,"YEAR":2018,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Deceit","COUNT_":"1"},{"_id":42,"YEAR":2018,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Discreditable Conduct","COUNT_":"166"},{"_id":43,"YEAR":2018,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Insubordination","COUNT_":"6"},{"_id":44,"YEAR":2018,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Neglect of Duty","COUNT_":"56"},{"_id":45,"YEAR":2018,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Policy","COUNT_":"3"},{"_id":46,"YEAR":2018,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Service","COUNT_":"18"},{"_id":47,"YEAR":2018,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Unlawful/Unecessary Exercise of Authority","COUNT_":"89"},{"_id":48,"YEAR":2019,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Breach of Confidence","COUNT_":"2"},{"_id":49,"YEAR":2019,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Consuming Drugs or Alcohol","COUNT_":"0"},{"_id":50,"YEAR":2019,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Corrupt practice","COUNT_":"0"},{"_id":51,"YEAR":2019,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Deceit","COUNT_":"1"},{"_id":52,"YEAR":2019,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Discreditable Conduct","COUNT_":"125"},{"_id":53,"YEAR":2019,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Insubordination","COUNT_":"4"},{"_id":54,"YEAR":2019,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Neglect of Duty","COUNT_":"46"},{"_id":55,"YEAR":2019,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Policy","COUNT_":"2"},{"_id":56,"YEAR":2019,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Service","COUNT_":"24"},{"_id":57,"YEAR":2019,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Unlawful/Unecessary Exercise of Authority","COUNT_":"84"},{"_id":58,"YEAR":2020,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Breach of Confidence","COUNT_":"2"},{"_id":59,"YEAR":2020,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Consuming Drugs or Alcohol","COUNT_":"0"},{"_id":60,"YEAR":2020,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Corrupt practice","COUNT_":"2"},{"_id":61,"YEAR":2020,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Deceit","COUNT_":"0"},{"_id":62,"YEAR":2020,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Discreditable Conduct","COUNT_":"166"},{"_id":63,"YEAR":2020,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Insubordination","COUNT_":"2"},{"_id":64,"YEAR":2020,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Neglect of Duty","COUNT_":"45"},{"_id":65,"YEAR":2020,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Policy","COUNT_":"5"},{"_id":66,"YEAR":2020,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Service","COUNT_":"17"},{"_id":67,"YEAR":2020,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Unlawful/Unecessary Exercise of Authority","COUNT_":"59"},{"_id":68,"YEAR":2021,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Breach of Confidence","COUNT_":"1"},{"_id":69,"YEAR":2021,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Consuming Drugs or Alcohol","COUNT_":"0"},{"_id":70,"YEAR":2021,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Corrupt practice","COUNT_":"1"},{"_id":71,"YEAR":2021,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Deceit","COUNT_":"0"},{"_id":72,"YEAR":2021,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Discreditable Conduct","COUNT_":"175"},{"_id":73,"YEAR":2021,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Insubordination","COUNT_":"5"},{"_id":74,"YEAR":2021,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Neglect of Duty","COUNT_":"75"},{"_id":75,"YEAR":2021,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Policy","COUNT_":"3"},{"_id":76,"YEAR":2021,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Service","COUNT_":"31"},{"_id":77,"YEAR":2021,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Unlawful/Unecessary Exercise of Authority","COUNT_":"61"},{"_id":78,"YEAR":2022,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Breach of Confidence","COUNT_":"2"},{"_id":79,"YEAR":2022,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Consuming Drugs or Alcohol","COUNT_":"0"},{"_id":80,"YEAR":2022,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Corrupt practice","COUNT_":"1"},{"_id":81,"YEAR":2022,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Deceit","COUNT_":"1"},{"_id":82,"YEAR":2022,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Discreditable Conduct","COUNT_":"139"},{"_id":83,"YEAR":2022,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Insubordination","COUNT_":"1"},{"_id":84,"YEAR":2022,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Neglect of Duty","COUNT_":"70"},{"_id":85,"YEAR":2022,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Policy","COUNT_":"1"},{"_id":86,"YEAR":2022,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Service","COUNT_":"51"},{"_id":87,"YEAR":2022,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Unlawful/Unecessary Exercise of Authority","COUNT_":"54"},{"_id":88,"YEAR":2023,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Breach of Confidence","COUNT_":"3"},{"_id":89,"YEAR":2023,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Consuming Drugs or Alcohol","COUNT_":"1"},{"_id":90,"YEAR":2023,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Corrupt practice","COUNT_":"1"},{"_id":91,"YEAR":2023,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Deceit","COUNT_":"0"},{"_id":92,"YEAR":2023,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Discreditable Conduct","COUNT_":"131"},{"_id":93,"YEAR":2023,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Insubordination","COUNT_":"2"},{"_id":94,"YEAR":2023,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Neglect of Duty","COUNT_":"101"},{"_id":95,"YEAR":2023,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Policy","COUNT_":"2"},{"_id":96,"YEAR":2023,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Service","COUNT_":"68"},{"_id":97,"YEAR":2023,"TYPE":"ALLEGED MISCONDUCT - Investigated Complaints","SUBTYPE":"Unlawful/Unecessary Exercise of Authority","COUNT_":"61"}], "fields": [{"id": "_id", "type": "int"}, {"id": "YEAR", "type": "int4"}, {"id": "TYPE", "type": "text"}, {"id": "SUBTYPE", "type": "text"}, {"id": "COUNT_", "type": "text"}], "_links": {"start": "/api/action/datastore_search?resource_id=86509cde-be45-4f22-9158-48ad4b88aa32", "next": "/api/action/datastore_search?resource_id=86509cde-be45-4f22-9158-48ad4b88aa32&offset=100"}, "total": 97, "total_was_estimated": false}}