Barcelona Data Sets

station Station	air_quality Air Quality	longitude Longitude	latitude Latitude	o3_hour O3 Hour	o3_quality O3 Quality	o3_value O3 Value	no2_hour NO2 Hour	no2_quality NO2 Quality	no2_value NO2 Value	pm10_hour PM10 Hour	pm10_quality PM10 Quality	pm10_value PM10 Value	generated Generated	date_time Date Time
Barcelona - Sants	Good	2.1331	41.3788	nan	nan		0h	Good	84	nan	nan		01/11/2018 0:00	1541027104
Barcelona - Eixample	Moderate	2.1538	41.3853	0h	Good	1	0h	Moderate	113	0h	Good	36	01/11/2018 0:00	1541027104
Barcelona - Gràcia	Good	2.1534	41.3987	0h	Good	10	0h	Good	73	nan	nan		01/11/2018 0:00	1541027104
Barcelona - Ciutadella	Good	2.1874	41.3864	0h	Good	2	0h	Good	86	nan	nan		01/11/2018 0:00	1541027104
Barcelona - Vall Hebron	Good	2.148	41.4261	0h	Good	7	0h	Good	69	nan	nan		01/11/2018 0:00	1541027104
Barcelona - Palau Reial	Good	2.1151	41.3875	23h	Good	11	23h	Good	57	23h	Good	23	01/11/2018 0:00	1541027104
Barcelona - Poblenou	Good	2.2045	41.4039	nan	nan		23h	Good	86	23h	Good	32	01/11/2018 0:00	1541027104
Barcelona - Observ Fabra	Good	2.1239	41.4183	23h	Good	58	23h	Good	3	23h	Good	25	01/11/2018 0:00	1541027104
Barcelona - Sants	Good	2.1331	41.3788	nan	nan		0h	Good	62	nan	nan		01/11/2018 1:00	1541030725
Barcelona - Eixample	Good	2.1538	41.3853	0h	Good	6	0h	Good	80	1h	Good	35	01/11/2018 1:00	1541030725


CREATE TABLE air_quality_nov2017 (
  "station" VARCHAR,
  "air_quality" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "o3_hour" VARCHAR,
  "o3_quality" VARCHAR,
  "o3_value" DOUBLE,
  "no2_hour" VARCHAR,
  "no2_quality" VARCHAR,
  "no2_value" DOUBLE,
  "pm10_hour" VARCHAR,
  "pm10_quality" VARCHAR,
  "pm10_value" DOUBLE,
  "generated" VARCHAR,
  "date_time" BIGINT
);