commits
12 rows where "author_date" is on date 2021-11-14 sorted by raw_author
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 |
---|---|---|---|---|---|---|---|
502c02fa6dde6a8bb840af6c4c8cf858aa1db687 | 2021-11-14T05:37:40Z | 2021-11-14T05:37:40Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
030390fd4abcecf1ab80d0528e32d7dbc50d1b5f | 2021-11-14T05:29:43Z | 2021-11-14T05:29:43Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | datasette 107914493 | simonw 9599 | web-flow 19864447 |
de1e031713f47fbd51eb7239db3e7e6025fbf81a | 2021-11-14T05:14:43Z | 2021-11-14T05:14:43Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
1c13e1af0664a4dfb1e69714c56523279cae09e4 | 2021-11-14T05:08:33Z | 2021-11-14T05:08:33Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
c9e3cfecc8e966e5137d72e3f2150be9602d55f5 | 2021-11-14T04:53:00Z | 2021-11-14T04:53:00Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
c306b696de0a582e322f9eb7cb4125c83301e3a9 | 2021-11-14T04:44:54Z | 2021-11-14T04:44:54Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | datasette 107914493 | simonw 9599 | simonw 9599 |
adea5bc3965c80684f219b12299f708f2f422ca1 | 2021-11-14T23:24:15Z | 2021-11-14T23:24:15Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
73e214a9760c5dc32ed3c5429cb04d4d471ce014 | 2021-11-14T23:21:04Z | 2021-11-14T23:21:04Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
12b8c9de256ba907d4fa8e134bf9ce9bc012302e | 2021-11-14T23:05:00Z | 2021-11-14T23:05:00Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
13195d8747764df3952ed1117e0fd2152f1899e7 | 2021-11-14T22:55:42Z | 2021-11-14T22:55:42Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
e8d958109ee290cfa1b44ef7a39629bb50ab673e | 2021-11-14T22:49:19Z | 2021-11-14T22:49:42Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
bc4c42d68879c710c851dba3c98deda96ca6caa8 | 2021-11-14T23:25:40Z | 2021-11-14T23:25:40Z | Denys Pavlov 64b848f51063b81fd138f806322b4add4b5f1afd | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | sqlite-utils 140912432 | meatcar 191622 | 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]);