I went through the nearly 700 Brin-l addresses in my database (84,752 messages, about 502 people with 612 addresses) and mapped the ones that I'm fairly sure belong to the same people. Here's how the Top 25 standings come out (still affected by my apparent missing data from October -- anybody got an mbox archive that includes it?). The addresses shown here are the first ones that the database found. See below for the variants.
(And as I send this, I realize that none of it answers Jon's original question, which I'll now tackle.) +----------------------------------------------+----------+ | pseudonym | count(*) | +----------------------------------------------+----------+ | [EMAIL PROTECTED] | 3253 | | [EMAIL PROTECTED] | 3138 | | [EMAIL PROTECTED] | 2820 | | [EMAIL PROTECTED] | 2773 | | [EMAIL PROTECTED] | 2619 | | [EMAIL PROTECTED] | 2414 | | [EMAIL PROTECTED] | 2398 | | [EMAIL PROTECTED] | 2238 | | [EMAIL PROTECTED] | 2015 | | [EMAIL PROTECTED] | 1920 | | [EMAIL PROTECTED] | 1692 | | [EMAIL PROTECTED] | 1607 | | [EMAIL PROTECTED] | 1572 | | [EMAIL PROTECTED] | 1545 | | [EMAIL PROTECTED] | 1530 | | [EMAIL PROTECTED] | 1357 | | [EMAIL PROTECTED] (Vera Horiuchi) | 1347 | | [EMAIL PROTECTED] | 1319 | | [EMAIL PROTECTED] (Kristin A. Ruhle) | 1276 | | [EMAIL PROTECTED] | 1249 | | [EMAIL PROTECTED] | 1202 | | [EMAIL PROTECTED] | 1092 | | [EMAIL PROTECTED] | 1072 | | [EMAIL PROTECTED] | 1050 | | [EMAIL PROTECTED] | 1006 | +----------------------------------------------+----------+ Since Jan. 1, 2002: +----------------------------------------------+----------+ | pseudonym | count(*) | +----------------------------------------------+----------+ | [EMAIL PROTECTED] | 1770 | | [EMAIL PROTECTED] | 1384 | | [EMAIL PROTECTED] | 1192 | | [EMAIL PROTECTED] | 1172 | | [EMAIL PROTECTED] | 945 | | [EMAIL PROTECTED] | 868 | | [EMAIL PROTECTED] | 849 | | [EMAIL PROTECTED] | 833 | | [EMAIL PROTECTED] | 751 | | [EMAIL PROTECTED] | 652 | | [EMAIL PROTECTED] | 590 | | [EMAIL PROTECTED] | 564 | | [EMAIL PROTECTED] | 482 | | [EMAIL PROTECTED] | 473 | | [EMAIL PROTECTED] | 460 | | [EMAIL PROTECTED] | 458 | | [EMAIL PROTECTED] | 395 | | [EMAIL PROTECTED] | 341 | | [EMAIL PROTECTED] | 330 | | [EMAIL PROTECTED] | 308 | | [EMAIL PROTECTED] | 306 | | [EMAIL PROTECTED] | 281 | | [EMAIL PROTECTED] | 254 | | [EMAIL PROTECTED] | 250 | | [EMAIL PROTECTED] | 243 | +----------------------------------------------+----------+ Since June 1, 2002: +----------------------------------------------+----------+ | pseudonym | count(*) | +----------------------------------------------+----------+ | [EMAIL PROTECTED] | 936 | | [EMAIL PROTECTED] | 890 | | [EMAIL PROTECTED] | 708 | | [EMAIL PROTECTED] | 659 | | [EMAIL PROTECTED] | 585 | | [EMAIL PROTECTED] | 454 | | [EMAIL PROTECTED] | 443 | | [EMAIL PROTECTED] | 440 | | [EMAIL PROTECTED] | 430 | | [EMAIL PROTECTED] | 321 | | [EMAIL PROTECTED] | 301 | | [EMAIL PROTECTED] | 261 | | [EMAIL PROTECTED] | 261 | | [EMAIL PROTECTED] | 258 | | [EMAIL PROTECTED] | 254 | | [EMAIL PROTECTED] | 251 | | [EMAIL PROTECTED] | 242 | | [EMAIL PROTECTED] | 223 | | [EMAIL PROTECTED] | 213 | | [EMAIL PROTECTED] | 185 | | [EMAIL PROTECTED] | 184 | | [EMAIL PROTECTED] | 179 | | [EMAIL PROTECTED] | 167 | | [EMAIL PROTECTED] | 158 | | [EMAIL PROTECTED] | 126 | +----------------------------------------------+----------+ Anybody who has used remarkably different addresses over the years, please feel free to advise me. Jeroen, do you have some mappings that you use? We should compare our data. And Julia, are you [EMAIL PROTECTED] and/or [EMAIL PROTECTED]? We may be able to boost your standings... Finally... if you really want to be helpful, see if there are any errors in this list of mappings (addresses with the same person_id are mapped to one another): +---------------------------------------------------+-----------+ | pseudonym | person_id | +---------------------------------------------------+-----------+ | [EMAIL PROTECTED] | 613 | | [EMAIL PROTECTED] | 613 | | [EMAIL PROTECTED] | 615 | | [EMAIL PROTECTED] | 615 | | [EMAIL PROTECTED] | 615 | | [EMAIL PROTECTED] | 623 | | [EMAIL PROTECTED] | 623 | | [EMAIL PROTECTED] | 623 | | [EMAIL PROTECTED] | 623 | | [EMAIL PROTECTED] | 623 | | [EMAIL PROTECTED] | 638 | | [EMAIL PROTECTED] | 638 | | [EMAIL PROTECTED] | 638 | | [EMAIL PROTECTED] | 638 | | [EMAIL PROTECTED] | 654 | | [EMAIL PROTECTED] | 654 | | [EMAIL PROTECTED] | 654 | | [EMAIL PROTECTED] | 654 | | [EMAIL PROTECTED] | 654 | | [EMAIL PROTECTED] | 655 | | [EMAIL PROTECTED] | 655 | | [EMAIL PROTECTED] | 655 | | [EMAIL PROTECTED] | 656 | | [EMAIL PROTECTED] | 656 | | [EMAIL PROTECTED] | 656 | | [EMAIL PROTECTED] | 656 | | [EMAIL PROTECTED] | 657 | | [EMAIL PROTECTED] | 657 | | [EMAIL PROTECTED] | 657 | | [EMAIL PROTECTED] | 671 | | [EMAIL PROTECTED] | 671 | | [EMAIL PROTECTED] | 672 | | [EMAIL PROTECTED] | 672 | | [EMAIL PROTECTED] (d.brin) | 675 | | [EMAIL PROTECTED] | 675 | | [EMAIL PROTECTED] | 676 | | [EMAIL PROTECTED] | 676 | | [EMAIL PROTECTED] | 678 | | [EMAIL PROTECTED] | 678 | | [EMAIL PROTECTED] | 684 | | [EMAIL PROTECTED] (Yanni Cooper) | 684 | | [EMAIL PROTECTED] | 697 | | [EMAIL PROTECTED] | 697 | | [EMAIL PROTECTED] | 697 | | [EMAIL PROTECTED] | 700 | | [EMAIL PROTECTED] | 700 | | [EMAIL PROTECTED] | 707 | | [EMAIL PROTECTED] | 707 | | [EMAIL PROTECTED] (Brett Coster) | 707 | | [EMAIL PROTECTED] | 707 | | [EMAIL PROTECTED] | 724 | | [EMAIL PROTECTED] (Yang Li Hector Yee) | 724 | | [EMAIL PROTECTED] | 729 | | [EMAIL PROTECTED] | 729 | | [EMAIL PROTECTED] | 729 | | [EMAIL PROTECTED] | 734 | | [EMAIL PROTECTED] | 734 | | [EMAIL PROTECTED] (John D. Giorgis) | 737 | | [EMAIL PROTECTED] | 737 | | [EMAIL PROTECTED] | 737 | | [EMAIL PROTECTED] | 749 | | [EMAIL PROTECTED] | 749 | | [EMAIL PROTECTED] | 749 | | [EMAIL PROTECTED] | 749 | | [EMAIL PROTECTED] | 749 | | [EMAIL PROTECTED] | 749 | | [EMAIL PROTECTED] | 755 | | [EMAIL PROTECTED] | 755 | | [EMAIL PROTECTED] | 760 | | [EMAIL PROTECTED] | 760 | | [EMAIL PROTECTED] | 760 | | [EMAIL PROTECTED] | 760 | | [EMAIL PROTECTED] | 760 | | [EMAIL PROTECTED] | 791 | | [EMAIL PROTECTED] | 791 | | [EMAIL PROTECTED] | 797 | | [EMAIL PROTECTED] | 797 | | [EMAIL PROTECTED] | 820 | | [EMAIL PROTECTED] | 820 | | [EMAIL PROTECTED] | 827 | | [EMAIL PROTECTED] | 827 | | [EMAIL PROTECTED] | 827 | | [EMAIL PROTECTED] | 827 | | [EMAIL PROTECTED] | 837 | | [EMAIL PROTECTED] | 837 | | [EMAIL PROTECTED] | 852 | | [EMAIL PROTECTED] | 852 | | [EMAIL PROTECTED] | 852 | | [EMAIL PROTECTED] | 852 | | [EMAIL PROTECTED] | 852 | | [EMAIL PROTECTED] | 855 | | [EMAIL PROTECTED] | 855 | | [EMAIL PROTECTED] | 863 | | [EMAIL PROTECTED] | 863 | | [EMAIL PROTECTED] | 863 | | [EMAIL PROTECTED] | 870 | | [EMAIL PROTECTED] | 870 | | [EMAIL PROTECTED] | 902 | | [EMAIL PROTECTED] | 902 | | [EMAIL PROTECTED] | 903 | | [EMAIL PROTECTED] | 903 | | [EMAIL PROTECTED] | 912 | | [EMAIL PROTECTED] | 912 | | [EMAIL PROTECTED] | 921 | | [EMAIL PROTECTED] | 921 | | [EMAIL PROTECTED] | 921 | | [EMAIL PROTECTED] (Kosh) | 922 | | [EMAIL PROTECTED] (Eythain Lazh) | 922 | | [EMAIL PROTECTED] | 926 | | [EMAIL PROTECTED] (Ronaldo Nguyen Carpio) | 926 | | [EMAIL PROTECTED] (Jonathan Schattke) | 932 | | [EMAIL PROTECTED] | 932 | | [EMAIL PROTECTED] (K. Feete) | 941 | | [EMAIL PROTECTED] | 941 | | [EMAIL PROTECTED] (RCHASE) | 949 | | [EMAIL PROTECTED] | 949 | | [EMAIL PROTECTED] | 949 | | [EMAIL PROTECTED] | 971 | | [EMAIL PROTECTED] | 971 | | [EMAIL PROTECTED] | 976 | | [EMAIL PROTECTED] | 976 | | [EMAIL PROTECTED] | 977 | | [EMAIL PROTECTED] | 977 | | [EMAIL PROTECTED] | 978 | | [EMAIL PROTECTED] | 978 | | [EMAIL PROTECTED] | 994 | | [EMAIL PROTECTED] | 994 | | [EMAIL PROTECTED] (Vera Horiuchi) | 994 | | [EMAIL PROTECTED] | 999 | | [EMAIL PROTECTED] | 999 | | [EMAIL PROTECTED] | 1004 | | [EMAIL PROTECTED] (Kristin A. Ruhle) | 1004 | | [EMAIL PROTECTED] | 1018 | | [EMAIL PROTECTED] | 1018 | | [EMAIL PROTECTED] (Steinn Sigurdsson) | 1028 | | [EMAIL PROTECTED] (Steinn Sigurdsson) | 1028 | | [EMAIL PROTECTED] | 1034 | | [EMAIL PROTECTED] | 1034 | | [EMAIL PROTECTED] | 1038 | | [EMAIL PROTECTED] | 1038 | | [EMAIL PROTECTED] | 1048 | | [EMAIL PROTECTED] | 1048 | | [EMAIL PROTECTED] | 1048 | | [EMAIL PROTECTED] | 1048 | | [EMAIL PROTECTED] | 1051 | | [EMAIL PROTECTED] | 1051 | | [EMAIL PROTECTED] | 1060 | | [EMAIL PROTECTED] | 1060 | | [EMAIL PROTECTED] (Gord Sellar) | 1078 | | [EMAIL PROTECTED] | 1078 | | [EMAIL PROTECTED] (Gordon A. Sellar) | 1078 | | [EMAIL PROTECTED] | 1078 | | [EMAIL PROTECTED] (Gord Sellar) | 1078 | | [EMAIL PROTECTED] | 1087 | | [EMAIL PROTECTED] | 1087 | | [EMAIL PROTECTED] | 1094 | | [EMAIL PROTECTED] ( Vasu Kengeri) | 1094 | | [EMAIL PROTECTED] | 1121 | | [EMAIL PROTECTED] | 1121 | | [EMAIL PROTECTED] | 1121 | | [EMAIL PROTECTED] | 1129 | | [EMAIL PROTECTED] | 1129 | | [EMAIL PROTECTED] | 1143 | | [EMAIL PROTECTED] | 1143 | | [EMAIL PROTECTED] (Patrick S Schlichtenmyer) | 1169 | | [EMAIL PROTECTED] (Patrick Schlichtenmyer) | 1169 | | [EMAIL PROTECTED] | 1169 | | [EMAIL PROTECTED] | 1191 | | [EMAIL PROTECTED] | 1191 | | [EMAIL PROTECTED] (Robert D. Clark) | 1207 | | [EMAIL PROTECTED] (Robert Douglas Clark) | 1207 | | [EMAIL PROTECTED] | 1207 | | [EMAIL PROTECTED] | 1210 | | [EMAIL PROTECTED] | 1210 | | [EMAIL PROTECTED] | 1214 | | [EMAIL PROTECTED] | 1214 | | [EMAIL PROTECTED] | 1214 | | [EMAIL PROTECTED] | 1224 | | [EMAIL PROTECTED] | 1224 | +---------------------------------------------------+-----------+ P.S. For those who care... here's some SQL that generated this stuff. Table sf is where the meta-data from each message lives; table sf_person contains pseudonyms and ids. For rankings, this is the query, with the WHERE part removed for all-time counts or changed for whatever date wanted: SELECT sf.pseudonym, COUNT(*) FROM sf_person, sf WHERE sf_person.pseudonym=sf.pseudonym AND posting_date_time >= "2002-06-01" GROUP BY sf_person.person_id ORDER BY 2 DESC LIMIT 25; To find the mappings, two steps: CREATE TABLE tmp SELECT COUNT(*) AS count, pseudonym, person_id FROM sf_person GROUP BY person_id HAVING count>1 SELECT sf_person.pseudonym,sf_person.person_id FROM tmp, sf_person WHERE tmp.person_id=sf_person.person_id ORDER BY tmp.person_id; _______________________________________________ http://www.mccmedia.com/mailman/listinfo/brin-l
