CREATE TABLE table_14843 ("Minister" CLOB, "Party" CLOB, "Start date" CLOB, "End date" CLOB, "Prime Minister" CLOB)

Name the minister for end date of 31 july 2004
SELECT "Minister" FROM table_14843 WHERE "End date" = '31 july 2004'
SELECT "Minister" FROM "table_14843" WHERE "End date" = '31 july 2004'