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=690 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=690SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=359SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=690 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hister' AND (junior_species='abbreviatus' OR junior_species='abbreviatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Hister' AND (species='abbreviatus' OR species='abbreviatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Hister' AND (species='abbreviatus' OR species='abbreviatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Hister' AND (junior_species='abbreviatus' OR junior_species='abbreviatus')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='Hister' AND (species='abbreviatus' OR species='abbreviatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='lunatum' OR junior_species='lunatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphaeridium' AND (species='lunatum' OR species='lunatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphaeridium' AND (species='lunatum' OR species='lunatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='lunatum' OR junior_species='lunatum')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='Sphaeridium' AND (species='lunatum' OR species='lunatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='scarabaeoides' OR junior_species='scarabaeoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphaeridium' AND (species='scarabaeoides' OR species='scarabaeoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphaeridium' AND (species='scarabaeoides' OR species='scarabaeoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='scarabaeoides' OR junior_species='scarabaeoides')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='Sphaeridium' AND (species='scarabaeoides' OR species='scarabaeoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='bipustulatum' OR junior_species='bipustulatum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Sphaeridium' AND (species='bipustulatum' OR species='bipustulatum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Sphaeridium' AND (species='bipustulatum' OR species='bipustulatum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Sphaeridium' AND (junior_species='bipustulatum' OR junior_species='bipustulatum')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='Sphaeridium' AND (species='bipustulatum' OR species='bipustulatum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='pygmaeus' OR junior_species='pygmaeus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercyon' AND (species='pygmaeus' OR species='pygmaeus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercyon' AND (species='pygmaeus' OR species='pygmaeus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='pygmaeus' OR junior_species='pygmaeus')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='Cercyon' AND (species='pygmaeus' OR species='pygmaeus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='quisquilius' OR junior_species='quisquilius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercyon' AND (species='quisquilius' OR species='quisquilius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercyon' AND (species='quisquilius' OR species='quisquilius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='quisquilius' OR junior_species='quisquilius')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='Cercyon' AND (species='quisquilius' OR species='quisquilius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='unipunctatus' OR junior_species='unipunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cercyon' AND (species='unipunctatus' OR species='unipunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cercyon' AND (species='unipunctatus' OR species='unipunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cercyon' AND (junior_species='unipunctatus' OR junior_species='unipunctatus')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='Cercyon' AND (species='unipunctatus' OR species='unipunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptopleurum' AND (junior_species='minutum' OR junior_species='minutum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Cryptopleurum' AND (species='minutum' OR species='minutum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Cryptopleurum' AND (species='minutum' OR species='minutum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Cryptopleurum' AND (junior_species='minutum' OR junior_species='minutum')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='Cryptopleurum' AND (species='minutum' OR species='minutum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='hecate' OR junior_species='hecate')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='hecate' OR species='hecate') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='hecate' OR species='hecate')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='hecate' OR junior_species='hecate')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='Onthophagus' AND (species='hecate' OR species='hecate') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Onthophagus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Onthophagus' AND (species='pennsylvanicus' OR species='pennsylvanicus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Onthophagus' AND (junior_species='pennsylvanicus' OR junior_species='pennsylvanicus')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='Onthophagus' AND (species='pennsylvanicus' OR species='pennsylvanicus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='haemorrhoidalis' OR species='haemorrhoidalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='haemorrhoidalis' OR junior_species='haemorrhoidalis')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='Aphodius' AND (species='haemorrhoidalis' OR species='haemorrhoidalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='granarius' OR junior_species='granarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='granarius' OR species='granarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='granarius' OR species='granarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='granarius' OR junior_species='granarius')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='Aphodius' AND (species='granarius' OR species='granarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='fimetarius' OR junior_species='fimetarius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='fimetarius' OR species='fimetarius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='fimetarius' OR species='fimetarius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='fimetarius' OR junior_species='fimetarius')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='Aphodius' AND (species='fimetarius' OR species='fimetarius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='vittatus' OR junior_species='vittatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='vittatus' OR species='vittatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='vittatus' OR species='vittatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='vittatus' OR junior_species='vittatus')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='Aphodius' AND (species='vittatus' OR species='vittatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='distinctus' OR junior_species='distinctus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='distinctus' OR species='distinctus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='distinctus' OR species='distinctus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='distinctus' OR junior_species='distinctus')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='Aphodius' AND (species='distinctus' OR species='distinctus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='ruricola' OR junior_species='ruricola')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aphodius' AND (species='ruricola' OR species='ruricola') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aphodius' AND (species='ruricola' OR species='ruricola')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aphodius' AND (junior_species='ruricola' OR junior_species='ruricola')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='Aphodius' AND (species='ruricola' OR species='ruricola') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ataenius' AND (junior_species='spretulus' OR junior_species='spretulus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Ataenius' AND (species='spretulus' OR species='spretulus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Ataenius' AND (species='spretulus' OR species='spretulus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Ataenius' AND (junior_species='spretulus' OR junior_species='spretulus')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='Ataenius' AND (species='spretulus' OR species='spretulus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platystethus' AND (junior_species='americanus' OR junior_species='americanus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Platystethus' AND (species='americanus' OR species='americanus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Platystethus' AND (species='americanus' OR species='americanus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Platystethus' AND (junior_species='americanus' OR junior_species='americanus')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='Platystethus' AND (species='americanus' OR species='americanus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falagria' AND (junior_species='dissecta' OR junior_species='dissecta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Falagria' AND (species='dissecta' OR species='dissecta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Falagria' AND (species='dissecta' OR species='dissecta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Falagria' AND (junior_species='dissecta' OR junior_species='dissecta')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='Falagria' AND (species='dissecta' OR species='dissecta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxytelus' AND (junior_species='suspectus' OR junior_species='suspectus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Oxytelus' AND (species='suspectus' OR species='suspectus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Oxytelus' AND (species='suspectus' OR species='suspectus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Oxytelus' AND (junior_species='suspectus' OR junior_species='suspectus')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='Oxytelus' AND (species='suspectus' OR species='suspectus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleochara' AND (junior_species='bipustulata' OR junior_species='bipustulata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Aleochara' AND (species='bipustulata' OR species='bipustulata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aleochara' AND (species='bipustulata' OR species='bipustulata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleochara' AND (junior_species='bipustulata' OR junior_species='bipustulata')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='Aleochara' AND (species='bipustulata' OR species='bipustulata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='cruentatus' OR junior_species='cruentatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philonthus' AND (species='cruentatus' OR species='cruentatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philonthus' AND (species='cruentatus' OR species='cruentatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='cruentatus' OR junior_species='cruentatus')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='Philonthus' AND (species='cruentatus' OR species='cruentatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='rectangularis' OR junior_species='rectangularis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Philonthus' AND (species='rectangularis' OR species='rectangularis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Philonthus' AND (species='rectangularis' OR species='rectangularis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Philonthus' AND (junior_species='rectangularis' OR junior_species='rectangularis')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='Philonthus' AND (species='rectangularis' OR species='rectangularis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleocharinae' 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='Aleocharinae' AND (species='indet.' OR species='indet.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Aleocharinae' AND (species='indet.' OR species='indet.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Aleocharinae' 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='Aleocharinae' AND (species='indet.' OR species='indet.') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=690 The Ecological Register: Brookings County (sheep manure)
Brookings County (sheep manure)
Basic information
Sample name: Brookings County (sheep manure)

Reference: H. Kessler, E. U. Balsbaugh Jr, and B. McDaniel. 1974. Faunistic comparison of adult coleoptera recovered from cattle and sheep manure in east central South Dakota. Entomological News 85:67-71 [ER 359]
Geography
Country: United States

State: South Dakota


Coordinate: 44.37° N, -96.79° W
Coordinate basis: based on political unit

Geography comments: coordinate based on county

Environment
Habitat: temperate savanna

Substrate: ground surface

WMT: 22.7

CMT: -6.4

MAP: 629.0

Habitat comments: climate data based on station 72651 (Sioux Falls Regional Airport)

Methods
Life forms: beetles,scarab beetles

Sampling methods: no design,hand capture

Sample size: 2283 individuals

Years: 1969

Sampling comments: "sheep manure was placed into a Berlese funnel" to collect the insects, with sampling from 18 June to 10 September

Metadata
Sample number: 690

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-04-01 11:43:25

Modified: 2015-10-02 10:41:37

Abundance distribution
24 species
3 singletons
total count 2283
extrapolated richness: 30.5
Fisher's α: 3.741
geometric series k: 0.7278
Hurlbert's PIE: 0.5461
Shannon's H: 1.4014
Good's u: 0.9987
Each square represents a species. Square sizes are proportional to counts.
Register