commits

Table actions

2 rows where author = 9097307, raw_committer = "279c587273ec459ffb5192e60bf8447c05601fa5" and repo = 13221727 sorted by author_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: author_date (date), committer_date (date)

repo 1

  • xarray · 2 ✖

author 1

  • brian-rose · 2 ✖
sha message author_date ▲ committer_date raw_author raw_committer repo author committer
96e57d00c1a7060f571befa708406146a7257fb5 Fix typo in docstring (#3474) 2019-10-31T14:28:15Z 2019-10-31T14:28:15Z Brian Rose 5219fc118b6532645cbdc2e7a2fa2aab34ed62d6 Maximilian Roos 279c587273ec459ffb5192e60bf8447c05601fa5 xarray 13221727 brian-rose 9097307 max-sixty 5635139
b87b684b36cf5adbe4dca208aed0c69c44fc44c4 Fix spelling -- change recieved to received (#2367) 2018-08-14T18:44:21Z 2018-08-14T18:44:21Z Brian Rose 5219fc118b6532645cbdc2e7a2fa2aab34ed62d6 Maximilian Roos 279c587273ec459ffb5192e60bf8447c05601fa5 xarray 13221727 brian-rose 9097307 max-sixty 5635139

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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]);