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`
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`

> Resolved Issues Fields

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 > Sub-types	`resolved_issue_sub_types`

> Resolving Pull Requests Fields

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`

Linking Pull Requests to Issues

Issues and PRs > Metatags

Issues and PRs > Resolved Issue Labels

Issues and PRs > Resolved Issue Metatags

Issues and PRs > Resolved Issue Assignees