c_participant

1,297,111 rows

✎ View and edit SQL

Suggested facets: participant_id, participant_group, participant_role, name_prefix, mid_name, name_suffix, state, phone_ext, fax_num, afl_cio, incumbent_union, local_dist_id, party_scope, parti_type

c_case_number participant_id participant_group participant_role name_for_correspondence name_prefix first_name mid_name last_name name_suffix street_address_1 street_address_2 city state zip phone_num phone_ext cell_phone fax_num e_mail_address formal_name parent_name exclusive_service afl_cio incumbent_union labor_org_code local_dist_id party_scope parti_type
01-CA-19224-001 1 CdP01 Party Brown & Sharpe Manufacturing Company Mr. John   Gordon   Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-19224-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-19224-001 3 CgP01 Party International Association of Machinists & Aerospace Workers, Local Lodges 1142, 1088 and 883, Distri Mr. John   Kennedy   Suite 2348 420 Lexington Avenue New York NY 10170           International Association of Machinists and Aerospace Workers, Local Lodge 264, District Lodge 38, AFL-CIO   N Y U 33700   Sngle U
01-CA-19224-001 4 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-19958-001 1 CdP01 Party Brown & Sharpe Manufacturing Company Mr. John   Gordon   Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-19958-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-19958-001 3 CgP01 Party International Association of Machinists & Aerospace Workers, Local Lodges 1142, 1088 and 883, Distri Mr. John   Kennedy   Suite 2348 420 Lexington Avenue New York NY 10170           International Association of Machinists and Aerospace Workers, Local Lodge 264, District Lodge 38, AFL-CIO   N Y U 33700   Sngle U
01-CA-19958-001 4 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-19958-001 5 CgP01 AddS1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-19958-001 6 CgP01 AddS2 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-20291-001 1 CdP01 Party Brown & Sharpe Manufacturing Company Mr. John   Gordon   Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-20291-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-20291-001 3 CgP01 Party International Association of Machinists & Aerospace Workers, Local Lodges 1142, 1088 and 883, Distri Mr. John   Kennedy   Suite 2348 420 Lexington Avenue New York NY 10170           International Association of Machinists and Aerospace Workers, Local Lodge 264, District Lodge 38, AFL-CIO   N Y U 33700   Sngle U
01-CA-20291-001 4 CgP01 AddS1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-20291-001 5 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-20304-001 1 CdP01 Party Brown & Sharpe Manufacturing Company Mr. John   Gordon   Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-20304-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-20304-001 3 CgP01 Party International Association of Machinists & Aerospace Workers, Local Lodges 1142, 1088 and 883, District Lodge 64, AFL-CIO Mr. John   Kennedy   Suite 2348 420 Lexington Avenue New York NY 10170           International Association of Machinists & Aerospace Workers, Local Lodges 1142, 1088 and 883, District Lodge 64, AFL-CIO   N Y U 33700   Sngle U
01-CA-20304-001 4 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-20304-001 5 CgP01 AddS1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-20508-001 1 CdP01 Party Brown & Sharpe Manufacturing Company Mr. John   Gordon   Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-20508-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-20508-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO Mr. Robert   Thayer   Business Representative 78 Kenwood St. Cranston RI 02907           International Association of Machinists and Aerospace Workers, Local Lodge 264, District Lodge 38, AFL-CIO   N Y U 33700   Sngle U
01-CA-20508-001 4 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-20508-001 5 CgP01 AddS1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-21560-001 1 CdP01 Party Brown & Sharpe Manufacturing Company Mr. Richard   Jocelyn   Industrial Relations Manager Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-21560-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-21560-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Ms. Alison   Beck Esq. IAM Headquarters 9000 Machinists Place, Room 202 Upper Marlboro MD 20772 (301)967-4510     (301)967-4594   International Association of Machinists and Aerospace Workers, Local Lodge 264, District Lodge 38, AFL-CIO   N Y U 33700   Sngle U
01-CA-21560-001 4 CgP01 AddS1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-21943-001 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-21943-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-21943-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700 Lodge 64 Sngle U
01-CA-22040-002 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-22040-002 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-22040-002 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700   Sngle U
01-CA-22687-001 1 CdP01 Party Rimoldi Sportswear, Inc., Computex Corp., Phillip Beninati Mr. Phillip   Beninati   9 Prescott St.   Somerville MA 02143           Rimoldi Sportswear, Inc., Computex Corp., Phillip Beninati   N         Sngle E
01-CA-22687-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-22687-001 3 CgP01 Party Boston Joint Board, International Ladies' Garment Workers' Union, AFL-CIO           33 Harrison Avenue   Boston MA 02111           Boston Joint Board, International Ladies' Garment Workers' Union, AFL-CIO   N Y U 58600   Sngle U
01-CA-22687-001 4 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-22769-001 1 CdP01 Party Rimoldi Sportswear, Inc.; Computex Corp./ Phillip Beninati Mr. Philip   Beninati   9 Prescott St.   Somerville MA 02143 (781)625-3780         Rimoldi Sportswear, Inc.; Computex Corp.; Philip Beninati   N         Sngle E
01-CA-22769-001 2 CgP01 Party Union of Needletrades, Industrial and Textile Employees, AFL-CIO, CLC Mr. Warren   Pepicelli   33 Harrison Avenue   Boston MA 02111 (617)426-9350     (617)426-7684   Boston Joint Board, International Ladies' Garment Workers' Union, AFL-CIO   N Y U 58600   Sngle U
01-CA-22769-001 3 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-22869-001 1 CdP01 Party Rimoldi Sportswear, Inc., Computex Corp. & Phililip Beninati Mr. Phillip   Beninati   9 Prescott St.   Somerville MA 02143           Rimoldi Sportswear, Inc., Computex Corp., Philip Beninati   N         Sngle E
01-CA-22869-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-22869-001 3 CgP01 Party Boston Joint Board, International Ladies' Garment Workers' Union, AFL-CIO           33 Harrison Avenue   Boston MA 02111           Boston Joint Board, International Ladies' Garment Workers' Union, AFL-CIO   N Y U 58600   Sngle U
01-CA-22869-001 4 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-23307-001 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-23307-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-23307-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700   Sngle U
01-CA-23576-001 1 CdP01 Party Rimoldi Sportswear, Inc., Computex Corp., Phillip Beninati Mr. Phillip   Beninati   9 Prescott St.   Somerville MA 02143           Rimoldi Sportswear, Inc., Computex Corp., Phillip Beninati   N         Sngle E
01-CA-23576-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-23576-001 3 CgP01 Party Boston Joint Board, International Ladies' Garment Workers' Union, AFL-CIO           33 Harrison Ave.   Boston MA 02111           Boston Joint Board, International Ladies' Garment Workers' Union, AFL-CIO   N Y U 58600   Sngle U
01-CA-23576-001 4 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-23748-001 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-23748-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-23748-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700 Local 64 Sngle U
01-CA-24161-001 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-24161-001 2 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700 District Lodge 64 Sngle U
01-CA-24161-001 3 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-24390-002 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-24390-002 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-24390-002 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700 Lodge 64 Sngle U
01-CA-24528-001 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-24528-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-24528-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700   Sngle U
01-CA-24921-001 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-24921-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-24921-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700 64 Sngle U
01-CA-24967-001 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-24967-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-24967-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700 64 Sngle U
01-CA-25033-001 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-25033-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25033-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 883, 1088, 1142, AFL-CIO   N Y U 33700 Local Lodges 883, 1088, 1142 Sngle U
01-CA-25237-001 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-25237-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25237-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700 883, 1088,1142 Sngle U
01-CA-25237-002 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-25237-002 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25237-002 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700 883, 1088, 1142 Sngle U
01-CA-25341-001 1 CdP01 Party Brown & Sharpe Manufacturing Company           Director Industrial Relations Precision Park North Kingstown RI 02852           Brown & Sharpe Manufacturing Company   N         Sngle E
01-CA-25341-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25341-001 3 CgP01 Party International Association of Machinists and Aerospace Workers, AFL-CIO Mr. William   Rudis   Eastern Territory Office 135 Merchant Street, Suite 265 Cincinnati OH 45246 (513)772-9310     (513)612-3166   International Association of Machinists and Aerospace Workers, District Lodge 64, AFL-CIO   N Y U 33700   Sngle U
01-CA-25521-001 1 CdP01 Party Silver Brothers Co., Inc. d/b/a The Good Life Beverage Company Mr. Parry   Robson   Grenier Industrial Village P.O. Box 4060 Manchester NH 03108           Silver Brothers Company, Inc. d/b/a The Good Life Beverage Company and Victor W. Dahar   N         Sngle E
01-CA-25521-001 2 CgP01 Party Chauffeurs, Teamsters & Helpers Local Union No. 633, a/w IBTCWHA, AFL-CIO           265 Maple Street   Manchester NH 03103           Chauffeurs, Teamsters & Helpers Local Union No. 633, a/w IBTCWHA, AFL-CIO   N Y U 54900   Sngle U
01-CA-25599-001 1 CdP01 Party Rimoldi Sportswear, Inc., Computex Corp., & Phillip Beninati Mr. Phillip   Beninati   9 Prescott St.   Somerville MA 02143           Rimoldi Sportswear, Inc., Computex Corp., & Phillip Beninati   N         Sngle E
01-CA-25599-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25599-001 3 CgP01 Party Boston Joint Board, International Ladies' Garment Workers' Union, AFL-CIO           33 Harrison Avenue   Boston MA 02111           Boston Joint Board, International Ladies' Garment Workers' Union, AFL-CIO   N Y U 58600   Sngle U
01-CA-25599-001 4 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25656-001 1 CdP01 Party Eastern Marine Construction, Inc. Ms. Mary   Lawson   Suite 23 3 Bud Way Nashua NH 03063           Eastern Marine Construction, Inc.   N         Sngle E
01-CA-25656-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25656-001 3 CgP01 Party An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N           I
01-CA-25656-001 4 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25736-001 1 CdP01 Party Sportswear Group, Inc. Mr. Frank   Capaldo   President 982 Bennington St. East Boston MA 02128           Sportswear Group, Inc   N         Sngle E
01-CA-25736-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25736-001 3 CgP01 Party New England Regional Joint Board, Union of Needletrades, Industrial and Textile Employees, AFL-CIO (UNITE) Mr. Sam   Giurleo   33 Harrison Avenue   Boston MA 02111           New England Regional Joint Board, Union of Needletrades, Industrial, and Textile Employees, AFL-CIO (UNITE)   N Y U 58600   Sngle U
01-CA-25736-001 4 CgP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25736-001 5 CgP01 AddS1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
01-CA-25805-001 1 CdP01 Party Rimoldi Sportswear, Inc., Computex Corp., Phillip Beninati Mr. Phillip   Beninati   9 Prescott St.   Somerville MA 02143           Rimoldi Sportswear, Inc., Computex Corp., Phillip Beninati   N         Sngle E
01-CA-25805-001 2 CdP01 LRep1 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            

Next page

Download this data

CSV · JSON

Table schema 
CREATE TABLE c_participant(c_case_number VARCHAR, participant_id BIGINT, participant_group VARCHAR, participant_role VARCHAR, name_for_correspondence VARCHAR, name_prefix VARCHAR, first_name VARCHAR, mid_name VARCHAR, last_name VARCHAR, name_suffix VARCHAR, street_address_1 VARCHAR, street_address_2 VARCHAR, city VARCHAR, state VARCHAR, zip VARCHAR, phone_num VARCHAR, phone_ext VARCHAR, cell_phone VARCHAR, fax_num VARCHAR, e_mail_address VARCHAR, formal_name VARCHAR, parent_name VARCHAR, exclusive_service VARCHAR, afl_cio VARCHAR, incumbent_union VARCHAR, labor_org_code BIGINT, local_dist_id VARCHAR, party_scope VARCHAR, parti_type VARCHAR);