2001-2022 Hourly Dataset Of Pollution In Madrid

Time series of hourly pollution with 14 variables from Escuelas Aguirre, Madrid

@kaggle.ignacioqg_20012022_hourly_dataset_of_pollution_in_madrid

Table List

1 table(2.85 MB)

Madridpolution2001–2022

Madridpolution2001–2022

@kaggle.ignacioqg_20012022_hourly_dataset_of_pollution_in_madrid.madridpolution2001_2022

2.85 MB
172622 rows
15 columns

time Time	ben BEN	co CO	ebe EBE	no NO	no2 NO2	nox NOx	o3 O3	pm10 PM10	so2 SO2	tol TOL
Mon Jan 01 2001 00:00:00 GMT+0000 (Coordinated Universal Time)	4		2	66	67	168	7	32	26	11
Mon Jan 01 2001 01:00:00 GMT+0000 (Coordinated Universal Time)	9		5	146	71	294	7	41	21	21
Mon Jan 01 2001 02:00:00 GMT+0000 (Coordinated Universal Time)	9		5	190	73	364	7	50	22	24
Mon Jan 01 2001 03:00:00 GMT+0000 (Coordinated Universal Time)	10		5	170	75	335	7	55	19	25
Mon Jan 01 2001 04:00:00 GMT+0000 (Coordinated Universal Time)	8		4	102	67	224	8	42	14	21
Mon Jan 01 2001 05:00:00 GMT+0000 (Coordinated Universal Time)	3	1	2	63	60	157	8	21	10	10
Mon Jan 01 2001 06:00:00 GMT+0000 (Coordinated Universal Time)	2		1	28	47	90	17	14	8	6
Mon Jan 01 2001 07:00:00 GMT+0000 (Coordinated Universal Time)	2	1	1	33	43	93	21	13	8	6
Mon Jan 01 2001 08:00:00 GMT+0000 (Coordinated Universal Time)	2	1	1	36	49	105	20	17	8	6
Mon Jan 01 2001 09:00:00 GMT+0000 (Coordinated Universal Time)	2	1	1	25	43	82	24	15	7	5


CREATE TABLE madridpolution2001_2022 (
  "time" TIMESTAMP,
  "ben" DOUBLE,
  "ch4" DOUBLE,
  "co" DOUBLE,
  "ebe" DOUBLE,
  "nmhc" DOUBLE,
  "no" DOUBLE,
  "no2" DOUBLE,
  "nox" DOUBLE,
  "o3" DOUBLE,
  "pm10" DOUBLE,
  "pm25" DOUBLE,
  "so2" DOUBLE,
  "tch" DOUBLE,
  "tol" DOUBLE
);