commits
111 rows where committer = 9599 and repo = 206156866
This data as json, CSV (advanced)
sha ▼ | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
ef70bb8b3658a984f00e377e6ca1c1d5c238e81d | 2019-09-03T21:17:25Z | 2019-09-03T21:18:05Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
f07d3d14ca39ea95416edc904e566fe28e5b46f6 | 2019-09-04T21:54:39Z | 2019-09-04T21:54:39Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
f5b7ceba5b3167e962808814d492e49f87454b3f | 2019-10-14T03:30:17Z | 2019-10-14T03:30:17Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
f95762cc25cbf75909fee8ad041cc903d5f421b0 | 2019-09-03T22:42:41Z | 2019-09-03T22:42:41Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
faefa30fff03a9e88fc60e646ea6e7be97646dc1 | 2020-04-17T19:29:58Z | 2020-04-17T19:29:58Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
fb1a3a4b9fbe6bee80e93d86c2a10dd248636ab4 | 2021-09-21T17:39:08Z | 2021-09-21T17:39:08Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
fb2698086d766e0333a55bb73435e7283feeb438 | 2019-10-11T06:45:21Z | 2019-10-11T06:45:21Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
fced2a9b67d2cbdf9817f1eb75f7c28e413c963b | 2019-10-16T19:12:41Z | 2019-10-16T19:12:41Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
fd196a7f65c3c4721904042ff97ee85c839f6bf3 | 2019-11-09T19:35:09Z | 2019-11-09T19:35:09Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
fd1a989e09ccfd7b19ac5044ed4679c2134c1294 | 2019-09-03T20:42:38Z | 2019-09-03T20:42:38Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
ff55f97f1c9ba3203a25eb2cafe21e712c010d86 | 2019-10-16T18:58:17Z | 2019-10-16T18:58:17Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | 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]);