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
Daily Air Quality Index (AQI) in Jakarta from January 2010 - February 2025
@kaggle.senadu34_air_quality_index_in_jakarta_2010_2021
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
);
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
);
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
);
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
);
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
);
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
);
Anyone who has the link will be able to view this.