Zimbabwe Social Contact Patterns
Households, Contacts, Time Use, and Participants
@kaggle.thedevastator_zimbabwe_social_contact_patterns
Households, Contacts, Time Use, and Participants
@kaggle.thedevastator_zimbabwe_social_contact_patterns
CREATE TABLE n_2017_melegaro_zimbabwe_contact_common (
"cont_id" BIGINT,
"part_id" BIGINT,
"cnt_age_exact" DOUBLE,
"cnt_age_est_min" DOUBLE,
"cnt_age_est_max" DOUBLE,
"cnt_gender" VARCHAR,
"cnt_home" VARCHAR,
"cnt_school" VARCHAR,
"cnt_work" VARCHAR,
"cnt_transport" VARCHAR,
"cnt_leisure" VARCHAR,
"cnt_otherplace" VARCHAR,
"frequency_multi" VARCHAR,
"phys_contact" DOUBLE,
"duration_multi" VARCHAR
);
CREATE TABLE n_2017_melegaro_zimbabwe_contact_extra (
"cont_id" BIGINT,
"studyday" BIGINT,
"cnt_partrel" VARCHAR
);
CREATE TABLE n_2017_melegaro_zimbabwe_hh_common (
"hh_id" VARCHAR,
"country" VARCHAR,
"hh_size" BIGINT
);
CREATE TABLE n_2017_melegaro_zimbabwe_hh_extra (
"hh_id" VARCHAR,
"hhline" BIGINT,
"hh_member_id" VARCHAR,
"study_site" BIGINT,
"hhmem_relation_ego" VARCHAR,
"hhmem_age" DOUBLE,
"hhmem_gender" VARCHAR,
"sleep_room_ego" DOUBLE,
"hh_access_to_water" DOUBLE,
"hh_toilet" DOUBLE,
"hh_shared_toilet" DOUBLE,
"hh_electricity" DOUBLE,
"hh_refridgerator" DOUBLE,
"hh_radio" DOUBLE,
"hh_television" DOUBLE,
"type_house" DOUBLE,
"type_floor" DOUBLE
);
CREATE TABLE n_2017_melegaro_zimbabwe_household_common (
"hh_id" VARCHAR,
"country" VARCHAR,
"hh_size" BIGINT
);
CREATE TABLE n_2017_melegaro_zimbabwe_household_extra (
"hh_id" VARCHAR,
"hhline" BIGINT,
"study_site" BIGINT,
"hhmem_relation_ego" VARCHAR,
"hhmem_age" DOUBLE,
"hhmem_gender" VARCHAR,
"sleep_room_ego" DOUBLE,
"hh_access_to_water" VARCHAR,
"hh_toilet" VARCHAR,
"hh_shared_toilet" VARCHAR,
"hh_electricity" VARCHAR,
"hh_refridgerator" VARCHAR,
"hh_radio" VARCHAR,
"hh_television" VARCHAR,
"type_house" VARCHAR,
"type_floor" VARCHAR
);
CREATE TABLE n_2017_melegaro_zimbabwe_participant_common (
"part_id" BIGINT,
"hh_id" VARCHAR,
"part_age" DOUBLE,
"part_gender" VARCHAR
);
CREATE TABLE n_2017_melegaro_zimbabwe_participant_extra (
"part_id" BIGINT,
"type" DOUBLE,
"study_site" BIGINT,
"part_agegrp" BIGINT,
"current_student" DOUBLE,
"current_educ_lev" DOUBLE,
"school_name" VARCHAR,
"school_village" VARCHAR,
"school_district" VARCHAR,
"distance_school" DOUBLE,
"trasp_school" DOUBLE,
"school_size" DOUBLE,
"class_size" DOUBLE,
"ever_worked" DOUBLE,
"work_sector" DOUBLE,
"work_sector_detail" VARCHAR,
"distance_work" DOUBLE,
"transp_work" DOUBLE,
"transp_work_detail" VARCHAR,
"workplace_size" DOUBLE,
"workplace_village" VARCHAR,
"workplace_district" VARCHAR,
"distance_tarred_road" DOUBLE,
"bicycle" DOUBLE,
"motorcycle" DOUBLE,
"car" DOUBLE,
"tractor" DOUBLE
);
CREATE TABLE n_2017_melegaro_zimbabwe_sday (
"part_id" BIGINT,
"sday_id" DOUBLE,
"studyday" BIGINT,
"day" DOUBLE,
"month" DOUBLE,
"year" DOUBLE,
"dayofweek" BIGINT
);
CREATE TABLE n_2017_melegaro_zimbabwe_time_use_common (
"part_id" BIGINT,
"studyday" BIGINT,
"time_use_id" VARCHAR,
"athome_0405" DOUBLE,
"atschool_0405" DOUBLE,
"atwork_0405" VARCHAR,
"atshadowplace_0405" DOUBLE,
"wvillage_0405" DOUBLE,
"wward_0405" DOUBLE,
"wdistrict_0405" DOUBLE,
"odistrict_0405" DOUBLE,
"athome_0506" DOUBLE,
"atschool_0506" DOUBLE,
"atwork_0506" DOUBLE,
"atshadowplace_0506" DOUBLE,
"wvillage_0506" DOUBLE,
"wward_0506" DOUBLE,
"wdistrict_0506" DOUBLE,
"odistrict_0506" DOUBLE,
"athome_0607" DOUBLE,
"atschool_0607" DOUBLE,
"atwork_0607" DOUBLE,
"atshadowplace_0607" DOUBLE,
"wvillage_0607" DOUBLE,
"wward_0607" DOUBLE,
"wdistrict_0607" DOUBLE,
"odistrict_0607" DOUBLE,
"athome_0710" DOUBLE,
"atschool_0710" DOUBLE,
"atwork_0710" DOUBLE,
"atshadowplace_0710" DOUBLE,
"wvillage_0710" DOUBLE,
"wward_0710" DOUBLE,
"wdistrict_0710" DOUBLE,
"odistrict_0710" DOUBLE,
"athome_1012" DOUBLE,
"atschool_1012" DOUBLE,
"atwork_1012" DOUBLE,
"atshadowplace_1012" DOUBLE,
"wvillage_1012" DOUBLE,
"wward_1012" DOUBLE,
"wdistrict_1012" DOUBLE,
"odistrict_1012" DOUBLE,
"athome_1214" DOUBLE,
"atschool_1214" DOUBLE,
"atwork_1214" DOUBLE,
"atshadowplace_1214" DOUBLE,
"wvillage_1214" DOUBLE,
"wward_1214" DOUBLE,
"wdistrict_1214" DOUBLE,
"odistrict_1214" DOUBLE,
"athome_1416" DOUBLE,
"atschool_1416" DOUBLE,
"atwork_1416" DOUBLE,
"atshadowplace_1416" DOUBLE,
"wvillage_1416" DOUBLE,
"wward_1416" DOUBLE,
"wdistrict_1416" DOUBLE,
"odistrict_1416" DOUBLE,
"athome_1617" DOUBLE,
"atschool_1617" DOUBLE,
"atwork_1617" DOUBLE,
"atshadowplace_1617" DOUBLE,
"wvillage_1617" DOUBLE,
"wward_1617" DOUBLE,
"wdistrict_1617" DOUBLE,
"odistrict_1617" DOUBLE,
"athome_1718" DOUBLE,
"atschool_1718" DOUBLE,
"atwork_1718" DOUBLE,
"atshadowplace_1718" DOUBLE,
"wvillage_1718" DOUBLE,
"wward_1718" DOUBLE,
"wdistrict_1718" DOUBLE,
"odistrict_1718" DOUBLE,
"athome_1819" DOUBLE,
"atschool_1819" DOUBLE,
"atwork_1819" DOUBLE,
"atshadowplace_1819" DOUBLE,
"wvillage_1819" DOUBLE,
"wward_1819" DOUBLE,
"wdistrict_1819" DOUBLE,
"odistrict_1819" DOUBLE,
"athome_1920" DOUBLE,
"atschool_1920" DOUBLE,
"atwork_1920" DOUBLE,
"atshadowplace_1920" DOUBLE,
"wvillage_1920" DOUBLE,
"wward_1920" DOUBLE,
"wdistrict_1920" DOUBLE,
"odistrict_1920" DOUBLE,
"athome_2000" DOUBLE,
"atschool_2000" DOUBLE,
"atwork_2000" DOUBLE,
"atshadowplace_2000" DOUBLE,
"wvillage_2000" DOUBLE,
"wward_2000" DOUBLE,
"wdistrict_2000" DOUBLE,
"odistrict_2000" DOUBLE,
"athome_0004" DOUBLE
);
Anyone who has the link will be able to view this.