About the Data
Please note that the dashboards and Excel file downloads linked under the "Dashboard or Excel Download Link" column 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
- *Please refer to CUL FOLIO Material Bib Format Display Table and Documentation for information on physical material format groupings found in Annual Data Collection dashboards.
- Accessing and Using Data Dashboards - Detailed Instructions
- Filtering and Sorting Data in Excel Downloads - Detailed Instructions
| Index Number | Name | Description | Dashboard or Excel File Download | Excel File Download | Documentation | SQL Query Code |
|---|---|---|---|---|---|---|
| TD400 | 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 | Filtering data to obtain specific counts | ||
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 | N/A | ||
E-usage Counts | E-usage Counts (forthcoming) | |||||
| CR144 | volume_count_stats | newly created and total existing volume count statistics for Cornell annual statistics reports by unit and on campus versus the annex | N/A | BY REQUEST - please use the Request Form to get this report Note: long-running query, results post to local schema | CR144 SQL Query | |
| CR147_A | circulation_chargesrenewals_adc | Circulation statistics (charges and renewals) by library, patron group and collection type (regular, reserve, laptop, equipment) used for the annual data collection. Excludes SPEC and ILL/BD owned by other institutions. | N/A | BY REQUEST - please use the Request Form to get this report | CR147_A SQL Query | |
| CR147_B | CR147_B - BY REQUEST - please use the Request Form to get this report | Annual circulation statistics by consolidated patron group | N/A | BY REQUEST - please use the Request Form to get this report | CR147_B SQL Query | |
| CR160 | soundrec_piece_ct_adc | This set of queries provides soundrecording piece count statistics for Cornell annual statistics reports, by unit "on campus," and by unit at the Annex. | N/A | BY REQUEST - please use the Request Form to get this report Warning - currently requires manual processing of results Note: long-running query, some results post to local schema | CR160 SQL Query | |
| CR161 | vidrec_piece_ct_adc | This set of queries provides videorecording piece count statistics for Cornell annual statistics reports, by unit "on campus," and by unit at the Annex. | N/A | BY REQUEST - please use the Request Form to get this report Warning - currently requires manual processing of results Note: long-running query, some results post to local schema | CR161 SQ: Query | |
| 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. The query lists title, holdings hrid, library name, location name, call number, holdings type, withdrawal date, and number of pieces withdrawn. | N/A | NOTE: As of 8-15-22, the count of withdrawn items comes from the administrative note on the instance record and is not linked to specific holdings records. In this case, the the query lists all the holdings locations, and the total number of pieces withdrawn, without being able to specify from which locations the withdrawals took place. | 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. | N/A | CR193 SQL Query |