Canadian Flag

Canadian Centre for Occupational
Health and Safety

Centre canadien d'hygiène et de
sécurité au travail
Government of Canada Wordmark
CCOHS: Canadian Centre for Occupational Health and Safety
Français Contact Us Help
        
Canada Site
Web Info Service Products & Services OSH Answers Education
Canada's national Occupational Health & Safety Resource
Home About Us E-News OSH Events Resources Shop@CCOHS
  Web Info Service
  Search:
Web Information Service
MSDS plus CHEMINFO
CHEMpendium
RTECS®
OSH References
Canadian enviroOSH Legislation
 
Academic Support Program
  Other Languages:
Français
Español
  Collection Information
  About the Web Information Service
  More about:
MSDS plus CHEMINFO
CHEMpendium
RTECS®
OSH References
Canadian enviroOSH Legislation
  Help
  Help - Searching
  Help - Results and Toolbar
  Help - Databases
  More Information
  Free Trial Option(s)
  Pricing and Ordering
  Terms of Use
  Disclaimer

clientservices@ccohs.ca
1-800-668-4284 (CAN & US)
1-905-570-8094
Fax: 1-905-572-2206
Help - HSDB Field Searching

Each database/collection has an Advanced Search page which allows you to search in the specific fields for that database/collection. Using the Advanced Search page, you can:

  • build your search step-by-step using the boxes at the top of the Advanced Search page,
    or
  • type your query statement, including all appropriate syntax, in the Query box.

To search in a specific field, click on the drop down button next to All Fields and select the desired field, e.g. IdentificationNumber. The most frequently searched fields are listed first. To find out the appropriate names of all fields, turn on the Field Help from the toolbar and click on the ? help symbol next to the field in any database record. You can now view the field name and its description.

Use the information below as a guide to executing detailed searches using the HSDB Advanced Search page:

Major Search Fields
Search Examples
Field Summary (Names To Be Used For Searching)

HSDB - Major Search Fields

These are the frequently searched fields listed in the drop down list on the Advanced Search page.

Searching using: Finds information in these fields:
AllFields All fields 
 Name

 Substance Name
Synonyms

 IdentificationNumber

 CAS Registry Number
Shipping Name Number
STCC Number

 MolecularFormula  Molecular Formula 

 HealthEffects  related to human health and toxic effects 

 AnimalToxicity

 related to animal health and toxic effects 

 EnvironmentalEffects

 environmental fate and exposure pontential

 UsesAndSources

 ManufacturersLabel(Major Uses)
Sources and Concentrations (Natural Occuring Sources, Artificial Sources)

Note: All fields have been indexed. Each field has a specific name which must be used for searching. Use the Field Summary to view the specific "field names" to be used for searching.

Tip:   For a complete list of database fields, while viewing a database record, turn on the Field Help from the toolbar and click on the ? help symbol next to the field in any database record. You can now view the field name and its description, from the complete list of fields for the database. You can easily print this list, by clicking in the field help window, right-clicking and then selecting Print.

HSDB - Search Examples

Tip: For searches from the Advanced Search page, multiple words are automatically treated as a phrase and find all forms of the words as a phrase.

 Search Examples Finds all records
 Note: The best results are frequently found by searching using a CAS Registry Number.
 * <IN> UsesAndSources  with a Uses And Sources field
 sulfuric acid <IN> Name  with all forms of the word as a phrase in a Name field
 "sulfuric acid" <IN> Name

 with the name sulfuric acid in a Name field

 7664-93-9 
7664-93-9 <IN> IdentificationNumber

 both searches find Sulfuric acid

 *h2-o4-s <IN> MolecularFormula

 with h2-o4-s in a molecular formula

 skin sensitization<IN> HealthEffects

 with all forms of the word as a phrase in Health Effects

 Toxicology review <IN> AnimalToxicity

 with toxicology reviews

 aquatic fate <IN> EnvironmentalEffects

 substances with information on aquatic fate

 antimicrobial agent <IN> UsesAndSources

 substances which are used as antimicrobial agents

 LD50 <IN> AnimalToxicity <AND> rat <IN> AnimalToxicity

 with an LD50 value for rat

 LD50 <IN> AnimalToxicity <AND> rat <IN> AnimalToxicity <AND> oral <IN> AnimalToxicity

 with an oral LD50 value for rat

Tip:   Brackets have special meaning in searching, therefore, to search for chemical name containing brackets, e.g. Bis(chloromethyl) Ether, use Bis\(chloromethyl)\ Ether.

HSDB - Field Summary

You can search all the fields in the database. Each field has a specific name which must be used for searching. The table below summarizes the commonly used fields and gives the syntax of the field name to be used for searching:

Field Name Names To Be Used For Searching
Name Of Substance Name
Synonym Name
CAS Registry Number IdentificationNumber
Shipping Name Number IdentificationNumber
Molecular Formula MolecularFormula
Odor AppearanceAndOdour

Tip:   For a complete list of database fields, while viewing a database record, turn on the Field Help from the toolbar and click on the ? help symbol next to the field in any database record. You can now view the field name and its description, from the complete list of fields for the database. You can easily print this list, by clicking in the field help window, right-clicking and then selecting Print.

 Client Services 
 Inquiries Service 
 Webmaster 
Important Notices and Disclaimers
©CCOHS, 2004
Answering your questions about our products and services Answering your workplace health and safety questions Accepting questions and comments about this website