SilverPlatter Guide


AGRICOLA (agri)

Guide Index:
About AGRICOLA
Fields in AGRICOLA
Limit Fields
Search Examples
     Searching Using Descriptors and Identifiers
     Searching Using the Index
     Searching Using Truncation
Stopwords
Subject Category Codes
     Subject Category Code A
     Subject Category Code B-E
     Subject Category Code F
     Subject Category Code G-M
     Subject Category Code N-R
     Subject Category Code S-W
Combining Searches

Go: Back


About AGRICOLA

The AGRICOLA (Agricultural Online Access) database contains bibliographic records of materials acquired by the National Agricultural Library (NAL) and cooperating institutions in the agricultural and related sciences.  Ninety percent of the records describe journal articles and book chapters, and the remaining ten percent describe monographs, series, microforms, audiovisuals, maps, and other types of materials.  Together they provide worldwide coverage of the agricultural literature. 

Pre-1979 AGRICOLA records are derived from the CAIN format; from 1979 on, MARC-formatted records are used to create the database.

Go: Guide Index or Back


Fields in AGRICOLA (agri)

Records in AGRICOLA (agri) are divided into the following fields. Highlighted fields are limit fields.

Label Field Name   Label Field Name

AB

Abstract

 

LA

Language

AI

Acquisition Information

 

LR

Latest Revision

AL

NAL Location

 

LS

Language of Summaries

AN

Accession Number

 

MI

Meeting Information

AU

Author

 

MX

Map Information

AUI

Browsable Author Index

 

NT

Notes

BK

Book Source

 

OT

Original Title

BT

Book Title

 

PB

Publisher

CA

Corporate Author

 

PD

Physical Description

CC

Category Codes

 

PP

Place of Publication (+)

CO

CODEN (+)

 

PS

Personal Name as Subject

DE

Descriptors (+)

 

PT

Publication Type

DN

Document Numbers

 

PY

Publication Year

ED

Edition

 

SH

Subject Heading

GC

Geographic Area

 

SO

Source

HL

Holding Institution

  ST

Series Title

IB

ISBN (+)

 

TI

Title

ID

Identifiers

 

UD

Update Code

IL

Intellectual Level (+)

 

URL

URL

IS

ISSN (+)

 

XURL

URLS ETC

JN

Journal

     

(+) does not appear in pre-1979 records.

There is also a special subset of fields, Citation (CITN), which consists of the AL, AU, CA, LA, SO, and TI fields. Use the citation to display, print, or save only these fields for a set of records.

Go: Guide Index or Back


Label Field Name
AB Abstract
nutrition in ab
 

The AB field contains a brief summary of the document.

Go: Back to Fields

AI

Acquisition Information
dept of agriculture in ai

 

The AI field contains acquisition information for the item described or its reproduction. Stock numbers may be included.

Go: Back to Fields

AL

  NAL Location
389.8 J824 in al

 

The AL field contains either a National Agricultural Library (NAL) call number or an NAL classification number.

Search NAL Locations only as hyphenated, "bound" phrases. Replace spaces with hyphens and omit all decimal points. Use the truncation symbol (*) to search only part of a number or to retrieve all records within a call number range.  Use near in your search statement to combine a call number with an agency code, e.g. near al to limit to NAL's numbers only, or near DLC to limit to LCs.

Go: Back to Fields

AN

Accession Number
cat in an and 84798551 in an
fnc in an

 

The AN contains a unique 11 character alphanumeric identifier assigned by the National Agricultural Library.

Go: Back to Fields

AU  

Author
bellamy-d in au
downing-p-j in au
brown-john-c in au

 

Authors' names are hyphenated and appear last name first.  The most efficient way to search for an author's name is as a hyphenated, "bound" phrase, excluding dates and qualifiers.  For the exact form of name and possible variations, consult the Index.

Go: Back to Fields

AUI

Browsable Author Index
abbey-ami in aui

 

