This site and its content are under development. We would welcome your feedback

A list of all taxa in a vice-county with the number of tetrads with records since a specified year

To count the number of tetrads for each taxon, you add a ‘distinct’ clause to the grouped query.  In the example below, the number of tetrads for each taxon within Kent (vice-counties 15 and 16) since 1987 is listed. 

records in vice county Kent, grouped by taxon name, counting distinct tetrads, recorded since 1987: click to see query in DDb (login required)

Monad can be substituted instead of tetrad within the ‘distinct’ clause.