Stargazers
Lists users who have starred a repository, indicating their interest in or support for the project.
View-Specific Information
Select
The add-in processes all filters client-side within the add-in. The following query is the only one processed server-side:
SELECT * FROM [Stargazers]
Columns
| Name | Type | References | OrderBySupport | Description |
| Id [KEY] | String | A unique identifier assigned to the user for tracking and reference. | ||
| DatabaseId | Int | The primary key value for the user as stored in the database. | ||
| Login | String | The GitHub username used by the user to log in and interact with the platform. | ||
| Name | String | The public display name of the user on their GitHub profile. | ||
| String | The publicly visible email address listed on the user's profile, if available. | |||
| TwitterUsername | String | The Twitter handle associated with the user's GitHub profile. | ||
| Pronouns | String | The pronouns specified by the user on their public GitHub profile. | ||
| Bio | String | A brief description or biography provided by the user on their profile. | ||
| BioHTML | String | The user's biography formatted and rendered in HTML for profile display. | ||
| Company | String | The organization or company the user is affiliated with, as listed on their profile. | ||
| CompanyHTML | String | The company information rendered in HTML for profile display. | ||
| Location | String | The geographic location specified by the user on their public profile. | ||
| AnyPinnableItems | Bool | Indicates whether the user has any repositories or gists that can be pinned to their profile. | ||
| PinnedItemsRemaining | Int | The number of additional items the user can pin to their profile. | ||
| ItemShowcaseHasPinnedItems | Bool | Indicates whether the user has already pinned repositories or gists to their profile. | ||
| IsEmployee | Bool | Indicates whether the user is an employee of GitHub. | ||
| IsHireable | Bool | Indicates whether the user is open to job opportunities, as stated on their profile. | ||
| IsBountyHunter | Bool | Indicates whether the user participates in the GitHub Security Bug Bounty Program. | ||
| IsCampusExpert | Bool | Indicates whether the user is part of the GitHub Campus Experts Program, which promotes technical leadership on campuses. | ||
| IsFollowingViewer | Bool | Indicates whether this user is currently following the viewer. | ||
| IsSiteAdmin | Bool | Indicates whether the user has administrative privileges on GitHub. | ||
| IsDeveloperProgramMember | Bool | Indicates whether the user is a member of the GitHub Developer Program, which provides early access to new features. | ||
| IsGitHubStar | Bool | Indicates whether the user is a recognized member of the GitHub Stars Program, highlighting influential contributors. | ||
| IsSponsoringViewer | Bool | Indicates whether this user or organization is sponsoring the viewer on GitHub Sponsors. | ||
| IsViewer | Bool | Indicates whether this user is the currently authenticated viewer. | ||
| ViewerCanFollow | Bool | Indicates whether the currently authenticated viewer has permission to follow this user. | ||
| ViewerCanSponsor | Bool | Indicates whether the viewer can sponsor this user or organization via GitHub Sponsors. | ||
| ViewerIsFollowing | Bool | Indicates whether the viewer is currently following this user. | ||
| ViewerIsSponsoring | Bool | Indicates whether the viewer is currently sponsoring this user or organization on GitHub. | ||
| ViewerCanCreateProjects | Bool | Indicates whether the current viewer is authorized to create new projects for this user or organization. | ||
| ViewerCanChangePinnedItems | Bool | Indicates whether the viewer can pin repositories and gists to the user's profile. | ||
| StatusId | String | A unique identifier for the user's status emoji. | ||
| StatusEmoji | String | An emoji representing the user's current status. | ||
| StatusMessage | String | A short message that describes the user's current activity or availability. | ||
| StatusIndicatesLimitedAvailability | Bool | Indicates whether the user's status message signifies limited availability on GitHub. | ||
| StatusEmojiHTML | String | The user's status emoji rendered in HTML format. | ||
| StatusCreatedAt | Datetime | The date and time when the user's status was first set. | ||
| StatusExpiresAt | Datetime | The expiration date and time after which the status will no longer be displayed. | ||
| StatusUpdatedAt | Datetime | The date and time when the user's status was last updated. | ||
| StatusOrganizationId | String | The unique identifier of the organization associated with the user's status. | ||
| StatusOrganizationLogin | String | The login name of the organization linked to the user's status. | ||
| InteractionAbilityLimit | String | The current interaction restriction applied to this user (for example, limits on comments or contributions). | ||
| InteractionAbilityOrigin | String | The origin of the active interaction restriction (for example, organization or GitHub-wide policy). | ||
| InteractionAbilityExpiresAt | Datetime | The expiration date and time for the currently active interaction restriction. | ||
| HasSponsorsListing | Bool | Indicates whether the user or organization has an active GitHub Sponsors profile. | ||
| MonthlyEstimatedSponsorsIncomeInCents | Int | The estimated monthly GitHub Sponsors income for this user or organization, in cents (USD). | ||
| EstimatedNextSponsorsPayoutInCents | Int | The estimated amount in cents (USD) for the next GitHub Sponsors payout. | ||
| SponsorsListingId | String | The unique identifier for the user's GitHub Sponsors listing. | ||
| SponsorsListingName | String | The full name associated with the GitHub Sponsors listing. | ||
| TotalSponsorshipAmountAsSponsorInCents | Int | The total amount in cents (USD) that this user has spent sponsoring others on GitHub. | ||
| ResourcePath | String | The HTTP path that provides access to the user's profile on GitHub. | ||
| ProjectsResourcePath | String | The HTTP path that lists the user's projects. | ||
| Url | String | The HTTP URL to the user's profile page on GitHub. | ||
| ProjectsUrl | String | The HTTP URL that lists the user's projects. | ||
| WebsiteUrl | String | The URL of the user's personal website or blog. | ||
| AvatarUrl | String | The URL of the user's avatar image on GitHub. | ||
| CopilotEndpointsApi | String | The API endpoint used for GitHub Copilot integration. | ||
| CopilotEndpointsOriginTracker | String | The GitHub Copilot origin tracking endpoint. | ||
| CopilotEndpointsProxy | String | The proxy endpoint used for GitHub Copilot interactions. | ||
| CopilotEndpointsTelemetry | String | The telemetry endpoint used for tracking GitHub Copilot usage data. | ||
| CreatedAt | Datetime | The date and time when the user's GitHub account or organization was created. | ||
| UpdatedAt | Datetime | The date and time when the user's profile information was last updated. | ||
| RepositoryCount | Int | The total number of repositories owned by the user. | ||
| FollowerCount | Int | The total number of users following this user. |