Skip to content

Latest commit

 

History

History
56 lines (44 loc) · 4.76 KB

Colombia-COVID-19-official-dataset.md

File metadata and controls

56 lines (44 loc) · 4.76 KB

Colombia COVID-19 Official Dataset

This government-generated dataset (in Spanish) compiles daily data of COVID-19 confirmed cases in Colombia (South America). It provides details on confirmed cases, recoveries and deaths by city.

Update Frequency: Daily.

Dataset stats: Microsoft Excel file named according to its date of generation. It includes current and historical information starting from 03-02-2020.

  • Format: .xlsx
  • Number of columns: 17
  • Language: Spanish

Dataset Profile: Pandas-profile for the dataset. Soon to be replaced with Dataprep EDA profile.

Data Sources:


Colombia National Institute of Health (Instituto Nacional de Salud - INS)

Website Dashboard

Codebook


The data columns for the file are as follows:

ID Column (in Spanish) Column (in English) Column additional information (if applicable) Non-Null Count Dtype
0 Caso Case number 30493 non-null int64
1 Fecha Not Notification date to INS 30493 non-null object
2 Código ciudad City code City code according to the following table 30493 non-null int64
3 Departamento Department name Department is a term equivalent to Province (in Canada) or State (in the US) 30493 non-null object
4 Ciudad City name 30493 non-null object
5 Edad Age 30493 non-null int64
6 Sexo Gender 30493 non-null object
7 Tipo Case origin type -"Importado" (Imported): Individual with COVID-19 who arrived in Colombia from overseas.
-"Relacionado" (Related): Individual who got infected with COVID-19 from contact with an infected person.
-"En estudio" (Under revision).
30493 non-null object
8 Ubicación Patient location -"Casa" (Home)
-"Fallecido" (Deceased)
-"Hospital" (Hospital)
-"Hospital UCI" (Intensive care unit - ICU)
-"Recuperado" (Recovered)
-"N/A" (Non-applicable)
30448 non-null object
9 Estado Patient health status -"Asintomático" (Asymptomatic)
-"Fallecido" (Deceased)
-"Grave" (Gravely ill)
-"Leve" (Slightly ill)
-"Moderado" (Moderately ill)
30442 non-null object
10 Pais de procedencia Country of origin 30493 non-null object
11 Fecha de inicio de síntomas Symptoms start date 30490 non-null object
12 Fecha de muerte Date of death 1005 non-null object
13 Fecha de diagnóstico Date of diagnosis 30493 non-null object
14 Fecha recuperado Date of recovery 9645 non-null object
15 Fecha cargue web System upload date 30493 non-null object
16 Tipo de recuperación Recovery type -"PCR": Negative results on a second PCR test.
-"Tiempo": Asymptomatic patient after thirty days of diagnosis.

PCR: Polymerase chain reaction test
28749 non-null object

Projects:


Colombian government has created a dashboard with this dataset.

License:


Creative Commons Attribution-ShareAlike 4.0 International Public License

Authors:


National Institute of Health (Instituto Nacional de Salud - INS) - Government of Colombia