{
  "fields": [{"id":"_id","type":"int"},{"id":"Reference Number","type":"text"},{"id":"Title of Agreement","type":"text"},{"id":"Department Responsible","type":"text"},{"id":"Description of Goods and/or Services Provided","type":"text"},{"id":"Supplier Name and Details","type":"text"},{"id":"Sum to be paid over the length of the Contract","type":"text"},{"id":"Value Added Tax that can't be Recovered","type":"text"},{"id":"Contract Start Date","type":"text"},{"id":"Contract End Date","type":"text"},{"id":"Contract Type","type":"text"},{"id":"Contract Category","type":"text"},{"id":"Enterprise Category","type":"text"},{"id":"Sector Type","type":"text"},{"id":"Company / Charity Reg No.","type":"text"}],
  "records": [
    [1,"P000001","Support and Maintenance of VMDS, VMDS GPS, AIUS, CMS, CMS Realtime, DIDS, Hydra, STEPS and STEPS Gazetteer","Technical Services","Support and maintenance of MDT and ICU hardware and software","Airbus Defence and Space","£76,897",null,"01/04/2015","31/03/2017","OJEU","Department for Communities and Local Government","Enterprise","Private","2449259"],
    [2,"P000002","Airwave Service Fee Recharge inc. SAN J Uplift","Technical Services","The Airwave network is a mobile communications network dedicated for the use by emergency Services in Great Britain. The contract is held by Central Government and is rechargeable to the FRS. The value is based on the average annual recharge to NYFRS over the term of the contract.","Airwave","£3,365,556",null,"01/04/2010","30/03/2019","OJEU","Department for Communities and Local Government","Medium Business","Private","3985643"],
    [3,"P000003","Breathing Air Compressor Servicing and Maintenance","Technical Services","Annual B.A. Compressor Inspection, testing and maintenance","Revolution Air Services","£17,212",null,"01/04/2016","31/03/2018","Tender","Tender","Micro Business","Private","7666072"],
    [4,"P000004","Breathing apparatus Total Care package ","Risk Management","01/07/13 Amendment to add hands free communication equipment £3750 per annum","Draeger","£45,500",null,"01/02/2013","01/01/2028","Tender","0","Enterprise","Private","0"],
    [5,"P000005","Building Cleaning","Technical Services","Year one contract value shown, contract subject to annual inflation calculation based on RPI. One year contract extension taken up. Contract bespoke to and tendered by NYFRS ","Superclean Services Wothorpe Ltd","£824,160",null,"01/04/2006","01/10/2017","Tender","0","Small Business","Private","3731435"],
    [6,"P000006","Building Maintenance  ","Technical Services","Responsive building maintenance with the facility for some minor works and planned maintenance.  Contract value is not fixed as this is a responsive call off contract. Budget levels are currently set at £110,000 pa.","Tom Willoughby Ltd","£175,000",null,"01/08/2013","31/03/2018","Framework","NYCC framework Contract","Medium Business","Private","00703979"],
    [7,"P000007","Building Maintenance  Contract Support","Technical Services","Building Maintenance including provision of Help Desk facility and measurement, valuation and invoice preparation of the Building Maintenance Contract works. Contract accessed through NYCC Consultants Framework Contract arrangements. Value based on scale of annual maintenance work carried out","North Yorkshire County Council","£0",null,"01/04/2017","31/03/2018","0","SLA (Service Level Agreement)","0","Public","0"],
    [8,"P000008","Capita System Support and Maintenance","Technical Services","Maintenance and Support for Capita supplied DS3000 and VISION mobilising systems. Right of use to licensing used within the system.","Capita Justice and Secure Services ","£660,000",null,"01/03/2013","31/03/2023","Tender","Tender","Enterprise","Private","4746912"],
    [9,"P000009","Software Support and Maintenance Agreement (Capital Asset Register)","Technical Services","Support and maintenance of Finance operated software for Capital Asset Register","CIPFA","£14,400",null,"01/04/2014","30/03/2017","Single Supplier","Single Supplier Contract","Medium Business","Public","2376684"],
    [10,"P000010","CFRMIS Support and Maintenance","Technical Services","Support and maintenance of CFRMIS system","Civica ","£17,521",null,"07/09/2016","06/09/2017","Single Supplier","Single Supplier Contract","Enterprise","Private","2449259"],
    [11,"P000011","Chemdata","Risk Management","Chemical hazard database for use by training operational personnel.  ","NCEC","£18,290",null,"01/04/2014","31/03/2017","Quote","Annual Subscription ","Multi National","Private","0"],
    [12,"P000013","Committee Services SLA and legal Services SLA","Financial Services","Provision of Committee Services","North Yorkshire County Council","£81,570",null,"01/04/2011","31/03/2017","0","SLA (Service Level Agreement)","0","Public","0"],
    [13,"P000014","Courier Services","Technical Services","Courier Service","Paul Mackley Courier Services","£67,080",null,"31/03/2015","01/04/2018","Tender","0","Small Business","Private","0"],
    [14,"P000015","DR Rack and Services","Technical Services","Disaster recovery IT rack and facilities (power and cooling)","Knowledge IT An Onyx Group Company","£15,470",null,"01/04/2016","31/03/2017","Prefered Supplier","Preferred Supplier","Medium Business","Private","1554385"],
    [15,"P000016","Electricity Supply","Technical Services","Contract for the supply of electricity to all NYFRS sites.","N Power","£374,564",null,"01/11/2014","31/03/2017","Framework","Yorkshire Purchasing Organisation","Multi National","Private","0"],
    [16,"P000017","EMC SAN Maintenance","Technical Services","Maintenance for EMC network based storage systems including parts, labour and 24 hour monitoring of both systems.","VS Proactive","£58,518",null,"01/04/2014","31/03/2019","3 Quotes","Quotation","Small Business","Private","5327635"],
    [17,"P000018","Employee Assistance Programme","Human Resources","Provision of confidential advice and assistance services. ","Care First","£40,240",null,"01/12/2012","30/11/2017","Tender","Competitive","0","Private","0"],
    [18,"P000019","Employer & Public Liability Insurance","Financial Services","Combined Public Liability Insurance Policy","Arthur J  Gallagher (UK) Ltd Partner in Risk Management Partners","£166,724",null,"01/10/2013","30/09/2018","Tender","0","0","Private","0"],
    [19,"P000020","Engineering Insurance and Inspection","Financial Services","Provision of engineering insurance and inspections","Zurich Municipal","£145,030",null,"01/10/2013","30/09/2018","Tender","0","0","Private","0"],
    [20,"P000021","Finance SLA - Finance","Financial Services","Provision of Financial Ledger, Treasury Management, Risk Management, Internal Audit","North Yorkshire County Council","£55,017",null,"01/04/2016","31/03/2017","0","SLA (Service Level Agreement)","0","Public","0"],
    [21,"P000022","Finance SLA - Payroll","Financial Services","Managed payroll system ","North Yorkshire County Council","£21,252",null,"19/09/2007","31/03/2017","0","SLA (Service Level Agreement)","0","Public","0"],
    [22,"P000023","Fire Appliances & Equipment","Technical Services","4 new fire appliances per year.","Emergency One ","£4,000,000",null,"01/04/2011","01/04/2015","Framework","Firebuy","Medium Business ","Private","0"],
    [23,"P000024","FireWatch HR & Availability System","Human Resources","Accumulative module purchase of a HR, attendance, Occupational Health and Health and Safety system and IPDS training system integrated between Fortek Vision Control system and FireWatch.","Infographics UK Ltd","£185,500",null,"23/02/2010","23/02/2016","Tender","0","0","Private","0"],
    [24,"P000025","FleetPlan & Unidata","Technical Services","Fleet management system","Civica","£13,557",null,"01/10/2014","30/09/2016","0","0","Unknown","Private","3600842"],
    [25,"P000026","FPS and NFPS Administration and associated Payroll","Human Resources","Administration of the Firefighters pension and compensation schemes and pension payment. ","West Yorkshire Pension Fund","£202,320",null,"01/10/2011","30/09/2017","Tender","0","0","Public","0"],
    [26,"P000027","Fuel for Vehicles","Technical Services","Supply of Bulk Fuel for Vehicles","Bayford & Co Ltd","£241,427",null,null,null,"Framework","Yorkshire Purchasing Organisation","0","Private","4168225"],
    [27,"P000028","Gas Supply","Technical Services","Supply of Gas","Corona","£380,000",null,null,"01/04/2021","Framework","Yorkshire Purchasing Organisation","Multi National","Private","0"],
    [28,"P000029","Hydraulic Rescue Equipment and Rescue Airbags ","Risk Management","Annual service, performance testing and certification of hydraulic equipment.","Weber Rescue UK Limited","£52,500",null,"15/09/2014","12/09/2017","Consortium Framework agreement FBTC/ERE/016/2","Consortium Framework Agreement FBTC/ERE/016/3","Multi National","Private","6031223"],
    [29,"P000031","LearnPro","Human Resources","Computerised modular training programme.","Learn Pro","£22,466",null,"01/02/2007","31/01/2018","0","Single Supplier Contract","0","Private","0"],
    [30,"P000033","Lease of Multi Function Devices","Financial Services","Lease of Multi Funtion Devices throughout the service","Xerox (UK) Limited","£63,113",null,"17/04/2015","17/04/2020","Framework","Yorkshire Purchasing Organisation","Enterrpise","Private","0"],
    [31,"P000035","Operational PPE","Risk Management","Provision of Personal Protective Equipment for workforce.","Ballyclare Ltd","£2,671,595",null,"05/03/2012","04/03/2020","Framework","Framework","0","Private","7463998"],
    [32,"P000036","Vodafone Direct Call-Off","Technical Services","Provision of Mobile phones","Vodafone","£23,000",null,"24/02/2015","23/02/2017","Framework","Public Services Network","Enterprise","Private","1471587"],
    [33,"P000037","PFI Contract","Technical Services","Twenty-Five year PFI Contract for Training Centre and Huntington Fire Station","Semperian/LBS","£27,160,000",null,"23/05/2002","23/04/2027","PFI","Privately Financed Initiative","0","Private","6786026"],
    [34,"P000038","R.T.C. Hydraulic Equipment","Risk Management","Annual Inspection of R.T.C. Equipment.","Weber Hydraulics","£65,811",null,"23/08/2014","25/08/2017","Framework","Firebuy","Medium Business ","Private","6031223"],
    [35,"P000040","Station End Maintenance","Technical Services","Station end mobilising cabinet maintenance (originated from RCC Project)","Multitone Electronics PLC","£5,706",null,"01/04/2016","31/03/2017","Framework","Department for Communities and Local Government","Medium Business","Private","256314"],
    [36,"P000042","Supply of Smoke Alarms ","Risk Management","Supply of Smoke alarms for Fitting in Domestic properties","Sprue Safety Products Ltd","£40,000",null,"03/04/2013","31/03/2017","Mini Competition Framework","Competitive Dialogue","0","Private","3641019"],
    [37,"P000043","Supply, installation  and maintenance of a command and control mobilising system and associated sub systems.","Service Delivery","Provision of  mobilising system, ICCS Software for the status messaging and AVLS on the MDTs.   \n","Fortek Computers Limited","£1,050,000",null,"16/01/2012","15/01/2022","Tender","0","0","Private","1587856"],
    [38,"P000044","Telephony Services","Technical Services","Traditional Telephony Services Extension option 1 + 1","Daisy Telecom Ltd","£94,215",null,"01/04/2014","31/03/2017","Framework","Direct Award Framework Crown commercial Services","Medium Business","Private","6977942"],
    [39,"P000046","Vehicle Insurance","Financial Services","Provision of motor vehicle insurance, (excluding Marine Cover)","Arthur J  Gallagher (UK) Ltd Partner in Risk Management Partners","£166,724",null,"01/10/2013","30/09/2018","Tender","0","0","Private","0"],
    [40,"P000047","Wide Area Network","Technical Services","Provision of Wide Area Network connecting all locations with SHQ including some Daul lines for additional Resilience","NYnet","£474,820",null,"01/04/2014","31/03/2019","Framework","Single Supplier under the Tekal Agreement","Micro Business","Private","6069791"],
    [41,"P000049","Water Hygiene","Technical Services","To carry out water hygiene inspections of NYFRS properties.","Integrated Water Services","£13,240",null,"01/04/2016","31/03/2018","Tender","Framework","Multi National","Private","5283349"],
    [42,"P000053-1","Waste Collection ","Technical Services","10 sites agregated ","Yorwaste Ltd","£5,368",null,"01/04/2017","31/03/2018","Single Supplier","Single Supplier Contract","Medium Business","Private","2666908"],
    [43,"P000053-2","Waste Collection ","Technical Services","8 Sites agregated","Scarborough Borough Council","£3,230",null,"01/04/2017","31/03/2018","Single Supplier","Single Supplier Contract","0","Public","0"],
    [44,"P000053-3","Waste Collection ","Technical Services","2 Sites agregated","Selby District Council","£1,597",null,"01/04/2017","31/03/2018","Single Supplier","Single Supplier Contract","0","Public","0"],
    [45,"P000053-4","Waste Collection ","Technical Services","2 Sites agregated","City of York Council   ","£2,432",null,"01/04/2017","31/03/2018","Single Supplier","Single Supplier Contract","0","Public","0"],
    [46,"P000053-5","Waste Collection ","Technical Services","5 Sites agregated","Harrogate Borough Council  ","£1,580",null,"01/04/2017","31/03/2018","Single Supplier","Single Supplier Contract","0","Public","0"],
    [47,"P000053-6","Waste Collection ","Technical Services","4 Sites agregated","Craven District Council","£981",null,"01/04/2017","31/03/2018","Single Supplier","Single Supplier Contract","0","Public","0"],
    [48,"P000053-7","Waste Collection ","Technical Services","5 Sites agregated","Ryedale District Council","£1,389",null,"01/04/2017","31/03/2018","Single Supplier","Single Supplier Contract","0","Public","0"],
    [49,"P000055","FireWatch License and Maintenance Agreement","Human Resources","The use and maintenance of FireWatch for the Service up to specified user limits","Infographics UK Ltd","£27,000",null,"28/08/2015","27/08/2016","Tender","Tender","Small Business","Private","0"],
    [50,"P000056","Sharepoint Support Contract","Technical Services","Sharepoint Support Contract","Black Marble","£20,000",null,"01/04/2016","31/03/2020","3 Quotes","Quotation","Small Business","Private","0"],
    [51,"P000057","Nexent Anti-Virus & Spam Prevention & Tagging Service","Technical Services","Nexent Anti-Virus & Spam Prevention & Tagging Service ","Onyx Group","£6,000",null,"16/12/2015","15/12/2016","Single Supplier","Single Supplier","Medium Business","Private","0"],
    [52,"P000058","Point to Point Leased Line A-End DL6 2ND - B-End NE27 0QF","Technical Services","Point to Point Leased Line A-End DL6 2ND - B-End NE27 0QF","Onyx Group","£40,000",null,"01/01/2016","31/12/2017","Single Supplier","Single Supplier","Medium Business","Private","0"],
    [53,"P000059","Internal Audit and Counter Fraud Limited","Financial Services","Internal Audit and Counter Fraud Limited","Veritau Limited","£24,586",null,"01/04/2016","31/03/2017","Single Supplier","Single Supplier","Small Business","Private","0"],
    [54,"P000060","TRV0616-001 Tactical Response Vehicles","Technical Services","Provision of Light Rescue Pumping Appliances form Framework DS086-12","Emergency One (UK) Ltd","£1,226,229",null,"17/06/2016","31/03/2018","Framework","Framework","Small Business","Private","0"],
    [55,"P000061","AMS0616-001 Asset Management System","Risk Management","Supply and Management of an Asset Management System","Creative Software Solutions (Europe) Ltd","£57,441",null,"01/06/2016","31/03/2019","Competitive Tender","Open Procedure","Small Business","Private","0"],
    [56,"P000062","CID-12-15-001 Customer Insight Data","Risk Management","Provision of Customer Insight Data and Data Tool","CACI","£22,950",null,"24/03/2016","23/03/2019","Quotation","Open Competitive","Small Business","Private","0"],
    [57,"P000063","Gold Software Support","Technical Services","External Client and Server Software Support ","Onyx Group","£7,995",null,"01/07/2016","30/06/2017","Single Supplier","Single Supplier","Medium Business","Private","0"],
    [58,"P000064","Achieve Forms","Technical Services","Achieve forms ","Firmstep Ltd","£7,014",null,"01/04/2016","31/03/2017","3 Quotes","Quotation","Medium Business","Private","0"],
    [59,"P000065","ERM12 Services Mechanical Servicing and Installations ","Michael Davies","Technical Services","HCS Mechanical Services Ltd","£200,000",null,"29/06/2013","31/03/2018","Framework","Framework","Mediun Business","Private","0"],
    [60,"P000066","SEEaP2 Services Servicing of Electrical Equipment and Plant","Michael Davies","Technical Services","Express Elevators","£200,000",null,"11/01/2015","10/01/2019","Framework","Framework","Multi National","Private","0"]
]}