commits
6 rows where "author_date" is on date 2020-02-22 sorted by message
This data as json, CSV (advanced)
Suggested facets: raw_author, raw_committer, author, committer, committer_date (date)
sha | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
d6335f1f3184683b05131dd12a73ff1115aefba3 | 2020-02-22T02:53:35Z | 2020-02-22T02:53:35Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
7c6a9c35299f251f9abfb03fd8e85143e4361709 | 2020-02-22T02:27:07Z | 2020-02-22T02:27:07Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
be2265b0e811d0ac2875c2f748125c17b0f9289e | 2020-02-22T02:32:17Z | 2020-02-22T02:32:17Z | Adrien Di Pasquale bd53542d6923dd8fcfd93cd43a925e6e8acd6e80 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | datasette 107914493 | adipasquale 883348 | web-flow 19864447 |
962a7e16e5e73c000d87815194b8261428e0938e | 2020-02-22T03:01:57Z | 2020-02-22T03:01:57Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
b031fe97636b80b05fec409ee1dffb7d044fd4e9 | 2020-02-22T03:04:46Z | 2020-02-22T03:04:46Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
6303ea50483e432bbef193d1c54c2bf54e53f157 | 2020-02-22T01:32:40Z | 2020-02-22T01:32:40Z | 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]);