Name: participant
Creator: Forest Gregg
License: https://creativecommons.org/publicdomain/mark/1.0/

Parties to each case — petitioners, charged parties, employers, unions, intervenors, and their legal representatives. Many cases have multiple participants. Note that the subtype column is partially polluted by upstream data quality issues (some rows contain street addresses where a subtype code is expected).

address: Mailing address of the participant.
address_1: Address line 1, when split.
address_2: Address line 2, when split.
case_number: Foreign key to filing.case_number.
city: City.
created_at: Scrape timestamp.
participant: Name of the party (organization or individual).
phone_number: Phone number, when available.
state: Two-letter US Postal Service state abbreviation.
subtype: Party subtype — "Union", "Employer", "Union as an Employer", "Individual", "Legal Representative", "Additional Service", "Notification", or "Not Specified". Subject to upstream data-quality issues; some rows contain address text instead of a valid subtype.
type: Role in the case — "Petitioner", "Employer", "Intervenor", "Union Involved", "Charging Party", "Involved Party", "Charged Party", "Charged Party / Respondent", or "Not Specified".
zip: ZIP code.

1,937,176 rows

descending

✎ View and edit SQL

Link	case_number	participant	type	subtype	address	address_1	address_2	city	state	zip	phone_number	created_at
1	01-RC-020966	INTERNATIONAL BROTHERHOOD OF TEAMSTERS LOCAL 25	Petitioner	Union	Charlestown, MA 02129-1109	544 Main Street		Charlestown	MA	02129-1109		2021-05-28 23:52:13
2	01-RC-020966	NEW ENGLAND MECHANICAL SERVICES OF MA	Employer	Employer	Boston, MA -	Washington St		Boston	MA	-		2021-05-28 23:52:13
3	01-RC-022166	AMALGAMATED TRANSIT UNION LOCAL 1547, AFL-CIO, CLC	Petitioner	Union	Long Island City, NY 11101-2042	37-18 Railroad Ave		Long Island City	NY	11101-2042		2021-05-28 23:52:13
4	01-RC-022166	NORTHEAST TRANSIT SERVICES, INC.	Employer	Employer	Brockton, MA 02301-7152	1442 Main St		Brockton	MA	02301-7152	(508)638-5985	2021-05-28 23:52:13
5	01-RC-022175	AMALGAMATED TRANSIT UNION LOCAL 1547, AFL-CIO-CLC	Petitioner	Union	Long Island City, NY 11101-2042	37-18 Railroad Ave		Long Island City	NY	11101-2042		2021-05-28 23:52:13
6	01-RC-022175	NORTHEAST TRANSIT SERVICES, INC.	Employer	Employer	Brockton, MA 02301-7152	1442 Main St		Brockton	MA	02301-7152	(508)638-5985	2021-05-28 23:52:13
7	01-RC-022538	D.W. CLARK, INC.	Employer	Employer	East Bridgewater, MA 02333-0448	PO Box 448		East Bridgewater	MA	02333-0448	(508)378-4014	2021-05-28 23:52:13
8	01-RC-022538	GLASS, MOLDERS, POTTERY, PLASTICS & ALLIED WORKERS INTERNATIONAL UNION, LOCAL 257-B	Petitioner	Union	San Jacinto, CA 92583-4021	486 W 7th St		San Jacinto	CA	92583-4021	(413)363-2319	2021-05-28 23:52:13
9	01-RC-063656	MVM, Inc.	Employer	Employer	Ashburn, VA 20147-6063	44620 Guilford Drive, Suite 150		Ashburn	VA	20147-6063	(571)223-4500	2021-05-28 23:52:13
10	01-RC-063656	United Government Security Officers of America (UGSOA)	Petitioner	Union	East Wareham, MA 02538-1327	2879 Cranberry Highway		East Wareham	MA	02538-1327	(774)678-0936	2021-05-28 23:52:13
11	01-RC-071664	M.V.M SECURITY, INC.	Employer	Employer	Ashburn, VA 20147-6063	44620 Guilford Drive, Suite 150		Ashburn	VA	20147-6063	(571)223-4574	2021-05-28 23:52:13
12	01-RC-071664	UNITED GOVERNMENT SECURITY OFFICERS OF AMERICA, LOCAL UNION NO. 273	Petitioner	Union	East Cambridge, MA 02141-1201	28 Sciarappa St		East Cambridge	MA	02141-1201	(617)372-3769	2021-05-28 23:52:13
13	01-RC-083491	JET VIDEO	Employer	Employer	Portland, ME 04103-3203	199 Pleasant Ave		Portland	ME	04103-3203	(207)773-9968	2021-05-28 23:52:13
14	01-RC-083491	INDUSTRIAL WORKERS OF THE WORLD, SOUTHERN MAINE	Petitioner	Union	Gray, ME 04039-1178	PO Box 1178		Gray	ME	04039-1178	(207)657-4183	2021-05-28 23:52:13
15	01-RC-091350	UNITED SERVICE AND ALLIED WORKERS OF RHODE ISLAND	Petitioner	Union	PROVIDENCE, RI 02904-2775	90 PRINTERY ST		PROVIDENCE	RI	02904-2775	(401)751-0500	2021-05-28 23:52:13
16	01-RC-091350	BROWN UNIVERSITY	Employer	Employer	Providence, RI 02912-1879	PO Box 1879		Providence	RI	02912-1879	(401)863-3122	2021-05-28 23:52:13
17	01-RC-091741	BROWN UNIVERSITY	Employer	Employer	Providence, RI 02912-1879	PO Box 1879		Providence	RI	02912-1879	(401)863-3122	2021-05-28 23:52:13
18	01-RC-091741	UNITED SERVICE AND ALLIED WORKERS OF RHODE ISLAND	Petitioner	Union	PROVIDENCE, RI 02904-2775	90 PRINTERY ST		PROVIDENCE	RI	02904-2775	(401)751-0500	2021-05-28 23:52:13
19	01-RC-145924	BROWN UNIVERSITY	Employer	Employer	PROVIDENCE, RI 02912-1879	PO BOX 1879	165 ANGELL STREET	PROVIDENCE	RI	02912-1879	(401)863-3122	2021-05-28 23:52:13
20	01-RC-145924	UNITED SERVICE AND ALLIED WORKERS	Petitioner	Union	PROVIDENCE, RI 02904-2775	90 PRINTERY ST		PROVIDENCE	RI	02904-2775	(401)751-0500	2021-05-28 23:52:13
21	01-RC-179252	FOXCROFT ACADEMY	Employer	Employer	Dover Foxcroft, ME 04426-1053	975 W Main St		Dover Foxcroft	ME	04426-1053	(207)564-8351	2021-05-28 23:52:13
22	01-RC-179252	FOXCROFT ACADEMY EDUCATION ASSOCIATION/MAINE EDUCATION ASSOCIATION	Petitioner	Union	Bangor, ME 04401-2401	1349 Broadway		Bangor	ME	04401-2401	(207)942-2907	2021-05-28 23:52:13
23	01-RC-187449	RETAIL WHOLESALE DEPARTMENT STORE UNION, (RWDSU)	Petitioner	Union	Leominster, MA 01453-5768	14 Manning Ave Ste 302		Leominster	MA	01453-5768	(978)534-6534	2021-05-28 23:52:13
24	01-RC-187449	A.T. WALL COMPANY	Employer	Employer	Warwick, RI 02886-1020	55 Service Ave		Warwick	RI	02886-1020	(401)739-0740	2021-05-28 23:52:13
25	01-RC-199812	Local 30 I.U.O.E. and Local 478 I.U.O.E.	Petitioner	Union	Whitestone, NY 11357	16-16 Whitestone Expressway,		Whitestone	NY	11357	(718)847-8484	2021-05-28 23:52:13
26	01-RC-199812	CBRE, INC.	Employer	Employer	Stamford, CT 06907-2524	10 Riverbend Dr S		Stamford	CT	06907-2524	(203)945-0444	2021-05-28 23:52:13
27	01-RC-202503	CSRA LLC	Employer	Employer	Orlando, FL 32826	12501 Research Pkwy		Orlando	FL	32826	(321)245-0968	2021-05-28 23:52:13
28	01-RC-202503	International Association of Machinists and Aerospace Workers, AFL-CIO, District Lodge 26	Petitioner	Union	Brooklyn, NY 11242	28 Court Street	Suite 1710	Brooklyn	NY	11242	(646)926-2910	2021-05-28 23:52:13
29	01-RC-227961	UNITED SERVICE AND ALLIED WORKERS	Petitioner	Union	PROVIDENCE, RI 02904-2775	90 PRINTERY ST		PROVIDENCE	RI	02904-2775	(401)751-0500	2021-05-28 23:52:13
30	01-RC-227961	BROWN UNIVERSITY	Employer	Employer	PROVIDENCE, RI 02912-1879	PO BOX 1879	165 ANGELL STREET	PROVIDENCE	RI	02912-1879	(401)863-3122	2021-05-28 23:52:13
31	01-RC-243688	First Student, Inc.	Employer	Employer	Westborough, MA 01581-____	131 Oak Street		Westborough	MA	01581-____		2021-05-28 23:52:13
32	01-RC-243688	Teamsters Union Local 170	Petitioner	Union	Worcester, MA 01604-____	330 Southwest Cutoff	Suite 201	Worcester	MA	01604-____	(508)799-0551	2021-05-28 23:52:13
33	01-RC-275103	Nova Technologies	Employer	Employer	Tallahassee, FL 32312	2420 Lakeshore Drive	Suite 202	Tallahassee	FL	32312	(850)509-9099	2021-05-28 23:52:13
34	01-RC-275103	Quonset Association of Simulator Instructors	Petitioner	Union	N. Kingstown, RI 02852	522 Rhode Warrior Way		N. Kingstown	RI	02852	(401)267-3818	2021-05-28 23:52:13
35	02-RC-023225	Saint Barnabas Hospital	Employer	Employer	Bronx, NY 10457-2594	4422 Third Avenue		Bronx	NY	10457-2594	(718)960-6560	2021-05-28 23:52:13
36	02-RC-023225	Levy Ratner	Petitioner	Union	New York, NY 10022	900 Third Ave, 21st Floor		New York	NY	10022-4869	(516)542-1115	2021-05-28 23:52:13
37	02-RC-023247	Levy Ratner	Petitioner	Union	New York, NY 10036-6902	330 W 42nd St Fl 15	Cell 646 996-5422	New York	NY	10036-6902	(212)603-1700	2021-05-28 23:52:13
38	02-RC-023247	SPECIAL AND SUPERIOR OFFICERS BENEVOLENT ASSOCIATION	Employer	Employer	Bronx, NY 10457-2594	4422 Third Avenue		Bronx	NY	10457-2594	(718)960-9000	2021-05-28 23:52:13
39	02-RC-023277	Levy Ratner	Petitioner	Union	New York, NY 10022	900 Third Ave, 21st Floor		New York	NY	10022-4869	(516)542-1115	2021-05-28 23:52:13
40	02-RC-023277	St. Barnabas Hospital	Employer	Employer	Bronx, NY 10457	Third Avenue And 183rd St		Bronx	NY	10457	(718)960-9000	2021-05-28 23:52:13
41	02-RC-023296	LOCAL 621 UNITED CONSTRUCTION TRADES AND INDUSTRIAL EMPLOYEES UNION, USW, IUJAT	Petitioner	Union	Douglaston, NY 11363	40-26 235th Street		Douglaston	NY	11363	(718)326-4052	2021-05-28 23:52:13
42	02-RC-023298	LOCAL 621 UNITED CONSTRUCTION TRADES AND INDUSTRIAL EMPLOYEES UNION, USW, IUJAT	Petitioner	Union	Douglaston, NY 11363	40-26 235th Street		Douglaston	NY	11363	(718)326-4052	2021-05-28 23:52:13
43	02-RC-023400	INTERNATIONAL UNION OF JOURNEYMAN & ALLIED TRADES, LOCAL 947	Petitioner	Union	Huntington Station, NY 11746-1726	1500 New York Ave		Huntington Station	NY	11746-1726	(631)670-5660	2021-05-28 23:52:13
44	02-RC-023400	USI SERVICES GROUP INC.	Employer	Employer	Springfield, NJ 07081-3115	43 Fadem Rd		Springfield	NJ	07081-3115	(973)232-7156	2021-05-28 23:52:13
45	02-RC-023420	LILBEE CONTRACTING, INC.	Employer	Employer	Mount Vernon, NY 10553-1327	80 Hartford Ave		Mount Vernon	NY	10553-1327	(914)663-6011	2021-05-28 23:52:13
46	02-RC-023420	LOCAL 713, INTERNATIONAL BROTHERHOOD OF TRADE UNIONS.	Petitioner	Union	Garden City, NY 11530	400 Garden City Plaza, Suite 106		Garden City	NY	11530	(516)741-5564	2021-05-28 23:52:13
47	02-RC-023424	UNITED FEDERATION OF SPECIAL POLICE AND SECURITY OFFICERS, INC.	Petitioner	Union	Briarcliff Manor, NY 10510-0076	PO Box 76	540 N State Rd	Briarcliff Manor	NY	10510-0076	(914)941-4103	2021-05-28 23:52:13
48	02-RC-023424	HARVARD PROTECTION SERVICES	Employer	Employer	NEW YORK, NY 10018-1603	570 FASHION AVENUE		NEW YORK	NY	10018-1603	(212)730-0001	2021-05-28 23:52:13
49	02-RC-023482	LOCAL 713, INTERNATIONAL BROTHERHOOD OF TRADE UNIONS.	Petitioner	Union	Garden City, NY 11530	400 Garden City Plaza, Plaza, Suite 106,		Garden City	NY	11530	(516)741-5564	2021-05-28 23:52:13
50	02-RC-023482	KRAUSS MANAGEMENT	Employer	Employer	Long Island City, NY 11106-4928	3301 Vernon Blvd		Long Island City	NY	11106-4928	(718)274-5000	2021-05-28 23:52:13
51	02-RC-023485	LOCAL 713, INTERNATIONAL BROTHERHOOD OF TRADE UNIONS.	Petitioner	Union	Garden City, NY 11530	400 Garden City Plaza, Plaza, Suite 106,		Garden City	NY	11530	(516)741-5564	2021-05-28 23:52:13
52	02-RC-023485	ASHTON MANAGEMENT A/A/F HUDSON PIERS ASSOCIATES LP	Employer	Employer	Long Island City, NY 11106-4928	3301 Vernon Blvd		Long Island City	NY	11106-4928	(718)274-5000	2021-05-28 23:52:13
53	02-RC-023501	CLINTON MANAGEMENT	Employer	Employer	Little Neck, NY 11363-1525	4206 235th St		Little Neck	NY	11363-1525	(347)287-3101	2021-05-28 23:52:13
54	02-RC-023501	LOCAL 116, PRODUCTION AND MAINTENANCE EMPLOYEES UNION	Petitioner	Union	New York, NY 10032-5122	935 Saint Nicholas Ave Apt 5J		New York	NY	10032-5122	(631)559-5045	2021-05-28 23:52:13
55	02-RC-023534	PEARSON MOVERS	Employer	Employer	Yonkers, NY 10710-5834	14 Wainwright Ave		Yonkers	NY	10710-5834	(914)346-0408	2021-05-28 23:52:13
56	02-RC-023534	PEARSON MOVING, INC.	Employer	Employer	Yonkers, NY 10710-5834	14 Wainwright Ave		Yonkers	NY	10710-5834	(914)346-0408	2021-05-28 23:52:13
57	02-RC-023534	UNITED SERVICE WORKERS UNION, LOCAL 1212, IUJAT	Petitioner	Union	Briarwood, NY 11435	138-50 Queens Boulevard		Briarwood	NY	11435	(718)523-4732	2021-05-28 23:52:13
58	02-RC-023609	PETTA CONTRACTING	Employer	Employer	New York, NY 10005-1404	20 Pine St		New York	NY	10005-1404		2021-05-28 23:52:13
59	02-RC-023609	UNITED ASSOCIATION OF WORKERS OF AMERICA, LOCAL 528	Petitioner	Union	Jamaica, NY 11435-3331	148-06 Hillside Avenue		Jamaica	NY	11435-3331	(718)291-3434	2021-05-28 23:52:13
60	02-RC-063828	SODEXO MGT. INC.	Employer	Employer	Newark, DE 19713-4337	200 Continental Dr Ste 400		Newark	DE	19713-4337	(716)650-6832	2021-05-28 23:52:13
61	02-RC-063828	CSEA, LOCAL 1000	Petitioner	Union	New York, NY 10038-4912	125 Maiden Ln, 5th flr		New York	NY	10038-4912	(716)691-6555	2021-05-28 23:52:13
62	02-RC-063828	SODEXO MANAGEMENT, INC., C/O MOUNT SAINT MARY COLLEGE	Employer	Employer	Newburgh, NY 12550-3412	330 Powell Ave		Newburgh	NY	12550-3412	(845)561-2800	2021-05-28 23:52:13
63	02-RC-067938	INTREPID SEA, AIR & SPACE MUSEUM	Employer	Employer	New York, NY 10036-1007	1 Intrepid Sq	12th Avenue 46th Street	New York	NY	10036-1007	(646)381-5227	2021-05-28 23:52:13
64	02-RC-067938	SPECIAL AND SUPERIOR OFFICERS BENEVOLENT ASSOCIATION	Petitioner	Union	Babylon, NY 11702-3422	200B W Main St		Babylon	NY	11702-3422	(631)587-9116	2021-05-28 23:52:13
65	02-RC-071317	SPECIAL AND SUPERIOR OFFICERS BENEVOLENT ASSOCIATION	Intervenor	Union	Babylon, NY 11702-	220B W Main St		Babylon	NY	11702-		2021-05-28 23:52:13
66	02-RC-071317	NY DISTRICT OF COUNCIL OF CARPENTERS AND ITS LOCALS	Petitioner	Union	New York, NY 10014-7450	395 Hudson St Lbby 3		New York	NY	10014-7450	(212)366-3342	2021-05-28 23:52:13
67	02-RC-071317	GRAND CENTRAL PARTNERSHIP (GCP)	Employer	Employer	New York, NY 10168-0699	122 E 42nd St Rm 601		New York	NY	10168-0699	(212)883-2420	2021-05-28 23:52:13
68	02-RC-073859	SODEXO CORPORATION	Employer	Employer	Gaithersburg, MD 20878-7314	9801 Washingtonian Blvd Fl 1		Gaithersburg	MD	20878-7314	(800)763-3946	2021-05-28 23:52:13
69	02-RC-073859	DISTRICT COUNCIL 37, AFSME	Petitioner	Union	New York, NY 10007-2233	125 Barclay Street		New York	NY	10007-2233	(212)815-1450	2021-05-28 23:52:13
70	02-RC-094206	IBEW Local Union 1430	Petitioner	Union	N WHITE PLAINS, NY 10603-2414	901 N BROADWAY, STE 16		N WHITE PLAINS	NY	10603-2414	(914)948-3771	2021-05-28 23:52:13
71	02-RC-094206	ADDERLY INDUSTRIES	Employer	Employer	Bronx, NY 10474-4908	830 Whittier St		Bronx	NY	10474-4908	(718)967-2220	2021-05-28 23:52:13
72	02-RC-106980	Neighborhood Association for Inter-Cultural Affairs, Inc.	Employer	Employer	Bronx, NY 10456-6129	3339 Park Ave		Bronx	NY	10456-6129		2021-05-28 23:52:13
73	02-RC-106980	Local 74 United Service Workers Union	Petitioner	Union	Long Island City, NY 11106-2329	36-36 33rd St Ste 202		Long Island City	NY	11106-2329	(718)729-7400	2021-05-28 23:52:13
74	02-RC-107305	WAREHOUSE PRODUCTION SALES & ALLIED SERVICE EMPLOYEES UNION, LOCAL 811	Petitioner	Union	BROOKLYN, NY 11215	534 3RD AVE STE	GROUND FLOOR	BROOKLYN	NY	11215	(718)333-5476	2021-05-28 23:52:13
75	02-RC-107305	PROMINENT CLEANING CORP.	Employer	Employer	New York, NY 10001-4404	29 W 30th St		New York	NY	10001-4404	(212)924-1515	2021-05-28 23:52:13
76	02-RC-111132	WAREHOUSE PRODUCTION SALES & ALLIED SERVICE EMPLOYEES UNION, LOCAL 811	Petitioner	Union	BROOKLYN, NY 11215	534 3RD AVE STE	GROUND FLOOR	BROOKLYN	NY	11215	(718)333-5476	2021-05-28 23:52:13
77	02-RC-111132	PRESTIGE CLEANERS	Employer	Employer	New York, NY 10016-3240	650 1st Ave 7th Floor		New York	NY	10016-3240	(646)710-4728	2021-05-28 23:52:13
78	02-RC-111947	WAREHOUSE PRODUCTION SALES & ALLIED SERVICE EMPLOYEES UNION, LOCAL 811	Petitioner	Union	BROOKLYN, NY 11215	534 3RD AVE STE	GROUND FLOOR	BROOKLYN	NY	11215	(718)333-5476	2021-05-28 23:52:13
79	02-RC-111947	PRESTIGE CLEANERS	Employer	Employer	New York, NY 10016-3240	650 1st Ave 7th Floor		New York	NY	10016-3240	(646)710-4728	2021-05-28 23:52:13
80	02-RC-122304	MONTEFIORE MEDICAL CENTER NORTH	Employer	Employer	Bronx, NY 10466-2697	600 E 233rd St		Bronx	NY	10466-2697	(718)920-9905	2021-05-28 23:52:13
81	02-RC-122304	Special and Superior Officers Benevolent Association	Petitioner	Union	Lindenhurst, NY 11757	199 North Wellwood Avenue		Lindenhurst	NY	11757		2021-05-28 23:52:13
82	02-RC-126294	LAW ENFORCEMENT EMPLOYEES BENEVOLENT ASSOCIATION	Petitioner	Union	Catskill, NY 12414-1512	277 Main St Ste 1		Catskill	NY	12414-1512	(518)943-5065	2021-05-28 23:52:13
83	02-RC-126294	FJC SECURITIES SERVICES	Employer	Employer	NEW YORK, NY 10278	26 FEDERAL PLAZA		NEW YORK	NY	10278		2021-05-28 23:52:13
84	02-RC-126757	LOCAL 1430, I.B.E.W., AFL-CIO	Petitioner	Union	WHITE PLAINS, NY 10603	901 N. BROADWAY	SUITE 16N	WHITE PLAINS	NY	10603	(914)358-5085	2021-05-28 23:52:13
85	02-RC-126757	No Parking Today, Inc.	Employer	Employer	Mount Vernon, NY 10550-1714	31 South St		Mount Vernon	NY	10550-1714	(212)738-9035	2021-05-28 23:52:13
86	02-RC-148023	International Brotherhood of Electrical Workers Local 1430	Petitioner	Union	Armonk, NY 10604	84 Business Park Drive, Suite 202		Armonk	NY	10604	(914)948-3771	2021-05-28 23:52:13
87	02-RC-148023	Shalom Ambulette Services, Inc.	Employer	Employer	White Plains, NY 10603-2466	600 N Broadway		White Plains	NY	10603-2466	(914)285-3397	2021-05-28 23:52:13
88	02-RC-151729	Urban Home Ownership Corp.	Employer	Employer	New York, NY 10001-2519	494 8th Avenue, 19th Floor		New York	NY	10001-2519	(212)563-0310	2021-05-28 23:52:13
89	02-RC-151729	Local 947 USWU, IUJAT	Petitioner	Union	Kings Park, NY 11754	3 Main Street		Kings Park	NY	11754	(631)670-5660	2021-05-28 23:52:13
90	02-RC-158654	Alphabet Plaza LLC	Employer	Employer	New York, NY 10016	381 Park Avenue South		New York	NY	10016	(212)251-9600	2021-05-28 23:52:13
91	02-RC-158654	Service Employees International Union, Local 32BJ	Petitioner	Union	New York, NY 10011-4676	25 West 18th Street, 5th Floor	5th Floor	New York	NY	10011-4676	(212)539-2941	2021-05-28 23:52:13
92	02-RC-165054	BROTHERHOOD OF AMALGAMATED TRADES	Petitioner	Union	White Plains, NY 10604-3520	777 Westchester Ave	STE 101	White Plains	NY	10604-3520	(914)705-5488	2021-05-28 23:52:13
93	02-RC-165054	Wildcat Service Corporation	Employer	Employer	New York, NY 10011	210 East 43rd St		New York	NY	10011	(212)727-4377	2021-05-28 23:52:13
94	02-RC-166397	NELSON SERVICE SYSTEMS INC	Employer	Employer	Yonkers, NY 10701	199 Nepperhan Ave		Yonkers	NY	10701		2021-05-28 23:52:13
95	02-RC-166397	Brotherhood of Amalgamated Trades, Local Union 514	Petitioner	Union	White Plains, NY 10604	777 Westchester Avenue	Suite 101	White Plains	NY	10604	(914)705-5488	2021-05-28 23:52:13
96	02-RC-171341	International Brotherhood of Electrical Workers Local 1430	Petitioner	Union	Armonk, NY 10540	84 Business Park Drive, Suite 202		Armonk	NY	10540	(914)948-3771	2021-05-28 23:52:13
97	02-RC-171341	No Parking Today, Inc.	Employer	Employer	Mount Vernon, NY	14 Courtlandt Street	2nd Floor	Mount Vernon	NY		(212)738-9035	2021-05-28 23:52:13
98	02-RC-196662	Kelman Winston & Velone	Employer	Employer	New York, NY 10006-1819	2 Rector St		New York	NY	10006-1819	(212)966-3730	2021-05-28 23:52:13
99	02-RC-196662	Local 153, Office of Professional Employees International Union, AFL-CIO	Petitioner	Union	New York, NY 10011-7103	265 W 14th St, Fl 6th		New York	NY	10011-7103	(917)690-5594	2021-05-28 23:52:13
100	02-RC-201153	AKAM Associates, Inc. for DAK Equities Corp. at 514 West End Avenue	Employer	Employer	New York, NY 10024-4337	514 W End Ave		New York	NY	10024-4337	(212)986-0001	2021-05-28 23:52:13

Download this data

CSV · JSON

Table schema

CREATE TABLE participant (case_number text not null,
                     	  participant text,
		     	  type text,
			  subtype text,
		     	  address text,
			  address_1 text,
			  address_2 text,
			  city text,
			  state text,
			  zip text,
			  phone_number text,
		          created_at timestamp default CURRENT_TIMESTAMP,
		     	  FOREIGN KEY(case_number) REFERENCES filing(case_number));
CREATE INDEX [idx_participant_case_number]
    ON [participant] ([case_number]);