Name: ASHRAE Global Occupant Behavior Database
Creator: Kaggle
License: https://opendatacommons.org/licenses/by/1-0/index.html

About this Dataset

ASHRAE Global Occupant Behavior Database

Dataset and documentation: https://ashraeobdatabase.com

Context

The ASHRAE Global Occupant Behavior Database was developed by Wei Mu, Yapan Liu and Bing Dong (Syracuse University), Tianzhen Hong (LBNL), Bjarne W. Olesen (Technical University of Denmark), Tom Lawrence (University of Georgia) and Zheng O’Neill (Texas A&M University) as part of the ASHRAE MTG.OBB research grant URP-1883.

Content

Study_ID	Behavior_Type	Publication
1	Door_Status	Korsavi, S. S., Montazami, A., & Brusey, J. (2018). Developing a design framework to facilitate adaptive behaviours. Energy and Buildings, 179, 360-373. https://doi.org/10.1016/j.enbuild.2018.09.011
	Fan_Status
	Occupant_Number
	Occupancy
	Shading_Status
	Window_Status
2	Appliance_Usage	Rafsanjani, H. N., Ahn, C. R., & Chen, J. (2018). Linking building energy consumption with occupants' energy-consuming behaviors in commercial buildings: Non-intrusive occupant load monitoring (NIOLM). Energy and Buildings, 172, 317-327. https://doi.org/10.1016/j.enbuild.2018.05.007
3	Door_Status	Kumar, S., Singh, M. K., Kukreja, R., Chaurasiya, S. K., & Gupta, V. K. (2019). Comparative study of thermal comfort and adaptive actions for modern and traditional multi-storey naturally ventilated hostel buildings during monsoon season in India. Journal of Building Engineering, 23, 90-106. https://doi.org/10.1016/j.jobe.2019.01.020
	Fan_Status
	Window_Status
4	HVAC_Measurement	Schwee, J. H., Johansen, A., Jørgensen, B. N., Kjærgaard, M. B., Mattera, C. G., Sangogboye, F. C., & Veje, C. (2019). Room-level occupant counts and environmental quality from heterogeneous sensing modalities in a smart building. Scientific data, 6(1), 1-11. https://doi.org/10.1038/s41597-019-0274-4
	Occupant_Number
5	Appliance_Usage	Piselli, C., & Pisello, A. L. (2019). Occupant behavior long-term continuous monitoring integrated to prediction models: Impact on office building energy performance. Energy, 176, 667-681. https://doi.org/10.1016/j.energy.2019.04.005
	Door_Status
	Window_Status
8	Door_Status	Touchie, M. F., & Pressnail, K. D. (2014). Using suite energy-use and interior condition data to improve energy modeling of a 1960s MURB. Energy and buildings, 80, 184-194. http://doi.org/10.1016/j.enbuild.2014.05.014
	Window_Status
9	Lighting_Status	Bursill, J. (2020). An Approach to Data-Driven Sensing and Predictive Supervisory Control for Commercial Buildings with In-Situ Evaluation (Doctoral dissertation, Carleton University). https://doi.org/10.22215/etd/2020-14103
	Occupancy
10	Appliance_Usage	Mora, D., Fajilla, G., Austin, M. C., & De Simone, M. (2019). Occupancy patterns obtained by heuristic approaches: cluster analysis and logical flowcharts. A case study in a university office. Energy and Buildings, 186, 147-168. https://doi.org/10.1016/j.enbuild.2019.01.023
	Door_Status
	HVAC_Measurement
	Occupancy
	Occupant_Number
	Window_Status
11	Occupancy	Dong, B., Li, Z., & Mcfadden, G. (2015). An investigation on energy-related occupancy behavior for low-income residential buildings. Science and Technology for the Built Environment, 21(6), 892-901. http://doi.org/10.1080/23744731.2015.1040321
13	HVAC_Measurement	Bandurski, K., Hamerla, M., Szulc, J., & Koczyk, H. (2017). The influence of multifamily apartment building occupants on energy and water consumption-the preliminary results of monitoring and survey campaign. In E3S Web of Conferences (Vol. 22, p. 00010). EDP Sciences. https://doi.org/10.1051/e3sconf/20172200010
18	Appliance_Usage	Das, A., Annaqeeb, M. K., Azar, E., Novakovic, V., & Kjærgaard, M. B. (2020). Occupant-centric miscellaneous electric loads prediction in buildings using state-of-the-art deep learning methods. Applied Energy, 269, 115135. https://doi.org/10.1016/j.apenergy.2020.115135
	Occupancy
