CREATE TABLE table_204_223 (id NUMBER, "party" CLOB, "previous council" NUMBER, "staying councillors" NUMBER, "seats up for election" NUMBER, "election result" NUMBER, "new council" NUMBER)

which is the only one with 2 new council
SELECT "party" FROM table_204_223 WHERE "new council" = 2
SELECT "party" FROM "table_204_223" WHERE "new council" = 2