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='Rupicapra' AND species='rupicapra' GROUP BY t.sample_no
SELECT life_form FROM register WHERE genus='Rupicapra' LIMIT 1
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1962
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=1971
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3250
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3277
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3366
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3382
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3384
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3386
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3387
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3391
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3435
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3436
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3931
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3932
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3933
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=3934
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4103
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4104
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4108
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4109
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4111
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4112
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4118
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4378
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4384
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4385
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4387
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4388
SELECT corrected_richness AS estimate FROM samples WHERE sample_no=4389
SELECT genus FROM register WHERE register_no IN (89003,33099,11821,52643,48447,46624,7780,49843,14825,99833) AND species REGEXP '^[a-z]*$'
Rupicapra rupicapra (ungulate): 29 samples
Standardised estimates are based on the geometric series index (Kerr and Alroy 2023; Carter and Alroy 2024).