ASHRAE Global Occupant Behavior Database
Data from 32 research studies focused on occupancy interactions with spaces
@kaggle.claytonmiller_ashrae_global_occupant_behavior_database
Data from 32 research studies focused on occupancy interactions with spaces
@kaggle.claytonmiller_ashrae_global_occupant_behavior_database
CREATE TABLE study_32_static_info_study32 (
"country" VARCHAR,
"city" VARCHAR,
"building_type" VARCHAR,
"room_type" VARCHAR,
"building_id" BIGINT,
"room_id" BIGINT
);
CREATE TABLE study_32_static_info_study33 (
"country" VARCHAR,
"city" VARCHAR,
"building_type" VARCHAR,
"room_type" VARCHAR,
"building_id" BIGINT,
"room_id" BIGINT
);
CREATE TABLE study_3_dict_study3 (
"suggested_col_names" VARCHAR,
"note" VARCHAR
);
CREATE TABLE study_3_study3 (
"series_num" DOUBLE,
"date" TIMESTAMP,
"season" VARCHAR,
"building_type" VARCHAR,
"floor_num" DOUBLE,
"orientation" VARCHAR,
"time" VARCHAR,
"temperature_air_indoor_c" VARCHAR,
"temperature_globe_c" DOUBLE,
"temperature_mean_radiant_c" VARCHAR,
"temperature_operative_c" VARCHAR,
"temperature_wall_c" DOUBLE,
"relative_humidity" DOUBLE,
"air_sped_m_s" DOUBLE,
"tsv" DOUBLE,
"tpv" DOUBLE,
"data_accracy_and_removal_of_outlier" DOUBLE,
"asv" DOUBLE,
"apv" DOUBLE,
"hsv" DOUBLE,
"hpv" DOUBLE,
"overall_comfort" DOUBLE,
"temperature_outdoor_c" DOUBLE,
"relative_humidity_1" DOUBLE,
"outdoor_condition" VARCHAR,
"clothing_level" DOUBLE,
"activity_level" DOUBLE,
"exterior_door_status" DOUBLE,
"window_status" DOUBLE,
"fan_status" DOUBLE,
"pmv" DOUBLE,
"ppd" DOUBLE,
"window_operation" DOUBLE,
"door_operation" DOUBLE,
"fan_operation" DOUBLE,
"clothing_change" DOUBLE,
"posture_change" DOUBLE,
"walking_in_out" DOUBLE,
"drink_change" DOUBLE,
"evaporative_cooling_status" DOUBLE,
"temperature_outdoor_daily_mean" DOUBLE,
"temperature_outdoor_running_mean_3d" DOUBLE,
"temperature_outdoor_running_mean_7d" DOUBLE,
"temperature_outdoor_monthly_mean" DOUBLE
);
CREATE TABLE study_4_hvac_measurement (
"date_time" TIMESTAMP,
"vav_opening" DOUBLE,
"hvac_zone_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_4_indoor_measurement (
"date_time" TIMESTAMP,
"indoor_temp_c" DOUBLE,
"indoor_rh" DOUBLE,
"indoor_co2_ppm" BIGINT,
"indoor_illuminance_lux" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_4_occupant_number_measurement (
"date_time" TIMESTAMP,
"occupant_number_measurement" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_4_static_info (
"country" VARCHAR,
"city" VARCHAR,
"building_type" VARCHAR,
"room_type" VARCHAR,
"building_id" BIGINT,
"room_id" BIGINT
);
CREATE TABLE study_5_appliance_usage (
"date_time" TIMESTAMP,
"electric_power_w" DOUBLE,
"appliance_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_5_door_status (
"date_time" TIMESTAMP,
"door_status_0_closed_1_open" BIGINT,
"door_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_5_indoor_measurement (
"date_time" TIMESTAMP,
"indoor_temp_c" DOUBLE,
"indoor_illuminance_lux" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_5_outdoor_measurement (
"date_time" TIMESTAMP,
"outdoor_temp_c" DOUBLE,
"outdoor_rh" DOUBLE,
"wind_speed_m_s" DOUBLE,
"wind_direction_deg" BIGINT,
"solar_radiation_w_m2" DOUBLE,
"precipitation" DOUBLE,
"building_id" BIGINT
);
CREATE TABLE study_5_window_status (
"date_time" TIMESTAMP,
"window_status_0_closed_1_open" BIGINT,
"window_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_6_hvac_measurement (
"date_time" TIMESTAMP,
"cooling_status_0_off_1_on" BIGINT,
"hvac_zone_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_6_indoor_measurement (
"date_time" TIMESTAMP,
"indoor_temp_c" DOUBLE,
"indoor_rh" DOUBLE,
"indoor_illuminance_lux" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_6_outdoor_measurement (
"date_time" TIMESTAMP,
"outdoor_temp_c" DOUBLE,
"outdoor_rh" DOUBLE,
"solar_radiation_w_m2" DOUBLE,
"building_id" BIGINT
);
CREATE TABLE study_6_window_status (
"date_time" TIMESTAMP,
"window_status_0_closed_1_open" BIGINT,
"window_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_7_hvac_measurement (
"date_time" TIMESTAMP,
"heating_status_0_off_1_on" BIGINT,
"cooling_status_0_off_1_on" BIGINT,
"hvac_zone_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_7_indoor_measurement (
"date_time" TIMESTAMP,
"indoor_temp_c" DOUBLE,
"indoor_rh" BIGINT,
"indoor_co2_ppm" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_7_occupancy_measurement (
"date_time" TIMESTAMP,
"occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_7_outdoor_measurement (
"date_time" TIMESTAMP,
"outdoor_temp_c" DOUBLE,
"outdoor_rh" DOUBLE,
"wind_speed_m_s" DOUBLE,
"wind_direction_deg" DOUBLE,
"solar_radiation_w_m2" DOUBLE,
"precipitation" DOUBLE,
"building_id" BIGINT
);
CREATE TABLE study_7_static_info (
"country" VARCHAR,
"city" VARCHAR,
"building_type" VARCHAR,
"room_type" VARCHAR,
"building_id" BIGINT,
"room_id" BIGINT
);
CREATE TABLE study_8_door_status (
"date_time" TIMESTAMP,
"door_status_0_closed_1_open" BIGINT,
"door_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_8_indoor_measurement (
"date_time" TIMESTAMP,
"indoor_temp_c" DOUBLE,
"indoor_rh" DOUBLE,
"indoor_illuminance_lux" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_8_outdoor_measurement (
"date_time" TIMESTAMP,
"outdoor_temp_c" DOUBLE,
"outdoor_rh" DOUBLE,
"wind_speed_m_s" DOUBLE,
"wind_direction_deg" DOUBLE,
"outdoor_air_pressure_pa" DOUBLE,
"solar_radiation_w_m2" DOUBLE,
"precipitation" DOUBLE,
"building_id" BIGINT
);
Anyone who has the link will be able to view this.