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 21 Hvac Measurement Study21

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_21_hvac_measurement_study21

912.54 kB
110,370 rows
5 columns

CREATE TABLE study_21_hvac_measurement_study21 (
  "date_time" TIMESTAMP,
  "cooling_status_0_off_1_on" BIGINT  -- Cooling Status[0-OFF;1-ON],
  "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.14 MB
146,825 rows
6 columns

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

Study 21 Occupancy Measurement Study21

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_21_occupancy_measurement_study21

1.47 MB
373,887 rows
5 columns

CREATE TABLE study_21_occupancy_measurement_study21 (
  "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 21 Outdoor Measurement Study21

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_21_outdoor_measurement_study21

1.26 MB
146,825 rows
4 columns

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

Study 21 Static Info Study21

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_21_static_info_study21

4.61 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.52 MB
395,413 rows
5 columns

CREATE TABLE study_21_window_status_study21 (
  "date_time" TIMESTAMP,
  "window_status_0_closed_1_open" BIGINT  -- Window Status[0-Closed;1-Open],
  "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.91 MB
2,203,392 rows
5 columns

CREATE TABLE study_22_appliance_usage_study22 (
  "date_time" TIMESTAMP,
  "electric_power_w" DOUBLE  -- Electric Power[w],
  "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.93 kB
4,320 rows
5 columns

CREATE TABLE study_23_hvac_measurement_study23 (
  "date_time" TIMESTAMP,
  "cooling_status_0_off_1_on" BIGINT  -- Cooling Status[0-OFF;1-ON],
  "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

38.22 kB
4,320 rows
5 columns

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

Study 23 Window Status Study23

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_23_window_status_study23

19.8 kB
4,320 rows
5 columns

CREATE TABLE study_23_window_status_study23 (
  "date_time" TIMESTAMP,
  "window_status_0_closed_1_open" BIGINT  -- Window Status[0-Closed;1-Open],
  "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

21.03 MB
2,731,329 rows
5 columns

CREATE TABLE study_24_indoor_measurement_study24 (
  "date_time" TIMESTAMP,
  "indoor_temp_c" DOUBLE  -- Indoor Temp[C],
  "indoor_co2_ppm" DOUBLE  -- Indoor CO2[ppm],
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 24 Occupancy Measurement Study24

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_24_occupancy_measurement_study24

458.5 kB
48,458 rows
4 columns

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

Study 24 Static Info Study24

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_24_static_info_study24

4.71 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

334.6 kB
51,486 rows
5 columns

CREATE TABLE study_24_window_status_study24 (
  "date_time" TIMESTAMP,
  "window_status_0_closed_1_open" BIGINT  -- Window Status[0-Closed;1-Open],
  "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.68 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

12.28 MB
840,984 rows
116 columns

CREATE TABLE study_26_study26 (
  "date_time" TIMESTAMP,
  "occupantnumber" BIGINT,
  "surveytime" DOUBLE,
  "indoor_temp_c" DOUBLE  -- Indoor Temp [C],
  "indoor_rh" DOUBLE  -- Indoor RH [%],
  "indoor_air_speed_m_s" DOUBLE  -- Indoor Air Speed [m/s],
  "indoormeanradianttemp_c" DOUBLE  -- INDOORMeanRadiantTemp [C],
  "indoorlumens_lux" DOUBLE  -- INDOORLumens [LUX],
  "indoor_co2_ppm" DOUBLE  -- Indoor CO2 [ppm],
  "outdoor_temp_c" DOUBLE  -- Outdoor Temp [C],
  "outdoor_rh" DOUBLE  -- OUTDoor RH [%],
  "outdoor_air_speed_m_s" DOUBLE  -- Outdoor Air Speed [m/s],
  "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  -- Relative Busyness, Recently,
  "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  -- Temp Setpoint [C],
  "basethermostatcoolingsetpoint_c" DOUBLE  -- BaseThermostatCOOLINGSetpoint [C],
  "currentthermostatheatingsetpoint_c" DOUBLE  -- CurrentThermostatHEATINGSetpoint [C],
  "basethermostatheatingsetpoint_c" DOUBLE  -- BaseThermostatHEATINGSetpoint [C],
  "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

558.84 MB
82,689,864 rows
5 columns

CREATE TABLE study_2_appliance_usage (
  "date_time" TIMESTAMP,
  "electric_power_w" DOUBLE  -- Electric Power[w],
  "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.58 MB
373,491 rows
4 columns

CREATE TABLE study_30_indoor_measurement_study30 (
  "date_time" TIMESTAMP,
  "indoor_illuminance_lux" BIGINT  -- Indoor Illuminance[LUX],
  "room_id" BIGINT,
  "building_id" BIGINT
);

Study 30 Occupancy Measurement Study30

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_30_occupancy_measurement_study30

1.35 MB
373,491 rows
4 columns

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

Study 30 Static Info Study30

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_30_static_info_study30

4.6 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

3.02 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

41.16 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 Refrigerator?,
  "own_washing_machine" VARCHAR  -- Own Washing Machine?,
  "own_tv" VARCHAR  -- Own TV?,
  "own_ceiling_fan" VARCHAR  -- Own Ceiling Fan?,
  "own_exhaust_fan" VARCHAR  -- Own Exhaust Fan?,
  "own_air_cooler" VARCHAR  -- Own Air-cooler?,
  "own_ac" VARCHAR  -- Own AC?,
  "own_computer" VARCHAR  -- Own Computer?,
  "others" VARCHAR  -- Others?,
  "metabolic_rate_w_m2" DOUBLE  -- Metabolic Rate [W/m2],
  "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 [C],
  "temperature_indoor_globe_c" DOUBLE  -- Temperature Indoor Globe [C],
  "relative_humidity_indoor" DOUBLE  -- Relative Humidity Indoor [%],
  "air_speed_indoor_m_s" DOUBLE  -- Air Speed Indoor [m/s],
  "illumination_indoor_lux" BIGINT  -- Illumination Indoor [LUX],
  "temperature_outdoor_c" DOUBLE  -- Temperature Outdoor [C],
  "relative_humidity_outdoor" DOUBLE  -- Relative Humidity Outdoor [%]
);

Study 32 Indoor Measurement Study32

@kaggle.claytonmiller_ashrae_global_occupant_behavior_database.study_32_indoor_measurement_study32

91.42 kB
14,688 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

85.72 kB
14,688 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

54.85 kB
6,529 rows
4 columns

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