stars
6 rows where repo = 107914493 and "starred_at" is on date 2021-08-25
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
30934,107914493 | 20after4 30934 | datasette 107914493 | 2021-08-25T04:42:32Z |
86240,107914493 | aleks 86240 | datasette 107914493 | 2021-08-25T20:30:08Z |
4366956,107914493 | baychimo 4366956 | datasette 107914493 | 2021-08-25T19:42:43Z |
7081992,107914493 | achandran 7081992 | datasette 107914493 | 2021-08-25T09:25:10Z |
13529535,107914493 | lukethacoder 13529535 | datasette 107914493 | 2021-08-25T03:28:21Z |
16377166,107914493 | xiaohao0576 16377166 | datasette 107914493 | 2021-08-25T01:23: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]);