stars
9 rows where "starred_at" is on date 2019-06-04 sorted by user
This data as json, CSV (advanced)
Link | user ▼ | repo | starred_at |
---|---|---|---|
16631,107914493 | p3k 16631 | datasette 107914493 | 2019-06-04T09:35:00Z |
150102,107914493 | emres 150102 | datasette 107914493 | 2019-06-04T14:25:43Z |
684965,107914493 | joehand 684965 | datasette 107914493 | 2019-06-04T21:19:01Z |
705860,107914493 | defvol 705860 | datasette 107914493 | 2019-06-04T02:36:05Z |
1008866,107914493 | netbek 1008866 | datasette 107914493 | 2019-06-04T04:46:34Z |
1560526,107914493 | mkuthan 1560526 | datasette 107914493 | 2019-06-04T09:31:36Z |
3394202,107914493 | agurtovoy 3394202 | datasette 107914493 | 2019-06-04T01:00:15Z |
34098595,107914493 | bherr2 34098595 | datasette 107914493 | 2019-06-04T18:15:50Z |
34513461,107914493 | karaninder 34513461 | datasette 107914493 | 2019-06-04T06:28:11Z |
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]);