gistfile1.txt

mysql> select * from bioguide_legislator where party not in('Republican', 'Democrat', 'Independent', 'Democrat Farmer Labor', 'New Progressive', 'Independence Party (Minnesota)');
+------+-------------+--------+-------------------------+----------+--------+-------------+----------------+-------------------------+-------+----------+
| id   | bioguide_id | prefix | first                   | last     | suffix | birth_death | position       | party                   | state | congress |
+------+-------------+--------+-------------------------+----------+--------+-------------+----------------+-------------------------+-------+----------+
|  327 | M001183     |        | III, Joe                | MANCHIN  |        | 1947-  | Senator        | Democratic              | WV    | 111      |
|  455 | S001177     |        | Gregorio Kilili Camacho | SABLAN   |        | 1955-  | Delegate       | Independent/Democrat    | MP    | 111      |
| 1885 | H000067     |        | Ralph Moody             | HALL     |        | 1923-  | Representative | Democrat/Republican     | TX    | 108      |
| 2405 | G000280     |        | Virgil H                | GOODE    | Jr.    | 1946-  | Representative | Independent/Republican  | VA    | 107      |
| 2472 | J000072     |        | James Merrill           | JEFFORDS |        | 1934-  | Senator        | Republican; Independent | VT    | 107      |
| 2959 | G000280     |        | Virgil H                | GOODE    | Jr.    | 1946-  | Representative | Democrat/Independent    | VA    | 106      |
| 3091 | M000206     |        | Matthew Gilbert         | MARTINEZ |        | 1929-  | Representative | Democrat/Republican     | CA    | 106      |
| 4844 | T000058     |        | Wilbert Joseph (Billy)  | TAUZIN   |        | 1943-  | Representative | Democrat;Republican     | LA    | 104      |
| 5749 | L000243     |        | Norman Frederick        | LENT     |        | 1931-  | Representative | Republican-Conservative | NY    | 102      |
| 5911 | S000124     |        | James Haas              | SCHEUER  |        | 1920-2005   | Representative | Democrat-Liberal        | NY    | 102      |
| 6300 | L000243     |        | Norman Frederick        | LENT     |        | 1931-  | Representative | Republican-Conservative | NY    | 101      |
| 6433 | R000354     |        | Tommy Franklin          | ROBINSON |        | 1942-  | Representative | Democrat/Republican     | AR    | 101      |
| 6460 | S000124     |        | James Haas              | SCHEUER  |        | 1920-2005   | Representative | Democrat-Liberal        | NY    | 101      |
+------+-------------+--------+-------------------------+----------+--------+-------------+----------------+-------------------------+-------+----------+