stars
8 rows where "starred_at" is on date 2021-09-15 sorted by user
This data as json, CSV (advanced)
Suggested facets: starred_at (date)
repo 3 ✖
Link | user ▼ | repo | starred_at |
---|---|---|---|
563120,107914493 | shiyan31214 563120 | datasette 107914493 | 2021-09-15T12:16:09Z |
3963680,140912432 | zahariash 3963680 | sqlite-utils 140912432 | 2021-09-15T23:17:41Z |
5283352,107914493 | sd-omkar 5283352 | datasette 107914493 | 2021-09-15T05:47:09Z |
9288014,197431109 | m-aciek 9288014 | dogsheep-beta 197431109 | 2021-09-15T04:55:14Z |
18740659,107914493 | tomasfarias 18740659 | datasette 107914493 | 2021-09-15T07:48:03Z |
23205122,107914493 | IsaacPang 23205122 | datasette 107914493 | 2021-09-15T00:47:23Z |
52237913,107914493 | Redfire75369 52237913 | datasette 107914493 | 2021-09-15T15:59:19Z |
88512618,107914493 | PankajTaywade 88512618 | datasette 107914493 | 2021-09-15T08:05:07Z |
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]);