19	Fan_Status	Lipczynska, A., Schiavon, S., & Graham, L. T. (2018). Thermal comfort and self-reported productivity in an office with ceiling fans in the tropics. Building and Environment, 135, 202-212. https://doi.org/10.1016/j.buildenv.2018.03.013
	HVAC_Measurement
	Window_Status
20	Appliance_Usage	Mahdavi, A., Berger, C., Tahmasebi, F., & Schuss, M. (2019). Monitored data on occupants' presence and actions in an office building. Scientific data, 6(1), 1-5. https://doi.org/10.1038/s41597-019-0271-7
22	Appliance_Usage	Sonta, A., Dougherty, T. R., & Jain, R. K. (2021). Data-driven optimization of building layouts for energy efficiency. Energy and Buildings, 238, 110815. https://doi.org/10.1016/j.enbuild.2021.110815
23	HVAC_Measurement	Neves, L. O., Hopes, A. P., Chung, W. J., & Natarajan, S. (2020). "Mind reading" building operation behaviour. Energy for Sustainable Development, 56, 1-18. https://doi.org/10.1016/j.esd.2020.02.003
	Window_Status
24	Occupancy	Schweiker, M., Kleber, M., & Wagner, A. (2019). Long-term monitoring data from a naturally ventilated office building. Scientific data, 6(1), 1-6. https://doi.org/10.1038/s41597-019-0283-3
	Window_Status
25	HVAC_Measurement	Rupp, Ricardo Forgiarini; Andersen, R.K.; Toftum, J.; Ghisi, E. (2021). Occupant behaviour in mixed-mode office buildings in a subtropical climate: Beyond typical models of adaptive actions https://doi.org/10.1016/j.buildenv.2020.107541
26	Door_Status	Langevin, J. (2019). Longitudinal dataset of human-building interactions in US offices. Scientific data, 6(1), 1-10. https://doi.org/10.1038/s41597-019-0273-5
	Fan_Status
	HVAC_Measurement
	Shading_Status
	Window_Status
