user: ### NOW ANSWER:
Question: Name the party for  John Randolph Redistricted from the 15th district
Columns: ['District', 'Incumbent', 'Party', 'First elected', 'Result', 'Candidates']
Types: ['text', 'text', 'text', 'text', 'text', 'text']
Sample row: ['Virginia 1', 'Thomas Wilson', 'Federalist', '1811', 'Lost re-election Democratic-Republican gain', 'John G. Jackson (DR) 60.2% Thomas Wilson (F) 39.8%']
SQL:

assistant: SELECT "Party" FROM "Table" WHERE "Incumbent" = 'John Randolph Redistricted from the 15th district';