Sumo Reference Updates Options

[Doitsuyama]

I will announce the updates on the Sumo Reference site on this forum - I feel that's better than somewhere hidden on the site.

Firstly I could correct a few errors found by Asashosakari and Randomitsuki. Next I want to thank Gans-san for sharing a lot of material which will be worked into the database, but it's so much it will last some months. Gochisozan also is providing me with a lot of missing lower division results in the Heisei era from his Sumo magazine archive. Of course Nishinoshima also is active and I received a fat letter with lots of material from him.

It's so much, I actually could need help in entering all that new data. So, if there is another person or two insane dedicated enough to enter data into Excel sheets, I happily can throw loads of work at them. Ability to read kanji or at least hiragana is widening the range of possible tasks, but there actually also are enough tasks where only kanji for "east" and "west" must be distinguished or even less than this.

Actually I can understand if no one wants to do that time-consuming job, but I'm accepting volunteers - just send a PM or email.

Now what's new in the database since last week?

I have added the missing juryo kimarite from 1974 to 1988 with some rare kimarite (like ipponzeoi, sabaori, gasshohineri etc) among them. There still are a lot more available from Haru 1956 to 1973 waiting to be entered.

Then I was able to get the correct W-L records for Aki 1988 and Kyushu 1988. Until now these two full banzuke were entered from the banzuke itself (it was nice training to read the jonidan and jonokuchi shikona on the real banzuke), with the wins implicitly deduced from banzuke movement - naturally no distinction was possible between losses and absences, and final scores from intai rikishi were guessed with 0-0-7. Now everything is correct here. Some minor errors between Hatsu 1989 and Aki 1989 also were corrected and hoshitori added.

And lastly I completed the records of Kitamayama's favorite oldest rikishi in Ozumo, Ichinoya.


This post has been edited by Doitsuyama: Jul 2, 2007, 09:41

[Doitsuyama]

I was doing some research in the sumo reference database earlier, when I happened to come across this and this.

I'm impressed that Ishida was able to fight 14 times (sometimes 2 times on the same day) and still only get a 5-2 score. Not to talk about Hamaeiko's 6-1 score without entering the dohyo even once.

Jokes aside, I thought it was probably a good idea to inform you of my find.

No jokes, I am happy about any and all reported errors. This one is fixed now.

[Kaiomitsuki]

No jokes, I am happy about any and all reported errors. This one is fixed now.

I remember a few weeks ago when I made a search with birth date
http://sumodb.sumogames.com/Rikishi.aspx?s...i=-1&sort=4
the last line of this page... you have an error too
Arie seems to be born after his Intai
http://sumodb.sumogames.com/Rikishi.aspx?r=2360

Thank you for this great site

[Doitsuyama]

Arie seems to be born after his Intai
http://sumodb.sumogames.com/Rikishi.aspx?r=2360

Yes, a typo... birth year is 1969, not 1996. Corrected.

[Doitsuyama]

No new banzuke added as my references for 1974 and before are beginning to get a bit sketchy. For example I have only hoshitori tables from 1968 to 1974, no rikishi details like real name etc which makes tracking of shikona changes more arduous. I am still hoping that I might get some sources in the future, namely odd month magazines of "Sumo" in those years or copies, so I am postponing this part for now.

I was quite busy in the last week though as I wanted to complete the career records of several important rikishi, starting with Mienoumi, Takanosato, Wakanohana II and Oshio. I certainly got a bit overboard after that as I followed this up to complete about 100 more rikishi, but now all sanyaku rikishi with hatsu dohyo in 1935 or later have complete career records, and almost all rikishi with 400 or more career wins are completed too.

Now that the major rikishi (in terms of number of bouts and wins) are complete, I have started to make some interesting record lists, beginning with Career Wins and Makuuchi Wins. More will certainly follow later.

[Kotoseiya Yuichi]

(…) now all sanyaku rikishi with hatsu dohyo in 1935 or later have complete career records, and almost all rikishi with 400 or more career wins are completed too.

Such an awesome site.

[Asashosakari]

Now that the major rikishi (in terms of number of bouts and wins) are complete, I have started to make some interesting record lists, beginning with Career Wins and Makuuchi Wins. More will certainly follow later.

Intriguing! Asanowaka is the Makuuchi wins leader for rikishi below sanyaku...not quite the name I expected to see there. And nobody active is even close to him now after Tokitsuumi's retirement (who was about four basho away from breaking the record).

In a similar vein, Kitazakura is about a year and a half away from becoming the new leader for most career wins by a rikishi below sanyaku; Kitakachidoki leads this one, also not a name I expected to see there, but I always forget that he did stick around quite long. Tochitenko needs five more wins to take over the lead for most career wins below makuuchi. And Kimenryu needs 23 more to become the first (?) rikishi below juryo to get 500 career wins. (Ichinoya is actually still ahead of him right now, but...)

