stars
5 rows where "starred_at" is on date 2021-02-11
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
692632,107914493 | corytheboyd 692632 | datasette 107914493 | 2021-02-11T21:53:16Z |
4052400,107914493 | sapk 4052400 | datasette 107914493 | 2021-02-11T20:19:57Z |
24499480,107914493 | ivant75 24499480 | datasette 107914493 | 2021-02-11T17:58:34Z |
40061177,107914493 | Regis242 40061177 | datasette 107914493 | 2021-02-11T06:15:58Z |
43069023,107914493 | JakubKoralewski 43069023 | datasette 107914493 | 2021-02-11T13:43:29Z |
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]);