Sign in to follow this  
aderechelsea

Sumo Reference Website Down?

Recommended Posts

i don't know if this is the right place to post this topic but here goes .... (Clapping wildly...)

as i mentioned in the past i am completely illiterate when it comes to database queries. I don't know why but all these parameters in the query page make me insane and i barely ever get any results similar to what i was looking for.

my problem this time is the following...

i noticed the high percentage of okuri-something wins for Kaiho (not very strange though if you know his style of fighting) and i wanted to make a comparison to the rest of the sekitori (maybe include some retired ones too) and i wanted to avoid doing that manually. Is there any chance of doing this?

please instruct me and i will buy you a beer when we meet. :-P

:-)

Share this post


Link to post
Share on other sites

The database queries does not give percentages since you'd have to define which values to compare which would become quite complex. I've thought about enriching the interface with such options, and likely I will do so, though not in the near future. Anyway, I doubt a more complex interface is what you are looking for. :-)

For now, I really recommend the "Bouts by kimarite" page, which even works without queries. :-P Here is the one for Kaiho. For all kimarite (Kaiho had) you also get the overall percentage as a reference which looks like you are looking for. The overall percentage is calculated during the time the rikishi was active, so it will vary slightly between rikishi (or not so slightly in case of big shifts in kimarite usage).

Kaiho had 41 okuridashi, about 9% of his wins, while the overall percentage for okuridashi is about 3%, so your hunch is correct. It's similar for okuritaoshi (1.53% to 0.56%) and of course his single okurinage (0.22% to 0.04%).

Edit: No, I don't think off-topic is a good sub-forum for this. Should be moved to Ozumo discussions where the other Sumo Reference topics are too.

Edited by Doitsuyama

Share this post


Link to post
Share on other sites
i don't know if this is the right place to post this topic but here goes .... (Clapping wildly...)

as i mentioned in the past i am completely illiterate when it comes to database queries. I don't know why but all these parameters in the query page make me insane and i barely ever get any results similar to what i was looking for.

my problem this time is the following...

i noticed the high percentage of okuri-something wins for Kaiho (not very strange though if you know his style of fighting) and i wanted to make a comparison to the rest of the sekitori (maybe include some retired ones too) and i wanted to avoid doing that manually. Is there any chance of doing this?

please instruct me and i will buy you a beer when we meet. :-P

:-)

I am also not the most experienced querier...

However, I used the bout query, entered the career points of Kaiho in the "basho" field (199601-200707), chose "wins only" and kimarite "okuridashi", and sorted results by rikishi1. This at least gave me the absolute number of okuridashi wins during Kaiho's career.

If you go to Kaiho's page and choose "Show all bouts by kimarite" you can see that his okuridashi percentage is about 9% as compared to 3% for all other rikishi. As far as I know these percentages do not take into account the full history of ozumou, but only those bouts which were taking place during Kaiho's career.

I don't think that this is sufficient for a beer because it's not exactly what you've been asking for. But a Coke will do it for starters. (Clapping wildly...)

Share this post


Link to post
Share on other sites
Kaiho had 41 okuridashi, about 9% of his wins, while the overall percentage for okuridashi is about 3%, so your hunch is correct. It's similar for okuritaoshi (1.53% to 0.56%) and of course his single okurinage (0.22% to 0.04%).

thanks a lot for your answer ... :-)

i have made a small research manually for other rikishi like Tokitenku or Ama but i was wondering if it was possible to get a list easier. I realize it is not easy but your work never seases to amaze me and that's why i was thinking there might be more than i found by myself.

the comparison results between Kaiho's and overall percentage don't surprise me because i cannot think of another rikishi that has an actuall strategy of doing well-timed inashi and then try to get from behind. I am glad my "feeling" was on spot.

Share this post


Link to post
Share on other sites
I don't think that this is sufficient for a beer because it's not exactly what you've been asking for. But a Coke will do it for starters. :-P

if not for anything more, i'll get you a beer too just for taking the time to answer my silly question ....

(Clapping wildly...)

EDIT: another "suspect" of high percentage of okuri wins was Kyokushuzan and he is standing at 6.08% .... (i think i found a new "toy" ... hehehe :-) )

Edited by aderechelsea

Share this post


Link to post
Share on other sites

