About this Dataset

ASHRAE Global Occupant Behavior Database

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 10 Appliance Usage Study10

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_10_appliance_usage_study10

4.39 MB
525600 rows
5 columns


CREATE TABLE study_10_appliance_usage_study10 (
  "date_time" TIMESTAMP,
  "electric_power_w" DOUBLE,
  "appliance_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 10 Door Status Study10

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_10_door_status_study10

3.8 MB
525600 rows
5 columns


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
);

Study 10 Hvac Measurement Study10

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_10_hvac_measurement_study10

3.79 MB
525600 rows
5 columns


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
);

Study 10 Indoor Measurement Study10

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_10_indoor_measurement_study10

5.36 MB
525600 rows
8 columns


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
);

Study 10 Occupancy Measurement Study10

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_10_occupancy_measurement_study10

3.79 MB
525600 rows
4 columns


CREATE TABLE study_10_occupancy_measurement_study10 (
  "date_time" TIMESTAMP,
  "occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 10 Occupant Number Measurement Study10

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_10_occupant_number_measurement_study10

3.79 MB
525600 rows
4 columns


CREATE TABLE study_10_occupant_number_measurement_study10 (
  "date_time" TIMESTAMP,
  "occupant_number_measurement" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 10 Static Info Study10

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_10_static_info_study10

4.48 KB
1 row
6 columns


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

Study 10 Window Status

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_10_window_status

3.79 MB
525600 rows
5 columns


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
);

Study 11 Occupancy Measurement Study11

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_11_occupancy_measurement_study11

662.1 KB
94499 rows
4 columns


CREATE TABLE study_11_occupancy_measurement_study11 (
  "date_time" TIMESTAMP,
  "occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 11 Static Info Study11

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_11_static_info_study11

4.63 KB
12 rows
6 columns


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

Study 12 Hvac Behavior Dict Study12

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_12_hvac_behavior_dict_study12

2.5 KB
9 rows
2 columns


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

Study 12 Hvac Behavior Study12

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_12_hvac_behavior_study12

58.23 KB
3831 rows
9 columns


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
);

Study 12 Shading Behavior Dict Study12

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_12_shading_behavior_dict_study12

2.54 KB
10 rows
2 columns


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

Study 12 Shading Behavior Study12

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_12_shading_behavior_study12

56.19 KB
3243 rows
10 columns


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
);

Study 12 Window Behavior Dict Study12

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_12_window_behavior_dict_study12

2.5 KB
9 rows
2 columns


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

Study 12 Window Behavior Study12

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_12_window_behavior_study12

84.09 KB
6245 rows
9 columns


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
);

Study 14 Occupancy Measurement Study14

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_14_occupancy_measurement_study14

662.47 KB
298845 rows
4 columns


CREATE TABLE study_14_occupancy_measurement_study14 (
  "date_time" TIMESTAMP,
  "occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 14 Outdoor Measurement Study14

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_14_outdoor_measurement_study14

1.5 MB
298845 rows
9 columns


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
);

Study 14 Static Info Study14

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_14_static_info_study14

4.51 KB
3 rows
6 columns


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

Study 14 Window Status Study14

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_14_window_status_study14

370.13 KB
105138 rows
5 columns


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
);

Study 15 Door Status Study15

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_15_door_status_study15

3.63 MB
799200 rows
5 columns


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
);

Study 15 Hvac Measurement Study15

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_15_hvac_measurement_study15

634.62 KB
198288 rows
5 columns


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
);

Study 15 Indoor Measurement Study14

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_15_indoor_measurement_study14

1021.31 KB
298845 rows
4 columns


CREATE TABLE study_15_indoor_measurement_study14 (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 15 Indoor Measurement Study15

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_15_indoor_measurement_study15

903.46 KB
146880 rows
5 columns


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

Study 15 Outdoor Measurement Study15

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_15_outdoor_measurement_study15

618.1 KB
62568 rows
4 columns


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

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
);

Study 21 Hvac Measurement Study21

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_21_hvac_measurement_study21

891.15 KB
110370 rows
5 columns


