Smart City Sensor Event Streams
This dataset aggregates real-time event streams from diverse IoT sensors deployed across urban environments, capturing air quality, noise, light, and pedestrian flow metrics with precise geolocation and timestamping. It enables advanced urban monitoring, anomaly detection, and data-driven resource allocation for smart city initiatives. The dataset's granular, multi-modal structure supports both operational dashboards and in-depth analytics for city planners and researchers.
Sample rows
preview · 8 of 200 rows · all 16 columns| event_idstring | statusstring | battery_levelfloat | sensor_typestring | sensor_idstring | event_timestampdatetime | location_latitudefloat | location_longitudefloat | location_descriptionstring | air_quality_pm25float | air_quality_pm10float | air_quality_no2float | noise_level_dbfloat | light_level_luxfloat | pedestrian_countinteger | firmware_versionstring |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| EVT00001 | normal | 82.5 | air_quality | SEN_AQ_001 | 2021-03-15T09:17:00Z | 40.748817 | -73.985428 | 5th Ave & W 34th St, NYC | 18.6 | 28.1 | 20.4 | blank | blank | blank | 2.3.1 |
| EVT00002 | anomaly | 10.3 | noise | SEN_NI_004 | 2022-08-01T17:54:00Z | 35.689487 | 139.691706 | Shibuya Crossing, Tokyo | blank | blank | blank | 91.7 | blank | blank | 1.4.0 |
| EVT00003 | normal | 90.2 | light | SEN_LI_002 | 2023-05-10T11:35:00Z | 48.85837 | 2.294481 | Eiffel Tower Plaza, Paris | blank | blank | blank | blank | 15500 | blank | 3.2.0 |
| EVT00004 | normal | 87.9 | pedestrian_flow | SEN_PF_003 | 2021-12-31T23:59:59Z | 51.507351 | -0.127758 | Piccadilly Circus, London | blank | blank | blank | blank | blank | 183 | 3.3.3 |
| EVT00005 | anomaly | 91.5 | pedestrian_flow | SEN_PF_008 | 2022-03-01T16:20:00Z | 37.774929 | -122.419416 | Market St & 5th St, San Francisco | blank | blank | blank | blank | blank | 982 | 3.0.1 |
| EVT00006 | anomaly | 13.8 | air_quality | SEN_AQ_005 | 2023-01-13T03:11:00Z | 28.613939 | 77.209021 | Connaught Place, New Delhi | 112.2 | 315.6 | 31.7 | blank | blank | blank | 2.8.2 |
| EVT00007 | normal | 78.1 | noise | SEN_NI_009 | 2023-03-15T12:00:00Z | 34.052234 | -118.243685 | Pershing Square, Los Angeles | blank | blank | blank | 44.2 | blank | blank | 2.6.7 |
| EVT00008 | anomaly | 99.7 | light | SEN_LI_010 | 2022-09-06T22:02:00Z | -33.86882 | 151.209296 | Circular Quay, Sydney | blank | blank | blank | blank | 22800.5 | blank | 3.0.8 |
| EVT00009 | offline | 0 | air_quality | SEN_AQ_004 | 2022-10-10T00:00:00Z | 55.755826 | 37.6173 | Red Square, Moscow | 0 | 0 | 0 | blank | blank | blank | 1.9.1 |
| EVT00010 | error | 0.2 | noise | SEN_NI_011 | 2023-06-21T18:30:00Z | 52.520007 | 13.404954 | Alexanderplatz, Berlin | blank | blank | blank | 0 | blank | blank | 2.0.3 |
| EVT00011 | anomaly | 100 | light | SEN_LI_015 | 2022-12-25T12:10:00Z | 1.352083 | 103.819836 | Marina Bay, Singapore | blank | blank | blank | blank | 100000 | blank | 3.1.2 |
| EVT00012 | normal | 83.4 | pedestrian_flow | SEN_PF_012 | 2023-02-01T15:45:00Z | 41.902783 | 12.496366 | Piazza Venezia, Rome | blank | blank | blank | blank | blank | 321 | 3.1.1 |
| EVT00013 | normal | 76.8 | air_quality | SEN_AQ_007 | 2021-11-11T11:11:11Z | 39.9042 | 116.407396 | Tiananmen Square, Beijing | 41.8 | 65.7 | 25.1 | blank | blank | blank | 2.2.5 |
| EVT00014 | anomaly | 4.7 | noise | SEN_NI_013 | 2023-07-04T22:22:00Z | 34.693738 | 135.502165 | Dotonbori, Osaka | blank | blank | blank | 121 | blank | blank | 2.5.4 |
| EVT00015 | normal | 65.9 | light | SEN_LI_017 | 2022-06-15T14:00:00Z | 51.165691 | 10.451526 | Brandenburg Gate, Berlin | blank | blank | blank | blank | 1200 | blank | 3.2.1 |
| EVT00016 | offline | 0 | pedestrian_flow | SEN_PF_021 | 2022-07-01T08:40:00Z | 55.953252 | -3.188267 | Princes St & Waverley Bridge, Edinburgh | blank | blank | blank | blank | blank | 0 | 1.1.0 |
| EVT00017 | normal | 72.6 | air_quality | SEN_AQ_008 | 2023-04-02T10:15:00Z | -23.55052 | -46.633308 | Paulista Ave, São Paulo | 36.5 | 55.8 | 17.3 | blank | blank | blank | 2.9.6 |
| EVT00018 | normal | 59.8 | noise | SEN_NI_014 | 2022-04-30T01:59:00Z | 41.385064 | 2.173404 | La Rambla, Barcelona | blank | blank | blank | 73.5 | blank | blank | 2.6.3 |
| EVT00019 | normal | 62.1 | light | SEN_LI_021 | 2023-08-15T13:47:00Z | 19.432608 | -99.133209 | Zócalo, Mexico City | blank | blank | blank | blank | 506 | blank | 3.3.2 |
| EVT00020 | normal | 79.2 | pedestrian_flow | SEN_PF_027 | 2023-01-01T00:01:00Z | -33.924869 | 18.424055 | Long Street, Cape Town | blank | blank | blank | blank | blank | 64 | 3.2.9 |
What the 200 rows show
from the 200-row sampleOffline status stands out: mean battery_
- 71.2median battery_
level - 17.3median air_
quality_ pm25 - 33.0median air_
quality_ pm10 - 18.8median air_
quality_ no2 - 59.8median noise_
level_ db - 15,200median light_
level_ lux
Median 71.2, from 0.0 to 100.0.
- string 6
- integer 1
- float 8
- datetime 1
Columns
16 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 6 columns | |||
event_id | string | Unique identifier for each sensor event recordunique | EVT00001 |
sensor_id | string | Unique identifier for the physical IoT sensor device | SEN_AQ_001 |
sensor_type | string | Type of sensor reporting the event (e.g., air_quality, noise, light, pedestrian_flow)air_quality · noise · light · pedestrian_flow | air_quality |
location_description | string | Human-readable description of the sensor location (e.g., 'Main St & 3rd Ave')optional | 5th Ave & W 34th St, NYC |
status | string | Status of the sensor event (e.g., normal, anomaly, offline, error)normal · anomaly · offline · error · optional | normal |
firmware_version | string | Firmware version of the sensor deviceoptional | 2.3.1 |
| Numbers 9 columns | |||
location_latitude | float | Latitude coordinate of the sensor location-90 to 90 | 40.748817 |
location_longitude | float | Longitude coordinate of the sensor location-180 to 180 | -73.985428 |
air_quality_pm25 | float | Particulate matter 2.5 concentration (µg/m³) if sensor_type is air_quality0 or more · optional | 18.6 |
air_quality_pm10 | float | Particulate matter 10 concentration (µg/m³) if sensor_type is air_quality0 or more · optional | 28.1 |
air_quality_no2 | float | Nitrogen dioxide concentration (ppb) if sensor_type is air_quality0 or more · optional | 20.4 |
noise_level_db | float | Noise level in decibels (dB) if sensor_type is noise0 or more · optional | 91.7 |
light_level_lux | float | Ambient light level in lux if sensor_type is light0 or more · optional | 15500 |
pedestrian_count | integer | Number of pedestrians detected in the event interval if sensor_type is pedestrian_flow0 or more · optional | 183 |
battery_level | float | Battery level of the sensor at the time of event (percentage, 0-100)0 to 100 · optional | 82.5 |
| Dates and times 1 column | |||
event_timestamp | datetime | Date and time when the sensor event was recorded (UTC) | 2021-03-15T09:17:00Z |
Use it for
A technology dashboard
Battery_
level by status and a breakdown of sensor_ type. Excel, Power BI or Tableau. Why do the 18 offline rows have a mean battery_
level of 0.04? A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Events200EVT0000182.5normalEVT0000210.3anomalyEVT0000390.2normal
A software demo
Believable events with sensor_
id, sensor_ type and event_ timestamp to fill a screen in front of a buyer.
blueprint · smart-city-sensor-event-streams
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 16 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.
- Sensor outages randomly simulated
- Readings show time and spatial correlation
- Anomalous spikes indicate events
- Different sensor types follow unique sampling rates
- Maintenance logs included
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-sensor-event-streams