Key Metric Rankings: Difference between revisions
mNo edit summary |
mNo edit summary |
||
| (One intermediate revision by the same user not shown) | |||
| Line 7: | Line 7: | ||
<br clear=all /> | <br clear=all /> | ||
==England== | ==England== | ||
{{#clear_external_data:}} | {{#clear_external_data:}} | ||
{{#get_db_data: db=ID |from=england_joined| | {{#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" | {| class="wikitable sortable" | ||
! Authority | ! Authority | ||
! Recycling (%) | ! Recycling (%) | ||
| Line 24: | Line 24: | ||
{{!}} {{{chhwpp}}} | {{!}} {{{chhwpp}}} | ||
{{!}} {{{rnkhhpp}}} | {{!}} {{{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== | ==Scotland== | ||
{{#clear_external_data:}} | {{#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}} | {{#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" | {| class="wikitable sortable" | ||
! Authority | ! Authority | ||
! Recycling (%) | ! Recycling (%) | ||
| Line 54: | Line 71: | ||
==Wales== | ==Wales== | ||
{{#clear_external_data:}} | {{#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}} | {{#get_db_data: db=ID |from=wales_joined |data=authority=authority,wrrccpc=wrrccpc,rnkkkwrec=rnkkkwrec,hhwpp=hhwpp,rnkhhwpp=rnkhhwpp}} | ||
{| class="wikitable sortable" | {| class="wikitable sortable" | ||
! Authority | ! Authority | ||
! Recycling (%) | ! Recycling (%) | ||