{"help": "https://ckan0.cf.opendata.inter.prod-toronto.ca/tr/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "5d04d510-88cb-4b48-8311-94b3e155e100", "total_estimation_threshold": null, "records": [{"_id":1,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Sexual Violation","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":2,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Fraud","COUNT_":"2","COUNT_CLEARED":"1"},{"_id":3,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Other","COUNT_":"2","COUNT_CLEARED":"0"},{"_id":4,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Theft Under $5000","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":5,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Assault","COUNT_":"1","COUNT_CLEARED":"0"},{"_id":6,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Robbery - All Other","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":7,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other","COUNT_":"3","COUNT_CLEARED":"3"},{"_id":8,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other Criminal Violations - Offensive Weapons","COUNT_":"3","COUNT_CLEARED":"3"},{"_id":9,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Controlled Drugs and Substances Act","SUBTYPE":"Other","COUNT_":"10","COUNT_CLEARED":"8"},{"_id":10,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Auto Theft","COUNT_":"5","COUNT_CLEARED":"4"},{"_id":11,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Apartment","COUNT_":"12","COUNT_CLEARED":"6"},{"_id":12,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Commercial","COUNT_":"2","COUNT_CLEARED":"0"},{"_id":13,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Educational","COUNT_":"1","COUNT_CLEARED":"0"},{"_id":14,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-House","COUNT_":"2","COUNT_CLEARED":"0"},{"_id":15,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Other","COUNT_":"2","COUNT_CLEARED":"1"},{"_id":16,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Fraud","COUNT_":"38","COUNT_CLEARED":"16"},{"_id":17,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Other","COUNT_":"70","COUNT_CLEARED":"31"},{"_id":18,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Theft Over $5000","COUNT_":"6","COUNT_CLEARED":"3"},{"_id":19,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Theft Under $5000","COUNT_":"365","COUNT_CLEARED":"260"},{"_id":20,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Assault","COUNT_":"52","COUNT_CLEARED":"32"},{"_id":21,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Other","COUNT_":"12","COUNT_CLEARED":"8"},{"_id":22,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Robbery - All Other","COUNT_":"9","COUNT_CLEARED":"1"},{"_id":23,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Sexual Violation","COUNT_":"6","COUNT_CLEARED":"3"},{"_id":24,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Criminal Code Traffic","SUBTYPE":"Other","COUNT_":"5","COUNT_CLEARED":"5"},{"_id":25,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other","COUNT_":"26","COUNT_CLEARED":"23"},{"_id":26,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other Criminal Violations - Offensive Weapons","COUNT_":"6","COUNT_CLEARED":"5"},{"_id":27,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Federal Statute Violations","SUBTYPE":"Other","COUNT_":"2","COUNT_CLEARED":"2"},{"_id":28,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Criminal Code Traffic","SUBTYPE":"Other","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":29,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Controlled Drugs and Substances Act","SUBTYPE":"Other","COUNT_":"26","COUNT_CLEARED":"26"},{"_id":30,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Auto Theft","COUNT_":"14","COUNT_CLEARED":"8"},{"_id":31,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Apartment","COUNT_":"11","COUNT_CLEARED":"5"},{"_id":32,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Commercial","COUNT_":"1","COUNT_CLEARED":"0"},{"_id":33,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-House","COUNT_":"5","COUNT_CLEARED":"1"},{"_id":34,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Fraud","COUNT_":"24","COUNT_CLEARED":"5"},{"_id":35,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Other","COUNT_":"68","COUNT_CLEARED":"28"},{"_id":36,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Theft Over $5000","COUNT_":"6","COUNT_CLEARED":"1"},{"_id":37,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Theft Under $5000","COUNT_":"152","COUNT_CLEARED":"27"},{"_id":38,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Assault","COUNT_":"81","COUNT_CLEARED":"62"},{"_id":39,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Other","COUNT_":"27","COUNT_CLEARED":"15"},{"_id":40,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Robbery - All Other","COUNT_":"17","COUNT_CLEARED":"5"},{"_id":41,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Robbery - Business","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":42,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Robbery - Financial","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":43,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Sexual Violation","COUNT_":"12","COUNT_CLEARED":"5"},{"_id":44,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Criminal Code Traffic","SUBTYPE":"Other","COUNT_":"8","COUNT_CLEARED":"8"},{"_id":45,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other","COUNT_":"45","COUNT_CLEARED":"42"},{"_id":46,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other Criminal Violations - Offensive Weapons","COUNT_":"10","COUNT_CLEARED":"10"},{"_id":47,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Federal Statute Violations","SUBTYPE":"Other","COUNT_":"3","COUNT_CLEARED":"3"},{"_id":48,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Controlled Drugs and Substances Act","SUBTYPE":"Other","COUNT_":"14","COUNT_CLEARED":"13"},{"_id":49,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Auto Theft","COUNT_":"17","COUNT_CLEARED":"3"},{"_id":50,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Apartment","COUNT_":"9","COUNT_CLEARED":"4"},{"_id":51,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Robbery - All Other","COUNT_":"10","COUNT_CLEARED":"6"},{"_id":52,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Robbery - Financial","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":53,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Robbery - Home Invasion","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":54,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Sexual Violation","COUNT_":"5","COUNT_CLEARED":"3"},{"_id":55,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Criminal Code Traffic","SUBTYPE":"Other","COUNT_":"7","COUNT_CLEARED":"7"},{"_id":56,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other","COUNT_":"33","COUNT_CLEARED":"31"},{"_id":57,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other Criminal Violations - Offensive Weapons","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":58,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Federal Statute Violations","SUBTYPE":"Other","COUNT_":"3","COUNT_CLEARED":"3"},{"_id":59,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Controlled Drugs and Substances Act","SUBTYPE":"Other","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":60,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Apartment","COUNT_":"1","COUNT_CLEARED":"0"},{"_id":61,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Commercial","COUNT_":"1","COUNT_CLEARED":"0"},{"_id":62,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Fraud","COUNT_":"3","COUNT_CLEARED":"1"},{"_id":63,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Other","COUNT_":"6","COUNT_CLEARED":"4"},{"_id":64,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Theft Over $5000","COUNT_":"2","COUNT_CLEARED":"0"},{"_id":65,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Theft Under $5000","COUNT_":"40","COUNT_CLEARED":"8"},{"_id":66,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Assault","COUNT_":"5","COUNT_CLEARED":"4"},{"_id":67,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Sexual Violation","COUNT_":"1","COUNT_CLEARED":"0"},{"_id":68,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Criminal Code Traffic","SUBTYPE":"Other","COUNT_":"6","COUNT_CLEARED":"6"},{"_id":69,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other","COUNT_":"3","COUNT_CLEARED":"3"},{"_id":70,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Theft Under $5000","COUNT_":"1","COUNT_CLEARED":"0"},{"_id":71,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Assault","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":72,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Controlled Drugs and Substances Act","SUBTYPE":"Other","COUNT_":"15","COUNT_CLEARED":"15"},{"_id":73,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Auto Theft","COUNT_":"16","COUNT_CLEARED":"7"},{"_id":74,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Apartment","COUNT_":"6","COUNT_CLEARED":"3"},{"_id":75,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Commercial","COUNT_":"4","COUNT_CLEARED":"2"},{"_id":76,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Educational","COUNT_":"3","COUNT_CLEARED":"1"},{"_id":77,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-House","COUNT_":"6","COUNT_CLEARED":"3"},{"_id":78,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Fraud","COUNT_":"21","COUNT_CLEARED":"5"},{"_id":79,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Other","COUNT_":"40","COUNT_CLEARED":"15"},{"_id":80,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Theft Over $5000","COUNT_":"4","COUNT_CLEARED":"1"},{"_id":81,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against Property","SUBTYPE":"Theft Under $5000","COUNT_":"51","COUNT_CLEARED":"10"},{"_id":82,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Assault","COUNT_":"54","COUNT_CLEARED":"45"},{"_id":83,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Other","COUNT_":"22","COUNT_CLEARED":"9"},{"_id":84,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Robbery - All Other","COUNT_":"3","COUNT_CLEARED":"0"},{"_id":85,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Robbery - Business","COUNT_":"1","COUNT_CLEARED":"0"},{"_id":86,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Sexual Violation","COUNT_":"10","COUNT_CLEARED":"4"},{"_id":87,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Criminal Code Traffic","SUBTYPE":"Other","COUNT_":"9","COUNT_CLEARED":"9"},{"_id":88,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other","COUNT_":"60","COUNT_CLEARED":"57"},{"_id":89,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other Criminal Violations - Offensive Weapons","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":90,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Federal Statute Violations","SUBTYPE":"Other","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":91,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Crimes Against the Person","SUBTYPE":"Other","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":92,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":93,"REPORT_YEAR":2014,"DIVISION":"D11","CATEGORY":"Other Criminal Code Violations","SUBTYPE":"Other","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":94,"REPORT_YEAR":2014,"DIVISION":"D12","CATEGORY":"Controlled Drugs and Substances Act","SUBTYPE":"Other","COUNT_":"31","COUNT_CLEARED":"31"},{"_id":95,"REPORT_YEAR":2014,"DIVISION":"D12","CATEGORY":"Crimes Against Property","SUBTYPE":"Auto Theft","COUNT_":"10","COUNT_CLEARED":"3"},{"_id":96,"REPORT_YEAR":2014,"DIVISION":"D12","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Apartment","COUNT_":"8","COUNT_CLEARED":"3"},{"_id":97,"REPORT_YEAR":2014,"DIVISION":"D12","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Commercial","COUNT_":"5","COUNT_CLEARED":"4"},{"_id":98,"REPORT_YEAR":2014,"DIVISION":"D12","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-Educational","COUNT_":"1","COUNT_CLEARED":"1"},{"_id":99,"REPORT_YEAR":2014,"DIVISION":"D12","CATEGORY":"Crimes Against Property","SUBTYPE":"Break & Enter-House","COUNT_":"6","COUNT_CLEARED":"2"},{"_id":100,"REPORT_YEAR":2014,"DIVISION":"D12","CATEGORY":"Crimes Against Property","SUBTYPE":"Fraud","COUNT_":"24","COUNT_CLEARED":"5"}], "fields": [{"id": "_id", "type": "int"}, {"id": "REPORT_YEAR", "type": "int4"}, {"id": "DIVISION", "type": "text"}, {"id": "CATEGORY", "type": "text"}, {"id": "SUBTYPE", "type": "text"}, {"id": "COUNT_", "type": "text"}, {"id": "COUNT_CLEARED", "type": "text"}], "_links": {"start": "/api/action/datastore_search?resource_id=5d04d510-88cb-4b48-8311-94b3e155e100", "next": "/api/action/datastore_search?resource_id=5d04d510-88cb-4b48-8311-94b3e155e100&offset=100"}, "total": 47099, "total_was_estimated": false}}