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=4111 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4111SELECT 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=4111 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='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=4111 The Ecological Register: El Mirón Cave (Upper Magdalenian)
El Mirón Cave (Upper Magdalenian)
Basic information
Sample name: El Mirón Cave (Upper 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 International 272: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: Late Pleistocene

Section: 3786

Unit number: 3

Unit order: above to below

Max Ma: 0.013853

Min Ma: 0.01246

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 Upper Magdalenian levels of the site have been radiocarbon dated to between 13,853 and 12,460 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: 932 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: 4111

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2023-02-24 14:07:13

Modified: 2023-05-30 05:14:10

Abundance distribution
6 species
0 singletons
total count 932
extrapolated richness: 6.6
Fisher's α: 0.858
geometric series k: 0.3686
Hurlbert's PIE: 0.5610
Shannon's H: 0.9599
Good's u: 1.0000
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Equus ferus11422 kg
"Equus caballus": not domesticated
Cervus elaphus430104 kg
Capreolus capreolus1122 kg browser
Sus scrofa354 kg herbivore
Capra pyrenaica441
Rupicapra rupicapra3627 kg browser-grazer