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.

  • last updated 1 Feb 2026
  • by GoMask
The brief that made it

Urban pollution trend analysis and hotspot mapping

Sample rows

preview · 8 of 150 rows · all 20 columns
reading_idstringsensor_typestringvaluefloatis_anomalybooleanlocation_statestringsensor_idstringreading_datetimedatetimeunitstringlocation_latitudefloatlocation_longitudefloatlocation_street_addressstringlocation_citystringlocation_postal_codestringlocation_countrystringsensor_statusstringcalibration_datedatetemperature_celsiusfloathumidity_percentfloatdata_sourcestringnotesstring
RD-0001APM2.513.5falseCASENS-1012024-05-01T07:30:00Zµg/m³34.0522-118.24371200 N Main StLos Angeles90012USAactive2024-03-2018.142EnviroSysblank
RD-0002BPM1018.9falseNYSENS-1022024-05-01T07:45:00Zµg/m³40.7127-74.0059233 BroadwayNew York10007USAactive2024-04-0216.738.4EnviroSysblank
RD-0003CNO20.042falseblankSENS-1032024-05-01T08:00:00Zppm51.5074-0.127810 Downing StLondonSW1A2AAUKactive2024-02-2214.462.3BritSensorsblank
RD-0004DCO2750falseblankSENS-1042024-05-01T08:15:00Zppm35.6895139.69173 Chome-1-1 MarunouchiTokyo100-0005Japanactive2024-03-0121.553JPN-Sensorsblank
RD-0005EO30.03falseNSWSENS-1052024-05-01T08:30:00Zppm-33.8688151.20931 Macquarie StSydney2000Australiaactive2024-02-1526.148.5AUS-Airblank
RD-0006FSO20.1falseblankSENS-1062024-05-01T08:45:00Zppm48.85662.35225 Rue de RivoliParis75001Franceactive2024-03-101357.2FrAirTechblank
RD-0007GCO0.7falseblankSENS-1072024-05-01T09:00:00Zppm55.755837.61731 Red SquareMoscow101000Russiaactive2024-04-01970.3RusCleanAirblank
RD-0008HOther3.6falseblankSENS-1082024-05-01T09:15:00Zmg/m³19.4326-99.1332Av. Paseo de la Reforma 1Mexico City06500Mexicoactive2024-03-1222.546LatinoAirblank

What the 150 rows show

from the 150-row sample

Other (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
Mean value by sensor_type150 rows
020k40k68.6PM2…20 r…45.4PM1021 r…0.04NO219 r…2.4CO18 r…0.02O317 r…1.2SO219 r…754.0CO218 r…22,426Oth…18 r…
value150 rows, in bands of 10k
075150146000000004050k100kvalue →

Median 4.0, from 0.0 to 100,000.

location_state42 rows with a value · 108 left blank
  1. CA9
  2. NY5
  3. IL4
  4. NC4
  5. NSW3
  6. ON3
  7. SP2
  8. BA2
  9. FL2
  10. AZ1
20 columns by typefrom the column list below
  • string 12
  • float 5
  • date 1
  • datetime 1
  • boolean 1

Columns

20 columns in four groups
blueprint · 20 columns
columntypedescriptionexample
Text 12 columns
reading_idstringUnique identifier for each air sensor reading recorduniqueRD-0001A
sensor_idstringUnique identifier for the IoT sensor deviceSENS-101
sensor_typestringType of sensor (e.g., PM2.5, NO2, CO2, Ozone)8 valuesPM2.5
unitstringUnit of measurement for the sensor value (e.g., µg/m³, ppm)µg/m³ · ppm · ppb · mg/m³ · Otherµg/m³
location_street_addressstringStreet address of the sensor's locationoptional1200 N Main St
location_citystringCity where the sensor is locatedLos Angeles
location_statestringState or province where the sensor is locatedoptionalCA
location_postal_codestringPostal code of the sensor's locationoptional90012
location_countrystringCountry where the sensor is locatedUSA
sensor_statusstringOperational status of the sensor at the time of readingactive · inactive · maintenance · erroractive
data_sourcestringSource system or vendor of the sensor dataoptionalEnviroSys
notesstringAdditional notes or comments about the readingoptionalBoundary latitude value
Numbers 5 columns
valuefloatMeasured value from the sensor (e.g., micrograms/m³, ppm)0 or more13.5
location_latitudefloatLatitude of the sensor's location-90 to 9034.0522
location_longitudefloatLongitude of the sensor's location-180 to 180-118.2437
temperature_celsiusfloatAmbient temperature at the sensor location (in Celsius)-50 to 60 · optional18.1
humidity_percentfloatAmbient relative humidity at the sensor location (percentage)0 to 100 · optional42
Dates and times 2 columns
reading_datetimedatetimeTimestamp when the sensor reading was taken (UTC)2024-05-01T07:30:00Z
calibration_datedateDate when the sensor was last calibratedoptional2024-03-20
True or false 1 column
is_anomalybooleanFlag indicating if the reading is detected as an anomalyoptionalfalse

Use it for

  • is anomaly25%38 of 150 rowsmean value by sensor …68.6PM2.545.4PM100.04NO22.4CO

    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.

  • A software demo

    Believable readings with sensor_id, sensor_type and reading_datetime to fill a screen in front of a buyer.

Not quite right?

Make it yours.

Same 20 columns, your size and your rules. See 20 rows before you pay.

Preview 20 rows free

10,000 rows of yours: $12.99One-time. No subscription. All prices

This dataset150 rows20 columns
Yours10,000 rows20 columnslocation_latitude: UK only

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.

Rules it was built with
  • 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.
Rows
Open the blueprint in Data Factory

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

What should your data show?

Preview 20 rows free
No signup. No card.