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)