Your submission is now in Draft mode.

Once it's ready, please submit your draft for review by our team of Community Moderators. Thank you!

Submit Essay

Once you submit your essay, you can no longer edit it.

Pending

This content now needs to be approved by community moderators.

Submitted

This essay was submitted and is waiting for review.

When will the 7-day moving average of daily confirmed COVID-19 cases first drop below 10% of a previous peak in the US?

Question

The COVID-19 pandemic is an ongoing global pandemic of coronavirus disease 2019 (COVID-19), that has spread to multiple world regions. It is caused by the SARS-CoV-2 virus, first identified in December 2019 in Wuhan, China. As of July 15, 2020, more than 13.3 million cases have been confirmed globally, 3.43 million of which in the United States.

On March 13, 2020, Trump declared a National Emergency concerning the COVID-19 outbreak in the United States.

This question resolves as the date on which the seven-day simple moving average of daily confirmed COVID-19 cases in the US, as reported by the European Centre for Disease Prevention and Control, is equal to or lower than 10% of its highest previous value. More specifically, it resolves as the date in the output of the following Python program (if/when it outputs any date):

import pandas as pd 

csv_file = pd.read_csv("https://opendata.ecdc.europa.eu/covid19/casedistribution/csv")
us_data = pd.DataFrame(csv_file[csv_file['countriesAndTerritories'] == 'United_States_of_America']).iloc[::-1]
us_data['new_cases_rolling_averages'] = us_data.iloc[:,4].rolling(window=7).mean()
maximum = us_data['new_cases_rolling_averages'].max()
index_of_maximum = us_data.loc[us_data['new_cases_rolling_averages'] == maximum].index[0]
date_of_resolution = us_data.loc[ (us_data['new_cases_rolling_averages'] <= 0.1 * maximum) & (us_data['new_cases_rolling_averages'].index <= index_of_maximum)].head(1)['dateRep']
print(date_of_resolution)

Make a Prediction

Prediction

Note: this question resolved before its original close time. All of your predictions came after the resolution, so you did not gain (or lose) any points for it.

Note: this question resolved before its original close time. You earned points up until the question resolution, but not afterwards.

Current points depend on your prediction, the community's prediction, and the result. Your total earned points are averaged over the lifetime of the question, so predict early to get as many points as possible! See the FAQ.