data description

These datasets contains raw data from the collectected within the Thermo-staat project downloadable per full year.

Measurements contain indoor temperature and humidity data. Sensors in the dataset are bound to different rooms in a home and have different periods of activity. The aim was to get most sensors active in the summer.

Measurements where not done at a constant frequency, depending on the connectivity sensors did send up to once every 20 seconds.

Data is available under the CC BY-NC-SA 4.0 Creative Commons license.

Download data year 2023 (487MB) →

data

The data directory contains a csv file per sensor using the following format for the filename:[home_id]_[sensor_type]_[instance_id].csv . An example of the contents of 1_pvvx_1.csv :

utc,temperature,humidity
1676661308,18.12,66.12
1676661870,18.11,66.03
1676661882,18.15,67.11
1676661895,18.13,66.5

The columns:

• utc: the Epoch / Unix timestamp in seconds
• temperature: temperature in degrees Celcius
• humidity: relative humidity in percentage

meta data

The meta directory contains a JSON file per sensor, each file corresponding with one of the files in the data directory.
Properties of the sensor are the combined properties of the house and the room the sensor is located in. The directory contains a json file per sensor using the following format for the filename: [home_id]_[sensor_type]_[instance_id].json.
An example of the contents of 1_pvvx_1.json :

{
  "postcode": "3582DP",
  "beschutting": [
    "bebouwing"
   ],
  "bouwjaar": [
    "05-15"
  ],
  "buitenmuren": [
    "3"
  ],
  "energielabel": [
    "A"
  ],
  "klimaatregeling": [
    "doorluchten"
  ],
  "ligging": [
    "rustige_weg",
    "woonwijk",
    "centrum"
  ],
  "orientatie": [
    "Z",
    "O"
  ],
  "ruimte": [
    "woonkamer"
  ],
  "verdieping": [
    "0"
  ],
  "woningtype": [
    "hoekwoning"
  ],
  "woonvorm": [
    "koopwoning"
  ]
}

Metadata is also included as SQLite database. The following query collects all data for all sensors:

sqlite3 -header -csv thermo-staat.db "SELECT home_id, sensor_type, instance_id, postal_code, vocabularies.name, string_agg(tags.tag, ':') 
    FROM sensors JOIN sensor_tags ON sensor_tags.sensor = sensors.id 
    JOIN tags ON sensor_tags.tag = tags.id JOIN vocabularies ON tags.parent = vocabularies.id 
    WHERE sensor_type = 'pvvx'
    GROUP BY home_id, sensor_type, instance_id, vocabularies.name 
    ORDER BY home_id, sensor_type, instance_id;"
    

meta data properties

Properties are in Dutch and are limited to the following values: