Sumo Reference Updates

[Asashosakari 19,943]

@Tamanaogijima Do we have a source for Dewanohana having been Musashigawa until 1976? His retirement date will have been 1974/02/28, and while his ja.wiki article indicates that he continued being part of the NSK in a sodan yaku role until January 1976, I'm not sure if this entailed his continued use of the kabu as well. Their Musashigawa toshiyori page has him only to 1974, but of course that's not sourced either.

[Tamanaogijima 770]

4 hours ago, Asashosakari said:

@Tamanaogijima Do we have a source for Dewanohana having been Musashigawa until 1976?

I have been hunting banzuke images (esp. Showa era) on ebay some time ago - not only but also for exactly that purpose... I present you the banzuke of May 1974. Another one of November 1975 with much poorper quality shows the same. Between the west jonokuchi and the sanyo sits, in a separate box of his own, Musashigawa Yoshihide.

Edited November 1, 2023 by Tamanaogijima

[Asashosakari 19,943]

28 minutes ago, Tamanaogijima said:

I have been hunting banzuke images (esp. Showa era) on ebay some time ago - not only but also for exactly that purpose... I present you the banzuke of May 1974. Another one of November 1975 with much poorper quality shows the same. Between the west jonokuchi and the sanyo sits, in a separate box of his own, Musashigawa Yoshihide.

Well, that was quick and definitive.  Many thanks! Time to fix a couple of chronology issues in his en.wiki article.

[sahaven111 188]

Onokatsu's appearance on the Kyushu 2023 banzuke doesn't show the high rank marker. It also doesn't show on the banzuke itself.

 

I'll also add that his profile lists his highest rank as "Gyoji"

Edited November 2, 2023 by sahaven111

[Yamanashi 3,988]

I know that records before 1800 are like cobwebs and butterfly wings, but the db says Ozeki Shakagatake had a Hatsu Dohyo in November 1770 as a member of the Raiden heya.  Now I know Raiden was maybe the best ever, but he didn't join Ozumo until 1790; also, no one else in the db is in this heya.

[Asashosakari 19,943]

14 minutes ago, Yamanashi said:

I know that records before 1800 are like cobwebs and butterfly wings, but the db says Ozeki Shakagatake had a Hatsu Dohyo in November 1770 as a member of the Raiden heya.  Now I know Raiden was maybe the best ever, but he didn't join Ozumo until 1790; also, no one else in the db is in this heya.

You're thinking of the wrong Raiden; this one was Shakagatake's shisho.

[Yamanashi 3,988]

2 hours ago, Asashosakari said:

You're thinking of the wrong Raiden; this one was Shakagatake's shisho.

Thanks, though that confuse me even more (I know, not your fault!).  I neglected this other Raiden for the following reasons: Shakagatake entered in November 1770 while Raiden Tamegoro was still active.  I know that in the old days a rikishi could also be an Oyakata, but Raiden Tamegoro is listed as a member of Asahiyamabeya.

However, Raiden T. has no results from his Hatsu Dohyo in October 1760 until he shows up as a Sekiwake in November 1770 -- the same month as Shakagatake's first basho.  Is this when the Raiden (Tamegoro) heya is born? 

It is still the case that Shakagatake is the only rikishi in the db who was listed in the Raiden heya.

[Asashosakari 19,943]

11 hours ago, Yamanashi said:

Thanks, though that confuse me even more (I know, not your fault!).  I neglected this other Raiden for the following reasons: Shakagatake entered in November 1770 while Raiden Tamegoro was still active.  I know that in the old days a rikishi could also be an Oyakata, but Raiden Tamegoro is listed as a member of Asahiyamabeya.

However, Raiden T. has no results from his Hatsu Dohyo in October 1760 until he shows up as a Sekiwake in November 1770 -- the same month as Shakagatake's first basho.  Is this when the Raiden (Tamegoro) heya is born? 

It is still the case that Shakagatake is the only rikishi in the db who was listed in the Raiden heya.

I'm afraid you're opening up about five different cans of worms here, which makes it a bit too much to explain on the Saturday before a honbasho. If nobody else gets to it first, I'll try to whip up some explanations later on.

[Chiyotasuke 311]

Kotakiyama's given name is missing a kanji. The NSK site has it.

Also, Umetsu's shikona given name on the Japanese page should be Shunnosuke and not Sunnosuke. Here, his name is on the bottom of the New Recruits list of Hatsu 2013:

On 13/01/2013 at 19:25, Naganoyama said:

SHIKONA	KANJI	NAME	HEYA	HEIGHT	WEIGHT	DOB	BIRTHPLACE
Chimideregezen	チミデレゲゼン	Chimideregezen Shijirubayaru	Oitekaze	182	143	28 - August - 1994	Mongolia
Hamagami	濱上	Kyosuke Hamagami	Kasugayama	177	120	04 - April - 1994	Kanagawa
Hiroshima	廣嶋	Chikara Hiroshima	Fujishima	177	117	04 - August - 1994	Fukuoka
Ishiura	石浦	Masakatsu Ishiura	Miyagino	173	96	10 - January - 1990	Tottori
Ito	伊藤	Baraki Ito	Shikihide	167	104	10 - May - 1994	Saitama
Kimishima	君島	Yamamoto Kimishima	Kasugayama	169	90	22 - July - 1994	Tochigi
Majima	間島	Shogo Majima	Kasugayama	175	130	24 - January - 1995	Tochigi
Morimune	森宗	Junpei Morimune	Fujishima	177	91	24 - August - 1990	Hiroshima
Nishihata	西畑	Ryu Nishihata	Takanohana	168	111	03 - November - 1995	Fukuoka
Ogata	緒方	Koichiro Ogata	Kasugano	172	71	25 - January - 1994	Fukuoka
Omori	大森	Kohei Omori	Irumagawa	180	177	09 - June - 1994	Okayama
Sanjo	三條	Tatsuaki Sanjo	Tomozuna	170	169	10 - March - 1995	Hyogo
Shimada	嶋田	Tetsuya Shimada	Kitanoumi	168	91	15 - November - 1990	Hyogo
Takagishi	高岸	Shota Takagishi	Sadogatake	183	131	17 - August - 1994	Fukuoka
Umetsu	梅津	Shunnosuke Umetsu	Shikoroyama	173	147	01 - June - 1996	Yamagata
...

I'll bump a previous post I made about typos in the DB FWIW in case you missed it. Since most of them are old and lower ranked rikishi I doubt there are any sources with the correct shikonas. I guess they appeared due to either erroneous input or sources with typos

On 04/09/2023 at 10:32, Chiyotasuke said:

On the Japanese side:

Ichigashima missing "ma"
Yatsuogi appears as Zatsuogi
Akandake appears as Akansake
Chibanohoshi appears as Chibanosato (probably mistook 星 for 里)
Kotoishimi's change back to Yamashita is not reflected in the kanji
For some reason, Ojiyama has 0xfeff (zero-width no-break space) characters in the kana form of his shikona. It's also in the words Nobunaga and Sekizukayama on his profile

On both sides or not sure which one's correct:

Iizukayama missing "yama"
Miyatsunishiki 宮津山 could be Miyatsuyama
Hironoumi 弘の冨士 could be Hironofuji
Should Hikoneo have a # after it? It's there on the English and missing on the Japanese

Edited November 14, 2023 by Chiyotasuke
Added Kotakiyama

[Asashosakari 19,943]

Asagyokusei has an unnecessary yasumi marker in his maezumo records.

[Yubinhaad 11,856]

Tokushoryu's final basho record should be 0-0-1 to tally with his Kyokai profile career record of 553-570-1, intai announced on Day 3 of that basho.

[Asashosakari 19,943]

There are a small bunch of early modern era cases where makushita rikishi appeared in juryo and their interim records after those matches show up with yasumi listed, even though they had no absent days (as confirmed by their final records which match the expected number of bouts for makushita in those tournaments):

Ayazakura 1927.03
Musashiyama 1928.05 (records wrong altogether, should be 5-0 after Day 7 and 6-0 after Day 8)
Takanami 1928.10
Wakashio 1929.01 (records wrong altogether, should be 4-1 / 5-1 / 5-2 / 6-2)
Wakashio 1929.03
Komanishiki 1929.05 (first record wrong, should be 2-0 after Day 2)
Kaishin 1930.03
Banshinzan 1931.01

Edited November 18, 2023 by Asashosakari

[Asashosakari 19,943]

And as a result of the previous investigation I also ran into a rather more severe issue involving makushita rikishi in juryo, namely many cases where their interim records are totally wrong because they were apparently taken from their opponents' final records somehow (column error while importing/exporting?).

It starts right in 1909.06, the first tournament for which the DB has juryo results, and basho all the way to 1944.11 are affected.

Strangely, it hasn't always hit every juryo appearance by a rikishi, e.g. Hajimayama in 1944.01 has records taken from his opponents after Days 1, 4 and 14, but not after Day 11. However, Day 11 is also wrong here since it shows Hajimayama's own final record of 6-2 rather than the correct interim record of 5-2 based on his day-by-day hoshitori. For some rikishi this may not be completely fixable anyway, e.g. Usanoyama in the same tournament, because he has no day-by-day available. (Although perhaps the torikumi source that was used will have his correct daily records as they were after each juryo appearance?)

Edit: Even more strangely, those wrong interim records can't actually be queried for. 0-15 wins after the bout and 0-15 wins before the bout don't yield any hits for Hajimayama, only basho total works. So I'm not even sure where the query code obtains that bogus interim results data - maybe it's not actually a database issue, just one with the code?

Edited November 18, 2023 by Asashosakari

[Chiyotasuke 311]

It seems that the sewanin and wakaimonogashira's heya affiliations after their retirement from dohyo are/were supposed to be shown in their profiles. But most of them are missing heya transfers (if they had any). I used the DB, HeyaA-Z and the Japanese Wikipedia pages for sewanin and wakaimonogashira to examine each members, then I compiled this list which distinguishes the ones who have the correct heya information and the ones who don't in the DB, with the missing heya in red:

Sewanin:

    Correct: Mitsuwaka, Kenryu, Fusanobori

    Missing:

        Mutsuhokkai: Ajigawa - Isegahama

        Aranonami:   Musashigawa - Fujishima - Ikazuchi

        Ranbo:       Futagoyama - Takanohana - Chiganoura - Tokiwayama

        Tochinoyama: Kasugano - Chiganoura - Tokiwayama

        Nishikikaze: Oguruma - Oshiogawa

        Byakuhoyama: Kasugayama - Ajigawa - Kasugayama - Oitekaze - Nakagawa - Miyagino

        Saisu:       Isegahama - Kiriyama - Asahiyama - Isegahama

        Yuho:        Taiho - Otake

Wakaimonogashira:

    Correct: Fukunosato, Isenishiki

    Missing:

        Torafusuyama: Mihogaseki - Kasugano

        Hananokuni:   Hanakago - Hanaregoma - Shibatayama

        Tsurumiyama:  Izutsu - Michinoku

        Shiraiwa:     Isegahama - Kiriyama - Asahiyama - Asakayama

Edited November 24, 2023 by Chiyotasuke

[Yubinhaad 11,856]

I'd much rather have a dedicated section for urakata in a similar way to the existing kabu section, to be honest. For instance, when an oyakata moves to a different heya, that information is shown on the relevant oyakata/kabu history pages, it doesn't get added to the man's rikishi profile.

That's not an objection to your efforts above by the way, which are appreciated. That information should be displayed, I just think including it in the active heya list on the rikishi profile could cause confusion.

[Chiyotasuke 311]

54 minutes ago, Yubinhaad said:

I'd much rather have a dedicated section for urakata in a similar way to the existing kabu section, to be honest. For instance, when an oyakata moves to a different heya, that information is shown on the relevant oyakata/kabu history pages, it doesn't get added to the man's rikishi profile.

That's not an objection to your efforts above by the way, which are appreciated. That information should be displayed, I just think including it in the active heya list on the rikishi profile could cause confusion.

I sure second that.

[WAKATAKE 2,732]

Kyokukaiyu needs to have Nippon Sports Science University added to his profile for university.

https://sumodb.sumogames.de/Rikishi.aspx?r=12841

Source:

 

[Tigerboy1966 1,539]

I don't know if this is unusual, but the database still isn't showing the playoff/ "day 16" results for Kyushu '23.

[Asashosakari 19,943]

Hmm. Would it be possible to extend the "Rikishi details" options of the query page with a setting to show a column with the database rikishi IDs? I'm finding myself in need of that data somewhat frequently (either because I'm running a query for which the "group by rikishi" setting isn't feasible, or because I'm combining the output of two different queries), and while it's possible to extract the IDs, it would be much more convenient to have them displayed in the query output itself so they can just be copy-pasted.

[Gurowake 4,123]

1 hour ago, Asashosakari said:

while it's possible to extract the IDs

This is generally what I've done.  I wrote a function that did that, and it's not too much of a hassle having done that to use it whenever I need it.  To save you from counting, it's 42 characters in the URL before the rikishi ID starts.  Or at least that's the number to use in the MID() function.

[Tetsuba 33]

52 minutes ago, Gurowake said:

This is generally what I've done.  I wrote a function that did that, and it's not too much of a hassle having done that to use it whenever I need it.  To save you from counting, it's 42 characters in the URL before the rikishi ID starts.  Or at least that's the number to use in the MID() function.

I guess you can probably use regular expressions if you don't want to use a character count

[Chiyotasuke 311]

Nanajo and Yariryu are written in the Kintamayama style romanization (as Nanajou and Yariryuu) on the English side. I didn't find any other instances of this upon further searching.

[Asashosakari 19,943]

His ja.wiki profile is rather insistent that Ryuko's real given name has a long o just like his later shikona did (where given and family name were reversed), so the Ryuko reading in his maezumo shikona should probably be adjusted to りゅうこう (it's just りゅうこ right now).

[Asashosakari 19,943]

The end of Tenkaiho's Otowayama tenure is erroneously tagged AO instead of KC.

[Akinomaki 41,186]

3 hours ago, Akinomaki said:

Ex-Koshinishiki, Masashi Ozawa - pro wrestler Killer Khan has suddenly died yesterday at the age of 76 

1 hour ago, Kamitsuumi said:

According to Sponichi, his shikona is pronounced Koshinishiki

the DB has him as Etsunishiki#, needs to be updated, along with his death date