stars
12 rows where repo = 107914493 and "starred_at" is on date 2020-05-08 sorted by repo
This data as json, CSV (advanced)
Link | user | repo ▼ | starred_at |
---|---|---|---|
10921676,107914493 | sikasjc 10921676 | datasette 107914493 | 2020-05-08T03:02:25Z |
3280204,107914493 | ycrao 3280204 | datasette 107914493 | 2020-05-08T06:42:30Z |
7335567,107914493 | qbmiller 7335567 | datasette 107914493 | 2020-05-08T09:11:15Z |
43341228,107914493 | meghatiku 43341228 | datasette 107914493 | 2020-05-08T13:54:39Z |
854991,107914493 | DonDebonair 854991 | datasette 107914493 | 2020-05-08T16:19:31Z |
1667388,107914493 | brianmcdonald 1667388 | datasette 107914493 | 2020-05-08T16:42:44Z |
86492,107914493 | danromero 86492 | datasette 107914493 | 2020-05-08T17:36:00Z |
2041398,107914493 | jiangplus 2041398 | datasette 107914493 | 2020-05-08T18:08:20Z |
1930631,107914493 | OneCricketeer 1930631 | datasette 107914493 | 2020-05-08T19:36:05Z |
445341,107914493 | fspadini 445341 | datasette 107914493 | 2020-05-08T20:03:19Z |
6299586,107914493 | rufb 6299586 | datasette 107914493 | 2020-05-08T22:04:16Z |
1280346,107914493 | jacopofar 1280346 | datasette 107914493 | 2020-05-08T23:12:35Z |
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]);