Education
26 columns
150 rows
8 formats

School IoT Energy Savings Tracker

This dataset enables education technology teams to monitor, analyze, and optimize energy consumption across school buildings using granular IoT sensor data. It supports anomaly detection, upgrade prioritization, and ESG/sustainability reporting, helping districts identify inefficiencies and drive data-driven facility improvements. The schema is ideal for operational analytics, sustainability tracking, and smart building management.

last updated 27 Nov 2025
by GoMask

The brief that made it

Real-time monitoring and optimization of school building energy usage

Sample rows

preview · 8 of 150 rows · all 26 columns

district_idstring	sensor_typestring	upgrade_priorityinteger	is_anomalyboolean	district_namestring	school_idstring	school_namestring	building_idstring	building_namestring	address_streetstring	address_citystring	address_statestring	address_postal_codestring	address_countrystring	sensor_idstring	sensor_locationstring	reading_idstring	reading_datetimedatetime	energy_consumption_kwhfloat	gas_consumption_m3float	water_consumption_litersfloat	temperature_celsiusfloat	humidity_percentfloat	anomaly_typestring	esg_reportedboolean	recommended_actionstring
D001	electricity	blank	false	North Valley Unified District	S1001	North Valley Elementary School	B1001	Main Academic Building	123 Maple Lane	Springfield	CA	90001	USA	E1001	Room 201, 2nd Floor	R00001	2024-02-21T09:15:00	312.6	blank	blank	blank	blank	none	true	blank
D002	gas	2	true	Eastside Education District	S1002	Eastside Middle School	B1002	Science Wing	456 Oak Street	Madison	TX	73301	USA	G1001	Mechanical Room	R00002	2024-02-21T10:05:00	blank	148.3	blank	blank	blank	spike	true	Inspect boiler for irregular gas usage.
D003	water	3	true	Greenfield Public Schools	S1003	Greenfield High School	B1003	Athletics Center	789 Pine Drive	Greenfield	FL	33101	USA	W1001	Locker Room Area	R00003	2024-02-21T11:10:00	blank	blank	20899	blank	blank	leak	true	Conduct plumbing inspection for possible leaks.
D004	temperature	blank	false	Westside Charter Schools	S1004	Westside Charter Academy	B1004	Library Annex	321 Cedar Ave	Denver	CO	80203	USA	T1001	Reading Room 1	R00004	2024-02-21T09:35:00	blank	blank	blank	18.7	blank	none	false	blank
D005	humidity	blank	false	Central Urban School District	S1005	Central Urban High School	B1005	Arts Building	654 Elm Street	Minneapolis	MN	55401	USA	H1001	Art Studio A	R00005	2024-02-21T09:50:00	blank	blank	blank	blank	61.4	none	true	blank
D006	other	1	true	Riverbend Community Schools	S1006	Riverbend Elementary School	B1006	Cafeteria	234 Willow Road	Riverbend	NY	10003	USA	O1001	Kitchen Storage	R00006	2024-02-21T12:30:00	blank	blank	blank	-47.2	blank	other	false	Calibrate temperature sensor and verify installation.
D007	electricity	blank	false	Hillside Unified Schools	S1007	Hillside Middle School	B1007	Gymnasium	890 Birch Blvd	Hillside	UT	84101	USA	E1002	Main Gym Lighting Panel	R00007	2024-02-21T08:45:00	185.7	blank	blank	blank	blank	none	true	blank
D008	gas	2	true	Lakeshore Area Schools	S1008	Lakeshore Primary School	B1008	Administration Wing	555 Lakeview Ave	Lakeshore	ND	58102	USA	G1002	Furnace Room	R00008	2024-02-21T11:20:00	blank	0	blank	blank	blank	outage	true	Check gas supply and furnace operation.
D009	water	blank	false	Sunset County Schools	S1009	Sunset Elementary School	B1009	Music Hall	777 Sunset Blvd	Sunset	CA	90210	USA	W1002	Restroom 3A	R00009	2024-02-21T10:25:00	blank	blank	12088	blank	blank	none	false	blank
D010	temperature	blank	false	Mountainview Public Schools	S1010	Mountainview High School	B1010	Science Center	222 Summit Rd	Mountainview	CO	80501	USA	T1002	Lab 5, Lower Level	R00010	2024-02-21T13:05:00	blank	blank	blank	24.1	blank	none	true	blank
D011	humidity	blank	false	Cedar Plains School District	S1011	Cedar Plains Elementary	B1011	Main Building	101 Cedar Lane	Cedarville	TX	75001	USA	H1002	Hallway West Wing	R00011	2024-02-21T08:50:00	blank	blank	blank	blank	41.3	none	true	blank
D001	electricity	blank	false	North Valley Unified District	S1001	North Valley Elementary School	B1002	Gymnasium	125 Maple Lane	Springfield	CA	90001	USA	E1003	Gym Electrical Panel	R00012	2024-02-21T09:55:00	117.2	blank	blank	blank	blank	none	true	blank
D012	gas	blank	false	Silver Lake School District	S1012	Silver Lake Middle School	B1012	Technology Wing	202 Silver Lake Dr	Lakewood	FL	33401	USA	G1003	Tech Storage Area	R00013	2024-02-21T12:05:00	blank	332.5	blank	blank	blank	none	false	blank
D003	water	4	true	Greenfield Public Schools	S1003	Greenfield High School	B1004	Science Block	791 Pine Drive	Greenfield	FL	33101	USA	W1003	Lab Wash Area	R00014	2024-02-21T10:50:00	blank	blank	3500	blank	blank	overuse	true	Audit water usage in science labs.
D013	temperature	1	true	Red Rock School District	S1013	Red Rock Primary School	B1013	Auditorium	303 Red Rock Rd	Redford	CO	80301	USA	T1003	Auditorium Main	R00015	2024-02-21T12:20:00	blank	blank	blank	60	blank	spike	false	Inspect HVAC for temperature regulation failure.
D014	humidity	3	true	Prairie View Public Schools	S1014	Prairie View High School	B1014	South Wing	444 Prairie Ave	Prairie	ND	58105	USA	H1003	Basement Storage	R00016	2024-02-21T09:25:00	blank	blank	blank	blank	100	overuse	true	Investigate ventilation and possible flooding.
D015	other	1	true	Maple Grove Unified	S1015	Maple Grove Middle School	B1015	North Building	555 Maple Ave	Grovetown	MN	55410	USA	O1002	Electrical Room	R00017	2024-02-21T14:00:00	0	blank	blank	blank	blank	outage	false	Check sensor wiring and restore power.
D016	electricity	blank	false	Willow Creek School District	S1016	Willow Creek Elementary	B1016	East Wing	606 Willow St	Willow	UT	84103	USA	E1004	East Wing Panel	R00018	2024-02-21T13:30:00	234.8	blank	blank	blank	blank	none	true	blank
D017	gas	blank	false	Summit Ridge Schools	S1017	Summit Ridge High School	B1017	West Hall	707 Summit Pkwy	Summit	CA	90211	USA	G1004	Boiler Room	R00019	2024-02-21T10:10:00	blank	275.9	blank	blank	blank	none	false	blank
D018	water	blank	false	Elmwood School District	S1018	Elmwood Middle School	B1018	Activity Center	808 Elmwood Dr	Elmwood	NY	10004	USA	W1004	Activity Center Restroom	R00020	2024-02-21T09:40:00	blank	blank	8999	blank	blank	none	true	blank

