Publications by R on Redwall Analytics
Loading a large, messy csv using data.table fread with cli tools
Setup library(data.table) library(here) ## here() starts at /Users/davidlucey/Desktop/David/Projects/redwall-analytics library(glue) ## Warning: package 'glue' was built under R version 4.1.2 library(tictoc) setDTthreads(percent = 90) path_to_data <- "~/Desktop/David/Projects/uscompanies/data" path_to_original <- here::here(path_to_data, "us...
9838 sym R (8358 sym/14 pcs) 2 img
Introduction to Redwall Analytics Nutmeg Open Data Project
Introduction Redwall Analytics has spent the last couple of months gathering data from the State of Connecticut’s relatively new “open data initiative”. In recent months, we have made several posts on LinkedIn describing our explorations and looking at the some of the financial challenges faced by our home state: Quick Review of State of Co...
8553 sym
Reviewing Fairfield County Municipal Fiscal Indicators Since 2001
Introduction In recent weeks, we have been exploring the State of Connecticut’s municipal oversight infrastructure. Every year, each of the 169 towns files an audited Comprehensive Annual Report (CAFR) and the state aggregates these into the Municipal Fiscal Indicators report Municipal Fiscal Indicators – Fiscal Years Ended 2012-2017. The rep...
1461 sym
Analysis of Connecticut Tax Load by Income Bracket
Introduction This brief study finds that Connecticut residents pay $62-63 billion annually in total taxes (including: Federal, State, Municipal Real Estate, Sales, FICA, Medicare) on adjusted gross income of $165-167 billion (an effective tax rate of 37-38%). Some taxes, such as FICA and Medicare, might be considered forms of savings or insurance...
10076 sym 2 img
IRS Data Shows Growth in Number not Income of Highest Earners since 2005
Introduction In this study, Redwall Analytics looks at 12 years of adjusted gross income data from over 140 million annual tax returns across the US and compare to Connecticut returns over five income brackets. We find a few suprising trends: Despite being the highest income state, mean income of Connecticut’s Many states showed a surprising,...
8578 sym 4 img
A Through the Cycle Geo-Spatial Analysis of CT Town Finances
Introduction In an earlier post, Reviewing Fairfield County Municipal Fiscal Indicators Since 2001, we used 17 years of individual Town Comprehensive Annual Financial Reports (CAFR) aggregated in Connecticut’s Municipal Fiscal Indicator’s to compare 15 Fairfield County towns. The challenge was that the graphs became crowded even with that sma...
2228 sym
IRS Data shows Connecticut Taxpayers Also Pay Higher Federal Taxes
Introduction 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 de...
6959 sym
Connecticut City Unfunded Pension and OPEB Liabilities Over Time
Introduction – Part I Earlier this year, Reviewing Fairfield County Municipal Fiscal Indicators Since 2001 looked at data from 17 annual Connecticut Municipal Fiscal Indicators reports to better understand the current financial condition of all 169 towns. Those reports included only began including the net pension liability over the last three ...
3602 sym
Replicating Yankee Institute Risk Score Over 15 Years
Warning Signs – Part II As mentioned in part I of this series Connecticut City Unfunded Pension and OPEB Liabilities Over Time, we intend to look at the evolution of city financial vulnerability over time. The metric put forth in the Yankee report used a methodology developed by Marc Joffe of the Reason Foundation in two pieces. Mr. Joffe’s ...
7260 sym
Analyzing 500,000 Connecticut Real Estate Sales over 20 Years
Under Construction Related To leave a comment for the author, please follow the link and comment on their blog: R on Redwall Analytics. R-bloggers.com 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 o...
425 sym