stars
13 rows where "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 |
1191606,140912432 | laysent 1191606 | sqlite-utils 140912432 | 2022-04-05T03:29:37Z |
5794444,107914493 | tiger360 5794444 | datasette 107914493 | 2022-04-05T04:11:25Z |
5794444,140912432 | tiger360 5794444 | sqlite-utils 140912432 | 2022-04-05T04:34:10Z |
10188264,107914493 | mapsgeek 10188264 | datasette 107914493 | 2022-04-05T06:36:56Z |
20721797,107914493 | zerosym 20721797 | datasette 107914493 | 2022-04-05T13:18:53Z |
22422950,140912432 | notylou 22422950 | sqlite-utils 140912432 | 2022-04-05T04:27:02Z |
25097587,107914493 | stevelizcano 25097587 | datasette 107914493 | 2022-04-05T04:34:06Z |
41028971,140912432 | peppapigs 41028971 | sqlite-utils 140912432 | 2022-04-05T05:48:03Z |
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]);