Library loaning data
Received: 7 July 2025
I would like to request two datasets and one policy question related to the Council Library system. 1. Unborrowed books: I'd like to compile a list of titles for the physical books that the Council Library system owns, but which have not been loaned out or requested by any library patron.I am specifically interested in titles that have been owned for more than one year, without any loan requests.If possible, it would be great if the data could include as many of the following features as possible: - Title- Author- ISBN- Date of acquisition by the Council Library system- Where the book was acquired from (ex. 'Public donation', 'Publisher donation', 'Purchase', etc.)- Item type (ex. 'Adult Non-fiction', 'Junior fiction', etc.)- Storage location/Item Home location (typically library branch)- Periods of time in which the title was present in a lending library (not in storage)If it would be possible to provide the data search query you use (the SQL query, for example), that would also be tremendously helpful. 2. Library loaning trendsI would also like the following loan information, aggregated by year for each of the past 20 years (2004 - 2024).- Total count of physical book loans per year- Count of physical book loans by Item type ('Adult Non-fiction', 'Junior fiction', etc.)- Number of borrowing patrons per year (where a borrowing patron is defined as any person who has borrowed at least 1 physical book in the given year)3. Book cleanup policy I would like to know if the Council Library system has a policy for when books are removed from stock without replacement. Specially, under what circumstances would a book be removed from stock without replacement?
Outcome / Documents
- Response (some not held) - application/pdf - Download