More from this project:
Organizations by IRS Subsection
501(c)(17) - Supplemental Unemployment Benefits Trusts
library(tidyverse)
library(knitr)
library(stringr)
library(scales)
library(httr)
source('https://raw.githubusercontent.com/UrbanInstitute/urban_R_theme/master/urban_theme_windows.R')
#Import IRS BMF
bmffile <- read.csv(file = "Data/bm1608.csv")
#Filter out of scope organizations
bmffile <- bmffile %>%
filter((OUTNCCS != "OUT")) %>%
filter((FNDNCD != "02" & FNDNCD!= "03" & FNDNCD != "04")) %>%
filter((SUBSECCD == "17"))
#Sort the bmf in descending order by gross receipts
#Limit the list to 10
#Select the appropriate columns, drop the rest
LargestGrossReceipts <- bmffile %>%
arrange(desc(INCOME)) %>%
slice(1:10) %>%
select(NAME, INCOME, ASSETS)
#Rename columns appropriately
colnames(LargestGrossReceipts) <- c("Organization", "Gross Receipts", "Total Assets")
LargestAssets <- bmffile %>%
arrange(desc(ASSETS)) %>%
slice(1:10) %>%
select(NAME, INCOME, ASSETS)
#Rename columns appropriately
colnames(LargestAssets) <- c("Organization", "Gross Receipts", "Total Assets")
#Generate random sample
set.seed(143)
random20 <- bmffile %>%
filter(bmffile$INCOME != 0 | bmffile$ASSETS != 0)
random20 <-sample_n(random20, 20, replace = FALSE) %>%
select(NAME, INCOME, ASSETS)
colnames(random20) <- c("Organization", "Gross Receipts", "Total Assets")
Number of organizations reporting assets or income = 79. Total Gross Receipts = $367,826,156. Total Assets = $323,255,548.
Largest 501(c)(17)s by Gross Receipts
#display tables
kable(LargestGrossReceipts, format.args = list(decimal.mark = '.', big.mark = ","), caption = "Largest Organizations (By Gross Receipts)")
Organization | Gross Receipts | Total Assets |
---|---|---|
OPERATING ENGINEERS LOCAL 825 SUB FUND | 58,269,716 | 49,116,700 |
MELLON FINANCIAL CORP SUPPLEMENTAL UNEMPLOYMENT BENEFIT TR | 48,577,968 | 0 |
LOCAL 68 ENGINEERS SUPPLEMENTAL UNEMPLOYMENT BENIFIT FUND | 26,331,061 | 49,953,745 |
FORD UAW SUPPLEMENTAL UNEMPLOYMENT BENEFIT PLAN 2227 | 26,308,963 | 318,848 |
ILA-WEST GULF MARITIME ASSOCIATION INC ROYALTY TRUST FUND NO 1 | 26,069,719 | 29,483,018 |
ELECTRICAL INDUSTRY SUPPLEMENTAL UNEMPLOYMENT BENEFIT FUND | 16,837,200 | 47,606,345 |
INTERNATIONAL LONGSHOREMENS ASSN S FL ILA CONTAINER ROYALTY FUND | 12,934,607 | 12,804,023 |
OPERATING ENGINEERS JOINT SUB FUND OF EASTERN PA & DELAWARE | 12,124,073 | 13,759,008 |
NATIONAL ASSOCIATION OF PREVAILING WAGE CONTRACTORS SUPPLEMENTAL | 11,446,666 | 3,345,092 |
GENERAL DYNAMICS EMPLOYMENT TRANSITION BENEFIT PLAN TRUST | 10,783,766 | 368,927 |
Largest 501(c)(17)s by Total Assets
#display tables
kable(LargestAssets, format.args = list(decimal.mark = '.', big.mark = ","), caption ="Largest Organizations (By Total Assets)")
Organization | Gross Receipts | Total Assets |
---|---|---|
LOCAL 68 ENGINEERS SUPPLEMENTAL UNEMPLOYMENT BENIFIT FUND | 26,331,061 | 49,953,745 |
OPERATING ENGINEERS LOCAL 825 SUB FUND | 58,269,716 | 49,116,700 |
ELECTRICAL INDUSTRY SUPPLEMENTAL UNEMPLOYMENT BENEFIT FUND | 16,837,200 | 47,606,345 |
ILA-WEST GULF MARITIME ASSOCIATION INC ROYALTY TRUST FUND NO 1 | 26,069,719 | 29,483,018 |
OPERATIONS ENGINEERS LOCAL 66 BENEFIT FUND TRUST | 9,149,138 | 20,352,017 |
OPERATING ENGINEERS JOINT SUB FUND OF EASTERN PA & DELAWARE | 12,124,073 | 13,759,008 |
INTERNATIONAL LONGSHOREMENS ASSN S FL ILA CONTAINER ROYALTY FUND | 12,934,607 | 12,804,023 |
INTERNATIONAL BROHOOD-BOILERMAKERS LODGE 1 SUPP UNEMP BENEFIT FUND | 7,266,987 | 10,109,713 |
IBEW LOCAL UNION NO 269 WELFARE AND SUPPLEMENTAL FUND | 3,442,564 | 9,925,712 |
PLUMBERS & STEAMFITTERS LOCAL UNION NO 375 SUPPLEMENTAL UNEMPLOYMENT B | 3,474,139 | 9,736,537 |
Random Sample of 501(c)(17)s
#display tables
kable(random20, format.args = list(decimal.mark = '.', big.mark = ","), caption = "Random Sample" )
Organization | Gross Receipts | Total Assets | |
---|---|---|---|
75 | NEUBRIDG INC SUPPLEMENTAL UNEMPLOYMENT COMP BENEFIT PLAN & T | 8,855,820 | 2,135,061 |
1 | MELLON FINANCIAL CORP SUPPLEMENTAL UNEMPLOYMENT BENEFIT TR | 48,577,968 | 0 |
58 | PIPEFITTERS SUPPLEMENTAL UNEMPLOYMENT BENEFIT TR FUND-636 | 6,304,077 | 8,573,223 |
32 | GRAPHIC PACKAGING INTERNATIONAL INC SUPP UNEMPLOYMNT BENEFITS TR | 1,626,573 | 6,164 |
6 | L-3 COMMUNICATIONS CORPORATION SUPPLEMENT UNEMPLOYMENT BEN PL | 29 | 101,149 |
71 | ILA-WEST GULF MARITIME ASSOCIATION INC ROYALTY TRUST FUND NO 1 | 26,069,719 | 29,483,018 |
45 | CATERPILLAR INC SUB TRUST 4 | 3,894,027 | 0 |
43 | CLEVELAND CLIFFS IRON CO SUB TRUST | 3 | 3,770 |
72 | BELL HELICOPTER COMPANY-UAW SUPPLEMENTAL UNEMPLOYMENT TRUST | 73,621 | 939,191 |
28 | ALUMINUM CO OF AMERICA PLAN SUB | 444 | 706,881 |
30 | UNITED STATES STEEL CORPORATION SUPPLEMENTAL UNEMPLOYMENT BENEFIT | 2,165,275 | 50,107 |
13 | SUPPLEMENTAL UNEMPLOYMENT BENEFIT PLAN FOR EMPLOYEES OF COLD SPRING | 805,055 | 1,000 |
65 | INTERNATIONAL LONGSHOREMENS ASSN S FL ILA CONTAINER ROYALTY FUND | 12,934,607 | 12,804,023 |
21 | BLDG LABORERS 310 SUB FUND | 991,829 | 1,117,093 |
57 | FORD PATTERN MAKERS LEAGUE SUPPL UNEMPLOYMENT BENEFIT PLAN | 132,299 | 2,242 |
77 | GRAMERCY ALUMINA LLC | 12,601 | 503,437 |
66 | NATIONAL CEMENT COMPANY SUPPLEMENTAL UNEMPLOYMENT BENEFIT | 0 | 11,247 |
18 | OPERATING ENGINEERS LOCAL 825 SUB FUND | 58,269,716 | 49,116,700 |
42 | MICHIGAN LIMESTONE OPERATIONS LIM PTRSHP SUPP UNEMP BENE PLAN TR | 76,666 | 134,006 |
14 | HARRIS FINANCIAL CORP BMO US SUB TR | 6,209,579 | 18,373 |
Source: NCCS IRS Business Master File August 2016