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=2613 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=2613SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=2405SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=2613 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episoriculus' 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='Episoriculus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Episoriculus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Episoriculus' 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='Episoriculus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' AND (junior_species='intermedius' OR junior_species='intermedius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eliomys' AND (species='intermedius' OR species='intermedius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eliomys' AND (species='intermedius' OR species='intermedius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eliomys' AND (junior_species='intermedius' OR junior_species='intermedius')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='Eliomys' AND (species='intermedius' OR species='intermedius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimomys' AND (junior_species='medasensis' OR junior_species='medasensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mimomys' AND (species='medasensis' OR species='medasensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mimomys' AND (species='medasensis' OR species='medasensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mimomys' AND (junior_species='medasensis' OR junior_species='medasensis')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='Mimomys' AND (species='medasensis' OR species='medasensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castillomys' AND (junior_species='crusafonti' OR junior_species='crusafontii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Castillomys' AND (species='crusafonti' OR species='crusafontii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Castillomys' AND (species='crusafonti' OR species='crusafontii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Castillomys' AND (junior_species='crusafonti' OR junior_species='crusafontii')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='Castillomys' AND (species='crusafonti' OR species='crusafontii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' AND (junior_species='calpensis' OR junior_species='calpensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Prolagus' AND (species='calpensis' OR species='calpensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Prolagus' AND (species='calpensis' OR species='calpensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Prolagus' AND (junior_species='calpensis' OR junior_species='calpensis')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='Prolagus' AND (species='calpensis' OR species='calpensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryctolagus' AND (junior_species='laynensis' OR junior_species='laynensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oryctolagus' AND (species='laynensis' OR species='laynensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oryctolagus' AND (species='laynensis' OR species='laynensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oryctolagus' AND (junior_species='laynensis' OR junior_species='laynensis')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='laynensis' OR species='laynensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctereutes' AND (junior_species='megamastoides' OR junior_species='megamastoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nyctereutes' AND (species='megamastoides' OR species='megamastoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nyctereutes' AND (species='megamastoides' OR species='megamastoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nyctereutes' AND (junior_species='megamastoides' OR junior_species='megamastoides')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='Nyctereutes' AND (species='megamastoides' OR species='megamastoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='issiodorensis' OR junior_species='issiodorensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lynx' AND (species='issiodorensis' OR species='issiodorensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lynx' AND (species='issiodorensis' OR species='issiodorensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lynx' AND (junior_species='issiodorensis' OR junior_species='issiodorensis')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='issiodorensis' OR species='issiodorensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaenidae' 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='Hyaenidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hyaenidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hyaenidae' 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='Hyaenidae' 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='livenzovensis' OR junior_species='livenzovensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Equus' AND (species='livenzovensis' OR species='livenzovensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='livenzovensis' OR species='livenzovensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' AND (junior_species='livenzovensis' OR junior_species='livenzovensis')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='livenzovensis' OR species='livenzovensis') 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='Eucladoceros' AND (junior_species='ctenoides' OR junior_species='ctenoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Eucladoceros' AND (species='ctenoides' OR species='ctenoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Eucladoceros' AND (species='ctenoides' OR species='ctenoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Eucladoceros' AND (junior_species='ctenoides' OR junior_species='ctenoides')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='Eucladoceros' AND (species='ctenoides' OR species='ctenoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='borbonica' OR junior_species='borbonica')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gazella' AND (species='borbonica' OR species='borbonica') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gazella' AND (species='borbonica' OR species='borbonica')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gazella' AND (junior_species='borbonica' OR junior_species='borbonica')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='Gazella' AND (species='borbonica' OR species='borbonica') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=2613 The Ecological Register: El Rincon-1
El Rincon-1
Basic information
Sample name: El Rincon-1

Reference: M. T. Alberdi, E. Cerdeño, N. López-Martínez, J. Morales, and M. D. Soria. 1997. La fauna Villafranquiense de El Rincon-1 (Albacete, Castilla-La Mancha). Estudios Geológicos 53:59-93 [ER 2405]
Geography
Country: Spain


Coordinate: 39° 0' N, 1° 51' W
Coordinate basis: based on nearby landmark

Time interval: Late Pliocene

Ma: 2.65

Max Ma: 2.7

Min Ma: 2.6

Geography comments: "Albacete" (basis of coordinate)
"Villafranquiense/Villanyense inferior... Al yacimiento de El Rincón-1 se le situó en tomo a los... 2,6-2,7 Ma y Villafranquiense medio"

Environment
Substrate: ground surface

Lithology: marl

Habitat comments: "Los fósiles aparecen en un nivel margoso de color verde de unos 6 cm de espesor, reposando unos fósiles sobre la base y otros cerca del techo, en contacto con el nivel carbonâtico suprayacente"

Methods
Life forms: carnivores,rodents,ungulates,other small mammals

Sampling methods: quarry,screenwash

Sample size: 327 specimens

Years: 1976 - 1986

Sampling comments: quarried, but with respect to the micromammals, "La mayoría de los restos (dientes aislados) proceden del lavado-tamizado de unos 1.800 kg de sedimentos extraídos de los ripios de la excavación, aunque algunos restos (maxilares y mandíbulas completos) fueron encontrados durante el proceso de excavación a simple vista"

Metadata
Sample number: 2613

Contributor: John Alroy

Enterer: John Alroy

Created: 2017-02-19 11:11:46

Modified: 2023-09-08 12:26:33

Abundance distribution
13 species
2 singletons
total count 327
extrapolated richness: 18.6
Fisher's α: 2.707
geometric series k: 0.6544
Hurlbert's PIE: 0.6971
Shannon's H: 1.6205
Good's u: 0.9939
Each square represents a species. Square sizes are proportional to counts.
Register