Care Economy In Colombia
Regional analysis from the framework of the family life cycle
@kaggle.darwingalvis_care_economy_in_colombia
Regional analysis from the framework of the family life cycle
@kaggle.darwingalvis_care_economy_in_colombia
This dataset contains data from the National Time Use Survey (ENUT) conducted in Colombia for the period 2012-2013. It focuses on the analysis of time allocation to different care activities in the Colombian population. The dataset includes variables related to caregiving, both direct and indirect, and covers various regions of Colombia. This dataset is valuable for studying the care economy and understanding the distribution of time dedicated to different care-related tasks. It was compiled as part of an economics research project conducted at the University of Pamplona. The dataset is publicly available and can be used to explore patterns and trends in care-related activities in Colombia.
This survey is divided into nine chapters; however, to analyze caregiving activities in the economy, only four chapters are needed, namely: chapters B, D, E, and I. In this regard, the chapters have the following characteristics:
For more detailed information on the variables used in each chapter, please refer to the respective descriptions of each by clicking on their names.
CREATE TABLE chapter_b (
"directorio" BIGINT,
"fex_c" DOUBLE,
"region" BIGINT,
"dia_referencia_2" BIGINT,
"clase" BIGINT,
"p424" BIGINT,
"p4030s1" BIGINT,
"p4030s1a1" DOUBLE,
"p4030s5" BIGINT,
"p4030s3" BIGINT,
"p4030s4" BIGINT,
"p4030s4a1" DOUBLE,
"p4030s2" BIGINT,
"p4020" BIGINT
);CREATE TABLE chapter_d (
"directorio" BIGINT,
"secuencia_p" BIGINT,
"orden" BIGINT,
"p6040" BIGINT,
"p6020" BIGINT,
"p425" BIGINT,
"p1174" DOUBLE,
"p1174s1" DOUBLE,
"p1174s1a1" DOUBLE,
"p1174s2" DOUBLE,
"p1174s2a1" DOUBLE,
"p1174s3" DOUBLE,
"p1174s3a1" DOUBLE,
"p1173" BIGINT,
"p426" DOUBLE,
"p1172" DOUBLE,
"p1172s1" DOUBLE,
"p5762" BIGINT,
"p5762s2" DOUBLE,
"p5754" BIGINT,
"p5754s2" DOUBLE
);CREATE TABLE chapter_e (
"directorio" BIGINT,
"secuencia_p" BIGINT,
"orden" BIGINT,
"p6090" BIGINT,
"p6100" DOUBLE,
"p1171" BIGINT,
"p1170s1" BIGINT,
"p1170s2" BIGINT,
"p1170s3" BIGINT,
"p1170s4" BIGINT,
"p1170s5" BIGINT,
"p1170s6" BIGINT,
"p1170s7" BIGINT,
"p1170s8" BIGINT,
"p1170s9" BIGINT,
"p1169s1" BIGINT,
"p1169s2" BIGINT,
"p1169s3" BIGINT,
"p1169s4" BIGINT,
"p1169s5" BIGINT,
"p1169s6" BIGINT,
"p1169s7" BIGINT,
"p1169s8" BIGINT,
"p1168" DOUBLE,
"p1167s1" DOUBLE,
"p1167s1a1" DOUBLE,
"p1167s1a4" DOUBLE,
"p1167s1a2" DOUBLE,
"p1167s1a5" DOUBLE,
"p1167s1a3" DOUBLE,
"p1167s1a6" DOUBLE,
"p1167s2" DOUBLE,
"p1167s2a1" DOUBLE,
"p1167s2a2" DOUBLE,
"p1167s3" DOUBLE,
"p1167s3a1" DOUBLE,
"p1167s3a2" DOUBLE,
"p1167s4" DOUBLE,
"p1167s5" DOUBLE,
"p1166" BIGINT,
"p1166s1" VARCHAR,
"p1166s1a1" DOUBLE,
"p1166s1a2" DOUBLE,
"p1166s2" VARCHAR,
"p1166s2a1" DOUBLE,
"p1166s2a2" DOUBLE
);CREATE TABLE chapter_i (
"directorio" BIGINT,
"secuencia_p" BIGINT,
"orden" BIGINT,
"p1144s1" DOUBLE,
"p1144s1a1" DOUBLE,
"p1144s1a2" DOUBLE,
"p1144s2" DOUBLE,
"p1144s2a1" DOUBLE,
"p1144s2a2" DOUBLE,
"p1144s3" DOUBLE,
"p1144s3a1" DOUBLE,
"p1144s3a2" DOUBLE,
"p1144s4" DOUBLE,
"p1144s4a1" DOUBLE,
"p1144s4a2" DOUBLE,
"p1144s5" DOUBLE,
"p1144s5a1" DOUBLE,
"p1144s5a2" DOUBLE,
"p1143s1" DOUBLE,
"p1143s1a1" DOUBLE,
"p1143s1a2" DOUBLE,
"p1143s2" DOUBLE,
"p1143s2a1" DOUBLE,
"p1143s2a2" DOUBLE,
"p1143s3" DOUBLE,
"p1143s3a1" DOUBLE,
"p1143s3a2" DOUBLE,
"p1143s4" DOUBLE,
"p1142s1" DOUBLE,
"p1142s1a1" DOUBLE,
"p1142s1a2" DOUBLE,
"p1142s2" DOUBLE,
"p1142s2a1" DOUBLE,
"p1142s2a2" DOUBLE,
"p1142s3" DOUBLE,
"p1142s3a1" DOUBLE,
"p1142s3a2" DOUBLE,
"p1142s4" DOUBLE,
"p1142s4a1" DOUBLE,
"p1142s4a2" DOUBLE,
"p1142s5" DOUBLE,
"p1136s1" DOUBLE,
"p1136s1a1" DOUBLE,
"p1136s1a2" DOUBLE,
"p1136s2" DOUBLE,
"p1136s2a1" DOUBLE,
"p1136s2a2" DOUBLE,
"p1136s3" DOUBLE,
"p1136s3a1" DOUBLE,
"p1136s3a2" DOUBLE,
"p1136s4" DOUBLE,
"p1136s4a1" DOUBLE,
"p1136s4a2" DOUBLE,
"p1136s5" DOUBLE,
"p1141s1" DOUBLE,
"p1141s1a1" DOUBLE,
"p1141s1a2" DOUBLE,
"p1141s2" DOUBLE,
"p1141s2a1" DOUBLE,
"p1141s2a2" DOUBLE,
"p1141s3" DOUBLE,
"p1141s3a1" DOUBLE,
"p1141s3a2" DOUBLE,
"p1141s4" DOUBLE,
"p1141s4a1" DOUBLE,
"p1141s4a2" DOUBLE,
"p1141s5" DOUBLE,
"p1140s1" DOUBLE,
"p1140s1a1" DOUBLE,
"p1140s1a2" DOUBLE,
"p1140s2" DOUBLE,
"p1140s2a1" DOUBLE,
"p1140s2a2" DOUBLE,
"p1140s3" DOUBLE,
"p1140s3a1" DOUBLE,
"p1140s3a2" DOUBLE,
"p1140s4" DOUBLE,
"p1140s4a1" DOUBLE,
"p1140s4a2" DOUBLE,
"p1140s5" DOUBLE,
"p1140s5a1" DOUBLE,
"p1140s5a2" DOUBLE,
"p1140s6" DOUBLE,
"p1140s6a1" DOUBLE,
"p1140s6a2" DOUBLE,
"p1140s7" DOUBLE,
"p1140s7a1" DOUBLE,
"p1140s7a2" DOUBLE,
"p1140s8" DOUBLE,
"p1139s1" DOUBLE,
"p1139s1a1" DOUBLE,
"p1139s1a2" DOUBLE,
"p1139s1a3" DOUBLE,
"p1139s2" DOUBLE,
"p1139s2a1" DOUBLE,
"p1139s2a2" DOUBLE,
"p1139s2a3" DOUBLE,
"p1139s3" DOUBLE,
"p1139s3a1" DOUBLE,
"p1139s3a2" DOUBLE
);Anyone who has the link will be able to view this.