Incidentally, Kimenryu and Koriyama (another currently active high-wins guy below juryo) sure have extremely opposite career paths...Kimenryu didn't come up to makushita until he was almost 22 already, peaked late around age 30 and then essentially stayed just slightly below his peak level for the next half-decade. Koriyama on the other hand was in Makushita at age 18, already peaked around age 24/25 and never got close to that level again. So much for predicting career patterns based on age. One thing they do have in common is that both achieved their career-highest kachi-koshi at Ms10...

[Doitsuyama]

And Kimenryu needs 23 more to become the first (?) rikishi below juryo to get 500 career wins. (Ichinoya is actually still ahead of him right now, but...)

I guess it's possible that there is a non-sekitori still not in the database who has more than 500 wins, but it's not too likely as fewer than six basho per year mean fewer opportunities to get the wins. Since I know the hatsu dohyo for all rikishi active in Kyushu 1974 and later, this candidate must have retired until Aki 1974. Let's suppose Aki 1974 as the last basho - then the hatsu dohyo must be in 1949 or earlier to reach 1000 bouts (and no abences of course). If the last basho is earlier than Aki 1974, the necessary hatsu dohyo very quickly shifts back, last basho in Aki 1972 means hatsu dohyo in 1944 or earlier to get to 1000 bouts.

[ryafuji]

So Tochitenko needs just four more tournaments to surpass Oshio's record of 157. Of course he hasn't fought nearly as many matches but still quite an achievement.

I also find it interesting that Oshio is in second place on the Career Wins list but doesn't even make it into the top 100 when it comes to Makuuchi Wins. He really did spend a long time in the lower divisions.

This post has been edited by ryafuji: Dec 13, 2007, 20:06

[Koukai]

1 . Why is three "Chyonofuji"s in japanese version and only two in the english?
(last two in japanese are looking similar)

2. How can be two sumotori with the same shikona at the same time (1970-1974)?

[Harry]

1 . Why is three "Chyonofuji"s in japanese version and only two in the english?
(last two in japanese are looking similar)

2. How can be two sumotori with the same shikona at the same time (1970-1974)?

To 1., you're right in Japanese the last two lines are identical so either a database problem or a display problem. Edit: thanks Doitsuyama, I should have looked more closely to see that the kanji were not in fact the same. With a small font they look very close.

To 2., are you sure they were active at the same time? It looks like Akimoto's career came just after Miyamoto's and for the first while of course Akimoto used his family name before becoming Oakimoto and finally Chiyonofuji. Finally perhaps they had different given names so their whole shikona was not common? Could also be data errors as the first one seems to have had a very short career while Akimoto became Yokozuna so he has lots of data.

This post has been edited by Harry: Feb 10, 2008, 22:49

[Doitsuyama]

1 . Why is three "Chiyonofuji"s in japanese version and only two in the english?
(last two in japanese are looking similar)

2. How can be two sumotori with the same shikona at the same time (1970-1974)?

1. You answered that one yourself already (I think). The later yokozuna Chiyonofuji had a shikona change from 千代の冨士 to 千代の富士 which is why there are two Japanese search results for him if you look for "Chiyonofuji" (or "ちよのふじ" of course).

2. I have currently a gap in the database as the full banzuke from Hatsu 1968 is entered (thanks again to aderechelsea for the material), but I have no "Sumo" magazines between that basho and Kyushu 1974. The gap will hopefully be closed eventually, but until then there are a few hundred rikishi with unknown intai (somewhere in those seven years anyway). The unknown intai is actually written as such. The second Chiyonofuji is one of them and I concede that his intai must have been earlier than Haru 1971 (when Chiyonofuji assumed this shikona), but I didn't check for such things as I intend to complete the missing full banzuke anyway.

[Koukai]

Thank you both for the answers

[Mark Buckton]

2. I have no "Sumo" magazines between Hatsu 1968 and Kyushu 1974. The gap will hopefully be closed eventually, but until then there are a few hundred rikishi with unknown intai

these magazines are readily available in Tokyo - at least 2 outlets (used bookstores) have hundreds upon hundreds from the 60s - 90s and must contain the years you are after. Priced at a few hundred yen apiece as far as I recall. If you need help, I am sure Nishi or I could get along sometime.

This post has been edited by Mark Buckton: Feb 11, 2008, 05:55

[Mark Buckton]

also - repeating part of another post but probably better written here - shikona (you have しこ名)　would better match Japanese language records were it installed / penned 四股名

[Doitsuyama]

also - repeating part of another post but probably better written here - shikona (you have しこ名)　would better match Japanese language records were it installed / penned 四股名

The NSK site uses しこ名more often than the other form so it certainly isn't wrong or even misleading in any way. The japanese wikipedia page for 四股名 also states that "しこ名" is a frequently used writing.

I have changed it now since the japanese wikipedia has 四股名 as the main form.

