repos_starred (view)
1 row where created_at = "2019-10-13T02:10:13Z" and "starred_at" is on date 2020-04-01 sorted by forks
This data as json, CSV (advanced)
Suggested facets: created_at (date), pushed_at (date), topics (array)
Advanced export
JSON shape: default, array, newline-delimited
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;