stars
12 rows where "starred_at" is on date 2023-02-19 sorted by user
This data as json, CSV (advanced)
Link | user ▼ | repo | starred_at |
---|---|---|---|
833720,107914493 | nilsbunger 833720 | datasette 107914493 | 2023-02-19T17:31:14Z |
1730702,107914493 | mquandalle 1730702 | datasette 107914493 | 2023-02-19T00:24:58Z |
4615889,107914493 | Techcable 4615889 | datasette 107914493 | 2023-02-19T20:29:35Z |
4978418,107914493 | djpowers 4978418 | datasette 107914493 | 2023-02-19T23:27:14Z |
8758839,107914493 | ClaudioCorridore 8758839 | datasette 107914493 | 2023-02-19T21:22:13Z |
13216097,107914493 | 50tu 13216097 | datasette 107914493 | 2023-02-19T06:07:36Z |
20387688,107914493 | wlib 20387688 | datasette 107914493 | 2023-02-19T02:24:51Z |
43533426,107914493 | tnychn 43533426 | datasette 107914493 | 2023-02-19T14:40:15Z |
65138622,206156866 | chozahell 65138622 | twitter-to-sqlite 206156866 | 2023-02-19T09:11:56Z |
104471537,140912432 | flumpus-dev 104471537 | sqlite-utils 140912432 | 2023-02-19T23:39:15Z |
104471537,207052882 | flumpus-dev 104471537 | github-to-sqlite 207052882 | 2023-02-19T23:39:23Z |
124468992,107914493 | mortezaghaemi 124468992 | datasette 107914493 | 2023-02-19T23:18:12Z |
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]);