commits
10 rows where "author_date" is on date 2020-04-01
This data as json, CSV (advanced)
Suggested facets: committer_date (date)
raw_committer 1 ✖
sha ▼ | author_date | committer_date | raw_author | raw_committer | repo | author | committer |
---|---|---|---|---|---|---|---|
0b8a952cd5709ac27494b1694ca95188c89442ce | 2020-04-01T04:31:23Z | 2020-04-01T04:31:23Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
19bdd23a1c81d31664c44adc543ac9c9f7692edf | 2020-04-01T04:31:05Z | 2020-04-01T04:31:05Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
32690eb7641b119030f439d1cc0fb160f379691f | 2020-04-01T04:12:54Z | 2020-04-01T04:12:54Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
4b6c8d8c1cc6fefdb566ec8506157133f47c569a | 2020-04-01T03:44:30Z | 2020-04-01T03:44:30Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
7f9eaa7bb08eb7f34911b954c9c88850d2a54b10 | 2020-04-01T04:13:33Z | 2020-04-01T04:13:33Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
824109b0707f0d352470ba4e9ec7d729250afcd3 | 2020-04-01T03:37:33Z | 2020-04-01T03:37:33Z | 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 |
aab95d1f68f84e900764ec502dad87c4940206da | 2020-04-01T03:28:58Z | 2020-04-01T03:28:58Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
c78e6ba76453e9f6461b1182599a1a6fd0535dc9 | 2020-04-01T03:17:09Z | 2020-04-01T03:17:09Z | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | Simon Willison 13ae486343ea6454a93114c6f558ffea2f2c6874 | twitter-to-sqlite 206156866 | simonw 9599 | simonw 9599 |
e2e373d2178ea76fe16fc8d07fffac8b175c2010 | 2020-04-01T04:18:17Z | 2020-04-01T04:18:17Z | 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]);