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_10_appliance_usage_study10 (
"date_time" TIMESTAMP,
"electric_power_w" DOUBLE,
"appliance_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_10_door_status_study10 (
"date_time" TIMESTAMP,
"door_status_0_closed_1_open" BIGINT,
"door_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_10_hvac_measurement_study10 (
"date_time" TIMESTAMP,
"cooling_status_0_off_1_on" BIGINT,
"hvac_zone_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_10_indoor_measurement_study10 (
"date_time" TIMESTAMP,
"indoor_temp_c" DOUBLE,
"indoor_rh" DOUBLE,
"indoor_co2_ppm" BIGINT,
"indoor_voc_ppm" BIGINT,
"indoor_air_pressure_pa" DOUBLE,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_10_occupancy_measurement_study10 (
"date_time" TIMESTAMP,
"occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_10_occupant_number_measurement_study10 (
"date_time" TIMESTAMP,
"occupant_number_measurement" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_10_static_info_study10 (
"country" VARCHAR,
"city" VARCHAR,
"building_type" VARCHAR,
"room_type" VARCHAR,
"building_id" BIGINT,
"room_id" BIGINT
);
CREATE TABLE study_10_window_status (
"date_time" TIMESTAMP,
"window_status_0_closed_1_open" BIGINT,
"window_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_11_occupancy_measurement_study11 (
"date_time" TIMESTAMP,
"occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_11_static_info_study11 (
"country" VARCHAR,
"city" VARCHAR,
"building_type" VARCHAR,
"room_type" VARCHAR,
"building_id" BIGINT,
"room_id" BIGINT
);
CREATE TABLE study_12_hvac_behavior_dict_study12 (
"col_names" VARCHAR,
"note" VARCHAR
);
CREATE TABLE study_12_hvac_behavior_study12 (
"co2_ppm" BIGINT,
"temperature_indoor_c" DOUBLE,
"relative_humidity_indoor" DOUBLE,
"temperature_outdoor_c" DOUBLE,
"relative_humidity_outdoor" DOUBLE,
"solar_radiation_w_m2" DOUBLE,
"southward_vertical_irradiance_w_m2" DOUBLE,
"class" VARCHAR,
"room_id" VARCHAR
);
CREATE TABLE study_12_shading_behavior_dict_study12 (
"col_names" VARCHAR,
"note" VARCHAR
);
CREATE TABLE study_12_shading_behavior_study12 (
"temperature_indoor_c" DOUBLE,
"relative_humidity_indoor" DOUBLE,
"indoor_illumination_lux" BIGINT,
"temperature_outdoor_c" DOUBLE,
"relative_humidity_outdoor" DOUBLE,
"solar_radiation_w_m2" DOUBLE,
"southward_vertical_irradiance_w_m2" DOUBLE,
"shading_status_last" DOUBLE,
"class" VARCHAR,
"room_id" VARCHAR
);
CREATE TABLE study_12_window_behavior_dict_study12 (
"col_names" VARCHAR,
"note" VARCHAR
);
CREATE TABLE study_12_window_behavior_study12 (
"co2_ppm" BIGINT,
"temperature_indoor_c" DOUBLE,
"relative_humidity_indoor" DOUBLE,
"temperature_outdoor_c" DOUBLE,
"relative_humidity_outdoor" DOUBLE,
"solar_radiation_w_m2" DOUBLE,
"southward_vertical_irradiance_w_m2" DOUBLE,
"class" VARCHAR,
"room_id" VARCHAR
);
CREATE TABLE study_14_occupancy_measurement_study14 (
"date_time" TIMESTAMP,
"occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_14_outdoor_measurement_study14 (
"date_time" TIMESTAMP,
"outdoor_temp_c" DOUBLE,
"outdoor_rh" DOUBLE,
"wind_speed_m_s" DOUBLE,
"wind_direction_deg" DOUBLE,
"solar_radiation_w_m2" BIGINT,
"particle_level_ug_m3" BIGINT,
"particle_type" VARCHAR,
"building_id" BIGINT
);
CREATE TABLE study_14_static_info_study14 (
"country" VARCHAR,
"city" VARCHAR,
"building_type" VARCHAR,
"room_type" VARCHAR,
"building_id" BIGINT,
"room_id" BIGINT
);
CREATE TABLE study_14_window_status_study14 (
"date_time" TIMESTAMP,
"window_status_0_closed_1_open" BIGINT,
"window_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_15_door_status_study15 (
"date_time" TIMESTAMP,
"door_status_0_closed_1_open" BIGINT,
"door_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_15_hvac_measurement_study15 (
"date_time" TIMESTAMP,
"cooling_status_0_off_1_on" BIGINT,
"hvac_zone_id" BIGINT,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_15_indoor_measurement_study14 (
"date_time" TIMESTAMP,
"indoor_temp_c" DOUBLE,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_15_indoor_measurement_study15 (
"date_time" TIMESTAMP,
"indoor_temp_c" DOUBLE,
"indoor_rh" DOUBLE,
"room_id" BIGINT,
"building_id" BIGINT
);
CREATE TABLE study_15_outdoor_measurement_study15 (
"date_time" TIMESTAMP,
"outdoor_temp_c" DOUBLE,
"outdoor_rh" DOUBLE,
"building_id" BIGINT
);
Anyone who has the link will be able to view this.