{"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": "5e360382-fe8b-4592-9617-78a87440bd57", "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.":"1837","Average ratio":"0.8","Median ratio":"0.89"},{"_id":2,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"52606","Average ratio":"0.86","Median ratio":"0.94"},{"_id":3,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"57783","Average ratio":"0.86","Median ratio":"0.94"},{"_id":4,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"3622","Average ratio":"0.71","Median ratio":"0.82"},{"_id":5,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"90885","Average ratio":"0.82","Median ratio":"0.91"},{"_id":6,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"99743","Average ratio":"0.81","Median ratio":"0.91"},{"_id":7,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"4354","Average ratio":"0.35","Median ratio":"0.28"},{"_id":8,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"92928","Average ratio":"0.3","Median ratio":"0.24"},{"_id":9,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"102924","Average ratio":"0.3","Median ratio":"0.24"},{"_id":10,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"6309","Average ratio":"0.14","Median ratio":"0.13"},{"_id":11,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"134393","Average ratio":"0.11","Median ratio":"0.12"},{"_id":12,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"148533","Average ratio":"0.11","Median ratio":"0.12"},{"_id":13,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"688","Average ratio":"0.18","Median ratio":"0.12"},{"_id":14,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"18072","Average ratio":"0.14","Median ratio":"0.1"},{"_id":15,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"19952","Average ratio":"0.14","Median ratio":"0.1"},{"_id":16,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"1047","Average ratio":"0.22","Median ratio":"0.15"},{"_id":17,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"24730","Average ratio":"0.16","Median ratio":"0.11"},{"_id":18,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"27399","Average ratio":"0.17","Median ratio":"0.11"},{"_id":19,"Broad industry":"B.Mining","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"58","Average ratio":"0.61","Median ratio":"0.64"},{"_id":20,"Broad industry":"B.Mining","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"1147","Average ratio":"0.66","Median ratio":"0.71"},{"_id":21,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"1277","Average ratio":"0.66","Median ratio":"0.71"},{"_id":22,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"100","Average ratio":"0.54","Median ratio":"0.62"},{"_id":23,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"1794","Average ratio":"0.61","Median ratio":"0.66"},{"_id":24,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"2001","Average ratio":"0.61","Median ratio":"0.66"},{"_id":25,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"372","Average ratio":"0.39","Median ratio":"0.28"},{"_id":26,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"3676","Average ratio":"0.35","Median ratio":"0.23"},{"_id":27,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"4254","Average ratio":"0.35","Median ratio":"0.23"},{"_id":28,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"487","Average ratio":"0.25","Median ratio":"0.11"},{"_id":29,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"4964","Average ratio":"0.19","Median ratio":"0.1"},{"_id":30,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"5726","Average ratio":"0.2","Median ratio":"0.1"},{"_id":31,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"104","Average ratio":"0.43","Median ratio":"0.4"},{"_id":32,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"1426","Average ratio":"0.31","Median ratio":"0.25"},{"_id":33,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"1607","Average ratio":"0.32","Median ratio":"0.26"},{"_id":34,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"162","Average ratio":"0.45","Median ratio":"0.44"},{"_id":35,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"2274","Average ratio":"0.34","Median ratio":"0.29"},{"_id":36,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"2551","Average ratio":"0.35","Median ratio":"0.29"},{"_id":37,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"3132","Average ratio":"0.62","Median ratio":"0.63"},{"_id":38,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"40946","Average ratio":"0.6","Median ratio":"0.61"},{"_id":39,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"46254","Average ratio":"0.61","Median ratio":"0.62"},{"_id":40,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"4639","Average ratio":"0.57","Median ratio":"0.6"},{"_id":41,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"54836","Average ratio":"0.58","Median ratio":"0.6"},{"_id":42,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"62607","Average ratio":"0.58","Median ratio":"0.6"},{"_id":43,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"5990","Average ratio":"0.33","Median ratio":"0.24"},{"_id":44,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"65210","Average ratio":"0.28","Median ratio":"0.18"},{"_id":45,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"74337","Average ratio":"0.28","Median ratio":"0.19"},{"_id":46,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"7862","Average ratio":"0.2","Median ratio":"0.12"},{"_id":47,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"81829","Average ratio":"0.19","Median ratio":"0.11"},{"_id":48,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"93907","Average ratio":"0.18","Median ratio":"0.11"},{"_id":49,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"1651","Average ratio":"0.27","Median ratio":"0.24"},{"_id":50,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"24748","Average ratio":"0.25","Median ratio":"0.23"},{"_id":51,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"27783","Average ratio":"0.25","Median ratio":"0.23"},{"_id":52,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"2437","Average ratio":"0.3","Median ratio":"0.27"},{"_id":53,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"33283","Average ratio":"0.27","Median ratio":"0.25"},{"_id":54,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"37650","Average ratio":"0.27","Median ratio":"0.25"},{"_id":55,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"107","Average ratio":"0.62","Median ratio":"0.67"},{"_id":56,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"1533","Average ratio":"0.64","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.":"1726","Average ratio":"0.64","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.":"166","Average ratio":"0.57","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.":"2048","Average ratio":"0.62","Median ratio":"0.65"},{"_id":60,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"2336","Average ratio":"0.62","Median ratio":"0.65"},{"_id":61,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"383","Average ratio":"0.32","Median ratio":"0.25"},{"_id":62,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"4001","Average ratio":"0.28","Median ratio":"0.19"},{"_id":63,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"4595","Average ratio":"0.28","Median ratio":"0.2"},{"_id":64,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"516","Average ratio":"0.18","Median ratio":"0.12"},{"_id":65,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"4966","Average ratio":"0.19","Median ratio":"0.13"},{"_id":66,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"5757","Average ratio":"0.18","Median ratio":"0.12"},{"_id":67,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"107","Average ratio":"0.25","Median ratio":"0.22"},{"_id":68,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"1524","Average ratio":"0.24","Median ratio":"0.22"},{"_id":69,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"1707","Average ratio":"0.24","Median ratio":"0.22"},{"_id":70,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"144","Average ratio":"0.28","Median ratio":"0.23"},{"_id":71,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"2035","Average ratio":"0.26","Median ratio":"0.23"},{"_id":72,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"2284","Average ratio":"0.26","Median ratio":"0.23"},{"_id":73,"Broad industry":"E.Construction","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"11266","Average ratio":"0.7","Median ratio":"0.75"},{"_id":74,"Broad industry":"E.Construction","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"109279","Average ratio":"0.67","Median ratio":"0.7"},{"_id":75,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"125734","Average ratio":"0.67","Median ratio":"0.71"},{"_id":76,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"14152","Average ratio":"0.67","Median ratio":"0.72"},{"_id":77,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"131736","Average ratio":"0.64","Median ratio":"0.69"},{"_id":78,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"152486","Average ratio":"0.65","Median ratio":"0.69"},{"_id":79,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"32637","Average ratio":"0.41","Median ratio":"0.4"},{"_id":80,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"276910","Average ratio":"0.38","Median ratio":"0.36"},{"_id":81,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"321095","Average ratio":"0.39","Median ratio":"0.36"},{"_id":82,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"38280","Average ratio":"0.33","Median ratio":"0.3"},{"_id":83,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"315279","Average ratio":"0.32","Median ratio":"0.29"},{"_id":84,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"367336","Average ratio":"0.32","Median ratio":"0.29"},{"_id":85,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"6170","Average ratio":"0.29","Median ratio":"0.26"},{"_id":86,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"64522","Average ratio":"0.25","Median ratio":"0.23"},{"_id":87,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"73939","Average ratio":"0.26","Median ratio":"0.23"},{"_id":88,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"8362","Average ratio":"0.32","Median ratio":"0.29"},{"_id":89,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"82406","Average ratio":"0.28","Median ratio":"0.25"},{"_id":90,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"94968","Average ratio":"0.28","Median ratio":"0.25"},{"_id":91,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Commenced","no.":"2642","Average ratio":"0.36","Median ratio":"0.3"},{"_id":92,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio    ","Profitable status":"Profitable","Business status":"Established","no.":"29834","Average ratio":"0.41","Median ratio":"0.38"},{"_id":93,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"34335","Average ratio":"0.41","Median ratio":"0.37"},{"_id":94,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"3992","Average ratio":"0.33","Median ratio":"0.29"},{"_id":95,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"40537","Average ratio":"0.4","Median ratio":"0.37"},{"_id":96,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"47167","Average ratio":"0.39","Median ratio":"0.36"},{"_id":97,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"3423","Average ratio":"0.17","Median ratio":"0.07"},{"_id":98,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"37674","Average ratio":"0.18","Median ratio":"0.08"},{"_id":99,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"43410","Average ratio":"0.18","Median ratio":"0.08"},{"_id":100,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"4809","Average ratio":"0.07","Median ratio":"0.02"}], "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=5e360382-fe8b-4592-9617-78a87440bd57", "next": "/api/action/datastore_search?resource_id=5e360382-fe8b-4592-9617-78a87440bd57&offset=100"}, "total": 342, "total_was_estimated": false}}