stars
14 rows where "starred_at" is on date 2022-08-31
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
333073,107914493 | jide 333073 | datasette 107914493 | 2022-08-31T22:34:02Z |
621054,107914493 | rebot 621054 | datasette 107914493 | 2022-08-31T14:26:14Z |
999336,107914493 | luoq 999336 | datasette 107914493 | 2022-08-31T00:40:52Z |
3185290,248903544 | crishnakh 3185290 | hacker-news-to-sqlite 248903544 | 2022-08-31T20:18:52Z |
4258713,107914493 | ekuiter 4258713 | datasette 107914493 | 2022-08-31T17:44:32Z |
5471162,140912432 | girip11 5471162 | sqlite-utils 140912432 | 2022-08-31T15:55:32Z |
6959765,107914493 | mwbyeon 6959765 | datasette 107914493 | 2022-08-31T15:08:07Z |
8560683,107914493 | ddervs 8560683 | datasette 107914493 | 2022-08-31T10:49:18Z |
17963229,140912432 | nclv 17963229 | sqlite-utils 140912432 | 2022-08-31T22:51:43Z |
17963229,207052882 | nclv 17963229 | github-to-sqlite 207052882 | 2022-08-31T22:59:46Z |
27709025,197431109 | themaxdavitt 27709025 | dogsheep-beta 197431109 | 2022-08-31T01:13:07Z |
32404415,107914493 | miwojc 32404415 | datasette 107914493 | 2022-08-31T04:58:13Z |
109500550,197882382 | xmas7 109500550 | healthkit-to-sqlite 197882382 | 2022-08-31T03:13:12Z |
109500550,256834907 | xmas7 109500550 | dogsheep-photos 256834907 | 2022-08-31T03:13:10Z |
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]);