stars
82 rows where "starred_at" is on date 2023-04-28
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
48814916,107914493 | seconddayout 48814916 | datasette 107914493 | 2023-04-28T02:36:04Z |
49968061,107914493 | octokatherine 49968061 | datasette 107914493 | 2023-04-28T15:40:20Z |
50975539,107914493 | xuchun425dtyj 50975539 | datasette 107914493 | 2023-04-28T09:32:44Z |
51336003,107914493 | FingonCelebrindal 51336003 | datasette 107914493 | 2023-04-28T18:57:33Z |
51963680,107914493 | thompson0012 51963680 | datasette 107914493 | 2023-04-28T05:45:53Z |
55909886,107914493 | PlanarFox 55909886 | datasette 107914493 | 2023-04-28T04:39:25Z |
57092231,107914493 | pengqi 57092231 | datasette 107914493 | 2023-04-28T15:03:26Z |
57516881,107914493 | wwmogu 57516881 | datasette 107914493 | 2023-04-28T01:38:51Z |
58155247,107914493 | ZhReimu 58155247 | datasette 107914493 | 2023-04-28T00:44:47Z |
60435548,107914493 | aliothor 60435548 | datasette 107914493 | 2023-04-28T01:43:34Z |
61230541,107914493 | DouglasDyx 61230541 | datasette 107914493 | 2023-04-28T02:24:03Z |
66560900,107914493 | MikeYueng9911 66560900 | datasette 107914493 | 2023-04-28T00:52:12Z |
69497874,107914493 | WLaoDuo 69497874 | datasette 107914493 | 2023-04-28T01:44:06Z |
76872894,107914493 | sanf4520 76872894 | datasette 107914493 | 2023-04-28T03:08:05Z |
97818953,107914493 | Xunop 97818953 | datasette 107914493 | 2023-04-28T01:54:04Z |
99574027,107914493 | bestwater 99574027 | datasette 107914493 | 2023-04-28T00:46: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]);