commits
22 rows where "author_date" is on date 2017-11-13 sorted by committer
This data as json, CSV (advanced)
committer_date (date) 1 ✖
sha | author_date | committer_date | raw_author | raw_committer | repo | author | committer ▼ |
---|---|---|---|---|---|---|---|
d75f423b6fcfc074b7c6f8f7679da8876f181edd | 2017-11-13T22:00:39Z | 2017-11-13T22:00:53Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
d76412668f8c12572eb7de57ccb72f1e50306177 | 2017-11-13T20:34:39Z | 2017-11-13T20:34:39Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
e838bd743d31358b362875854a0ac5e78047727f | 2017-11-13T18:41:53Z | 2017-11-13T18:41:59Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
fe279ab7b4ae99dab295d5cf4d39ad06d782997e | 2017-11-13T21:17:34Z | 2017-11-13T21:17:34Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
ff2fb573cd8773206a6df83229620928056e2ee2 | 2017-11-13T02:12:21Z | 2017-11-13T02:12:21Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
452c5f047ea229dbb444e271183a55381bb4abce | 2017-11-13T21:24:14Z | 2017-11-13T21:24:14Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | datasette 107914493 | simonw 9599 | web-flow 19864447 |
bdfb6d4f1359e98e127a3514248fd19b27b574e9 | 2017-11-13T22:18:44Z | 2017-11-13T22:18:44Z | 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]);