stars
10 rows where "starred_at" is on date 2022-11-17 sorted by user descending
This data as json, CSV (advanced)
Suggested facets: user
repo 3 ✖
Link | user ▲ | repo | starred_at |
---|---|---|---|
34368999,107914493 | SSwser 34368999 | datasette 107914493 | 2022-11-17T03:50:36Z |
10437179,107914493 | christophbalzer 10437179 | datasette 107914493 | 2022-11-17T21:45:30Z |
2943895,107914493 | choudhary 2943895 | datasette 107914493 | 2022-11-17T20:00:39Z |
1349906,107914493 | adamzimmermann 1349906 | datasette 107914493 | 2022-11-17T03:04:57Z |
1026584,197431109 | zph 1026584 | dogsheep-beta 197431109 | 2022-11-17T18:08:31Z |
938915,107914493 | sedatkaplan 938915 | datasette 107914493 | 2022-11-17T14:07:23Z |
876947,140912432 | JnyJny 876947 | sqlite-utils 140912432 | 2022-11-17T00:16:44Z |
876947,107914493 | JnyJny 876947 | datasette 107914493 | 2022-11-17T00:15:13Z |
442798,107914493 | zhangwm404 442798 | datasette 107914493 | 2022-11-17T23:57:19Z |
419145,107914493 | rdmurphy 419145 | datasette 107914493 | 2022-11-17T02:27:21Z |
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]);