Users
Lists information about GitHub users.
View-Specific Information
Select
By default view will return information about all the registered users in GitHub. Note: This can be quite slow since GitHub has more than 20 million registered users.
If you specify the Login column, this view will only return information about the specified user.
The driver uses the GitHub API to process search criteria that refer to UserLogin. The driver processes other filters client-side within the driver. For example, the following queries are processed server side. You can turn off the client-side execution of the query by setting SupportEnhancedSQL to false in which case any search criteria that refers to other columns will cause an error.
- Login and Location support the following operator: =,!=
- CreatedAt supports the following operators: =,>,>=,<,<=
SELECT * FROM Users WHERE Login = 'MyUser'
Columns
| Name | Type | OrderBySupport | Description |
| Id [KEY] | String | The ID of the user. | |
| Login | String | The username used to login. | |
| AnyPinnableItems | Boolean | Determine if this repository owner has any items that can be pinned to their profile. Arguments type (PinnableItemType) Filter to only a particular kind of pinnable item. | |
| AvatarUrl | String | A URL pointing to the user's public avatar. Arguments size (Int) The size of the resulting square image. | |
| Bio | String | The user's public profile bio. | |
| BioHTML | String | The user's public profile bio as HTML. | |
| Company | String | The user's public profile company. | |
| CompanyHTML | String | The user's public profile company as HTML. | |
| CreatedAt | Datetime | Identifies the date and time when the object was created. | |
| DatabaseId | Int | Identifies the primary key from the database. | |
| String | The user's publicly visible profile email. | ||
| IsBountyHunter | Boolean | Whether or not this user is a participant in the GitHub Security Bug Bounty. | |
| IsCampusExpert | Boolean | Whether or not this user is a participant in the GitHub Campus Experts Program. | |
| IsDeveloperProgramMember | Boolean | Whether or not this user is a GitHub Developer Program member. | |
| IsEmployee | Boolean | Whether or not this user is a GitHub employee. | |
| IsHireable | Boolean | Whether or not the user has marked themselves as for hire. | |
| IsSiteAdmin | Boolean | Whether or not this user is a site administrator. | |
| IsViewer | Boolean | Whether or not this user is the viewing user. | |
| Location | String | The user's public profile location. | |
| Name | String | The user's public profile name. | |
| PinnedItemsRemaining | Int | Returns how many more items this profile owner can pin to their profile. | |
| ProjectsResourcePath | String | The HTTP path listing user's projects. | |
| ProjectsUrl | String | The HTTP URL listing user's projects. | |
| ResourcePath | String | The HTTP path for this user. | |
| TwitterUsername | String | The user's Twitter username. | |
| UpdatedAt | Datetime | Identifies the date and time when the object was last updated. | |
| Url | String | The HTTP URL for this user. | |
| ViewerCanChangePinnedItems | Boolean | Can the viewer pin repositories and gists to the profile?. | |
| ViewerCanCreateProjects | Boolean | Can the current viewer create new projects on this owner. | |
| ViewerCanFollow | Boolean | Whether or not the viewer is able to follow the user. | |
| ViewerIsFollowing | Boolean | Whether or not this user is followed by the viewer. | |
| WebsiteUrl | String | A URL pointing to the user's public website/blog. |
Pseudo-Columns
Pseudo column fields are used in the WHERE clause of SELECT statements and offer a more granular control over the tuples that are returned from the data source.
| Name | Type | Description |
| Repositories | Integer | You can filter users based on the number of repositories they own. |
| Language | String | You can search for users based on the languages of repositories they own. |
| Followers | Integer | You can filter users based on the number of followers that they have. |