Searching for the number of COVID-19 cases in NYC schools in my neighborhood shouldn’t be this difficult.

In a sea of dashboards and trackers following COVID-19's path, the lack of aggregated data for schools in the state of New York led me to create my own.

Image for post
Image for post
Photo by NASA on Unsplash.
  • Charter Schools
  • Private Schools
  • BOCES Programs
  • Higher Education Institutions
  • State Universities
Image for post
Image for post
The Report Card’s summary page. Source: New York State COVID-19 Report Card.
Image for post
Image for post
Reported COVID-19 cases in Manhattan as of December 11th, 2020. An interactive map can be found at moges.io. Underlying data sourced from the New York State COVID-19 Report Card.
Underlying data sourced from the New York State COVID-19 Report Card.
Underlying data sourced from the New York State COVID-19 Report Card.

Steps to solving the data problem

First off, it should be noted that I am not a programmer by trade. As you can see from my LinkedIn profile, I have spent most of my career working in the investment management industry as a fundamental equity analyst and portfolio manager. These roles require a significant amount of time to analyze data. And while the spreadsheet has been the primary tool used by the investment community for well over 30 years, the role of Data Science and tools like Python and R are becoming a more critical part of the process.

  1. Rate defined as the number of cumulative cases since Sept.8, 2020, as a % of the total on-site and off-site school population in a given region. Underlying data sourced from the New York State COVID-19 Report Card.
  2. Source: CDC, using the change in cumulative cases between Sep. 8th and December 14th as a percent of the overall population.

Written by

Seasoned energy analyst and investor newly focused on predictive data analytics, digital innovation, digital transformation and machine learning techniques.

Get the Medium app

A button that says 'Download on the App Store', and if clicked it will lead you to the iOS App store
A button that says 'Get it on, Google Play', and if clicked it will lead you to the Google Play store