Skip to Main Content

Experts Directory: Data Extracts

Data Extracts

Data Extracts

Experts Directory provides a number of data extracts to provide reports on the data within the system. 

If you have need for a report that is not included here, please complete a Support Ticket.

Go to Experts Directory menu icon(Menu) > Reporting > Reports & Dashboards > Reporting Hub

The reports available to you will be displayed. Click the heart icon to favorite any of the reports/reports; you may then use the filter on the right side of the page to view all favorited reports/dashboards. See bottom of this page for a description of each report.

1. Click on the Run button next to the report you wish to run

2. Click Select Target group and click Confirm

  • Only groups for which you have 'Statistician' access will be available. If you would like to request Statistician access, complete a Support Ticket.
  • You may only run reports for one group at a time.

3. Select Start and End Dates (if available)

  • Enter a 'Date from' and a 'Date to' in the format 'DD/MM/YYYY'. These dates are inclusive.
  • Choose whether to include inactive users (those who have now left OSU)
  • Choose whether to include non-academic staff

4. Select a Format (if available)

  • Available file types (e.g. Excel, CSV) will be displayed.
  • If the report is a Data Extract, output will be in CSV by default.

Available reports

  • Academic CV: An academic CV populated with personal details from an individual's profile, including associated research outputs, activities and grants. This is a "stock" report and at this point may display errors or incomplete data. Further development to this report will be implemented in 2025.
  • Academic Appointments: Provides all data from academic appointments table (includes institutional and academic appointments) by group.
  • Associated identifiers: Returns information on identifiers (e.g. ORCIDs, Scopus IDs) used for automatic publications claiming
  • Associated ORCID iDs: The ORCID iDs that are associated with users, including their connection status.
  • Coronavirus Publications Retrieves a dataset of publications including any of the words coronavirus, covid, MERS-CoV, or SARS-CoV in the keywords, abstract, or title fields.
  • Faculty Degree Table: A table of degree data for all faculty members in the group selected, designated either "Internal" or "Public." Data includes degree name, field, institution, city, country, graduation date, and thesis title (if provided). The 'degree_index' column specifies the order in which they appear, with 0 indicating the top degree. 
  • Fields of Research (OSU) Report: Provides OSU Fields of Research for each user in the group, including label name, label code, and vocabulary IDs
  • Grant Report (Public and Internal Only): A table of a user's Grants, Other Funding, and Proposed Grants designated as "internal" or "public" only. Includes one row per unique user/item -- therefore there may be duplication if multiple users within the group co-authored an item. Deduplicate using the 'experts_grant_id' variable. 
  • NIH biographical sketch (2015): Required for due dates on or after May 25 2015 and encouraged for applications due on or after January 25 2015, using data available on your profile.
  • NIH biographical sketch (2021): Required for due dates on or after January 25 2022 and encouraged for due dates on or after May 25 2021, using data available on your profile.
  • NIH biographical sketch (pre-2015): Required for due dates before January 25 2015, using data available on your profile.
  • Public Profile Status Report with Departments: This report provides the count of public, internal , private and percentage of public users at the college level.
  • Scholarly & creative works summary (public and internal items): A summary of user's public scholarly & creative works. Includes one row per unique user/item -- therefore there may be duplication if multiple users within the group co-authored an item. Deduplicate using the ID value.
  • Scholarly & creative works summary (public items only): A summary of user's public scholarly & creative works. Includes one row per unique user/item -- therefore there may be duplication if multiple users within the group co-authored an item. Deduplicate using the ID value.
  • Scholarly & creative works summary with roles (public and internal items): Includes all claimed scholarly and creative works with specification of Creative or Contributor roles (if added). If a given individual had more than one Creative or Contributor role then there will be multiple rows for that individual.
  • Scholarly & creative works with Sustainable Development Goals (SDGs) (public + internal items only): The SDG labels for user publication relationships related to the claimed publications with SDG labels. Returns items marked "public" or "internal" only. Includes one row per unique article + current OSU author + SDG combination. Thus for instance if an article is authored by two current OSU authors and has three SDGs there will be 6 rows for that article.
  • Service & Outreach Activities: A table of a user's service and outreach activities. Returns items marked "public" or "internal" only.
  • User profile completeness with Departments: Returns a completeness report for user's profiles, including a field for department.