About this Dataset

Air Quality Data From UK-AIR

This data is downloaded from UK-AIR database from the Department of Environment, Food and Rural Affairs. The data supplied contains the daily average pollutant reading for Ozone, Nitrogen Oxide, Nitrogen Dioxide and Sulpher Dioxide from October 1997 to July 2016.

The are two data sources from different Cambridgeshire air monitoring stations. One is called Cambridge Roadside, which is within Cambridge City, and the other is in Wicken Fen, East Cambridgeshire.

The national air quality objecitves for these pollutant state the following averages cannot exceed:

Nitrogen Oxide: 30 ugm-3 per year
Nitrogen Dioxide: 40 ugm-3 per year
Ozone: 100 ugm-3 per 8 hour (max 10 times a year)
Sulphur Dioxide: 125 ugm-3 per day (max 3 times a year) or 20 ugm-3 per year
Publisher name: Cambridgeshire Insight
Last updated: 2024-09-14T15:29:14Z

Tables

Cambridge Roadside Air Quality

@ukgov.air_quality_data_from_uk_air1.cambridge_roadside_air_quality

81.58 kB
6,199 rows
7 columns

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
);

Wicken Fen Air Quality

@ukgov.air_quality_data_from_uk_air1.wicken_fen_air_quality

97.78 kB
6,844 rows
13 columns

CREATE TABLE wicken_fen_air_quality (
  "date" TIMESTAMP,
  "ozone" VARCHAR,
  "status" VARCHAR,
  "nitric_oxide" VARCHAR,
  "status_1" VARCHAR,
  "nitrogen_dioxide" VARCHAR,
  "status_2" VARCHAR,
  "nitrogen_oxides_as_nitrogen_dioxide" VARCHAR,
  "status_3" VARCHAR,
  "sulphur_dioxide" VARCHAR,
  "status_4" VARCHAR,
  "sulphur_dioxide_1" VARCHAR,
  "status_5" VARCHAR
);