stars
6 rows where repo = 107914493 and "starred_at" is on date 2021-09-15 sorted by repo
This data as json, CSV (advanced)
Link | user | repo ▼ | starred_at |
---|---|---|---|
23205122,107914493 | IsaacPang 23205122 | datasette 107914493 | 2021-09-15T00:47:23Z |
5283352,107914493 | sd-omkar 5283352 | datasette 107914493 | 2021-09-15T05:47:09Z |
18740659,107914493 | tomasfarias 18740659 | datasette 107914493 | 2021-09-15T07:48:03Z |
88512618,107914493 | PankajTaywade 88512618 | datasette 107914493 | 2021-09-15T08:05:07Z |
563120,107914493 | shiyan31214 563120 | datasette 107914493 | 2021-09-15T12:16:09Z |
52237913,107914493 | Redfire75369 52237913 | datasette 107914493 | 2021-09-15T15:59:19Z |
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]);