stars
8 rows where "starred_at" is on date 2023-06-19
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
3373830,107914493 | benjamin-kirkbride 3373830 | datasette 107914493 | 2023-06-19T15:53:47Z |
11182185,107914493 | salamer 11182185 | datasette 107914493 | 2023-06-19T08:40:01Z |
15189408,107914493 | dan-carroll 15189408 | datasette 107914493 | 2023-06-19T08:10:53Z |
17715468,107914493 | 92000 17715468 | datasette 107914493 | 2023-06-19T08:09:13Z |
39752045,107914493 | xiqiliuse 39752045 | datasette 107914493 | 2023-06-19T04:49:32Z |
49828783,107914493 | liuwwang 49828783 | datasette 107914493 | 2023-06-19T02:40:17Z |
84087968,107914493 | spamhater-grav 84087968 | datasette 107914493 | 2023-06-19T00:40:07Z |
119676372,107914493 | jean-jimbo-sonarsource 119676372 | datasette 107914493 | 2023-06-19T17:01: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]);