stars
87 rows where repo = 206649770
This data as json, CSV (advanced)
user >30 ✖
- mrluanma 1
- maurycy 1
- nogweii 1
- martymcguire 1
- Tafkas 1
- fmarani 1
- geraldb 1
- fkazimierczak 1
- barakplasma 1
- lqc 1
- alejandrodumas 1
- terrywang 1
- fly51fly 1
- victorfontes 1
- digvan 1
- JeffCarpenter 1
- mkol5222 1
- khimaros 1
- thedjpetersen 1
- tedmiston 1
- umaar 1
- ccope 1
- citelao 1
- mjstealth 1
- shouya 1
- rhamzeh 1
- jasonrdsouza 1
- oieduardorabelo 1
- venishjoe 1
- jankatins 1
- …
starred_at (date) >30 ✖
- 2020-11-14 5
- 2021-03-25 3
- 2023-03-13 3
- 2019-09-07 2
- 2019-11-26 2
- 2019-12-20 2
- 2020-05-08 2
- 2021-01-24 2
- 2021-03-26 2
- 2021-07-06 2
- 2021-12-26 2
- 2022-12-10 2
- 2019-09-05 1
- 2019-09-06 1
- 2019-10-08 1
- 2019-11-12 1
- 2019-11-23 1
- 2019-11-24 1
- 2019-11-29 1
- 2019-12-29 1
- 2019-12-31 1
- 2020-01-08 1
- 2020-05-09 1
- 2020-05-24 1
- 2020-05-30 1
- 2020-07-24 1
- 2020-07-28 1
- 2020-09-01 1
- 2020-09-24 1
- 2020-11-15 1
- …
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [stars] ( [user] INTEGER REFERENCES [users]([id]), [repo] INTEGER REFERENCES [repos]([id]), [starred_at] TEXT, PRIMARY KEY ([user], [repo]) ); CREATE INDEX [idx_stars_repo] ON [stars] ([repo]); CREATE INDEX [idx_stars_user] ON [stars] ([user]);