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.02 MB
3941137 rows
5 columns


CREATE TABLE study_15_window_status_study15 (
  "date_time" TIMESTAMP,
  "window_status_0_closed_1_open" DOUBLE,
  "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

595.92 KB
134299 rows
6 columns


CREATE TABLE study_16_hvac_measurement_study16 (
  "date_time" VARCHAR,
  "heating_status_0_off_1_on" BIGINT,
  "supply_air_temp_c" DOUBLE,
  "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

765.14 KB
134299 rows
5 columns


CREATE TABLE study_16_indoor_measurement_study16 (
  "date_time" VARCHAR,
  "indoor_temp_c" DOUBLE,
  "indoor_rh" DOUBLE,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 16 Outdoor Measurement Study16

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_16_outdoor_measurement_study16

939.07 KB
134299 rows
4 columns


CREATE TABLE study_16_outdoor_measurement_study16 (
  "date_time" VARCHAR,
  "outdoor_temp_c" DOUBLE,
  "outdoor_rh" DOUBLE,
  "building_id" BIGINT
);

Study 16 Window Status Study16

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_16_window_status_study16

539.9 KB
134299 rows
5 columns


CREATE TABLE study_16_window_status_study16 (
  "date_time" VARCHAR,
  "window_status_0_closed_1_open" BIGINT,
  "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

445.37 KB
49331 rows
5 columns


CREATE TABLE study_17_door_status_study17 (
  "date_time" TIMESTAMP,
  "door_status_0_closed_1_open" BIGINT,
  "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

444.06 KB
49331 rows
6 columns


CREATE TABLE study_17_hvac_measurement_study17 (
  "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
);

Study 17 Indoor Measurement Study17

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_17_indoor_measurement_study17

545.98 KB
49331 rows
5 columns


CREATE TABLE study_17_indoor_measurement_study17 (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE,
  "indoor_rh" DOUBLE,
  "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

445.87 KB
49331 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_5" VARCHAR
);

Study 17 Outdoor Measurement Study17

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_17_outdoor_measurement_study17

459.52 KB
49331 rows
5 columns


CREATE TABLE study_17_outdoor_measurement_study17 (
  "date_time" TIMESTAMP,
  "outdoor_temp_c" DOUBLE,
  "outdoor_rh" BIGINT,
  "building_id" BIGINT,
  "room_id" BIGINT
);

Study 17 Static Info Study17

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_17_static_info_study17

4.5 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.74 MB
961920 rows
6 columns


CREATE TABLE study_18_appliance_usage_study18 (
  "date_time" TIMESTAMP,
  "electric_power_w" DOUBLE,
  "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

221.87 KB
16032 rows
6 columns


CREATE TABLE study_18_indoor_measurement_study18 (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE,
  "indoor_rh" DOUBLE,
  "indoor_illuminance_lux_ft2" DOUBLE,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 18 Occupancy Measurement Study18

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_18_occupancy_measurement_study18

419.27 KB
176352 rows
5 columns


CREATE TABLE study_18_occupancy_measurement_study18 (
  "date_time" TIMESTAMP,
  "occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
  "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.61 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.19 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_1_text_yes" VARCHAR,
  "q9_1_non_sensitive_very_sensitive" DOUBLE,
  "q10_how_much_do_you_usually_perspire_sweat" VARCHAR,
  "q11_if_you_are_warm_do_you_prefer_to_cool_you_down_with" VARCHAR
);

Study 19 Survey Study19

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_19_survey_study19

29.71 KB
1048575 rows
16 columns


CREATE TABLE study_19_survey_study19 (
  "date_time" TIMESTAMP,
  "study_condition" VARCHAR,
  "day_time" DOUBLE,
  "id" DOUBLE,
  "temperature_air_c" DOUBLE,
  "relative_humidity" DOUBLE,
  "temperature_operative_c" DOUBLE,
  "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.08 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_1st_c" DOUBLE,
  "temperature_outdoor_median_c" DOUBLE,
  "temperature_outdoor_mean_c" DOUBLE,
  "temperature_outdoor_3rd_c" DOUBLE,
  "temperature_outdoor_max_c" DOUBLE,
  "relative_humidity_outdoor_min" BIGINT,
  "relative_humidity_outdoor_1st" DOUBLE,
  "relative_humidity_outdoor_median" BIGINT,
  "relative_humidity_outdoor_mean" DOUBLE,
  "relative_humidity_outdoor_3rd" DOUBLE,
  "relative_humidity_outdoor_max" BIGINT,
  "solar_radiation_min_w_m2" BIGINT,
  "solar_radiation_1st_w_m2" DOUBLE,
  "solar_radiation_median_w_m2" BIGINT,
  "solar_radiation_mean_w_m2" DOUBLE,
  "solar_radiation_3rd_w_m2" DOUBLE,
  "solar_radiation_max_w_m2" BIGINT
);

Study 1 Part 1 Dict Study1

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_1_part_1_dict_study1

4.06 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

60.44 KB
1361 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

4.98 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

122.97 KB
1089 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

987.05 KB
280320 rows
5 columns


CREATE TABLE study_20_appliance_usage_study20 (
  "date_time" TIMESTAMP,
  "electric_power_w" DOUBLE,
  "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.25 MB
245280 rows
6 columns


CREATE TABLE study_20_indoor_measurement_study20 (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE,
  "indoor_rh" DOUBLE,
  "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

133.91 KB
8760 rows
7 columns


CREATE TABLE study_20_outdoor_measurement_study20 (
  "date_time" TIMESTAMP,
  "outdoor_temp_c" DOUBLE,
  "outdoor_rh" BIGINT,
  "wind_speed_m_s" DOUBLE,
  "wind_direction_deg" BIGINT,
  "solar_radiation_w_m2" BIGINT,
  "building_id" BIGINT
);