stars
7 rows where "starred_at" is on date 2020-07-30
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
20485,107914493 | jtinsky 20485 | datasette 107914493 | 2020-07-30T17:15:31Z |
651095,107914493 | jgorecki-zz 651095 | datasette 107914493 | 2020-07-30T15:35:15Z |
3069493,107914493 | hkjang 3069493 | datasette 107914493 | 2020-07-30T12:33:48Z |
5590534,107914493 | matthewbegun 5590534 | datasette 107914493 | 2020-07-30T04:22:50Z |
7269717,107914493 | boan-anbo 7269717 | datasette 107914493 | 2020-07-30T13:51:11Z |
7476523,107914493 | bobwhitelock 7476523 | datasette 107914493 | 2020-07-30T11:17:34Z |
60454206,107914493 | ychoi-atop 60454206 | datasette 107914493 | 2020-07-30T03:53:25Z |
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]);