{
  "fields": [{"id":"_id","type":"int"},{"id":"Yortender  Ref","type":"text"},{"id":"Directorate","type":"text"},{"id":"Service Area","type":"text"},{"id":"Spend Category","type":"text"},{"id":"Contract Title","type":"text"},{"id":"Contract  Start Date","type":"text"},{"id":"Contract  Term  (months)","type":"text"},{"id":"Breakdown (months)","type":"text"},{"id":"Estimated Whole Life Cost (excl. VAT)","type":"text"},{"id":"Estimated Whole Life Cost including  extensions  (inc VAT)","type":"text"},{"id":"Annual Cost  (ex VAT)","type":"text"},{"id":"Procurement Method","type":"text"},{"id":"Key Decision?","type":"text"},{"id":"PCMS Operational Risk Rating","type":"text"}],
  "records": [
    [1,"100108158","NYH","NYH","Utilities","599-NYH-OO NYH - Highway Electrical Installations including ICP","2026-06-01 00:00:00","48","24 +12 +12","1100000","1320000","275000","Further Comp Above Threshold","No","Green"],
    [2,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","New Quay Rd Viaduct (Whitby) Painting columns and handrails","2027-01-01 00:00:00","1","1","200000","240000","200000","Bid","Decision Record",null],
    [3,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Jack Beck Bridge Strengthening, Clapham","2027-10-01 00:00:00",null,null,"80000","96000",null,"Bid","TBC",null],
    [4,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Selby Swing Bridge Redecking",null,null,null,"1000000","1000000",null,"Further Comp Below Threshold","TBC","Green"],
    [5,null,"NYH","NYH","ICT","Contract Event Management and Reporting system","2027-04-01 00:00:00","48",null,"140000","168000","35000","Further Comp Below Threshold","No","Green"],
    [6,null,"CS Resources","Property, Procurement and Commercial","Catering","110-NYC-RS Innovative Catering","2027-02-01 00:00:00","24","12+12","131248.44","157598.13","65624.22","Contract Extension","TBC","Green"],
    [7,"tbc","NYH","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","657-NYH-EN Vehicle Restraint System Repair","2026-09-01 00:00:00","48","24 + 12 + 12","3600000","4320000","900000","Further Comp Above Threshold","TBC","Green"],
    [8,"91164","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","66-NYC-EN-EV Electric Vehicle (EV) Charge point installation (Local Electric Vehicle Infrastructure (LEVI) funding) Charge Point Operator (PMO: 4024)","2025-10-01 00:00:00","192","180+12","26000000","26000000",null,"Above Threshold","Yes",null],
    [9,"TBC","CS Resources","Technology","ICT","Clinical Service Platform for Community Pharmacies","2026-06-01 00:00:00","36","24+12","61575","73890","20525","Contract Extension","Decision Record","Green"],
    [10,"85682","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","442-NYC-CY Independent Investigating Officers, Panellists and Chairs","2027-09-01 00:00:00","60","36+24","88717","106500","17500","Contract Extension","Decision Record","Green"],
    [11,"67654","CS Resources","Finance (inc. Pension Fund)","Financial Services","465-NYC-RS Cash Collection","2027-02-01 00:00:00","24","12+ 12","180000","200000","100000","Contract Termination","Decision Record","Green"],
    [12,"79644","CYPS","Children and Families","HR","430-NYC-LE Interpretation Services and Translation Services: Spoken and Unspoken","2027-04-01 00:00:00","60","36 + 12 + 12","845000","1014000","169000","Contract Extension","Yes","Green"],
    [13,"89161","CS Resources","Customer, Revenues and Benefits","Social & Community Care Supplies & Services - Adults","312-NYC-HA Welfare Rights Information and Guidance Service","2027-04-01 00:00:00","72","2+1+1","428400","428400","107100","Contract Extension","No","Green"],
    [14,"90414","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","309-NYC-CY Disabled Childrens Services APL","2024-11-01 00:00:00","84","36 + 24 + 24","8166133","8166133","1166590","Contract Variation","Yes","Green"],
    [15,"60359","Community Development","Planning","Consultancy","Sustainability Appraisal","2026-04-01 00:00:00","48","24 +12 +12","26000","31200","6500","Contract Extension","No","Green"],
    [16,"93189","CS Resources","Technology","ICT","112-NYC-RS Waste Management Software Licenses and In Cab Technology","2026-06-12 00:00:00","48","48","429990","515988","49560","Direct Award","Yes","Amber"],
    [17,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","ICT","113-NYC-RS Garden Waste Licences","2027-12-01 00:00:00","36","24+12","536250","643500","178750","Contract Extension","TBC","Green"],
    [18,"TBC","CS Resources","Technology","ICT","582-NYC-RS Pendulum & Broadcast & Watchsted Inspector Modules","2026-11-01 00:00:00",null,"TBC",null,null,"16197","Direct Award","Decision Record","Green"],
    [19,"TBC","CS Resources","Technology","ICT","543-NYC-RS Electronic Document and Records Management System Support","2026-09-01 00:00:00",null,null,null,null,"33747.73","Best Value","Decision Record","Green"],
    [20,"87738","CS Resources","Finance (inc. Pension Fund)","Financial Services","Contract for Pensions Tracing and Mortality Services","2028-07-01 00:00:00","72","48+24","148725.6","178470.72","24787","Contract Extension","Decision Record","Green"],
    [21,null,"CS Resources","Technology","ICT","Library Management System","2028-04-01 00:00:00","84","43+24+24","276374","331648.8","39482","Contract Extension","No","Green"],
    [22,"85087","CS Resources","Customer, Revenues and Benefits","ICT","Replacement Analogue Lines","2027-03-18 00:00:00","48","36+12","1294062","1552874","323515","Contract Extension","Yes",null],
    [23,"85361","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Vehicle Management","792-NYC-EN Fuel Cards","2027-03-23 00:00:00","48","24+12+11","3846553","4615864","961638","Contract Extension","Yes","Green"],
    [24,null,"CS Resources","Technology","ICT","E-Brokerage and Organisation Recharging Module","2027-04-01 00:00:00","58","34+24","396248","475497.6","85000","Contract Extension","Decision Record","Green"],
    [25,null,"CS Resources","Technology","ICT","118-NYC-RS Secure File Transfer System for Early Year Provider Data","2027-05-11 00:00:00","48","36 + 12","104000","124800","26000","Contract Extension","No","Green"],
    [26,null,"NYH","NYH","HR","119-NYH-OO Substance Misuse Testing","2027-04-01 00:00:00","48","12+12+12+12","100000","120000","25000","Contract Extension","Decision Record","Green"],
    [27,null,"CS Resources","Technology","ICT","Oracle E-Business Suite - Third Party Support and Maintenance (New Contract)","2026-10-04 00:00:00","36","24+12","369113","442935.6","111141.45","Contract Extension","No","Green"],
    [28,null,"CS Resources","Technology","ICT","793-NYC-RS Back Office System for English National Concessionary Travel Scheme","2027-10-07 00:00:00","48","36+12","600000","720000","120000","Contract Extension","No","Green"],
    [29,null,"NYNET","NYNET","ICT","WAN Equipment and Support Services","2029-10-01 00:00:00",null,null,"5600000","6720000","1120000","Further Comp Above Threshold","TBC","Green"],
    [30,"TBC","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Public Transport","120-NYC-EN Mainstream, SEN, and Local Bus Services Transport","2026-10-01 00:00:00","96",null,"900000000","1080000000","62000000","Open Framework Establish","Yes","Red"],
    [31,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Property Level Resilience Scheme","2027-01-01 00:00:00","48","36+12","1500000","1800000","375000","Framework Establish","Yes",null],
    [32,null,"CS Resources","Technology","ICT","Web-mapping and cloud computing for traffic engineering and highway management","2028-04-01 00:00:00","48","48","52490","62988","13123","Further Comp Below Threshold","Decision Record",null],
    [33,"TBC","CS HR and business support","Business Support","Catering","741-NYC-CE Water Coolers and Associated goods","2026-12-04 00:00:00","48","24+24","12000","24000","6000","Best Value","TBC","Green"],
    [34,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","122-NYC-EN Flooding Consultancy","2027-11-19 00:00:00","36","36","331495.04","397794","107511.9","Further Comp Above Threshold","TBC","Green"],
    [35,"102157","CS Resources","Technology","ICT","193-NYC-EN Parking Notices","2028-11-17 00:00:00","36","36+12+12","500000","600000","100000","Contract Extension","TBC","Green"],
    [36,"0004029","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","427-NYC-RS Portable Appliance Testing (PAT)","2028-02-01 00:00:00","72","24+24+24","665970","799164","110995","Contract Extension","Key Decision","Green"],
    [37,null,"Community Development","Planning","Consultancy","Habitats Regulations Appraisal","2029-04-01 00:00:00","48","48","150000","180000","150000","Further Comp Below Threshold","Decision Record","Green"],
    [38,null,"CS Resources","Technology","ICT","Multifunctional devices including print management services and software, desktop printers, print room equipment and duplicators","2029-10-11 00:00:00","60",null,"1250000","1500000","250000","Further Comp Above Threshold","Yes","Green"],
    [39,"TBC","CS Resources","Technology","ICT","794-NYC_EN UTC and UTMC System","2027-10-01 00:00:00","48","48","83191","99829","33690","Further Comp Below Threshold","TBC","Green"],
    [40,null,"HAS","Director of Public Health","Healthcare","Infection Control and Prevention","2027-07-01 00:00:00","24","12 + 12","2028312","2028312","185000","Section 75 or 76","Yes","Green"],
    [41,"TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","576-NYC-HA Supported Housing - Living Independently For Everyone (LIFE)","2026-10-01 00:00:00","84","36+24+24","16675415.15","20010498.18","1443268.54","Above Threshold LTR","Yes","Amber"],
    [42,null,"CS HR and business support","Human Resources","HR","647-NYC-CE Agency Services","2026-11-01 00:00:00","48","24+24","24000000","28800000","6000000","Direct Award","Yes","Green"],
    [43,"56817","HAS","Director of Public Health","Healthcare","326-NYC-HA Sexual Health","2030-04-01 00:00:00","120","48+48+24","30480540","30480540","3048054","Contract Extension","Yes","Green"],
    [44,null,"CS HR and business support","Business Support","Furniture & Soft Furnishings","125-NYC-CX Supply of Office Furniture","2027-04-01 00:00:00","48","24+12+12","428000","513600","142667","Contract Extension","Yes","Green"],
    [45,"54186","CS Resources","Technology","ICT","374-NYC-RS Survey Software","2026-10-01 00:00:00","36","12+12+12","37044","44453","12348","Contract Extension","No","Green"],
    [46,"23894 / DN366165","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","437-NYC-HA Dementia Support and Advice Services","2027-04-01 00:00:00","120","48+24+24+24","2750838","3301005","275084","Contract Extension","Yes","Green"],
    [47,"73017","Community Development","Housing","Works - Construction, Repair & Maintenance","010-NYC-CD Solar Panel Annual Servicing and Maintenance","2027-03-31 00:00:00","48","24 + 12 + 12","1280000","1536000","320000","Contract Extension","Yes","Green"],
    [48,null,"NYH","NYH","Vehicle Management","126-NYH-OO Supply of Vehicle Logos and Chapter 8","2027-05-01 00:00:00","48","24+12+12",null,null,null,"Contract Extension","No","Green"],
    [49,"69100","Community Development","Housing","Works - Construction, Repair & Maintenance","Contract 1 - Gas Service and Maintenance  - Appliance/Domestic Heating Servicing, Repairs and Maintenance","2027-01-29 00:00:00","48","24+24","19200000","24000000","4800000","Contract Extension","No","Amber"],
    [50,"TBC","CYPS","Education & Skills","Domestic Goods","298-NYC-CY Musical Instruments","2025-04-01 00:00:00","24","24","311099","373319","155549","Direct Award","Yes","Green"],
    [51,"TBC (22283)","CS Resources","Customer, Revenues and Benefits","Social & Community Supplies & Services","339-NYC-LE Administering the North Yorkshire Local Assistance Fund","2027-04-01 00:00:00","60","36+24","450000","540000","98000","Contract Extension","Yes","Green"],
    [52,null,"CS Resources","Technology","ICT","795-NYC-RS Digital Care Records & E Scheduling","2027-07-01 00:00:00","60","36+24","648500","778200","129700","Above Threshold","No","Green"],
    [53,"90556","HAS","Director of Public Health","Healthcare","Primary Care Services - Pharmacies","2028-04-01 00:00:00","84","36+24+24","1536250","1843500","307250","Provider Selection Regime","Yes","Green"],
    [54,null,"HAS","Director of Public Health","Healthcare","Primary Care Services - GPs","2028-04-01 00:00:00","84","36+24+24","7247000","8696400","1449400","Provider Selection Regime","Yes","Green"],
    [55,"TBC","CS Local Engagement","Policy, Performance, Refugee / Asylum Issues and Community Safety","Social & Community Care Supplies & Services - Adults","441-NYC-LE Domestic Abuse Services in North Yorkshire and City of York","2028-04-01 00:00:00","96","48+24+24","7464000","8956800","933000","Contract Extension","Yes","Green"],
    [56,null,"CS HR and business support","Human Resources","HR","Employee Benefits and Salary Sacrifice Schemes","2030-01-01 00:00:00","48","48","100000000","120000000","25000000","Framework Establish","Yes","Green"],
    [57,"99342","CS Resources","Finance (inc. Pension Fund)","Financial Services","129-NYC-RS Debt Tracing and Debt Recovery Services","2026-09-30 00:00:00","60","36+12+12","75000","90000","15000","Bid","Decision Record","Green"],
    [58,null,"CS Resources","Technology","ICT","796-NYC-RS Leisure Management Software as a Service (SAAS) for Harrogate","2027-01-12 00:00:00","24","18+6","186000","223000","93000","Contract Extension","Decision Record","Green"],
    [59,"71964","CS HR and business support","Human Resources","HR","130-NYC-CX Employee Assistance Programme","2029-04-01 00:00:00","60","36+12+12","332500","399000","66500","Contract Extension","TBC","Green"],
    [60,"100109344","CS Resources","Technology","ICT","195-NYC-RS Surveillance Devices including CCTV","2027-10-01 00:00:00","72","48+24","600000","720000","80000","Further Comp Above Threshold","Yes","Amber"],
    [61,null,"CS Resources","Technology","ICT","Telephony - Single Phone Number IVR Phase 2","2031-04-01 00:00:00","60","36+12+12","948773.75","1138528.5","189755","Direct Award","Key Decision","Green"],
    [62,"96045","Community Development","Economic Development, Regeneration, Tourism and Skills","Works - Construction, Repair & Maintenance","012-NYC-CD Levelling Up Fund (LUF) Catterick Garrison - building occupier Expiry tbc","2027-03-08 00:00:00","120","60+60","1643960","1961953.2","164960","Above Threshold","Yes","Green"],
    [63,"80223","CS Legal and Democratic Services","Democratic Services","Social & Community Care Supplies & Services - Adults","433-NYC-LD Healthwatch Services in North Yorkshire","2027-03-01 00:00:00","84","36+24+24","1260000","1512000","180000","Contract Extension","Yes","Green"],
    [64,"78953","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","338-NYC-CY Independent Adoption Support Service (on behalf of Consortium of Regional Adoption Agencies)","2027-04-01 00:00:00","60","36+12+12","2295000","2700000","459000","Contract Extension","Yes","Green"],
    [65,"83891","CS HR and business support","Human Resources","HR","435-NYC-CX Approved Provider List (APL) - Training","2027-02-01 00:00:00","60","36+12+12","48000000","57600000","9600000","Contract Extension","Yes","Green"],
    [66,"101568","Community Development","Housing","Social & Community Supplies & Services","285-NYC-CD Young Peoples Pathway - Managed Accommodation Pathway 2","2029-02-01 00:00:00","60","36 + 12 + 12","6845541.35","6845541.35","1369108.27","Contract Extension","Yes","Amber"],
    [67,"TBC","CS Legal and Democratic Services","Legal","Legal Services","624-NYC-LD Legal reference material","2027-04-01 00:00:00",null,"TBC",null,null,"84000","Direct Award","Decision Record","Green"],
    [68,"58204","CS Resources","Technology","ICT","Youth Justice Case Management and Reporting System (PMO: 3998)","2027-03-26 00:00:00","48","36+12","133000","159600","33250","Contract Extension","Decision Record",null],
    [69,null,"CS Resources","Technology","ICT","Enterprise Data Architecture Solution","2027-01-30 00:00:00","12","12","150000","180000","150000","Further Comp Below Threshold","Decision Record","Green"],
    [70,"58301","CS Resources","Technology","ICT","Revenues & Benefits System","2029-04-01 00:00:00","84","36+24+24","4101757","4922108","585965","Contract Extension","TBC",null],
    [71,null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","703-NYC-RS Internal Audit, Counter Fraud, Information Governance and Data Protection Officer Services","2027-04-01 00:00:00","120","120","17000000","20400000","1700000","Direct Award","Yes","Green"],
    [72,"72692","CS Resources","Technology","ICT","134-NYC-RS Customer Engagement and Relationship Platform","2030-10-08 00:00:00","120","60+36+24","7500000","9000000","450000","Contract Extension","TBC","Green"],
    [73,"68009","CS Resources","Technology","ICT","611-NYC-RS Housing Management System","2027-08-01 00:00:00","70","60+10","377062.7","452475.24","61187.54","Contract Extension","Decision Record","Green"],
    [74,null,"CS Resources","Technology","ICT","The Provision of Vehicle Telematics and Portal System","2027-11-01 00:00:00","60","36+24","600000","720000","100000","Contract Extension","No","Green"],
    [75,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","768-NYC-EN- Flooding response works (debris removal)",null,null,null,"60000","72000",null,"Further Comp Below Threshold","TBC","Green"],
    [76,null,"CS Resources","Technology","ICT","Bus Service Registration, Publicity and NaPTAN Data System (PMO Ref: 3023 'Open Bus Data')","2027-04-01 00:00:00","63","39+24","157249","188699","29952","Contract Extension","Decision Record","Green"],
    [77,null,"CS Resources","Technology","ICT","Provision of software for Electronic Ticket Machines for Buses – portal fees","2027-04-01 00:00:00","48","12+12+12+12","72000","86400","18000","Further Comp Below Threshold","TBC","Green"],
    [78,"N/A","CS Resources","Technology","ICT","286-NYC-RS Door and Security Access System","2026-08-01 00:00:00","96","48+24+24","1120000","1334000","140000","Above Threshold","Decision Record","Amber"],
    [79,"87525","NYH","NYH","Vehicle Management","499-NYH-OO Fuel Cards for North Yorkshire Highways","2027-05-01 00:00:00","46","24+12+10","104000","110000","27130","Contract Extension","No","Green"],
    [80,null,"HAS","Prevention and Service Development","ICT","Care Cubed - Cost of Care Calculator System","2027-11-01 00:00:00",null,null,null,null,"26000","Best Value","No","Green"],
    [81,null,"CS Local Engagement","Communications","HR","Multidisciplinary Media Services","2027-04-01 00:00:00","36","24+12","150000","180000","50000","Contract Extension","Decision Record","Green"],
    [82,null,"Community Development","Economic Development, Regeneration, Tourism and Skills","ICT","Destination Management Solution, Including Ongoing Hosting, Support, and Maintenance","2028-11-11 00:00:00","72","48+12+12","250000","300000","25000","Above Threshold","Decision Record","Green"],
    [83,null,"CS Resources","Technology","ICT","Replacement of Idox Systems","2029-11-01 00:00:00","60","60","1250000","1500000","250000","Further Comp Above Threshold","TBC","Green"],
    [84,"67857, 67858, 67859, 67861","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","NYH/NYC Gritter Lease Extension - Lease Ref: AA4Z000593","2026-12-15 00:00:00","120","84+12+12+12","2082364.59","2498839.51","701.13","Contract Extension","No","Green"],
    [85,"94371","NYH","NYH","Street & Traffic Management","Rural grass cutting services- NYH - Lot 1","2027-05-01 00:00:00","48","24+12+12","1560000","1872000","390000","Contract Extension","No","Green"],
    [86,"DN546293","CYPS","Inclusion","Social & Community Care Supplies & Services - Children","355-NYC-CY The Provision of Radio Aids, Associated Equipment and Maintenance","2026-08-01 00:00:00","108","36+24+24+24","280000","280000","38000","Contract Extension","No","Green"],
    [87,"102163","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","527-NYC-ES Parking Machine Replacement Programme","2026-03-12 00:00:00","36",null,"3250900","3901080",null,"Further Comp Above Threshold","Yes","Green"],
    [88,"65257","CS Resources","Finance (inc. Pension Fund)","Financial Services","797-NYC-RS The Provision of Printed Cheques","2026-11-25 00:00:00","84","36 + 12 + 12 + 12 + 12","65000","78000","9286","Contract Extension","Decision Record","Green"],
    [89,"N/A","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","574-NYC-RS Responsive Maintenance","2031-02-01 00:00:00","120","60+60","80000000","96000000","8000000","Contract Extension","Key Decision","Green"],
    [90,"TBC","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","140-NYC-RS Washroom Services","2026-07-01 00:00:00","48","36+12","746105","895326","185000","Direct Award","Yes","Green"],
    [91,"TBC","CS Resources","Property, Procurement and Commercial","Catering","Vending Machines","2026-08-01 00:00:00","48","36+12","32000","38400","8000","Contract Extension","No","Green"],
    [92,"TBC","CS Resources","Technology","ICT","568-NYC-EN Complex Contract Management System","2026-04-20 00:00:00","48","24+12+12","26250","31500","8750","Best Value","No","Green"],
    [93,"56453","CS Resources","Technology","ICT","798-NYC-RS Accounts Payable Audit Solution","2026-11-28 00:00:00","24","24","41500","49800","20750","Contract Extension","No","Green"],
    [94,"66900","CS HR and business support","Business Support","Facilities & Management Services","141-NYC-CX Annual Bill Printing","2027-01-13 00:00:00","72","24+24+24","360000","432000","60000","Contract Extension","Decision Record","Amber"],
    [95,null,"CS Resources","Technology","ICT","Occupational Health Case Management System","2028-05-23 00:00:00","48","36+12","84212.14","101054.57","21053.04","Contract Extension","TBC","Green"],
    [96,"100107874","HAS","Director of Public Health","Healthcare","603-NYC-HA Vouchers for the supply of e-cigarettes and associated products","2026-09-01 00:00:00","36","19+12","340833.33","409000","131935.48","Open Procedure","Yes","Green"],
    [97,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Cover Head Bridge, East Witton Strengthening","2027-09-01 00:00:00",null,null,"85000","102000",null,"Bid","TBC",null],
    [98,"TBC","CS Resources","Technology","ICT","Coroners Case Management System","2027-11-25 00:00:00","48",null,"87536","105043","21884","Further Comp Below Threshold","TBC",null],
    [99,"100107399","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","453-NYC-CY Independent Visitors","2028-05-01 00:00:00","24","24 + 24 + 12","83333.33","100000","16666.67","Contract Extension","Key Decision","Green"],
    [100,"100107036","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","683-NYC-EN-Bridge Repairs - Scott Beck, Hole House and Kirk Gill","2026-03-16 00:00:00","3","3","100000","120000","100000","Further Comp Below Threshold","Decision Record","Green"],
    [101,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","Facilities & Management Services","314-NYC-EN Seasonal Vegetation Cutting Programme","2029-04-01 00:00:00","48","48","300000","360000","75000","Framework Establish","Yes","Green"],
    [102,null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","Consultancy Services (Treasury Management)","2028-04-01 00:00:00","60","36+24","109665","131598","21933","Further Comp Below Threshold","No","Green"],
    [103,"TBC","CS Resources","Finance (inc. Pension Fund)","Financial Services","Treasury Management Investment Consultancy Services  (NYCC, Selby & Ryedale)","2028-04-01 00:00:00","60","36+24","109665","131598","21933","Further Comp Below Threshold","Decision Record",null],
    [104,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Runley - Strengthening","2027-08-01 00:00:00",null,null,"120000","144000","120000","Further Comp Below Threshold","Decision Record",null],
    [105,null,"CS Resources","Technology","ICT","Budget planning tool for schools","2028-05-01 00:00:00","48","36+12","100000","120000","25000","Contract Extension","Decision Record",null],
    [106,null,"CS Resources","Technology","ICT","LCS/ EHM MeLearning","2027-04-01 00:00:00","48","36+12","121713","146055","30428","Further Comp Below Threshold","TBC",null],
    [107,null,"CS Resources","Property, Procurement and Commercial","ICT","Harrogate District CCTV Network Maintenance, Servicing and Additional Works","2027-10-01 00:00:00","36","24+12","123280","147936","41093","Contract Extension","No","Green"],
    [108,"DN199463 (CONTRACT-A9VJ-T406WA)","Community Development","Economic Development, Regeneration, Tourism and Skills","Catering","Provision of Fish Market Services","2026-11-01 00:00:00","84","60+24","125000","150000","25000","Contract Extension","No","Green"],
    [109,"TBC","Community Development","Economic Development, Regeneration, Tourism and Skills","Catering","Provision of Fish Market Services","2028-11-01 00:00:00",null,null,"125000","150000",null,"Open Procedure","TBC",null],
    [110,null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","Insurance Broker and Risk Management Consultancy Services","2030-07-01 00:00:00","42","42","99336","99336","99336","Direct Award","TBC",null],
    [111,null,"CS Resources","Technology","ICT","Drupal Website Hosting","2027-04-01 00:00:00","48","36+12","132000","158400","33000","Further Comp Below Threshold","Decision Record","Green"],
    [112,null,"CS Resources","Technology","ICT","VMWare Licencing for Storage Area and Compute Hardware","2029-11-01 00:00:00","60","60","515164.64","618197.57","103032.93","Further Comp Above Threshold","Yes","Green"],
    [113,"100108096","CS Resources","Property, Procurement and Commercial","Environmental Services","556-NYC-RS Arboriculture Services","2026-11-01 00:00:00","48","24+12+12","135599","162719","33900","Open Procedure","Key Decision","Green"],
    [114,"103261","HAS","Director of Public Health","Social & Community Supplies & Services","422-NYC-HA Oral Health Promotion","2026-04-01 00:00:00","60","36 + 12 + 12","300000","360000","60000","Contract Variation","No","Green"],
    [115,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","550-NYC-EN Ashfield Road - Reconstruct","2026-09-01 00:00:00",null,null,"150000","180000","150000","Bid","Decision Record","Green"],
    [116,"78884","CS Resources","Technology","ICT","700-NYC-RS Health and Safety Management System","2026-11-01 00:00:00","48","36+12","159850","191820","39963","Contract Extension","Decision Record","Green"],
    [117,"95121","CYPS","Inclusion","Social & Community Care Supplies & Services - Children","284-NYC-CY Parent Participation and Co Production","2028-04-01 00:00:00","60","36 + 24","204521","245425","41454","Contract Extension","No","Green"],
    [118,null,"CS Resources","Technology","ICT","765-NYC-CD Local Planning Software","2027-09-20 00:00:00","48","36+12","166000","199200","41500","Direct Award","TBC","Green"],
    [119,"105452","CS Resources","Technology","ICT","280-NYC-RS Fleet and Workshop Management System","2026-09-01 00:00:00","84","36+24+24","616504.96","739805.96","80000","Further Comp Above Threshold","Decision Record","Green"],
    [120,"DN218887","CS Resources","Technology","ICT","799-NYC-RS Insurance System\n(currently EvoClaim, provided by DWF 360)","2027-03-08 00:00:00","96","24+24+24+24+24","177098","212518","22137","Contract Extension","Decision Record",null],
    [121,"TBC","CS Resources","Technology","ICT","557-NYC-RS Gartner subscription for IT leaders","2026-07-01 00:00:00","24","24","187400","224880","93700","Direct Award","Decision Record","Green"],
    [122,"TBC","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","704-NYC-RS Off Site Commercial Storage","2027-08-07 00:00:00","180","120 + 60","150000","180000","10000","Further Comp Below Threshold","Decision Record","Green"],
    [123,"YPO tender portal","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","070-NYC-EN Tyres and associated services (fitting valves) for NYC depots","2027-11-01 00:00:00","48","24+12+12","1600000","1920000","400000","Contract Extension","No","Green"],
    [124,"95728","CS Local Engagement","Policy, Performance, Refugee / Asylum Issues and Community Safety","Social & Community Care Supplies & Services - Children","295-NYC-LE Domestic Abuse Children's Therapeutic Services","2027-10-01 00:00:00","36","24 + 12","400000","480000","132726.42","Contract Extension","Yes","Green"],
    [125,"tbc","NYH","NYH","Building Construction Materials","Hot boxes for ashphalt","2028-06-01 00:00:00","24","12+12","104720","125664","52360","TBC",null,null],
    [126,null,"CS Resources","Technology","ICT","Adobe Licences","2029-03-31 00:00:00","36","36","397610","477132","132537","Further Comp Above Threshold","Decision Record","Green"],
    [127,"tbc","NYH","NYH","Works - Construction, Repair & Maintenance","724-NYH-OO - SRF - A6108 Package 5 Leyburn to Bellerby cycleroute 24/25","2026-09-01 00:00:00",null,null,"978750","1174500","978750","Further Comp Below Threshold","No","Green"],
    [128,"DN418993","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","352-NYC-CY Medical advice for adoption and fostering panels","2027-04-01 00:00:00","84","36+24+24","350000","420000","50000","Contract Extension","No","Green"],
    [129,null,"CS HR and business support","Business Support","Facilities & Management Services","146-NYC-CX Corporate Business Travel","2029-03-02 00:00:00","48","36 + 12","2104000","2524800","525000","Contract Extension","TBC","Amber"],
    [130,null,"CS Resources","Technology","ICT","800-NYC-RS Lone Worker Solutions","2027-03-01 00:00:00","48","48","240000","288000","45000","Further Comp Above Threshold","Decision Record","Green"],
    [131,"TBC","CS Resources","Technology","ICT","617-NYC-RS Financial Accounting Solution for External Clients","2026-11-01 00:00:00","48","24+24","351734","422081","117245","Direct Award","Decision Record","Green"],
    [132,"92156","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","307-NYC-HA Care at Esk Moors Lodge","2029-10-01 00:00:00","96","4 +2 +2","1342525","1342525","175000","Contract Extension","Yes","Green"],
    [133,"37408","CS Resources","Technology","ICT","671-NYC-RS Education Case Management System","2027-05-01 00:00:00","83","59+24","770000","924000","110000","Contract Extension","Yes","Green"],
    [134,"51885","CS Resources","Technology","ICT","Backup solution for the M365 environment","2028-10-01 00:00:00","60","60","445000","534000","89000","Direct Award","Yes",null],
    [135,null,"CS Resources","Technology","ICT","Internet Filtering for Schools","2028-04-01 00:00:00","36","36","470000","564000","156667","TBC","Yes","Green"],
    [136,"TBC","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Demolition of buildings Grammar School Lane, Northallerton","2027-01-30 00:00:00",null,null,"500000","600000","720000","Bid","Yes",null],
    [137,null,"CS Local Engagement","Locality Structure","Social & Community Care Supplies & Services - Children","Holiday Activities Fund","2029-04-01 00:00:00",null,null,null,null,"210000",null,"Yes","Green"],
    [138,"DN388786","CS Resources","Technology","ICT","Service Management System\n(currently Ivanti Service Manager, provided under contract with Ultima)","2026-11-11 00:00:00","120","60 + 24 + 24 + 12","595884","715061","59588","Contract Extension","Yes","Green"],
    [139,"DN388786","CS Resources","Technology","ICT","Service Management System\n(currently Ivanti Service Manager, provided under contract with Ultima)","2028-11-11 00:00:00","120","60 + 24 + 24 + 12","595884","715061","59588","Contract Extension","Yes",null],
    [140,null,"CS Resources","Technology","ICT","Kitchen Management System and Associated Hardware","2028-03-01 00:00:00","24","24","245500","294600","122750","Further Comp Above Threshold","TBC","Green"],
    [141,"TBC","CS Resources","Technology","ICT","642-NYC-RS Income Management System","2026-11-01 00:00:00","60","36+12+12","1250000","1500000","250000","Further Comp Above Threshold","Decision Record","Amber"],
    [142,null,"CS Resources","Technology","ICT","Anti-Virus and Malware Protection Licences","2029-06-07 00:00:00","60","60","220500","264600","44000","Further Comp Above Threshold","Decision Record","Green"],
    [143,"DN560044 / 26113","CS Resources","Finance (inc. Pension Fund)","Consultancy","Pensions Fund Investment Consultant","2026-10-07 00:00:00","84","60+24","650000","780000","92857","Contract Extension","Decision Record","Green"],
    [144,null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","Actuarial Services for the Pension Fund","2028-01-01 00:00:00","84","60+12+12","700000","840000","144800","Further Comp Above Threshold","Decision Record","Green"],
    [145,null,"CS HR and business support","Business Support","Mail Services","Postal Services","2029-04-01 00:00:00","48","24+12+12","2800000","3360000","700000","Further Comp Above Threshold","Yes","Green"],
    [146,null,"CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Removals and storage services","2027-09-18 00:00:00","48","24+12+12","760000","912000","190000","Further Comp Above Threshold","Key Decision","Green"],
    [147,"PRO154","Environment","Regulatory Services, Registration, Bereavement, Coroners Service","Cemetery & Crematorium","Cremator Inspection","2038-07-26 00:00:00",null,null,"800000","960000",null,"Open Procedure","TBC",null],
    [148,null,"NYH","NYH","HR","Specialist Training for NY Highways","2027-01-01 00:00:00","60","24+12+12+12","850000","1020000","170000","Contract Extension","No","Green"],
    [149,null,"CS Resources","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","ICT","Library Kiosks - 2088 Public Use of IT Provision","2029-04-01 00:00:00","120","84+24+12","915000","1098000","42000","Open Procedure","Yes","Green"],
    [150,"DN368842","CS Resources","Technology","ICT","Library Kiosks - 2088 Public Use of IT Provision","2028-04-01 00:00:00","120","84+24+12","915000","1098000","91500","Contract Extension","Yes",null],
    [151,"DN490195","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","Traffic Signals Maintenance","2027-10-01 00:00:00","48","24+24","980000","1176000","140000","TBC","Key Decision","Green"],
    [152,"60471","CS Resources","Technology","ICT","Adult and Children’s Social Care System & Finance System","2027-04-01 00:00:00","84","60+24","1414000","1696800","202000","Contract Extension","Yes",null],
    [153,"TBC","CS Resources","Technology","ICT","Adult and Children’s Social Care System & Finance System","2029-04-01 00:00:00","84","60+24","1414000","1696800","202000","Open Procedure","Yes",null],
    [154,"TBC","CS Resources","Technology","ICT","Procurement Management Software (Currently YORtender/Proactis)","2027-01-01 00:00:00","84","36+24+24","1463000","1755600","209000","Contract Extension","Decision Record",null],
    [155,"60471","CS Resources","Technology","ICT","Trailblazer modules -  contract variation to Liquid Logic (HAS Funded)","2028-04-01 00:00:00","84","60+24","1815729","2178875","259390","Contract Variation","Yes",null],
    [156,"DN567561","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","348-NYC-HA Home From Hospital","2027-04-01 00:00:00","84","60+24","2235000","2682000","319286","Contract Extension","Yes","Green"],
    [157,"Lot1&2 - 67248 Lot3&4 - 35688 Tender - 48093","HAS","Prevention and Service Development","Social & Community Supplies & Services","325-NYC-HA Carers Information and Advice Service / Young Carers information and advice service","2028-07-01 00:00:00","60","36+36+24","5776000","6931200","722000","Contract Extension","Yes","Green"],
    [158,null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Prevention and Wellbeing Service","2027-04-01 00:00:00",null,null,"2606236","3127483",null,"Grant","Yes","Green"],
    [159,"39242 / 52084","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","323-NYC-CY Universal Youth Services","2028-09-01 00:00:00","96","36+36+24","2800000","3360000","350000","Contract Extension","Yes","Green"],
    [160,"52084","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","323-NYC-HA Universal Youth Services","2028-09-01 00:00:00","96","36+36+24","2800000","3360000","350000","Contract Extension","Yes","Green"],
    [161,null,"CYPS","Children and Families","Social & Community Care Supplies & Services - Children","608-NYC-CY Targeted Healthy Child Service","2027-04-01 00:00:00","60","36+24","3777175",null,"318000","TBC","Yes","Green"],
    [162,null,"CS Resources","Technology","ICT","Pension Administration System","2030-09-01 00:00:00","120",null,null,"3130812","500000","Above Threshold","Yes","Green"],
    [163,null,"CS Resources","Technology","ICT","152-NYC-RS Automated Collection and Analysis of Carriageway Condition Data Services","2027-04-01 00:00:00","60","60","901783.2","1127229","225000","Open Procedure","Yes","Green"],
    [164,null,"CS Resources","Technology","ICT","Corporate WAN","2030-01-01 00:00:00","72","60+12","4000000","4800000","800000","Contract Extension","Key Decision","Green"],
    [165,null,"CS Resources","Technology","ICT","IT Hardware Partner (Education) & (Corporate)","2027-09-01 00:00:00","60","24+24+12","5399000","6478800","1079800","Contract Extension","Yes","Green"],
    [166,"DN579573","HAS","Prevention and Service Development","Social & Community Supplies & Services","341-NYC-HA Advocacy Services :- Independent Health Complaints & CYPS Advocacy","2027-04-01 00:00:00","84","36+24+24","5618000","6741600","802571","Contract Extension","Yes","Green"],
    [167,"TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","518-NYC-EN-Supply of Waste Bins-Post Transformation","2027-08-06 00:00:00","48","24+12+12","15000000","18000000",null,"Open Procedure","Yes",null],
    [168,"76426","CS Resources","Property, Procurement and Commercial","Consultancy","Property (Estate and Projects) Consultancy Services (Currently Align)","2028-04-01 00:00:00","120","60+60","25000000","30000000","2500000","Direct Award","Yes","Green"],
    [169,"73132","CS Resources","Finance (inc. Pension Fund)","Financial Services","Insurance -  Casualty, Motor, Property, Travel/PA and Engineering","2026-04-01 00:00:00","66","36+24+6","44465759","53358911","8084683","Contract Extension","Decision Record","Green"],
    [170,"73132","CS Resources","Finance (inc. Pension Fund)","Financial Services","Insurance -  Casualty, Motor, Property, Travel/PA and Engineering","2028-04-01 00:00:00","66","36+24+6","44465759","53358911","8084683","Contract Extension","Decision Record",null],
    [171,"40885","HAS","Director of Public Health","Healthcare","440-NYC-HA Healthy Child Programme","2027-04-01 00:00:00","120","33+36+24+24","70233720","84280464","7023372","Contract Extension","TBC","Green"],
    [172,"TBC","CS Resources","Property, Procurement and Commercial","Utilities","35-NYC-RS Purchase of Power (Electricity) for corporate, schools and streetlighting from 2030","2028-10-01 00:00:00","48","48","101161888","121394266","25290472","Direct Award","Yes","Green"],
    [173,"73828","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","451-NYC-EN Waste Management Services","2030-09-18 00:00:00","120","60+24+24+12","182500000","219000000","18250000","Contract Extension","Yes","Green"],
    [174,"TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","Allerton Waste Recovery Park","2043-04-01 00:00:00",null,null,"1000000000","1200000000",null,"Above Threshold","Key Decision",null],
    [175,"54565","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","HAS APL: Supported Living  - Nursing and Residential  - Home Based Support - Community Based Support","2027-11-01 00:00:00","84","60+12+12","1200000000","1440000000","171428571","Contract Extension","Yes","Green"],
    [176,"TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Utilities","Clinical waste contract",null,null,null,null,"1000000",null,"TBC","TBC","Green"],
    [177,"SDC2019 050","Community Development","Housing","Housing Management","015-NYC-CD Kitchen, Bathrooms Expiry tbc","2026-06-29 00:00:00","48","2+1+1","19200000","23040000","4800000","Further Comp Above Threshold","Yes","Green"],
    [178,null,"CS Resources","Technology","ICT","154-NYC-RS Anti Virus - Schools","2028-06-13 00:00:00","36","36","144480.13","173376.16","33381.15","Further Comp Below Threshold","TBC","Green"],
    [179,"41052","Community Development","Locality Structure","ICT","CFO Insights - Data Analysis Tool","2026-03-31 00:00:00","36","36","40000","72000","10000","Best Value","Decision Record","Green"],
    [180,"TBC","CS Resources","Property, Procurement and Commercial","Catering","194-NYC-RS-1  Supply of Ambient, Chilled and Frozen Products (including Soft Beverages)","2027-04-01 00:00:00","84","60+12+12","17500000","21000000","2500000","Further Comp Above Threshold","Yes","Green"],
    [181,null,"CS Resources","Technology","ICT","584-NYC-RS Elections Management System","2028-09-01 00:00:00","41","29+12","505101.13","606121.36","143856.5","Contract Extension","Decision Record","Green"],
    [182,null,"CS Resources","Technology","ICT","393-NYC-RS Financial Forecasting Software","2026-12-09 00:00:00","12","12","218511.17","262261.4","192722","Direct Award","Decision Record","Green"],
    [183,"TBC","CS Resources","Technology","ICT","672-NYC-RS Highways Asset Management System","2027-06-01 00:00:00","48","36+12","1073560","1288272","268390","Direct Award","Yes","Green"],
    [184,null,"CS HR and business support","Human Resources","ICT","155-NYC-RS HR Recruitment Main Admin System","2029-01-05 00:00:00","48","36+12","325048.75","390058.5","80653","Direct Award","Decision Record","Green"],
    [185,"SDC2020 026","Community Development","Housing","Facilities & Management Services","Replacement Doors and Windows Harrogate, Selby and Richmondshire","2028-03-01 00:00:00","48","24+12+12","7769304","9711630","1942326","Contract Extension","Yes","Green"],
    [186,"TBC","CS Resources","Property, Procurement and Commercial","Catering","194-NYC-RS-5 Supply of Fresh Fruit, Vegetables, and Dairy","2027-03-01 00:00:00","60","36+12+12","6750000","8100000","1350000","Open Procedure","Key Decision","Green"],
    [187,"TBC","CS Resources","Property, Procurement and Commercial","Catering","194-NYC-RS-4 Supply of Fresh Meat","2027-03-01 00:00:00","60","24+12+12+12","1250000","1500000","250000","Open Procedure","Key Decision","Green"],
    [188,"100109264","CS Resources","Technology","ICT","558-NYC-RS Legal Services Case Management System.","2027-04-01 00:00:00","72","24+24+24","484547","581456.4","75514","Competitive Flexible Procedure","Yes","Amber"],
    [189,"TBC","CS Resources","Technology","ICT","Library Kiosks - 2088 Public Use of IT Provision","2029-04-01 00:00:00","48","36+12","915000","1098000","91500","Open Procedure","TBC",null],
    [190,null,"CS Resources","Technology","ICT","MANY (ANPR Cameras)","2030-01-10 00:00:00","60","60","28560.01","34272.01","5712","Further Comp Below Threshold",null,"Green"],
    [191,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","Facilities & Management Services","Grounds Maintenance","2027-04-01 00:00:00",null,"12","180000","216000","180000","Further Comp Above Threshold","No","Green"],
    [192,"73132","CS Resources","Finance (inc. Pension Fund)","Financial Services","Insurance -  Casualty, Motor, Property, Travel/PA and Engineering","2028-10-01 00:00:00",null,null,null,null,null,"Open Procedure","Yes",null],
    [193,"tbc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","PE and External Play Equipment - Inspection and Minor Repairs","2028-10-01 00:00:00","48","48","450000","540000","112500","TBC","Key Decision","Green"],
    [194,"94016","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","287-NYC-RS Asbestos Abatement","2028-09-01 00:00:00","84","36+24+24","10000000","12000000","1450000","Contract Extension","Key Decision","Green"],
    [195,"DN412771","Environment","Regulatory Services, Registration, Bereavement, Coroners Service","Cemetery & Crematorium","Stonefall Replacement Cremators","2035-10-01 00:00:00",null,null,null,null,null,"Open Procedure","TBC",null],
    [196,null,"CS Resources","Technology","ICT","490-NYC-RS Pensions Administration/PARIS/eBS Database support","2026-10-04 00:00:00","12","12","101919.45","122303.34","101919.45","Best Value","Decision Record","Green"],
    [197,null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","156-NYC-RS Pension Investment Independent Advisor","2027-04-01 00:00:00","36","24+12","60000","72000","20000","Contract Extension","No","Green"],
    [198,"TBC","CS Resources","Technology","ICT","458-NYC-RS Property Asset Management System","2027-04-07 00:00:00","24","12+12","182000","218000.4","91000","Direct Award","Decision Record","Green"],
    [199,"TBC","CS Resources","Finance (inc. Pension Fund)","Financial Services","157-NYC-RS Pensions Custodian Services","2026-04-01 00:00:00","24","12 + 12","120000","144000","60000","Waiver","Yes","Amber"],
    [200,"94013","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","38-NYC-RS Chimneys, Lightning Conductors and other High Access Structures - Inspection and Maintenance","2028-08-01 00:00:00","84","36+24+24","2400000","2880000","350000","Contract Extension","Key Decision","Green"],
    [201,"TBC","CS Resources","Finance (inc. Pension Fund)","Consultancy","Pensions Fund Investment Consultant","2028-10-08 00:00:00","84","60+24","650000","780000","92857","Open Procedure","Decision Record",null],
    [202,"TBC","CS Resources","Customer, Revenues and Benefits","Financial Services","158-NYC-RS Prepaid Cards for CoP & Migrant Programme Teams","2026-04-01 00:00:00","36","24+12","136150","163380","45383","Further Comp Below Threshold","Decision Record","Amber"],
    [203,null,"CS Resources","Technology","ICT","Corporate Mobile Phones","2028-01-20 00:00:00","60","36+12+12","520770","624924","104154","Contract Extension","Yes","Green"],
    [204,"100249","Environment","Regulatory Services, Registration, Bereavement, Coroners Service","Facilities & Management Services","160-NYC-EN - Stray Dogs Kennelling","2026-07-01 00:00:00","60","36+24","425000","510000","75000","Open Procedure","Key Decision","Green"],
    [205,"115791","CS Resources","Technology","ICT","687-NYC-RS-UiPath Robotic Process Automation","2027-07-25 00:00:00","24","12+12","37600","45120","18800","Contract Extension","No","Green"],
    [206,"TBC","CS HR and business support","Human Resources","HR","643-NYC-CE Shared Cost Additional Voluntary Contribution Schemes","2026-05-03 00:00:00","48","36+12","330000","396000","75000","Direct Award","Key Decision","Green"],
    [207,"TBC","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","317-NYC-CY Clinical psychologist (No Wrong Door, CAMHS, PiP)","2028-04-01 00:00:00","60","36+24","3861540","4633848","772308","Contract Extension","Yes","Green"],
    [208,"95176","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","75-NYC-EN Supply of Road Salt Expiry 2029","2029-06-01 00:00:00","48","48","10000000","12000000","2500000","Open Procedure","Yes","Green"],
    [209,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Cleaning & Janitorial","161-NYC-EN Provision of Cleaning, Minor Maintenance, and Consumables for Public Conveniences","2030-02-01 00:00:00","120","48+48+24","8383844","10060612.8","838384.4","Contract Extension","TBC","Green"],
    [210,null,"CS Resources","Technology","ICT","472-NYC-RS Microsoft Licencing Solution Partner","2028-06-01 00:00:00","42","36+6","15417500","18501000","3840691.72","Contract Extension","Yes","Green"],
    [211,null,"CS Resources","Technology","ICT","801-NYC-RS Security portfolio partner - Next Gen Firewall","2028-10-01 00:00:00","36","24+12","522867.76","627441.31","174289.25","Direct Award","Key Decision","Green"],
    [212,null,"CS Resources","Technology","ICT","Service Management System","2029-11-11 00:00:00",null,"60+24+24+12","602804.8","723365.76","53292.2","Further Comp Above Threshold","TBC","Green"],
    [213,null,"CS Resources","Property, Procurement and Commercial","Catering","Vending Machines","2027-08-01 00:00:00",null,null,"32000","38400","8000","Open Procedure","TBC",null],
    [214,"TBC","HAS","Director of Public Health","Education","622-NYC-HA Growing up in North Yorkshire - Learning and Wellbeing Surveys","2027-04-01 00:00:00",null,null,null,null,"25000","TBC","TBC","Green"],
    [215,"TBC","HAS","Director of Public Health","Healthcare","318-NYC-HA Public Health Medicines Optimisation Advisory Service","2025-03-01 00:00:00","60","36+24","150000","180000","30000","Provider Selection Regime","Decision Record","Green"],
    [216,"95697","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","265-NYH-OO Weather Forecast & Bureau Service Expiry 2028 plus extension","2028-07-05 00:00:00","84","36+24+24","1211000","1445200","176000","Contract Extension","Key Decision","Green"],
    [217,null,"Community Development","Culture, Arts and Leisure","Financial Services","Subscription to CollectionHQ (Libraries)","2027-06-16 00:00:00",null,null,null,null,"15000","TBC","No","Green"],
    [218,"SDC2021 033","Community Development","Housing","Works - Construction, Repair & Maintenance","044-NYC-RS Roofing Repairs and Replacement - Countywide Expiry tbc","2026-05-04 00:00:00","48","24+12+12","1600000","1920000","400000","Further Comp Above Threshold","Yes","Green"],
    [219,"91562","CS Local Engagement","Locality Structure","Social & Community Care Supplies & Services - Adults","354-NYC-LE Voluntary, Community and Social Enterprise (VCSE) Infrastructure Sector Support Service Grant","2028-04-01 00:00:00","60","36+24","2600000","2600000","510000","Contract Extension","Yes","Green"],
    [220,"TBC","CS HR and business support","Business Support","Clothing","165-NYC-CX Workwear & PPE / Uniforms – Joint NYH/NYC","2026-07-12 00:00:00","60","36+12+12","2250000","2700000","450000","Further Comp Above Threshold","Yes","Red"],
    [221,"TBC","CS Resources","Property, Procurement and Commercial","Catering","194-NYC-RS-2 Supply and Delivery of Pre-Packed Sandwiches and Associated Products","2026-04-01 00:00:00","60","36+12+12","1600000","1920000","320000","Further Comp Above Threshold","Yes","Green"],
    [222,"93191","CS Resources","Technology","ICT","166-NYC-RS Passenger Transport System","2027-09-01 00:00:00","84","60+24","400000","480000","56500","Competitive Flexible Procedure","Decision Record","Green"],
    [223,"98558","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","350-NYC-CY Inter Country Adoption","2027-07-01 00:00:00","60","2+2+1","180000","180000","36000","Contract Extension","No","Amber"],
    [224,"89503","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","432-NYC-HA Representative Body for Adult Social Care in North Yorkshire","2027-10-01 00:00:00","60","36+24","185000","222000","37000","Contract Extension","Yes","Green"],
    [225,"77584","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","431-NYC-HA Shared Lives","2027-02-01 00:00:00","60","36+12+12","2203292","2643950","440658","Contract Extension","Yes","Green"],
    [226,"TBC","CYPS","Education & Skills","Education","364-NYC-CY NYC  Supported Internships Approved Provider List","2028-08-01 00:00:00","72","48+24","4320000","5184000","720000","Contract Extension","Yes","Green"],
    [227,"83424","CYPS","Education & Skills","Education","363-NYC-CY High Needs Study Programme Approved Provider List","2028-08-01 00:00:00","72","48+24","9000000","10800000","1500000","Contract Extension","Yes","Green"],
    [228,"TBC","CS Resources","Technology","ICT","802-NYC-RS eSigning Solution (Digital Signatures)","2027-07-15 00:00:00","48","36+12","13056","15667","3264","Bid","TBC",null],
    [229,null,"CS Resources","Finance (inc. Pension Fund)","ICT","Supply and Implementation of a Financial Management System, Including Ongoing Hosting, Support, and Maintenance","2029-10-15 00:00:00","120","60+60","8400000","10080000","600000","Contract Extension","No","Green"],
    [230,null,"CS Resources","Technology","ICT","North Yorkshire Council ePEP/Attendance School Management System.","2027-08-01 00:00:00","48","36+12","88100","105720","22025","Contract Extension","No","Green"],
    [231,null,"CS Resources","Technology","ICT","168-NYC-RS Housing Asset Management System","2027-08-01 00:00:00","35","29+6","400000","480000","125000","Contract Extension","Decision Record","Green"],
    [232,null,"CS Resources","Customer, Revenues and Benefits","Facilities & Management Services","644-NYC-RS Customer Access and Tourist Information Points SLA","2027-04-01 00:00:00","12","12","50000","60000","50000","Grant","Decision Record","Green"],
    [233,"79486","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Automatic Doors and Gates - Servicing, Repair and Renewal","2027-04-01 00:00:00","84","36+24+24","4200000","5040000","614634","Contract Extension","Yes","Green"],
    [234,"104816","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","491-NYC-EN Technical and Planning Advisor (AWRP)","2029-05-01 00:00:00","48","36+12","400000","480000","100000","Contract Extension","Decision Record","Green"],
    [235,"92262","CS Resources","Technology","ICT","171-NYC-RS Consultation and Engagement System","2026-06-15 00:00:00","60","24+24+12","110000","132000","20000","Bid","Decision Record","Green"],
    [236,"TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","462-NYC-HA Integrated Community Equipment Loan Service","2027-04-01 00:00:00",null,null,"5110642",null,"2185714","TBC","Yes","Red"],
    [237,null,"CS Resources","Property, Procurement and Commercial","Catering","Catering Disposable Products","2028-01-01 00:00:00","48","24+24","149008","178809","37252","Further Comp Below Threshold","TBC","Green"],
    [238,null,"Community Development","Housing","ICT","Case Management System (Housing)","2027-10-01 00:00:00","36","24+12","83531","100237.2","26700","Further Comp Above Threshold","TBC","Green"],
    [239,null,"CS Resources","Finance (inc. Pension Fund)","ICT","Electronic Payment Services","2027-06-30 00:00:00","48","24 + 12 +24","400000","480000","22600","Further Comp Above Threshold","No","Amber"],
    [240,"69476","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Environmental Services","218-NYC-EN Roundabout Advertising","2027-04-01 00:00:00","36","24+12",null,null,null,"Contract Extension","TBC","Green"],
    [241,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","Consultancy","Bathymetric Surveys","2028-11-01 00:00:00","12","12","221934","266320.8","221934","Further Comp Above Threshold","TBC","Amber"],
    [242,"61015","CS Resources","Technology","ICT","Online Assessment Tool for Living Aids and Daily Needs","2027-04-05 00:00:00","36","36","32063","38475.6","12825.2","Best Value","TBC","Amber"],
    [243,"100106998","CYPS","Inclusion","Social & Community Care Supplies & Services - Children","320-NYC-CY SEND Mediation and Disagreement Resolution","2026-06-01 00:00:00","48","24+24",null,"1000000","180000","Open Procedure","Yes","Amber"],
    [244,"TBC","HAS","Director of Public Health","Healthcare","321-NYC-HA  Dental Epidemiology Survey in 5-year-olds","2027-07-01 00:00:00","60","12+24+24","200000","240000",null,"Provider Selection Regime","Yes","Green"],
    [245,"N/a","NYH","NYH","Vehicle Management","Vehicle purchases (various), including ongoing parts and servicing for next 12 month period","2026-09-01 00:00:00",null,null,"1000000","1200000","1000000","Further Comp Above Threshold","No","Green"],
    [246,"N/a","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","NYC Fleet requirements for 2026-2027","2027-03-31 00:00:00",null,"12","15000000","17785500","10000000","Further Comp Above Threshold","Yes","Green"],
    [247,"102564","CS Resources","Technology","ICT","173-NYC-RS Leisure Management System","2026-04-20 00:00:00","88","40+24+24","2166666","2600000","309000","Open Procedure","Yes","Amber"],
    [248,"tbc","Community Development","Housing","Works - Construction, Repair & Maintenance","Neville House, Gargrave - Redevelopment","2027-07-06 00:00:00","14","14","3600000","4000000","3600000","Further Comp Above Threshold","Yes","Amber"],
    [249,"99605","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","288-NYC-RS Pool Plant Maintenance","2027-09-01 00:00:00","60","24 + 24 + 12","500539","650000","100107.8","Contract Extension","Yes","Green"],
    [250,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","176-NYC-EN Route Optimisation Consultancy","2027-01-12 00:00:00","12",null,"99394","119272.8","99394","Contract Extension","Decision Record","Amber"],
    [251,"TBC","CS HR and business support","Business Support","Stationery","274-NYC-CX Office Supplies","2027-05-31 00:00:00","60","48+12","800000","960000","160000","Open Procedure","Key Decision","Amber"],
    [252,"DN510228","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","Supply, Installation and Maintenance of Vehicle Charger Units in the Harrogate District","2027-03-08 00:00:00","120","60+12+12+12+12+12","280000","336000","33000","TBC","Decision Record","Green"],
    [253,"100106805","Community Development","Culture, Arts and Leisure","Arts & Leisure Services","289-NYC-RS Gym Equipment and Maintenance","2027-01-11 00:00:00","72","24 + 24 + 24","2500000","3000000","500000","Open Procedure","Yes","Green"],
    [254,"91585","Community Development","Housing","Works - Construction, Repair & Maintenance","Minor Works at St Andrews Avenue and Stockwell Place","2025-02-17 00:00:00","6","6","154000","154000","154000","Further Comp Below Threshold","No","Amber"],
    [255,"TBC","Community Development","Housing","Housing Management","43-NYC-RS Damp & Mould surveys/treatments LOT 2","2026-08-01 00:00:00","24","12+12","600000","600000","300000","Contract Extension","Yes","Green"],
    [256,"100109124","Community Development","Housing","Housing Management","570-NYC-EN Service Repair and Maintenance of Septic Tanks and Pumping Stations","2026-09-01 00:00:00","48","24+12+12","360000","432000","90000","Further Comp Above Threshold","No","Amber"],
    [257,"tbc","Community Development","Housing","Works - Construction, Repair & Maintenance","044-NYC-RS Roofing Repairs and Replacement - Countywide Expiry tbc","2026-05-22 00:00:00","48","24+12+12","1156000","1387200","289000","Further Comp Above Threshold","Yes","Green"],
    [258,"tbc","Community Development","Housing","Housing Management","Groundworks - landscaping and tree removals etc","2025-09-01 00:00:00",null,null,"250000","300000",null,"Further Comp Below Threshold","TBC","Green"],
    [259,"103469","Community Development","Housing","Housing Management","446-NYC-CD Rendering and Plastering","2028-02-01 00:00:00","48","24+12+12","450000","540000","112500","Contract Extension","Yes","Green"],
    [260,"tbc","Community Development","Housing","Housing Management","022-NYC-CD Housing - Supply of Scaffolding and Access Equipment","2027-03-31 00:00:00","36","24+12","150000","180000","50000","Further Comp Below Threshold","No","Green"],
    [261,"94765","NYH","NYH","Horticulture","Urban Highway Grass Cutting","2027-04-01 00:00:00","12","24+12+12","300000","360000","75000","Contract Extension","No","Green"],
    [262,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","716-NYC-EN - Swinney Bridge precast beam supply and works","2027-04-01 00:00:00",null,null,"200000","240000","200000","Bid",null,"Green"],
    [263,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","591-NYC-EN OEM Parts Supply","2026-10-01 00:00:00","48","48","3493175","4191810","873294","TBC","Yes","Amber"],
    [264,null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","356-NYC-HA Community Mental Health","2027-10-01 00:00:00","48","2+1+1","1058210.8","1058210.8","264552","Provider Selection Regime","Key Decision","Amber"],
    [265,"CTBT11","CS Resources","Technology","ICT","Civica (Database / EDM for Ryedale)","2027-01-01 00:00:00",null,null,null,null,"32514.73","Contract Extension","No","Green"],
    [266,"TBC","CS Resources","Technology","ICT","702-NYC-RS HR and Payroll System","2027-08-01 00:00:00","48","36+12","2867300","3440760","716825","Contract Extension","Yes","Green"],
    [267,"67609","CS Resources","Technology",null,"Service Management Platform Convergence","2030-03-31 00:00:00","87.5","63.5+24","695767.11","834920.53","82040","Contract Extension","Key Decision","Green"],
    [268,"61444","CS Resources","Technology","ICT","713-NYC-RS Energy Management System","2028-04-01 00:00:00","48","24+12+12","26000","31200","6500","Contract Extension","No","Green"],
    [269,"74102","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","438-NYC-HA Carers Break Service","2026-10-01 00:00:00","84","36+24+24","1813670.83","2176405","319141.24","Contract Extension","Key Decision","Green"],
    [270,null,"Community Development","Culture, Arts and Leisure","Social & Community Supplies & Services","747-NYC-CD E-Books and E-Audio","2027-04-01 00:00:00",null,null,null,null,"75000","Further Comp Above Threshold",null,"Green"],
    [271,"76276","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Mechanical Equipment and Plant - Servicing and Responsive Maintenance","2027-07-01 00:00:00","84","36+24+24","105000000","126000000","15000000","Contract Extension","Key Decision","Green"],
    [272,"80005","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Asbestos Sampling and Analysis","2027-04-01 00:00:00","84","36+24+24","9975000","11970000","1425000","Contract Extension","Yes","Green"],
    [273,"79343","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Lifting Equipment Servicing, Remedial and Renewal Works","2027-04-01 00:00:00","84","36+24+24","7140000","8568000","1020000","Contract Extension","Key Decision","Green"],
    [274,null,"Community Development","Planning","Environmental Services","Provision of Ecological Data","2030-10-05 00:00:00","60","60","302900","363560","75725","Direct Award","Decision Record","Green"],
    [275,"90323","CS Resources","Customer, Revenues and Benefits","Social & Community Care Supplies & Services - Adults","311-NYC-HA Provision of a North Yorkshire Information, Advice and Guidance Service","2027-04-01 00:00:00","72","2 +2 + 2","3373788","3373788","562298","Contract Extension","Key Decision","Green"],
    [276,"TBC","CS Resources","Business Support","Cleaning & Janitorial","180-NYC-RS - Cleaning and Janitorial Products","2026-07-20 00:00:00","60","36+12+12","1000000","1200000","200000","Further Comp Above Threshold","Yes","Green"],
    [277,"110107732","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Environmental Services","193-NYC-EN Parking Payment AppsA","2026-06-01 00:00:00","60","36+12+12","1220000","1464000","244000","Further Comp Above Threshold","Key Decision","Amber"],
    [278,"93067","CS Resources","Customer, Revenues and Benefits",null,"Blue Badge Digital Service","2027-08-05 00:00:00","60","36 + 24","135000","162000","27000","Contract Extension","Decision Record","Green"],
    [279,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Highway Equipment & Materials","533-NYC-EN Harbour Liquid Fuel Tank","2027-08-18 00:00:00","48","2+2","658132","822664","205666","Contract Extension","Yes","Green"],
    [280,"73454","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Planned Preventative Maintenance (PPM) Service for Air Source Heat Pumps (Leisure Centres)","2028-09-25 00:00:00","60","3+2","482030","578436","96406","Contract Extension","Yes","Amber"],
    [281,"NA","NYH","NYH","ICT","507-NYH-OO Gully Maintenance Software","2026-04-01 00:00:00","48","36+12","201414","241696","50353","Direct Award","No","Green"],
    [282,"104715","CS HR and business support","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Facilities & Management Services","181-NYC-CX - External Venues Booking","2027-03-14 00:00:00","36","24+12","702000","842400","234000","Contract Extension","TBC","Green"],
    [283,"tbc","Community Development","Economic Development, Regeneration, Tourism and Skills","Works - Construction, Repair & Maintenance","Malton Castlegate and Greenspaces Project­",null,null,null,null,null,null,null,null,"Green"],
    [284,null,"CS Resources","Technology","ICT","182-NYC-RS Project Portfolio Management and Resource System","2029-04-01 00:00:00","88","40+24+24","625000","750000","55000","Contract Extension","TBC","Green"],
    [285,"TBC","Community Development","HCC","Catering","705-NYC-CD Sun Pavilion Catering Contract","2027-06-01 00:00:00","120","60+60","3900000","4685242.39","390436.86","Above Threshold LTR","Yes","Green"],
    [286,"TBC","CS Resources","Customer, Revenues and Benefits","Social & Community Supplies & Services","454-NYC-RS Crisis Resilience Fund","2026-07-01 00:00:00",null,null,null,null,"500000","TBC","TBC","Amber"],
    [287,null,"Community Development","Housing","Legal Services","290-NYC-LC Legal Services - Housing Disrepairs","2027-04-01 00:00:00","41","24 + 17","427000","427000","125000","Contract Extension","No","Green"],
    [288,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","ICT","Cameras and system for Cawood Weighbridge","2030-12-01 00:00:00","60",null,"110000","125000","25000","Further Comp Above Threshold","TBC","Green"],
    [289,"105689","Community Development","Housing","Social & Community Supplies & Services","291-NYC-LE Management of Gypsy, Roma and Traveller Sites including Domestic Abuse Support to Residents","2026-08-03 00:00:00","108","36 + 24 + 24 + 24","6750000","8010000","750000","Open Procedure","Yes","Amber"],
    [290,"TBC","CS Local Engagement","Policy, Performance, Refugee / Asylum Issues and Community Safety","Health & Safety","803-NYC-LE Northallerton Community Safety CCTV","2027-10-01 00:00:00","12","12","16500","19800","16500","Best Value","No","Green"],
    [291,"TBC","CS Resources","Technology","ICT","645-NYC-RS Online learning and workforce development platform","2026-12-03 00:00:00","24","24","103206","123847.2","51603","TBC","No","Green"],
    [292,null,"Community Development","HCC","ICT","Event and Venue Management Software","2028-01-01 00:00:00","48","TBC","187845.24","225414.29","46961.31","Further Comp Above Threshold","TBC","Green"],
    [293,"TBC","Community Development","Locality Structure","Social & Community Supplies & Services","188-NYC-LE VCSE specialist support consultancy services","2026-09-01 00:00:00","60","36+24","500000","600000","100000","Open Framework Establish","Yes","Green"],
    [294,"100107773","CYPS","Inclusion","Education","369-NYC-CY Inclusion Services Framework","2026-09-01 00:00:00","120","120","40000000","33333333.33","2790000","Framework Establish","Yes","Amber"],
    [295,null,"CS Resources","Technology","ICT","Library Management System","2030-04-01 00:00:00","84","43+24+24","276374","331648.8","39482","Contract Extension","No","Green"],
    [296,null,"CS Resources","Technology","ICT","Library Management System","2032-04-01 00:00:00",null,null,null,null,"39482","Above Threshold","Yes","Green"],
    [297,null,"CS Resources","Technology","ICT","Digital Care Records & E Scheduling","2029-07-01 00:00:00",null,null,null,null,"129700","Above Threshold","Yes","Green"],
    [298,null,"CS Resources","Technology","ICT","Vehicle Telematics and Portal System","2029-11-01 00:00:00",null,null,null,null,"100000","Further Comp Above Threshold","Yes","Green"],
    [299,null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","Pension Legal Advisors","2028-09-01 00:00:00","48","24+12+12","146800","176160","36700","Further Comp Below Threshold","No","Green"],
    [300,null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","Pensions Legal Advisor","2028-09-01 00:00:00",null,null,"146800","176160","36700","Further Comp Below Threshold","Decision Record","Green"],
    [301,null,"CS Resources","Technology","ICT","Back Office System for English National Concessionary Travel Scheme","2028-10-06 00:00:00",null,null,"600000","720000","120000","Further Comp Above Threshold","Yes","Green"],
    [302,"tbc","Community Development","Housing","Housing Management","Managed Stores","2024-11-25 00:00:00","60","36+12+12","20000000","24000000","4000000","Contract Management Targeted Support","Yes","Green"],
    [303,"75054","Community Development","Culture, Arts and Leisure","Cleaning & Janitorial","99-NYC-CD Purchase of Swimming Pool Chemicals","2026-02-01 00:00:00","48","36+12","216000","259200","54000","Direct Award","Decision Record","Green"],
    [304,"TBC","Community Development","Housing","Housing Management","529-NYC-CD Legionella Risk Assessment - Expiry 2030","2026-09-10 00:00:00","48","24+12+12","43000","51600","11000","TBC","No","Green"],
    [305,"TBC","Community Development","Housing","Housing Management","530-NYC-CD-Fire Safety and Security","2026-10-01 00:00:00","48","24+12+12","175000","210000","25000","Further Comp Below Threshold","TBC","Green"],
    [306,"TBC","Community Development","Housing","Housing Management","Radon Monitoring and PPM","2025-09-01 00:00:00",null,null,null,null,null,"Further Comp Below Threshold",null,"Amber"],
    [307,"103827","Community Development","Housing","Housing Management","052-NYC-RS Fencing and Gate Repair Works","2027-12-01 00:00:00","48","24+12+12","450000","540000","112500","Contract Extension","Yes","Amber"],
    [308,"TBC","Community Development","Housing","Housing Management","Independence Adaptations (Inc Extensions)","2025-10-01 00:00:00",null,null,"0","0","0","Further Comp Above Threshold",null,"Amber"],
    [309,null,"CS Resources","Technology","ICT","Occupational Health Case Management System","2029-05-23 00:00:00",null,null,null,null,"21053.04","Further Comp Below Threshold","TBC","Green"],
    [310,null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","467-NYC-HA Live-in Care","2026-11-02 00:00:00","84","60+24","43302270","43302270","7873140","Open Framework Establish","Yes","Amber"],
    [311,"100108282","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","100-NYC-HA Intermediate Care Beds","2026-10-01 00:00:00","48",null,"12000000",null,"2296320","Framework Establish","Yes","Amber"],
    [312,"DN476035","Environment","Highways, Transportation, Parking Services, Parks and Grounds","ICT","823-NYC-EN Fleet Management System","2026-09-06 00:00:00","78","36 +12 +12+12+6","118800","198000","39600","Contract Extension","TBC","Green"],
    [313,null,"Environment","Regulatory Services, Registration, Bereavement, Coroners Service","ICT","Chapel Music and Video Hardware","2027-04-01 00:00:00","48",null,"188000","225600","47000","Direct Award","No","Green"],
    [314,"tbc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Water Hygiene Risk Assessment, Monitoring and Works","2027-07-01 00:00:00","84","36+24+24","21000000",null,"3000000","Contract Extension","TBC","Green"],
    [315,"76022","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Water Hygiene Risk Assessment, Monitoring and Repairs","2025-04-01 00:00:00","84","36+24+24","21000000","25200000","3000000","Contract Termination","Decision Record","Green"],
    [316,null,"CS Resources","Technology","ICT","804-NYC-RS Online Forms for Revenue and Benefits","2026-11-30 00:00:00","24","12+12",null,"95280","39700","Further Comp Below Threshold","No","Green"],
    [317,"68417","CS Resources","Technology","ICT","191-NYC-RS Customer Relationship Management System","2026-11-01 00:00:00","20","12+8","164523.29","197427.94","98713.97","Contract Variation","Decision Record","Green"],
    [318,"68714","CS Resources","Technology","ICT","192-NYC-RS Meritec Systems","2027-04-01 00:00:00","36","24 + 12","117150","93720","39050","Contract Extension","Decision Record","Green"],
    [319,"N/A","Community Development","Housing","Social & Community Care Supplies & Services - Adults","333-NYC-CD Technology Enabled Care Services including Call Monitoring","2027-09-26 00:00:00","48","24+12+12","1035286","1242343.2","180000","Contract Extension","Yes","Green"],
    [320,"101631","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","424-NYC-HA Independent Advocacy Services","2029-04-01 00:00:00","72","36+24+24","5760076","5760076","822868","Contract Extension","Yes","Green"],
    [321,"N/A","Community Development","Housing","Social & Community Care Supplies & Services - Adults","104-NYC-CD Warden Call","2026-09-01 00:00:00","12",null,null,"210000",null,"Direct Award",null,"Green"],
    [322,"tbc","Environment","Regulatory Services, Registration, Bereavement, Coroners Service","Cemetery & Crematorium","107-NYC-EN Woodland Crematorium Scarborough - replacement cremators","2027-06-01 00:00:00",null,null,"1400000","1680000",null,"Direct Award","Yes","Green"],
    [323,"69787 - Contract Register","CS Resources","Property, Procurement and Commercial","Utilities","NYC-RS Meter Operator Services (MOp) Expiry TBC","2027-04-01 00:00:00","24","24","340422","357433","170211","Direct Award","Decision Record","Green"],
    [324,"60544","Community Development","HCC","Catering","Provision of Food Harrogate Convention Centre","2027-04-17 00:00:00","36","12+12+12","1065888","1065888","532944","Contract Extension","Decision Record","Green"],
    [325,"95393","CS Resources","Technology","ICT","Leisure Management System (Craven)","2027-02-01 00:00:00","36","24 + 12","44668.44","53602.13","14889.48","Contract Extension","No","Green"],
    [326,null,"CS Resources","Technology","ICT","Leisure Management System (Selby)","2026-09-01 00:00:00","24","12+12","62500","75000","30250","Contract Extension",null,"Green"],
    [327,null,"CS Resources","Technology","ICT","340-NYC-RS HR / Payroll Case Management System","2027-03-01 00:00:00",null,null,"120000","144000","120000","Contract Variation","Decision Record","Green"],
    [328,null,"CS Resources","Technology","ICT","466-NYC-RS Digital EHCPs","2028-01-05 00:00:00","48","24 + 24","222800","267360","50000","Contract Extension","TBC","Green"],
    [329,null,"CS Resources","Human Resources","HR","278-NYC-RS Drug and Alcohol Testing","2029-10-03 00:00:00","48","48","100000","120000","25000","Further Comp Below Threshold","Decision Record","Green"],
    [330,null,"Community Development","Culture, Arts and Leisure","Healthcare","Provision of Medical Support for Scarborough Open Air Theatre, Scarborough Spa, Whitby Pavilion and Other Events","2030-04-01 00:00:00",null,null,null,null,"110000","Provider Selection Regime","Yes","Green"],
    [331,"105149","Community Development","Culture, Arts and Leisure","Health & Safety","Events Portable Toilets","2030-04-01 00:00:00","48",null,null,null,"100000","Bid","No","Green"],
    [332,null,"Community Development","Economic Development, Regeneration, Tourism and Skills","Arts & Leisure Services","279-NYC-CD Scarborough Speedboat Licences","2035-04-01 00:00:00","120","120","254016","304818.2","25401.6","Bid","Decision Record","Green"],
    [333,"tbc","NYH","NYH","Works - Construction, Repair & Maintenance","236-NYH-OO A1 Civils (landslip, Stonesdale to Ravenseat)","2026-06-26 00:00:00","6","6","203280","243936","203280","Further Comp Below Threshold","No","Green"],
    [334,"95532","NYH","NYH","Works - Construction, Repair & Maintenance","240-NYH-OO A2 Surfacing A20024 - Area 2 25/26 tender package 1: R&R and PSDP schemes","2025-04-01 00:00:00","7","7","2676584","3211901","2676584","Further Comp Below Threshold","No","Green"],
    [335,"TBC","NYH","NYH","Works - Construction, Repair & Maintenance","245-NYH-OO A3 Civils A30024 (Landslip, Glen Esk Road, Mounter beck To Jacobs Well,) (Area 4)","2027-06-01 00:00:00","6","6","530350","636420","530350","Further Comp Below Threshold","No","Green"],
    [336,null,"HAS","Director of Public Health","Healthcare","301-NYC-HA Substance Use Service - Adults","2026-04-01 00:00:00","60","60","15614855","18477355.77","2803226","Provider Selection Regime","Yes","Red"],
    [337,"100077","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Fire and Intruder Alarms - Servicing, Responsive Maintenance, Remedial and Renewal","2028-04-01 00:00:00","84","36+24+24","2794596","3493245","499035","Contract Extension","Yes","Amber"],
    [338,"TBC","CS Resources","Technology","ICT","522-NYC-RS Online Information, Procedures and Guidance for CYPS","2026-05-26 00:00:00","48","36+12","40000","40000","10000","TBC","TBC","Green"],
    [339,"tbc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","357-NYC-HA Harrogate Care and Support Hub","2027-04-01 00:00:00",null,null,"12000000","14400000",null,"Competitive Flexible Procedure","Yes","Green"],
    [340,"76187","HAS","Director of Public Health","Social & Community Care Supplies & Services - Adults","501-NYC-HA Lived Experience Recovery Organisations","2029-04-01 00:00:00","60","36 + 24","425000","425000","85000","Contract Extension","TBC","Green"],
    [341,"TBC","CS Resources","Technology","ICT","738-NYC-EN On-Line Registrar, Births, Deaths and Marriages","2027-03-01 00:00:00","120","36 + 36 +24+12+12","114000","136800","9468.75","Contract Extension","TBC","Green"],
    [342,"tbc","Community Development","Economic Development, Regeneration, Tourism and Skills","Works - Construction, Repair & Maintenance","292-NYC-CD Studio 2 Harrogate Convention Centre HCC","2026-04-07 00:00:00","12","12","7440000","8928000","7440000","Further Comp Above Threshold","Yes","Red"],
    [343,"96077","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","293-NYC-RS Scarborough North Bay Development",null,null,"tbc","19000000","22800000","19000000","Open Procedure","Yes","Green"],
    [344,"51154","Community Development","Culture, Arts and Leisure","Health & Safety","660-NYC-CD Event Health and Safety Services","2027-04-01 00:00:00","84","60+24","741820.85","890185.02","105975","Contract Extension","No","Amber"],
    [345,"100110894","Community Development","Culture, Arts and Leisure","Health & Safety","749-NYC-CD Event Noise Monitoring Services","2027-04-01 00:00:00","72","48+24","125400","137940","22990","Bid","TBC","Green"],
    [346,"TBC","Community Development","Planning","Consultancy","464-NYC-CD Strategic Flood Risk Assessment","2026-04-30 00:00:00",null,null,"150000","180000",null,"Further Comp Below Threshold","TBC","Green"],
    [347,null,"Community Development","Planning","Consultancy","Landscape Character Assessment","2026-10-01 00:00:00","16","13+3","184919.21","221903.06",null,"Contract Extension","No","Green"],
    [348,"TBC","Community Development","Planning","Consultancy","544-NYC-CD Whole Plan Viability Assessment","2026-09-01 00:00:00","12","12","100000","120000","100000","Further Comp Below Threshold","Decision Record","Green"],
    [349,"TBC","Community Development","Planning","Consultancy","463-NYC-CD Infrastructure Capacity Study & Potential Growth Project","2025-05-30 00:00:00",null,null,"300000","360000",null,"Further Comp Above Threshold","Decision Record","Amber"],
    [350,"tbc","CS Resources","Property, Procurement and Commercial","Utilities","Supply of gas","2027-04-01 00:00:00","48","48","12000000","14400000","3000000","Further Comp Above Threshold","Yes","Green"],
    [351,"tbc","CS Resources","Property, Procurement and Commercial","Utilities","Supply of pottable water","2028-10-01 00:00:00","48","48","10500000","12600000","2625000","Further Comp Above Threshold","Yes","Green"],
    [352,"tbc","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Vehicle Management","NYC-EN The Supply and Maintenance of Municipal Vehicles","2027-12-01 00:00:00",null,null,"18000000","21600000","900000","Contract Termination","Key Decision","Green"],
    [353,"101341","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","418-NYC-EN Underwater Inspection and Maintenance Contract 2025 - 2032","2032-04-01 00:00:00","76","76","250000","300000","39473.68","Open Procedure","Yes","Green"],
    [354,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","403-NYC-EN Escoe House Culvert Repair","2026-04-01 00:00:00","3","3","100000","120000","100000","Bid","Decision Record","Green"],
    [355,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","405-NYC-EN North (Ripon) Major repair works","2026-03-01 00:00:00","3","3","250000","300000","250000","Bid",null,"Green"],
    [356,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","406-NYC-EN Low Green Concrete Invert","2027-03-01 00:00:00","3","3","80000","96000","80000","Bid",null,"Green"],
    [357,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","407-NYC-EN Low Easby South Form invert and scour protection","2027-09-01 00:00:00","3","3","100000","120000","100000","Bid",null,"Green"],
    [358,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","409-NYC-EN Holme Beck Path Wall Ret wall works",null,"3","3","100000","120000",null,"Bid","No","Green"],
    [359,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","410-NYC-EN Side Bank Wood (APS) Rebuild most of the wall",null,"3","3","200000","240000","200000","Bid","No","Green"],
    [360,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","411-NYC-EN Kirklington Replace structure","2027-07-01 00:00:00","3","3","200000","240000","240000","Bid",null,"Green"],
    [361,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","412-NYC-EN Long Gill (West) (APS) Strengthening","2026-09-01 00:00:00","3","3","60000","72000","60000","Bid",null,"Green"],
    [362,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","413-NYC-EN Skipton on Swale Fill replacement to west flood arches","2027-09-01 00:00:00","3","3","200000","240000","200000","Bid",null,"Green"],
    [363,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","414-NYC-EN Potts Beck (Litton) Spandrel rebuild and saddle","2026-10-01 00:00:00","3","3","150000","180000","150000","Bid",null,"Green"],
    [364,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","415-NYC-EN Park Street Railway (APS) Repairs","2026-10-01 00:00:00","3","3","400000","480000","400000","Bid",null,"Green"],
    [365,"tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","416-NYC-EN West Stonesdale Wall rebuild",null,"3","3","80000","96000","80000","Further Comp Below Threshold","No","Green"],
    [366,"N/a","NYH","NYH","Vehicle Management","NYH- Leased MEWP","2027-02-01 00:00:00",null,"tbc","640000","768000","640000","Further Comp Above Threshold","No","Green"],
    [367,"100110703","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Works - Construction, Repair & Maintenance","426-NYC-EN Remediation works to collapsed mineshaft at Langbaurgh Ridge - Closed Landfill site","2026-09-01 00:00:00","5","5","710000","852000","710000","Further Comp Below Threshold","Yes","Green"],
    [368,"tbc","CS Resources","Property, Procurement and Commercial","Utilities","Liquid Fuels for NYC, NY H and Harbours","2028-04-01 00:00:00","48","48 + 48","16000000","19200000","4803946","Further Comp Above Threshold","Yes","Green"],
    [369,"88786","Community Development","Housing","Housing Management","782-NYC-EN-Heating Appliance Auditing","2026-10-25 00:00:00","36","12+12+12","135000","162000","45000","Contract Extension","Decision Record","Green"],
    [370,"49427","Community Development","Housing","Housing Management","Selby PFI","2034-01-01 00:00:00","360","360","12915000","15498000","554000","Contract Management Targeted Support","No","Green"],
    [371,"tbc","NYH","NYH","Environmental Services","637-NYH-EN - Provision of Civil Engineering Coring and Testing","2026-08-01 00:00:00","48","24+12+12","840000","1008000","210000","Open Procedure","No","Green"],
    [372,"102024","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","469-NYC-RS Electrical Safety Framework","2029-12-01 00:00:00","48","48","9988000","13000000","1544000","Framework Establish","Yes","Green"],
    [373,"99617","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","460-NYC-RS Stage Lighting Inspection and Maintenance","2028-02-01 00:00:00","72","24+24+24","420125","504150","84025","Contract Extension","Yes","Green"],
    [374,null,"HAS","Director of Public Health","Healthcare","461-NYC-HA Pharmacotherapy Patient Group Directive (PGD)","2026-04-01 00:00:00","39","39","450000","540000","164661","Provider Selection Regime","Yes","Red"],
    [375,"69553","CS Resources","Property, Procurement and Commercial","Social & Community Supplies & Services","479-NYC-RS The Provision of SME and VCSE Support Services for The Councils Procurement and Contracting Opportunities","2027-04-01 00:00:00","36","24+12","37500","45000","12500","Contract Extension","No","Green"],
    [376,null,"CS Resources","Technology","ICT","E-Brokerage and Organisation Recharging Module","2029-04-01 00:00:00","58","34+24","396248","475497.6","85000","Open Procedure","Yes","Green"],
    [377,null,"CS HR and business support","Human Resources","HR","Employee benefits and Salary Sacrifice Scheme (NYC Call Off - Lot 2)","2032-03-01 00:00:00","84","84","0","0","0","Further Comp Below Threshold","TBC","Green"],
    [378,null,"HAS","Director of Public Health","Healthcare","470-NYC-HA Substance Use Service - Young People","2026-04-01 00:00:00","60","60","1610485","1610485","309130","Provider Selection Regime","Yes","Red"],
    [379,null,"HAS","Prevention and Service Development","Healthcare","502-NYC-HA North Yorkshire Mental Health Transformation Hubs","2027-04-01 00:00:00","60","36 + 24","3811430",null,"762286","Provider Selection Regime","Yes","Green"],
    [380,"TBC","Community Development","Culture, Arts and Leisure","Cleaning & Janitorial","482-NYC-CD Provision of Clean Linen and Laundering Services","2026-09-01 00:00:00","24","12+6+6","410800","548350","205200","Contract Extension","No","Green"],
    [381,null,"CS Local Engagement","Communications","HR","Multidisciplinary Media Services","2028-04-01 00:00:00",null,null,null,null,"50000","Open Procedure","TBC","Green"],
    [382,"TBC","Community Development","Economic Development, Regeneration, Tourism and Skills","Consultancy","512-NYC-CD Scarborough Piers - Bullnose and Lighthouse - Sheet Pile Replacement - Consultant to support ECI stage","2026-08-01 00:00:00","24","12+12","447242","536690.4","223621","Further Comp Above Threshold","No","Green"],
    [383,"TBC","Community Development","Economic Development, Regeneration, Tourism and Skills","Works - Construction, Repair & Maintenance","521-NYC-CD Scarborough Piers - West Pier Bullnose and Lighthouse Pier - Sheet Pile Replacement","2026-08-01 00:00:00","24","12+12","7580738","9056897.6","3790369","Further Comp Above Threshold","Yes","Green"],
    [384,null,"CS Resources","Property, Procurement and Commercial","Utilities","Liquid Fuels for NYC,NYH and Harbours","2027-04-01 00:00:00","48","24 + 12 +12","16000000","19200000","4000000","Contract Extension","Yes","Green"],
    [385,"104588","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","495-NYC-EN-Supply and Potential delivery of waste bins-Interim-Expiry TBC","2026-06-01 00:00:00","48","24+12+12","2750000","3300000","1375000","Open Procedure","Yes","Green"],
    [386,null,"Community Development","Housing","Legal Services","Legal Services - Housing Disrepairs","2028-10-01 00:00:00","48",null,"500000","600000","125000","Further Comp Above Threshold","Key Decision","Green"],
    [387,null,"CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Fire Equipment: Inspection and Supply","2028-04-01 00:00:00","72","36+12+12+12+12","1820000","2184000","260000","Contract Extension","No","Green"],
    [388,"100106231","NYH","NYH","Works - Construction, Repair & Maintenance","400-NYH-OO - Civil Engineering Contractors Framework 2026","2026-04-27 00:00:00","48","48","25000000","30000000","6250000","Framework Establish","No","Green"],
    [389,"TBC","CS Resources","Technology","ICT","560-NYC-RS Countryside Access Management System","2027-04-01 00:00:00",null,null,null,null,null,"TBC","TBC","Green"],
    [390,"49508","CS Resources","Technology","ICT","805-NYC-RS Housing Management System (Selby)","2027-07-23 00:00:00","84","60+24","839631.16","1007767.39","51918.06","Contract Extension","Decision Record","Green"],
    [391,"100106123","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","484-NYC-EN Digital TROs","2026-06-01 00:00:00","60","36+12+12","960000","1152000","50000","Open Procedure","Yes","Green"],
    [392,"77289","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Highway Equipment & Materials","498-NYC-EN Network Surveying","2026-04-01 00:00:00","60","24+24","300000","360000","75000","Further Comp Above Threshold","No","Amber"],
    [393,null,"NYH","NYH","HR","486-NYH-OO Everybody Benefits - NYH Only","2029-06-01 00:00:00","84","48+12+12+12","120000","144000","17000","Direct Award","No","Green"],
    [394,"100106656","CS Legal and Democratic Services","Elections","Stationery","493-NYC-LD Election and Annual Canvass Printing","2026-05-01 00:00:00","48","24+12+12","1600000","1920000","400000","Further Comp Above Threshold","Yes","Green"],
    [395,null,"CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","535-NYC-RS Window Glazing Surveys","2026-08-01 00:00:00",null,null,null,null,"175000","TBC","TBC","Green"],
    [396,null,"CYPS","Education & Skills","Public Transport","Outdoor Vehicle Servicing - East Barnby & Bewerley Park","2027-04-01 00:00:00","48","24+24","300000","30000","55000","Open Procedure","TBC","Green"],
    [397,"N/A","NYH","NYH","Building Construction Materials","517-NYH- OO Supply of materials and equipment","2026-11-05 00:00:00","48","12+12+12+12","668680","802417","167170","Contract Extension","No","Green"],
    [398,"TBC","CS Resources","Technology","ICT","516-NYC-RS AI Transcription Services","2026-09-01 00:00:00","25","13+12","270000","324000","135000","Contract Extension","No","Green"],
    [399,"100109317","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","520-NYC-RS Energy Performance Certificates","2028-04-01 00:00:00","36","24+12","25000","30000","8334","Direct Award","No","Green"],
    [400,null,"CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Hard FM Contracts Collateral Warranty Variation","2026-06-01 00:00:00",null,null,"171849999","206219998.8",null,"Contract Variation","No","Green"],
    [401,null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","Pensions Independent Advisor","2028-04-01 00:00:00","48",null,"80000","96000","20000","Bid","TBC","Green"],
    [402,null,"CS HR and business support","Business Support","Mail Services","Postal Services","2027-04-01 00:00:00","48","24+12+12","2800000","3360000","700000","Contract Extension","No","Green"],
    [403,"449-NYC-HA","HAS","Prevention and Service Development","Social & Community Supplies & Services","449-NYC-HA Community Equipment","2026-04-01 00:00:00","24","12+6+6","5633589.4","6760307.28","2816794.7","Contract Extension","Yes","Amber"],
    [404,null,"CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Langton Primary School - Kitchen drainage","2027-07-01 00:00:00","12","12","350000","350000","350000","TBC","TBC","Green"],
    [405,null,"CS Resources","Technology","ICT","Care Leavers App","2027-04-01 00:00:00","48","36+12","47966","57559","26196",null,"TBC","Green"],
    [406,null,"Community Development","Culture, Arts and Leisure","Domestic Goods","526-NYC-CD Own Brand Product Line for the Turkish Baths","2027-04-01 00:00:00",null,null,null,null,"50000","TBC","Yes","Green"],
    [407,null,"CYPS","Children and Families","Social & Community Care Supplies & Services - Children","528-NYC-CY Provision of Foster Care Placements (IFA)","2027-04-01 00:00:00",null,null,null,null,"10000000","Further Comp Above Threshold","Yes","Green"],
    [408,null,"CS Resources","Technology","ICT","532-NYC-RS Incident Reporting and Auditing Solution","2026-10-31 00:00:00","48","48","160000","192000","40000","Further Comp Below Threshold","TBC","Green"],
    [409,"N/A","NYH","NYH","Highway Equipment & Materials","Cold Lay Materials -NYH","2028-03-05 00:00:00","48","24+24","680000","816000","170000","TBC","No","Green"],
    [410,"103919","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Works - Construction, Repair & Maintenance","548-NYC-EN Coastal and Flood Defence Maintenance Works","2026-05-18 00:00:00","72","48 + 24","1627194.75","1952633.7","271199.12","Open Procedure","Yes","Green"],
    [411,null,"Community Development","Planning","ICT","Uniform System","2029-09-30 00:00:00","60","60","3005309","3607084",null,"Further Comp Above Threshold","Yes","Green"],
    [412,"TBC","NYH","NYH","Environmental Services","592-NYH-EN Waste Bay Spoil Removal","2026-07-20 00:00:00","48","12+12+12+12","288000","306460","76615","Further Comp Above Threshold","No","Green"],
    [413,"100109726","NYH","NYH","Vehicle Management","600-NYH-OO NYH Non-Operated Plant","2026-09-01 00:00:00","48","12+12++12+12","1600000","2000000","200000","Framework Establish","No","Green"],
    [414,null,"Community Development","Housing","Housing Management","43-NYC-RS Damp & Mould surveys/ treatment LOT 1","2026-11-03 00:00:00","24","12+12","350000","291666.67","145833.34","Contract Extension","Yes","Green"],
    [415,"71964","CS Resources","Technology","ICT","562-NYC-RS HWRC Permit & Booking","2029-04-01 00:00:00","48","36+12","27985","33582","5995","Contract Extension","No","Green"],
    [416,"TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","563-NYC-EN Waste Strategy Consultancy",null,null,null,null,null,null,"Quotation Process","TBC","Green"],
    [417,null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","763-NYC-RS Banking Services","2027-04-01 00:00:00","60","48+12+12","490000","588000","98000","Further Comp Above Threshold","Key Decision","Green"],
    [418,"100107217","Environment","Economic Development, Regeneration, Tourism and Skills","Environmental Services","551-NYC-EN North Bay Wall Phase 2 Repairs","2026-08-01 00:00:00","11","11","850000","1020000","850000","Further Comp Above Threshold","Yes","Amber"],
    [419,null,"NYH","NYH","Street & Traffic Management","Retexturing and Road Markings- Area 1 & 6","2027-01-01 00:00:00","12","12 +12 + 12+ 12","400000","480000","400000","Contract Extension","No","Green"],
    [420,"69437","CS Resources","Property, Procurement and Commercial","Utilities","Scarborough Gas Contract","2027-04-01 00:00:00","60","60","8500000","8500000",null,null,null,"Green"],
    [421,"76966","CS Resources","Technology","ICT","587-NYC-RS Committee and Decisions Management eDemocracy System","2028-02-01 00:00:00","36","24+12","65994","79192.8","21998","Contract Extension","Decision Record","Green"],
    [422,"71129","CS Resources","Property, Procurement and Commercial","Utilities","Gas Contract - Richmonshire","2027-04-01 00:00:00","12","12","500000","500000","500000","TBC","TBC","Green"],
    [423,"68830","Community Development","Housing","Housing Management","Supply Agreement for Supply of Products under the Stairlift, Lifting Equipment and Property Adaptions Framework Lot 1.2","2027-04-01 00:00:00",null,null,"120000","144000","120000","Further Comp Below Threshold","No","Green"],
    [424,"100106653","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Highway Equipment & Materials","579-NYC-EN Scarborough Traffic Signals Upgrade - Interim Schemes","2026-09-01 00:00:00","7","7","500000","600000","500000","Further Comp Below Threshold","No","Green"],
    [425,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","654-NYC-EN Traffic Signals Framework","2027-01-04 00:00:00","48","24+24","4000000","4000000","1000000","Framework Establish","Yes","Green"],
    [426,"78952","NYH","NYH","Works - Construction, Repair & Maintenance","NYH - Spray Injection - Pot Hole Repairs","2026-11-01 00:00:00","48","24 + 12 + 12","1800000","2160000","400000","Contract Extension","No","Green"],
    [427,"TBC","NYH","NYH","Street & Traffic Management","601-NYH-EN Gully Waste","2027-01-01 00:00:00","48","24 + 24","780000","936000","195000","Open Procedure","No","Green"],
    [428,"TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","LEVI - Renewables Contractor for 70 EVCPs- Installs","2026-12-01 00:00:00","12","12","1500000","1800000",null,"Open Procedure","Yes","Green"],
    [429,null,"CS Resources","Technology","ICT","Microsoft Licencing Solution Partner","2028-06-01 00:00:00","42","36+6","15417500","18501000","3840691.72","Further Comp Above Threshold","Yes","Green"],
    [430,"104372","CS Resources","Technology","ICT","588-NYC-RS Housing Management System","2027-08-01 00:00:00","120","60+60","3750000","4500000","350000","Further Comp Above Threshold","Yes","Green"],
    [431,null,"Community Development","Culture, Arts and Leisure","Arts & Leisure Services","Hire and Operation of Scarborough Open Air Theatre","2030-04-01 00:00:00",null,null,null,null,"65620","TBC","Yes","Green"],
    [432,"TBC","CS Resources","Property, Procurement and Commercial","ICT","781-NYC-RS - Financial Health Tool","2026-11-22 00:00:00","60","12+12+12+24","47480","59976","14616","TBC","Decision Record","Green"],
    [433,"TBC","CS Resources","Technology","ICT","589-NYC-RS Offsite Back-up (NYES)","2027-04-01 00:00:00","36","24+12","180000","216000","60000","Further Comp Above Threshold","Decision Record","Green"],
    [434,"100106580","Community Development","Housing","Housing Management","602-NYC-CD DFG Lifting Equipment","2026-09-01 00:00:00","48","24+24","6000000","6000000","750000","Open Procedure","Yes","Amber"],
    [435,null,"CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Materials Supply for Remedial Works - East & West","2026-01-01 00:00:00","24","12+12",null,null,null,"Further Comp Below Threshold","TBC","Green"],
    [436,"TBC","NYH","NYH","Financial Services","590-NYH-OO External Audit Services (NYH)","2027-01-01 00:00:00","48","36+12","146000","175200","36500","Further Comp Below Threshold","No","Green"],
    [437,null,"Community Development","Housing","Consultancy","Consultancy Support - Regulator of Social Housing/ NYC Housing Support","2025-08-20 00:00:00","36","12+12+12","135000","162000","90000","Contract Extension","Decision Record","Green"],
    [438,null,"CS Resources","Technology","ICT","Traded Service Online Communications Platform","2027-04-01 00:00:00","60","36+12+12","79000","94800","15800","Best Value","Decision Record","Green"],
    [439,"101936","HAS","Adult Social Care","Social & Community Care Supplies & Services - Adults","569-NYC-HA Assistive Technology Managed Service","2028-07-24 00:00:00","48","36+12","8500000","10200000","1730068.95","Contract Extension","Yes","Green"],
    [440,"105647","Community Development","Culture, Arts and Leisure","Clothing","596-NYC-CD Purchase of Linen for the Turkish Baths","2026-09-01 00:00:00","84","36+24+24","166666","200000","24000","Open Procedure","Decision Record","Green"],
    [441,null,"Community Development","Culture, Arts and Leisure","Arts & Leisure Services","271-NYC-CD Ticketing System","2026-04-01 00:00:00",null,null,"172000","206400","43000","Contract Variation","TBC","Green"],
    [442,null,"NYH","NYH","Environmental Services","NYH - Arboricultural Services","2025-12-01 00:00:00","48","12+12+12+12","1120000","1344000","280000","Further Comp Above Threshold","No","Green"],
    [443,"TBC","NYH","NYH","Vehicle Management","717-NYH-EN - Operated Street Sweepers","2026-05-01 00:00:00","12","12+12+12+12","560000","672000","140000","Further Comp Above Threshold","No","Green"],
    [444,null,"NYH","NYH","Highway Equipment & Materials","NYH - Salt Replenishment (Bins & Heaps)","2026-11-01 00:00:00","36","12+12+12","320000","384000","80000","Further Comp Below Threshold","No","Green"],
    [445,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","636-NYC-EN Jacksons Lane","2026-11-01 00:00:00","12","12","717000","860400",null,"Further Comp Above Threshold","Yes","Green"],
    [446,"94371","NYH","NYH","Horticulture","565-NYH-00 Rural Grass Cutting - NYH -Lots 2-7","2027-05-01 00:00:00","41","17+12+12","196108.77","235330.53","65369.59","Contract Extension","No","Green"],
    [447,"TBC","CS Resources","Property, Procurement and Commercial","Catering","194-NYC-RS-3 Provision of Alcohol",null,"60","36+12+12","2100000","2520000","420000","Further Comp Above Threshold","Yes","Green"],
    [448,"100107746","Community Development","Culture, Arts and Leisure","Catering","194-NYC-RS-6  Local Produce","2026-11-09 00:00:00","12","12","170000","204000","170000","Framework Establish","Decision Record","Green"],
    [449,null,"CS Resources","Property, Procurement and Commercial","Facilities & Management Services","609-NYC-RS Estates Rates Appeals","2025-12-12 00:00:00","16","16","67519.24","81023.09","67519.24","Direct Award","No","Green"],
    [450,"TBC","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","612-NYC_RS Block Management","2027-01-01 00:00:00",null,null,null,null,null,"TBC","TBC","Green"],
    [451,"TBC","Community Development","Housing","Housing Management","615-NYC-CD Homeless Accommodation","2026-09-01 00:00:00","12","12",null,"2500000",null,"Waiver","No","Green"],
    [452,null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","623-NYC-RS Cash Collection","2027-02-01 00:00:00","60","24","160000","192000","80000","Direct Award","TBC","Green"],
    [453,"N/a","NYH","NYH","Street & Traffic Management","NYH- Non-Operated Plant Hire Services- Telehandlers","2026-11-01 00:00:00","36","12+12+12","200000",null,"75000","Further Comp Above Threshold","No","Green"],
    [454,null,"NYNET",null,null,"NYNET Contracts Review","2026-02-01 00:00:00",null,null,null,null,null,null,null,"Green"],
    [455,null,"NYH","NYH","Street & Traffic Management","NYH-Paving & Cold Milling Equipment","2026-07-01 00:00:00","12","12",null,null,null,"Further Comp Below Threshold","No","Green"],
    [456,"N/a","NYH","NYH","Street & Traffic Management","659-NYH-OO  Structural & Electrical Testing of Steel Lamp Posts in NYC","2026-04-01 00:00:00","12","12","164080","205100","100000","Further Comp Below Threshold","No","Green"],
    [457,"100109406","NYH","NYH","Street & Traffic Management","689-NYH-OO-Highway Maintenance Gangs & Other Operatives","2026-10-01 00:00:00","48","24+12+12","3835043","4602051.42","958760.75","Further Comp Above Threshold","No","Green"],
    [458,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","620-NYC-EN MTE Cameras",null,"60","36+12+12","1000000","1200000","200000","Open Procedure","Yes","Green"],
    [459,null,"HAS","Prevention and Service Development","Works - Construction, Repair & Maintenance","618-NYC-HA Extra Care Scheme - Cardale Park, Harrogate",null,null,null,null,null,null,"Open Procedure","Yes","Green"],
    [460,null,"HAS","Prevention and Service Development","Works - Construction, Repair & Maintenance","692-NYC-HA Extra Care Scheme - Whitby",null,null,null,"25000000","30000000","25000000","Open Procedure","Yes","Green"],
    [461,null,"HAS","Prevention and Service Development","Works - Construction, Repair & Maintenance","748-NYC-HA Extra Care Scheme - Bedale",null,null,null,null,null,null,"Open Procedure","Yes","Green"],
    [462,"100107309","HAS","Prevention and Service Development","Works - Construction, Repair & Maintenance","693-NYC-HA Extra Care Scheme - Malton",null,null,null,"25000000","30000000","25000000","Open Procedure","Yes","Green"],
    [463,null,"HAS","Prevention and Service Development","Works - Construction, Repair & Maintenance","619-NYC-HA Extra Care Scheme - Eshton Road, Gargrave",null,null,null,null,null,null,"Competitive Flexible Procedure","Yes","Green"],
    [464,"92156","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","307-NYC-HA Care at Esk Moors Lodge","2025-10-01 00:00:00","96","48+24+24","1342525","1342525","175000","Contract Variation",null,"Green"],
    [465,"TBC","Community Development","Planning","Environmental Services","625-NYC-CD Statutory Advertising","2025-11-01 00:00:00","36","24+12",null,null,null,"Best Value","Yes","Green"],
    [466,"N/A","NYH","NYH","Street & Traffic Management","NYH DPS - Paving and Milling Lot Bs","2026-09-15 00:00:00","48","12+12+12+12","4000000","4800000","1000000","Contract Extension","No","Green"],
    [467,"N/A","NYH","NYH","Street & Traffic Management","NYH DPS - Street Lighting","2026-09-15 00:00:00","48","12+12+12+12","3200000","3840000","800000","Contract Extension","No","Green"],
    [468,"N/A","NYH","NYH","Street & Traffic Management","NYH DPS - Gully Tankers","2026-09-15 00:00:00","48","12+12+12+12","2000000","2400000","500000","Contract Extension","No","Green"],
    [469,"TBC","CS Resources","Technology","ICT","626-NYC-RS Audio Visual Equipment","2026-06-01 00:00:00","36","24+12","207000","248400","69000","Further Comp Above Threshold","Decision Record","Amber"],
    [470,"N/a","NYH","NYH","Vehicle Management","629-NYH-OO   Gritters x22 various","2026-05-01 00:00:00","84",null,"2500000","3000000","360000","Further Comp Above Threshold","No","Green"],
    [471,null,"CS Resources","Technology","ICT","Gazetteer Management System","2029-04-01 00:00:00","40","40","89300","107160","28000","Direct Award","Decision Record","Green"],
    [472,null,"NYH","Highways, Transportation, Parking Services, Parks and Grounds","Highway Equipment & Materials","Traffic Management","2027-04-01 00:00:00","36","12+12 + 12",null,null,"1600000","Further Comp Below Threshold",null,"Green"],
    [473,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","712-NYC-EN Swing Bridge Maintenance - Expiry 2030","2026-09-02 00:00:00","48","48","400000","480000","100000","Open Procedure","Yes","Green"],
    [474,"100106788","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","652-NYC-RS-Fuel Management System and Fuel Pumps inc NYH","2026-07-01 00:00:00","12","12","199500","239400","199500","Further Comp Below Threshold","TBC","Green"],
    [475,"104481","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","627-NYC-RS Open Framework - Works","2027-03-01 00:00:00","96","4 + 2 + 2","726000000","871000000","90750000","Open Framework Establish","Yes","Amber"],
    [476,null,"Community Development","Economic Development, Regeneration, Tourism and Skills","Works - Construction, Repair & Maintenance","817-NYC-RS Scarborough Station Gateway - Phase 2","2027-03-01 00:00:00","12","12","5430139","6516166.8","5430139","Further Comp Above Threshold","TBC","Green"],
    [477,"100109577","Community Development","Planning","Consultancy","675- NYC-CD Open Space Needs Assessment","2026-06-01 00:00:00",null,null,"100000","120000","100000","Further Comp Below Threshold","TBC","Green"],
    [478,null,"CS Resources","Property, Procurement and Commercial","Facilities & Management Services","646-NYC-RS Gritting","2026-10-01 00:00:00","38","36+2",null,null,null,"Further Comp Below Threshold","No","Green"],
    [479,"100106338","Community Development","Culture, Arts and Leisure","Works - Construction, Repair & Maintenance","640-NYC-CD- HCC- Royal Hall Lighting Refurbishment","2026-06-26 00:00:00","12","12","350000","350000","350000","Open Procedure","Yes","Green"],
    [480,null,"Community Development","Culture, Arts and Leisure","Arts & Leisure Services","50-NYC-CD Northallerton Station Improvement Project","2026-06-01 00:00:00",null,null,"100000",null,null,"Bid","No","Green"],
    [481,null,"NYH","NYH","HR","486-NYH-OO Childcare Vouchers","2029-07-01 00:00:00","48","48","1500","1800","375","Direct Award","No","Green"],
    [482,null,"CS Resources","Property, Procurement and Commercial","Utilities","NYC-RS Purchase of Power (Electricity) for corporate, schools and streetlighting from 2028","2026-09-01 00:00:00","24",null,"101161888","121394266","25290472","Contract Extension","Yes","Green"],
    [483,"105485","NYH","NYH","Works - Construction, Repair & Maintenance","688-NYH-CD A30003 Tender Package 5 Area 3 Scarborough Footway Special and R&R Huntriss (combined) Repaving part of precinct","2026-01-23 00:00:00","4","4","644800","773760","773760","Further Comp Below Threshold","No","Green"],
    [484,null,"CYPS","Education & Skills","Works - Construction, Repair & Maintenance","Killinghall Primary School -Flood Defence Works","2026-07-01 00:00:00","12","12",null,null,null,"TBC","Yes","Green"],
    [485,"100109092","Community Development","Housing","Housing Management","733-NYC-CD-Auditing Services - Housing Compliance - Asbestos, DSEAR, FRA, EICR, and Legionella","2026-08-01 00:00:00","36","12+12+12","1620946.74","1945136.09","540315.58","Further Comp Above Threshold","Yes","Green"],
    [486,"TBC","Community Development","Housing","Housing Management","658-NYC-CD Legionella Monitoring and Remedial - Expiry 2030","2026-09-10 00:00:00","48","24+12+12","170358","204429.6","32000","Open Procedure","No","Green"],
    [487,null,"HAS","Prevention and Service Development","Social & Community Supplies & Services","648-NYC-HA Light Touch Framework for Adult Social Care","2027-11-01 00:00:00",null,null,null,null,null,"TBC","Yes","Green"],
    [488,null,"CS Resources","Technology","ICT","676-NYC-RS PC Booking System","2026-10-01 00:00:00","48",null,"60000","72000","15000","Direct Award","TBC","Green"],
    [489,null,"CS HR and business support","Culture, Arts and Leisure","Facilities & Management Services","External Venues Booking","2028-03-14 00:00:00","36",null,"702000","842400","234000","Further Comp Above Threshold","Yes","Green"],
    [490,null,"Community Development","Culture, Arts and Leisure","Healthcare","661-NYC-CD Online Health","2026-08-24 00:00:00","60","36+24","3600000","4320000","720000","Provider Selection Regime","Yes","Amber"],
    [491,"100106806","Community Development","Culture, Arts and Leisure","Arts & Leisure Services","662-NYC-CD Virtual and In-Person Fitness Classes","2027-04-01 00:00:00","60","12 + 24 + 24",null,null,"120000","Open Procedure","Yes","Amber"],
    [492,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","Provision of Waste Services - Variation","2026-04-01 00:00:00","60","60","182500000","182500000",null,"Contract Variation","No","Green"],
    [493,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Vehicle Management","Short Term Lease Hire",null,null,null,null,null,null,"Direct Award","Yes","Green"],
    [494,null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Assistive Technology for Care and Support Hubs","2028-04-01 00:00:00",null,null,null,null,null,"TBC","Yes","Green"],
    [495,null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Technology Enabled Care for Care and Support Hubs","2028-04-01 00:00:00",null,null,null,null,null,"TBC","TBC","Green"],
    [496,null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Nurse Call System for Care and Support Hubs","2028-04-01 00:00:00",null,null,null,null,null,"TBC",null,"Green"],
    [497,null,"CS Local Engagement","Economic Development, Regeneration, Tourism and Skills","Health & Safety","Scarborough CCTV","2027-09-30 00:00:00","60","36+24","300000","360000","60000","Contract Extension","No","Green"],
    [498,null,"Community Development","Culture, Arts and Leisure",null,"Scarborough Security for Events","2026-04-01 00:00:00","48","24+12+12",null,"650000","780000","Contract Extension","Key Decision","Green"],
    [499,null,"Community Development","HCC",null,"Security Services (Harrogate Convention Centre)","2026-05-01 00:00:00","72","36+12+12+12",null,"865000","1038000","Contract Extension","Decision Record","Green"],
    [500,null,"Community Development","HCC","Arts & Leisure Services","Stewarding Services at Harrogate Convention Centre","2027-04-01 00:00:00","72","36+12+12+12","235875","283050","39313","Contract Extension","Decision Record","Green"],
    [501,null,"Community Development","Housing","Housing Management","Harrogate Security Services: Lot 2 Static Guarding for Temporary Accommodation Hostels","2026-05-01 00:00:00","60","36+24","1046000","1255200","209200","Contract Extension","Decision Record","Green"],
    [502,null,"CS Resources","Property, Procurement and Commercial",null,"Pre-Packed Sandwiches and Associated Products","2026-04-01 00:00:00","60","36+24","2975000","3570000","595000","Contract Extension","Decision Record","Green"],
    [503,"TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","656-NYC-HA Supported Housing - Resettlement and Community Safety Service (RACSS)","2026-10-01 00:00:00","84","36+24+24","3911339.44","4693607.33","480390","Open Procedure","Yes","Amber"],
    [504,"N/A","Community Development","Housing","Social & Community Supplies & Services","285-NYC-CD Young Peoples Pathway - Managed Accommodation Pathway 2 (Ryedale and Craven only)","2029-02-01 00:00:00","57","33 + 12 + 12","1335941.01","1335941.01","281250.74","Contract Extension","No","Amber"],
    [505,"TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Consultancy","677-NYC-EN Phase 4 North East Coastal Monitoring Programme 2027-33  - Aerial Survey 2027, 2029 & 2031","2027-01-01 00:00:00","72","72","386446","463735.2","64407.67","Further Comp Above Threshold","TBC","Green"],
    [506,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","ICT","Pay on Entry System for Public Conveniences","2027-05-01 00:00:00",null,null,null,null,null,"Further Comp Above Threshold","TBC","Amber"],
    [507,null,"CS Resources","Technology","ICT","679-NYC-RS E-Newsletter","2026-06-30 00:00:00",null,"TBC",null,null,"13000","Further Comp Below Threshold","No","Green"],
    [508,"TBC","Community Development","Culture, Arts and Leisure","Facilities & Management Services","680-NYC-CD Site and Event Security","2026-09-01 00:00:00","72","48 + 24","13885000","16662000","1384733","Open Procedure","Yes","Amber"],
    [509,"TBC","Community Development","Housing","Facilities & Management Services","681-NYC-CD Concierge and Reception Services","2027-04-01 00:00:00","60","3+1+1","1200000","1440000","240000","Open Procedure","Key Decision","Green"],
    [510,null,"CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Miscellaneous Security Services","2026-11-01 00:00:00",null,null,null,null,null,"Open Procedure","TBC","Green"],
    [511,null,"Community Development","Housing","Consultancy","684-NYC-CD Homeless Reviews","2026-04-01 00:00:00",null,null,"15000",null,"15000","Further Comp Below Threshold",null,"Green"],
    [512,"TBC","Community Development","Housing","Social & Community Care Supplies & Services - Adults","686-NYC-CD Reducing Exclusion for Adults with Complex Housing Needs (REACH)","2026-07-01 00:00:00","12","12",null,null,null,"Provider Selection Regime",null,"Amber"],
    [513,"90556","HAS","Director of Public Health","Healthcare","299-NYC-HA Primary Care Services - Pharmacies","2025-04-01 00:00:00","60","60","7247000","8696400","1449400","Provider Selection Regime","No","Green"],
    [514,null,"Environment","Regulatory Services, Registration, Bereavement, Coroners Service","Cleaning & Janitorial","Cleaning Services at Hambleton Crematorium at Maple Park","2028-02-27 00:00:00","60",null,"77500","93000","15500","Bid","TBC","Green"],
    [515,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","ICT","Garden Waste Licences","2027-12-01 00:00:00","36","36","536250","643500","178750","Open Procedure","Yes","Green"],
    [516,null,"CS Resources","Technology","ICT","Parking Notices System","2028-11-17 00:00:00","60",null,"500000","600000","100000","Further Comp Above Threshold","Yes","Green"],
    [517,"N/a","NYH","NYH","Vehicle Management","NYH vehicle replacement programme 2026-27","2027-03-31 00:00:00","12","12","1219000","1462800","1200000","Further Comp Below Threshold","No","Green"],
    [518,"100110959","NYH","NYH","Works - Construction, Repair & Maintenance","A10040 A1 Surfacing (R&R and Patching)","2026-07-20 00:00:00","3","3","1720372","1720372","1720372","Further Comp Above Threshold","No","Green"],
    [519,null,"NYH","NYH","Works - Construction, Repair & Maintenance","A10041 - Area 1 & 2 - Landslips",null,null,null,null,null,null,"Further Comp Below Threshold","No","Green"],
    [520,"100108041","NYH","NYH","Works - Construction, Repair & Maintenance","716-NYH-OO-A20027 A2 Surfacing (R&R and Patching)","2026-04-01 00:00:00","3","3","3348618","3348618","3348618","Further Comp Above Threshold","No","Green"],
    [521,null,"NYH","NYH","Works - Construction, Repair & Maintenance","A20028 - Sutton Bank","2026-09-11 00:00:00","1","1","100000","100000","100000","Further Comp Below Threshold","No","Green"],
    [522,null,"NYH","NYH","Works - Construction, Repair & Maintenance","Drainage - Area 2","2026-09-07 00:00:00","1","1","650000","650000","650000","Further Comp Below Threshold","No","Green"],
    [523,"TBC","NYH","NYH","Works - Construction, Repair & Maintenance","718-NYH-OO - A2 - KIRKBY TO RAISDALE (carry over) Beakhills","2027-04-01 00:00:00","1","1","200000","200000","200000","Further Comp Below Threshold","No","Green"],
    [524,"100108113","NYH","NYH","Works - Construction, Repair & Maintenance","825-NYH-OO A3 Surfacing (R&R and Patching)","2026-08-01 00:00:00","4","4","2673392.13","3208070.56","2673392.13","Further Comp Below Threshold","No","Green"],
    [525,"TBC","NYH","NYH","Works - Construction, Repair & Maintenance","826-NYH-OO A3 - Landslips (Mounterbeck)","2026-10-01 00:00:00","4","4","250000","300000","250000","Further Comp Below Threshold","No","Green"],
    [526,"100108113","NYH","NYH","Works - Construction, Repair & Maintenance","825-NYH-OO A4 Surfacing (R&R and Patching)","2026-04-01 00:00:00","4","4","2382815","2859378","2382815","Further Comp Below Threshold","No","Green"],
    [527,null,"NYH","NYH","Works - Construction, Repair & Maintenance","A60027 - NYH - Landslip Area 6","2026-09-01 00:00:00","1","1","80000","80000","80000","Further Comp Below Threshold","No","Green"],
    [528,"TBC","NYH","NYH","Works - Construction, Repair & Maintenance","726-NYH-OO- A7 Surfacing (R&R and Patching)","2026-05-01 00:00:00","3","3","2293362","2293362","2293362","Further Comp Above Threshold","No","Green"],
    [529,null,"CYPS","Children and Families","Social & Community Care Supplies & Services - Children","309-NYC-CY Disabled Childrens Services APL","2027-11-01 00:00:00","84","36 + 24 + 24","8166133","8166133","1166590","Contract Extension","No","Green"],
    [530,null,"Community Development","Housing","Facilities & Management Services","695-NYC-CD Laundry Equipment, Support and Maintenance","2027-04-11 00:00:00","84","60+12+12","250000","300000","36000","Further Comp Above Threshold","Yes","Green"],
    [531,null,"CS Local Engagement","Locality Structure","Social & Community Supplies & Services","694-NYC-LE Prevention Plus","2026-10-01 00:00:00","36",null,null,null,"1200000","Grant","Yes","Green"],
    [532,null,"CYPS","Education & Skills","Works - Construction, Repair & Maintenance","709-NYC-CY Wistow Primary School Kitchen Adapt and Extension","2026-09-01 00:00:00","12",null,"350000",null,null,"TBC","Yes","Green"],
    [533,null,"CYPS","Education & Skills","Works - Construction, Repair & Maintenance","710-NYC-CY Amotherby Primary School Kitchen Adapt and Extension","2026-11-01 00:00:00","12",null,"350000",null,null,"TBC","Yes","Green"],
    [534,"77529","CS Resources","Technology","ICT","715-NYC-RS Parking Correspondence System","2026-04-01 00:00:00","36","24+12","88512","106214.4","29504","Direct Award","No","Green"],
    [535,null,"CS Resources","Property, Procurement and Commercial","ICT","822-NYC-RS BSI Subscription","2026-02-01 00:00:00",null,null,null,null,null,"Direct Award","TBC","Green"],
    [536,null,"CS Resources","Customer, Revenues and Benefits","Financial Services","821-NYC-RS Enforcement Agents and Associated Legal Services",null,null,null,"4500000",null,null,"Further Comp Above Threshold","Yes","Green"],
    [537,null,"CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Business Rates: Rating Agent","2026-06-01 00:00:00",null,null,null,null,null,null,null,"Green"],
    [538,null,"CS Resources","Property, Procurement and Commercial","Consultancy","696-NYC-RS Development Partner Agreement",null,null,null,null,null,null,null,null,"Green"],
    [539,null,"Community Development","Planning","Consultancy","708-NYC-CD Organisational “Health-Check” Consultancy (Planning)","2026-05-01 00:00:00",null,null,"100000",null,null,"Direct Award","No","Green"],
    [540,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","ICT",null,null,null,null,null,null,null,null,null,"Green"],
    [541,null,"Community Development","Housing","Works - Construction, Repair & Maintenance","736-NYC-CD Damp & Mould Cleaning and Remedial Treatment","2026-08-01 00:00:00","48","36+12","2700000","3240000","675000","Framework Establish","Yes","Green"],
    [542,"100110317","Community Development","Housing","Housing Management","711-NYC-CD Emergency Accommodation","2026-05-01 00:00:00","36","24+12","10500000","12600000","3500000","Direct Award","Yes","Green"],
    [543,"100109253","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","728-NYC-EN Wetherby Road Signals & Pedestrian Crossing Upgrades","2026-08-10 00:00:00","3","3","300000","360000","300000","Open Procedure","No","Green"],
    [544,"TBC","NYH","NYH","Works - Construction, Repair & Maintenance","729-NYH-OO High Friction Surfacing and Road Markings","2026-06-01 00:00:00","12","12","1000000",null,null,"Contract Extension","No","Green"],
    [545,"TBC","NYH","NYH","Works - Construction, Repair & Maintenance","730-NYH-OO Surface Dressing","2026-09-01 00:00:00","12","12",null,null,null,"Contract Extension","No","Green"],
    [546,"TBC","NYH","NYH","Works - Construction, Repair & Maintenance","731-NYH-OO Micro Asphalt","2026-08-11 00:00:00","12","12","4000000",null,null,"Contract Extension","No","Green"],
    [547,"N/A","NYH","NYH","Works - Construction, Repair & Maintenance","773-NYH-OO Bus Shelters","2026-08-12 00:00:00","48","12+12+12+12","160000","192000","40000","Contract Extension","No","Green"],
    [548,"N/A","NYH","NYH","Vehicle Management","774-NYH-OO Operated Excavators","2026-06-01 00:00:00","48","12+12+12+12","2100000","2520000","525000","Contract Extension","No","Green"],
    [549,null,"NYH","NYH","Street & Traffic Management","787-NYH-OO-Lanterns","2026-11-01 00:00:00","48","24+12+12","850000","1020000","212500","TBC","No","Green"],
    [550,null,"NYH","NYH","Works - Construction, Repair & Maintenance","788-NYH-OO- Drainage Reactive Maintenance","2026-09-01 00:00:00",null,null,"1700000","2040000","425000","TBC","No","Green"],
    [551,null,"NYH","NYH","Street & Traffic Management","Street Lighting Electrical Equipment Ancillary Electrical Equipment","2026-12-01 00:00:00",null,null,"2000000",null,null,"TBC","No","Green"],
    [552,null,"NYH","NYH","Consultancy","External Auditing Services- NYH","2027-03-01 00:00:00",null,null,"146000","175200",null,"TBC","No","Green"],
    [553,null,"NYH","NYH","Works - Construction, Repair & Maintenance","Property Reactive Maintenance- NYH","2026-12-01 00:00:00",null,null,"10000000",null,null,"TBC","No","Green"],
    [554,null,"NYH","NYH","Environmental Services","Weeds- NYH","2027-04-01 00:00:00",null,null,"1000000",null,null,"TBC","No","Green"],
    [555,null,"Community Development","Planning","ICT","207-NYC-RS Uniform System","2024-09-30 00:00:00","60","60","2763847.49","3316616.99",null,"Contract Variation","TBC","Green"],
    [556,"90323","CS Resources","Customer, Revenues and Benefits","Social & Community Care Supplies & Services - Adults","311-NYC-HA Provision of a North Yorkshire Information, Advice and Guidance Service","2025-04-01 00:00:00","72","2+2+2","4732811","4732811","676115","Contract Variation",null,"Green"],
    [557,null,"CS Local Engagement","Locality Structure","Social & Community Supplies & Services","719-NYC-LE Grant Management and Distribution Framework","2026-10-01 00:00:00","96","3+3+2","1666666.67","2000000","208333.33","Open Framework Establish","Yes","Green"],
    [558,"N/A","Community Development","Housing","Social & Community Care Supplies & Services - Adults","333-NYC-CD Technology Enabled Care Services including Call Monitoring","2025-09-26 00:00:00","48","24+12+12","1035286","1242343","180000","Contract Variation","No","Green"],
    [559,"102024","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","469-NYC-RS Electrical Safety Framework","2026-04-01 00:00:00",null,"48","9988000","13000000","1544000","Contract Variation","No","Green"],
    [560,"74168","CS Resources","Technology","ICT","182-NYC-RS Project Portfolio Management and Resource System","2031-04-01 00:00:00","88","40+24+24","625000","750000","55000","Contract Extension","TBC","Green"],
    [561,"74168","CS Resources","Technology","ICT","Project Portfolio Management and Resource System","2033-04-01 00:00:00","88","40+24+24","625000","750000","55000","Open Procedure","Yes","Green"],
    [562,null,"CS Resources","Technology","ICT","HWRC Permit & Booking","2030-04-01 00:00:00","48","36+12","27985","33582","5995","Further Comp Below Threshold","TBC","Green"],
    [563,"71964","CS HR and business support","Human Resources","HR","130-NYC-CX Employee Assistance Programme","2030-04-01 00:00:00","60","36+12+12","332500","399000","66500","Contract Extension","TBC","Green"],
    [564,null,"CS HR and business support","Human Resources","HR","Employee Assistance Programme","2031-04-01 00:00:00","60","36+12+12","332500","399000","66500","Further Comp Above Threshold",null,"Green"],
    [565,null,"CS Local Engagement","Economic Development, Regeneration, Tourism and Skills","Health & Safety","Harrogate Radiolink","2023-04-01 00:00:00","60","36+24",null,null,null,"Contract Extension","No","Green"],
    [566,null,"Community Development","Culture, Arts and Leisure","Arts & Leisure Services","Delivery of Cultural Grants","2028-09-01 00:00:00",null,null,null,null,"175000","Grant",null,"Green"],
    [567,null,"NYH","NYH","HR","Specialist Training for NY Highways","2028-01-01 00:00:00","60",null,"850000","1020000","170000","Open Procedure","TBC","Green"],
    [568,null,"CS HR and business support","Human Resources","ICT","HR Recruitment Main Admin System","2030-01-05 00:00:00","48",null,"325048.75","390058.5","80653","TBC","TBC","Green"],
    [569,"N/a","NYNET","NYNET","Vehicle Management","732-NYN-OO -NYNET - Vehicle Purchases 5 x Vans","2026-06-01 00:00:00",null,null,"100000","120000",null,"Further Comp Below Threshold","No","Green"],
    [570,null,"CS Resources","Technology","ICT","807-NYC-RS VCSE Grant System","2027-04-30 00:00:00","48",null,"200000","240000","50000","TBC","Yes","Green"],
    [571,null,"CYPS","Children and Families","ICT","744-NYC-CY EasyPeasy App","2026-06-01 00:00:00","36","36","151000","181200","50000","Waiver","Decision Record","Green"],
    [572,"TBC","CYPS","Education & Skills","ICT","Online CPD Portal for HLE","2027-04-01 00:00:00","12","12",null,null,null,"Quotation Process","TBC","Green"],
    [573,"56916","CS Resources","Technology","ICT","739-NYC-RS Choice Based Letting System","2026-06-01 00:00:00","36","24+12","300000","360000","77000","Contract Extension","Decision Record","Green"],
    [574,"N/A","CS Resources","Technology","ICT","740-NYC-RS IT Hardware Partner (Education) & (Corporate)",null,"60","24+24+12","5399000","6478800","1079800","Contract Variation","TBC","Green"],
    [575,"100109664","CS Local Engagement","Locality Structure","Social & Community Supplies & Services","720-NYC-LE Community Management Support","2026-06-01 00:00:00","36","12+12+12","466170","559404","155390","Bid","Yes","Green"],
    [576,"TBC","Community Development","Housing","Social & Community Supplies & Services","722-NYC-CD Provision of Emergency Accommodation","2027-04-01 00:00:00",null,null,null,null,null,"Framework Establish","Yes","Green"],
    [577,"TBC","Community Development","Housing","Social & Community Supplies & Services","721-NYC-CD Provision of Temporary Accommodation","2027-04-01 00:00:00",null,null,null,null,null,"Framework Establish","Yes","Green"],
    [578,null,"Community Development","HCC","Street & Traffic Management","808-NYC-CD HCC Event Traffic Management","2026-07-01 00:00:00","48","24+12+12","800000","960000","200000","TBC","Yes","Green"],
    [579,null,"CS Resources","Technology","ICT","Digital EHCPs","2030-01-05 00:00:00","48",null,"222800","367360","50000","Further Comp Above Threshold","TBC","Green"],
    [580,"TBC","HAS","Director of Public Health",null,"735-NYC-CA Selby and Scarborough Community Health and Wellbeing Project","2026-05-31 00:00:00","24","24","250000","250000","125000","Grant","No","Green"],
    [581,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","Technical and Planning Advisor (AWRP)","2030-05-01 00:00:00","48","36+12","400000","480000","100000","Further Comp Above Threshold","Decision Record","Green"],
    [582,null,"CS Resources","Finance (inc. Pension Fund)","ICT","Supply and Implementation of a Financial Management System, Including Ongoing Hosting, Support, and Maintenance","2026-04-01 00:00:00","120","60+60","8400000","10080000","600000","Contract Variation","No","Green"],
    [583,null,"Community Development","Regulatory Services, Registration, Bereavement, Coroners Service","Cemetery & Crematorium","771-NYC-RS- Cremators and Associated Elements","2026-10-01 00:00:00",null,null,"600000","720000","600000","TBC","Yes","Green"],
    [584,"TBC","Community Development","HCC","Works - Construction, Repair & Maintenance","772-NYC-RS- M&E - Replacement of Chiller Units","2026-09-01 00:00:00",null,"TBC","800000","960000","800000","TBC","Yes","Green"],
    [585,"TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","Technical and Planning Advisor for Allerton Waste Recovery Park Public-Private Partnership","2026-06-01 00:00:00","12","12","502000","602400","83666","Contract Variation","No","Green"],
    [586,"100109132","Community Development","Culture, Arts and Leisure","Arts & Leisure Services","775-NYC-CD Beach Lifeguard Services","2027-01-01 00:00:00","120","60 + 60","3682621.92","4419146.3","201484.97","Direct Award","Yes","Green"],
    [587,null,"Community Development","Housing","Housing Management","Contract 4- ASHP Servicing, Repairs and Maintenance","2025-01-29 00:00:00","56","24+24+12","3000000","3600000","100000","Contract Extension","TBC","Green"],
    [588,null,"Community Development","Housing","Housing Management","Contract 5 - Ground Source Heat Pumps Repairs and Maintenance",null,"56","24+24+12","416665","499998","83333","Contract Extension","TBC","Green"],
    [589,"67857, 67858, 67859, 67861","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","NYH/NYC Gritter Lease Extension- Lease Ref: P002358212 & Lease Ref: AD5M000352","2027-01-06 00:00:00","120","84+12+12+12","2082364.59","2498839.51","701.13","Contract Extension","No","Green"],
    [590,null,"NYNET","NYNET","ICT","750-NYN-OO Internal Audit","2026-05-01 00:00:00",null,null,null,null,"9000","Direct Award","No","Green"],
    [591,null,"CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","751-NYC-HA Scarborough Care and Support Hub","2027-04-01 00:00:00",null,null,"12000000","14400000",null,"Competitive Flexible Procedure","Yes","Green"],
    [592,null,"Community Development","Housing","Works - Construction, Repair & Maintenance","789-NYC-CD - Service, Repair, and Maintenance of Passenger Lifts, Stair Lifts and Through Floor Lifts.","2026-12-01 00:00:00","48","24 +12+12","600000","600000","150000","Further Comp Above Threshold","No","Green"],
    [593,"TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Children","753-NYC-CY Technology Enabled Care",null,null,null,null,null,null,"TBC","TBC","Green"],
    [594,"51509","HAS","Director of Public Health","Domestic Goods","439-NYC-HA Vouchers for the supply of e-cigarettes and associated products","2026-07-03 00:00:00","38","24+12+2","86197.88","100189.88",null,"Contract Extension","No","Green"],
    [595,"83891","CS HR and business support","Human Resources","HR","435-NYC-CX Approved Provider List (APL) - Training","2024-02-01 00:00:00","60","36+12+12","48000000","57600000","9600000","Contract Variation","No","Green"],
    [596,"TBC","CS Resources","Property, Procurement and Commercial","Furniture & Soft Furnishings","754-NYC-RS Skipton Town Hall: Library Provision",null,null,null,null,null,null,"Further Comp Above Threshold","TBC","Green"],
    [597,null,"CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","755-NYC-RS Filey Brigg Glamping Pods",null,null,null,null,"1100000",null,null,null,"Green"],
    [598,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","Modification of Green Waste Framework","2026-05-07 00:00:00",null,null,null,null,"118000","Contract Novation","No","Green"],
    [599,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","Re-procurement of a 3rd party MRF for the processing of dry mixed recycling from the Craven area","2027-05-01 00:00:00","48","24+12+12","200000","240000","50000","TBC","No","Green"],
    [600,"TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","764-NYC-EN Independent Technical Advisor","2026-04-13 00:00:00","12","12","10000","12000","10000","Contract Variation","No","Green"],
    [601,null,"CS Resources","Technology","ICT","766-NYC-RS POS Systems","2026-07-01 00:00:00",null,null,null,null,"38000","Direct Award","No","Green"],
    [602,null,"CS Resources","Property, Procurement and Commercial","Cleaning & Janitorial","Electrical Cleaning Machinery","2027-04-01 00:00:00",null,null,null,null,"90000","Further Comp Above Threshold","TBC","Green"],
    [603,null,"CS Resources","Technology","ICT","809-NYC-RS Cleaning and Caretaking Time Recording System",null,null,null,null,null,null,"Further Comp Above Threshold","TBC","Green"],
    [604,null,"CS Resources","Property, Procurement and Commercial","Consultancy","791-NYC-RS Estates Management Professional Services","2026-09-01 00:00:00","60",null,null,null,null,"Contract Termination","TBC","Green"],
    [605,"77623","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","469-NYC-RS Electrical Safety Framework","2026-02-01 00:00:00","48","48","9988000","13000000","1544000","Contract Variation",null,"Green"],
    [606,null,"Environment","Regulatory Services, Registration, Bereavement, Coroners Service","Environmental Services","767-NYC-EN Private Water Supply Sampling and Testing","2027-05-01 00:00:00","96","3+2+2",null,null,null,"TBC","TBC","Green"],
    [607,null,"CS Resources","Property, Procurement and Commercial","Catering","Innovative Catering","2028-02-01 00:00:00","24","12+12","131248.44","157598.13","65624.22","Further Comp Below Threshold","Decision Record","Green"],
    [608,null,"CS Resources","Technology","ICT","Telephony - Single Phone Number IVR Phase 2","2029-04-01 00:00:00","60","36+12+12","948773.75","1138528.5","189755","Contract Extension","TBC","Green"],
    [609,null,"CS Resources","Technology","ICT","Telephony - Single Phone Number IVR Phase 2","2030-04-01 00:00:00","60","36+12+12","948773.75","1138528.5","189755","Contract Extension","TBC","Green"],
    [610,null,"CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","777-NYC-EN Royal Parade","2027-11-01 00:00:00",null,null,"960000","1500000","960000","TBC","Yes","Green"],
    [611,null,"CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Scarborough Station Gateway -Phase 3",null,null,null,null,null,null,null,null,"Green"],
    [612,null,"Community Development","Culture, Arts and Leisure","Works - Construction, Repair & Maintenance","Whitby LWH - Site 3- Leisure Investment Strategy",null,null,null,"9700000",null,null,"Further Comp Above Threshold","Yes","Green"],
    [613,null,"Community Development","Culture, Arts and Leisure","Works - Construction, Repair & Maintenance","Skipton LWH -  Site 2- Leisure Investment Strategy","2027-07-01 00:00:00","12",null,"9900000","11880000","9900000","Further Comp Above Threshold","Yes","Green"],
    [614,null,"Community Development","Culture, Arts and Leisure","Works - Construction, Repair & Maintenance","Selby LWH - Site 1- Leisure Investment Strategy","2027-07-01 00:00:00",null,"12","2500000","3000000","2500000","Further Comp Above Threshold","Yes","Green"],
    [615,null,"Community Development","Culture, Arts and Leisure","Works - Construction, Repair & Maintenance","Ryedale LWH - Site 4- leisure Investment Strategy",null,null,null,"10200000",null,null,"Further Comp Above Threshold","Yes","Green"],
    [616,null,"Community Development","Culture, Arts and Leisure","Stationery","22-150 Supply and Service of Library Books Lot 1 and Lot 2","2026-08-01 00:00:00","60","36+12+12",null,null,"475000","Contract Extension","TBC","Green"],
    [617,null,"CS Resources","Property, Procurement and Commercial","Health & Safety","Asbestos Surveys","2026-12-01 00:00:00","48","48","120000","144000","30000","Contract Termination","No","Green"],
    [618,null,"NYH","NYH","Works - Construction, Repair & Maintenance","NPIF Carry Over- Area 6","2026-11-01 00:00:00","3","3",null,null,null,"Further Comp Below Threshold","No","Green"],
    [619,null,"NYH","NYH","Works - Construction, Repair & Maintenance","Area 6-\tTraffic Calming -20mph","2026-11-01 00:00:00","3","3",null,null,null,"Further Comp Below Threshold","No","Green"],
    [620,null,"HAS","Director of Public Health","Healthcare","776-NYC-HA Public Health Medicines Optimisation Service","2026-07-01 00:00:00","12","12",null,null,null,"Provider Selection Regime",null,"Green"],
    [621,"100109132","Community Development","Culture, Arts and Leisure","Arts & Leisure Services","452-NYC-CD Beach Lifeguard Services","2009-05-22 00:00:00","211","55 initial term then a rolling contract","33179.88","1410064.49","2300000","Contract Termination","No","Green"],
    [622,null,"Community Development","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours",null,"Dredger Skippers","2027-01-01 00:00:00",null,null,null,null,"200000","Open Procedure","TBC","Green"],
    [623,null,"Central Services","Business Support","ICT","Corporate Business Travel","2030-04-01 00:00:00","48",null,"2104000","2524800","525000","Further Comp Above Threshold","Yes","Green"],
    [624,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","84-NYC-EN Flood Defences","2026-07-01 00:00:00","12","12",null,null,null,"Direct Award","No","Green"],
    [625,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","Consultancy","810-NYC-EN Lane Rental Consultancy","2026-06-01 00:00:00",null,null,null,null,null,"Direct Award","TBC","Green"],
    [626,null,"Community Development","Housing","Facilities & Management Services","811-NYC-CD Window Cleaning (Housing)","2026-10-01 00:00:00","72",null,"199998","239997.6","33333","Further Comp Above Threshold","TBC","Green"],
    [627,null,"Community Development","Housing","Facilities & Management Services","812-NYC-CD Removals and Storage (Housing)","2026-11-01 00:00:00","60","36+12+12","300000","360000","60000","Further Comp Above Threshold","TBC","Green"],
    [628,null,"Community Development","Housing","Facilities & Management Services","813-NYC-CD EPCs for Housing","2026-11-01 00:00:00","36",null,"600000","720000","200000","Further Comp Above Threshold","TBC","Green"],
    [629,null,"Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Arts & Leisure Services","eBooks","2027-04-22 00:00:00","60","36+24","750000","900000","150000","Open Procedure","Yes","Green"],
    [630,null,"CS Resources","Technology","ICT","814-NYC-RS Recruitment Admin System","2026-08-05 00:00:00",null,null,null,null,null,"Contract Extension","TBC","Green"],
    [631,null,"Community Development","Planning","Consultancy","815-NYC-CD Joint Minerals and Waste Plan","2026-10-01 00:00:00",null,null,null,null,null,"Direct Award","TBC","Green"],
    [632,null,"NYH","Highways, Transportation, Parking Services, Parks and Grounds","Highway Equipment & Materials","565-NYH-00 Urban & Rural Grass Cutting","2026-05-01 00:00:00",null,null,null,null,null,"Contract Novation","No","Green"],
    [633,null,"CS Resources","Technology","ICT","Elections Management System","2029-09-01 00:00:00",null,null,null,null,"144000","Further Comp Above Threshold","TBC","Green"],
    [634,null,"Community Development","Housing","Works - Construction, Repair & Maintenance","Cyclical Painting Programme for Housing","2027-01-01 00:00:00","72","24+24+24","416666.67","500000","84000","Open Procedure","Yes","Green"],
    [635,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Street & Traffic Management","Depot Charging Scheme-  for the installation of EVCPS at depots","2027-01-25 00:00:00","9","9","800000","1000000","800000","TBC","Yes","Green"],
    [636,null,"CS Local Engagement","Policy, Performance, Refugee / Asylum Issues and Community Safety","Social & Community Care Supplies & Services - Adults","Domestic Abuse Practitioners (Housing)","2028-04-01 00:00:00",null,null,null,null,"200000","TBC","Yes","Green"],
    [637,"Lot1&2 - 67248 Lot3&4 - 35688 Tender - 48093","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","325-NYC-HA Carers Information and Advice Service","2028-07-01 00:00:00","96","36+36+24","5776000","6931200","722000","Contract Variation","TBC","Green"],
    [638,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","ICT","Dashcams",null,null,null,null,null,null,"Further Comp Above Threshold","TBC","Green"],
    [639,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds",null,"Driving Licence Check System",null,null,null,null,null,null,"Direct Award","TBC","Green"],
    [640,null,"Community Development","Housing","Works - Construction, Repair & Maintenance","5 Vine Street Norton - Refurbishment","2027-04-28 00:00:00","3","3","170000","204000","170000","TBC","Yes","Green"],
    [641,null,"Community Development","Housing","Works - Construction, Repair & Maintenance","Princess Road, Malton",null,null,null,null,null,null,"TBC","Yes","Green"],
    [642,null,"Community Development","Housing","Works - Construction, Repair & Maintenance","82 Castlegate, Malton",null,null,null,"2780000",null,"278000","TBC","Yes","Green"],
    [643,null,"Community Development","Housing","Works - Construction, Repair & Maintenance","148 North Marine Road  (Charnwood), Scarborough","2026-10-01 00:00:00",null,null,"872575",null,"872575","TBC","Yes","Green"],
    [644,null,"Community Development","Housing","Works - Construction, Repair & Maintenance","Valley Road, Darley nr Hgate",null,null,null,"110000",null,"110000","TBC","Yes","Green"],
    [645,null,"Community Development","Housing","Works - Construction, Repair & Maintenance","West Square/Hanover Road - Scarborough",null,null,null,"1176500","1411800","1176500","TBC","Yes","Green"],
    [646,null,"CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","St Mary's Avenue,  Hemingbrough- Demolition and Rebuild","2027-06-28 00:00:00","12","12","857000","1028400","857000","Further Comp Below Threshold","Yes","Green"],
    [647,null,"CS Resources","NYH","Street & Traffic Management","657-NYH- EN Vehicle Restraint System Repair","2026-08-01 00:00:00","3","3","3000000","3600000","300000","Contract Extension","No","Green"],
    [648,null,"Community Development","Housing","Facilities & Management Services","736-NYC-CD Damp & Mould Cleaning and Remedial Treatment","2026-08-01 00:00:00","51","36+12+3","2700000","3240000","675000","Contract Extension","Yes","Green"],
    [649,null,"CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Nursery Extension",null,null,null,null,null,null,"TBC","TBC","Green"],
    [650,null,"Community Development","Highways, Transportation, Parking Services, Parks and Grounds","Sports & Playground Equipment & Maintenance","816-NYC-CD Playground Equipment","2027-01-01 00:00:00","12",null,"250000","300000",null,null,"Yes","Green"],
    [651,"DN546741","CS Resources","Technology","ICT","420-NYC-LD Legal Services Case Management","2027-04-01 00:00:00","64","24+24+12+4","163437.5","196125","23978","Contract Extension","No","Green"],
    [652,null,"Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","Business Rates Advice",null,null,null,null,null,null,"Further Comp Above Threshold","TBC","Green"],
    [653,null,"HAS","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","819-NYC-HA Hambleton Care and Support Hub",null,"16","16","14000000","15500000",null,"Further Comp Above Threshold","Yes","Green"],
    [654,null,"HAS","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","820-NYC-HA Selby Care and Support Hub",null,"16","16","14000000","15500000",null,"Further Comp Above Threshold","Yes","Green"],
    [655,null,"CS Resources","Technology","ICT","Leisure Management System","2026-04-20 00:00:00","88","40+24+24","2166666","2600000","309000","Contract Variation","TBC","Green"],
    [656,null,null,null,null,"Consultancy Strategy",null,null,null,null,null,null,"TBC",null,"Green"],
    [657,null,"CS Resources","Technology","ICT","193-NYC-EN Parking Notices System","2028-11-17 00:00:00","60","36+12+12","500000","600000","100000","Contract Variation","TBC","Green"],
    [658,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green"],
    [659,null,"NYH","NYH","Vehicle Management","NYH - 1 x 18t hotbox","2026-09-01 00:00:00",null,null,null,null,null,"Further Comp Below Threshold","No","Green"],
    [660,null,"CS Resources","Technology","ICT","NYNet Catterick WiFi","2026-06-01 00:00:00","5","60","393980","472776","78796","Direct Award","No","Green"],
    [661,null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","Vehicle Servicing inc NYH","2026-10-01 00:00:00","48","12+12+12+12",null,null,null,"Open Procedure","Yes","Green"],
    [662,null,"CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Neville House, Gargrave - Demolition","2026-09-01 00:00:00","3","3",null,null,null,"TBC","Yes","Green"],
    [663,null,"NYH","NYH","Works - Construction, Repair & Maintenance","Area 3 - Larpool Lane ( Danger Bank/Glen Esk)","2027-07-01 00:00:00",null,null,"326140","391368","326140","Further Comp Below Threshold","No","Green"],
    [664,null,"NYH","NYH","Works - Construction, Repair & Maintenance","Area 3 - The Delves","2026-09-01 00:00:00",null,null,"100000","120000","100000","Further Comp Below Threshold","No","Green"],
    [665,null,"NYH","NYH","Works - Construction, Repair & Maintenance","Area 3 - Lealholme Landslip","2026-08-01 00:00:00",null,null,"72000","86400","72000","Further Comp Below Threshold","No","Green"],
    [666,null,"NYH","NYH","Works - Construction, Repair & Maintenance","Area 4 - Bazeleys (Whitewall)","2026-08-01 00:00:00",null,null,"108350","130020","108350","Further Comp Below Threshold","No","Green"],
    [667,null,"NYH","NYH","Works - Construction, Repair & Maintenance","Area 4 - East Moor - Cockayne Landslip",null,null,null,null,null,null,"Further Comp Below Threshold","No","Green"],
    [668,null,"NYH","NYH","Works - Construction, Repair & Maintenance","Area 4 - Whitby Road Landslip",null,null,null,null,null,null,"Further Comp Below Threshold","No","Green"],
    [669,null,"NYH","NYH","Works - Construction, Repair & Maintenance","Area 4 - Wood House Farm",null,null,null,null,null,null,"Further Comp Below Threshold","No","Green"],
    [670,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green"],
    [671,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green"],
    [672,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green"],
    [673,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green"],
    [674,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green"],
    [675,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green"],
    [676,null,null,null,null,null,null,null,null,null,null,null,null,null,"Green"]
]}
