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=4170 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4170SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3824SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4170 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionailurus' AND (junior_species='bengalensis' OR junior_species='bengalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prionailurus' AND (species='bengalensis' OR species='bengalensis') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prionailurus' AND (junior_species='bengalensis' OR junior_species='bengalensis')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='Prionailurus' AND (species='bengalensis' OR species='bengalensis') 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='Lepus' 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='Lepus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lepus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lepus' 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='Lepus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotonoides' 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='Ochotonoides' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ochotonoides' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ochotonoides' 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='Ochotonoides' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procapra' AND (junior_species='przewalskii' OR junior_species='przewalski')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Procapra' AND (species='przewalskii' OR species='przewalski') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Procapra' AND (species='przewalskii' OR species='przewalski')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Procapra' AND (junior_species='przewalskii' OR junior_species='przewalski')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='Procapra' AND (species='przewalskii' OR species='przewalski') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervidae' 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='Cervidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cervidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cervidae' 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='Cervidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubalus' 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='Bubalus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bubalus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubalus' 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='Bubalus' 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='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='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='Struthio' AND (junior_species='anderssoni' OR junior_species='anderssonii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Struthio' AND (species='anderssoni' OR species='anderssonii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Struthio' AND (species='anderssoni' OR species='anderssonii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Struthio' AND (junior_species='anderssoni' OR junior_species='anderssonii')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='Struthio' AND (species='anderssoni' OR species='anderssonii') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4170 The Ecological Register: Shuidonggou Locality 7
Shuidonggou Locality 7
Basic information
Sample name: Shuidonggou Locality 7

Sample aka: SDG7

Reference: S. Zhang, Y. Zhang, S. Pei, and X. Gao. 2020. Human exploitation of carnivores in Pleistocene China: A case study of the faunal remains from Shuidonggou Locality 7. Science China Earth Sciences 63(1):132-144 [ER 3824]
Geography
Country: China

State: Ningxia


Coordinate: 38° 17' 51" N, 106° 30' 21" E
Coordinate basis: stated in text

Time interval: Late Pleistocene

Max Ma: 0.03

Min Ma: 0.023

Age basis: OSL

Geography comments: there are OSL dates "from 23±2 to 30±3 ka BP"

•
Environment
Lithology: not described

Taphonomic context: human accumulation

Archaeology: stone tools,other artifacts

Habitat comments: "archaeological remains are restricted to the lowest four layers (layers 7–10)"
"9901 stone artifacts, in addition to two ostrich eggshell beads and a large number of animal bones, were recovered"
"cut-marked bone at SDG7 provides clear evidence of hominin exploitation... humans were the main agent responsible for the accumulation and modification of faunal remains"

Methods
Life forms: carnivores,ungulates,other small mammals,birds

Sampling methods: quarry,screenwash

Sample size: 147 specimens

Years: 2003 - 2005

Sampling comments: "an area of 25 m2 was exposed... sediments excavated therefrom were dry-sieved with a 4 mm mesh"
counts for Ochotonoides, Coelodonta antiquitatis, and Struthio anderssoni are based on the original faunal description of Zhang et al. (2014, Acta Anthropologica Sinica)

Metadata
Sample number: 4170

Contributor: John Alroy

Enterer: John Alroy

Created: 2023-03-15 19:56:39

Modified: 2023-03-15 08:56:39

Abundance distribution
10 species
4 singletons
total count 147
extrapolated richness: 17.5
Fisher's α: 2.427
geometric series k: 0.6781
Hurlbert's PIE: 0.8297
Shannon's H: 1.8706
Good's u: 0.9728
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Prionailurus bengalensis13.4 kg carnivore
"Felis chinensis"
Vulpes vulpes15.3 kg carnivore-insectivore
"Vulpes vulgaris": plus two indeterminate canid bones
Lepus sp.15
Ochotonoides sp.1
Procapra przewalskii33
Cervidae indet.26
may include the indeterminate antilopine of Zhang et al. 2014
Bubalus sp.19
Equus hemionus30 grazer
Coelodonta antiquitatis1
Struthio anderssoni20
broken egg shells