Originally Posted by DaFace (Post 16996361)

Resurrecting an old thread because I've been playing around with the backend database as a way to practice some SQL skills (and put ChatGPT's coding skills to the test). If anyone has any ideas for analysis stuff you think would be interesting, drop them in here.

No promises on when or if I'll get to anything that you suggest, but I appreciate the fodder for things to think about. Don't worry too much about whether you think a question is answerable - that's part of the fun.

Examples of things that come to mind as stuff I might look at:
-What percentage of OG posters are still active today?
-How have participation rates in individual subforums ebbed and flowed over the years?
-How does the political leanings of the President impact the political leanings of who is active in DC? (This one will be tricky, and I might need a partner who has been a long-term DC participant help me categorize people. I think it's an interesting question, though.)
-What percentage of total posts in each forum come from that forum's top posters (e.g., how many people make up >50% of posts in each forum)?

Originally Posted by kcgreene (Post 16996462)

I'm just one guy, but I'd be curious if there was a way to see if we could see the ratio of those lurking without an account to active users. As someone who was mainly a lurker almost daily for essentially the last decade, and finally decided to start posting, I'm genuinely curious how many more are like that.

Originally Posted by BleedingRed (Post 16996464)

50/50 half of those lurking forgot their login information.

Originally Posted by DaFace (Post 16996361)

Resurrecting an old thread because I've been playing around with the backend database as a way to practice some SQL skills (and put ChatGPT's coding skills to the test). If anyone has any ideas for analysis stuff you think would be interesting, drop them in here.

No promises on when or if I'll get to anything that you suggest, but I appreciate the fodder for things to think about. Don't worry too much about whether you think a question is answerable - that's part of the fun.

