stars
9 rows where "starred_at" is on date 2022-05-31 sorted by user descending
This data as json, CSV (advanced)
Suggested facets: repo
Link | user ▲ | repo | starred_at |
---|---|---|---|
67177269,140912432 | dhruvmanila 67177269 | sqlite-utils 140912432 | 2022-05-31T02:54:57Z |
26646386,107914493 | twodonkeys 26646386 | datasette 107914493 | 2022-05-31T01:18:46Z |
15080806,107914493 | mcauto 15080806 | datasette 107914493 | 2022-05-31T02:03:50Z |
7479412,107914493 | tsangrex 7479412 | datasette 107914493 | 2022-05-31T10:19:26Z |
4822597,107914493 | sverweij 4822597 | datasette 107914493 | 2022-05-31T19:06:13Z |
3985697,107914493 | fallrising 3985697 | datasette 107914493 | 2022-05-31T12:15:15Z |
2021567,107914493 | darrylng 2021567 | datasette 107914493 | 2022-05-31T14:45:57Z |
1879571,107914493 | JulianLiu 1879571 | datasette 107914493 | 2022-05-31T08:06:56Z |
794388,140912432 | gr7ffo 794388 | sqlite-utils 140912432 | 2022-05-31T11:15:37Z |
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]);