About the Data
Please note that the dashboards and Excel file downloads linked under the "Tableau Dashboard or " and "Excel File Download Link" column 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
E-usage Counts (forthcoming)
volume_count_stats
N/A
Note: long-running query, results post to local schema
circulation_chargesrenewals_adc
N/A
CR147_B - BY REQUEST - please use the Request Form to get this report
N/A
soundrec_piece_ct_adc
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
vidrec_piece_ct_adc
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
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 |
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.
filled_delivery_requests
N/A