...
| Index Number | Name | Description | Tableau Dashboard | Excel File Download | Documentation | SQL 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 | 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 | 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 |