Thank you, especially for already joining the data with names for corps, alliances and systems.

For my fellow analysts:
Keep in mind, that the column "victimCoalition" is not an ingame-attribute and as such has to be treated as corrupted data.
An example is the following line, which lists "Circle-Of-Two" as a member of "The Imperium" in april, where in reality they left the glorious empire a week prior to that:
98261786,The Clown Shoe Crew,Circle-Of-Two,The Imperium,98343305,Run and Gun Mercenary Corps,FETID,,670,Capsule,Capsule,2016-04-03 03:06:16,30002719,Miroitem,10000032,Sinq Laison,1022826005.05,1022826005.05,204565201.01

Hey guys,

We've noticed that a bunch of players are trying to go through kill data, especially now during the war. This can be very tedious to scrape and stitch together from the killboards, so we're looking into ways to accommodate. Provided below is a link to all PVP kills made in the period Mar 1 to Apr 4, with the condition that the victim is a player character and the final blow is made by a player character. Keep in mind that the isk lost / destroyed values for supers are lower than the killboard ones since they dont have any market prices behind them for the hulls and some "exotic" modules, only base costs. You will have to adjust for that.

http://cdn1.eveonline.com/community/quant/WWB_killdump.zip

I've denormalized the data for you quite extensively, e.g. added solarSystemName, regionName, type names, and so forth. This might not be necessary but it allows people to make analysis on the data as-is without the need to join in other eve datasets.
characterIDs are also not included at this point, since we're not comfortable with including them at this point.


If this turns out successful, and only good things come out of this, we are more likely to move into a direction where we can provide kill data in bulk, be it through CSV dumps like this one (e.g. in the monthly economic report data dump) or through CREST.

Happy crunching!

nice, can we have a csv dump of POS mod contents that died between mar 1 and april 7?

Excuse me? Some people like to keep certain kills and losses secret, this is a big change in policy.

We excluded characterID for that purpose. If that is still giving away too much info we could move(from corporationID as the lowest identifier) up to allianceID, but yeah this sentiment is the reason kills aren't accessible in bulk through CREST. However, one of the biggest arguments for hiding kills has been to hide fitting, these kill logs don't show fitting. Also, it's only PVP kills where a player character kills a player character.

Personally, I think it needs something to identify individual pilots. That way we can tell how many individual pilots are involved. I think it would be very enlightening. The identifying ID needn't be the characterID available from the API, it could just be random and uniquely identifying. Admittedly, you could probably match those IDs up with a public killboard.

Okay, that was a knee jerk reaction. .

I didn't want to dance around the subject no knee jerk reaction intended! I'm biased here as If this were completely up to me I'd say we open up the killfeed in crest and the 0.1% of pilots who don't want kills shown will just have to suck it up However, and luckily for the 0.1% the decision is not solely in my hands.

I didn't want to dance around the subject no knee jerk reaction intended! I'm biased here as If this were completely up to me I'd say we open up the killfeed in crest and the 0.1% of pilots who don't want kills shown will just have to suck it up However, and luckily for the 0.1% the decision is not solely in my hands.

As I understand the conversation, he meant that he made a knee jerk reaction and actually thinks it's a good idea, now he's had time to review it further.

I'm biased here as If this were completely up to me I'd say we open up the killfeed in crest and the 0.1% of pilots who don't want kills shown will just have to suck it up However, and luckily for the 0.1% the decision is not solely in my hands.

God I would love to just open up all killmails... /me dreams

God I would love to just open up all killmails... /me dreams

I'd say we open up the killfeed in crest and the 0.1% of pilots who don't want kills shown will just have to suck it up However, and luckily for the 0.1% the decision is not solely in my hands.

I think providing intel like this is wrong in Eve. There should NOT be any intel that's absolutely accurate. Public killboards provide much of the same data in searchable form, but you can never be sure if the data is absolutely accurate. Some critical info might be missing. With a dump like this, the accuracy kills any doubt of the fog of war. CCP, please do NOT publish any data this accurate!

I like the concept in general, but one major exclusion that I would like to see is any kills in w-space systems. Much like the removal of NPC kills in w-space from the API, excluding pvp kills from any automatic database dump is very important for the security of those that live in w-space.

