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=3519 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=3519SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=3208SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=3519 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gopherus' AND (junior_species='agassizi' OR junior_species='agassizii')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gopherus' AND (species='agassizi' OR species='agassizii') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gopherus' AND (species='agassizi' OR species='agassizii')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gopherus' AND (junior_species='agassizi' OR junior_species='agassizii')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='Gopherus' AND (species='agassizi' OR species='agassizii') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sauromalus' AND (junior_species='obesus' OR junior_species='obesus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sauromalus' AND (species='obesus' OR species='obesus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sauromalus' AND (species='obesus' OR species='obesus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sauromalus' AND (junior_species='obesus' OR junior_species='obesus')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='Sauromalus' AND (species='obesus' OR species='obesus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' 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='Crotalus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crotalus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crotalus' 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='Crotalus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' AND (junior_species='platyrhynchos' OR junior_species='platyrhynchos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anas' AND (species='platyrhynchos' OR species='platyrhynchos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anas' AND (species='platyrhynchos' OR species='platyrhynchos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' AND (junior_species='platyrhynchos' OR junior_species='platyrhynchos')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='Anas' AND (species='platyrhynchos' OR species='platyrhynchos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' AND (junior_species='carolinensis' OR junior_species='carolinensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Anas' AND (species='carolinensis' OR species='carolinensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Anas' AND (species='carolinensis' OR species='carolinensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Anas' AND (junior_species='carolinensis' OR junior_species='carolinensis')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='Anas' AND (species='carolinensis' OR species='carolinensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mareca' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mareca' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mareca' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mareca' AND (junior_species='americana' OR junior_species='americana')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='Mareca' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aythya' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aythya' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aythya' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aythya' AND (junior_species='americana' OR junior_species='americana')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='Aythya' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyura' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxyura' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxyura' AND (species='jamaicensis' OR species='jamaicensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxyura' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')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='Oxyura' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mergus' AND (junior_species='merganser' OR junior_species='merganser')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mergus' AND (species='merganser' OR species='merganser') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mergus' AND (species='merganser' OR species='merganser')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mergus' AND (junior_species='merganser' OR junior_species='merganser')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='Mergus' AND (species='merganser' OR species='merganser') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnogyps' AND (junior_species='amplus' OR junior_species='amplus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Gymnogyps' AND (species='amplus' OR species='amplus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Gymnogyps' AND (species='amplus' OR species='amplus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Gymnogyps' AND (junior_species='amplus' OR junior_species='amplus')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='Gymnogyps' AND (species='amplus' OR species='amplus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquila' AND (junior_species='chrysaetos' OR junior_species='chrysaetos')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aquila' AND (species='chrysaetos' OR species='chrysaetos') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aquila' AND (species='chrysaetos' OR species='chrysaetos')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aquila' AND (junior_species='chrysaetos' OR junior_species='chrysaetos')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='Aquila' AND (species='chrysaetos' OR species='chrysaetos') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Buteo' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Buteo' AND (species='jamaicensis' OR species='jamaicensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Buteo' AND (junior_species='jamaicensis' OR junior_species='jamaicensis')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='Buteo' AND (species='jamaicensis' OR species='jamaicensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fulica' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Fulica' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Fulica' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Fulica' AND (junior_species='americana' OR junior_species='americana')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='Fulica' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Recurvirostra' AND (junior_species='americana' OR junior_species='americana')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Recurvirostra' AND (species='americana' OR species='americana') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Recurvirostra' AND (species='americana' OR species='americana')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Recurvirostra' AND (junior_species='americana' OR junior_species='americana')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='Recurvirostra' AND (species='americana' OR species='americana') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenaida' AND (junior_species='macroura' OR junior_species='macroura')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zenaida' AND (species='macroura' OR species='macroura') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zenaida' AND (species='macroura' OR species='macroura')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zenaida' AND (junior_species='macroura' OR junior_species='macroura')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='Zenaida' AND (species='macroura' OR species='macroura') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubo' AND (junior_species='virginianus' OR junior_species='virginianus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bubo' AND (species='virginianus' OR species='virginianus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bubo' AND (species='virginianus' OR species='virginianus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bubo' AND (junior_species='virginianus' OR junior_species='virginianus')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='Bubo' AND (species='virginianus' OR species='virginianus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='cafer' OR junior_species='cafer')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colaptes' AND (species='cafer' OR species='cafer') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colaptes' AND (species='cafer' OR species='cafer')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='cafer' OR junior_species='cafer')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='Colaptes' AND (species='cafer' OR species='cafer') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corvus' AND (junior_species='corax' OR junior_species='corax')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Corvus' AND (species='corax' OR species='corax') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Corvus' AND (species='corax' OR species='corax')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Corvus' AND (junior_species='corax' OR junior_species='corax')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='Corvus' AND (species='corax' OR species='corax') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathinae' 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='Perognathinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perognathinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perognathinae' 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='Perognathinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' 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='Neotoma' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Neotoma' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Neotoma' 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='Neotoma' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taxidea' AND (junior_species='taxus' OR junior_species='taxus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Taxidea' AND (species='taxus' OR species='taxus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Taxidea' AND (junior_species='taxus' OR junior_species='taxus')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='Taxidea' AND (species='taxus' OR species='taxus') 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='Urocyon' 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='Urocyon' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Urocyon' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Urocyon' 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='Urocyon' 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='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='Equus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' 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='Equus' 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='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='Equus' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Equus' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Equus' 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='Equus' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiauchenia' 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='Hemiauchenia' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hemiauchenia' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hemiauchenia' 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='Hemiauchenia' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camelidae' 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='Camelidae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Camelidae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Camelidae' 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='Camelidae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capromeryx' 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='Capromeryx' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Capromeryx' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Capromeryx' 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='Capromeryx' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=3519 The Ecological Register: Schuiling Cave
Schuiling Cave
Basic information
Sample name: Schuiling Cave

Reference: T. Downs, H. Howard, T. Clements, and G. A. Smith. 1959. Quaternary animals from Schuiling Cave in the Mohave Desert, California. Los Angeles County Museum Contributions in Science 29:1-21 [ER 3208]
Geography
Country: United States

State: California


Coordinate: 34.81° N, -116.66° W
Coordinate basis: stated in text

Time interval: Late Pleistocene

Geography comments: "two miles southeast of Newberry... in the SW1/4, NE1/4, Sec. 9, T8N, R3E... approximately 2160 feet above sea level"
"late Pleistocene" based on the fauna and geology, with no dates because there was "an insufficient quantity of carbon"

•
Environment
Lithology: not described

Taphonomic context: aeolian deposit,cave,fluvial deposit

Habitat comments: "unconsolidated angular fragments, mostly of rhyolite, in a matrix of finer particles of the same material, and fine aeolian dust... much of the material is alluvial fill"
there were "human remains from the top layers (24-30 inches)" but "Extinct animals" were "below the human remains"

Methods
Life forms: carnivores,rodents,ungulates,birds,lizards,snakes,turtles

Sampling methods: quarry

Sample size: 88 specimens

Years: 1953

Sampling comments: screenwashing is not discussed

Metadata
Sample number: 3519

Contributor: John Alroy

Enterer: John Alroy

Created: 2019-09-11 10:25:42

Modified: 2019-09-12 00:23:05

Abundance distribution
28 species
13 singletons
total count 88
extrapolated richness: 80.2
Fisher's α: 14.176
geometric series k: 0.8904
Hurlbert's PIE: 0.8843
Shannon's H: 2.7306
Good's u: 0.8541
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Gopherus agassizi1
"Many frags., 1 partial carapace"
Sauromalus obesus4
Crotalus sp.2
Anas cf. platyrhynchos135.3 g granivore
Anas cf. carolinensis1
Mareca ? americana1
Aythya cf. americana21.1 kg
"Nyoca cf. americana"
Oxyura jamaicensis1629 g
Mergus merganser11.7 kg piscivore
Gymnogyps amplus2
Aquila chrysaetos13.9 kg carnivore
Buteo jamaicensis230.4 g carnivore
Fulica americana4724 g
Recurvirostra americana1307 g
Zenaida macroura1123 g granivore-frugivore
"Zenaidura macroura"
Bubo virginianus534.0 g carnivore
Colaptes cafer1
Corvus corax1 omnivore
Perognathinae indet.2
"Perognathus sp."
Neotoma sp.3
Taxidea cf. taxus157.0 kg carnivore
Canis cf. lupus143 kg carnivore
Urocyon sp.2
Equus sp. small23
Equus sp. large1
Hemiauchenia sp.4
compared to "Tanupolama"
Camelidae indet. large3
Capromeryx sp.2
"Breameryx sp."