{"help": "https://ckan0.cf.opendata.inter.prod-toronto.ca/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "q": "MR ROOTER", "records_format": "objects", "resource_id": "169e90ba-3ae0-43dd-8b2f-919e87002f50", "total_estimation_threshold": null, "records": [{"_id":130398,"Category":"PLUMBING CONTRACTOR","Licence No.":"T94-4182137","Operating Name":"MR ROOTER PLUMBING SOS","Issued":"2011-05-18","Client Name":"1327656 ONTARIO INC","Business Phone":null,"Business Phone Ext.":null,"Licence Address Line 1":"281 QUEEN ST S","Licence Address Line 2":"MISSISSAUGA, ON","Licence Address Line 3":"L5M 1L9","Ward":null,"Conditions":null,"Free Form Conditions Line 1":null,"Free Form Conditions Line 2":null,"Plate No.":null,"Endorsements":"PLUMBING CONTRACTOR;","Cancel Date":"2025-08-19","Last Record Update":"2025-08-19","rank":0.09016734},{"_id":131120,"Category":"PLUMBING CONTRACTOR","Licence No.":"T94-5587376","Operating Name":"MR. ROOTER PLUMBING OF ETOBICOKE ON","Issued":"2025-10-09","Client Name":"1327656 ONTARIO INC","Business Phone":null,"Business Phone Ext.":null,"Licence Address Line 1":"281 QUEEN ST S","Licence Address Line 2":"MISSISSAUGA, ON","Licence Address Line 3":"L5M 1L9","Ward":null,"Conditions":"OFFICE USE ONLY;","Free Form Conditions Line 1":null,"Free Form Conditions Line 2":null,"Plate No.":null,"Endorsements":"PLUMBING CONTRACTOR;","Cancel Date":null,"Last Record Update":"2025-10-09","rank":0.09016734},{"_id":130509,"Category":"PLUMBING CONTRACTOR","Licence No.":"T94-0239829","Operating Name":"MR ROOTER (TORONTO)","Issued":"1995-09-21","Client Name":"1131071 ONTARIO LTD","Business Phone":null,"Business Phone Ext.":null,"Licence Address Line 1":"71 PENN DR","Licence Address Line 2":"TORONTO, ON","Licence Address Line 3":"M9L 2A6","Ward":7,"Conditions":null,"Free Form Conditions Line 1":null,"Free Form Conditions Line 2":null,"Plate No.":null,"Endorsements":"PLUMBING CONTRACTOR;","Cancel Date":null,"Last Record Update":"2026-07-14","rank":0.09016734},{"_id":126781,"Category":"DRAIN CONTRACTOR","Licence No.":"T87-0244840","Operating Name":"COBRA-ROOTER DRAIN SERVICE","Issued":"1996-07-10","Client Name":"1036266 ONTARIO INC","Business Phone":null,"Business Phone Ext.":null,"Licence Address Line 1":"133 HOLLY MEADOW RD","Licence Address Line 2":"BARRIE, ON","Licence Address Line 3":"L4N 9Z6","Ward":null,"Conditions":"PRE-2009 DRAIN CONTRACTOR;","Free Form Conditions Line 1":"MR JOSEPH MYERS PASSED EXAM FOR DRAIN CONTRACTOR","Free Form Conditions Line 2":null,"Plate No.":null,"Endorsements":"DRAIN CONTRACTOR;","Cancel Date":"2017-07-31","Last Record Update":"2017-07-31","rank":0.001107236},{"_id":126829,"Category":"DRAIN CONTRACTOR","Licence No.":"T87-4750201","Operating Name":"DR ROOTER","Issued":"2017-11-27","Client Name":"8344604 CANADA INC","Business Phone":null,"Business Phone Ext.":null,"Licence Address Line 1":"2578 ST CLAIR AVE W","Licence Address Line 2":"TORONTO, ON","Licence Address Line 3":"M6N 1L8","Ward":5,"Conditions":"MAILING ADDRESS ONLY; MUST COMPLY WITH CITY/ZONING BY-LAWS;","Free Form Conditions Line 1":"MR YURIY YAKOVENKO PASSED EXAM","Free Form Conditions Line 2":null,"Plate No.":null,"Endorsements":"DRAIN CONTRACTOR;","Cancel Date":"2023-02-28","Last Record Update":"2023-02-28","rank":0.00015000078},{"_id":126005,"Category":"BUILDING RENOVATOR","Licence No.":"T85-4657852","Operating Name":"ROTO-ROOTER","Issued":"2016-09-27","Client Name":"SJC ENTERPRISES INC","Business Phone":null,"Business Phone Ext.":null,"Licence Address Line 1":"923 OXFORD ST","Licence Address Line 2":"TORONTO, ON","Licence Address Line 3":"M8Z 5T3","Ward":3,"Conditions":"ALL WORK TO BE SUB-CONTRACTED TO LICENSED RENOVATORS/CONTR.;PLASTERING;DRYWALL;WATERPROOFING;NON-STRUCTURAL FRAMING;TAPING;","Free Form Conditions Line 1":"MR STANLEY COLLINI PASSED EXAM","Free Form Conditions Line 2":null,"Plate No.":null,"Endorsements":"BUILDING RENOVATOR;","Cancel Date":null,"Last Record Update":"2026-07-21","rank":2.0303056e-05},{"_id":122783,"Category":"BUILDING RENOVATOR","Licence No.":"T85-4702641","Operating Name":"DR ROOTER","Issued":"2017-02-17","Client Name":"8344604 CANADA INC","Business Phone":null,"Business Phone Ext.":null,"Licence Address Line 1":"2578 ST CLAIR AVE W","Licence Address Line 2":"TORONTO, ON","Licence Address Line 3":"M6N 1L8","Ward":5,"Conditions":"MAILING ADDRESS ONLY; MUST COMPLY WITH CITY/ZONING BY-LAWS;ALL WORK TO BE SUB-CONTRACTED TO LICENSED RENOVATORS/CONTR.;WATERPROOFING;","Free Form Conditions Line 1":"MR YURIY YAKOVENKO PASSED EXAM","Free Form Conditions Line 2":null,"Plate No.":null,"Endorsements":"BUILDING RENOVATOR;","Cancel Date":"2018-05-20","Last Record Update":"2018-05-20","rank":3.834815e-06}], "fields": [{"id": "_id", "type": "int"}, {"id": "Category", "type": "text", "info": {"notes": "Type of licence or permit"}}, {"id": "Licence No.", "type": "text", "info": {"notes": "Number. of licence issued by City of Toronto"}}, {"id": "Operating Name", "type": "text", "info": {"notes": "Name that company operates under"}}, {"id": "Issued", "type": "date", "info": {"notes": "Date of issue of licence/permit"}}, {"id": "Client Name", "type": "text", "info": {"notes": "Name that the licence is issued to"}}, {"id": "Business Phone", "type": "text", "info": {"notes": "Client Business Phone Number"}}, {"id": "Business Phone Ext.", "type": "text", "info": {"notes": "Client Business Phone Extension Number"}}, {"id": "Licence Address Line 1", "type": "text", "info": {"notes": "First line of client's business address"}}, {"id": "Licence Address Line 2", "type": "text", "info": {"notes": "Client address town and province"}}, {"id": "Licence Address Line 3", "type": "text", "info": {"notes": "Client address postal code"}}, {"id": "Ward", "type": "int4", "info": {"notes": "Client address ward number"}}, {"id": "Conditions", "type": "text", "info": {"notes": "Restriction on the licence/permit recorded in the licensing system"}}, {"id": "Free Form Conditions Line 1", "type": "text", "info": {"notes": "Restriction/comment on the licence/permit"}}, {"id": "Free Form Conditions Line 2", "type": "text", "info": {"notes": "Continuation of line 1"}}, {"id": "Plate No.", "type": "text", "info": {"notes": "Licence identifying plate, issued to most vehicles"}}, {"id": "Endorsements", "type": "text", "info": {"notes": "Activity permitted under the licence"}}, {"id": "Cancel Date", "type": "date", "info": {"notes": "Date the license or permit was cancelled"}}, {"id": "Last Record Update", "type": "date", "info": {"notes": ""}}, {"id": "rank", "type": "float"}], "_links": {"start": "/api/3/action/datastore_search?q=MR+ROOTER&resource_id=169e90ba-3ae0-43dd-8b2f-919e87002f50", "next": "/api/3/action/datastore_search?q=MR+ROOTER&resource_id=169e90ba-3ae0-43dd-8b2f-919e87002f50&offset=100"}, "total": 7, "total_was_estimated": false}}