stars
17 rows where repo = 140912432 and "starred_at" is on date 2022-02-27
This data as json, CSV (advanced)
Link | user | repo | starred_at |
---|---|---|---|
14161,140912432 | ts 14161 | sqlite-utils 140912432 | 2022-02-27T16:00:27Z |
40560,140912432 | solarmist 40560 | sqlite-utils 140912432 | 2022-02-27T18:05:54Z |
65872,140912432 | extesy 65872 | sqlite-utils 140912432 | 2022-02-27T15:51:49Z |
85981,140912432 | georgek 85981 | sqlite-utils 140912432 | 2022-02-27T13:00:32Z |
187848,140912432 | jevinskie 187848 | sqlite-utils 140912432 | 2022-02-27T16:54:48Z |
396324,140912432 | yareally 396324 | sqlite-utils 140912432 | 2022-02-27T17:46:49Z |
494783,140912432 | riyadparvez 494783 | sqlite-utils 140912432 | 2022-02-27T15:37:37Z |
536171,140912432 | michaelvmata 536171 | sqlite-utils 140912432 | 2022-02-27T20:09:48Z |
667598,140912432 | danielledeleo 667598 | sqlite-utils 140912432 | 2022-02-27T17:32:26Z |
997952,140912432 | joejordan 997952 | sqlite-utils 140912432 | 2022-02-27T20:39:37Z |
1000648,140912432 | jlangston 1000648 | sqlite-utils 140912432 | 2022-02-27T18:52:16Z |
1059636,140912432 | decabyte 1059636 | sqlite-utils 140912432 | 2022-02-27T16:05:56Z |
1915469,140912432 | volks73 1915469 | sqlite-utils 140912432 | 2022-02-27T20:58:40Z |
6705942,140912432 | slachiewicz 6705942 | sqlite-utils 140912432 | 2022-02-27T13:20:39Z |
9067610,140912432 | proteanblank 9067610 | sqlite-utils 140912432 | 2022-02-27T19:42:05Z |
12343599,140912432 | twiccox 12343599 | sqlite-utils 140912432 | 2022-02-27T18:42:08Z |
18597725,140912432 | wlamason 18597725 | sqlite-utils 140912432 | 2022-02-27T21:00:30Z |
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]);