stars
19 rows where repo = 107914493 and "starred_at" is on date 2020-11-28 sorted by user
This data as json, CSV (advanced)
Suggested facets: starred_at (date)
Link | user ▼ | repo | starred_at |
---|---|---|---|
11238,107914493 | antogerva 11238 | datasette 107914493 | 2020-11-28T20:53:32Z |
89019,107914493 | matthewturk 89019 | datasette 107914493 | 2020-11-28T19:39:05Z |
127824,107914493 | zoosky 127824 | datasette 107914493 | 2020-11-28T19:26:35Z |
246743,107914493 | atse 246743 | datasette 107914493 | 2020-11-28T22:44:10Z |
370173,107914493 | cawlin 370173 | datasette 107914493 | 2020-11-28T05:10:57Z |
380000,107914493 | AoJ 380000 | datasette 107914493 | 2020-11-28T07:05:25Z |
400311,107914493 | xqzhou 400311 | datasette 107914493 | 2020-11-28T00:08:25Z |
521097,107914493 | pauloxnet 521097 | datasette 107914493 | 2020-11-28T21:50:11Z |
697194,107914493 | cmaldonadowilson 697194 | datasette 107914493 | 2020-11-28T01:04:58Z |
780882,107914493 | powerdude 780882 | datasette 107914493 | 2020-11-28T03:57:28Z |
1212964,107914493 | gorcha 1212964 | datasette 107914493 | 2020-11-28T12:21:22Z |
2750442,107914493 | recamshak 2750442 | datasette 107914493 | 2020-11-28T23:17:23Z |
3451581,107914493 | giovannibonetti 3451581 | datasette 107914493 | 2020-11-28T18:23:01Z |
4599599,107914493 | knguyen0105 4599599 | datasette 107914493 | 2020-11-28T01:01:30Z |
7829379,107914493 | poudel 7829379 | datasette 107914493 | 2020-11-28T17:22:17Z |
12673597,107914493 | dlaperriere 12673597 | datasette 107914493 | 2020-11-28T19:17:50Z |
14849329,107914493 | plluksie 14849329 | datasette 107914493 | 2020-11-28T18:39:30Z |
34899034,107914493 | code86 34899034 | datasette 107914493 | 2020-11-28T01:56:18Z |
47585455,107914493 | tg-z 47585455 | datasette 107914493 | 2020-11-28T06:04:05Z |
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]);