Sumo Reference Updates

[Asashosakari 18,950]

Gusoyama's kinboshi thread reminded me of a nagging mini-issue I've had...would it be possible to add something like "all except fusen" to the kimarite choices in the bout query?

[Doitsuyama 1,173]

Gusoyama's kinboshi thread reminded me of a nagging mini-issue I've had...would it be possible to add something like "all except fusen" to the kimarite choices in the bout query?

I rather had the idea to add "Had a kinboshi" in the banzuke query... well, there are a few more things which could be added, and feel free to come up with your ideas (like age or heights/weights). Take your time, because I'm awfully busy these weeks, so it wouldn't get done soon anyway.

[Babaryutaikai 1]

I would just like to say that Doitsuyama's database in invaluable. So much information, it boggles my mind and answers so many heretofore unanswered questions (that I had, anyway). Thank you, thank you, thank you! (I am not worthy...) (Showing respect...)

[Asashosakari 18,950]

(Grabbed from the scgroup thread...)

Off topic: Itachi, a suggestion how to overcome the pasting as date when you copy from the Doitsubase to Excel: ...

That's pretty much how I import data from DB query output, too. One small addition that could make this more efficient: the ability to optionally suppress the yusho markers (Y/D/J) because those throw off the column count when separating the copied data by space character.

Low priority request, of course, but it's the type of thing that always bugs me just a tiny little bit.

[Kofuji 0]

While the sumo reference will continue to be available at sumodb.sumogames.com so links still work, I'm pleased to announce that the Doitsubase now has a domain of its own that is more fitting ... www.sumoreference.com ... I've submitted the URL to Google and linked it from the sumogames.com home page. I'll gradually add it to my other sumo-related sites.

Edited November 26, 2009 by Kofuji

[Kofuji 0]

www.sumoreference.com is now being found by Google. Please change links to this from sumodb.sumogames.com ... The more the merrier! Thanks!

[yorikiried by fate 2,001]

Deutscher Berg: Let me first express my deepest gratitude for the invaluable site. Without it, the sumo community would lack its most important resource.

For me, one small but particularly useful gem is the tool tip style mouseover info for every rikishi.

Just now I happen to wonder: Would it be hard to implement (without being a strain for performance) something similar for the links to the individual basho/banzuke sheets?

I was thinking about yusho and sansho info, something along the line of "Y: Asashoryu (25), S: Baruto (1), K: Kisenosato (9), G: -"

I would enjoy that, because it would ease the orientation in the timeline when you are viewing lists of hon-basho.

Thanks for considering.

Edited January 18, 2010 by yorikiried by fate

[Oimeru 0]

A small error report:

The day 11 juryo match Kyokunankai vs. Sagatsukasa is missing the kimarite. According to the Kyokai website it should be Yoritaoshi.

[Doitsuyama 1,173]

A small error report:

The day 11 juryo match Kyokunankai vs. Sagatsukasa is missing the kimarite. According to the Kyokai website it should be Yoritaoshi.

Thanks, corrected.

[Jokkamura 4]

I'm a fan of that kabu database, thx for that. ;-)

Would be great if you could add an overall history, same as kabu history ordered by date descending. That would give us a place to keep up with latest changes overall.

[HenryK 38]

(Grabbed from the scgroup thread...)

Off topic: Itachi, a suggestion how to overcome the pasting as date when you copy from the Doitsubase to Excel: ...

That's pretty much how I import data from DB query output, too. One small addition that could make this more efficient: the ability to optionally suppress the yusho markers (Y/D/J) because those throw off the column count when separating the copied data by space character.

Low priority request, of course, but it's the type of thing that always bugs me just a tiny little bit.

I had a different issue with pasting to excel recently: excel doesn't recoginze the black and white circles that the database uses to indicate wins or losses. Does anybody know a way around this?

Thanks,

HK

[Asashosakari 18,950]

I had a different issue with pasting to excel recently: excel doesn't recoginze the black and white circles that the database uses to indicate wins or losses. Does anybody know a way around this?

Text-only rikishi profiles, simple-style results and the new simple-style banzuke should work. Hoshitori can also be grabbed from the banzuke and torikumi sidebars.

