BAP by Genus, Species and Location

Note this data goes back awhile and may not be perfect, however it is interesting

{arttablesorter filter="true" theme="blue" class="table sorter"} {artsqltable attributes="class=tablesorter" query="SELECT s_genus, s_species, s_location, s_start_year, COUNT( jos_spawns.id) AS cnt FROM jos_spawns GROUP BY s_genus, s_species ORDER BY s_genus ASC, s_species ASC, s_location ASC" headerNames="Genus, Species, Number_of_Spawns" headers="s_genus, s_species, cnt"}{/artsqltable}{/arttablesorter}