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=2544 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2544SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2367SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2544 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' 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='Apodemus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Apodemus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Apodemus' 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='Apodemus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocranius' AND (junior_species='gregalis' OR junior_species='gregalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stenocranius' AND (species='gregalis' OR species='gregalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stenocranius' AND (species='gregalis' OR species='gregalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stenocranius' AND (junior_species='gregalis' OR junior_species='gregalis')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='Stenocranius' AND (species='gregalis' OR species='gregalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='oeconomus' OR junior_species='oeconomus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Alexandromys' AND (species='oeconomus' OR species='oeconomus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Alexandromys' AND (junior_species='oeconomus' OR junior_species='oeconomus')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='Alexandromys' AND (species='oeconomus' OR species='oeconomus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicola' AND (junior_species='amphibius' OR junior_species='amphibius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arvicola' AND (species='amphibius' OR species='amphibius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Arvicola' AND (species='amphibius' OR species='amphibius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicola' AND (junior_species='amphibius' OR junior_species='amphibius')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='Arvicola' AND (species='amphibius' OR species='amphibius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrostonyx' AND (junior_species='torquatus' OR junior_species='torquatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dicrostonyx' AND (species='torquatus' OR species='torquatus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dicrostonyx' AND (junior_species='torquatus' OR junior_species='torquatus')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='Dicrostonyx' AND (species='torquatus' OR species='torquatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neomys' AND (junior_species='fodiens' OR junior_species='fodiens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Neomys' AND (species='fodiens' OR species='fodiens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neomys' AND (species='fodiens' OR species='fodiens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neomys' AND (junior_species='fodiens' OR junior_species='fodiens')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='Neomys' AND (species='fodiens' OR species='fodiens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2544 The Ecological Register: Bois Roche (layer 2)
Bois Roche (layer 2)
Basic information
Sample name: Bois Roche (layer 2)

Reference: C. Sesé and P. Villa. 2008. Micromammals (rodents and insectivores) from the early Late Pleistocene cave site of Bois Roche (Charente, France): Systematics and paleoclimatology. Geobios 41:399-414 [ER 2367]
Geography
Country: France


Coordinate: 45° 42' N, 0° 20' W
Coordinate basis: based on nearby landmark

Time interval: Late Pleistocene

Ma: 0.071

Geography comments: "near the city of Cognac" (coordinate based on Cognac)
"dated to late OIS 5 or early OIS 4 by preliminary ESR estimates" (i.e., roughly 71 kyr)

•
Environment
Substrate: ground surface

Lithology: siltstone

Habitat comments: "a massive (up to 30–40 cm) clast-supported accumulation of clayey silt with centimeter to decimeter size blocks of limestone roof fall"

Methods
Life forms: rodents

Sampling methods: quarry,screenwash

Sample size: 2724 specimens

Years: 1995, 1997-2000

Sampling comments: "Our excavations were done by 1-m grid system... All sediments were waters-creened with superimposed screens of 5 and 2 mm mesh"

Metadata
Sample number: 2544

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-15 09:37:21

Modified: 2017-02-14 22:37:21

Abundance distribution
6 species
3 singletons
total count 2724
extrapolated richness: 12.6
Fisher's α: 0.729
geometric series k: 0.2076
Hurlbert's PIE: 0.0923
Shannon's H: 0.2114
Good's u: 0.9989
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Apodemus sp.1
Stenocranius gregalis2592
"Microtus gregalis"
Alexandromys oeconomus836.5 g
"Microtus oeconomus"
Arvicola amphibius121
"Arvicola terrestris"
Dicrostonyx torquatus152.0 g
Neomys cf. fodiens1