New Delhi Air Quality

Information about air quality in the Indian capital

@kaggle.anuragbantu_new_delhi_air_quality

Table List

2 tables(26.78 KB)

Newdelhi Air Quality 1

@kaggle.anuragbantu_new_delhi_air_quality.newdelhi_air_quality_1

13.39 KB
72 rows
12 columns

unnamed_0 Unnamed: 0	aqi AQI	co CO	datetime Datetime	no2 No2	o3 O3	pm10 Pm10	pm25 Pm25	so2 So2	timestamp_local Timestamp Local	timestamp_utc Timestamp Utc	ts Ts
	42.600002	198.60268	2022-10-26:14	0.03480818	45.776367	20.490215	10.88934	0.48428774	Wed Oct 26 2022 19:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 14:00:00 GMT+0000 (Coordinated Universal Time)	1666792800
1	35.4	199.60403	2022-10-26:15	0.034607366	45.347214	20.559843	8.720495	0.5066395	Wed Oct 26 2022 20:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 15:00:00 GMT+0000 (Coordinated Universal Time)	1666796400
2	28.2	199.93782	2022-10-26:16	0.034004916	44.631958	20.810652	6.5466533	0.52154064	Wed Oct 26 2022 21:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 16:00:00 GMT+0000 (Coordinated Universal Time)	1666800000
3	21	200.2716	2022-10-26:17	0.033469405	44.345856	20.712862	4.397015	0.5289912	Wed Oct 26 2022 22:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 17:00:00 GMT+0000 (Coordinated Universal Time)	1666803600
4	20	201.94054	2022-10-26:18	0.033469405	43.988228	20.244165	4.394664	0.5364418	Wed Oct 26 2022 23:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 18:00:00 GMT+0000 (Coordinated Universal Time)	1666807200
5	20	205.2784	2022-10-26:19	0.033469405	43.988228	20.306908	4.457184	0.5364418	Thu Oct 27 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 19:00:00 GMT+0000 (Coordinated Universal Time)	1666810800
6	21	206.94733	2022-10-26:20	0.033469405	44.345856	20.308283	4.4578876	0.5364418	Thu Oct 27 2022 01:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 20:00:00 GMT+0000 (Coordinated Universal Time)	1666814400
7	21	208.61626	2022-10-26:21	0.0338041	44.345856	20.545723	4.461374	0.5364418	Thu Oct 27 2022 02:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 21:00:00 GMT+0000 (Coordinated Universal Time)	1666818000
8	21	210.28519	2022-10-26:22	0.0338041	44.703484	20.495142	4.4098935	0.5438924	Thu Oct 27 2022 03:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 22:00:00 GMT+0000 (Coordinated Universal Time)	1666821600
9	21	210.28519	2022-10-26:23	0.033469405	44.345856	20.727442	4.4095955	0.55134296	Thu Oct 27 2022 04:00:00 GMT+0000 (Coordinated Universal Time)	Wed Oct 26 2022 23:00:00 GMT+0000 (Coordinated Universal Time)	1666825200


CREATE TABLE newdelhi_air_quality_1 (
  "unnamed_0" BIGINT,
  "aqi" DOUBLE,
  "co" DOUBLE,
  "datetime" VARCHAR,
  "no2" DOUBLE,
  "o3" DOUBLE,
  "pm10" DOUBLE,
  "pm25" DOUBLE,
  "so2" DOUBLE,
  "timestamp_local" TIMESTAMP,
  "timestamp_utc" TIMESTAMP,
  "ts" BIGINT
);