stars
8 rows where repo = 107914493 and "starred_at" is on date 2017-11-30
This data as json, CSV (advanced)
Suggested facets: starred_at (date)
Link | user | repo | starred_at |
---|---|---|---|
45195,107914493 | rtanglao 45195 | datasette 107914493 | 2017-11-30T00:46:24Z |
224488,107914493 | paracycle 224488 | datasette 107914493 | 2017-11-30T01:48:48Z |
597887,107914493 | joshdance 597887 | datasette 107914493 | 2017-11-30T07:08:50Z |
608191,107914493 | brendanmurty 608191 | datasette 107914493 | 2017-11-30T03:48:07Z |
1007667,107914493 | R-K-H 1007667 | datasette 107914493 | 2017-11-30T11:38:03Z |
5445746,107914493 | cavb 5445746 | datasette 107914493 | 2017-11-30T17:45:23Z |
8047551,107914493 | edverillo 8047551 | datasette 107914493 | 2017-11-30T20:21:41Z |
10926503,107914493 | coetry 10926503 | datasette 107914493 | 2017-11-30T01:33:05Z |
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]);