About this Dataset

Air Quality - Nitrogen Dioxide

Datasets showing nitrogen dioxide levels (NO2) at various locations around Leeds. Please note ----------- From 17/02/17 this dataset will be archived and superseeded by the ratified air quality dataset https://datamillnorth.org/dataset/ratified-air-quality---nitrogen-dioxide which contains corroborated data quality checked by external auditors. Additional information ----------------------- * The data is collected on an hourly basis * Column A = Date of collection (YYMMDD) * Column B = Time of collection * Column C = Reading * Column D = Validation (14 means the data has been validated but not that it has been ratified) * NOTE: The data is not necessarily collected for all dates/times/stations Defra air quality data ---------------------- * Information manage a further two stations in Leeds * You can be sent information through their air quality bulletin and request up to hourly information from http://uk-air.defra.gov.uk/bulletin-subscription * Archive CSV data can be downloaded from http://uk-air.defra.gov.uk/data/data_selector?=l&1=&s;=&o;=#mid
Publisher name: Leeds City Council
Last updated: 2024-09-10T23:25:54Z

Tables

Compton Road

@ukgov.air_quality_nitrogen_dioxide.compton_road

54.53 kB
129,810 rows
5 columns

CREATE TABLE compton_road (
  "cr3" VARCHAR  -- CR3+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Copperfield

@ukgov.air_quality_nitrogen_dioxide.copperfield

45.68 kB
129,810 rows
5 columns

CREATE TABLE copperfield (
  "jn1" VARCHAR  -- JN1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Corn Exchange

@ukgov.air_quality_nitrogen_dioxide.corn_exchange

659.86 kB
129,810 rows
5 columns

CREATE TABLE corn_exchange (
  "ce3" VARCHAR  -- CE3+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Haslewood Close

@ukgov.air_quality_nitrogen_dioxide.haslewood_close

659.37 kB
129,810 rows
5 columns

CREATE TABLE haslewood_close (
  "hw2" VARCHAR  -- HW2+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Headingley 1

@ukgov.air_quality_nitrogen_dioxide.headingley_1

130.56 kB
129,810 rows
5 columns

CREATE TABLE headingley_1 (
  "hd1" VARCHAR  -- HD1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Headingley 2

@ukgov.air_quality_nitrogen_dioxide.headingley_2

99.54 kB
129,810 rows
5 columns

CREATE TABLE headingley_2 (
  "hd2" VARCHAR  -- HD2+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Headingley 5

@ukgov.air_quality_nitrogen_dioxide.headingley_5

89.96 kB
129,810 rows
5 columns

CREATE TABLE headingley_5 (
  "hd5" VARCHAR  -- HD5+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Headingley 7

@ukgov.air_quality_nitrogen_dioxide.headingley_7

543.59 kB
129,810 rows
5 columns

CREATE TABLE headingley_7 (
  "hd7" VARCHAR  -- HD7+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Jack Lane

@ukgov.air_quality_nitrogen_dioxide.jack_lane

624.66 kB
129,810 rows
5 columns

CREATE TABLE jack_lane (
  "jl4" VARCHAR  -- JL4+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Kirkstall 1

@ukgov.air_quality_nitrogen_dioxide.kirkstall_1

51.38 kB
129,810 rows
5 columns

CREATE TABLE kirkstall_1 (
  "kn1" VARCHAR  -- KN1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Kirkstall 2

@ukgov.air_quality_nitrogen_dioxide.kirkstall_2

489.33 kB
129,810 rows
5 columns

CREATE TABLE kirkstall_2 (
  "kn2" VARCHAR  -- KN2+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Middlecross

@ukgov.air_quality_nitrogen_dioxide.middlecross

45.98 kB
129,810 rows
5 columns

CREATE TABLE middlecross (
  "mc1" VARCHAR  -- MC1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Millshaw

@ukgov.air_quality_nitrogen_dioxide.millshaw

78.33 kB
129,810 rows
5 columns

CREATE TABLE millshaw (
  "ym1" VARCHAR  -- YM1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Morley Library

@ukgov.air_quality_nitrogen_dioxide.morley_library

47.46 kB
129,810 rows
5 columns

CREATE TABLE morley_library (
  "ml1" VARCHAR  -- ML1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Norman Row

@ukgov.air_quality_nitrogen_dioxide.norman_row

107.01 kB
129,810 rows
5 columns

CREATE TABLE norman_row (
  "nr1" VARCHAR  -- NR1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Queens Court

@ukgov.air_quality_nitrogen_dioxide.queens_court

812.31 kB
129,810 rows
5 columns

CREATE TABLE queens_court (
  "qc1" VARCHAR  -- QC1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Rodillian School

@ukgov.air_quality_nitrogen_dioxide.rodillian_school

46.71 kB
129,810 rows
5 columns

CREATE TABLE rodillian_school (
  "rd2" VARCHAR  -- RD2+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Selby Road

@ukgov.air_quality_nitrogen_dioxide.selby_road

53.31 kB
129,810 rows
5 columns

CREATE TABLE selby_road (
  "sr4" VARCHAR  -- SR4+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Temple Newsam 2

@ukgov.air_quality_nitrogen_dioxide.temple_newsam_2

62.93 kB
129,810 rows
5 columns

CREATE TABLE temple_newsam_2 (
  "tn2" VARCHAR  -- TN2+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Temple Newsam 6

@ukgov.air_quality_nitrogen_dioxide.temple_newsam_6

432.84 kB
129,810 rows
5 columns

CREATE TABLE temple_newsam_6 (
  "tn6" VARCHAR  -- TN6+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Tilbury Terrace

@ukgov.air_quality_nitrogen_dioxide.tilbury_terrace

158.41 kB
129,810 rows
5 columns

CREATE TABLE tilbury_terrace (
  "tt1" VARCHAR  -- TT1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

Victoria Avenue

@ukgov.air_quality_nitrogen_dioxide.victoria_avenue

79.66 kB
129,810 rows
5 columns

CREATE TABLE victoria_avenue (
  "va1" VARCHAR  -- VA1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);

West Street

@ukgov.air_quality_nitrogen_dioxide.west_street

107.33 kB
129,810 rows
5 columns

CREATE TABLE west_street (
  "ws1" VARCHAR  -- WS1+,
  "unnamed_1" DOUBLE  -- Unnamed: 1,
  "unnamed_2" VARCHAR  -- Unnamed: 2,
  "unnamed_3" VARCHAR  -- Unnamed: 3,
  "unnamed_4" VARCHAR  -- Unnamed: 4
);