stars
11 rows where repo = 107914493 and "starred_at" is on date 2023-02-07
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
152196,107914493 | mozey 152196 | datasette 107914493 | 2023-02-07T11:07:17Z |
712433,107914493 | hcoona 712433 | datasette 107914493 | 2023-02-07T12:02:58Z |
796136,107914493 | wolfy-j 796136 | datasette 107914493 | 2023-02-07T15:09:35Z |
1834241,107914493 | swayson 1834241 | datasette 107914493 | 2023-02-07T09:52:58Z |
3760421,107914493 | sekmet 3760421 | datasette 107914493 | 2023-02-07T16:53:34Z |
5640055,107914493 | danbarbarito 5640055 | datasette 107914493 | 2023-02-07T21:00:13Z |
9302265,107914493 | priyanshujain 9302265 | datasette 107914493 | 2023-02-07T09:09:27Z |
16711114,107914493 | anders-s 16711114 | datasette 107914493 | 2023-02-07T20:41:29Z |
31892049,107914493 | romadhonafajar 31892049 | datasette 107914493 | 2023-02-07T17:23:55Z |
61423497,107914493 | plexx-dev 61423497 | datasette 107914493 | 2023-02-07T19:41:01Z |
83613964,107914493 | cdonahue-chartis 83613964 | datasette 107914493 | 2023-02-07T19:34:53Z |
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]);