commits
1 row where "author_date" is on date 2018-04-14 and message = "Don't attempt to deploy new tags to PyPI This isn't working through Travis at the moment, so I'm disabling it and switching back to manual deploys."
This data as json, CSV (advanced)
Suggested facets: committer_date (date)
sha ▼ | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
932e0a3f91e4cee92b0e30c528300ec1d348d26c | 2018-04-14T15:21:37Z | 2018-04-14T15:21:37Z | Simon Willison 2946d096d0cdefdc017559e6b57e87658736e843 | GitHub cd792325681cbad9f663f2879d8b69f1edbb678f | datasette 107914493 | 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]);