27	Other_HeatWave	Andrews, Clinton & Mainelis, Gediminas & (co-Pi, Richard & Sorensen Allacci, Maryann & Plotnik, Deborah & Senick, Jennifer & Feygina, Irina & Autote, Olga & Ramkumar, Swetha & Pryce, Tiffany & Marathe, Rewa & Ding, Jiayi. (2013). Expanding the Definition of Green - Impacts of Green and Active Living Design on Health in Low Income Housing: Added Value of Behavioral Interventions as part of an Integrated Service Delivery Model.
28	Other_Role of habits in consumption	Andrews, Clinton & Mainelis, Gediminas & (co-Pi, Richard & Sorensen Allacci, Maryann & Plotnik, Deborah & Senick, Jennifer & Feygina, Irina & Autote, Olga & Ramkumar, Swetha & Pryce, Tiffany & Marathe, Rewa & Ding, Jiayi. (2013). Expanding the Definition of Green - Impacts of Green and Active Living Design on Health in Low Income Housing: Added Value of Behavioral Interventions as part of an Integrated Service Delivery Model.
29	Other_IAQ in Affordable Housing	Andrews, Clinton & Mainelis, Gediminas & (co-Pi, Richard & Sorensen Allacci, Maryann & Plotnik, Deborah & Senick, Jennifer & Feygina, Irina & Autote, Olga & Ramkumar, Swetha & Pryce, Tiffany & Marathe, Rewa & Ding, Jiayi. (2013). Expanding the Definition of Green - Impacts of Green and Active Living Design on Health in Low Income Housing: Added Value of Behavioral Interventions as part of an Integrated Service Delivery Model.
30	Occupancy	Park, J. Y., Dougherty, T., Fritz, H., & Nagy, Z. (2019). LightLearn: An adaptive and occupant centered controller for lighting based on reinforcement learning. Building and Environment, 147, 397-414. https://doi.org/10.1016/j.buildenv.2018.10.028
	Lighting_Status
31	Door_Status	Malik, J., Bardhan, R., Hong, T., & Piette, M. A. (2020). Contextualising adaptive comfort behaviour within low-income housing of Mumbai, India. Building and Environment, 177, 106877. https://doi.org/10.1016/j.buildenv.2020.106877
	Fan_Status
	HVAC_Measurement
	Light_Status
	Window_Status
32	Occupant_Number	Wang, Z., Hong, T., Piette, M. A., & Pritoni, M. (2019). Inferring occupant counts from Wi-Fi data in buildings through machine learning. Building and Environment, 158, 281-294. https://doi.org/10.1016/j.buildenv.2019.05.015

License:

This ASHRAE Global Occupant Behavior Database is made available under the Open Database License: http://opendatacommons.org/licenses/odbl/1.0/. Any rights in individual contents of the database are licensed under the Database Contents License: http://opendatacommons.org/licenses/dbcl/1.0/.

Acknowledgments:

The authors wish to acknowledge the generous contributions made by all dataset contributors. If you intend to use the research data contained in this database, please ensure that you give appropriate acknowledgment (e.g. citation) to the original researchers. We would also like to acknowledge the sponsorship from ASHRAE, Building Technologies Office of the U.S. Department of Energy, and kind support from IEA Annex 79 to make this possible.

Tables

Study 15 Window Status Study15

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_15_window_status_study15

12.61 MB
3,941,137 rows
5 columns

CREATE TABLE study_15_window_status_study15 (
  "date_time" TIMESTAMP,
  "window_status_0_closed_1_open" DOUBLE  -- Window Status[0-Closed;1-Open],
  "window_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 16 Hvac Measurement Study16

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_16_hvac_measurement_study16

610.22 kB
134,299 rows
6 columns

CREATE TABLE study_16_hvac_measurement_study16 (
  "date_time" VARCHAR,
  "heating_status_0_off_1_on" BIGINT  -- Heating Status[0-OFF;1-ON],
  "supply_air_temp_c" DOUBLE  -- Supply Air Temp[C],
  "hvac_zone_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 16 Indoor Measurement Study16

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_16_indoor_measurement_study16

783.5 kB
134,299 rows
5 columns

CREATE TABLE study_16_indoor_measurement_study16 (
  "date_time" VARCHAR,
  "indoor_temp_c" DOUBLE  -- Indoor Temp[C],
  "indoor_rh" DOUBLE  -- Indoor RH[%],
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 16 Outdoor Measurement Study16

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_16_outdoor_measurement_study16

961.6 kB
134,299 rows
4 columns

CREATE TABLE study_16_outdoor_measurement_study16 (
  "date_time" VARCHAR,
  "outdoor_temp_c" DOUBLE  -- Outdoor Temp[C],
  "outdoor_rh" DOUBLE  -- Outdoor RH[%],
  "building_id" BIGINT
);

Study 16 Window Status Study16

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_16_window_status_study16

552.86 kB
134,299 rows
5 columns

CREATE TABLE study_16_window_status_study16 (
  "date_time" VARCHAR,
  "window_status_0_closed_1_open" BIGINT  -- Window Status[0-Closed;1-Open],
  "window_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 17 Door Status Study17

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_17_door_status_study17

456.06 kB
49,331 rows
5 columns

CREATE TABLE study_17_door_status_study17 (
  "date_time" TIMESTAMP,
  "door_status_0_closed_1_open" BIGINT  -- Door Status[0-Closed;1-Open],
  "door_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 17 Hvac Measurement Study17

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_17_hvac_measurement_study17

454.71 kB
49,331 rows
6 columns

CREATE TABLE study_17_hvac_measurement_study17 (
  "date_time" TIMESTAMP,
  "heating_status_0_off_1_on" BIGINT  -- Heating Status[0-OFF;1-ON],
  "cooling_status_0_off_1_on" BIGINT  -- Cooling Status[0-OFF;1-ON],
  "hvac_zone_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 17 Indoor Measurement Study17

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_17_indoor_measurement_study17

559.08 kB
49,331 rows
5 columns

CREATE TABLE study_17_indoor_measurement_study17 (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE  -- Indoor Temp[C],
  "indoor_rh" DOUBLE  -- Indoor RH[%],
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 17 Occupant Number Measurement Study17

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_17_occupant_number_measurement_study17

456.57 kB
49,331 rows
6 columns

CREATE TABLE study_17_occupant_number_measurement_study17 (
  "date_time" TIMESTAMP,
  "occupant_number_measurement" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT,
  "unnamed_4" VARCHAR  -- Unnamed: 4,
  "unnamed_5" VARCHAR  -- Unnamed: 5
);

Study 17 Outdoor Measurement Study17

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_17_outdoor_measurement_study17

470.55 kB
49,331 rows
5 columns

CREATE TABLE study_17_outdoor_measurement_study17 (
  "date_time" TIMESTAMP,
  "outdoor_temp_c" DOUBLE  -- Outdoor Temp[C],
  "outdoor_rh" BIGINT  -- Outdoor RH[%],
  "building_id" BIGINT,
  "room_id" BIGINT
);

Study 17 Static Info Study17

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_17_static_info_study17

4.61 kB
1 row
6 columns

CREATE TABLE study_17_static_info_study17 (
  "country" VARCHAR,
  "city" VARCHAR,
  "building_type" VARCHAR,
  "room_type" VARCHAR,
  "building_id" BIGINT,
  "room_id" BIGINT
);

Study 18 Appliance Usage Study18

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_18_appliance_usage_study18

1.83 MB
961,920 rows
6 columns

CREATE TABLE study_18_appliance_usage_study18 (
  "date_time" TIMESTAMP,
  "electric_power_w" DOUBLE  -- Electric Power[w],
  "appliance_id" BIGINT,
  "desk_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 18 Indoor Measurement Study18

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_18_indoor_measurement_study18

227.19 kB
16,032 rows
6 columns

CREATE TABLE study_18_indoor_measurement_study18 (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE  -- Indoor Temp[C],
  "indoor_rh" DOUBLE  -- Indoor RH[%],
  "indoor_illuminance_lux_ft2" DOUBLE  -- Indoor Illuminance[LUX/ft2],
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 18 Occupancy Measurement Study18

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_18_occupancy_measurement_study18

429.34 kB
176,352 rows
5 columns

CREATE TABLE study_18_occupancy_measurement_study18 (
  "date_time" TIMESTAMP,
  "occupancy_measurement_0_unoccupied_1_occupied" BIGINT  -- Occupancy Measurement[0-Unoccupied;1-Occupied],
  "desk_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 18 Static Info Study18

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_18_static_info_study18

4.72 kB
1 row
6 columns

CREATE TABLE study_18_static_info_study18 (
  "country" VARCHAR,
  "city" VARCHAR,
  "building_type" VARCHAR,
  "room_type" VARCHAR,
  "building_id" BIGINT,
  "room_id" BIGINT
);

Study 19 General Info Study19

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_19_general_info_study19

23.74 kB
999 rows
32 columns

CREATE TABLE study_19_general_info_study19 (
  "id" DOUBLE,
  "age" DOUBLE,
  "height" DOUBLE,
  "weight" DOUBLE,
  "bmi" DOUBLE,
  "ethnic" VARCHAR,
  "sex" VARCHAR,
  "months_tropic" DOUBLE,
  "exercise_daily" DOUBLE,
  "bedroom_ac" VARCHAR,
  "bedroom_window" VARCHAR,
  "bedroom_deskfan" VARCHAR,
  "bedroom_ceilingfan" VARCHAR,
  "bedroom_standfan" VARCHAR,
  "bedroom_other" VARCHAR,
  "living_ac" VARCHAR,
  "living_window" VARCHAR,
  "living_deskfan" VARCHAR,
  "living_ceilingfan" VARCHAR,
  "living_standfan" VARCHAR,
  "living_other" VARCHAR,
  "work_ac" VARCHAR,
  "work_window" VARCHAR,
  "work_deskfan" VARCHAR,
  "work_ceilingfan" VARCHAR,
  "work_standfan" VARCHAR,
  "work_other" VARCHAR,
  "q8_are_there_any_other_aspects_of_your_general_health__c683eba0" VARCHAR  -- Q8 - Are There Any Other Aspects Of Your General Health Which May Affect Your Se...,
  "q8_1_text_yes" VARCHAR  -- Q8–1 TEXT - Yes,
  "q9_1_non_sensitive_very_sensitive" DOUBLE  -- Q9–1 - Non Sensitive:Very Sensitive,
  "q10_how_much_do_you_usually_perspire_sweat" VARCHAR  -- Q10 - How Much Do You Usually Perspire (sweat)? *,
  "q11_if_you_are_warm_do_you_prefer_to_cool_you_down_with" VARCHAR  -- Q11 - If You Are Warm, Do You Prefer To Cool You Down With ... ? *
);

Study 19 Survey Study19

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_19_survey_study19

30.42 kB
1,048,575 rows
16 columns

CREATE TABLE study_19_survey_study19 (
  "date_time" TIMESTAMP,
  "study_condition" VARCHAR,
  "day_time" DOUBLE,
  "id" DOUBLE,
  "temperature_air_c" DOUBLE  -- Temperature Air [C],
  "relative_humidity" DOUBLE  -- Relative Humidity [%],
  "temperature_operative_c" DOUBLE  -- Temperature Operative [C],
  "fan_setpoint" DOUBLE,
  "thermal_sensation" DOUBLE,
  "thermal_sensation_acceptability" DOUBLE,
  "thermal_sensation_preference" DOUBLE,
  "air_movement_acceptability" DOUBLE,
  "air_movement_preference" DOUBLE,
  "sleepiness_level" DOUBLE,
  "concentration_level" DOUBLE,
  "work_productivity" DOUBLE
);

Study 19 Weather Study19

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_19_weather_study19

23.63 kB
31 rows
26 columns

CREATE TABLE study_19_weather_study19 (
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "study_condition" VARCHAR,
  "rain_total" DOUBLE,
  "rain_30m" DOUBLE,
  "rain_60m" DOUBLE,
  "rain_120m" DOUBLE,
  "temperature_outdoor_min_c" DOUBLE  -- Temperature Outdoor Min [C],
  "temperature_outdoor_1st_c" DOUBLE  -- Temperature Outdoor 1st [C],
  "temperature_outdoor_median_c" DOUBLE  -- Temperature Outdoor Median[C],
  "temperature_outdoor_mean_c" DOUBLE  -- Temperature Outdoor Mean [C],
  "temperature_outdoor_3rd_c" DOUBLE  -- Temperature Outdoor 3rd [C],
  "temperature_outdoor_max_c" DOUBLE  -- Temperature Outdoor Max [C],
  "relative_humidity_outdoor_min" BIGINT  -- Relative Humidity Outdoor Min [%],
  "relative_humidity_outdoor_1st" DOUBLE  -- Relative Humidity Outdoor 1st [%],
  "relative_humidity_outdoor_median" BIGINT  -- Relative Humidity Outdoor Median [%],
  "relative_humidity_outdoor_mean" DOUBLE  -- Relative Humidity Outdoor Mean [%],
  "relative_humidity_outdoor_3rd" DOUBLE  -- Relative Humidity Outdoor 3rd [%],
  "relative_humidity_outdoor_max" BIGINT  -- Relative Humidity Outdoor Max [%],
  "solar_radiation_min_w_m2" BIGINT  -- Solar Radiation Min [w/m2],
  "solar_radiation_1st_w_m2" DOUBLE  -- Solar Radiation 1st [w/m2],
  "solar_radiation_median_w_m2" BIGINT  -- Solar Radiation Median [w/m2],
  "solar_radiation_mean_w_m2" DOUBLE  -- Solar Radiation Mean [w/m2],
  "solar_radiation_3rd_w_m2" DOUBLE  -- Solar Radiation 3rd [w/m2],
  "solar_radiation_max_w_m2" BIGINT  -- Solar Radiation Max [w/m2]
);

Study 1 Part 1 Dict Study1

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_1_part_1_dict_study1

4.16 kB
58 rows
2 columns

CREATE TABLE study_1_part_1_dict_study1 (
  "col_names" VARCHAR,
  "note" VARCHAR
);

Study 1 Part 1 Study1

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_1_part_1_study1

61.89 kB
1,361 rows
58 columns

CREATE TABLE study_1_part_1_study1 (
  "school_number" BIGINT,
  "classroom_number" DOUBLE,
  "time_intervals" DOUBLE,
  "date" TIMESTAMP,
  "morning_afternoon" BIGINT,
  "time" VARCHAR,
  "season" BIGINT,
  "mode" BIGINT,
  "floor" BIGINT,
  "room_orientation" BIGINT,
  "student_ref_num" BIGINT,
  "gender" BIGINT,
  "commuting_type" BIGINT,
  "clothing_level" BIGINT,
  "jumper_cardigan" VARCHAR,
  "clo_jumper" VARCHAR,
  "clothing_value" VARCHAR,
  "fan_status" BIGINT,
  "drink" BIGINT,
  "tsv" VARCHAR,
  "tpv" VARCHAR,
  "tsvplustpv" VARCHAR,
  "air_sensation_vote" VARCHAR,
  "air_preference_vote" VARCHAR,
  "light_sensation_vote" VARCHAR,
  "light_preference_vote" VARCHAR,
  "comfortable_level" VARCHAR,
  "tiredness_level" VARCHAR,
  "temperature_air" DOUBLE,
  "temperature_air_average" DOUBLE,
  "temperature_radiant" DOUBLE,
  "temperature_radiant_average" DOUBLE,
  "air_speed" DOUBLE,
  "air_speed_average" DOUBLE,
  "relative_humidity" DOUBLE,
  "relative_humidity_average" DOUBLE,
  "co2" VARCHAR,
  "co2_average" VARCHAR,
  "co2_10min" VARCHAR,
  "co2_15min" VARCHAR,
  "temperature_operative" DOUBLE,
  "temperature_operative_average" DOUBLE,
  "temperature_outdoor" DOUBLE,
  "tcomfortgriffiths" VARCHAR,
  "temperature_running_mean" DOUBLE,
  "tcomfashrae" VARCHAR,
  "tcomfortcen2trm" DOUBLE,
  "uppermargintcocentrm" DOUBLE,
  "lowermargintcocentrm" VARCHAR,
  "air_speed_outdoor" DOUBLE,
  "relative_humidity_outdoor" DOUBLE,
  "position" VARCHAR,
  "daylight_level" VARCHAR,
  "exteriror_door" BIGINT,
  "areaofexteriordooropen" DOUBLE,
  "areaofopenwindow" DOUBLE,
  "totalopenarea" DOUBLE,
  "percentofopenwindowatthetimeofsurvey" VARCHAR
);

Study 1 Part 2 Dict Study1

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_1_part_2_dict_study1

5.1 kB
103 rows
2 columns

CREATE TABLE study_1_part_2_dict_study1 (
  "col_names" VARCHAR,
  "note" VARCHAR
);

Study 1 Part 2 Study1

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_1_part_2_study1

125.92 kB
1,089 rows
103 columns

CREATE TABLE study_1_part_2_study1 (
  "school_number" BIGINT,
  "classroom_number" DOUBLE,
  "time_intervals" VARCHAR,
  "date" TIMESTAMP,
  "time" VARCHAR,
  "season" BIGINT,
  "mode" BIGINT,
  "floor" BIGINT,
  "room_orientation" BIGINT,
  "occupant_num" BIGINT,
  "typeofactivity" VARCHAR,
  "justoccupiedornot" BIGINT,
  "fillingq" BIGINT,
  "temperature_operative" VARCHAR,
  "tcomfortcenmode" VARCHAR,
  "lower_margin" VARCHAR,
  "metabolicrate" VARCHAR,
  "weight" DOUBLE,
  "height" DOUBLE,
  "bodysurfacearea" DOUBLE,
  "numberofstudents" VARCHAR,
  "numofstudentsdrinking" VARCHAR,
  "numofstudentsfanning" VARCHAR,
  "withoutjumperorcardigan" VARCHAR,
  "classroomarea" VARCHAR,
  "classroomheight" DOUBLE,
  "classroomvolume" VARCHAR,
  "depthtoheightratio" VARCHAR,
  "openningtoclassroomarea" VARCHAR,
  "windowareatoclassroomratio" VARCHAR,
  "typeofwindow" VARCHAR,
  "typeofblindshade" VARCHAR,
  "numberofoperableblindsshades" VARCHAR,
  "typeofinternaldoor" VARCHAR,
  "ventilationtype" VARCHAR,
  "ventilationfan" VARCHAR,
  "areaofoperablewindows2" VARCHAR,
  "totaloperableareas" VARCHAR,
  "areaofnonoperablewindow" VARCHAR,
  "areaofdoorglazing" VARCHAR,
  "totalareaofglazing" VARCHAR,
  "numberofoperablewindows" VARCHAR,
  "windowglazing" VARCHAR,
  "typeofwindowoperation" BIGINT,
  "minimumheightofoperablewindowsill" VARCHAR,
  "openingtowallratio" VARCHAR,
  "percentofopenwindow" VARCHAR,
  "areaofopenwindows" VARCHAR,
  "areaofdooropen" VARCHAR,
  "totalopenarea" VARCHAR,
  "areaofexteriordooropening" DOUBLE,
  "areaofoperablewindows" VARCHAR,
  "totaloperablearea" VARCHAR,
  "percentofopenareas" VARCHAR,
  "numberofslightlyopenlargewindows" VARCHAR,
  "numberoffullyopensmallwindows" VARCHAR,
  "numberofslightlyopensamallwindows" VARCHAR,
  "numberofopensmallwindows" VARCHAR,
  "totalnumberofopenwindows" VARCHAR,
  "totalnumberofwindowadjustment" VARCHAR,
  "reasonforadjustment2" VARCHAR,
  "whodidadjustment" VARCHAR,
  "blindstate" VARCHAR,
  "percentofclosedblinds" VARCHAR,
  "reasonforadjustment" VARCHAR,
  "totalnumberofblindadjustment" VARCHAR,
  "whodidadjustment2" VARCHAR,
  "exteriorshade" VARCHAR,
  "interiordoorstate" VARCHAR,
  "reasonforadjustment3" VARCHAR,
  "whodidadjustment3" VARCHAR,
  "exteriordoorstate" VARCHAR,
  "reasonforadjustment5" VARCHAR,
  "whodidadjustment5" VARCHAR,
  "stateofconnectingdoor" VARCHAR,
  "heatingsystem" BIGINT,
  "fanorcoolingsystem" VARCHAR,
  "reasonforadjustment4" VARCHAR,
  "whodidadjustment4" VARCHAR,
  "lights" VARCHAR,
  "temperature_air" VARCHAR,
  "temperature_radiant" VARCHAR,
  "temperature_operative_1" VARCHAR,
  "temperature_outdoor_mean" VARCHAR,
  "air_speed" VARCHAR,
  "relative_humidity" VARCHAR,
  "co2" VARCHAR,
  "co2_exterior" BIGINT,
  "temperature_air_outdoor" VARCHAR,
  "relative_humidity_outdoor" VARCHAR,
  "air_speed_outdoor" VARCHAR,
  "rainorsnow" BIGINT,
  "k" VARCHAR,
  "vco2" VARCHAR,
  "gpcm3s" VARCHAR,
  "gequalsngp" VARCHAR,
  "geforadults" DOUBLE,
  "totalge" VARCHAR,
  "occupantdensitym2" VARCHAR,
  "occupantdensitym3" VARCHAR
);

Study 20 Appliance Usage Study20

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_20_appliance_usage_study20

1.01 MB
280,320 rows
5 columns

CREATE TABLE study_20_appliance_usage_study20 (
  "date_time" TIMESTAMP,
  "electric_power_w" DOUBLE  -- Electric Power[w],
  "appliance_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 20 Indoor Measurement Study20

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_20_indoor_measurement_study20

1.31 MB
245,280 rows
6 columns

CREATE TABLE study_20_indoor_measurement_study20 (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE  -- Indoor Temp[C],
  "indoor_rh" DOUBLE  -- Indoor RH[%],
  "desk_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 20 Outdoor Measurement Study20

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_20_outdoor_measurement_study20

137.12 kB
8,760 rows
7 columns

CREATE TABLE study_20_outdoor_measurement_study20 (
  "date_time" TIMESTAMP,
  "outdoor_temp_c" DOUBLE  -- Outdoor Temp[C],
  "outdoor_rh" BIGINT  -- Outdoor RH[%],
  "wind_speed_m_s" DOUBLE  -- Wind Speed[m/s],
  "wind_direction_deg" BIGINT  -- Wind Direction[deg],
  "solar_radiation_w_m2" BIGINT  -- Solar Radiation[w/m2],
  "building_id" BIGINT
);