stars
12 rows where repo = 107914493 and "starred_at" is on date 2019-12-16
This data as json, CSV (advanced)
Suggested facets: starred_at (date)
Link | user | repo | starred_at |
---|---|---|---|
2807,107914493 | alakra 2807 | datasette 107914493 | 2019-12-16T02:03:38Z |
54230,107914493 | mrzor 54230 | datasette 107914493 | 2019-12-16T01:51:53Z |
632820,107914493 | askn 632820 | datasette 107914493 | 2019-12-16T06:17:38Z |
709962,107914493 | zmiftah 709962 | datasette 107914493 | 2019-12-16T02:26:50Z |
911359,107914493 | topher6345 911359 | datasette 107914493 | 2019-12-16T02:46:12Z |
2311344,107914493 | gryn010 2311344 | datasette 107914493 | 2019-12-16T02:41:17Z |
2348618,107914493 | obi1kenobi 2348618 | datasette 107914493 | 2019-12-16T01:46:18Z |
3421153,107914493 | DaniSQL 3421153 | datasette 107914493 | 2019-12-16T01:13:43Z |
11166947,107914493 | alexkreidler 11166947 | datasette 107914493 | 2019-12-16T01:50:56Z |
19561424,107914493 | yoinks-yoinks 19561424 | datasette 107914493 | 2019-12-16T06:57:03Z |
26268125,107914493 | rgwood 26268125 | datasette 107914493 | 2019-12-16T03:21:06Z |
30122185,107914493 | martin-kuehnhausen 30122185 | datasette 107914493 | 2019-12-16T01:58:32Z |
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]);