As an alternative to searching with the field label, browse available author names and search for them directly from the Browsable Author Index This field-specific Index contains only author names drawn from the AU field. Names are listed in alphabetical order and display in the exact format as they are indexed in the database. This is especially helpful if you do not know the format of an author's name. This is the most efficient way to search for author names as you can browse for a name and search for it directly from this index.

Go: Back to Fields

BK 

Book Source
agriculture in bk

 

The BK field includes the title of the book containing the chapter that has been individually indexed.

Go: Back to Fields

BT

Book Title
ascorbic acid in bt
lipoproteins in bt

 

The BT field contains publication and other information about the book from which a record was taken.

Go: Back to Fields

CA 

Corporate Author
united nations in ca
agriculture in ca
citrus congress in ca

 

The CA field contains the name of the sponsoring institution, conference, government agency, etc. You can search using a keyword or phrase.

Go: Back to Fields

CC

Category Codes
(a limit field)
t120 in cc
food service management in cc
cc=t120

 

The CC field contains the NAL Subject Category Codes and Headings. All of the older six-digit category codes have been converted to four-digit codes by omitting the last two zeroes.  Consult the AGRICOLA Subject Category Codes with Scope Notes for a list of codes.

Go: Back to Fields

CO

CODEN
jfdaz in co
mxsbae in co

 

The CO field contains a five- or six-character code for the journal title, assigned to scientific and technical periodicals by the International CODEN Service.  The CO field does not appear in pre-1979 records.

Go: Back to Fields

DE

Descriptors
agriculture-economic-aspects in de

 

The DE field contains terms from the National Agricultural Library Agricultural Thesaurus. See the Subject Heading (SH) field for controlled vocabulary terms from other thesauri and the Personal Name as Subject (PS) field for a person who is the subject of a work

Go: Back to Fields

DN

Document Numbers
B873 in dn
SUDOC in dn

 

The DN field contains various identifying numbers for the record, including GPO numbers, publisher numbers, report numbers, and SUDOC numbers.

Go: Back to Fields

ED

Edition
3rd in ed

 

The ED field contains information relating to the edition of a work.

Go: Back to Fields

GC

Geographic Area
india in gc

 

The GC field contains countries, individual states or provinces, and geographic regions when appropriate. Consider both the country and its principle sovereign entities when searching.

Go: Back to Fields

HL

Holding Institution
dnal in hl

 

The HL field contains the USMARC code of the institution reporting that it holds the item.

Go: Back to Fields

IB

ISBN
3110145359 in ib
ib=002897333x

 

The IB field contains the International Standard Book Number (10 digits).  The IB field does not appear in pre-1979 records.

Go: Back to Fields

ID

Identifiers
cancer in id
citrus-fruit in id

 

Identifiers are subject terms, not from a controlled vocabulary, assigned to records. The ID field may include personal, corporate, and place names when used as subject terms. Search as you would Descriptors (DE), with hyphenated, "bound" phrases or by keywords. For example, citrus-fruit in id limits the search to records containing the phrase in the ID field.  ID is the only subject field in pre-1979 records.

Go: Back to Fields

IL

Intellectual Level
         (a limit field)
adult in il
il=preschool in

 

The IL field indicates the age and educational level of the intended audience.  A small number of records, particularly in the nutrition and family-related subject areas, are directed at school-age children.  The IL field does not appear in pre-1979 records.

The levels are:
preschool 
elementary 
adult    
general
primary   
secondary  
juvenile
specialized

Go: Back to Fields

IS

ISSN
0309-586X in is

 

The IS field contains the International Standard Serial Number (8 digits with hyphen).  The IS field does not appear in pre-1979 records.

Go: Back to Fields

JN

Journal Name
jn=cryobiology
poultry research in jn

 

The JN field contains words from the Journal Name.

Go: Back to Fields

LA

Language
         (a limit field)
