I seem to be recognizing more and more people at the races I am running. At first, people would come up to me and say "I remember seeing your 'We Will Not Fail' sign on your shirt at ...". I thought It was amazing that I kept seeing familier at places. I saw the Crazy Squirrel Lady from Hartford, MCM and Boston, then Ben Navarrete in Detroit, LA, and NJ, got an idea:
Get a list of all the people who ran all the races I've run, and sort through them.
So I wrote a program that hit MarathonGuide's Database, and grabbed the data, and parsed it.
Massaging it took some time. Firstly, races gather different and report race data differently. Secondly, Alot of people seem to have the same name. And races dont always use the same spelling of peoples names. And there are II's and Jr's. And they move. And there are a lot of people who run the monsters of NY, Chicago, Marine Corps and Boston. Yikes.
I figured it was no big deal to run one Marathon with someone, and I wouldn't display someone that ran only the monsters with me...
The algorythm looks something like this:
For each race that I have run For each runner in that race For each race after the current one For each runner in that race If I havent looked at this runner for this race And this name equals that name And the the age of this runner is circa that runner's age Print him out and Add him to the list Its more efficient than this, as it keeps track of where in the alphabet the names really are, which is about 500x faster then this brut force method.
I looked at about 300000 runners in 59 races and found approximately 19000 people that I have run more 2 or more with. Here is the top, with 10+ (19 of them)...17 criniti francesco
Here's the whole list. (Caution: 4.1 meg).
Ben Navarrete comes in with only 7.
Updated April 22nd, 2015