stars
13 rows where repo = 107914493 and "starred_at" is on date 2020-10-02
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
721144,107914493 | lgw4 721144 | datasette 107914493 | 2020-10-02T17:53:51Z |
1227441,107914493 | maxhoffmann 1227441 | datasette 107914493 | 2020-10-02T15:59:42Z |
8991708,107914493 | acbilson 8991708 | datasette 107914493 | 2020-10-02T11:15:52Z |
11407254,107914493 | abedkhooli 11407254 | datasette 107914493 | 2020-10-02T17:54:44Z |
12421799,107914493 | klinga 12421799 | datasette 107914493 | 2020-10-02T17:20:42Z |
12999414,107914493 | sobamchan 12999414 | datasette 107914493 | 2020-10-02T13:30:30Z |
18221871,107914493 | noklam 18221871 | datasette 107914493 | 2020-10-02T04:11:20Z |
18239155,107914493 | leon-lei 18239155 | datasette 107914493 | 2020-10-02T17:19:55Z |
23582917,107914493 | m-01101101 23582917 | datasette 107914493 | 2020-10-02T21:58:25Z |
23723357,107914493 | bokwoon95 23723357 | datasette 107914493 | 2020-10-02T17:40:42Z |
47011394,107914493 | sizigia 47011394 | datasette 107914493 | 2020-10-02T15:44:40Z |
56534818,107914493 | tmtoivon 56534818 | datasette 107914493 | 2020-10-02T08:10:36Z |
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]);