stars
10 rows where "starred_at" is on date 2019-12-03
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
118283,107914493 | dbstraight 118283 | datasette 107914493 | 2019-12-03T15:03:42Z |
200770,107914493 | joshsimmons 200770 | datasette 107914493 | 2019-12-03T00:29:28Z |
310157,107914493 | bmix 310157 | datasette 107914493 | 2019-12-03T10:26:11Z |
1762878,107914493 | ian-andrich 1762878 | datasette 107914493 | 2019-12-03T16:20:55Z |
4598504,107914493 | afdevries 4598504 | datasette 107914493 | 2019-12-03T11:10:46Z |
5084596,107914493 | jackiealicordoba 5084596 | datasette 107914493 | 2019-12-03T02:53:09Z |
6344426,107914493 | jvalinsky 6344426 | datasette 107914493 | 2019-12-03T02:51:50Z |
11354777,107914493 | seisenberg 11354777 | datasette 107914493 | 2019-12-03T15:13:54Z |
19611354,107914493 | sjoerdapp 19611354 | datasette 107914493 | 2019-12-03T15:42:09Z |
22506838,107914493 | paradisessssspee 22506838 | datasette 107914493 | 2019-12-03T07:20:33Z |
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]);