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=273 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=273SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=117SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=273 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerbia' AND (junior_species='brevicollis' OR junior_species='brevicollis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Nerbia' AND (species='brevicollis' OR species='brevicollis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Nerbia' AND (species='brevicollis' OR species='brevicollis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Nerbia' AND (junior_species='brevicollis' OR junior_species='brevicollis')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='Nerbia' AND (species='brevicollis' OR species='brevicollis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='palustris' OR junior_species='palustris')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiophilus' AND (species='palustris' OR species='palustris') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiophilus' AND (species='palustris' OR species='palustris')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='palustris' OR junior_species='palustris')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='Notiophilus' AND (species='palustris' OR species='palustris') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='subtriatus' OR junior_species='subtriatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiophilus' AND (species='subtriatus' OR species='subtriatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiophilus' AND (species='subtriatus' OR species='subtriatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='subtriatus' OR junior_species='subtriatus')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='Notiophilus' AND (species='subtriatus' OR species='subtriatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='rufipes' OR junior_species='rufipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Notiophilus' AND (species='rufipes' OR species='rufipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Notiophilus' AND (species='rufipes' OR species='rufipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Notiophilus' AND (junior_species='rufipes' OR junior_species='rufipes')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='Notiophilus' AND (species='rufipes' OR species='rufipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loricera' AND (junior_species='pilicornis' OR junior_species='pilicornis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Loricera' AND (species='pilicornis' OR species='pilicornis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Loricera' AND (species='pilicornis' OR species='pilicornis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Loricera' AND (junior_species='pilicornis' OR junior_species='pilicornis')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='Loricera' AND (species='pilicornis' OR species='pilicornis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='lampros' OR junior_species='lampros')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='lampros' OR species='lampros') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='lampros' OR species='lampros')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='lampros' OR junior_species='lampros')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='Bembidion' AND (species='lampros' OR species='lampros') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='normannum' OR junior_species='normannum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='normannum' OR species='normannum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='normannum' OR species='normannum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='normannum' OR junior_species='normannum')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='Bembidion' AND (species='normannum' OR species='normannum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='obtusum' OR junior_species='obtusum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='obtusum' OR species='obtusum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='obtusum' OR species='obtusum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='obtusum' OR junior_species='obtusum')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='Bembidion' AND (species='obtusum' OR species='obtusum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='aenieum' OR junior_species='aenieum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='aenieum' OR species='aenieum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='aenieum' OR species='aenieum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='aenieum' OR junior_species='aenieum')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='Bembidion' AND (species='aenieum' OR species='aenieum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='guttula' OR junior_species='guttula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Bembidion' AND (species='guttula' OR species='guttula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Bembidion' AND (species='guttula' OR species='guttula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Bembidion' AND (junior_species='guttula' OR junior_species='guttula')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='Bembidion' AND (species='guttula' OR species='guttula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trechuts' AND (junior_species='obtusuts' OR junior_species='obtusuts')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Trechuts' AND (species='obtusuts' OR species='obtusuts') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Trechuts' AND (species='obtusuts' OR species='obtusuts')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Trechuts' AND (junior_species='obtusuts' OR junior_species='obtusuts')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='Trechuts' AND (species='obtusuts' OR species='obtusuts') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='aeneus' OR junior_species='aeneus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='aeneus' OR species='aeneus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='aeneus' OR species='aeneus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='aeneus' OR junior_species='aeneus')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='Harpalus' AND (species='aeneus' OR species='aeneus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='rubripes' OR junior_species='rubripes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Harpalus' AND (species='rubripes' OR species='rubripes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Harpalus' AND (species='rubripes' OR species='rubripes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Harpalus' AND (junior_species='rubripes' OR junior_species='rubripes')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='Harpalus' AND (species='rubripes' OR species='rubripes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acupalpus' AND (junior_species='luridus' OR junior_species='luridus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Acupalpus' AND (species='luridus' OR species='luridus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Acupalpus' AND (species='luridus' OR species='luridus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Acupalpus' AND (junior_species='luridus' OR junior_species='luridus')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='Acupalpus' AND (species='luridus' OR species='luridus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='communis' OR junior_species='communis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='communis' OR species='communis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='communis' OR species='communis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='communis' OR junior_species='communis')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='Amara' AND (species='communis' OR species='communis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='curta' OR junior_species='curta')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='curta' OR species='curta') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='curta' OR species='curta')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='curta' OR junior_species='curta')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='Amara' AND (species='curta' OR species='curta') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='acnea' OR junior_species='acnea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Amara' AND (species='acnea' OR species='acnea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Amara' AND (species='acnea' OR species='acnea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Amara' AND (junior_species='acnea' OR junior_species='acnea')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='Amara' AND (species='acnea' OR species='acnea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='verntalis' OR junior_species='verntalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Feronia' AND (species='verntalis' OR species='verntalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Feronia' AND (species='verntalis' OR species='verntalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='verntalis' OR junior_species='verntalis')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='Feronia' AND (species='verntalis' OR species='verntalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='macra' OR junior_species='macra')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Feronia' AND (species='macra' OR species='macra') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Feronia' AND (species='macra' OR species='macra')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='macra' OR junior_species='macra')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='Feronia' AND (species='macra' OR species='macra') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='melanaria' OR junior_species='melanaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Feronia' AND (species='melanaria' OR species='melanaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Feronia' AND (species='melanaria' OR species='melanaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='melanaria' OR junior_species='melanaria')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='Feronia' AND (species='melanaria' OR species='melanaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='gracilis' OR junior_species='gracilis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Feronia' AND (species='gracilis' OR species='gracilis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Feronia' AND (species='gracilis' OR species='gracilis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='gracilis' OR junior_species='gracilis')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='Feronia' AND (species='gracilis' OR species='gracilis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='diligens' OR junior_species='diligens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Feronia' AND (species='diligens' OR species='diligens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Feronia' AND (species='diligens' OR species='diligens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='diligens' OR junior_species='diligens')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='Feronia' AND (species='diligens' OR species='diligens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='madida' OR junior_species='madida')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Feronia' AND (species='madida' OR species='madida') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Feronia' AND (species='madida' OR species='madida')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Feronia' AND (junior_species='madida' OR junior_species='madida')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='Feronia' AND (species='madida' OR species='madida') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonuin' AND (junior_species='viduum' OR junior_species='viduum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agonuin' AND (species='viduum' OR species='viduum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agonuin' AND (species='viduum' OR species='viduum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonuin' AND (junior_species='viduum' OR junior_species='viduum')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='Agonuin' AND (species='viduum' OR species='viduum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonuin' AND (junior_species='dorsale' OR junior_species='dorsale')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Agonuin' AND (species='dorsale' OR species='dorsale') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Agonuin' AND (species='dorsale' OR species='dorsale')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Agonuin' AND (junior_species='dorsale' OR junior_species='dorsale')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='Agonuin' AND (species='dorsale' OR species='dorsale') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=273 The Ecological Register: Mill Field
Mill Field
Basic information
Sample name: Mill Field

Reference: G. Williams. 1959. Seasonal and diurnal activity of Carabidae, with particular reference to Nebria, Notiophilus and Feronia. Journal of Animal Ecology 28(2):309-330 [ER 117]
Geography
Country: United Kingdom


Coordinate: 51.2° N, 0.2° E
Environment
Habitat: temperate broadleaf/mixed forest

Altered habitat: cropland

Substrate: ground surface

Habitat comments: "a ley newly seeded under barley"

Methods
Life forms: ground beetles

Sites: 1

Sampling methods: pitfall traps

Sample size: 121 captures or sightings

Nets or traps: 3

Net or trap nights: 273

Sampling comments: JA: three pitfall traps each operated for a week at a time at intervals of four weeks over a year (i.e., 13 times) for a total of 3 x 7 x 13 =273 days

Metadata
Sample number: 273

Contributor: John Alroy

Enterer: Albert Garcia Selles

Created: 2013-04-08 16:20:38

Modified: 2014-08-22 02:54:45

Abundance distribution
25 species
13 singletons
total count 121
extrapolated richness: 72.6
Fisher's α: 9.565
geometric series k: 0.8414
Hurlbert's PIE: 0.7097
Shannon's H: 2.0698
Good's u: 0.8930
Each square represents a species. Square sizes are proportional to counts.
Register