Our project integrates data from various environmental factors with the data from COVID-19, which makes it a great tool for decision-making related to fighting the coronavirus, the analyzes provided through Termolink will provide a wide sight of the factors that influence the spread of the virus, in addition, we seek to structure the reports in a very clear way so that anyone can understand the data, to complement the study, we provide a questionnaire for the population to answer, thus we will raise data that may prove to be influential in the contagion of COVID-19.
We chose the theme "where there's a link, there's a way" because we saw the opportunity in helping at the decision making against the coronavirus, we saw that similar actions taken by countries in different conditions can generate different results, in addition to let available to the entire population a way to visualize the data of the disease and how it has behaved in certain factors.
When talking about data analysis, the Power BI tool, Microsoft's Business Intelligence solution, was the solution that first came to mind, given that some of the team members were already familiar with the tool.
With this in mind, we have integrated the information, so that it is possible to visualize through interactive dashboards, how the disease behaves according to each environmental factor, and so, Termolink was born!
To make this link between cases of coronavirus and environmental factors, we use the data available by NASA to quantify these factors.
To complement our project, we thought of conducting a worldwide questionnaire to relate the coronavirus to socioeconomic factors and symptoms of the disease developed in certain regions.
To host both the dashboard and our form we have developed a website, facilitating access for the entire population.
When using the Power BI tool we had to use a little M language, and for the site we used HTML and Java.
We had difficulty in the programming and data storage, we do not have the necessary knowledge in this area, we would need assistance to better understand how this process works.
ARRIAGA , M. Fabiola. The temperature and regional climate effects on communitarian COVID-19 contagion in Mexico throughout phase 1. Science of the Total Environmentjournal. ScienceDirect. 19 may 2020. available in: https://www.sciencedirect.com/science/article/pii/S0048969720330771?via%3Dihub. Acess in: 31 may. 2020.
SHI, Peng et al. Impact of temperature on the dynamics of the COVID-19 outbreak in China. Science of the Total Environmentjournal. ScienceDirect. 23 apr. 2020. available in: https://www.sciencedirect.com/science/article/pii/S0048969720324074?via%3Dihub. Acess in: 31 may. 2020.
Nature. Coronavirus misinformation needs researchers to respond. 27 may 2020. available in: https://www.nature.com/articles/d41586-020-01550-y. Acess in: 31 may. 2020.
WU. Xiao et al. Exposure to air pollution and COVID-19 mortality in the United States: A nationwide cross-sectional study. MedRxiv. 07 apr. 2020. available in: https://www.medrxiv.org/content/10.1101/2020.04.05.20054502v2. Acess in: 31 may. 2020.
LA ROSA, Giuseppina et al. Coronavirus in water environments: Occurrence, persistence and concentration methods - A scoping review. Water Research. ScienceDirect. 15 jul 2020. available in: https://www.sciencedirect.com/science/article/pii/S004313542030436X. Acess in: 31 may. 2020.
Feng, Yu et al. Influence of wind and relative humidity on the social distancing effectiveness to prevent COVID-19 airborne transmission: A numerical study, Journal of Aerosol Science. ScienceDirect. sep 2020. available in: https://www.sciencedirect.com/science/article/pii/S0021850220300744?via%3Dihub. Acess in : 31 may, 2020.
JOHNS HOPKINS WHITING SCHOOL OF ENGINEERING. Confirmed cases of COVID in the U. S. GITHUB. 2020. available in:https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_US.csv. Acess in: 31 may. 2020.
JOHNS HOPKINS WHITING SCHOOL OF ENGINEERING. Deaths from COVID in the U. S. GITHUB. 2020. available in:https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_US.csv. Acess in: 31 may. 2020.