# Github: Issues

## Description

* Basic information about issues as well as additional fields for things like assignees, projects, labels and open time

## Supported Data Sources

* <img src="https://fivetran.com/integrations/github/resources/github.svg" alt="" data-size="line"> GitHub

## Columns

| Type     | Name                        | Description                                                                                        |
| -------- | --------------------------- | -------------------------------------------------------------------------------------------------- |
| INTEGER  | issue\_id                   | The unique ID of an issue.                                                                         |
| STRING   | body                        | The text body of the issue's main description                                                      |
| DATETIME | closed\_at                  | The timestamp for when an issue was last closed. "null" for issues that are open                   |
| DATETIME | created\_at                 | The timestamp for when an issue was created                                                        |
| BOOLEAN  | is\_locked                  | Boolean indicating if the issue is locked.                                                         |
| INTEGER  | milestone\_id               | Foreign key that references the milestone table representing the current milestone the issue is in |
| INTEGER  | issue\_number               | The number of the issue. Is unique within a repository, but not accross                            |
| BOOLEAN  | is\_pull\_request           | Boolean indicating whether the issue is a pull request                                             |
| INTEGER  | repository\_id              | Foreign key that references the repository table                                                   |
| STRING   | state                       | Whether the issue is open or closed                                                                |
| STRING   | title                       | The title of the issue                                                                             |
| DATETIME | updated\_at                 | Timestamp of when the issue was last updated                                                       |
| INTEGER  | user\_id                    | Foreign key that references the user table.                                                        |
| STRING   | url\_link                   | a link to the issue on github.com                                                                  |
| DECIMAL  | days\_issue\_open           | The number of days an issue has been open                                                          |
| INTEGER  | number\_of\_times\_reopened | Total number of times the issue was reopened                                                       |
| STRING   | labels                      | A list of the labels that are currently applied to the issue                                       |
| INTEGER  | number\_of\_comments        | The total number of comments included in the issue                                                 |
| STRING   | repository                  | The repository that the issue is applicable to                                                     |
| STRING   | repository\_team\_names     | An aggreate of the teams associated with the repository                                            |
| STRING   | assignees                   | The current list of users assigned to the issue                                                    |
| STRING   | creator\_login\_name        | User that created the issue login name                                                             |
| STRING   | creator\_name               | User that created the issue name.                                                                  |
| STRING   | creator\_company            | User that created the issue company name.                                                          |


---

# Agent Instructions: Querying This Documentation

If you need additional information that is not directly available in this page, you can query the documentation dynamically by asking a question.

Perform an HTTP GET request on the current page URL with the `ask` query parameter:

```
GET https://endash-guidance-docs.gitbook.io/cigro-data-templates/data-model-templates/github-issues.md?ask=<question>
```

The question should be specific, self-contained, and written in natural language.
The response will contain a direct answer to the question and relevant excerpts and sources from the documentation.

Use this mechanism when the answer is not explicitly present in the current page, you need clarification or additional context, or you want to retrieve related documentation sections.