stars
12 rows where "starred_at" is on date 2019-05-13 sorted by user descending
This data as json, CSV (advanced)
Link | user ▲ | repo | starred_at |
---|---|---|---|
11752923,107914493 | tockards 11752923 | datasette 107914493 | 2019-05-13T11:48:24Z |
10001381,107914493 | swoldanski 10001381 | datasette 107914493 | 2019-05-13T21:55:16Z |
3315629,107914493 | laderast 3315629 | datasette 107914493 | 2019-05-13T19:53:32Z |
2645393,107914493 | madisonmay 2645393 | datasette 107914493 | 2019-05-13T12:34:46Z |
2517831,107914493 | bradbaris 2517831 | datasette 107914493 | 2019-05-13T23:22:28Z |
2155125,107914493 | nakaz 2155125 | datasette 107914493 | 2019-05-13T18:14:50Z |
1759570,107914493 | cncplyr 1759570 | datasette 107914493 | 2019-05-13T14:03:37Z |
1624945,107914493 | rightaditya 1624945 | datasette 107914493 | 2019-05-13T08:59:03Z |
1164962,107914493 | igorbrigadir 1164962 | datasette 107914493 | 2019-05-13T15:13:07Z |
643280,107914493 | aatrostle 643280 | datasette 107914493 | 2019-05-13T05:27:00Z |
118984,107914493 | natea 118984 | datasette 107914493 | 2019-05-13T17:46:56Z |
25930,107914493 | haraball 25930 | datasette 107914493 | 2019-05-13T12:11:07Z |
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]);