Air Quality Data From UK-AIR

Cambridgeshire Insight

@ukgov.air_quality_data_from_uk_air1

Table List

2 tables(175.16 KB)

Cambridge Roadside Air Quality

@ukgov.air_quality_data_from_uk_air1.cambridge_roadside_air_quality

79.67 KB
6199 rows
7 columns

date Date	nitric_oxide Nitric Oxide	status Status	nitrogen_dioxide Nitrogen Dioxide	status_1 Status.1	nitrogen_oxides_as_nitrogen_dioxide Nitrogen Oxides As Nitrogen Dioxide	status_2 Status.2
Fri Jul 23 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	61	V ugm-3	36	V ugm-3	128	V ugm-3
Sat Jul 24 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	44	V ugm-3	43	V ugm-3	109	V ugm-3
Sun Jul 25 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	6	V ugm-3	16	V ugm-3	26	V ugm-3
Mon Jul 26 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	9	V ugm-3	16	V ugm-3	30	V ugm-3
Tue Jul 27 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	8	V ugm-3	19	V ugm-3	31	V ugm-3
Wed Jul 28 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	6	V ugm-3	19	V ugm-3	28	V ugm-3
Thu Jul 29 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	10	V ugm-3	29	V ugm-3	43	V ugm-3
Fri Jul 30 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	14	V ugm-3	41	V ugm-3	62	V ugm-3
Sat Jul 31 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	13	V ugm-3	49	V ugm-3	69	V ugm-3
Sun Aug 01 1999 00:00:00 GMT+0000 (Coordinated Universal Time)	7	V ugm-3	43	V ugm-3	53	V ugm-3


CREATE TABLE cambridge_roadside_air_quality (
  "date" TIMESTAMP,
  "nitric_oxide" VARCHAR,
  "status" VARCHAR,
  "nitrogen_dioxide" VARCHAR,
  "status_1" VARCHAR,
  "nitrogen_oxides_as_nitrogen_dioxide" VARCHAR,
  "status_2" VARCHAR
);