l_notifications

2,553 rows

✎ View and edit SQL

This data as json, CSV (advanced)

Link rowid ▼ notification_id participant_group nlrb_office_id contact_id keyword subject coverage
1 1 1000001   1   Boilermakers Charges, Petitions & all dispositions Charges filed by or against
2 2 1000002   1 1000012 IBEW Charges, Petitions & all dispositions Charges filed by or against
3 3 1000003   1   Glass, Molders Charges, Petitions & all dispositoins Charges filed by or against
4 4 1000004   1 1000022 UAW Charges & all dispositions Charges filed by or against
5 5 1000005   1   UAW Petitions & all dispositions Petitions filed by or against
6 6 11000001   11 11000211 Allied & Technical Dist. 50, Allied & Tech. Wkrs. All charges/petitions filed by/against
7 7 11000002   11 11000037 Allied & Technical Dist. 50, Allied & Tech. Wkrs. All charges/petitions filed by/against
8 8 11000003   11 11000032 Aluminum, Brick (ABG) Aluminum, Brick & Glass Wkrs. Intl. Un. All charges/petitions filed by/against
9 9 11000004   11 11000005 Army and Air Force Army & Air Force Depts. All charges/petitions filed by/against
10 10 11000005   11 11000083 Automobile (UAW) Automobile, Aerospace Wkrs. Only charges filed by/against
11 11 11000006   11 11000227 Automobile (UAW) Automobile, Aerospace Wkrs. (UAW) Only petitions filed by/against
12 12 11000007   11 11000038 Bell Atlantic Bell Atlantic All charges/petitions filed by/against
13 13 11000008   11 11000177 Beverly Enterprises Beverly Enterprises, Inc. All charges/petitions filed by/against
14 14 11000009   11 11000024 Boilermakers Intl. Bro. of Boilermakers, Iron Ship All charges/petitions filed by/against
15 15 11000010   11 11000233 Boilermakers Intl. Bro. of Boilermakers, Iron Ship All charges/petitions filed by/against
16 16 11000011   11 11000076 Brewery Intl.Un. of Brewery, Flour, Cereal, Soft All charges/petitions filed by/against
17 17 11000012   11 11000102 Carpenters (UBC) Un.Bro. of Carpenters & Joiners of Amer. Only NC locals
18 18 11000013   11 11000223 Comm. Wkrs. (CWA) Communications Wkrs. of America, AFL-CIO All charges/petitions filed by/against
19 19 11000014   11 11000047 Comm. Wkrs. (CWA) Communications Wkrs. of America, AFL-CIO All charges/petitions filed by/against
20 20 11000015   11 11000378 Teamsters (IBT) Intl. Brotherhood of Teamsters (IBT) Chg/pet when Graphic Communications Conf
21 21 11000016   11 11000058 Cone Mills Cone Mills Corporation All charges/petitions filed by/against
22 22 11000017   11 11000209 Continental Gen. Tire Continental General Tire Only charges involving Charlotte plant
23 23 11000018   11 11000234 Duke Energy/Power Duke Energy Corp./Duke Power Co. All charges/petitions filed by/against
24 24 11000019   11 11000095 Elect., Radio (UE) Un. Electrical, Radio & Machine Wkrs. All charges/petitions filed by/against
25 25 11000020   11 11000018 Elect. Wkrs. (IBEW) Intl. Bro. of Electrical Wkrs., AFL-CIO All charges/petitions filed by/against
26 26 11000021   11 11000185 Elect. Wkrs. (IBEW) Intl. Bro. of Electrical Wkrs., AFL-CIO Only certain locals - see Notif. Card
27 27 11000022   11 11000130 Elect. Wkrs. (IBEW) Intl. Bro. of Electrical Wkrs., AFL-CIO Only serve when serving Gene Ruff
28 28 11000023   11 11000072 Elect. Wkrs. (IBEW) Intl. Bro. of Electrical Wkrs., AFL-CIO Only involving Lo. 379
29 29 11000024   11 11000226 Elect. Wkrs. (IBEW) Intl. Bro. of Electrical Wkrs., AFL-CIO Only involving DC, KY, MD, OH, VA, or WV
30 30 11000025   11 11000152 Electronic (IUE) Intl. Un. of Electronic, Elect. Salaried All charges/petitions filed by/against
31 31 11000026   11 11000367 Automobile (UAW) Automobile, Aerspace Wkrs. Only petitions
32 32 11000027   11 11000069 Fieldcrest Cannon Fieldcrest Cannon All charges/petitions filed by/against
33 33 11000028   11 11000027 Food & Comm. (UFCW) Un.Food & Commercial Wkrs. Intl. Un. Only serve when she requests svc.
34 34 11000029   11 11000186 Food & Comm. (UFCW) Un.Food & Commercial Wkrs. Intl. Un. Only petitions
35 35 11000030   11 11000366 Comm. Wkrs. (CWA) Communications Wkrs. of America, AFL-CIO All charges/petitions filed by/against
36 36 11000031   11 11000216 Food & Comm. (UFCW) Un.Food & Commercial Wkrs. Intl. Un. All charges/petitions filed by/against
37 37 11000032   11 11000217 Football Players Nat'l Football League Players Assoc. All charges/petitions filed by/against
38 38 11000033   11 11000194 Ford Motor Co. Ford Motor Company All charges/petitions filed by/against
39 39 11000034   11 11000006 Frito-Lay Frito-Lay, Inc. All charges/petitions filed by/against
40 40 11000035   11 11000230 Frito-Lay Frito-Lay, Inc. All charges/petitions filed by/against
41 41 11000036   11 11000189 General Motors General Motors Corporation All charges/petitions filed by/against
42 42 11000037   11 11000229 Glass, Molders, Pottery Glass, Molders, Pottery, Plastics & Alli All charges/petitions filed by/against
43 43 11000038   11 11000169 Glass, Molders, Pottery Glass, Molders, Pottery, Plastics & Alli All charges/petitions filed by/against
44 44 11000039   11 11000104 Bakery, Conf., Tob., Grain Millers Bakery, Conf., Tob. Wkrs.& Grain Millers All charges/petitions filed by/against
45 45 11000040   11 11000205 Bakery, Conf., Tob., Grain Millers Bakery, Conf., Tob. Wkrs.& Grain Millers All charges/petitions filed by/against
46 46 11000041   11 11000104 Bakery, Conf., Tob., Grain Millers Bakery, Conf., Tob. Wkrs.& Grain Millers All charges/petitions filed by/against
47 47 11000042   11 11000181 Graphic Commun. Graphic Communications Intl. Un., AFL-CI All charges/petitions filed by/against
48 48 11000043   11 11000235 Host Marriott Host Marriott Services All charges/petitions filed by/against
49 49 11000044   11 11000150 Hotel, Restaurant Hotel and Restaurant Employees Intl. Un. Only petitions filed by/against
50 50 11000045   11 11000147 Kolortex Corp. Kolortex Corporation All charges/petitions filed by/against
51 51 11000046   11 11000079 Kroger Co. The Kroger Co. All charges/petitions filed by/against
52 52 11000047   11 11000085 Laborers' (LIUNA) Laborers' Intl. Union of North America All charges/petitions filed by/against
53 53 11000048   11 11000203 Laidlaw Transit Laidlaw Transit, Inc. All charges/petitions filed by/against
54 54 11000049   11 11000100 Laidlaw Waste Laidlaw Waste Systems, Inc. All charges/petitions filed by/against
55 55 11000050   11 11000061 Letter Carriers (NALC) National Association of Letter Carriers All charges/petitions filed by/against
56 56 11000051   11 11000051 Letter Carriers (NALC) National Association of Letter Carriers All charges/petitions filed by/against
57 57 11000052   11 11000182 Letter Carriers (NALC) National Association of Letter Carriers Only NC, SC, & GA charges/petitions
58 58 11000053   11 11000213 Letter Carriers (NALC) National Association of Letter Carriers Only VA & MD charges/petitions
59 59 11000054   11 11000236 Longshoremen (ILA) Intl. Longshoremen's Association Only Lo. 1426 charges/petitions
60 60 11000055   11 11000063 Longshoremen (ILA) Intl. Longshoremen's Association Only Lo. 1422 & 1422A chgs./petitions
61 61 11000056   11   Longshoremen (ILA) Intl. Longshoremen's Association Only Lo. 1422A charges/petitions
62 62 11000057   11 11000070 Longshoremen (ILA) Intl. Longshoremen's Association Only Lo. 333 charges/petitions
63 63 11000058   11   Machinists (IAM) Intl. Assoc. of Machinists & Aerospace All chg/pet filed by/agst10/1/07-9/30/08
64 64 11000059   11   Machinists (IAM) Intl. Assoc. of Machinists & Aerospace All charges/petitions filed by/against
65 65 11000060   11 11000187 Machinists (IAM) Intl. Assoc. of Machinists & Aerospace All charges/petitions filed by/against
66 66 11000061   11 11000080 Machinists (IAM) Intl. Assoc. of Machinists & Aerospace Only when requested
67 67 11000062   11 11000183 Machinists (IAM) Intl. Assoc. of Machinists & Aerospace All chg/pet filed by/agst 10/1/08-9/30/0
68 68 11000063   11 11000085 Mailhandlers/Laborers Mailhandlers Div. of Laborers' Intl. Un. All charges/petitions filed by/against
69 69 11000064   11 11000052 Mailhandlers/Laborers Mailhandlers Div. of Laborers' Intl. Un. All charges/petitions filed by/against
70 70 11000065   11 11000088 Mailhandlers/Laborers Mailhandlers Div. of Laborers' Intl. Un. All charges/petitions filed by/against
71 71 11000066   11 11000135 Mailhandlers/Laborers Mailhandlers Div. of Laborers' Intl. Un. All charges/petitions filed by/against
72 72 11000067   11 11000118 Mailhandlers/Laborers Mailhandlers Div. of Laborers' Intl. Un. Only chgs./petitions re: Lynchburg, VA
73 73 11000068   11 11000043 Oper. Eng. (IUOE) Local 132 Int'l Union of Operating Engineers Chg/pet. filed by/against Lo. 132 only
74 74 11000069   11 11000119 Maritime (NMU) National Maritime Union, AFL-CIO All charges/petitions filed by/against
75 75 11000070   11 11000212 Marriott Corp. Marriott Corporation All charges/petitions filed by/against
76 76 11000071   11 11000055 Mine Wkrs. (UMWA) United Mine Workers of America Only charges filed by/against
77 77 11000072   11 11000239 Mine Wkrs. (UMWA) United Mine Workers of America Only charges filed by/against
78 78 11000073   11 11000172 Needletrades (UNITE HERE) UNITE HERE All except VA chgs./petitions by/against
79 79 11000074   11 11000175 Needletrades (UNITE HERE) UNITE HERE All except VA chgs./petitions by/against
80 80 11000075   11 11000168 Needletrades (UNITE HERE) UNITE HERE All except VA chgs./petitions by/against
81 81 11000076   11 11000067 Needletrades (UNITE HERE) UNITE HERE Only VA chgs./petitions by/against
82 82 11000077   11 11000077 Needletrades (UNITE HERE) UNITE HERE Only serve when Raynor notifies to do so
83 83 11000078   11 11000180 Needletrades (UNITE HERE) UNITE HERE Only involving J.P.Stevens, DrakesBr.,VA
84 84 11000079   11 11000116 NC Labor Alliance NC Labor Alliance All charges/petitions filed by/against
85 85 11000080   11 11000074 Oper. Eng. (IUOE) Intl. Union of Operating Engineers Only non-profit health care institutions
86 86 11000081   11 11000064 Overnite Transportation Overnite Transportation Company All charges/petitions filed by/against
87 87 11000082   11 11000003 United Steel, Paper and Forestry United Steel, Paper and Forestry, Rubber All charges/petitions filed by/against
88 88 11000083   11 11000162 Postal Wkrs. (APWU) American Postal Workers Union, AFL-CIO Only send copy of charge - no ltr.,etc.
89 89 11000084   11 11000008 Rural Ltr. Carriers (NRLCA) National Rural Letter Carriers' Assoc.  
90 90 11000085   11 11000240 Postal Wkrs. (APWU) American Postal Workers Union, AFL-CIO Only serve if filed by/against National
91 91 11000086   11 11000184 Printing Sector of CWA Printing, Pub. & Media Wkrs. Sector/CWA Only serve if Printing Sector involved
92 92 11000087   11 11000148 Printing Sector of CWA Printing, Pub. & Media Wkrs. Sector/CWA Only serve if Printing Sector involved
93 93 11000088   11 11000142 Roofers United Un.of Roofers,Waterproofers All charges/petitions filed by/against
94 94 11000089   11 11000082 Rural Ltr. Carriers (NRLCA) National Rural Letter Carriers' Assoc. All charges/petitions filed by/against
95 95 11000090   11 11000241 Rural Ltr. Carriers (NRLCA) National Rural Letter Carriers' Assoc. All charges/petitions filed by/against
96 96 11000091   11 11000191 Service Employees (SEIU) Service Employees International Union All charges/petitions filed by/against
97 97 11000092   11 11000199 Service Employees (SEIU) Service Employees International Union Only send copy of petition - no ltr.,etc
98 98 11000093   11 11000108 Sheet Metal Wkrs. (SMWIA) Sheet Metal Workers Intl. Association All charges/petitions filed by/against
99 99 11000094   11 11000071 Sheet Metal Wkrs. (SMWIA) Sheet Metal Workers Intl. Association Only Lo. 159 charges/petitions
100 100 11000095   11 11000242 Sheet Metal Wkrs. (SMWIA) Sheet Metal Workers Intl. Association Only Lo. 159 charges/petitions

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "l_notifications" (
    "notification_id" integer,
    "participant_group" integer,
    "nlrb_office_id" integer,
    "contact_id" integer,
    "keyword" text,
    "subject" text,
    "coverage" text
);