stars
12 rows where "starred_at" is on date 2020-10-05
This data as json, CSV (advanced)
Suggested facets: repo
Link | user | repo | starred_at |
---|---|---|---|
1563,214746582 | bru 1563 | dogsheep.github.io 214746582 | 2020-10-05T07:09:49Z |
2079,107914493 | whoisjake 2079 | datasette 107914493 | 2020-10-05T13:54:40Z |
45997,107914493 | asmallteapot 45997 | datasette 107914493 | 2020-10-05T22:17:57Z |
208447,107914493 | dschein 208447 | datasette 107914493 | 2020-10-05T10:59:42Z |
242588,107914493 | dmajka 242588 | datasette 107914493 | 2020-10-05T01:41:53Z |
305282,140912432 | mattmakai 305282 | sqlite-utils 140912432 | 2020-10-05T15:17:00Z |
551589,197882382 | geniusphil 551589 | healthkit-to-sqlite 197882382 | 2020-10-05T02:34:27Z |
553953,107914493 | ProfAvery 553953 | datasette 107914493 | 2020-10-05T05:11:03Z |
12937257,107914493 | blu3r4d0n 12937257 | datasette 107914493 | 2020-10-05T00:30:40Z |
13174219,107914493 | zmrenwu 13174219 | datasette 107914493 | 2020-10-05T03:47:52Z |
29686531,140912432 | alphapenng 29686531 | sqlite-utils 140912432 | 2020-10-05T03:31:21Z |
35223722,140912432 | RobertasMurnikovas 35223722 | sqlite-utils 140912432 | 2020-10-05T17:40:27Z |
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]);