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=4342 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4342SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3937SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4342 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='marmota' OR junior_species='marmota')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Marmota' AND (species='marmota' OR species='marmota') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Marmota' AND (species='marmota' OR species='marmota')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Marmota' AND (junior_species='marmota' OR junior_species='marmota')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='marmota' OR species='marmota') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castor' AND (junior_species='fiber' OR junior_species='fiber')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castor' AND (species='fiber' OR species='fiber') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castor' AND (species='fiber' OR species='fiber')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castor' AND (junior_species='fiber' OR junior_species='fiber')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='fiber' OR species='fiber') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='europaeus' OR junior_species='europaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='europaeus' OR species='europaeus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='europaeus' OR junior_species='europaeus')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='europaeus' OR species='europaeus') 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='spelaeus' OR junior_species='spelaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ursus' AND (species='spelaeus' OR species='spelaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ursus' AND (species='spelaeus' OR species='spelaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' AND (junior_species='spelaeus' OR junior_species='spelaeus')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='spelaeus' OR species='spelaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gulo' AND (junior_species='gulo' OR junior_species='gulo')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gulo' AND (species='gulo' OR species='gulo') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gulo' AND (junior_species='gulo' OR junior_species='gulo')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='Gulo' AND (species='gulo' OR species='gulo') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='erminea' OR junior_species='erminea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mustela' AND (species='erminea' OR species='erminea') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='erminea' OR junior_species='erminea')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='Mustela' AND (species='erminea' OR species='erminea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='putorius' OR junior_species='putorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mustela' AND (species='putorius' OR species='putorius') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mustela' AND (junior_species='putorius' OR junior_species='putorius')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='Mustela' AND (species='putorius' OR species='putorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meles' AND (species='meles' OR species='meles') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')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='Meles' AND (species='meles' OR species='meles') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocuta' 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='Crocuta' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocuta' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocuta' 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='Crocuta' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' 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='Felis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Felis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' 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='Felis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='lynx' OR junior_species='lynx')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='lynx' OR species='lynx') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='lynx' OR junior_species='lynx')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='lynx' OR species='lynx') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='spelaea' OR junior_species='spelaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='spelaea' OR species='spelaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panthera' AND (species='spelaea' OR species='spelaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='spelaea' OR junior_species='spelaea')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='Panthera' AND (species='spelaea' OR species='spelaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mammuthus' AND (junior_species='primigenius' OR junior_species='primigenius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mammuthus' AND (species='primigenius' OR species='primigenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mammuthus' AND (species='primigenius' OR species='primigenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mammuthus' AND (junior_species='primigenius' OR junior_species='primigenius')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='Mammuthus' AND (species='primigenius' OR species='primigenius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='ferus' OR species='ferus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='ferus' OR junior_species='ferus')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='Equus' AND (species='ferus' OR species='ferus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='hydruntinus' OR junior_species='hydruntinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='hydruntinus' OR species='hydruntinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='hydruntinus' OR species='hydruntinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='hydruntinus' OR junior_species='hydruntinus')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='Equus' AND (species='hydruntinus' OR species='hydruntinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelodonta' AND (junior_species='antiquitatis' OR junior_species='antiquitatis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Coelodonta' AND (species='antiquitatis' OR species='antiquitatis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Coelodonta' AND (species='antiquitatis' OR species='antiquitatis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Coelodonta' AND (junior_species='antiquitatis' OR junior_species='antiquitatis')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='Coelodonta' AND (species='antiquitatis' OR species='antiquitatis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' AND (junior_species='scrofa' OR junior_species='scrofa')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='Sus' AND (species='scrofa' OR species='scrofa') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cervus' AND (species='elaphus' OR species='elaphus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervus' AND (junior_species='elaphus' OR junior_species='elaphus')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='elaphus' OR species='elaphus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaloceros' 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='Megaloceros' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megaloceros' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megaloceros' 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='Megaloceros' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' AND (junior_species='capreolus' OR junior_species='capreolus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capreolus' AND (species='capreolus' OR species='capreolus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capreolus' AND (junior_species='capreolus' OR junior_species='capreolus')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='Capreolus' AND (species='capreolus' OR species='capreolus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rangifer' AND (junior_species='tarandus' OR junior_species='tarandus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rangifer' AND (species='tarandus' OR species='tarandus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rangifer' AND (junior_species='tarandus' OR junior_species='tarandus')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='Rangifer' AND (species='tarandus' OR species='tarandus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saiga' AND (junior_species='tatarica' OR junior_species='tatarica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Saiga' AND (species='tatarica' OR species='tatarica') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Saiga' AND (junior_species='tatarica' OR junior_species='tatarica')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='Saiga' AND (species='tatarica' OR species='tatarica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' AND (junior_species='priscus' OR junior_species='priscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bison' AND (species='priscus' OR species='priscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bison' AND (species='priscus' OR species='priscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' AND (junior_species='priscus' OR junior_species='priscus')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='Bison' AND (species='priscus' OR species='priscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='ibex' OR junior_species='ibex')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capra' AND (species='ibex' OR species='ibex') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='ibex' OR junior_species='ibex')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='Capra' AND (species='ibex' OR species='ibex') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4342 The Ecological Register: Vergisson II
Vergisson II
Basic information
Sample name: Vergisson II

Reference: M. Jeannet. 2018. Vergisson II (Saône-et-Loire, France): microfaune et environnement de l'Homme de Néandertal. Quaternaire 29(3):233-242 [ER 3937]
Geography
Country: France


Coordinate: 46° 19' N, 4° 43' E
Coordinate basis: based on nearby landmark

Time interval: Late Pleistocene

Zone: MIS 4

Max Ma: 0.071

Min Ma: 0.057

Age basis: zone

Geography comments: "on the south-western slope of the Roche de Vergisson" (basis of coordinate)
assigned to MIS 4 (basis of numerical age assignment) based on biochronology

Environment
Lithology: siliciclastic (mixed)

Taphonomic context: cave

Archaeology: stone tools

Habitat comments: the lithology is a reddish clay with medium-sized gravel
taphonomy and accumulation agents are not discussed
a Mousterian industry of the Quina type is represented by artefacts

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

Sampling methods: quarry

Sample size: 2979 specimens

Years: 1952, 1954 - 1961

Sampling comments: the cave was discovered in 1946 and excavated in 1952 and from 1954 to 1961
an abundant small mammal fauna is discussed, but specimen counts are not provided
"vingtaine" Neanderthal teeth (assumed to be 20) are mentioned in the text, but not listed in the table

Metadata
Sample number: 4342

Contributor: John Alroy

Enterer: John Alroy

Created: 2023-08-13 16:57:01

Modified: 2023-08-13 06:57:01

Abundance distribution
26 species
6 singletons
total count 2979
extrapolated richness: 40.1
Fisher's α: 3.919
geometric series k: 0.7431
Hurlbert's PIE: 0.6400
Shannon's H: 1.4718
Good's u: 0.9980
Each square represents a species. Square sizes are proportional to counts.
Register