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 566–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_566_2024

507.54 kB
52,786 rows
5 columns

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

Ecocity 20 Minute 611–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_611_2023

864.63 kB
88,055 rows
5 columns

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

Ecocity 20 Minute 611–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_611_2024

864.63 kB
88,055 rows
5 columns

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

Ecocity 20 Minute 650–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_650_2023

3.34 MB
365,944 rows
5 columns

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

Ecocity 20 Minute 650–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_650_2024

4.09 MB
454,699 rows
5 columns

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

Ecocity 20 Minute 767–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_767_2023

2.01 MB
255,325 rows
5 columns

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

Ecocity 20 Minute 767–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_767_2024

2.33 MB
300,902 rows
5 columns

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

Ecocity 20 Minute 774–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_774_2023

2.01 MB
248,714 rows
5 columns

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

Ecocity 20 Minute 774–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_774_2024

2.57 MB
327,508 rows
5 columns

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

Ecocity 20 Minute 790–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_790_2023

1.82 MB
226,014 rows
5 columns

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

Ecocity 20 Minute 790–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_790_2024

2.4 MB
299,109 rows
5 columns

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

Ecocity 20 Minute 848–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_848_2023

1.54 MB
160,059 rows
5 columns

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

Ecocity 20 Minute 848–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_20_minute_848_2024

1.54 MB
160,059 rows
5 columns

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

Ecocity 337–20211127092201–2020–11–27–2021–11–27

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_337_20211127092201_2020_11_27_2021_11_27

12.83 MB
2,232,519 rows
7 columns

CREATE TABLE ecocity_337_20211127092201_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 650–20211128160601–2020–11–28–2021–11–28

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_650_20211128160601_2020_11_28_2021_11_28

12.93 MB
2,163,414 rows
7 columns

CREATE TABLE ecocity_650_20211128160601_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 761–20211127092301–2020–11–27–2021–11–27

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_761_20211127092301_2020_11_27_2021_11_27

16.44 MB
2,970,929 rows
7 columns

CREATE TABLE ecocity_761_20211127092301_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 767–20211127092401–2020–11–27–2021–11–27

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_767_20211127092401_2020_11_27_2021_11_27

5.48 MB
887,040 rows
7 columns

CREATE TABLE ecocity_767_20211127092401_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 774–20211127092501–2020–11–27–2021–11–27

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_774_20211127092501_2020_11_27_2021_11_27

229.39 kB
39,632 rows
7 columns

CREATE TABLE ecocity_774_20211127092501_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 790–20211127092601–2020–11–27–2021–11–27

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_790_20211127092601_2020_11_27_2021_11_27

214.71 kB
36,522 rows
7 columns

CREATE TABLE ecocity_790_20211127092601_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 848–20211127092701–2020–11–27–2021–11–27

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_848_20211127092701_2020_11_27_2021_11_27

9.62 MB
1,628,766 rows
7 columns

CREATE TABLE ecocity_848_20211127092701_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 About Stations 2021

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_about_stations_2021

8.51 kB
10 rows
10 columns

CREATE TABLE ecocity_about_stations_2021 (
  "id_saveecobot" DOUBLE,
  "id_ecocity" BIGINT,
  "network" VARCHAR,
  "locality" VARCHAR,
  "address" VARCHAR,
  "start_date" VARCHAR,
  "lat" DOUBLE,
  "lng" DOUBLE,
  "notes" VARCHAR,
  "source" VARCHAR
);

Ecocity Archive 651–561–2024–03–25–2024–05–10

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_archive_651_561_2024_03_25_2024_05_10

132.87 kB
19,646 rows
8 columns

CREATE TABLE ecocity_archive_651_561_2024_03_25_2024_05_10 (
  "n_1315" BIGINT  -- 1315,
  "n_49_23327_28_409161" VARCHAR  -- 49.23327–28.409161,
  "n_2024_03_25" TIMESTAMP  -- 2024-03-25,
  "n_01" BIGINT  -- 01,
  "n_18" BIGINT  -- 18,
  "pm1_0" VARCHAR,
  "ug_m3" VARCHAR,
  "n_26_8422" DOUBLE  -- 26.8422
);

Ecocity Daily 1172–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_daily_1172_2023

38.87 kB
3,375 rows
5 columns

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

Ecocity Daily 1172–2024

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_daily_1172_2024

38.86 kB
3,376 rows
5 columns

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

Ecocity Daily 1315–2023

@kaggle.vbmokin_air_quality_monitoring_from_ecocity.ecocity_daily_1315_2023

35.87 kB
3,891 rows
5 columns

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