r_participant

236,073 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ r_case_number participant_id participant_role participant_group 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 incumbent_union labor_org_code local_dist_id afl_cio party_scope parti_type
1 1 01-AC-00093 1 Party Employer #1 Emp01 Bath Iron Works Corporation Mr. Gregory   Black   MS 2150, 700 Washington Street   Bath ME 04530 (207)442-4770         Bath Iron Works Corporation   N         Single Sngle Employer E
2 2 01-AC-00093 2 Party Petitioner #1 Pet01 Bath Marine Draftsmen's Association           P.O. Box 213   Bath ME 04530           Bath Marine Draftsmen's Association   N U International Union, United Automobile, Aerospace and Agricultural Implement Workers of America, AFL-CIO (UAW) 57600   Y Single Sngle Union U
3 3 01-AC-00093 3 Legal Representative #1 LRep1 Petitioner #1 Pet01 UAW Legal Department An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
4 4 01-AC-00094 1 Party Employer #1 Emp01 Brigham and Women's Hospital           75 Francis Street   Boston MA 02115 (617)951-7000         Brigham and Women's Hospital   N         Single Sngle Employer E
5 5 01-AC-00094 2 Legal Representative #1 LRep1 Employer #1 Emp01 Ropes & Gray An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
6 6 01-AC-00094 3 Party Petitioner #1 Pet01 International Union of Operating Engineers, Local 877 AFL-CIO Mr. Allen R. McWade   89 Access Road, Unit 4   Norwood MA 02062 (781)769-1877     (781)769-2165   International Union of Operating Engineers, Local 877, AFL-CIO   N U International Union of Operating Engineers, AFL-CIO (IUOE) 42300 Local 877 Y Single Sngle Union U
7 7 01-AC-00094 4 Party Petitioner #2 Pet02 International Brotherhood of Electrical Workers, Local 103, AFL-CIO Mr. Richard P. Gambino   256 Freeport Street   Dorchester MA 02122           International Brotherhood of Electrical Workers, Local 103, AFL-CIO   N U International Brotherhood of Electrical Workers, AFL-CIO (IBEW) 25200 Local 103 Y Single Sngle Union U
8 8 01-AC-00094 5 Party Petitioner #3 Pet03 Plumbers and Gasfitters Local 12 Mr. Kevin L. Cotter   John A. McGinness, Business Agent 1240 Massachusetts Avenue Boston MA 02125           Plumbers and Gasfitters Local 12   N U United Association of Journeymen and Apprentices of the Plumbing and Pipe Fitting Industry of the United States and Canada, AFL-CIO (PPF) 44800 Local 12 Y Single Sngle Union U
9 9 01-AC-00094 6 Party Petitioner #4 Pet04 Boston District Council of Carpenters, AFL-CIO Mr. Henry J. Welsh   760 Adams Street   Dorchester MA 02122           Boston District Council of Carpenters, AFL-CIO   N U United Brotherhood of Carpenters and Joiners of America (UBC) 11100   Y Single Sngle Union U
10 10 01-AC-00094 7 Party Petitioner #5 Pet05 International Brotherhood of Paitners and Allied Trades, District Council 35 Mr. Ralph   Harriman   Mr. Jim Snow 25 Colgate Road, Suite 305 Roslindale MA 02131           International Union of Painters and Allied Trades, District Council 35   N U International Union of Painters and Allied Trades, AFL-CIO, CLC 42800 District Council 35 Y Single Sngle Union U
11 11 01-AC-00094 8 Legal Representative #1 LRep1 Petitioner #1 Pet01 Robert M. Cheverie and Associates, P.C. An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
12 12 01-AC-00095 1 Party Employer #1 Emp01 Valley Air Services, Inc. d/b/a Heritage Flight Services Mr. Andrew   Button   P.O. Box 2365   S. Burlington VT 95496 (802)658-9573         Valley Air Services, Inc. d/b/a Heritage Flight Services   N         Single Sngle Employer E
13 13 01-AC-00095 2 Party Petitioner #1 Pet01 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, Local Lodge 1726, District Lodge 141, AFL-CIO   N U International Association of Machinists and Aerospace Workers, AFL-CIO (IAM) 33700 Local Lodge 1726, District Lodge 141 Y Single Sngle Union U
14 14 01-AC-00095 3 Additional Service #1 AddS1 Petitioner #1 Pet01 International Association of Machinists and Aerospace Workers, AFL-CIO An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
15 15 01-AC-00096 1 Party Employer #1 Emp01 Emerson College Mr. William   McCabe   120 Boylston Street   Boston MA 02116           Emerson College   N         Single Sngle Employer E
16 16 01-AC-00096 2 Party Petitioner #1 Pet01 Emerson College Police Patrolman's Association Mr. Robert   Fasulo   19 Broad Street   Wilmington MA 01887 (617)824-8555         Emerson College Police Patrolman's Association   N U UNKNOWN 91002   U Single Sngle Union U
17 17 01-AC-00097 1 Party Employer #1 Emp01 M.V.M., Inc. Mr. Edward   Hayes   Six Downtown Boston Buildings 1593 Spring Hill Road, 7th Floor Vienna VA 22182 (703)245-9734     (703)827-0780   M.V.M., Inc.   N         Single Sngle Employer E
18 18 01-AC-00097 2 Party Petitioner #1 Pet01 New England Security Officers Association           P.O. Box 6724   Boston MA 02114           New England Security Officers Association   N U None 90003   U Single Sngle Union U
19 19 01-AC-00097 3 Legal Representative #1 LRep1 Petitioner #1 Pet01 Sandulli Grace, PC An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
20 20 01-AC-00097 4 Legal Representative #1 LRep1 Employer #1 Emp01 Littler Mendelson, P.C. An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
21 21 01-AC-00098 1 Party Employer #1 Emp01 Sterling Suffolk Racecourse, LLC Mr. Johon   Rizzo   111 Waldemar Avenue   East Boston MA 02128 (617)567-3900     (617)568-9005   Sterling Suffolk Racecourse, LLC   N         Single Sngle Employer E
22 22 01-AC-00098 2 Party Petitioner #1 Pet01 International Union, Security, Police and Fire Professionals of America (SPFPA) Mr. Steve   Maritas   Mr. David L. Hickey, Int'l President 25510 Kelly Road Roseville MI 48066 (586)772-7250     (685)772-9644   International Union, Security, Police and Fire Professionals of America (SPFPA)   N Y International Union, Security, Police, and Fire Professionals of America (SPFPA) 63055   N Single Sngle Union U
23 23 01-AC-00098 3 Legal Representative #1 LRep1 Petitioner #1 Pet01 Gregory, Moore, Jeakle, Heinen & Brooks, PC An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
24 24 01-AC-00098 4 Additional Service #1 AddS1 Petitioner #1 Pet01 International Union, Security, Police and Fire Professionals of America, Region 6 An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
25 25 01-AC-00098 5 Party Employer #2 Emp02 U. S. Security Associates, Inc. Mr. John   Marshall   200 Mansell Court, 5th Floor   Roswell GA 30076 (770)625-1550     (770)625-1462   U. S. Security Associates, Inc.   N         Single Sngle Employer E
26 26 01-AC-00098 6 Party Employer #3 Emp03 U.S. Security Associates, Inc. Mr. John   Paretti   262 Washington Street, Room 900   Boston MA 02109 (617)973-4554     (617)973-5885   U. S. Security Associates, Inc.   N         Single Sngle Employer E
27 27 01-AC-00098 7 Legal Representative #1 LRep1 Employer #2 Emp02 Ford and Harrison An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
28 28 01-AC-00098 8 Legal Representative #1 LRep1 Employer #1 Emp01 Goulston & Storrs An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
29 29 01-AC-00099 1 Party Employer #1 Emp01 Asset Protection Associates Mr. John   Nugent   60 Rogers Street, Suite No. 8   Manchester NH 03103 (800)630-8228     (603)669-7463   Asset Protection Associates   N         Single Sngle Employer E
30 30 01-AC-00099 2 Party Petitioner #1 Pet01 International Union, Security, Police and Fire Professionals of America (SPFPA) Mr. Steve   Maritas   25510 Kelly Road   Roseville MI 48066 (586)772-7250     (586)772-9644   International Union, Security, Police and Fire Professionals of America (SPFPA)   N Y International Union, Security, Police, and Fire Professionals of America (SPFPA) 63057   N Single Sngle Union U
31 31 01-AC-00099 3 Legal Representative #1 LRep1 Employer #1 Emp01 Holland & Knight LLP An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
32 32 01-AC-00100 1 Party Employer #1 Emp01 Westerly Ambulance Corps. Inc. Mr. Michael   Previte   30 Chestnut Street   Westerly RI 02891 (401)596-4375     (401)596-8942   Westerly Ambulance Corps. Inc.   N         Single Sngle Employer E
33 33 01-AC-00100 2 Party Petitioner #1 Pet01 Rhode Island Laborers' District Council, a/w Laborers' International Union of North America, Local Union No. 1322 Mr. Ronald R. Coia   410 South Main Street   Providence RI 02903 (401)751-6565     (401)751-1591 Ron@rildc.org Rhode Island Laborers' District Council, a/w Laborers' International Union of North America, Local Union No. 1322   N Y Laborers' International Union of North America (LIUNA) 31700 Local 1322 N Single Sngle Union U
34 34 01-AC-00100 3 Additional Service #1 AddS1 Petitioner #1 Pet01 Laborers International Union of North America An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
35 35 01-AC-00100 4 Legal Representative #1 LRep1 Employer #1 Emp01 Romano, Spinella, D'Allessandro & Wright, LLC An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
36 36 01-AC-00100 5 Additional Service #1 AddS1 Employer #1 Emp01   An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
37 37 01-AC-00101 1 Party Employer #1 Emp01 St. Joseph Hospital Health Services of Rhode Island Mr. Anthony   Rizzotti Esq. 21 Peace Street   Providence RI 02907 (617)378-6009   (978)460-1046 (617)904-1938 arizzotti@littler.com St. Joseph Hospital Health Services of Rhode Island   N         Single Sngle Employer E
38 38 01-AC-00101 2 Legal Representative #1 LRep1 Employer #1 Emp01 Littler Mendelson, P.C. An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
39 39 01-AC-00101 3 Party Petitioner #1 Pet01 Federation of Nurses and Health Professionals of Rhode Island Local Union No. 5018, a/w American Federation of Teachers, AFL-CIO Mr. James A. Parisi   356 Smith Street   Providence RI 02908 (401)273-9800   (401)965-4598 (401)331-8815 riftjim@aol.com Federation of Nurses and Health Professionals of Rhode Island Local Union No. 5018, a/w American Federation of Teachers, AFL-CIO   N N American Federation of Teachers, AFL-CIO (AFT) 54700 Local 5018 Y Single Sngle Union U
40 40 01-AC-00101 4 Legal Representative #2 LRep2 Employer #1 Emp01 Littler Mendelson, P. C. An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
41 41 01-AC-00102 1 Party Employer #1 Emp01 St. Joseph Hospital Health Services of Rhode Island Mr. Anthony   Rizzotti Esq. 21 Peace Street   Providence RI 02907 (617)378-6009     (617)904-1039 arizzotti@littler.com St. Joseph Hospital Health Services of Rhode Island   N         Single Sngle Employer E
42 42 01-AC-00102 2 Legal Representative #1 LRep1 Employer #1 Emp01 Littler Mendelson, P.C. An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
43 43 01-AC-00102 3 Party Petitioner #1 Pet01 Federation of Nurses and Health Professionals of Rhode Island Local Union No. 5018, a/w American Federation of Teachers, AFL-CIO Mr. James A. Parisi   356 Smith Street   Providence RI 02908 (401)273-9800   (401)965-4598 (401)331-8815   Federation of Nurses and Health Professionals of Rhode Island Local Union No. 5018, a/w American Federation of Teachers, AFL-CIO   N N American Federation of Teachers, AFL-CIO (AFT) 54700 Local 5018 Y Single Sngle Union U
44 44 01-AC-00102 4 Legal Representative #2 LRep2 Employer #1 Emp01 Littler Mendelson, P. C. An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
45 45 01-RC-19536 1 Party Employer #1 Emp01 Uniform Printing & Supply, Inc.   Daniel   Makuch   520 Industrial Drive   Bellows Falls VT 05101           Uniform Printing & Supply, Inc.   N         Single Sngle Employer E
46 46 01-RC-19536 2 Party Petitioner #1 Pet01 Food & Commercial Workers Local 1459           44 School Street   Boston MA 02108           Food & Commercial Workers Local 1459   N U United Food and Commercial Workers International Union, CLC (UFCW) 20100 Local 1459 Y Single Sngle Union U
47 47 01-RC-19536 3 Legal Representative #1 LRep1 Petitioner #1 Pet01 Pyle, Rome, Lichten & Ehrenberg, P.C. An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
48 48 01-RC-19536 4 Legal Representative #1 LRep1 Employer #1 Emp01 Jackson Lewis LLP An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
49 49 01-RC-19910 1 Party Employer #1 Emp01 Sumo Airline           50 Harborside Drive   East Boston MA 02128           Sumo Airline   N         Single Sngle Employer E
50 50 01-RC-19910 2 Party Petitioner #1 Pet01 International Brotherhood of Teamsters Local 25, AFL-CIO           544 Main Street   Boston MA 02129           International Brotherhood of Teamsters Local 25, AFL-CIO   N U International Brotherhood of Teamsters (IBT) 54900   Y Single Sngle Union U
51 51 01-RC-19910 3 Legal Representative #1 LRep1 Petitioner #1 Pet01 Dwyer, Duddy and Facklam, P.C. An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
52 52 01-RC-19910 4 Legal Representative #1 LRep1 Employer #1 Emp01 Anthony Evangelista, President An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
53 53 01-RC-19926 1 Party Employer #1 Emp01 Beverly Enterprises d/b/a Cape Cod Nursing Home Mr. Jeffrey   Aframe   Lewis Point Road   Buzzards Bay MA 02532           Beverly Enterprises d/b/a Cape Cod Nursing Home   N         Single Sngle Employer E
54 54 01-RC-19926 2 Party Petitioner #1 Pet01 Service Employees Local 767 Mr. Julie   Oullette   94 Main Street   Hyannis MA 02601           Service Employees Local 767   N U Service Employees International Union (SEIU) 52100 Local 767 Y Single Sngle Union U
55 55 01-RC-19926 3 Legal Representative #1 LRep1 Employer #1 Emp01 Mr. Howard M. Bloom An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
56 56 01-RC-19926 4 Legal Representative #1 LRep1 Petitioner #1 Pet01 Pyle, Rome & Lichten, P.C. An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
57 57 01-RC-19980 1 Party Employer #1 Emp01 Confidence Mgmt. Systems, Union Square Nursing Ctr. & Supreme Mgmt., Inc. Ms. Trudy   Venette   533 Cambridge Street   Allston MA 02134           Confidence Mgmt. Systems, Inc., Union Square Nursing Ctr., & Supreme Mgmt.   N         Joint Employer E
58 58 01-RC-19980 2 Party Petitioner #1 Pet01 Service Employees International Union, Local 285, AFL-CIO           21 Fellows Street   Roxbury MA 02119 (617)442-4100 129   (617)541-6839   Service Employees Local 285   N U Service Employees International Union (SEIU) 52100 Local 285 Y Single Sngle Union U
59 59 01-RC-20080 1 Party Employer #1 Emp01 Elmhurst Extended Care Facility Mr. Richard   Fishpaw   50 Maude Street   Providence RI 02908           Elmhurst Extended Care Facility   N         Single Sngle Employer E
60 60 01-RC-20080 2 Party Petitioner #1 Pet01 Service Employees District 1199 Mr. Dave   Pickus   1201 Elmwood avenue   Providence RI 02907           Service Employees District 1199   N U Service Employees International Union (SEIU) 51900 District 1199 Y Single Sngle Union U
61 61 01-RC-20292 1 Party Petitioner #1 Pet01 International Brotherhood of Teamsters, Local 170, AFL-CIO Mr. Carl F. Gentile   805 Millbury Street   Worcester MI 01607 (508)799-0551         International Brotherhood of Teamsters, Local 170, AFL-CIO   N U International Brotherhood of Teamsters (IBT) 54900 Local 170 Y Single Sngle Union U
62 62 01-RC-20460 1 Party Employer #1 Emp01 Hillcrest Hospital           165 Tor Court   Pittsfield MA 01201           Hillcrest Hospital   N         Single Sngle Employer E
63 63 01-RC-20460 2 Legal Representative #1 LRep1 Employer #1 Emp01 Murphy, Hese, Toomey and Lahane, LLP An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
64 64 01-RC-20460 3 Party Petitioner #1 Pet01 Service Employees International Union, Local 2020 Mr. Michael   Fadel   21 Fellows Street   Roxbury MA 02119 (617)442-4100     (617)541-6839   Service Employees International Union Local 2020, AFL-CIO   N U Service Employees International Union (SEIU) 52100 Local 2020 Y Single Sngle Union U
65 65 01-RC-20467 1 Party Employer #1 Emp01 Ionics, Inc. Mr. Stephen   Korn   203 West Street   Ludlow MA 01056           Ionics, Inc.   N         Single Sngle Employer E
66 66 01-RC-20467 2 Party Petitioner #1 Pet01 International Brotherhood of Teamsters, Local 404, AFL-CIO Mr. Peter J. Krawczyk   Organizer 115 Progress Avenue Springfield MA 01104 (413)781-6326     (413)746-9094   Internaitonal Brotherhood of Teamsters, Local 404, AFL-CIO   N U International Brotherhood of Teamsters (IBT) 28200   Y Single Sngle Union U
67 67 01-RC-20508 1 Party Employer #1 Emp01 A. Russo & Sons, Inc. Mr. Michael   Russo   560 Pleasant Street   Watertown MA 02172           A. Russo & Sons, Inc.   N         Single Sngle Employer E
68 68 01-RC-20508 2 Party Petitioner #1 Pet01 International Brotherhood of Teamsters, Local 829. AFL-CIO Mr. Daniel   McLaughlin   650 Beacon Street   Boston MA 02215           Teamsters Local 829   N U International Brotherhood of Teamsters (IBT) 25400 Local 829 Y Single Sngle Union U
69 69 01-RC-20538 1 Party Employer #1 Emp01 Thielsch Engineering           195 Frances Avenue   Cranston RI 02910           Thielsch Engineering Inc.   N         Single Sngle Employer E
70 70 01-RC-20538 2 Party Petitioner #1 Pet01 International Brotherhood of Boilermakers, Iron Ship Builders, Blacksmiths, Forgers & Helpers           P.O. Box 623   Moon Township PA 15108           Boilermakers   N U International Brotherhood of Boilermakers, Iron Ship Builders, Blacksmiths, Forgers and Helpers, AFL-CIO 9700   Y Single Sngle Union U
71 71 01-RC-20574 1 Party Petitioner #1 Pet01 House Officers' Association/Comittee of Interns and Residents Ms. Sandra   Shea   Area Director, c/o Boston Medical Center Maternity Bldg Basement,818 Harrison Ave Boston MA 02118 (617)414-5301         House Officers' Association/Committe of Interns and Residents (HOA/CIR)   N U Union of American Physicians and Dentists (UAPD) 43300   N Single Sngle Union U
72 72 01-RC-20600 1 Party Employer #1 Emp01 Rykof Sexton U.S. Food Service, Inc. Mr. Rudy   Zensmeister   140 Morgan Drive   Norwood MA 02062       (717)831-7500   Rykoff Sexton U. S. Food Service, Inc.   N         Other Employer E
73 73 01-RC-20600 2 Party Petitioner #1 Pet01 International Brotherhood of Teamsters, Local 404, AFL-CIO Mr. Frank A. Gentile I   115 Progress Avenue Springfield MA 01104 (413)781-6326     (413)746-9094   Teamsters Local Union 404, a/w International Brotherhood of Teamsters, AFL-CIO   N U International Brotherhood of Teamsters (IBT) 28200 Local Union 404 Y Other Union U
74 74 01-RC-20600 3 Additional Service #1 AddS1 Petitioner #1 Pet01 International Brotherhood of Teamsters, AFL-CIO An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
75 75 01-RC-20600 4 Additional Service #2 AddS2 Petitioner #1 Pet01 Teamsters Local Union 829, a/w International Brotherhood of Teamsters, AFL-CIO An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
76 76 01-RC-20622 1 Party Employer #1 Emp01 Intercity Maintenance Co.           11 Nate Whipple Highway   Cumberland RI 02864           Intercity Maintenance Co.   N         Single Sngle Employer E
77 77 01-RC-20622 2 Party Petitioner #1 Pet01 Service Employees International Union Local 254           11 Beacon Street   Boston MA 02108           Service Employees International Union Local 254   N U Service Employees International Union (SEIU) 52100 Local 254 Y Single Sngle Union U
78 78 01-RC-20626 1 Party Employer #1 Emp01 Tropical Produce           170 Prescott Street   Worcester MA 01605           Tropical Produce   N         Single Sngle Employer E
79 79 01-RC-20626 2 Party Petitioner #1 Pet01 International Brotherhood of Teamsters, Local 170, AFL-CIO             805 Millbury Street, P.O. Box 70634 Worcester MA 01607 (508)799-0551     (508)752-9647   International Brotherhood of Teamsters Local 270, AFL-CIO   N U International Brotherhood of Teamsters (IBT) 54900 Local 170 Y Single Sngle Union U
80 80 01-RC-20634 1 Party Employer #1 Emp01 Mediplex of Lowell           19 Varnum Street   Lowell MA 01850           Mediplex of Lowell   N         Single Sngle Employer E
81 81 01-RC-20634 2 Party Petitioner #1 Pet01 Service Employees International Union Local 285, AFL-CIO           529 Main Street   Charlestown MA             Service Employees International Union Local 285, AFL-CIO   N U Service Employees International Union (SEIU) 52100 Local 285 Y Single Sngle Union U
82 82 01-RC-20649 1 Party Petitioner #1 Pet01 Roofers Local 169, United Union of Roofers, Waterproofers & Allied Workers           150 Ernest Street   Providence RI 02905           Roofers Local 169   N U United Union of Roofers, Waterproofers and Allied Workers, AFL-CIO (RWAW) 50000   Y Single Sngle Union U
83 83 01-RC-20761 1 Party Employer #1 Emp01 Coventry Health Center Ms. Kathy   Lavallee   10 Woodland Drive   Coventry RI 02816 (401)826-2000         Coventry Health Center   N         Single Sngle Employer E
84 84 01-RC-20761 2 Legal Representative #1 LRep1 Employer #1 Emp01 Adler, Pollock & Sheehan, Inc. An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
85 85 01-RC-20761 3 Party Petitioner #1 Pet01 International Brotherhood of Teamsters, Local 64, AFL-CIO Mr. Richard   Bergeron   14 Jefferson Park Road   Warwick RI 02888 (401)461-6800     (401)461-6894   International Brotherhood of Teamsters, Local 64, AFL-CIO   N N International Brotherhood of Teamsters (IBT) 25400   Y Single Sngle Union U
86 86 01-RC-20761 4 Legal Representative #1 LRep1 Petitioner #1 Pet01 Gursky Law Associates An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
87 87 01-RC-20804 1 Party Petitioner #1 Pet01 Plumbers and Gasfitters Local 12 Mr. Thomas M. Brockett Esq. 333 East River Drive, Suite 101   Hartford CT 06108           Plumbers and Gasfitters Local 1240   N U United Association of Journeymen and Apprentices of the Plumbing and Pipe Fitting Industry of the United States and Canada, AFL-CIO (PPF) 44700 Local 1240 Y Single Sngle Union U
88 88 01-RC-20815 1 Party Employer #1 Emp01 Coventry Health Continum, Inc. d/b/a Brookside Villa Ms. Kathy   Lavallee   10 Woodland Drive   Coventry RI 02816 (401)826-2000         Coventry Health Continum, Inc. d/b/a Brookside Villa   N         Single Sngle Employer E
89 89 01-RC-20815 2 Party Petitioner #1 Pet01 International Brotherhood of Teamsters, Local 64, AFL-CIO Mr. Richard   Bergeron   54 New London Avenue   West Warwick RI 02893 (401)823-5656     (401)821-9435   International Brotherhood of Teamsters, Local 64, AFL-CIO   N N International Brotherhood of Teamsters (IBT) 28200 Local 64 Y Single Sngle Union U
90 90 01-RC-20815 3 Legal Representative #1 LRep1 Employer #1 Emp01 Adler Pollock & Sheehan Incorporated An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
91 91 01-RC-20815 4 Legal Representative #1 LRep1 Petitioner #1 Pet01   An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
92 92 01-RC-20826 1 Party Employer #1 Emp01 Ovo Moving & Storage Inc. Ms. Darlene J. Szerrinski   870 Dyer Avenue   Cranston RI 02920           Ovo Moving & Storage Inc.   N         Single Sngle Employer E
93 93 01-RC-20826 2 Party Petitioner #1 Pet01 Teamsters Local Union No. 251 Mr. Stu   Mundy   121 Brightridge Avenue   E. Providence RI 02914           Teamsters Local Union No. 251   N U International Brotherhood of Teamsters (IBT) 25400 Local 251 Y Single Sngle Union U
94 94 01-RC-20826 3 Additional Service #1 AddS1 Petitioner #1 Pet01 International Brotherhood of Teamsters, AFL-CIO An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
95 95 01-RC-20869 1 Party Employer #1 Emp01 McDonald Projects Inc. Mr. Bob   Hayter   1450 Somerset Avenue   North Dighton MA 02715 (508)669-4170         McDonald Projects Inc.   N         Single Sngle Employer E
96 96 01-RC-20869 2 Legal Representative #1 LRep1 Employer #1 Emp01   An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
97 97 01-RC-20869 3 Party Petitioner #1 Pet01 International Brotherhood of Boilermakers, Iron Ship Builders, Blacksmiths, Forgers & Helpers, AFL-C Mr. James A. Bragan   International Representative 68 Sagamore Street North Quincy MA 02171 (617)786-8903         International Brotherhood of Boilermakers, Iron Ship Builders, Blacksmiths, Forgers & Helpers, AFL-CIO   N U International Brotherhood of Boilermakers, Iron Ship Builders, Blacksmiths, Forgers and Helpers, AFL-CIO 25100   Y Single Sngle Union U
98 98 01-RC-20869 4 Additional Service #1 AddS1 Petitioner #1 Pet01 International Brotherhood of Boilermakers, Iron Ship Builders, Blacksmiths, Forgers & Helpers, AFL-C An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            
99 99 01-RC-20880 1 Party Employer #1 Emp01 New England Cleaning Company Mr. Mike   Valchuvis   25 Claredon Street   Watertown MA 02272           New England Cleaning Co.   N         Single Sngle Employer E
100 100 01-RC-20880 2 Legal Representative #1 LRep1 Employer #1 Emp01 Hinckley, Allen & Snyder An Individual An Individual An Individual An Individual An Individual An Individual An Individual An Individual                   N            

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "r_participant" (
    "r_case_number" text,
    "participant_id" integer,
    "participant_role" text,
    "participant_group" text,
    "name_for_correspondence" text,
    "name_prefix" text,
    "first_name" text,
    "mid_name" text,
    "last_name" text,
    "name_suffix" text,
    "street_address_1" text,
    "street_address_2" text,
    "city" text,
    "state" text,
    "zip" text,
    "phone_num" text,
    "phone_ext" text,
    "cell_phone" text,
    "fax_num" text,
    "e_mail_address" text,
    "formal_name" text,
    "parent_name" text,
    "exclusive_service" text,
    "incumbent_union" text,
    "labor_org_code" integer,
    "local_dist_id" text,
    "afl_cio" text,
    "party_scope" text,
    "parti_type" text,
    FOREIGN KEY (r_case_number) REFERENCES r_case (r_case_number),
    FOREIGN KEY ([state]) REFERENCES[l_state] ([state]),
    FOREIGN KEY ([labor_org_code]) REFERENCES[l_labor_org_code] ([labor_org_code]),
    FOREIGN KEY ([parti_type]) REFERENCES[l_parti_type] ([parti_type]),
    FOREIGN KEY ([participant_group]) REFERENCES[l_participant_group] ([participant_group]),
    FOREIGN KEY ([party_scope]) REFERENCES[l_party_scope] ([party_scope]),
    FOREIGN KEY ([participant_role]) REFERENCES[l_r_part_role_type] ([participant_role])
);