stars
11 rows where "starred_at" is on date 2023-01-25
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
290596,107914493 | eval 290596 | datasette 107914493 | 2023-01-25T15:49:57Z |
380000,140912432 | AoJ 380000 | sqlite-utils 140912432 | 2023-01-25T23:56:48Z |
380000,197431109 | AoJ 380000 | dogsheep-beta 197431109 | 2023-01-25T23:59:52Z |
2090495,107914493 | gmolveau 2090495 | datasette 107914493 | 2023-01-25T12:25:07Z |
2697536,107914493 | Atrion 2697536 | datasette 107914493 | 2023-01-25T02:21:54Z |
5324956,107914493 | followingell 5324956 | datasette 107914493 | 2023-01-25T14:37:26Z |
5399780,107914493 | eregnier 5399780 | datasette 107914493 | 2023-01-25T20:14:43Z |
8788860,107914493 | al-ramadhan 8788860 | datasette 107914493 | 2023-01-25T01:45:11Z |
11389761,107914493 | anilprasad 11389761 | datasette 107914493 | 2023-01-25T09:57:45Z |
96209093,107914493 | mojoba 96209093 | datasette 107914493 | 2023-01-25T03:42:10Z |
103542461,140912432 | mappflow 103542461 | sqlite-utils 140912432 | 2023-01-25T16:27:54Z |
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]);