stars
7 rows where repo = 107914493 and "starred_at" is on date 2021-04-05
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
1286818,107914493 | crudbug 1286818 | datasette 107914493 | 2021-04-05T22:53:52Z |
1413457,107914493 | fsodogandji 1413457 | datasette 107914493 | 2021-04-05T20:28:54Z |
1636597,107914493 | mralbu 1636597 | datasette 107914493 | 2021-04-05T20:52:26Z |
16197489,107914493 | cowen314 16197489 | datasette 107914493 | 2021-04-05T04:40:55Z |
19581621,107914493 | fahmifan 19581621 | datasette 107914493 | 2021-04-05T23:03:55Z |
27863547,107914493 | daanklijn 27863547 | datasette 107914493 | 2021-04-05T15:09:35Z |
41791983,107914493 | Kalebu 41791983 | datasette 107914493 | 2021-04-05T06:14:23Z |
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]);