UCI Air Quality Dataset

Comprehensive Data on Pollutant Concentrations Over Time

@kaggle.dakshbhalala_uci_air_quality_dataset

Table List

1 table(221.89 KB)

Airqualityuci

@kaggle.dakshbhalala_uci_air_quality_dataset.airqualityuci

221.89 KB
9471 rows
17 columns

date Date	time Time	co_gt CO(GT)	pt08_s1_co PT08.S1(CO)	nmhc_gt NMHC(GT)	c6h6_gt C6H6(GT)	pt08_s2_nmhc PT08.S2(NMHC)	nox_gt NOx(GT)	pt08_s3_nox PT08.S3(NOx)	no2_gt NO2(GT)	pt08_s4_no2 PT08.S4(NO2)	pt08_s5_o3 PT08.S5(O3)	t T	rh RH	ah AH
Wed Mar 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	18:00:00	2.6	1360	150	11.9	1046	166	1056	113	1692	1268	13.6	48.9	0.7578
Wed Mar 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	19:00:00	2	1292	112	9.4	955	103	1174	92	1559	972	13.3	47.7	0.7255
Wed Mar 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	20:00:00	2.2	1402	88	9	939	131	1140	114	1555	1074	11.9	54	0.7502
Wed Mar 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	21:00:00	2.2	1376	80	9.2	948	172	1092	122	1584	1203	11	60	0.7867
Wed Mar 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	22:00:00	1.6	1272	51	6.5	836	131	1205	116	1490	1110	11.2	59.6	0.7888
Wed Mar 10 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	23:00:00	1.2	1197	38	4.7	750	89	1337	96	1393	949	11.2	59.2	0.7848
Thu Mar 11 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	0:00:00	1.2	1185	31	3.6	690	62	1462	77	1333	733	11.3	56.8	0.7603
Thu Mar 11 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	1:00:00	1	1136	31	3.3	672	62	1453	76	1333	730	10.7	60	0.7702
Thu Mar 11 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	2:00:00	0.9	1094	24	2.3	609	45	1579	60	1276	620	10.7	59.7	0.7648
Thu Mar 11 2004 00:00:00 GMT+0000 (Coordinated Universal Time)	3:00:00	0.6	1010	19	1.7	561	-200	1705	-200	1235	501	10.3	60.2	0.7517


CREATE TABLE airqualityuci (
  "date" TIMESTAMP,
  "time" VARCHAR,
  "co_gt" DOUBLE,
  "pt08_s1_co" DOUBLE,
  "nmhc_gt" DOUBLE,
  "c6h6_gt" DOUBLE,
  "pt08_s2_nmhc" DOUBLE,
  "nox_gt" DOUBLE,
  "pt08_s3_nox" DOUBLE,
  "no2_gt" DOUBLE,
  "pt08_s4_no2" DOUBLE,
  "pt08_s5_o3" DOUBLE,
  "t" DOUBLE,
  "rh" DOUBLE,
  "ah" DOUBLE,
  "unnamed_15" VARCHAR,
  "unnamed_16" VARCHAR
);