commits
11 rows where committer = 9599 and message = "Applied Black"
This data as json, CSV (advanced)
Suggested facets: repo, author_date (date), committer_date (date)
sha ▼ | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
0f1b951c5131d16f3c8559a8e4d79ed5c559e3cb | 2020-09-18T22:20:55Z | 2020-09-18T22:20:55Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | dogsheep-beta 197431109 | simonw 9599 | simonw 9599 |
2da4144c57a54db420d3e787004390b4f9f7cff3 | 2020-08-16T17:35:14Z | 2020-08-16T17:35:14Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
317071a552003384c939a7551684f7299792ad18 | 2020-09-22T23:09:28Z | 2020-09-22T23:09:28Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
5534c320e4dfdf0ee854704a40ced275f70edb05 | 2020-09-23T00:32:40Z | 2020-09-23T00:32:40Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
8a4639bc43a016a1f8fae6a07d5b5f7abe0074e8 | 2020-10-30T05:14:33Z | 2020-10-30T05:14:33Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
8dd816bc76937f1e37f86acce10dc2cb4fa31e52 | 2022-05-30T22:42:38Z | 2022-05-30T22:42:38Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
8e8fc5cee5c78da8334495c6d6257d5612c40792 | 2021-01-11T21:34:38Z | 2021-01-11T21:34:38Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
b08037edcfb499dc443592820f80a8aba0fe3b19 | 2020-03-21T04:19:07Z | 2020-03-21T04:19:07Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | hacker-news-to-sqlite 248903544 | simonw 9599 | simonw 9599 |
b47ac37114d522d8f295b2b7cbe70ab094fc2608 | 2020-10-07T22:51:25Z | 2020-10-07T22:51:25Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
b5e902fcb02953f0f1fc4c652a24c262559a37d7 | 2022-07-28T15:13:47Z | 2022-07-28T15:13:47Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
f29f6821f2d08e91c5c6d65d885a1bbc0c743bdd | 2020-09-22T07:49:27Z | 2020-09-22T07:49:27Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE [commits] ( [sha] TEXT PRIMARY KEY, [message] TEXT, [author_date] TEXT, [committer_date] TEXT, [raw_author] TEXT REFERENCES [raw_authors]([id]), [raw_committer] TEXT REFERENCES [raw_authors]([id]), [repo] INTEGER REFERENCES [repos]([id]), [author] INTEGER REFERENCES [users]([id]), [committer] INTEGER REFERENCES [users]([id]) ); CREATE INDEX [idx_commits_committer] ON [commits] ([committer]); CREATE INDEX [idx_commits_author] ON [commits] ([author]); CREATE INDEX [idx_commits_repo] ON [commits] ([repo]); CREATE INDEX [idx_commits_raw_committer] ON [commits] ([raw_committer]); CREATE INDEX [idx_commits_raw_author] ON [commits] ([raw_author]);