Bolivia COVID19 Datasets
Positive/Deaths/Recovered cases in Bolivia
@kaggle.eddysan_casos_positivos_covid19_bolivia
Positive/Deaths/Recovered cases in Bolivia
@kaggle.eddysan_casos_positivos_covid19_bolivia
CREATE TABLE covid19bo_confirmed_cases_daily (
"announcementdate" TIMESTAMP,
"la_paz" BIGINT,
"cochabamba" BIGINT,
"santa_cruz" BIGINT,
"pando" BIGINT,
"beni" BIGINT,
"oruro" BIGINT,
"chuquisaca" BIGINT,
"tarija" BIGINT,
"potosi" BIGINT,
"bolivia" BIGINT,
"source" VARCHAR
);
CREATE TABLE covid19bo_confirmed_cases_daily_accumulated (
"announcementdate" TIMESTAMP,
"la_paz" BIGINT,
"cochabamba" BIGINT,
"santa_cruz" BIGINT,
"pando" BIGINT,
"beni" BIGINT,
"oruro" BIGINT,
"chuquisaca" BIGINT,
"tarija" BIGINT,
"potosi" BIGINT,
"bolivia" BIGINT
);
CREATE TABLE covid19bo_confirmed_cases_detail (
"case" BIGINT,
"announcementdate" TIMESTAMP,
"gender" VARCHAR,
"age" DOUBLE,
"nationality" VARCHAR,
"region" VARCHAR,
"subregion" VARCHAR,
"origin" VARCHAR,
"detail" VARCHAR,
"source" VARCHAR
);
CREATE TABLE covid19bo_deaths_accumulated (
"deathdate" TIMESTAMP,
"la_paz" BIGINT,
"cochabamba" BIGINT,
"santa_cruz" BIGINT,
"pando" BIGINT,
"beni" BIGINT,
"oruro" BIGINT,
"chuquisaca" BIGINT,
"tarija" BIGINT,
"potosi" BIGINT,
"bolivia" BIGINT
);
CREATE TABLE covid19bo_deaths_daily (
"deathdate" TIMESTAMP,
"la_paz" BIGINT,
"cochabamba" BIGINT,
"santa_cruz" BIGINT,
"pando" BIGINT,
"beni" BIGINT,
"oruro" BIGINT,
"chuquisaca" BIGINT,
"tarija" BIGINT,
"potosi" BIGINT,
"bolivia" BIGINT,
"source" VARCHAR
);
CREATE TABLE covid19bo_deaths_detail (
"case" BIGINT,
"deathdate" TIMESTAMP,
"region" VARCHAR,
"subregion" VARCHAR,
"gender" VARCHAR,
"age" DOUBLE,
"observation" VARCHAR,
"source" VARCHAR
);
CREATE TABLE covid19bo_decesos_detalle (
"caso" BIGINT,
"fechadeceso" TIMESTAMP,
"departamento" VARCHAR,
"municipio" VARCHAR,
"genero" VARCHAR,
"edad" DOUBLE,
"obervaciones" VARCHAR,
"fuente" VARCHAR
);
CREATE TABLE covid19bo_descartados_acumulado (
"fechadescartado" TIMESTAMP,
"beni" BIGINT,
"pando" BIGINT,
"chuquisaca" BIGINT,
"cochabamba" BIGINT,
"lapaz" BIGINT,
"oruro" BIGINT,
"potosi" BIGINT,
"tarija" BIGINT,
"santacruz" BIGINT,
"totaldia" BIGINT
);
CREATE TABLE covid19bo_discarded_accumulated (
"discardeddate" TIMESTAMP,
"santa_cruz" BIGINT,
"la_paz" BIGINT,
"cochabamba" BIGINT,
"oruro" BIGINT,
"potosi" BIGINT,
"pando" BIGINT,
"tarija" BIGINT,
"chuquisaca" BIGINT,
"beni" BIGINT,
"total_dia" BIGINT,
"source" VARCHAR
);
CREATE TABLE covid19bo_positivos_acumulado (
"fechapositivo" TIMESTAMP,
"la_paz" BIGINT,
"cochabamba" BIGINT,
"santa_cruz" BIGINT,
"pando" BIGINT,
"beni" BIGINT,
"oruro" BIGINT,
"chuquisaca" BIGINT,
"tarija" BIGINT,
"potosi" BIGINT
);
CREATE TABLE covid19bo_positivos_conteo (
"fechapositivo" TIMESTAMP,
"la_paz" BIGINT,
"cochabamba" BIGINT,
"santa_cruz" BIGINT,
"pando" BIGINT,
"beni" BIGINT,
"oruro" BIGINT,
"chuquisaca" BIGINT,
"tarija" BIGINT,
"potosi" BIGINT
);
CREATE TABLE covid19bo_positivos_detalle (
"caso" BIGINT,
"fechapositivo" TIMESTAMP,
"genero" VARCHAR,
"edad" DOUBLE,
"nacionalidad" VARCHAR,
"departamento" VARCHAR,
"provincia" VARCHAR,
"procedencia" VARCHAR,
"tipocontagio" VARCHAR,
"estadopaciente" VARCHAR,
"obervaciones" VARCHAR,
"fuente" VARCHAR
);
CREATE TABLE covid19bo_recovered_accumulated (
"recovereddate" TIMESTAMP,
"la_paz" BIGINT,
"cochabamba" BIGINT,
"santa_cruz" BIGINT,
"pando" BIGINT,
"beni" BIGINT,
"oruro" BIGINT,
"chuquisaca" BIGINT,
"tarija" BIGINT,
"potosi" BIGINT,
"bolivia" BIGINT
);
CREATE TABLE covid19bo_recovered_daily (
"recovereddate" TIMESTAMP,
"la_paz" BIGINT,
"cochabamba" BIGINT,
"santa_cruz" BIGINT,
"pando" BIGINT,
"beni" BIGINT,
"oruro" BIGINT,
"chuquisaca" BIGINT,
"tarija" BIGINT,
"potosi" BIGINT,
"bolivia" BIGINT,
"source" VARCHAR
);
CREATE TABLE covid19bo_recovered_detail (
"case" BIGINT,
"recovereddate" TIMESTAMP,
"region" VARCHAR,
"subregion" VARCHAR,
"gender" VARCHAR,
"age" DOUBLE,
"observation" VARCHAR,
"source" VARCHAR
);
CREATE TABLE covid19bo_recuperados_detalle (
"caso" BIGINT,
"fecharecuperacion" TIMESTAMP,
"departamento" VARCHAR,
"municipio" VARCHAR,
"genero" VARCHAR,
"edad" DOUBLE,
"obervaciones" VARCHAR,
"fuente" VARCHAR
);
CREATE TABLE covid19bo_sospechosos_acumulado (
"fechasospechoso" TIMESTAMP,
"lapaz" DOUBLE,
"cochabamba" VARCHAR,
"santacruz" DOUBLE,
"oruro" DOUBLE,
"pando" DOUBLE,
"potosi" DOUBLE,
"tarija" DOUBLE,
"chuquisaca" DOUBLE,
"beni" DOUBLE,
"totaldia" BIGINT
);
CREATE TABLE covid19bo_suspected_accumulated (
"suspectdate" TIMESTAMP,
"lapaz" DOUBLE,
"cochabamba" VARCHAR,
"santacruz" DOUBLE,
"oruro" DOUBLE,
"pando" DOUBLE,
"potosi" DOUBLE,
"tarija" DOUBLE,
"chuquisaca" DOUBLE,
"beni" DOUBLE,
"totaldia" BIGINT
);
CREATE TABLE cronologia_covid19_bolivia_decesos (
"nro" BIGINT,
"fecha_deceso" TIMESTAMP,
"departamento" VARCHAR,
"municipio" VARCHAR,
"genero" VARCHAR,
"edad" DOUBLE,
"observaciones" VARCHAR,
"fuente" VARCHAR
);
CREATE TABLE cronologia_covid19_bolivia_positivos (
"casos" BIGINT,
"fecha" TIMESTAMP,
"genero" VARCHAR,
"edad" DOUBLE,
"nacionalidad" VARCHAR,
"departamento" VARCHAR,
"provincia" VARCHAR,
"procedencia" VARCHAR,
"tipo_contagio" VARCHAR,
"situacion_actual" VARCHAR,
"observaciones" VARCHAR,
"unnamed_11" VARCHAR
);
CREATE TABLE geografico_covid19_elalto (
"caso" BIGINT,
"distrito" BIGINT,
"sector" VARCHAR,
"genero" VARCHAR,
"fallecidos" DOUBLE,
"observaciones" VARCHAR,
"fuente" VARCHAR
);
CREATE TABLE geografico_covid19_lapaz (
"casos" BIGINT,
"macrodistrito" VARCHAR,
"distrito" BIGINT,
"estado" VARCHAR,
"zona" VARCHAR,
"fuente" VARCHAR
);
CREATE TABLE hospitales_covid19_lapaz (
"nro" BIGINT,
"hospital" VARCHAR,
"lugar" VARCHAR,
"fuente" VARCHAR
);
Anyone who has the link will be able to view this.