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='Chrysemys' GROUP BY t.sample_no
SELECT life_form FROM register WHERE genus='Chrysemys' LIMIT 1
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=315
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=316
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=318
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=319
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=320
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=321
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=361
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=384
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1023
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3430
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3437
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3438
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3439
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3451
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3452
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3461
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3463
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3464
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3479
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3483
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3496
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3504
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3507
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3517
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3521
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3524
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3525
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3546
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4637
SELECT genus FROM register WHERE register_no IN (60983,16338,55096,1991,34778,44616,32679,2011,66842,2014) AND species REGEXP '^[a-z]*$'
global
North America
United States
South America/Africa
Europe
Eurasia
Africa/Australasia
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
Chrysemys (turtle): 29 samples
Standardised estimates are based on the geometric series index (Kerr and Alroy 2023; Carter and Alroy 2024).