stars
25 rows where "starred_at" is on date 2020-05-08
This data as json, CSV (advanced)
Suggested facets: user
repo 9 ✖
| Link | user | repo | starred_at |
|---|---|---|---|
| 50712,197882382 | gms8994 50712 | healthkit-to-sqlite 197882382 | 2020-05-08T19:19:54Z |
| 86492,107914493 | danromero 86492 | datasette 107914493 | 2020-05-08T17:36:00Z |
| 86492,206156866 | danromero 86492 | twitter-to-sqlite 206156866 | 2020-05-08T17:36:40Z |
| 445341,107914493 | fspadini 445341 | datasette 107914493 | 2020-05-08T20:03:19Z |
| 445341,207052882 | fspadini 445341 | github-to-sqlite 207052882 | 2020-05-08T20:03:34Z |
| 445341,248903544 | fspadini 445341 | hacker-news-to-sqlite 248903544 | 2020-05-08T20:04:01Z |
| 445341,256834907 | fspadini 445341 | dogsheep-photos 256834907 | 2020-05-08T20:03:43Z |
| 854991,107914493 | DonDebonair 854991 | datasette 107914493 | 2020-05-08T16:19:31Z |
| 1232007,197882382 | leleu 1232007 | healthkit-to-sqlite 197882382 | 2020-05-08T22:07:37Z |
| 1280346,107914493 | jacopofar 1280346 | datasette 107914493 | 2020-05-08T23:12:35Z |
| 1667388,107914493 | brianmcdonald 1667388 | datasette 107914493 | 2020-05-08T16:42:44Z |
| 1912892,214746582 | vonj 1912892 | dogsheep.github.io 214746582 | 2020-05-08T18:55:20Z |
| 1930631,107914493 | OneCricketeer 1930631 | datasette 107914493 | 2020-05-08T19:36:05Z |
| 2041398,107914493 | jiangplus 2041398 | datasette 107914493 | 2020-05-08T18:08:20Z |
| 3280204,107914493 | ycrao 3280204 | datasette 107914493 | 2020-05-08T06:42:30Z |
| 3280204,140912432 | ycrao 3280204 | sqlite-utils 140912432 | 2020-05-08T06:42:21Z |
| 6299586,107914493 | rufb 6299586 | datasette 107914493 | 2020-05-08T22:04:16Z |
| 7335567,107914493 | qbmiller 7335567 | datasette 107914493 | 2020-05-08T09:11:15Z |
| 7573442,206649770 | tbino 7573442 | google-takeout-to-sqlite 206649770 | 2020-05-08T19:23:25Z |
| 7573442,214746582 | tbino 7573442 | dogsheep.github.io 214746582 | 2020-05-08T19:23:20Z |
| 10921676,107914493 | sikasjc 10921676 | datasette 107914493 | 2020-05-08T03:02:25Z |
| 25287458,206649770 | bryan-crompton 25287458 | google-takeout-to-sqlite 206649770 | 2020-05-08T16:48:23Z |
| 25287458,207052882 | bryan-crompton 25287458 | github-to-sqlite 207052882 | 2020-05-08T16:47:48Z |
| 25287458,248903544 | bryan-crompton 25287458 | hacker-news-to-sqlite 248903544 | 2020-05-08T16:48:58Z |
| 43341228,107914493 | meghatiku 43341228 | datasette 107914493 | 2020-05-08T13:54:39Z |
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]);