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=1200 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1200SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=848SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1200 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicanthis' AND (junior_species='niloticus' OR junior_species='niloticus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Arvicanthis' AND (species='niloticus' OR species='niloticus') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Arvicanthis' AND (junior_species='niloticus' OR junior_species='niloticus')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='Arvicanthis' AND (species='niloticus' OR species='niloticus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otomys' AND (junior_species='angoniensis' OR junior_species='angoniensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Otomys' AND (species='angoniensis' OR species='angoniensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Otomys' AND (species='angoniensis' OR species='angoniensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Otomys' AND (junior_species='angoniensis' OR junior_species='angoniensis')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='Otomys' AND (species='angoniensis' OR species='angoniensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='minutoides' OR junior_species='minutoides')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mus' AND (species='minutoides' OR species='minutoides') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mus' AND (species='minutoides' OR species='minutoides')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='minutoides' OR junior_species='minutoides')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='Mus' AND (species='minutoides' OR species='minutoides') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='triton' OR junior_species='triton')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mus' AND (species='triton' OR species='triton') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mus' AND (species='triton' OR species='triton')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mus' AND (junior_species='triton' OR junior_species='triton')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='Mus' AND (species='triton' OR species='triton') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' 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='Crocidura' AND (species='sp.' OR species='sp.') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Crocidura' AND (species='sp.' OR species='sp.')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Crocidura' 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='Crocidura' AND (species='sp.' OR species='sp.') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhabdomys' AND (junior_species='pumilio' OR junior_species='pumilio')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Rhabdomys' AND (species='pumilio' OR species='pumilio') ORDER BY measurement,sex,last_names,yearSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Rhabdomys' AND (junior_species='pumilio' OR junior_species='pumilio')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='Rhabdomys' AND (species='pumilio' OR species='pumilio') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophuromys' AND (junior_species='flavopunctatus' OR junior_species='flavopunctatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lophuromys' AND (species='flavopunctatus' OR species='flavopunctatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lophuromys' AND (species='flavopunctatus' OR species='flavopunctatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lophuromys' AND (junior_species='flavopunctatus' OR junior_species='flavopunctatus')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='Lophuromys' AND (species='flavopunctatus' OR species='flavopunctatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendromus' AND (junior_species='mesomelas' OR junior_species='mesomelas')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Dendromus' AND (species='mesomelas' OR species='mesomelas') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Dendromus' AND (species='mesomelas' OR species='mesomelas')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Dendromus' AND (junior_species='mesomelas' OR junior_species='mesomelas')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='Dendromus' AND (species='mesomelas' OR species='mesomelas') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastomys' AND (junior_species='natalensis' OR junior_species='natalensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Mastomys' AND (species='natalensis' OR species='natalensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Mastomys' AND (species='natalensis' OR species='natalensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Mastomys' AND (junior_species='natalensis' OR junior_species='natalensis')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='Mastomys' AND (species='natalensis' OR species='natalensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemniscomys' AND (junior_species='striatus' OR junior_species='striatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Lemniscomys' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Lemniscomys' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Lemniscomys' AND (junior_species='striatus' OR junior_species='striatus')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='Lemniscomys' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyoryctes' AND (junior_species='splendens' OR junior_species='splendens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tachyoryctes' AND (species='splendens' OR species='splendens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tachyoryctes' AND (species='splendens' OR species='splendens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tachyoryctes' AND (junior_species='splendens' OR junior_species='splendens')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='Tachyoryctes' AND (species='splendens' OR species='splendens') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1200 The Ecological Register: Lake Nakuru National Park
Lake Nakuru National Park
Basic information
Sample name: Lake Nakuru National Park

Reference: T. G. Schwan. 1986. Seasonal abundance of fleas (Siphonaptera) on grassland rodents in Lake Nakuru National Park, Kenya, and potential for plague transmission. Bulletin of Entomological Research 76(4):633-648 [ER 848]
Geography
Country: Kenya


Coordinate: 0° 23' S, 36° 2' E
Coordinate basis: stated in text

Environment
Habitat: tropical/subtropical savanna

Protection: national/state park

Substrate: ground surface

WMT: 18.8

CMT: 15.9

MAP: 841.0

Habitat comments: "grassland"

Methods
Life forms: rodents,other small mammals

Sampling methods: quadrat,baited,Sherman traps

Sample size: 935 captures or sightings

Years: 1975, 1976

Days: 110

Seasons: dry,wet or monsoon

Nets or traps: 60

Net or trap nights: 5923

Sampling comments: 60 rolled oats-baited Sherman traps in a 6 x 10 grid spaced 10 m apart (total area 4500 m2) plus a 3 x 10 grid control plot sampled less frequently; as few as 52 traps were in use at a time; days of trapping and trap-nights are reported in text

Metadata
Sample number: 1200

Contributor: John Alroy

Enterer: John Alroy

Created: 2015-02-13 21:29:59

Modified: 2015-02-13 10:29:59

Abundance distribution
11 species
2 singletons
total count 935
extrapolated richness: 14.8
Fisher's α: 1.751
geometric series k: 0.5201
Hurlbert's PIE: 0.4376
Shannon's H: 1.0116
Good's u: 0.9979
Each square represents a species. Square sizes are proportional to counts.
Register