stars
28 rows where "starred_at" is on date 2021-03-26
This data as json, CSV (advanced)
Suggested facets: user, starred_at (date)
| Link | user | repo | starred_at |
|---|---|---|---|
| 8654,107914493 | igungor 8654 | datasette 107914493 | 2021-03-26T06:29:14Z |
| 14547,197431109 | nogweii 14547 | dogsheep-beta 197431109 | 2021-03-26T01:28:08Z |
| 14547,206156866 | nogweii 14547 | twitter-to-sqlite 206156866 | 2021-03-26T01:27:39Z |
| 14547,206649770 | nogweii 14547 | google-takeout-to-sqlite 206649770 | 2021-03-26T01:27:32Z |
| 39916,107914493 | joeshaw 39916 | datasette 107914493 | 2021-03-26T16:46:25Z |
| 57199,107914493 | dwt 57199 | datasette 107914493 | 2021-03-26T20:32:41Z |
| 128885,197431109 | fly51fly 128885 | dogsheep-beta 197431109 | 2021-03-26T09:57:40Z |
| 189420,207052882 | morphar 189420 | github-to-sqlite 207052882 | 2021-03-26T06:31:17Z |
| 392251,107914493 | hessammehr 392251 | datasette 107914493 | 2021-03-26T08:59:31Z |
| 494686,107914493 | tpatel 494686 | datasette 107914493 | 2021-03-26T15:25:58Z |
| 494686,140912432 | tpatel 494686 | sqlite-utils 140912432 | 2021-03-26T15:27:51Z |
| 569269,107914493 | darvid 569269 | datasette 107914493 | 2021-03-26T03:12:04Z |
| 663703,107914493 | kobyv 663703 | datasette 107914493 | 2021-03-26T12:52:07Z |
| 869862,107914493 | dmitrykoval 869862 | datasette 107914493 | 2021-03-26T07:03:09Z |
| 1821570,107914493 | voidpainter 1821570 | datasette 107914493 | 2021-03-26T08:26:46Z |
| 1922628,107914493 | hendrikcech 1922628 | datasette 107914493 | 2021-03-26T08:20:01Z |
| 3735758,107914493 | xyxu 3735758 | datasette 107914493 | 2021-03-26T06:16:37Z |
| 3768247,107914493 | iladin 3768247 | datasette 107914493 | 2021-03-26T15:40:28Z |
| 3768247,207052882 | iladin 3768247 | github-to-sqlite 207052882 | 2021-03-26T15:38:43Z |
| 8696177,107914493 | parasdahal 8696177 | datasette 107914493 | 2021-03-26T03:46:00Z |
| 10156699,207052882 | zambonin 10156699 | github-to-sqlite 207052882 | 2021-03-26T02:44:25Z |
| 11516280,107914493 | vrajanap 11516280 | datasette 107914493 | 2021-03-26T00:12:11Z |
| 11666017,107914493 | 4M01 11666017 | datasette 107914493 | 2021-03-26T05:23:24Z |
| 13487305,107914493 | aavanian 13487305 | datasette 107914493 | 2021-03-26T03:46:57Z |
| 15616911,206649770 | hthuwal 15616911 | google-takeout-to-sqlite 206649770 | 2021-03-26T08:50:14Z |
| 21260838,206156866 | KasperZutterman 21260838 | twitter-to-sqlite 206156866 | 2021-03-26T20:18:57Z |
| 21260838,213286752 | KasperZutterman 21260838 | pocket-to-sqlite 213286752 | 2021-03-26T20:19:38Z |
| 32652297,213286752 | jimbrig 32652297 | pocket-to-sqlite 213286752 | 2021-03-26T20:33: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]);