stars
9 rows where repo = 107914493 and "starred_at" is on date 2022-04-05
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
4256,107914493 | cobuso 4256 | datasette 107914493 | 2022-04-05T10:27:06Z |
15691,107914493 | streaps 15691 | datasette 107914493 | 2022-04-05T08:32:46Z |
70572,107914493 | alykhan 70572 | datasette 107914493 | 2022-04-05T10:07:07Z |
827793,107914493 | mofosyne 827793 | datasette 107914493 | 2022-04-05T11:10:04Z |
5794444,107914493 | tiger360 5794444 | datasette 107914493 | 2022-04-05T04:11:25Z |
10188264,107914493 | mapsgeek 10188264 | datasette 107914493 | 2022-04-05T06:36:56Z |
20721797,107914493 | zerosym 20721797 | datasette 107914493 | 2022-04-05T13:18:53Z |
25097587,107914493 | stevelizcano 25097587 | datasette 107914493 | 2022-04-05T04:34:06Z |
89194947,107914493 | ratul-cefalo 89194947 | datasette 107914493 | 2022-04-05T10:11:50Z |
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]);