Colombia COVID-19 data

In the colombia schema, we currently have 3 tables related to this country. So far, the available data are related to the COVID-19 and stratified by departamento¹. They were provided by the Instituto Nacional de Salud². In the table below, we have a brief description of the content of each table. For each of them, we have another table named {table_name}_meta that contains an explanation of the columns in the table.

For example, in the colombia schema, we have a table called positive_cases_covid_d that represents the daily records timelines for positive cases in each departamento¹ of Colombia. The meaning of the columns of this table are explained in the positive_cases_covid_meta table.

Table name	Keys	Content	Source
positive_cases_covid_d	fecha_reporte_web	This dataset contains the individual data of positive cases in Colombia including informations as sex, age, date of first symptons, date of report, disease severity and date of death of individuals that died of the disease.	Instituto Nacional de Salud2
casos_covid_agg_m	fecha_inicio_sintomas	This dataset contains the monthly aggregation of the positive cases by the date of first symptoms considering the sex, age group, departamento, and disease severity. This dataset was created using the table positive_cases_covid_d.	Epigraphhub3
casos_covid_deaths_agg_m	fecha_muerte	This table contains the monthly aggregation of the positive cases that died, considering the sex, age group, departamento, and disease severity. This table was created using the table positive_cases_covid_d and the date of death as the index.	Epigraphhub3

departamento¹ - refers to a political division of Colombia.

Instituto Nacional de Salud² - https://www.datos.gov.co/Salud-y-Protecci-n-Social/Casos-positivos-de-COVID-19-en-Colombia/gt2j-8ykr/data

Epigraphhub³ - It means that the dataset was created by one of the epigraphhub analysts using another dataset available on the platform.