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