That's not going to be the answer you're looking for, adere, but questions like these are when I fire up Excel and copy the output from several queries into a spreadsheet for further processing... Of course, that tends to make things more complicated rather than easier.

BTW, as a long-term suggestion, I'd really like the kimarite box in the bout query to be multi-selectable...

Edited by Asashosakari

Share this post


Link to post
Share on other sites
i have made a small research manually for other rikishi like Tokitenku or Ama but i was wondering if it was possible to get a list easier. I realize it is not easy but your work never seases to amaze me and that's why i was thinking there might be more than i found by myself.

Hmm, it looks like you found that "Bouts by kimarite" page already. Since your question was about the bout query feature originally, I will concentrate a bit on that to help in your research. You can narrow down the field of potential rikishi if you group them by okuridashi wins, here is the query definition for this (restricted to makuuchi and juryo here). Look at that and try to play around with it, and maybe you will find the bout query not so complicated as it seems at first.

From this query result you can follow the links to the rikishi and look in the "Bouts by kimarite" page for the okuridashi ratio. You will find that only Asanowaka and Terao had more okuridashi wins than Kaiho as a sekitori, but a lower percentage, Asanowaka 8.24% and Terao 5.41%. Higonoumi with 7.73%, Daio with 7.13%, ozeki Kirishima with 6.55% and Kyokushuzan with 6.08% also had a high okuridashi ratio.

Share this post


Link to post
Share on other sites
From this query result you can follow the links to the rikishi and look in the "Bouts by kimarite" page for the okuridashi ratio. You will find that only Asanowaka and Terao had more okuridashi wins than Kaiho as a sekitori, but a lower percentage, Asanowaka 8.24% and Terao 5.41%. Higonoumi with 7.73%, Daio with 7.13%, ozeki Kirishima with 6.55% and Kyokushuzan with 6.08% also had a high okuridashi ratio.

Asanowaka was the one i looked up after Kyokushuzan .... (Showing respect...)

the rest of them are interesting additions to my "mental list" of okuri experts. So .... is Kaiho the all-time leader in the percentage list? (Holiday feeling...)

Share this post


Link to post
Share on other sites

Some Excel magic gives me this (rikishi with >=50 Makuuchi wins since 1949.05, all okuri* techniques combined, bouts as Makuuchi rikishi only):

Shikona

Wins

okuri

okuri%

Daio

57

8

14.04%

Naminohana

117

15

12.82%

Kaiho

306

34

11.11%

Asanowaka

346

37

10.69%

Enazakura

175

18

10.29%

Higonoumi

335

33

9.85%

Kiraiho

177

17

9.60%

Hamanoshima

293

27

9.22%

Ama

135

12

8.89%

Kenko

181

16

8.84%

Aminishiki

299

26

8.70%

Tomonohana

104

9

8.65%

Toyozakura

81

7

8.64%

Kyokudozan

325

28

8.62%

Kototsubaki

100

8

8.00%

Takamisakari

250

20

8.00%

Kyokushuzan

408

32

7.84%

Aogiyama

223

17

7.62%

Mainoumi

241

18

7.47%

Kitazakura

67

5

7.46%

Kirishima

519

38

7.32%

Daishi

145

10

6.90%

Terao

626

43

6.87%

Wakanoyama

204

14

6.86%

Shiratayama

88

6

6.82%

Kotomitsuki

355

24

6.76%

Daishoho

222

15

6.76%

Kitakachidoki

331

22

6.65%

Wakanojo

78

5

6.41%

Wakanohana

488

31

6.35%

Kasuganishiki

95

6

6.32%

Tokitenku

128

8

6.25%

Tamarikido

65

4

6.15%

Toyonoshima

116

7

6.03%

Shinko

50

3

6.00%

Futatsuryu

186

11

5.91%

Kakizoe

170

10

5.88%

Ushiomaru

68

4

5.88%

Akinoshima

647

38

5.87%

Kotonowaka

608

35

5.76%

Kotoinazuma

405

23

5.68%

Yoshikaze

56

3

5.36%

Gojoro

113

6

5.31%

Kaio

706

37

5.24%

Asanosho

213

11

5.16%

Tamakasuga

409

21

5.13%

Asahifuji

488

25

5.12%

