Notable Partnerships

1 row where player2_id = 11

✎ View and edit SQL

This data as json, CSV (advanced)

id ▼ season wicket runs player1_id player1_runs player2_id player2_runs opponent competition all_time_record
1 2025 1 53 S. Ratnayake 46 49 H. Deshmukh 11 21 Blade Warriors NYCL-T20 0

Advanced export

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

CSV options: 

CREATE TABLE partnerships (
        id              INTEGER PRIMARY KEY AUTOINCREMENT,
        season          INTEGER NOT NULL,
        wicket          INTEGER,
        runs            INTEGER,
        player1_id      INTEGER REFERENCES players(id),
        player1_runs    TEXT,
        player2_id      INTEGER REFERENCES players(id),
        player2_runs    TEXT,
        opponent        TEXT,
        competition     TEXT,
        all_time_record INTEGER DEFAULT 0  -- 1 if noted as all-time record
    );