Help for the query form

Settings
Show sansho
Show total wins
 

Select how many columns you want displayed. Tick the desired checkboxes for displaying total number of wins and sansho in the search result. Show sansho will be on by default if any of the search constraints include sansho.

Rikishi
Include changes

Enter a search pattern in the Shikona field to find rikishi with a matching shikona.

Example: to find Chiyotaikai, simply write Chiyotaikai in the search field.

You can also use wildcards * and ?, where * means match anything, and ? means match exactly one character. The whole pattern has to match.

Examples:
write koto* to search for rikishi starting with Koto.
write *azuma* to search for rikishi with azuma anywhere in their shikona.

The search is case-insensitive.

More than one shikona can be entered, seperate them with a comma.

You can enter the shikona in English or Japanese (either kanji or kana is possible, but not mixed).

Ticking the checkbox Include changes enables you to include results under a different shikona – the only condition here is that the searched shikona must have been used at some time in his career

Example: writing Takamisakari and ticking the checkbox Include changes will also find his results under his former shikona Kato.

Select a heya or a shusshin (= birth place) to restrict the search results to rikishi with the selected heya or shusshin.

You can also specify All Japanese or All foreigners.

Note that several of the Japanese shusshin are historic and not in usage anymore since 1946.

Wins over consecutive basho
wins over basho starting with number

Specify how many wins you want over a number of consecutive basho.

Example: You want to view results with at least 33 wins over basho 2-4. Select At least, enter 33 wins over 3 basho starting with number 2.

Tick the checkbox if you want the sum over these basho displayed. If you want to see the sum but don't want to restrict the search, just enter At least 0 wins and check Show total wins over these basho.

Group similar results
and require

You can group search results by basho or by rikishi.

Example: search for rank O and group by rikishi. The result will be a table with the rikishi with most basho at the ozeki rank, and number of basho at the rank.

When grouping by basho, all basho will be returned (as far as allowed by the Year or Month constraint). Basho without matching results will be listed with 0 matches, naturally.

You can also restrict to finding basho/rikishi with at least, at most or exactly the number of matches. Requiring 0 matches is not possible for grouping by rikishi.

If Expand result is not checked (default), you will get a summary with just the number of matches for each basho/rikishi. If the checkbox is checked, you will get the full query result (same as without grouping) but the results for each basho/rikishi will be marked and kept together. Exception: if at most 0 or exactly 0 is selected, Expand result will have no effect.

By default, two fieldsets with Basho constraints are shown below. If you want to specify constraints for more basho than there are basho forms, click the More basho button. Clicking the Fewer basho button removes the last basho form.

Basho constraints
Rank
Wins
Losses
Year
Month
Yusho
Division
Debut
Sansho
 

Basho

Basho is the column number of the basho for which you want to specify constraints. Example: if you have selected to show 3 basho, Basho can be 1, 2 or 3.

Highlight only

If the Highlight only checkbox is checked, no filtering will be done on the selected criteria. Instead all matching results will be highlighted. You can choose to highlight results for one or more columns, and a column may also have more than one highlight condition.

Rank

Rank can be specified in a number of ways:

  • Y
  • sandanme
  • k-m
  • M
  • Ms1W
  • M2-M4w
  • M1E, M2-M4
Sanyaku
Regardless of whether there are two or more yokozuna on the banzuke, writing YE or YW will only select the two east or west yokozuna, and analogous for the rest of sanyaku.
Y means any yokozuna, Y1E is equivalent to YE. Y1 means YE and YW, Y2 means Y2E and Y2W etc. If you want to specify all east yokozuna regardless of number, write Y1E, Y2E, Y3E. The same goes for the rest of sanyaku.
Maegashira and lower divisions
Ranges are very useful here. m3-m1 will work, and so will M14-J2 or M2W-M4, but not M6-8 (write M6-M8 instead). Just M will select all maegashira, as does J, Ms, Sd, Jd and Jk for the lower divisions. Mz selects Mae-zumo, while Bg gets all Banzuke-gai rikishi.
To specify “maegashira 10 or lower maegashira”, write M10-M23.
Lower division records are complete only for Nagoya 1988 and later. Before that only yusho winners, playoff participants and other scattered results are in the database.

Wins and Losses

Wins and Losses can be specified as ranges and/or comma-separated, just like rank.

Shorthand notations: kk for kachi-koshi (majority of wins), mk for make-koshi (majority of losses) and zensho (only wins).

  • This will work even when the number of days in a basho is not 15.
  • Draws are marked with a small d, azukari (another form of draw) are marked with a small a in the tables.

Year

Year can be specified as ranges and/or comma-separated, just like rank.

The year has to be specified with 4 digits. The notation now in the Year field means the current year.

You can also enter specific basho (or ranges of basho) instead of years. They can be written with six digits of year and month (e.g. 200703) or with a dot between year and month (e.g. 2007.03). Years and basho also may be mixed (e.g. 2005-2006.07).

Month

Months can be specified as ranges and/or comma-separated, just like wins.

Since specific basho can be entered in the year field already, the month field is necessary only for questions like “Who had the most yusho in the Kyushu basho?”.

Yusho

Yusho is yusho (division championship), Jun-yusho is runner-up including yusho-doten (playoff loss, marked with D in the tables).

Division

By default, all matching results regardless of division are included. If you don't want that, tick one or more of the Division checkboxes.

Please note that lower division records before Nagoya 1988 are quite incomplete.

Debut

With the Debut checkboxes you can search for first appearances at a certain position on the banzuke.

  • Division finds division debuts (first time in makuuchi, juryo or one of the lower divisions).
  • Rank finds rikishi who are on a new career high rank in that basho.

Combine the debut checkboxes with other constraints to find more specific debuts. For instance, check debut Division (or Rank) and enter M1-M9 in the Rank text field to find makuuchi debuts at maegashira 9 or higher.

Sansho

  • Shukun-sho = Outstanding Performance Prize
  • Kanto-sho = Fighting Spirit Prize
  • Gino-sho = Technique Prize

If any of the sansho checkboxes are checked, sansho will automatically be displayed in the search result, even if SettingsShow sansho isn't checked.