What the 150 rows show

from the 150-row sample

Water (sensor type) stands out: mean upgrade_priority is 3.9, against 2.0 for the rest.

38%is_anomaly = true
2median upgrade_priority
6anomaly types
22address states
227.6median energy_consumption_kwh
301.2median gas_consumption_m3

Mean upgrade_priority by sensor_type57 rows

upgrade_priority57 rows, in bands of 0.5

Median 2, from 1 to 5.

district_id150 rows · top 10 of 35 values

D01911
D01810
D0209
D0217
D0226
D0236
D0246
D0256
D0276
D0286

26 columns by typefrom the column list below

string 17
integer 1
float 5
datetime 1
boolean 2

Columns

26 columns in four groups

blueprint · 26 columns
column	type	description	example
Text 17 columns
`district_id`	string	Unique identifier for the school district	D001
`district_name`	string	Name of the school district	Westside Charter Schools
`school_id`	string	Unique identifier for the schoolunique	S1001
`school_name`	string	Name of the school	Eastside Middle School
`building_id`	string	Unique identifier for the building within the schoolunique	B1001
`building_name`	string	Name or description of the building	Main Academic Building
`address_street`	string	Street address of the building	123 Maple Lane
`address_city`	string	City where the building is located	Springfield
`address_state`	string	State where the building is located	CA
`address_postal_code`	string	Postal code for the building address	90001
`address_country`	string	Country of the building address	USA
`sensor_id`	string	Unique identifier for the IoT sensorunique	E1001
`sensor_type`	string	Type of IoT sensor (e.g., electricity, gas, water, temperature, humidity)6 values	electricity
`sensor_location`	string	Location within the building where the sensor is installed (e.g., room number, floor)	Room 201, 2nd Floor
`reading_id`	string	Unique identifier for the sensor readingunique	R00001
`anomaly_type`	string	Type of anomaly detected (e.g., spike, outage, leak, overuse)6 values · optional	none
`recommended_action`	string	Suggested action to address detected inefficiency or anomalyoptional	Inspect boiler for irregu…
Numbers 6 columns
`energy_consumption_kwh`	float	Measured energy consumption in kilowatt-hours (kWh) for the reading period0 or more · optional	312.6
`gas_consumption_m3`	float	Measured gas consumption in cubic meters (m³) for the reading period0 or more · optional	148.3
`water_consumption_liters`	float	Measured water consumption in liters for the reading period0 or more · optional	20899
`temperature_celsius`	float	Measured temperature in Celsius at the time of reading-50 to 60 · optional	18.7
`humidity_percent`	float	Measured humidity as a percentage at the time of reading0 to 100 · optional	61.4
`upgrade_priority`	integer	Priority level for facility upgrade based on detected inefficiency (1=highest, 5=lowest)1 to 5 · optional	2
Dates and times 1 column
`reading_datetime`	datetime	Timestamp when the sensor reading was recorded	2024-02-21T09:15:00
True or false 2 columns
`is_anomaly`	boolean	Indicates if the reading is flagged as an anomaly or inefficiencyoptional	false
`esg_reported`	boolean	Indicates if the data point was included in ESG/sustainability reportingoptional	true

