Name: Air Quality Monitoring From EcoCity
Creator: Kaggle
License: https://creativecommons.org/licenses/by-nd/4.0/

About this Dataset

Air Quality Monitoring From EcoCity

Context

The dataset contains data from public monitoring of air quality in Ukraine (for Vinnytsia city and region - population: 1 575 808, square: 26513 sq. km).

Content

Many stations monitor air quality day and night according to the following indicators:

pm1 - PM1.0 (dust particles with a size of 1 μm), mkg/cub.m
pm25 - PM2.5 (dust particles with a size of 2.5 μm), mkg/cub.m
pm10 - PM10 (dust particles with a size of 10 μm), mkg/cub.m
CO2 - carbon dioxide, mkg/cub.m
temperature - temperature, in degrees Celsius
humidity - Humidity, %
pressure - Pressure, pascals (Pa)

In some stations, there may be additional indicators.

The stations belong to the monitoring network "Eco-City".
Data are measured at intervals of 15 seconds to several minutes (145 seconds or more). Sometimes longer periods of time are possible, due to power outages and/or communications.

Acknowledgments

I thank service "Eco-City" for the opportunity to download data.

Inspiration

It is interesting to solve the following problems, which are typical for other cities and regions around the world:

Analyze the basic patterns of data change in the city or regions as a whole and for each station separately (seasonality, anomalies, etc.).
Forecast data for the following dates, which is easy to check for new data from service "Eco-City". New data in the dataset will be updated periodically.
Forecast the data for the current day. For comparison, they can be downloaded from service "Eco-City" via API.
Compare public monitoring data with state monitoring data available through API.

I will prepare baseline notebooks to solve these problems and invite others to improve them.

Tables

Ecocity Daily 774–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_daily_774_2023

38.37 kB
3,589 rows
5 columns

CREATE TABLE ecocity_daily_774_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Daily 774–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_daily_774_2024

49.27 kB
4,747 rows
5 columns

CREATE TABLE ecocity_daily_774_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Daily 790–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_daily_790_2023

34.44 kB
3,297 rows
5 columns

CREATE TABLE ecocity_daily_790_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Daily 790–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_daily_790_2024

49.79 kB
4,373 rows
5 columns

CREATE TABLE ecocity_daily_790_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Daily 848–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_daily_848_2023

35.83 kB
3,120 rows
5 columns

CREATE TABLE ecocity_daily_848_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Daily 848–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_daily_848_2024

35.83 kB
3,120 rows
5 columns

CREATE TABLE ecocity_daily_848_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1172–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1172_2023

818 kB
78,108 rows
5 columns

CREATE TABLE ecocity_hourly_1172_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1172–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1172_2024

825.45 kB
78,109 rows
5 columns

CREATE TABLE ecocity_hourly_1172_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1315–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1315_2023

611.92 kB
86,649 rows
5 columns

CREATE TABLE ecocity_hourly_1315_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1315–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1315_2024

954.15 kB
133,174 rows
5 columns

CREATE TABLE ecocity_hourly_1315_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1434–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1434_2023

347.26 kB
34,403 rows
5 columns

CREATE TABLE ecocity_hourly_1434_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1434–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1434_2024

347.26 kB
34,403 rows
5 columns

CREATE TABLE ecocity_hourly_1434_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1488–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1488_2024

39.91 kB
3,319 rows
5 columns

CREATE TABLE ecocity_hourly_1488_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1523–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1523_2023

163.65 kB
17,520 rows
5 columns

CREATE TABLE ecocity_hourly_1523_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1523–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1523_2024

303.06 kB
30,030 rows
5 columns

CREATE TABLE ecocity_hourly_1523_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 154–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_154_2023

384.33 kB
28,242 rows
5 columns

CREATE TABLE ecocity_hourly_154_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 154–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_154_2024

384.33 kB
28,242 rows
5 columns

CREATE TABLE ecocity_hourly_154_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1596–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1596_2023

105.23 kB
8,146 rows
5 columns

CREATE TABLE ecocity_hourly_1596_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1596–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1596_2024

105.23 kB
8,146 rows
5 columns

CREATE TABLE ecocity_hourly_1596_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1612–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1612_2023

90.87 kB
8,691 rows
5 columns

CREATE TABLE ecocity_hourly_1612_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1612–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1612_2024

430.51 kB
40,743 rows
5 columns

CREATE TABLE ecocity_hourly_1612_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1769–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1769_2023

413.28 kB
39,335 rows
5 columns

CREATE TABLE ecocity_hourly_1769_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1769–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1769_2024

677.14 kB
65,995 rows
5 columns

CREATE TABLE ecocity_hourly_1769_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1811–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1811_2023

308.73 kB
29,760 rows
5 columns

CREATE TABLE ecocity_hourly_1811_2023 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);

Ecocity Hourly 1811–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_hourly_1811_2024

638.12 kB
67,140 rows
5 columns

CREATE TABLE ecocity_hourly_1811_2024 (
  "id_station" BIGINT,
  "datetime" TIMESTAMP,
  "indicator_name" VARCHAR,
  "indicator_dimension" VARCHAR,
  "value" DOUBLE
);