One row per F-7 notice filed with FMCS since 1997. Most rows are Renegotiation (advance notice of an existing contract's expiration); smaller shares are Reopener, Initial Contract, and other categories. Notices have been filed by either the employer or the union, indicated in notice_submitted_by.

affected_location_city: City where the bargaining-unit workers are employed (may differ from employer's headquarters city).
affected_location_state: State where the bargaining-unit workers are employed.
affected_location_zip: ZIP code where the bargaining-unit workers are employed.
bargaining_unit_size: Number of workers in the bargaining unit (the group covered by the collective-bargaining agreement).
category: Type of notice. Common values are "Renegotiation" (advance notice of an existing contract's expiration), "Reopener" (mid-term reopening provision triggered), and "Initial Contract" (newly-formed bargaining relationship). Less common categories include "I & I" (an FMCS internal service-type code, expansion not publicly documented), "Unspecified", "Employment Mediation", "Regulatory Negotiation", "Facilitate a Meeting", and "Dispute Systems Design".
employer: Employer name as reported on the notice.
employer_city: Employer city.
employer_representative: Name of the employer's designated contact for bargaining.
employer_representative_email: Email address of the employer representative.
employer_representative_phone: Phone number for the employer representative.
employer_representative_title: Job title of the employer representative.
employer_state: Employer state (two-letter US postal abbreviation or full name; format varies).
employer_street: Employer street address.
employer_zip: Employer ZIP code.
establishment_size: Total number of employees at the establishment (typically larger than bargaining_unit_size).
expiration_date: Expiration date of the contract being renegotiated. (ISO 8601, YYYY-MM-DD)
healthcare_related: Boolean flag (0 or 1) indicating whether the employer is a healthcare establishment subject to the 60-day NLRA Section 8(d)(A) notice requirement.
industry: Human-readable industry name corresponding to the NAICS code.
initiated_date: Date the F-7 notice was created in the FMCS system (ISO 8601, YYYY-MM-DD).
location_negotiation_city: City where bargaining will take place, when supplied.
location_negotiation_state: State where bargaining will take place, when supplied.
location_negotiation_zip: ZIP code where bargaining will take place, when supplied.
naics: NAICS industry code for the employer (2- to 6-digit, depending on what FMCS captured).
notice_date: Notice date as reported by FMCS. (ISO 8601, YYYY-MM-DD)
notice_submitted_by: Who filed the notice — typically "F-7 from Employer" or "F-7 from Union".
union_city: Union city.
union_name: Full name of the union, typically including parent affiliation and local number.
union_representative: Name of the union's designated contact for bargaining.
union_representative_email: Email address of the union representative.
union_representative_phone: Phone number for the union representative.
union_representative_title: Job title of the union representative (e.g. "Business Manager", "President").
union_state: Union state.
union_street: Union mailing address.
union_zip: Union ZIP code.

581,295 rows

descending

✎ View and edit SQL

notice_date	initiated_date	employer	employer_street	employer_city	employer_state	employer_zip	employer_representative	employer_representative_phone	employer_representative_title	union_name	union_street	union_city	union_state	union_zip	union_representative	union_representative_phone	union_representative_title	affected_location_city	affected_location_state	affected_location_zip	expiration_date	naics	industry	bargaining_unit_size	establishment_size	notice_submitted_by	category	healthcare_related
1930-03-23	2020-06-22	Drywall Contractors-Multiple NY								Drywall Tapers and Pointers of Greater New York IUPAT DC No. 9 AFL-CIO 1974	45 West 14th Street	New York	NY	10011	Joseph Azzopardi		Business Manager/S T	Woodside	New York	11377	2020-06-27	23	Construction	1220		F-7 from Union	Renegotiation	0
1931-03-31	2016-04-16	Applied Restoration Inc		Tukwila	WA	98188	Mettler, Dick			Pacific Northwest Regional Council of Carpenters-	25120 Pacific Highway S Suite 200	Kent	WA	98032	Tweedy, Doug		Union Representative	Tukwila	WA	98188	2016-05-31	23	Construction	0	0	F-7 from Organization	Renegotiation	0
1996-10-01		ASH GROVE CEMENT	8900 INDIAN CREEK PKWY	OVERLAND PARK		66225	GARY CHURCH	(913) 451-8900	LAB RELS	BBF - D435	NOT PROVIDED	MONTANA CITY	MT		MICHAEL ATCHISON	(970) 225-9714	INTL REP	HELENA	MT	59601	1996-11-30		E	60	80
1996-10-01		ASPEN MEDICAL GROUP CLINICS	1021 BANDANA BL E STE 200	ST PAUL		55108	JILL LORD	(612) 642-2709	DIR OF H R	SEIU - 113	2021 E HENNEPIN AVE 260	MINNEAPOLIS	MN	55413	CURTIS KIMMONS	(612) 331-4690	BR	SAINT PAUL	MN	55108	1996-12-31		L	382	500
1996-10-01		ASPLUNDH TREE EXPERT COMPANY	708 BLAIN MILL RD	WILLOW GROVE		19090	CHRISTOPHER ASPLUNDH	(215) 784-4200	PRESIDENT	IBEW - 659	24 1/2 SOUTH GRAPE	MEDFORD	OR	97501	JIM MC CLEAN	(541) 772-5271	BM	MEDFORD	OR	97501	1996-12-31		C	100	130
1996-10-01		B & G MAINTENANCE (WINDOW CLEANERS)(B&G)	8500 PENA BLVD POB 492036	DENVER		80249	DON BEALE	(303) 342-3627		SEIU - 105	1535 LOGAN	DENVER	CO	80203	RICK HALL	(303) 830-2788	PRESIDENT	DENVER	CO	80249	1996-11-30		J	16	20
1996-10-01		BARTLETT SVCS (PEACH BOTTOM NUCLEAR POWER STATION)	60 INDUSTRIAL PARK RD	PLYMOUTH		02360	BRUCE BARTLETT	(800) 225-0385	OWNER	IBEW - 126	3455 GERMANTOWN PIKE	COLLEGEVILLE	PA	19426	THOMAS A LEACH	(610) 489-1185	BUS REP	COLLEGEVILLE	PA	19426	1996-12-31		J	22	50
1996-10-01		BOUCHARD TRANSPORTATION CO INC (HOUSTON TX)	77 NEWBRIDGE ROAD	HICKSVILLE		11801	MORTON BOUCHARD III	(516) 681-4900		ILA - 333	552 BAY ST	STATEN ISLAND	NY	10304	ALBERT CORNETTE	(718) 727-5675		HICKSVILLE	NY	11801	1996-11-30		F	80	700
1996-10-01		BOWES INDUSTRIES INC	P O BOX 18802	INDIANAPOLIS		46218	MIKE ARCHER	(317) 547-5245	PLT MGR	SMW - 503	707 MAIN	BEECH GROVE	IN	46107	DONALD E JOHNSON	(317) 786-5373	BUS MGR	INDIANAPOLIS	IN	46218	1996-12-01		E	80	105
1996-10-01		BROWN DERBY INCORPORATED (CLEVELAND)	520 S MAIN ST STE 2554	AKRON		44311	PARRIS GIRVES	(330) 375-9040	PRESIDENT	HERE - 10	1836 EUCLID AVE 7TH FLR	CLEVELAND	OH	44115	DENNIS FRANCIS	(216) 241-3670	PRESIDENT	CLEVELAND	OH	44115	1996-12-31		J	60	84
1996-10-01		BROWN DERBY INCORPORATED (INDEPENDENCE)	520 S MAIN ST STE 2554	AKRON		44311	PARRIS GIRVES	(330) 375-9040	PRESIDENT	HERE - 10	1836 EUCLID AVE 7TH FLR	CLEVELAND		44115	DENNIS FRANCIS	(216) 241-3670	PRESIDENT	CLEVELAND	OH	44115	1997-12-31		J	51	70
1996-10-01		CAGWIN & DORWARD	8001 BINFORD RD	NOVATO		94945	ROBERT L CROWELL	(415) 892-7710	VP	PPF - 38	1621 MARKET ST	SAN FRANCISCO	CA	94103	LARRY MAZZOLA	(415) 626-2000	PRESIDENT	NOVATO	CA	94945	1996-10-01		C	1	0
1996-10-01		CAPESIDE COVE GOOD SAMARITAN CENTER (S&M)	BOX 49	SIREN		54872	JULIANE SAXON	(712) 349-2293	ADMIN	SEIU - 113	2021 E HENNEPIN AVE 260	MINNEAPOLIS	MN	55413	JAN CUCCIA	(612) 331-4690	BR	SIREN	WI	54872	1996-12-31		L	96	230
1996-10-01		CAROLINA COACH CO	POB 28088	RALEIGH		27611	WILLIAM C STEELE	(919) 833-3601		ATU - 1493	3535 S WILMINGTON ST 202	RALEIGH	NC	27603	JANIS M BORCHARDT	(919) 772-0790		RALEIGH	NC	27603	1996-11-30		F	75	130
1996-10-01		CENTRAL MICHIGAN COMMUNITY HOSPITAL	1221 SOUTH DRIVE	MT PLEASANT		48858	JULIE WARD	(517) 772-6857	DIR OF H R	RNA -	NOT PROVIDED	NOT PROVIDED	MI		JIM HAYES	(517) 772-4329		MOUNT PLEASANT	MI	48858	1996-11-30		L	102	500
1996-10-01		CHICO COMMUNITY HOSPITAL	560 COHASSET RD	CHICO		95926	LIZ GUIGNIER	(916) 896-5000	DIR PERS	ILWU - 6	99 HEGENBERGER RD	OAKLAND	CA	94621	JILL DUKE	(510) 638-5605	BA	CHICO	CA	95926	1997-01-15		L	130	0
1996-10-01		CORVETTES MEATS	9604 CHURCH AVENUE	BROOKLYN		11212	JOSEPH BASSO	(718) 485-9727	OWNER	UFCW - 174	540 WEST 48TH STREET	NEW YORK	NY	10036-1130	MITCHELL HOLLOWAY	(212) 307-7007	PRESIDENT	BROOKLYN	NY	11212	1996-11-30		T	3	0
1996-10-01		DAVEY TREE SURGERY COMPANY	POB 5015	LIVERMORE		94551-5015	LARRY ABERNATHY	(510) 443-1723	OPERS MGR	IBEW - 659	24 1/2 SOUTH GRAPE	MEDFORD	OR	97501	JIM MC CLEAN	(541) 772-5271	BM	MEDFORD	OR	97501	1996-12-31		C	100	120
1996-10-01		DEER RIVER HEALTHCARE CENTER (S&M)	1002 COMSTOCK DRIVE	DEER RIVER		56636	MICHAEL HEDRIX	(218) 246-2900	CEO	SEIU - 113	2021 E HENNEPIN AVE 260	MINNEAPOLIS	MN	55413	KATHY FODNESS	(612) 331-4690	BR	DEER RIVER	MN	56636	1996-12-31		L	115	175
1996-10-01		DELCO ELECTRONICS CORP	7929 SOUTH HOWELL AVE	OAK CREEK		53154	MARK CHANEY	(414) 768-2514	I/R REP	IBEW - 663	W233 S8625 CHATEAU LN	BIG BEND	WI	53103	RANDAL A MIDDLETON	(414) 662-5161		OAK CREEK	WI	53154	1996-12-07		E	57	750
1996-10-01		DELPHI AUTOMOTIVE	7929 SOUTH HOWELL AVE	OAK CREEK		53154	PATRICK J MCDONALD	(414) 768-3305		IBEW - 663	W233 S8625 CHATEAU LN	BIG BEND	IN	53103	RANDAL A MIDDLETON	(414) 662-5161		OAK CREEK	WI	53154	1996-12-07		E	44	1024
1996-10-01		EXCEL WIRE & CABLE	108 ELM AVE	TIFFIN		44883	WAYNE WITSMAN	(419) 448-0312	PLANT MGR	IBEW - 1270	240 NORTH WASHINGTON ST	TIFFIN	OH	44883	PHILLIP L HUNTER	(419) 447-6629	PRES	FINDLAY	OH	45839	1996-11-01		E	155	175
1996-10-01		FARM FRESH CATFISH CO	POB 85	HOLLANDALE		38748	KURT L SAMUELSON	(601) 827-2204		UFCW - 1529	761 WALNUT KNOLL LANE	CORDOVA	TN	38018	DAVID F JENNINGS	(901) 758-1529	OPER DIR	HOLLANDALE	MS	38748	1997-01-21		T	193	228
1996-10-01		FBF INC (F B F)	1145 INDUSTRIAL BLVD	SOUTHAMPTON		18966	JOHN WRIGHT	(610) 254-9400	ATTORNEY	UAW - 1612	125 WITMER ROAD	HORSHAM	PA	19044	JOSEPH SINNI	(215) 441-5415	INTL REP	HORSHAM	PA	19044	1996-12-01		E	75	150
1996-10-01		FINGERHUT CORPORATION	11 MCLELAND ROAD	ST CLOUD		56395	LARRY MCGINLEY	(320) 654-4738	L R MGR	UNITE - 66 978 1259	312 CENTRAL AVE SE 398	MINNEAPOLIS	MN	55414	RICHARD METCALF	(612) 379-7102	MGR	SAINT CLOUD	MN	56301	1997-02-06		J	2000	2000
1996-10-01		FT MCCLELLAN BARBER (SHEAR PLEASURE & BEAUTY SALOONS	620 HUGHES ST	CAPE MAY		08204	BOB GRECO	(609) 884-3047		UFCW - 1657	2013 FIRST AVE NORTH	BIRMINGHAM	AL	35203	GEORGE L SEIDENFADEN	(205) 324-1657		OXFORD	AL	36203			J	10	20
1996-10-01		GILLIG CORPORATION	POB 3008	HAYWARD		94540	STEVE COHAINE	(510) 785-1500		PAT - 1176	8400 ENTERPRISE WY RM 124	OAKLAND	CA	94621	MARK VAN ZEVERN	(510) 632-7456	BR	HAYWARD	CA	94540	1996-12-31		C	5	550
1996-10-01		GRAPHIC VINYL PRODUCTS INC	400 FERRY ST	NEWARK		07105	LARRY MAYER	(201) 589-5550		UFCW - 342-50	149 FIFTH AVE	NEW YORK	NY	10010	PETER LAUREANO	(212) 533-7700	VP	NEWARK	NJ	07105	1997-01-31		E	110	176
1996-10-01		HILLHAVEN OF WINDSOR (CERTIFIED NURSES AIDES ETC)	581 POQUONOCK AVENUE	WINDSOR		06095	JAMES FIDANZA	(203) 688-7211	ADMIN	HERE - 1115	761 MERRICK AVENUE	WESTBURY	NY	11590-6608	JOHN SEALES	(516) 542-1115	S T	WINDSOR	CT	06095	1996-12-03		L	80	110
1996-10-01		MCCONE ELEC CO OPERATIVE INC (MC CONE)(COOPERATIVE)	POB 368	CIRCLE		59215	DUANE GACKLE	(406) 485-3430	GM	IBEW - 1050	401 COOKE ST	GLENDIVE	MT	59330	KENNETH L OLSEN	(406) 652-4146		CIRCLE	MT	59215	1996-12-31		H	13	22
1996-10-01		METROPOLITAN HEALTHCARE PARTNERSHIP TWIN CITIES/SEIU	VARIOUS	MINNEAPOLIS		55433	VARIOUS			SEIU - 113	2021 E HENNEPIN AVE 260	MINNEAPOLIS	MN	55413	DONNA CHESTER	(612) 331-4690	FS	ST PAUL	MN	55114	1996-10-30		L	120	100000
1996-10-01		MIDWEST GRAIN	1301 1ST ST DISTILLERY RD	PEKIN		61555-1069	BRIAN CAHILL	(309) 353-3990	VP & GM	UFCW - 4D	300 MCLEAN	PEKIN	IL	61554	VERN FRAKES	(309) 685-2815	INTL PRES	PEKIN	IL	61555-1069	1996-11-01		T	90	135
1996-10-01		MILWAUKEE HILTON	509 WEST WISCONSIN AVE	MILWAUKEE		53203	SUSAN FREDRICK	(414) 226-3244	HR MGR	IUOE - 317	3152 SOUTH 27TH ST	MILWAUKEE	WI	53215	EARL MATZINGER	(414) 671-3258		MILWAUKEE	WI	53203	1996-11-30		J	7	85
1996-10-01		MINNESOTA EPILEPSY GROUP PA	310 N SMITH AVE STE 300	ST PAUL		55102	KEVIN MOULTON	(612) 220-5290	H R REP	SEIU - 113	2021 E HENNEPIN AVE 260	MINNEAPOLIS	MN	55413	JOYCE GONIER	(612) 331-4690	BR	SAINT PAUL	MN	55102	1996-12-31		L	31	40
1996-10-01		MUSKEGON MERCY COMMUNITY HEALTHCARE	1500 E SHERMAN BLVD	MUSKEGON		49440	CARL VERBEEK	(616) 336-6000	ATTY	SEIU - 79	POB 727	MUSKEGON	MI	49443	RAY MURDAUGH	(616) 722-6303	BUS REP	MUSKEGON	MI	49440			L	12	800
1996-10-01		P&M TRANSPORTATION (P & M)	849 KING GEORGIES RAOD	FORDS		08863	RON RICCI	(908) 738-4559		IBT - 202	9A NYC TERMINAL MKT	BRONX	NY	10474	JOSEPH BYERS	(718) 328-7000	PRESIDENT	FORDS	NJ	08863	1996-11-01		F	14	23
1996-10-01		PACE SUBURBAN BUS SYSTEM (SOUTH DIVISION)	550 W ALGONQUIN ROAD	ARLINGTON HEIGHTS		60005-4412	MELINDA METZGER	(847) 228-2403	DEPUTY DIR	SPOT - 2000	POB 1542	MATTESON	IL	60443	LEE RUFF	(708) 389-6916	PRESIDENT	HARVEY	IL	60426	1995-08-31		F	160	182
1996-10-01		PANTAGRAPH PRINTING AND STATIONERY (2)	217 WEST JEFFERSON	BLOOMINGTON		61701	MIKE DOLAN	(309) 829-1071	PRESIDENT	GCIU - 68C	802 YORKSHIRE COURT	WASHINGTON	IL	61571	BARBARA FLEMING	(309) 444-8517	S T	BLOOMINGTON	IL	61701	1996-10-20		E	25	45
1996-10-01		POMODA INC	2904 LINCOLN AVENUE	OCEANSIDE		11572	TONINO D'ANTONIO	(516) 536-1900	PRESIDENT	UFCW - 174	540 WEST 48TH STREET	NEW YORK	NY	10036-1130	MITCHELL HOLLOWAY	(212) 307-7007	PRESIDENT	OCEANSIDE	NY	11572	1996-11-30		J	6	0
1996-10-01		PORT OF CROW WING COUNTY INC	POB 488 115 E RIVER ROAD	BRAINERD		56401	KEN ANDERSON	(218) 829-0263	EX DIR	SEIU - 113	2021 E HENNEPIN AVE 260	MINNEAPOLIS	MN	55413	LORNE JOHNSON	(612) 331-4690	BR	BRAINERD	MN	56401	1996-12-31		L	43	55
1996-10-01		QUEBECOR PRINTING (ST PAUL)	1999 SHEPARD ROAD	ST PAUL		55116	DAVID ULRICH	(612) 690-7572	DIR OF H R	GCIU - 29-C	411 MAIN ST SUITE 213	ST PAUL	MN	55102	NICHOLAS D CARUSO	(612) 222-7803	PRESIDENT	SAINT PAUL	MN	55116	1996-12-31		E	143	200
1996-10-01		RAB ELECTRIC CO INC	170 LUDLOW AVENUE	NORTHVALE		07647	RICHARD BARNA	(201) 784-8600	PRESIDENT	IBEW - 3	158-11 H V ARSDALE JR AVE	FLUSHING	NY	11365	RUDOLPH BOGUE	(718) 591-4000	BR	NORTHVALE	NJ	07647	1996-11-15		E	55	63
1996-10-01		RETAIL CLOTHING COS OF NYC NY & VIC UNITE N Y JT BD	VARIOUS ADDRESSES	VARIOUS CITIES						UNITE - NEW YORK JT BD	31 WEST 15TH STREET	NEW YORK	NY	10011	SAL RUMBOLO	(212) 243-0300	GM	NEW YORK	NY	10011	1996-11-30		J	950	1500
1996-10-01		RIGHT OF WAY LINE CLEAR AGT COLLEGEVILLE PA IBEW 126	VARIOUS ADDRESSES	VARIOUS CITIES		00000	GEN MGR			IBEW - 126	3455 GERMANTOWN PIKE	COLLEGEVILLE	PA	19426	THOMAS A LEACH	(610) 489-1185	BUS MGR	COLLEGEVILLE	PA	19426	1996-12-31		J	50	55
1996-10-01		SANDIA NATIONAL LABORATORIES	POB 5800	ALBUQUERQUE		87185	ROBERT FRASER	(505) 844-3115		IUPA - 7002	512 CHAMA NE STE A	ALBUQUERQUE	MN	87108	BOBBY K GRIMES	(505) 265-7809	VP	ALBUQUERQUE	NM	87101	1996-11-30		J	130	4000
1996-10-01		SHAWN'S SPARKLING SQUEGEE SERVICE	2714 W 42TH AVE	DENVER		80211	SWAWN GARCIA	(303) 477-6428		SEIU - 105	1535 LOGAN	DENVER	CO	80203	RICK HALL	(303) 830-2788	PRESIDENT	DENVER	CO	80249	1996-11-30		J	6	6
1996-10-01		SIKORSKY AIRCRAFT	6900 MAIN ST	STRATFORD		06497	JOSEPH BYRKA	(203) 386-6330	HR DIR	IBT - 1150	150 GARFIELD AVE	STRATFORD	CT	06497	JOHN SANTAMARIA	(203) 381-9240	SECY TREAS	TROY	AL	36081	1996-10-13		E	100	450
1996-10-01		SOUTHERN IOWA COOPERATIVE INC	NOT PROVIDED	BLOOMFIELD		52537	DARLENE FRY	(515) 664-2277		IBEW - 55	1435 NE 5TH AVENUE	DES MOINES	IA	50313	DONALD BARROW	(515) 265-6193	BM	BLOOMFIELD	IA	52537	1996-12-31		H	11	23
1996-10-01		ST PETERS HOME FOR BOYS (SAINT PETER'S)	16121 JOY ROAD	DETROIT		48227	BERRY SAWYER	(313) 846-6942	EX DIR	AFSCME - 1640	23855 NORTHWESTERN HWY	SOUTHFIELD	MI	48075	SHARON DONAHUE	(810) 827-1770	STAFF REP	DETROIT	MI	48227	1997-01-31		J	81	93
1996-10-01		SYLVAN SERVICE CORP	575 N PENNSYLVANIA ST	INDIANAPOLIS		46204	JAY MCCARTHY	(317) 630-9073	PRESIDENT	IBT - 716	849 S MERIDIAN ST	INDIANAPOLIS	IN	46225	ANDREW WATERMAN	(317) 632-9468	BUS REP	INDIANAPOLIS	IN	46225	1997-03-31		J	21	25
1996-10-01		TEXAS REFINERY CORPORATION	840 N MAIN ST POB 711	FORT WORTH		76101	JANET MAY	(817) 335-1161		IAM - 2513	555 N GRANTS LANE	FORT WORTH	TX	76108	PAT L LANE	(817) 246-2443	PRESIDENT	FORT WORTH	TX	76101	1996-11-30		D	13	100
1996-10-01		TIMES SUPER MARKET LTD	2153 N KING ST 2ND FL	HONOLULU		96819	CLIFFORD HAYASHI	(808) 847-0811	GM	IBT - 996	904 KOHOU ST STE 102	HONOLULU	HI	96817	EDWARD MC INERNY	(808) 847-6633	BR	HONOLULU	HI	96817	1996-10-24		U	117	960
1996-10-01		TRANSIT MANAGEMENT OF DURHAM INC	POB 1612	DURHAM		27702	ALLEN B CARTER	(919) 687-7055		ATU - 1493	3535 S WILMINGTON ST 202	RALEIGH	NC	27603	JANIS M BORCHARDT	(919) 772-0790		DURHAM	NC	27701	1997-01-31		F	50	200
1996-10-02		ARTEX KNITTING MILLS INC	300 HARVARD AVENUE	WESTVILLE		08093	BERNARD GERBARG	(609) 456-2800		UNITE - 33T	22 SOUTH 22ND ST	PHILADELPHIA	PA	19103	JOHN FOX	(215) 751-9770	MANAGER	PHILADELPHIA	PA	19103	1997-01-15		E	60	70
1996-10-02		BREDERO PRICE COMPANY	21 S STEEL ROAD	MORRISVILLE		19067	GEN MGR	(215) 736-1111		LIUNA - 57	1367 RIDGE AVENUE	PHILADELPHIA	PA	19123	RICHARD MCCURDY JR	(215) 235-5700	BUS MGR	MORRISVILLE	PA	19067	1997-02-28		E	30	60
1996-10-02		BROCK & COMPANY INC	77 GREAT VALLEY PARKWAY	MALVERN		19355	LYNMAR BROCK JR	(215) 647-5656		UAW - 1612	125 WITMER ROAD	HORSHAM	PA	19044	JOSEPH SINNI	(215) 441-5415	INTL REP	MALVERN	PA	19355	1996-12-31		J	35	2000
1996-10-02		BROGAN CADILLAC OLDSMOBILE CO (CADILLAC-OLDSMOBILE)	POB 206 ROUTE 46 EAST	TOTOWA		07511	THOMAS BROGAN JR	(201) 785-4300		SEIU - 355	138 50 QUEENS BLVD	BRIARWOOD	NY	11435	JONATHAN SCOTT AMES	(718) 658-4848		TOTOWA	NJ	07511	1997-01-31		J	12	50
1996-10-02		CARGILL INC	POB 9300	MINNEAPOLIS		55440	FELIX RICO	(612) 742-7001	DIR OF L R	AFGM - 110	625 DELAWARE AVE STE 302	BUFFALO	NY	14202	JAMES SCORDATO	(716) 881-2293	BA	ALEXANDER	NY	14005	1996-12-04		T	9	9
1996-10-02		CASE IH (I H)	800 SUNSHINE	KANSAS CITY		66115	DAVE KENDRICK	(913) 281-9700		USA - 14777	4212 S HOCKER STE 150	INDEPENDENCE	MO	64055	JERRY T JOHNSON	(913) 478-4800	STAFF REP	KANSAS CITY	KS	66115	1996-11-30		J	38	50
1996-10-02		CLASS ACT CATERING	POB 17	HEMLOCK		46937	DICK TROTT	(317) 455-3663		HERE - 12	35 EAST 7TH ST 308	CINCINNATI	OH	45202	GREG SLAGLE	(513) 241-0341		HEMLOCK	IN	46937	1996-12-30		J	9	9
1996-10-02		COLUMBIA MEMORIAL HOSPITAL	71 PROSPECT AVENUE	HUDSON		12534	JANE EHRLICH	(518) 828-8244		AFSCME - 888 CSEA	ONE LEAR JET LANE STE 2	LATHAM	NY	12110-2394	ANDREW A MACDONALD			CATSKILL	NY	12414	1996-12-31		L	109	160
1996-10-02		COMMUNITY INVOLVEMENT PROGRAMS (AVEYRON)	1600 BROADWAY ST NE 100	MINNEAPOLIS		55413-2961	JOHN EVERETT	(612) 362-9939	CEO	USA - 12106	2829 UNIVERSITY AV SE 100	MINNEAPOLIS	MN	55414	DENISE R ORSON	(612) 623-8003	STAFF REP	MINNEAPOLIS	MN	55413-2961	1997-01-01		L	22	26
1996-10-02		CONNECTOR MANUFACTURING	3501 SYMMES ROAD	HAMILTON		45015-1369	W J BOEHM	(513) 860-4455		IBEW - 648	4300 MILLIKIN ROAD	HAMILTON	OH	45011	DONALD W VIDOUREK	(513) 863-6545	BUS MGR	HAMILTON	OH	45011	1996-11-30		E	80	90
1996-10-02		CONST CONTRS LABOR EMPLRS OF NEW JERSEY (CCLE/NJ)	POB 815	LAKEWOOD		08701	ROBERT A BRIANT	(908) 367-1500	VP	PPF - 274	1000 HENDRICKS CAUSEWAY	RIDGEFIELD	NJ	07657	THOMAS J STILES	9434700	BM	LAKEWOOD	NJ	08701	1996-10-31		J	100	120
1996-10-02		DAYTON MAIMI AFL CIO SENIOR HOUSING FOUNDATION INC	980 WILMINGTON	DAYTON		45420	WES WELLS	(513) 245-6141		HERE - 12	35 EAST 7TH ST 308	CINCINNATI	OH	45202	GREG SLAGLE	(513) 241-0341		DAYTON	OH	45420	1996-12-01		L	3	3
1996-10-02		DEFIANCE HOSPITAL LOCAL 514	1206 EAST 2ND ST	DEFIANCE		43512	LINDA SHAFFER	(419) 783-6955		OPEIU - 457	POB 619	BROWNSVILLE	PA	15417	PATRICIA PRILOH	(412) 785-2822	PRESIDENT	DEFIANCE	OH	43512	1996-12-16		L	250	350
1996-10-02		DIRECT PRESS MODERN LITHO STUDIO	386 OAKWOOD ROAD	HUNTINGTON STATIO		11746	JOE HUMBERT	(516) 271-7000		IBT - 918	2137 UTICA AVENUE	BROOKLYN	NY	11234	DANIEL LOMBARDOZZI	(718) 258-9180	PRESIDENT	HUNTINGTON STATIO	NY	11746	1996-11-30		E	63	125
1996-10-02		DR RALPH KORNBLOTT	374 NEW YORK AVENUE	HUNTINGTON		11743	RALPH KORNBLOTT	(516) 421-0250	DR	IUE - 408	200 PARK AVENUE SOUTH	NEW YORK	NY	10003	RICHARD L SMYTHE	(212) 260-1410	BR	HUNTINGTON	NY	11743	1996-12-01		J	0	0
1996-10-02		DR SAMUEL KORNBLOTT	POB 624 163-03 BAISLEY RD	JAMAICA		11434	SAMUEL KORNBLOTT	(718) 276-0707	DR	IUE - 408	200 PARK AVENUE SOUTH	NEW YORK	NY	10003	RICHARD L SMYTHE	(212) 260-1410	BR	JAMAICA	NY	11434	1996-12-01		J	0	0
1996-10-02		FARNAM SEALING SYSTEMS	900 FARNAM DRIVE	NECEDAH		54646	JIM MUTSCH	(608) 565-2241	H R	UE - 1107	POB 267	NECEDAH	WI	54646	GLENN BUSH	(608) 565-2400	PRESIDENT	NECEDAH	WI	54646	1996-11-30		E	290	335
1996-10-02		G T E SOUTH INC (MONROE) (GTE)	POB 1412	DURHAM		27702	PAUL GWALTNEY			CWA - DISTRICT 3	3354 PERIMETER HILL DR	NASHVILLE	TN	37211	WM DOUGLAS STEARMAN	(615) 331-4890		DURHAM	NC	27702	1996-12-07		G	15	26
1996-10-02		GLOBAL MOTORS CORP	POB 1305	NORTH PLAINFIELD		07060	LARRY MILLMAN	(516) 328-3737	ATTORNEY	SEIU - 355	138 50 QUEENS BLVD	BRIARWOOD	NY	11435	JONATHAN SCOTT AMES	(718) 658-4848		PLAINFIELD	NJ	07060	1997-01-31		J	27	33
1996-10-02		INTERSTATE BAKING COMPANY	POB 15409	SACRAMENTO		95851	JAMES R HAM	(415) 366-8261	DIR LR	IBT - 533	316 VASSAR ST	RENO	NV	89502	LOU MARTINO	(702) 348-6060	SECY TREAS	RENO	NV	89502	1997-01-31		E	25	30
1996-10-02		LUCENT TECHNOLOGIES INC	7400 SCOTT HAMILTON DR	LITTLE ROCK		72209-3175	MARGIT ELO-GENTHNER	(501) 569-4214		IBEW - 2022	6707 FORBING ROAD	LITTLE ROCK	AR	72209-3413	JERRY CHARLES	(501) 562-4609	PRESIDENT	LITTLE ROCK	AR	72209	1996-11-21		E	270	300
1996-10-02		MARINE OPTICAL	5 HAMPDEN DRIVE	SOUTH EASTON		02375	DAVE DUFOUR	(508) 238-7188		IUE - 408	200 PARK AVENUE SOUTH	NEW YORK	NY	10003	RICHARD L SMYTHE	(212) 260-1410	BR	SOUTH EASTON	MA	02375	1996-12-31		J	0	0
1996-10-02		MECHANICAL CONTRACTORS	3110 FAIRVIEW DRIVE	OWENSBORO		42303-2175	MIKE KOGER	(502) 685-0148	OWNER	PPF - 633	3128 ALVEY PARK DR WEST	OWENSBORO	KY	42303	NORMAN COLE		BUS MGR	OWENSBORO	KY	42301	1996-12-31		C	350	400
1996-10-02		MIDWEST WOODWORKING & FIXTURE CORP (ORDILL ILL PLANT	11634 GRAVOIS ROAD	ST LOUIS		63126	DONALD DEPKE	(314) 843-3001	I R REPR	CJA - 638	2290 SOUTH ILLINOIS ST	BELLEVILLE	IL	62220	DAVID PERKO	(618) 997-4869	B A	CARTERVILLE	IL	62918	1996-11-30		E	43	56
1996-10-02		NEIL BUICK CORP	1800 ROUTE 112	MEDFORD		11763	NEIL FELDSTEIN	(516) 289-7800		SEIU - 355	138 50 QUEENS BLVD	BRIARWOOD	NY	11435	SAL DILEONARDI	(718) 658-4848		MEDFORD	NY	11763	1998-12-31		J	9	60
1996-10-02		RIO GRANDE EMPLOYEES HOSPITAL ASSOCIATION	1675 CARR ST	LAKEWOOD		80215	VALORIE GLASER	(303) 274-2312	OFFICE MGR	TCIU - 837	53 W SEEGERS RD	ARLINGTON HEIGHTS	IL	60005	DENNIS LAMBERT	(847) 981-1290	PRESIDENT	LAKEWOOD	CO	80215	1996-12-31		J	5	7
1996-10-02		RUNYON MUSIC	ROUTE 22 & FADAM RD	SPRINGFIELD		07083		(908) 376-8777		IBT - 575	2414 MORRIS AVENUE	UNION	NJ	07083	ALBERT TUTELA	(908) 964-4550	S T	SPRINGFIELD	NJ	07081	1996-12-31		J	23	0
1996-10-02		SHADE TREE SERVICE CO THE	520 S HIGHWAY DRIVE	FENTON		63026	JAMES BAKER	(314) 343-1212		IBEW - 55	1435 NE 5TH AVENUE	DES MOINES	IA	50313	DON BARROW	(515) 265-6193	BM	DES MOINES	IA	50313	1996-12-31		C	25	250
1996-10-02		SPARTEK INC	NOT PROVIDED	SPARTA		54656	DICK KIEDEROWSKI	(608) 269-3154	GM	UE - 1161	320 N WATER ST	SPARTA	WI	54656	LINDA STEINHOFF	(608) 791-0752	PRESIDENT	SPARTA	WI	54656	1996-12-03		E	125	141
1996-10-02		SWAN OPTICAL	101 HENLEY AVENUE	NEW MILFORD		07646	JOSEPH GLASSMAN	(201) 599-0800		IUE - 408	200 PARK AVENUE SOUTH	NEW YORK	NY	10003	RICHARD L SMYTHE	(212) 260-1410	BR	NEW MILFORD	NJ	07646	1996-12-02		J	37	52
1996-10-02		T THERMAL INC	5 SENTRY PKWY E STE 204	BLUE BELL		19422	KENNETH T JOYCE	(215) 832-8767		UAW - 1612	125 WITMER ROAD	HORSHAM	PA	19044	JOSEPH SINNI	(215) 441-5415	INTL REP	BLUE BELL	PA	19422	1996-12-17		E	27	53
1996-10-02		TREES INC	POB 38038	HOUSTON		77238	BILLY MILLS	(713) 692-6371	VP	IBEW - 659	24 1/2 SOUTH GRAPE	MEDFORD	OR	97501	JIM MC LEAN	(541) 772-5271	BM	MEDFORD	OR	97501	1996-12-31		C	100	150
1996-10-02		UTILITY CONTRACTORS ASSN (GAS DISTRIBUTION AGREEMENT	PON 769 150 AIRPORT RD	LAKEWOOD		08701	ROBERT BRIANT	(908) 905-4951	DIR	PPF - 274	1000 HENDRICKS CAUSEWAY	RIDGEFIELD	NJ	07657	THOMAS J STILES	9434700	BM	LAKEWOOD	NJ	08701	1996-10-31		J	100	141
1996-10-02		VALLEY BROOK PROVISIONS	1810 COLUMBIA AVENUE	FOLCROFT		19032	MICHAEL GALLO	(215) 922-3113		SEIU - 455	138 50 QUEENS BLVD	BRIARWOOD	PA	11435	TROY ANDERSON	(718) 658-4848		FOLCROFT	PA	19032	1997-01-30		J	3	6
1996-10-02		VAN DYKE GAS	23823 SHERWOOD	CENTER LINE		48015	PETER SCHEID	(313) 757-8500		IBT - 283	1625 FORT ST	WYANDOTTE	MI	48192	MIKE FINEGAN	(313) 282-8850	BUS AGENT	CENTER LINE	MI	48015			H	9	0
1996-10-02		VARO FLOORS	1632 FAIRFAX ROAD	WEST ISLIP		11795	FRANK CRIVARO			IBEW - 1430	170 HAMILTON AVENUE	WHITE PLAINS	NY	10601	DOMINICK MACCHIA	(914) 948-3771	BM	WHITE PLAINS	NY	10601	1996-11-30		C	1	1
1996-10-02		VETERANS OF FOREIGN WARS HENRY HART POST 1411	205 UNION ST	CUMBERLAND		21502	VICTOR FEUNTEHLBA	(410) 539-5715	ATTY	HERE - 7	2205 N CHARLES ST STE 300	BALTIMORE	MD	21218	PAUL RICHARDS	(410) 467-4373	EXEC S/TR	CUMBERLAND	MD	21502	1997-01-18		J	4	20
1996-10-02		WEST END GARAGE	965 ST GEORGE AVENUE	RAHWAY		07065	NELSON TAYLOR	(908) 388-0094		SEIU - 355	138 50 QUEENS BLVD	BRIARWOOD	NJ	11435	JONATHAN SCOTT AMES	(718) 658-4848		RAHWAY	NJ	07065	1997-01-31		J	5	8
1996-10-03		A TO Z AUTO PARTS NO 2 INC	8528 WATSON ROAD	ST LOUIS		63119	LARRY STURM	(314) 842-6800	PRESIDENT	IAM -	50 WEST OAKTON ST	DES PLAINES	IL	60018	JOE COOPER	(312) 694-4088	GL REP	SAINT LOUIS	MO	63101			J	5	10
1996-10-03		A V X CORP (AVX)	3900 ELECTRONICS DR	RALEIGH		27604	RICHARD AIOSA	(919) 878-6200	HR VP	AFGW - 1028	1440 SOUTH BYRNE RD	TOLEDO	OH	43614	LAWRENCE BANKOWSKI	(419) 385-6687	PRES	RALEIGH	NC	27604	1996-12-14		E	204	300
1996-10-03		AVIV HEALTH CARE CENTERS OF MINNEAPOLIS (2)	VARIOUS	MINNEAPOLIS		55411	VARIOUS	(612) 374-3380	DON HON	UFCW - 653	505 N HIGHWAY 169 755	PLYMOUTH	MN	55441	AUGUST W ZAHN	(612) 525-1500		MINNEAPOLIS	MN	55441	1996-12-31		L	158	220
1996-10-03		BAKER KNAPP & TUBBS	171 EAST 24TH ST	HOLLAND		49423	GARY WAINWRIGHT	(616) 392-3181		CJA - 2535	1061 FOUNATIN N E	GRAND RAPIDS	MI	49503	JACK DREYER	(616) 451-3517	BUS REP	HOLLAND	MI	49423	1996-12-12		E	110	135
1996-10-03		BARRY & SAM	118 TENTH AVENUE	NEW YORK		10011				IAM - DISTRICT 15	1455 MAIN AVENUE	CLIFTON	NJ	07011	VICTOR BOBES	(201) 340-3601	BR	NEW YORK	NY	10011	1997-01-01		J	4	4
1996-10-03		BETATRONIX INC	110 NICON CT	HAUPPAUGE		11787	JOE YANOSIK	(516) 582-6740		IBEW - 1922	1065 OLD COUNTRY RD 214	WESTBURY	NY	11590	FRANK GAUCK	(516) 334-4140	BM	HAUPPAUGE	NY	11788	1996-12-31		E	41	60
1996-10-03		BETHEA CORP	5300 SOUTH HOWELL AVE	MILWAUKEE		53207	VERN BETHEA	(414) 747-4630	PRES	HERE - 122	231 WEST WISCONSIN AVE	MILWAUKEE	WI	53203	CAROL J CARLSON	(414) 271-0290	TRUSTEE	MILWAUKEE	WI	53201	1996-12-31		J	22	40
1996-10-03		BEVERLY MANOR CONVALESCENT CENTER	1930 KAMEHAMEHA IV RD	HONOLULU		96819	VIRGINA HUEFTLE	(808) 847-4834	ADMIN	AFSCME - 646	1426 N SCHOOL ST	HONOLULU	HI	96817	CLIFFORD T UWAINE	(808) 847-2631	DD	HONOLULU	HI	96817	1996-12-31		L	70	100
1996-10-03		BRADY'S INC (BRADYS)	5306 WST 25TH AVE	GARY		46406	RONALD COHEN	(219) 844-1130	PRES	UFCW - 881	122 WEST 22ND ST	OAKBROOK	IL	60521-1575	WALLY EVANS	(630) 954-1800		GARY	IN	46406	1996-12-30		J	13	0

Download this data

CSV · JSON

Table schema

CREATE TABLE f7(notice_date VARCHAR, initiated_date DATE, employer VARCHAR, employer_street VARCHAR, employer_city VARCHAR, employer_state VARCHAR, employer_zip VARCHAR, employer_representative VARCHAR, employer_representative_phone VARCHAR, employer_representative_title VARCHAR, employer_representative_email VARCHAR, union_name VARCHAR, union_street VARCHAR, union_city VARCHAR, union_state VARCHAR, union_zip VARCHAR, union_representative VARCHAR, union_representative_phone VARCHAR, union_representative_title VARCHAR, union_representative_email VARCHAR, affected_location_city VARCHAR, affected_location_state VARCHAR, affected_location_zip VARCHAR, expiration_date DATE, naics BIGINT, industry VARCHAR, bargaining_unit_size BIGINT, establishment_size BIGINT, notice_submitted_by VARCHAR, category VARCHAR, healthcare_related BIGINT, location_negotiation_city VARCHAR, location_negotiation_state VARCHAR, location_negotiation_zip VARCHAR);