german in la
french in la near summary in la

 

The LA field contains the language(s) of the text and of the summary.  Combine near summary in la with a language to limit your search to summaries in that language.  Search multi-word language names either as hyphenated phrases or as individual words.

Go: Back to Fields

LR

Latest Revision
960307 in lr

 

The LR field contains the year, month, and day a record was revised by the National Agricultural Library.

Go: Back to Fields

LS

Language of Summaries
         (a limit field)
spanish in ls

 

The LS field contains the language or languages of abstracts or summaries included in a work.

Go: Back to Fields

MI

Meeting Information
european isko conference in mi
mi=milwaukee wis

 

The MI field contains information for a meeting or conference citation, including the conference name, place, and date.

Go: Back to Fields

MX

Map Information
scale in mx

 

The MX field contains mathematical data associated with cartographic material, including a statement of scale, statement of projection, and a statement of bounding coordinates. The coordinates can represent a bounding rectangle, the outline of the area covered, or the outline of an interior area not covered. For celestial charts, it may also contain a statement of zone, declination data, ascension data, and equinox.

Go: Back to Fields

NT 

Notes
bibliography in nt

 

The NT field contains miscellaneous notes about the nature and contents of the document, including Citation notes and Contents notes.

Citation notes specify which abstracting/indexing services have cited the article or monograph. Contents notes list the chapters in books, or titles of volumes in collections or sets. Citation notes and Contents notes do not appear in pre-1979 records.

SUDOCS numbers are also searchable in this field.
Go: Back to Fields

OT

Original Title
prirodnye in ot

 

The OT field includes foreign language titles and variant forms of titles. You can search by keywords or phrases.

Go: Back to Fields

PB

Publisher
extension in pb
pb=usda

 

The PB field contains the publisher for books and serials.

Go: Back to Fields

PD

Physical Description
in box in pd
pd=instruction booklet

 

The PD field contains the physical description of the item which consists of its extent, dimensions, and other physical details, including information concerning accompanying material.

Go: Back to Fields

PP

Place of Publication
netherlands in pp
new-hampshire in pp
usa in pp

 

The PP field includes both countries and individual states or provinces when appropriate. Consider both the country and its principle sovereign entities when searching.

Go: Back to Fields

PS

Personal Name as Subject
losee in ps

 

The PS field contains the subject heading when it contains the name of a person who is the subject of a work. Generally the full name is included. You may also find dates and information specifically relating to the type of information included in the work.

Go: Back to Fields

PT

Publication Type
         (a limit field)
map in pt
pt=article

 

The PT field contains both the type of work as well as the content of a work.

Go: Back to Fields

PY

Publication Year
         (a limit field)
1985 in py
py>=1985
py=1983-1985

 

The PY field contains the publication date of the document.

Go: Back to Fields

SH

Subject Heading
Cache National Forest in sh
grain in sh

 

Subject Headings are terms assigned from controlled vocabularies, such as LCSH or CAB Thesaurus.  When used as subject terms, Subject Headings may include personal, corporate and place names.  For most efficient results, search Subject Headings as a hyphenated, "bound" phrase or by keywords.  Hyphenate one-word Subject Headings, e.g., agriculture- in de to limit the search to a single word.  If you do not know the exact form of a Subject Heading, consult the Index.

Pre-1979 records contain Identifiers only, not Subject Headings; use the Identifiers (ID) field for subject searching.

Go: Back to Fields

SO

Source
j-food-sci in so

 

The SO field includes the Journal (JN) and Publication Year (PY), as well as the Volume, Issue and Pagination information for journal articles; Book Title (BT) for book chapters, Place of Publication (PP), Publisher (PB), Publication Year (PY) for books and book chapters; and Place of Publication (PP), and Publisher (PB) for serials.

Go: Back to Fields

ST

Series Title
economic geology in st

 

The ST field contains the title of the series.  You can search by keywords or phrases.

Go: Back to Fields

