More from this project:
Organizations by IRS Subsection
501(c)(26) - State-Sponsored High-Risk Health Coverage Organizations (IRS)
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 == "26"))
#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 = TRUE) %>%
select(NAME, INCOME, ASSETS)
colnames(random20) <- c("Organization", "Gross Receipts", "Total Assets")
Number of organizations reporting assets or income = 10. Total Gross Receipts = $142,451,138. Total Assets = $126,477,055.
Largest 501(c)(26)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 |
---|---|---|
WASHINGTON STATE HEALTH INSURANCE POOL | 45,604,946 | 16,566,315 |
COMPREHENSIVE HEALTH INSURANCE RISK POOL ASSOCIATION | 28,861,410 | 50,051,766 |
LOUISIANA HEALTH INSURANCE ASSOC | 16,456,374 | 23,468,983 |
INDIANA COMPREHENSIVE HEALTH INSURANCE ASSOC | 16,050,293 | 14,391,117 |
COMPREHENSIVE HEALTH INSURANCE ASSOCIATION | 11,357,588 | 7,218,587 |
MISSOURI HEALTH INSURANCE POOL | 7,801,489 | 6,960,285 |
NEW HAMPSHIRE INDIVIDUAL HEALTH PLAN BENEFIT ASSOCIATION | 6,083,819 | 3,463,026 |
SOUTH CAROLINA HEALTH INSURANCE POOL | 5,959,416 | 2,035,020 |
OKLAHOMA HEALTH INSURANCE HIGH RISK POOL | 3,961,901 | 2,321,956 |
NORTH CAROLINA HEALTH INSURANCE RISK POOL | 313,902 | 0 |
Largest 501(c)(26)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 |
---|---|---|
COMPREHENSIVE HEALTH INSURANCE RISK POOL ASSOCIATION | 28,861,410 | 50,051,766 |
LOUISIANA HEALTH INSURANCE ASSOC | 16,456,374 | 23,468,983 |
WASHINGTON STATE HEALTH INSURANCE POOL | 45,604,946 | 16,566,315 |
INDIANA COMPREHENSIVE HEALTH INSURANCE ASSOC | 16,050,293 | 14,391,117 |
COMPREHENSIVE HEALTH INSURANCE ASSOCIATION | 11,357,588 | 7,218,587 |
MISSOURI HEALTH INSURANCE POOL | 7,801,489 | 6,960,285 |
NEW HAMPSHIRE INDIVIDUAL HEALTH PLAN BENEFIT ASSOCIATION | 6,083,819 | 3,463,026 |
OKLAHOMA HEALTH INSURANCE HIGH RISK POOL | 3,961,901 | 2,321,956 |
SOUTH CAROLINA HEALTH INSURANCE POOL | 5,959,416 | 2,035,020 |
NORTH CAROLINA HEALTH INSURANCE RISK POOL | 313,902 | 0 |
Random Sample of 501(c)(26)s
#display tables
kable(random20, format.args = list(decimal.mark = '.', big.mark = ","), caption = "Random Sample" )
Organization | Gross Receipts | Total Assets | |
---|---|---|---|
10 | COMPREHENSIVE HEALTH INSURANCE ASSOCIATION | 11,357,588 | 7,218,587 |
1 | NEW HAMPSHIRE INDIVIDUAL HEALTH PLAN BENEFIT ASSOCIATION | 6,083,819 | 3,463,026 |
8 | OKLAHOMA HEALTH INSURANCE HIGH RISK POOL | 3,961,901 | 2,321,956 |
5 | SOUTH CAROLINA HEALTH INSURANCE POOL | 5,959,416 | 2,035,020 |
1.1 | NEW HAMPSHIRE INDIVIDUAL HEALTH PLAN BENEFIT ASSOCIATION | 6,083,819 | 3,463,026 |
10.1 | COMPREHENSIVE HEALTH INSURANCE ASSOCIATION | 11,357,588 | 7,218,587 |
7 | LOUISIANA HEALTH INSURANCE ASSOC | 16,456,374 | 23,468,983 |
6 | COMPREHENSIVE HEALTH INSURANCE RISK POOL ASSOCIATION | 28,861,410 | 50,051,766 |
6.1 | COMPREHENSIVE HEALTH INSURANCE RISK POOL ASSOCIATION | 28,861,410 | 50,051,766 |
4 | WASHINGTON STATE HEALTH INSURANCE POOL | 45,604,946 | 16,566,315 |
5.1 | SOUTH CAROLINA HEALTH INSURANCE POOL | 5,959,416 | 2,035,020 |
2 | INDIANA COMPREHENSIVE HEALTH INSURANCE ASSOC | 16,050,293 | 14,391,117 |
10.2 | COMPREHENSIVE HEALTH INSURANCE ASSOCIATION | 11,357,588 | 7,218,587 |
4.1 | WASHINGTON STATE HEALTH INSURANCE POOL | 45,604,946 | 16,566,315 |
9 | NORTH CAROLINA HEALTH INSURANCE RISK POOL | 313,902 | 0 |
10.3 | COMPREHENSIVE HEALTH INSURANCE ASSOCIATION | 11,357,588 | 7,218,587 |
4.2 | WASHINGTON STATE HEALTH INSURANCE POOL | 45,604,946 | 16,566,315 |
3 | MISSOURI HEALTH INSURANCE POOL | 7,801,489 | 6,960,285 |
7.1 | LOUISIANA HEALTH INSURANCE ASSOC | 16,456,374 | 23,468,983 |
3.1 | MISSOURI HEALTH INSURANCE POOL | 7,801,489 | 6,960,285 |
Source: NCCS IRS Business Master File August 2016