Author Topic: Sorting the record by games played vs by date  (Read 521 times)

0 Members and 1 Guest are viewing this topic.

Offline Dave in Fairfax

  • Posts: 3186
Sorting the record by games played vs by date
« on: April 16, 2026, 07:05:28 pm »
This post kicked off a nice discussion about one of our WNFF quirks. A long time member, Old Chelsea, used to post an updated record to date comparison of the current Nats team to prior Nats teams after each win. We've continued the tradition after his passing. It's a less useful way to organize a comparison than record by games played. That said, it could be labor intense to redo things manually and we might have to do it every game to manage the list on an ongoing basis. The Chief suggests AI might help. Weigh in below. I am reluctant to put in the effort personally but with help we might be able to pull this oof.  JCA

Thank you to friends old and new who participated by viewing or posting comments.

With the :w: posted, we honor the memory of our friend Old Chelsea with the traditional post that tracks the Nats wins to date, in Anglophile style.

THE RACING PRECEDENTS - Comparative dates on which the Nationals notched their ninth win, each season:
Sorting the list by match rather than calendar date places this season solidly in the middle of the pack in franchise history, which is a positive given the state of the franchise and expectations going into the season.

2016 - 16th April (10th match of season)
2012 - 17th April (12th match)
2017 - 19th April (14th match)
2005 - 20th April (15th match)
2013 - 17th April (15th match)
2014 - 16th April (15th match)
2011 - 20th April (16th match)
2010 - 23rd April (17th match)
2019 - 18th April (17th match)
2018 - 17th April (18th match)
2026 - 16th April (19th match)
2024 - 20th April (20th match)
2021 - 28th April (21st match)
2025 - 20th April (21st match)
2015 - 29th April (22nd match)
2023 - 26th April (23rd match)
2022 - 3rd May (25th match)
2007 - 30th April (26th match)
2008 - 27th April (26th match)
2006 - 2nd May (27th match)
2009 - 7th May (27th match)

Offline The Chief

  • Posts: 32014
    • http://www.wnff.net
Re: Re: Nationals @ Pirates, Game 4
« Reply #1 on: April 16, 2026, 07:33:20 pm »
Sorting the list by match rather than calendar date places this season solidly in the middle of the pack in franchise history, which is a positive given the state of the franchise and expectations going into the season.

2016 - 16th April (10th match of season)
2012 - 17th April (12th match)
2017 - 19th April (14th match)
2005 - 20th April (15th match)
2013 - 17th April (15th match)
2014 - 16th April (15th match)
2011 - 20th April (16th match)
2010 - 23rd April (17th match)
2019 - 18th April (17th match)
2018 - 17th April (18th match)
2026 - 16th April (19th match)
2024 - 20th April (20th match)
2021 - 28th April (21st match)
2025 - 20th April (21st match)
2015 - 29th April (22nd match)
2023 - 26th April (23rd match)
2022 - 3rd May (25th match)
2007 - 30th April (26th match)
2008 - 27th April (26th match)
2006 - 2nd May (27th match)
2009 - 7th May (27th match)

Sort it any way you want, even sniffing .500 after almost 20 games is a welcome change.  Not going to get my hopes up of course, but it'd be great if this drags on for a while :whistle:

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Re: Nationals @ Pirates, Game 4
« Reply #2 on: April 16, 2026, 07:38:15 pm »
It's interesting to see the company this season is keeping. Within 2 games of this year's pace are the world series team, another above .500 team, 2021 (good until injuries catered them in July), 2024, where we had "should the Nats go for the wild card" into mid-May, and a complete disaster in 2025. 2010 was the start of improving. That might be this team

Online nats2playoffs

  • Posts: 24206
Re: Re: Nationals @ Pirates, Game 4
« Reply #3 on: April 16, 2026, 07:43:02 pm »
Sorting the list by match rather than calendar date...

This was how I always thought it should be done.

While I liked Old Chelsea, I always thought that his method was nonsensical. I think I posted it by match number instead of calendar date a few times. Old Chelsea has passed away; he won't mind if we update the method... along with the team's management.
 :stir:
Now if only we can get an owner who is interested in winning...

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Re: Nationals @ Pirates, Game 4
« Reply #4 on: April 16, 2026, 09:09:29 pm »
This was how I always thought it should be done.

While I liked Old Chelsea, I always thought that his method was nonsensical. I think I posted it by match number instead of calendar date a few times. Old Chelsea has passed away; he won't mind if we update the method... along with the team's management.
 :stir:
Now if only we can get an owner who is interested in winning...
I'm not going through 162 games for 20+ years to re-sort this. We can occasionally or periodically re-do the sort for record by game. I did it a bit last year in a separate clubhouse thread.

Offline The Chief

  • Posts: 32014
    • http://www.wnff.net
Re: Re: Nationals @ Pirates, Game 4
« Reply #5 on: April 16, 2026, 09:47:02 pm »
I'm not going through 162 games for 20+ years to re-sort this. We can occasionally or periodically re-do the sort for record by game. I did it a bit last year in a separate clubhouse thread.

I hate to say it but this is the sort of thing that AI excels at.

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Re: Nationals @ Pirates, Game 4
« Reply #6 on: April 16, 2026, 09:51:43 pm »
I hate to say it but this is the sort of thing that AI excels at.
I still  want to do the OC way as a tribute, but I'm game at doing it both record to date and record by games played if someone does the sorting stuff or can give me a query for this. Maybe something like "Sort the Nationals record through [X] games for each season since 2005."

Offline The Chief

  • Posts: 32014
    • http://www.wnff.net
Re: Re: Nationals @ Pirates, Game 4
« Reply #7 on: April 17, 2026, 08:18:44 am »
I still  want to do the OC way as a tribute, but I'm game at doing it both record to date and record by games played if someone does the sorting stuff or can give me a query for this. Maybe something like "Sort the Nationals record through [X] games for each season since 2005."

I think the way we've always done it is fine, I was just commenting.

Online imref

  • Posts: 54061
  • Rebuilding since 2022...
Re: Re: Nationals @ Pirates, Game 4
« Reply #8 on: April 17, 2026, 08:34:35 am »
seems like sorting by # of games rather than date is more informative. Just my .02

Offline tomterp

  • Global Moderator
  • ****
  • Posts: 35000
  • Hell yes!
Re: Re: Nationals @ Pirates, Game 4
« Reply #9 on: April 17, 2026, 08:37:47 am »
seems like sorting by # of games rather than date is more informative. Just my .02

Of course, but that's not how done historically by OC. 

Offline blue911

  • Posts: 19234
Re: Re: Nationals @ Pirates, Game 4
« Reply #10 on: April 17, 2026, 09:14:29 am »
I like honoring OC. He offered a unique perspective to the site.

Online imref

  • Posts: 54061
  • Rebuilding since 2022...
Re: Re: Nationals @ Pirates, Game 4
« Reply #11 on: April 17, 2026, 09:15:28 am »
I like honoring OC. He offered a unique perspective to the site.
:thumbs:

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #12 on: April 17, 2026, 11:09:46 am »
Let's continue the discussion in the Clubhouse rather than the GDT that I can now close.

I added some thoughts and history in the opening post
 One point I would want thought on is whether we would need to do record by games played each game. The easy thing about the OC method is I can just go to the GDT archives, copy the post from last year with the same wins, paste it into the latest win, then just add this year. If you do record by game, just updating when you win would leave you with a mishmash of records that hadn't been updated for maybe 2-3 seasons.  It would be simpler to update every game, but more work. AI might help the sorting.

At any rate, the wrap up post is mostly an OC tribute so there's a big part of me that wants to retain that.

Perhaps the best thing to do is to have a Clubhouse thread that periodically resorts the OC post when we want to do a record by games played comparison?

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #13 on: April 26, 2026, 05:58:12 pm »
Seasons sorted by games played to reach 13 wins. Teams in green were > .500 to 13 wins, teams in red were <.500. Playoff teams in italics. 2019 is underlined. 2026 is bold.

2016 - 23rd April (17th match of season)
2012 - 24th April (17th match)
2017 - 23rd April (18th match)