Examples of things that come to mind as stuff I might look at:
-What percentage of OG posters are still active today?
-How have participation rates in individual subforums ebbed and flowed over the years?
-How does the political leanings of the President impact the political leanings of who is active in DC? (This one will be tricky, and I might need a partner who has been a long-term DC participant help me categorize people. I think it's an interesting question, though.)
-What percentage of total posts in each forum come from that forum's top posters (e.g., how many people make up >50% of posts in each forum)?

Originally Posted by BleedingRed (Post 16996464)

50/50 half of those lurking forgot their login information.

Originally Posted by BleedingRed (Post 16996453)

I'd like to see a graph of Dongers post count by year, 2015 to today.

Typical bar graph, year over year.... Starting in 2015 for no particular reason.

Originally Posted by Bowser (Post 16996545)

Are there any accounts started in August 2000 that show still active but have zero posts for the entirety of their time here?

Originally Posted by DaFace (Post 16996566)

Ha, that's a fun one (and easy). Alas, there are none. However, here are five guys who really show what it means to be lurkers. They all joined in August of 2000, have been active in the past month, but have less than 500 posts.

Originally Posted by DaFace (Post 16996566)

Ha, that's a fun one (and easy). Alas, there are none. However, here are five guys who really show what it means to be lurkers. They all joined in August of 2000, have been active in the past month, but have less than 500 posts.

SUPER CHIEF was active this morning and averages one post every 85 days. ROFL

Originally Posted by DaFace (Post 16996566)

Ha, that's a fun one (and easy). Alas, there are none. However, here are five guys who really show what it means to be lurkers. They all joined in August of 2000, have been active in the past month, but have less than 500 posts.

SUPER CHIEF was active this morning and averages one post every 85 days. ROFL

Originally Posted by Chief Ten Beers (Post 16996581)

Super Chief is one cool liberal, you only get to him through me :#

Originally Posted by DaFace (Post 16996566)

Ha, that's a fun one (and easy). Alas, there are none. However, here are five guys who really show what it means to be lurkers. They all joined in August of 2000, have been active in the past month, but have less than 500 posts.

SUPER CHIEF was active this morning and averages one post every 85 days. ROFL

Originally Posted by Shoes (Post 16996627)

Does the board keep track of thumbs up/thumbs down? Aka which posters average the most thumbs up/down per post?

Originally Posted by Bowser (Post 16996595)

I believe you are speaking of SuperChief, not the OG two-worded Super Chief.

Originally Posted by Otter (Post 16996645)

What qualifies as an OG? I'd like to see those numbers.

Originally Posted by Otter (Post 16996645)

What qualifies as an OG? I'd like to see those numbers.

Originally Posted by Bowser (Post 16996654)

How the hell have I been here a year and a half longer than DaFace? That feels like some Mandela Effect shit.....

Originally Posted by Bowser (Post 16996650)

If I were to guess, the first 300 users to have signed up? 500?

If memory serves, a whole load of you got sick of the KC Star board and started this place, right?

Originally Posted by DaFace (Post 16996556)

I will PROBABLY stay away from anything that singles out an individual person unless that person specifically requests it. This is meant to be fun, not contentious.

Originally Posted by Otter (Post 16996661)

That's how I arrived.

Originally Posted by Bowser (Post 16996664)

You're the 319th user registered here. I'm the 3,527th.

Originally Posted by Bowser (Post 16996664)

You're the 319th user registered here. I'm the 3,527th.

Originally Posted by Bowser (Post 16996662)

Not sure if you can find it with the various database upgrades and purges, but can you locate the very first rep ever given on this site? From whom to whom?

Originally Posted by Bowser (Post 16996671)

Donger is the 3,166th

Originally Posted by DaFace (Post 16996678)

I don't even need a query on that one, though I'm not necessarily confident that it's all accurate. But from what's in the table, CP's first rep was sent by jcl-kcfan2 (who?) to Otter (funny coincidence) on 7/22/2003. The rep itself was "camps in, craps out". :shrug:

Originally Posted by BleedingRed (Post 16996453)

I'd like to see a graph of Dongers post count by year, 2015 to today.

Typical bar graph, year over year.... Starting in 2015 for no particular reason.

Originally Posted by Donger (Post 16996663)

Given, my permission and request are.

Originally Posted by DaFace (Post 16996678)

I don't even need a query on that one, though I'm not necessarily confident that it's all accurate. But from what's in the table, CP's first rep was sent by jcl-kcfan2 (who?) to Otter (funny coincidence) on 7/22/2003. The rep itself was "camps in, craps out". :shrug:

Originally Posted by Bowser (Post 16996685)

Ha, nice!

So that being the case, does the database not record or recognize any activity BEFORE August 2000, because I've never seen anyone with a join date of July 2000 (or earlier).......

Originally Posted by DaFace (Post 16996566)

Ha, that's a fun one (and easy). Alas, there are none. However, here are five guys who really show what it means to be lurkers. They all joined in August of 2000, have been active in the past month, but have less than 500 posts.

SUPER CHIEF was active this morning and averages one post every 85 days. ROFL

Originally Posted by DaFace (Post 16996686)

I'm too lazy to graph it, but here ya go.

Originally Posted by Bowser (Post 16996690)

GEE DONGER WHAT WAS HAPPENING IN 2020??

ROFL

Originally Posted by Otter (Post 16996701)

Donger, in 2020 you had almost as many posts as I've had in 20 years. It's time to start revaluating priorities.

Originally Posted by Donger (Post 16996735)

I agree. You need to up your game to catch up.

Originally Posted by DaFace (Post 12720437)

By request from lewdog, here's the 2016 update of our overall posts by year.

http://i.imgur.com/XqNxB5d.png

Post count isn't everything - I think we're rather have high-quality content more than high-quantity content, but things are definitely slowing down around here. Here's the average number of people logged in per day:

http://i.imgur.com/dbDNSw0.png

My guess is that most of the drop is due to the growth of a lot of other types of social media where people get their news, like ArrowheadPride, reddit, even the Chiefs themselves. I think the age of the flat forum is probably just plain coming to an end. But still, it's part of the motivation to try and see if we can make this place a little more attractive moving forward.

Originally Posted by Bowser (Post 16996685)

Ha, nice!

So that being the case, does the database not record or recognize any activity BEFORE August 2000, because I've never seen anyone with a join date of July 2000 (or earlier).......

Originally Posted by DaFace (Post 16996691)

Negative. The IDs are all wonky, but based on the timestamp, this is the first post and thread in CP history:

https://www.chiefsplanet.com/BB/show...=6905#post6905

Originally Posted by Otter (Post 16996645)

What qualifies as an OG? I'd like to see those numbers.

Originally Posted by DaFace (Post 16996566)

Ha, that's a fun one (and easy). Alas, there are none. However, here are five guys who really show what it means to be lurkers. They all joined in August of 2000, have been active in the past month, but have less than 500 posts.

SUPER CHIEF was active this morning and averages one post every 85 days. ROFL

Originally Posted by Chiefspants (Post 16996770)

It’s possible you’ve already done this, but I’d love to see an update of this graph in the Mahomes era.

Did we get a boost? Or is it an inverted line where places like this thrive the most in misery?

Originally Posted by DaFace (Post 16997366)

I update it from time to time, but honestly it hasn't been all that interesting in recent years. It's not completely clear like this, but you can kind of think of CP in four eras:

2000-2003 - Founding and rapid growth
2004-2013 - Continued steady growth
2014-2016 - The decline of the flat forum era
2017-2023 - The era of stability

Beyond that, we saw our biggest growth spikes in posts in 2009 (frustration with the beginning of the Haley and Cassel era?) and to a lesser extent in 2020 (because WTF else did we have to to?) and 2022 (more to discuss with the revamped roster?). In general, though, things fluctuate a little bit from year to year these days, but I think we largely have our set user base, and it just goes up and down a little bit depending on what all we have to discuss.

Anyway, here are the charts since you were interested.

https://i.imgur.com/67AdSiC.png


https://i.imgur.com/guVoqW8.png

Originally Posted by Bowser (Post 16996650)

If I were to guess, the first 300 users to have signed up? 500?

If memory serves, a whole load of you got sick of the KC Star board and started this place, right?

Originally Posted by Bowser (Post 16996650)

If I were to guess, the first 300 users to have signed up? 500?

If memory serves, a whole load of you got sick of the KC Star board and started this place, right?

Originally Posted by Rams Fan (Post 16997442)

Are you able to look at the net-growth of active posters?

For this, we could define an active poster as someone who posted >=100 times within a calendar year. In-active poster being someone who has posted <100 times within a calendar year.

Also, the mean users looks promising as it seems the forum isn't declining in people who view it when compared to previous years. 2019 maybe elevated due to the interest surrounding the team and the chase for the first ring with Reid/Mahomes and 2020 being an anomaly.

Originally Posted by Bearcat (Post 16997500)

*checks userid*

Yeah, first 500.

Originally Posted by Spott (Post 16997531)

Were you on the old Star board? It’s been a long time ago, but it seems like I remember you being part of that group.

Originally Posted by Mr. Plow (Post 16997652)

I'd like to know how many Office gifs Bearcat has used on the board.

Originally Posted by Mr. Plow (Post 16997652)

I'd like to know how many Office gifs Bearcat has used on the board.


https://media0.giphy.com/media/299by...=200w.gif&ct=g

Originally Posted by Mr. Plow (Post 16997652)

I'd like to know how many Office gifs Bearcat has used on the board.


https://media0.giphy.com/media/299by...=200w.gif&ct=g

Originally Posted by DaFace (Post 16997735)

I can't easily tell you how many posts are actually office gifs, but I can tell you that he has 693 posts that contain the characters ".gif".

Originally Posted by Mr. Plow (Post 16997772)

That seems low.



But I did mean it as a joke.

Originally Posted by DaFace (Post 16996361)

Resurrecting an old thread because I've been playing around with the backend database as a way to practice some SQL skills (and put ChatGPT's coding skills to the test). If anyone has any ideas for analysis stuff you think would be interesting, drop them in here.

