stars
10 rows where "starred_at" is on date 2023-04-30 sorted by user
This data as json, CSV (advanced)
Link | user ▼ | repo | starred_at |
---|---|---|---|
499566,107914493 | cagev 499566 | datasette 107914493 | 2023-04-30T13:31:20Z |
8627333,107914493 | nick-st 8627333 | datasette 107914493 | 2023-04-30T10:15:55Z |
11053299,107914493 | metinsenturk 11053299 | datasette 107914493 | 2023-04-30T21:27:03Z |
15886616,107914493 | longshines 15886616 | datasette 107914493 | 2023-04-30T13:33:36Z |
15907728,107914493 | shkey 15907728 | datasette 107914493 | 2023-04-30T05:56:45Z |
46263469,107914493 | antRainZ 46263469 | datasette 107914493 | 2023-04-30T08:41:57Z |
53047899,107914493 | RoyMikeJiang 53047899 | datasette 107914493 | 2023-04-30T00:24:44Z |
57161638,107914493 | jmnickerson05 57161638 | datasette 107914493 | 2023-04-30T12:43:37Z |
71040609,107914493 | wathika-eng 71040609 | datasette 107914493 | 2023-04-30T20:14:37Z |
88579893,107914493 | aaronzgh 88579893 | datasette 107914493 | 2023-04-30T08:07:18Z |
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]);