IRS Data shows Connecticut Taxpayers Also Pay Higher Federal Taxes

[This article was first published on R on Redwall Analytics, and kindly contributed to R-bloggers]. (You can report issue about the content on this page here)
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.


In this post, we will be using the same dataset as our earlier: IRS Data Shows Growth in Number not Income of Highest Earners since 2005. This dataset encompases 2.2 million rows of five brackets for each zip code from 2005-2016. Using actual tax data, we noted that despite the robust political dialogue, income inequality has been declining nationally and in Connecticut since 2007. Again, we also found a few new insights in this latest analysis:

  • Connecticut taxpayers in all brackets pay higher effective federal tax rates, which is suprising given the unlimited SALT deductions available until recently.
  • Though still highest nationally, Connecticut’s highest earners lost ground relative to the averages over the studied period, while its lowest earners gained ground, but remained close to the lowest.

Aggregate AGI Rises of Highest Earnings Group Soars Above Pre-Recession Levels

Figure 1 below shows AGI for the other 49 states (left) and for Connecticut alone (right). Note that the scale of the y-axes are not the same, but in both cases, the top bracket has made substantial gains in aggregate income relative to the other groups. However, the top group has 42% more taxpayers nationally and 22% in CT in 2016, so the increase has been driven by more taxpayers with more income and not more income per taxpayer. In addition, there are 23% fewer members of the lowest brackets both nationally and in Connecticut. Connecticut has clearly underperformed the national trends, but with the boom in global markets and the financial services industry, the late 2000’s was not a normal starting point. In the normal course of events, wage gains and inflation would be expected to push taxpayers into higher brackets, but those have been notably slow over the measured period. Although wage gains must be partly responsible for the “bracket creep”, such a significant number of taxpayers moving into the highest brackets and out of the lowest seems inconsistent with the current narrative of ever-rising inequality.

Figure 1: Adjusted Gross Income ($ Billions) for USA and Connecticut 2005-2016

AGI Per Taxpayer Declining for the Highest while Increasing for Lowest Group Since 2007

Figure 2 shows aggregate AGI divided by the number of taxpayers in each bracket. It can be seen that nationally (left) and in Connecticut, that the average income per taxpayer in the top bracket has declined steadily since 2007. In addition, the lowest brackets are still earning very small amounts, but 25-30% more than before the crisis. It is the middle income brackets which are earning exactly the same over the period, hence steadily losing to inflation both nationally and in Connecticut. Our previous analysis of the full tax load Analysis of Connecticut Tax Load by Income Bracketsuggested that the two middle brackets paid the highest percentage tax loads (counting federal and state income, real estate, sales, social security and medicare taxes). It is also notable that the top group in Connecticut has earned more than the national average for that bracket, average income levels in all other groups are exactly in sync.

Figure 2: AGI per Taxpayer for USA and Connecticut from 2005-2016

Connecticut Taxpayers Have Higher Effective Federal Tax Rates Despite SALT Deductions

Figure 3 shows that the federal tax rates for the top groups declined from 2006 through 2009 nationally, and through 2012 in Connecticut before rising again. Over the measured period, effective federal income tax rates in all brackets have been higher in Connecticut than nationally. Connecticut effective tax rates for the top bracket jumps by 2% in 2012 (unrelated to the separate 2011 state tax increases on higher incomes). In fact, the higher state income tax might have been expected to decrease the federal rate because of higher SALT deductions, but it did not.

While it is not surprising for the highest Connecticut bracket to pay ~2% higher effective rates (because the average AGI has been approximately 20% higher than the national average in that group), it is unexpected for the lower brackets where income is on par with national levels. The period measured ends in 2016 (before recent changes in the tax code), so many taxpayers should have higher deductions for Connecticut’s well known nation-leading state and local taxes (SALT) burden. However, SALT deductions would be expected to yield lower effective federal tax rates which is a surprise. in light of the new tax code, this unfortunate trend seems likely to worsen in the coming years.

Figure 3: Effective Federal Tax Rates for USA and Connecticut from 2005-2016

Connecticut’s Highest Earners Income Trails the National Average since 2007

The left chart in Figure 4 below shows the decline and recovery of AGI by CT residents compared to all other states for our five income groups. The three of the middle three brackets in CT have exactly tracked the rest of the country. The AGI of the top bracket rose to a 30% premium in the financial boom, and has subsequently fallen back to 20% above the national average. We are constrained by the available data, but it is problematic to use >$100k+ as a single bracket because it is likely dominated by a handful of extremely high earners, who “skew” the group mean above the median. Taxpayers who earn closer to $100k look very similar to the other middle income brackets (ie: flat over the period), so it is likely the contributions of the highest earners has declined more sharply than the group mean shown in the chart. There are a lot more taxpayers in this group, but some very high income taxpayers have probably changed their residencies. In IRS Data Shows Growth in Number not Income of Highest Earners since 2005, we noted that the bottom earners surprisingly were also the lowest in the country which is again shown here, although narrowing in 2007. This is a subject we plan to explore further in the future.

Figure 4: Connecticut Incomes Relative to USA by Bracket from 2005-2016

The right chart of Figure 4 above shows the relative tax paid by our income groups over time. Consistent our study of effective tax rates in Figure 3, we found that all Connecticut groups have paid higher taxes than the national average (above 1). Showing significant progressivity in federal taxes, the highest bracket (which earned between 20-30% of the national average), paid almost 50% more than the national average in 2007, but has steadily fallen back to less than it has been during the measurement period near 30%.

To leave a comment for the author, please follow the link and comment on their blog: R on Redwall Analytics. offers daily e-mail updates about R news and tutorials about learning R and many other topics. Click here if you're looking to post or find an R/data-science job.
Want to share your content on R-bloggers? click here if you have a blog, or here if you don't.

Never miss an update!
Subscribe to R-bloggers to receive
e-mails with the latest R posts.
(You will not see this message again.)

Click here to close (This popup will not appear again)