The case of Missing Mordecai Brown

[david limbaugh]

You said:
ready to look at some .csv files?
Copilot said:
Copilot
Absolutely. 😄

Given this Mordecai investigation, CSVs are probably where the real evidence lives.

Upload the .csv file(s), and I'll help:

Compare player records across seasons
Check whether Mordecai's player ID changes
Find when he disappears from databases
Compare batting/pitching/history tables
Track leaderboard eligibility
Look for orphaned records (stats exist but player record is gone)
Identify exactly which offseason transaction/event coincides with the disappearance
If you've got multiple CSVs from different dates/saves, even better—we can treat it like a forensic audit and build a timeline of the disappearance.

🕵️*♂️ Case Status:

Last known sighting: 9/14/1918
Missing by: 4/19/1919
Prime suspect: offseason player-retirement/deletion process
Next witnesses: CSV files
Send them over and let's interrogate the evidence. ⚾📂








image.png
You said:
time flies! lol
Copilot said:
Copilot
🤣 Time definitely flies when you're investigating a century-old disappearance.

And look at that backup ETA now:

Elapsed: 15:08
Remaining: 1:37:33
Progress: 13%
Processed: 5.99 GB of 44.6 GB
Speed: 6.7 MB/s
Remember when 7-Zip claimed 4:37:15 remaining at 1%?

OOTP Detective notes:

Suspect: 7-Zip ETA
Charge: Providing false statements to investigators.

😂

What's funny is that while the backup is chugging along, we've already made more progress on the Mordecai case than we expected:

Established Facts
9/14/1918

Mordecai Brown exists.
Career stats present.
259 wins.
Unemployed free agent.
Search finds him.
4/19/1919

Search for "mord" returns nothing.
Mordecai absent from career wins leaderboard.
Yet the 1918 Almanac still contains his career totals.
That's a pretty compelling disappearance window.

What I find most intriguing
The Almanac still "remembers" him.

His 1918 totals exist:

259 Wins
200 Losses
2.28 ERA
4264.1 IP
83.2 WAR
But the career records page behaves as if he never existed.

That's the kind of inconsistency that smells like:

player record removed
historical record retained
leaderboard rebuild skipping the missing player
In detective terms:

The fingerprints are still at the crime scene, but the suspect has vanished.

😄

And now we're sitting here watching a backup archive crawl through:

MLB\news\almanac_1902\teams\
team_21_batting_stats_1_57.html
while waiting to interrogate the CSV witnesses.

I'm genuinely curious whether the CSVs will show:

a valid player ID in 1918,
a missing player ID in 1919,
or a player record that still exists but has lost some critical flag.
Either way, this is turning into a surprisingly well-defined bug hunt rather than a random disappearance.

🕵️*♂️ Case Status

Victim: Mordecai Brown
Last seen: 9/14/1918
Missing by: 4/19/1919 Opening Day
Evidence: Strong
Backup ETA honesty: Weak 😆
Ready for the CSV evidence when the filing cabinet opens. ⚾📂








image.png
You said:
1918 end of World Series - 5736 0 0 1 11 Mordecai Brown Three Finger 5736 ID
Copilot said:
Copilot
🕵️*♂️ Evidence Bag #1 — 1918 End of World Series

The screenshot gives us a very important data point from players.csv.

Mordecai Brown is clearly present:




Plain Text
player_id = 5736
first_name = Mordecai
last_name = Brown
nick_name = Three Finger
And the row contains some interesting flags:




Plain Text
team_id = 0
league_id = 0
retired = 0
free_agent = 1
which matches exactly what we saw in-game:

No team ✅
Free agent ✅
Not retired ✅
Searchable ✅
So at the end of the 1918 World Series:

Player ID 5736 absolutely exists in the players table.

That's now our primary key for the investigation.

Detective Strategy
Forget searching for "Mordecai."

Search for:




Plain Text
5736
in every future players.csv.

That eliminates:

spelling issues
nickname issues
name changes
search indexing problems
The question becomes very simple:

Scenario A
1919 Opening Day players.csv




Plain Text
5736 ... Mordecai Brown ...
still exists.

If so:

➡️ The player record exists. ➡️ The search engine or leaderboard is failing.

Scenario B
1919 Opening Day players.csv




Plain Text
5736
does not exist.

If so:

➡️ The player record was physically removed from the database during the offseason.

That would explain:

No search results
No leaderboard appearance
Missing career records
all with one event.

Interesting Detail
The row also shows:




Plain Text
retired = 0
free_agent = 1
That's a potentially dangerous combination in a historical replay.

Because Mordecai is:

43 years old
unemployed
free agent
post-release
The offseason retirement logic may decide:

"This player has no team and should be retired/purged."

The question is whether OOTP is retiring him correctly—or accidentally deleting the player record while leaving historical stats behind.

