stars
17 rows where "starred_at" is on date 2019-12-20 sorted by repo
This data as json, CSV (advanced)
Suggested facets: repo
user 11 ✖
- ocdtrekkie 4
- ccope 3
- fire 2
- johnnypea 1
- nkantar 1
- csavelief 1
- jehb 1
- bleuarg 1
- sdeancos 1
- Maddosaurus 1
- corigrohman 1
Link | user | repo ▼ | starred_at |
---|---|---|---|
870947,107914493 | csavelief 870947 | datasette 107914493 | 2019-12-20T09:13:15Z |
1820476,107914493 | sdeancos 1820476 | datasette 107914493 | 2019-12-20T15:10:12Z |
57373570,107914493 | corigrohman 57373570 | datasette 107914493 | 2019-12-20T15:16:10Z |
32321,107914493 | fire 32321 | datasette 107914493 | 2019-12-20T19:54:18Z |
4399499,107914493 | ocdtrekkie 4399499 | datasette 107914493 | 2019-12-20T22:27:26Z |
568543,107914493 | nkantar 568543 | datasette 107914493 | 2019-12-20T22:50:33Z |
169748,107914493 | johnnypea 169748 | datasette 107914493 | 2019-12-20T23:04:30Z |
412019,107914493 | ccope 412019 | datasette 107914493 | 2019-12-20T23:51:49Z |
412019,205429375 | ccope 412019 | swarm-to-sqlite 205429375 | 2019-12-20T23:36:23Z |
4399499,206156866 | ocdtrekkie 4399499 | twitter-to-sqlite 206156866 | 2019-12-20T22:26:18Z |
4399499,206649770 | ocdtrekkie 4399499 | google-takeout-to-sqlite 206649770 | 2019-12-20T22:26:33Z |
412019,206649770 | ccope 412019 | google-takeout-to-sqlite 206649770 | 2019-12-20T23:36:31Z |
4399499,207052882 | ocdtrekkie 4399499 | github-to-sqlite 207052882 | 2019-12-20T22:26:15Z |
32321,214746582 | fire 32321 | dogsheep.github.io 214746582 | 2019-12-20T19:55:23Z |
1199635,214746582 | bleuarg 1199635 | dogsheep.github.io 214746582 | 2019-12-20T20:17:16Z |
1075305,214746582 | jehb 1075305 | dogsheep.github.io 214746582 | 2019-12-20T20:19:52Z |
8026915,214746582 | Maddosaurus 8026915 | dogsheep.github.io 214746582 | 2019-12-20T22:08:51Z |
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]);