stars
7 rows where repo = 107914493 and "starred_at" is on date 2022-08-31
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
333073,107914493 | jide 333073 | datasette 107914493 | 2022-08-31T22:34:02Z |
621054,107914493 | rebot 621054 | datasette 107914493 | 2022-08-31T14:26:14Z |
999336,107914493 | luoq 999336 | datasette 107914493 | 2022-08-31T00:40:52Z |
4258713,107914493 | ekuiter 4258713 | datasette 107914493 | 2022-08-31T17:44:32Z |
6959765,107914493 | mwbyeon 6959765 | datasette 107914493 | 2022-08-31T15:08:07Z |
8560683,107914493 | ddervs 8560683 | datasette 107914493 | 2022-08-31T10:49:18Z |
32404415,107914493 | miwojc 32404415 | datasette 107914493 | 2022-08-31T04:58:13Z |
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]);