stars
4 rows where repo = 107914493 and "starred_at" is on date 2023-03-29
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
208462,107914493 | mattblubaugh 208462 | datasette 107914493 | 2023-03-29T01:22:46Z |
9072473,107914493 | khvedzeli 9072473 | datasette 107914493 | 2023-03-29T19:50:44Z |
35005637,107914493 | 2214962083 35005637 | datasette 107914493 | 2023-03-29T17:03:01Z |
125396476,107914493 | tyson-dowd 125396476 | datasette 107914493 | 2023-03-29T12:48:33Z |
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]);