stars
8 rows where user = 161718
This data as json, CSV (advanced)
Suggested facets: starred_at (date)
| Link | user | repo | starred_at |
|---|---|---|---|
| 161718,107914493 | jgmize 161718 | datasette 107914493 | 2017-12-06T07:27:44Z |
| 161718,140912432 | jgmize 161718 | sqlite-utils 140912432 | 2021-06-30T06:37:30Z |
| 161718,197431109 | jgmize 161718 | dogsheep-beta 197431109 | 2021-09-18T05:25:33Z |
| 161718,206156866 | jgmize 161718 | twitter-to-sqlite 206156866 | 2021-09-18T05:30:17Z |
| 161718,207052882 | jgmize 161718 | github-to-sqlite 207052882 | 2021-03-12T21:27:11Z |
| 161718,213286752 | jgmize 161718 | pocket-to-sqlite 213286752 | 2023-07-10T04:02:30Z |
| 161718,256834907 | jgmize 161718 | dogsheep-photos 256834907 | 2021-09-18T05:29:37Z |
| 161718,611552758 | jgmize 161718 | apple-notes-to-sqlite 611552758 | 2023-03-13T03:25: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]);