{"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": "61f6cc58-4046-40dd-9fc9-e031f608f781", "total_estimation_threshold": null, "records": [{"_id":1,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"568","Average ratio":"1.02","Median ratio":"0.7"},{"_id":2,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Established","no.":"20475","Average ratio":"0.93","Median ratio":"0.68"},{"_id":3,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Total","no.":"21043","Average ratio":"0.93","Median ratio":"0.68"},{"_id":4,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"445","Average ratio":"0.02","Median ratio":"0.03"},{"_id":5,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"17321","Average ratio":"0.02","Median ratio":"0.03"},{"_id":6,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"17766","Average ratio":"0.02","Median ratio":"0.03"},{"_id":7,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"568","Average ratio":"-0.02","Median ratio":"0.02"},{"_id":8,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Established","no.":"20475","Average ratio":"0.01","Median ratio":"0.02"},{"_id":9,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Total","no.":"21043","Average ratio":"0.01","Median ratio":"0.02"},{"_id":10,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"170","Average ratio":"0.13","Median ratio":"0.07"},{"_id":11,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"8539","Average ratio":"0.09","Median ratio":"0.06"},{"_id":12,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"8709","Average ratio":"0.09","Median ratio":"0.06"},{"_id":13,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"219","Average ratio":"0.16","Median ratio":"0.08"},{"_id":14,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Established","no.":"9976","Average ratio":"0.45","Median ratio":"0.06"},{"_id":15,"Broad industry":"A.Agriculture, Forestry and Fishing","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Total","no.":"10195","Average ratio":"0.44","Median ratio":"0.06"},{"_id":16,"Broad industry":"B.Mining","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"12","Average ratio":"0.44","Median ratio":"0.38"},{"_id":17,"Broad industry":"B.Mining","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Established","no.":"771","Average ratio":"0.55","Median ratio":"0.52"},{"_id":18,"Broad industry":"B.Mining","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Total","no.":"783","Average ratio":"0.55","Median ratio":"0.52"},{"_id":19,"Broad industry":"B.Mining","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"10","Average ratio":"0.06","Median ratio":"0.06"},{"_id":20,"Broad industry":"B.Mining","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"715","Average ratio":"0.05","Median ratio":"0.05"},{"_id":21,"Broad industry":"B.Mining","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"725","Average ratio":"0.05","Median ratio":"0.05"},{"_id":22,"Broad industry":"B.Mining","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"12","Average ratio":"0.05","Median ratio":"0.04"},{"_id":23,"Broad industry":"B.Mining","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Established","no.":"771","Average ratio":"0.04","Median ratio":"0.05"},{"_id":24,"Broad industry":"B.Mining","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Total","no.":"783","Average ratio":"0.04","Median ratio":"0.05"},{"_id":25,"Broad industry":"B.Mining","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"3","Average ratio":"na","Median ratio":"na"},{"_id":26,"Broad industry":"B.Mining","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"358","Average ratio":"0.19","Median ratio":"0.13"},{"_id":27,"Broad industry":"B.Mining","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"361","Average ratio":"0.19","Median ratio":"0.13"},{"_id":28,"Broad industry":"B.Mining","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"4","Average ratio":"na","Median ratio":"na"},{"_id":29,"Broad industry":"B.Mining","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Established","no.":"392","Average ratio":"0.2","Median ratio":"0.14"},{"_id":30,"Broad industry":"B.Mining","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Total","no.":"396","Average ratio":"0.2","Median ratio":"0.14"},{"_id":31,"Broad industry":"C.Manufacturing","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"464","Average ratio":"0.77","Median ratio":"0.76"},{"_id":32,"Broad industry":"C.Manufacturing","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Established","no.":"13287","Average ratio":"0.81","Median ratio":"0.7"},{"_id":33,"Broad industry":"C.Manufacturing","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Total","no.":"13751","Average ratio":"0.81","Median ratio":"0.7"},{"_id":34,"Broad industry":"C.Manufacturing","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"378","Average ratio":"0.03","Median ratio":"0.03"},{"_id":35,"Broad industry":"C.Manufacturing","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"12060","Average ratio":"0.03","Median ratio":"0.04"},{"_id":36,"Broad industry":"C.Manufacturing","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"12438","Average ratio":"0.03","Median ratio":"0.04"},{"_id":37,"Broad industry":"C.Manufacturing","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"464","Average ratio":"0.02","Median ratio":"0.03"},{"_id":38,"Broad industry":"C.Manufacturing","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Established","no.":"13287","Average ratio":"0.03","Median ratio":"0.03"},{"_id":39,"Broad industry":"C.Manufacturing","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Total","no.":"13751","Average ratio":"0.03","Median ratio":"0.03"},{"_id":40,"Broad industry":"C.Manufacturing","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"215","Average ratio":"0.2","Median ratio":"0.17"},{"_id":41,"Broad industry":"C.Manufacturing","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"8131","Average ratio":"0.15","Median ratio":"0.12"},{"_id":42,"Broad industry":"C.Manufacturing","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"8346","Average ratio":"0.15","Median ratio":"0.12"},{"_id":43,"Broad industry":"C.Manufacturing","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"262","Average ratio":"0.22","Median ratio":"0.19"},{"_id":44,"Broad industry":"C.Manufacturing","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Established","no.":"8976","Average ratio":"0.16","Median ratio":"0.12"},{"_id":45,"Broad industry":"C.Manufacturing","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Total","no.":"9238","Average ratio":"0.16","Median ratio":"0.12"},{"_id":46,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"38","Average ratio":"0.66","Median ratio":"0.71"},{"_id":47,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Established","no.":"973","Average ratio":"0.64","Median ratio":"0.64"},{"_id":48,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Total","no.":"1011","Average ratio":"0.64","Median ratio":"0.64"},{"_id":49,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"36","Average ratio":"0.02","Median ratio":"0.03"},{"_id":50,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"900","Average ratio":"0.03","Median ratio":"0.04"},{"_id":51,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"936","Average ratio":"0.03","Median ratio":"0.04"},{"_id":52,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"38","Average ratio":"0.02","Median ratio":"0.03"},{"_id":53,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Established","no.":"973","Average ratio":"0.03","Median ratio":"0.04"},{"_id":54,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Total","no.":"1011","Average ratio":"0.03","Median ratio":"0.04"},{"_id":55,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"17","Average ratio":"0.16","Median ratio":"0.15"},{"_id":56,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"523","Average ratio":"0.15","Median ratio":"0.12"},{"_id":57,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"540","Average ratio":"0.15","Median ratio":"0.12"},{"_id":58,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"18","Average ratio":"0.18","Median ratio":"0.15"},{"_id":59,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Established","no.":"569","Average ratio":"0.17","Median ratio":"0.13"},{"_id":60,"Broad industry":"D.Electricity, Gas, Water and Waste Services","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Total","no.":"587","Average ratio":"0.17","Median ratio":"0.13"},{"_id":61,"Broad industry":"E.Construction","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"2462","Average ratio":"1.2","Median ratio":"0.61"},{"_id":62,"Broad industry":"E.Construction","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Established","no.":"44830","Average ratio":"1.84","Median ratio":"0.61"},{"_id":63,"Broad industry":"E.Construction","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Total","no.":"47292","Average ratio":"1.81","Median ratio":"0.61"},{"_id":64,"Broad industry":"E.Construction","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"2247","Average ratio":"0.03","Median ratio":"0.04"},{"_id":65,"Broad industry":"E.Construction","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"41545","Average ratio":"0.04","Median ratio":"0.04"},{"_id":66,"Broad industry":"E.Construction","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"43792","Average ratio":"0.04","Median ratio":"0.04"},{"_id":67,"Broad industry":"E.Construction","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"2462","Average ratio":"0.01","Median ratio":"0.04"},{"_id":68,"Broad industry":"E.Construction","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Established","no.":"44827","Average ratio":"0.02","Median ratio":"0.04"},{"_id":69,"Broad industry":"E.Construction","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Total","no.":"47289","Average ratio":"0.02","Median ratio":"0.04"},{"_id":70,"Broad industry":"E.Construction","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"826","Average ratio":"0.21","Median ratio":"0.18"},{"_id":71,"Broad industry":"E.Construction","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"20305","Average ratio":"0.16","Median ratio":"0.13"},{"_id":72,"Broad industry":"E.Construction","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"21131","Average ratio":"0.16","Median ratio":"0.13"},{"_id":73,"Broad industry":"E.Construction","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"928","Average ratio":"0.23","Median ratio":"0.18"},{"_id":74,"Broad industry":"E.Construction","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Established","no.":"21799","Average ratio":"0.63","Median ratio":"0.13"},{"_id":75,"Broad industry":"E.Construction","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Total","no.":"22727","Average ratio":"0.61","Median ratio":"0.13"},{"_id":76,"Broad industry":"F.Wholesale Trade","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"331","Average ratio":"0.9","Median ratio":"0.87"},{"_id":77,"Broad industry":"F.Wholesale Trade","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Established","no.":"8637","Average ratio":"0.78","Median ratio":"0.8"},{"_id":78,"Broad industry":"F.Wholesale Trade","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Total","no.":"8968","Average ratio":"0.78","Median ratio":"0.81"},{"_id":79,"Broad industry":"F.Wholesale Trade","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"230","Average ratio":"0.02","Median ratio":"0.02"},{"_id":80,"Broad industry":"F.Wholesale Trade","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"7358","Average ratio":"0.02","Median ratio":"0.02"},{"_id":81,"Broad industry":"F.Wholesale Trade","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"7588","Average ratio":"0.02","Median ratio":"0.02"},{"_id":82,"Broad industry":"F.Wholesale Trade","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"331","Average ratio":"0","Median ratio":"0.01"},{"_id":83,"Broad industry":"F.Wholesale Trade","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Established","no.":"8637","Average ratio":"0.02","Median ratio":"0.02"},{"_id":84,"Broad industry":"F.Wholesale Trade","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Total","no.":"8968","Average ratio":"0.02","Median ratio":"0.02"},{"_id":85,"Broad industry":"F.Wholesale Trade","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"93","Average ratio":"0.15","Median ratio":"0.13"},{"_id":86,"Broad industry":"F.Wholesale Trade","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"4602","Average ratio":"0.1","Median ratio":"0.07"},{"_id":87,"Broad industry":"F.Wholesale Trade","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"4695","Average ratio":"0.1","Median ratio":"0.07"},{"_id":88,"Broad industry":"F.Wholesale Trade","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"137","Average ratio":"0.16","Median ratio":"0.13"},{"_id":89,"Broad industry":"F.Wholesale Trade","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Established","no.":"5367","Average ratio":"0.11","Median ratio":"0.07"},{"_id":90,"Broad industry":"F.Wholesale Trade","Ratio":"Wages to sales ratio","Profitable status":"All","Business status":"Total","no.":"5504","Average ratio":"0.11","Median ratio":"0.07"},{"_id":91,"Broad industry":"G.Retail Trade","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"1063","Average ratio":"0.98","Median ratio":"0.94"},{"_id":92,"Broad industry":"G.Retail Trade","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Established","no.":"22416","Average ratio":"0.88","Median ratio":"0.85"},{"_id":93,"Broad industry":"G.Retail Trade","Ratio":"Expenses to sales ratio","Profitable status":"All","Business status":"Total","no.":"23479","Average ratio":"0.88","Median ratio":"0.86"},{"_id":94,"Broad industry":"G.Retail Trade","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"649","Average ratio":"0.01","Median ratio":"0.02"},{"_id":95,"Broad industry":"G.Retail Trade","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Established","no.":"19059","Average ratio":"0.02","Median ratio":"0.02"},{"_id":96,"Broad industry":"G.Retail Trade","Ratio":"GST to sales ratio","Profitable status":"Profitable","Business status":"Total","no.":"19708","Average ratio":"0.02","Median ratio":"0.02"},{"_id":97,"Broad industry":"G.Retail Trade","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Commenced","no.":"1063","Average ratio":"-0.01","Median ratio":"0"},{"_id":98,"Broad industry":"G.Retail Trade","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Established","no.":"22415","Average ratio":"0.01","Median ratio":"0.02"},{"_id":99,"Broad industry":"G.Retail Trade","Ratio":"GST to sales ratio","Profitable status":"All","Business status":"Total","no.":"23478","Average ratio":"0.01","Median ratio":"0.02"},{"_id":100,"Broad industry":"G.Retail Trade","Ratio":"Wages to sales ratio","Profitable status":"Profitable","Business status":"Commenced","no.":"347","Average ratio":"0.13","Median ratio":"0.1"}], "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=61f6cc58-4046-40dd-9fc9-e031f608f781", "next": "/api/action/datastore_search?resource_id=61f6cc58-4046-40dd-9fc9-e031f608f781&offset=100"}, "total": 285, "total_was_estimated": false}}