Doitsuyama

Sumo Reference Updates

426 posts in this topic

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?

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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...)

Share this post


Link to post
Share on other sites

(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.

Share this post


Link to post
Share on other sites

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 by Kofuji

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by yorikiried by fate

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
(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

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites
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.

Share this post


Link to post
Share on other sites

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 by ryafuji

Share this post


Link to post
Share on other sites

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.

Share this post


Link to post
Share on other sites
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 by Asashosakari

Share this post


Link to post
Share on other sites

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 by Gusoyama

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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...

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites
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...

Share this post


Link to post
Share on other sites

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

Share this post


Link to post
Share on other sites

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 by VictorDiVarca

Share this post


Link to post
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!


Register a new account

Sign in

Already have an account? Sign in here.


Sign In Now