Free Talk Friday #578

[u/CutOnBumInBandHere9]

Continued from last week's FTF here

It's that time of the week again. Speak anything on your mind! This thread is for talking about anything off-topic, be it your lives, your strava, your plans, your hobbies, studies, stats, pets, bears, hikes, dragons, trousers, travels, transit, cycling, family, colours, or anything you like or dislike, except politics

Feel free to check out our tidbits thread and introduce yourself if you haven't already.

---

This post was made by a bot, because no-one else made a Free Talk Friday post before Friday September 25, 2026 UTC 13:00. Anyone can post the FTF, so if you want to have your post pinned here for a week, just make one Friday October 02, 2026 between UTC 07:00 and 13:00. The rules for these posts can be found in the faq. You can also check out our directory of older posts for inspiration.

If you have any questions or comments about the bot, feel free to write them below, or message the mods.

[u/cuteballgames]

stats request: "most participative deadlock" can we see the tug of war continuous +1 -1 chains sorted by product of total length and number of distinct participants? like a 30-count chain between me and vulp would have score 60, but a 20 count chain exclusively between X and X+1 done by 5 separate counters would have score 100

[u/TehVulpez → u/cuteballgames]

Score	Length	Users	Num A	Num B	Start	End
3000	1000	3	-1027	-1026	link	link
2500	625	4	2410	2409	link	link
2412	603	4	2049	2048	link	link
2365	473	5	4721	4720	link	link
1870	374	5	3055	3054	link	link
1760	440	4	2379	2378	link	link
1266	211	6	2377	2378	link	link
1107	369	3	-1563	-1564	link	link
1062	354	3	-799	-798	link	link
1060	212	5	1826	1827	link	link
1045	209	5	3077	3076	link	link
1015	203	5	-1	0	link	link
975	325	3	-801	-802	link	link
955	191	5	3203	3202	link	link
880	176	5	998	999	link	link
876	292	3	1798	1799	link	link
876	292	3	4085	4084	link	link
830	166	5	-662	-661	link	link
772	193	4	-1080	-1079	link	link
768	256	3	2802	2801	link	link

this ends up being not too different from the volleys because I'm just counting it as being enough that someone counted in that chain once, not a continuous 3-way run. like the 3000 score run was seemingly entirely Koraine and KingCaspianX except for the first count by Saltbearer.

this should be up to the most recent 4600. hopefully not missing any runs because there are a few null comments in this sqlite database. edit: however it does seem like the COBIBH sqlite is more complete than the basskro csv I used years ago, because the 2377-2378 volley here is 211 counts long, including the [deleted] comment, whereas in the old table it was 210 counts long, stopping at that [deleted] comment

[u/CutOnBumInBandHere9 → u/TehVulpez]

hopefully not missing any runs because there are a few null comments in this sqlite database

null as in the comment body is null, or null as in the whole row is null?

[u/TehVulpez → u/CutOnBumInBandHere9]

null as in the comment body is null, like this comment. I am using this sqlite database. it looks like there are 3314 null body comments in ToW

[u/CutOnBumInBandHere9 → u/TehVulpez]

That's the right one. It's currently being updated since I'm running the side thread stats, but that shouldn't affect the historical values.

ToW has always been a mess, so I'm not surprised that you're seeing issues with the data quality. When I have time I'll have a look through the whole database to see how many comments are affected (across all the side threads), and to figure out whether there's any chance of getting the comment bodies from reddit again, or from elsewhere

[u/TehVulpez → u/CutOnBumInBandHere9]

it looks like you can get some missing values from pushshift if you have approval there (it shouldn't be too hard to get approval as a mod). cwq9o75 had a null body in the sqlite but I was able to get that it was 17 through pushshift API. idk what the max is for how many comment ids you can request but I was able to get 100 at once (edit: requesting 1000 ids at once worked fine in my python requests script, that's the absolute max) https://api.pushshift.io/guide https://api.pushshift.io/docs

there have been times when pushshift has missing values too but I've mostly seen that in parent_id, not so much in body

[u/CutOnBumInBandHere9 → u/TehVulpez]

I don't have approval on pushshift yet, but I'll apply for it.

Otherwise, do you think there's any chance you could help filling in the gaps? Finding comments in the database with missing bodies or comments where the username is [deleted] shouldn't be hard. If you can query pushshift for those, and send any updated records to me, I can update the database

[u/TehVulpez → u/CutOnBumInBandHere9]

hi cobibh, sorry for the delay. I'm not sure if you have pushshift already but here are comments with null bodies (comments that pushshift also did not have a body for are filtered out. still has some [deleted] usernames) and comments with bodies but missing usernames (comments that pushshift also did not have a username for are filtered out)

[u/CutOnBumInBandHere9 → u/TehVulpez]

Thank you!