You are viewing an old version of this page. View the current version.

Compare with Current View Page History

« Previous Version 25 Next »

About the Data

Please note that the dashboards and Excel file downloads linked under the "Tableau Dashboard" and "Excel File Download" columns below are automatically updated every morning by 10:00am. The data shown was current in the FOLIO system at the end of the previous business day (yesterday's data).

All Cornell Library staff have access to view these dashboards and Excel files. If you have questions about this data, please submit a request through the Requesting Reporting Help form.

Documentation


Index NumberNameDescriptionTableau Dashboard Excel File DownloadDocumentationSQL Query Code
TD400 CR184A CR193

Physical Items Circulation Counts

Provides 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

TD113

Physical Materials Counts

Provides fiscal year counts of physical collections by material type.

*Physical Materials Counts Dashboard (forthcoming)


CUL FOLIO Material Bib Format Display Table and Documentation

TD103

TD104

E-usage Counts

Eusage by Title - Annual data from EBSCO Consolidated files, received twice a year. Data not available in Folio. Data compiled by Sally Lockwood (sjl8) and made available in a BOX folder. 

Eusage by Platform - Annual data from EBSCO Consolidated files, received twice a year. Data not available in Folio. Data compiled by Sally Lockwood (sjl8) and made available in a BOX folder. 

E-usage Counts (forthcoming)





CR192

Withdrawn Items

This query finds the number of items withdrawn in the date range specified, as of 7-1-21 and going forward. From 7-1-21 through 8-14-22, the withdrawn information comes from the holdings note on specific holdings records. 


CR192 SQL Query
CR193

Filled Delivery Requests

This query provides a count of all contactless delivery and circulation desk pickup requests, by fiscal year. Patron group, material type, request type, and location details are included. 


ADC CR193 filled delivery requests Excel download
CR193 SQL Query



  • No labels