stars
8 rows where "starred_at" is on date 2021-03-27
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
526598,206649770 | shouya 526598 | google-takeout-to-sqlite 206649770 | 2021-03-27T01:37:15Z |
1802656,107914493 | sunt05 1802656 | datasette 107914493 | 2021-03-27T11:25:14Z |
4341867,107914493 | olinguyen 4341867 | datasette 107914493 | 2021-03-27T16:55:01Z |
6348619,140912432 | kspeeckaert 6348619 | sqlite-utils 140912432 | 2021-03-27T12:34:37Z |
17132317,107914493 | JacksonMaxfield 17132317 | datasette 107914493 | 2021-03-27T00:02:29Z |
25130238,140912432 | Twopothead 25130238 | sqlite-utils 140912432 | 2021-03-27T11:51:53Z |
32606354,140912432 | steeltrap 32606354 | sqlite-utils 140912432 | 2021-03-27T16:50:47Z |
32606354,213286752 | steeltrap 32606354 | pocket-to-sqlite 213286752 | 2021-03-27T16:53:09Z |
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]);