Army battle survivor totals

Total creatures surviving on the winning side after each army battle.

Custom SQL query returning 72 rows (hide) 

SELECT seed, rounds, (SELECT SUM(json_extract(value, '$.survivors')) FROM json_each(left_army)) AS left_survivors, (SELECT SUM(json_extract(value, '$.survivors')) FROM json_each(right_army)) AS right_survivors FROM battles_army ORDER BY rounds DESC

Edit SQL

This data as json, CSV

seedroundsleft_survivorsright_survivors
1 17 9 0
1 15 0 1
1 14 0 2
1 14 0 3
1 13 0 11
1 12 0 1
1 12 2 0
1 12 0 1
1 11 1 0
1 10 0 26
1 10 0 10
1 10 0 9
1 10 0 1
1 10 0 12
1 9 0 6
1 9 27 0
1 9 0 23
1 9 10 0
1 9 22 0
1 9 0 7
1 9 1 0
1 9 0 2
1 9 17 0
1 9 20 0
1 8 62 0
1 8 28 0
1 8 35 0
1 8 51 0
1 8 0 23
1 8 0 3
1 8 31 0
1 8 0 5
1 8 0 13
1 8 20 0
1 7 37 0
1 7 28 0
1 7 30 0
1 7 0 52
1 7 8 0
1 7 0 34
1 7 0 37
1 7 0 8
1 7 0 27
1 7 0 3
1 6 53 0
1 6 52 0
1 6 26 0
1 6 37 0
1 6 33 0
1 6 37 0
1 5 34 0
1 5 99 0
1 5 57 0
1 5 0 34
1 4 64 0
1 4 0 83
1 4 77 0
1 4 85 0
1 4 95 0
1 4 67 0
1 3 0 116
1 3 118 0
1 3 117 0
1 3 139 0
1 3 96 0
1 3 67 0
1 3 127 0
1 3 102 0
1 3 97 0
1 3 110 0
1 3 98 0
1 2 157 0