French Social Contact Data
A Study of 1755 Participants and their Household Contacts (2015)
@kaggle.thedevastator_french_social_contact_data
A Study of 1755 Participants and their Household Contacts (2015)
@kaggle.thedevastator_french_social_contact_data
CREATE TABLE n_2015_beraud_france_contact_common (
"part_id" BIGINT,
"cont_id" VARCHAR,
"cnt_age_exact" DOUBLE,
"cnt_age_est_min" DOUBLE,
"cnt_age_est_max" DOUBLE,
"cnt_gender" VARCHAR,
"cnt_home" VARCHAR,
"cnt_work" BOOLEAN,
"cnt_school" BOOLEAN,
"cnt_transport" BOOLEAN,
"cnt_leisure" BOOLEAN,
"cnt_otherplace" BOOLEAN,
"frequency_multi" DOUBLE,
"phys_contact" DOUBLE,
"duration_multi" DOUBLE
);
CREATE TABLE n_2015_beraud_france_contact_extra (
"cont_id" VARCHAR,
"wave" BIGINT,
"studyday" BIGINT
);
CREATE TABLE n_2015_beraud_france_hh_common (
"hh_id" VARCHAR,
"country" VARCHAR,
"hh_size" BIGINT
);
CREATE TABLE n_2015_beraud_france_hh_extra (
"hh_id" VARCHAR,
"hh_age_1" BIGINT,
"hh_age_2" BIGINT,
"hh_age_3" BIGINT,
"hh_age_4" BIGINT,
"hh_age_5" BIGINT,
"hh_age_6" VARCHAR,
"hh_age_7" VARCHAR,
"hh_age_8" VARCHAR,
"hh_age_9" VARCHAR,
"hh_age_10" VARCHAR
);
CREATE TABLE n_2015_beraud_france_participant_common (
"part_id" BIGINT,
"hh_id" VARCHAR,
"part_age" BIGINT,
"part_gender" VARCHAR
);
CREATE TABLE n_2015_beraud_france_participant_extra (
"part_id" BIGINT,
"wave_part_id" BIGINT,
"wave" BIGINT,
"questionnaire_type" BIGINT,
"childrespondentlink" DOUBLE,
"childrespondentage" DOUBLE,
"childrespondentgender" DOUBLE,
"transportmodeweek1" BIGINT,
"transportmodeweek2" BIGINT,
"transportmodeweek3" BIGINT,
"transportmodeweekend1" BIGINT,
"transportmodeweekend2" BIGINT,
"transportmodeweekend3" BIGINT,
"zip" BIGINT,
"participant_education" DOUBLE,
"participant_occupation" DOUBLE,
"participant_occ_detail" DOUBLE,
"enfscolarise" DOUBLE,
"enfgardemaison" DOUBLE,
"enfgardenounou" DOUBLE,
"enfnbenfnounou" DOUBLE,
"enfnounouscolarise" DOUBLE,
"enfcreche" DOUBLE,
"enfnbenfcreche" DOUBLE,
"enffreqgarderie" DOUBLE,
"class_size" DOUBLE,
"enfcantine" DOUBLE,
"enfcentreaere" DOUBLE,
"enfcentreaereecole" DOUBLE,
"enfcentreaerevacance" DOUBLE,
"work_contacts" DOUBLE,
"more20contactpro" DOUBLE,
"work_contacts_nr" DOUBLE,
"agecontactpro1" BIGINT,
"agecontactpro2" BIGINT,
"agecontactpro3" BIGINT,
"agecontactpro4" BIGINT,
"agecontactpro5" BIGINT,
"nbstudentclassroom" DOUBLE,
"studentcantina" DOUBLE,
"commonparticip" BIGINT
);
CREATE TABLE n_2015_beraud_france_sday (
"part_id" BIGINT,
"sday_id" BIGINT,
"wave" BIGINT,
"studyday" BIGINT,
"day" BIGINT,
"month" BIGINT,
"year" BIGINT,
"dayofweek" DOUBLE,
"holiday" BIGINT
);
Anyone who has the link will be able to view this.