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=4109 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4109SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3786SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4109 ORDER BY register_no ASCSELECT 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='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 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='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='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='rupicapra' OR junior_species='rupicapra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rupicapra' AND (species='rupicapra' OR species='rupicapra') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rupicapra' AND (junior_species='rupicapra' OR junior_species='rupicapra')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='rupicapra' OR species='rupicapra') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4109
The Ecological Register: El Mirón Cave (Final Magdalenian)
Reference:G. Cuenca-Bescós, A. B. Marín-Arroyo, I. Martínez, M. R. González-Morales, and L. G. Straus. 2012. Relationship between Magdalenian subsistence and environmental change: the mammalian evidence from El Mirón (Spain). Quaternary International272:125-137 [ER 3786]
Geography
Country: Spain
State: Cantabria
Coordinate:43° 14' 47" N, 3° 27' 4" W
Coordinate basis: stated in text
Time interval: Pleistocene - Holocene
Section: 3786
Unit number: 2
Unit order: above to below
Max Ma: 0.011942
Min Ma: 0.01158
Age basis: radiocarbon (calibrated)
Geography comments: "El Mirón is a large cave in the upper Ason River Valley of the Cantabrian Cordillera of northern Spain".
The Final Magdalenian levels of the site have been radiocarbon dated to between 11,942 and 11,580 cal. BP.
•
Environment
Lithology: not described
Taphonomic context: cave,human accumulation
Archaeology: hearths,stone tools
Habitat comments: The cave was used fairly continuously by humans. The entire Magdalenian and Azilian cultural periods contain abundant lithic assemblages, associated with hearth remains. Humans were the principal bone accumulators of the large mammal assemblage, while birds of prey (owls) were likely responsible for the gathering of small mammal fauna.
Methods
Life forms: ungulates
Sampling methods: quarry,screenwash
Sample size: 881 specimens
Years: 1996 - 2000
Sampling comments: "Sediments were washed through a graded series of sieves, from 2 cm to 1 mm, and were water-screened through fine mesh for the recovery of small vertebrate remains. This produced a rich and species-diverse assemblage of mainly rodents and insectivores, though also small carnivores, bats, lagomorphs, fishes, amphibians, reptiles and birds".
"A total of 5200 ungulate remains were identified, taxonomically distributed across 7 species". These are the only identified remains with NISP data reported; the numerous remains of small mammals are only given as MNI, of which there are "a minimum of 1915 individuals across 22 species".
Metadata
Sample number: 4109
Contributor: Benjamin Carter
Enterer: Benjamin Carter
Created: 2023-02-24 14:04:39
Modified: 2023-05-30 05:14:13
Abundance distribution
7 species
0 singletons
total count 881
extrapolated richness: 8.5
Fisher's α: 1.038
geometric series k: 0.4061
Hurlbert's PIE: 0.6008
Shannon's H: 1.0929
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.