SELECT p.first_name AS contributor_first,p.last_name AS contributor_last,p2.first_name AS enterer_first,p2.last_name AS enterer_last,t.* FROM people p,people p2,samples t,register t2 WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=t2.sample_no AND genus='Cyanocompsa' AND species='cyanoides' GROUP BY t.sample_no
SELECT life_form FROM register WHERE genus='Cyanocompsa' LIMIT 1
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1025
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1030
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1031
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1047
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1048
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1054
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1061
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1062
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1096
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1097
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1114
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1117
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1119
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1120
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1147
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1383
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1384
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1385
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1765
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1775
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1777
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2284
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2935
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2942
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=2953
SELECT genus FROM register WHERE register_no IN (69236,34645,39286,57819,98416,58778,65538,48855,91870,77832) AND species REGEXP '^[a-z]*$'
global
North America
United States
South America/Africa
Europe
Eurasia
Africa/Australasia
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Cyanocompsa cyanoides (bird): 25 samples
Standardised estimates are based on the geometric series index (Kerr and Alroy 2023; Carter and Alroy 2024).