Missing player career histories v10 - Help needed!

[archibalduk]

Whilst we have updated many of the main players's career histories in the database, there are a lot of players who have not had their histories updated. If you would like to see some missing histories added to the TBL Rosters 2017/18 releases then please post the data in here and we will import it for the next release.

The format for posting the career histories is as follows:

Code: Select all

First name,Second name,Date of Birth,On loan (y/n),Playoffs (y/n),Year,Club,Competition,GP,G,A,PIM,+/-,Mins,GA,SO,W,L,T/OT,Saves

Here is an example of how you would post Aleksi Honka's 2014/15 stats:

Code: Select all

Aleksi,Honka,27.3.1993,n,n,2014,JYP-Akatemia,Finnish Mestis,45,5,3,55,2
Aleksi,Honka,27.3.1993,n,y,2014,JYP-Akatemia,Finnish Mestis,6,0,2,2,-2

Here is an example of how you would add Jonathan Quick's regular season stats from 2016/17 (note that HockeyDB does not record goals scored by goalies but you should of course still include the appropriate figure/zero in the data posted to this thread):




Some really important notes:

• The "Year" column is based on the start year of the season. E.g. the 2016/17 season would be entered as 2016;
• Only add regular season and playoff stats. Do NOT add international stats or relegation, promotion, qualification or tournament statistics;
• Please use the club and competition names as they appear in EHM (e.g. you should use "National Hockey League" and not "NHL);
• The goalie saves statistic is number of saves and NOT save percentage;
• Please add ALL seasons that are missing for that player and not just a random selection; and
• Please do NOT add 2017/18 statistics.

[PeakyBlinder]

You got an example of a goalie?

[archibalduk]

Yes of course. I have added an example of Jonathan Quick's regular season stats to the first post.

[PeakyBlinder]

So I pretty much did all of Vancouver except that right winger Lukas Jasek guy. Hope there isn't any errors.

Code: Select all

Richard,Bachman,25.7.1987,n,n,2016,Utica Comets,American Hockey League,27,0,0,0,0,1584,70,1,13,11,0,695
Richard,Bachman,25.7.1987,n,n,2016,Vancouver Canucks,National Hockey League,5,0,0,0,0,297,13,0,2,3,0,149
Chris,Tanev,20.12.1989,n,n,2016,Vancouver Canucks,National Hockey League,53,2,8,14,3
Kristoffer,Gunnarsson,26.2.1997,n,n,2016,IK Oskarshamn,Swedish HockeyAllsvenskan,29,1,2,8,-5
Kristoffer,Gunnarsson,26.2.1997,n,n,2016,Frolunda HC,Swedish Hockey League,10,0,0,29,2
Kristoffer,Gunnarsson,26.2.1997,n,y,2016,Frolunda HC,Swedish Hockey League,8,0,0,6,0
Jack,Rathbone,20.5.1999,n,n,2016,Youngstown Phantoms,United States Hockey League,4,0,1,0,1
Thomas,Vanek,19.1.1984,n,n,2016,Detroit Red Wings,National Hockey League,48,15,23,16,2
Thomas,Vanek,19.1.1984,n,n,2016,Florida Panthers,National Hockey League,20,2,8,6,-10
Nikolai,Goldobin,10.7.1995,n,n,2016,San Jose Sharks,National Hockey League,2,0,0,0,-1
Nikolai,Goldobin,10.7.1995,n,n,2016,San Jose Barracuda,American Hockey League,46,15,26,16,5
Nikolai,Goldobin,10.7.1995,n,n,2016,Vancouver Canucks,National Hockey League,12,3,0,0,1
Nikolai,Goldobin,10.7.1995,n,n,2016,Utica Comets,American Hockey League,3,4,0,0,1
Brendan,Gaunce,25.3.1994,n,n,2016,Vancouver Canucks,National Hockey League,57,0,5,33,-2
Brendan,Gaunce,25.3.1994,n,n,2016,Utica Comets,American Hockey League,4,2,1,2,0
Jonah,Gadjovich,12.10.1998,n,n,2015,Owen Sound Attack,Ontario Hockey League,66,14,10,42,-7
Jonah,Gadjovich,12.10.1998,n,y,2015,Owen Sound Attack,Ontario Hockey League,6,1,1,6,-2
Jonah,Gadjovich,12.10.1998,n,n,2016,Owen Sound Attack,Ontario Hockey League,60,46,28,32,35
Jonah,Gadjovich,12.10.1998,n,y,2016,Owen Sound Attack,Ontario Hockey League,17,4,3,8,-1
Bo,Horvat,4.5.1995,n,n,2016,Vancouver Canucks,National Hockey League,81,20,32,27,-7
Elias,Pettersson,12.11.1998,n,n,2016,Timrå IK,Swedish HockeyAllsvenskan,43,19,22,14,15
Elias,Pettersson,12.11.1998,n,y,2016,Timrå IK,Swedish HockeyAllsvenskan,2,0,1,2,1
Yan Pavel,Laplante,23.4.1995,n,n,2015,Gatineau Olympiques,Quebec Major Junior Hockey League,63,34,31,88,17
Yan Pavel,Laplante,23.4.1995,n,y,2015,Gatineau Olympiques,Quebec Major Junior Hockey League,17,10,3,8,-3
Yan Pavel,Laplante,23.4.1995,n,n,2016,Uitca Comets,American Hockey League,13,0,1,9,-8
Yan Pavel,Laplante,23.4.1995,n,n,2016,Alaska Aces,ECHL,38,9,11,39,-7
Brett,McKenzie,12.3.1997,n,n,2015,North Bay Battalion,Ontario Hockey League,66,26,27,43,1
Brett,McKenzie,12.3.1997,n,y,2015,North Bay Battalion,Ontario Hockey League,11,2,3,12,-4
Brett,McKenzie,12.3.1997,n,n,2016,North Bay Battalion,Ontario Hockey League,67,29,38,60,-16
Rodrigo,Abols,5.1.1996,n,n,2015,Portland Winterhawks,Western Hockey League,62,20,29,42,9
Rodrigo,Abols,5.1.1996,n,y,2015,Portland Winterhawks,Western Hockey League,4,0,1,4,-2
Rodrigo,Abols,5.1.1996,n,n,2016,Portland Winterhawks,Western Hockey League,2,0,1,7,0
Rodrigo,Abols,5.1.1996,n,n,2016,Acadie-Bathurst Titan,Quebec Major Junior Hockey League,52,18,32,43,16
Rodrigo,Abols,5.1.1996,n,y,2016,Acadie-Bathurst Titan,Quebec Major Junior Hockey League,11,5,6,12,1
Jake,Virtanen,17.8.1996,n,n,2016,Vancouver Canucks,National Hockey League,10,0,1,2,1
Jake,Virtanen,17.8.1996,n,n,2016,Uitca Comets,American Hockey League,65,9,10,48,-11
Petrus,Palmu,16.9.1997,n,n,2015,Owen Sound Attack,Ontario Hockey League,52,23,26,30,-12
Petrus,Palmu,16.9.1997,n,y,2015,Owen Sound Attack,Ontario Hockey League,6,3,3,8,-5
Petrus,Palmu,16.9.1997,n,n,2016,Owen Sound Attack,Ontario Hockey League,62,40,58,34,31
Petrus,Palmu,16.9.1997,n,y,2016,Owen Sound Attack,Ontario Hockey League,17,13,8,6,-2
Will,Lockwood,20.6.1998,n,n,2012,Victory Honda U18,Tier 1 Elite Hockey League (Midget Major),28,8,9,12,0
Will,Lockwood,20.6.1998,n,n,2013,Oakland Jr. Grizzlies U16,United States U16,31,19,19,41,0
Will,Lockwood,20.6.1998,n,n,2014,U.S. National Development Team U18,United States Hockey League,35,8,5,10,-13
Will,Lockwood,20.6.1998,n,n,2014,U.S. National Development Team U17,US National Development Program,53,14,7,16,0
Will,Lockwood,20.6.1998,n,n,2015,U.S. National Development Team U18,United States Hockey League,20,3,3,27,-2
Will,Lockwood,20.6.1998,n,n,2015,U.S. National Development Team U17,US National Development Program,59,13,20,35,0
Will,Lockwood,20.6.1998,n,n,2016,Michigan Wolverines,Big Ten Conference,30,8,12,33,-10
Kole,Lind,16.10.1998,n,n,2015,Kelowna Rockets,Western Hockey League,70,14,27,54,14
Kole,Lind,16.10.1998,n,y,2015,Kelowna Rockets,Western Hockey League,16,0,0,12,1
Kole,Lind,16.10.1998,n,n,2016,Kelowna Rockets,Western Hockey League,70,30,57,79,36
Kole,Lind,16.10.1998,n,y,2016,Kelowna Rockets,Western Hockey League,17,6,6,10,-5

[Manimal]

So I pretty much did all of Vancouver except that right winger Lukas Jasek guy. Hope there isn't any errors.

Some small errors(I fixed them). ECHL is the full name of the league and Acadie-Bathurst plays in the QMJHL

[PeakyBlinder]

So I pretty much did all of Vancouver except that right winger Lukas Jasek guy. Hope there isn't any errors.

Some small errors(I fixed them). ECHL is the full name of the league and Acadie-Bathurst plays in the QMJHL

Thanks babe.

[archibalduk]

That's a big help - thanks PeakyBlinder!

[PeakyBlinder]

I can get more teams down, could you guys throw me a list of what y'all need help with or haven't done?

[xECK29x]

Archi,

Feel free not to duplicate work and take directly from my releases if you want.

[archibalduk]

I can get more teams down, could you guys throw me a list of what y'all need help with or haven't done?

That would be fantastic. Thank you! Here is a list of players in the TBL Rosters v10.1 and the most recent history entered for each player.: https://1drv.ms/u/s!AsXFKQMOdPqgiFi3K_EtwU71ZxtN

You will see that the "Latest Career History" column shows the most recent entry for each player. E.g. 2016 = 2016/17. So it's all players with entries earlier than 2016.

Also included a blank spreadsheet to input your work. You might find it easier to use the spreadsheet rather than post them in this thread. You can then email them to rosters AT ehmtheblueline.com

Archi,

Feel free not to duplicate work and take directly from my releases if you want.

Thank you - that's very kind. If can figure out an easy way to transfer over the missing histories then I'll do just that.

[PeakyBlinder]

Hey bud, just emailed y'all the missing player histories for the Colorado Avs.

[celislanders1]

Belfast as requested mate

Code: Select all

First name	Surname	DOB	On Loan	Playoffs	Year	Club	Competition	GP	G	A	PIM	Plus Minus
Kevin	Raine	28.5.1993	n	n	2008	Kenora Thistles	Manitoba Midget AAA Hockey League	41	3	6	38	0
Kevin	Raine	28.5.1993	n	y	2008	Kenora Thistles	Manitoba Midget AAA Hockey League	2	0	0	4	0
Ryan 	Martinelli	2.9.1986	n	n	2002	St. Thomas Stars	Western Ontario Hockey League	45	0	5	30	0
Ryan 	Martinelli	2.9.1986	n	n	2003	St. Thomas Stars	Western Ontario Hockey League	45	0	7	47	0
Ryan 	Martinelli	2.9.1986	n	y	2003	St. Thomas Stars	Western Ontario Hockey League	4	0	0	8	0
Ryan 	Martinelli	2.9.1986	n	n	2004	St. Thomas Stars	Western Ontario Hockey League	26	3	10	34	0
Sebastien	Sylvestre	7.10.1993	n	n	2009	Antoine-Girouard	 Midget AAA Gaulois Quebec Midget AAA Hockey League	42	10	12	56	0
Sebastien	Sylvestre	7.10.1993	n	y	2009	Antoine-Girouard	 Midget AAA Gaulois Quebec Midget AAA Hockey League	20	4	8	18	0
Sebastien	Sylvestre	7.10.1993	n	n	2010	Antoine-Girouard	 Midget AAA Gaulois Quebec Midget AAA Hockey League	40	25	39	74	0
Sebastien	Sylvestre	7.10.1993	n	y	2010	Antoine-Girouard	 Midget AAA Gaulois Quebec Midget AAA Hockey League	5	3	4	24	0
Colin	Shields	27.1.1980	n	n	1995	Paisley Pirates	British Division 1	8	6	1	2	0
John	Kurtz	16.5.1989	n	n	2004	Oakville Rangers	South Central AAA League	54	30	32	61	0
John	Kurtz	16.5.1989	n	n	2005	Burlington Cougars	Ontario Junior Hockey League	42	7	11	34	0
Blair	Riley	1.11.1985	n	n	2002	Merritt Centennials	British Columbia Hockey League	19	9	4	17	0
Blair	Riley	1.11.1985	n	y	2002	Merritt Centennials	British Columbia Hockey League	5	1	2	7	0
Brandon	Benedict	10.6.1982	n	n	2005	Acadia Axemen	Canadian Interuniversity Sport	28	10	24	14	0
Brendan	Connolly	15.9.1985	n	n	2000	Airdrie Xtreme	Alberta Major Bantam Hockey League (AAA)	31	7	22	118	0
Brendan	Connolly	15.9.1985	n	n	2002	Canmore Eagles	Alberta Junior Hockey League	35	4	8	74	0
Brendan	Connolly	15.9.1985	n	n	2002	Brooks Bandits	Alberta Junior Hockey League	17	2	6	65	0
Brendan	Connolly	15.9.1985	n	n	2003	Brooks Bandits	Alberta Junior Hockey League	56	17	22	199	0
Darcy	Murphy	24.8.1992	n	n	2009	Trenton Golden Hawks	Ontario Junior Hockey League	30	7	12	9	0
Darcy	Murphy	24.8.1992	n	n	2009	Wellington Dukes	Central Canada Hockey League	4	0	0	4	0
Darcy	Murphy	24.8.1992	n	n	2010	Wellington Dukes	Ontario Junior Hockey League	50	14	27	26	0
Darcy	Murphy	24.8.1992	n	y	2010	Wellington Dukes	Ontario Junior Hockey League	18	9	11	18	0
Darcy	Murphy	24.8.1992	n	n	2011	Wellington Dukes	Ontario Junior Hockey League	48	52	34	37	0
Darcy	Murphy	24.8.1992	n	y	2011	Wellington Dukes	Ontario Junior Hockey League	5	5	0	4	0
Darcy	Murphy	24.8.1992	n	n	2012	Colgate Raiders	Eastern Collegiate Athletic Conference	36	10	5	51	-1
Darcy	Murphy	24.8.1992	n	n	2013	Colgate Raiders	Eastern Collegiate Athletic Conference	39	19	9	40	10
Darcy	Murphy	24.8.1992	n	n	2014	Colgate Raiders	Eastern Collegiate Athletic Conference	34	11	15	52	18
Darcy	Murphy	24.8.1992	n	n	2015	Colgate Raiders	Eastern Collegiate Athletic Conference	37	8	13	21	-11
Darcy	Murphy	24.8.1992	n	n	2015	Elmira Jackals	ECHL	8	2	1	6	4
Darcy	Murphy	24.8.1992	n	n	2016	Tulsa Oilers	ECHL	55	18	14	27	-2
Darcy	Murphy	24.8.1992	y	n	2016	Manitoba Moose	American Hockey League	8	1	1	4	-3

First Name	Second Name	DOB	On Loan	Playoffs	Year	Club	Competition	GP	G	A	PIM	Plus Minus	Mins	GA	SO	W	L	T OT	Saves
Jackson	Whistle	9.6.1995	n	y	2012	Kelowna Rockets	Western Hockey League	1	0	0	0	0	0	0	0	0	0	0	0
Chris	Truehl	27.10.1993	n	n	2011	Soo Eagles	Northern Ontario Junior Hockey League	20	0	0	0	0	0	0	0	0	0	0	0
Chris	Truehl	27.10.1993	n	n	2011	Janesville Jets	Northern Ontario Junior Hockey League	1	0	0	0	0	60	6	0	0	1	0	21
Chris	Truehl	27.10.1993	n	n	2012	Johnstown Tomahawks	Northern Ontario Junior Hockey League	38	0	1	0	0	2031	79	1	17	11	6	941
Chris	Truehl	27.10.1993	n	y	2012	Johnstown Tomahawks	Northern Ontario Junior Hockey League	3	0	0	0	0	0	0	0	0	0	0	0
Chris	Truehl	27.10.1993	n	n	2013	Air Force Falcons	Atlantic Hockey Association	14	0	0	0	0	716	24	3	8	3		278
Chris	Truehl	27.10.1993	n	n	2014	Air Force Falcons	Atlantic Hockey Association	36	0	0	0	0	2029	100	0	13	18	4	834
Chris	Truehl	27.10.1993	n	n	2015	Air Force Falcons	Atlantic Hockey Association	0	0	0	0	0	0	0	0	0	0	0	0
Chris	Truehl	27.10.1993	n	n	2016	Quinnipiac Bobcats	National Collegiate Athletic Association	21	0	0	0	0	1105	49	1	10	8	2	434
Stephen	Murphy	11.12.1981	n	n	1997	Paisley Pirates	British national League	2	0	0	0	0	0	0	0	0	0	0	0
Stephen	Murphy	11.12.1981	n	n	1998	Fife Flyers	British national League	7	0	1	0	0	0	0	0	0	0	0	0
Stephen	Murphy	11.12.1981	n	y	1998	Fife Flyers	British national League	8	0	0	0	0	0	0	0	0	0	0	0
Stephen	Murphy	11.12.1981	n	n	1999	Fife Flyers	British national League	30	0	0	4	0	1774	63	0	0	0	0	891
Stephen	Murphy	11.12.1981	n	y	1999	Fife Flyers	British national League	11	0	1	0	0	0	0	0	0	0	0	0
Stephen	Murphy	11.12.1981	n	n	2000	Fife Flyers	British national League	12	0	1	0	0	720	22	0	0	0	0	366
Stephen	Murphy	11.12.1981	n	n	2007	Stjernen Hockey	Norwegian GET Ligean	36	0	0	0	0	0	0	0	0	0	0	0

[celislanders1]

Jordan Buesa in 2015 needs Toronto Titans and the Greater Toronto Hockey League its currently blank

Jackson Whistle in 2013 has 2 goals

Cole Jarrett needs Tohoku Fife Blades adding to 2010 its blank

David Rutherford https://belfastgiants.com/person/david-rutherford/ Didn't play any games for Abbotfords Pilots 2003 needs Chilliwick adding also as you have Abbotfords down twice in 2003

Craig Moore at Cardiff needs
2011 OHA Maroon Mavericks Midget AAA

Mark Richardson at Cardiff
2002 (none) played 1 scored 1 ??
Basingstoke Bison BNL 0 0 0 0 0 | Playoffs 1 0 0 0 0

Luke Piggott at Cardiff
Has Cardiff 2006 should be 2007 he didn't play 2006

[archibalduk]

PeakyBlinder - Thanks very much for emailing the Colorado histories to me. I'm importing those along with Vancouver today.

Celislanders1 - Thank you for sending the spreadsheets with the Belfast histories. I will import these today. I was slightly worried when you posted the data without any commas in this thread as it cannot be imported without commas, but then I saw your message with the spreadsheet versions! I have added <code></code> tags around your post above as it reduces scrolling. Thanks also for those corrections. I'll sort those today too.

EDIT: It looks like there are player, club and competition names which don't match what is in the database. It's going to take a few days to correct and import.

[celislanders1]

Is that my data ?? I have been using the club names and copying and pasting same with leagues ??

Here is Cardiff and Braehead i have just added them onto Belfast

https://ufile.io/z2bnx goalies

https://ufile.io/unli8 players

[celislanders1]

Is that my data ?? I have been using the club names and copying and pasting same with leagues ??

Here is Cardiff and Braehead i have just added them onto Belfast

https://ufile.io/z2bnx goalies

https://ufile.io/unli8 players

Gustav Ahnelöv needs Flemingsbergs IK J18 adding to team history in 2011
Dave Clements needs Coventry Blaze U16 adding to team history in 2006
Vojtěch Kloz needs HC Karlovy Vary U18 adding to team history in 1999 and 2001 and 2002
Garrett Ladd needs Compuware U18 adding to team history in 2005
Gabriel Lévesque has Duc de Dijon 2017 in his history ??
Malcolm Gould needs North Vancouver Wolf Pack adding to team history in 2009
Richards Grigors needs Jelgava U18 adding to team history in 2009
Sergei Banashkov needs Traktor Chelyabinsk-2 adding to team history in 2004 and Mechel Chelyabinsk-2 in 2006
Richards Birzins needs Beibarys Atyrau adding to team history in 2010 and also SK Riga 20 to 2007 & 2008

[celislanders1]

Here is Coventry, Dundee and Edinburgh added onto what you already have.

Goalies https://ufile.io/q4wpv

Players https://ufile.io/2arxt

[PeakyBlinder]

Emailed y'all the player histories for the Columbus Blue Jackets.

[celislanders1]

Carl Ackered needs Djurgårdens IF U16 adding to team history in 2006
Mike Clemente needs Washington Little Capitals adding to team history in 2005
Lee Bonner needs Kingston Sharks U16 adding to team history in 2011 and 2012
Dane Byers needs Red Deer Rebels changing to Prince Albert Raiders in his history

Fife and Guildford

https://ufile.io/m9pwv - Goalies

https://ufile.io/b5r1r - Players

[archibalduk]

Emailed y'all the player histories for the Columbus Blue Jackets.

Got them. Thank you!

Fife and Guildford

https://ufile.io/m9pwv - Goalies

https://ufile.io/b5r1r - Players

That's great. Thanks for your help. I'm going to hold off importing your data until you tell me you're done with the EIHL. Seeing as they're all in a single spreadsheet, it makes sense if I wait until you're done so that I can correct any mistakes in team and league names all in one go (there are only a handful IIRC).

Carl Ackered needs Djurgårdens IF U16 adding to team history in 2006
Mike Clemente needs Washington Little Capitals adding to team history in 2005
Lee Bonner needs Kingston Sharks U16 adding to team history in 2011 and 2012

Have you added the various missing items you have posed these past few days to your spreadsheet (aside from the team/league corrections)? Whilst I will look at them if you haven't, I can't promise it'll be in time for v10.2.

[celislanders1]

No i have not added the players with missing teams to my spreadsheets. As its just the team that needs adding. Got 4 EIHL teams to do then.

2 to do just Panthers and Steelers

Sam Gospel needs Nottingham Panthers not Sheffield Steelers in team History for 2014
Evan Mosey needs Chicago Mission U18 adding to team history in 2007 2nd entry

[celislanders1]

Goalies are done mate https://ufile.io/0c4hb

[celislanders1]

Matt Marquardt needs Norfolk Admirals in 2011
2 Florida Everblades
Norfolk was 34 games 13 goals one

Eric Neiley needs Exeter High in team history for 2009 and 2010

All done

Players - https://ufile.io/gmg71

[archibalduk]

Outstanding - thanks so much! I am working on getting them imported.

[celislanders1]

Excellent mate great stuff. Ya know of any leagues that need looking at ??