Air Quality Index In Jakarta

Daily Air Quality Index (AQI) in Jakarta from 2010 - 2023

@kaggle.senadu34_air_quality_index_in_jakarta_2010_2021

Table List

6 tables(449.27 KB)

Ispu Dki1

@kaggle.senadu34_air_quality_index_in_jakarta_2010_2021.ispu_dki1

74.61 KB
4383 rows
11 columns

tanggal Tanggal	stasiun Stasiun	pm10 Pm10	so2 So2	co Co	o3 O3	no2 No2	max Max	critical Critical	categori Categori
Fri Jan 01 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	DKI1 (Bunderan HI)	60	4	73	27	14	73	CO	SEDANG
Sat Jan 02 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	DKI1 (Bunderan HI)	32	2	16	33	9	33	O3	BAIK
Sun Jan 03 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	DKI1 (Bunderan HI)	27	2	19	20	9	27	PM10	BAIK
Mon Jan 04 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	DKI1 (Bunderan HI)	22	2	16	15	6	22	PM10	BAIK
Tue Jan 05 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	DKI1 (Bunderan HI)	25	2	17	15	8	25	PM10	BAIK
Wed Jan 06 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	DKI1 (Bunderan HI)	30	3	22	19	11	30	PM10	BAIK
Thu Jan 07 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	DKI1 (Bunderan HI)	41	4	24	27	13	41	PM10	BAIK
Fri Jan 08 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	DKI1 (Bunderan HI)	64	8	51	19	15	64	PM10	SEDANG
Sat Jan 09 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	DKI1 (Bunderan HI)	55	5	39	23	16	55	PM10	SEDANG
Sun Jan 10 2010 00:00:00 GMT+0000 (Coordinated Universal Time)	DKI1 (Bunderan HI)	34	5	23	26	12	34	PM10	BAIK


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