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=4164 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4164SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3819SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4164 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' 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='Homo' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Homo' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Homo' 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='Homo' AND (species='sp.' OR species='sp.') 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='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='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='Equus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' 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='Equus' AND (species='sp.' OR species='sp.') 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='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='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 * FROM register WHERE sample_no=4164 The Ecological Register: Salzgitter Lebenstedt
Salzgitter Lebenstedt
Basic information
Sample name: Salzgitter Lebenstedt

Reference: S. Gaudzinski and W. Roebroeks. 2000. Adults only. Reindeer hunting at the Middle Palaeolithic site Salzgitter Lebenstedt, Northern Germany. Journal of Human Evolution 38:497-521 [ER 3819]
Geography
Country: Germany


Coordinate: 52.17° N, 10.33° E
Coordinate basis: estimated from map

Time interval: Late Pleistocene

Ma: 0.05

Age basis: radiocarbon

Geography comments: "on the northern slope of a small river, the Kråhenriedebach" (coordinate estimated based on Kråhenriede, which is a stream within the Salzgitter area of Lebenstedt)
from "earlier part of the last (Weichsel) glacial (OIS5-3)" with "C14-dates obtained on humic extracts from the peaty find level" of "around 50,000 bp" based on an unpublished PhD thesis

Environment
Lithology: mudstone

Taphonomic context: fluvial deposit,human accumulation

Archaeology: bone tools,stone tools

Habitat comments: "finds were recovered at a depth of 4.5-5.5 m - most at a depth between 4.8 and 5.1 m... from waterlogged fluvial sediments"
fossils were from the "lower two" sub-units which are "sandy": apparently a sandstone above, and a "peaty mud" below
there are "840 flint artefacts" and "30 bone tools, mainly produced from mammoth bones"
there is clear evidence of human hunting of the reindeer such as "cut and impact marks"

Methods
Life forms: carnivores,primates,ungulates

Sampling methods: quarry

Sample size: 2860 specimens

Sampled by: A. Tode

Years: 1952

Sampling comments: site area was "approximately 150 m2"
counts are only of large mammals
human fossils are referred to as "Neanderthal" but listed as Homo sp.
pollen, "macro-botanical remains", fungi, and micromammals presumably including rodents are also present

Metadata
Sample number: 4164

Contributor: John Alroy

Enterer: John Alroy

Created: 2023-03-14 20:48:36

Modified: 2023-05-09 02:00:11

Abundance distribution
7 species
1 singleton
total count 2860
extrapolated richness: 8.7
Fisher's α: 0.864
geometric series k: 0.2788
Hurlbert's PIE: 0.4175
Shannon's H: 0.8285
Good's u: 0.9997
Each square represents a species. Square sizes are proportional to counts.
Register