Then & Now Historical Swipe Map

Explore the geographic changes each decade since the 1950's with satellite imagery data in this interactive swipe map. Pull the bar in the middle left or right to reveal the modern (2020) map and compare it with your choice of time period. There are 13 included "Quick Location" just a few interesting samples, feel free to pan and explore the map on your own.

more ...

2021Q1 - RI Political Expenditures

Following my post on 2021-Q1 campaign contributions, this post will cover the 2021-Q1 campaign expenditures. This recent quarter saw about $910,856.13 spent in 2,696 transactions across 33 different states. These include aggregate expenditure, campaign expenditure, repayment of loans and refunds of contributions.

more ...

National Donut Day - Political Spending

Since 2006, politicians in Rhode Island have had 1,633 expenditures at donut shops for a total of $76,269.09. Probably to little surprise, these are largely dominated by Dunkin'. This post will take a look at spending that revolves around donut shops, from national chains to local shops, highest single expenditure, spending by year and more. Happy National Donut Day!

more ...

2021Q1 - RI Political Contributions

Arriving a bit late on 2021-Q1 campaign finance data, which was released at the end of last month totalling $1,507,741.19 dollars received by Rhode Island statewide politicians, down from the $2,777,997.78 received during 2020-Q4. The data includes individual donations, PAC's, interest from bank accounts and loans. This first table shows a breakdown of the top 20 campaign accounts that gained the most money and the source of the funds.

more ...

RI Dunkin' Isochrone Map

Date Category Map Tags dunkin

It's been over 2 years since my reddit Distance to Nearest Dunkin' post and i've been looking for a geo related Python project. So I decided to revisit and update it to address some of the issues with my first map that people pointed out. Mainly, I tackled the "as the crow flies" issue by using isolines that show drive-time and adhere to the roadway limitations.

more ...

Governor's Office Transition

A breakdown of payroll changes in the 2 most recent quarters of the Governor's Office, during the transition from Gina Raimondo to Daniel McKee. The data is released quarterly, so this consists of data from January 2021, and April 2021. This takes a look at who left, who joined and who remained as well as pay changes between the 2 quarters.

more ...

401Gives 2021 Summary

Last week the community raised over $2,000,000 dollars for non-profits in Rhode Island through 401Gives. 401Gives is a 24-hour fundraising campaign online using the platform GiveGab. Using the leaderboard api from GiveGab I collected general information about donations and visualized the data using Tableau, sadly the records lack any datetime records, so no breakdown by hour was possible.

more ...

Simple YTD Button

This tutorial will walk you through creating a button to swap back and forth between showing the full years worth of data, and showing all years filtered to the most recent date in your dataset. This can be useful when trying to see how the current year compares with prior years when not yet occurring dates aren't included.

more ...