{"help": "https://data.gov.au/data/en/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "records_format": "objects", "resource_id": "3237ada2-9c2e-4d96-88a0-40b01bfb5a79", "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.":"784","Average ratio":"0.85","Median ratio":"0.92"},{"_id":2,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"27426","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.":"30235","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.":"1582","Average ratio":"0.75","Median ratio":"0.86"},{"_id":5,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"47844","Average ratio":"0.83","Median ratio":"0.91"},{"_id":6,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"52767","Average ratio":"0.82","Median ratio":"0.91"},{"_id":7,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"1442","Average ratio":"0.28","Median ratio":"0.24"},{"_id":8,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"41560","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.":"46026","Average ratio":"0.26","Median ratio":"0.22"},{"_id":10,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"2245","Average ratio":"0.05","Median ratio":"0.09"},{"_id":11,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"62032","Average ratio":"0.06","Median ratio":"0.1"},{"_id":12,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"68704","Average ratio":"0.06","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.":"228","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.":"7470","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.":"8114","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.":"287","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.":"9710","Average ratio":"0.12","Median ratio":"0.09"},{"_id":18,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"10547","Average ratio":"0.13","Median ratio":"0.09"},{"_id":19,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"6","Average ratio":"0.55","Median ratio":"0.54"},{"_id":20,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"91","Average ratio":"0.77","Median ratio":"0.85"},{"_id":21,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"104","Average ratio":"0.76","Median ratio":"0.85"},{"_id":22,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"8","Average ratio":"0.59","Median ratio":"0.6"},{"_id":23,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"114","Average ratio":"0.74","Median ratio":"0.81"},{"_id":24,"Broad industry":"B.Mining","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"135","Average ratio":"0.74","Median ratio":"0.82"},{"_id":25,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"24","Average ratio":"0.37","Median ratio":"0.24"},{"_id":26,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"248","Average ratio":"0.4","Median ratio":"0.36"},{"_id":27,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"293","Average ratio":"0.4","Median ratio":"0.35"},{"_id":28,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"25","Average ratio":"0.36","Median ratio":"0.24"},{"_id":29,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"304","Average ratio":"0.28","Median ratio":"0.25"},{"_id":30,"Broad industry":"B.Mining","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"359","Average ratio":"0.27","Median ratio":"0.24"},{"_id":31,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"5","Average ratio":"0.2","Median ratio":"0.11"},{"_id":32,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"48","Average ratio":"0.16","Median ratio":"0.16"},{"_id":33,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"56","Average ratio":"0.17","Median ratio":"0.16"},{"_id":34,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"5","Average ratio":"0.2","Median ratio":"0.11"},{"_id":35,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"57","Average ratio":"0.18","Median ratio":"0.16"},{"_id":36,"Broad industry":"B.Mining","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"67","Average ratio":"0.19","Median ratio":"0.17"},{"_id":37,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"347","Average ratio":"0.62","Median ratio":"0.62"},{"_id":38,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"5090","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.":"5857","Average ratio":"0.64","Median ratio":"0.64"},{"_id":40,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"447","Average ratio":"0.59","Median ratio":"0.61"},{"_id":41,"Broad industry":"C.Manufacturing","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"6031","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.":"7030","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.":"529","Average ratio":"0.33","Median ratio":"0.28"},{"_id":44,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"7477","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.":"8588","Average ratio":"0.3","Median ratio":"0.26"},{"_id":46,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"652","Average ratio":"0.22","Median ratio":"0.22"},{"_id":47,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"8566","Average ratio":"0.23","Median ratio":"0.22"},{"_id":48,"Broad industry":"C.Manufacturing","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Total","no.":"9947","Average ratio":"0.23","Median ratio":"0.22"},{"_id":49,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"104","Average ratio":"0.19","Median ratio":"0.17"},{"_id":50,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"1956","Average ratio":"0.2","Median ratio":"0.18"},{"_id":51,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"2183","Average ratio":"0.2","Median ratio":"0.18"},{"_id":52,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Commenced","no.":"129","Average ratio":"0.23","Median ratio":"0.19"},{"_id":53,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"2212","Average ratio":"0.22","Median ratio":"0.19"},{"_id":54,"Broad industry":"C.Manufacturing","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"2497","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.76"},{"_id":56,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"173","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.":"207","Average ratio":"0.66","Median ratio":"0.68"},{"_id":58,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"19","Average ratio":"0.62","Median ratio":"0.7"},{"_id":59,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"202","Average ratio":"0.65","Median ratio":"0.67"},{"_id":60,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Total","no.":"244","Average ratio":"0.65","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.":"29","Average ratio":"0.29","Median ratio":"0.23"},{"_id":62,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"525","Average ratio":"0.32","Median ratio":"0.28"},{"_id":63,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"604","Average ratio":"0.32","Median ratio":"0.27"},{"_id":64,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"42","Average ratio":"0.09","Median ratio":"0.15"},{"_id":65,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"599","Average ratio":"0.25","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.":"700","Average ratio":"0.24","Median ratio":"0.23"},{"_id":67,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"7","Average ratio":"0.16","Median ratio":"0.13"},{"_id":68,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Established","no.":"126","Average ratio":"0.18","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.":"147","Average ratio":"0.18","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.":"9","Average ratio":"0.21","Median ratio":"0.21"},{"_id":71,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"134","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.":"157","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.":"949","Average ratio":"0.68","Median ratio":"0.73"},{"_id":74,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"12847","Average ratio":"0.69","Median ratio":"0.72"},{"_id":75,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"14868","Average ratio":"0.69","Median ratio":"0.72"},{"_id":76,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"1072","Average ratio":"0.65","Median ratio":"0.71"},{"_id":77,"Broad industry":"E.Construction","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"14164","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.":"16516","Average ratio":"0.66","Median ratio":"0.71"},{"_id":79,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"2449","Average ratio":"0.43","Median ratio":"0.42"},{"_id":80,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"30152","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.":"34890","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.":"2668","Average ratio":"0.38","Median ratio":"0.38"},{"_id":83,"Broad industry":"E.Construction","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Established","no.":"32668","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.":"37936","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.":"306","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.":"5389","Average ratio":"0.2","Median ratio":"0.18"},{"_id":87,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"Profitable","Business status":"Total","no.":"6055","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.":"324","Average ratio":"0.22","Median ratio":"0.18"},{"_id":89,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Established","no.":"5803","Average ratio":"0.21","Median ratio":"0.19"},{"_id":90,"Broad industry":"E.Construction","Ratio":"Wage to turnover ratio","Profitable status":"All","Business status":"Total","no.":"6528","Average ratio":"0.21","Median ratio":"0.19"},{"_id":91,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"173","Average ratio":"0.42","Median ratio":"0.38"},{"_id":92,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"2536","Average ratio":"0.48","Median ratio":"0.44"},{"_id":93,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"2893","Average ratio":"0.48","Median ratio":"0.44"},{"_id":94,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Commenced","no.":"249","Average ratio":"0.37","Median ratio":"0.34"},{"_id":95,"Broad industry":"F.Wholesale Trade","Ratio":"Gross profit ratio","Profitable status":"All","Business status":"Established","no.":"3169","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.":"3677","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.":"222","Average ratio":"0.22","Median ratio":"0.15"},{"_id":98,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Established","no.":"3357","Average ratio":"0.23","Median ratio":"0.16"},{"_id":99,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"Profitable","Business status":"Total","no.":"3827","Average ratio":"0.23","Median ratio":"0.16"},{"_id":100,"Broad industry":"F.Wholesale Trade","Ratio":"Net profit ratio","Profitable status":"All","Business status":"Commenced","no.":"304","Average ratio":"0.09","Median ratio":"0.07"}], "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=3237ada2-9c2e-4d96-88a0-40b01bfb5a79", "next": "/api/action/datastore_search?resource_id=3237ada2-9c2e-4d96-88a0-40b01bfb5a79&offset=100"}, "total": 342, "total_was_estimated": false}}