CPS COVID-19 Dashboard

PUBLISHED ON FEB 11, 2021

The Project

I started this project due to an interest in the Chicago Public Schools COVID-19 numbers and how the imminent reopening of schools to in-person learning may or may not change them. I hope that it can serve as a tool for those in Chicago (and elsewhere) interested in how COVID-19 might spread following the reopening of a large and diverse school district. There are a number of features that I plan on adding after this initial release, but as with most projects, my interest will depend largely on the interest in the community in using it.

This project is also a belated entry for the ACloud.guru Challenge run by Forrest Brazeal and the other fine folks at ACloud.guru. While this project is not at all what they had outlined (you can read that above) it certainly has the soul of an event-driven Python ETL pipeline for processing COVID-19 data.

I continue to build out this project and the site often recieves as many as 7000 viewers per day.

Technologies Used

  • HTML
  • JavaScript
    • PapaParse
    • D3.js
    • Leaflet
  • CSS
  • Route 53
  • AWS Certificate Manager
  • CloudFront
  • S3
  • CloudWatch Scheduled Events
  • Lambda
  • Python
    • Pandas
    • BeautifulSoup
    • Boto3
  • SNS
  • AWS Serverless Application Model
  • Infrastructure as Code
  • Git

Project in Production: cpscovid.com

A full blog post on the project can be found HERE (note that this post has not been updated as development continues)

Github Repo (Front-End)

Github Repo (Back-End)