About the Data
The following 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
- *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 -
DetailedInstructions
- Filtering and Sorting Data in Excel Downloads - Detailed Instructions
- TD = Tableau Dashboard, CR = Canned Report, AHR = Ad Hoc Report, ADC = Annual Data Collection
| Index Number |
|---|
| Name | Description | Tableau Dashboard | Excel File Download |
|---|
| Documentation | SQL Query Code | |
|---|---|---|
| TD400 CR184A CR193 | Physical Items Circulation Counts |
(Updated daily) | 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 | ||
| TD113 |
Materials Counts |
( |
Updated quarterly) | Provides fiscal year counts of |
| collections by material type. |
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.
ADC CR214 physical item counts (excluding microforms) EXCEL download ADC CR215 unique title (instance) counts of physical materials (excluding microforms) EXCEL download ADC CR216 unique title (instance) counts of microforms EXCEL download ADC CR217 unique title (instance) counts of ematerials EXCEL download | CUL Material Counts - Summary Documentation CUL Material Counts - Detailed Documentation CUL FOLIO Material Bib Format Display Table and Documentation Filtering data to obtain specific counts Updating the Annual Data Collection's location translation table | |||||
TD103 TD104 | E-usage Counts (Updated annually) | Provides annual year counts of esuage by resource type. Data not available in Folio; data are from EBSCO Consolidated files, compiled by Sally Lockwood (sjl8) and made available in a BOX folder. |
| Eusage Counts - Documentation | Not applicable | |
TD130 | Reference Interaction Counts (in review; update to be determined) | Provides counts of reference interactions from LibInsight as well as from the previously used CountIt system | NA | NA | NA | |
TD128 | Cornell University Library Annual Trends, FY2013 - FY2018 (Historical, no updates) | Provides a view of annual trends based the CUL Statistical Trends Reports, such as overall counts of collections and usage, research and learning services, visits, facilities, and staffing, expenditures, and Association of Research Libraries rankings. | Cornell University Library Annual Trends, FY2013 - FY2018 | See individual CUL Statistical Trends Reports for documentation pertaining to each year's data. | Not applicable |
CUL Report Code
and Link to Query
REP Issues
7/1/22
in review; not currently available
volume_count_stats
Note: long-running query, results post to local schema
newly created and total existing volume count statistics for Cornell annual statistics reports by unit and on campus versus the annex
np55
CR160 - 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
soundrec_piece_ct_adc
Note: long-running query, some results post to local schema
*adc = Annual Data Collection
CR161 - 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
*adc = Annual Data Collection
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
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.
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.