Issues & Pull Requests Dataset Overview

Click on any field to access its documentation.

> Entity Fields

Field label	Field ID in dataset
Approvals	`approvals_count`
Assigned at	`assigned_at`
Assignees	`assignee_usernames`
Author	`author_username`
Base ref \| Branch	`base_ref_branch`
Base ref \| Repository	`base_ref_repository`
Body	`body`
Build status	`build_status`
Closed at	`closed_at`
Created at	`created_at`
Due on	`due_on`
First comment after review requested at	`first_comment_after_review_requested_at`
First comment at	`first_comment_at`
First commit at	`first_commit_at`
First review created at	`first_review_created_at`
First review submitted at	`first_review_submitted_at`
Head ref \| Branch	`head_ref_branch`
Head ref \| Repository	`head_ref_repository`
ID (source)	`id`
ID (system)	`system_id`
Key	`key`
Labels	`label_names`
Last assigned at	`last_assigned_at`
Last comment at	`last_comment_at`
Last commit at	`last_commit_at`
Last commit before first review at	`last_commit_before_first_review_at`
Last review created at	`last_review_created_at`
Last review submitted at	`last_review_submitted_at`
Lines added	`additions`
Lines changed	`lines_changed`
Lines deleted	`deletions`
Mergeability	`mergeable`
Merged at	`merged_at`
Merged by	`merged_by_username`
Metatags	`metatags`
Owners	`owner_usernames`
Past assignees	`past_assignee_usernames`
Past reviewers	`past_reviewer_usernames`
Past workflow statuses	`past_workflow_statuses`
Project	`project_name`
Project Source	`project_source`
Recommended action	`recommended_action`
Recommended actors	`recommended_actor_username`
Requested reviewers	`requested_reviewer_` `usernames`
Required approvals	`required_approval_` `count`
Required approvals remaining	`required_approval_` `remaining_count`
Resolution state	`resolution_state`
Review approved at	`review_approved_at`
Review last approved at	`review_last_approved_at`
Review last rejected at	`review_last_rejected_at`
Review last requested at	`review_last_requested_at`
Review rejected at	`review_rejected_at`
Review requested at	`review_requested_at`
Review state	`review_state`
Source app	`source_app`
State	`state`
Story points	`story_points`
Sub-type	`sub_type`
Suggested mergers	`suggested_merger_usernames`
Time estimate	`time_estimate`
Time spent	`time_spent`
Title	`title`
Type	`type`
Updated at	`updated_at`
URL	`url`
Workflow status	`workflow_status`
Workflow timeline	`workflow_timeline`

> Parent Issue Fields

Read more about the logic behind the Parent Issue discovery.

Field label	Field ID in dataset
Parent Issue > Author	`parent_issue_author_username`
Parent Issue > Closed At	`parent_issue_closed_at`
Parent Issue > Created At	`parent_issue_created_at`
Parent Issue > Due On	`parent_issue_due_on`
Parent Issue > ID (Source)	`parent_issue_id`
Parent Issue > ID (System)	`parent_issue_system_id`
Parent Issue > Key	`parent_issue_key`
Parent Issue > Labels	`parent_issue_label_names`
Parent Issue > Lines added	`parent_issue_additions`
Parent Issue > Lines Changed	`parent_issue_lines_changed`
Parent Issue > Lines Deleted	`parent_issue_deletions`
Parent Issue > Metatags	`parent_issue_metatags`
Parent Issue > Past Workflow Statuses	`parent_issue_past_workflow_statuses`
Parent Issue > Project	`parent_issue_project_name`
Parent Issue > State	`parent_issue_state`
Parent Issue > Sub-Type	`parent_issue_sub_type`
Parent Issue > Title	`parent_issue_title`
Parent Issue > Updated At	`parent_issue_updated_at`
Parent Issue > URL	`parent_issue_url`
Parent Issue > Workflow Status	`parent_issue_workflow_status`
Parent Issue > Workflow Timeline	`parent_issue_workflow_timeline`

> Resolved Issues Fields

Read more about linking issues to pull requests.

Field label	Field ID in dataset
Resolved Issues > Assignees	`resolved_issue_assignee_usernames`
Resolved Issues > Authors	`resolved_issue_author_usernames`
Resolved Issues > First assigned at	`resolved_issue_first_assigned_a`t
Resolved Issues > First closed at	`resolved_issue_first_closed_at`
Resolved Issues > First created at	`resolved_issue_first_created_at`
Resolved Issues > IDs (System)	`resolved_issue_sysids`
Resolved Issues > Labels	`resolved_issue_label_names`
Resolved Issues > Last assigned at	`resolved_issue_last_assigned_a`t
Resolved Issues > Last closed at	`resolved_issue_last_closed_at`
Resolved Issues > Last created at	`resolved_issue_last_created_at`
Resolved Issues > Metatags	`resolved_issue_metatags`
Resolved Issues > Projects	`resolved_issue_project_names`
Resolved Issues > Sub-types	`resolved_issue_sub_types`

> Resolving Pull Requests Fields

Read more about which PRs qualify as resolving PRs for a given issue.

Field label	Field ID in dataset
Resolving PRs > Assignees	`resolving_pr_assignee_usernames`
Resolving PRs > Authors	`resolving_pr_author_usernames`
Resolving PRs > First closed at	`resolving_pr_first_closed_at`
Resolving PRs > First created at	`resolving_pr_first_created_at`
Resolving PRs > First merged at	`resolving_pr_first_merged_at`
Resolving PRs > IDs (System)	`resolving_pull_request_sysids`
Resolving PRs > Labels	`resolving_pr_label_names`
Resolving PRs > Last closed at	`resolving_pr_last_closed_at`
Resolving PRs > Last created at	`resolving_pr_last_created_at`
Resolving PRs > Last merged at	`resolving_pr_last_merged_at`
Resolving PRs > Projects	`resolving_pr_project_names`

> Sprint Fields

Field label	Field ID in dataset
Past sprint names	`past_sprint_names`
Sprint \| Closed at	`sprint_closed_at`
Sprint \| End at	`sprint_end_at`
Sprint \| Name	`sprint_name`
Sprint \| Start at	`sprint_start_at`
Sprint \| State	`sprint_state`

Comments Dataset Overview

Issues and PRs > Story points

Issues and PRs > Metatags

Issues and PRs > Resolved Issue Metatags

Activity Events Dataset Overview