{"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": "a17313e8-df96-4bda-8b2e-aee2c2402bda", "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.":"202","Average ratio":"0.66","Median ratio":"0.72"},{"_id":2,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"4211","Average ratio":"0.73","Median ratio":"0.83"},{"_id":3,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"4804","Average ratio":"0.74","Median ratio":"0.84"},{"_id":4,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"365","Average ratio":"0.63","Median ratio":"0.67"},{"_id":5,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"6550","Average ratio":"0.71","Median ratio":"0.82"},{"_id":6,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"7513","Average ratio":"0.71","Median ratio":"0.82"},{"_id":7,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"521","Average ratio":"0.23","Median ratio":"0.1"},{"_id":8,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"9233","Average ratio":"0.27","Median ratio":"0.15"},{"_id":9,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"10523","Average ratio":"0.27","Median ratio":"0.15"},{"_id":10,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"786","Average ratio":"0.08","Median ratio":"0.02"},{"_id":11,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"12912","Average ratio":"0.13","Median ratio":"0.06"},{"_id":12,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"14775","Average ratio":"0.13","Median ratio":"0.06"},{"_id":13,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"220","Average ratio":"0.26","Median ratio":"0.2"},{"_id":14,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"4041","Average ratio":"0.22","Median ratio":"0.17"},{"_id":15,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"4608","Average ratio":"0.22","Median ratio":"0.17"},{"_id":16,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"354","Average ratio":"0.29","Median ratio":"0.24"},{"_id":17,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"5754","Average ratio":"0.24","Median ratio":"0.19"},{"_id":18,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"6598","Average ratio":"0.24","Median ratio":"0.19"},{"_id":19,"Broad industry":"B.Mining","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"43","Average ratio":"0.63","Median ratio":"0.65"},{"_id":20,"Broad industry":"B.Mining","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"816","Average ratio":"0.63","Median ratio":"0.66"},{"_id":21,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"909","Average ratio":"0.63","Median ratio":"0.66"},{"_id":22,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"81","Average ratio":"0.53","Median ratio":"0.58"},{"_id":23,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"1349","Average ratio":"0.57","Median ratio":"0.6"},{"_id":24,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"1506","Average ratio":"0.57","Median ratio":"0.6"},{"_id":25,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"174","Average ratio":"0.21","Median ratio":"0.08"},{"_id":26,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"2200","Average ratio":"0.26","Median ratio":"0.14"},{"_id":27,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"2497","Average ratio":"0.26","Median ratio":"0.13"},{"_id":28,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"267","Average ratio":"0.07","Median ratio":"0.01"},{"_id":29,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"3188","Average ratio":"0.11","Median ratio":"0.05"},{"_id":30,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"3629","Average ratio":"0.11","Median ratio":"0.04"},{"_id":31,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"78","Average ratio":"0.45","Median ratio":"0.4"},{"_id":32,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"1145","Average ratio":"0.32","Median ratio":"0.26"},{"_id":33,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"1283","Average ratio":"0.33","Median ratio":"0.27"},{"_id":34,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"130","Average ratio":"0.47","Median ratio":"0.46"},{"_id":35,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"1893","Average ratio":"0.35","Median ratio":"0.3"},{"_id":36,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"2112","Average ratio":"0.36","Median ratio":"0.3"},{"_id":37,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"1261","Average ratio":"0.57","Median ratio":"0.58"},{"_id":38,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"18814","Average ratio":"0.56","Median ratio":"0.56"},{"_id":39,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"21284","Average ratio":"0.56","Median ratio":"0.57"},{"_id":40,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"2164","Average ratio":"0.54","Median ratio":"0.56"},{"_id":41,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"27984","Average ratio":"0.54","Median ratio":"0.56"},{"_id":42,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"31948","Average ratio":"0.54","Median ratio":"0.56"},{"_id":43,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"1851","Average ratio":"0.12","Median ratio":"0.05"},{"_id":44,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"24223","Average ratio":"0.14","Median ratio":"0.06"},{"_id":45,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"27629","Average ratio":"0.13","Median ratio":"0.06"},{"_id":46,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"2934","Average ratio":"0.01","Median ratio":"0.01"},{"_id":47,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"34806","Average ratio":"0.05","Median ratio":"0.02"},{"_id":48,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"39965","Average ratio":"0.04","Median ratio":"0.02"},{"_id":49,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"1087","Average ratio":"0.29","Median ratio":"0.26"},{"_id":50,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"15806","Average ratio":"0.26","Median ratio":"0.24"},{"_id":51,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"17858","Average ratio":"0.26","Median ratio":"0.24"},{"_id":52,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"1676","Average ratio":"0.32","Median ratio":"0.28"},{"_id":53,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"22466","Average ratio":"0.29","Median ratio":"0.26"},{"_id":54,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"25519","Average ratio":"0.29","Median ratio":"0.26"},{"_id":55,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"58","Average ratio":"0.58","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.":"819","Average ratio":"0.62","Median ratio":"0.64"},{"_id":57,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"931","Average ratio":"0.62","Median ratio":"0.64"},{"_id":58,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"102","Average ratio":"0.55","Median ratio":"0.64"},{"_id":59,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"1215","Average ratio":"0.58","Median ratio":"0.6"},{"_id":60,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"1396","Average ratio":"0.59","Median ratio":"0.61"},{"_id":61,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"153","Average ratio":"0.17","Median ratio":"0.09"},{"_id":62,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"1628","Average ratio":"0.16","Median ratio":"0.09"},{"_id":63,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"1879","Average ratio":"0.16","Median ratio":"0.09"},{"_id":64,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"233","Average ratio":"0.04","Median ratio":"0.01"},{"_id":65,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"2302","Average ratio":"0.06","Median ratio":"0.03"},{"_id":66,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"2674","Average ratio":"0.06","Median ratio":"0.03"},{"_id":67,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"71","Average ratio":"0.27","Median ratio":"0.23"},{"_id":68,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"974","Average ratio":"0.26","Median ratio":"0.23"},{"_id":69,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"1092","Average ratio":"0.26","Median ratio":"0.23"},{"_id":70,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"101","Average ratio":"0.3","Median ratio":"0.27"},{"_id":71,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"1388","Average ratio":"0.27","Median ratio":"0.25"},{"_id":72,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"1559","Average ratio":"0.28","Median ratio":"0.25"},{"_id":73,"Broad industry":"E.Construction","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"4041","Average ratio":"0.65","Median ratio":"0.69"},{"_id":74,"Broad industry":"E.Construction","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"38362","Average ratio":"0.61","Median ratio":"0.65"},{"_id":75,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"44518","Average ratio":"0.61","Median ratio":"0.65"},{"_id":76,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"5997","Average ratio":"0.63","Median ratio":"0.68"},{"_id":77,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"53482","Average ratio":"0.59","Median ratio":"0.64"},{"_id":78,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"62452","Average ratio":"0.6","Median ratio":"0.65"},{"_id":79,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"7840","Average ratio":"0.13","Median ratio":"0.05"},{"_id":80,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"64093","Average ratio":"0.14","Median ratio":"0.07"},{"_id":81,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"75673","Average ratio":"0.14","Median ratio":"0.06"},{"_id":82,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"11379","Average ratio":"0.04","Median ratio":"0.01"},{"_id":83,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"88338","Average ratio":"0.07","Median ratio":"0.03"},{"_id":84,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"104770","Average ratio":"0.06","Median ratio":"0.02"},{"_id":85,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"4254","Average ratio":"0.32","Median ratio":"0.29"},{"_id":86,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"37802","Average ratio":"0.28","Median ratio":"0.26"},{"_id":87,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"44223","Average ratio":"0.28","Median ratio":"0.26"},{"_id":88,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"6164","Average ratio":"0.35","Median ratio":"0.32"},{"_id":89,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"52345","Average ratio":"0.3","Median ratio":"0.28"},{"_id":90,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"61422","Average ratio":"0.31","Median ratio":"0.28"},{"_id":91,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"1722","Average ratio":"0.32","Median ratio":"0.26"},{"_id":92,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"18288","Average ratio":"0.38","Median ratio":"0.35"},{"_id":93,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"21234","Average ratio":"0.38","Median ratio":"0.34"},{"_id":94,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"2717","Average ratio":"0.3","Median ratio":"0.25"},{"_id":95,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"25892","Average ratio":"0.37","Median ratio":"0.35"},{"_id":96,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"30361","Average ratio":"0.37","Median ratio":"0.34"},{"_id":97,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"1973","Average ratio":"0.09","Median ratio":"0.03"},{"_id":98,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"21517","Average ratio":"0.13","Median ratio":"0.05"},{"_id":99,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"24966","Average ratio":"0.13","Median ratio":"0.05"},{"_id":100,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"2977","Average ratio":"0","Median ratio":"0"}], "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=a17313e8-df96-4bda-8b2e-aee2c2402bda", "next": "/api/action/datastore_search?resource_id=a17313e8-df96-4bda-8b2e-aee2c2402bda&offset=100"}, "total": 342, "total_was_estimated": false}}