stars
10 rows where repo = 107914493 and "starred_at" is on date 2021-01-20
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
58662,107914493 | amitu 58662 | datasette 107914493 | 2021-01-20T10:57:29Z |
150135,107914493 | bnadland 150135 | datasette 107914493 | 2021-01-20T13:22:41Z |
3671624,107914493 | jonesberg 3671624 | datasette 107914493 | 2021-01-20T14:27:35Z |
4434603,107914493 | Baoqi 4434603 | datasette 107914493 | 2021-01-20T15:59:48Z |
5052636,107914493 | ixcviw7bw 5052636 | datasette 107914493 | 2021-01-20T19:49:28Z |
7883396,107914493 | jamwine 7883396 | datasette 107914493 | 2021-01-20T21:31:35Z |
17103888,107914493 | TheAndrewJackson 17103888 | datasette 107914493 | 2021-01-20T14:30:12Z |
19284077,107914493 | AnttiHaerkoenen 19284077 | datasette 107914493 | 2021-01-20T10:36:15Z |
23000671,107914493 | noufalsalim 23000671 | datasette 107914493 | 2021-01-20T05:07:35Z |
57777521,107914493 | ConradSollitt 57777521 | datasette 107914493 | 2021-01-20T23:08:05Z |
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]);