stars
13 rows where "starred_at" is on date 2023-04-12 sorted by user
This data as json, CSV (advanced)
Link | user ▼ | repo | starred_at |
---|---|---|---|
484824,107914493 | avinash2 484824 | datasette 107914493 | 2023-04-12T15:25:04Z |
1809086,107914493 | mnsrulz 1809086 | datasette 107914493 | 2023-04-12T19:50:31Z |
1886550,107914493 | toSvenson 1886550 | datasette 107914493 | 2023-04-12T05:36:23Z |
4267202,107914493 | ClemDoum 4267202 | datasette 107914493 | 2023-04-12T07:38:12Z |
5407422,107914493 | ceylanb 5407422 | datasette 107914493 | 2023-04-12T01:22:22Z |
7989047,107914493 | vpodolyan 7989047 | datasette 107914493 | 2023-04-12T09:39:20Z |
9270494,107914493 | arpadgabor 9270494 | datasette 107914493 | 2023-04-12T20:26:06Z |
16408477,107914493 | louyongjiu 16408477 | datasette 107914493 | 2023-04-12T04:24:34Z |
22381129,107914493 | mauryaland 22381129 | datasette 107914493 | 2023-04-12T20:13:59Z |
25609742,107914493 | mj-will 25609742 | datasette 107914493 | 2023-04-12T19:13:34Z |
31341013,107914493 | sanamhub 31341013 | datasette 107914493 | 2023-04-12T18:13:30Z |
42179768,107914493 | constantinPilsl 42179768 | datasette 107914493 | 2023-04-12T08:39:43Z |
66202856,107914493 | ACvanWyk 66202856 | datasette 107914493 | 2023-04-12T20:56:13Z |
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]);