commits
12 rows where message = "Fixed typo" sorted by sha descending
This data as json, CSV (advanced)
Suggested facets: raw_author, raw_committer, repo, committer, committer_date (date)
sha ▲ | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
cb4854a435cc1418665edec2a73664ad74a32017 | 2022-03-20T01:17:58Z | 2022-03-20T01:17:58Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
a258339a935d8d29a95940ef1db01e98bb85ae63 | 2020-09-19T06:33:09Z | 2020-09-19T06:33:09Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | datasette 107914493 | simonw 9599 | web-flow 19864447 |
92aa5c9c5d26b0889c8c3d97c76a908d5f8af211 | 2021-11-11T20:50:22Z | 2021-11-11T20:50:22Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | sqlite-utils 140912432 | simonw 9599 | web-flow 19864447 |
841ad44bacaff05ec79ef78166d12e80c82ba6d7 | 2022-05-02T18:17:19Z | 2022-05-02T18:17:19Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | sqlite-utils 140912432 | simonw 9599 | web-flow 19864447 |
8059c8a27c9a5dd18e29e8cb54bb9290ffd77d67 | 2022-12-31T18:54:25Z | 2022-12-31T18:54:25Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
5f38c8160138702810698249be27a3c71023b9e4 | 2022-01-11T19:20:34Z | 2022-01-11T19:20:34Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | sqlite-utils 140912432 | simonw 9599 | web-flow 19864447 |
42caabf7e9e6e4d69ef6dd7de16f2cd96bc79d5b | 2021-02-22T17:35:41Z | 2021-02-22T17:35:41Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | datasette 107914493 | simonw 9599 | web-flow 19864447 |
1a77f30d3c40b1a6812da5d27ab35fa1acbd988b | 2020-02-26T07:11:19Z | 2020-02-26T07:11:19Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | datasette 107914493 | simonw 9599 | web-flow 19864447 |
197e69cec40052c423a5ed071feb5f7cccea41b9 | 2021-02-09T15:47:54Z | 2021-02-09T15:47:54Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | twitter-to-sqlite 206156866 | simonw 9599 | web-flow 19864447 |
0e7b461eb3e925aef713206c15794ceae9259c57 | 2019-08-04T04:13:31Z | 2019-08-04T04:13:31Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | sqlite-utils 140912432 | simonw 9599 | web-flow 19864447 |
092e1368edc4e7f4cb337a62eabd9a6e1245006b | 2019-05-25T14:24:17Z | 2019-05-25T14:24:17Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
075d422c0a1c70259188dfbd940538c67419694a | 2017-11-14T05:28:02Z | 2017-11-14T05:28:02Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | datasette 107914493 | simonw 9599 | web-flow 19864447 |
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]);