Air Quality In São Paulo, Brazil

Air quality in some cities of São Paulo state in Brazil

@kaggle.amandalk_sp_air_quality

Table List

1 table(8.47 MB)

Sp Air Quality

@kaggle.amandalk_sp_air_quality.sp_air_quality

8.47 MB
3445260 rows
11 columns

datetime Datetime	station Station	pm10 PM10	o3 O3
Wed May 08 2013 01:00:00 GMT+0000 (Coordinated Universal Time)	Araçatuba	30	7
Wed May 08 2013 02:00:00 GMT+0000 (Coordinated Universal Time)	Araçatuba	30	6
Wed May 08 2013 03:00:00 GMT+0000 (Coordinated Universal Time)	Araçatuba	31	6
Wed May 08 2013 04:00:00 GMT+0000 (Coordinated Universal Time)	Araçatuba	31	4
Wed May 08 2013 05:00:00 GMT+0000 (Coordinated Universal Time)	Araçatuba	32	4
Wed May 08 2013 06:00:00 GMT+0000 (Coordinated Universal Time)	Araçatuba	35	5
Wed May 08 2013 07:00:00 GMT+0000 (Coordinated Universal Time)	Araçatuba	38	5
Wed May 08 2013 08:00:00 GMT+0000 (Coordinated Universal Time)	Araçatuba	40	5
Wed May 08 2013 09:00:00 GMT+0000 (Coordinated Universal Time)	Araçatuba	40	4
Wed May 08 2013 10:00:00 GMT+0000 (Coordinated Universal Time)	Araçatuba	41	4


CREATE TABLE sp_air_quality (
  "datetime" TIMESTAMP,
  "station" VARCHAR,
  "benzene" DOUBLE,
  "co" DOUBLE,
  "pm10" DOUBLE,
  "pm2_5" DOUBLE,
  "no2" DOUBLE,
  "o3" DOUBLE,
  "so2" DOUBLE,
  "toluene" DOUBLE,
  "trs" DOUBLE
);