Inert Landfill: Difference between revisions

@@ Line 85: / Line 85: @@
   |from=lfvoidrgn
   |where=year=2020 and class='Inert Landfill' and cntry = 'England'
+ |data=rgn=rgn, num=num, void=void, avgvoid=avgvoid
+ |order by=rgn
+ |suppress error
+}}
+{| class="wikitable"
+   ! Region !! Number of Sites !! Total Void (m<sup>3</sup>) !! Average Void per site (m<sup>3</sup>){{#for_external_table:<nowiki/>
+   {{!}}-
+   {{!}} {{{rgn}}}
+   {{!}} {{{num}}}
+   {{!}} {{{void}}}
+   {{!}} {{{avgvoid}}}
+  }}
+|}
+===Scotland===
+{{#clear_external_data:}}
+{{#get_db_data:
+ db=engy
+ |from=lfvoidrgn
+ |where=year=2019 and class='Inert Landfill' and cntry = 'Scotland'
+ |data=rgn=rgn, num=num, void=void, avgvoid=avgvoid
+ |order by=rgn
+ |suppress error
+}}
+{| class="wikitable"
+   ! Region !! Number of Sites !! Total Void (m<sup>3</sup>) !! Average Void per site (m<sup>3</sup>){{#for_external_table:<nowiki/>
+   {{!}}-
+   {{!}} {{{rgn}}}
+   {{!}} {{{num}}}
+   {{!}} {{{void}}}
+   {{!}} {{{avgvoid}}}
+  }}
+|}
+===Wales===
+{{#clear_external_data:}}
+{{#get_db_data:
+ db=engy
+ |from=lfvoidrgn
+ |where=year=2018 and class='Inert Landfill' and cntry = 'Wales'
   |data=rgn=rgn, num=num, void=void, avgvoid=avgvoid
   |order by=rgn