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 20 Minute 1825–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1825_2023

866.19 kB
102,720 rows
5 columns

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

Ecocity 20 Minute 1825–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1825_2024

1.76 MB
205,396 rows
5 columns

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

Ecocity 20 Minute 1830–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1830_2023

572.62 kB
71,258 rows
5 columns

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

Ecocity 20 Minute 1830–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1830_2024

1.48 MB
175,435 rows
5 columns

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

Ecocity 20 Minute 1834–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1834_2023

675.65 kB
83,306 rows
5 columns

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

Ecocity 20 Minute 1834–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1834_2024

1.57 MB
190,357 rows
5 columns

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

Ecocity 20 Minute 1864–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1864_2023

262.81 kB
28,642 rows
5 columns

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

Ecocity 20 Minute 1864–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1864_2024

965.74 kB
108,698 rows
5 columns

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

Ecocity 20 Minute 1866–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1866_2023

423.31 kB
50,589 rows
5 columns

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

Ecocity 20 Minute 1866–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1866_2024

1.31 MB
158,375 rows
5 columns

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

Ecocity 20 Minute 1872–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1872_2023

279.94 kB
31,104 rows
5 columns

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

Ecocity 20 Minute 1872–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1872_2024

1.03 MB
120,720 rows
5 columns

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

Ecocity 20 Minute 1874–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1874_2023

172.11 kB
18,670 rows
5 columns

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

Ecocity 20 Minute 1874–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1874_2024

401.01 kB
44,678 rows
5 columns

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

Ecocity 20 Minute 1876–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1876_2023

208.82 kB
24,090 rows
5 columns

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

Ecocity 20 Minute 1876–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1876_2024

1.01 MB
116,400 rows
5 columns

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

Ecocity 20 Minute 197–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_197_2023

73.06 kB
7,285 rows
5 columns

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

Ecocity 20 Minute 197–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_197_2024

73.06 kB
7,285 rows
5 columns

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

Ecocity 20 Minute 337–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_337_2023

2.78 MB
322,740 rows
5 columns

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

Ecocity 20 Minute 337–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_337_2024

2.78 MB
322,740 rows
5 columns

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

Ecocity 20 Minute 400–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_400_2023

465.32 kB
47,234 rows
5 columns

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

Ecocity 20 Minute 400–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_400_2024

465.32 kB
47,234 rows
5 columns

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

Ecocity 20 Minute 564–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_564_2023

1.03 MB
105,893 rows
5 columns

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

Ecocity 20 Minute 564–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_564_2024

1.03 MB
105,893 rows
5 columns

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

Ecocity 20 Minute 566–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_566_2023

507.54 kB
52,786 rows
5 columns

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