Key Metric Rankings: Difference between revisions

(12 intermediate revisions by 2 users not shown)

Line 1:

[[Category:Arrangements]]

[[Category:Arrangements]][[Category:Targets & Metrics]]

Below are tables showing all the ranked metrics from the [[Key Metrics]], grouped by region. Use the arrows in the header row to sort any of the columns into ascending or descending order.

Recycling is ranked from high to low, whilst household waste per person has been ranked low to high. In the case of Scotland where they have a Carbon metric, that has also been ranked from low to high.

__TOC__

~~__FORCETOC__~~

==England==

{{#get_db_data: db=ID |from=england_joined|~~where~~=year=~~'2020-21'~~|data=authority=authority,hhwrecypc=hhwrecypc,rnkrecypc=rnkrecypc,chhwpp=chhwpp,rnkhhpp=rnkhhpp}}

{{#get_db_data: db=ID| from=england_joined|limit=1|data=year=year}}

For reporting period: {{#external_value:year}}

{{#get_db_data: db=ID |from=england_joined|data=authority=authority,hhwrecypc=hhwrecypc,rnkrecypc=rnkrecypc,chhwpp=chhwpp,rnkhhpp=rnkhhpp}}

{| class="wikitable sortable"

! Authority

! Recycling (%)

Line 23:

Line 24:

{{!}} {{{chhwpp}}}

{{!}} {{{rnkhhpp}}}

}}

|}

==Northern Ireland==

{{#get_db_data: db=ID| from=nireland_joined |limit=1|data=year=year}}

For reporting period: {{#external_value:year}}{{#clear_external_data:}}

{{#get_db_data: db=ID |from=nireland_joined |data=name=name,kpi_a2=kpi_a2,kpi_a2_rnk=kpi_a2_rnk,kpi_p=kpi_p,kpi_p_rnk=kpi_p_rnk}}

{| class="wikitable sortable"

! Authority

! Recycling (%)

! Rank

! Household Waste (kg/pp)

! Rank {{#for_external_table:<nowiki/>

{{!}}-

{{!}} [[{{{name}}}]]

{{!}} {{{kpi_a2}}}

{{!}} {{{kpi_a2_rnk}}}

{{!}} {{{kpi_p}}}

{{!}} {{{kpi_p_rnk}}}

}}

|}

==Scotland==

{{#get_db_data: db=ID| from=scotland_joined|limit=1|data=period=period}}

For reporting period: {{#external_value:period}}{{#clear_external_data:}}

{{#get_db_data: db=ID |from=scotland_joined |data=authority=authority,mrroprtpc=mrroprtpc,rnkrec=rnkrec,ghhgkgpp=ghhgkgpp,rnkkgpp=rnkkgpp,tco2epp=tco2epp,rnkcarb=rnkcarb}}

{| class="wikitable sortable"

! Authority

! Recycling (%)

Line 53:

Line 71:

==Wales==

{{#get_db_data: db=ID| from=wales_joined |limit=1|data=period=period}}

For reporting period: {{#external_value:period}}{{#clear_external_data:}}

{{#get_db_data: db=ID |from=wales_joined |data=authority=authority,wrrccpc=wrrccpc,rnkkkwrec=rnkkkwrec,hhwpp=hhwpp,rnkhhwpp=rnkhhwpp}}

{| class="wikitable sortable"

! Authority

! Recycling (%)

@@ Line 1: / Line 1: @@
-[[Category:Arrangements]]
+[[Category:Arrangements]][[Category:Targets & Metrics]]
 Below are tables showing all the ranked metrics from the [[Key Metrics]], grouped by region. Use the arrows in the header row to sort any of the columns into ascending or descending order.
 Recycling is ranked from high to low, whilst household waste per person has been ranked low to high. In the case of Scotland where they have a Carbon metric, that has also been ranked from low to high.
+__TOC__
-__FORCETOC__
+<br clear=all />
 ==England==
 {{#clear_external_data:}}
-{{#get_db_data: db=ID |from=england_joined|where=year='2020-21'|data=authority=authority,hhwrecypc=hhwrecypc,rnkrecypc=rnkrecypc,chhwpp=chhwpp,rnkhhpp=rnkhhpp}}
+{{#get_db_data: db=ID| from=england_joined|limit=1|data=year=year}}
+For reporting period: {{#external_value:year}}
+{{#clear_external_data:}}
+{{#get_db_data: db=ID |from=england_joined|data=authority=authority,hhwrecypc=hhwrecypc,rnkrecypc=rnkrecypc,chhwpp=chhwpp,rnkhhpp=rnkhhpp}}
 {| class="wikitable sortable"
 ! Authority
 ! Recycling (%)
@@ Line 23: / Line 24: @@
 {{!}} {{{chhwpp}}}
 {{!}} {{{rnkhhpp}}}
+}}
+|}
+==Northern Ireland==
+{{#clear_external_data:}}
+{{#get_db_data: db=ID| from=nireland_joined |limit=1|data=year=year}}
+For reporting period: {{#external_value:year}}{{#clear_external_data:}}
+{{#get_db_data: db=ID |from=nireland_joined |data=name=name,kpi_a2=kpi_a2,kpi_a2_rnk=kpi_a2_rnk,kpi_p=kpi_p,kpi_p_rnk=kpi_p_rnk}}
+{| class="wikitable sortable"
+! Authority
+! Recycling (%)
+! Rank
+! Household Waste (kg/pp)
+! Rank  {{#for_external_table:<nowiki/>
+{{!}}-
+{{!}} [[{{{name}}}]]
+{{!}} {{{kpi_a2}}}
+{{!}} {{{kpi_a2_rnk}}}
+{{!}} {{{kpi_p}}}
+{{!}} {{{kpi_p_rnk}}}
 }}
 |}
 ==Scotland==
 {{#clear_external_data:}}
+{{#get_db_data: db=ID| from=scotland_joined|limit=1|data=period=period}}
+For reporting period: {{#external_value:period}}{{#clear_external_data:}}
 {{#get_db_data: db=ID |from=scotland_joined |data=authority=authority,mrroprtpc=mrroprtpc,rnkrec=rnkrec,ghhgkgpp=ghhgkgpp,rnkkgpp=rnkkgpp,tco2epp=tco2epp,rnkcarb=rnkcarb}}
 {| class="wikitable sortable"
 ! Authority
 ! Recycling (%)
@@ Line 53: / Line 71: @@
 ==Wales==
 {{#clear_external_data:}}
+{{#get_db_data: db=ID| from=wales_joined |limit=1|data=period=period}}
+For reporting period: {{#external_value:period}}{{#clear_external_data:}}
 {{#get_db_data: db=ID |from=wales_joined |data=authority=authority,wrrccpc=wrrccpc,rnkkkwrec=rnkkkwrec,hhwpp=hhwpp,rnkhhwpp=rnkhhwpp}}
 {| class="wikitable sortable"
 ! Authority
 ! Recycling (%)