stars
11 rows where repo = 140912432 and "starred_at" is on date 2022-05-16 sorted by repo
This data as json, CSV (advanced)
Link | user | repo ▼ | starred_at |
---|---|---|---|
61048,140912432 | gcollazo 61048 | sqlite-utils 140912432 | 2022-05-16T00:11:02Z |
802786,140912432 | mgrandi 802786 | sqlite-utils 140912432 | 2022-05-16T03:37:03Z |
768611,140912432 | msimav 768611 | sqlite-utils 140912432 | 2022-05-16T07:12:54Z |
8730704,140912432 | ambitioussong 8730704 | sqlite-utils 140912432 | 2022-05-16T07:18:34Z |
1724279,140912432 | atoko 1724279 | sqlite-utils 140912432 | 2022-05-16T10:12:04Z |
965804,140912432 | baybatu 965804 | sqlite-utils 140912432 | 2022-05-16T13:39:40Z |
712551,140912432 | Aralnoth 712551 | sqlite-utils 140912432 | 2022-05-16T16:00:05Z |
2133,140912432 | danhorst 2133 | sqlite-utils 140912432 | 2022-05-16T17:12:00Z |
52753034,140912432 | charliefortner 52753034 | sqlite-utils 140912432 | 2022-05-16T20:27:01Z |
5902731,140912432 | rickybassom 5902731 | sqlite-utils 140912432 | 2022-05-16T20:50:44Z |
11781043,140912432 | LakeFlake 11781043 | sqlite-utils 140912432 | 2022-05-16T23:31:28Z |
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]);