Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

About the Data

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


Index NumberNameDescriptionTableau Dashboard Excel File DownloadDocumentationSQL 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 


ADC

CR184A

MCR184 loans and renewals Excel download

ADC

CR193

MCR193 filled delivery requests Excel download

Filtering data to obtain specific counts
CR184A

MCR184 SQL Query

CR193

MCR193 SQL Query

TD113
Physical Materials Counts

Material Counts

(updated quarterly)

Provides fiscal year counts of
physical
collections by material type.
*Physical

Materials Counts Dashboard

(forthcoming)

 

ADC MCR214 physical item counts (excluding microforms) EXCEL download

ADC MCR215 unique title (instance) counts of physical materials (excluding microforms) EXCEL download

ADC MCR216 unique title (instance) counts of microforms EXCEL download

ADC MCR217 unique title (instance) counts of ematerials EXCEL download


CUL Material Counts - Summary Documentation

CUL Material Counts - Detailed Documentation

CUL

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 QueryCR147_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 reportCR147_A SQL QueryCR147_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 reportCR147_B SQL QueryCR160

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 QueryCR161

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

Filtering data to obtain specific counts

Updating the Annual Data Collection's location translation table

MCR214 SQL Query

MCR215 SQL Query

MCR216 SQL Query

MCR217 SQL Query


Withdrawals and Transfers (updated quarterly)

Provides quarterly counts of withdrawals and transfers by college group (endowed or contract) or by location, for reporting to the Division of Financial Affairs

Withdrawals and Transfers




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


Eusage Counts Annual 2022

 

Data files available upon request, please email assessmentandplanning@cornell.eduEusage Counts - DocumentationNot applicable 

TD130

Reference and Instruction Dashboards

(updated daily)

Provides counts of reference interactions and presentations to groups from from Springshare's LibInsight platform 

Reference & Instruction Dashboards

Data files availabe upon request; please email libinsight@cornell.eduFiltering data to obtain specific countsNot applicable 

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 

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: QueryCR192

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