Dataset: Air Quality Index In Jakarta

About this Dataset

Air Quality Index In Jakarta

Description

This dataset contains the Air Quality Index (AQI) or Indeks Standar Pencemaran Udara (ISPU) measured from 5 air quality monitoring stations (SPKU) in DKI Jakarta from January 2010 to February 2025. This data is sourced from Satu Data Jakarta.

File description

In this dataset, there are 2 types of files:

ispu_dkix: This file represents the AQI measurement results from each monitoring station. The “x” is the station sequence number. This file contains measurements from January 2010 to February 2025 (except 2022).
ispu_dki_all: This file is the combined results of AQI measurements from each station where the highest AQI will represent Jakarta's air quality on that day. This file contains measurement results from January 2010 to February 2025.

Explanation of variables

tanggal : The date when the AQI measurement was recorded.
stasiun : The name or identifier of the monitoring station where the measurement was taken.
pm25 : The concentration of particulate matter with a diameter of 2.5 micrometers or less (PM2.5), measured in micrograms per cubic meter (µg/m³).
pm10 : The concentration of particulate matter with a diameter of 10 micrometers or less (PM10), measured in micrograms per cubic meter (µg/m³).
so2 : The concentration of sulfur dioxide (SO2), measured in parts per million (ppm).
co : The concentration of carbon monoxide (CO), measured in parts per million (ppm).
o3 : The concentration of ozone (O3), measured in parts per million (ppm).
no2 : The concentration of nitrogen dioxide (NO2), measured in parts per million (ppm).
max : The maximum value recorded among the pollutants for that particular date and station. This value represents the highest concentration among PM25, PM10, SO2, CO, O3, and NO2.
critical: The pollutant that had the highest concentration for that date and station.
category : The air quality category based on the 'max' value that describes the air quality level.

Tables

Ispu Dki1

@kaggle.senadu34_air_quality_index_in_jakarta_2010_2021.ispu_dki1

87.59 KB
5173 rows
11 columns


CREATE TABLE ispu_dki1 (
  "tanggal" TIMESTAMP,
  "stasiun" VARCHAR,
  "pm25" DOUBLE,
  "pm10" DOUBLE,
  "so2" DOUBLE,
  "co" DOUBLE,
  "o3" DOUBLE,
  "no2" DOUBLE,
  "max" DOUBLE,
  "critical" VARCHAR,
  "categori" VARCHAR
);

Ispu Dki2

@kaggle.senadu34_air_quality_index_in_jakarta_2010_2021.ispu_dki2

88.59 KB
5173 rows
11 columns


CREATE TABLE ispu_dki2 (
  "tanggal" TIMESTAMP,
  "stasiun" VARCHAR,
  "pm25" DOUBLE,
  "pm10" DOUBLE,
  "so2" DOUBLE,
  "co" DOUBLE,
  "o3" DOUBLE,
  "no2" DOUBLE,
  "max" DOUBLE,
  "critical" VARCHAR,
  "categori" VARCHAR
);

Ispu Dki All

@kaggle.senadu34_air_quality_index_in_jakarta_2010_2021.ispu_dki_all

98.24 KB
5538 rows
11 columns


CREATE TABLE ispu_dki_all (
  "tanggal" TIMESTAMP,
  "stasiun" VARCHAR,
  "pm25" DOUBLE,
  "pm10" DOUBLE,
  "so2" DOUBLE,
  "co" DOUBLE,
  "o3" DOUBLE,
  "no2" DOUBLE,
  "max" DOUBLE,
  "critical" VARCHAR,
  "categori" VARCHAR
);

Ispu Dki4

@kaggle.senadu34_air_quality_index_in_jakarta_2010_2021.ispu_dki4

86.39 KB
5173 rows
11 columns


CREATE TABLE ispu_dki4 (
  "tanggal" TIMESTAMP,
  "stasiun" VARCHAR,
  "pm25" DOUBLE,
  "pm10" DOUBLE,
  "so2" DOUBLE,
  "co" DOUBLE,
  "o3" DOUBLE,
  "no2" DOUBLE,
  "max" DOUBLE,
  "critical" VARCHAR,
  "categori" VARCHAR
);

Ispu Dki5

@kaggle.senadu34_air_quality_index_in_jakarta_2010_2021.ispu_dki5

81.44 KB
5173 rows
11 columns


CREATE TABLE ispu_dki5 (
  "tanggal" TIMESTAMP,
  "stasiun" VARCHAR,
  "pm25" DOUBLE,
  "pm10" DOUBLE,
  "so2" DOUBLE,
  "co" DOUBLE,
  "o3" DOUBLE,
  "no2" DOUBLE,
  "max" DOUBLE,
  "critical" VARCHAR,
  "categori" VARCHAR
);

Ispu Dki3

@kaggle.senadu34_air_quality_index_in_jakarta_2010_2021.ispu_dki3

86.51 KB
5173 rows
11 columns


CREATE TABLE ispu_dki3 (
  "tanggal" TIMESTAMP,
  "stasiun" VARCHAR,
  "pm25" DOUBLE,
  "pm10" DOUBLE,
  "so2" DOUBLE,
  "co" DOUBLE,
  "o3" DOUBLE,
  "no2" DOUBLE,
  "max" DOUBLE,
  "critical" VARCHAR,
  "categori" VARCHAR
);