Search

Library Holdings, Checkouts and Transit information

Followers
1

Library Holdings, Checkouts and Transit information

Resources

Resource Format Link
2013 Library Holdings and Checkouts (zip 550MB) TXT Go to resource
2014 Library transactions (zip 65MB) TXT Go to resource
2014 Collection data - item information (zip 21MB) TXT Go to resource
2016 Collection data - item information (ZIP ... TXT Go to resource
2013 - all put into transit TXT Go to resource
2014 - all put into transit TXT Go to resource
2015 - all put into transit TXT Go to resource
2013 - all receive from transit TXT Go to resource
2014 - all receive from transit TXT Go to resource
2015 - all receive from transit TXT Go to resource
2015 - Library transactions TXT Go to resource
2016 - all receive from transit TXT Go to resource
2016 - Library transactions TXT Go to resource
2016 - all put into transit TXT Go to resource
2017 Collection data - item information (ZIP ... TXT Go to resource

Additional Info

Field Value
Description

Contains the MARC, bibliographic, records and items in system at a given point in time as well as some transaction data - the checkouts by year and transit information by year.

Date First Published
Update Frequency
Data will be updated on an annual basis.
Accuracy

Items are being added and purged regularly; many of the Library\u2019s collections are floating and therefore are \u2018owned\u2019 by wherever they happen to be at any given moment.

Attributes

xcheckouts.txt:

  • \u2022\tshowing date,
  • \u2022\ttime,
  • \u2022\tbranch, and
  • \u2022\t item ID (barcode).

fileofitems.txt:

  • \u2022\titem ID, 
  • \u2022\tcatalog key,
  • \u2022\ttotal checkouts,
  • \u2022\tdate last checked out,
  • \u2022\tnumber of renewals, and
  • \u2022\towning branch
  • \u2022\tNote: The total checkouts for each item in fileofitems.txt reflects the total number of checkouts in that item\u2019s lifetime. This number may not match the number of checkouts for an item that may be gathered from the yearly checkout transaction data in the \u201cYYYY all checkouts.txt\u201d files.

fileofmarc.txt:

  • \u2022\tfollows MARC standard format.
  • \u2022\tMARC records connect to item records via the catkey in 001 field - e.g. .001. |au389170
  • \u2022\tNote: Each MARC record has a catkey in the 001 field. Each item in fileofitems.txt has a catkey attaching it to a MARC record. Example from fileofitems.txt (catkey is in the second field): 2950034432896 |628660|18|20120828|3|.
  • \u2022\tFurther information about working with MARC format can be found here: http://wiki.code4lib.org/index.php/Working_with_MARC.

"all put into transit XXXX.txt"

  • These files refer to the transaction information for all items put in transit that year - these are items leaving a branch, either to fulfill a hold or return to the items home branch.
  • It is pipe delimited as follows: Date|Time|Transaction library|Item ID|From library|To library|Transit reason

"all receive from transit XXXX.txt"

  • These files refer to the transaction information for all items received from transit that year - these are items arrving at a branch from transit.
  • It is pipe delimited as follows: Date|Time|Receiving library|User access|Item ID
  • note: User access - this will tell you whether it was branch staff or one our automated sorter machines options are:
  • SIPSORTER <-- machine
  • XXCIRC or XXCIRCEX <-- branch staff, XX refers to branch code.

Source
Author Craig Ginther
Author Email Craig Ginther
Maintainer Content & Technology Department, Ottawa Public Library
Maintainer Email Content & Technology Department, Ottawa Public Library

Licence:

Developer Tools

  • The information on this page (the publication metadata) is also available in JSON format
    Link to JSON format