In honor of day 3 of this year's Haru Basho in Osaka and the kind
services of Masumi Abe who compiled the data ...
I've written some XEmacs Lisp that takes the "Machine-readable" Sumo
statistics on
http://www.scgroup.com/sumo/format.html and puts it into
a Postgres database. Put the attached two files somewhere in
.xemacs/xemacs-packages/lisp, download the data files somewhere,
(require 'pg-sumodb) and M-x pg-sumodb-load and follow the prompts.
Tested against Postgres 6.5.3 and 7.0beta, XEmacs 21.1/21.2. If
XEmacs chokes, be sure you're running with the most recent set of
postgres patches (i.e. from about 7 hours ago).
Sample query:
SELECT count (*), k.reading as "Kimarite"
FROM all_results ar, kimarite k
WHERE ar.kimarite=k.number AND ar.rikishi='Musashimaru' AND result = 1
GROUP BY k.reading ORDER BY count DESC;
count | Kimarite
------+-----------------
108 | Yorikiri
107 | Oshidashi
24 | Oshitaoshi
18 | Yoritaoshi
...