These forums have been archived and are now read-only.

The new forums are live and can be found at https://forums.eveonline.com/

EVE Information Portal

 
  • Topic is locked indefinitely.
 

CSV dump of all PVP kills between Mar 1-Apr 4

First post
Author
Seri Michele
Knights of the Protectorate
#41 - 2016-04-09 19:30:33 UTC  |  Edited by: Seri Michele
Edit: removed.
Unknown Region
Crotchety Old Farts
#42 - 2016-04-09 20:24:44 UTC
Masao Kurata wrote:
CCP Quant wrote:
Masao Kurata wrote:


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.


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.



Having thought about this for some time, this really should be considered. For the longest time it has been pounded into our heads to keep an active API key for the kill boards. "If you ever want to be recruited by a big PVP group, then you got to have a nice looking killboard!" Or just killboard bragging rights, what not. This gives me my own knee jerk reaction to blindly keep an API killboard without even thinking of the consequence. But historically, for myself, more than anything else, killboard data has been my #1 go to source for intel. Who do people fly with? what do they fit? What is there most active systems that they commonly patrol?

This prompted me to two ations.

1) Delete my own killboard api key!

2) Wonder if maybe CCP should consider a checkmark in the API section to allow your account to be included into such broad sweeping potential intel holes.

P.S.

Never suspected CCP would be the SPAIS!
Chris Hallen
V0LTA
WE FORM V0LTA
#43 - 2016-04-11 04:08:47 UTC
Things like this are why I really appreciate the development team in this game. Really looking out for what the players are doing and trying to help them. It is really fantastic to see.
Talon White
Mission Ready Mining
Fly Fearless
#44 - 2016-04-11 11:25:46 UTC  |  Edited by: Talon White
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
Mishra San
#45 - 2016-04-12 00:02:38 UTC  |  Edited by: Mishra San
the eBig **** contest just got more real(er)..

EDIT:

It's got a cop motor, a 440 cubic inch plant, it's got cop tires, cop suspensions, cop shocks. It's a model made before catalytic converters so it'll run good on regular gas. What do you say, is it the new Bluesmobile or what?
Aaron Honk
Distributed Denial of Service
#46 - 2016-04-12 12:20:19 UTC
Talon White wrote:
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...
Fifth Blade
Jump Drive Appreciation Society
#47 - 2016-04-12 12:24:32 UTC  |  Edited by: Fifth Blade
Aaron Honk wrote:
Talon White wrote:
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...


FWIW we have about 35 Active pilots @ 11th. 50-170 times more active than most of the groups on that list.
Arkon Olacar
Avalanche.
Triumvirate.
#48 - 2016-04-12 12:34:43 UTC
Talon White wrote:
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


:smug:
Willam Crane
Hoover Inc.
Pandemic Legion
#49 - 2016-04-12 12:37:03 UTC
Fifth Blade wrote:
Aaron Honk wrote:
Talon White wrote:
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...


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


Stop spreading lies. You are slowly dying in Thera.
Vision Thing Achasse
Brave Newbies Inc.
Brave Collective
#50 - 2016-04-12 13:02:46 UTC
Aaron Honk wrote:
Talon White wrote:
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...


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!!!
Lord MacAdder
Rapid Withdrawal
Pen Is Out
#51 - 2016-04-12 16:26:04 UTC  |  Edited by: Lord MacAdder
Vision Thing Achasse wrote:
Aaron Honk wrote:


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 our least active months of the year
Searly1981 Searle
Rapid Withdrawal
Pen Is Out
#52 - 2016-04-12 16:35:19 UTC
Lord MacAdder wrote:
Vision Thing Achasse wrote:
Aaron Honk wrote:


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


with 5% of the pilots that are in Pandemic Horde....
Alex Zalbazar
Fight The Blob
Kingless.
#53 - 2016-04-12 16:50:40 UTC
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.
Patrick von Matterhorn
Jump Drive Appreciation Society
#54 - 2016-04-12 22:36:37 UTC  |  Edited by: Patrick von Matterhorn
Would be fun to se kills per corp member.
Fifth Blade
Jump Drive Appreciation Society
#55 - 2016-04-12 22:43:59 UTC  |  Edited by: Fifth Blade
Alex Zalbazar wrote:
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.

Taken from someone else on reddit:

Quote:
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.

And a description of each:
Quote:

  1. PIRAT - Highsec wardeccers camping the amarr undock
  2. Faceless Ronins - N-RAEL Gatecampers
  3. CODE. - Highsec suicide ganking smartbombing catalysts
  4. Rapid Withdrawal - (lowsec - Galmil FW) small gang pvp around the Black Rise / Citadel area
  5. NOG8S - Therabois, (mostly null) small gang pvp, blops
  6. Tuskers - (lowsec) small gang pvp
  7. Waffles - Snigg feeder corp, small-mid scale (mostly lowsec) pvp, focus on activity
  8. Stimulus - Rote Kapelle, (nullsec) small gang pvp
  9. Brave Newbies - mid-scale fleets as part of the querious thunderdome
  10. Test Alliance Please Ignore - large null warfare

Talon White
Mission Ready Mining
Fly Fearless
#56 - 2016-04-18 14:49:57 UTC  |  Edited by: Talon White
Looking forward to to next data round up; we've (RvB) hit 4k kills in just 18 days!Blink
Talon White
Mission Ready Mining
Fly Fearless
#57 - 2016-05-03 16:48:49 UTC
Talon White wrote:
Looking forward to to next data round up; we've (RvB) hit 4k kills in just 18 days!Blink


;)
Talon White
Mission Ready Mining
Fly Fearless
#58 - 2016-05-11 21:51:56 UTC
CCP Quant wrote:
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.



It turned out successful, Woohooo! Can we go again with April data?

Please?
Dreamer Targaryen
KarmaFleet
Goonswarm Federation
#59 - 2016-05-15 22:43:29 UTC
I second that: getting the data for april would be nice. =)
Talon White
Mission Ready Mining
Fly Fearless
#60 - 2016-05-27 12:16:58 UTC
Dreamer Targaryen wrote:
I second that: getting the data for april would be nice. =)


Third!

The next kill dump data, please?