stars
7 rows where repo = 107914493 and "starred_at" is on date 2020-03-03 sorted by user
This data as json, CSV (advanced)
Link | user ▼ | repo | starred_at |
---|---|---|---|
230232,107914493 | victoriano 230232 | datasette 107914493 | 2020-03-03T09:47:58Z |
895720,107914493 | ivanprado 895720 | datasette 107914493 | 2020-03-03T18:19:45Z |
1192339,107914493 | edubxb 1192339 | datasette 107914493 | 2020-03-03T22:49:40Z |
3304507,107914493 | Morantron 3304507 | datasette 107914493 | 2020-03-03T10:02:28Z |
16630989,107914493 | honggui 16630989 | datasette 107914493 | 2020-03-03T14:18:24Z |
31397412,107914493 | sanchitnis 31397412 | datasette 107914493 | 2020-03-03T03:58:07Z |
53604264,107914493 | flexibleplaces 53604264 | datasette 107914493 | 2020-03-03T10:41:15Z |
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]);