Asashosakari 18,786 Posted September 24, 2009 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
Doitsuyama 1,173 Posted September 24, 2009 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
Babaryutaikai 1 Posted September 25, 2009 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
Asashosakari 18,786 Posted November 24, 2009 (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
Kofuji 0 Posted November 26, 2009 (edited) 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 Share this post Link to post Share on other sites
Kofuji 0 Posted December 7, 2009 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
yorikiried by fate 1,989 Posted January 18, 2010 (edited) 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 Share this post Link to post Share on other sites
Oimeru 0 Posted January 22, 2010 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
Doitsuyama 1,173 Posted January 22, 2010 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
Jokkamura 4 Posted January 22, 2010 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
HenryK 38 Posted January 22, 2010 (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
Asashosakari 18,786 Posted January 22, 2010 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
HenryK 38 Posted January 22, 2010 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
ryafuji 807 Posted January 30, 2010 (edited) 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 Share this post Link to post Share on other sites
Sokkenaiyama 76 Posted March 1, 2010 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
Asashosakari 18,786 Posted March 2, 2010 (edited) 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 Share this post Link to post Share on other sites
Gusoyama 95 Posted March 3, 2010 (edited) 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 Share this post Link to post Share on other sites
Asojima 2,870 Posted March 3, 2010 I did it for you, though, with the query from 1989-nowhttp://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. Share this post Link to post Share on other sites
Gusoyama 95 Posted March 3, 2010 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
Flohru 176 Posted March 4, 2010 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
Gusoyama 95 Posted March 9, 2010 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
Doitsuyama 1,173 Posted March 10, 2010 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
Gusoyama 95 Posted March 10, 2010 I must have been doing something wrong yesterday, because it works today. Share this post Link to post Share on other sites
VictorDiVarca 5 Posted March 12, 2010 (edited) 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 Share this post Link to post Share on other sites