stars
16 rows where "starred_at" is on date 2020-12-19 sorted by user descending
This data as json, CSV (advanced)
Suggested facets: user
repo 2 ✖
- datasette 15
- dogsheep-photos 1
Link | user ▲ | repo | starred_at |
---|---|---|---|
64683513,107914493 | JamesAngus 64683513 | datasette 107914493 | 2020-12-19T08:54:11Z |
44065561,107914493 | darwin1224 44065561 | datasette 107914493 | 2020-12-19T01:29:05Z |
14998269,107914493 | jc628 14998269 | datasette 107914493 | 2020-12-19T16:19:51Z |
9330346,107914493 | rossiotti 9330346 | datasette 107914493 | 2020-12-19T14:07:08Z |
8573886,107914493 | nickvazz 8573886 | datasette 107914493 | 2020-12-19T03:30:14Z |
8573886,256834907 | nickvazz 8573886 | dogsheep-photos 256834907 | 2020-12-19T07:36:06Z |
6220504,107914493 | ucg8j 6220504 | datasette 107914493 | 2020-12-19T20:59:04Z |
5246078,107914493 | itski 5246078 | datasette 107914493 | 2020-12-19T17:15:39Z |
4941334,107914493 | epistrephein 4941334 | datasette 107914493 | 2020-12-19T20:54:44Z |
3855349,107914493 | rjusher 3855349 | datasette 107914493 | 2020-12-19T16:15:10Z |
3800219,107914493 | sevensixseven 3800219 | datasette 107914493 | 2020-12-19T17:52:15Z |
3473393,107914493 | kiliczsh 3473393 | datasette 107914493 | 2020-12-19T18:10:43Z |
1525500,107914493 | hardikudeshi 1525500 | datasette 107914493 | 2020-12-19T13:59:55Z |
1163840,107914493 | sandeepmistry 1163840 | datasette 107914493 | 2020-12-19T13:11:31Z |
330895,107914493 | imsky 330895 | datasette 107914493 | 2020-12-19T20:31:07Z |
67972,107914493 | jonDowdle 67972 | datasette 107914493 | 2020-12-19T13:28:46Z |
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]);