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=3461 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3461SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3161SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3461 ORDER BY register_no ASCSELECT 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='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='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='Urocyon' AND (junior_species='cinereoargenteus' OR junior_species='cinereoargenteus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Urocyon' AND (species='cinereoargenteus' OR species='cinereoargenteus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urocyon' AND (junior_species='cinereoargenteus' OR junior_species='cinereoargenteus')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='Urocyon' AND (species='cinereoargenteus' OR species='cinereoargenteus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='canadensis' OR junior_species='canadensis')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='Cervus' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='canadensis' OR junior_species='canadensis')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='Cervus' AND (species='canadensis' OR species='canadensis') 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='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='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='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='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='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='Bos' AND (junior_species='taurus' OR junior_species='taurus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='taurus' OR species='taurus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='taurus' OR junior_species='taurus')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='Bos' AND (species='taurus' OR species='taurus') 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='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='Martes' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Martes' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Martes' AND (junior_species='americana' OR junior_species='americana')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='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' 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='Microtus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Microtus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Microtus' 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='Microtus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sylvilagus' AND (junior_species='floridanus' OR junior_species='floridanus')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='Sylvilagus' AND (species='floridanus' OR species='floridanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='maniculatus' OR junior_species='maniculatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Peromyscus' AND (species='maniculatus' OR species='maniculatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Peromyscus' AND (junior_species='maniculatus' OR junior_species='maniculatus')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='maniculatus' OR species='maniculatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pekania' AND (junior_species='pennanti' OR junior_species='pennantii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pekania' AND (species='pennanti' OR species='pennantii') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pekania' AND (junior_species='pennanti' OR junior_species='pennantii')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='Pekania' AND (species='pennanti' OR species='pennantii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Homo' AND (species='sapiens' OR species='sapiens') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' AND (junior_species='sapiens' OR junior_species='sapiens')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='Homo' AND (species='sapiens' OR species='sapiens') 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='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='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='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='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='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='Ictalurus' AND (junior_species='nebulosus' OR junior_species='nebulosus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ictalurus' AND (species='nebulosus' OR species='nebulosus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ictalurus' AND (species='nebulosus' OR species='nebulosus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ictalurus' AND (junior_species='nebulosus' OR junior_species='nebulosus')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='nebulosus' OR species='nebulosus') 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='Salvelinus' AND (junior_species='namaycush' OR junior_species='namaycush')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Salvelinus' AND (species='namaycush' OR species='namaycush') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salvelinus' AND (species='namaycush' OR species='namaycush')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salvelinus' AND (junior_species='namaycush' OR junior_species='namaycush')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='Salvelinus' AND (species='namaycush' OR species='namaycush') 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='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='Stizostedion' 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='Stizostedion' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stizostedion' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stizostedion' 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='Stizostedion' AND (species='sp.' OR species='sp.') 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='Perciformes' 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='Perciformes' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perciformes' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perciformes' 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='Perciformes' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salmo' 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='Salmo' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Salmo' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Salmo' 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='Salmo' AND (species='sp.' OR species='sp.') 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='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='Buteo' 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='Buteo' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buteo' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' 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='Buteo' AND (species='sp.' OR species='sp.') 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='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='Melanitta' AND (junior_species='nigra' OR junior_species='nigra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melanitta' AND (species='nigra' OR species='nigra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melanitta' AND (species='nigra' OR species='nigra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melanitta' AND (junior_species='nigra' OR junior_species='nigra')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='nigra' OR species='nigra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anatidae' 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='Anatidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anatidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anatidae' 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='Anatidae' AND (species='indet.' OR species='indet.') 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='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='Terrapene' AND (junior_species='carolina' OR junior_species='carolina')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Terrapene' AND (species='carolina' OR species='carolina') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Terrapene' AND (species='carolina' OR species='carolina')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Terrapene' AND (junior_species='carolina' OR junior_species='carolina')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='Terrapene' AND (species='carolina' OR species='carolina') 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='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='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 * FROM register WHERE sample_no=3461 The Ecological Register: Irving-Johnston
Irving-Johnston
Basic information
Sample name: Irving-Johnston

Sample aka: AjGx-27

Reference: F. L. Stewart and W. D. Finlayson. 2000. Subsistence at the Irving-Johnston village and the question of deer tending by the neutrals. Canadian Journal of Archaeology 24(1):17-40 [ER 3161]
Geography
Country: Canada

State: Ontario


Coordinate: 43° 28' N, 79° 57' W
Coordinate basis: based on nearby landmark

Time interval: Holocene

Max Ma: 0.000387

Min Ma: 0.000367

Age basis: other

Geography comments: "just south of Campbellville... 9.3 km north of Crawford Lake" (coordinate based on Crawford Lake Conservation Area)
"Using pottery rim sherd seriations and correlations to the varved sediments of Crawford Lake, which contain corn and other pollens, this site has been dated to ca. A.D. 1563 to 1583"

•
Environment
Lithology: not described

Taphonomic context: human accumulation,midden,settlement

Archaeology: ceramics

Habitat comments: material was identified from six middens
there is no discussion of lithics or of structures such as hearths or pit moulds

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

Sampling methods: quarry,screenwash

Sample size: 1444 specimens

Sampling comments: "the dirt was screened through a 0.6 mm mesh"

Metadata
Sample number: 3461

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-09-03 14:43:35

Modified: 2023-02-25 11:21:48

Abundance distribution
48 species
16 singletons
total count 1444
extrapolated richness: 93.0
Fisher's α: 9.552
geometric series k: 0.8655
Hurlbert's PIE: 0.6072
Shannon's H: 1.7282
Good's u: 0.9889
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Odocoileus virginianus88775 kg herbivore
Castor canadensis11011 kg
Ursus americanus77115 kg browser-insectivore
Urocyon cinereoargenteus14.1 kg frugivore-carnivore
Cervus canadensis64329 kg browser-grazer
"Cervus elaphus"
Sciurus carolinensis25519 g frugivore
Procyon lotor145.5 kg carnivore-granivore
Tamias striatus13113 g frugivore-insectivore
Canis lupus familiaris6943 kg carnivore
"Canis familiaris"
Marmota monax74.5 kg
Alces alces4421 kg herbivore
Bos taurus3337 kg
Ondatra zibethicus31.1 kg
Vulpes vulpes35.3 kg carnivore-insectivore
Martes americana2946 g
Microtus sp.2
Sylvilagus floridanus11.1 kg herbivore
Peromyscus maniculatus119.1 g
Pekania pennanti13.8 kg
"Martes pennanti"
Homo sapiens164 kg
Neogale vison1950 g
"Mustela vison"
Erethizon dorsatum19.9 kg herbivore
Tamiasciurus hudsonicus1187 g
Lepus americanus11.4 kg browser
Coregonus sp.15
Catostomidae indet.14
Ictalurus nebulosus4
Esox lucius4
Salvelinus namaycush3
Anguilla rostrata2
Micropterus sp.2
Stizostedion sp.2
Amia calva1
Perciformes indet.1
Salmo sp.1
Ectopistes migratorius53
Meleagris gallopavo147.8 kg omnivore
one specimen tentatively referred
Buteo sp.3
Corvus brachyrhynchos2 omnivore
Colaptes auratus211.3 g insectivore-frugivore
Melanitta nigra11.1 kg
Anatidae indet.1
Bonasa umbellus1566 g omnivore
Corvus corax1 omnivore
Terrapene carolina9
Glyptemys insculpta7
"Clemmys insculpta": one specimen tentatively referred
Chelydra serpentina5
Chrysemys picta4