TI

Title
plant growth in ti

 

The TI field contains the title of a journal article, book chapter, book or serial and also information from the Editor (ED) field if available. In records for book chapters, the Book Title (BT) field will display in the Source (SO) field.

Go: Back to Fields

UD

Update Code
         (a limit field)
8300 in ud
ud>=8300
ud=8300-8400
ud=199901

 

The Update Code (UP) field contains the four-digit numeric code indicating the year (YY) and month (MM) of the update in the format YYMM. Latest Revision (LT) by the producer also appears here in the format YYMMDD.

Go: Back to Fields

URL

  URL
http in url
url in ulr

 

The URL field contains the URL (Uniform Resource Locator) where an online version of the document, a full-text version of the document, or additional information such as journals can be located.  This field also indicates the method of access, such as: http, ftp, email, remote login, etc.

This field is useful in limiting your search to only those records that contain URLs.  For example, if you are interested in agricultural laws, but want to retrieve only those records that provide URLs, conduct the following search:
    (agricultural laws) and (url in url)

Similarly, if you wanted only those records that contain http addresses:
    (agricultural laws) and (http in url)

Note: Use parentheses to group long search statements to assure that SPIRS interprets them correctly.
Go: Back to Fields

XURL 

URLS ETC
         (a limit field)
url in xurl

 

The XURL field is supposed to help users retrieve records with certain features, e.g. all records that include URL’s, all records that contain email addresses, etc.   Use the Authority List of terms to decide which terms to include in the field; this field will be used when cross-database searching, so it's important to use controlled vocabulary.

Go: Back to Fields

CITN Citation
 

The Citation is a subset of fields consisting of the following fields. The Citation serves as an easy way to display, print, or save only these fields for a set of records.

NAL Location (AL)
Author (AU)
Corporate Author (CA)
Title (TI)
Source (SO)
Language (LA)

Go: Back to Fields

Go: Guide Index or Back


 

Limit Fields

The limit fields listed below are specially indexed fields that have relatively few possible values.  They allow you to limit your searches to records of a particular characteristic, such as type of document or publication frequency.

Category Codes (CC)
Language (LA)
Language of Summaries (LS)
Publication Type (PT)
Publication Year (PY)
Update Code (UD)
URLS ETC (XURL)

You can search these fields with in or =.  For example, to retrieve documents published in German, enter:

  german in la  or  la=german

In addition to in and =, the following operators may be used with numeric limit fields:

Symbol Operation Performed Example
<
less than py<1990  
>
greater than  py>1991  
<=
less than or equal to py<=1989
>=
greater than or equal to py>=1992  
-
within a range py=1990-1992 

Go: Guide Index or Back


Search Examples

Below are several examples of the types of searches you can use to retrieve information from the AGRICOLA database.

Searching Using Descriptors and Identifiers
Searching Using the Index (including author field)
Searching Using Truncation

Go: Guide Index or Back

 

Searching Using the Index

Authors' names appear in the Author (AU) field and are hyphenated with the last name first. The best way to search for an author is by selecting the name from the Index. For example, let's look for articles by J. R. Abernathy.

1.  First look up Abernathy in the Index.

2.  Select Abernathy-JR and then start the search.

Go: Guide Index or Back

 

Searching Using Descriptors and Identifiers

Descriptors
Descriptors, found in the Descriptors (DE) field, have been assigned to most of the records in the AGRICOLA database beginning in 1985.  Descriptors are from two controlled vocabularies, either the Library of Congress Subject Headings (LCSH) or the CAB Thesaurus, published by CAB International.  Some records contain both types of Descriptors and a small number of records contain neither.

Descriptors are usually subject terms, but they may also be personal, corporate, or place names.  From 1979 to 1985, only monograph or serial title records contain Descriptors; before 1979, no records contain Descriptors.  The majority of the database, therefore, contains only Identifiers.

