repos_starred (view)

Table actions

1 row where "created_at" is on date 2013-09-30, "pushed_at" is on date 2024-05-04 and "starred_at" is on date 2021-10-08

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: starred_at (date), created_at (date), updated_at (date), pushed_at (date), topics (array)

starred_at starred_by id node_id name full_name private owner html_url description fork created_at updated_at pushed_at homepage size stargazers_count watchers_count language has_issues has_projects has_downloads has_wiki has_pages has_discussions forks_count archived disabled open_issues_count license allow_forking is_template web_commit_signoff_required topics visibility forks open_issues watchers default_branch permissions temp_clone_token allow_squash_merge allow_merge_commit allow_rebase_merge allow_auto_merge delete_branch_on_merge allow_update_branch use_squash_pr_title_as_default squash_merge_commit_message squash_merge_commit_title merge_commit_message merge_commit_title organization security_and_analysis network_count subscribers_count custom_properties
2021-10-08T20:41:23Z lokhiufung 13221727 MDEwOlJlcG9zaXRvcnkxMzIyMTcyNw== xarray pydata/xarray 0 1284191 https://github.com/pydata/xarray N-D labeled arrays and datasets in Python 0 2013-09-30T17:21:10Z 2024-05-04T07:04:43Z 2024-05-04T14:49:07Z https://xarray.dev 43680 3417 3417 Python 1 1 1 0 0 1 1016 0 0 1144 apache-2.0 1 0 0 
[
    "dask",
    "netcdf",
    "numpy",
    "pandas",
    "python",
    "xarray"
]
 public 1016 1144 3417 main 
{
    "admin": true,
    "maintain": true,
    "push": true,
    "triage": true,
    "pull": true
}
   1 0 0 1 1 1 0 COMMIT_MESSAGES COMMIT_OR_PR_TITLE PR_TITLE MERGE_MESSAGE 1284191 
{
    "secret_scanning": {
        "status": "enabled"
    },
    "secret_scanning_push_protection": {
        "status": "disabled"
    },
    "dependabot_security_updates": {
        "status": "disabled"
    },
    "secret_scanning_validity_checks": {
        "status": "disabled"
    }
}
 1016 109 
{}

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE VIEW repos_starred AS select
  stars.starred_at,
  starring_user.login as starred_by,
  repos.*
from
  repos
  join stars on repos.id = stars.repo
  join users as starring_user on stars.user = starring_user.id
  join users on repos.owner = users.id
order by
  starred_at desc;