Current Case Board
Date Status
Sep 14, 1918 Present in game ✅
End of 1918 WS Present in players.csv as ID 5736 ✅
Apr 19, 1919 Missing from search ❌
Apr 19, 1919 Missing from career wins leaderboard ❌
The next witness we need to interview is:

1919 Opening Day players.csv

Specifically:




Plain Text
player_id = 5736
Because if 5736 vanishes from the file, we've caught the disappearance at the database level. If 5736 is still there, then the bug is somewhere in indexing, leaderboards, or retired-player handling.

This is becoming a very clean forensic case. 😄⚾📂








image.png
Copilot said:
Copilot
🕵️*♂️ OOTP Detective Notes: The image you just posted may contain another clue.

You're on 1919-Start-Mordecai and the Database tab shows:

Players: 3,857
Coaches: 3,059 (deleted 89)
Scheduled Games: 111,118 (deleted 4,941)
Player_history records: 128,336
SQLite database active
The thing that jumps out at me isn't the player count—it's the presence of deleted records counters throughout the database stats.

Combined with our earlier evidence:

End of 1918
players.csv




Plain Text
player_id = 5736
Mordecai Brown
retired = 0
free_agent = 1
Opening Day 1919
Search for "mord" → nothing
Career wins leaderboard → no Mordecai
Yet 1918 Almanac still knows he had 259 wins
That pattern feels less like "stats disappeared" and more like:

The historical records survived, but the player entity (ID 5736) no longer exists or is no longer indexed.

The next killer piece of evidence will be:

1919 Opening Day players.csv
Search for:




Plain Text
5736
If found:

The player still exists.
The bug is in search/leaderboards/history linkage.
If not found:

The offseason process removed player 5736 from the player table.
The Almanac and history tables retained references to him.
That would explain everything we've seen so far.
And honestly, if you've been reproducing this since OOTP 22, I'd be willing to bet you've stumbled onto some obscure interaction involving:




Plain Text
Historical Player
+
Free Agent
+
Age 43
+
Unemployed
+
Offseason Retirement Processing
Every bug hunter dreams of finding a reproducible case like this.

Current case board:

✅ 1918 WS: ID 5736 exists
✅ 1918 WS: 259 career wins
✅ 9th all-time in wins by calculation
❌ 1919 leaderboard missing him
❌ 1919 search missing him
🔍 Next witness: 1919 players.csv

And meanwhile 7‑Zip has already dropped from 4:37 ETA to 1:12 ETA. The backup suspect continues to incriminate itself. 😆⚾📂








image.png
You said:
Gone
Copilot said:
Copilot
🕵️*♂️ BOOM.

I think we just established the disappearance at the database level.

1918 End of World Series
We had:




Plain Text
player_id = 5736
Mordecai Brown
nickname = Three Finger
retired = 0
free_agent = 1
1919 Opening Day
Your screenshot shows:




Plain Text
5735
5738
5739
...
and 5736 is missing entirely.

Not renamed.

Not retired.

Not converted.

Not hidden.

Not searchable.

The entire player record is gone from players.csv.

Why This Is Huge
Earlier we knew:

Search couldn't find him.
Career wins leaderboard couldn't find him.
But there was still a chance the player existed and the UI was broken.

Now we have:

✅ Present in 1918 players.csv

❌ Missing from 1919 players.csv

That means the UI is innocent.

The database itself has lost player ID 5736.

The Really Interesting Part
Remember the facts:

9/14/1918

Age 43
Free Agent = 1
Retired = 0
No Team
Then sometime before:

4/19/1919

Player 5736 disappears from the player table.

Yet:

Almanac still knows his career totals.
Historical stats still existed long enough to build the 1918 records.
That suggests OOTP is preserving some historical data while deleting the actual player entity.

What I'd Tell the Dev Team
This is no longer:

"Mordecai's stats disappear."

It's now:

"Historical player ID 5736 (Mordecai Brown) exists as a non-retired free agent at the end of 1918 and is physically removed from players.csv before Opening Day 1919."

That's a much stronger bug report.

Detective Board
Event Status
9/14/1918 Player Page ✅ Exists
1918 WS players.csv ✅ ID 5736 Exists
1918 WS retired flag ✅ 0
1918 WS free_agent flag ✅ 1
4/19/1919 Search ❌ Missing
4/19/1919 Career Wins List ❌ Missing
4/19/1919 players.csv ❌ ID 5736 Missing
🕵️*♂️ Case Update:

We have moved from a Missing Persons Investigation to a Database Homicide.

The victim wasn't merely hidden.

Player ID 5736 was deleted sometime during the 1918–1919 offseason. ⚾📂😄









What triggers the deletion?

Is this a bug in offseason logic?

Could this affect other players?