commits
11 rows where "committer_date" is on date 2020-06-06 sorted by author
This data as json, CSV (advanced)
Suggested facets: raw_committer, committer, author_date (date)
sha | author_date | committer_date | raw_author | raw_committer | repo | author ▼ | committer |
---|---|---|---|---|---|---|---|
f1daf64e722f9aedc61bea1636a9df715c4c4a8e | 2020-06-06T19:46:40Z | 2020-06-06T19:46:40Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
415ccd7cbdeebfb52f514a0387221023aa8b4d91 | 2020-06-06T19:40:19Z | 2020-06-06T19:40:19Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | datasette 107914493 | simonw 9599 | web-flow 19864447 |
3359d54a4eb9c9725c27a85437661b5180c4099a | 2020-06-06T19:33:08Z | 2020-06-06T19:33:08Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
966eec7f75d2e1b809b001bb7e82f35d477f77ea | 2020-06-06T19:27:00Z | 2020-06-06T19:27:00Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
070838bfa19b177f59ef3bd8f0139266adecda90 | 2020-06-06T19:26:19Z | 2020-06-06T19:26:19Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
3f83d4632a643266f46ccd955d951be7aacbab99 | 2020-06-06T19:05:22Z | 2020-06-06T19:05:22Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
14f6b4d200f24940a795ddc0825319ab2891bde2 | 2020-06-06T18:39:11Z | 2020-06-06T18:39:11Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
d4c7b85f556230923d37ff327a068ed08aa9b62b | 2020-06-06T18:23:54Z | 2020-06-06T18:23:54Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
30a8132d58a89fed0e034e058b62fab5180fae0f | 2020-06-06T18:18:46Z | 2020-06-06T18:18:46Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
9c563d6aed072f14d3d25f58e84659f9caa1a243 | 2020-06-06T00:15:52Z | 2020-06-06T00:15:52Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
7dc23cd71aeb5a0e194f25fd1b8e569e3bb2149b | 2020-06-06T20:05:09Z | 2020-06-06T20:05:09Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | 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]);