Daizen

235

12

5.11%

Yoshinomine

157

8

5.10%

Other currently active (plus some recently-retired) rikishi:

Shikona

Wins

okuri

okuri%

Asashoryu

469

23

4.90%

Takanohana

707

34

4.81%

Takatoriki

505

24

4.75%

Musashimaru

709

33

4.65%

Takekaze

156

7

4.49%

Otsukasa

179

8

4.47%

Asasekiryu

203

9

4.43%

Roho

139

6

4.32%

Tosanoumi

521

22

4.22%

Chiyotenzan

144

6

4.17%

Jumonji

222

9

4.05%

Kotooshu

173

7

4.05%

Miyabiyama

396

16

4.04%

Toki

249

10

4.02%

Shimotori

150

6

4.00%

Tochiazuma

484

19

3.93%

Tochinohana

155

6

3.87%

Oginishiki

299

11

3.68%

Musoyama

520

18

3.46%

Tochisakae

149

5

3.36%

Mitoizumi

530

17

3.21%

Tokitsuumi

317

10

3.15%

Buyuzan

167

5

2.99%

Hokutoriki

215

6

2.79%

Tochinonada

431

12

2.78%

Takanowaka

229

6

2.62%

Iwakiyama

200

5

2.50%

Kokkai

162

4

2.47%

Kotoryu

325

8

2.46%

Hakurozan

83

2

2.41%

Hayateumi

126

3

2.38%

Wakanosato

388

9

2.32%

Kasugao

136

3

2.21%

Chiyotaikai

513

11

2.14%

Kinkaiyama

102

2

1.96%

Hakuho

211

4

1.90%

Akebono

573

10

1.75%

Kyokutenho

371

5

1.35%

Kotoshogiku

115

1

0.87%

Dejima

471

4

0.85%

Kisenosato

134

1

0.75%

Futeno

145

0

0.00%

Homasho

68

0

0.00%

Edited by Asashosakari

Share this post


Link to post
Share on other sites

(Showing respect...) (Shaking head...)

exactly what i was looking for ..... (Holiday feeling...)

Share this post


Link to post
Share on other sites

I can't access the "Sumo Reference" site. Is the reason because of the server being down, or ????

It gives me the following message:

Network Error (tcp_error)

A communication error occurred: "Operation timed out" The Web Server may be down, too busy, or experiencing other problems preventing it from responding to requests. You may wish to try again at a later time.

Regards:

Achiyama

Share this post


Link to post
Share on other sites

OK fess up... Who asked the database when will Kisenosato make yokozuna?

You know how supercomputers tend to go on a strike (i.e. sulk) when faced with impossible questions...

  • Like 1

Share this post


Link to post
Share on other sites

I can't access the "Sumo Reference" site. Is the reason because of the server being down, or ????

The site is down.

Share this post


Link to post
Share on other sites

I can't access the "Sumo Reference" site. Is the reason because of the server being down, or ????

The site is down.

Is there a chance the site to be back on soon or not?

Edited by Achiyama

Share this post


Link to post
Share on other sites

I can't access the "Sumo Reference" site. Is the reason because of the server being down, or ????

The site is down.

Is there a chance the site to be back on soon or not?

We don't know. We hope it will be back for the basho. People are trying to fix it.

Share this post


Link to post
Share on other sites

Sorry if there are better places for this post. Sumo Reference appears to be down. Any prognosis? I am sure efforts are being made, I was just wondering as the new Banzuke comes out tomorrow Japan time. Thanks for your efforts to those who run Sumo Ref, I love it.

Share this post


Link to post
Share on other sites

Try this link for the moment. More infos are already in the Sumo Games subforum. Doitsu is moving the stuff around.

Thanks for the link Yorikiried by fate. It worked!

Regards,

Achiyama

Edited by Achiyama

Share this post


Link to post
Share on other sites

Thanks to the sumo gods for moving my post. I would have never thought to look in "sumo games" for reference info, but it makes sense now.. maybe. :-)

Share this post


Link to post
Share on other sites

For several days I have no access to Sumo Reference :-|

Is there only an update or has the page moved?

Share this post


Link to post
Share on other sites

I definitely hope it will be back before the basho starts! It is an amazing site for information.

Swami

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
Sign in to follow this