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=4115 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4115SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3788SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4115 ORDER BY register_no ASCSELECT 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='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='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='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='Meles' AND (junior_species='meles' OR junior_species='meles')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meles' AND (species='meles' OR species='meles') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='meles' OR junior_species='meles')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='Meles' AND (species='meles' OR species='meles') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4115 The Ecological Register: La Fragua Cave (Level 1)
La Fragua Cave (Level 1)
Basic information
Sample name: La Fragua Cave (Level 1)

Reference: A. B. Marín-Arroyo and M. R. Gonzalez Morales. 2007. La Fragua Cave, a seasonal hunting camp in the lower Asón Valley (Cantabria, Spain) at the Pleistocene-Holocene transition. Anthropozoologica 42(1):61-84 [ER 3788]
Geography
Country: Spain

State: Cantabria


Coordinate: 43° 26' 29" N, 3° 27' 27" W
Coordinate basis: based on nearby landmark

Time interval: Holocene

Section: 3788

Unit number: 1

Unit order: above to below

Max Ma: 0.00753

Min Ma: 0.00665

Age basis: radiocarbon (uncalibrated)

Geography comments: "La Fragua Cave is located at 125 m above sea level on the southeastern slope of Mount Buciero, in Santoña (basis of coordinate), eastern Cantabria, Spain".
Radiocarbon dates for Level 1 of the deposit range from 7,530 ± 70 to 6,650 ± 120 BP.

•
Environment
Lithology: claystone

Taphonomic context: cave,human accumulation,midden

Archaeology: stone tools

Habitat comments: "There are four main stratigraphic levels within the cave: Level 1 consists of a shell midden within a dirt matrix. A small number of lithic artefacts have been found in the deposit. The characteristics of the lithic assemblage show that the site was used for the production of bladelets to make projectile and composed elements, maintenance of bladelet cores, repair of hunting tools, and treatment of animal carcasses".

Methods
Life forms: carnivores,ungulates

Sampling methods: quarry,screenwash

Sample size: 57 specimens

Years: 1990 - 1996

Sampling comments: "The excavation of the cave was conducted under the direction of M.R. Gonzâlez Morales and Diaz Casado between 1990-1996. Only 6 of the 16 m2 of the site has been excavated, mostly in the central part, which is the most inhabitable and spacious area of the cave. Some bones were recovered through sieving using a 2 mm mesh".

Metadata
Sample number: 4115

Contributor: Benjamin Carter

Enterer: Benjamin Carter

Created: 2023-02-24 16:09:36

Modified: 2023-05-30 05:18:30

Abundance distribution
7 species
2 singletons
total count 57
extrapolated richness: 11.3
Fisher's α: 2.096
geometric series k: 0.6122
Hurlbert's PIE: 0.7484
Shannon's H: 1.5711
Good's u: 0.9649
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Bovina indet.4
"Bos/Bison"
Cervus elaphus18104 kg
Capreolus capreolus822 kg browser
Capra pyrenaica6
Sus scrofa1954 kg herbivore
Vulpes vulpes15.3 kg carnivore-insectivore
also 3 Canidae indet.
Meles meles111 kg invertivore-herbivore