[Kaikitsune Makot...]

It is very sad Tongans quit decades ago due to circumstances.

It is still awesome and flabbergasting that this kind of statistical heaven exists. Hard work indeed and useful to thousands of human beings all around the world.

[Mark Buckton]

The second Chiyonofuji is one of them and I concede that his intai must have been earlier than Haru 1971 (when Chiyonofuji assumed this shikona), but I didn't check for such things as I intend to complete the missing full banzuke anyway.

最高位 序二段 72
本名 宮本　久夫
生年月日 昭和24年5月21日
出身地 大阪府大阪市東住吉区
所属部屋 九重 哨
改名歴 千代の富士
初土俵 昭和42年3月
最終場所 不明

the missing date - is 43年9月 - Sept, 1968

[aderechelsea]

i wanted to ask something about Musashimaru's entry.

There are is no mae-zumo result listed and there are also no opponent names for his first few basho. You are waiting to get these details from a magazine or a somewhat "official" source? because these are available online somewhere but i cannot verify their accuracy. I was just wondering.

.
.
.

For example I have only hoshitori tables from 1968 to 1974, no rikishi details like real name etc which makes tracking of shikona changes more arduous. I am still hoping that I might get some sources in the future, namely odd month magazines of "Sumo" in those years or copies, so I am postponing this part for now

i have a March 1968 magazine. Interested?

.
.
.

and something last ... how impossible is it to include kimarite in the queries? or some sort of search by kimarite? i have no idea how this whole database system works so i might be talking about some serious work here but i thought i could just ask ...

[Doitsuyama]

i wanted to ask something about Musashimaru's entry.

There are is no mae-zumo result listed and there are also no opponent names for his first few basho. You are waiting to get these details from a magazine or a somewhat "official" source? because these are available online somewhere but i cannot verify their accuracy. I was just wondering.

The mae-zumo result I would like to add, but I am not interested in adding single lower division bouts. It's too much work to add them piece-wise and even worse when I get the rest of a basho. So I am adding lower division bouts on a whole basho scale only.

For example I have only hoshitori tables from 1968 to 1974, no rikishi details like real name etc which makes tracking of shikona changes more arduous. I am still hoping that I might get some sources in the future, namely odd month magazines of "Sumo" in those years or copies, so I am postponing this part for now

i have a March 1968 magazine. Interested?

Guess where I got the Hatsu 1968 full banzuke and rikishi details?

and something last ... how impossible is it to include kimarite in the queries? or some sort of search by kimarite? i have no idea how this whole database system works so i might be talking about some serious work here but i thought i could just ask ...

Hmm, you mean like this (showing uchimuso wins grouped by rikishi)? You can study that query and play with it by clicking the "modify query" link.

[Randomitsuki]

and something last ... how impossible is it to include kimarite in the queries? or some sort of search by kimarite? i have no idea how this whole database system works so i might be talking about some serious work here but i thought i could just ask ...

Kimarite search was available from day 1. I remember you saying that you are databasically-challenged, but it's really quite easy. Just select the bout query. There you'll see a kimarite pull-down menu. Take a rare kimarite and press "Search". You'll see a list where each bout with that kimarite is displayed (in fact, using this method it is displayed twice).
Then you can use this query and experiment a little with it. You want cumulative results? Use the pull-down menus at the bottom where you can group by rikishi1. Voila, you get a list of who used what kimarite how often. And so on...

This post has been edited by Randomitsuki: Feb 12, 2008, 23:28

Reason for edit: Beaten by the databassist himself...

[aderechelsea]

Guess where I got the Hatsu 1968 full banzuke and rikishi details?

and something last ... how impossible is it to include kimarite in the queries? or some sort of search by kimarite? i have no idea how this whole database system works so i might be talking about some serious work here but i thought i could just ask ...

Hmm, you mean like this (showing uchimuso wins grouped by rikishi)? You can study that query and play with it by clicking the "modify query" link.

ok, i am officially stupid.

sorry to bother you. Forget my existence ...

[Doitsuyama]

Finally there are some update news. Thanks to aderechelsea (even if he forgot it somewhere in South America), I have added eight full banzuke from Kyushu 1966 until Hatsu 1968, along with rikishi details (real name, birth date, heya, detailed shusshin) for about 500 rikishi. Randomitsuki added the juryo kimarite from 1956 to 1964, about 14,000 of them, making the juryo kimarite complete as far as my sources go. Fay added more than 40 pics from lower division rikishi.

[Bealzbob]

Brilliant work everyone involved

[kame]

ya, thanks a ton to Doitsuyama and everyone else who's contributed to the sumo database, my browser's toolbar wouldn't be complete w/o it.

[Doitsuyama]

Another update is available, I have added 13 full banzuke from Haru 1968 until Haru 1970. I guess further updates will have to wait a month or so as I will be busy and the Haru basho is coming up.