commits
247 rows where raw_committer = "2946d096d0cdefdc017559e6b57e87658736e843" sorted by message
This data as json, CSV (advanced)
sha | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
084350b0f1343d988928cae63cfedbeb6205e25e | 2017-11-17T14:53:37Z | 2017-11-17T14:53:37Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
22851ed9f0541904f5c3fca7ddbd7add10a75d39 | 2017-11-12T21:16:59Z | 2017-11-12T21:16:59Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
1b04662585ea1539014bfbd616a8112b650d5699 | 2017-11-18T03:09:32Z | 2017-11-18T03:15:49Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
0b8c1b0a6da9cb8ac0d28cc90dd783de87554036 | 2017-11-15T02:41:03Z | 2017-11-15T02:43:34Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
8acdc2fd14c0f7251e1e3fd592c53b3152f5256c | 2017-11-12T20:08:32Z | 2017-11-12T20:08:32Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
ed78922ae38b51513319b60ac39990b7c2aca810 | 2018-12-16T21:32:55Z | 2018-12-16T21:32:55Z | Jay Graves 6410ac01839c113476668eeff88d60a0a2c6eb7a | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | jaywgraves 418191 | simonw 9599 |
29f9a29250169cdb564020109f76e0f4b52afa5d | 2018-04-08T23:13:52Z | 2018-04-09T05:10:22Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
82261a638bd35c9d69a9582a898cf4dab374f76c | 2017-11-16T01:59:42Z | 2017-11-16T01:59:42Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
70e1f831a00ec97b724187025e35338becd2309a | 2018-08-01T01:32:03Z | 2018-08-01T01:32:03Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
858d79fe938afbe04e2b249da71860e812869ec8 | 2018-05-16T15:15:56Z | 2018-05-16T15:27:24Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
3cce63b59851495b6d9d38936356e21ea8fbad3a | 2017-10-25T15:19:32Z | 2017-10-25T15:19:32Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
8a0bd68c393423a6c3bdae27d3826e6161a101c1 | 2018-05-15T13:23:20Z | 2018-05-16T15:27:24Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
3c50a3600d0975b84d98c93bb2336a790afc6aca | 2018-07-28T14:29:20Z | 2018-07-28T14:29:20Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
9e8c36793bfbb17c2f67371cc7f9aa8b9202fdc4 | 2019-03-15T05:06:45Z | 2019-03-15T05:06:45Z | joelondon 41e868c44ebf155cd4e69182c407f1d278d635ce | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | joelondon 28597217 | simonw 9599 |
e06b0117711ca7c9d6d6865d2bff8525aa11ebf0 | 2017-11-10T18:43:54Z | 2017-11-10T18:43:54Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
d1209a2c453311432dcc41966a81a39d895e9fae | 2018-08-13T00:33:13Z | 2018-08-13T00:33:13Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
a892f9a0bd6667c1ad4c590016d6845cd98a645a | 2018-05-15T15:00:39Z | 2018-05-16T15:27:24Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
d9fa2bf7ba2f9d3dcb2beb303f772c86344b4bcf | 2017-11-09T14:39:50Z | 2017-11-09T14:39:50Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
cf1fe693e5741035df65cc9d69c4af32befd021d | 2018-05-13T12:58:28Z | 2018-05-14T03:04:23Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
5928c11ee798a232aa4096706cd47e639d1c9fc2 | 2017-11-14T00:45:23Z | 2017-11-14T00:45:23Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
b0f3d4e375655f0764f3137dbcede324f9bbc0cb | 2017-11-14T01:48:22Z | 2017-11-14T01:48:22Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
db3fa4abfac366184e97fb313b36d3429e5b937a | 2017-11-12T21:29:26Z | 2017-11-12T21:29:26Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
ff2ab9dc7d82f70daae10f5b0cde87d74704f910 | 2017-11-12T20:31:46Z | 2017-11-12T20:32:25Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
f4943ca89bf400350205788f9130c135aaf7b85b | 2018-05-15T10:28:48Z | 2018-05-16T15:27:24Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
f3a3820ff5c5ba9b4af102e65ed1f084b1fe704d | 2018-04-09T00:06:10Z | 2018-04-09T05:10:22Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
a82175276c3f5898161c7630f669d0b8990d7a16 | 2018-05-15T09:34:45Z | 2018-05-16T15:27:24Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
ed2b3f25beac720f14869350baacc5f62b065194 | 2017-11-17T13:29:22Z | 2017-11-17T13:29:22Z | Ray N 19245be93da11be3d5e72991646660a06a9d3449 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | raynae 3433657 | simonw 9599 |
f643f7aee1b3d29df82b93a6560887a35b7a2f13 | 2017-10-24T14:58:41Z | 2017-10-24T14:58:41Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
62f1d3a6cbf7fca5c0e85c13a77830755c314883 | 2018-05-16T05:08:58Z | 2018-05-16T15:27:24Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
ff2fb573cd8773206a6df83229620928056e2ee2 | 2017-11-13T02:12:21Z | 2017-11-13T02:12:21Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
4c66097d581c3970a23530598c4fe98b09f422ee | 2017-11-12T23:16:24Z | 2017-11-12T23:16:24Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
f4907f6df58d822dfb67660b982a9081b39a06fb | 2018-07-31T16:19:05Z | 2018-07-31T16:19:20Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
6a0c5de6154893eb4269dc7b1f160726ec6395f2 | 2017-10-23T16:02:40Z | 2017-10-23T16:02:40Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
bc9871c93583f3cdcca191b7fa05b255be7275c8 | 2017-11-09T16:09:55Z | 2017-11-09T16:09:55Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
446d47fdb005b3776bc06ad8d1f44b01fc2e938b | 2018-04-03T15:24:04Z | 2018-04-03T15:24:04Z | Ryan Pitts daa0836007170071f748b575d34c4432f4f43926 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | ryanpitts 56477 | simonw 9599 |
2b79f2bdeb1efa86e0756e741292d625f91cb93d | 2018-05-14T03:02:07Z | 2018-05-14T03:04:23Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
8a4ed052a5034d3f12daf5eedabb0808a0bf20fc | 2018-05-14T22:09:09Z | 2018-05-16T15:27:24Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
3863a30b5d18204b4c77518f1880a1f705e929db | 2017-11-11T16:00:00Z | 2017-11-11T16:00:00Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
20d41c8e8e84ab3e8bdb5cca9bd9799da09794ad | 2017-11-13T18:40:51Z | 2017-11-13T18:40:51Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
606ff9e35e007ae58a491d417f47779034bacabc | 2017-10-24T05:53:13Z | 2017-10-24T05:53:13Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
be768f26d09fa060b1ca71785ff546dd572f3fbc | 2017-11-04T23:40:27Z | 2017-11-04T23:40:27Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
3ef35ca8b4369af6a8bcdd9e5cfbb5f3a7d17cf8 | 2017-11-13T15:20:02Z | 2017-11-13T15:20:02Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
f571b19d8a5fd3a19fdf679421fd55a8edbf5295 | 2017-10-23T15:28:00Z | 2017-10-23T15:28:00Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
b69f8b6c856adff577fe6a1816359bb00e82ffd1 | 2018-07-31T03:24:35Z | 2018-07-31T03:24:35Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
4427d2d96f7197e25acee85643bcf02e758b8b1e | 2018-08-01T15:20:44Z | 2018-08-01T15:20:44Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | sqlite-utils 140912432 | simonw 9599 | simonw 9599 |
e55bc3b2fa6e1e8be7b7c1f5b6cb3764713b6faa | 2017-10-25T14:46:38Z | 2017-10-25T14:46:38Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | simonw 9599 | simonw 9599 |
fe279ab7b4ae99dab295d5cf4d39ad06d782997e | 2017-11-13T21:17:34Z | 2017-11-13T21:17:34Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | datasette 107914493 | 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]);