{"help": "https://data.gov.au/data/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "a5e8e3cf-4329-491b-bd03-5621fba34ee7", "total_estimation_threshold": null, "records": [{"_id":1,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"807","Average ratio":"0.84","Median ratio":"0.91"},{"_id":2,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"27391","Average ratio":"0.89","Median ratio":"0.95"},{"_id":3,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"30202","Average ratio":"0.88","Median ratio":"0.94"},{"_id":4,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"1655","Average ratio":"0.74","Median ratio":"0.85"},{"_id":5,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"46962","Average ratio":"0.84","Median ratio":"0.92"},{"_id":6,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"51847","Average ratio":"0.84","Median ratio":"0.92"},{"_id":7,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"1446","Average ratio":"0.29","Median ratio":"0.23"},{"_id":8,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"41464","Average ratio":"0.26","Median ratio":"0.22"},{"_id":9,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"46017","Average ratio":"0.27","Median ratio":"0.22"},{"_id":10,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"2247","Average ratio":"0.06","Median ratio":"0.09"},{"_id":11,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"61548","Average ratio":"0.07","Median ratio":"0.11"},{"_id":12,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"68196","Average ratio":"0.08","Median ratio":"0.11"},{"_id":13,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"224","Average ratio":"0.12","Median ratio":"0.08"},{"_id":14,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"7416","Average ratio":"0.11","Median ratio":"0.08"},{"_id":15,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"8069","Average ratio":"0.11","Median ratio":"0.08"},{"_id":16,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"309","Average ratio":"0.14","Median ratio":"0.09"},{"_id":17,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"9782","Average ratio":"0.12","Median ratio":"0.08"},{"_id":18,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"10664","Average ratio":"0.12","Median ratio":"0.09"},{"_id":19,"Broad industry":"B.Mining","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"2","Average ratio":"na","Median ratio":"na"},{"_id":20,"Broad industry":"B.Mining","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"81","Average ratio":"0.75","Median ratio":"0.84"},{"_id":21,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"89","Average ratio":"0.75","Median ratio":"0.84"},{"_id":22,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"3","Average ratio":"na","Median ratio":"na"},{"_id":23,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"104","Average ratio":"0.76","Median ratio":"0.87"},{"_id":24,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"119","Average ratio":"0.76","Median ratio":"0.87"},{"_id":25,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"8","Average ratio":"0.41","Median ratio":"0.29"},{"_id":26,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"244","Average ratio":"0.4","Median ratio":"0.34"},{"_id":27,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"272","Average ratio":"0.39","Median ratio":"0.32"},{"_id":28,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"10","Average ratio":"0.3","Median ratio":"0.17"},{"_id":29,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"303","Average ratio":"0.26","Median ratio":"0.23"},{"_id":30,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"341","Average ratio":"0.25","Median ratio":"0.22"},{"_id":31,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"1","Average ratio":"na","Median ratio":"na"},{"_id":32,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"45","Average ratio":"0.17","Median ratio":"0.13"},{"_id":33,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"48","Average ratio":"0.18","Median ratio":"0.14"},{"_id":34,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"2","Average ratio":"na","Median ratio":"na"},{"_id":35,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"51","Average ratio":"0.19","Median ratio":"0.14"},{"_id":36,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"58","Average ratio":"0.2","Median ratio":"0.17"},{"_id":37,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"355","Average ratio":"0.63","Median ratio":"0.64"},{"_id":38,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"4876","Average ratio":"0.64","Median ratio":"0.65"},{"_id":39,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"5619","Average ratio":"0.64","Median ratio":"0.65"},{"_id":40,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"453","Average ratio":"0.58","Median ratio":"0.62"},{"_id":41,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"5804","Average ratio":"0.62","Median ratio":"0.63"},{"_id":42,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"6772","Average ratio":"0.62","Median ratio":"0.63"},{"_id":43,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"544","Average ratio":"0.34","Median ratio":"0.29"},{"_id":44,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"7109","Average ratio":"0.3","Median ratio":"0.26"},{"_id":45,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"8187","Average ratio":"0.31","Median ratio":"0.26"},{"_id":46,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"660","Average ratio":"0.23","Median ratio":"0.23"},{"_id":47,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"8216","Average ratio":"0.23","Median ratio":"0.21"},{"_id":48,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"9549","Average ratio":"0.23","Median ratio":"0.21"},{"_id":49,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"104","Average ratio":"0.2","Median ratio":"0.17"},{"_id":50,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"1902","Average ratio":"0.2","Median ratio":"0.19"},{"_id":51,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"2144","Average ratio":"0.2","Median ratio":"0.19"},{"_id":52,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"127","Average ratio":"0.21","Median ratio":"0.18"},{"_id":53,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"2152","Average ratio":"0.22","Median ratio":"0.2"},{"_id":54,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"2446","Average ratio":"0.22","Median ratio":"0.19"},{"_id":55,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"15","Average ratio":"0.63","Median ratio":"0.62"},{"_id":56,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"187","Average ratio":"0.66","Median ratio":"0.67"},{"_id":57,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"214","Average ratio":"0.66","Median ratio":"0.67"},{"_id":58,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"15","Average ratio":"0.63","Median ratio":"0.62"},{"_id":59,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"208","Average ratio":"0.67","Median ratio":"0.68"},{"_id":60,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"241","Average ratio":"0.66","Median ratio":"0.68"},{"_id":61,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"40","Average ratio":"0.37","Median ratio":"0.26"},{"_id":62,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"530","Average ratio":"0.33","Median ratio":"0.29"},{"_id":63,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"613","Average ratio":"0.33","Median ratio":"0.29"},{"_id":64,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"45","Average ratio":"0.3","Median ratio":"0.23"},{"_id":65,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"592","Average ratio":"0.27","Median ratio":"0.24"},{"_id":66,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"689","Average ratio":"0.27","Median ratio":"0.24"},{"_id":67,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"4","Average ratio":"na","Median ratio":"na"},{"_id":68,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"136","Average ratio":"0.17","Median ratio":"0.16"},{"_id":69,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"153","Average ratio":"0.17","Median ratio":"0.16"},{"_id":70,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"4","Average ratio":"na","Median ratio":"na"},{"_id":71,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"145","Average ratio":"0.18","Median ratio":"0.16"},{"_id":72,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"164","Average ratio":"0.18","Median ratio":"0.16"},{"_id":73,"Broad industry":"E.Construction","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"998","Average ratio":"0.68","Median ratio":"0.72"},{"_id":74,"Broad industry":"E.Construction","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"12620","Average ratio":"0.68","Median ratio":"0.71"},{"_id":75,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"14700","Average ratio":"0.68","Median ratio":"0.71"},{"_id":76,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"1119","Average ratio":"0.65","Median ratio":"0.7"},{"_id":77,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"13942","Average ratio":"0.66","Median ratio":"0.7"},{"_id":78,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"16325","Average ratio":"0.66","Median ratio":"0.7"},{"_id":79,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"2368","Average ratio":"0.42","Median ratio":"0.4"},{"_id":80,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"29476","Average ratio":"0.39","Median ratio":"0.37"},{"_id":81,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"34041","Average ratio":"0.39","Median ratio":"0.37"},{"_id":82,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"2600","Average ratio":"0.36","Median ratio":"0.37"},{"_id":83,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"31956","Average ratio":"0.34","Median ratio":"0.34"},{"_id":84,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"37040","Average ratio":"0.34","Median ratio":"0.34"},{"_id":85,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"302","Average ratio":"0.22","Median ratio":"0.18"},{"_id":86,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"5297","Average ratio":"0.21","Median ratio":"0.18"},{"_id":87,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"5943","Average ratio":"0.21","Median ratio":"0.18"},{"_id":88,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"328","Average ratio":"0.23","Median ratio":"0.19"},{"_id":89,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"5682","Average ratio":"0.22","Median ratio":"0.19"},{"_id":90,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"6395","Average ratio":"0.22","Median ratio":"0.19"},{"_id":91,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"134","Average ratio":"0.39","Median ratio":"0.32"},{"_id":92,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"2412","Average ratio":"0.48","Median ratio":"0.43"},{"_id":93,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"2732","Average ratio":"0.48","Median ratio":"0.42"},{"_id":94,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"202","Average ratio":"0.37","Median ratio":"0.3"},{"_id":95,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"3084","Average ratio":"0.47","Median ratio":"0.43"},{"_id":96,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"3533","Average ratio":"0.46","Median ratio":"0.42"},{"_id":97,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"189","Average ratio":"0.27","Median ratio":"0.17"},{"_id":98,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"3196","Average ratio":"0.24","Median ratio":"0.16"},{"_id":99,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"3627","Average ratio":"0.24","Median ratio":"0.16"},{"_id":100,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"261","Average ratio":"0.13","Median ratio":"0.09"}], "fields": [{"id": "_id", "type": "int"}, {"id": "Broad industry", "type": "text"}, {"id": "Ratio", "type": "text"}, {"id": "Profitable status", "type": "text"}, {"id": "Business status", "type": "text"}, {"id": "no.", "type": "text"}, {"id": "Average ratio", "type": "text"}, {"id": "Median ratio", "type": "text"}], "_links": {"start": "/api/action/datastore_search?resource_id=a5e8e3cf-4329-491b-bd03-5621fba34ee7", "next": "/api/action/datastore_search?resource_id=a5e8e3cf-4329-491b-bd03-5621fba34ee7&offset=100"}, "total": 342, "total_was_estimated": false}}