l_union_codes_and_names
216 rows
This data as json, CSV (advanced)
| code ▼ | union_name |
|---|---|
| 1 | Actors and Artists of A., Associated - AAA |
| 2 | Air Line Pilots - ALPA |
| 3 | Aluminum Workers Intl. Un. - AWU (Merged with 025) |
| 4 | Asbestos Workers; Intl. Assn. of Heat and Frost Insulators - HFIA |
| 5 | Industrial Workers of A.; Intl. Un., Allied - AIW |
| 7 | Atomic Trades Labor Council |
| 9 | Actors' Equity Assn. - AEA |
| 11 | Baker and Confectionery Workers; Intl. Un. of A. - BCW (Merged to form 026) |
| 12 | Barbers, Hairdressers, Cosmetologists and Proprieters' Intl. Un. of A.; Journeymen - BHC (Merged with 241) |
| 13 | Bill Pasters, Billers & Distributors of the U.S. & Canada; Intl. Alliance of - BPBD (Charter Surrendered) |
| 15 | Boilermakers, Iron Shipbuilders, Forgers & Helpers; Intl. Brthd. of - BBF |
| 16 | Graphic Arts; Intl. Un. of - GAIU (Merged to form 245) |
| 17 | Shoe Workers' Un.; Boot and - BSSW (Merged with 241) |
| 20 | Brick and Clay Workers of A., United - UBCW (Merged to form 025) |
| 21 | Iron Workers, Intl. Assn. of Bridge Structural & Ornamental - BSOIW |
| 22 | Broom and Whisk Makers' Un. of A., Intl. - BWM (Disbanded) |
| 23 | Service Employees Intl. Un. - SEIU |
| 25 | Aluminum, Brick and Glass Workers |
| 26 | Bakery, Confectionery & Tobacco Wkrs, Intl. Un. of A. - BCTW |
| 31 | Carpenters and Joiners of A.; United Brthd. of - CJA |
| 32 | Cement, Line and Gypsum Workers Intl. Un.; United - CLGW (merged with 015) |
| 33 | Cigar Makers; Intl. Un. of - CMIU (Merged with 241) |
| 36 | Retail Clerks Intl. Assn. - RCIA (merged with 241) |
| 37 | Coopers'; Intl. Un. of N.A. - CIU |
| 38 | Chemical Workers Un. Intl. - ICW |
| 52 | Engineers; American Federation of Technical - AFTE |
| 53 | Distillery, Rectifying, Wine and Allied Workers; Intl. Un. of A. - DRWW (Merged with 241) |
| 61 | Electrical Workers; Intl. Brthd. of - IBEW |
| 62 | Elevater Constructors; Intl. Un. of - IUEC |
| 63 | Engineers; Intl. Un. of Operating - IUOE |
| 71 | Fire Fighters Intl. Assn. of - IAFF |
| 72 | Firemen and Oilers; Intl. Brthd. of - IBFO |
| 74 | Fabricated Metal & Enamelware Workers; Council of |
| 78 | Peanut Shelling Workers; United - UPSW |
| 81 | Garment Workers of A.; United - UGW |
| 82 | Glass Bottle Blowers Assn. of the United States & Canada - GBBA (Merged with 150) |
| 83 | Glass Cutters League of A.; Window - WGCL (Merged with 150) |
| 84 | Glass Workers' Un. of N.A.; American Flint - AFGW |
| 86 | Government Employees; American Federation of - AFGE |
| 87 | Granite Cutters' Intl. Assn. of A.; - CGIA (Merged with 031) |
| 88 | Grain Millers; American Federation of - AFGM |
| 101 | Leather Goods, Plastic & Nevelty Workers Un.; Intl. - LGPN |
| 102 | Hatters, Cap & Millinery Wkrs. Intl. Un.; United - HOMW (Merged with 563) |
| 103 | Laborers Intl. Union of N.A. - LI |
| 104 | Horseshoers of the U.S. & Canada; Intl. Un. of Journeymen - UJH |
| 105 | Hotel & Restaurant Employees & Bartenders Intl. Un. - HREU |
| 106 | Hebrew Actors Un., Inc. - HAU |
| 109 | Insurance Workers Intl. Un. - IWIU |
| 110 | Italian Actors Un. - IAU |
| 111 | Jewelry Workers Un.; Intl. - JWU (Merged with 023) |
| 121 | Garment Workers Un.; Intl. Ladies - ILGW (Merged to form 890) |
| 122 | Lathers Intl. Un.; The Wood, Wire and Metal - WWML (Merged with 031) |
| 125 | Letter Carriers of the United States of A.; Natl. Assn. of - NALC |
| 126 | Letter Carriers Assn. Natl. Rural - RLCA |
| 130 | Longshoremen's Assn. Intl. - ILA |
| 132 | Laundry and Dry Cleaning Intl. Un. - LDC |
| 134 | Locomotive Firemen and Enginemen Brthd. Of (Merged with 563) |
| 135 | Licensed Tugmen and Pilots Protective Assoc. of A. |
| 141 | Machinists and Aerospace Workers; Intl. Assn. of - IAM |
| 142 | Maintenance of Way Employees; Brthd. of - BMWE |
| 143 | Marble, Slate & Stone Polishers, Rubbers & Sawyers, Tile & Marble Setters' Helpers & Marble Mosaic & Terrazzo Wkrs. Helpers; Intl. Assn. of - MSSP (Merged with 031) |
| 144 | Masters, Mates and Pilots Intl. Organization of - MMP (Merged with 130) |
| 146 | Meat Cutters and Butcher Workmen of N.A.; Amalgamated - MCBW (Merged to form 241) |
| 147 | Metal Engraves Union; Intl. |
| 148 | Metal Polishers, Baffers, Platers and Helpers Intl. Un. - MPBP |
| 149 | Mine Workers Progressive (N) |
| 150 | Glass, Molders, Pottery, Plastic and Allied Workers Un. Intl. |
| 151 | Musicians; American Federation of AFM |
| 154 | American Guild of Musical Artists, Inc. - AGM |
| 166 | Office Employees' Intl. Un. - OEIU |
| 169 | Hospital and Health Care Employees; National Un. of |
| 171 | Painters and Allied Trades; Intl. Un. of - IUPAT |
| 172 | Papermakers and Paperworkers; United - UPP (Merged to form 187) |
| 173 | Pattern Makers' League of N.A. - PML |
| 175 | Lithographers and Photoengravers Intl. Un. - LPIU (Merged to form 245) |
| 177 | Plasterers' and Cement Masons' Assn. of the U.S. & Canada; Operative - OPCM |
| 178 | Plumbing and Pipe Fitting Industry of the U.S. & Canada; United Assa. of Journeymen and Apprentice of the - PPF |
| 179 | Postal Workers Union; American - APWU |
| 181 | Pottery and Allied Workers; Intl. Brthd. - IBPAW (Merged with 150) |
| 183 | Plate Printers' Die Stampers' & Engravers' Un. of N.A.; Intl. - PPDGE |
| 184 | Printing & Graphic Communication Un., Intl. - IPGC (Merged to form 245) |
| 185 | Pulp, Suiphite & Paper Mill Workers; Intl. Brthd. of - PSPMW (Merged to form 187) |
| 187 | Paperworkers, United Intl. - UPI (Merged to form 891) |
| 201 | Railway Carmen of A.; Brthd. (Merged with 202) |
| 202 | Railway Airline & Steamship Clerks, Freight Handlers, Express & Station Employees, Brthd. of - BRASC (Title changed to Transportation Communications Intl. Union) |
| 204 | Roofers, Deep & Waterproof Workers Assn.; United Slate, Tile & Composition - RDWW (Changed to Roofers, Waterproofers and Allied Workers) |
| 205 | Railway Patrolmen's Intl. Un. - RPU (Merged with 202) |
| 207 | American Federation of Television & Radio Artists |
| 211 | Seafarers' Intl. Un. of N.A. - SIU |
| 213 | Sheet Metal Workers' Intl. Assn. - SMW |
| 214 | Siderographers; Intl. Assn. of - IAS |
| 217 | Messengers; The National Assn. of Special Delivery - SDM (Merged with 179) |
| 219 | State, County & Municipal Employees; American Federation of - SCME |
| 220 | Stereotypers' & Electrotypers' Un. of North A.; Intl. - ISEU (merged to form 245) |
| 221 | Stone Cutters Assn. of North A.: Journeymen - JSA (Merged with 103) |
| 222 | Stove, Furnace, & Allied Appliance Workers, Intl. Un. of N.A. |
| 223 | Transit Union; Amalgamated - ATU |
| 226 | Screen Actors Galid, Inc. - SAG |
| 227 | Screen Extras Guild, Inc. - SEG |
| 231 | Tailors Un. of A.: Journeymen |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "l_union_codes_and_names" ( [code] INTEGER PRIMARY KEY, [union_name] TEXT );