Overview of 501(c)(26)s

11.14.2018
Deondre' Jones

More from this project:

Organizations by IRS Subsection

501(c)(26) - State-Sponsored High-Risk Health Coverage Organizations (IRS)

  1. library(tidyverse)
  2. library(knitr)
  3. library(stringr)
  4. library(scales)
  5. library(httr)
  6. source('https://raw.githubusercontent.com/UrbanInstitute/urban_R_theme/master/urban_theme_windows.R')
  7.  
  8.  
  9. #Import IRS BMF
  10. bmffile <- read.csv(file = "Data/bm1608.csv")
  11. #Filter out of scope organizations 
  12. bmffile <- bmffile %>%
  13.   filter((OUTNCCS != "OUT")) %>%
  14.   filter((FNDNCD != "02" & FNDNCD!= "03" & FNDNCD != "04")) %>%
  15.   filter((SUBSECCD == "26"))
  16.  
  17.  
  18. #Sort the bmf in descending order by gross receipts
  19. #Limit the list to 10
  20. #Select the appropriate columns, drop the rest
  21. LargestGrossReceipts <- bmffile %>%
  22.   arrange(desc(INCOME)) %>%
  23.   slice(1:10) %>%
  24.   select(NAME, INCOME, ASSETS)
  25.  
  26. #Rename columns appropriately
  27. colnames(LargestGrossReceipts) <- c("Organization", "Gross Receipts", "Total Assets")
  28.  
  29. LargestAssets <- bmffile %>%
  30.   arrange(desc(ASSETS)) %>%
  31.   slice(1:10) %>%
  32.   select(NAME, INCOME, ASSETS)
  33.  
  34. #Rename columns appropriately
  35. colnames(LargestAssets) <- c("Organization", "Gross Receipts", "Total Assets")
  36.  
  37. #Generate random sample
  38. set.seed(143)
  39. random20 <- bmffile %>% 
  40.   filter(bmffile$INCOME != 0 | bmffile$ASSETS != 0) 
  41. random20 <-sample_n(random20, 20, replace = TRUE) %>%
  42.   select(NAME, INCOME, ASSETS)
  43.  
  44. 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

  1. #display tables
  2. 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

  1. #display tables
  2. 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

  1. #display tables
  2. 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