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

@kaggle.anuragbantu_new_delhi_air_quality.newdelhi_air_quality

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
	30.2	198.60268	2022-10-21:18	0.046857167	55.789948	10.486722	5.6374097	0.3874302	Fri Oct 21 2022 23:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 21 2022 18:00:00 GMT+0000 (Coordinated Universal Time)	1666375200
1	28.2	197.60132	2022-10-21:19	0.046455536	54.93164	10.719325	4.618169	0.40978193	Sat Oct 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 21 2022 19:00:00 GMT+0000 (Coordinated Universal Time)	1666378800
2	26.6	198.60268	2022-10-21:20	0.046857167	54.64554	11.155578	3.520902	0.40233135	Sat Oct 22 2022 01:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 21 2022 20:00:00 GMT+0000 (Coordinated Universal Time)	1666382400
3	25	201.94054	2022-10-21:21	0.048195943	55.07469	11.116206	2.2259188	0.37625432	Sat Oct 22 2022 02:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 21 2022 21:00:00 GMT+0000 (Coordinated Universal Time)	1666386000
4	26	205.2784	2022-10-21:22	0.048865333	55.789948	10.40525	1.9794711	0.33900142	Sat Oct 22 2022 03:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 21 2022 22:00:00 GMT+0000 (Coordinated Universal Time)	1666389600
5	26	208.61626	2022-10-21:23	0.050204106	56.505203	9.402518	1.7926769	0.31292439	Sat Oct 22 2022 04:00:00 GMT+0000 (Coordinated Universal Time)	Fri Oct 21 2022 23:00:00 GMT+0000 (Coordinated Universal Time)	1666393200
6	26	208.61626	2022-10-22:00	0.050204106	55.789948	8.482822	1.7522373	0.31292439	Sat Oct 22 2022 05:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 22 2022 00:00:00 GMT+0000 (Coordinated Universal Time)	1666396800
7	24	205.2784	2022-10-22:01	0.050204106	52.928925	7.5866675	1.8584585	0.3427267	Sat Oct 22 2022 06:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 22 2022 01:00:00 GMT+0000 (Coordinated Universal Time)	1666400400
8	23	200.2716	2022-10-22:02	0.046857167	50.0679	7.6365867	2.2080758	0.39488077	Sat Oct 22 2022 07:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 22 2022 02:00:00 GMT+0000 (Coordinated Universal Time)	1666404000
9	24	196.93375	2022-10-22:03	0.044179615	51.498413	8.487648	2.4766808	0.42840838	Sat Oct 22 2022 08:00:00 GMT+0000 (Coordinated Universal Time)	Sat Oct 22 2022 03:00:00 GMT+0000 (Coordinated Universal Time)	1666407600


CREATE TABLE newdelhi_air_quality (
  "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
);