{"help": "https://data.yorkopendata.org/en/api/3/action/help_show?name=datastore_search", "success": true, "result": {"include_total": true, "limit": 100, "q": "jones", "records_format": "objects", "resource_id": "5d132ac9-8827-4874-8da7-2f8bcb398c42", "total_estimation_threshold": null, "records": [{"_id":91915,"OrganisationName":"City of York Council","Directorate":"Customer & Business Support","Department":"Customers & People","ExpenseCategory":"Training Course Fees","Supplier_Beneficiary":"Dr Hilary M Jones","SupplierID":"920082","PaymentDate":"30/09/2016","TransactionReference":"CR0000327525","NetAmount_ExcVAT":"1500","rank":0.057308756},{"_id":91916,"OrganisationName":"City of York Council","Directorate":"Customer & Business Support","Department":"Customers & People","ExpenseCategory":"Training Course Fees","Supplier_Beneficiary":"Dr Hilary M Jones","SupplierID":"920082","PaymentDate":"30/09/2016","TransactionReference":"CR0000327525","NetAmount_ExcVAT":"5340","rank":0.057308756},{"_id":112144,"OrganisationName":"City of York Council","Directorate":"City and Environmental Service","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"11/11/2016","TransactionReference":"CR0000331149","NetAmount_ExcVAT":"22312.8","rank":0.057308756},{"_id":116987,"OrganisationName":"City of York Council","Directorate":"City and Environmental Service","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"25/11/2016","TransactionReference":"CR0000332179","NetAmount_ExcVAT":"0","rank":0.057308756},{"_id":116988,"OrganisationName":"City of York Council","Directorate":"City and Environmental Service","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"25/11/2016","TransactionReference":"CR0000332182","NetAmount_ExcVAT":"14733.4","rank":0.057308756},{"_id":116989,"OrganisationName":"City of York Council","Directorate":"City and Environmental Service","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"25/11/2016","TransactionReference":"CR0000332182","NetAmount_ExcVAT":"17122.6","rank":0.057308756},{"_id":120859,"OrganisationName":"City of York Council","Directorate":"Health Housing & Adult So Care","Department":"Housing & Community Safety","ExpenseCategory":"Non Statutory Service Grants","Supplier_Beneficiary":"Mr P Dunn-Jones","SupplierID":"925038","PaymentDate":"01/12/2016","TransactionReference":"CR0000332801","NetAmount_ExcVAT":"300","rank":0.057308756},{"_id":121023,"OrganisationName":"City of York Council","Directorate":"City and Environmental Service","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"02/12/2016","TransactionReference":"CR0000332817","NetAmount_ExcVAT":"14418.8","rank":0.057308756},{"_id":121551,"OrganisationName":"City of York Council","Directorate":"City and Environmental Service","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"06/12/2016","TransactionReference":"CR0000333205","NetAmount_ExcVAT":"14597","rank":0.057308756},{"_id":121968,"OrganisationName":"City of York Council","Directorate":"City and Environmental Service","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"09/12/2016","TransactionReference":"CR0000333474","NetAmount_ExcVAT":"10175","rank":0.057308756},{"_id":124200,"OrganisationName":"City of York Council","Directorate":"City and Environmental Service","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"22/12/2016","TransactionReference":"CR0000334813","NetAmount_ExcVAT":"17122.6","rank":0.057308756},{"_id":126349,"OrganisationName":"City of York Council","Directorate":"City and Environmental Service","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"10/01/2017","TransactionReference":"CR0000335611","NetAmount_ExcVAT":"11453.2","rank":0.057308756},{"_id":130330,"OrganisationName":"City of York Council","Directorate":"Economy and Place","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"01/02/2017","TransactionReference":"CR0000337712","NetAmount_ExcVAT":"3933.6","rank":0.057308756},{"_id":137411,"OrganisationName":"City of York Council","Directorate":"Economy and Place","Department":"LED Light Replacement Prog","ExpenseCategory":"DLO Capital Works","Supplier_Beneficiary":"Jones Lighting Ltd","SupplierID":"927677","PaymentDate":"22/03/2017","TransactionReference":"CR0000341961","NetAmount_ExcVAT":"3657.76","rank":0.057308756}], "fields": [{"id": "_id", "type": "int"}, {"id": "OrganisationName", "type": "text"}, {"id": "Directorate", "type": "text"}, {"id": "Department", "type": "text"}, {"id": "ExpenseCategory", "type": "text"}, {"id": "Supplier_Beneficiary", "type": "text"}, {"id": "SupplierID", "type": "text"}, {"id": "PaymentDate", "type": "text"}, {"id": "TransactionReference", "type": "text"}, {"id": "NetAmount_ExcVAT", "type": "text"}, {"id": "rank", "type": "float"}], "_links": {"start": "/api/action/datastore_search?q=jones&resource_id=5d132ac9-8827-4874-8da7-2f8bcb398c42", "next": "/api/action/datastore_search?q=jones&resource_id=5d132ac9-8827-4874-8da7-2f8bcb398c42&offset=100"}, "total": 14, "total_was_estimated": false}}