2010 - 30th April (23rd match)
2005 - 30th April (24th match)
2014 - 25th April (24th match)
2013 - 27th April (24th match)

2024 - 28th April (27th match)
2011 - 1st May (27th match)
2015 - 4th May (27th match)
2025 - 27th April (28th match)
2021 - 7th May (28th match)
2026 - 26th April (29th match)
2018 - 30th April (29th match)
2019 - 2nd May (30th match)
2008 - 3rd May (31st match)
2023 - 4th May (31st match)
2020 - 4th September (37th match)
2006 - 14th May (38th match)
2007 - 14th May (38th match)
2022 - 19th May (39th match)
2009 - 21st May (41st match)


Offline nobleisthyname

  • Posts: 4771
Re: Sorting the record by games played vs by date
« Reply #14 on: April 27, 2026, 09:00:37 am »
I like this format and approach.

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #15 on: April 27, 2026, 09:06:56 am »
I like this format and approach.
It's not hard to re-sort updated OC lists after each win. It's more effort to do a 1 to 162 list for record by game.

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #16 on: April 27, 2026, 09:09:09 am »
The tougher to remember season start for me is 2010. That team got off to a hot start but eventually slumped enough to get the Rendon pick

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #17 on: May 04, 2026, 09:39:00 am »
Seasons sorted by games played to reach 16 wins. Teams in green were > .500 to 16 wins, teams in red were <.500. Playoff teams in italics. 2019 is underlined. 2026 is bold.

2017 - 26th April (21st match of season)
2016 - 29th April (22nd match)
2012 - 2nd May (24th match)
2014 - 29th April (27th match)

2005 - 4th May (28th match)
2010 - 6th May (28th match)
2013 - 2nd May (29th match)
2015 - 8th May (30th match)
2018 - 2nd May (31st match)

2024 - 3rd May (32nd match)
2011 - 6th May (32nd match)
2021 - 14th May (34th match)
2026 - 3rd May (35th match)
2025 - 4th May (35th match)
2008 - 8th May (35th match)
2019 - 9th May (37th match)
2023 - 10th May (37th match)
2020 - 7th September (40th match)
2007 - 17th May (41st match)
2006 - 20th May (43rd match)
2022 - 26th May (45th match)
2009 - 2nd June (51st match)


Hard to remember but 2024 had a strong enough start that we had a thread about whether the team should add and push for the playoffs that was active for much of the first half of the season . That team was only 1 under .500 77 games into the season. The 2021 team was above .500 near the end of June.

More easy to recall, the 2019 had not yet started its run. And, of course, 2005 was in the middle of a great 1st half.

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #18 on: May 08, 2026, 10:11:50 pm »
19th win is always a good check in point because of 19-31 in 2019.

Seasons sorted by games played to reach 19 wins. Teams in green were > .500 to 19 wins, teams in red were <.500. Playoff teams in italics. 2019 is underlined. 2026 is bold.

2016 - 4th May (27th match of season)
2017 - 4th May (28th match)
2012 - 10th May (31st match)
2014 - 7th May (34th match)

2013 - 9th May (34th match)
2010 - 12th May (34th match)
2015 - 13th May (35th match)
2018 - 7th May (36th match)
2005 - 14th May (36th match)
2024 -  10th May (37th match)

2026 - 8th May (39th match)
2011 - 15th May (40th match)
2021 - 22nd May (42nd match)
2008 - 18th May (45th match)
2019 - 18th May (45th match)
2025 - 16th May (46th match)
2023 - 20th May (46th match)
2007 - 24th May (48th match)
2006 - 25th May (48th match)
2020 - 18th September (49th match)
2022 - 3rd June (54th match)
2009 - 18th June (65th match)


Other than 2019, the playoff teams had risen to the top by now, just short of 1/4 of the way through the season.

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #19 on: May 17, 2026, 10:25:02 am »
Posting an update through 23 wins because the Nats broke a streak of losing 15 games in a row in which a win would have brought them to .500. While they have been .500 or over for short stretches at the start of the year, like winning opening day and games 3 & 4 this year, they had lost 15 straight times when they entered a game 1 under.

