Longitudinal Indoor Personal Comfort Preferences
Thermal/light/noise data captured from building occupants using smartwatches
@kaggle.claytonmiller_longitudinal_personal_thermal_comfort_preferences
Thermal/light/noise data captured from building occupants using smartwatches
@kaggle.claytonmiller_longitudinal_personal_thermal_comfort_preferences
CREATE TABLE cresh_tabular_merged (
"unnamed_0" BIGINT,
"index" BIGINT,
"time" VARCHAR,
"clothing" DOUBLE,
"comfort_cozie" DOUBLE,
"heartrate_cozie" DOUBLE,
"lat_cozie" DOUBLE,
"light_cozie" DOUBLE,
"lon_cozie" DOUBLE,
"noise_cozie" DOUBLE,
"responsespeed_cozie" DOUBLE,
"thermal_cozie" DOUBLE,
"user_id" VARCHAR,
"floor" DOUBLE,
"latitude" DOUBLE,
"longitude" DOUBLE,
"space_id" DOUBLE,
"room" DOUBLE,
"co2_sensing" DOUBLE,
"humidity_sensing" DOUBLE,
"light_sensing" DOUBLE,
"noise_sensing" DOUBLE,
"temperature_sensing" DOUBLE,
"voc_sensing" DOUBLE,
"temperature_mbient" DOUBLE
);
CREATE TABLE enth_surveys_renamed (
"user_id" VARCHAR,
"yob" BIGINT,
"sex" VARCHAR,
"height" BIGINT,
"weight" DOUBLE,
"shoulder_circumference" BIGINT,
"years_here" BIGINT,
"used_weather" VARCHAR,
"satisfaction_weather" VARCHAR,
"sweating" BIGINT,
"enjoy_ourdoor" VARCHAR,
"outdoor_hr_weekday" BIGINT,
"outdoor_hr_weekend" BIGINT,
"subtleties_awareness" BIGINT,
"overwhelemed_awareness" BIGINT,
"rich_life" BIGINT,
"rattled" BIGINT,
"deeply_moved" BIGINT,
"annoyed" BIGINT,
"violent_movies" BIGINT,
"unpleasant" BIGINT,
"changes_shake" BIGINT,
"delicates" BIGINT,
"stimuli_awareness" BIGINT,
"nervous" BIGINT,
"life_ideal" BIGINT,
"life_conditions" BIGINT,
"life_satisfaction" BIGINT,
"important_things" BIGINT,
"life_changes" BIGINT,
"extraverted" BIGINT,
"critical" BIGINT,
"dependable" BIGINT,
"anxious" BIGINT,
"new_exp" BIGINT,
"reserved" BIGINT,
"sympathetic" BIGINT,
"disorganized" BIGINT,
"calm" BIGINT,
"conventional" BIGINT
);
CREATE TABLE enth_tabular_merged (
"time" VARCHAR,
"space_id" BIGINT,
"building_name" VARCHAR,
"air_vel" DOUBLE,
"body_presence" BOOLEAN,
"change" DOUBLE,
"clothing" DOUBLE,
"comfort" DOUBLE,
"heartrate" DOUBLE,
"indoor_outdoor" DOUBLE,
"met" DOUBLE,
"response_speed" DOUBLE,
"resting_heartrate" BIGINT,
"thermal" DOUBLE,
"nb_temp" DOUBLE,
"indoor_floor" DOUBLE,
"indoor_latitude" DOUBLE,
"indoor_longitude" DOUBLE,
"skin_temp" DOUBLE,
"co2_indoor" DOUBLE,
"voc_indoor" DOUBLE,
"pm25_indoor" DOUBLE,
"noise_indoor" DOUBLE,
"n_0_3um_count_outdoor" DOUBLE,
"n_0_5um_count_outdoor" DOUBLE,
"n_1_0um_count_outdoor" DOUBLE,
"n_10_0um_count_outdoor" DOUBLE,
"n_2_5um_count_outdoor" DOUBLE,
"n_5_0um_count_outdoor" DOUBLE,
"humidity_outdoor" DOUBLE,
"pm1_0_outdoor" DOUBLE,
"pm10_0_outdoor" DOUBLE,
"pm2_5_outdoor" DOUBLE,
"pressure_outdoor" DOUBLE,
"temp_outdoor" DOUBLE,
"user_id" VARCHAR,
"temp_zone" DOUBLE,
"humidity_zone" DOUBLE
);
Anyone who has the link will be able to view this.