contributors

Table actions

4 rows where repo_id = 206156866

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: contributions

Link repo_id user_id contributions
206156866,9599 twitter-to-sqlite 206156866 simonw 9599 128
206156866,21148 twitter-to-sqlite 206156866 jacobian 21148 1
206156866,42904 twitter-to-sqlite 206156866 rubenv 42904 1
206156866,370930 twitter-to-sqlite 206156866 mikepqr 370930 1

Advanced export

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

CSV options: 

CREATE TABLE [contributors] (
   [repo_id] INTEGER REFERENCES [repos]([id]),
   [user_id] INTEGER REFERENCES [users]([id]),
   [contributions] INTEGER,
   PRIMARY KEY ([repo_id], [user_id])
);
CREATE INDEX [idx_contributors_user_id]
                ON [contributors] ([user_id]);
CREATE INDEX [idx_contributors_repo_id]
                ON [contributors] ([repo_id]);