Smart City Air Sensor Trends
This dataset provides granular, time-stamped air quality measurements from IoT sensors deployed across multiple city locations, including pollutant concentrations, environmental conditions, and regulatory compliance status. It is designed to help urban planners, sustainability analysts, and policymakers identify pollution hotspots, monitor air quality trends, and ensure regulatory compliance for smarter, healthier cities.
Sample rows
preview · 8 of 120 rows · all 18 columns| sensor_idstring | regulatory_compliance_statusstring | no2float | sensor_statusstring | location_idstring | location_namestring | latitudefloat | longitudefloat | measurement_datetimedatetime | pm2_5float | pm10float | so2float | cofloat | o3float | temperaturefloat | humidityfloat | citystring | districtstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| SENSOR_001 | non-compliant | 41.2 | active | LOC_A01 | Los Angeles Downtown | 34.0522 | -118.2437 | 2024-06-19T08:15:00 | 58.2 | 102.7 | 12.6 | 2.1 | 67.5 | 27.8 | 36.2 | Los Angeles | Downtown |
| SENSOR_002 | non-compliant | 37.5 | active | LOC_A02 | Chicago Industrial Park | 41.8905 | -87.6742 | 2024-06-19T09:30:00 | 49.7 | 94.3 | 10.3 | 1.7 | 59.2 | 22.4 | 40.7 | Chicago | North Side |
| SENSOR_003 | non-compliant | 48.1 | maintenance | LOC_A03 | Miami Airport | 25.7959 | -80.2871 | 2024-06-19T11:05:00 | 62.4 | 110.2 | 14.9 | 2.6 | 70.3 | 31.2 | 43.7 | Miami | Airport |
| SENSOR_004 | non-compliant | 39.3 | active | LOC_A04 | Houston Shipyard | 29.7361 | -95.2807 | 2024-06-19T13:40:00 | 55.8 | 98.9 | 11.8 | 1.9 | 63.4 | 29.5 | 38.5 | Houston | Shipyard |
| SENSOR_005 | non-compliant | 33.7 | active | LOC_A05 | Seattle Downtown | 47.6062 | -122.3321 | 2024-06-19T08:55:00 | 42.9 | 87.1 | 8.7 | 1.3 | 52.8 | 19.7 | 44.8 | Seattle | Pioneer Square |
| SENSOR_006 | compliant | 4.1 | active | LOC_B01 | Central Park | 40.7851 | -73.9683 | 2024-06-19T07:20:00 | 9.8 | 13.2 | 0.9 | 0.3 | 17.6 | 21.4 | 60.1 | New York | Manhattan |
| SENSOR_007 | compliant | 7.2 | active | LOC_B02 | Chicago Schoolyard | 41.8781 | -87.6298 | 2024-06-19T10:05:00 | 12.7 | 22.8 | 2.3 | 0.5 | 20.4 | 19.2 | 72.9 | Chicago | Lincoln Park |
| SENSOR_008 | compliant | 3.7 | active | LOC_B03 | Seattle City Park | 47.6396 | -122.3308 | 2024-06-19T11:35:00 | 8.4 | 14.9 | 1.1 | 0.2 | 15.8 | 16.8 | 79.5 | Seattle | Green Lake |
| SENSOR_009 | compliant | 9.9 | active | LOC_B04 | Boston Playground | 42.3601 | -71.0589 | 2024-06-19T15:05:00 | 16.3 | 28.1 | 2.7 | 0.6 | 23.1 | 13.5 | 81.7 | Boston | Dorchester |
| SENSOR_010 | compliant | 6.3 | active | LOC_B05 | Austin Suburban School | 30.2672 | -97.7431 | 2024-06-19T14:25:00 | 11.8 | 21.7 | 1.8 | 0.4 | 19.2 | 22.6 | 59.5 | Austin | Westlake |
| SENSOR_011 | compliant | 2.1 | active | LOC_C01 | Denver Mountain Station | 39.7392 | -104.9903 | 2024-06-19T10:47:00 | 4.2 | 8.3 | 0.3 | 0.1 | 11.8 | 2.5 | 92.3 | Denver | Mountain |
| SENSOR_012 | compliant | 3.4 | active | LOC_C02 | Las Vegas Desert Outpost | 36.1699 | -115.1398 | 2024-06-19T06:22:00 | 5.6 | 10.9 | 1.2 | 0.2 | 12.3 | 19.7 | 13.8 | Las Vegas | Desert |
| SENSOR_013 | compliant | 2.9 | active | LOC_C03 | Boston Farm Station | 42.3505 | -71.1054 | 2024-06-19T12:05:00 | 6.1 | 12.6 | 0.7 | 0.2 | 13.9 | 8.7 | 79.4 | Boston | Farm |
| SENSOR_014 | compliant | 1.4 | active | LOC_C04 | Seattle Forest Reserve | 47.7511 | -122.4597 | 2024-06-19T17:45:00 | 2.9 | 7.5 | 0.4 | 0.1 | 9.7 | 4.1 | 94.2 | Seattle | Forest |
| SENSOR_015 | compliant | 1.9 | active | LOC_C05 | San Diego Mountain | 32.7157 | -117.1611 | 2024-06-19T08:00:00 | 3.1 | 6.2 | 0.5 | 0.1 | 10.6 | 7.3 | 87.8 | San Diego | Mountain |
| SENSOR_016 | unknown | blank | error | LOC_D01 | Null Island | 0 | 0 | 2023-12-01T03:44:00 | 0 | 0 | blank | blank | blank | -60 | 0 | Null Island | blank |
| SENSOR_017 | unknown | blank | error | LOC_D02 | Arctic Station | 82.5018 | -62.3481 | 2023-12-01T01:20:00 | 0 | 0 | blank | blank | blank | -52.7 | 100 | Resolute | blank |
| SENSOR_018 | unknown | blank | maintenance | LOC_D03 | Miami Ocean Buoy | 25.7981 | -80.1262 | 2023-12-01T07:10:00 | 0 | 0 | blank | blank | blank | 24.5 | 100 | Miami | Ocean |
| SENSOR_019 | unknown | blank | maintenance | LOC_D04 | San Francisco Bay Edge | 37.8066 | -122.4325 | 2023-12-01T06:20:00 | 1.2 | 2.6 | blank | blank | blank | 12.3 | 90 | San Francisco | Bay |
| SENSOR_020 | unknown | blank | maintenance | LOC_D05 | Houston Remote Sensor | 29.7604 | -95.3698 | 2023-12-01T05:15:00 | 0 | 0 | blank | blank | blank | 10.2 | 30 | Houston | Remote |
What the 120 rows show
from the 120-row sampleNon-compliant (regulatory compliance status) stands out: mean no2 is 38.1, against 9.6 for the rest.
- 12.5median no2
- 19.8median pm2_
5 - 33.3median pm10
- 3.3median so2
- 0.60median co
- 27.8median o3
Median 12.5, from 1.1 to 56.4.
- string 7
- float 10
- datetime 1
Columns
18 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 7 columns | |||
sensor_id | string | Unique identifier for each IoT air quality sensor deviceunique | SENSOR_001 |
location_id | string | Unique identifier for the city location where the sensor is installed | LOC_A01 |
location_name | string | Human-readable name of the sensor location (e.g., intersection, park, district) | Los Angeles Downtown |
regulatory_compliance_status | string | Status indicating if the measurement meets local air quality regulationscompliant · non-compliant · unknown · optional | non-compliant |
sensor_status | string | Operational status of the sensor at the time of measurementactive · inactive · maintenance · error · optional | active |
city | string | City where the sensor is located | Los Angeles |
district | string | District or borough within the city where the sensor is locatedoptional | Downtown |
| Numbers 10 columns | |||
latitude | float | Latitude coordinate of the sensor location-90 to 90 | 34.0522 |
longitude | float | Longitude coordinate of the sensor location-180 to 180 | -118.2437 |
pm2_5 | float | Particulate matter 2.5 microns concentration (μg/m³)0 or more | 58.2 |
pm10 | float | Particulate matter 10 microns concentration (μg/m³)0 or more | 102.7 |
no2 | float | Nitrogen dioxide concentration (ppb)0 or more · optional | 41.2 |
so2 | float | Sulfur dioxide concentration (ppb)0 or more · optional | 12.6 |
co | float | Carbon monoxide concentration (ppm)0 or more · optional | 2.1 |
o3 | float | Ozone concentration (ppb)0 or more · optional | 67.5 |
temperature | float | Ambient temperature at the sensor location (°C)optional | 27.8 |
humidity | float | Relative humidity at the sensor location (%)0 to 100 · optional | 36.2 |
| Dates and times 1 column | |||
measurement_datetime | datetime | Timestamp when the air quality measurement was recorded | 2024-06-19T08:15:00 |
Use it for
A government dashboard
No2 by regulatory_
compliance_ status and a breakdown of sensor_ status. Excel, Power BI or Tableau. Why do the 32 non-compliant rows have a mean no2 of 38.1?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Sensors120SENSOR_00141.2non-comp…SENSOR_00237.5non-comp…SENSOR_00348.1non-comp…
A software demo
Believable sensors with location_
id, location_ name and latitude to fill a screen in front of a buyer.
This dataset120 rows18 columns
Yours1,000 rows18 columnslocation_id: UK only
blueprint · smart-city-air-sensor-trends
Behind this dataset
Same schema. As many rows as you need.
These 120 rows came out of a blueprint — 18 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 sensor location reading
- Sensor readings include PM2.5, NO2, and CO2 levels
- Timestamp resolution at hourly intervals
- Missing or faulty sensor data flagged for review
- City zones mapped to regulatory compliance thresholds
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
- smart-city-air-sensor-trends