stars
9 rows where "starred_at" is on date 2019-08-23
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
14547,107914493 | nogweii 14547 | datasette 107914493 | 2019-08-23T07:00:26Z |
359477,107914493 | oscarcarlsson 359477 | datasette 107914493 | 2019-08-23T08:20:23Z |
1013448,107914493 | bradhughes 1013448 | datasette 107914493 | 2019-08-23T18:59:16Z |
1409782,107914493 | qazwsxpawel 1409782 | datasette 107914493 | 2019-08-23T12:30:33Z |
3527248,107914493 | kelbyludwig 3527248 | datasette 107914493 | 2019-08-23T23:46:35Z |
5688923,107914493 | lwakefield 5688923 | datasette 107914493 | 2019-08-23T11:10:05Z |
7285799,107914493 | zmaas 7285799 | datasette 107914493 | 2019-08-23T02:48:43Z |
9583775,107914493 | ghishadow 9583775 | datasette 107914493 | 2019-08-23T02:15:37Z |
23507721,107914493 | ngeraci 23507721 | datasette 107914493 | 2019-08-23T19:51:22Z |
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]);