commits
111 rows where committer = 9599 and repo = 206156866 sorted by author_date
This data as json, CSV (advanced)
sha | author_date ▼ | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
6be0ffcee24504fa2964b0e526842b8cfce7567b | 2020-04-30T18:11:42Z | 2020-04-30T18:11:42Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
ac60ce9331dc557837d879680611aca4bd6c28be | 2020-04-30T18:20:43Z | 2020-04-30T18:20:43Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
40d7530317b9b30a1c4bd3b73dac6f8b0669585b | 2020-07-22T18:55:05Z | 2020-07-22T19:00:42Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
e1777ab6db51fa37a05943c2c83fbf2281ec3ec7 | 2020-07-22T19:01:07Z | 2020-07-22T19:01:33Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
10dddcc2822863f9a6dbdc5cd4b28c6c4e4e9170 | 2021-08-20T00:01:16Z | 2021-08-20T00:01:28Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
00a9a5a5d184251c46e4c6426b10a1e56583300f | 2021-08-20T00:04:07Z | 2021-08-20T00:04:07Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
2a1def46e15baf6328e76a7660a3cfeb7b22e4f3 | 2021-08-20T00:12:10Z | 2021-08-20T00:12:10Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
0a47c376ba8c7143aeb05146643d6b26bb83e485 | 2021-08-21T20:50:14Z | 2021-08-21T20:50:14Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
255201afab0674212be0fe124716ef5d0dfe995d | 2021-08-21T20:52:11Z | 2021-08-21T20:52:11Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
74726190d4031bfa36db93e189555e273b35e283 | 2021-08-21T20:56:03Z | 2021-08-21T20:56:03Z | 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 |
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]);