Once again I am playing with data analytics tools… Microsoft Power BI now since, as I noted in my post about the MER, I couldn’t justify a Tableau license at work… and so I went digging into the kill_dump.csv file again. That file, which comes with the MER, lists out all the kills CCP recorded for the month.
I did this for the December data as well, but later realized I made a mistake. I did not discern the difference between the ISK destroyed and ISK lost data and reported on the former as if it were the later. I believe destroyed is what is taken out of the game. That is always the hull and some, but not all, of the modules and cargo. ISK lost looks to be what the value taken from the person whose ship or structure was destroyed.
So the total value lost was 41 trillion ISK in value, which lines up with the MER for January, or at least the total from the produced, destroyed, mined chart data. The regional data shows a bit more, which is odd because doesn’t include WH space. Once again, different data from different sources.
The total destroyed was 30 trillion ISK in value, so the loot fairy granted about 11 trillion ISK in drops in January.
Oddly, going back to the MER and the regional stats, the kill file tells a different tale. The MER regional data gave the following for the top ten regions for destruction:
- The Forge – 2.04 trillion 4.99% (Caldari High Sec)
- Lonetrek – 1.78 trillion 4.36% (Caldari High Sec)
- The Citadel – 1.67 trillion 4.10% (Caldari High Sec)
- Syndicate – 1.58 trillion 3.88% (NPC Null Sec)
- Pure Blind – 1.57 trillion 3.83% (B2 Coalition)
- Delve – 1.54 trillion 3.77% (Imperium)
- Sinq Laison – 1.31 trillion 3.21% (Gallente High Sec)
- Vale of the Silent – 1.30 trillion 3.17% (Fraternity)
- Metropolis – 1.27 trillion 3.11% (Minmatar High Sec)
- Tenerifis – 1.26 trillion 3.08% (FI.RE)
However, the kill data sorts the top ten for ISK lost as:
- Syndicate – 1.54 trillion
- The Forge – 1.53 trillion
- Pure Blind – 1.52 trillion
- The Citadel – 1.37 trillion
- Tenerifis – 1.21 trillion
- Vale of the Silent – 1.15 trillion
- Insmother – 1.15 trillion
- Perrigen Falls – 1.13 trillion
- Delve – 1.13 trillion
- Genesis – 1.06 trillion
This leads me to make another assumption, that possibly the kill_dump is only PvP destruction. I certainly don’t seen CONCORD on the list of corporations with kills. Then again, I do see Vigilant Tyrannos, which are wormhole and abyssal NPCs, so I am not sure what to think. They are on the list for 827 billion ISK in kills. I hate when the data raises more questions than it answers.
Anyway, the numbers are different and I am just going to roll with that.
Still, we know why Syndicate is at the top of the kill dump list. That is where FI.RE got caught in its move ops to the northwest of null sec to join B2 coalition. Sorting out value lost by system shows that very clearly. Here are the top ten systems with the most destruction by value lost:
- KFR-ZE – 1.11 trillion
- Jita – .76 trillion
- Ahbazon – .75 trillion
- Q-5211 – .71 trillion
- MJ-5F9 – .38 trillion
- RH0-EG – .35 trillion
- Miroitem – .28 trillion
- J-RXYN – .26 trillion
- J-ZYSZ – .25 trillion
- Gheth – .25 trillion
You can see on the move op route map that is where FI.RE took a big hit. The battle report listed 850 billion ISK lost for that one ambush alone, and I am sure there were more stragglers killed along the way.
When I turn the data to just look at raw number of kills per system, the top ten are:
- Deepari – 12,805
- Jita – 9,729
- Ahbazon – 9,499
- Auga – 6,879
- Aldranette – 6,455
- Nagamanen – 5,686
- Tama – 5,247
- Miroitem – 5,222
- MJ-5F9 – 4,878
- Sujarento – 4,557
I kind of expected Jita to be at the top, but now I wonder what the hell is going on in Deepari?
Digging into the data, 12,799 of those losses were corvettes. Is somebody staging newbie ship battles in there? It was second on the list last month, so clearly something happens there.
This is why I don’t include corvettes or capsules in some of my stats… though only 2 capsules were lost in Deepari.
Jita, second on the list, is a little more diverse. The top ten ship groups lost there in January were:
- Shuttle – 2,881
- Capsule – 2,577
- Frigate – 1,089
- Corvette – 965
- Destroyer – 509
- Attack Battlecruiser – 469
- Hauler – 245
- Blockade Runner – 237
- Cruiser – 170
- Combat Battlecruiser – 116
People think they can move through hostiles in a shuttle learn the hard way that there is no safety once you undock.
Overall there were 425,629 kills recorded in the kill dump for January.
Of those, 115,904 were capsules and another 27,221 were corvettes.
Excluding those two gives us a total of 282,504 losses, with the top 20 ship groups being:
- Frigate 69,831
- Cruiser 32,777
- Destroyer 32,330
- Shuttle 20,005
- Combat Battlecruiser 14,423
- Mobile Tractor Unit 10,741
- Heavy Assault Cruiser 9,913
- Hauler 8,847
- Interdictor – 7,464
- Interceptor – 7,387
- Battleship – 6,990
- Assault Frigate – 5,623
- Tactical Destroyer – 4,488
- Strategic Cruiser – 4,145
- Stealth Bomber – 3,935
- Mining Barge – 3,895
- Mobile Warp Disruptor – 3,740
- Covert Ops – 3,205
- Force Recon Ship – 2,479
- Marauder – 2,385
When we get down to specific hulls, the top 20 losses by total count were:
- Venture – 12,318
- Mobile Tractor Unit – 10,215
- Caldari Shuttle – 7,765
- Heron – 7,030
- Caracal – 5,445
- Ishtar – 5,306
- Thrasher – 4,962
- Amarr Shuttle – 4,441
- Catalyst – 4,202
- Sabre – 4,171
- Tristan – 4,166
- Vexor – 4,101
- Gallente Shuttle – 3,991
- Merlin – 3,413
- Cormorant – 3,391
- Punisher – 3,383
- Rifter – 3,370
- Atron – 3,035
- Algos – 2,942
- Minmatar Shuttle – 2,734
Ventures continue to top the list while MTU hunters are still very active.
Meanwhile, capital losses, which totalled up to just shy of 7 trillion ISK in losses, saw the following types destroyed:
- Dreadnought – 516
- Freighter – 198
- Carrier – 141
- Force Auxiliary – 90
- Capital Industrial Ship – 47
- Supercarrier – 44
- Jump Freighter – 41
- Titan – 12
- Dreadnought – 11
I’m guessing that the second Dreadnought entry might be faction dreads.
Over a trillion of the capital ship losses, including 7 of the titans, were part of FI.RE’s losses in KFR-ZE, and 3 more of the titans lost were their’s in other systems along the way.
So it goes. Another month goes by.
Related:
Deepari and beginners systems lost twoships in the tutorial / career agents
LikeLike
@inactiveseller – But does this mean new players roll Amarr more than other empires… or that bots favor it? It still stands out.
Also, if there is some particular stat or list you want to see, I’ll do requests.
LikeLike