Completely un-sarcastically, I'm interested in what you mean by being sure if the data is accurate? Don't the KB sites just pull from API-authed CREST?

Okay, that was a knee jerk reaction. Upon actually reviewing the columns included and considering the matter, this level of data is.... mostly fine? It is possible in some cases to trivially get the kill hash from the data (when both the victim and killers are in one or two man corporations), and getting a range of possible kill ids based on the timestamp is easy, providing enough information to query public CREST for the full kill details. I imagine that if one were to run a script over the kills querying on the assumption that a CEO killed a CEO, that alone would yield many killmails previously not pushed to any killboards.

Using a pivot table we (RvB) calculated the total number of kill mails (ACTUAL KILLS) per corporation over the period of Mar 1-Apr 4.

The 'Top 30' result

1 Pandemic Horde Inc. 5896
2 Rapid Withdrawal 5168
3 G0P-ST0P 4753
4 The Conference Elite 4289
5 SniggWaffe 3644
6 KarmaFleet 3298
7 Dreddit 3223
8 Blue Republic 2625
9 The Scope 2458
10 Brave Newbies Inc. 2388
11 Jump Drive Appreciation Society 2254
12 Red Federation 2145
13 GoonWaffe 2104
14 EVE University 2000
15 Stimulus 1993
16 Kill'em all. Let Bob sort'em out. 1959
17 V0LTA 1955
18 Caldari Provisions 1929
19 Addicted To Chaos 1928
20 Sniggerdly 1897
21 The Tuskers 1894
22 Gate Is Red 1888
23 Furnace 1876
24 State Protectorate 1804
25 Brutor Tribe 1729
26 Dirt 'n' Glitter 1687
27 Faceless Ronins 1683
28 Ex Presidents. 1657
29 Beyond Frontier 1657
30 Federal Defense Union 1643

Combined; (Red versus Blue) killed 4770

It doesn't mean anything if you don't weight it with number of active pilots...

Using a pivot table we (RvB) calculated the total number of kill mails (ACTUAL KILLS) per corporation over the period of Mar 1-Apr 4.

The 'Top 30' result

11 Jump Drive Appreciation Society 2254

17 V0LTA 1955

23 Furnace 1876

FWIW we have about 35 Active pilots @ 11th. 50-170 times more active than most of the groups on that list.

It doesn't mean anything if you don't weight it with number of active pilots...

The number of actual kills doesn't matter?

To RvB it's the ONLY thing that matters! We are for the fights - not the stats. Moaar fights!!!

What he means if you have many active pilots in your corp then you can kill more, whilst the average pilot in your corp might actually kill less than corps further down the list.

P.S RDRAW number 2! In one of least active months of the year

Would you guys be willing to do this same sort of ranking list, but with weighting for number of active pilots?

Would be a closer measure of individual activity, I think.

Hi, I actually did a comparison of Kills vs. Members of the top 15 listed, here are the top ten.

1. G0P-ST0P - 4753 kills, 69 members, 68.88 kills per
2. Faceless Ronins - 1683 kills, 46 members, 36.59 kills per
3. The Conference Elite - 4289 kills, 157 members, 27.31 kills per
4. Rapid Withdrawal - 5168 kills, 205 members, 25.21 kills per
5. Jump Drive Appreciation Society - 2254 kills, 111 members, 20.31 kills per
6. The Tuskers - 1894 kills, 100 members, 18.94 kills per
7. Snigwaffe - 3644 kills, 230 members, 15.84 kills per
8. Stimulus - 1993 kills, 147 members, 13.56 kills per
9. Brave Newbies - 2388 kills, 1647 members, 1.45 kills per
10. Dreddit - 3223 kills, 2578 members, 1.25 kills per.

Looking forward to to next data round up; we've (RvB) hit 4k kills in just 18 days!

Hey guys,

If this turns out successful, and only good things come out of this, we are more likely to move into a direction where we can provide kill data in bulk, be it through CSV dumps like this one (e.g. in the monthly economic report data dump) or through CREST.

I second that: getting the data for april would be nice. =)