home / h3_units

Menu
  • Open in marimo
  • llms.txt

1-v-1 upset victories

Battles where the side with fewer creatures still won.

Custom SQL query returning 35 rows (hide)

SELECT seed, left_name, left_count, right_name, right_count, winner, rounds, winner_survivors FROM battles_1v1 WHERE (winner = 'left' AND left_count < right_count) OR (winner = 'right' AND right_count < left_count) ORDER BY rounds DESC

Edit SQL

This data as json, CSV

seedleft_nameleft_countright_nameright_countwinnerroundswinner_survivors
1 Gnoll 36 Goblin 45 left 5 10
1 Gremlin 48 Imp 45 right 5 12
1 Pixie 60 Skeleton 36 right 5 4
1 Halberdier 42 Master Gremlin 48 left 5 14
1 Gnoll 36 Gremlin 48 left 4 16
1 Gnoll 36 Imp 45 left 4 18
1 Gnoll 36 Pixie 60 left 4 12
1 Goblin 45 Gremlin 48 left 4 24
1 Gremlin 48 Skeleton 36 right 4 22
1 Imp 45 Skeleton 36 right 4 15
1 Imp 45 Troglodyte 42 right 4 19
1 Pixie 60 Troglodyte 42 right 4 10
1 Familiar 45 Master Gremlin 48 left 4 17
1 Gnoll Marauder 36 Hobgoblin 45 left 4 15
1 Gnoll Marauder 36 Infernal Troglodyte 42 left 4 9
1 Hobgoblin 45 Master Gremlin 48 left 4 25
1 Hobgoblin 45 Skeleton Warrior 36 right 4 12
1 Centaur 42 Goblin 45 left 3 34
1 Goblin 45 Pikeman 42 right 3 32
1 Gremlin 48 Pikeman 42 right 3 35
1 Gremlin 48 Troglodyte 42 right 3 26
1 Imp 45 Pikeman 42 right 3 33
1 Pikeman 42 Pixie 60 left 3 32
1 Familiar 45 Gnoll Marauder 36 right 3 20
1 Familiar 45 Infernal Troglodyte 42 right 3 25
1 Familiar 45 Skeleton Warrior 36 right 3 18
1 Halberdier 42 Hobgoblin 45 left 3 35
1 Hobgoblin 45 Infernal Troglodyte 42 right 3 22
1 Centaur 42 Gremlin 48 left 2 35
1 Centaur 42 Imp 45 left 2 37
1 Centaur 42 Pixie 60 left 2 26
1 Centaur Captain 42 Familiar 45 left 2 40
1 Centaur Captain 42 Hobgoblin 45 left 2 39
1 Centaur Captain 42 Master Gremlin 48 left 2 35
1 Familiar 45 Halberdier 42 right 2 36
Powered by Datasette · Queries took 0.949ms