stars
16 rows where "starred_at" is on date 2023-05-04 sorted by user
This data as json, CSV (advanced)
Link | user ▼ | repo | starred_at |
---|---|---|---|
1548795,107914493 | johnnychtlac 1548795 | datasette 107914493 | 2023-05-04T01:10:59Z |
2399123,107914493 | imyelo 2399123 | datasette 107914493 | 2023-05-04T03:37:06Z |
6634872,107914493 | jackhuntcn 6634872 | datasette 107914493 | 2023-05-04T03:58:04Z |
6814731,107914493 | yanglichuan 6814731 | datasette 107914493 | 2023-05-04T03:30:19Z |
9546437,107914493 | surprise3465 9546437 | datasette 107914493 | 2023-05-04T09:25:39Z |
12424061,107914493 | vzjl 12424061 | datasette 107914493 | 2023-05-04T09:15:58Z |
13618006,107914493 | CJDong 13618006 | datasette 107914493 | 2023-05-04T08:31:20Z |
14256545,107914493 | zhaopei8948 14256545 | datasette 107914493 | 2023-05-04T07:55:47Z |
14961633,107914493 | smashell 14961633 | datasette 107914493 | 2023-05-04T10:26:14Z |
15954640,107914493 | Ieuanyoung 15954640 | datasette 107914493 | 2023-05-04T06:08:43Z |
17877309,107914493 | HiddenSnail 17877309 | datasette 107914493 | 2023-05-04T08:02:56Z |
22088957,107914493 | ShaldonHe 22088957 | datasette 107914493 | 2023-05-04T01:41:49Z |
28683383,107914493 | LqNoob 28683383 | datasette 107914493 | 2023-05-04T03:29:44Z |
42488522,107914493 | XhFu96 42488522 | datasette 107914493 | 2023-05-04T02:22:11Z |
69758022,107914493 | tuanductran 69758022 | datasette 107914493 | 2023-05-04T12:02:44Z |
73209903,107914493 | jihan-socool 73209903 | datasette 107914493 | 2023-05-04T03:10:44Z |
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]);