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=3936 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3936SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3714SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3936 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='timidus' OR junior_species='timidus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lepus' AND (species='timidus' OR species='timidus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='timidus' OR species='timidus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' AND (junior_species='timidus' OR junior_species='timidus')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='timidus' OR species='timidus') ORDER BY year,last_namesSELECT 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='Vulpes' 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='Vulpes' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vulpes' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' 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='Vulpes' AND (species='sp.' OR species='sp.') 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='hemionus' OR junior_species='hemionus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='hemionus' OR species='hemionus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='hemionus' OR species='hemionus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='hemionus' OR junior_species='hemionus')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='hemionus' OR species='hemionus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocerotidae' 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='Rhinocerotidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rhinocerotidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhinocerotidae' 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='Rhinocerotidae' AND (species='indet.' OR species='indet.') 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='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='Bovina' 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='Bovina' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bovina' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bovina' 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='Bovina' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3936
The Ecological Register: Chez-Pinaud Jonzac (Layer 22)
Reference:L. Niven, T. E. Steele, W. Rendu, J. B. Mallye, S. P. McPherron, M. Soressi, J. Jaubert, and J. J. Hublin. 2012. Neandertal mobility and large-game hunting: The exploitation of reindeer during the Quina Mousterian at Chez-Pinaud Jonzac (Charente-Maritime, France). Journal of Human Evolution63(4):624-635 [ER 3714]
Geography
Country: France
State: Nouvelle-Aquitaine
Coordinate:45° 26' 48" N, 0° 26' 1" W
Coordinate basis: based on nearby landmark
Time interval: Late Pleistocene
Ma: 0.0727
Max Ma: 0.0813
Min Ma: 0.068
Age basis: thermoluminescence
Geography comments: "Chez Pinaud Jonzac is a collapsed rockshelter situated against a low limestone cliff face in the broad valley of the Seugne River, a tributary of the Charente River, in the Charente-Maritime region of southwest France".
Thermoluminescence dates on heated flint artefacts from Layer 22 range from 68 ± 12.7 ka to 81.3 ± 14.3 ka. The weighted mean is 72.7 ± 7.9 ka" (from Richter et al. 2013).
•
Environment
Lithology: sandstone
Taphonomic context: cave,human accumulation
Archaeology: stone tools
Habitat comments: "The archaeological sequence is contained in deposits that have been divided into five geological units. The lowest most layers are located in a deposit of yellow–brown, clayey sands with no evidence of soil formation and with little evidence of stratification except for some more sandy lenses localized against the cliff face".
"The Middle Paleolithic sequence starts just above bedrock at the base with a nearly 1.5 m thick bonebed deposit (Layer 22) that is extremely rich in well-preserved faunal remains associated with a Quina Mousterian lithic industry, also in a relatively high density".
"Reindeer are by far the most dominant species. Zooarchaeological analyses indicate these were hunted when they were seasonally abundant in the local area and were butchered on-site, with abundant evidence of meat filleting and marrow exploitation".
Methods
Life forms: carnivores,rodents,ungulates,other small mammals
Sampling methods: quarry,screenwash
Sample size: 2325 specimens
Years: 2004 - 2007
Sampling comments: "An initial campaign of excavations was undertaken between 1998 and 2003, and was followed by a new program conducted from 2004 to 2007. During the 2004–2007 excavations, the initial ∼2 m2 test unit was expanded to a surface of ∼5.5 m2. Every archaeological find (bone and stone) > 2.5 cm was piece-plotted in three dimensions using a total station. If the bone specimen was < 2.5 cm but diagnostic (e.g. tooth, tarsal, sesamoid), it was also recorded separately".
"All sediment was water-screened through fine mesh (2 and 5 mm)". Due to the high densities of lithics and bone, a "décapage approach was used in which sediments were removed using fine utensils to expose a surface of bones. All specimens were then mapped in place before they were removed".
Metadata
Sample number: 3936
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2022-03-29 16:06:22
Modified: 2022-04-06 01:11:09
Abundance distribution
9 species
2 singletons
total count 2325
extrapolated richness: 13.7
Fisher's α: 1.187
geometric series k: 0.3883
Hurlbert's PIE: 0.2934
Shannon's H: 0.6070
Good's u: 0.9991
Each square represents a species. Square sizes are proportional to counts.