stars
14 rows where "starred_at" is on date 2020-11-20
This data as json, CSV (advanced)
repo 4 ✖
Link | user | repo | starred_at |
---|---|---|---|
21751,214746582 | jjudge 21751 | dogsheep.github.io 214746582 | 2020-11-20T12:59:57Z |
107030,107914493 | eby 107030 | datasette 107914493 | 2020-11-20T15:05:48Z |
107030,214746582 | eby 107030 | dogsheep.github.io 214746582 | 2020-11-20T15:06:16Z |
205317,107914493 | andreyz 205317 | datasette 107914493 | 2020-11-20T17:07:19Z |
1239752,107914493 | vjo 1239752 | datasette 107914493 | 2020-11-20T12:29:58Z |
1239752,205429375 | vjo 1239752 | swarm-to-sqlite 205429375 | 2020-11-20T12:25:19Z |
1319404,107914493 | akehrer 1319404 | datasette 107914493 | 2020-11-20T17:46:03Z |
8393979,107914493 | T017 8393979 | datasette 107914493 | 2020-11-20T01:57:16Z |
17869861,107914493 | jjsantos01 17869861 | datasette 107914493 | 2020-11-20T22:27:47Z |
18268101,107914493 | chiragkolani 18268101 | datasette 107914493 | 2020-11-20T12:37:47Z |
18268101,197431109 | chiragkolani 18268101 | dogsheep-beta 197431109 | 2020-11-20T12:38:03Z |
20607201,107914493 | wrathofquan 20607201 | datasette 107914493 | 2020-11-20T21:50:07Z |
45250053,107914493 | lucasmiranda42 45250053 | datasette 107914493 | 2020-11-20T23:50:46Z |
61557282,107914493 | jonnywrightscode 61557282 | datasette 107914493 | 2020-11-20T14:09:53Z |
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]);