stars
15 rows where repo = 107914493 and "starred_at" is on date 2020-09-05
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
5383,107914493 | maurycy 5383 | datasette 107914493 | 2020-09-05T19:36:04Z |
595909,107914493 | gregrahn 595909 | datasette 107914493 | 2020-09-05T16:38:37Z |
1863808,107914493 | tomwalters 1863808 | datasette 107914493 | 2020-09-05T08:35:35Z |
3531195,107914493 | rdoume 3531195 | datasette 107914493 | 2020-09-05T17:01:44Z |
3647567,107914493 | dclambert 3647567 | datasette 107914493 | 2020-09-05T15:23:03Z |
3865161,107914493 | pbaylies 3865161 | datasette 107914493 | 2020-09-05T18:49:25Z |
5487021,107914493 | veggiemonk 5487021 | datasette 107914493 | 2020-09-05T15:38:54Z |
6831355,107914493 | eugeneyan 6831355 | datasette 107914493 | 2020-09-05T18:38:06Z |
10904217,107914493 | lonestriker 10904217 | datasette 107914493 | 2020-09-05T15:28:11Z |
11818904,107914493 | eschmidt42 11818904 | datasette 107914493 | 2020-09-05T05:44:23Z |
13970565,107914493 | jeremyjordan 13970565 | datasette 107914493 | 2020-09-05T18:00:51Z |
24938377,107914493 | ujjwal-9 24938377 | datasette 107914493 | 2020-09-05T14:41:48Z |
28380506,107914493 | SzuHannah 28380506 | datasette 107914493 | 2020-09-05T17:28:38Z |
28828377,107914493 | daltonturner 28828377 | datasette 107914493 | 2020-09-05T19:05:01Z |
39058496,107914493 | st3v3odom 39058496 | datasette 107914493 | 2020-09-05T16:24:51Z |
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]);