Smart City Air Quality Index
This dataset contains daily air quality readings from urban sensors, including pollutant concentrations, Air Quality Index (AQI), precise geolocation, and sensor status. It enables environmental monitoring, health risk modeling, and smart city planning by providing granular, location-based air quality data across urban areas.
Sample rows
preview · 8 of 200 rows · all 19 columns| reading_idstring | sensor_statusstring | pm25float | countrystring | sensor_idstring | sensor_location_namestring | latitudefloat | longitudefloat | citystring | statestring | reading_datedate | aqiinteger | pm10float | cofloat | no2float | so2float | o3float | temperaturefloat | humidityfloat |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| AQ-1000 | active | 13.7 | USA | SENS-A101 | Main St & 5th Ave | 40.7128 | -74.006 | New York | NY | 2024-06-01 | 52 | 29.3 | 1.2 | 19.4 | 4.5 | 18.1 | 22.5 | 68.2 |
| AQ-1001 | active | 55.6 | USA | SENS-B702 | Industrial Park North | 41.8781 | -87.6298 | Chicago | IL | 2024-06-01 | 148 | 88.5 | 4.1 | 40.2 | 15.9 | 36.8 | 29.6 | 41.3 |
| AQ-1002 | active | 18.2 | USA | SENS-C209 | Central Plaza Station | 34.0522 | -118.2437 | Los Angeles | CA | 2024-06-01 | 79 | 36.7 | 2.3 | 27.1 | 7.3 | 22.5 | 27.8 | 54.9 |
| AQ-1003 | active | 11.9 | USA | SENS-D321 | Harbor District | 47.6062 | -122.3321 | Seattle | WA | 2024-06-01 | 42 | 21.4 | 0.8 | 12.6 | 4.1 | 15.7 | 18.7 | 77.1 |
| AQ-1004 | active | 16.2 | USA | SENS-E543 | Downtown Square | 25.7617 | -80.1918 | Miami | FL | 2024-06-01 | 63 | 34.1 | 2.9 | 22.8 | 5.2 | 20.9 | 31.2 | 70.3 |
| AQ-1005 | active | 22.8 | USA | SENS-F601 | Market Promenade | 35.2271 | -80.8431 | Charlotte | NC | 2024-06-01 | 98 | 44.6 | 3.7 | 32.9 | 8.8 | 27.3 | 28 | 49.5 |
| AQ-1006 | active | 9.7 | USA | SENS-G719 | Bay Area Station | 37.7749 | -122.4194 | San Francisco | CA | 2024-06-01 | 39 | 19.6 | 1.1 | 11.3 | 2.8 | 13.2 | 16.9 | 82.4 |
| AQ-1007 | active | 5.2 | USA | SENS-H832 | Highway 100 Junction | 61.2181 | -149.9003 | Anchorage | AK | 2024-06-01 | 27 | 12.8 | 0.6 | 6.7 | 1.9 | 9.4 | 8.1 | 88.7 |
| AQ-1008 | active | 0.1 | Antarctica | SENS-J290 | McMurdo Station | -77.8419 | 166.6863 | McMurdo | Antarctica | 2024-06-01 | 2 | 0.3 | 0 | 0 | 0 | 0 | -28.4 | 100 |
| AQ-1009 | active | 1 | Norway | SENS-K001 | Remote Forest Station | 60.3913 | 5.3221 | Bergen | Finnmark | 2024-06-01 | 8 | 2.6 | 0.2 | 2.1 | 0.6 | 4.5 | 7.6 | 93.5 |
| AQ-1010 | active | 3.3 | USA | SENS-L912 | Mountain Peak Station | 46.8523 | -121.7603 | Paradise | WA | 2024-06-02 | 15 | 8.7 | 0.3 | 3.8 | 1.2 | 7.9 | 3.2 | 97.2 |
| AQ-1011 | active | 82.7 | UAE | SENS-M563 | Desert Outpost | 25.2048 | 55.2708 | Abu Dhabi | Abu Dhabi | 2024-06-02 | 204 | 164.3 | 7.9 | 60.2 | 28.8 | 71.3 | 46.1 | 13.7 |
| AQ-1012 | active | 17.8 | France | SENS-N801 | Riverbank Station | 48.8566 | 2.3522 | Paris | Île-de-France | 2024-06-02 | 72 | 32.4 | 1.7 | 24.6 | 6.8 | 21.6 | 19.3 | 64.8 |
| AQ-1013 | active | 120.3 | India | SENS-O603 | City Market Station | 28.7041 | 77.1025 | Delhi | Delhi | 2024-06-02 | 327 | 242.7 | 11 | 88.6 | 41.2 | 93.8 | 39.2 | 29.6 |
| AQ-1014 | active | 15.6 | UK | SENS-P204 | Greenway Station | 51.5074 | -0.1278 | London | England | 2024-06-02 | 65 | 31.1 | 2.5 | 21.9 | 5.7 | 19.3 | 17.4 | 74.5 |
| AQ-1015 | active | 19.7 | USA | SENS-Q842 | Sunset Boulevard Station | 34.0983 | -118.3267 | Los Angeles | CA | 2024-06-02 | 82 | 39.3 | 2.8 | 28.5 | 8.1 | 23.7 | 26.4 | 52.4 |
| AQ-1016 | active | 70.2 | USA | SENS-R102 | Promenade Station | 33.4484 | -112.074 | Phoenix | AZ | 2024-06-02 | 175 | 137.8 | 6.1 | 52 | 16.3 | 61.9 | 38.5 | 19.7 |
| AQ-1017 | active | 12.6 | Norway | SENS-S221 | City Hall Station | 59.9139 | 10.7522 | Oslo | Oslo | 2024-06-02 | 48 | 25.5 | 1.3 | 15.8 | 3.9 | 17 | 15.2 | 81.6 |
| AQ-1018 | active | 14.1 | Australia | SENS-T808 | Station Street | -33.8688 | 151.2093 | Sydney | NSW | 2024-06-02 | 57 | 28.6 | 2 | 18.2 | 4.7 | 16.9 | 21.7 | 61.2 |
| AQ-1019 | active | 21 | Japan | SENS-U503 | Civic Center Station | 35.6895 | 139.6917 | Tokyo | Tokyo | 2024-06-02 | 94 | 42.1 | 2.6 | 30.4 | 7.8 | 24.2 | 27.9 | 63.4 |
What the 200 rows show
from the 200-row sampleActive (sensor status) stands out: mean pm25 is 21.4, against 232.6 for the rest.
- 14.0median pm25
- 56states
- 56median aqi
- 25.4median pm10
- 2.0median co
- 20.1median no2
Median 14.0, from 0.0 to 475.2.
- string 7
- integer 1
- float 10
- date 1
Columns
19 columns in three groups| column | type | description | example |
|---|---|---|---|
| Text 7 columns | |||
reading_id | string | Unique identifier for each air quality reading recordunique | AQ-1000 |
sensor_id | string | Unique identifier for the sensor device reporting the reading | SENS-A101 |
sensor_location_name | string | Human-readable name or description of the sensor's location (e.g., Main St & 5th Ave) | Main St & 5th Ave |
city | string | City where the sensor is located | New York |
state | string | State or region where the sensor is located | NY |
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 |
| Numbers 11 columns | |||
latitude | float | Latitude coordinate of the sensor location-90 to 90 | 40.7128 |
longitude | float | Longitude coordinate of the sensor location-180 to 180 | -74.006 |
aqi | integer | Air Quality Index value for the location and date0 to 500 | 52 |
pm25 | float | Particulate Matter 2.5 concentration (µg/m³)0 or more | 13.7 |
pm10 | float | Particulate Matter 10 concentration (µg/m³)0 or more | 29.3 |
co | float | Carbon Monoxide concentration (ppm)0 or more | 1.2 |
no2 | float | Nitrogen Dioxide concentration (ppb)0 or more | 19.4 |
so2 | float | Sulfur Dioxide concentration (ppb)0 or more | 4.5 |
o3 | float | Ozone concentration (ppb)0 or more | 18.1 |
temperature | float | Ambient temperature at the sensor location (°C)optional | 22.5 |
humidity | float | Relative humidity at the sensor location (%)0 to 100 · optional | 68.2 |
| Dates and times 1 column | |||
reading_date | date | Date the air quality reading was taken | 2024-06-01 |
Use it for
An energy dashboard
Pm25 by sensor_
status and a breakdown of country. Excel, Power BI or Tableau. Why do the 184 active rows have a mean pm25 of 21.4?
A root-cause class exercise
Hand out the rows and one question. The answer is in the data, not in the brief.
- Readings200AQ-100013.7activeAQ-100155.6activeAQ-100218.2active
A software demo
Believable readings with sensor_
id, sensor_ location_ name and latitude to fill a screen in front of a buyer.
This dataset200 rows19 columns
Yours1,000 rows19 columnssensor_location_name: UK only
blueprint · smart-city-air-quality-index
Behind this dataset
Same schema. As many rows as you need.
These 200 rows came out of a blueprint — 19 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
- Sensor ID and location per record
- AQI values 5-350
- Weather data mapped to readings
- Alert status for high pollution flagged
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-quality-index