stars
7 rows where repo = 107914493 and "starred_at" is on date 2022-05-31
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
1879571,107914493 | JulianLiu 1879571 | datasette 107914493 | 2022-05-31T08:06:56Z |
2021567,107914493 | darrylng 2021567 | datasette 107914493 | 2022-05-31T14:45:57Z |
3985697,107914493 | fallrising 3985697 | datasette 107914493 | 2022-05-31T12:15:15Z |
4822597,107914493 | sverweij 4822597 | datasette 107914493 | 2022-05-31T19:06:13Z |
7479412,107914493 | tsangrex 7479412 | datasette 107914493 | 2022-05-31T10:19:26Z |
15080806,107914493 | mcauto 15080806 | datasette 107914493 | 2022-05-31T02:03:50Z |
26646386,107914493 | twodonkeys 26646386 | datasette 107914493 | 2022-05-31T01:18:46Z |
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]);