commits
132 rows where repo = 206156866 sorted by sha descending
This data as json, CSV (advanced)
sha ▲ | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
2e4b7c136734b352732186b4d761e608835f7ad3 | 2019-09-03T20:28:36Z | 2019-09-03T20:30:34Z | 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 |
2a0a84a4ff8211cd96e2f7a8b882a6cc3cc55c5c | 2019-09-03T20:41:20Z | 2019-09-03T20:41:20Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
2878c7ccbfc98f22d6fa3bc96a070aba7b712297 | 2019-10-16T19:37:10Z | 2019-10-16T19:37:10Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
279f2ba0652221bb4a542603f0846e9754e1632f | 2020-04-17T22:02:59Z | 2020-04-17T22:02:59Z | 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 |
24568509931d68d0ad1b017ab72f0462cde7666c | 2019-09-08T19:45:53Z | 2019-09-08T19:45:53Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
21fc1cad6dd6348c67acff90a785b458d3a81275 | 2020-07-23T14:56:02Z | 2020-07-23T14:56:02Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | twitter-to-sqlite 206156866 | simonw 9599 | web-flow 19864447 |
215bd23ee36701aebd8088d0c49d3c8e8be3df48 | 2019-09-04T21:23:38Z | 2019-09-04T21:23:38Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | twitter-to-sqlite 206156866 | simonw 9599 | web-flow 19864447 |
20ffa86b8ad3f2c98d88bb5e92365977bbcff417 | 2019-10-16T19:23:35Z | 2019-10-16T19:23:35Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
2057fc2d2a9b86a2bd34ca4fc3bb1dde798bcd1a | 2020-03-20T20:16:46Z | 2020-03-20T20:16:46Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
2045f2766387dada103dce4c9aaf1418bfaec3b5 | 2019-10-11T16:55:10Z | 2019-10-11T16:55:10Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
2019ee908731054c6eaa3d5123dfbdf7d2d70fc4 | 2019-10-11T06:45:00Z | 2019-10-11T06:45:00Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | twitter-to-sqlite 206156866 | simonw 9599 | web-flow 19864447 |
1f1310a25d95351d4bc8840472e97263c886b852 | 2019-09-03T21:17:52Z | 2019-09-03T21:17:52Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | twitter-to-sqlite 206156866 | simonw 9599 | web-flow 19864447 |
1ef6075b258703b411e9dd22ecbdce9b719a9b30 | 2019-11-09T19:55:38Z | 2019-11-09T19:55:38Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
1dcf8029cc08814197deb39a8a15f460aa0ef78f | 2019-11-09T19:36:30Z | 2019-11-09T19:36:30Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
1d84a96a47a70680de9d621771dfe6cf2082cf08 | 2019-10-11T16:51:03Z | 2019-10-11T16:51:03Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
1aad51519b6a7a224565a44c081b136ff3a7d667 | 2019-10-17T16:56:28Z | 2019-10-17T16:56:42Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
19bdd23a1c81d31664c44adc543ac9c9f7692edf | 2020-04-01T04:31:05Z | 2020-04-01T04:31:05Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
19b5633b4ae0937e33e980b93bf777763f454a80 | 2019-10-15T18:51:16Z | 2019-10-15T18:51:16Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
197e69cec40052c423a5ed071feb5f7cccea41b9 | 2021-02-09T15:47:54Z | 2021-02-09T15:47:54Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | twitter-to-sqlite 206156866 | simonw 9599 | web-flow 19864447 |
17606ed11e157f3c67611d7233b60ed5eb750c37 | 2019-10-07T00:31:27Z | 2019-10-07T00:31:39Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
11b2847252a2d6683023339873d6a31c5300409e | 2019-09-04T20:22:52Z | 2019-09-04T20:22:52Z | 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 |
0b8a952cd5709ac27494b1694ca95188c89442ce | 2020-04-01T04:31:23Z | 2020-04-01T04:31:23Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
0b84d52ab87d960d4b5e188052540518db2ea569 | 2019-10-15T18:53:53Z | 2019-10-15T18:53:53Z | 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 |
08110bc2b8801d725d65fa834d30b57e473d2241 | 2019-11-08T23:04:17Z | 2019-11-08T23:04:17Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
04c1d2cc54c71d4c6e795d174c7bb52f91739627 | 2020-03-20T23:12:30Z | 2020-03-20T23:12:30Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
013cc8147abb78227b7232c2d14cb428613b5760 | 2019-09-04T20:39:12Z | 2019-09-04T20:39:12Z | 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 |
005913518b695a2456fada7db61ba0d30488bc12 | 2019-09-04T21:16:38Z | 2019-09-04T21:16:38Z | 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]);