[HenryK 38]

I had a different issue with pasting to excel recently: excel doesn't recoginze the black and white circles that the database uses to indicate wins or losses. Does anybody know a way around this?

Text-only rikishi profiles, simple-style results and the new simple-style banzuke should work. Hoshitori can also be grabbed from the banzuke and torikumi sidebars.

Thank you.

[ryafuji 810]

Just noticed a small mistake on Daijuyama's entry. His July 1989 Kantosho was his third, not his first. The error also appears on the July '89 banzuke page.

Edited January 30, 2010 by ryafuji

[Sokkenaiyama 80]

A topic on the Sumotalk forum raised a few questions for the latent number cruncher in me. First of all, is there any convenient way for the SQL-challenged of us to list rikishi by the total number of different kimarite used? Also, I'd like to know the formula for the KV50.

[Asashosakari 18,950]

A topic on the Sumotalk forum raised a few questions for the latent number cruncher in me. First of all, is there any convenient way for the SQL-challenged of us to list rikishi by the total number of different kimarite used? Also, I'd like to know the formula for the KV50.

I don't know about convenient, but one could import query outputs such as this into Excel and use a pivot table to count how many entries each rikishi has. Probably gets unwieldy if you use it for more than just sekitori bouts and without a reasonable time frame, though. (Ack, and rikishi with multiple shikona get split entries...)

For the KV50, see here.

Edited March 2, 2010 by Asashosakari

[Sokkenaiyama 80]

Thanks.

[Gusoyama 97]

if you're using excel, the easiest way to get that data from the query into kimarite/rikishi is to get the unique records from the rikishi list, and then count the number of entries in the rikishi column that match the unique identifiers.

I did it for you, though, with the query from 1989-now

http://spreadsheets.google.com/pub?key=tpV...amp;output=html

Edited March 3, 2010 by Gusoyama

[Asojima 2,873]

I did it for you, though, with the query from 1989-now

http://spreadsheets.google.com/pub?key=tpV...amp;output=html

An excellent recap. (In jonokuchi...) (Sign of approval...) This is a good candidate for addition to the pond as a quick reference.

[Gusoyama 97]

if you like, I can do it for any period of time, it literally took me 5 minutes to do.

[Flohru 176]

This got me wondering who was the last highest ranked Japanese rikishi older than Kaio now. I set the following rule for that task: The rikishi must be highest ranked Japanese (of course) and the last day of appearance is counting (usually senshuraku, but no-shows and fusenpai doesn't count).

Kaio is the oldest in more than 78 years and I found only three rikishi older than Kaio since 1909 with a surprising leader:

1) Onosato, 39 years 6 months in 1931.10 (Ozeki like Kaio)

2) Tachiyama, 39 years 5 months in 1917.01 (this guy had amazingly few losses even at advanced age)

3) Hitachiyama, 39 years 0 months in 1913.01

4) Kaio, 37 years 8 months in 2010.03 (if he appears on day 11 or later)

5) Haguroyama, 37 years 7 months in 1952.05

6) Minanogawa, 37 years 6 months in 1941.05

7) Nishinoumi, 36 years 6 months in 1927.05

8) Yoshibayama, 36 years 3 months in 1956.05

Those links remind me again of a suggestion I wanted to make some time ago (sorry if it had been discussed somewhere already): do you think it would be possible to include the days of death of deceased rikishi? I guess it wouldn't be too much work to find them out at least for the former top dogs, though I don't know if there would be any general interest in that apart from the curiosity of one mere historian...

[Gusoyama 97]

Any chance of making the scgroup matrix cut and pastable to Excel? Or does anyone have any good ways of doing this?

[Doitsuyama 1,173]

Any chance of making the scgroup matrix cut and pastable to Excel? Or does anyone have any good ways of doing this?

If I copy the matrix and paste it in Excel the result is not perfect, but good enough for me...

[Gusoyama 97]

I must have been doing something wrong yesterday, because it works today.

[VictorDiVarca 5]

How about changing column number to rank in bout matrix? Don't you think it will be easier to match dots with actual opponents, especially in the middle of table?

Edited March 12, 2010 by VictorDiVarca