Seasons sorted by games played to reach 23 wins. Teams in green were > .500 to 23 wins, teams in red were <.500. Playoff teams in italics. 2019 is underlined. 2026 is bold.

2017 - 13th May (35th match)
2016 - 14th May (36th match)
2012 - 16th May (37th match)

2015 - 19th May (40th match)
2018 - 12th May (41st match)
2005 - 19th May (41st match)
2013 - 17th May (42nd match)
2014 - 18th May (43rd match)
2010 - 23rd May (45th match)

2026 - 16th May (46th match)
2025 - 22nd May (50th match)
2024 - 25th May (50th match)
2023 - 27th May (52nd match)
2021 - 2nd June (52nd match)
2008 - 28th May (54th match)
2011 - 31st May (54th match)
2019 - 28th May (55th match)
2006 - 2nd June (55th match)
2007 - 3rd June (55th match)
2020 - 22nd September (55th match)
2022 - 11th June (61st match)
2009 - 28th June (74th match)


Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #20 on: May 20, 2026, 09:24:34 pm »
Seasons sorted by games played to reach 25 wins. Teams in green were > .500 to 25 wins, teams in red were <.500. Playoff teams in italics. 2019 is underlined. 2026 is bold.

2017 - 16th May (38th match of season)
2016 - 19th May (41st match)
2012 - 21st May (42nd match)

2015 - 22nd May (42nd match)
2018 - 21st May (47th match)
2013 - 24th May (48th match)
2010 - 28th May (49th match)

2026 - 20th May (50th match)
2014 - 25th May (50th match)
2005 - 29th May (50th match)
2024 - 29th May (54th match)
2025 - 28th May (55th match)
2011 - 2nd June (56th match)
2023 - 2nd June (57th match)
2006 - 4th June (57th match)
2019 - 1st June (58th match)
2021 - 9th June (58th match)
2020 - 26th September (59th match)
2008 - 5th June (61st match)
2007 - 8th June (61st match)
2022 - 21st June (71st match)
2009 - 5th July (80th match)



Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #21 on: May 20, 2026, 09:35:13 pm »
Sure beats 19-31 after 50 games!

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #22 on: May 24, 2026, 09:58:29 pm »
At the 1/3 mark of the season, Team 2026 is .500.

Seasons sorted by games played to reach 25 wins. Teams in green were > .500 to 25 wins, teams in red were <.500. Playoff teams in italics. 2019 is underlined. 2026 is bold.

2016 - 22nd May (44th match of season)
2017 - 23rd May (44th match)
2012 - 25th May (45th match)

2015 - 25th May (45th match)
2018 - 25th May (49th match)
2013 - 28th May (52nd match)
2005 - 31st May (52nd match)

2026 - 24th May (54th match)
2014 - 31st May (54th match)
2010 - 4th June (56th match)
2025 - 30th May (57th match)
2024 - 2nd June (58th match)
2019 - 4th June (60th match)
2006 - 7th June (60th match)
2011 - 7th June (61st match)
2021 - 13th June (62nd match)
2007 - 12th June (64th match)
2008 - 13th June (69th match)
2023 - 15th June (67th match)
2022 - 26th June (75th match)
2009 - 21st July (93rd match)
---
2020 - finished 26-34

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #23 on: May 25, 2026, 07:48:41 pm »
FWIW, last day the 2024 team was over .500 was 5/10. Last day 2021 was over .500 was 7/1. 2022, 2023, and 2025 were never over .500.

So far, last day 2026 was over .500 was March 31 (3-2).

Online JCA-CrystalCity

  • Global Moderator
  • ****
  • Posts: 54207
  • Platoon - not just a movie, a baseball obsession
Re: Sorting the record by games played vs by date
« Reply #24 on: May 25, 2026, 08:48:35 pm »
FWIW, last day the 2024 team was over .500 was 5/10. Last day 2021 was over .500 was 7/1. 2022, 2023, and 2025 were never over .500.

So far, last day 2026 was over .500 was March 31 (3-2).
gotta update that BS.

5/25/26 - Nats over .500!

In 2021, the Nats peaked at 2 over on 6/30. If the Nats somehow get to 3 over this year, the comps are to 2019.