stars
6 rows where "starred_at" is on date 2021-12-06 sorted by repo
This data as json, CSV (advanced)
repo 2 ✖
Link | user | repo ▼ | starred_at |
---|---|---|---|
441980,107914493 | jmiziolek 441980 | datasette 107914493 | 2021-12-06T11:23:43Z |
6625123,107914493 | beppe9000 6625123 | datasette 107914493 | 2021-12-06T12:02:41Z |
13165540,107914493 | RusinovAnton 13165540 | datasette 107914493 | 2021-12-06T12:36:11Z |
4190609,107914493 | ibmw 4190609 | datasette 107914493 | 2021-12-06T21:50:24Z |
92409154,107914493 | CMD-reverse 92409154 | datasette 107914493 | 2021-12-06T22:19:51Z |
35042820,140912432 | jmatthewpeters 35042820 | sqlite-utils 140912432 | 2021-12-06T05:02:51Z |
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]);