stars
13 rows where repo = 107914493 and "starred_at" is on date 2017-11-23
This data as json, CSV (advanced)
Suggested facets: starred_at (date)
Link | user | repo | starred_at |
---|---|---|---|
57228,107914493 | pvergain 57228 | datasette 107914493 | 2017-11-23T11:55:01Z |
387669,107914493 | j-e-d 387669 | datasette 107914493 | 2017-11-23T21:02:08Z |
535829,107914493 | alexras 535829 | datasette 107914493 | 2017-11-23T21:45:07Z |
645877,107914493 | reams 645877 | datasette 107914493 | 2017-11-23T19:27:22Z |
942068,107914493 | AdeleD 942068 | datasette 107914493 | 2017-11-23T18:18:11Z |
1639127,107914493 | shahriar1 1639127 | datasette 107914493 | 2017-11-23T07:38:43Z |
5020172,107914493 | jaffwu 5020172 | datasette 107914493 | 2017-11-23T01:05:33Z |
5713464,107914493 | jberentsson 5713464 | datasette 107914493 | 2017-11-23T01:00:31Z |
6325555,107914493 | blavoie 6325555 | datasette 107914493 | 2017-11-23T18:23:59Z |
7448443,107914493 | josejibin 7448443 | datasette 107914493 | 2017-11-23T04:30:34Z |
12259519,107914493 | bear256 12259519 | datasette 107914493 | 2017-11-23T02:52:39Z |
12944430,107914493 | peter-sharp 12944430 | datasette 107914493 | 2017-11-23T07:15:49Z |
21187751,107914493 | mavx 21187751 | datasette 107914493 | 2017-11-23T00:25:41Z |
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]);