No promises on when or if I'll get to anything that you suggest, but I appreciate the fodder for things to think about. Don't worry too much about whether you think a question is answerable - that's part of the fun.

Examples of things that come to mind as stuff I might look at:
-What percentage of OG posters are still active today?
-How have participation rates in individual subforums ebbed and flowed over the years?
-How does the political leanings of the President impact the political leanings of who is active in DC? (This one will be tricky, and I might need a partner who has been a long-term DC participant help me categorize people. I think it's an interesting question, though.)
-What percentage of total posts in each forum come from that forum's top posters (e.g., how many people make up >50% of posts in each forum)?

Originally Posted by KurtCobain (Post 16997791)

I like would to see a breakdown of post activity in 2022-2023 sorted by the year the users joined. To see what Class is still the strongest.

Originally Posted by DaFace (Post 16984922)

This was a good excuse to practice my newfound SQL skills (because ChatGPT now exists). So here are some charts just for fun:

https://i.imgur.com/GK2Ffan.png

These only look at "active users" who have posted at least 100 times in the past 12 months. It's certainly true that there hasn't been as much "new blood" in recent years, but it's not as much of a drop off as I would have guessed (2023 doesn't really count). And it's also kind of amazing that about 10% of our active users have been here since the beginning (51 out of 474 active users).

Originally Posted by DaFace (Post 16997798)

Already done! (this was in a different thread, so I don't expect you to follow my every post)

Originally Posted by DaFace (Post 16997787)

<iframe src="https://giphy.com/embed/eCWtXco400HwhLqJ4I" width="480" height="400" frameBorder="0" class="giphy-embed" allowFullScreen></iframe><p><a href="https://giphy.com/gifs/theoffice-nbc-the-office-tv-eCWtXco400HwhLqJ4I">via GIPHY</a></p>

Originally Posted by DaFace (Post 16997735)

I can't easily tell you how many posts are actually office gifs, but I can tell you that he has 693 posts that contain the characters ".gif".

Originally Posted by Boxer_Chief (Post 16998321)

I was in high school when I made the switch from KC star lurking to Chiefsplanet. I never created an account though because I just wanted to read and noobs were treated like noobs. Finally decided to make it official in 2014.

Originally Posted by Mr. Plow (Post 16997652)

I'd like to know how many Office gifs Bearcat has used on the board.


https://media0.giphy.com/media/299by...=200w.gif&ct=g