commits
22 rows where "author_date" is on date 2019-02-24 sorted by committer_date descending
This data as json, CSV (advanced)
Suggested facets: raw_author, committer, committer_date (date)
raw_committer 3 ✖
- Simon Willison 20
- Simon Willison 1
- GitHub 1
sha | author_date | committer_date ▲ | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
05317f53411fab3c3d66b88408bc867f2e474a35 | 2019-02-24T23:11:51Z | 2019-02-24T23:11:51Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
3cab079d3e45aa3468e9f7317680ded6438f3955 | 2019-02-24T22:24:00Z | 2019-02-24T22:24:00Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
557dc3f9a7b622c45c73fd791cfe0a786f9a1de0 | 2019-02-24T22:12:45Z | 2019-02-24T22:12:45Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
f8d3b7cfe5c1950b0749d40eb2640df50b52f651 | 2019-02-24T21:33:45Z | 2019-02-24T21:33:45Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
e1ca938aa1c84367fd9d4786b9709c56f3e6e778 | 2019-02-24T21:10:51Z | 2019-02-24T21:10:51Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
9756310408c7e5fa1ca257573e46aa13c2041c24 | 2019-02-24T20:59:46Z | 2019-02-24T20:59:46Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
33df260b38e1b0f179cdb849fc4e3e9c76e57f3a | 2019-02-24T20:12:59Z | 2019-02-24T20:12:59Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
0bc49e938e1e3444df734f9178a9a317f68f9716 | 2019-02-24T20:04:33Z | 2019-02-24T20:04:33Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
05a85b358fb907d8fcb72f19390ee2ba5a2261a5 | 2019-02-24T19:50:56Z | 2019-02-24T19:50:56Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
6d25f648ed708b8dd78cbb0af5e356d16859625f | 2019-02-24T19:49:24Z | 2019-02-24T19:49:31Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
c5286d2c66b8c187002f9ad8991a6665b2b092f9 | 2019-02-24T19:40:58Z | 2019-02-24T19:40:58Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
dc2560879ed32136d64707a031b62b2870809892 | 2019-02-24T19:40:26Z | 2019-02-24T19:40:26Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
8a5d0d80c37008f30953110d58f474aac2728ee3 | 2019-02-24T19:11:21Z | 2019-02-24T19:11:21Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
7784b924a179ee213f52693276ab7b68d6549b51 | 2019-02-24T18:46:44Z | 2019-02-24T18:46:44Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
0c6745b70f95663f8ddf4309c578bd568eca75ec | 2019-02-24T18:42:27Z | 2019-02-24T18:42:27Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
e7ffbcdb364810213b0697c9bcab064efb1dd469 | 2019-02-24T18:41:51Z | 2019-02-24T18:41:51Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
1b6025e8ab5cef6a6f2550cc3be1f80b12cc64a1 | 2019-02-24T06:54:43Z | 2019-02-24T06:54:43Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
10e3aab4c63bc02cacd64e7aa1e5eaff2b314b3e | 2019-02-24T06:49:54Z | 2019-02-24T06:49:54Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
6c3f5e647934413dfc46a218f1540a1cab31e52e | 2019-02-24T06:45:17Z | 2019-02-24T06:45:17Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
dbf239e3fc8af00ef43ec578fb195dfe604a99fe | 2019-02-24T04:36:40Z | 2019-02-24T04:36:40Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
e615d22c5564ea1f32abb086088b2700110be10a | 2019-02-24T04:02:19Z | 2019-02-24T04:02:19Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | sqlite-utils 140912432 | simonw 9599 | web-flow 19864447 |
c5068a0972651b3e359ebc2d6c1486b8b7d2c242 | 2019-02-24T03:55:04Z | 2019-02-24T03:55:04Z | Jeff Triplett 207bb2132044fa5a4fe28a579f7588c2eee6e391 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | sqlite-utils 140912432 | jefftriplett 50527 | 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]);