matches

3 rows where rt1 = "GlueGunner", rt2 = "MonkeyAce" and rt3 = "MonkeyBuccaneer"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: playerLeftWin, lt3, rHero

match_id ▼ map playerLeftWin lHero lt1 lt2 lt3 rHero rt1 rt2 rt3 duration endRound
9bbf158ec296fbb81843eb4a5e79e577c60514a29e10d8523f02b68a58ce sun_palace 0 Gwendolin_Science GlueGunner MonkeyVillage NinjaMonkey Etienne GlueGunner MonkeyAce MonkeyBuccaneer 507 21
9bbf158ec296fbb81945eb4b5979e77fc60415a29e10d8523c06b88a53ce basalt_columns 1 Adora_Fateweaver DartMonkey SniperMonkey SpikeFactory Etienne GlueGunner MonkeyAce MonkeyBuccaneer 267 11
9bbf158ec296fbb81a47eb495d79e47ec6071ca29e10d8523d11ad8c55d9 ports 0 Etienne BananaFarm MonkeyAce SpikeFactory Jericho GlueGunner MonkeyAce MonkeyBuccaneer 164 5

Advanced export

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

CSV options: 

CREATE TABLE matches (
            match_id CHAR(60) PRIMARY KEY,
            map TEXT,
            playerLeftWin BOOLEAN,
            lHero TEXT,
            lt1 TEXT,
            lt2 TEXT,
            lt3 TEXT,
            rHero TEXT,
            rt1 TEXT,
            rt2 TEXT,
            rt3 TEXT,
            duration INT,
            endRound INT
        );