School Sensor Data Impact Analysis
This dataset provides granular, timestamped sensor readings from smart building deployments in schools, along with contextual information about sensor types, locations, and operational status. It enables benchmarking of learning environment quality and operational efficiency, supporting data-driven decisions for EdTech developers and facilities managers regarding sensor investments and maintenance strategies.
Sample rows
preview · 8 of 58 rows · all 22 columns| school_idstring | sensor_typestring | sensor_valuefloat | maintenance_requiredboolean | sensor_locationstring | school_namestring | school_typestring | address_streetstring | address_citystring | address_statestring | address_postal_codestring | address_countrystring | sensor_idstring | sensor_install_datedate | sensor_statusstring | reading_timestampdatetime | sensor_unitstring | learning_env_quality_scorefloat | operational_efficiency_scorefloat | last_maintenance_datedate | sensor_manufacturerstring | deployment_costfloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SCH-1001 | temperature | 22.7 | false | classroom | Riverside Elementary | elementary | 450 Maple Ave | Greenville | NC | 27834 | USA | SNSR-5001 | 2023-06-21 | active | 2024-05-29T09:18:00 | °C | 84.5 | 81.2 | 2024-03-22 | EnviroSense | 340 |
| SCH-1002 | co2 | 670.5 | false | cafeteria | Liberty Middle School | middle | 220 Liberty Blvd | Stamford | CT | 06902 | USA | SNSR-5002 | 2022-10-03 | active | 2024-05-29T12:05:00 | ppm | 78.9 | 87.1 | 2024-01-15 | AirLogic | 465 |
| SCH-1003 | humidity | 51.8 | false | library | Northside High | high | 1620 North St | Madison | WI | 53704 | USA | SNSR-5003 | 2023-09-16 | active | 2024-05-29T15:42:00 | % | 90.3 | 92.7 | 2024-04-08 | ClimaTech | 370 |
| SCH-1004 | occupancy | 19 | false | hallway | Greenview Academy | K-12 | 250 Greenview Rd | Aurora | IL | 60506 | USA | SNSR-5004 | 2024-01-11 | active | 2024-05-29T10:32:00 | persons | 76.1 | 73.4 | 2024-01-11 | SpaceTrack | 415 |
| SCH-1005 | noise | 57.9 | false | gymnasium | Sunrise School | elementary | 98 Sunrise Way | Boca Raton | FL | 33431 | USA | SNSR-5005 | 2022-12-05 | active | 2024-05-29T13:45:00 | dB | 80.2 | 75.6 | 2023-10-29 | SoundVision | 495 |
| SCH-1006 | temperature | 20.2 | false | science lab | New Horizons High | high | 3116 Lakeview Dr | Erie | PA | 16508 | USA | SNSR-5006 | 2023-02-17 | active | 2024-05-29T14:10:00 | °C | 83.4 | 88.2 | 2024-02-20 | EnviroSense | 355 |
| SCH-1007 | co2 | 1120.2 | true | auditorium | Westlake Middle | middle | 1200 Westlake Pkwy | Austin | TX | 78746 | USA | SNSR-5007 | 2022-11-14 | maintenance | 2024-05-29T15:05:00 | ppm | 68.9 | 64.2 | 2024-05-27 | AirLogic | 475 |
| SCH-1008 | humidity | 44.2 | false | classroom | Hillcrest School | elementary | 87 Hillcrest Rd | Des Moines | IA | 50310 | USA | SNSR-5008 | 2023-08-29 | active | 2024-05-29T08:35:00 | % | 88.7 | 90.2 | 2024-03-01 | ClimaTech | 390 |
| SCH-1009 | occupancy | 45 | false | gymnasium | Harborview High | high | 465 Harborview Dr | Seattle | WA | 98126 | USA | SNSR-5009 | 2023-06-10 | active | 2024-05-29T10:55:00 | persons | 72.3 | 78.6 | 2024-03-09 | SpaceTrack | 430 |
| SCH-1010 | noise | 48.6 | false | cafeteria | Cedar Ridge Academy | K-12 | 55 Cedar Ridge Dr | Boulder | CO | 80302 | USA | SNSR-5010 | 2024-02-01 | active | 2024-05-29T12:25:00 | dB | 82.8 | 79.4 | 2024-02-01 | SoundVision | 510 |
| SCH-1011 | temperature | 23.1 | false | classroom | Lakewood Elementary | elementary | 602 Lakewood Rd | Richmond | VA | 23226 | USA | SNSR-5011 | 2023-05-28 | active | 2024-05-29T09:55:00 | °C | 85.3 | 83.5 | 2024-02-10 | EnviroSense | 340 |
| SCH-1012 | co2 | 1500.8 | true | auditorium | Summit Middle | middle | 290 Summit Blvd | Denver | CO | 80237 | USA | SNSR-5012 | 2021-12-20 | decommissioned | 2024-05-29T13:23:00 | ppm | 49.2 | 54.7 | 2024-05-22 | AirLogic | 480 |
| SCH-1013 | humidity | 38.5 | true | library | Eastwood High | high | 841 Eastwood Ln | Columbus | OH | 43209 | USA | SNSR-5013 | 2022-04-18 | inactive | 2024-05-29T16:12:00 | % | 60.8 | 66.3 | 2024-05-23 | ClimaTech | 385 |
| SCH-1014 | occupancy | 28 | false | hallway | Silver Oak School | elementary | 209 Silver Oak Ct | San Jose | CA | 95120 | USA | SNSR-5014 | 2023-09-05 | active | 2024-05-29T11:15:00 | persons | 74.5 | 85.2 | 2024-01-07 | SpaceTrack | 420 |
| SCH-1015 | noise | 62.3 | false | cafeteria | Stonebridge K-12 | K-12 | 77 Stonebridge Ave | Syracuse | NY | 13214 | USA | SNSR-5015 | 2023-03-17 | active | 2024-05-29T12:53:00 | dB | 79.4 | 76.7 | 2023-11-05 | SoundVision | 505 |
| SCH-1016 | temperature | 21.4 | false | science lab | Canyon View Middle | middle | 392 Canyon View Dr | Phoenix | AZ | 85018 | USA | SNSR-5016 | 2023-01-30 | active | 2024-05-29T14:40:00 | °C | 87.9 | 92.1 | 2024-02-28 | EnviroSense | 350 |
| SCH-1017 | co2 | 890.4 | false | auditorium | Meadowlark High School | high | 1800 Meadowlark Dr | Boise | ID | 83702 | USA | SNSR-5017 | 2021-09-22 | active | 2024-05-29T15:27:00 | ppm | 73.6 | 70.4 | 2024-01-18 | AirLogic | 470 |
| SCH-1018 | humidity | 48.7 | false | classroom | Willowbrook Elementary | elementary | 321 Willowbrook St | Lexington | KY | 40509 | USA | SNSR-5018 | 2023-07-16 | active | 2024-05-29T08:43:00 | % | 91.2 | 94.5 | 2024-03-22 | ClimaTech | 395 |
| SCH-1019 | occupancy | 17 | true | hallway | Redwood Academy | K-12 | 88 Redwood Ave | Portland | OR | 97205 | USA | SNSR-5019 | 2024-01-22 | maintenance | 2024-05-29T10:18:00 | persons | 67.8 | 62.1 | 2024-05-25 | SpaceTrack | 410 |
| SCH-1020 | noise | 54.2 | false | gymnasium | Oakwood Middle | middle | 421 Oakwood Dr | Chattanooga | TN | 37421 | USA | SNSR-5020 | 2022-06-15 | active | 2024-05-29T13:39:00 | dB | 78.2 | 74.5 | 2023-11-22 | SoundVision | 490 |
What the 58 rows show
from the 58-row sampleCo2 (sensor type) stands out: mean sensor_
- 17%maintenance_
required = true - 46.8median sensor_
value - 2address countries
- 4sensor statuses
- 5school types
- 6sensor units
Median 46.8, from 17.0 to 1,501.
- string 14
- float 4
- date 2
- datetime 1
- boolean 1
Columns
22 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 14 columns | |||
school_id | string | Unique identifier for the schoolunique | SCH-1001 |
school_name | string | Official name of the school | Riverside Elementary |
school_type | string | Type of school (e.g., elementary, middle, high, K-12)elementary · middle · high · K-12 · other | elementary |
address_street | string | Street address of the school | 450 Maple Ave |
address_city | string | City where the school is located | Greenville |
address_state | string | State or province where the school is located | NC |
address_postal_code | string | Postal code of the school's address | 27834 |
address_country | string | Country where the school is located2 countries | USA |
sensor_id | string | Unique identifier for the sensor deviceunique | SNSR-5001 |
sensor_type | string | Type of sensor deployed (e.g., temperature, CO2, humidity, occupancy, noise)6 values | temperature |
sensor_location | string | Location within the school where the sensor is installed (e.g., classroom, hallway, cafeteria) | classroom |
sensor_status | string | Current operational status of the sensoractive · inactive · maintenance · decommissioned | active |
sensor_unit | string | Unit of measurement for the sensor value (e.g., °C, ppm, %, dB)6 units | °C |
sensor_manufacturer | string | Name of the sensor manufacturer9 manufacturers · optional | EnviroSense |
| Numbers 4 columns | |||
sensor_value | float | Value recorded by the sensor (unit depends on sensor type) | 22.7 |
learning_env_quality_score | float | Composite score (0-100) reflecting learning environment quality based on sensor data0 to 100 · optional | 84.5 |
operational_efficiency_score | float | Composite score (0-100) reflecting operational efficiency improvements from sensor deployment0 to 100 · optional | 81.2 |
deployment_cost | float | Cost of deploying the sensor (in local currency)0 or more · optional | 340 |
| Dates and times 3 columns | |||
sensor_install_date | date | Date the sensor was installed | 2023-06-21 |
reading_timestamp | datetime | Timestamp when the sensor reading was recorded | 2024-05-29T09:18:00 |
last_maintenance_date | date | Date of last maintenance for the sensoroptional | 2024-03-22 |
| True or false 1 column | |||
maintenance_required | boolean | Indicates if maintenance is required for the sensor | false |
Use it for
An education dashboard
The maintenance_
required rate, sensor_ value by sensor_ type and a breakdown of sensor_ location. Excel, Power BI or Tableau. Why do the 12 co2 rows have a mean sensor_
value of 807.8? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Schools58SCH-100122.7temperat…SCH-10071120.2co2SCH-10121500.8co2
A software demo
Believable schools with school_
name, school_ type and address_ street to fill a screen in front of a buyer.
This dataset58 rows22 columns
Yours1,000 rows22 columnsaddress_street: UK only
blueprint · school-sensor-data-impact-analysis
Behind this dataset
Same schema. As many rows as you need.
These 58 rows came out of a blueprint — 22 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 a unique school building with sensor integration.
- Sensor types include air quality, occupancy, temperature, and light.
- Impact metrics measured: energy savings, absenteeism rate, classroom comfort score, and maintenance response time.
- Only buildings with at least 6 months post-integration data are included.
- Data anonymized for institution privacy.
- Sensor malfunctions flagged with specific codes.
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-sensor-data-impact-analysis