stars
9 rows where repo = 107914493 and "starred_at" is on date 2021-08-30
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
45906,107914493 | benjixx 45906 | datasette 107914493 | 2021-08-30T07:07:58Z |
66427,107914493 | mattreduce 66427 | datasette 107914493 | 2021-08-30T07:55:55Z |
73650,107914493 | mickume 73650 | datasette 107914493 | 2021-08-30T14:56:07Z |
3075069,107914493 | marco-m 3075069 | datasette 107914493 | 2021-08-30T06:04:32Z |
3711942,107914493 | jeongkyu 3711942 | datasette 107914493 | 2021-08-30T18:28:25Z |
10997042,107914493 | fabienbernard 10997042 | datasette 107914493 | 2021-08-30T07:13:54Z |
12959423,107914493 | josemolinag 12959423 | datasette 107914493 | 2021-08-30T08:30:36Z |
28663259,107914493 | laughlinbrian 28663259 | datasette 107914493 | 2021-08-30T12:54:40Z |
28726747,107914493 | long1208 28726747 | datasette 107914493 | 2021-08-30T06:50:54Z |
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]);