{
  "fields": [{"id":"_id","type":"int"},{"id":"Category","type":"text"},{"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":"Key Decision?","type":"text"},{"id":"PCMS Operational Risk Rating","type":"text"}],
  "records": [
    [1,"Place","tbc","NYH","NYH","Utilities","Highway Electrical Installations including ICP","2025-06-01 00:00:00","48","48","2800000","3360000",null,null],
    [2,"Professional","TBC","CS Resources","Property, Procurement and Commercial","Catering","Fresh Meat and Frozen Products","2026-04-01 00:00:00",null,null,null,null,"Yes",null],
    [3,"Place","TBC","NYH","NYH","Works - Construction, Repair & Maintenance","87-NYH-OO Lealholm Landslip C221 A30015","2025-09-01 00:00:00","1","1","60000","72000","No","Green"],
    [4,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Lastingham Bridge Strengthening","2026-10-01 00:00:00",null,null,"50000","60000","TBC",null],
    [5,"Place","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","Decision Record",null],
    [6,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Jack Beck Bridge Strengthening, Clapham","2026-10-01 00:00:00",null,null,"80000","96000","TBC",null],
    [7,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","402-NYC-EN Smeaton Embankment Scheme","2025-10-01 00:00:00",null,"TBC","100000","120000","Decision Record","Green"],
    [8,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Rarey Drive Bridge","2026-09-01 00:00:00","3","3","100000","120000","Decision Record",null],
    [9,"Place","90977","Community Development","Housing","Works - Construction, Repair & Maintenance","Cavendish House, Robert Street","2025-03-03 00:00:00","12","12","707126","848551","Key Decision","Green"],
    [10,"Place","89318","NYH","NYH","Works - Construction, Repair & Maintenance","A40016 In Situ Recycling","2025-03-01 00:00:00","2",null,"509000","610800",null,"Amber"],
    [11,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Selby Swing Bridge Redecking","2026-10-01 00:00:00",null,null,"1000000","1000000","Decision Record",null],
    [12,"Place","87287","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Crakehall Beck Side - Wall Rebuild","2024-07-17 00:00:00","3","3","80000","96000","Decision Record","Green"],
    [13,"Place","87358","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","West Pier Boat Lift, Scarborough Harbour - Purchase and installation","2025-04-01 00:00:00","6","6","753000","903600","Yes","Green"],
    [14,"Professional","TBC","CS Resources","Property, Procurement and Commercial","Catering","110-NYC-RS Innovative Catering","2025-09-01 00:00:00","60","36+12+12","1097814","1317377","Decision Record","Amber"],
    [15,"Place","91002","Community Development","Housing","Works - Construction, Repair & Maintenance","Extensions and development at three sites","2025-03-03 00:00:00","11","11","123074","147689","Key Decision","Green"],
    [16,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","Vehicle Restraint System Repair and Maintenance","2027-08-01 00:00:00",null,null,"1633280","1959936","TBC",null],
    [17,"Place","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-06-01 00:00:00","192",null,"26000000","26000000","Yes","Green"],
    [18,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","LEVI Pilot Fund - Renewables Contractor for 70 EVCPs","2025-04-01 00:00:00",null,null,"75000",null,"Yes","Amber"],
    [19,"Professional",null,"CS Resources","Technology","ICT","Clinical Service Platform for Community Pharmacies","2026-06-01 00:00:00","48","24+12","61575","73890","Decision Record","Amber"],
    [20,"People","N/A","HAS","Director of Public Health","Social & Community Care Supplies & Services - Adults","310-NYC-HA Falls prevention in care settings","2024-04-01 00:00:00","12",null,"104000","104000","No","Green"],
    [21,"People","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","Decision Record","Green"],
    [22,"Professional","67654","CS Resources","Finance (inc. Pension Fund)","Financial Services","Provision of North Yorkshire Council Cash Collection Service","2025-02-01 00:00:00","24","12+ 12","180000","200000","Decision Record","Green"],
    [23,"People","79644","CS HR and business support","Human Resources","HR","430-NYC-LE Interpretation Services and Translation Services: Spoken and Unspoken","2027-04-01 00:00:00","60","36 + 12 + 12","845000","1014000","Yes","Green"],
    [24,"People","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","48","2+1+1","428400","428400","Yes","Green"],
    [25,"Professional","53588","CS Resources","Property, Procurement and Commercial","Horticulture","Arboriculture services","2024-11-01 00:00:00","48","24+24","135599","162719","Decision Record","Green"],
    [26,"People","90414","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","Disabled Childrens Services APL","2024-11-01 00:00:00","84","36 + 24 + 24","8166133","8166133","Yes","Green"],
    [27,"Professional","63871 (Selby) / 64470 (Ham/Rye/Rich/Scar) / DN200600 (Harrogate)","CS Resources","Technology","Environmental Services","Waste Management Software Licenses and In Cab technology (Interim alignments)","2024-04-01 00:00:00","36","24+12","673237.5","807885","Decision Record","Green"],
    [28,"Professional","93189","CS Resources","Technology","ICT","112-NYC-RS Waste Management Software Licenses and In Cab Technology","2026-04-01 00:00:00","60","36+24","750000","900000","Yes","Green"],
    [29,"Place","TBC","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","HVAC Replacement Halls B&C Heating & Cooling units, Harrogate Convention Centre","2025-10-01 00:00:00","8","8","175000","210000","TBC",null],
    [30,"Place","TBC","Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Street & Traffic Management","Event Traffic Management supplier to Harrogate Convention Centre","2025-06-01 00:00:00","36","36","600000","720000","Decision Record","Red"],
    [31,"Professional","TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","ICT","113-NYC-RS Garden Waste Licences 2025 onwards","2025-11-24 00:00:00","60","36+12+12","718750","862500","Yes","Amber"],
    [32,"Professional","TBC","CYPS","Education & Skills","Education","114-NYC-RS Pupil and School Performance Data Analysis","2025-04-01 00:00:00","24","12+12","153000","183600","Decision Record","Green"],
    [33,"Professional","92657","CS Resources","Technology","ICT","EDRMS Support (Electronic Document and Records Management System)","2024-09-01 00:00:00","24","24","134991","161989","Decision Record","Green"],
    [34,"Professional","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","148726","178471","Decision Record","Green"],
    [35,"Professional",null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","Pension Legal Advisors","2026-08-31 00:00:00","48","24+12+12","146800","176160","No","Green"],
    [36,"Professional",null,"CS Resources","Technology","ICT","Library Management System","2028-04-01 00:00:00","84","43+24+24","276374","331649","No","Green"],
    [37,"Professional","TBC","CS Resources","Technology","ICT","115-NYC-RS Bereavement Burial and Cremation Administration","2025-04-01 00:00:00","48","36+12","148000","177600","Decision Record","Green"],
    [38,"Professional","94487","NYH","NYH",null,"119-NYH-OO Substance Misuse Testing","2025-04-01 00:00:00","48","12+12+12+12","100000","120000","Decision Record","Green"],
    [39,"Professional",null,"CS Resources","Technology","ICT","Back Office System for English National Concessionary Travel Scheme","2027-10-07 00:00:00","48","36+12","600000","720000","No","Green"],
    [40,"Professional","75766","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Public Transport","Special Educational Needs Home to School Transport - x3 schools  (Marchbank, Forest Moor and Brompton Hall)","2024-04-01 00:00:00","60","36+12+12","9266374","11119649","Yes","Green"],
    [41,"Professional","78508","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Public Transport","Local Bus Services and Mainstream Home to School Transport (Craven, Harrogate, Richmond, Ryedale and Miscellaneous) - plus additional contract extensions + Hamb LBS only","2024-04-01 00:00:00","48","48","88000000","105600000","Yes","Green"],
    [42,"Professional","TBC","CS Resources","Technology","ICT","Kofax - Document Management Centre scanning/ePost - Mail Scanning","2024-10-01 00:00:00","12","12","53694","64432","TBC",null],
    [43,"Place","87731","NYH","NYH","Works - Construction, Repair & Maintenance","AREA 1 24/25 TENDER PACKAGE 1: R&R SCHEMES (A10028)","2024-09-09 00:00:00","3","3","282400","338880","No","Green"],
    [44,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Property Level Resilience Scheme","2026-01-01 00:00:00","48","36+12","1500000","1800000","Yes",null],
    [45,"Professional","65970","CS HR and business support","Business Support","Catering","Water Coolers and Associated goods","2024-09-01 00:00:00","48","24+24","12000","24000","Decision Record","Green"],
    [46,"Professional","68207","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","122-NYC-EN Flooding Consultancy","2024-11-06 00:00:00","37","37","331495","397794","Key Decision","Green"],
    [47,"Professional","TBC","CS Resources","Technology","ICT","193-NYC-EN Parking Notices","2026-04-01 00:00:00","60","36+12+12","500000","600000","Key Decision","Amber"],
    [48,"Place","https://www.contractsfinder.service.gov.uk/Notice/6338e014-2687-4182-9b48-9a89e7862bac","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","30-NYC-RS Fire Equipment - Inspection and Supply","2025-04-01 00:00:00","84","36+24+24","1200000","1440000","Key Decision","Green"],
    [49,"Place","TBC","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","427-NYC-RS Portable Appliance Testing (PAT)","2026-02-01 00:00:00","84","36+24+24","1550788","1860946","Key Decision","Green"],
    [50,"Professional","88926","Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Consultancy","Leisure Investment Strategy Consultant","2024-09-02 00:00:00","12","12","108795","130557","Yes","Amber"],
    [51,"Professional","95041","Community Development","Planning","Consultancy","124-NYC-CD Habitats Regulations Appraisal","2025-04-01 00:00:00","12","12","150000","180000","Decision Record","Green"],
    [52,"Professional","85568","CS HR and business support","Technology","ICT","Multifunctional devices including print management services and software, desktop printers, print room equipment and duplicators","2024-10-01 00:00:00","60",null,"1250000","1500000","Yes","Green"],
    [53,"People","TBC","CS Local Engagement","Locality Structure","Social & Community Supplies & Services","455-NYC-LE External Local Authority Lottery","2026-06-01 00:00:00","60","60",null,null,"Yes","Green"],
    [54,"People","54591","HAS","Director of Public Health","Healthcare","264-NYC-HA Infection Control and Prevention","2025-07-01 00:00:00","132",null,"2028312","2028312","Yes","Green"],
    [55,"People","TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","296-NYC-HA Independent Living Skills Housing Support","2026-10-01 00:00:00",null,null,null,null,"Yes","Amber"],
    [56,"Professional",null,"CS HR and business support","Human Resources","HR","Agency Services","2026-11-01 00:00:00","48","24+24","16000000","19200000","Yes","Green"],
    [57,"People","56817","HAS","Director of Public Health","Healthcare","326-NYC-HA Sexual Health","2026-04-01 00:00:00","120","48+48+24","25252489","30302987","Yes","Amber"],
    [58,"People","49328","HAS","Adult Social Care","Social & Community Care Supplies & Services - Children","328-NYC-HA Harrogate and Rural Alliance - Section 75","2025-04-01 00:00:00","120","36+12+12+12+12+12+12+12",null,null,"Yes","Amber"],
    [59,"Professional","68398","CS Resources","Technology","ICT","201-NYC-EN Notice Parking System","2025-04-01 00:00:00","12","12","112219","134663","Decision Record","Amber"],
    [60,"Professional","TBC","CS HR and business support","Business Support","Furniture & Soft Furnishings","125-NYC-CX Supply of Office Furniture","2025-04-01 00:00:00","48","36+12","428000","513600","Yes","Amber"],
    [61,"Professional","54186","CS Resources","Technology","ICT","Survey Software","2025-10-01 00:00:00","36","12+12+12","37044","44453","No",null],
    [62,"People","48908","Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Education","327-NYC-CD E-Books / E-Audio","2025-04-22 00:00:00","60","36+24","375000","450000","Decision Record","Green"],
    [63,"People","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","Yes","Green"],
    [64,"Professional","tbc","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","Devolution Deal Net Zero Project - District Heat Network Project – Potto","2023-03-01 00:00:00","15","15","60000","72000","Decision Record",null],
    [65,"Place","Not Applicable","Community Development","Housing","Works - Construction, Repair & Maintenance","Solar Panel Annual Servicing and Maintenance","45748","48","24 + 12 + 12","320000","384000","Yes","Green"],
    [66,"Professional","tbc","NYH","NYH","Vehicle Management","Supply of Vehicle Logos and Chapter 8","2025-05-01 00:00:00","60","24+24+12","80000","87000","No","Green"],
    [67,"Place","tbc","NYH","NYH","Utilities","Propane gas bulk deliveries and static gas holding tanks","2025-07-29 00:00:00","48","48","210000","252000","No","Green"],
    [68,"Place","SDC2019 071","Community Development","Housing","Works - Construction, Repair & Maintenance","Gas Servicing & Maintenance - Richmond / Harrogate / Selby","2025-01-29 00:00:00","48","2 years plus 2 x 1 year extensions","19200000","24000000","Yes","Amber"],
    [69,"People","TBC","CYPS","Education & Skills","Domestic Goods","298-NYC-CY Musical Instruments","2025-04-01 00:00:00","24","24","311099","373319","Yes","Green"],
    [70,"People","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","Yes","Green"],
    [71,"Professional","TBC","CS Resources","Property, Procurement and Commercial","ICT","358-NYC-RS Interactive Panels","2025-09-01 00:00:00","36","36",null,null,"Decision Record","Green"],
    [72,"Professional",null,"CS Resources","Technology","ICT","Digital Care Records & E Scheduling","2027-07-01 00:00:00","60","36+24","648500","778200","No","Green"],
    [73,"People","90556","HAS","Director of Public Health","Healthcare","299-NYC-HA Primary Care Services - Pharmacies (PMO: 4049)","2025-04-01 00:00:00","60","60","1536250","1843500","Yes","Green"],
    [74,"Professional",null,"CS Resources","Technology","ICT","Framework Agreement for the Provision of School's Online Payment Systems",null,"48","48","410000","492000","Yes","Green"],
    [75,"People","90551","HAS","Director of Public Health","Healthcare","299-NYC-HA Primary Care Services - GPs (PMO: 4049)","2025-04-01 00:00:00","60","60","7247000","8696400","Yes","Green"],
    [76,"People","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","Yes","Green"],
    [77,"Professional","87263","CS HR and business support","Human Resources","HR","Employee Benefits and Salary Sacrifice Schemes","2025-01-01 00:00:00","48","48","100000000","120000000","Yes","Green"],
    [78,"People","TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Approved Provider List (APL) - Specialist Care","2026-04-01 00:00:00","48","36+12",null,null,"Yes","Green"],
    [79,"Professional",null,"CS Resources","Technology","ICT","The provision of a PC Booking and Print Management System for North Yorkshire Libraries","2026-10-01 00:00:00","60","36+24","71000","85200","Decision Record",null],
    [80,"Professional","TBC","CS HR and business support","Human Resources","HR","130-NYC-CX Employee Assistance Programme (EAP)","2025-08-01 00:00:00","36","24+12","199500","239400","Decision Record","Green"],
    [81,"Place","96045","Community Development","Economic Development, Regeneration, Tourism and Skills","Works - Construction, Repair & Maintenance","Levelling Up Fund (LUF) Catterick Garrison - building occupier","2025-07-01 00:00:00","120","60+60","1643960","1961953","Yes","Green"],
    [82,"People","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","Yes","Green"],
    [83,"People","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","Yes","Green"],
    [84,"Place","tbc","Community Development","Economic Development, Regeneration, Tourism and Skills","Works - Construction, Repair & Maintenance","Levelling Up Fund (LUF) Catterick Garrison - buildings & civils/public realm","2025-02-03 00:00:00","12","12","12350000","14820000","Key Decision","Green"],
    [85,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","West Yorkshire Combined Authority Transforming Cities Fund\nWYCA TCF / Overarching project\nHarrogate / Skipton / Selby","2024-06-01 00:00:00",null,null,"41476123","49771348","Key Decision","Amber"],
    [86,"People","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","Yes","Green"],
    [87,"People","TBC","Community Development","Housing","Social & Community Supplies & Services","285-NYC-CD Young Peoples Pathway - Managed Accommodation (Pathway 2 (Foundation) Emergency & Extended Supported Lodgings (Pathway 2 (SASH))","2026-02-01 00:00:00","1900-02-28 00:00:00","36 + 12 + 12",null,null,"Yes","Amber"],
    [88,"Professional","58512","CS Resources","Technology","ICT","Countryside Access Management System","2026-04-01 00:00:00","36","24+12","51000","61200","Decision Record",null],
    [89,"Professional","66879","CS Resources","Technology","ICT","Income Management Systems (Harrogate and Scarborough)","2025-01-01 00:00:00","27","1900-01-27 00:00:00","111000","133000","Decision Record","Green"],
    [90,"Professional","59591","CS Legal and Democratic Services","Legal","Legal Services","Legal reference material","2027-04-01 00:00:00",null,"TBC",null,null,"Decision Record",null],
    [91,"Professional","91069","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Health & Safety","131-NYC-EN Bikeability Cycle Training","2025-09-01 00:00:00","42","18+12+12","768300","768300","Yes","Green"],
    [92,"Professional","TBC","CS Resources","Technology","ICT","132-NYC-RS Enterprise Data Architecture Solution","2025-07-01 00:00:00","1900-02-05 00:00:00","24+12","220000","264000","Decision Record","Green"],
    [93,"Professional","TBC","CS Legal and Democratic Services","Legal","Legal Services","133-NYC-LD Counsel (Barristers)","2025-09-01 00:00:00","60","36+12+12","2649410","3179292","Yes","Green"],
    [94,"Professional",null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","Internal Audit, Counter Fraud, Information Governance and Data Protection Officer Services","2027-04-01 00:00:00",null,"TBC",null,null,"Yes",null],
    [95,"Professional","90523","CS Resources","Technology","ICT","134-NYC-RS Customer Engagement and Relationship Platform","2025-10-01 00:00:00","84","60+24","2000000","2400000","Yes","Green"],
    [96,"Professional","DN471980","CS Resources","Technology","ICT","Housing Management System","2025-04-01 00:00:00","60","60","377063","452475","Decision Record","Green"],
    [97,"Professional",null,"CS Resources","Technology","ICT","The Provision of Vehicle Telematics and Portal System","2027-11-01 00:00:00","60","36+24","600000","720000","No","Green"],
    [98,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Flooding response works (debris removal)","2026-01-01 00:00:00",null,null,"60000","72000","TBC","Green"],
    [99,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Area 3 F374 Museum Terrace, Scarborough Special Grade II listed stone steps","45901",null,null,null,null,"TBC",null],
    [100,"Professional","51363","CS Resources","Technology","ICT","Smoking Cessation System","2025-11-01 00:00:00","60","36+12+12","57501","69001","No","Green"],
    [101,"Professional","TBC","CS Resources","Technology","ICT","286-NYC-RS Door and Security Access System","2026-08-01 00:00:00","48","24+12+12","556175","667410","Yes",null],
    [102,"People","TBC","CYPS","Education & Skills","Education","313-NYC-CY North Yorkshire Selection Test Scheme for Grammar School Entry","2026-02-01 00:00:00","36",null,"96000","115200","Decision Record","Amber"],
    [103,"Professional","92168","CS Local Engagement","Communications","HR","Multidisciplinary Media Services Contract(s)","2025-04-01 00:00:00","1900-02-05 00:00:00","24+12","150000","180000","Decision Record","Green"],
    [104,"Place","TBC","NYH","NYH","Works - Construction, Repair & Maintenance","A10025 A6108 SRF Package 2 Leyburn Improvements","2024-05-27 00:00:00","1","1","232000","278400",null,"Amber"],
    [105,"Professional","65846","Community Development","Economic Development, Regeneration, Tourism and Skills","ICT","Destination Management Solution, Including Ongoing Hosting, Support, and Maintenance","2024-11-11 00:00:00","72","48+12+12","250000","300000","Decision Record","Green"],
    [106,"Professional","91584","Community Development","Housing","Cleaning & Janitorial","267-NYC-CD VOID Cleaning","2025-07-01 00:00:00","60","36+12+12","500000","600000","Yes","Amber"],
    [107,"Professional","89504","NYNET",null,null,"Care Home Wifi Connectivity","2025-04-01 00:00:00","12","12","330000","396000","Yes","Amber"],
    [108,"Professional",null,"CS Resources","Technology","ICT","Replacement of Idox Systems","2029-11-01 00:00:00","60","60","1250000","1500000","TBC","Green"],
    [109,"Professional","TBC","CS Resources","Technology","ICT","Historic Environment Record System","2026-04-01 00:00:00",null,"TBC",null,null,"No",null],
    [110,"Professional",null,"CS Resources","Technology","ICT","268-NYC-RS Oracle PBCS (Planning and Budgeting Cloud Solution) Application Support","2025-07-26 00:00:00",null,"10","20000","24000","Decision Record","Green"],
    [111,"Place","67857, 67858, 67859, 67861","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","NYC Gritter Lease Extension","2024-11-25 00:00:00","120","84+12+12+12","2082365","2498840","No","Green"],
    [112,"Place","tbc","NYH","NYH","Street & Traffic Management","Rural grass cutting services","2025-05-01 00:00:00","48","24+24","1560000","1872000","No","Green"],
    [113,"Place","50839","Community Development","Housing","Works - Construction, Repair & Maintenance","Procurement Framework for Housing New Build and Extension Works","2024-05-01 00:00:00","36","24+12","1696951","2036341","Yes","Green"],
    [114,"People","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","84","36+24+24","190000","228000","Yes","Green"],
    [115,"People","DN579573","HAS","Prevention and Service Development","Social & Community Supplies & Services","341-NYC-HA Advocacy Services :- Independent Health Complaints- CYPS Advocacy- HAS Advocacy","2025-04-01 00:00:00","84","36+24+24","5618000","6741600","Yes","Amber"],
    [116,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","Parking Machine Replacement Programme","2025-06-01 00:00:00","60",null,"2000000","2400000","Yes","Green"],
    [117,"Professional","DN502144","CS Resources","Finance (inc. Pension Fund)","Financial Services","The Provision of Printed Cheques","2025-11-25 00:00:00","84","36 + 12 + 12 + 12 + 12","65000","78000","Decision Record","Green"],
    [118,"Place","TBC","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","General Building - Responsive Maintenance","2026-02-01 00:00:00",null,null,null,null,"Key Decision","Amber"],
    [119,"Place","TBC","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Mechanical and Engineering frameworks including decarbonisation (Salix)","2026-06-01 00:00:00",null,null,"1000000",null,"Yes",null],
    [120,"Professional","TBC","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","140-NYC-RS Washroom Services","2026-07-01 00:00:00","36","36","315000","378000","Yes","Green"],
    [121,"Professional","TBC","CS Resources","Technology","ICT","Arboriculture Asset Management System","2026-07-01 00:00:00","12","12","8960","10752","TBC",null],
    [122,"Professional",null,"CS Resources","Property, Procurement and Commercial","Catering","Vending Machines","2026-08-01 00:00:00","48","36+12","32000","38400","No",null],
    [123,"Professional","TBC","Environment","Technology","ICT","Complex Contract Management System (AWRP PFI)","46132","1900-02-17 00:00:00","24+12+12","38000","45600","TBC",null],
    [124,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Double Arch, East Marton A59 - Maintenance","2025-11-03 00:00:00","1","1","50000","60000","Decision Record","Green"],
    [125,"Professional",null,"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","Decision Record","Green"],
    [126,"Professional",null,"CS Resources","Technology","ICT","Occupational Health Case Management System","2028-05-23 00:00:00","48","36+12","84212","101055","TBC","Green"],
    [127,"People","66032","HAS","Director of Public Health","Healthcare","439-NYC-HA Provision of vouchers for the supply of e-cigarettes and associated products","2025-07-03 00:00:00","36","24+12","75000","90000","Yes","Green"],
    [128,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Beggars Wife North Redeck insitu RC Slab","2025-09-01 00:00:00",null,null,"80000","96000","Decision Record","Green"],
    [129,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Low Farm - Spandrel wall take down","2026-01-01 00:00:00",null,null,"80000","96000","Decision Record","Green"],
    [130,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Cover Head Bridge, East Witton Strengthening","2026-09-01 00:00:00",null,null,"85000","102000","TBC",null],
    [131,"Professional","48830","CS Resources","Technology","ICT","Coroners Case Management System","2026-11-25 00:00:00","48","36+12","87536","105043","Decision Record",null],
    [132,"Professional","TBC","CS Resources","Technology","ICT","Coroners Case Management System","2027-11-25 00:00:00","48",null,"87536","105043","TBC",null],
    [133,"Professional","26112","CS Resources","Technology","ICT","Legal Services Case Management System.","2026-04-01 00:00:00","72","24+24+24","93775","112530","Decision Record",null],
    [134,"Professional","TBC","CS Resources","Technology","ICT","Property Asset Management System","2026-04-07 00:00:00","48","36+12","96000","115200","Decision Record",null],
    [135,"People","TBC","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","453-NYC-CY Independent Visitors","2026-03-01 00:00:00",null,null,null,null,"TBC","Green"],
    [136,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Scott Beck - arch repairs and saddle","2025-11-01 00:00:00",null,null,"100000","120000","Decision Record",null],
    [137,"Professional","94517","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Facilities & Management Services","314-NYC-EN Seasonal Vegetation Cutting Programme","2025-04-01 00:00:00","48","48","300000","360000","Yes","Green"],
    [138,"Professional","TBC","CS Resources","Finance (inc. Pension Fund)","Financial Services","Treasury Management Investment Consultancy Services  (NYCC, Selby & Ryedale)","2026-04-01 00:00:00","60","36+24","109665","131598","No",null],
    [139,"Professional","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","Decision Record",null],
    [140,"Professional","DN570992","CS Resources","Technology","ICT","269-NYC-RS Direct Debit Payment System","2025-10-01 00:00:00",null,null,"110000","132000","Decision Record",null],
    [141,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Runley - Strengthening","2026-08-01 00:00:00",null,null,"120000","144000","Decision Record",null],
    [142,"Professional","66860","CS Resources","Technology","ICT","Budget planning tool for schools","2025-05-01 00:00:00","48","36+12","100000","120000","Decision Record",null],
    [143,"Professional","64684","CS Resources","Technology","ICT","LCS/ EHM MeLearning","2026-04-01 00:00:00","48","36+12","121713","146055","Decision Record",null],
    [144,"Professional","TBC","CS Resources","Technology","ICT","Hardware Security Modules","2026-04-01 00:00:00","60","60","126756","152107","Decision Record",null],
    [145,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Hole House - Saddle and maintenance","2025-11-01 00:00:00",null,null,"130000","156000","Decision Record",null],
    [146,"Professional","68239","CS Resources","Technology","ICT","Website Hosting - Drupal (Currently Code Enigma)","2026-04-01 00:00:00","1900-02-17 00:00:00","36+12","132000","158400","Decision Record",null],
    [147,"Professional","TBC","CS Resources","Technology","ICT","VMWare Licencing for Storage Area and Compute Hardware","2024-11-08 00:00:00","1900-02-28 00:00:00","1900-02-28 00:00:00","515165","618198","Yes","Green"],
    [148,"Professional","53588","CS Resources","Property, Procurement and Commercial","Horticulture","Arboriculture services","2025-11-01 00:00:00","48","24+24","135599","162719","Decision Record","Green"],
    [149,"Professional","TBC","CS Resources","Property, Procurement and Commercial","Horticulture","Arboriculture services","2026-11-01 00:00:00","48","24+12+12","135599","162719","TBC",null],
    [150,"Professional","34436","CS Resources","Technology","ICT","HR Recruitment Main Admin System (Havas People)","2025-11-05 00:00:00","48","24+12+12","136000","163200","Decision Record",null],
    [151,"People","TBC","HAS","Director of Public Health","Social & Community Supplies & Services","422-NYC-HA Oral Health Promotion","2025-11-28 00:00:00","36","36","150000","180000","Decision Record","Green"],
    [152,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Ashfield Road - Reconstuct","2025-11-01 00:00:00",null,null,"150000","180000","Decision Record","Green"],
    [153,"Professional","67809","CS Resources","Technology","ICT","School Data Collection and Reporting System\n(Groupcall Product - Xporter, Virtual School &amp; Xvault)","2026-04-01 00:00:00","48","36+12","150400","180480","Decision Record",null],
    [154,"Professional","78884","CS Resources","Technology","ICT","Health and Safety Management System (2020 PMO Ref: 1053)","2026-11-01 00:00:00","48","36+12","159850","191820","Decision Record",null],
    [155,"People","95121","CYPS","Inclusion","Social & Community Care Supplies & Services - Children","284-NYC-CY Parent Participation and Co Production","2025-04-01 00:00:00","60","36 + 24","168910","202692","Key Decision","Green"],
    [156,"Professional","53634","CS Resources","Technology","ICT","Local Planning Software","2026-09-20 00:00:00","48","36+12","166000","199200","Decision Record",null],
    [157,"Professional",null,"CS Resources","Technology","ICT","280-NYC-RS Fleet Management System","2025-09-07 00:00:00","1900-02-28 00:00:00","36+12+12",null,"200000","Decision Record",null],
    [158,"Professional","DN218887","CS Resources","Technology","ICT","Insurance Claims Management System","2025-03-06 00:00:00","96","24+24+24+24+24","177098","212518","Decision Record","Green"],
    [159,"Professional","DN218887","CS Resources","Technology","ICT","Insurance System\n(currently EvoClaim, provided by DWF 360)","2027-03-08 00:00:00","96","24+24+24+24+24","177098","212518","Decision Record",null],
    [160,"Professional","66284","CS Resources","Technology","ICT","Gartner for IT leaders (subscription)","2024-11-01 00:00:00","24","24","187400","224880","Decision Record","Green"],
    [161,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","Tyres and associated services (fitting valves) for NYC depots","2025-05-01 00:00:00","1900-02-17 00:00:00","24+12+12","1600000","1920000","TBC","Amber"],
    [162,"People","TBC","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","2025-10-01 00:00:00","36","24 + 12","400000","480000","Yes","Green"],
    [163,"Place","TBC","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Phoenix Business Park, Ripon - upgrading of units to meet EPC legislation","2025-07-01 00:00:00","3","3","240000","288000","Decision Record","Amber"],
    [164,"Place","tbc","NYH","NYH","Building Construction Materials","Hot boxes for ashphalt","2026-05-01 00:00:00","48","24+12+12","240000","288000",null,null],
    [165,"Professional","TBC","CS Resources","Technology","ICT","Adobe Licences (Corporate - All)","2026-04-01 00:00:00","48","36+12","250000","300000","Yes",null],
    [166,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","SRF - A6108 Package 5 Leyburn to Bellerby cycleroute 24/25","2026-09-01 00:00:00",null,null,"978750","1174500",null,null],
    [167,"Place","90954","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Scarborough Harbour West Pier Procurement","2025-11-03 00:00:00","24","24","10000000","11000000","Yes","Red"],
    [168,"Professional","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Consultancy","West Pier Boat Lift, Scarborough Harbour - Specialist Consultant","2025-03-31 00:00:00","12","12","295000","354000","Decision Record","Amber"],
    [169,"People","DN418993","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","352-NYC-CY Medical advice for adoption and fostering panels","2025-04-01 00:00:00","84","36+24+24","350000","420000","No","Amber"],
    [170,"Professional","88292","CS HR and business support","Business Support","Facilities & Management Services","Corporate Business Travel","2025-08-01 00:00:00","48","24 + 24","2104000","2524800","Yes","Amber"],
    [171,"Professional","48221","CS Resources","Technology","ICT","Lone Worker Solutions (PMO: 3886)","2026-05-21 00:00:00","36","24+12","350000","420000","TBC","Green"],
    [172,"Professional","TBC","CS Resources","Technology","ICT","Financial Accounting Solution for External Clients","2026-11-01 00:00:00","36","36","351734","422081","TBC",null],
    [173,"Professional","TBC","CS Resources","Technology","ICT","147-NYC-RS Automated Collection and Analysis of Carriageway Condition Data Services (NYC Call off)","2025-04-01 00:00:00","24","24","305829","366994","No","Green"],
    [174,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","Kingsley Farm Resurfacing s278\nBogs Lane, Harrogate","2026-04-01 00:00:00","1900-01-01 00:00:00",null,"400000","480000","Decision Record",null],
    [175,"People","92156","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Care at Esk Moors Lodge","2025-10-01 00:00:00","1900-04-05 00:00:00","4 +2 +2","1400000","1400000","Yes","Green"],
    [176,"Professional","TBC","CS Resources","Technology","ICT","Education Case Management System \nProject Kairos (2020 PMO Ref: 1940)","2027-05-01 00:00:00","84","60+24","410331","492397","Yes",null],
    [177,"Professional","51885","CS Resources","Technology","ICT","Backup solution for the M365 environment","2028-10-01 00:00:00","60","60","445000","534000","Yes",null],
    [178,"Professional",null,"CS Resources","Technology","ICT","148-NYC-RS Internet Filtering for Schools","2025-04-01 00:00:00","36","36","470000","564000","Yes","Amber"],
    [179,"Place","TBC","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Demolition of buildings Grammar School Lane, Northallerton","2026-01-30 00:00:00",null,null,"500000","600000","Yes",null],
    [180,"People","TBC","CS Local Engagement","Locality Structure","Social & Community Care Supplies & Services - Children","Holiday Activities Fund","2026-04-01 00:00:00",null,null,null,null,"TBC","Green"],
    [181,"Professional","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","Yes",null],
    [182,"Professional","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","Yes",null],
    [183,"Professional","TBC","CS Resources","Technology","ICT","392-NYC-RS Kitchen Management System and Associated Hardware","2026-03-01 00:00:00","60","36+24","620000","744000","Yes",null],
    [184,"Professional","48877","CS Resources","Technology","ICT","149-NYC-RS Income Management and Card Payments System","2026-05-01 00:00:00","18","18","350000","420000","Decision Record","Green"],
    [185,"Professional","DN560044 / 26113","CS Resources","Finance (inc. Pension Fund)","Consultancy","Pensions Fund Investment Consultant","2025-12-31 00:00:00","84","60+24","650000","780000","Decision Record",null],
    [186,"Professional","DN498638","CS Resources","Finance (inc. Pension Fund)","Financial Services","Actuarial Services - To provide the Pension Fund with Actuarial Service","2026-01-01 00:00:00","84","60+12+12","700000","840000","Decision Record",null],
    [187,"Professional","YPO Consortium lead Kirklees Council","CS HR and business support","Business Support","Mail Services","Postal Services","2025-08-09 00:00:00","48",null,"2800000","3360000","Yes","Green"],
    [188,"Professional","74949","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Removals and storage services","2025-09-18 00:00:00","48","24+12+12","760000","912000","Key Decision","Green"],
    [189,"Professional","DN368842","CS Resources","Technology","ICT","Library Kiosks - 2088 Public Use of IT Provision","2026-04-01 00:00:00","120","84+24+12","915000","1098000","Yes",null],
    [190,"Professional","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","Yes",null],
    [191,"Place","DN490195","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","Traffic Signals Maintenance","2025-10-01 00:00:00","84","60+24","980000","1176000","Key Decision","Green"],
    [192,"Professional","50805","CS Resources","Technology","ICT","Highways Asset Management System (PMO Ref: 3175)","46174","48","36+12","1073000","1287600","Key Decision",null],
    [193,"Place","94304","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","233-NYC-EN Whitby scheme 1 / Junction improvement Spital Bridge / A171Whitby Towns Fund","2025-03-11 00:00:00","3",null,"675000","810000","Yes","Green"],
    [194,"People","64118","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","Young Peoples Pathway - Emergency & Extended Supported Lodgings (Pathway 2 (SASH))","2025-01-31 00:00:00","48","24+15+6+6","1360000","1632000","Yes","Amber"],
    [195,"Professional","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","Yes",null],
    [196,"Professional","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","Yes",null],
    [197,"Professional","TBC","CS Resources","Technology","ICT","Procurement Management Software (Currently YORtender/Proactis)","2026-06-01 00:00:00","84","36+24+24","1463000","1755600","Decision Record",null],
    [198,"People","TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","300-NYC-HA Resettlement and Community Safety Scheme (RACSS)","2026-10-01 00:00:00",null,null,null,null,"Yes","Amber"],
    [199,"People","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","Yes","Green"],
    [200,"People","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","Yes","Green"],
    [201,"People",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","Yes","Green"],
    [202,"People","39242 / 52084","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","323-NYC-CY Universal Youth Services","2025-09-01 00:00:00","96","36+36+24","2800000","3360000","Yes","Amber"],
    [203,"People","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","Yes","Green"],
    [204,"People",null,"CYPS","Children and Families","Social & Community Care Supplies & Services - Children","Targeted Healthy Child Service","2027-04-01 00:00:00",null,null,null,null,"Yes","Green"],
    [205,"Professional",null,"CS Resources","Technology","ICT","Pension Administration System","2030-09-01 00:00:00","120",null,null,"3130812","Yes","Green"],
    [206,"Place","TBC","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Harrogate Convention Centre Redevelopment / HCC\nVenue Operators\nMechanical and Electrical Plant","2026-04-01 00:00:00",null,"3","3500000","4200000",null,null],
    [207,"Professional","TBC","CS Resources","Technology","ICT","152-NYC-RS Automated Collection and Analysis of Carriageway Condition Data Services","2026-04-01 00:00:00","48","48","4000000","4800000","Yes","Green"],
    [208,"Professional",null,"CS Resources","Technology","ICT","Corporate WAN","2030-01-01 00:00:00","72","60+12","4000000","4800000","Key Decision","Green"],
    [209,"Place","TBC","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Skipton Greatwood Primary School - provide additional pupil places to expand the school from 1 form entry to 2 form entry","2027-09-01 00:00:00",null,null,"2600000","3120000","Yes",null],
    [210,"People","TBC","CYPS","Education & Skills","Education","School Improvement & Locality Boards","2026-09-20 00:00:00","48","48","5000000","6000000","Yes","Green"],
    [211,"Professional","76600","CS Resources","Technology","ICT","IT Hardware Partner (Education) & (Corporate)","2025-09-01 00:00:00","60","24+24+12","5399000","6478800","Yes","Amber"],
    [212,"People","DN579573","HAS","Prevention and Service Development","Social & Community Supplies & Services","341-NYC-HA Advocacy Services :- Independent Health Complaints- CYPS Advocacy- HAS Advocacy","2025-04-01 00:00:00","84","36+24+24","5618000","6741600","Yes","Amber"],
    [213,"People","TBC","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","Therapeutic Support to Adopters and Adoptees (collaborative arrangement)","2027-04-01 00:00:00","60",null,"6000000","7200000","Yes","Green"],
    [214,"Professional","TBC","CS Resources","Finance (inc. Pension Fund)","Financial Services","Insurance-Linked Securities (ILS)","2026-05-21 00:00:00","120","36+12+12+12+12+12+12+12","6140000","7368000","Yes",null],
    [215,"Professional","TBC","CS Resources","Finance (inc. Pension Fund)","Financial Services","Insurance-Linked Securities (ILS)","2027-05-21 00:00:00",null,null,"###############################################################################################################################################################################################################################################################","7368000","Yes",null],
    [216,"Professional","73120","CS Resources","Property, Procurement and Commercial","Catering","Ambient and shelf stable food products","2026-04-01 00:00:00","60","36+12+12","6560000","7872000","Yes",null],
    [217,"Professional","73120","CS Resources","Property, Procurement and Commercial","Catering","Ambient and shelf stable food products","2027-04-01 00:00:00","1900-02-28 00:00:00","36+12+12","6560000","7872000","Yes",null],
    [218,"Place","TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","Supply and potential delivery of waste bins - wheeled post transformation","2026-08-01 00:00:00",null,null,"15000000","18000000","Yes",null],
    [219,"Professional","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","Yes","Green"],
    [220,"Professional","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","Decision Record",null],
    [221,"Professional","73132","CS Resources","Finance (inc. Pension Fund)","Financial Services","Insurance -  Casualty, Motor, Property, Travel/PA and Engineering","2028-04-01 00:00:00","1900-03-06 00:00:00","36+24+6","###############################################################################################################################################################################################################################################################","53358911","Decision Record",null],
    [222,"People","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","Yes","Green"],
    [223,"Place","TBC","CS Resources","Property, Procurement and Commercial","Utilities","Purchase of Power (Electricity) for corporate, schools and streetlighting from 2028","2028-10-01 00:00:00","48","48","101161888","121394266","Yes","Green"],
    [224,"Place","TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","451-NYC-EN Waste Management Services","2025-09-18 00:00:00","180","120+60","187500000","225000000","Yes","Green"],
    [225,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","400-NYH-OO Civil Engineering Contractors Framework (Refresh to current in train framework)","2025-08-02 00:00:00","48","48","220000000","266400000","Key Decision","Green"],
    [226,"Place","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","Key Decision",null],
    [227,"People","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","Yes","Green"],
    [228,"Place","TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Utilities","Clinical waste contract","2026-01-01 00:00:00",null,null,null,null,"TBC","Amber"],
    [229,"Place","SDC2019 050","Community Development","Housing","Housing Management","Kitchen, Bathrooms","2025-08-01 00:00:00","48","2+1+1","19200000","23040000","Yes","Green"],
    [230,"Professional","TBC","CS Resources","Technology","ICT","154-NYC-RS Anti Virus - Schools (currently Sophos) [Anti-Virus for Schools?]","2025-06-01 00:00:00","36","36","100143","120172","Decision Record","Green"],
    [231,"Professional","TBC","CS Resources","Technology","ICT","Citrix ADC Software","2026-03-22 00:00:00","60","60",null,null,"Decision Record",null],
    [232,"Professional","39509","CS Resources","Technology","ICT","272-NYC-RS Citrix Virtual Apps and Desktop (software assurance and support)","2025-12-24 00:00:00",null,null,null,null,"Decision Record","Green"],
    [233,"Professional","73120","CS Resources","Property, Procurement and Commercial","Catering","Ambient and shelf stable food products","2028-04-01 00:00:00",null,null,null,null,"Yes",null],
    [234,"Professional","TBC","CS Resources","Technology","ICT","Financial Forecasting Software","2025-12-09 00:00:00","12","12","127000","152400","Decision Record","Green"],
    [235,"Professional",null,"CS Resources","Technology","ICT","Highways Asset Management System (PMO Ref: 3175)","2027-06-01 00:00:00","48","36+12","1073560",null,null,null],
    [236,"Professional","TBC","CS HR and business support","Business Support","ICT","155-NYC-RS HR Recruitment Main Admin System","2025-07-15 00:00:00","48","48","344000","412800","TBC","Amber"],
    [237,"Place","SDC2020 026","Community Development","Housing","Facilities & Management Services","Replacement Doors and Windows Harrogate, Selby and Richmondshire","2025-06-01 00:00:00","48","24+12+12","8000000","10000000","Yes","Amber"],
    [238,"Professional","TBC","CS Resources","Technology","ICT","Insurance and Claims Management System","2027-03-05 00:00:00",null,null,null,"170000","TBC",null],
    [239,"Professional","TBC","CS Resources","Property, Procurement and Commercial","Catering","Fresh Fruit, Vegetables and Milk Products\n(currently supplied by Stuarts / Paynes)","2026-04-01 00:00:00",null,null,null,null,"Yes",null],
    [240,"Professional","TBC","CS Resources","Property, Procurement and Commercial","Catering","Fresh Meat and Frozen Products","2026-04-01 00:00:00",null,null,null,null,"Yes",null],
    [241,"Professional","TBC","CS Resources","Technology","ICT","Legal Services Case Management System.","2028-04-01 00:00:00","72","24+24+24",null,null,"Decision Record",null],
    [242,"Professional","TBC","CS Resources","Technology","ICT","Library Kiosks - 2088 Public Use of IT Provision","2029-04-01 00:00:00","48","36+12","915000",null,"TBC",null],
    [243,"Professional",null,"CS Resources","Technology","ICT","MANY (ANPR Cameras)","2025-01-10 00:00:00","60","60","28560","34272","Decision Record","Green"],
    [244,"Professional","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,"Yes",null],
    [245,"Place","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","Key Decision","Green"],
    [246,"Place","94016","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","287-NYC-RS Asbestos Abatement","2025-09-01 00:00:00","84","36+24+24","10000000","12000000","Key Decision","Green"],
    [247,"Professional","TBC","CS HR and business support","Business Support","Mail Services","273-NYC-CX Mailroom Equipment and Associated Software Services and Consumables","2026-01-12 00:00:00",null,null,null,null,"TBC","Amber"],
    [248,"Professional",null,"CS Resources","Technology","ICT","Pensions Administration/PARIS/eBS Database support","2025-10-04 00:00:00","12","12","101919","122303","Decision Record","Green"],
    [249,"Professional",null,"CS Resources","Technology","ICT","458-NYC-RS Property Asset Management System","2027-04-07 00:00:00",null,null,null,null,"Decision Record",null],
    [250,"Professional","92226","CS Resources","Finance (inc. Pension Fund)","Financial Services","Pensions Custodian Services (ancillary services)","2025-07-01 00:00:00","120","60 + 60","600000","720000","No","Red"],
    [251,"Place","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","2025-08-01 00:00:00","84","36+24+24","2400000","2880000","Key Decision","Green"],
    [252,"Professional","TBC","CS Resources","Finance (inc. Pension Fund)","Consultancy","Pensions Fund Investment Consultant","2028-10-08 00:00:00",null,null,null,null,"Decision Record",null],
    [253,"Professional","TBC","CS Resources","Customer, Revenues and Benefits","Financial Services","158-NYC-RS Pre Payment Cards for Court of Protection","2025-07-25 00:00:00","36","12+12+12","136150","163380","Decision Record","Green"],
    [254,"Professional","67439","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Facilities & Management Services","160-NYC-EN - Stray Dogs Kennelling","2025-10-01 00:00:00","72","60 + 12","375000","450000","TBC","Green"],
    [255,"Professional",null,"CS Resources","Technology","ICT","Robotic Automation","2026-05-01 00:00:00",null,null,null,null,"Decision Record",null],
    [256,"Place","TBC","NYH","NYH","Works - Construction, Repair & Maintenance","A30003 Tender Package 5 Area 3 Scarborough Footway Special and R&R Huntriss (combined) Repaving part of precinct","2025-09-01 00:00:00","1","1","644800","773760",null,null],
    [257,"Place","95176","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","Supply of Road Salt","2025-06-01 00:00:00","48","48","10000000","12000000","Yes","Green"],
    [258,"Professional","TBC","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Cleaning & Janitorial","Provision of Cleaning, Minor Maintenance, and Consumables for Public Conveniences - on hold","2025-07-01 00:00:00","120","48+48+24","4119790","4943748","Yes","Green"],
    [259,"Professional",null,"CS Resources","Technology","ICT","Microsoft Licencing Solution Partner","45809","36","36","1020000","1224000","Yes","Green"],
    [260,"Professional","TBC","CS HR and business support","Business Support","Stationery","163-NYC-CX - Shredding & Secure Disposal of Confidential Material - Confidential Shredding and General Paper Waste","2025-08-01 00:00:00","48","24+12+12","60000","72000","Decision Record","Amber"],
    [261,"Professional","TBC","CS Resources","Technology","ICT","164-NYC-RS Security portfolio partner - Next Gen Firewall - Expiry TBC","2025-10-01 00:00:00","36","24+12","203000","243600","Decision Record","Green"],
    [262,"Professional","TBC","CS Resources","Technology","ICT","Service Management System","2026-11-11 00:00:00",null,null,null,null,"TBC",null],
    [263,"Professional",null,"CS Resources","Property, Procurement and Commercial","Catering","Vending Machines","2027-08-01 00:00:00",null,null,null,null,"TBC",null],
    [264,"People","TBC","HAS","Director of Public Health","Education","Growing up in North Yorkshire - Learning and Wellbeing Surveys","45748","168","120+24+24","382500","459000","Decision Record","Amber"],
    [265,"Professional","TBC","CS Resources","Technology","ICT","Supply and Maintenance of SAN Virtual Tape Library","46631",null,null,null,null,"TBC",null],
    [266,"Professional","TBC","Environment","Technology","ICT","Trading Standards Business System","46112",null,null,null,null,"TBC",null],
    [267,"People","TBC","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","456-NYC-CY Provision of Foster Care Placements (IFA)","46113",null,null,null,null,"TBC","Green"],
    [268,"Place","95697","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Street & Traffic Management","Weather Forecasting Contract and Weather Station Bureau Service Contract","2025-07-05 00:00:00","84","36+24+24","1050000","1260000","Key Decision","Green"],
    [269,"People",null,"Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Financial Services","Subscription to CollectionHQ (Libraries)","2027-06-16 00:00:00",null,null,null,null,"No","Green"],
    [270,"People","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","Yes","Green"],
    [271,"Professional","TBC","CS HR and business support","Business Support","Clothing","Workwear & PPE / Uniforms","2025-07-14 00:00:00","60","36+24","680000","816000","Yes","Green"],
    [272,"Professional","TBC","CS Resources","Property, Procurement and Commercial","Catering","Supply and Delivery of Pre-Packed Sandwiches and Associated Products","2026-04-01 00:00:00",null,null,null,null,"Yes",null],
    [273,"People","TBC","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","Inter Country Adoption","2025-07-01 00:00:00","48","3 + 1","144000","172800","No","Amber"],
    [274,"People","89503","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","432-NYC-HA Representative Body for Adult Social Care in North Yorkshire","2024-10-01 00:00:00","60","36+24","185000","222000","Yes","Green"],
    [275,"People","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","Yes","Green"],
    [276,"People","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","Yes","Green"],
    [277,"People","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","Yes","Green"],
    [278,"People","50483","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Extra Care Housing - Whitby","2024-10-01 00:00:00",null,null,"10000000","12000000","Yes","Amber"],
    [279,"People","66739","HAS","Director of Public Health","Healthcare","351-NYC-HA Living and Lived Experience of  Substance Use (NY Connected Spaces)","2025-04-01 00:00:00","12","12+6+6","75000","75000","No","Green"],
    [280,"People","TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Extra Care Housing - future provision","2025-09-25 00:00:00",null,null,"850000000","1020000000","Yes","Green"],
    [281,"People","TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Extra Care Housing - Whitby","2025-09-25 00:00:00",null,null,null,null,"Yes","Green"],
    [282,"People","TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","335-NYC-HA Extra Care Housing - Harrogate","2025-08-18 00:00:00",null,null,null,null,"Yes","Green"],
    [283,"Professional","TBC","CS Resources","Technology","ICT","eSigning Solution (Digital Signatures)","2026-07-15 00:00:00","48","36+12","13056","15667","TBC",null],
    [284,"Professional","TBC","CS Resources","Technology","ICT","eSigning Solution (Digital Signatures)","2027-07-15 00:00:00","48","36+12","13056","15667","TBC",null],
    [285,"Professional","62147","CS Resources","Finance (inc. Pension Fund)","ICT","Supply and Implementation of a Financial Management System, Including Ongoing Hosting, Support, and Maintenance","2024-10-15 00:00:00","120","60+60","8400000","10080000","Yes","Green"],
    [286,"Professional","67931","CS Resources","Technology","ICT","168-NYC-RS Housing Asset Management System","2025-03-01 00:00:00","35","29+6","400000","480000","Decision Record","Green"],
    [287,"Professional","TBC","CS Resources","Customer, Revenues and Benefits","Facilities & Management Services","169-NYC-RS Customer Access and Tourist Information Points SLA","2025-04-01 00:00:00","12","12","50000","60000","Decision Record","Green"],
    [288,"Place","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","82","36+24+24","4200000","5040000","Yes","Green"],
    [289,"Professional","None","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Consultancy","Business Rates and Asset Valuation","2026-03-31 00:00:00","48","36+12","30000","36000","No","Green"],
    [290,"Professional","92262","CS Resources","Technology","ICT","171-NYC-RS Consultation and Engagement System","2025-07-27 00:00:00","60","36+24","150000","180000","Decision Record","Amber"],
    [291,"People","TBC","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","462-NYC-HA Integrated Community Equipment Service","2026-04-01 00:00:00",null,null,"5110642",null,"Yes","Amber"],
    [292,"Professional","TBC","CS Resources","Property, Procurement and Commercial","Catering","Catering Disposable Products","2026-01-12 00:00:00","48","24+24","136635","163962","Decision Record",null],
    [293,"Professional","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds",null,"218-NYC-EN Roundabout Advertising","2025-04-01 00:00:00","36","24+12",null,null,"Decision Record","Green"],
    [294,"Professional","88505","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Consultancy","Bathymetric Surveys","2024-11-01 00:00:00","12","12","221934","266320.8","Decision Record","Amber"],
    [295,"Professional","TBC","CS Resources","Technology","ICT","Online Assessment Tool for Living Aids and Daily Needs","2027-04-01 00:00:00",null,null,null,null,"TBC",null],
    [296,"People","TBC","CYPS","Inclusion","Social & Community Care Supplies & Services - Children","320-NYC-CY SEN Mediation and Disagreement Resolution","2025-09-01 00:00:00",null,null,null,null,"Decision Record","Amber"],
    [297,"People","82466","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","436-NYC-HA Assistive Technology","2026-10-01 00:00:00","36","24+12","1042500","1042500","Yes","Green"],
    [298,"People","TBC","HAS","Director of Public Health","Healthcare","321-NYC-HA  Dental Epidemiology Survey in 5-year-olds","2025-04-01 00:00:00","60","12+24+24","200000","240000","Yes","Green"],
    [299,"Place","N/a","NYH","NYH","Vehicle Management","Vehicle purchases (various), including ongoing parts and servicing for next 12 month period","2025-09-01 00:00:00",null,null,"1000000","1200000","No","Green"],
    [300,"Place","N/a","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","Fleet requirements for 2024-2025 inc NYH fleet requirements","2025-09-01 00:00:00",null,"12","15000000","17785500","Yes","Green"],
    [301,"Professional","tbc","CS Resources","Technology","ICT","173-NYC-RS Leisure Management System","2026-04-01 00:00:00","84","36+12+12","2100000","2520000","Yes","Red"],
    [302,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","Lease car partner","2025-06-23 00:00:00",null,null,null,null,"TBC","Green"],
    [303,"Place","tbc","Community Development","Housing","Works - Construction, Repair & Maintenance","Neville House, Gargrave.  Brownfield Housing Fund development","2025-10-01 00:00:00","24","24","3000000","3600000","Yes","Green"],
    [304,"Place","TBc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","288-NYC-RS Pool Plant Maintenance","2025-07-01 00:00:00","60","24 + 24 + 12","2350000","2350000","Yes","Green"],
    [305,"Place","tbc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","CHP Repair, Maintenance and Remote Monitoring","2025-05-01 00:00:00",null,null,"60000",null,"TBC","Amber"],
    [306,"Place","tbc","Environment","Integrated Passenger Transport, Licencing, Public Rights of Ways & Harbours","Environmental Services","Vet inspections - animal licensing",null,null,"60","75000","90000",null,"Green"],
    [307,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Building Construction Materials","80-NYC-EN Supply of 4 FRP Resin Footbridges","2025-02-01 00:00:00","2","2","110000","132000","No","Green"],
    [308,"Place","96259","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","391-NYC-EN South Otterington - Bridge replacement","2025-07-01 00:00:00","6","6","175000","210000","No","Green"],
    [309,"Professional","TBC","Environment","Regulatory Services, Registration, Bereavement, Coroners Service","ICT","177-NYC-EN Chapel Music and Video Hardware","2025-04-01 00:00:00","12","12","124885","149862","Decision Record","Green"],
    [310,"Place","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","2022-03-08 00:00:00","120","60+12+12+12+12+12","280000","336000","Decision Record","Green"],
    [311,"People","TBC","Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Arts & Leisure Services","289-NYC-RS Gym Equipment and Maintenance","2025-09-01 00:00:00","60","24 + 24 + 12","600000","600000","Yes","Green"],
    [312,"Place","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","No","Amber"],
    [313,"Place","tbc","Community Development","Housing","Housing Management","446-NYC-CD Rendering and Plastering","2025-04-01 00:00:00","48","24+12+12","450000","540000","Yes","Red"],
    [314,"Place","tbc","Community Development","Housing","Housing Management","Housing - Supply of scaffolding and access equipment","2025-05-12 00:00:00",null,null,"200000","220000","No","Green"],
    [315,"People","59565","CS Local Engagement","Locality Structure","Social & Community Care Supplies & Services - Children","347-NYC-LE Holiday Activities Fund","2025-04-01 00:00:00","24","12+12","438750","438750","No","Amber"],
    [316,"Place","tbc","NYH","NYH","Horticulture","Urban Highway Grass Cutting","2025-05-01 00:00:00","96","48 + 48","300000","360000","No","Green"],
    [317,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Highway Equipment & Materials","Signals Infrastructure and Equipment NPIF","2025-07-07 00:00:00","3","3","243828.82","292594.58",null,"Green"],
    [318,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Highway Equipment & Materials","Provision of Variable Message Signs (VMS) A63 Selby Bridges","2026-04-01 00:00:00",null,null,"400000","480000",null,"Green"],
    [319,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","Swinney Bridge precast beam supply and works","2026-06-01 00:00:00",null,null,"200000","240000",null,"Green"],
    [320,"Place","tbc","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Utilities","Wheeled Bins for Malton","2025-01-31 00:00:00",null,null,"1300000","1560000","Yes","Green"],
    [321,"Place","90239","Community Development","Housing","Works - Construction, Repair & Maintenance","Whinny Gill Road","2025-01-06 00:00:00","6",null,"221000","265200","No","Amber"],
    [322,"Place","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Vehicle Management","OEM Parts Supply","2025-03-03 00:00:00","48","48","3493175","4191810","Yes","Red"],
    [323,"People","54565","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","342-NYC-HA HAS APL: Supported Living  - Nursing and Residential  - Home Based Support - Community Based Support","2025-04-01 00:00:00","84","60+12+12","1200000000","1200000000","No","Amber"],
    [324,"People",null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Community Mental Health","2025-10-01 00:00:00","36","2+1+1","1058210.8","1058210.8","Key Decision","Red"],
    [325,"People","DN456769","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","297-NYC-HA (HP) Offender Services (Resettlement and Community Safety)(Housing related support) including Substance Misuse Lot","2025-10-01 00:00:00","48","36+12","1253473","1253473","Yes","Amber"],
    [326,"People",null,"Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Facilities & Management Services","Pitch Maintenance","2026-06-01 00:00:00",null,null,null,null,null,"Green"],
    [327,"Professional","51078","CS Resources","Technology","Facilities & Management Services","Customer Feedback System (Govmetric)",null,"24","24","140000","168000","No","Red"],
    [328,"Professional","5773","CS Resources","Human Resources","ICT","HR and Payroll System","2024-08-01 00:00:00","48","36+12","2867300","3440760","Yes","Red"],
    [329,"People","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",null,"2241540","No","Green"],
    [330,"People",null,"Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Social & Community Supplies & Services","E-Books and E-Audio","2027-04-01 00:00:00",null,null,null,null,null,"Green"],
    [331,"Place","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",null,"Key Decision","Green"],
    [332,"Place","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",null,"Key Decision","Green"],
    [333,"Place","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",null,"Key Decision","Green"],
    [334,"People","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","Key Decision","Green"],
    [335,"Professional","TBC","CS Resources","Business Support","Cleaning & Janitorial","180-NYC-RS - Cleaning and Janitorial Products","2025-07-31 00:00:00","60","36+12+12","1000000","1200000","Yes","Green"],
    [336,"Professional",null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","ICT","225-NYC-EN Parking Payment Apps","2024-08-01 00:00:00","12",null,"324000","388800","Decision Record","Green"],
    [337,"Professional",null,"Environment","Highways, Transportation, Parking Services, Parks and Grounds","ICT","193-NYC-EN Parking Payment AppsA","2025-06-25 00:00:00","60","60","1090345","1308414","TBC","Green"],
    [338,"Place","tbc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Planned Preventative Maintenance (PPM) Service for Air Source Heat Pumps (Leisure Centres)","2025-09-01 00:00:00","60","3+2","400000","500000","Yes","Green"],
    [339,"Place","TBC","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Scarborough Sports Village - Replacement Pitch","2025-05-01 00:00:00",null,null,"550000","660000","TBC","Green"],
    [340,"Place","TBC","Community Development","Housing","Works - Construction, Repair & Maintenance","Housing Standards Construction Framework","2025-12-01 00:00:00","36","36","2000000","2400000",null,"Red"],
    [341,"Professional","52022","NYH","NYH","ICT","Gully Maintenance Software","2025-04-19 00:00:00","48","24+12+12","201414","241696","No","Green"],
    [342,"Professional","TBC","CS HR and business support","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Facilities & Management Services","181-NYC-CX - External Venues Booking","2025-03-14 00:00:00","36","24+12","702000","842400","Yes","Green"],
    [343,"Place","tbc","Community Development","Economic Development, Regeneration, Tourism and Skills","Works - Construction, Repair & Maintenance","Malton Castlegate and Greenspaces Project­",null,null,null,null,null,null,"Green"],
    [344,"People","DN512204","HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","297-NYC-HA Housing Support - Mental Health","2025-10-01 00:00:00","48","24+12+12","2144491","2144491","Yes","Amber"],
    [345,"People","DN366170","HAS","Director of Public Health","Healthcare","346-NYC-HA Drug & Alcohol Service - Adults (Substance Misuse)","2025-10-01 00:00:00","96","60+12+24","38547675","46257209","Key Decision","Green"],
    [346,"People","DN501113","HAS","Director of Public Health","Healthcare","353-NYC-HA Drug & Alcohol Service - Childrens - Rise","2025-10-01 00:00:00","78","36+18+24","1274000","1274000","Key Decision","Green"],
    [347,"Professional",null,"CS Resources","Technology","ICT","182-NYC-RS Corporate Planning, Project and Performance Management and Resourcing Solution(s)","2026-04-01 00:00:00","48","48","460000","552000","Yes","Green"],
    [348,"People","64869","CYPS","Children and Families","Social & Community Care Supplies & Services - Children","Inter Country Adoption","2025-04-01 00:00:00","12","12","22500","27000","No","Green"],
    [349,"Professional",null,"Community Development","Economic Development, Regeneration, Tourism and Skills","Catering","Sun Pavillion Catering Contract","2027-06-01 00:00:00",null,null,null,null,"Yes","Green"],
    [350,"People",null,"CS Resources","Customer, Revenues and Benefits","Social & Community Supplies & Services","454-NYC-RS Administration of the Household Support Fund","2026-04-01 00:00:00",null,null,null,null,"No","Green"],
    [351,"People",null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","434-NYC-HA Prevention and Wellbeing Service","2026-04-01 00:00:00","60","48+12","2171860",null,null,"Green"],
    [352,"Professional","97916","Community Development","Culture, Arts and Leisure","Arts & Leisure Services","271-NYC-CD Ticketing System","2025-10-01 00:00:00","60","36+24",null,"1400000","Yes","Green"],
    [353,"Professional","TBC","Environment","Highways, Transportation, Parking Services, Parks and Grounds","ICT","185-NYC-EN Cameras and system for Cawood Weighbridge","2025-04-01 00:00:00","60",null,"110000","125000","No","Green"],
    [354,"People","TBC","CS Local Engagement","Policy, Performance, Refugee / Asylum Issues and Community Safety","Social & Community Supplies & Services","291-NYC-LE Management of Gypsy, Roma and Traveller Sites including Domestic Abuse Support to Residents","2025-09-01 00:00:00",null,null,null,null,"Yes","Green"],
    [355,"Professional",null,"CS Resources","Technology","ICT","Online learning and workforce development platform","2024-12-03 00:00:00","24","24","103206","123847.2","No","Green"],
    [356,"Professional","TBC","CS Resources","Technology","ICT","187-NYC-RS - Event and Venue Management Software","2025-01-01 00:00:00","24","12+12","93922.62","112707.15","No","Green"],
    [357,"People",null,"CYPS","Inclusion","Education","369-NYC-HA Alternative Provision / EOTAS Approved Provider List","2026-04-01 00:00:00",null,null,null,null,"Yes","Green"],
    [358,"Professional",null,"CS Resources","Technology","ICT","Library Management System","2030-04-01 00:00:00","84","43+24+24","276374","331648.8","No","Green"],
    [359,"Professional",null,"CS Resources","Finance (inc. Pension Fund)","Financial Services","Pension Legal Advisors","2027-09-01 00:00:00","48","24+12+12","146800","176160","No","Green"],
    [360,"Place","No CAN done","Community Development","Housing","Housing Management","Kitchen Replacements for Council Owned Residential Dwellings","2023-09-18 00:00:00","36","24+12","4290000","5148000","TBC","Amber"],
    [361,"Professional","TBC","Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Cleaning & Janitorial","99-NYC-CD Purchase of Swimming Pool Chemicals","2025-09-01 00:00:00","48","36+12","400000",null,"TBC","Green"],
    [362,"Place","TBC","Community Development","Housing","Housing Management","Fencing and Gate Repair Works","2025-05-05 00:00:00","48","24+12+12","1800000","1800000",null,"Amber"],
    [363,"Place","tbc","CS Resources","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Environmental Services","Contract for roll out - delivery partner","2025-03-24 00:00:00",null,null,"95000",null,null,"Green"],
    [364,"People",null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Framework Agreement for Live-in Care","2026-04-01 00:00:00",null,null,null,null,"Yes","Green"],
    [365,"People",null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","100-NYC-HA Intermediate Care Beds","2025-11-01 00:00:00",null,null,"20000000",null,"Yes","Green"],
    [366,"Professional",null,"Community Development","Economic Development, Regeneration, Tourism and Skills","Consultancy","394-NYC-Abbey Quarter Regeneration - Feasibility","2025-07-01 00:00:00","18",null,"150000","180000","No","Green"],
    [367,"Place","tbc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Water Hygiene Risk Assessment, Monitoring and Works","2027-04-01 00:00:00","84","36+24+24","21000000",null,"TBC","Green"],
    [368,"Place","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","Decision Record","Green"],
    [369,"Professional","N/A","CS Resources","Technology","ICT","Customer Forms Platform","2025-04-01 00:00:00",null,null,null,null,"Key Decision","Green"],
    [370,"Professional","68417","CS Resources","Technology","ICT","191-NYC-RS Customer Relationship Management System","2025-04-01 00:00:00","20","12+8","164523.29","164523.29","Decision Record","Green"],
    [371,"People",null,"HAS","Prevention and Service Development","Social & Community Care Supplies & Services - Adults","Independent Advocacy Services","2026-04-01 00:00:00",null,null,null,null,"Yes","Green"],
    [372,"Professional","26112","CS Resources","Technology","ICT","Legal Services Case Management System","2025-03-01 00:00:00","72","24+24+24","139458","167349.6","Decision Record","Green"],
    [373,"Place","tbc","CS Resources","Property, Procurement and Commercial","Utilities","Supply of Gas",null,"48","24+24","9466666","11360000",null,"Green"],
    [374,"Place","tbc","Environment","Regulatory Services, Registration, Bereavement, Coroners Service","Cemetery & Crematorium","107-NYC-EN Woodfield Crematorium Scarborough - replacement cremators","2026-06-01 00:00:00",null,null,"2000000","2400000","Yes","Green"],
    [375,"Place","tbc","CS Resources","Property, Procurement and Commercial","Utilities","108-NYC-RS Meter Operator Services (MOp) Expiry TBC","2025-04-01 00:00:00","24","24","340422","357433","Decision Record","Amber"],
    [376,"Professional","DN511173","CS HR and business support","Business Support","Facilities & Management Services","Corporate Business Travel","2025-02-22 00:00:00","48","24+12+12+4","1075780","1290936","No","Green"],
    [377,"Professional","60544","CS Resources","Property, Procurement and Commercial","Catering","Provision of Food Harrogate Convention Centre","2025-04-17 00:00:00","24","12+12","1065888","1065888","No","Green"],
    [378,"Place","tbc","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Utilities","231-NYC-EN Potential generation of green hydrogen at Seamer Carr closed landfill site",null,null,null,null,null,null,"Green"],
    [379,"Professional",null,"Environment","Regulatory Services, Registration, Bereavement, Coroners Service","Consultancy","Project Management and Supervision Services for Major Projects","2025-06-30 00:00:00","60","48+24","1850000","2220000","Yes","Green"],
    [380,"Professional","TBC","Community Development","Economic Development, Regeneration, Tourism and Skills","Cleaning & Janitorial","275-NYC-CD - Event Cleaning Services","2025-06-02 00:00:00","48","24+12+12","700000","840000","Yes","Green"],
    [381,"Professional",null,"Community Development","Economic Development, Regeneration, Tourism and Skills","Catering","276-NYC-CD Event Catering and Banquet Staffing","2025-10-01 00:00:00","60","36+24","1000000","1200000","Yes","Green"],
    [382,"Professional",null,"Community Development","Economic Development, Regeneration, Tourism and Skills","Consultancy","277-NYC-RCS Coastal Change Adaption Plans","2025-06-01 00:00:00","10","10","90000","108000","TBC","Green"],
    [383,"Professional","95611","CS Resources","Human Resources","HR","278-NYC-RS Drug and Alcohol Testing","2025-10-03 00:00:00","48","48","100000","120000","Decision Record","Green"],
    [384,"Professional",null,"Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Health & Safety","324-NYC Event Medical Provision","2026-04-01 00:00:00","48",null,"440000","528000","TBC","Green"],
    [385,"Professional",null,"Community Development","Culture, Arts, Libraries, Museums, Archives, Key Venues & Leisure","Health & Safety","457-NYC-CD Events Portable Toilets","2026-04-01 00:00:00","48",null,"250000","300000","TBC","Green"],
    [386,"Professional",null,"Community Development","Economic Development, Regeneration, Tourism and Skills","Arts & Leisure Services","279-NYC-CD Scarborough Speedboat Licences","2025-04-01 00:00:00","120","120","254016","304818.2","Decision Record","Green"],
    [387,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","234-NYH-OO A1 Surfacing A10037 (including A1 Civils (A10033))","2025-07-01 00:00:00","4","4","2947042","3536450","No","Green"],
    [388,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","236-NYH-OO A1 Civils (landslip, Stonesdale to Ravenseat)","2025-06-01 00:00:00","6","6","203280","243936","No","Green"],
    [389,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","237-NYH-OO A1 Civils (Special, Church Bank + Mkt Place)","2025-08-01 00:00:00","3","3","200000","240000","No","Green"],
    [390,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","239-NYH-OO A1 Non LTP","2025-06-01 00:00:00","6","6","1600000","1920000","No","Green"],
    [391,"Place","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","3617184","4340621","No","Green"],
    [392,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","241-NYH-OO A2 Civils (Landslip) A20025  Area 2 25/26 Beakhills","2025-06-01 00:00:00","5","5","98842","118610","No","Green"],
    [393,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","242-NYH-OO A2 Civils (Thirsk Mkt Place)","2025-05-01 00:00:00","6","6","276400","331680","No","Green"],
    [394,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","243-NYH-OO A2 Sutton Bank A20026","2025-09-01 00:00:00","2","2","276400","331680","No","Green"],
    [395,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","244-NYH-OO A3 Surfacing A30023 Area 3 R&R and Patching (inc A40019)","2025-07-01 00:00:00","4","4","4064381","4877257","No","Green"],
    [396,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","245-NYH-OO A3 Civils A30024 (Landslip, Lealhom + Delves + Glenesk + Whitewall (A4) + Woodhouse (A4))","2025-06-01 00:00:00","6","6","530350","636420","No","Green"],
    [397,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","246-NYH-OO A3 Civils (Cattle grid)","2025-06-01 00:00:00","5","5","50000","60000","No","Green"],
    [398,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","247-NYH-OO A30016 A3 Civils (Special, Museum Tce + Mitford St)","2025-09-01 00:00:00","2","2","270000","324000","No","Green"],
    [399,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","249-NYH-OO A3 Non LTP","2025-06-01 00:00:00","6","6","500000","600000","No","Green"],
    [400,"Place","95466","NYH","NYH","Works - Construction, Repair & Maintenance","250-NYH-OO A4 Surfacing Area 4 - Tender Package 25 26 PSDP and R&R - A40017","2025-03-07 00:00:00","7","7","2489610","2987532","No","Green"],
    [401,"Place","95459","NYH","NYH","Works - Construction, Repair & Maintenance","251-NYH-OO A4 Civils (Landslip, Rosedale + another) - Area 4 Tender Package - Assessment - Rosedale Landslip - A40020","2025-03-28 00:00:00","7","7","1241350","1489620","No","Green"],
    [402,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","252-NYH-OO A4 Civils (Cattle grid)","2025-06-01 00:00:00","5","5","200000","240000","No","Green"],
    [403,"Place","97049","NYH","NYH","Works - Construction, Repair & Maintenance","253-NYH-OO A50010 - Area 5 and 7 Surfacing and PSD Patching 2025/26","2025-06-01 00:00:00","7","7","1501811","1802173.2","No","Green"],
    [404,"Place","97249","NYH","NYH","Works - Construction, Repair & Maintenance","254-NYH-OO A6 Surfacing (Just R&R) A60026","2025-06-01 00:00:00","5","5","1812650","2175180","No","Green"],
    [405,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","255-NYH-OO A6 Civils (Drainage)  A60028","2025-09-01 00:00:00","6","6","310000","372000","No","Green"],
    [406,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","256-NYH-OO A60027 A6 Civils (Landslip, A59 Skipton Rd + Gilsthwaite La + C379 Thorn Hill)","2025-07-01 00:00:00","4","4","215000","258000","No","Green"],
    [407,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","258-NYH-OO A6 Non LTP","2025-05-01 00:00:00","6","6","715000","858000","No","Green"],
    [408,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","259-NYH-OO A7 Surfacing","2025-07-01 00:00:00","4","4","1321524","1585829","No","Green"],
    [409,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","260-NYH-OO A7 Civils (Drainage, Stocking La + New Rd) A70014","2025-08-01 00:00:00","3","3","301640","361968","No","Green"],
    [410,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","261-NYH-OO A7 Civils (Specials)","2025-06-01 00:00:00","7","7","215100","258120","No","Green"],
    [411,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","262-NYH-OO A7 Micro Asphalt (includes A1 Micro Asphalt)","2025-05-01 00:00:00","6","6","527180","632616","No","Green"],
    [412,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","263-NYH-OO A7 Non LTP","2025-05-01 00:00:00","6","6","2400000","2880000","No","Green"],
    [413,"People",null,"HAS","Director of Public Health","Healthcare","301-NYC-HA Substance Use Service - Adults and Children's","2026-04-01 00:00:00",null,null,"37460000","44952000","Yes","Green"],
    [414,"Place","TBC","Community Development","Housing","Works - Construction, Repair & Maintenance","266-NYC-CD Rewire and CO Testing","2025-04-01 00:00:00",null,null,"0","0",null,"Amber"],
    [415,"Place","79343","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Lifting Equipment","2025-04-01 00:00:00","84","36+24+24","7140000","8568000","TBC","Green"],
    [416,"Place","76276","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Mechanical Equipment","2025-04-01 00:00:00","84","36+24+24","105000000","126000000","TBC","Green"],
    [417,"Place","79486","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Automatic Doors","2025-04-01 00:00:00","84","36+24+24","4200000","5040000","TBC","Green"],
    [418,"Place","tbc","CS Resources","Property, Procurement and Commercial","Facilities & Management Services","Asbestos Analysis","2025-04-01 00:00:00","84","36+12+12","10000000","12000000","TBC","Green"],
    [419,"Place","95074","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","281-NYC-EN Hawes Station Saddle Emergency Works","2025-03-01 00:00:00","2","2","150000","180000",null,"Green"],
    [420,"Place","tbc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Care and Support Hubs","2025-11-01 00:00:00",null,null,"60000000",null,"Yes","Green"],
    [421,"People",null,"HAS","Director of Public Health","Social & Community Care Supplies & Services - Adults","Lived Experience Recovery Organisations","2026-04-01 00:00:00","48",null,"400000",null,"TBC","Green"],
    [422,"Place","tbc","Community Development","Culture, Arts and Leisure","Works - Construction, Repair & Maintenance","292-NYC-CD Studio 2 Harrogate Convention Centre HCC","2026-01-01 00:00:00","12","12","7000000","8400000","Yes","Green"],
    [423,"Place","96077","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","293-NYC-RS Scarborough North Bay Development","2026-01-01 00:00:00",null,"tbc","19000000","22800000","Yes","Green"],
    [424,"Professional","68062","CS Resources","Technology","ICT","webCAPTURE Suite - Harrogate","2025-03-01 00:00:00","36","24+12","105000","126000","No","Green"],
    [425,"Place","tbc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","376-NYC-RS 5-12 St. Marys Walk Hemingbrough","2026-04-01 00:00:00",null,null,"700000","840000","Yes","Green"],
    [426,"Professional","64566","CS Resources","Technology","ICT","Back Office System for English National Concessionary Travel Scheme","2024-10-07 00:00:00","48","36+12","600000","720000",null,"Green"],
    [427,"Professional",null,"Community Development","Culture, Arts and Leisure","Health & Safety","Event Health and Safety Services","2027-04-01 00:00:00",null,"60","310000",null,"TBC","Green"],
    [428,"Professional",null,"Community Development","Culture, Arts and Leisure","Health & Safety","Event Noise Monitoring Services","2027-04-01 00:00:00","60",null,"125000",null,"TBC","Green"],
    [429,"Professional",null,"Community Development","Planning","Consultancy","Strategic Flood Risk Assessment","2025-04-30 00:00:00",null,null,"150000","180000","TBC","Green"],
    [430,"Professional","TBC","Community Development","Planning","Consultancy","397-NYC-CD Landscape Character Assessment","2025-04-30 00:00:00",null,null,"250000","300000","TBC","Green"],
    [431,"Professional","TBC","Community Development","Planning","Consultancy","Whole Plan Viability Assessment","2025-08-30 00:00:00",null,null,"100000","120000","TBC","Green"],
    [432,"Professional",null,"Community Development","Planning","Consultancy","Infrastructure Capacity Study","2025-05-30 00:00:00",null,null,"200000","240000","TBC","Green"],
    [433,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","385-NH-OO A30025 A3 Civils (Drainage, Storr la)","2025-08-18 00:00:00",null,null,"150000","180000","No","Green"],
    [434,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","386-NYH-OO A6 Civil (Crossings, Wetherby + Oatlands)","2025-06-01 00:00:00","3","3","300000","360000","No","Green"],
    [435,"Place","tbc","NYH","NYH","Works - Construction, Repair & Maintenance","387-NYH-OO A7 Non LTP","2025-08-01 00:00:00","6","6","2400000","2880000","No","Green"],
    [436,"Professional",null,"CS Resources","Technology","ICT","Harrogate Backup and Disaster Recovery Contracts","2025-08-01 00:00:00",null,null,null,null,null,"Green"],
    [437,"Place","tbc","Central Services","Property, Procurement and Commercial","Utilities","Supply of gas","2028-04-01 00:00:00","48","48","12000000","14400000","Yes","Green"],
    [438,"Place","tbc","Central Services","Property, Procurement and Commercial","Utilities","Supply of pottable water","2028-10-01 00:00:00","48","48","10500000","12600000","Yes","Green"],
    [439,"Place","97309","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","399-NYC-EN Gallows Bridge Replacement - Skipton (TCF)","2025-06-01 00:00:00","8","8","400000","480000","No","Green"],
    [440,"Place","tbc","Environment","Environmental Services inc. low Carbon, Natural Capital & Waste Services","Vehicle Management","396-NYC-EN The Supply and Maintenance of Municipal Vehicles","2015-07-07 00:00:00","240","120 + 120","18000000","21600000",null,"Green"],
    [441,"Place","tbc","Community Development","Housing","Consultancy","401-NYC-CD Stock Condition Surveys – Housing Properties","2025-06-01 00:00:00","60","60","5000000","6000000","Yes","Green"],
    [442,"People","66017","HAS","Director of Public Health","Social & Community Care Supplies & Services - Adults","Workplace Cardiovascular Disease Health Checks (Pilot)","2025-03-31 00:00:00","6","6","28000","33600","No","Green"],
    [443,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","418-NYC-EN 2025-2029 Diving Framework",null,"48","48","250000","300000",null,"Green"],
    [444,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","403-NYC-EN Escoe House Culvert Repair","2025-08-01 00:00:00","3","3","100000","120000",null,"Green"],
    [445,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","405-NYC-EN North (Ripon) Major repair works","2025-08-01 00:00:00","3","3","250000","300000",null,"Green"],
    [446,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","406-NYC-EN Low Green Concrete Invert","2025-08-01 00:00:00","3","3","80000","96000",null,"Green"],
    [447,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","408-NYC-EN Kirk Gill (APS) Saddle","2025-08-01 00:00:00","3","3","120000","140000",null,"Green"],
    [448,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","409-NYC-EN Holme Beck Path Wall Ret wall works","2025-09-01 00:00:00","3","3","100000","120000",null,"Green"],
    [449,"Place","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","2025-11-01 00:00:00","3","3","200000","240000",null,"Green"],
    [450,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","411-NYC-EN Kirklington Replace structure","2026-07-01 00:00:00","3","3","200000","240000",null,"Green"],
    [451,"Place","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",null,"Green"],
    [452,"Place","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","2026-09-01 00:00:00","3","3","2000000","240000",null,"Green"],
    [453,"Place","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",null,"Green"],
    [454,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","416-NYC-EN West Stonesdale Wall rebuild","2025-10-01 00:00:00","3","3","80000","96000",null,"Green"],
    [455,"Place","tbc","Environment","Highways, Transportation, Parking Services, Parks and Grounds","Works - Construction, Repair & Maintenance","417-NYC-EN Newton Grange Canal Strengthening (Changeline)","2025-10-01 00:00:00","3","3","100000","120000",null,"Green"],
    [456,"Place","tbc","NYH","NYH","Vehicle Management","Leased MEWP","2026-04-01 00:00:00",null,"tbc","640000","768000",null,"Green"],
    [457,"Professional","58301","CS Resources","Technology","ICT","Revenues & Benefits System","2025-03-30 00:00:00","84","60+24","4101757","4922108",null,"Green"],
    [458,"Place","tbc","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","2025-10-01 00:00:00","5","5","710000","852000",null,"Green"],
    [459,"Place","tbc","CS Resources","Property, Procurement and Commercial","Utilities","Liquid Fuels for NYC, NY H and Harbours","2028-04-01 00:00:00","48","48","16000000","19200000","Yes","Green"],
    [460,"Place","tbc","Community Development","Housing","Housing Management","Heating Appliance Auditing","2025-10-25 00:00:00","36","12+12+12","135000","162000",null,"Green"],
    [461,"Place","tbc","CS Resources","Property, Procurement and Commercial","Utilities","108-NYC-RS Meter Operator Services (Mop)","2025-04-01 00:00:00","36","36",null,null,null,"Green"],
    [462,"Place","tbc","NYH","NYH","Environmental Services","Provision of Civil Engineering Coring and Testing","2025-05-01 00:00:00","48","24+12+12","2240000","2688000",null,"Green"],
    [463,"Professional","64459","CS Legal and Democratic Services","Elections","Stationery","447-NYC-CD Election printing services","2025-04-01 00:00:00","48","24+24","1475000","1770000","No","Green"],
    [464,"Place","tbc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","Fixed Electrical Inspection, Responsive Maintenance and High Voltage","2026-02-01 00:00:00","84","36+24+24","12152267","14582720","Yes","Green"],
    [465,"Place","tbc","CS Resources","Property, Procurement and Commercial","Works - Construction, Repair & Maintenance","460-NYC-RS Stage Lighting Inspection and Maintenance","2026-02-01 00:00:00","84","36+24+24","1149957","1379949","Yes","Green"],
    [466,"People",null,"HAS","Director of Public Health","Healthcare","461-NYC-HA Pharmacotherapy Patient Group Directive (PGD)",null,"36","36",null,null,"Yes","Green"]
]}
