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=1139 GROUP BY t.sample_noSELECT * FROM samples WHERE sample_no=1139SELECT person_no,first_name,last_name FROM peopleSELECT * FROM refs WHERE ref_no=793SELECT sql FROM sqlite_master WHERE tbl_name='samples';SELECT * FROM register WHERE sample_no=1139 ORDER BY register_no ASCSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' 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='Accipiter' AND (species='striatus' OR species='striatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Accipiter' AND (species='striatus' OR species='striatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Accipiter' 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='Accipiter' AND (species='striatus' OR species='striatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='flavipes' OR junior_species='flavipes')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tringa' AND (species='flavipes' OR species='flavipes') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tringa' AND (species='flavipes' OR species='flavipes')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='flavipes' OR junior_species='flavipes')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='Tringa' AND (species='flavipes' OR species='flavipes') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='solitaria' OR junior_species='solitaria')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Tringa' AND (species='solitaria' OR species='solitaria') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Tringa' AND (species='solitaria' OR species='solitaria')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Tringa' AND (junior_species='solitaria' OR junior_species='solitaria')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='Tringa' AND (species='solitaria' OR species='solitaria') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='pubescens' OR junior_species='pubescens')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Picoides' AND (species='pubescens' OR species='pubescens') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Picoides' AND (species='pubescens' OR species='pubescens')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Picoides' AND (junior_species='pubescens' OR junior_species='pubescens')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='Picoides' AND (species='pubescens' OR species='pubescens') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='auratus' OR junior_species='auratus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Colaptes' AND (species='auratus' OR species='auratus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Colaptes' AND (species='auratus' OR species='auratus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Colaptes' AND (junior_species='auratus' OR junior_species='auratus')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='auratus' OR species='auratus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='alnorum' OR junior_species='alnorum')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='alnorum' OR species='alnorum') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='alnorum' OR species='alnorum')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='alnorum' OR junior_species='alnorum')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='Empidonax' AND (species='alnorum' OR species='alnorum') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='hammondii' OR junior_species='hammondi')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Empidonax' AND (species='hammondii' OR species='hammondi') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Empidonax' AND (species='hammondii' OR species='hammondi')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Empidonax' AND (junior_species='hammondii' OR junior_species='hammondi')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='Empidonax' AND (species='hammondii' OR species='hammondi') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perisoreus' AND (junior_species='canadensis' OR junior_species='canadensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Perisoreus' AND (species='canadensis' OR species='canadensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Perisoreus' AND (species='canadensis' OR species='canadensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Perisoreus' AND (junior_species='canadensis' OR junior_species='canadensis')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='Perisoreus' AND (species='canadensis' OR species='canadensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' AND (junior_species='atricapillus' OR junior_species='atricapillus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Poecile' AND (species='atricapillus' OR species='atricapillus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Poecile' AND (species='atricapillus' OR species='atricapillus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Poecile' AND (junior_species='atricapillus' OR junior_species='atricapillus')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='Poecile' AND (species='atricapillus' OR species='atricapillus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Regulus' AND (junior_species='calendula' OR junior_species='calendula')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Regulus' AND (species='calendula' OR species='calendula') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Regulus' AND (species='calendula' OR species='calendula')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Regulus' AND (junior_species='calendula' OR junior_species='calendula')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='Regulus' AND (species='calendula' OR species='calendula') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='minimus' OR junior_species='minimus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharus' AND (species='minimus' OR species='minimus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharus' AND (species='minimus' OR species='minimus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='minimus' OR junior_species='minimus')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='Catharus' AND (species='minimus' OR species='minimus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='ustulatus' OR junior_species='ustulatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharus' AND (species='ustulatus' OR species='ustulatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharus' AND (species='ustulatus' OR species='ustulatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='ustulatus' OR junior_species='ustulatus')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='Catharus' AND (species='ustulatus' OR species='ustulatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='guttatus' OR junior_species='guttatus')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Catharus' AND (species='guttatus' OR species='guttatus') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Catharus' AND (species='guttatus' OR species='guttatus')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Catharus' AND (junior_species='guttatus' OR junior_species='guttatus')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='Catharus' AND (species='guttatus' OR species='guttatus') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='migratorius' OR junior_species='migratorius')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Turdus' AND (species='migratorius' OR species='migratorius') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Turdus' AND (species='migratorius' OR species='migratorius')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Turdus' AND (junior_species='migratorius' OR junior_species='migratorius')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='Turdus' AND (species='migratorius' OR species='migratorius') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothlypis' AND (junior_species='celata' OR junior_species='celata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Leiothlypis' AND (species='celata' OR species='celata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Leiothlypis' AND (species='celata' OR species='celata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Leiothlypis' AND (junior_species='celata' OR junior_species='celata')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='Leiothlypis' AND (species='celata' OR species='celata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='petechia' OR junior_species='petechia')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='petechia' OR species='petechia') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='petechia' OR species='petechia')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='petechia' OR junior_species='petechia')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='Setophaga' AND (species='petechia' OR species='petechia') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='coronata' OR junior_species='coronata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='coronata' OR species='coronata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='coronata' OR species='coronata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='coronata' OR junior_species='coronata')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='Setophaga' AND (species='coronata' OR species='coronata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='striata' OR junior_species='striata')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Setophaga' AND (species='striata' OR species='striata') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Setophaga' AND (species='striata' OR species='striata')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Setophaga' AND (junior_species='striata' OR junior_species='striata')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='Setophaga' AND (species='striata' OR species='striata') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkesia' AND (junior_species='noveboracensis' OR junior_species='noveboracensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Parkesia' AND (species='noveboracensis' OR species='noveboracensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Parkesia' AND (species='noveboracensis' OR species='noveboracensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Parkesia' AND (junior_species='noveboracensis' OR junior_species='noveboracensis')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='Parkesia' AND (species='noveboracensis' OR species='noveboracensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' AND (junior_species='pussilla' OR junior_species='pussilla')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Wilsonia' AND (species='pussilla' OR species='pussilla') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Wilsonia' AND (species='pussilla' OR species='pussilla')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Wilsonia' AND (junior_species='pussilla' OR junior_species='pussilla')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='Wilsonia' AND (species='pussilla' OR species='pussilla') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spizella' AND (junior_species='arborea' OR junior_species='arborea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Spizella' AND (species='arborea' OR species='arborea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Spizella' AND (species='arborea' OR species='arborea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Spizella' AND (junior_species='arborea' OR junior_species='arborea')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='Spizella' AND (species='arborea' OR species='arborea') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerculus' AND (junior_species='sandwichensis' OR junior_species='sandwichensis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passerculus' AND (species='sandwichensis' OR species='sandwichensis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passerculus' AND (species='sandwichensis' OR species='sandwichensis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerculus' AND (junior_species='sandwichensis' OR junior_species='sandwichensis')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='Passerculus' AND (species='sandwichensis' OR species='sandwichensis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerella' AND (junior_species='iliaca' OR junior_species='iliaca')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Passerella' AND (species='iliaca' OR species='iliaca') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Passerella' AND (species='iliaca' OR species='iliaca')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Passerella' AND (junior_species='iliaca' OR junior_species='iliaca')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='Passerella' AND (species='iliaca' OR species='iliaca') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melospiza' AND (junior_species='lincolnii' OR junior_species='lincolni')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Melospiza' AND (species='lincolnii' OR species='lincolni') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Melospiza' AND (species='lincolnii' OR species='lincolni')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Melospiza' AND (junior_species='lincolnii' OR junior_species='lincolni')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='Melospiza' AND (species='lincolnii' OR species='lincolni') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='leucophrys' OR junior_species='leucophrys')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Zonotrichia' AND (species='leucophrys' OR species='leucophrys') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Zonotrichia' AND (species='leucophrys' OR species='leucophrys')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Zonotrichia' AND (junior_species='leucophrys' OR junior_species='leucophrys')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='Zonotrichia' AND (species='leucophrys' OR species='leucophrys') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junco' AND (junior_species='hyemalis' OR junior_species='hyemalis')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Junco' AND (species='hyemalis' OR species='hyemalis') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Junco' AND (species='hyemalis' OR species='hyemalis')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Junco' AND (junior_species='hyemalis' OR junior_species='hyemalis')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='Junco' AND (species='hyemalis' OR species='hyemalis') ORDER BY year,last_namesSELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='flammea' OR junior_species='flammea')SELECT s.*,r.* FROM sizes s,refs r WHERE s.ref_no=r.ref_no AND measurement='body mass' AND genus='Carduelis' AND (species='flammea' OR species='flammea') ORDER BY measurement,sex,last_names,yearSELECT *,0 AS individuals FROM crc WHERE genus='Carduelis' AND (species='flammea' OR species='flammea')SELECT senior_genus genus,senior_species species FROM itis WHERE junior_genus='Carduelis' AND (junior_species='flammea' OR junior_species='flammea')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='Carduelis' AND (species='flammea' OR species='flammea') ORDER BY year,last_namesSELECT * FROM register WHERE sample_no=1139 The Ecological Register: Creamer’s Field Migratory Waterfowl Refuge (spring)
Creamer’s Field Migratory Waterfowl Refuge (spring)
Basic information
Sample name: Creamer’s Field Migratory Waterfowl Refuge (spring)

Reference: J. M. Wright. 1998. Monitoring Neotropical and migratory birds in Alaska, April 1997 - April 1998. Alaska Department of Fish and Game Final Research Report SE-3-5:1-12 [ER 793]
Geography
Country: United States

State: Alaska


Coordinate: 64° 51' N, 147° 43' W
Coordinate basis: based on nearby landmark

Geography comments: coordinate based on Fairbanks

•
Environment
Habitat: boreal forest/taiga

Substrate: ground surface

MAT: -2.8

WMT: 17.9

CMT: -25.1

MAP: 286.0

Habitat comments: "boreal forest, shrub, and wetland habitats"
MAT based on Sparrow et al. (2003, AFES Bulletin); CMT, WMT, and MAP based on climate station 70261

Methods
Life forms: birds

Sampling methods: mist nets

Sample size: 353 individuals

Years: 1997

Days: 42

Nets or traps: 26

Net or trap nights: 1092

Sampling comments: "Nets were opened about 7 hours a day"; there were 26 nets used for 42 days and 7548 hours

Metadata
Sample number: 1139

Contributor: John Alroy

Enterer: John Alroy

Created: 2014-08-31 13:15:13

Modified: 2014-08-31 03:15:13

Abundance distribution
27 species
6 singletons
total count 353
extrapolated richness: 41.0
Fisher's α: 6.804
geometric series k: 0.8474
Hurlbert's PIE: 0.9043
Shannon's H: 2.6845
Good's u: 0.9830
Each square represents a species. Square sizes are proportional to counts.
• Find matching samples
• Map matching samples
• Extrapolate richness estimates
Register
Accipiter striatus19.7 g carnivore
Tringa flavipes177.5 g
Tringa solitaria448.4 g invertivore
Picoides pubescens12.8 g insectivore
Colaptes auratus311.3 g insectivore-frugivore
Empidonax alnorum312.7 g insectivore
Empidonax hammondii1610.6 g insectivore
Perisoreus canadensis1
Poecile atricapillus510.8 g
Regulus calendula36.5 g insectivore
Catharus minimus532.6 g insectivore-frugivore
Catharus ustulatus2830.3 g insectivore-frugivore
Catharus guttatus130.1 g insectivore-frugivore
Turdus migratorius4378.5 g insectivore-frugivore
Leiothlypis celata20
"Vermivora celata"
Setophaga petechia10
"Dendroica petechia"
Setophaga coronata74
"Dendroica coronata"
Setophaga striata3
"Dendroica striata"
Parkesia noveboracensis25 insectivore
"Seiurus noveboracensis"
Wilsonia pussilla13
Spizella arborea118.6 g
Passerculus sandwichensis171.7 g insectivore
Passerella iliaca22.0 g insectivore-granivore
Melospiza lincolnii816.6 g insectivore-granivore
Zonotrichia leucophrys132.0 g insectivore-granivore
Junco hyemalis371.6 g insectivore-granivore
Carduelis flammea1513.0 g