Antrim and Newtownabbey Borough Council: Difference between revisions

@@ Line 1: / Line 1: @@
 Antrim and Newtownabbey Borough Council[[Category:Disposal]]
-<!-- {{#clear_external_data:}}
+{{#vardefine:gss|N09000001}}
-{{#get_db_data: db=ID|from=nireland_joined|where=gsscode='N09000001'|data=area=area,pop=pop,pop_area=pop_area,hwrc=hwrc,hwrc_pop=hwrc_pop,hwrc_area=hwrc_area,kpi_a2=kpi_a2,kpi_b=kpi_b,kpi_e2=kpi_e2,kpi_f=kpi=f,kpi_g=kpi_g,kpi_h=kpi_h,kpi_j=kpi_j,kpi_p=kpi_p,kpi_a2_rnk=kpi_a2_rnk,kpi_p_rnk=kpi_p_rnk}} -->
+{{#clear_external_data:}}
+{{#get_db_data: db=ID|from=nireland_joined|where=gsscode='{{#var:gss}}'|data=area=area,pop=pop,pop_area=pop_area}}
 == Demographic Information ==
-GSSCode: {{#vardefine:gss|N09000001}}{{#var:gss}}
+GSSCode: {{#var:gss}}
 Authority Type: UTA<ref>Authority Type Abreviations:
@@ Line 30: / Line 31: @@
 ==[[Key Metrics]]==
 ===[[Household Waste Recycling Centres]] ([[HWRC]])===
+{{#clear_external_data:}}
+{{#get_db_data: db=ID|from=nireland_joined|where=gsscode='{{#var:gss}}'|data=hwrc=hwrc,hwrc_pop=hwrc_pop,hwrc_area=hwrc_area}}
 {| class=wikitable
 ! Metric !!Indicator
@@ Line 42: / Line 47: @@
 ===Authority Reported Metrics===
+{{#clear_external_data:}}
+<!-- {{#get_db_data: db=ID|from=nireland_joined|where=gsscode='{{#var:gss}}'|data=kpi_a2=kpi_a2,kpi_b=kpi_b,kpi_e2=kpi_e2,kpi_f=kpi=f,kpi_g=kpi_g,kpi_h=kpi_h,kpi_j=kpi_j,kpi_p=kpi_p,kpi_a2_rnk=kpi_a2_rnk,kpi_p_rnk=kpi_p_rnk}} -->
 ====Ranked Metrics====
 {| class=wikitable