commits
42 rows where committer = 19864447 and repo = 207052882 sorted by message
This data as json, CSV (advanced)
sha | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
4ae4aa6f172344b19ff3513707195ee6d2654bd4 | 2020-07-18T22:34:15Z | 2020-07-18T22:34:15Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
426cb329349181428126b88eec362806e5e37a5e | 2020-09-17T03:54:16Z | 2020-09-17T03:54:16Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
16d271253f4ea71b261d2d228b926c7bc1a7e660 | 2020-10-19T05:36:32Z | 2020-10-19T05:36:32Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
7ede11eca30a8ad5ef78cd1f8b6eb6aa7b91f268 | 2020-11-30T04:16:41Z | 2020-11-30T04:16:41Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
70dffca351375e6f542969c72ebc43c6d393d99c | 2021-05-19T16:08:12Z | 2021-05-19T16:08:12Z | Felix Rosencrantz a7fbb45ec68f58915ee5484e65e5159f5ed91182 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | frosencrantz 631242 | web-flow 19864447 |
38e38373828af1988fa172a1f3859998ad30d3fe | 2020-07-23T14:53:33Z | 2020-07-23T14:53:33Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
12731143c8bba510bebe96a48c126902ca8b5449 | 2021-05-19T16:05:52Z | 2021-05-19T16:05:52Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
26fd45f4bdae7b2c884a2c9120ca2f54ba7bf3e7 | 2020-04-30T23:27:03Z | 2020-04-30T23:27:03Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
ed3752022e45b890af63996efec804725e95d0d4 | 2021-08-17T23:55:01Z | 2021-08-17T23:55:01Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
c0d54e0260468be38152293df5abd775c068495d | 2020-05-03T02:26:29Z | 2020-05-03T02:26:29Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
751bc900366ca52e662ea383b858cbf4365093d9 | 2022-01-06T17:19:02Z | 2022-01-06T17:19:02Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
0e45b72312a0756e5a562effbba08cb8de1e480b | 2022-09-28T21:07:54Z | 2022-09-28T21:07:54Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
5c1d27fbf75ec01bd1cbb90e416818fbbf6d42c5 | 2020-05-02T08:34:17Z | 2020-05-02T08:34:17Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
78b2dc89dc3f652ae4e67de497fcadc242be17fc | 2020-07-06T00:57:52Z | 2020-07-06T00:57:52Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
ba8cf3e9bb5f4f8740bd4b9eed28f1464d7f6b9a | 2021-05-19T16:07:09Z | 2021-05-19T16:07:09Z | Daniel Butler 54b04f11239eb4002452e63ac0afe49e5a6c45a9 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | daniel-butler 22578954 | web-flow 19864447 |
b37f55549461cfe0731b57623f315860b3db49d0 | 2020-11-29T23:51:08Z | 2020-11-29T23:51:08Z | Adam Jonas 04fb3d52db4bd9bf23ce52c5cc72fda2068a1fce | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | adamjonas 755825 | web-flow 19864447 |
a6e237f75a4b86963d91dcb5c9582e3a1b3349d6 | 2022-03-22T01:59:45Z | 2022-03-22T01:59:45Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
1a6105cfcc99ba72050b4101cb0f072b58d9a8a0 | 2020-09-11T04:31:14Z | 2020-09-11T04:31:14Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
626dd61f6070f95f7652104cb9f4100e9b88862f | 2022-12-15T06:57:31Z | 2022-12-15T06:57:31Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
5148f10da94a8684bb747cb3d25ccfff8185ff5a | 2020-11-30T01:31:12Z | 2020-11-30T01:31:12Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | 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]);