stars
13 rows where "starred_at" is on date 2023-07-09 sorted by user
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 |
1582652,107914493 | bukansaya 1582652 | datasette 107914493 | 2023-07-09T06:18:25Z |
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 |
6568955,107914493 | dbeley 6568955 | datasette 107914493 | 2023-07-09T01:07:19Z |
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 |
37644685,140912432 | 15532 37644685 | sqlite-utils 140912432 | 2023-07-09T12:21:59Z |
54499510,611552758 | getjake 54499510 | apple-notes-to-sqlite 611552758 | 2023-07-09T22:56:05Z |
55829277,107914493 | ykz0608 55829277 | datasette 107914493 | 2023-07-09T05:19:57Z |
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]);