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=4401 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4401SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3986SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4401 ORDER BY register_no ASCSELECT 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='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='Equus' AND (junior_species='hydruntinus' OR junior_species='hydruntinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='hydruntinus' OR species='hydruntinus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='hydruntinus' OR species='hydruntinus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='hydruntinus' OR junior_species='hydruntinus')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='hydruntinus' OR species='hydruntinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' 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='Sus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sus' 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='Sus' 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='mosbachensis' OR junior_species='mosbachensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='mosbachensis' OR species='mosbachensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='mosbachensis' OR species='mosbachensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='mosbachensis' OR junior_species='mosbachensis')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='mosbachensis' OR species='mosbachensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' AND (junior_species='schoetensacki' OR junior_species='schoetensackii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bison' AND (species='schoetensacki' OR species='schoetensackii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bison' AND (species='schoetensacki' OR species='schoetensackii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' AND (junior_species='schoetensacki' OR junior_species='schoetensackii')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='Bison' AND (species='schoetensacki' OR species='schoetensackii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='primigenius' OR junior_species='primigenius')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bos' AND (species='primigenius' OR species='primigenius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bos' AND (species='primigenius' OR species='primigenius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bos' AND (junior_species='primigenius' OR junior_species='primigenius')SELECT junior_genus,junior_species FROM itis WHERE senior_genus='' AND senior_species=''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='Bos' AND (species='primigenius' OR species='primigenius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='etruscus' OR junior_species='etruscus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Stephanorhinus' AND (species='etruscus' OR species='etruscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Stephanorhinus' AND (species='etruscus' OR species='etruscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Stephanorhinus' AND (junior_species='etruscus' OR junior_species='etruscus')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='Stephanorhinus' AND (species='etruscus' OR species='etruscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocuta' AND (junior_species='intermedia' OR junior_species='intermedia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Crocuta' AND (species='intermedia' OR species='intermedia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocuta' AND (species='intermedia' OR species='intermedia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocuta' AND (junior_species='intermedia' OR junior_species='intermedia')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='Crocuta' AND (species='intermedia' OR species='intermedia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaena' AND (junior_species='prisca' OR junior_species='prisca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hyaena' AND (species='prisca' OR species='prisca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyaena' AND (species='prisca' OR species='prisca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaena' AND (junior_species='prisca' OR junior_species='prisca')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='Hyaena' AND (species='prisca' OR species='prisca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lupus' OR species='lupus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lupus' OR junior_species='lupus')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='Canis' AND (species='lupus' OR species='lupus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuon' AND (junior_species='alpinus' OR junior_species='alpinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cuon' AND (species='alpinus' OR species='alpinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cuon' AND (junior_species='alpinus' OR junior_species='alpinus')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='Cuon' AND (species='alpinus' OR species='alpinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='lunensis' OR junior_species='lunensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Felis' AND (species='lunensis' OR species='lunensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Felis' AND (species='lunensis' OR species='lunensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='lunensis' OR junior_species='lunensis')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='Felis' AND (species='lunensis' OR species='lunensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='spelaea' OR junior_species='spelaea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Panthera' AND (species='spelaea' OR species='spelaea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Panthera' AND (species='spelaea' OR species='spelaea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Panthera' AND (junior_species='spelaea' OR junior_species='spelaea')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='Panthera' AND (species='spelaea' OR species='spelaea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='thorali' OR junior_species='thoralii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Meles' AND (species='thorali' OR species='thoralii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Meles' AND (species='thorali' OR species='thoralii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Meles' AND (junior_species='thorali' OR junior_species='thoralii')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='thorali' OR species='thoralii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='pardinus' OR junior_species='pardinus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='pardinus' OR species='pardinus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='pardinus' OR junior_species='pardinus')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='Lynx' AND (species='pardinus' OR species='pardinus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='silvestris' OR junior_species='silvestris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Felis' AND (species='silvestris' OR species='silvestris') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Felis' AND (junior_species='silvestris' OR junior_species='silvestris')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='Felis' AND (species='silvestris' OR species='silvestris') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4401
Reference:P. Fosse. 1996. La grotte no 1 de Lunel-Viel (Hérault, France): Repaire d'hyènes du Pléistocène moyen. Etude taphonomique du matériel osseux. Paléo8:47-81 [ER 3986]
Geography
Country: France
Coordinate:43° 41' N, 4° 5' E
Coordinate basis: based on nearby landmark
Time interval: Middle Pleistocene
Max Ma: 0.424
Min Ma: 0.191
Age basis: zone
Geography comments: this collection is from a single cave gallery in a large complex, also called Lunel-Viel I or Mas des Caves, near the town of Lunel-Viel at an elevation of 50 m (Brugal et al. 2021) (coordinate based on Lunel-Viel)
assigned to the late Middle Pleistocene based on biochronology, and specifically between MIS 11 and MIS 7 (Uzunidis 2020), which is the basis of the age range
•
Environment
Lithology: not described
Taphonomic context: carnivore accumulation,cave
Habitat comments: layers 6 through 14 include mixed material thanks to alteration "by gravity and run off phenomena" (Uzunidis 2020)
Acheulean lithic artifacts and hearths are present (Brugal et al. 2021) but they are essentially restricted to layers 1 to 5 (Fosse 1995), and the main accumulation agent was hyaenas based on the "presence of coprolites, gnawed bones... and young hyaena remains" (Fosse 1996)
Methods
Life forms: carnivores,ungulates
Sample size: 2786 specimens
Years: 1962 - 1983
Sampling comments: the initial excavation was from 1824 to 1827, but the reported material was collected by M.-F. Bonifay from 1962 through 1983 (Uzunidis 2020)
Metadata
Sample number: 4401
Contributor: John Alroy
Enterer: John Alroy
Created: 2023-12-09 22:05:24
Modified: 2023-12-09 11:05:24
Abundance distribution
17 species
3 singletons
total count 2786
extrapolated richness: 25.3
Fisher's α: 2.410
geometric series k: 0.6294
Hurlbert's PIE: 0.5949
Shannon's H: 1.2663
Good's u: 0.9989
Each square represents a species. Square sizes are proportional to counts.