SELECT * FROM sessions,people WHERE ip=20315109220 AND enterer=person_noSELECT 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 WHERE t.contributor_no=p.person_no AND t.enterer_no=p2.person_no AND t.sample_no=3451 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3451SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3155SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3451 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepisosteus' AND (junior_species='osseus' OR junior_species='osseus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepisosteus' AND (species='osseus' OR species='osseus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepisosteus' AND (species='osseus' OR species='osseus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepisosteus' AND (junior_species='osseus' OR junior_species='osseus')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='Lepisosteus' AND (species='osseus' OR species='osseus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amia' AND (junior_species='calva' OR junior_species='calva')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amia' AND (species='calva' OR species='calva') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amia' AND (species='calva' OR species='calva')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amia' AND (junior_species='calva' OR junior_species='calva')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='Amia' AND (species='calva' OR species='calva') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salmonidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salmonidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salmonidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salmonidae' AND (junior_species='indet.' OR junior_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='Salmonidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coregonus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coregonus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coregonus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coregonus' AND (junior_species='sp.' OR junior_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='Coregonus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Esox' AND (junior_species='lucius' OR junior_species='lucius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Esox' AND (species='lucius' OR species='lucius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Esox' AND (species='lucius' OR species='lucius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Esox' AND (junior_species='lucius' OR junior_species='lucius')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='Esox' AND (species='lucius' OR species='lucius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catostomidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catostomidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catostomidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catostomidae' AND (junior_species='indet.' OR junior_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='Catostomidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameirus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ameirus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ameirus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ameirus' AND (junior_species='sp.' OR junior_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='Ameirus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictalurus' AND (junior_species='punctatus' OR junior_species='punctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ictalurus' AND (species='punctatus' OR species='punctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ictalurus' AND (species='punctatus' OR species='punctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictalurus' AND (junior_species='punctatus' OR junior_species='punctatus')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='Ictalurus' AND (species='punctatus' OR species='punctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguilla' AND (junior_species='rostrata' OR junior_species='rostrata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anguilla' AND (species='rostrata' OR species='rostrata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anguilla' AND (species='rostrata' OR species='rostrata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anguilla' AND (junior_species='rostrata' OR junior_species='rostrata')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='Anguilla' AND (species='rostrata' OR species='rostrata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambloplites' AND (junior_species='rupestris' OR junior_species='rupestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ambloplites' AND (species='rupestris' OR species='rupestris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ambloplites' AND (species='rupestris' OR species='rupestris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ambloplites' AND (junior_species='rupestris' OR junior_species='rupestris')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='Ambloplites' AND (species='rupestris' OR species='rupestris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepomis' AND (junior_species='gibbosus' OR junior_species='gibbosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepomis' AND (species='gibbosus' OR species='gibbosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepomis' AND (species='gibbosus' OR species='gibbosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepomis' AND (junior_species='gibbosus' OR junior_species='gibbosus')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='Lepomis' AND (species='gibbosus' OR species='gibbosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropterus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Micropterus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Micropterus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Micropterus' AND (junior_species='sp.' OR junior_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='Micropterus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perca' AND (junior_species='flavescens' OR junior_species='flavescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perca' AND (species='flavescens' OR species='flavescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perca' AND (species='flavescens' OR species='flavescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perca' AND (junior_species='flavescens' OR junior_species='flavescens')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='Perca' AND (species='flavescens' OR species='flavescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sander' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sander' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sander' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sander' AND (junior_species='sp.' OR junior_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='Sander' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aplodinotus' AND (junior_species='grunniens' OR junior_species='grunniens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aplodinotus' AND (species='grunniens' OR species='grunniens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aplodinotus' AND (species='grunniens' OR species='grunniens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aplodinotus' AND (junior_species='grunniens' OR junior_species='grunniens')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='Aplodinotus' AND (species='grunniens' OR species='grunniens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='americanus' OR junior_species='americanus')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='Lepus' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sciurus' AND (species='carolinensis' OR species='carolinensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sciurus' AND (junior_species='carolinensis' OR junior_species='carolinensis')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='Sciurus' AND (species='carolinensis' OR species='carolinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamiasciurus' AND (junior_species='hudsonicus' OR junior_species='hudsonicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tamiasciurus' AND (species='hudsonicus' OR species='hudsonicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamiasciurus' AND (junior_species='hudsonicus' OR junior_species='hudsonicus')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='Tamiasciurus' AND (species='hudsonicus' OR species='hudsonicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='monax' OR junior_species='monax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmota' AND (species='monax' OR species='monax') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='monax' OR junior_species='monax')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='Marmota' AND (species='monax' OR species='monax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamias' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tamias' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tamias' AND (junior_species='striatus' OR junior_species='striatus')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='Tamias' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castor' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castor' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castor' AND (junior_species='canadensis' OR junior_species='canadensis')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='Castor' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Peromyscus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='sp.' OR junior_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='Peromyscus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemmini' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lemmini' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lemmini' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemmini' AND (junior_species='indet.' OR junior_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='Lemmini' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')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='Microtus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='chrotorrhinus' OR junior_species='chrotorrhinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Microtus' AND (species='chrotorrhinus' OR species='chrotorrhinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' AND (junior_species='chrotorrhinus' OR junior_species='chrotorrhinus')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='Microtus' AND (species='chrotorrhinus' OR species='chrotorrhinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ondatra' AND (junior_species='zibethicus' OR junior_species='zibethicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ondatra' AND (species='zibethicus' OR species='zibethicus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ondatra' AND (junior_species='zibethicus' OR junior_species='zibethicus')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='Ondatra' AND (species='zibethicus' OR species='zibethicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erethizon' AND (junior_species='dorsatum' OR junior_species='dorsatum')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Erethizon' AND (species='dorsatum' OR species='dorsatum') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Erethizon' AND (junior_species='dorsatum' OR junior_species='dorsatum')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Erethizon' AND (species='dorsatum' OR species='dorsatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='Canis' AND (species='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='vulpes' OR junior_species='vulpes')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='Vulpes' AND (species='vulpes' OR species='vulpes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='americanus' OR junior_species='americanus')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='Ursus' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procyon' AND (species='lotor' OR species='lotor') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procyon' AND (junior_species='lotor' OR junior_species='lotor')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='Procyon' AND (species='lotor' OR species='lotor') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neogale' AND (junior_species='vison' OR junior_species='vison')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neogale' AND (species='vison' OR species='vison') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neogale' AND (junior_species='vison' OR junior_species='vison')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='Neogale' AND (species='vison' OR species='vison') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Martes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Martes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='sp.' OR junior_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='Martes' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mephitidae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mephitidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mephitidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mephitidae' AND (junior_species='indet.' OR junior_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='Mephitidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lynx' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='sp.' OR junior_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='Lynx' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Odocoileus' AND (junior_species='virginianus' OR junior_species='virginianus')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='Odocoileus' AND (species='virginianus' OR species='virginianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alces' AND (junior_species='alces' OR junior_species='alces')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alces' AND (species='alces' OR species='alces') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alces' AND (junior_species='alces' OR junior_species='alces')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='Alces' AND (species='alces' OR species='alces') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gavia' AND (junior_species='immer' OR junior_species='immer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gavia' AND (species='immer' OR species='immer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gavia' AND (species='immer' OR species='immer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gavia' AND (junior_species='immer' OR junior_species='immer')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='Gavia' AND (species='immer' OR species='immer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podiceps' AND (junior_species='auritus' OR junior_species='auritus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Podiceps' AND (species='auritus' OR species='auritus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Podiceps' AND (species='auritus' OR species='auritus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Podiceps' AND (junior_species='auritus' OR junior_species='auritus')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='Podiceps' AND (species='auritus' OR species='auritus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Botaurus' AND (junior_species='lentiginosus' OR junior_species='lentiginosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Botaurus' AND (species='lentiginosus' OR species='lentiginosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Botaurus' AND (species='lentiginosus' OR species='lentiginosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Botaurus' AND (junior_species='lentiginosus' OR junior_species='lentiginosus')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='Botaurus' AND (species='lentiginosus' OR species='lentiginosus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Branta' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Branta' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Branta' AND (species='canadensis' OR species='canadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Branta' AND (junior_species='canadensis' OR junior_species='canadensis')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='Branta' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' AND (junior_species='acuta' OR junior_species='acuta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anas' AND (species='acuta' OR species='acuta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anas' AND (species='acuta' OR species='acuta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' AND (junior_species='acuta' OR junior_species='acuta')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='Anas' AND (species='acuta' OR species='acuta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anas' AND (species='carolinensis' OR species='carolinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anas' AND (species='carolinensis' OR species='carolinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' AND (junior_species='carolinensis' OR junior_species='carolinensis')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='Anas' AND (species='carolinensis' OR species='carolinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spatula' AND (junior_species='clypeata' OR junior_species='clypeata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spatula' AND (species='clypeata' OR species='clypeata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spatula' AND (species='clypeata' OR species='clypeata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spatula' AND (junior_species='clypeata' OR junior_species='clypeata')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='Spatula' AND (species='clypeata' OR species='clypeata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aythya' AND (junior_species='collaris' OR junior_species='collaris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aythya' AND (species='collaris' OR species='collaris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aythya' AND (species='collaris' OR species='collaris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aythya' AND (junior_species='collaris' OR junior_species='collaris')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='Aythya' AND (species='collaris' OR species='collaris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aythya' AND (junior_species='marila' OR junior_species='marila')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aythya' AND (species='marila' OR species='marila') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aythya' AND (species='marila' OR species='marila')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aythya' AND (junior_species='marila' OR junior_species='marila')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='Aythya' AND (species='marila' OR species='marila') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aythya' AND (junior_species='affinis' OR junior_species='affinis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aythya' AND (species='affinis' OR species='affinis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aythya' AND (species='affinis' OR species='affinis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aythya' AND (junior_species='affinis' OR junior_species='affinis')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='Aythya' AND (species='affinis' OR species='affinis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bucephala' AND (junior_species='albeola' OR junior_species='albeola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bucephala' AND (species='albeola' OR species='albeola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bucephala' AND (species='albeola' OR species='albeola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bucephala' AND (junior_species='albeola' OR junior_species='albeola')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='Bucephala' AND (species='albeola' OR species='albeola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clangula' AND (junior_species='hyemalis' OR junior_species='hyemalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Clangula' AND (species='hyemalis' OR species='hyemalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Clangula' AND (species='hyemalis' OR species='hyemalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Clangula' AND (junior_species='hyemalis' OR junior_species='hyemalis')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='Clangula' AND (species='hyemalis' OR species='hyemalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitta' AND (junior_species='deglandi' OR junior_species='deglandii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitta' AND (species='deglandi' OR species='deglandii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitta' AND (species='deglandi' OR species='deglandii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitta' AND (junior_species='deglandi' OR junior_species='deglandii')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='Melanitta' AND (species='deglandi' OR species='deglandii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyura' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyura' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyura' AND (species='jamaicensis' OR species='jamaicensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyura' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')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='Oxyura' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mergus' AND (junior_species='serrator' OR junior_species='serrator')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mergus' AND (species='serrator' OR species='serrator') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mergus' AND (species='serrator' OR species='serrator')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mergus' AND (junior_species='serrator' OR junior_species='serrator')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='Mergus' AND (species='serrator' OR species='serrator') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mergus' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mergus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mergus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mergus' AND (junior_species='sp.' OR junior_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='Mergus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='sp.' OR junior_species='sp.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Accipiter' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' AND (junior_species='sp.' OR junior_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='Accipiter' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falcipennis' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Falcipennis' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Falcipennis' AND (species='canadensis' OR species='canadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falcipennis' AND (junior_species='canadensis' OR junior_species='canadensis')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='Falcipennis' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bonasa' AND (junior_species='umbellus' OR junior_species='umbellus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bonasa' AND (species='umbellus' OR species='umbellus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bonasa' AND (species='umbellus' OR species='umbellus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bonasa' AND (junior_species='umbellus' OR junior_species='umbellus')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='Bonasa' AND (species='umbellus' OR species='umbellus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallus' AND (junior_species='gallus' OR junior_species='gallus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gallus' AND (species='gallus' OR species='gallus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gallus' AND (species='gallus' OR species='gallus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gallus' AND (junior_species='gallus' OR junior_species='gallus')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='Gallus' AND (species='gallus' OR species='gallus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meleagris' AND (junior_species='gallopavo' OR junior_species='gallopavo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meleagris' AND (species='gallopavo' OR species='gallopavo') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meleagris' AND (species='gallopavo' OR species='gallopavo')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meleagris' AND (junior_species='gallopavo' OR junior_species='gallopavo')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='Meleagris' AND (species='gallopavo' OR species='gallopavo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectopistes' AND (junior_species='migratorius' OR junior_species='migratorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ectopistes' AND (species='migratorius' OR species='migratorius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ectopistes' AND (species='migratorius' OR species='migratorius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ectopistes' AND (junior_species='migratorius' OR junior_species='migratorius')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='Ectopistes' AND (species='migratorius' OR species='migratorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='auratus' OR junior_species='auratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colaptes' AND (species='auratus' OR species='auratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colaptes' AND (species='auratus' OR species='auratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='auratus' OR junior_species='auratus')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='Colaptes' AND (species='auratus' OR species='auratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocitta' AND (junior_species='cristata' OR junior_species='cristata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cyanocitta' AND (species='cristata' OR species='cristata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cyanocitta' AND (species='cristata' OR species='cristata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cyanocitta' AND (junior_species='cristata' OR junior_species='cristata')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='Cyanocitta' AND (species='cristata' OR species='cristata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corvus' AND (junior_species='corax' OR junior_species='corax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corvus' AND (species='corax' OR species='corax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corvus' AND (species='corax' OR species='corax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corvus' AND (junior_species='corax' OR junior_species='corax')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='Corvus' AND (species='corax' OR species='corax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corvus' AND (junior_species='brachyrhynchos' OR junior_species='brachyrhynchos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corvus' AND (species='brachyrhynchos' OR species='brachyrhynchos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corvus' AND (species='brachyrhynchos' OR species='brachyrhynchos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corvus' AND (junior_species='brachyrhynchos' OR junior_species='brachyrhynchos')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='Corvus' AND (species='brachyrhynchos' OR species='brachyrhynchos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chelydra' AND (junior_species='serpentina' OR junior_species='serpentina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chelydra' AND (species='serpentina' OR species='serpentina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chelydra' AND (species='serpentina' OR species='serpentina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chelydra' AND (junior_species='serpentina' OR junior_species='serpentina')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='Chelydra' AND (species='serpentina' OR species='serpentina') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyptemys' AND (junior_species='insculpta' OR junior_species='insculpta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Glyptemys' AND (species='insculpta' OR species='insculpta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Glyptemys' AND (species='insculpta' OR species='insculpta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Glyptemys' AND (junior_species='insculpta' OR junior_species='insculpta')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='Glyptemys' AND (species='insculpta' OR species='insculpta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysemys' AND (junior_species='picta' OR junior_species='picta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Chrysemys' AND (species='picta' OR species='picta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Chrysemys' AND (species='picta' OR species='picta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Chrysemys' AND (junior_species='picta' OR junior_species='picta')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='Chrysemys' AND (species='picta' OR species='picta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natricinae' AND (junior_species='indet.' OR junior_species='indet.')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Natricinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Natricinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Natricinae' AND (junior_species='indet.' OR junior_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='Natricinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3451 The Ecological Register: Keffer (Midden 57, screened)
Keffer (Midden 57, screened)
Basic information
Sample name: Keffer (Midden 57, screened)

Sample aka: AkGv-14

Reference: F. L. Stewart. 1991. Floating for fauna: some methodological considerations using the Keffer site (AkGv-14). Canadian Journal of Archaeology 15:97-115 [ER 3155]
Geography
Country: Canada

State: Ontario


Coordinate: 43° 50' N, 79° 30' W
Coordinate basis: based on nearby landmark

Time interval: Holocene

Ma: 0.00045

Age basis: other

Geography comments: "just north of Toronto in the town of Vaughan" (coordinate based on Vaughan)
"occupied possibly in the very last of the 15th century and certainly in the first two or three decades of the 16th century" (dating method unclear)

Environment
Lithology: not described

Taphonomic context: human accumulation,midden,settlement

Archaeology: buildings,ceramics,stone tools,other structures

Habitat comments: the site is "comprised of at least 26 middens and 19 houses surrounded by palisades which also enclosed some burials" with "ceramics and stone artifacts"

Methods
Life forms: carnivores,rodents,ungulates,other small mammals,birds,snakes,turtles,fishes

Sampling methods: quarry,screenwash

Sample size: 973 specimens

Sampled by: W. D. Finlayson

Years: 1985

Metadata
Sample number: 3451

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-09-02 13:02:28

Modified: 2023-02-25 10:54:53

Abundance distribution
67 species
22 singletons
total count 973
extrapolated richness: 120.8
Fisher's α: 16.324
geometric series k: 0.9290
Hurlbert's PIE: 0.9366
Shannon's H: 3.2265
Good's u: 0.9774
Each square represents a species. Square sizes are proportional to counts.
Register
Lepisosteus osseus3
"longnose gar"
Amia calva18
"bowfin"
Salmonidae indet.96
"trout"
Coregonus sp.129
"whitefish"
Esox lucius2
"northern pike"
Catostomidae indet.14
"sucker"
Ameirus sp.15
"bullhead"
Ictalurus punctatus1
"channel catfish"
Anguilla rostrata16
"American eel"
Ambloplites rupestris1
"rock bass"
Lepomis gibbosus24
"pumpkinseed"
Micropterus sp.4
"bass"
Perca flavescens13
"yelow perch"
Sander sp.18
"walleye" or "sauger"
Aplodinotus grunniens2
"freshwater drum"
Lepus americanus51.4 kg browser
"snowshoe hare"
Sciurus carolinensis14519 g frugivore
"grey squirrel"
Tamiasciurus hudsonicus14187 g
"red squirrel"
Marmota monax294.5 kg
"woodchuck"
Tamias striatus11113 g frugivore-insectivore
"eastern chipmunk"
Castor canadensis8511 kg
"beaver"
Peromyscus sp.3
Lemmini indet.1
"lemming mouse"
Microtus pennsylvanicus335.7 g
"meadow vole"
Microtus chrotorrhinus133.0 g
"rock vole"
Ondatra zibethicus251.1 kg
"muskrat"
Erethizon dorsatum19.9 kg herbivore
"porcupine"
Canis lupus familiaris6743 kg carnivore
"domestic dog"
Vulpes vulpes115.3 kg carnivore-insectivore
"red fox"
Ursus americanus19115 kg browser-insectivore
"black bear"
Procyon lotor125.5 kg carnivore-granivore
"raccoon"
Neogale vison3950 g
"mink"
Martes sp.6
"marten"
Mephitidae indet.1
"skunk"
Lynx sp.1
Odocoileus virginianus10975 kg herbivore
"white-tailed deer"
Alces alces2421 kg herbivore
"moose"
Gavia immer15.5 kg piscivore
"common loon"
Podiceps auritus1453 g
"horned grebe"
Botaurus lentiginosus1706 g piscivore
"American bittern"
Branta canadensis54.1 g folivore
"Canada goose"
Anas acuta11.0 kg
"pintail"
Anas carolinensis1
"green-winged teal"
Spatula clypeata1
"shoveller"
Aythya collaris1730 g granivore
"ring-necked duck"
Aythya marila11.1 kg
"greater scaup"
Aythya affinis1850 g
"lesser scaup"
Bucephala albeola3473 g
"bufflehead"
Clangula hyemalis5932 g
"oldsquaw"
Melanitta deglandi1
"white-winged scoter"
Oxyura jamaicensis1629 g
"ruddy duck"
Mergus serrator41.1 kg piscivore
"red-breasted merganser"
Mergus sp.1
"merganser sp."
Accipiter sp.3
"goshawk"
Falcipennis canadensis4492 g
"spruce grouse"
Bonasa umbellus15566 g omnivore
"ruffed grouse"
Gallus gallus129.1 g frugivore-granivore
"chicken"
Meleagris gallopavo337.8 kg omnivore
"wild turkey"
Ectopistes migratorius24
"passenger pigeon"
Colaptes auratus211.3 g insectivore-frugivore
"yellow-shafted flicker"
Cyanocitta cristata1 insectivore-granivore
"blue jay"
Corvus corax3 omnivore
"common raven"
Corvus brachyrhynchos1 omnivore
"common crow"
Chelydra serpentina13
"snapping turtle"
Glyptemys insculpta2
"wood turtle"
Chrysemys picta59
"painted turtle"
Natricinae indet.4
"water snake"