Use it for

An education dashboard
The is_anomaly rate, upgrade_priority by sensor_type and a breakdown of district_id. Excel, Power BI or Tableau.
Why do the 12 water rows have a mean upgrade_priority of 3.9?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
Districts150
D001electric…
D0022gas
D0033water
A software demo
Believable districts with district_name, school_id and school_name to fill a screen in front of a buyer.

This dataset150 rows26 columns

Yours1,000 rows26 columnsaddress_street: UK only

blueprint · school-iot-energy-savings-tracker

Behind this dataset

Same schema. As many rows as you need.

These 150 rows came out of a blueprint — 26 columns with generation rules behind each one. Open it in Data Factory to retune a column, add your own, wire in foreign keys, and run it at the size you actually need.

Rules it was built with

Each row represents daily aggregated readings from a unique school building IoT energy sensor.
Include metrics for electricity, heating, and cooling usage (kWh, BTUs).
Flag readings that exceed defined efficiency thresholds.
Provide contextual data: day of week, weather impact factor, and occupancy status.
Include calculated daily CO2 emissions for ESG tracking.
Sensor uptime must be logged; gaps indicate maintenance needs.

Rows1,000 rows10,000 rows100,000 rows1,000,000 rows

Open the blueprint in Data Factory

1 credit per row. Preview 20 rows free. Buy rows for the full run.

Exports: CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
Licence: yours to use, including commercially
API slug: school-iot-energy-savings-tracker

What should your data show?

No signup. No card.

Sample rows

What the 150 rows show

Columns

Use it for

An education dashboard

A root-cause class exercise

A software demo

Make it yours.

Same schema. As many rows as you need.

More in Education

What should your data show?