stars
12 rows where "starred_at" is on date 2018-10-10 sorted by user
This data as json, CSV (advanced)
Suggested facets: starred_at (date)
Link | user ▼ | repo | starred_at |
---|---|---|---|
21705,107914493 | benspaulding 21705 | datasette 107914493 | 2018-10-10T04:09:01Z |
302135,107914493 | zmilan 302135 | datasette 107914493 | 2018-10-10T14:32:49Z |
331710,107914493 | nicolasramy 331710 | datasette 107914493 | 2018-10-10T18:55:11Z |
1306472,107914493 | paulhig 1306472 | datasette 107914493 | 2018-10-10T14:58:50Z |
1448377,107914493 | halhenke 1448377 | datasette 107914493 | 2018-10-10T09:01:21Z |
1458333,107914493 | tecnom1k3 1458333 | datasette 107914493 | 2018-10-10T19:06:46Z |
1900200,107914493 | jacob-beltran 1900200 | datasette 107914493 | 2018-10-10T15:13:02Z |
8646724,107914493 | wsinw 8646724 | datasette 107914493 | 2018-10-10T21:33:32Z |
12756112,107914493 | gt-sun 12756112 | datasette 107914493 | 2018-10-10T03:14:57Z |
14828299,107914493 | normade 14828299 | datasette 107914493 | 2018-10-10T12:59:52Z |
32710031,107914493 | NaiveIsopod 32710031 | datasette 107914493 | 2018-10-10T13:56:04Z |
37161524,107914493 | Sixl-Daniel 37161524 | datasette 107914493 | 2018-10-10T12:52:08Z |
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]);