About the Data
The following 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
CUL Report Code
and Link to Query
REP Issues
7/1/22
in review; not currently available
| Index Number | Status | Name | Dashboard or Excel File Download | Description | Documentation | SQL Query Code |
|---|---|---|---|---|---|---|
| TD400 | Active | Physical Items Circulation Counts | Physical Items Circulation Counts Dashboard | 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. The data in this dashboard is based on the CR184A and CR193 SQL queries. | Filtering data to obtain specific counts | N/A |
| CR184A | Active | loans and renewals | CR184A SQL Query | |||
| CR193 | Active | filled delivery requests | CR193 SQL Query | |||
Physical Materials Counts | *Physical Materials Counts Dashboard (forthcoming) | Provides fiscal year counts of physical collections by material type. | CUL FOLIO Material Bib Format Display Table and Documentation | N/A | ||
E-usage Counts | E-usage Counts (forthcoming) |
Annual Statistics Reports
Documentation (in progress) on how these reports are being used for the CUL annual data collection and for national reporting is available on the FOLIO Annual Statistics Documentation page.
| CR144 | Review |
volume_count_stats |
N/A | newly created and total existing volume count statistics for Cornell annual statistics reports by unit and on campus versus the annex |
| 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 | Review | circulation_chargesrenewals_adc | N/A | 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. |
| BY REQUEST - please use the Request Form to get this report | CR147_A SQL Query |
| CR147_B | Review |
CR147_B - BY REQUEST - please use the Request Form to get this report |
N/A | Annual circulation statistics by consolidated patron group |
| BY REQUEST - please use the Request Form to get this report |
Warning - currently requires manual processing of results
7/1/22
| CR147_B SQL Query | |
| CR160 | Review |
soundrec_piece_ct_adc |
Note: long-running query, some results post to local schema
*adc = Annual Data CollectionN/A | This set of queries provides soundrecording piece count statistics for Cornell annual statistics reports, |
| by unit "on campus," and by unit at the Annex. |
BY REQUEST - please use the Request Form to get this report Warning - currently requires manual processing of results |
7/1/22
in review; not currently available
vidrec_piece_ct_adc
Note: long-running query, some results post to local schema |
| CR160 SQL Query | ||||
| CR161 | Review | vidrec_piece_ct_adc | N/A | This set of queries provides videorecording piece count statistics for Cornell annual statistics reports, by unit "on campus," and by unit at the Annex. |
BY REQUEST - please use the Request Form to get this report |
6/27/22
in review; not currently available
title_count_non-micr-physical_adc_stats
Note: long-running queries; some results post to local schema
5/10/22
in review; not currently available
title_count_micro_adc_stats
Note: long-running queries; some results post to local schema
8/11/22
in review; not currently available
title_count_servremo_viaculcodes_adc
Note: long-running queries; some results post to local schema
8/5/22
in review; not currently available
title_count_servremo_adc
Note: long-running queries; some results post to local schema
5/11/22
6/24/33
Warning - currently requires manual processing of results Note: long-running query, some results post to local schema | CR161 SQ: Query | ||
| CR192 | Active | withdrawn_items | N/A |
6/24/22
in review; not currently available
773_and_899_aggr_counts_adc
Note: long-running query
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. | 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. |
The query lists title, holdings hrid, library name, location name, call number, holdings type, withdrawal date, and number of pieces withdrawn.
| CR192 SQL Query | |
| CR193 | Active |
filled_delivery_requests | N/A | 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. |
| CR193 SQL Query |