commits
42 rows where committer = 19864447 and repo = 207052882
This data as json, CSV (advanced)
sha ▼ | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
8cdbde0668c060265a9dd5a669f1052e97531363 | 2020-07-23T14:50:56Z | 2020-07-23T14:50:56Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
904877589de50582c721f898b84476060ca01ae2 | 2020-11-30T04:15:14Z | 2020-11-30T04:15:14Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
947dd916eda3d6f65fd9602f27f7a9bb106523d8 | 2020-06-12T17:48:33Z | 2020-06-12T17:48:33Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
9eb5cce9d887c3246a989f9177b3165ffb8adfba | 2020-10-18T22:31:17Z | 2020-10-18T22:31:17Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | 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 |
a87f9d9da5d45fe5ea2c65acdb9447c7eda2b23e | 2020-07-23T14:52:36Z | 2020-07-23T14:52:36Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
ace13ec3d98090d99bd71871c286a4a612c96a50 | 2022-07-18T19:47:17Z | 2022-07-18T19:47:17Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | 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 |
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 |
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 |
c34d5a18bfc41fa08755ba3d5cf9fe09ff204238 | 2020-04-22T01:26:57Z | 2020-04-22T01:26:57Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
c4aaa50e167cfa9021c7c94260bc3e89e10947bf | 2020-04-16T17:31:04Z | 2020-04-16T17:31:04Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
db02e87840e0b86ec35fcdfb170d7a879189adb9 | 2020-09-07T23:18:07Z | 2020-09-07T23:18:07Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | simonw 9599 | web-flow 19864447 |
dbac2e5dd8a562b45d8255a265859cf8020ca22a | 2022-07-18T19:40:11Z | 2022-07-18T19:40:11Z | カシオ 金城 大関 5706ac4cf453125159bc20ff21584abaa85d68e1 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | github-to-sqlite 207052882 | empjustine 1224205 | 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 |
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]);