To narrow a search, use the most specific subject term for the concept.  Check LCSH and the CAB Thesaurus for specific terms.  Both vocabularies provide related terms, narrower and broader in scope.  To expand a search, use related or broader terms.

Identifiers
Identifiers, found in the Identifiers (ID) field, are subject terms for which no controlled vocabulary exists.  Since Identifiers have been used consistently in the database (unlike Descriptors), searching with Identifiers will give you comprehensive results.

How to Search
Descriptors and Identifiers have been hyphenated to make searching more efficient.  The most efficient way to search a multi-word Descriptor or Identifier is as a hyphenated, "bound" phrase, such as calcium-binding-protein in de. The search calcium in de retrieves all records with Descriptors containing the word calcium, for example, calcium-binding-protein, calcium-hydroxide, etc.  To limit a search to the single-word Descriptor term calcium, search for calcium- in de.

Search Identifiers as you would Descriptors, with hyphenated, "bound" phrases or by keywords. For example, citrus-fruit in id limits the search to records containing the phrase in the ID field. 

Go: Guide Index or Back

 

Searching Using Truncation

Searching with truncation lets you retrieve records containing variations of your term. For example, let's search for the effects of irradiation on either food storage or food quality.

1.  Search for food storage or quality:
     food storage or quality

2.  Combine the results with a search for irradiat*:
     and irradiat*

The truncation symbol (*) searches for all terms beginning with the root irradiat*, such as irradiate, irradiation, irradiating, etc.


Go: Guide Index or Back

Stopwords

Words of little intrinsic meaning that occur too frequently to be useful in searching text are known as "stopwords." You cannot search for the following stopwords by themselves, but you can include them within phrases:

an

be

is

that

were

and

by

more

the

which

are

for

of

their

with

as

from

on

to

 

at

in

or

was

 

Go: Guide Index or Back


Subject Category Codes

Most records in AGRICOLA contain Subject Category Codes (CC).  NAL has assigned two types of codes:  numeric (1979 and earlier) and alphanumeric (since 1980). 

Check the AGRICOLA Subject Category Codes with Scope Notes for various types of Subject Category Codes searchable in AGRICOLA. It may be necessary to use several category codes in a search to cover all aspects of a subject.  For example, crops are covered by field crops (f120 in cc or 4050 in cc), horticultural crops (f110 in cc or 4055 in cc), miscellaneous crops (f140 in cc or 4060 in cc) and forest trees as crop (k100 in cc or 3515 in cc).

     Subject Category Code A
     Subject Category Code B-E
     Subject Category Code F
     Subject Category Code G-M
     Subject Category Code N-R
     Subject Category Code S-W

Go: Guide Index or Back


Subject Category Codes A

Go: Guide Index or Back


Subject Category Codes B-E

Go: Guide Index or Back


Subject Category Codes F

Go: Guide Index or Back


Subject Category Codes G-M

Go: Guide Index or Back


Subject Category Codes N-R

Go: Guide Index or Back


Subject Category Codes S-W

Go: Guide Index or Back


Combining Searches

Beginning a search statement with an operator (and, not, or, with, near, or in) combines that statement with the previous one.

For instance, if the search you just completed is radio, searching for and telephone will give you the same results as if you search for radio and telephoneSimilarly, the search red cross followed by the search in ti is the same as red cross in ti.

Operator: Example: How it works:
OR radio or telephone Retrieves records that contain either "radio," "telephone," or both.
AND radio and telephone Retrieves records that contain both "radio" and "telephone."
NOT radio not telephone Retrieves records that contain "radio" and excludes those containing "telephone."
WITH red with cross Retrieves records that contain both "red" and "cross" in the same field.
NEAR radio near telephone Retrieves records that contain both "radio" and "telephone" in the same sentence.
IN red cross in ti Retrieves records that contain "red cross " in the Title (TI) field.

Guide Revised December 7, 2005

Go: Guide Index or Back