stars
11 rows where "starred_at" is on date 2019-11-08
This data as json, CSV (advanced)
Suggested facets: repo, starred_at (date)
Link | user | repo | starred_at |
---|---|---|---|
19387,107914493 | eman 19387 | datasette 107914493 | 2019-11-08T22:11:47Z |
329591,107914493 | wesm 329591 | datasette 107914493 | 2019-11-08T21:02:13Z |
365396,107914493 | fredmonroe 365396 | datasette 107914493 | 2019-11-08T21:41:04Z |
425059,206156866 | pringshia 425059 | twitter-to-sqlite 206156866 | 2019-11-08T01:27:48Z |
905704,107914493 | jentjr 905704 | datasette 107914493 | 2019-11-08T22:19:00Z |
1412716,107914493 | thiagoalmeidasa 1412716 | datasette 107914493 | 2019-11-08T22:37:02Z |
1862455,107914493 | unknownv2 1862455 | datasette 107914493 | 2019-11-08T21:20:53Z |
2475547,107914493 | GISDev01 2475547 | datasette 107914493 | 2019-11-08T21:53:17Z |
5837841,107914493 | bc-maia 5837841 | datasette 107914493 | 2019-11-08T19:21:55Z |
9989566,214746582 | fitodic 9989566 | dogsheep.github.io 214746582 | 2019-11-08T12:11:32Z |
11164430,107914493 | thomastu 11164430 | datasette 107914493 | 2019-11-08T21:13:52Z |
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]);