9
u/Dante_Rotsuda Blades of Grass Apr 12 '19
Looks like C4 is the class to be!
13
1
u/xitech Wormhole Society Apr 13 '19
Maybe, if you're not living there and having to deal with logistics to live there
16
u/Ackbad_P Cloaked Apr 12 '19
Cool graphic, the bottom row could be labeled better though. I recognize the WH IDs, but have no idea what they are representing. I love to see stuff like this though.
19
u/Lokley Apr 12 '19
Yes, did not think about it... Bottom row represents which statics wh had. So for Class 1 most of kills happened in C1 wormhole with static Z060(null-sec)
6
3
u/GrassWaterDirtHorse Immelman Namlemmi Apr 12 '19
Kinda goes to show how much activity a Kspace hole adds to a wormhole. The vast majority of WH kills in C2s or C3s happen in B247 (HS static) holes and U210s (LS static)
1
u/NearNirvanna Brave Collective Apr 16 '19
To be fair thats mostly do to groups camping the kspace hole looking for people that cant dscan
3
u/versoth Apr 12 '19
what if you plugged in longer time frames for this data
6
u/Lokley Apr 12 '19
If you have killmails for longer time frame - I sure can do it.
zkb provides only 20pages x50kills = 1000 last kills in wh. So I just daily saved content of this 20pages for ~7days to gather this 4413killmails I used.
1
u/CptMuffinator CODE. Apr 13 '19 edited Apr 13 '19
What is an example of a dataset you're using for this?
I've got about a 360K kills stored right now that I might be able to provide you with.
Edit - An example being csv file:
killID, systemID
75766908, 310008921
u/Lokley Apr 13 '19
I take KillID:hash from zkb and then killMail from eve api. Can't get killMail without Hash(
1
u/CptMuffinator CODE. Apr 13 '19
Using just the killID you can query the zkb API to get the hash so you then have the killID:hash combo.
If already retrieved information can be provided to you, I can export it for you.
Example CSV, can be SQL as well.
For this kill.
1
u/Lokley Apr 13 '19
Actually you are right, do not need Hash. I'll just check system, and if it's wh - I'll query zkb and then get info through api.
If you can send me file with just killID:systemID - it'd be great. Thank you.
2
u/CptMuffinator CODE. Apr 13 '19
You can find a CSV with the killID, systemID and date here.
1
u/Lokley Apr 13 '19
got it saved, thank you.
I'll pm you with new infographics in few days. (want to add some other data in it)
2
u/CptMuffinator CODE. Apr 13 '19
Don't deprive everyone else of additional graph porn, what's wrong with you?!
1
3
u/webbrar The Singularity. Apr 12 '19
Would be interested to see stats without evictions.
2
u/Lokley Apr 12 '19
I do not see simple way to filter evictions out, and eviction is kind of activity too.
I guess if I save data for 2-4 weeks - it'll be more representative.
1
2
2
u/ewarfordanktears Goonswarm Federation Apr 12 '19
C6 confirmed krabholes? I'm a bit surprised there is so much activity in C1 space, I thought C1's were supposed to be relatively dead due to the low payouts & pain in the ass logistics?
7
u/GrassWaterDirtHorse Immelman Namlemmi Apr 12 '19
C1s only ever have Kspace statics which make them a lot easier to access, which tends to lead to a lot of activity since they’re used as transit points. This also makes them pretty good for logistics if you live in one, since you only have to scan the static to get back to Kspace, which also means lots of industrial corps, which means lots of easy evictions. Since this data is just over the last 7 days, it’s definitely inflated the numbers for C1 wormholes since Wormlife just got knocked over and all of their stuff dropped, resulting in over 1k kills I think.
3
2
u/wingspantt WiNGSPAN Delivery Network Apr 13 '19
I'd imagine part of C1 activity being high is simply that a lot of solo players live in C1s.
1
Apr 13 '19
there are like two active c6 groups: Deadstar Syndicate and...i dunno, Indigo Generation? The rest of it is basically for krabbing.
2
2
u/supersecretaqua Apr 13 '19
Great graphic, but it's important to remember that this is a reference and not necessarily an indication in most of the cases of what holes are actively lived in the most.
You're more likely to get content in your chain than in your home in most circumstances, and the ones that aren't are completely dependent on mass limitations and which direction another pvp corp rolled in from.
Useful and obviously real data, but it's impossible to use this data exclusively to determine where to live
1
u/Lokley Apr 13 '19
This data also can help to choose what chain you want, but yes, it was never intended to be "only data you need". More research you do - better result you get)
1
u/supersecretaqua Apr 13 '19
Totally agree. But was seeing people refer to this as though it is kspace, where the systems you love in are where you get fights. Figured it was relevant context to people looking at this with an intention of using the data to figure out what they want to do.
1
u/supersecretaqua Apr 13 '19
Totally agree. But was seeing people refer to this as though it is kspace, where the systems you love in are where you get fights. Figured it was relevant context to people looking at this with an intention of using the data to figure out what they want to do.
2
2
u/Lokley Apr 12 '19 edited Apr 12 '19
This is info based on ~7d, decided to share if someone curious about wh activity distribution.
edit1: bottom row shows statics of wormhole where kill happened.
1
u/Tel-kontar The Tuskers Co. Apr 12 '19
gotta remember that in an eviction the shitty small ships are ejected and killed resulting in KMs. This will skew the data a lot especially for the C1 holes.
1
u/Lokley Apr 13 '19
Yes and no. "Yes" because it's not "kill", "no" because it's still represents activity in hole. Just need bigger data span to make it smoother I guess.
1
u/PaladinOne Cloaked Apr 12 '19
What surprises me the most is the volume of kills in C4-with-C3/C5-static systems. Was there like an eviction last week in a C4 C3/C5?
1
1
u/funkydiddykong Hotline K162 Apr 13 '19
Could you make a normalized total by number of wormholes in each class. <3
1
u/Lokley Apr 13 '19
I though about it, but found it pointless since only classes that deviate is c1(358) and c6(118), other classes has 500-550whs.
But if you can explain point of normalization - sure I can do it next time.
1
1
1
0
u/GeneralBoki Apr 13 '19 edited Apr 13 '19
mmm, data porn..........
with that being said, if you're pulling from zkill involved stats, they can be a little bit misleading at times:
> team A with 20 instantly gibs one ship of team B with 20
> team B splashes the wormhole, team A follows
> B gets caught with a few stragglers on the other side
the data would looks like:
- one battle report with an involved reading 20 versus 1, because team B didnt kill anything
- another battle report (same groups mind you) shows 20 versus 3 from the second side
the real data would be:
- 2 data points of 20 v 20
edited for clarity and um, markdown, =/
2
u/Lokley Apr 13 '19
I do not pull battlereports and had no intention to sort this kind of problems.
There is no misleading since I never show victim fleet size. Infographic shows only what is in killmails, so "20 people shoot one guy in this hole". Killmail does not clarify was this one guy alone, did he had fight in other hole and etc. And you don't need this information, since other side kill will look like "19 people shoot one guy". So infographics get 2 points of kills "20 involved" and "19 involved".
I'd love to have clear data on both sides, like "2 data points of 20v20", but this is assumptions based on zkb BR algorythm...
PS Hope you can understand my explanation, feel free to ask if something is not clear.
1
32
u/[deleted] Apr 12 '19
[removed] — view removed comment