Brown University Library Collections - Collection Growth & Use Reports

» Return to Collection Data & Reports


Reports, January - December 2001 | Age of the Collections Reports |
Borrowing Patterns | Collections by Josiah Codes


Reports, January - December 2001

Collection Growth & Use Reports present data on the number of items owned, acquired, cataloged, and circulated over a selected time period, grouped by call number range. Call number ranges are defined by entries in the Statistical Category (SCAT) table, which the library maintains. The SCAT table covers only items cataloged in the Library of Congress classification.

The number of items roughly corresponds to the number of volumes, although not every volume owned is represented by an item record.

The system scans every item in the Josiah database, looking for a call number in the bibliographic record. If the bibliographic record does not contain a call number, the system uses the call number from the item record. If there is no call number in either the bibliographic or item record, it is counted in the "No Call #" line of the resulting report. If the call number in either the bibliographic or item record is not found in the Library of Congress SCAT table, the record will be counted in the "Not in table" line of the report.

HTML files sorted by a variety of factors are linked below.  You may also download the original excel files.  For further information contact Bonnie_Buzzell@brown.edu

ROCKEFELLER Library (download original excel file)

sort by:

SCIENCES Library (download original excel file)

sort by:

ORWIG Music Library (download original excel file)

sort by:

DEMOGRAPHY Library (download original excel file)

sort by:

JOHN HAY Library (download original excel file) (see also: Paging Statistics)

sort by:

GENERAL COLLECTIONS - Rockefeller, Sciences, Orwig combined (download original excel file)

sort by:

ALL LIBRARIES combined (download original excel file)

sort by:


Definition of Column Headings:
A: scat Subject category number
B: scat LC call number range and subject
C: Coll. Size # Items The total number of items in each subject category. 
D: Size Rank Ranking of column (c)
E: # Items Added The number of items added to the collection during the specified date range. The system gathers this information from the "Created" field in the item record.
F: # Bibs Cataloged The number of bibliographic records added for the specified call number range. The system gathers this information from the "CAT DATE" field in the bibliographic record.
G: Orders # Received The number of ordered items received within the specified date range. The system gathers this information from the "RDATE" field in the order record.
H: # of Check Outs The number of items checked out for the specified call number range. This does not include renewals.
I: Check Out Rank Ranking of column (h)
J: Use Ratio A comparison of number of checkouts (column h) and collection size (column c), expressed as a percentage. The higher the percentage, the heavier the circulation for that subject category.
K: Use Rank Ranking of column (k)
L: Library floor Current location within library of that subject.



Age of the Collections Reports

Age of Collection Reports provide a decade-by-decade count of publication dates from the bibliographic records in Josiah, grouped by Statistical Category (SCAT) range. The SCAT table covers only material cataloged in the Library of Congress classification.

The number of bibliographic records roughly corresponds to the number of titles in the database, although some material is linked to more than one title.

The system scans every title in the Josiah database, looking for a call number in the first attached item record. If none of the items contains a call number, the call number in the bibliographic record will be used. If there is no call number in the bibliographic record, the record is counted in the "No Call #" line of the resulting report. If the call number in either the bibliographic or item record is not found in the SCAT table, the record is counted in the "Not in table" line of the report.

The publication date is taken from the MARC 260 IMPRINT field in the bibliographic record. If a 260 field contains multiple dates, the system uses the first date. Date ranges are grouped into decades with a separate count for each decade of the 20th and 21st centuries. Records with dates earlier than 1900 are reported together.

All of these reports were generated as of January 1, 2001 (give or take two days).


Borrowing Patterns

Undergraduate Borrowing, 1999-2001 (pdf format) 


Collections by Josiah Codes 

Location, Item, Order, Checkin, Bib codes, 5/20/02
(download original excel file)
sort by: