Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

All Cornell Library staff who have approval to access to the Library Data Platform (LDP) reporting database have access to view these data dashboards.  If you have questions about this data, please submit a request through the Requesting Reporting Help form.

Documentation

...

  • MCR = Canned

...

  • Report

...

Access Services Dashboards & Excel Downloads

(all Access Services dashboards and Excel reports update daily)


Index NumberNameDescriptionTableau DashboardExcel File DownloadDocumentationSQL Query Code
TD400Physical Items Circulation CountsProvides fiscal year counts of physical collections use (loans and renewals) with filters for owning library, patron group, material type, and collection type (regular, equipment, etc.). Also provides counts of patron filled requests.Physical Items Circulation Counts Dashboard 

ADC CR184A loans and renewals Excel download

ADC CR193 filled delivery requests Excel download

Filtering data to obtain specific counts

CR184A SQL Query

CR193 SQL Query

TD401Circulation Desk TransactionsProvides counts of circulation desk transactions by month, day, date, and time of day, with filters for material type, request type, and action type (checkin or checkout). Circulation Desk Transaction DashboardN/ATD402
TD402Missing, Lost, Claimed, Returned, and
Missing and
In Transit ItemsProvides a list of all items
that have an
with item status
of 'missing',
(missing, lost, claimed returned, aged to lost, etc.) including item details
, with filters including
. Filters include Library, permanent location, missing status date, call number and LC class. Also contains a separate view for list of items where item status is 'in transit', along with  item details and a filter for number of days in transit. If items haven't been checked in at the home location (permanent location) after a specified time period, the items might have been lost or misplaced on their way back to their home location.Missing, Lost, Claimed Returned, and In Transit Items Dashboard
N/ACR204Missing, Lost, Claimed, Returned ItemsThis query creates a list of missing, lost, and claimed returned items (including equipment) at a given library, and includes item status date, last date and location of check in, and size/pagination. Sorts

MCR204 Missing Lost Claimed Returned Excel Download


MCR118 Missing In Transit Excel Download


Excel file sorts in call number order. To view results for a particular library, sort your Excel file on the library_name column. To view results for a particular item status (e.g., Missing, Aged to Lost, Lost and Paid), sort your Excel file on the status_name columnMCR118, MCR204

Patron Item RequestsProvides counts of patron item requests by year, patron type, request type (page, recall, etc.) and owning library.Patron Item Requests

MCR107 Query


Provides counts as well as details of BD/ILL physical item loans from CUL to other universities, and from other universities to CUL. For loans to CUL, title names are available, but no further information about the title is available. Patron group and department names are included when available. 

(updated daily)

Borrow Direct/Interlibrary Loans Counts and Details





MCR171

MCR172

MCR174A

MCR174B

SQL Queries

TD401Circulation Desk TransactionsProvides counts of circulation desk transactions by month, day, date, and time of day, with filters for material type, request type, and action type (checkin or checkout)
Circulation Desk Transaction Dashboard

MCR108 SQL Query
TD400Physical Items Circulation CountsProvides fiscal year counts of physical collections use (loans and renewals) with filters for owning library, patron group, material type, and collection type (regular, equipment, etc.). Also provides counts of patron filled requests.Physical Items Circulation Counts Dashboard 

ADC MCR184 loans and renewals Excel download

ADC MCR193 filled delivery requests Excel download

Filtering data to obtain specific counts

MCR184 SQL Query

MCR193 SQL Query


E-journals usage, 2020 - 2023

Provides year to year comparisons of details of e-journals usage by title, publisher, and platform. 

(updated annually)

E-journals usage 2020 - 2023

E-journals usage 2022 - 2024

E-journals usage 2024 - 2025

N/A: Data from EBSCO Consolidated Counter Reports

Missing Lost Claimed Returned Excel DownloadCR204