stars
9 rows where repo = 107914493 and "starred_at" is on date 2023-02-19
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
833720,107914493 | nilsbunger 833720 | datasette 107914493 | 2023-02-19T17:31:14Z |
1730702,107914493 | mquandalle 1730702 | datasette 107914493 | 2023-02-19T00:24:58Z |
4615889,107914493 | Techcable 4615889 | datasette 107914493 | 2023-02-19T20:29:35Z |
4978418,107914493 | djpowers 4978418 | datasette 107914493 | 2023-02-19T23:27:14Z |
8758839,107914493 | ClaudioCorridore 8758839 | datasette 107914493 | 2023-02-19T21:22:13Z |
13216097,107914493 | 50tu 13216097 | datasette 107914493 | 2023-02-19T06:07:36Z |
20387688,107914493 | wlib 20387688 | datasette 107914493 | 2023-02-19T02:24:51Z |
43533426,107914493 | tnychn 43533426 | datasette 107914493 | 2023-02-19T14:40:15Z |
124468992,107914493 | mortezaghaemi 124468992 | datasette 107914493 | 2023-02-19T23:18:12Z |
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]);