commits
132 rows where repo = 206156866 sorted by message descending
This data as json, CSV (advanced)
sha | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
801c0c2daf17d8abce9dcb5d8d610410e7e25dbe | 2019-11-04T05:31:10Z | 2019-11-04T05:31:10Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
7275abb5573f00e1ea60707cfe243346a6e0ece6 | 2019-10-30T02:19:23Z | 2019-10-30T02:19:23Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
35c18a09fa664324dcb75e5e58ccb90644456d02 | 2020-02-07T07:03:22Z | 2020-02-07T07:03:22Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
cfd977e97f82ece49c850fbed3d8778149a59c7d | 2019-10-06T04:48:23Z | 2019-10-06T04:48:23Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
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 |
b6a4da8be3b6d4b74c6a5fac8924bf22a6824f2c | 2021-08-20T00:02:10Z | 2021-08-20T00:02:10Z | Mike Lee Williams 216dbfd3bd82e49cf8d12e9f574d76f408f2f0d6 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | twitter-to-sqlite 206156866 | mikepqr 370930 | web-flow 19864447 |
98729fd80a7b3f16d82752c6972c8d96c2f2f959 | 2020-03-20T20:16:28Z | 2020-03-20T20:16:28Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
bd26f356649ebe0a98cd11e8992a531ec3bc66c8 | 2019-09-13T20:32:52Z | 2019-09-13T20:32:52Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | twitter-to-sqlite 206156866 | simonw 9599 | web-flow 19864447 |
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 |
8585efbecda055d62d2357bc3cee040dd3c3e0f3 | 2020-04-01T00:31:01Z | 2020-04-01T00:31:01Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
506c9d5e8e659b46e2f544bf476a96047feed402 | 2019-09-04T20:00:10Z | 2019-09-04T20:00:10Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
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 |
b03674cc30991439c5320148a4a32de674f2896c | 2020-03-20T22:36:46Z | 2020-03-20T22:36:46Z | 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 |
73947d50115257b15e4a687ddf41cbf60ba942cb | 2020-04-17T23:43:35Z | 2020-04-17T23:43:35Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
dd2b02304274a5b44f7dd37cddb61a4978848d1e | 2019-10-28T12:33:41Z | 2019-10-28T12:33:41Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | twitter-to-sqlite 206156866 | simonw 9599 | web-flow 19864447 |
d22afae39b1390964dace33f43a8f86c222876fe | 2019-10-11T16:54:25Z | 2019-10-11T16:54:25Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
c1340a15bbd2fced600e5e72626cf42d93b3f789 | 2019-09-04T16:13:21Z | 2019-09-04T16:13:21Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
656c970d8b7d0744f1bb5743767fc5b34b62b90e | 2019-09-04T20:01:12Z | 2019-09-04T20:01:12Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
47f474c0fb76c53bdf46aefcb3ca9669e676f932 | 2019-09-03T21:31:58Z | 2019-09-03T21:31:58Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | twitter-to-sqlite 206156866 | simonw 9599 | web-flow 19864447 |
9fa0f564486c416456a88c277df2f16b86739c73 | 2019-09-09T22:44:33Z | 2019-09-09T22:44:33Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
a1d547132356501d3d19c99d0f2e6c8108c53981 | 2019-09-09T22:39:41Z | 2019-09-09T22:39:41Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
4c0977fc5d091d3c31102000a7312f28d07cdd5b | 2019-09-03T22:42:06Z | 2019-09-03T22:42:06Z | 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 |
8c710517e6edf68b1d9bcb5873063d341524c6f5 | 2020-04-30T18:28:31Z | 2020-04-30T18:28:31Z | 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 |
4f86a46b1e6ef4d02d72fd2241850039f41fd8a8 | 2019-11-04T05:30:58Z | 2019-11-04T05:30:58Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
674dcc0d19c1398203c0efffddef43919ee04a09 | 2019-11-09T20:11:41Z | 2019-11-09T20:11:41Z | 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 |
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 |
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 |
3e21277c76b86b54fb5cc8dd41a3eb14b6164947 | 2019-09-08T21:24:27Z | 2019-09-08T21:24:27Z | 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]);