Municipal Air Sensor Readings Log
This dataset contains granular air quality measurements from municipal IoT sensors, including pollutant concentrations, environmental conditions, and sensor metadata. Designed for smart city analytics, it enables urban planners and IT teams to monitor pollution trends, detect anomalies, and support ESG reporting for healthier communities.
Sample rows
preview · 8 of 150 rows · all 20 columns| reading_idstring | sensor_typestring | valuefloat | is_anomalyboolean | location_statestring | sensor_idstring | reading_datetimedatetime | unitstring | location_latitudefloat | location_longitudefloat | location_street_addressstring | location_citystring | location_postal_codestring | location_countrystring | sensor_statusstring | calibration_datedate | temperature_celsiusfloat | humidity_percentfloat | data_sourcestring | notesstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| RD-0001A | PM2.5 | 13.5 | false | CA | SENS-101 | 2024-05-01T07:30:00Z | µg/m³ | 34.0522 | -118.2437 | 1200 N Main St | Los Angeles | 90012 | USA | active | 2024-03-20 | 18.1 | 42 | EnviroSys | blank |
| RD-0002B | PM10 | 18.9 | false | NY | SENS-102 | 2024-05-01T07:45:00Z | µg/m³ | 40.7127 | -74.0059 | 233 Broadway | New York | 10007 | USA | active | 2024-04-02 | 16.7 | 38.4 | EnviroSys | blank |
| RD-0003C | NO2 | 0.042 | false | blank | SENS-103 | 2024-05-01T08:00:00Z | ppm | 51.5074 | -0.1278 | 10 Downing St | London | SW1A2AA | UK | active | 2024-02-22 | 14.4 | 62.3 | BritSensors | blank |
| RD-0004D | CO2 | 750 | false | blank | SENS-104 | 2024-05-01T08:15:00Z | ppm | 35.6895 | 139.6917 | 3 Chome-1-1 Marunouchi | Tokyo | 100-0005 | Japan | active | 2024-03-01 | 21.5 | 53 | JPN-Sensors | blank |
| RD-0005E | O3 | 0.03 | false | NSW | SENS-105 | 2024-05-01T08:30:00Z | ppm | -33.8688 | 151.2093 | 1 Macquarie St | Sydney | 2000 | Australia | active | 2024-02-15 | 26.1 | 48.5 | AUS-Air | blank |
| RD-0006F | SO2 | 0.1 | false | blank | SENS-106 | 2024-05-01T08:45:00Z | ppm | 48.8566 | 2.3522 | 5 Rue de Rivoli | Paris | 75001 | France | active | 2024-03-10 | 13 | 57.2 | FrAirTech | blank |
| RD-0007G | CO | 0.7 | false | blank | SENS-107 | 2024-05-01T09:00:00Z | ppm | 55.7558 | 37.6173 | 1 Red Square | Moscow | 101000 | Russia | active | 2024-04-01 | 9 | 70.3 | RusCleanAir | blank |
| RD-0008H | Other | 3.6 | false | blank | SENS-108 | 2024-05-01T09:15:00Z | mg/m³ | 19.4326 | -99.1332 | Av. Paseo de la Reforma 1 | Mexico City | 06500 | Mexico | active | 2024-03-12 | 22.5 | 46 | LatinoAir | blank |
| RD-0009I | PM2.5 | 95.9 | false | blank | SENS-109 | 2024-05-01T09:30:00Z | µg/m³ | 35.6762 | 139.6503 | 2-4-1 Nihonbashi | Tokyo | 103-0027 | Japan | active | 2024-04-28 | 20.8 | 51.7 | JPN-Sensors | blank |
| RD-0010J | PM10 | 0 | true | blank | SENS-110 | 2024-05-01T09:45:00Z | µg/m³ | 52.52 | 13.405 | Pariser Platz 1 | Berlin | 10117 | Germany | active | 2024-03-29 | 15.2 | 49.8 | AirQ | Zero PM10 detected; sensor possible calibration drift. |
| RD-0011K | NO2 | 0.001 | false | blank | SENS-111 | 2024-05-01T10:00:00Z | ppb | 28.6139 | 77.209 | Rajpath | Delhi | 110001 | India | active | 2024-03-25 | 32.4 | 34.7 | IndiAir | blank |
| RD-0012L | CO2 | 1350 | false | SP | SENS-112 | 2024-05-01T10:15:00Z | ppm | -23.5505 | -46.6333 | Av. Paulista 1578 | São Paulo | 01310-200 | Brazil | active | 2024-04-10 | 27 | 68 | BrAirNet | blank |
| RD-0013M | O3 | 0 | true | blank | SENS-113 | 2024-05-01T10:30:00Z | mg/m³ | 59.3293 | 18.0686 | Stortorget 2 | Stockholm | 11129 | Sweden | active | 2024-03-06 | 9.4 | 71.2 | NordicSensors | Ozone sensor returned zero; possible blocked intake. |
| RD-0014N | SO2 | 0.0001 | false | blank | SENS-114 | 2024-05-01T10:45:00Z | ppb | 60.1699 | 24.9384 | Mannerheimintie 12 | Helsinki | 00100 | Finland | active | 2024-03-02 | 5.3 | 82.1 | FinnAir | blank |
| RD-0015O | CO | 9.99 | false | blank | SENS-115 | 2024-05-01T11:00:00Z | Other | 25.2048 | 55.2708 | Sheikh Zayed Rd | Dubai | blank | UAE | active | 2024-04-05 | 42.1 | 18.8 | MEAir | blank |
| RD-0016P | Other | 99999.9 | true | blank | SENS-116 | 2024-05-01T11:15:00Z | ppb | -90 | 0 | blank | Antarctica | blank | Antarctica | active | 2024-01-15 | -49.9 | 10.5 | PolarNet | Boundary value anomaly: sensor at south pole. |
| RD-0017Q | PM2.5 | 250 | true | IL | SENS-117 | 2024-05-01T11:30:00Z | µg/m³ | 41.8781 | -87.6298 | 233 S Wacker Dr | Chicago | 60606 | USA | active | 2024-04-18 | 15.8 | 44.2 | EnviroSys | High PM2.5 event; possible wildfire smoke. |
| RD-0018R | PM10 | 180.2 | true | blank | SENS-118 | 2024-05-01T11:45:00Z | µg/m³ | 40.4168 | -3.7038 | Plaza Mayor 1 | Madrid | 28012 | Spain | active | 2024-04-01 | 19.4 | 36.6 | AirQ | High PM10 detected after construction activities. |
| RD-0019S | NO2 | 0.098 | false | CA | SENS-101 | 2024-05-01T12:00:00Z | mg/m³ | 34.0522 | -118.2437 | 1200 N Main St | Los Angeles | 90012 | USA | active | 2024-04-20 | 19.2 | 41.5 | EnviroSys | blank |
| RD-0020T | SO2 | 5 | false | blank | SENS-119 | 2024-05-01T12:15:00Z | mg/m³ | 45.4642 | 9.19 | Piazza del Duomo | Milan | 20122 | Italy | active | 2024-03-09 | 16.5 | 68.9 | EnviroSys | blank |
What the 150 rows show
from the 150-row sampleOther (sensor type) stands out: mean value is 22,426, against 120.9 for the rest.
- 25%is_
anomaly = true - 4.0median value
- 4sensor statuses
- 5units
- 18data sources
- 32location countries
Median 4.0, from 0.0 to 100,000.
- string 12
- float 5
- date 1
- datetime 1
- boolean 1
Columns
20 columns in four groups| column | type | description | example |
|---|---|---|---|
| Text 12 columns | |||
reading_id | string | Unique identifier for each air sensor reading recordunique | RD-0001A |
sensor_id | string | Unique identifier for the IoT sensor device | SENS-101 |
sensor_type | string | Type of sensor (e.g., PM2.5, NO2, CO2, Ozone)8 values | PM2.5 |
unit | string | Unit of measurement for the sensor value (e.g., µg/m³, ppm)µg/m³ · ppm · ppb · mg/m³ · Other | µg/m³ |
location_street_address | string | Street address of the sensor's locationoptional | 1200 N Main St |
location_city | string | City where the sensor is located | Los Angeles |
location_state | string | State or province where the sensor is locatedoptional | CA |
location_postal_code | string | Postal code of the sensor's locationoptional | 90012 |
location_country | string | Country where the sensor is located | USA |
sensor_status | string | Operational status of the sensor at the time of readingactive · inactive · maintenance · error | active |
data_source | string | Source system or vendor of the sensor dataoptional | EnviroSys |
notes | string | Additional notes or comments about the readingoptional | Boundary latitude value |
| Numbers 5 columns | |||
value | float | Measured value from the sensor (e.g., micrograms/m³, ppm)0 or more | 13.5 |
location_latitude | float | Latitude of the sensor's location-90 to 90 | 34.0522 |
location_longitude | float | Longitude of the sensor's location-180 to 180 | -118.2437 |
temperature_celsius | float | Ambient temperature at the sensor location (in Celsius)-50 to 60 · optional | 18.1 |
humidity_percent | float | Ambient relative humidity at the sensor location (percentage)0 to 100 · optional | 42 |
| Dates and times 2 columns | |||
reading_datetime | datetime | Timestamp when the sensor reading was taken (UTC) | 2024-05-01T07:30:00Z |
calibration_date | date | Date when the sensor was last calibratedoptional | 2024-03-20 |
| True or false 1 column | |||
is_anomaly | boolean | Flag indicating if the reading is detected as an anomalyoptional | false |
Use it for
A government dashboard
The is_
anomaly rate, value by sensor_ type and a breakdown of location_ state. Excel, Power BI or Tableau. Why do the 18 Other rows have a mean value of 22,426?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Readings150RD-0001A13.5PM2.5RD-0010J0PM10RD-0013M0O3
A software demo
Believable readings with sensor_
id, sensor_ type and reading_ datetime to fill a screen in front of a buyer.
blueprint · municipal-air-sensor-readings-log
Behind this dataset
Same schema. As many rows as you need.
These 150 rows came out of a blueprint — 20 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.
- Each row records readings from a unique sensor location and timestamp.
- Pollutant levels (PM2.5, NO2, O3, CO) are captured in standardized units.
- Sensor status includes operational flags and error notifications.
- Weather factors (temperature, humidity) are logged for context.
- Data must include maintenance events when sensors are serviced.
1 credit per row. New accounts start with 25 free credits.
- Exports
- CSV, JSON, JSONL, Parquet, SQL, Excel, TSV, XML
- Licence
- yours to use, including commercially
- API slug
- municipal-air-sensor-readings-log