SELECT * FROM samples WHERE sample_no=4587
SELECT person_no,first_name,last_name FROM people
SELECT * FROM refs WHERE ref_no=4135
SELECT sql FROM sqlite_master WHERE tbl_name='samples';
SELECT * FROM register WHERE sample_no=4587 ORDER BY register_no ASC
SELECT * FROM extinct WHERE genus IN ('Mesodma','Mesodma','Ectypodus','Catopsalis','Palaeoryctidae','Protungulatum','Protungulatum','Loxolophus','Mithrandir','Oxyacodon','Conacodon','Conacodon','Ectoconus','Periptychidae') OR species IN ('ambigua','garfieldensis','sp. A','joyneri','indet.','donnae','gorgun','hyattianus','gillianus','agapetillus','delphae','harbourae','sp.','indet.')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Mesodma' AND (species='ambigua' OR species='ambigua')
SELECT genus,species FROM synonyms WHERE right_genus='Mesodma' AND (right_species='ambigua' OR right_species='ambigua')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesodma' AND (species='ambigua' OR species='ambigua') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Mesodma' AND (species='ambigua' OR species='ambigua')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Mesodma' AND (species='ambigua' OR species='ambigua')
SELECT genus,species FROM synonyms WHERE right_genus='Mesodma' AND (right_species='ambigua' OR right_species='ambigua')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesodma' AND (species='ambigua' OR species='ambigua') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis')
SELECT genus,species FROM synonyms WHERE right_genus='Mesodma' AND right_species='garfieldensis'
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis')
SELECT genus,species FROM synonyms WHERE right_genus='Mesodma' AND right_species='garfieldensis'
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mesodma' AND (species='garfieldensis' OR species='garfieldensis') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Ectypodus' AND (species='sp.' OR species='sp.')
SELECT genus,species FROM synonyms WHERE right_genus='Ectypodus' AND (right_species='sp.' OR right_species='sp.')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectypodus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ectypodus' AND (species='sp.' OR species='sp.')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Ectypodus' AND (species='sp.' OR species='sp.')
SELECT genus,species FROM synonyms WHERE right_genus='Ectypodus' AND (right_species='sp.' OR right_species='sp.')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ectypodus' AND (species='sp.' OR species='sp.') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Catopsalis' AND (species='joyneri' OR species='joynerii')
SELECT genus,species FROM synonyms WHERE right_genus='Catopsalis' AND right_species='joyneri'
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsalis' AND (species='joyneri' OR species='joynerii') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Catopsalis' AND (species='joyneri' OR species='joynerii')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsalis' AND (species='joyneri' OR species='joynerii') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Catopsalis' AND (species='joyneri' OR species='joynerii')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catopsalis' AND (species='joyneri' OR species='joynerii') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Catopsalis' AND (species='joyneri' OR species='joynerii')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Catopsalis' AND (species='joyneri' OR species='joynerii')
SELECT genus,species FROM synonyms WHERE right_genus='Catopsalis' AND right_species='joyneri'
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catopsalis' AND (species='joyneri' OR species='joynerii') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catopsalis' AND (species='joyneri' OR species='joynerii') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Catopsalis' AND (species='joyneri' OR species='joynerii') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Palaeoryctidae' AND (species='indet.' OR species='indet.')
SELECT genus,species FROM synonyms WHERE right_genus='Palaeoryctidae' AND (right_species='indet.' OR right_species='indet.')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Palaeoryctidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Palaeoryctidae' AND (species='indet.' OR species='indet.')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Palaeoryctidae' AND (species='indet.' OR species='indet.')
SELECT genus,species FROM synonyms WHERE right_genus='Palaeoryctidae' AND (right_species='indet.' OR right_species='indet.')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Palaeoryctidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Protungulatum' AND (species='donnae' OR species='donnae')
SELECT genus,species FROM synonyms WHERE right_genus='Protungulatum' AND right_species='donnae'
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protungulatum' AND (species='donnae' OR species='donnae') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Protungulatum' AND (species='donnae' OR species='donnae')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protungulatum' AND (species='donnae' OR species='donnae') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Protungulatum' AND (species='donnae' OR species='donnae')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protungulatum' AND (species='donnae' OR species='donnae') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Protungulatum' AND (species='donnae' OR species='donnae')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Protungulatum' AND (species='donnae' OR species='donnae')
SELECT genus,species FROM synonyms WHERE right_genus='Protungulatum' AND right_species='donnae'
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protungulatum' AND (species='donnae' OR species='donnae') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protungulatum' AND (species='donnae' OR species='donnae') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protungulatum' AND (species='donnae' OR species='donnae') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Protungulatum' AND (species='gorgun' OR species='gorgun')
SELECT genus,species FROM synonyms WHERE right_genus='Protungulatum' AND right_species='gorgun'
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protungulatum' AND (species='gorgun' OR species='gorgun') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Protungulatum' AND (species='gorgun' OR species='gorgun')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protungulatum' AND (species='gorgun' OR species='gorgun') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Protungulatum' AND (species='gorgun' OR species='gorgun')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protungulatum' AND (species='gorgun' OR species='gorgun') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Protungulatum' AND (species='gorgun' OR species='gorgun')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Protungulatum' AND (species='gorgun' OR species='gorgun')
SELECT genus,species FROM synonyms WHERE right_genus='Protungulatum' AND right_species='gorgun'
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protungulatum' AND (species='gorgun' OR species='gorgun') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protungulatum' AND (species='gorgun' OR species='gorgun') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protungulatum' AND (species='gorgun' OR species='gorgun') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Loxolophus' AND (species='hyattianus' OR species='hyattianus')
SELECT genus,species FROM synonyms WHERE right_genus='Loxolophus' AND (right_species='hyattianus' OR right_species='hyattianus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loxolophus' AND (species='hyattianus' OR species='hyattianus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Loxolophus' AND (species='hyattianus' OR species='hyattianus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chriacus' AND (species='hyattianus' OR species='hyattianus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Chriacus' AND (species='hyattianus' OR species='hyattianus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Protochriacus' AND (species='hyattianus' OR species='hyattianus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Protochriacus' AND (species='hyattianus' OR species='hyattianus')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Loxolophus' AND (species='hyattianus' OR species='hyattianus')
SELECT genus,species FROM synonyms WHERE right_genus='Loxolophus' AND (right_species='hyattianus' OR right_species='hyattianus')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Loxolophus' AND (species='hyattianus' OR species='hyattianus') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Chriacus' AND (species='hyattianus' OR species='hyattianus') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Protochriacus' AND (species='hyattianus' OR species='hyattianus') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Mithrandir' AND (species='gillianus' OR species='gillianus')
SELECT genus,species FROM synonyms WHERE right_genus='Mithrandir' AND (right_species='gillianus' OR right_species='gillianus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mithrandir' AND (species='gillianus' OR species='gillianus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Mithrandir' AND (species='gillianus' OR species='gillianus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Haploconus' AND (species='gillianus' OR species='gillianus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Haploconus' AND (species='gillianus' OR species='gillianus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisonchus' AND (species='gillianus' OR species='gillianus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Anisonchus' AND (species='gillianus' OR species='gillianus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gillisonchus' AND (species='gillianus' OR species='gillianus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Gillisonchus' AND (species='gillianus' OR species='gillianus')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Mithrandir' AND (species='gillianus' OR species='gillianus')
SELECT genus,species FROM synonyms WHERE right_genus='Mithrandir' AND (right_species='gillianus' OR right_species='gillianus')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Mithrandir' AND (species='gillianus' OR species='gillianus') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Haploconus' AND (species='gillianus' OR species='gillianus') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anisonchus' AND (species='gillianus' OR species='gillianus') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Gillisonchus' AND (species='gillianus' OR species='gillianus') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Oxyacodon' AND (species='agapetillus' OR species='agapetillus')
SELECT genus,species FROM synonyms WHERE right_genus='Oxyacodon' AND (right_species='agapetillus' OR right_species='agapetillus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyacodon' AND (species='agapetillus' OR species='agapetillus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Oxyacodon' AND (species='agapetillus' OR species='agapetillus')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anisonchus' AND (species='agapetillus' OR species='agapetillus') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Anisonchus' AND (species='agapetillus' OR species='agapetillus')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Oxyacodon' AND (species='agapetillus' OR species='agapetillus')
SELECT genus,species FROM synonyms WHERE right_genus='Oxyacodon' AND (right_species='agapetillus' OR right_species='agapetillus')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Oxyacodon' AND (species='agapetillus' OR species='agapetillus') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Anisonchus' AND (species='agapetillus' OR species='agapetillus') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Conacodon' AND (species='delphae' OR species='delphae')
SELECT genus,species FROM synonyms WHERE right_genus='Conacodon' AND right_species='delphae'
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conacodon' AND (species='delphae' OR species='delphae') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Conacodon' AND (species='delphae' OR species='delphae')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conacodon' AND (species='delphae' OR species='delphae') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Conacodon' AND (species='delphae' OR species='delphae')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conacodon' AND (species='delphae' OR species='delphae') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Conacodon' AND (species='delphae' OR species='delphae')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Conacodon' AND (species='delphae' OR species='delphae')
SELECT genus,species FROM synonyms WHERE right_genus='Conacodon' AND right_species='delphae'
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conacodon' AND (species='delphae' OR species='delphae') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conacodon' AND (species='delphae' OR species='delphae') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conacodon' AND (species='delphae' OR species='delphae') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Conacodon' AND (species='harbourae' OR species='harbourae')
SELECT genus,species FROM synonyms WHERE right_genus='Conacodon' AND right_species='harbourae'
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conacodon' AND (species='harbourae' OR species='harbourae') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Conacodon' AND (species='harbourae' OR species='harbourae')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conacodon' AND (species='harbourae' OR species='harbourae') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Conacodon' AND (species='harbourae' OR species='harbourae')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Conacodon' AND (species='harbourae' OR species='harbourae') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Conacodon' AND (species='harbourae' OR species='harbourae')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Conacodon' AND (species='harbourae' OR species='harbourae')
SELECT genus,species FROM synonyms WHERE right_genus='Conacodon' AND right_species='harbourae'
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conacodon' AND (species='harbourae' OR species='harbourae') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conacodon' AND (species='harbourae' OR species='harbourae') ORDER BY year,last_names
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Conacodon' AND (species='harbourae' OR species='harbourae') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Ectoconus' AND (species='sp.' OR species='sp.')
SELECT genus,species FROM synonyms WHERE right_genus='Ectoconus' AND (right_species='sp.' OR right_species='sp.')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectoconus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Ectoconus' AND (species='sp.' OR species='sp.')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Ectoconus' AND (species='sp.' OR species='sp.')
SELECT genus,species FROM synonyms WHERE right_genus='Ectoconus' AND (right_species='sp.' OR right_species='sp.')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Ectoconus' AND (species='sp.' OR species='sp.') ORDER BY year,last_names
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Periptychidae' AND (species='indet.' OR species='indet.')
SELECT genus,species FROM synonyms WHERE right_genus='Periptychidae' AND (right_species='indet.' OR right_species='indet.')
SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Periptychidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,year
SELECT *,0 AS individuals FROM crc WHERE genus='Periptychidae' AND (species='indet.' OR species='indet.')
SELECT right_genus genus,right_species species FROM synonyms WHERE genus='Periptychidae' AND (species='indet.' OR species='indet.')
SELECT genus,species FROM synonyms WHERE right_genus='Periptychidae' AND (right_species='indet.' OR right_species='indet.')
SELECT d.diet,d.diet_2,r.ref_no,r.last_names,r.year FROM diets d,refs r WHERE d.ref_no=r.ref_no AND genus='Periptychidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_names
SELECT * FROM register WHERE sample_no=4587
SELECT genus FROM register WHERE register_no IN (62614,22050,35484,62301,61191,10174,87494,17870,96435,97807) AND species REGEXP '^[a-z]*$'
The Ecological Register: Ferris Formation (UW locality V-91031)
Ferris Formation (UW locality V-91031)
Basic information
Sample name: Ferris Formation (UW locality V-91031)

Reference: J. J. Eberle and J. A. Lillegraven. 1998. A new important record of earliest Cenozoic mammalian history: geologic setting, Multituberculata, and Peradectia. Rocky Mountain Geology 33(1):3-47 [ER 4135]
Geography
Country: United States

State: Wyoming


County: Carbon


Coordinate: 41.94° N, -106.88° W
Coordinate basis: estimated from map

Formation: Ferris

Time interval: Early Palaeocene

Zone: Puercan

Section: Ferris

Unit number: 2

Unit order: below to above

Geography comments: near the north-central edge of sec. 28, T. 23 N., R. 84 W.
said to be in the basal Pu2 zone

•
Environment
Lithology: sandstone

Habitat comments: shown in Fig. 2 as coming from a sandstone bed

Methods
Life forms: ungulates,other small mammals

Sampling methods: quarry,surface

Sample size: 27 specimens

Years: 1991

Museum: University of Wyoming

Sampling comments: presumably discovered in 1991
"a fossiliferous anthill perched atop a quarry site"
counts are based on two companion papers by Eberle and Lillegraven (1998), ER refs 4135 and 4136

Metadata
Sample number: 4587

Contributor: John Alroy

Enterer: John Alroy

Modifier no: John Alroy

Created: 2024-12-09 04:13:14

Modified: 2024-12-09 04:24:41

Abundance distribution
14 species
7 singletons
total count 27
geometric series index: 47.0
Fisher's α: 11.708
geometric series k: 0.8712
Hurlbert's PIE: 0.8903
Shannon's H: 2.4482
Good's u: 0.7517
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Draw sampling curves
Register
†Mesodma ambigua1
†Mesodma cf. garfieldensis1
Ectypodus sp. A2
†Catopsalis joyneri1
Palaeoryctidae indet.1
†Protungulatum donnae1
†Protungulatum gorgun2
†Loxolophus cf. hyattianus1
†Mithrandir gillianus3
†Oxyacodon agapetillus3
†Conacodon delphae1
†Conacodon harbourae2
Ectoconus sp.2
Periptychidae indet.6