stars
10 rows where "starred_at" is on date 2019-05-21
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
368589,107914493 | jamhall 368589 | datasette 107914493 | 2019-05-21T21:06:12Z |
1532209,107914493 | oucb 1532209 | datasette 107914493 | 2019-05-21T01:46:08Z |
1950733,107914493 | kristoff-it 1950733 | datasette 107914493 | 2019-05-21T17:23:31Z |
2188547,107914493 | juvu 2188547 | datasette 107914493 | 2019-05-21T17:49:12Z |
3181863,107914493 | keithporcaro 3181863 | datasette 107914493 | 2019-05-21T17:35:04Z |
6838373,107914493 | pmilovanov 6838373 | datasette 107914493 | 2019-05-21T16:49:39Z |
10872821,107914493 | ewenme 10872821 | datasette 107914493 | 2019-05-21T20:28:44Z |
19263739,107914493 | Anondo 19263739 | datasette 107914493 | 2019-05-21T03:39:50Z |
42959635,107914493 | kimba4u 42959635 | datasette 107914493 | 2019-05-21T01:41:15Z |
50889611,107914493 | TheDataDudeDE 50889611 | datasette 107914493 | 2019-05-21T21:39:02Z |
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]);