stars
14 rows where "starred_at" is on date 2022-05-16
This data as json, CSV (advanced)
Suggested facets: repo, starred_at (date)
Link | user | repo | starred_at |
---|---|---|---|
2133,140912432 | danhorst 2133 | sqlite-utils 140912432 | 2022-05-16T17:12:00Z |
61048,140912432 | gcollazo 61048 | sqlite-utils 140912432 | 2022-05-16T00:11:02Z |
120362,207052882 | jrhizor 120362 | github-to-sqlite 207052882 | 2022-05-16T17:26:59Z |
712551,140912432 | Aralnoth 712551 | sqlite-utils 140912432 | 2022-05-16T16:00:05Z |
768611,140912432 | msimav 768611 | sqlite-utils 140912432 | 2022-05-16T07:12:54Z |
802786,140912432 | mgrandi 802786 | sqlite-utils 140912432 | 2022-05-16T03:37:03Z |
965804,140912432 | baybatu 965804 | sqlite-utils 140912432 | 2022-05-16T13:39:40Z |
1724279,140912432 | atoko 1724279 | sqlite-utils 140912432 | 2022-05-16T10:12:04Z |
2192641,107914493 | sametheridge 2192641 | datasette 107914493 | 2022-05-16T11:53:52Z |
5902731,140912432 | rickybassom 5902731 | sqlite-utils 140912432 | 2022-05-16T20:50:44Z |
8730704,140912432 | ambitioussong 8730704 | sqlite-utils 140912432 | 2022-05-16T07:18:34Z |
10896673,107914493 | pazacharis 10896673 | datasette 107914493 | 2022-05-16T20:49:07Z |
11781043,140912432 | LakeFlake 11781043 | sqlite-utils 140912432 | 2022-05-16T23:31:28Z |
52753034,140912432 | charliefortner 52753034 | sqlite-utils 140912432 | 2022-05-16T20:27:01Z |
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]);