Downloads
IoT and household data

Smart Home

One connected family home: 83 devices in 12 rooms, 13 months of sensor readings, solar, battery and EV energy, automations, alerts, security cameras, weather, utility bills, sleep, trips and a floor plan. October-September fiscal year.

smarthomeSQL ServerMariaDB 39 tables
readingsdevicessensor_channelsroomsevents

Read the guide

IoT and smart home (smarthome): One connected family home: 83 devices, 13 months of sensor readings, solar, battery and EV energy, automations, security, bills, trips and a floor plan.

Good for

Time-series and sensor dataEnergy, solar and billsMaps, trips and a floor planWater-year reporting

Questions to try

  • How much power comes from the sun each month?
  • What did each utility cost this fiscal year?
  • Does stuffy bedroom air hurt sleep?
  • Where is the motion in the house?

Write each as a query in the SQL editor, or ask an AI assistant to walk you through it.

Connect to it

Server learnsql.cpetoday.com,1433, database smarthome, in Excel or Power BI (Import mode) or DBeaver. These tables are in the dbo schema, so once you have picked the database you can use plain names such as access_codes.

Download the Excel connection (.odc)

How to use it: download the file and open it. Excel opens it as a connection to smarthome and asks for the SQL Server username and password from your CPE Today course. The file holds no password. The first table is selected by default, and you can pick others from the Data window. Setup details for other tools are on Connect.

Tables (39)

Click a table to preview it in the Playground.

← All databases