Table:
text: Minister for Community Safety and Legal Affairs
Minister for Community Safety and Legal Affairs
Minister for Community Safety and Legal Affairs
Name_ Entered_office Left_office Party First_Minister
Name Entered office Left office Party First Minister
Angus MacKay 19 May 1999 2 November 2000 Labour Donald Dewar
Iain Gray 2 November 2000 28 November 2001 Labour Henry McLeish
Richard Simpson 28 November 2001 26 November 2002 Labour Jack McConnell
Hugh Henry 28 November 2002 14 November 2006 Labour Jack McConnell
Johann Lamont 16 November 2006 17 May 2007 Labour Jack McConnell
Minister for Community Safety Minister for Community Safety Minister for Community Safety Minister for Community Safety Minister for Community Safety
Fergus Ewing 17 May 2007 20 May 2011 Scottish National Party Alex Salmond

Question: When did First Minister Henry Mcleish take office as Secretary of State for Local Safety and Legal Affairs?

Question: What is the name of the Minister for Community Security and Legal Affairs who left office on November 14, 2006?

Question: What is the party of the Minister for Community Security and Legal Affairs who resigned on 26 November 2002?

Question: What is Richard Simpson's party under Secretary of State for Community Security and Legal Affairs?