CREATE TABLE table_39466 ("Name" TEXT, "Status" TEXT, "Population" FLOAT, "District" TEXT, "Former local authority" TEXT)

What is the district for the parish, Brough?
SELECT "District" FROM table_39466 WHERE "Name" = 'brough'
SELECT "District" FROM "table_39466" WHERE "Name" = 'brough'