CREATE TABLE study_21_hvac_measurement_study21 (
  "date_time" TIMESTAMP,
  "cooling_status_0_off_1_on" BIGINT,
  "hvac_zone_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 21 Indoor Measurement Study21

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_21_indoor_measurement_study21

1.08 MB
146825 rows
6 columns


CREATE TABLE study_21_indoor_measurement_study21 (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE,
  "indoor_rh" DOUBLE,
  "indoor_co2_ppm" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 21 Occupancy Measurement Study21

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_21_occupancy_measurement_study21

1.41 MB
373887 rows
5 columns


CREATE TABLE study_21_occupancy_measurement_study21 (
  "date_time" TIMESTAMP,
  "occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
  "desk_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 21 Outdoor Measurement Study21

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_21_outdoor_measurement_study21

1.21 MB
146825 rows
4 columns


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

Study 21 Static Info Study21

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_21_static_info_study21

4.5 KB
3 rows
6 columns


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

Study 21 Window Status Study21

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_21_window_status_study21

1.45 MB
395413 rows
5 columns


CREATE TABLE study_21_window_status_study21 (
  "date_time" TIMESTAMP,
  "window_status_0_closed_1_open" BIGINT,
  "window_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 22 Appliance Usage Study22

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_22_appliance_usage_study22

6.59 MB
2203392 rows
5 columns


CREATE TABLE study_22_appliance_usage_study22 (
  "date_time" TIMESTAMP,
  "electric_power_w" DOUBLE,
  "appliance_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 23 Hvac Measurement Study23

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_23_hvac_measurement_study23

19.47 KB
4320 rows
5 columns


CREATE TABLE study_23_hvac_measurement_study23 (
  "date_time" TIMESTAMP,
  "cooling_status_0_off_1_on" BIGINT,
  "hvac_zone_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 23 Indoor Measurement Study23

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_23_indoor_measurement_study23

37.32 KB
4320 rows
5 columns


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

Study 23 Window Status Study23

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_23_window_status_study23

19.34 KB
4320 rows
5 columns


CREATE TABLE study_23_window_status_study23 (
  "date_time" TIMESTAMP,
  "window_status_0_closed_1_open" BIGINT,
  "window_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 24 Indoor Measurement Study24

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_24_indoor_measurement_study24

20.05 MB
2731329 rows
5 columns


CREATE TABLE study_24_indoor_measurement_study24 (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE,
  "indoor_co2_ppm" DOUBLE,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 24 Occupancy Measurement Study24

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_24_occupancy_measurement_study24

447.75 KB
48458 rows
4 columns


CREATE TABLE study_24_occupancy_measurement_study24 (
  "date_time" TIMESTAMP,
  "occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 24 Static Info Study24

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_24_static_info_study24

4.6 KB
17 rows
6 columns


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

Study 24 Window Status Study24

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_24_window_status_study24

326.76 KB
51486 rows
5 columns


CREATE TABLE study_24_window_status_study24 (
  "date_time" TIMESTAMP,
  "window_status_0_closed_1_open" BIGINT,
  "window_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 26 Dict Study26

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_26_dict_study26

5.55 KB
116 rows
2 columns


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

Study 26 Study26

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_26_study26

11.71 MB
840984 rows
116 columns


CREATE TABLE study_26_study26 (
  "date_time" TIMESTAMP,
  "occupantnumber" BIGINT,
  "surveytime" DOUBLE,
  "indoor_temp_c" DOUBLE,
  "indoor_rh" DOUBLE,
  "indoor_air_speed_m_s" DOUBLE,
  "indoormeanradianttemp_c" DOUBLE,
  "indoorlumens_lux" DOUBLE,
  "indoor_co2_ppm" DOUBLE,
  "outdoor_temp_c" DOUBLE,
  "outdoor_rh" DOUBLE,
  "outdoor_air_speed_m_s" DOUBLE,
  "metabolicrate_last15mins" DOUBLE,
  "metabolicrate_last1hour" DOUBLE,
  "clothinglevel" DOUBLE,
  "clothinglevel_chair" DOUBLE,
  "min_accept_sensation_rightnow" DOUBLE,
  "med_accept_sensation_rightnow" DOUBLE,
  "max_accept_sensation_rightnow" DOUBLE,
  "min_accept_seasonalmedian" DOUBLE,
  "med_accept_seasonalmedian" DOUBLE,
  "max_accept_seasonalmedian" DOUBLE,
  "thermalpreference_rightnow" DOUBLE,
  "gender" DOUBLE,
  "age" DOUBLE,
  "officetype" DOUBLE,
  "floornumber" DOUBLE,
  "locationonfloorplan" DOUBLE,
  "min_accept_sensation_summer" DOUBLE,
  "min_accept_sensation_winter" DOUBLE,
  "med_accept_sensation_summer" DOUBLE,
  "med_accept_sensation_winter" DOUBLE,
  "max_accept_sensation_summer" DOUBLE,
  "max_accept_sensation_winter" DOUBLE,
  "generalthermalcomfort_rightnow" DOUBLE,
  "thermalcomfortmovement_recently" DOUBLE,
  "discomfortlocation_head" DOUBLE,
  "discomfortlocation_chest" DOUBLE,
  "discomfortlocation_back" DOUBLE,
  "discomfortlocation_pelvis" VARCHAR,
  "discomfortlocation_arms" DOUBLE,
  "discomfortlocation_hands" DOUBLE,
  "discomfortlocation_legs" DOUBLE,
  "discomfortlocation_feet" DOUBLE,
  "discomfortlocation_allover" DOUBLE,
  "thermalsensation_rightnow" DOUBLE,
  "thermalsensationmovement_recently" DOUBLE,
  "relative_busyness_recently" DOUBLE,
  "relativeproductivity_recently" DOUBLE,
  "generalsatisfactionw_amountofspace" DOUBLE,
  "generalsatisfactionw_privacy" DOUBLE,
  "generalthermalcomfort" DOUBLE,
  "generalsatisfactionw_perceivedcontrol" DOUBLE,
  "fan_heaterclass" DOUBLE,
  "fan_status" DOUBLE,
  "windor_status" DOUBLE,
  "temp_setpoint_c" DOUBLE,
  "basethermostatcoolingsetpoint_c" DOUBLE,
  "currentthermostatheatingsetpoint_c" DOUBLE,
  "basethermostatheatingsetpoint_c" DOUBLE,
  "clothingchange_recently" DOUBLE,
  "clothingchangeup_recently" DOUBLE,
  "clothingchangedown_recently" DOUBLE,
  "netclothingchange_recently" DOUBLE,
  "drinkingbeverage" DOUBLE,
  "purposeofgettingcolddrink" DOUBLE,
  "purposeofgettingwarmdrink" DOUBLE,
  "actiononwindow_recently" DOUBLE,
  "windowstate_rightnow" DOUBLE,
  "howlongagowaswindowaction" DOUBLE,
  "actionondoor_recently" DOUBLE,
  "doorstate_rightnow" DOUBLE,
  "howlongagowasdooraction" DOUBLE,
  "actiononblinds_recently" DOUBLE,
  "blindsstate_rightnow" DOUBLE,
  "howlongagowasblindsaction" DOUBLE,
  "actiononlocalfan_recently" DOUBLE,
  "localfanstate_rightnow" DOUBLE,
  "howlongagowaslocalfanaction" DOUBLE,
  "actiononlocalheater_recently" DOUBLE,
  "localheaterstate_rightnow" DOUBLE,
  "howlongagowaslocalheateraction" DOUBLE,
  "actiononthermostat_recently" DOUBLE,
  "thermostatstate_rightnow" DOUBLE,
  "howlongagowasthermostataction" DOUBLE,
  "reasonfornowindowaction" DOUBLE,
  "reasonfornodooraction" DOUBLE,
  "reasonfornoblindsaction" DOUBLE,
  "reasonfornolocalfanaction" DOUBLE,
  "reasonfornolocalheateraction" DOUBLE,
  "reasonfornothermostataction" DOUBLE,
  "clothingavailability" DOUBLE,
  "drinksavailability" DOUBLE,
  "localheateravailability" DOUBLE,
  "localfanavailability" DOUBLE,
  "thermostatavailability" DOUBLE,
  "windowavailability" DOUBLE,
  "dooravailability" DOUBLE,
  "blindsavailability" DOUBLE,
  "clothingeffectiveness" DOUBLE
);

Study 2 Appliance Usage

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_2_appliance_usage

532.95 MB
82689864 rows
5 columns


CREATE TABLE study_2_appliance_usage (
  "date_time" TIMESTAMP,
  "electric_power_w" DOUBLE,
  "appliance_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 30 Indoor Measurement Study30

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_30_indoor_measurement_study30

1.51 MB
373491 rows
4 columns


CREATE TABLE study_30_indoor_measurement_study30 (
  "date_time" TIMESTAMP,
  "indoor_illuminance_lux" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 30 Occupancy Measurement Study30

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_30_occupancy_measurement_study30

1.29 MB
373491 rows
4 columns


CREATE TABLE study_30_occupancy_measurement_study30 (
  "date_time" TIMESTAMP,
  "occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 30 Static Info Study30

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_30_static_info_study30

4.49 KB
5 rows
6 columns


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

Study 31 Dict Study31

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_31_dict_study31

2.95 KB
34 rows
2 columns


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

Study 31 Study31

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_31_study31

40.2 KB
704 rows
34 columns


CREATE TABLE study_31_study31 (
  "obs_no" BIGINT,
  "date" VARCHAR,
  "time" VARCHAR,
  "loc_type" VARCHAR,
  "age" BIGINT,
  "gender" VARCHAR,
  "residency_year" VARCHAR,
  "own_refrigerator" VARCHAR,
  "own_washing_machine" VARCHAR,
  "own_tv" VARCHAR,
  "own_ceiling_fan" VARCHAR,
  "own_exhaust_fan" VARCHAR,
  "own_air_cooler" VARCHAR,
  "own_ac" VARCHAR,
  "own_computer" VARCHAR,
  "others" VARCHAR,
  "metabolic_rate_w_m2" DOUBLE,
  "clothing_insulation" DOUBLE,
  "window_status" VARCHAR,
  "balcony_door" VARCHAR,
  "door_status" VARCHAR,
  "window_curtains" VARCHAR,
  "lights" VARCHAR,
  "exhaust_fans" VARCHAR,
  "ceiling_fans" VARCHAR,
  "air_coolers" VARCHAR,
  "ac" VARCHAR,
  "temperature_indoor_c" DOUBLE,
  "temperature_indoor_globe_c" DOUBLE,
  "relative_humidity_indoor" DOUBLE,
  "air_speed_indoor_m_s" DOUBLE,
  "illumination_indoor_lux" BIGINT,
  "temperature_outdoor_c" DOUBLE,
  "relative_humidity_outdoor" DOUBLE
);

Study 32 Indoor Measurement Study32

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_32_indoor_measurement_study32

89.27 KB
14688 rows
5 columns


CREATE TABLE study_32_indoor_measurement_study32 (
  "date_time" TIMESTAMP,
  "connected_device_number" BIGINT,
  "connected_device_type" VARCHAR,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 32 Occupant Number Measurement Study32

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_32_occupant_number_measurement_study32

83.71 KB
14688 rows
4 columns


CREATE TABLE study_32_occupant_number_measurement_study32 (
  "date_time" TIMESTAMP,
  "occupant_number_measurement" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 32 Occupant Number Measurement Study33

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_32_occupant_number_measurement_study33

53.57 KB
6529 rows
4 columns


CREATE TABLE study_32_occupant_number_measurement_study33 (
  "date_time" TIMESTAMP,
  "occupant_number_measurement" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 32 Static Info Study32

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_32_static_info_study32

4.49 KB
2 rows
6 columns


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

Study 32 Static Info Study33

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_32_static_info_study33

4.47 KB
1 row
6 columns


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

Study 3 Dict Study3

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_3_dict_study3

3.61 KB
44 rows
2 columns


CREATE TABLE study_3_dict_study3 (
  "suggested_col_names" VARCHAR,
  "note" VARCHAR
);

Study 3 Study3

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_3_study3

71.95 KB
1216 rows
44 columns


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
);

Study 4 Hvac Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_4_hvac_measurement

815.36 KB
190080 rows
5 columns


CREATE TABLE study_4_hvac_measurement (
  "date_time" TIMESTAMP,
  "vav_opening" DOUBLE,
  "hvac_zone_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 4 Indoor Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_4_indoor_measurement

1.08 MB
190080 rows
7 columns


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
);

Study 4 Occupant Number Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_4_occupant_number_measurement

844.74 KB
190080 rows
4 columns


CREATE TABLE study_4_occupant_number_measurement (
  "date_time" TIMESTAMP,
  "occupant_number_measurement" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 4 Static Info

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_4_static_info

4.55 KB
3 rows
6 columns


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

Study 5 Appliance Usage

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_5_appliance_usage

6.84 MB
1064590 rows
5 columns


CREATE TABLE study_5_appliance_usage (
  "date_time" TIMESTAMP,
  "electric_power_w" DOUBLE,
  "appliance_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 5 Door Status

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_5_door_status

1.82 MB
532295 rows
5 columns


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
);

Study 5 Indoor Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_5_indoor_measurement

3.02 MB
532295 rows
5 columns


CREATE TABLE study_5_indoor_measurement (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE,
  "indoor_illuminance_lux" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 5 Outdoor Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_5_outdoor_measurement

982.71 KB
53259 rows
8 columns


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
);

Study 5 Window Status

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_5_window_status

1.81 MB
532295 rows
5 columns


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
);

Study 6 Hvac Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_6_hvac_measurement

5.85 KB
170 rows
5 columns


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
);

Study 6 Indoor Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_6_indoor_measurement

753.28 KB
57238 rows
6 columns


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
);

Study 6 Outdoor Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_6_outdoor_measurement

2.56 MB
209602 rows
5 columns


CREATE TABLE study_6_outdoor_measurement (
  "date_time" TIMESTAMP,
  "outdoor_temp_c" DOUBLE,
  "outdoor_rh" DOUBLE,
  "solar_radiation_w_m2" DOUBLE,
  "building_id" BIGINT
);

Study 6 Window Status

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_6_window_status

24.13 KB
2401 rows
5 columns


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
);

Study 7 Hvac Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_7_hvac_measurement

1.82 MB
778752 rows
6 columns


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
);

Study 7 Indoor Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_7_indoor_measurement

3.31 MB
778752 rows
6 columns


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
);

Study 7 Occupancy Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_7_occupancy_measurement

1.82 MB
778752 rows
4 columns


CREATE TABLE study_7_occupancy_measurement (
  "date_time" TIMESTAMP,
  "occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 7 Outdoor Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_7_outdoor_measurement

4.73 MB
778752 rows
8 columns


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
);

Study 7 Static Info

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_7_static_info

4.63 KB
16 rows
6 columns


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

Study 8 Door Status

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_8_door_status

122.07 KB
28356 rows
5 columns


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
);

Study 8 Indoor Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_8_indoor_measurement

872.11 KB
283560 rows
6 columns


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
);

Study 8 Outdoor Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_8_outdoor_measurement

176.82 KB
9452 rows
9 columns


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
);

Study 8 Window Status

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_8_window_status

233.7 KB
113424 rows
5 columns


CREATE TABLE study_8_window_status (
  "date_time" TIMESTAMP,
  "window_status_0_closed_1_open" BIGINT,
  "window_id" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 9 Occupancy Measurement

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_9_occupancy_measurement

435.65 KB
48292 rows
4 columns


CREATE TABLE study_9_occupancy_measurement (
  "date_time" TIMESTAMP,
  "occupancy_measurement_0_unoccupied_1_occupied" BIGINT,
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 9 Static Info

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_9_static_info

4.62 KB
26 rows
6 columns


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