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=4381 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=4381SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3970SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=4381 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mammuthus' AND (junior_species='meridionalis' OR junior_species='meridionalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mammuthus' AND (species='meridionalis' OR species='meridionalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mammuthus' AND (species='meridionalis' OR species='meridionalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mammuthus' AND (junior_species='meridionalis' OR junior_species='meridionalis')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='Mammuthus' AND (species='meridionalis' OR species='meridionalis') 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='Equus' AND (junior_species='suessenbornensis' OR junior_species='suessenbornensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='suessenbornensis' OR species='suessenbornensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='suessenbornensis' OR species='suessenbornensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='suessenbornensis' OR junior_species='suessenbornensis')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='suessenbornensis' OR species='suessenbornensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='altidens' OR junior_species='altidens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='altidens' OR species='altidens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='altidens' OR species='altidens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='altidens' OR junior_species='altidens')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='altidens' OR species='altidens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippopotamus' AND (junior_species='antiquus' OR junior_species='antiquus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hippopotamus' AND (species='antiquus' OR species='antiquus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hippopotamus' AND (species='antiquus' OR species='antiquus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hippopotamus' AND (junior_species='antiquus' OR junior_species='antiquus')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='Hippopotamus' AND (species='antiquus' OR species='antiquus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' 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='Bison' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bison' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bison' 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='Bison' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='alba' OR junior_species='alba')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Capra' AND (species='alba' OR species='alba') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capra' AND (species='alba' OR species='alba')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capra' AND (junior_species='alba' OR junior_species='alba')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='alba' OR species='alba') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammotragus' AND (junior_species='europaeus' OR junior_species='europaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ammotragus' AND (species='europaeus' OR species='europaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ammotragus' AND (species='europaeus' OR species='europaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ammotragus' AND (junior_species='europaeus' OR junior_species='europaeus')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='Ammotragus' AND (species='europaeus' OR species='europaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacervoceros' AND (junior_species='rhenanus' OR junior_species='rhenanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Metacervoceros' AND (species='rhenanus' OR species='rhenanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Metacervoceros' AND (species='rhenanus' OR species='rhenanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Metacervoceros' AND (junior_species='rhenanus' OR junior_species='rhenanus')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='Metacervoceros' AND (species='rhenanus' OR species='rhenanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praemegaceros' AND (junior_species='verticornis' OR junior_species='verticornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Praemegaceros' AND (species='verticornis' OR species='verticornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Praemegaceros' AND (species='verticornis' OR species='verticornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Praemegaceros' AND (junior_species='verticornis' OR junior_species='verticornis')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='Praemegaceros' AND (species='verticornis' OR species='verticornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' 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='Canis' AND (species='mosbachensis' OR species='mosbachensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canis' AND (species='mosbachensis' OR species='mosbachensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' 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='Canis' AND (species='mosbachensis' OR species='mosbachensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lycanoides' OR junior_species='lycanoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Canis' AND (species='lycanoides' OR species='lycanoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Canis' AND (species='lycanoides' OR species='lycanoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Canis' AND (junior_species='lycanoides' OR junior_species='lycanoides')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='lycanoides' OR species='lycanoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='alopecoides' OR junior_species='alopecoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Vulpes' AND (species='alopecoides' OR species='alopecoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Vulpes' AND (species='alopecoides' OR species='alopecoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Vulpes' AND (junior_species='alopecoides' OR junior_species='alopecoides')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='alopecoides' OR species='alopecoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycrocuta' AND (junior_species='brevirostris' OR junior_species='brevirostris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Pachycrocuta' AND (species='brevirostris' OR species='brevirostris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pachycrocuta' AND (species='brevirostris' OR species='brevirostris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pachycrocuta' AND (junior_species='brevirostris' OR junior_species='brevirostris')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='Pachycrocuta' AND (species='brevirostris' OR species='brevirostris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megantereon' AND (junior_species='whitei' OR junior_species='whiteii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Megantereon' AND (species='whitei' OR species='whiteii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Megantereon' AND (species='whitei' OR species='whiteii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Megantereon' AND (junior_species='whitei' OR junior_species='whiteii')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='Megantereon' AND (species='whitei' OR species='whiteii') 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='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 senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pannonictis' 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='Pannonictis' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Pannonictis' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Pannonictis' 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='Pannonictis' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' 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='Ursus' AND (species='etruscus' OR species='etruscus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ursus' AND (species='etruscus' OR species='etruscus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ursus' 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='Ursus' AND (species='etruscus' OR species='etruscus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryctolagus' AND (junior_species='lacosti' OR junior_species='lacostii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oryctolagus' AND (species='lacosti' OR species='lacostii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oryctolagus' AND (species='lacosti' OR species='lacostii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryctolagus' AND (junior_species='lacosti' OR junior_species='lacostii')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='Oryctolagus' AND (species='lacosti' OR species='lacostii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudines' 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='Testudines' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Testudines' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Testudines' 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='Testudines' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=4381
Reference:L. A. Courtenay, J. Yravedra, D. Herranz-Rodrigo, J. J. Rodríguez-Alba, A. Serrano-Ramos, V. Estaca-Gómez, D. González-Aguilera, J. A. Solano, and J. M. Jiménez-Arenas. 2023. Deciphering carnivoran competition for animal resources at the 1.46 Ma early Pleistocene site of Barranco Leon (Orce, Granada, Spain). Quaternary Science Reviews300:107912 [ER 3970]
Geography
Country: Spain
State: Granada
Coordinate:37.72° N, -2.45° W
Coordinate basis: estimated from map
Time interval: Early Pleistocene
Ma: 1.46
Age basis: ESR
Geography comments: "in proximity with the town of Orce" (shown on the map of Fig. 1 as about 2 km due east of Orce; coordinate estimated from Google map, which shows the site)
"The present study focuses on the taphonomic analysis of the richest of these layers, level D1 (BL-D1), dated at 1.46 ± 0.19 Ma using Electron Spin Resonance"
Habitat comments: "on the palaeoshoreline of the Guadix-Baza lake"
"characterised by sandy gravels, product of a sudden event producing high-energy currents"
"The lithic assemblage of BL is mostly comprised of local flint and micritic limestone tools, typical of the Oldowan technocomplex"
"an intense degree of fragmentation and fractured bones. Cut and percussion marks appear on a wide array of taxa, of all sizes, while carnivoran alterations are inter-mixed alongside anthropogenic alterations" but carnivores may "have had a more secondary access to faunal remains"
Methods
Life forms: carnivores,ungulates,other small mammals,turtles
Sampling methods: quarry
Sample size: 2312 specimens
Years: 2016 - 2020
Sampling comments: "excavated between the years 2016 and 2020"
Metadata
Sample number: 4381
Contributor: John Alroy
Enterer: John Alroy
Created: 2023-11-29 20:34:03
Modified: 2023-11-29 09:34:03
Abundance distribution
21 species
3 singletons
total count 2312
extrapolated richness: 27.9
Fisher's α: 3.188
geometric series k: 0.7012
Hurlbert's PIE: 0.6838
Shannon's H: 1.6844
Good's u: 0.9987
Each square represents a species. Square sizes are proportional to counts.