ASHRAE Global Thermal Comfort Database II
81,846 sets of indoor climatic observations with subjective evaluations
@kaggle.claytonmiller_ashrae_global_thermal_comfort_database_ii
81,846 sets of indoor climatic observations with subjective evaluations
@kaggle.claytonmiller_ashrae_global_thermal_comfort_database_ii
Recognizing the value of open-source research databases in advancing the art and science of
HVAC, in 2014 the ASHRAE Global Thermal Comfort Database II project was launched under
the leadership of University of California at Berkeley’s Center for the Built Environment and
The University of Sydney’s Indoor Environmental Quality (IEQ) Laboratory.
The exercise began with a systematic collection and harmonization of raw data from the last
two decades of thermal comfort field studies around the world. The final database is comprised
of field studies conducted between 1995 and 2015 from around the world, with contributors
releasing their raw data to the project for wider dissemination to the thermal comfort research
community. After the quality-assurance process, there was a total of 81,846 rows of data of
paired subjective comfort votes and objective instrumental measurements of thermal comfort
parameters. An additional 25,617 rows of data from the original ASHRAE RP-884 database are
included, bringing the total number of entries to 107,463.
The database is intended to support diverse inquiries about thermal comfort in field settings.
To achieve this goal, two web-based tools were developed to accompany the database:
In order to ensure that the quality of the database would permit end-users to conduct robust
hypothesis testing, the team built the data collection methodology on specific requirements, as
follows:
All datasets from individual studies were subject to a stringent quality assurance process
before being assimilated into the database. The research team conducted a final
validation by first comparing each raw dataset with its related publication provided by the data
contributor to prevent transmission errors. Systematic quality control of each study was
performed to ensure that records within the database were reasonable. Firstly, distributions of
each variable were visualized to identify aberrant values. Then, cross-plots between two
variables (e.g. thermal sensation and thermal comfort) were used to check for incorrectly coded
data. Finally, a few rows from each study were randomly selected to verify consistency between
the original dataset and the standardized database. Since the data came from multiple
independent studies, every record did not necessarily include all of the thermal comfort
variables. Where data were missing, that particular range of cells was filled with a null value.
The dataset is provided as a comma-separated value (.csv) file using UTF-8 character encoding.
The first row contains human-readable column headers. Each row represents an individual’s
questionnaire responses, and the associated instrumental measurements, thermal index values
and outdoor meteorological observations where available. Full details can be found in the
related work.
American Society of Heating, Refrigerating and Air Conditioning Engineers, Award: URP 1656
This dataset is supplement to https://doi.org/10.1016/j.buildenv.2018.06.022
CREATE TABLE ashrae_db2_01 (
  "publication_citation" VARCHAR  -- Publication (Citation),
  "data_contributor" VARCHAR,
  "year" DOUBLE,
  "season" VARCHAR,
  "koppen_climate_classification" VARCHAR,
  "climate" VARCHAR,
  "city" VARCHAR,
  "country" VARCHAR,
  "building_type" VARCHAR,
  "cooling_startegy_building_level" VARCHAR,
  "cooling_startegy_operation_mode_for_mm_buildings" VARCHAR,
  "heating_strategy_building_level" VARCHAR,
  "age" DOUBLE,
  "sex" VARCHAR,
  "thermal_sensation" DOUBLE,
  "thermal_sensation_acceptability" DOUBLE,
  "thermal_preference" VARCHAR,
  "air_movement_acceptability" DOUBLE,
  "air_movement_preference" VARCHAR,
  "thermal_comfort" VARCHAR,
  "pmv" DOUBLE,
  "ppd" DOUBLE,
  "set" DOUBLE,
  "clo" DOUBLE,
  "met" DOUBLE,
  "activity_10" DOUBLE,
  "activity_20" DOUBLE,
  "activity_30" DOUBLE,
  "activity_60" DOUBLE,
  "air_temperature_c" DOUBLE  -- Air Temperature (C),
  "air_temperature_f" DOUBLE  -- Air Temperature (F),
  "ta_h_c" DOUBLE  -- Ta H (C),
  "ta_h_f" DOUBLE  -- Ta H (F),
  "ta_m_c" DOUBLE  -- Ta M (C),
  "ta_m_f" VARCHAR  -- Ta M (F),
  "ta_l_c" DOUBLE  -- Ta L (C),
  "ta_l_f" DOUBLE  -- Ta L (F),
  "operative_temperature_c" DOUBLE  -- Operative Temperature (C),
  "operative_temperature_f" DOUBLE  -- Operative Temperature (F),
  "radiant_temperature_c" DOUBLE  -- Radiant Temperature (C),
  "radiant_temperature_f" DOUBLE  -- Radiant Temperature (F),
  "globe_temperature_c" DOUBLE  -- Globe Temperature (C),
  "globe_temperature_f" DOUBLE  -- Globe Temperature (F),
  "tg_h_c" DOUBLE  -- Tg H (C),
  "tg_h_f" DOUBLE  -- Tg H (F),
  "tg_m_c" DOUBLE  -- Tg M (C),
  "tg_m_f" DOUBLE  -- Tg M (F),
  "tg_l_c" DOUBLE  -- Tg L (C),
  "tg_l_f" DOUBLE  -- Tg L (F),
  "relative_humidity" DOUBLE  -- Relative Humidity (%),
  "humidity_preference" VARCHAR,
  "humidity_sensation" DOUBLE,
  "air_velocity_m_s" DOUBLE  -- Air Velocity (m/s),
  "air_velocity_fpm" DOUBLE  -- Air Velocity (fpm),
  "velocity_h_m_s" DOUBLE  -- Velocity H (m/s),
  "velocity_h_fpm" DOUBLE  -- Velocity H (fpm),
  "velocity_m_m_s" DOUBLE  -- Velocity M (m/s),
  "velocity_m_fpm" DOUBLE  -- Velocity M (fpm),
  "velocity_l_m_s" DOUBLE  -- Velocity L (m/s),
  "velocity_l_fpm" DOUBLE  -- Velocity L (fpm),
  "subject_s_height_cm" DOUBLE  -- Subject«s Height (cm),
  "subject_s_weight_kg" DOUBLE  -- Subject«s Weight (kg),
  "blind_curtain" DOUBLE  -- Blind (curtain),
  "fan" DOUBLE,
  "window" DOUBLE,
  "door" DOUBLE,
  "heater" DOUBLE,
  "outdoor_monthly_air_temperature_c" DOUBLE  -- Outdoor Monthly Air Temperature (C),
  "outdoor_monthly_air_temperature_f" DOUBLE  -- Outdoor Monthly Air Temperature (F),
  "database" VARCHAR
);Anyone who has the link will be able to view this.