{
  "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","œ9,000",null,"01/04/2015","31/03/2015","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","31/03/2016","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/2017","Framework","NYCC framework Contract","Medium Business","Private","703979"],
    [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","Jacobs Engineering UK","œ83,999",null,"01/04/2009","27/02/2016","Framework","NYCC framework Contract","Multi National","Private","81111269"],
    [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 ","œ64,000",null,"07/09/2011","06/09/2015","Single Supplier","Single Supplier Contract","Enterprise","Private","2449259"],
    [11,"P000011","Chemdata","Risk Management","Chemical hazard database for use by training operational personnel.  ","NCEC","œ18,010",null,"01/04/2014","31/03/2016","Quote","Annual Subscription ","Multi National","Private","0"],
    [12,"P000012","Client Server Messaging Suite Exch Enterprise","Technical Services","Server and workstation anti-virus product","Knowledge IT","œ5,490",null,"01/04/2014","31/03/2015","Quote","Single Supplier Contract","Medium Business","Private","1554385"],
    [13,"P000013","Committee Services SLA","Financial Services","Provision of Committee Services","North Yorkshire County Council","œ24,830",null,"01/04/2011","31/03/2015","0","SLA (Service Level Agreement)","0","Public","0"],
    [14,"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"],
    [15,"P000015","DR Rack and Services","Technical Services","Disaster recovery IT rack and facilities (power and cooling)","Knowledge IT","œ69,975",null,"01/04/2010","31/03/2015","Prefered Supplier","Preferred Supplier","Medium Business","Private","1554385"],
    [16,"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"],
    [17,"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","œ47,533",null,"01/04/2014","31/03/2018","3 Quotes","Quotation","Small Business","Private","5327635"],
    [18,"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"],
    [19,"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"],
    [20,"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"],
    [21,"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/2011","31/03/2015","0","SLA (Service Level Agreement)","0","Public","0"],
    [22,"P000022","Finance SLA - Payroll","Financial Services","Managed payroll system ","North Yorkshire County Council","œ21,252",null,"19/09/2007","31/03/2015","0","SLA (Service Level Agreement)","0","Public","0"],
    [23,"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"],
    [24,"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"],
    [25,"P000025","FleetPlan & Unidata","Technical Services","Fleet management system","Civica","œ12,914",null,"01/10/2014","30/09/2016","0","0","Unknown","Private","3600842"],
    [26,"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","œ158,000",null,"01/10/2011","30/09/2016","Tender","0","0","Public","0"],
    [27,"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"],
    [28,"P000028","Gas Supply","Technical Services","Supply of Gas","British Gas","œ95,589",null,null,"31/03/2017","Framework","Yorkshire Purchasing Organisation","Multi National","Private","0"],
    [29,"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"],
    [30,"P000030","Point to Point Leased Line","Technical Services","Provision of Main data line for internet access, email transport, and disaster recovery data syncronisation","Knowledge IT","œ27,000",null,"01/04/2015","31/03/2016","Oper procedure","Single Supplier Contract","Medium Business","Private","1554385"],
    [31,"P000031","LearnPro","Human Resources","Computerised modular training programme.","Learn Pro","œ11,113",null,"01/02/2007","31/01/2016","0","Single Supplier Contract","0","Private","0"],
    [32,"P000032","Legal Services SLA","Financial Services","Provision of Legal Services","North Yorkshire County Council","œ44,180",null,"01/04/2011","31/03/2015","0","SLA (Service Level Agreement)","0","Public","0"],
    [33,"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"],
    [34,"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"],
    [35,"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"],
    [36,"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"],
    [37,"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"],
    [38,"P000039","SharePoint Support Contract","Technical Services","SharePoint Support Contract","Black Marble","œ20,000",null,"01/03/2013","31/03/2017","3 Quotes","Quotation","Small Business","Private","3343234"],
    [39,"P000040","Station End Maintenance","Technical Services","Station end mobilising cabinet maintenance (originated from RCC Project)","Multitone Electronics PLC","œ5,655",null,"01/04/2015","31/03/2016","Framework","Department for Communities and Local Government","Medium Business","Private","256314"],
    [40,"P000041","Stock Condition Survey","Technical Services","One off Stock condition survey of all Fire Stations","Nifes Consulting Group","œ20,435",null,"11/08/2014","15/09/2014","Quotation","0","Medium Business","Private","6115895"],
    [41,"P000042","Supply of Smoke Alarms ","Risk Management","Supply of Smoke alarms for Fitting in Domestic properties","Sprue Safety Products Ltd","œ31,200",null,"09/09/2013","09/09/2015","Mini Competition Framework","Competitive Dialogue","0","Private","3641019"],
    [42,"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"],
    [43,"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"],
    [44,"P000045","TC line to Nexent","Technical Services","Provison of Backup line connecting to the ISP for internet access, email transport and ADSL connectivity.","Knowledge IT","œ44,000",null,"01/10/2014","30/09/2015","Single Supplier","Single Supplier Contract","Medium Business","Private","1554385"],
    [45,"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"],
    [46,"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"],
    [47,"P000049","Water Hygiene","Technical Services","To carry out water hygiene inspections of NYFRS properties.","Integrated Water Services","œ40,000",null,"01/05/2014","31/05/2016","Tender","Tender","Multi National","Private","5283349"],
    [48,"P000050","York Fire Station Project","Technical Services","Consultancy services on New  Build","Drivers Jonas Deloitte","œ410,000",null,"20/01/2010","01/02/2015","Tender","NYFRS Tendered Fixed Term Project specific","Multi National","Private","OC303675"],
    [49,"P000051","York Fire Station Project","Technical Services","Building Work for New Build","Caddick","œ2,400,000",null,"01/06/2013","01/02/2015","Tender","NYFRS Tendered Fixed Term Project specific","Medium Business","Private","1435461"],
    [50,"P000052","FireWatch License and Maintenance Agreement","Technical Services"," The use and maintenance of FireWatch for the Service up to specified user limits ","FireWatch","œ45,000",null,"23/02/2010","22/02/2013","Tender","Tender","Small Business","Private","Company Number (Scotland): 89526"],
    [51,"P000053","Waste Collection (8 sites agregated cost the remainder of the waste contracts are under œ1,000 provided by local councils)","Technical Services","8 sites agregated cost the remainder of the waste contracts are under œ1,000 and proved by local councils","Yorwaste Ltd","œ1,597",null,"01/04/2015","31/03/2016","Single Supplier","Single Supplier Contract","Medium Business","Private","2666908"]
]}