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=3354 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3354SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3080SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3354 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carnivora' 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='Carnivora' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carnivora' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carnivora' 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='Carnivora' AND (species='indet.' OR species='indet.') 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='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='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='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='Capra' AND (junior_species='pyrenaica' OR junior_species='pyrenaica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capra' AND (species='pyrenaica' OR species='pyrenaica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capra' AND (species='pyrenaica' OR species='pyrenaica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='pyrenaica' OR junior_species='pyrenaica')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='pyrenaica' OR species='pyrenaica') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rupicapra' AND (junior_species='pyrenaica' OR junior_species='pyrenaica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rupicapra' AND (species='pyrenaica' OR species='pyrenaica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Rupicapra' AND (species='pyrenaica' OR species='pyrenaica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rupicapra' AND (junior_species='pyrenaica' OR junior_species='pyrenaica')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='Rupicapra' AND (species='pyrenaica' OR species='pyrenaica') 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 * FROM register WHERE sample_no=3354
Reference:M. A. Fano, A. García-Moreno, A. Chauvin, I. Clemente-Conte, S. Costamagno, I. Elorrieta-Baigorri, N. E. Pascual, and A. Tarriño. 2016. Contribution of landscape analysis to the characterisation of Palaeolithic sites: A case study from El Horno Cave (northern Spain). Quaternary International412:82-98 [ER 3080]
Geography
Country: Spain
State: Cantabria
Coordinate:43° 15' N, 3° 27' W
Coordinate basis: stated in text
Time interval: Late Pleistocene
Section: 3080
Unit number: 2
Unit order: above to below
Max Ma: 0.013092
Min Ma: 0.0118
Age basis: radiocarbon (calibrated)
Geography comments: "in the middle Ason valley, at the base of a vertical wall on the south-west side of Monte Pando"
coordinate based on Cueva de Covalanas
"A sample of bones from the upper part of the level (all collected at the same depth) was used for the radiocarbon determination GX-27456 (12,250±190 BP,13,092-11,800 cal BC"
•
Environment
Lithology: limestone
Taphonomic context: cave,human accumulation
Habitat comments: "0.23 m thick, a brown sediment, very rich in organic matter and with abundant archaeological material"
"the impact of carnivores is very limited (less than 1% of the toothmarks on the remains). Taphonomic analysis strongly suggests a human origin for the fauna"
Methods
Life forms: carnivores,ungulates,other small mammals
Sampling methods: quarry
Sample size: 844 specimens
Years: 1999 - 2007
Metadata
Sample number: 3354
Contributor: John Alroy
Enterer: John Alroy
Created: 2019-08-26 15:05:23
Modified: 2023-04-29 00:36:28
Abundance distribution
8 species
1 singleton
total count 844
extrapolated richness: 11.5
Fisher's α: 1.224
geometric series k: 0.3955
Hurlbert's PIE: 0.3489
Shannon's H: 0.6415
Good's u: 0.9988
Each square represents a species. Square sizes are proportional to counts.