Baselight

Air Quality Index In Jakarta

Daily Air Quality Index (AQI) in Jakarta from January 2010 - February 2025

@kaggle.senadu34_air_quality_index_in_jakarta_2010_2021

Loading...
Loading...

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

  1. tanggal : The date when the AQI measurement was recorded.
  2. stasiun : The name or identifier of the monitoring station where the measurement was taken.
  3. 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³).
  4. pm10 : The concentration of particulate matter with a diameter of 10 micrometers or less (PM10), measured in micrograms per cubic meter (µg/m³).
  5. so2 : The concentration of sulfur dioxide (SO2), measured in parts per million (ppm).
  6. co : The concentration of carbon monoxide (CO), measured in parts per million (ppm).
  7. o3 : The concentration of ozone (O3), measured in parts per million (ppm).
  8. no2 : The concentration of nitrogen dioxide (NO2), measured in parts per million (ppm).
  9. 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.
  10. critical: The pollutant that had the highest concentration for that date and station.
  11. 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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
Loading...

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
);

Share link

Anyone who has the link will be able to view this.