Essig Specimens Advanced Database Query
 
 
Back to: Essig Museum of Entomology Collections

Instructions: Use Customize the Display below to customize your search results (it's optional). Use fields on the rest of the page to create your query. Type-in fields are not case sensitive. If you complete more than one field, the search will return records that meet all conditions of the fields that were completed (boolean AND). See Query Help for tips.

Downloading the results: You will be able to download a tab-delimited file containing the fields you choose for the display.
Mapping the results: Mapping is only available if you choose "Default fields"
Need help? Got a question, or don't see the field you need? Click here to send email to BSCIT.

To view non-public records Name:      Password:
Customize the Display:
Fields to display in results: Default fields All fields Custom *


* Choose fields for Custom
(Ctrl-click for multiple)
Group selected fields and show totals? yes


Sort results first by:
then by:


Specimen info:
Coll ID # (bnhm_id)   Example: EMEC666
Catalog Number   Example: 666
Project Name   Example: French Polynesia
Institution   Example: Bishop or Essig
Collecting Event ID   Example: 1249
Collected by   Example: Knowlton
Coll. Year
Collector's Indiv. Num.   Example: sel_188
Identified by  
ID Year
Type status  
Preparation Type  
Sex/Caste  
Life Stage  
Parts  


Taxonomy:
Name Soup Matches any part of any taxonomy field
Subspecific Epithet Example: coreopsidis
Specific Epithet Example: coreopsidis
Genus Example: Akkaia
Sci. Name Example: aphis ceanothi
Common Name
Tribe
Subfamily
Family
Suborder
Order
Subclass
Class
Previous ID   Example: Tricorythodes


Locality:
Collector's Locality Num.   Example: SCC04_011
Habitat/Host Examples: alfalfa, salix, trap pans
Locality Examples: Berkeley, Seattle
County
State/Province
Country
Continent/Ocean
Island
IslandGroup
Elevation1 (m)
Elevation2 (m)
Elevation Text


Administrative Info:
Date record created 2006-05-16
Submitted By  
Notes  
Public?    


 
The Essig Database is a project of BSCIT   University of California, Berkeley     Comments & Questions

Essig Museum of Entomology      Berkeley Natural History Museums