stars
9 rows where repo = 107914493 and "starred_at" is on date 2019-05-10
This data as json, CSV (advanced)
Suggested facets: starred_at (date)
Link | user | repo | starred_at |
---|---|---|---|
511734,107914493 | kimadactyl 511734 | datasette 107914493 | 2019-05-10T14:09:37Z |
3973674,107914493 | jaumebonet 3973674 | datasette 107914493 | 2019-05-10T07:13:32Z |
4325375,107914493 | SCKelemen 4325375 | datasette 107914493 | 2019-05-10T06:59:16Z |
5393921,107914493 | blakedallen 5393921 | datasette 107914493 | 2019-05-10T19:25:27Z |
12166244,107914493 | fjcamillo 12166244 | datasette 107914493 | 2019-05-10T02:58:25Z |
13223818,107914493 | osule 13223818 | datasette 107914493 | 2019-05-10T06:11:27Z |
18410176,107914493 | KEVINYZY 18410176 | datasette 107914493 | 2019-05-10T13:49:02Z |
22195501,107914493 | LuisPaGarcia 22195501 | datasette 107914493 | 2019-05-10T15:24:26Z |
40428449,107914493 | who0sy 40428449 | datasette 107914493 | 2019-05-10T07:15:06Z |
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]);