stars
16 rows where repo = 107914493 and "starred_at" is on date 2021-03-26
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
8654,107914493 | igungor 8654 | datasette 107914493 | 2021-03-26T06:29:14Z |
39916,107914493 | joeshaw 39916 | datasette 107914493 | 2021-03-26T16:46:25Z |
57199,107914493 | dwt 57199 | datasette 107914493 | 2021-03-26T20:32:41Z |
392251,107914493 | hessammehr 392251 | datasette 107914493 | 2021-03-26T08:59:31Z |
494686,107914493 | tpatel 494686 | datasette 107914493 | 2021-03-26T15:25:58Z |
569269,107914493 | darvid 569269 | datasette 107914493 | 2021-03-26T03:12:04Z |
663703,107914493 | kobyv 663703 | datasette 107914493 | 2021-03-26T12:52:07Z |
869862,107914493 | dmitrykoval 869862 | datasette 107914493 | 2021-03-26T07:03:09Z |
1821570,107914493 | voidpainter 1821570 | datasette 107914493 | 2021-03-26T08:26:46Z |
1922628,107914493 | hendrikcech 1922628 | datasette 107914493 | 2021-03-26T08:20:01Z |
3735758,107914493 | xyxu 3735758 | datasette 107914493 | 2021-03-26T06:16:37Z |
3768247,107914493 | iladin 3768247 | datasette 107914493 | 2021-03-26T15:40:28Z |
8696177,107914493 | parasdahal 8696177 | datasette 107914493 | 2021-03-26T03:46:00Z |
11516280,107914493 | vrajanap 11516280 | datasette 107914493 | 2021-03-26T00:12:11Z |
11666017,107914493 | 4M01 11666017 | datasette 107914493 | 2021-03-26T05:23:24Z |
13487305,107914493 | aavanian 13487305 | datasette 107914493 | 2021-03-26T03:46:57Z |
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]);