stars
8 rows where repo = 213286752 and "starred_at" is on date 2023-07-09
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
566106,213286752 | davidag 566106 | pocket-to-sqlite 213286752 | 2023-07-09T11:29:43Z |
872730,213286752 | krzysztofjeziorny 872730 | pocket-to-sqlite 213286752 | 2023-07-09T13:32:30Z |
1511229,213286752 | ityogi 1511229 | pocket-to-sqlite 213286752 | 2023-07-09T06:01:34Z |
1578674,213286752 | teonbrooks 1578674 | pocket-to-sqlite 213286752 | 2023-07-09T11:51:26Z |
2817092,213286752 | ar-nelson 2817092 | pocket-to-sqlite 213286752 | 2023-07-09T03:45:55Z |
4171730,213286752 | menegazzi 4171730 | pocket-to-sqlite 213286752 | 2023-07-09T02:29:29Z |
11855322,213286752 | robmarkcole 11855322 | pocket-to-sqlite 213286752 | 2023-07-09T07:18:02Z |
20791518,213286752 | ashutosh1206 20791518 | pocket-to-sqlite 213286752 | 2023-07-09T05:36:26Z |
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]);