RI SBA PPP Loans

An interactive drill-down treemap allowing you to view loans under 150k by sector -> subsector -> industry group -> national industry by NAICS code. A table is provided to show all loan-level data, however those under 150k lack a business name, while those over 150k lack a specific loan ammount.

more ...

COVID Deaths Change Over Time

A quick animation with data dumps from various dates between 5/10/2020 and 6/30/2020 showing how the death toll has climbed and gradually increased the peak. Orange line shows what the 7-day moving average was on the day data was reported. Blue line shows how the 7-day moving average has increased with the updating of prior dates.

more ...

Providence 311 Firework Complaints

Like most people i've been hearing a lot of fireworks, more then usual around Warwick, even for this time of year. After seeing a few news articles mentioning how it is apparently a thing happening all across the nation. I decided to dig up my old code collecting Providence 311 reports and see what I could find regarding fireworks. The data contains every 311 report with a description containing the word "firework".

more ...

COVID-19 Deaths Then vs. Now

A look back at data leading up to the May 9th reopening. What the death totals were on May 10th compared to what they are today. Deaths back in April and May continue to climb even today half way through the month of June.

more ...

2020 Census Response Rate

Recently census.gov has begun releasing the response rate for the 2020 census. This map shows the percentage of people who responded in each city/town, as well as an option to view how many of those that responded, did so by using the internet. Future plans to update the map allowing drill down to the census-tract and census-block-group detail, but currently the very granular geographies are missing some info.

more ...

Northeast Dunkin' Maps

Date Category Map Tags dunkin

For National Donut Day I recreated my "RI Dunkin Map" for all of the Northeast states. The maps contain 1 to 5 mile buffer rings around every dunkin and layers it over the given state. This time, rather then using QGIS which is a bit of a lengthy process. I chose to automate 90% of the work with Python, the processing is done with GeoPandas and Shapely, while the mapping with Matplotlib.

more ...

COVID-19 vs. 2018 Top 15 Causes of Death

An interactive graph showing 2020 COVID-19 pandemic deaths along side the top 15 causes of death in 2018. You can select a state & which binned range you want for 2018 deaths. "Most Recent" is the most recent COVID data vs. top 5 2018 leading causes of death for that month. "Prior Full Month" rolls the COVID data back the the prior full month comparing it to the top 5 causes of death up to that given month. "2018 Full Year" compares the most recent COVID data to the leading 15 causes of death for all of 2018.

more ...

RI COVID-19 Trends

4 graphs showing the 7-day moving averages and the last 14-day trends for COVID-19 testing and hospital data in Rhode Island. Charts made with data from RIDOH revised trend sheet, created using Python matplotlib.

more ...