{
  "fields": [{"id":"_id","type":"int"},{"id":"Master Category","type":"text"},{"id":"Yortender Ref","type":"text"},{"id":"Directorate","type":"text"},{"id":"Post LGR: Directorate","type":"text"},{"id":"Post LGR: Service unit","type":"text"},{"id":"Spend category","type":"text"},{"id":"Procurement stage - Initial term or extension","type":"text"},{"id":"Contract title","type":"text"},{"id":"Date contract to start","type":"text"},{"id":"Total duration of contract in months including extensions","type":"text"},{"id":"Breakdown of total duration including extensions","type":"text"},{"id":"Estimated Whole Life Cost including extensions","type":"text"},{"id":"Whole Life Cost (inc VAT) assumed 20%","type":"text"},{"id":"Proposed procurement method","type":"text"},{"id":"Key Decision required? (or Decision Record)","type":"text"},{"id":"Key Decision Date","type":"text"}],
  "records": [
    [1,"Place","NA","CS","Resources","Property, Procurement and Commercial ","Built Environment","Variation","Hard FM KPI, Insurance & Additional Extension Variation","2024-02-01 00:00:00","NA","NA",null,null,"Contract Variation","No","NA"],
    [2,"Place","TBC","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 2) Mechnical Re-procurement\nMechanical Equipment and Plant","2024-04-01 00:00:00",null,null,null,null,"TBC","Yes","TBC"],
    [3,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Whitley Bridge\nService bay protection\nA0012\n1014","2023-08-02 00:00:00","tbc","tbc",null,null,"Further Comp - Internal (Non OJEU)","Decision Record","tbc"],
    [4,"People","DN436659","CYPS","CYPS","Children and Families","Social Care","Initial Term","Inter Country Adoption","2024-04-01 00:00:00",null,null,null,null,null,"No","N/A"],
    [5,"Place","TBC","LGR","Resources","Property, Procurement and Commercial ","Property","Initial Term","Building Signage for Vesting day","2023-04-01 00:00:00",null,null,"50000","60000","TBC","NA","NA"],
    [6,"People","TBC","HAS","HAS","Prevention and Service Development ","Social Care","Initial Term","Domestic Deep Cleaning","2024-05-01 00:00:00","TBC","TBC","50000","60000","Bid","No","N/A"],
    [7,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Kirkham Bridge","2023-07-01 00:00:00","tbc","tbc","50000","60000","Further Comp - Internal (OJEU)","Decision Record",null],
    [8,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Built Environment","Initial Term","Lastingham Bridge Strengthening","2024-05-01 00:00:00","tba","tba","50000","60000","Bid","TBC","TBC"],
    [9,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Garden Wood Bridge Infilling ","2023-11-06 00:00:00","tbc","tbc","50000","60000","Bid","Decision Record","tbc"],
    [10,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Badger Gill \n743 Downstream invert repair ","2023-07-01 00:00:00","1","1","55000","66000","Further Comp - Internal (Non OJEU)","Decision Record","tbc"],
    [11,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Hot box","2023-05-01 00:00:00","12","12","60000","72000","Contract Extension","n/a","n/a"],
    [12,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Tyres and associated services","2024-05-01 00:00:00","12","12","60000","72000","OJEU","n/a","n/a"],
    [13,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Broome House Bridge","tbc","1","1","60000","72000","Bid","Decision Record","tbc"],
    [14,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Marage Path Footbridge – Design and Build Replacement","2023-06-01 00:00:00","6","1","60000","72000","Bid","Decision Record","tbc"],
    [15,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Hot box","2024-05-01 00:00:00","12","12","60000","72000","Contract Extension","n/a","n/a"],
    [16,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Skipton on Swale Bridge","2023-09-01 00:00:00","tbc","tbc","60000","72000","Further Comp - Internal (OJEU)","Decision Record","tbc"],
    [17,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","County Hall Data Centre Servicing & Maintenance Contract","2023-02-01 00:00:00","60","tbc","60000","72000","Bid","Decision Record","tbc"],
    [18,"Place","tbc","BES","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Provision of two vehicles to Ryedale","tbc","tbc","tbc","60000","72000","Further Comp - External (OJEU)","N/A","n/a"],
    [19,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Income Management and Card Payments System","2023-05-01 00:00:00","36","36","760731","912877.2","Direct Award","Key Decision  ","2023-04-11 00:00:00"],
    [20,"Professional","64316","LGR","HR_BS","Technology","ICT","Initial Term","Lone Worker Solutions","2023-05-21 00:00:00","36","24+12","300000","360000","OJEU","Decision Record","N/A"],
    [21,"Professional","DN531051","CS","Resources","Technology","ICT","Extension","Occupational Health Case Management System\n(currently eOPAS, provided by Civica)","2023-05-24 00:00:00","48","24+12+12","63312","75974.4","Contract Extension","Decision Record","NA"],
    [22,"Professional","TBC","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","Initial Term","The Provision of Specialist Advice for the Waste Management Service","2023-06-01 00:00:00","48","24+12+12","140000","168000","Further Comp - External (non OJEU)","Decision Record","N/A"],
    [23,"People","TBC","CYPS","CYPS","Inclusion","Social Care","Extension","OT tribunals and hubs ","2023-09-01 00:00:00","36","24+12","70000","84000","Contract Extension","No","N/A"],
    [24,"People","TBC","CYPS","CYPS","Inclusion","Social Care","Initial Term","OT tribunals and hubs ","2024-09-01 00:00:00","TBC","TBC","70000","84000","Bid","No","Decision Record"],
    [25,"Professional","DN332989","CS","LDS","Legal ","Legal","Variation","Counsel APL - Legal Services ","2023-06-01 00:00:00","48","36+12+12","2649410","3179292","Contract Variation","No","NA"],
    [26,"Professional",null,"CS","Resources","Property, Procurement and Commercial ","Facilities","Initial Term","Washroom Services","2023-07-01 00:00:00",null,null,"TBC",null,"TBC","Decision Record","NA"],
    [27,"Professional",null,"BES","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Passenger Transport","Extension","Special Educational Needs Home to School Transport - x2 schools (Brompton Hall, Forest Moor)","2023-07-01 00:00:00",null,null,"TBC",null,"Contract Extension","Yes","TBC"],
    [28,"Professional","TBC","LGR","Resources","Transformation ","Consultancy","Initial Term","LGR Critical Friend ","2023-07-01 00:00:00","TBC","TBC","TBC","#VALUE!","Further Comp - External (non OJEU)","No","NA"],
    [29,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Initial Term","Supply of e-cigarettes","2023-01-01 00:00:00","36","24+12","75000","90000","Bid","Key Decision","HASEX: 22/03/2023"],
    [30,"Place","65372\t","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Ouse Swing Bridge Run on Slab/joints ","2023-03-03 00:00:00","1","1","75000","90000","Further Comp - Internal (Non OJEU)","Decision Record","N/A"],
    [31,"Place","73244","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Cornforth Hill Retaining Wall","2023-06-30 00:00:00","tbc","tbc","75000","90000","Bid","Decision Record","tbc"],
    [32,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Great Ayton High Street Wall","2023-08-01 00:00:00","tbc","tbc","75000","90000","Bid","Decision Record","tbc"],
    [33,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Cam Gill Road Creep \n1927 Redeck ","tbc","1","1","75000","90000","Further Comp - Internal (Non OJEU)","Decision Record","tbc"],
    [34,"Place","TBC","BES","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","A20020 Area 2 23/24 Tender Package 5 Sutton Bank Annual Maintenance\nA170","2023-09-01 00:00:00","1","1","75000","90000","Further Comp - Internal (Non OJEU)","n/a","n/a"],
    [35,"Professional","DN555452","CS","Resources","Technology","ICT","Extension","Oracle PBCS (Planning & Budgeting Cloud Solution) Application Support\n(currently provided by Evosys)","2023-07-26 00:00:00","48","24+12+12","80000","96000","Contract Extension","No","NA"],
    [36,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Duchess of Kent Bridge Monitoring System\nSurfacing, Monitoring System Upgrade","tbc","tbc","tbc","75000","90000","Bid","Decision Record","tbc"],
    [37,"Professional",null,"CS","Resources","Property, Procurement and Commercial ","Furniture & Soft Furnishings","Initial Term","Removals and storage services","2023-08-01 00:00:00","TBC","TBC","~£200k pa","#VALUE!","TBC","Key Decision ","2023-03-29 00:00:00"],
    [38,"Professional","TBC","CS","HAS","Technology","ICT","Initial Term","Adult Learning System (currently provided by Tribal Education Limited)","2023-08-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [39,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Harlow Nursery boiler replacement","tbc","3","tbc","76000","91200","Bid","tbc","tbc"],
    [40,"Professional","DN560907","CS","HR_BS","Business Support","Mail Services","Extension","Postal Service collaboration with Kirklees","2023-08-09 00:00:00","48","24+12+12","700000","840000","Contract Extension","Key Decision","44406"],
    [41,"Professional","NA","CS","Resources","Property, Procurement and Commercial ","Subscription","Initial Term","Municipal Journal Subscription (MJ)","2023-08-18 00:00:00","TBC","TBC","TBC","#VALUE!","Direct Award","No","NA"],
    [42,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Cockayne \n531 Saddle and spandrel wall take down ","2023-08-01 00:00:00","1","1","80000","96000","Further Comp - Internal (Non OJEU)","Decision Record","tbc"],
    [43,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Snaizeholme Wall, Gayle","2023-10-01 00:00:00","tbc","tbc","80000","96000","Bid","Decision Record","tbc"],
    [44,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Built Environment","Initial Term","Jack Beck Bridge Strengthening, Clapham","2024-06-01 00:00:00","tba","tba","80000","96000","Bid","TBC","TBC"],
    [45,"Professional",null,"CS","Resources","Technology","ICT","Initial Term","IT Hardware Partner","2023-09-01 00:00:00","5","3+2","5000000","6000000","OJEU","Yes","TBC"],
    [46,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Built Environment","Initial Term","Cover Head Bridge, East Witton Strenthening","2024-05-01 00:00:00","tba","tba","85000","102000","Bid","TBC","TBC"],
    [47,"Professional","DN476035","BES","Environment","Technology ","Passenger Transport","Extension","Fleet Management System\n(currently provided by AssetWorks) Civica","2023-09-07 00:00:00","60","36+12+12","198500","238200","Contract Extension","Decision Record","NA"],
    [48,"Professional","DN488954","CS","HR_BS","Technology","ICT","Initial Term","Kofax - Document Management Centre scanning/ePost - Mail Scanning","2023-10-01 00:00:00","TBC","TBC","140000","168000","TBC","TBC","TBC"],
    [49,"Place","TBC","BES","Resources","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","A20018 Area 2 23/24 Tender Package 3 Landslips\nU1858 Beakhills","2023-07-01 00:00:00","1","1","89294","107152.8","Further Comp - Internal (Non OJEU)","n/a","n/a"],
    [50,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Interactive Panels and Projectors including installation - Schools ICT","2023-10-01 00:00:00","24","24","400000","480000","Further Comp - External (OJEU)","No","Exempt"],
    [51,"People","TBC","HAS","HAS","Director of Public Health","Social & Community Supplies & Services","Initial Term","Dental Epidemiology Survey","2024-02-01 00:00:00","TBC","TBC","90000","108000","TBC","No","TBC"],
    [52,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Initial Term","Treasury Management Investment Consultancy Services  (NYCC, Selby & Ryedale)","2023-10-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","NA"],
    [53,"Professional",null,"CS","Resources","Technology","ICT","Initial Term","Survey Software\n(currently provided by Snap Surveys)","2023-10-01 00:00:00","12","12","TBC","#VALUE!","TBC","No","NA"],
    [54,"Professional","DN564570 ","CS","Resources","Technology","ICT","Extension","Oracle E-Business Suite - Third Party Support and Maintenance (PMO Ref: 3071) DN564570","2023-10-03 00:00:00","37","24+12+12","309075","370890","Contract Extension","Decision Record","NA"],
    [55,"Place","62082","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Eggbrough Canal Bridge re waterproofing works","2023-02-01 00:00:00","1","1","100000","120000","Direct Award","Decision Record","tbc"],
    [56,"Place","TBC","NY H","Resources","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Thermal Pothole Repairs","tbc","3","3","100000","120000","DPS - External call off","n/a","N/A"],
    [57,"Professional","TBC","BES","Environment","Technology","ICT","Initial Term","UTC and UTMC System\n(currently Siemens)","2023-10-27 00:00:00","48","48","TBC","#VALUE!","Direct Award","Decision Record","N/A"],
    [58,"Professional",null,"CS","Resources","Technology","ICT","Initial Term","Arboriculture Asset Management System\n(currently Arbortrack, provided by TriNova Systems)","2023-11-01 00:00:00","TBC","TBC","TBC",null,"TBC","No","NA"],
    [59,"Place","tbc","BES","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Commondale Station Bridge - replacement bridge","2023-09-01 00:00:00","1","1","100000","120000","Bid","Decision Record","n/a"],
    [60,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Stell Bank \n599 Saddle and new invert  ","2023-09-01 00:00:00","1","1","100000","120000","Bid","Decision Record","tbc"],
    [61,"Professional","TBC","CS","CYPS","Technology","ICT","Initial Term","eTraining - Governor Training (Currently Modern Governor via Herts for Learning)","2023-11-01 00:00:00","TBC","TBC","TBC",null,"TBC","No","NA"],
    [62,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Safeguarding Adults Review ","2024-09-01 00:00:00","TBC","TBC","100000","120000","Bid","No","N/A"],
    [63,"Professional","DN441357","CS","HR_BS","Business Support","Business Support","Initial Term","Supply and Delivery of Corporate Printing Services (Bulk Paper)","2023-11-01 00:00:00",null,null,"120000","144000","TBC","Decision Record","NA"],
    [64,"People","DN511710","CYPS","CYPS","Children and Families","Social Care","Extension","Independent Visitors","2025-03-01 00:00:00","60","24+24+12","100000","120000","Contract Extension","No","N/A"],
    [65,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Health and Safety Management System (2020 PMO Ref: 1053)","2023-11-01 00:00:00","48","24+12+12","TBC","#VALUE!","TBC","TBC","TBC"],
    [66,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Area 5 Storiths Lane Landslips\nA50006","tbc","1","1","100000","120000","Further Comp - Internal (Non OJEU)","Key Decision","TBC"],
    [67,"Professional","48830","CS","Resources","Technology","ICT","Initial Term","Coroners Case Management System","2023-11-25 00:00:00","48","36+12","87536","105043.2","Direct Award","Decision Record","NA"],
    [68,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Temporary Traffic Data Collection, including Manual Traffic Surveys","tbc","48","36+12","108000","129600","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [69,"Professional","TBC","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","Initial Term","Heat Offtake Feasibility Consultancy -Allerton Park ","2023-12-01 00:00:00","6","6","50000","60000","Further Comp - External (non OJEU)","No","NA"],
    [70,"Professional","TBC","CS","Environment","Technology","ICT","Initial Term","Highways Asset Management System (currently Insight) PMO Ref: 3175","2023-12-01 00:00:00","48","36+12","1073000","1287600","Direct Award","Key Decision","2023-04-28 00:00:00"],
    [71,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Password Self Provisioning - Courion","2023-12-29 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [72,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","SSPR - support","2023-12-30 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [73,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance/Insurance","Extension","Insurance Broker and Risk Management Consultancy Services","2023-12-31 00:00:00","60","36+12+12+12","130000","156000","Contract Extension","Decision Record","NA"],
    [74,"Professional","TBC","CS","Resources","Transformation ","Consultancy","Initial Term","Consultancy for LGR / Devolution Editoral Support","2024-01-01 00:00:00","12","12","£495,000.00 GBP (SOW 6, 7, 8)","#VALUE!","Director's Recommendation","No","NA"],
    [75,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Financial Accounting Solution for External Clients\n(currently Sage, provided by Datel - contract with Boxxe as a re-seller)","2024-01-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [76,"People","\t58725","CS","LE","Policy, Performance, Refugee / Asylum Issues and Community Safety","Social Care","Initial Term","Domestic Abuse Support Pilot","2024-09-01 00:00:00","24","24","124000","148800","TBC","TBC","TBC"],
    [77,"Professional","TBC","CS","LDS","Technology","ICT","Initial Term","e-Democracy System (Old PMO Ref: 2151)\n(currently Modern.Gov, provided by Civica)","2024-01-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [78,"Professional","TBC","CS","CYPS","Technology","ICT","Initial Term","Educational visit software - risk assessment tool for school visits - evolve - edubase","2024-01-01 00:00:00","48","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [79,"Professional","DN562841","CS","LE","Communications","Media & Communications","Extension","Multidisciplinary Media Services Framework","2024-01-02 00:00:00","36","24+12"," £20,700.00 GBP (SOW 4)","#VALUE!","Contract Extension","Decision Record","NA"],
    [80,"Professional",null,"LGR","Resources","Technology","ICT","Initial Term","LGR Oracle PBCS (Planning & Budgeting Cloud Solution) Application Support (Additional Support)","2024-01-16 00:00:00","12","12","TBC",null,"Direct Award","No ","No"],
    [81,"Professional ","DN460974","CS","LDS","Technology","ICT","Extension","e-Democracy System (PMO Ref: 2151)\n(currently Modern.Gov, provided by Civica)","2024-01-31 00:00:00","56","32+12+12","55000","66000","Contract Extension","No ","NA"],
    [82,"Professional",null,"CS","CYPS","Technology","ICT","Initial Term","MOMO software for CYPS (PMO Ref: 3056)","2024-02-03 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [83,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP2 Landslips A10023\nB6270 Grinton to Hags Gill","2023-09-01 00:00:00","1","1","135000","162000","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [84,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP3 Specials A10024\nRichmond Town Centre Cobbles - Newbiggin / Market Place","2023-09-01 00:00:00","1","1","135000","162000","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [85,"Professional","TBC","CS","CYPS","Technology","ICT","Extension","Music Service System","2024-02-06 00:00:00","24","12+12","TBC","#VALUE!","Contract Extension","No","NA"],
    [86,"Professional","DN511173","CS","HR_BS","Business Support","Business Support","Extension","Business Travel","2024-02-22 00:00:00","48","24+12+12","750000","900000","Contract Extension","Yes","2020-11-09 00:00:00"],
    [87,"Professional","TBC","CS","Resources","Technology","ICT","Extension","On-line Registrar, Births, Deaths and Marriages - Online Appointments System","2024-03-01 00:00:00","96","36+36+24","75750","90900","Contract Extension","Decision Record","NA"],
    [88,"Professional","TBC","HAS","HAS","Technology","ICT","Initial Term","PAMMS Software - Data Market Insight (ADASS Collab)","2024-03-14 00:00:00",null,null,"TBC",null,"TBC","No","NA"],
    [89,"Professional","29039","BES","LDS","Legal ","Legal","Extension","Legal Advice for Waste Strategy","2024-03-14 00:00:00","36","24+12","300000","360000","Contract Extension","Yes","2021-12-07 00:00:00"],
    [90,"Professional","49859","CS","HR_BS","Business Support","Venues","Extension","External Venues","2024-03-14 00:00:00","36","24+12","784000","940800","Contract Extension","Yes","Initial period: 22/02/2022, OTE: TBC"],
    [91,"Professional","66261","LGR","Resources","Technology ","ICT","Extension","Telephony - Single Phone Number IVR Phase 2 - Variation to Opus Telephony Contract","2024-03-22 00:00:00","37","13+12+12","580374.46","696449.352","Direct Award","Key Decision","Initial KD: 10/02/2023"],
    [92,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP2 Duck Street - A60020","2023-08-01 00:00:00","1","tbc","143000","171600","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [93,"People","TBC","HAS","CD","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Consultancy","Initial Term","Strategic Leisure Review - Asset Condition Surveys","2023-08-01 00:00:00","6","6","150000","180000","Further Comp - External (non OJEU)","No","N/A"],
    [94,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Alverton and Bedale Primaries – roofing works combined package","2023-07-01 00:00:00","3","3","150000","180000","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [95,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Built Environment","Initial Term","Crosby New Bridge Concrete Repairs","2023-11-01 00:00:00","tba","tba","150000","180000","Bid","TBC","TBC"],
    [96,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Initial Term","Oral Health Promotion ","2025-11-28 00:00:00","36","36","150000","180000","Bid","TBC","TBC"],
    [97,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Westway - High Street, Eastfield\nArea 3","tbc","1","1","150000","180000","Bid","Decision Record","tbc"],
    [98,"Professional","TBC","CS","CYPS","Property, Procurement and Commercial ","Catering","Initial Term","Cash Collection service for schools/customers","2024-03-22 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [99,"Professional","DN533038","CS","Environment","Technology ","Trading Standards","Extension","Trading Standards Business System (2020 PMO Ref: 2953)\n(currently APP, provided by Civica)","2024-03-31 00:00:00","60","36+12+12","112055","134466","Contract Extension","Decision Record","NA"],
    [100,"Professional","DN544710","CS","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Fleet Management","Initial Term","Fuel Cards \n(currently supplied by Allstar Business Solutions Ltd)","2024-03-31 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","NA"],
    [101,"Place",null,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds ","Engineering & Environment","Initial Term","Commondale Station Bridge - precast concrete beams supply","2023-09-01 00:00:00","1","1","160000","192000","Bid","n/a","n/a"],
    [102,"People","DN386609","CYPS","CYPS","Inclusion","Social Care","Variation","Provision of Support Services to the North Yorkshire Parents and Carers(Parent Carer Voice)","2020-04-01 00:00:00","60","12+12+36","165600","198720","Contract Novation","No","N/A"],
    [103,"People","DN386609","CYPS","CYPS","Inclusion","Social Care","Initial Term","Provision of Support Services to the North Yorkshire Parents and Carers(Parent Carer Voice)","2025-04-01 00:00:00","60","12+12+36","165600","198720","Bid","No","N/A"],
    [104,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Initial Term","Banking Services ","2024-04-01 00:00:00",null,null,"TBC",null,"Further Comp - External (OJEU)","Decision Record","NA"],
    [105,"Professional","72900","BES","Environment","Technology ","Fleet Management","Initial Term","Provision of Electronic Ticket Machines – portal fees","2024-04-01 00:00:00","48","12+12+12+12","72000","86400","Contract Extension","No","NA"],
    [106,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","County Hall - the Grand Ceiling Repairs\n20047","tbc","3","3","174000","208800","Bid","Decision Record","tbc"],
    [107,"Professional","26112","CS","LDS","Technology","ICT","Extension","Legal Services Case Management System. ","2024-04-01 00:00:00","72","24+24+24","93775.3","112530.36","Contract Extension","Decision Record","NA"],
    [108,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Extension","Pension Investment Independent Advisor","2024-04-01 00:00:00","48","24+12+12","100000","120000","Contract Extension","No","NA"],
    [109,"Professional","DN536533","CS","HR_BS","Human Resources","HR & Training","Extension","Children, Young People and Families - Residential Apprenticeships","2024-04-01 00:00:00","48","24+12+12","156000","187200","Contract Extension","No","NA"],
    [110,"Professional","48920\t","CS","Resources","Technology","ICT","Extension","Library Management System ","2024-04-01 00:00:00","36","24+12","169776","203731.2","Contract Extension","Decision Record","NA"],
    [111,"Professional","TBC","CS","Resources","Technology","ICT","Extension","Project Management System\n(currently PPM, provided by Cora)","2024-04-01 00:00:00","36","24+12","177000","212400","Contract Extension","No","N/A"],
    [112,"Place","68201","BES","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Engineering & Environment","Initial Term","River Foss Catchment Project","tbc","24","24","180000","216000","Bid","Decision Record","N/A"],
    [113,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Bell End Landslip\nA40008","2023-04-24 00:00:00","1","1","180000","216000","Further Comp - Internal (Non OJEU)","Key Decision","Approved capital programme 22/23"],
    [114,"Professional","DN536306","CS","HR_BS","Human Resources","Training","Extension","Production Chef Apprenticeship","2024-04-01 00:00:00","48","24+12+12","180000","216000","Contract Extension","No","NA"],
    [115,"Professional","DN549272","CS","HR_BS","Human Resources","HR & Training","Extension","NYCC Employee Assistance Programme (EAP)","2024-04-01 00:00:00","36","24+12","199500","239400","Contract Extension","Decision Record",null],
    [116,"People","DN546293","CYPS","CYPS","Inclusion","Social Care","Extension","The Provision of Radio Aids, Associated Equipment and Maintenance","2024-08-01 00:00:00","60","36+24","190000","228000","Contract Extension","Yes","2021-05-20 00:00:00"],
    [117,"Place","64540","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","A100021 Tender Package 8 \nFremmington\nCotterdale\n?A684 drainage?\n","2023-04-01 00:00:00","1","1","191773","230127.6","Further Comp - Internal (Non OJEU)","Key Decision","tbc"],
    [118,"Professional","TBC","CS","Resources","Property, Procurement and Commercial ","Catering","Initial Term","Catering Disposable Products\n(currently supplied by YPO/Wilkes)","2024-04-01 00:00:00","36","36","250000","300000","Further Comp - External (OJEU)","Decision Record","NA"],
    [119,"Professional","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Urban Grass Cutting","2024-04-01 00:00:00","48","48","320000","384000","TBC","Yes","TBC"],
    [120,"Professional",null,"CS","HAS","Technology","ICT","Initial Term","Digital Transformation of Care Provider Services - eCare Records System","2024-04-01 00:00:00","3+2","tbc","400000","480000","Further Comp - External (non OJEU)","Decision Record","Yes"],
    [121,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Carbon Neutral Surfacing pilot","tbc","12","12","200000","240000","Direct Award","Not required","n/a"],
    [122,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Richmond Methodists - Hygiene Room","tbc","tbc","tbc","210000","252000","Further Comp - External (non OJEU)","Decision Record","n/a"],
    [123,"People","TBC","CYPS","CYPS","Children and Families","Social Care","Initial Term","Investigating Officer and Independent Person Stage 2 Service and Stage 3 Chair/Panellist Service","2024-09-01 00:00:00","60","36+24","211200","253440","Bid","Yes","TBC"],
    [124,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","SRF - A6108 Package 3 Skid resistance improvements A10020","tbc","tbc","tbc","217500","261000","Further Comp - Internal (OJEU)","n/a","n/a"],
    [125,"Professional","49871","CS","HR_BS","Business Support","Furniture & Soft Furnishings","Extension","Supply of Office Furniture","2024-04-01 00:00:00","36","24+12","428000","513600","Contract Extension","no ","N/A"],
    [126,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Cattle Grids 2023/24","2023-08-01 00:00:00","tbc","tbc","225000","270000","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [127,"Professional","49924","CS","Resources","Technology","ICT","Extension","Telephony - ( Virgin / NG Bailey) Provision of support and voice services","2024-04-01 00:00:00","48","24+12+12","620000","744000","Contract Extension","Decision Record","NA"],
    [128,"Professional","DN585990","CS","Resources","Property, Procurement and Commercial ","Catering","Extension","Supply and Delivery of Pre-Packed Sandwiches and Associated Products","2024-04-01 00:00:00","52","28+24","2800000","3360000","Contract Extension","Yes",null],
    [129,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Framework Agreement for the Provision of School's Online Payment Systems","2024-04-01 00:00:00","4","4","3000000","3600000","OJEU","Yes","TBC"],
    [130,"Professional","36403","CS","Resources","Property, Procurement and Commercial ","Catering","Extension","Fresh Meat and Frozen Products","2024-04-01 00:00:00","48","24+24","8000000","9600000","Contract Extension","TBC","Initial Term KD taken:15/11/2021, OTE KD taken: TBC"],
    [131,"Professional",null,"BES","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Passenger Transport","Initial Term","Local Bus Services and Mainstream Home to School Transport (Craven and Ryedale Areas) - plus additional contract extensions (+ Richmondshire & Harrogate) + Hamb LBS only","2024-04-01 00:00:00","48",null,"22217516.18","26661019.416","Contract Extension","Yes",null],
    [132,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","SRF Package 2 Leyburn A10025","2023-10-01 00:00:00","1","1","232000","278400","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [133,"Professional","36492","CS","Environment","Highways, Transportation, Parking Services, Parks and Grounds ","Horticulture & Arboriculture","Extension","Grounds Maintenance","2024-04-01 00:00:00","42","18+12+12","£300,000 - £600,000","#VALUE!","Contract Extension","Yes","2022-07-06 00:00:00"],
    [134,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP4 Thirsk Market Place Phase 1 Special A20014\nBoltby Mill to Boltby\nCrayke Road\nStillington Road","tbc","tbc","tbc","233333","279999.6","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [135,"Place","tbc","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Waste","Initial Term","Hazchem collection from HWRC","2023-09-01 00:00:00","48","24+12+12","240000","288000","Bid","Decision Record","TBC"],
    [136,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hot box","2023-05-01 00:00:00","48","24+12+12","240000","288000","OJEU","n/a","n/a"],
    [137,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Tyres and associated services","2024-05-01 00:00:00","48","24+12+12","240000","288000","OJEU","n/a","n/a"],
    [138,"People","TBC","CS","LE","Policy, Performance, Refugee / Asylum Issues and Community Safety","Social Care","Initial Term","DOMESTIC ABUSE - Therapeutic Services (children)","2025-10-01 00:00:00","36","36","240000","288000","Bid","Yes","TBC"],
    [139,"Professional","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Consultancy","Initial Term","Highways Engineering & Design Consultancy (HEDC) contract (currently WSP)","2024-04-01 00:00:00","TBC","TBC","£3-4M PA","#VALUE!","OJEU","Yes","TBC"],
    [140,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Barwic Parade Community Primary School - 19036 External play area development - 2022","TBC","3","3","250000","300000","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [141,"Place","65690\t","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Foston C of E VC Primary School – Classroom Extension","2023-07-01 00:00:00","tbc","tbc","265000","318000","Further Comp - External (OJEU)","Decision Record","tbc"],
    [142,"Place","72831","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Cowling Primary School - Playing Field Works","tbc","tbc","tbc","275000","330000","Further Comp - External (non OJEU)","Decision Record","n/a"],
    [143,"Place","TBC","NY H","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Supply of permanent cold lay pot hole repair materials","2023-10-01 00:00:00","tbc","tbc","280000","336000","Further Comp - External (OJEU)","No","N/A"],
    [144,"Professional","TBC","CS","CYPS","Technology","ICT","Initial Term","Single View of a Child  (2020 PMO ref: 1869)","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [145,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Extension","Traffic Signals Maintenance","2025-10-01 00:00:00","24","24","280000","336000","Further Comp - Internal (Non OJEU)","Key Decision","tbc"],
    [146,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Initial Term","Internal Audit Services","2024-04-01 00:00:00","180","TBC","TBC","#VALUE!","TBC","Yes","TBC"],
    [147,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Public Network Computers  - 2088 Public Use of IT Provision","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [148,"Professional","TBC","CS","Environment","Technology","ICT","Initial Term","Map Management System\n(currently CAMS, provided by Exegesis)","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [149,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Langton Primary Kitchen extension and ancillary works and drainage scheme","tbc","tbc","tbc","620000","744000","Further Comp - External (OJEU)","Key Decision","tbc"],
    [150,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Built Environment","Initial Term","Whitby Swing Bridge Painting and Surfacing","2023-08-01 00:00:00","tba","tba","300000","360000","Bid","TBC","TBC"],
    [151,"People","TBC","Community Development","CD","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Education & Training","Extension","E-Books","2025-04-22 00:00:00","60","36+24","300000","360000","Contract Extension","No","N/A"],
    [152,"Professional","TBC","CS","CYPS","Technology","ICT","Initial Term","Youth Justice Case Management System currently Careworks, provided by OneAdvanced","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No ","NA"],
    [153,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Social Action Digital Solution\n(currently Tribe, provided by Bronze Software Labs)","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [154,"Professional",null,"CS","Resources","Technology ","ICT","Initial Term","Library Management System ","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [155,"Professional","TBC","BES","Environment","Technology","ICT","Initial Term","Historic Environment Record System (PMO Ref: 3024)\n(currently provided by Exegesis) Now PMO Ref: 3178","2024-04-01 00:00:00","48","24+12+12","TBC","#VALUE!","Contract Extension","No","NA"],
    [156,"Place","66151","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP1 Selby Area 7 Carriageway Surfacing package 1 – 2023 A70010","2023-05-01 00:00:00","1","tbc","329162","394994.4","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [157,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Settrington All Saint's Intervention space","2023-07-01 00:00:00","3","3","331727","398072.4","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [158,"Place","tbc","HAS","HAS","Property, Procurement & Commercial","Built Environment","Initial Term","HAS EPH refurb 2022/23 Ashfield, Skipton","2023-07-01 00:00:00","3","3","331727","398072.4","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [159,"Place","tbc","HAS","HAS","Property, Procurement and Commercial ","Built Environment","Initial Term","HAS EPH refurb 2022/23 Silver Birches, Filey","2023-07-01 00:00:00","3","3","331727","398072.4","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [160,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Summerbridge - 19030 internal adaptations - 2022","2023-07-01 00:00:00","3","3","331727","398072.4","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [161,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Bedale High School - TBC changing room refurbishment\n21022","2023-07-01 00:00:00","3","3","331727","398072.4","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [162,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","CYPS SEN provision - 2023","2023-07-01 00:00:00","3","3","331727","398072.4","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [163,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","CYPS SEN provision - 2023","2023-07-01 00:00:00","3","3","331727","398072.4","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [164,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","CYPS SEN provision - 2023","2023-07-01 00:00:00","3","3","331727","398072.4","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [165,"People","DN539319","BES","CD","Economic Development, Regeneration, Tourism and Skills ","Education & Training","Extension","LEP Careers Enterprise","2023-09-01 00:00:00","60","12+12+12+12+12","338000","405600","Contract Extension","Yes","BESEX 26/03/2021"],
    [166,"People","DN418993","CYPS","CYPS","Children and Families","Social Care","Extension","Medical advice for adoption and fostering panels","2023-04-01 00:00:00","84","36+24+24","350000","420000","Contract Extension","No","N/A"],
    [167,"Professional","52022","NY H","Environment","Technology","ICT","Extension","Gully Maintenance Risk software - Better Drainage ","2024-04-20 00:00:00","48","24+12+12","168115.24","201738.288","Contract Extension","No","NYH Budget"],
    [168,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Risedale School Bus parking","2024-09-01 00:00:00","3","3","350000","420000","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [169,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Scarborough Library - internal refurb","tbc","tbc","tbc","364000","436800","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [170,"People","TBC","HAS","HAS","Director of Public Health","Social Care","Extension","Winter Health - Warm & Well","2024-09-25 00:00:00","48","36+12","390000","468000","Bid","Yes","HASLT: 18/02/2021 \nHAS EX: 12/03/2021"],
    [171,"People","TBC","HAS","HAS","Director of Public Health","Social Care","Initial Term","Winter Health - Warm & Well / Winter Health Co-ordination","2025-09-25 00:00:00","TBC","TBC","390000","468000","Bid","TBC","TBC"],
    [172,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP2 Selby Area 7 PSD Patching 2023 A70011","2023-09-01 00:00:00","2","tbc","390349","468418.8","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [173,"Professional","TBC","CS","HAS","Technology","ICT","Initial Term","Coroners Court Video Conferencing System (includes installation of hardware, support and maintenance)\n(provided by Visavvi; contract with Softcat as a re-seller)","2024-04-30 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [174,"Place","tbc","NY H","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Survey of Private Network Cabling / Underground Utility Surveying and Mapping","2023-07-28 00:00:00","48","1","400000","480000","Further Comp - External (non OJEU)","n/a","n/a"],
    [175,"Place","TBC","NY H","Resources","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Waste management services","2023-05-01 00:00:00","48","tbc","1176864.07","1412236.884","Bid","n/a","n/a"],
    [176,"Professional","48445","CS","Environment","Technology","ICT","Extension","MapInfo Pro Maintenance and Technical Support","2024-05-01 00:00:00","72","48+12+12","115000","138000","Waiver","Decision Record","N/A"],
    [177,"Professional","DN542302","CYPS","CYPS","Technology","ICT","Extension","Budget planning tool for schools\n(currently provided by Orovia)","2024-05-01 00:00:00","48","24+12+12","120000","144000","Contract Extension","Decision Record","NA"],
    [178,"Place","73276","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Rievaulx Bridge Maintenance\nMajor Works\n314","2023-06-01 00:00:00","5","tbc","400000","480000","Bid","Decision Record","tbc"],
    [179,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Highway Maintenance Gangs and Other Operatives/ \nHighway maintenance gangs","2024-06-01 00:00:00","12","12","400000","480000","Contract Extension","n/a","n/a"],
    [180,"Professional","TBC","CS","Environment","Technology ","ICT","Initial Term","ENCTS Back Office Software (2020 PMO Ref: 3134)\n","2024-05-01 00:00:00","48 months + 11 months","48 + 11","289131","346957.2","Direct Award","TBC","TBC"],
    [181,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Kingsley Farm Resurfacing s278\nBogs Lane, Harrogate","tbc","1","tbc","400000","480000","Further Comp - Internal (Non OJEU)","Decision Record","tbc"],
    [182,"People","DN264420","HAS","HAS","Adult Social Care","Social Care","Extension","Care at Esk Moors Lodge","2024-10-01 00:00:00","48","36+12","403000","483600","Contract Extension","Yes","HASLT: 18/03/2021\nHAS EX: 09/04/2021"],
    [183,"People","TBC","HAS","HAS","Adult Social Care","Social Care","Initial Term","Care at Esk Moors Lodge","2025-10-01 00:00:00","TBC","TBC","403000","483600","Bid","TBC","TBC"],
    [184,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP3 Civils / Landslips A30015","2023-09-01 00:00:00","tbc","tbc","407500","489000","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [185,"Professional","DN536303","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","Extension","Technical and Planning Advisor for Waste (PPP) (Currently Jacobs) ","2024-05-01 00:00:00","60","36+12+12","400000","480000","Contract Extension","Decision Record","NA"],
    [186,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","The Wensleydale School - 20017 Design technology refurbishment - 2022","2023-07-01 00:00:00","3","3","416000","499200","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [187,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Extension","Insurance-Linked Securities (ILS)","2024-05-21 00:00:00","120","36+12+12+12+12+12+12+12","6140000","7368000","Contract Extension","Yes","TBC"],
    [188,"People","TBC","Community Development","CD","Economic Development, Regeneration, Tourism and Skills ","Social Care","Initial Term","Administering the North Yorkshire Local Assistance Fund ","2024-04-01 00:00:00","TBC","TBC","450000","540000","OJEU","Yes","TBC"],
    [189,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Yore New \n293 Wall take down and rebuild ","2023-06-01 00:00:00","1","1","450000","540000","Further Comp - Internal (Non OJEU)","Decision Record","tbc"],
    [190,"Professional","DN531051","CS","Resources","Technology","ICT","Extension","Occupational Health Case Management System\n(currently eOPAS, provided by Civica)","2024-05-24 00:00:00","48","24+12+12","63312","75974.4","Contract Extension","Decision Record","NA"],
    [191,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Traffic Management","2023-06-01 00:00:00","12","12","475000","570000","Contract Extension","n/a","n/a"],
    [192,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Traffic Management","2024-06-01 00:00:00","12","12","475000","570000","Contract Extension","n/a","n/a"],
    [193,"People","DN579573","CYPS","CYPS","Children and Families","Social Care","Variation","Advocacy Services :\n- CYPS Advocacy","2023-04-01 00:00:00",null,"36+24+24","476000","571200","Contract Variation","Yes","HASLT: 22/07/2021\nHAS EX: 13/08/2021"],
    [194,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Winter Service Equipment","2024-10-01 00:00:00","TBC","TBC","480000","576000","OJEU","Decision Record","tbc"],
    [195,"Professional","TBC","CS","HR_BS","Technology","ICT","Initial Term","Multifunctional devices including print management services and software, desktop printers, print room equipment and duplicators","2024-06-01 00:00:00",null,null,"TBC",null,"TBC","TBC","TBC"],
    [196,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Built Environment","Initial Term","Easingwold Three Gables Bridge Painting","2024-07-01 00:00:00","tba","tba","500000","600000","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [197,"Place","62271","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Bishop Monkton Replace PCU with traditional build","2023-04-01 00:00:00","tbc","tbc","580000","696000","Further Comp - External (OJEU)","Key Decision","tbc"],
    [198,"Professional","TBC","CS","Resources","Technology","ICT","Extension","Procurement Management Software (Currently YORtender/Proactis)","2024-06-01 00:00:00","84","36+24+24","1463000","1755600","Contract Extension","No","NA"],
    [199,"Professional","TBC","CS","LDS","Legal ","Legal","Initial Term","Counsel (Barristers) to act for NYCC in respect of a range of legal matters","2024-06-01 00:00:00","60","36+12+12","2649410","3179292","APL","Yes","TBC"],
    [200,"People","TBC","Community Development","CD","Economic Development, Regeneration, Tourism and Skills ","Social Care","Initial Term","Holiday Activities Fund","2025-04-01 00:00:00","TBC","36","585000","702000","Bid","TBC","TBC"],
    [201,"Professional","TBC","CS","HR_BS","Business Support","Utilities","Initial Term","Water Coolers and Associated goods","2024-06-11 00:00:00","48","24+24","40000","48000","TBC","No","NA"],
    [202,"Professional",null,"BES","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Passenger Transport","Initial Term","Special Educational Needs Home to School Transport - x6 schools (The Forest, Marchbank, Springwater, Woodlands) (add in Forest Moor and Brompton Hall)","2024-07-01 00:00:00",null,null,"TBC",null,"OJEU","Yes","TBC"],
    [203,"People","TBC","CYPS","CYPS","Children and Families","Social Care","Extension","Young Peoples Pathway - Emergency & Extended Supported Lodgings (Pathway 2 (SASH))","2023-10-01 00:00:00","48","24+12+12","600000","720000","Contract Extension","Yes","06/07/2021 -Urgency notice issued"],
    [204,"People","TBC","CYPS","CYPS","Children and Families","Social Care","Variation","Young Peoples Pathway - Emergency & Extended Supported Lodgings (Pathway 2 (SASH))","2023-04-01 00:00:00","48","24+12+12","600000","720000","Contract Variation","Yes","06/07/2021 -Urgency notice issued"],
    [205,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Hard FM (Lot 9) - Fire Equipment \n(to 31/08/2025)","2024-04-01 00:00:00","67","24+12+12+2+17","600000","720000","Contract Extension","Key Decision","tbc"],
    [206,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Initial Term","Contract for Pensions Tracing and Mortality Services","2024-07-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [207,"Professional",null,"CS","HR_BS","Human Resources","HR & Training","Extension","International Recruitment Agency","2024-07-12 00:00:00","48","24+24","130000","156000","Contract Extension","No","NA"],
    [208,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","SRF - A6108 Package 5 Leyburn to Bellerby cycleroute 24/25","2024-04-01 00:00:00","tbc","tbc","627440","752928","Further Comp - Internal (OJEU)","n/a","n/a"],
    [209,"Place","66216","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Waste","Initial Term","Craven area dry mixed recycling","2023-05-01 00:00:00","48","tbc","640000","768000","OJEU","YORwaste","TBC"],
    [210,"Professional","DN508661","CS","HAS","Technology","ICT","Extension","e-Scheduling System (2020 Ref: 2261) Lot 1 only","2024-07-19 00:00:00","60","36+12+12","221600","265920","Contract Extension","Decision Record","NA"],
    [211,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP3 Drainage and Specials - A60016","2023-07-01 00:00:00","5","tbc","652000","782400","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [212,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Variation ","Drug & Alcohol Service - Childrens - Rise (Healthy Child Substance Misuse)","2022-07-01 00:00:00","84","36+24+24","698000","837600","Contract Variation","TBC","TBC"],
    [213,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Initial Term","Drug & Alcohol Service - Childrens - Rise (Healthy Child Substance Misuse)","2028-04-01 00:00:00","TBC","TBC","698000","837600","OJEU - LTR","TBC","TBC"],
    [214,"Professional","DN548074","CS","HR_BS","Business Support","Clothing","Extension","Workwear & PPE\nUniforms","2024-07-19 00:00:00","48","36+12","785250","942300","Contract Extension","Decision Record","TBC"],
    [215,"Professional",null,"BES","Environment","Technology","ICT","Initial Term","Forensic Platform (currently with Nuix)","2024-07-21 00:00:00","36","36","74766","89719.2","TBC","No","NA"],
    [216,"Professional","DN565376","CS","Resources","Property, Procurement and Commercial ","Cleaning & Janitorial","Extension","Cleaning and Janitorial\n(currently supplied by YPO)","2024-08-01 00:00:00",null,null,"TBC",null,"TBC","TBC","TBC"],
    [217,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Active Travel Across the County A60011\nA59 (Maple Close, Harrogate to Knaresborough)\nVictoria Avenue, Harrogate                                                                                          \n","2023-03-01 00:00:00","4","4","700000","840000","Further Comp - Internal (Non OJEU)","Key Decision","tbc"],
    [218,"Professional","DN558175","CS","HR_BS","Business Support","Business Support","Extension","Shredding & Secure Disposal of Confidential Material - Confidential Shredding and General Paper Waste ","2024-08-01 00:00:00","48","24+12+12","60000","72000","Contract Extension","Decision Record","TBC"],
    [219,"Place","tbc","BES","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Selby Town Swing Bridge – fibre reinforced polymer (FRP) composite deck replacement.\nDesign, manufactuer and install","tba","6","6","750000","900000","Further Comp - External (OJEU)","Key Decision required?","n/a"],
    [220,"Professional","TBC","CS","Resources","Technology","ICT","Extension","Door and Security Access System\n(currently Semieta, provided by Access IT, under contract with Softcat)","2024-08-01 00:00:00","48","24+12+12","751406.25","901687.5","Contract Extension","Yes","2022-06-21 00:00:00"],
    [221,"Professional","33185","CS","HR_BS","Human Resources","HR & Training","Extension","Apprenticeship - End Point Assessment [EPA]","2024-08-01 00:00:00","48","24+24","£50,000 - £60,000","#VALUE!","Direct Award","Decision Record","NA"],
    [222,"Place","tbc","BES","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Area 3 Whitby R&R Tender Package 1","2023-06-05 00:00:00","3","3","776702","932042.4","Further Comp - Internal (Non OJEU)","Yes","2022-11-30 00:00:00"],
    [223,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP1 R&R A30013","2023-06-01 00:00:00","4","tbc","777000","932400","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [224,"Professional",null,"CS","Resources","Finance (inc. Pension Fund)","Finance","Initial Term","Purchasing Cards","2024-08-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [225,"Professional","30219","CS","HR_BS","Technology","ICT","Extension","Recruitment Admin System (DBS Functionality)","2024-08-24 00:00:00","48","24+12+12","100000","120000","Direct Award","Decision Record","tbc"],
    [226,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","SRF - A6108 Package 7 Richmond Town Centre","2023-07-01 00:00:00","tbc","tbc","791430","949716","Further Comp - Internal (OJEU)","n/a","n/a"],
    [227,"People","TBC","CS","LE","Prevention & Service Development","Social Care","Initial Term","DOMESTIC ABUSE - Services for Adult Perpetrators of Domestic Abuse in North Yorkshire & City of York","2023-04-01 00:00:00","60","48+12","800000","960000","OJEU - LTR","Yes","TBC"],
    [228,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Extension","DOMESTIC ABUSE - Domestic Abuse Victims Community-Based Services in North Yorkshire & City of York","2023-04-01 00:00:00","60","48+12","800000","960000","Contract Extension","No","N/A"],
    [229,"Place","66500","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Great Ouseburn Classroom remodel plus ancillary\nHire or purchase of prefab","2023-07-01 00:00:00","3","3","800000","960000","Further Comp - External (non OJEU)","Decision Record","tbc"],
    [230,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Hard FM (Lot 7) - Chimneys, Lighting Conductors \n(to 31/08/2025)","2024-04-01 00:00:00","67","24+12+12+2+17","800000","960000","Contract Extension","Key Decision","tbc"],
    [231,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Rural grass cutting","2024-05-01 00:00:00","24","24","800000","960000","Contract Extension","n/a","n/a"],
    [232,"Place","tbc","HAS","CD","Housing","Built Environment","Initial Term","Homelessness provision in Scarborough","2023-04-01 00:00:00","tbc","tbc","800000","960000","Bid","Decision Record","tbc"],
    [233,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP2 Patching A30014","2023-09-01 00:00:00","2","tbc","801000","961200","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [234,"Place","tbc","BES","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Engineering & Environment","Extension","Vehicle Restraint System Repair and Maintenance","2024-08-01 00:00:00","24","24","816640.3133333334","979968.376","Contract Extension","Key Decision","tbc"],
    [235,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Built Environment","Initial Term","Highway access / enabling works to site for potential 0-100 Place SEN School, Osgodby, Selby (Selby Free School)","2023-10-01 00:00:00","tbc","tbc","835329.96","1002395.9519999999","Further Comp - Internal (Non OJEU)","Key Decision","tbc"],
    [236,"Professional","30219","CS","HR_BS","Technology","ICT","Extension","Recruitment Admin System (DBS Functionality)","2024-08-24 00:00:00","48","24+12+12","100332","120398.4","Direct Award","Decision Record","N/A"],
    [237,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","SRF Package 5 Laybys A10027\nA6108","2023-05-01 00:00:00","3","3","850000","1020000","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [238,"Place","tbc","BES","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Huntriss Row\nScarborough\nA30003","2023-07-01 00:00:00","tbc","tbc","900000","1080000","Further Comp - Internal (Non OJEU)","n/a","tbc"],
    [239,"Professional","TBC","CS","Resources","Property, Procurement and Commercial ","Libraries","Initial Term","Storage- Long term deep storage for archive materials","2024-08-28 00:00:00","120","TBC","TBC","#VALUE!","TBC","Decision Record","Yes"],
    [240,"Professional","DN546084","CS","HR_BS","Human Resources","Training","Extension","Social Worker Degree Apprenticeship","2024-09-01 00:00:00","60","36+12+12","230000","276000","Contract Extension","No","NA"],
    [241,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Non Operated Plant Hire","2023-05-20 00:00:00","24","24","930000","1116000","Contract Extension","n/a","n/a"],
    [242,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Carers Breaks Sitting Services","2023-04-01 00:00:00","60","36+24","968000","1161600","OJEU - LTR","Yes","HASLT: 14/07/2022\nHAS EX:  16/09/2022"],
    [243,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Area 6 Otley Road Cycleway A60012\nNPIF2\n(West Harrogate Scheme (NPIF))\nNew roundabout and cycle route, crossings, kerbs","2023-08-01 00:00:00","2","2","989000","1186800","Further Comp - Internal (Non OJEU)","Key Decision","2019-08-23 00:00:00"],
    [244,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Hard FM (Lot 12) - Asbestos Abatement \n(to 31/08/2025)","2024-04-01 00:00:00","67","24+12+12+2+17","1000000","1200000","Contract Extension","Key Decision","tbc"],
    [245,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Road traffic signs","2025-06-01 00:00:00","48","48","1000000","1200000","OJEU","n/a","n/a"],
    [246,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","The Ghyll Children's Resource Centre, Skipton - reinstate residential centre","2023-07-01 00:00:00","tbc","tbc","1000000","1200000","Direct Award","Decision Record","tbc"],
    [247,"Place","66016","BES","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","A20016 Area 2 23/24 Tender Package 1 R&R Schemes\nA19 Easingwold Bypass\nThirsk Road, Easingwold\nEasingwold Market Place\nC86 Uppleby\nBoltby\nPickhill","2023-05-01 00:00:00","1","1","1009863","1211835.6","Further Comp - Internal (Non OJEU)","n/a","n/a"],
    [248,"Professional"," ","CS","Resources","Finance (inc. Pension Fund)","Finance","Initial Term","Pension Legal Advisors","2024-09-01 00:00:00","72","TBC","£20k pa","#VALUE!","TBC","Decision Record","NA"],
    [249,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","EDRMS Support (Electronic Document and Records Management System)","2024-09-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","N/A"],
    [250,"Professional","TBC","CS","CYPS","Technology","ICT","Initial Term","Pobble - Pupil Engagement tool","2024-09-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [251,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","SRF Package 4 Richmond and Skeeby A10026\nRichmond Town Centre\nRichmond School\nSkeeby","2023-08-01 00:00:00","2","2","1122000","1346400","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [252,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP1 R&R and PSDP A10022\nUckerby Hall Road\nUckerby Grange Road\nEshington Lane\nHargill\nSatronside\nQuakers Lane\nBrokes\nGreen Howards\nRayns Bridge\nFeetham & Satronside","2023-06-01 00:00:00","2","2","1125000","1350000","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [253,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Whitby scheme 1 / Junction improvement","tbc","tbc","tbc","1150000","1380000","Further Comp - Internal (OJEU)","N/A","n/a"],
    [254,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Whitby scheme 2 / Public realm works","tbc","tbc","tbc","1150000","1380000","Further Comp - Internal (OJEU)","N/A","n/a"],
    [255,"Place","59449","BES","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","A60014 Area 6 & Area 5 Joint R&R Package 22/23              ","2023-02-01 00:00:00","2","2","1174000","1408800","Further Comp - Internal (Non OJEU)","N/A","n/a"],
    [256,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Workshop Parts / Inventory ","2023-06-01 00:00:00","36","24+12","1200000","1440000","OJEU","n/a","n/a"],
    [257,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP1 R&R and Patching - A50007","2023-06-12 00:00:00","3","tbc","1212000","1454400","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [258,"Place","TBC","BES","Resources","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","A40010 Area 4 23/24 Tender package 1\nGillamoor R&R / Claxton R&R / Sinton R&R / Pickering R&R / Settrington R&R / Keldhome R&R + PSDP\n","2023-07-01 00:00:00","3","3","1263995.45","1516794.54","Further Comp - Internal (Non OJEU)","n/a","n/a"],
    [259,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Extension","Drug & Alcohol Service - Childrens - Rise (Healthy Child Substance Misuse)","2024-04-01 00:00:00","84","36+24+24","1274000","1528800","Contract Extension","No","25/08/2020"],
    [260,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Fleet","Initial Term","Vehicle Lifting Equipment","2023-06-01 00:00:00","48","24+24","1325000","1590000","OJEU","n/a","n/a"],
    [261,"Professional","DN476035","BES","Environment","Technology","Passenger Transport","Extension","Fleet Management System\n(currently provided by AssetWorks)","2024-09-07 00:00:00","60","36+12+12","198500","238200","Contract Extension","Decision Record","NA"],
    [262,"Professional","TBC","CS","Resources","Property, Procurement and Commercial ","Catering","Initial Term","Innovation Catering Concept","2024-09-11 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","TBC"],
    [263,"Professional","DN544810","CS","Resources","Technology","ICT","Extension","Library PC Booking and Print Management System","2024-10-01 00:00:00","60","36+24","71000","85200","Direct Award","Decision Record","N/A"],
    [264,"Professional","DN437927","CS","Resources","Finance (inc. Pension Fund)","Finance","Extension","Debt Tracing and Debt Recovery Services","2024-10-01 00:00:00","60","36+24","75000","90000","Contract Extension","Decision Record","NA"],
    [265,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds ","Engineering & Environment","Initial Term","Property Level Resilience Scheme","2023-06-01 00:00:00","48","36+12","1500000","1800000","Framework Establish","Yes","tbc"],
    [266,"People","TBC","HAS","CD","Housing","Social Care","Initial Term","REACH - homelessness provision S'Boro - Phase 2","2024-04-01 00:00:00","TBC","TBC","1500000","1800000","OJEU - LTR","TBC","TBC"],
    [267,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Ryedale DC Depot","2024-04-01 00:00:00","tbc","tbc","1500000","1800000","TBC","Key Decision","tbc"],
    [268,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","TP1 R&R and PSDP - A40010","2023-06-01 00:00:00","7","tbc","1511000","1813200","Further Comp - Internal (Non OJEU)","TBC","TBC"],
    [269,"Place","TBC","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Spray Injection Patching","2023-10-01 00:00:00","48","24+12+12","1705948","2047137.6","Bid","TBC","TBC"],
    [270,"Place","tbc","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Waste","Initial Term","On farm composting of green waste (Ryedale, Selby and Scarborough areas)","2023-12-01 00:00:00","48","assumed","1712000","2054400","OJEU","Key Decision","tbc"],
    [271,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Extension","Community Mental Health Services  ","2023-10-01 00:00:00","84","36+24+24","1727447.82","2072937.384","Contract Extension","Yes ","HASLT:\nHAS EX: 09/12/2022"],
    [272,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Community Mental Health Services  ","2025-10-01 00:00:00","TBC","TBC","1727447.82","2072937.384","OJEU - LTR","Yes ","TBC"],
    [273,"Professional","TBC","CS","Resources","Property, Procurement and Commercial ","Property","Extension","Staff Restaurant County Hall (Concessions contract)","2024-10-10 00:00:00","120","60+36+24","130000","156000","OJEU","TBC","TBC"],
    [274,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Non Operated Plant Hire","2023-05-20 00:00:00","48","24+24","1860000","2232000","OJEU","n/a","n/a"],
    [275,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Traffic Management","2023-06-01 00:00:00","48","24+12+12","1900000","2280000","OJEU","n/a","n/a"],
    [276,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Extension","(HP) Offender Services (Resettlement and Community Safety)(Housing related support) including Substance Misuse Lot","2024-10-01 00:00:00","48","36+12","1939200","2327040","Contract Extension","Yes","2020-01-10 00:00:00"],
    [277,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","(HP) Offender Services (Resettlement and Community Safety)(Housing related support) including Substance Misuse Lot","2025-10-01 00:00:00","TBC","TBC","1939200","2327040","OJEU - LTR","Yes","TBC"],
    [278,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Rural grass cutting","2024-05-01 00:00:00","60","36+24","2000000","2400000","OJEU","n/a","n/a"],
    [279,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Extension","Welfare Benefits information & Advice\nLot 1 - Information & Advice Service\nLot 2 - Welfare rights information & guidance service","2022-10-01 00:00:00","84","60+6+6+6+6","2158390","2590068","Contract Extension","Yes","HASLT: 18/11/2021\nHASEX: 14/01/2022"],
    [280,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Welfare Benefits information & Advice\nLot 1 - Information & Advice Service\nLot 2 - Welfare rights information & guidance service","2024-04-01 00:00:00","TBC","TBC","2158390","2590068","TBC","Yes","HASLT: 07/09/2023\nHASEX: 13/10/2023"],
    [281,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Extension","Housing support - Mental Health ","2023-10-01 00:00:00","48","24+12+12","2231335","2677602","Contract Extension","Yes","2019-09-13 00:00:00"],
    [282,"People","DN567561","HAS","HAS","Prevention & Service Development","Social Care","Extension","Home From Hospital","2027-04-01 00:00:00","84","60+24","2235000","2682000","Contract Extension","Yes","HASLT: 05/08/21\nHAS EX: 13/08/21"],
    [283,"People","TBC","CYPS","CYPS","Children and Families","Social Care","Initial Term","Independent Adoption Support Service (on behalf of Consortium of Regional Adoption Agencies)","2024-01-01 00:00:00","TBC","TBC","2250000","2700000","TBC","Yes","TBC"],
    [284,"People","DN577410","HAS/CYPS","HAS","Prevention & Service Development","Social Care","Extension","Carers Information and Advice Service / \nYoung Carers information and advice service ","2025-07-01 00:00:00","60","36 + 24 + 24","2300000","2760000","Contract Extension","Yes"," HASLT: 15/07/21\nHAS EX: 13/08/21"],
    [285,"Professional","TBC","BES","Environment","Technology","ICT","Initial Term","Vehicle Telematics\n(currently provided by Ctrack)","2024-10-30 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [286,"People","TBC","CS","LE","Policy, Performance, Refugee / Asylum Issues and Community Safety","Social Care","Initial Term","DOMESTIC ABUSE - Domestic Abuse Accommodation-based Support Services","2024-04-01 00:00:00","48","36+12","2390599","2868718.8","OJEU - LTR","Yes","TBC"],
    [287,"People","DN366165","HAS","HAS","Prevention & Service Development","Social Care","Extension","Dementia Support and Advice Services","2023-04-01 00:00:00","120","48+24+24+24","2574075","3088890","Contract Extension","Yes ","HASLT 17/11/2022\nHASEX - 07/12/2022"],
    [288,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Oakbeck / Springwater redevelopments","2024-04-01 00:00:00","tbc","tbc","2600000","3120000","TBC","Key Decision","tbc"],
    [289,"People","N/A","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Prevention and Wellbeing Service","2025-04-01 00:00:00","TBC","TBC","2606235.6","3127482.72","Grant","Yes","TBC"],
    [290,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Skipton Greatwood Primary School - provide additional pupil places to expand the school from 1 form entry to 2 form entry","2023-07-01 00:00:00","tbc","tbc","2641000","3169200","Further Comp - External (non OJEU)","Key Decision","tbc"],
    [291,"Professional","51363","CS","Resources","Technology","ICT","Extension","Smoking Cessation System (Quit Manager, provided by Bionical) (PMO Ref: TBC)","2024-11-01 00:00:00","60","36+12+12","57502.6","69003.12","Contract Extension","No","NA"],
    [292,"Professional","53588","CS","Resources","Property, Procurement and Commercial ","Horticulture & Arboriculture","Extension","Arboriculture services","2024-11-01 00:00:00","48","24+12+12","135599","162718.8","Contract Extension","No","NA"],
    [293,"People","TBC","CYPS","CYPS","Schools, Adult Education & Outdoor Education Services","Education & Training","Initial Term","Maths Initiative - Multiply Numeracy Skills","2022-09-01 00:00:00","36","36","2700000","3240000","Grant","Yes","Provisional 30/08/2022"],
    [294,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Initial Term","Adult Weight Management","2024-07-01 00:00:00","TBC","TBC","2700000","3240000","OJEU - LTR","Yes ","HASLT: 23/11/23\nHASEX: 08/12/23"],
    [295,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Extension","Adult Weight Management","2024-07-01 00:00:00",null,null,"2700000","3240000","Contract Extension","Yes ","HASLT: 23/11/23\nHASEX: 08/12/23"],
    [296,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Highway Electrical Installations including ICP","2022-06-01 00:00:00","48","48","2800000","3360000","Further Comp - External (OJEU)","N/A","n/a"],
    [297,"People","52084","CYPS","CYPS","Inclusion","Social Care","Initial Term","Universal Youth Services ","2022-09-01 00:00:00","36","36+36+24","2800000","3360000","Contract Variation","Yes","Key Decision 25/11/2021"],
    [298,"Professional","36463","CS","HR_BS","Human Resources","HR & Training","Extension","Agency Services ","2024-11-01 00:00:00","48","24+24","16000000","19200000","Contract Extension","Yes","2022-05-30 00:00:00"],
    [299,"People","52084","CYPS","CYPS","Inclusion","Social Care","Extension","Universal Youth Services ","2025-09-01 00:00:00","96","36+36+24","2800000","3360000","Contract Extension","Yes","Key Decision 25/11/2021"],
    [300,"People","52084","CYPS","CYPS","Inclusion","Social Care","Extension","Universal Youth Services ","2028-09-01 00:00:00","96","36+36+24","2800000","3360000","Contract Extension","Yes","Key Decision 25/11/2021"],
    [301,"Place","TBC","BES ","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","A60015 Area 6 R&R","2023-07-01 00:00:00","1","1","2877000","3452400","Further Comp - Internal (Non OJEU)","n/a","TBC"],
    [302,"Professional","DN573174","CS","Resources","Technology","ICT","Variation","Telephony - Corporate Mobile Phones - Smartphone and basic mobile contracts","2024-11-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Yes","Previously taken 24/09/2021"],
    [303,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Utilities","Initial Term","Liquid Fuel - Oil - heating","2023-10-01 00:00:00","48","48","3094916","3713899.2","TBC","Key Decision","tbc"],
    [304,"People","TBC","HAS/CYPS","HAS","Director of Public Health","Public Health","Extension","Targeted Healthy Child Service","2025-04-01 00:00:00","60","36+24","3180000","3816000","Contract Extension","Yes","2019-12-06 00:00:00"],
    [305,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Corporate Anti-Virus \n(currently Trend Micro, provided under contract with Softcat)","2024-11-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","NA"],
    [306,"Professional","34436","CS","HR_BS","Technology","ICT","Extension","HR Recruitment Main Admin System (Havas People)","2024-11-05 00:00:00","48","24+12+12","136000","163200","Contract Extension","Decision Record","NA"],
    [307,"Professional","DN578215","CS","Resources","Property, Procurement and Commercial ","Catering","Extension","Fresh Fruit, Vegetables and Milk Products","2024-11-09 00:00:00","54","30+24","4250000","5100000","Contract Extension","Yes","TBC"],
    [308,"Professional","DN388786","CS","Resources","Technology","ICT","Extension","Service Management System\n(currently Ivanti Service Manager, provided under contract with Ultima)","2024-11-11 00:00:00","120","60 + 24 + 24 + 12","723364.8","868037.76","Contract Extension","Yes","TBC - 04/10/22???"],
    [309,"Place","TBC","BES","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Harrogate Convention Centre Redevelopment\nVenue Operators\nMechanical and Electrical Plant","tbc","tbc","3","3500000","4200000","TBC","n/a","n/a"],
    [310,"Place","tbc","NY H","Environment","Highways, Transportation, Parking Services, Parks and Grounds ","Built Environment","Initial Term","Supply of liquid fuels - road","2023-06-01 00:00:00","tbc","tbc","3580000","4296000","TBC","n/a","n/a"],
    [311,"People","TBC","HAS","CD","Housing","Social Care","Initial Term","Homeless Prevention - generic \"floating support\"","2024-10-01 00:00:00","60","60","3623815","4348578","OJEU - LTR","Yes","HASLT: 05/10/2023\nHASEX: 10/11/2023"],
    [312,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Variation","Assistive Technology","2023-04-01 00:00:00","60","36+12+12","3800000","4560000","Contract Variation","Yes","HASLT: 12/2022 \nHAS EX: 13/01/2023"],
    [313,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Assistive Technology","2024-04-01 00:00:00","TBC","TBC","3800000","4560000","OJEU - LTR","Yes","HASLT: 11/05/2023\nHASEX: 09/06/2023"],
    [314,"People","TBC","CYPS","CYPS","Children and Families","Social Care","Extension","Clinical psychologist (No Wrong Door, CAMHS, PiP).","2023-04-01 00:00:00","60","36+12+12","3861540","4633848","Contract Extension","No","Original procurement was KD"],
    [315,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Welburn Hall Maintenance Scheme\nHeating and drainage attenuation","tbc","tbc","tbc","4000000","4800000","OJEU","Key Decision","tbc"],
    [316,"Professional","DN387270 ","CS","Resources","Technology","ICT","Initial Term","Vmware licences for Vsphere, Virtual Centre & SRM  ","2024-11-30 00:00:00","TBC","TBC","TBC",null,"TBC","Decision Record","TBC"],
    [317,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Roofing Framework","2024-04-01 00:00:00","48","48","4000000","4800000","OJEU","Key Decision","tbc"],
    [318,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Supply of General Building Materials","tbc","12","12","4000000","4800000","Further Comp - External (OJEU)","n/a","n/a"],
    [319,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Reporting system - Aqua (ProAchieve)","2024-11-30 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [320,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Supply of Electrical Equipment","2025-06-01 00:00:00","48","48","4400000","5280000","OJEU","n/a","n/a"],
    [321,"Place","tbc","NY H","Environment","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Supply of Gritters including leasing options","2023-02-16 00:00:00","24","24","4700000","5640000","Further Comp - External (OJEU)","N/A","n/a"],
    [322,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Replacement windows tender ","tbc","3","3","4920000","5904000","OJEU","tbc","tbc"],
    [323,"People","TBC","CYPS","CYPS","Schools, Adult Education & Outdoor Education Services","Education & Training","Initial Term","School Improvement & Locality Boards  ","2022-11-01 00:00:00","60","35+24","5000000","6000000","OJEU - LTR","Yes","2021-05-25 00:00:00"],
    [324,"Professional",null,"CS","CYPS","Technology","ICT","Initial Term","Angel Solution - Pendulum & Broadcast & Watchsted Inspector Modules ","2024-11-30 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [325,"Professional","DN483368","CS","HR_BS","Human Resources","HR & Training","Extension","Framework Agreement for Everybody Benefits","2024-12-01 00:00:00","48","36+12","50000000","60000000","Contract Extension","Yes","TBC"],
    [326,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Outdoor learning service Bewerley Park reconfiguration\nReplacement of residential blocks in phases","tbc","12","12","5000000","6000000","OJEU","Key Decision","tbc"],
    [327,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Levelling Up Fund (LUF) Thirsk Platform","2023/24","12","12","5000000","6000000","Further Comp - External (OJEU)","Key Decision","tba"],
    [328,"People","TBC","Community Development","CD","Economic Development, Regeneration, Tourism and Skills ","Social & Community Care Supplies & Services - Adults","Initial Term","Household Support Fund (HSF 4) - DWP Voucher Scheme ","2023-08-01 00:00:00","TBC","TBC","5000000","6000000","Further Comp - External (OJEU)","Yes","TBC"],
    [329,"Place","62168","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","North Northallerton New Primary School \nRe tender","2023-09-01 00:00:00","12","12","5230000","6276000","OJEU","Key Decision","tbc"],
    [330,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Manse Farm, Knaresborough New Primary School\nRe tender","2023-09-01 00:00:00","12","12","5517000","6620400","OJEU","Key Decision","tbc"],
    [331,"Place","tbc","LGR","Resources","Property, Procurement and Commercial ","Utilities","Initial Term","Water Retail Services (De-regulation of water)","2023-04-01 00:00:00","48","tbc","5600000","6720000","OJEU","Key Decision","tbc"],
    [332,"People","DN579573","HAS/CYPS/CS","HAS","Prevention & Service Development","Social Care","Extension","Advocacy Services :\n- Independent Health Complaints\n- CYPS Advocacy\n- HAS Advocacy","2025-04-01 00:00:00","84","36+24+24","5618000","6741600","Contract Extension","Yes","HASLT: 22/07/2021\nHAS EX: 13/08/2021"],
    [333,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Ripon Barracks New Primary School","2024-08-01 00:00:00","12","12","6000000","7200000","OJEU","Key Decision","tbc"],
    [334,"Place","tbc","CyPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Norton Lodge (Malton) New Primary School ","2026-08-01 00:00:00","12","12","6000000","7200000","OJEU","Key Decision","tbc"],
    [335,"People","TBC","CYPS","CYPS","Children and Families","Social Care","Initial Term","Therapeutic Support to Adopters and Adoptees (collaborative arrangement)","2027-04-01 00:00:00","60","60","6000000","7200000","OJEU - LTR","Yes","TBC"],
    [336,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Conistone Cold / Aire Bridge Feasibility Project","2023-07-01 00:00:00","tbc","tbc","6000000","7200000","OJEU","Key Decision","tbc"],
    [337,"Professional",null,"BES","Environment","Technology","ICT","Initial Term","Mobile Phone Forensic Licensing (currently with Celebrite)","2024-12-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [338,"Professional","DN502144","CYPS","Resources","Finance (inc. Pension Fund)","Finance","Extension","The Provision of Printed Cheques","2024-12-13 00:00:00","84","36 + 12 + 12 + 12 + 12","65000","78000","Contract Extension","No","NA"],
    [339,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Netscaler, ADC licensing and hardware support (Citrix)","2024-12-19 00:00:00","60","60","86306.16","103567.392","Further Comp - External (OJEU)","Decision Record","NA"],
    [340,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","HP IMC - support","2024-12-20 00:00:00","TBC","TBC","86306","103567.2","TBC","No","NA"],
    [341,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Specialist Surfacing","2025-06-01 00:00:00","48","48","6200000","7440000","OJEU","n/a","n/a"],
    [342,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","NYNET Solutions Agreement / Corporate WAN\n(currently Nynet)","2024-12-31 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Yes","TBC"],
    [343,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Levelling Up Fund (LUF) Scarborough Transport Hub / public realm","2023/24","12","12","7100000","8520000","Further Comp - External (OJEU)","Key Decision","tba"],
    [344,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Levelling Up Fund (LUF) Catterick Garrison - civils / public realm","2023/24","12","12","8000000","9600000","Further Comp - External (OJEU)","Key Decision","tba"],
    [345,"Professional","\t27500","CS","HR_BS","Business Support","Business Support","Extension","The Supply and Delivery of Office Supplies\n (currently supplied by Lyreco) ","2025-01-01 00:00:00","48","36+12","582000","698400","Contract Extension","Decision Record",null],
    [346,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Extension","Sustainable Warmth","2023-04-01 00:00:00","18","12+6","8400000","10080000","Contract Extension","TBC","TBC"],
    [347,"People","50483","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Extra Care Housing - Whitby","2023-04-01 00:00:00","TBC","TBC","10000000","12000000","Framework Establish","Yes ","2015"],
    [348,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Levelling Up Fund (LUF) Catterick Garrison - buildings","2023/24","12","12","12000000","14400000","Further Comp - External (OJEU)","Key Decision","tba"],
    [349,"Place","tbc","CYPS","CYPS","Property, Procurement and Commercial ","Built Environment","Initial Term","Harrogate West Two Primary Schools ","2025-08-01 00:00:00","12","12","12000000","14400000","OJEU","Key Decision","tbc"],
    [350,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Supply of Road Salt","2025-04-01 00:00:00","tbc","tbc","15000000","18000000","OJEU","Key Decision","tbc"],
    [351,"Place","TBC","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Waste","Initial Term","Supply and potential delivery of waste bins - wheeled","2025-08-01 00:00:00","tbc","tbc","15000000","18000000","TBC","yes","tbs"],
    [352,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Wide Area Network (WAN) - Corporate","2025-01-01 00:00:00","TBC","TBC","4000000","4800000","TBC","TBC","TBC"],
    [353,"Place","tbc","HAS","HAS","Adult Social Care","Health and Adult Services","Initial Term","Residential Dementia Care Facility, Cardale Park, Harrogate","tbc","24","24","17000000","20400000","OJEU","tbc","tbc"],
    [354,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Hard FM (Lot 1) - Responsive Maintenance with Lot 3 - Alarms \n(to 31/01/2026)","2024-02-01 00:00:00","48","24+12+12","17020000","20424000","Contract Extension","Key Decision","tbc"],
    [355,"Place","TBC","CS","LE","Policy, Performance, Refugee / Asylum Issues and Community Safety","Built Environment","Initial Term","Home Upgrade Grant Phase 2 (HUG2)","2023-01-02 00:00:00","36","36","18000000","21600000","Direct Award","Yes ","TBC"],
    [356,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Malton / Norton Pinch Point scheme / Butchers Corner","tbc","tbc","tbc","18000000","21600000","OJEU","Key Decision","tbc"],
    [357,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Levelling Up Fund (LUF) Seamer Rail / Road Bridge","2023/24","12","12","20000000","24000000","Further Comp - External (OJEU)","Key Decision","tba"],
    [358,"Place","tbc","BES ","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Levelling Up Fund (LUF) Malton station and public realm between Malton and Norton","2023/24","12","12","20000000","24000000","Further Comp - External (OJEU)","Key Decision","tba"],
    [359,"Professional","38914","CS","Resources","Technology","ICT","Initial Term","Microsoft Licencing Solution Partner for Campus Agreement, Server and Cloud Enrolment and Enterprise Subscription Agreement.","2025-01-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Yes","TBC"],
    [360,"Place","TBC","BES","CD","Economic Development, Regeneration, Tourism and Skills ","Built Environment","Initial Term","UK Shared Prosperity Fund and Rural England Prosperity Fund\n(see also UKSPF - VCS Partnership Programmes)\n(see also Grow Yorkshire - UK Shared Prosperity Fund)","tbc","tba","tba","22300000","26760000","TBC","TBC","TBC"],
    [361,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Extension","Sexual Health","2026-04-01 00:00:00","120","48+36+36","25252489","30302986.8","Contract Extension","Yes","29/03/2019 & 03/09/2019"],
    [362,"Professional","TBC","CS","LE","Communications","Media & Communications","Initial Term ","Multidisciplinary Media Services Framework","2025-01-02 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","NA"],
    [363,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Utilities","Initial Term","Purchase of Power (Electricity) (including UMS for street)","2023-04-01 00:00:00","48","48","34747020","41696424","TBC","Key Decision","tbc"],
    [364,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Variation ","Drug & Alcohol Service - Adults - Horizons (Substance Misuse)","2022-07-01 00:00:00","120","60+36+24","36762000","44114400","Contract Variation","TBC","TBC"],
    [365,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Initial Term","Drug & Alcohol Service - Adults - Horizons (Substance Misuse)","2029-10-01 00:00:00","TBC","TBC","36762000","44114400","OJEU - LTR","TBC","TBC"],
    [366,"People","DN366170","HAS","HAS","Director of Public Health","Public Health","Extension","Drug & Alcohol Service - Adults - Horizons (Substance Misuse)","2024-10-01 00:00:00","120","60+36+24","38547674.5","46257209.4","OJEU - LTR","No","TBC"],
    [367,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds ","Engineering & Environment","Initial Term","West Yorkshire Combined Authority Transforming Cities Fund\nWYCA TCF / Overarching project\nHarrogate / Skipton / Selby","2024-03-01 00:00:00","tbc","tbc","41476123","49771347.6","Further Comp - Internal (OJEU)","Key Decision","tbc"],
    [368,"Professional",null,"CS","Resources","Technology","ICT","Initial Term","MANY (ANPR Cameras)","2025-01-10 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","TBC"],
    [369,"People","DN TBC","HAS/CYPS","HAS","Director of Public Health","Public Health","Extension","Healthy Child Programme","2024-04-01 00:00:00","120","33+36+24+24","70233720","84280464","Contract Extension","Yes","2019-08-13 00:00:00"],
    [370,"Place","tbc","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Waste","Extension","Waste Management Services 2015","2025-09-18 00:00:00","60","60","93750000","112500000","Contract Extension","Key Decision","tbc"],
    [371,"Place","tbc","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Waste","Initial Term","Waste Management Services post 2025","2025-09-18 00:00:00","120","tbc","187500000","225000000","OJEU","Key Decision","tbc"],
    [372,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Carriageway Planing and Surfacing Contractors Framework\n(Refresh to current framework exp 31/03/2024)","2024-04-01 00:00:00","Potential 48","Potential 48","300000000","360000000","OJEU","Key Decision","tbc"],
    [373,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Civil Engineering Contractors Framework\n(Refresh to current in train framework)","2025-08-02 00:00:00","Potential 48","Potential 48","300000000","360000000","OJEU","Key Decision","tbc"],
    [374,"Place","tbc","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Engineering & Environment","Initial Term","Allerton Waste Recovery Park","2043-04-01 00:00:00","tbc 300","tbc","1000000000","1200000000","OJEU","Key Decision","potential for future requirement"],
    [375,"People","54565","HAS","HAS","Adult Social Care","Social Care","Initial Term","NYCC Approved Provider List:\n - Supported Living \n - Nursing & Residential \n - Home Based Support\n - Community Based Support","2022-11-01 00:00:00","84","60+12+12","1200000000","1440000000","OJEU - LTR","Yes ","HASLT: 25/11/2021 \nHAS EX: 10/12/2021\nFull Executive: 25/01/2022\nHASLT: 07/07/2022 "],
    [376,"People","54565","HAS","HAS","Prevention and Service Development ","Social Care","Extension","NYCC Approved Provider List:\n - Supported Living \n - Nursing & Residential \n - Home Based Support\n - Community Based Support","2027-11-01 00:00:00","84","60+12+12","1200000000","1440000000","Contract Extension","Yes ","HASLT: 25/11/2021 \nHAS EX: 10/12/2021\nFull Executive: 25/01/2022\nHASLT: 07/07/2022 "],
    [377,"Professional","ID: 28074\nDN535837","BES","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Passenger Transport","Extension","Bus Service Registration, Publicity and NaPTAN Data System (PMO Ref: 3023 'Open Bus Data')","2025-01-14 00:00:00","63","39+24","157248.82","188698.584","Bid","Decision Record","N/A"],
    [378,"People","TBC","HAS","HAS","Prevention and Service Development ","Social Care","Initial Term","Housing support - Mental Health ","2024-10-01 00:00:00","TBC","TBC","TBC","#VALUE!","OJEU - LTR","Yes","TBC"],
    [379,"Professional","TBC","CS","HR_BS","Technology","ICT","Initial Term","HR & Payroll System\n(currently ResourceLink, provided by Zellis)","2025-02-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Yes","TBC"],
    [380,"Professional",null,"CS","HR_BS","Business Support","Facilities","Initial Term","Business Travel","2025-02-22 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Yes","TBC"],
    [381,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Outbreak Management System Support and Maintenance","2025-03-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No ","NA"],
    [382,"Professional","DN218887","CS","Resources","Technology","ICT","Extension","Insurance System\n(currently EvoClaim, provided by DWF 360)","2025-03-08 00:00:00","96","24+24+24+24+24+24","177098","212517.6","Contract Extension","Decision Record","NA"],
    [383,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Insurance and Claims Management System (PMO Ref: 1587)\n(currently EvoClaim, provided by DWF 360)","2025-03-08 00:00:00","TBC","TBC","TBC","#VALUE!","OJEU","TBC","TBC"],
    [384,"Professional","TBC","BES","LDS","Legal ","Legal","Initial Term","Legal Advice for Waste Strategy","2025-03-14 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [385,"Professional","DN533038","CS","Environment","Technology ","Trading Standards","Extension","Trading Standards Business System (2020 PMO Ref: 2953)\n(currently APP, provided by Civica)","2025-03-31 00:00:00","60","36+12+12","112055","134466","Contract Extension","Decision Record","NA"],
    [386,"Professional","38992","CS","Resources","Technology","ICT","Initial Term","EForms for Website","2025-04-01 00:00:00",null,null,"TBC",null,"TBC","Decision Record","NA"],
    [387,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Wide Area Network (WAN) - Schools\n(currently Nynet)","2025-04-01 00:00:00","TBC","TBC","TBC",null,"TBC","Yes","TBC"],
    [388,"Professional","48922","CS","Resources","Technology","ICT","Extension","Traded Service Online Communications Platform\n(currently SLA Online - provided by Frontline Data)\n(2020 Ref: 3011 - NYES Future Technology Review)","2025-04-01 00:00:00","60","36+12+12","79000","94800","Direct Award","Decision Record","NA"],
    [389,"Professional",null,"BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds ","Horticulture & Arboriculture","Initial Term","Seasonal Vegetation Cutting Programme 2020-24","2025-04-01 00:00:00","TBC","TBC","100000","120000","Contract Extension","Decision Record","TBC"],
    [390,"Professional",null,"CS","Resources","Technology","ICT","Initial Term","Gartner for IT leaders (subscription)","2025-04-01 00:00:00","24","24","187400","224880","Further Comp - External (non OJEU)","Decision Record","NA"],
    [391,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Initial Term","Infection Control and Prevention","2024-04-01 00:00:00","TBC","TBC","£480,424.00 GBP (SOW 9)","#VALUE!","OJEU - LTR","Yes ","HASLT: 21/09/2023\nHASEX: 10/11/2023"],
    [392,"Professional","37487","LGR","LDS","Technology ","ICT","Extension","Elections Management System","2025-04-01 00:00:00","41","29+12","225000","270000","Contract Extension","Decision Record","N/A"],
    [393,"Professional",null,"CS","Resources","Technology","ICT","Initial Term","Internet Filtering for Schools (Currently Smoothwall Product via Insight)","2025-04-01 00:00:00","36","36","470000","564000","TBC","Yes","TBC"],
    [394,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Supply, Install & Monitor Fixed CCTV Security Cameras","tba","60","60","475000","570000","TBC","N/A","No"],
    [395,"Professional","36492","CS","Environment","Highways, Transportation, Parking Services, Parks and Grounds ","Horticulture & Arboriculture","Extension","Grounds Maintenance","2025-04-01 00:00:00","42","18+12+12","£300,000 - £600,000","#VALUE!","Contract Extension","Yes ","2022-07-06 00:00:00"],
    [396,"Place","tbc","HAS","HAS","Prevention & Service Development","Built Environment","Initial Term","Extra Care Housing - future provision","2025-09-25 00:00:00","tbc","tbc","£M","#VALUE!","OJEU","key Decision","tbc"],
    [397,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Initial Term","Pensions Custodian Services (ancillary services)","2025-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","NA"],
    [398,"Professional","TBC","BES","Environment","Technology","ICT","Initial Term","Call-Off from Framework Agreement 30012. Automated Collection and Analysis of Carriageway Condition Data Services","2025-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [399,"People","TBC","CS","HR_BS","Human Resources","Education & Training","Initial Term","Approved Provider List (APL) - Training","2023-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","APL","Yes","TBC"],
    [400,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Corporate CRM (Customer Relationship Management) System ","2025-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [401,"People","TBC","CYPS","CYPS","Schools, Adult Education & Outdoor Education Services","Education & Training","Extension","Growing up in North Yorkshire - survey ","2023-04-01 00:00:00","168","120+48","TBC","#VALUE!","Contract Extension","No","N/A"],
    [402,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Initial Term","Pension Investment Independent Advisor","2025-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [403,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Fleet hire options appraisal","tbc","tbc","tbc","tbc","#VALUE!","Direct Award","N/A","n/a"],
    [404,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","EForms for Website","2025-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","NA"],
    [405,"Professional","DN536303","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","Extension","Technical and Planning Advisor for Waste (PPP) (Currently Jacobs) ","2025-05-01 00:00:00","60","36+12+12","400000","480000","Contract Extension","Decision Record","NA"],
    [406,"Professional","TBC","CS","Environment","Technology","ICT","Initial Term","MapInfo Pro Maintenance and Technical Support","2025-05-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","N/A"],
    [407,"People","TBC","CYPS","CYPS","Children and Families","Social Care","Initial Term","Young Peoples Pathway -Managed Accommodation (Pathway 2 (Foundation)","2023-10-01 00:00:00","26","14+6+6","TBC","#VALUE!","OJEU - LTR","Yes","TBC"],
    [408,"People","TBC","CYPS","CYPS","Children and Families","Social Care","Initial Term","Young Peoples Pathway - Prevention & Reconnection (Pathway 1 (Foundation)","2023-10-01 00:00:00","26","14+6+6","TBC","#VALUE!","OJEU - LTR","Yes","TBC"],
    [409,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Shared Lives","2023-11-01 00:00:00","TBC","TBC","TBC","#VALUE!","OJEU - LTR","Yes","HASLT: 19/05/2021 (Gate 1 06/2022)\nHAS EX: 10/03/2023 "],
    [410,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Extension","Insurance-Linked Securities (ILS)","2025-05-21 00:00:00","120","36+1+1+1+1+1+1+1","6140000","7368000","Contract Extension","Yes","TBC"],
    [411,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Arboricultural Services","2023-06-01 00:00:00","48","24+12+12","tbc","#VALUE!","Bid","n/a","n/a"],
    [412,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Community Equipment (Medequip)","2023-12-01 00:00:00","84","60+24","TBC","#VALUE!","OJEU","TBC","TBC"],
    [413,"People","TBC","CYPS","CYPS","Inclusion","Social Care","Initial Term","Disabled Childrens Services APL","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","OJEU - LTR","Yes ","TBC"],
    [414,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Occupational Health Case Management System\n(currently eOPAS, provided by Civica)","2025-05-24 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [415,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Anti Virus - Schools (currently Sophos)","2025-06-15 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [416,"Professional",null,"CS","HR_BS","Business Support","Clothing","Initial Term","Workwear & PPE\n(currently supplied by Thomas Owen)\n\nUniforms \n(currently supplied by Nalestar via YPO)","2025-07-19 00:00:00",null,null,"TBC",null,"TBC",null,null],
    [417,"Professional","TBC","CS","HAS","Prevention and Service Development ","Finance","Initial Term","Pre Payment Cards for Court of Protection (PMO Ref 2313)","2025-07-25 00:00:00","36","TBC","TBC",null,"Contract Extension","No","NA"],
    [418,"Professional","DN533207","BES","Environment","Technology","ICT","Initial Term","Case and Quality Management System\n(currently BlackRainbow, under contract with Avatu Ltd as a reseller)","2025-08-30 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [419,"Professional","DN479650 (Minicomp)\nDN413451 (RFI)","CS","Resources","Technology","ICT","Extension","Pension Administration System","2025-09-01 00:00:00","120","60+24+24+12","3395000","4074000","OJEU","Yes","43917"],
    [420,"People","TBC","CYPS","CYPS","Inclusion","Education & Training","Initial Term","SEN Mediation and Disagreement Resolution","2023-09-01 00:00:00","TBC","TBC","TBC","#VALUE!","Bid","Decision Record","NA"],
    [421,"Professional","TBC","BES","Environment","Technology","Passenger Transport","Initial Term","Fleet Management System\n(currently provided by AssetWorks)","2025-09-07 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [422,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Participation Support (previously called Self Advocacy)","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","Bid","TBC","TBC"],
    [423,"Place","TBC","NY H","Resources","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Street lighting","tbc","tbc","tbc","tbc",null,"tbc","n/a","n/a"],
    [424,"Place","TBC","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Waste","Initial Term","Waste receptacles\nLGR Day 1\nWaste Fleet Street and Highways (WFSH)","tbc","tbc","tbc","tbc","#VALUE!","tbc","tbc","tbc"],
    [425,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Fleet","Initial Term","Delivery of vehicles\nLGR Day 1\nWaste Fleet Street and Highways (WFSH)","tbc","tbc","tbc","tbc","#VALUE!","tbc","tbc","tbc"],
    [426,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Fleet","Initial Term","Parts supply / imprest\nLGR Day 1\nWaste Fleet Street and Highways (WFSH)","tbc","tbc","tbc","tbc","#VALUE!","Direct Award","tbc","tbc"],
    [427,"Professional","DN570992","CS","Resources","Technology","ICT","Initial Term","Direct Debit Payment System\n(currently PayGate; contract with boxxe as a re-seller)","2025-10-01 00:00:00","TBC","TBC","TBC",null,"TBC","Decision Record","N/A"],
    [428,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Highway maintenance gangs","2023-06-01 00:00:00","tbc","tbc","tbc","#VALUE!","tbc","n/a","n/a"],
    [429,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term","Background support for Extra Care provision","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","OJEU","TBC","TBC"],
    [430,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Security portfolio partner - Next Gen Firewall (Currently Palo Alto)","2025-10-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","NO","NA"],
    [431,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Supply of PPE and Workwear","tbc","tbc","tbc","tbc","#VALUE!","OJEU","n/a","n/a"],
    [432,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Structural survey of steel lamp posts","tbc","tbc","tbc","tbc","#VALUE!","TBC","n/a","n/a"],
    [433,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Extension","Weather Forecasting Contract and Weather Station Bureau Service Contract ","2023-07-05 00:00:00","24","24","tbc","#VALUE!","Further Comp - Internal (Non OJEU)","Key Decision","tbc"],
    [434,"People","TBC","CS","LDS","Democratic Services","Social Care","Initial Term","Healthwatch ","2024-03-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [435,"People","TBC","CYPS","CYPS","Children and Families","Social care","Initial Term","Unaccompanied Asylum Seeking Children's Bedspaces","2024-03-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","N/A"],
    [436,"Professional","TBC","BES","Environment","Technology","ICT","Initial Term","UTC and UTMC System\n(currently Siemens)","2025-10-27 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","N/A"],
    [437,"Professional","53588","CS","Resources","Property, Procurement and Commercial ","Horticulture & Arboriculture","Extension","Arboriculture services","2025-11-01 00:00:00","48","24+12+12","135599","162718.8","Contract Extension","No","NA"],
    [438,"Professional","34436","CS","HR_BS","Technology","ICT","Extension","HR Recruitment Main Admin System (Havas People)","2025-11-05 00:00:00","48","24+12+12","136000","163200","Contract Extension","Decision Record","NA"],
    [439,"People","TBC","CYPS","CYPS","Children and Families","Social Care","Initial Term","Provision of Foster Care Placements (IFA) ","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [440,"Professional",null,"CS","HR_BS","Human Resources","HR & Training","Initial Term","Framework Agreement for Everybody Benefits","2025-12-01 00:00:00",null,null,"TBC",null,"TBC","Yes","TBC"],
    [441,"Professional",null,"CS","Resources","Technology","ICT","Initial Term","Financial Forecasting Software\n(currently Oracle PBCS (Planning Budget Cloud Service) - contract with Insight as a re-seller)","2025-12-09 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Yes","TBC"],
    [442,"Professional","39509","CS","Resources","Technology","ICT","Initial Term","Citrix Virtual Apps and Desktop (software assurance and support)","2025-12-24 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","NA"],
    [443,"People","TBC","HAS","HAS","Adult Social Care","Social Care","Extension & Variation","Harrogate and Rural Alliance - Section 75","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","Contract Extension","Yes","2022-03-11 00:00:00"],
    [444,"Place","TBC","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Waste","Initial Term","Dry mixed recycling / transformation into 2024/25","tba","tbc","tbc","tbc","#VALUE!","tbc","tbc","TBC"],
    [445,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance/Insurance","Initial Term","Insurance Broker and Risk Management Consultancy Services","2025-12-31 00:00:00","60","36+12+12+12","130000","156000","Further Comp - External (non OJEU)","Decision Record","NA"],
    [446,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 8) Water Hygiene","2024-02-01 00:00:00","tbc","tbc","TBC","#VALUE!","Framework Establish","key Decision","tbc"],
    [447,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 4) Lifts","2024-02-01 00:00:00","tbc","tbc","TBC","#VALUE!","Framework Establish","key Decision","tbc"],
    [448,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 11) Asbestos Analysis","2024-02-01 00:00:00","tbc","tbc","TBC","#VALUE!","Framework Establish","key Decision","tbc"],
    [449,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 5) Auto Doors","2024-02-01 00:00:00","tbc","tbc","TBC","#VALUE!","Framework Establish","key Decision","tbc"],
    [450,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 6) Fixed Electrical Inspection / PAT / Stage Lighting","2024-02-01 00:00:00","tbc","tbc","TBC","#VALUE!","Framework Establish","key Decision","tbc"],
    [451,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Hard FM (Lot 10) PE and External Play","2024-02-01 00:00:00","tbc","tbc","TBC","#VALUE!","Contract Extension","key Decision","tbc"],
    [452,"Professional","DN498638","CS","Resources","Finance (inc. Pension Fund)","Finance","Extension","Actuarial Services - To provide the Pension Fund with Actuarial Service","2026-01-01 00:00:00","84","60+12+12","700000","840000","Contract Extension","Decision Record","NA"],
    [453,"Professional","TBC","CS","HR_BS","Business Support","Business Support","Initial Term","Mailroom Equipment and Associated Software Services and Consumables","2026-01-12 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [454,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","On-line Registrar, Births, Deaths and Marriages - Online Appointments System (PMO Ref: TBC)","2026-03-01 00:00:00","TBC","TBC","64000","76800","Bid","No","NA"],
    [455,"Professional","36238","CS","Resources","Technology","ICT","Extension","Kitchen Management System and Associated Hardware","2026-03-01 00:00:00","60","36+24","620000","744000","Contract Extension","Yes","2022-05-10 00:00:00"],
    [456,"Professional","53588","CS","Resources","Technology","ICT","Initial Term","Workforce Management System (Currently Injixo) (PMO Ref:3221)","2026-03-22 00:00:00","37","37","227399.5","272879.4","Direct Award","No","NA"],
    [457,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Citrix ADC Software (includes hardware, support and maintenance)\n(currently contract with Softcat as a re-seller)","2026-03-22 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","NA"],
    [458,"Professional","TBC","CS","Environment","Technology ","Trading Standards","Initial Term","Trading Standards Business System (2020 PMO Ref: 2953)\n(currently APP, provided by Civica)","2026-03-31 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [459,"People","DN494171","CS","LE","Policy, Performance, Refugee / Asylum Issues and Community Safety","Business Support","Initial Term","Interpretation Services (British Sign Language/ Non Spoken)","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [460,"People","DN510379","CS","LE","Policy, Performance, Refugee / Asylum Issues and Community Safety","Business Support","Initial Term","Interpretation Services - Written Translation Including Braille ","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [461,"People","DN510379","CS","LE","Policy, Performance, Refugee / Asylum Issues and Community Safety","Business Support","Initial Term","Interpretation Services - Face to Face and Video & Telephone Interpreting","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [462,"People","TBC","CYPS","CYPS","Schools, Adult Education & Outdoor Education Services","Social Care","Initial Term","NYCC Personalised Learning and Adult Learning - Supported Internships Approved Provider List ","2024-08-01 00:00:00","48","TBC","TBC","#VALUE!","TBC","Yes","TBC"],
    [463,"People","TBC","CYPS","CYPS","Schools, Adult Education & Outdoor Education Services","Social Care","Initial Term","NYCC Personalised Learning and Adult Learning - High Needs Study Programme Approved Provider List","2024-08-01 00:00:00","48","TBC","TBC","#VALUE!","TBC","Yes","TBC"],
    [464,"Professional","26112","CS","LDS","Technology","ICT","Extension","Legal Services Case Management System. ","2026-04-01 00:00:00","72","24+24+24","93775.3","112530.36","Contract Extension","Decision Record","NA"],
    [465,"Professional","64684","CS","Resources","Technology","ICT","Extension","LCS/ EHM MeLearning ","2026-04-01 00:00:00","48","36+12","121712.8","146055.36000000002","Contract Extension","Decision Record","NA"],
    [466,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Hardware Security Modules (currently includes hardware, support and maintenance)\n(currently provided by Thales - contract with Insight as a re-seller via IT Hardware Partner contract)","2026-04-01 00:00:00","60","60","126755.93","152107.11599999998","TBC","Decision Record","N/A"],
    [467,"People","TBC","CYPS","CYPS","Schools, Adult Education & Outdoor Education Services","Education & Training","Initial Term","Growing up in North Yorkshire - Learning and Wellbeing Surveys","2024-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","Bid","TBC","TBC"],
    [468,"Professional","68239","CS","Resources","Technology","ICT","Extension","Website Hosting - Drupal (Currently Code Enigma)","2026-04-01 00:00:00","48","36+12","132000","158400","Contract Extension","decision Record","NA"],
    [469,"People","TBC","CYPS","CYPS","Children and Families","Social Care","Initial Term","Young Peoples Pathway\nPrevention & Reconnection (Pathway 1 (Foundation)\nManaged Accommodation (Pathway 2 (Foundation)\nEmergency & Extended Supported Lodgings (Pathway 2 (SASH))","2025-01-01 00:00:00","TBC","TBC","TBC","#VALUE!","OJEU - LTR","Yes","TBC"],
    [470,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","County Hall - Alternative heating","tbc","tbc","tbc","tbc","#VALUE!","Further Comp - External (non OJEU)","Decision Record","n/a"],
    [471,"Place",null,"CS","Resources","Property, Procurement and Commercial ","Property","Variation","Alarms - Contract variation via Lot 1","2023-09-01 00:00:00","TBC","TBC","TBC","#VALUE!","Contract Variation","No","NA"],
    [472,"Professional","67809","CS","CYPS","Technology","ICT","Extension","School Data Collection and Reporting System\n(Groupcall Product - Xporter, Virtual School & Xvault)","2026-04-01 00:00:00","48","36+12","150400","180480","Contract Extension","Decision Record","Yes"],
    [473,"Place","tbc"," NY H ","Resources","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","Vehicle Restraint System Repair and Maintenance","2024-08-01 00:00:00","tbc","tbc","tbc","#VALUE!","OJEU","tbc","n/a"],
    [474,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Built Environment","Extension","Arboricultural Services","2024-06-01 00:00:00","12","12","tbc","#VALUE!","Contract Extension","n/a","n/a"],
    [475,"Professional","DN368842","CS","Resources","Technology","ICT","Extension","Library Kiosks - 2088 Public Use of IT Provision","2026-04-01 00:00:00","120","84+24+12","915000","1098000","Contract Extension","Yes","TBC"],
    [476,"Professional","TBC","BES","Environment","Technology","ICT","Initial Term","Framework Agreement Automated Collection and Analysis of Carriageway Condition Data Services","2026-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [477,"Professional","TBC","TBC","LDS","Technology","ICT","Initial Term","Elections Management System","2026-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","N/A"],
    [478,"People","TBC","HAS","HAS","Prevention & Service Development","Social Care","Initial Term ","Supported Living - immediate needs","2025-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Yes ","HASLT: 16/06/2022"],
    [479,"Professional","TBC","CS","Environment","Highways, Transportation, Parking Services, Parks and Grounds ","Horticulture & Arboriculture","Initial Term","Grounds Maintenance","2026-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC",null],
    [480,"Professional","TBC","CS","Environment","Technology","ICT","Initial Term","Complex Contract Management System\n(currently provided by Affinitext)","2026-04-20 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [481,"Professional","TBC","BES","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","Initial Term","Technical and Planning Advisor for Waste (PPP) (Currently Jacobs) ","2026-05-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","NA"],
    [482,"Professional","TBC","CS","HR_BS","Human Resources","HR & Training","Initial Term","Shared Cost Additional Voluntary Contribution Schemes (SCAVC’s) (Everybody Benefits - Salary Sacrifice add on)","2026-05-03 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [483,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Extension","Insurance-Linked Securities (ILS)","2026-05-21 00:00:00","120","36+1+1+1+1+1+1+1","6140000","7368000","Contract Extension","Yes","TBC"],
    [484,"Professional","TBC","CS","Resources","Technology","ICT","Extension","Procurement Management Software (Currently YORtender/Proactis)","2026-06-01 00:00:00","84","36+24+24","1463000","1755600","Contract Extension","No","NA"],
    [485,"Professional","TBC","CS","HR_BS","Human Resources","HR & Training","Initial Term","Apprenticeship - End Point Assessment [EPA]","2026-08-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","NA"],
    [486,"Professional","TBC","CS","HR_BS","Technology","ICT","Initial Term","Recruitment Admin System (DBS Functionality)","2026-08-24 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [487,"Professional",null,"HAS","HAS","Technology","ICT","Initial Term","Client money and case management system for Court of Protection Team (CASPAR)","2026-10-01 00:00:00",null,null,"50000","60000","TBC","Decision Record","NA"],
    [488,"Professional","DN560044 / 26113","CS","Resources","Finance (inc. Pension Fund)","Consultancy","Extension","Pensions Fund Investment Consultant ","2026-10-01 00:00:00","84","60+24","650000","780000","Contract Extension","Decision Record","N/A"],
    [489,"Professional",null,"CS","Resources","Property, Procurement and Commercial ","Horticulture & Arboriculture","Initial Term","Arboriculture services","2026-11-01 00:00:00","48","24+12+12","135599","162718.8","TBC","No","NA"],
    [490,"Professional","36463","CS","HR_BS","Human Resources","HR & Training","Initial Term","Agency Services ","2026-11-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Yes","2022-05-30 00:00:00"],
    [491,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Initial Term","Public Health GP Provider List ","2025-04-01 00:00:00","60","60","TBC","#VALUE!","OJEU - LTR","Yes ","TBC"],
    [492,"People","TBC","HAS","HAS","Director of Public Health","Public Health","Initial Term","Public Health Pharmacy Provider List ","2025-04-01 00:00:00","60","60","TBC","#VALUE!","OJEU - LTR","Yes ","TBC"],
    [493,"Professional","TBC","CS","HR_BS","Technology","ICT","Initial Term","HR Recruitment Main Admin System","2026-11-05 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","NA"],
    [494,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 10) PE and External Play","2024-12-31 00:00:00","tbc","tbc","TBC","#VALUE!","Framework Establish","key Decision","tbc"],
    [495,"Professional",null,"CS","Resources","Property, Procurement and Commercial ","Catering","Initial Term","Fresh Fruit, Vegetables and Milk Products\n(currently supplied by Stuarts / Paynes)","2026-11-09 00:00:00",null,null,"TBC",null,"TBC","Yes","TBC"],
    [496,"Professional","DN388786","CS","Resources","Technology","ICT","Extension","Service Management System\n(currently Ivanti Service Manager, provided under contract with Ultima)","2026-11-11 00:00:00","120","60 + 24 + 24 + 12","595883.89","715060.6680000001","Contract Extension","Yes","TBC"],
    [497,"Professional","DN498638","CS","Resources","Finance (inc. Pension Fund)","Finance","Extension","Actuarial Services - To provide the Pension Fund with Actuarial Service","2027-01-01 00:00:00","84","60+12+12","700000","840000","Contract Extension","Decision Record","NA"],
    [498,"Professional","TBC","CS","CD","Strategy and Performance","ICT","Initial Term","CFO Insights - Data Analysis Tool","2027-03-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [499,"Professional","DN218887","CS","Resources","Technology","ICT","Extension","Insurance System\n(currently EvoClaim, provided by DWF 360)","2027-03-08 00:00:00","96","24+24+24+24+24+24","177098","212517.6","Contract Extension","Decision Record","NA"],
    [500,"Professional","60471","CS","HAS","Technology","ICT","Extension","Adult and Children’s Social Care System & Finance System\nProject Kairos (2020 PMO Ref: 1940)","2027-04-01 00:00:00","84","60+24","1414000","1696800","Contract Extension","Yes","2021-05-10 00:00:00"],
    [501,"Professional","TBC","CS","CYPS","Technology","ICT","Extension","Education Case Management System (Servelec)\nProject Kairos (2020 PMO Ref: 1940)","2027-05-01 00:00:00","84","60+24","410331","492397.2","Direct Award","Yes","2021-05-10 00:00:00"],
    [502,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Utilities","Initial Term","Purchase of Gas\nUtilities Broker (Gas)","2025-04-01 00:00:00","tbc","tbc","tbc","#VALUE!","tbc","key Decision","tbc"],
    [503,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Finance","Initial Term","Insurance-Linked Securities (ILS)","2027-05-21 00:00:00","TBC","TBC","6140000","7368000","TBC","Yes","TBC"],
    [504,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Supply and Maintenance of SAN Virtual Tape Library","2027-09-01 00:00:00","TBC","TBC","TBC",null,"OJEU","TBC","TBC"],
    [505,"Professional","DN479650 (Minicomp)\nDN413451 (RFI)","CS","Resources","Technology","ICT","Extension","Pension Administration System","2027-09-01 00:00:00","120","60+24+24+12","3395000","4074000","OJEU","Yes","2020-03-27 00:00:00"],
    [506,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 7) - Chimneys, Lighting Conductors ","2025-09-01 00:00:00","tbc","tbc","tbc","#VALUE!","OJEU","Key Decision","tbc"],
    [507,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 9) - Fire Equipment ","2025-09-01 00:00:00","tbc","tbc","tbc","#VALUE!","OJEU","Key Decision","tbc"],
    [508,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 12) - Asbestos Abatement ","2025-09-01 00:00:00","tbc","tbc","tbc","#VALUE!","OJEU","Key Decision","tbc"],
    [509,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Kitchen Management System and Associated Hardware","2028-03-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [510,"Professional","DN368842","CS","Resources","Technology","ICT","Extension","Library Kiosks - 2088 Public Use of IT Provision","2028-04-01 00:00:00","120","84+24+12","915000","1098000","Contract Extension","Yes","TBC"],
    [511,"Place","tbc","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Engineering & Environment","Initial Term","Weather Forecasting Contract and Weather Station Bureau Service Contract ","2025-07-05 00:00:00","tbc","tbc","tbc","#VALUE!","Further Comp - Internal (Non OJEU)","Key Decision","tbc"],
    [512,"Professional","60471","CS","HAS","Technology","ICT","Extension","Trailblazer modules -  contract variation to Liquid Logic (HAS Funded)","2028-04-01 00:00:00","84","60+24","1815729","2178874.8","Contract Variation","Yes\n(Decision Record also completed for LLA variation)","13/05/2021\n(17/03/23)"],
    [513,"Professional","TBC","CS","LDS","Technology","ICT","Initial Term","Legal Services Case Management System. ","2028-04-01 00:00:00","72","24+24+24","TBC","#VALUE!","TBC","Decision Record","NA"],
    [514,"People","TBC","CS","CD","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Subscriptions","Initial Term","Subscription to CollectionHQ","2025-06-16 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [515,"Professional","TBC","CS","Resources","Finance (inc. Pension Fund)","Consultancy","Initial Term","Pensions Fund Investment Consultant ","2028-10-08 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","Decision Record","N/A"],
    [516,"Professional","DN388786","CS","Resources","Technology","ICT","Extension","Service Management System\n(currently Ivanti Service Manager, provided under contract with Ultima)","2028-11-11 00:00:00","120","60 + 24 + 24 + 12","595883.89","715060.6680000001","Contract Extension","Yes","TBC"],
    [517,"Place","tbc","CS","Resources","Property, Procurement and Commercial ","Built Environment","Initial Term","Hard FM (Lot 1) - Responsive Maintenance with Lot 3 - Alarms ","2026-02-01 00:00:00","tbc","tbc","tbc","#VALUE!","OJEU","Key Decision","tbc"],
    [518,"Professional",null,"CS","Resources","Finance (inc. Pension Fund)","Consultancy","Initial Term","Commercial Real Estate (Property) Debt","2029-03-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","No","NA"],
    [519,"Professional","TBC","CS","HAS","Technology","ICT","Initial Term","Adult and Children’s Social Care System & Finance System\nProject Kairos (2020 PMO Ref: 1940)","2029-04-01 00:00:00","TBC","TBC","1414000","1696800","TBC","Yes","TBC"],
    [520,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Library Kiosks - 2088 Public Use of IT Provision","2029-04-01 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [521,"Professional","DN479650 (Minicomp)\nDN413451 (RFI)","CS","Resources","Technology","ICT","Extension","Pension Administration System","2029-09-01 00:00:00","120","60+24+24+12","3395000","4074000","OJEU","Yes","2020-03-27 00:00:00"],
    [522,"Professional","TBC","CS","Resources","Technology","ICT","Initial Term","Service Management System\n(currently Ivanti Service Manager, provided under contract with Ultima)","2029-11-11 00:00:00","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [523,"Professional",null,"CS","Resources","Technology","ICT","Initial Term","Pension Administration System","2030-09-01 00:00:00","TBC","TBC","3395000","4074000","TBC","Yes","2020-03-27 00:00:00"],
    [524,"Professional","DN546084","CS","HR_BS","Human Resources","Training","Extension","Social Worker Degree Apprenticeship","01/30/2025","60","36+12+12","230000","276000","Contract Extension","No","NA"],
    [525,"People","TBC","CYPS","CYPS","Inclusion","Social Care","Initial Term","Assessments and provision of independent speech and language therapists, occupational therapists and physiotherapists ","TBC","TBC","TBC","TBC","#VALUE!","TBC","TBC","TBC"],
    [526,"People","TBC","HAS","CD","Housing","Consultancy","Initial Term","Strategic Analysis Assessment for Housing ","TBC","TBC","TBC","TBC","#VALUE!","Bid","No","N/A"],
    [527,"Professional","DN514894","CS","Resources","Technology","ICT","Variation","Financial Forecasting Software\n(currently Oracle PBCS (Planning Budget Cloud Service) - contract with Insight as a re-seller)",null,null,null,"TBC",null,null,null,null],
    [528,"Place","tbc","NY H","Resources","Property, Procurement and Commercial ","Engineering & Environment","Initial Term","General Building Materials supply","tbc","tbc","tbc","tbc","#VALUE!","Direct Award","N/A","n/a"],
    [529,"Place","TBC","BES","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Waste","Initial Term","Redesign and construction of HWRC Stonefall, Wetherby Road A661, Harrogate","tbc","tbc","tbc","TBC","#VALUE!","tbc","Key Decision","tbc"]
]}