The EVE Online Monthly Economic Report includes a data dump of all the ships destroyed in that month, which is usually a data set I am too lazy to start digging through. I tend to be satisfied with the ISK totals, which ran between 36.92 trillion and 38.8 trillion ISK in December, depending on which numbers you tally up.
I could work up the formulas in Excel if I put my mind to it. COUNTIF is my friend. But I generally don’t care enough. But this month I was playing around with Tableau, a data analysis tool, for work and wondered if it would sort things out for me… take that csv file and organize some nice summaries. And, sure enough, it did. I needed to poke at it for about 15 minutes to figure out what I was doing, but I managed to get it to cough up some data.
So I thought I would start with something easy. How many ships and structures were destroyed in December?
415,796. That is the total number.
Of course, 112,341 of those were capsules, which hardly count. I mean, sure, some of them are expensive, full of implants and such. But most are just the normal, 10K ISK a pop default units.
I remain glad that CCP got rid of capsule upgrades.
Likewise, there were 23,822 corvette losses, most of which were freebies and hardly worth accounting for.
So that leaves 279,633 ships, deployables, or structures that were blown up.
The top 20 destroyed, leaving out capsules and corvettes, were:
Frigate 71,295 25.50% Cruiser 35,162 12.57% Destroyer 32,535 11.63% Shuttle 15,881 5.68% Combat Battlecruiser 13,212 4.72% Mobile Tractor Unit 10,047 3.59% Heavy Assault Cruiser 10,020 3.58% Battleship 7,765 2.78% Hauler 7,749 2.77% Interdictor 7,600 2.72% Interceptor 6,638 2.37% Assault Frigate 5,296 1.89% Tactical Destroyer 4,261 1.52% Mining Barge 4,092 1.46% Strategic Cruiser 4,067 1.45% Stealth Bomber 3,907 1.40% Covert Ops 3,749 1.34% Mobile Warp Disruptor 3,505 1.25% Marauder 3,262 1.17% Expedition Frigate 3,176 1.14%
Those total up to 253,219 ships or deployables blown up, or 91% of the total for December.
More than a quarter were frigates, which is no surprise I am sure. Cruisers and destroyers add up to close to that number as well. Down a couple more are mobile tractor units, beloved of ratters and mission runners, little deployables that haul in and loot all the wrecks in the site you are running. There are players who just target those. I did a bit of MTU hunting back in the day myself.
I suppose the only surprise in the top 20 is marauders. Those are expensive, but being T2 battleships, with T2 materials depressed, I suppose they are that much more expensive than their T1 brethren anymore.
As for individual hull types lost, the top ten were:
Venture 11,277 4.03% Mobile Tractor Unit 9,624 3.44% Heron 8,464 3.03% Caracal 6,138 2.20% Caldari Shuttle 5,232 1.87% Ishtar 5,217 1.87% Thrasher 4,813 1.72% Stabber 4,387 1.57% Tristan 4,271 1.53% Vexor 4,064 1.45%
Ventures are mining frigates, so count in that 71K frigate losses above. But 1 in 7 of those were a Venture.
When it comes to capital ships, these were the losses in December:
Dreadnought 351 Freighter 156 Carrier 143 Force Auxiliary 88 Capital Industrial Ship 67 Jump Freighter 26 Supercarrier 20 Titan 6
That is a few dreadnoughts. Not exactly war time numbers otherwise, but there wasn’t much in the way of wars going on for most of December.
For structures the numbers were:
Customs Office 926 Athanor 272 Astrahus 193 Raitaru 106 Ansiblex Jump Gate 46 Fortizar 29 Tatara 9 Tenebrex Cyno Jammer 6 'Marginis' Fortizar 1 'Horizon' Fortizar 1
I went to the individual named list for those. A couple of unreplaceable legacy station Fortizars on that list.
Then I was sort of interested in where things were being blown up. We get the regional summary in the MER, but which systems were the most dangerous in December? Here are the top 20 for total hull losses.
Jita 10,597 Deepari 8,615 Tama 6,758 Aldranette 6,435 Ahbazon 5,512 Kourmonen 5,302 Miroitem 4,868 4-HWWF 4,607 Sujarento 4,371 Nagamanen 4,184 F-NMX6 3,987 Oicx 3,863 Huola 3,661 J111011 3,272 Aunenen 3,251 Hasmijaala 3,244 Kamela 3,168 H-PA29 3,104 Uitra 2,792
I guess Jita is no surprise. More people hang out there than any other system, and more people mean more kills. It is also where war dec kill crews hang out, waiting for unwary war targets to undock.
But hull losses are not the only measure, so I pulled out the top 20 system based on value destroyed.
Jita 655,792,417,291 Tama 299,788,005,609 H-PA29 261,607,799,598 Ahbazon 260,759,437,592 1DQ1-A 229,569,075,143 4-HWWF 218,299,175,054 Miroitem 203,325,454,675 TA3T-3 198,160,439,834 F-NMX6 188,624,728,769 Kourmonen 153,194,897,181 Aunenen 149,169,376,918 Aldranette 145,006,331,232 J111011 143,186,537,391 Sivala 137,777,830,149 Kinakka 135,049,636,379 J125101 131,145,192,638 Egmar 126,026,434,303 F7C-H0 111,313,563,703 Misaba 111,206,036,052 MJ-5F9 108,637,603,996
Jita remained on top, but H-PA29 rose up the ranks. I was there for that battle back in December. And coming to 1DQ1-A in Delve is a hazard it seems.
The total of destruction in that data set only adds up to 26.55 trillion ISK, so once again the numbers in the MER data don’t match up. But it is the only data we’re going to get I suppose.
Anyway, that kept me amused last night, so I thought I would make a blog post about it. If you are interested in the data you can, of course, find it all in the download data package for the MER. But I exported the discreet data sets I referenced above into comma separated text files (.txt extension, because WP.com doesn’t like .csv files), so if you want a closer look into that you can find them linked below.
Addendum – I had to move those files to pastebin because WP.com was only letting people access them if they were logged into the domain.