Air Quality - PM10 - 24 Hour Mean

Leicester City Council

@ukgov.air_quality_pm10_24_hour_mean

Table List

1 table(8.44 KB)

Table 1

@ukgov.air_quality_pm10_24_hour_mean.table_1

Air Quality - PM10 - 24 hour Mean (csv)

8.44 KB
123 rows
9 columns

site Site	type Type	year Year	maximum_24_hour_mean_ug_m3 Maximum 24 Hour Mean Ug M3	n_24_hour_means_50_inc_35_allowed 24 Hour Means 50 Inc 35 Allowed	total Total	data_capture Data Capture
Abbey Lane	TEOM x 1.3	2006	95		12
Abbey Lane	VCM	2014	69		8
Abbey Lane	BAM	2016	39
Abbey Lane	BAM	2019	61.91		10	98
Abbey Lane	BAM	2022	58.7	5		94.6
Abbey Lane	TEOM x 1.3	2003	78	7	42
Abbey Lane	TEOM x 1.3	2004	66		9
Abbey Lane	TEOM x 1.3	2005	81		6
Abbey Lane	TEOM x 1.3	2007	148		13
Abbey Lane	VCM	2009	63		4


CREATE TABLE table_1 (
  "site" VARCHAR,
  "type" VARCHAR,
  "year" BIGINT,
  "months" VARCHAR,
  "maximum_24_hour_mean_ug_m3" DOUBLE,
  "n_24_hour_means_50_inc_35_allowed" DOUBLE,
  "incidences_50_35_allowed" DOUBLE,
  "total" DOUBLE,
  "data_capture" DOUBLE
);

Share link

Anyone who has the link will be able to view this.