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 1172–20211128160501–2020–11–28–2021–11–28

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_1172_20211128160501_2020_11_28_2021_11_28

14.08 MB
2,182,576 rows
7 columns

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

Ecocity 1183–20211127092801–2020–11–27–2021–11–27

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_1183_20211127092801_2020_11_27_2021_11_27

732.48 kB
131,508 rows
7 columns

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

Ecocity 1315–20211127092901–2020–11–27–2021–11–27

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_1315_20211127092901_2020_11_27_2021_11_27

580.38 kB
214,740 rows
7 columns

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

Ecocity 1315–20220211200901–2021–11–11–2022–02–11

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_1315_20220211200901_2021_11_11_2022_02_11

4.23 MB
1,719,210 rows
7 columns

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

Ecocity 20 Minute 1172–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1172_2023

2.07 MB
232,859 rows
5 columns

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

Ecocity 20 Minute 1172–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1172_2024

2.07 MB
232,860 rows
5 columns

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

Ecocity 20 Minute 1315–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1315_2023

1.5 MB
258,459 rows
5 columns

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

Ecocity 20 Minute 1315–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1315_2024

2.28 MB
397,537 rows
5 columns

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

Ecocity 20 Minute 1434–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1434_2023

885.11 kB
101,993 rows
5 columns

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

Ecocity 20 Minute 1434–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1434_2024

885.11 kB
101,993 rows
5 columns

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

Ecocity 20 Minute 1488–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1488_2024

99.18 kB
9,862 rows
5 columns

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

Ecocity 20 Minute 1523–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1523_2023

454.79 kB
55,020 rows
5 columns

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

Ecocity 20 Minute 1523–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1523_2024

706.86 kB
89,052 rows
5 columns

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

Ecocity 20 Minute 154–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_154_2023

952.69 kB
82,120 rows
5 columns

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

Ecocity 20 Minute 154–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_154_2024

952.69 kB
82,120 rows
5 columns

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

Ecocity 20 Minute 1596–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1596_2023

266.09 kB
23,266 rows
5 columns

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

Ecocity 20 Minute 1596–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1596_2024

266.09 kB
23,266 rows
5 columns

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

Ecocity 20 Minute 1612–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1612_2023

267.86 kB
29,418 rows
5 columns

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

Ecocity 20 Minute 1612–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1612_2024

1.04 MB
122,010 rows
5 columns

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

Ecocity 20 Minute 1769–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1769_2023

992.16 kB
118,190 rows
5 columns

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

Ecocity 20 Minute 1769–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1769_2024

1.34 MB
195,185 rows
5 columns

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

Ecocity 20 Minute 1811–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1811_2023

731.98 kB
93,151 rows
5 columns

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

Ecocity 20 Minute 1811–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1811_2024

1.66 MB
201,189 rows
5 columns

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

Ecocity 20 Minute 1813–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1813_2023

526.87 kB
66,133 rows
5 columns

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

Ecocity 20 Minute 1813–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_1813_2024

1.17 MB
139,733 rows
5 columns

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