# Another look at "active users" at SDMB

**URL:** <https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133>\
**Category:** About This Message Board\
**Created:** [November 26, 2011, 7:01am UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133 "2011-11-26T07:01:17Z")\
**Posts on this page:** 20\
**Page:** 4

<div class="post-metadata">

**Author:** ![Zeldar](https://avatars.discourse-cdn.com/v4/letter/z/b77776/32.png) [@Zeldar](https://boards.straightdope.com/u/Zeldar)\
**Post date:** [November 28, 2011, 11:47pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/61 "2011-11-28T23:47:31Z")

</div>

> [@Chronos](#):
>
> > [@Zeldar](#):
> >
> > It would be a cute piece of trivia if we could locate the DAY when most people joined up.
> 
> I don’t feel like doing all of the digging right now, but I’d be willing to bet that it’s within a few days after January 7, 2003. That was the date that the epic “[If LotR Had Been Written By Someone Else!?](http://boards.straightdope.com/sdmb/showthread.php?threadid=138905)” thread was linked from Slashdot, leading to a huge flurry of activity here. I’m not sure how many of those new joins would have remained active, though.

I like your thinking! Maybe somebody between

Nametag Join Date: 04/13/2002 [http://boards.straightdope.com/sdmb/member.php?u=21252](http://boards.straightdope.com/sdmb/member.php)

and

Zeldar Join Date: 06-18-2003 [http://boards.straightdope.com/sdmb/member.php?u=36386](http://boards.straightdope.com/sdmb/member.php)

(a difference in User Numbers of 15134 or “halfway” being u=28819 might help zoom in on the range)

That seems to be:

[http://boards.straightdope.com/sdmb/member.php?u=28819](http://boards.straightdope.com/sdmb/member.php)  
wdcsmwscaa  
Guest  
Last Activity: 03-19-2004 10:15 PM  
Join Date: 01-02-2003

So that ought to help cut down on the heavy lifting.

Anybody? Wanna Race?

---

<div class="post-metadata">

**Author:** ![OpalCat](https://avatars.discourse-cdn.com/v4/letter/o/8edcca/32.png) [@OpalCat](https://boards.straightdope.com/u/OpalCat)\
**Post date:** [November 29, 2011, 12:13am UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/62 "2011-11-29T00:13:10Z")

</div>

User number 36, join date 3/11/1999

Others registered on the same day (\* denotes active users):

\*GusNSpot (#33)  
Fichchef  
Stevicus  
StaceyLyn(Slkaopi)  
\*Doug Bowe  
Lanna  
\*gotpasswords  
Granny J  
DianneCar  
Egads Ron  
\*AskNott  
\*PunditLisa  
\*KCB615   
Shane  
JustJoan  
Chuy63  
Trigger33  
TXRebel  
Barbara  
Dick Macy  
Tyler  
Quarterat  
IrRev Bat  
Karen  
JPetraliaX  
Jean  
SoxFan59  
The Crimson Hipster Dufuz  
\*DrFidelius  
DAVEW0071  
\*AHunter3  
Phantmwise  
Felinecare  
Mark Mal  
Darwinself (#70)

---

<div class="post-metadata">

**Author:** ![MEBuckner](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/mebuckner/32/2896_2.png) [@MEBuckner](https://boards.straightdope.com/u/MEBuckner)\
**Post date:** [November 29, 2011, 2:37am UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/63 "2011-11-29T02:37:10Z")

</div>

Here are the stats for August 3, 2000 (member number, member name, member status, total posts, last activity date):

```auto

8530 SixStringSamurai Guest 27 8/10/2000
8531 Endora Guest 44 6/15/2001
8532 INTERPRETER Guest 30 9/2/2000
8533 Gregatiki Guest 15 11/3/2000
8534 TommyTutone Guest 1,117 11/28/2011
8535 shorin-ryu Guest 88 11/28/2011
8536 tomstar Guest 1 8/9/2000
8537 nesta Charter Member 348 11/28/2011
8538 Chibi-X Registered User 0 10/9/2001
8539 TylerDurden Guest 0 8/3/2000
8540 brucemarnold Guest 2 11/7/2000
8541 George Orwell Registered User 0 8/3/2011
8542 peedin Member 536 11/28/2011
8543 Agentold Registered User 0 6/6/2001
8544 Pepsi90919 Guest 1 8/3/2000
8545 AntiNorn Guest 1 8/3/2000
8546 skwalker Guest 0 8/3/2000
8547 MEBuckner Charter Member 9,103 11/28/2011
8548 Sakura Guest 101 6/27/2003
8549 enilorac Guest 158 4/24/2003
8550 ShamaFrog Guest 65 10/18/2001
8551 boccmon Guest 3 4/19/2002
8552 vertigo Guest 271 10/26/2003
8553 manofgold5 Guest 0 8/3/2000
8554 Mammie Guest 162 6/13/2004
8555 Clarissa Moore Guest 2 8/15/2000
8556 Mad Man Registered User 0 5/23/2002
8557 geeky Registered User 0 8/3/2000
8558 jonathan_krauss Guest 0 8/3/2000

```

For the recently active posters, last post dates were:  
**TommyTutone** , 11/16/2011  
**shorin-ryu** , 9/16/2011  
**nesta** , 11/9/2011  
**peedin** , 11/23/2011  
**MEBuckner** , 11/28/2011

---

<div class="post-metadata">

**Author:** ![Darth\_Panda](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@Darth\_Panda](https://boards.straightdope.com/u/Darth_Panda)\
**Post date:** [November 29, 2011, 2:54am UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/64 "2011-11-29T02:54:37Z")

</div>

> [@Moonlitherial](#):
>
> A datapoint for a late joiner:
> 
> Total Posts: 2,115  
> Posts Per Day: 3.36  
> Last Activity: Today 01:30 PM  
> Join Date: 03-09-2010
> 
> User number 89087
> 
> 89071 - 89099
> 
> …  
> Darth Panda - 2017 posts, last activity today  
> …
> 
> Other than that only **Darth Panda** and myself are fairly active. Two others, **woodsjacker** with 2 posts and **random6X7** with 75 posts have logged in this month.

Sweet, I don’t have to do anything. Thanks.

---

<div class="post-metadata">

**Author:** ![pricciar](https://avatars.discourse-cdn.com/v4/letter/p/f4b2a3/32.png) [@pricciar](https://boards.straightdope.com/u/pricciar)\
**Post date:** [November 29, 2011, 4:02am UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/65 "2011-11-29T04:02:54Z")

</div>

```auto

Username Last Activity	Posts	UserID
Qaanik 04/28/00 07:05 PM	5	576
blando 04/28/00 07:05 PM	29	577
Sue 04/28/00 07:05 PM	4	578
Christine Batchelor	04/28/00 07:05 PM	4	579
Kemper Boyd 04/20/04 07:47 AM	2	580
pricciar today 2047 581
DakotaDusk 04/28/00 07:05 PM	18	582
mrsdewinter 04/28/00 07:05 PM	1	583
Walt 04/28/00 07:05 PM	1	584
phaticus 04/28/00 07:05 PM	2	585
NEterk1 04/28/00 07:05 PM	0	586
C-Gull 04/28/00 07:05 PM	0	587

```

I don’t know what I did wrong with my formatting. But, I think it is readable enough to show that my join date was not exactly a red letter day for new users. Aside from me only one of the 12 of us lasted past April 2000.

---

<div class="post-metadata">

**Author:** ![Zeldar](https://avatars.discourse-cdn.com/v4/letter/z/b77776/32.png) [@Zeldar](https://boards.straightdope.com/u/Zeldar)\
**Post date:** [November 29, 2011, 1:49pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/66 "2011-11-29T13:49:22Z")

</div>

> [@Biffy\_the\_Elephant\_Shrew](#):
>
> 44 users joined on 3-29-02.

> [@OpalCat](#):
>
> User number 36, join date 3/11/1999

> [@MEBuckner](#):
>
> Here are the stats for August 3, 2000

> [@Darth\_Panda](#):
>
> Sweet, I don’t have to do anything. Thanks.

03-09-2010

> [@pricciar](#):
>
> Join Date: 04-11-1999

Thanks to all of you for the input. I’ve begun the process of appending Julian Day numbers to the Join Date and User Numbers in my trimmed down and sorted summary file. As soon as I get that caught up with reality I will post it in hopes that somebody with good spreadsheet skills and software can do some fast number-crunching to provide a Big Picture analysis of how Join Dates and User Numbers are related.

The other details about “active members” may take more hands-on work.

That Biggest Day piece of trivia is another item we’ll need luck or grunt work to find.

Keep it coming. We’ve had 38 individual contributors so far.

---

<div class="post-metadata">

**Author:** ![brewha](https://avatars.discourse-cdn.com/v4/letter/b/91b2a8/32.png) [@brewha](https://boards.straightdope.com/u/brewha)\
**Post date:** [November 29, 2011, 3:06pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/67 "2011-11-29T15:06:56Z")

</div>

Here’s another data point for you.  
My user number is 14216 and I joined on 4-24-2001

Users 14196-14219 joined on the same day.

23 people joined on 4-24-01  
21 are inactive  
Myself and Simply\_cats(14219) are the only two remaining active.  
Oddly enough, Mort Furd, stuck around for 4 years and contributed 1432 posts before disappearing in Nov of '05

---

<div class="post-metadata">

**Author:** ![Jack\_Batty](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/jack_batty/32/3201_2.png) [@Jack\_Batty](https://boards.straightdope.com/u/Jack_Batty)\
**Post date:** [November 29, 2011, 4:20pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/68 "2011-11-29T16:20:58Z")

</div>

An interesting excercise.

My join date is 6/28/2000

Including me, there were 33 people who joined up that day; it looks like it’s just me and \*\*Lsura \*\*who are still active - and **Unix Geek** , but he needs to up his post count if he wants to hang with the big boys.

List:

Unix Geek - 136 posts - 11/27/2011  
dpr - 49 posts - 6/28/2000 - BANNED  
JJones - 1 Post - 12/2/2001  
Chupacabra - 112 posts - 1/9/2004  
Lsura - 5,759 posts - 11/29/2011  
Rafaqat - 0 posts  
qakkad - 11 posts - 6/28/2000 - BANNED  
IvanK - 0 posts  
PepperMan - 8 posts - 6/28/2000  
zwaldd - 1,449 posts - 8/14/2005  
Ayesha - 22 posts - 6/28/2000 - BANNED (with some weird sig about being a ‘look alike troll’)  
alymaitland - 2 posts - 7/27/2000  
Lil’ Kiffy - 43 posts - 2/21/2001  
Ayesha - 7 posts - 6/28/2000 - BANNED (same name as before, odd - and ditto on the weird ‘look alike troll’ sig thing)  
billrd01 - 0 posts  
bp628 - 1 post - 8/22/2000  
Saysha - 82 posts - 6/27/2001  
Roxanne\_in\_the\_red\_light - 0 posts  
Tymp - 11 posts - 6/28/2000 - BANNED  
Enigma - 0 posts  
Lord Vega - 128 posts - 4/25/2006  
Heloise - 2 posts - 6/28/2000 - BANNED (another ‘look alike troll’)  
Jack Batty - 10,185 posts - 11/29/2011  
[mystery dissappeared poster # 1]  
gump - 9 posts - 9/12/2005  
scoutmom6 - 0 posts  
SILENT-BOB NOT REALLY - 56 posts - 6/28/2000 - BANNED  
Salton - 14 posts - 7/2/2000  
Clayfighter - 1 post - 5/10/2001  
SILENT-BOB NOT - 33 posts - 6/28/2000 - BANNED  
Sarnoff - 0 posts  
[mystery dissappeared poster # 2]  
Badge - 622 posts - 2/23/2005  
I’m curious what the “look alike troll” thing was all about. The first Ayesha sig reads: “Hi, I’m a lookalike troll! Lynn put this in my sig!”

In fact, weren’t **Ayesha** , and another banned one from my list, **dpr** , (maybe \*\*Tymp \*\*too) settled and respected posters here? It must have been some troll crusade using existing names or something.

And I’m amused by the SILENT-BOB NOT thing. I remember **Silent Bob** … only posted in smilies. He was much loved/hated, depending on who you ask.

---

<div class="post-metadata">

**Author:** ![Zeldar](https://avatars.discourse-cdn.com/v4/letter/z/b77776/32.png) [@Zeldar](https://boards.straightdope.com/u/Zeldar)\
**Post date:** [November 29, 2011, 4:21pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/69 "2011-11-29T16:21:20Z")

</div>

As of **brewha** ’s post above we’ve had 39 individuals’ input. And since I’ve completed the Julian Day task I’ll post the latest version of the summary data.

If you want more info on Julian Day, please look at [Julian Day – Fun and Games](http://boards.straightdope.com/sdmb/showthread.php?t=631855) which I started on 11-18-2011, 10:58 AM and which could stand some participation!

====================

```auto

UserName Join Date User Number Julian Day
=====================================================================================================================

TubaDiva Join Date: 03-10-1999 http://boards.straightdope.com/sdmb/member.php?u=32 2451247  
OpalCat Join Date: 3/11/1999 http://boards.straightdope.com/sdmb/member.php?u=36 2451248
kunilou Join Date: April 7, 1999 http://boards.straightdope.com/sdmb/member.php?u=535 2451275
pricciar Join Date: 04-11-1999 http://boards.straightdope.com/sdmb/member.php?u=581 2451279
JBDivmstr Join Date: 6/14/1999 http://boards.straightdope.com/sdmb/member.php?u=1458 2451343
Joey P Join Date: 6/15/1999 http://boards.straightdope.com/sdmb/member.php?u=1478 2451344
Earl Snake-Hips Tucker
                  Join Date: 07-29-1999 http://boards.straightdope.com/sdmb/member.php?u=1972 2451388      
AuntiePam Join Date: 08-05-1999 http://boards.straightdope.com/sdmb/member.php?u=2058 2451395
Sparky812 Join Date: 08-31-1999 http://boards.straightdope.com/sdmb/member.php?u=2338 2451421
Eureka Join Date: 9/24/1999 http://boards.straightdope.com/sdmb/member.php?u=2661 2451445
Rhythmdvl Join Date: 10-13-1999 http://boards.straightdope.com/sdmb/member.php?u=2845 2451464
Chronos Join Date: 01-22-2000 http://boards.straightdope.com/sdmb/member.php?u=4176 2451565 
Clothahump Join Date: 05-24-2000 http://boards.straightdope.com/sdmb/member.php?u=6642 2451688  
Tamex Join Date: 7/19/2000 http://boards.straightdope.com/sdmb/member.php?u=8146 2451744
MEBuckner Join Date: August 3, 2000 http://boards.straightdope.com/sdmb/member.php?u=8547 2451759
Gyrate Join Date: November 13, 2000 http://boards.straightdope.com/sdmb/member.php?u=10829 2451861
malkavia Join Date: 11-17-2000 http://boards.straightdope.com/sdmb/member.php?u=10931 2451865
Cazzle Join Date: 12-27-2000 http://boards.straightdope.com/sdmb/member.php?u=11733 2451905
amarone Join Date: 3-30-2001 http://boards.straightdope.com/sdmb/member.php?u=13774 2451998
Cicero Join Date: 2nd April 2001 http://boards.straightdope.com/sdmb/member.php?u=13806 2452001
Omega Glory Join Date: 4/20/2001 http://boards.straightdope.com/sdmb/member.php?u=14145 2452019
brewha Join Date: 4-24-2001 http://boards.straightdope.com/sdmb/member.php?u=14216 2452023
don't ask Join Date: 31st of May 2001 http://boards.straightdope.com/sdmb/member.php?u=14776 2452060
ZipperJJ Join Date: 8-15-2001 http://boards.straightdope.com/sdmb/member.php?u=16467 2452136
Biffy the Elephant Shrew 
                  Join Date: 3-29-02 http://boards.straightdope.com/sdmb/member.php?u=20699 2452362 
Nametag Join Date: 04/13/2002 http://boards.straightdope.com/sdmb/member.php?u=21252 2452377
Zeldar Join Date: 06-18-2003 http://boards.straightdope.com/sdmb/member.php?u=36386 2452808
Starving Artist Join Date: 12-27-03 http://boards.straightdope.com/sdmb/member.php?u=42779 2453000
DfrntBreign Join Date: Feb. 21, 2004 http://boards.straightdope.com/sdmb/member.php?u=44274 2453056
RollOutTheBarrel Join Date: May 1st, 2005 http://boards.straightdope.com/sdmb/member.php?u=52702 2453491 
Crotalus Join Date: 6/30/2005 http://boards.straightdope.com/sdmb/member.php?u=53607 2453551
Bob Ducca Join Date: 1/2/2006 http://boards.straightdope.com/sdmb/member.php?u=56822 2453737
steronz Join Date: Feb 21, 2007 http://boards.straightdope.com/sdmb/member.php?u=64260 2454152
Half Man Half Wit Join Date: 6-14-2007 http://boards.straightdope.com/sdmb/member.php?u=67227 2454265
Panurge Join Date: 7-30-2007 http://boards.straightdope.com/sdmb/member.php?u=68877 2454311
Blank Slate Join Date: 4-13-2008 http://boards.straightdope.com/sdmb/member.php?u=75852 2454569
Zyanthia Join Date: 09/01/2009 http://boards.straightdope.com/sdmb/member.php?u=85536 2455075
Darth Panda Join Date: 03-09-2010 http://boards.straightdope.com/sdmb/member.php?u=89080 2455264
Moonlitherial Join Date: 03-09-2010 http://boards.straightdope.com/sdmb/member.php?u=89087 2455264
=============================

```

---

<div class="post-metadata">

**Author:** ![spinky](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@spinky](https://boards.straightdope.com/u/spinky)\
**Post date:** [November 29, 2011, 4:21pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/70 "2011-11-29T16:21:49Z")

</div>

You guys do everything the hard way. 😉 Computers will do this kind of thing for you. During the other thread **Zeldar** mentioned, I wrote some code that scrapes data like this, and as a result, I have a nearly complete dataset for answering these types of questions. It was a pretty simple matter to run it a bit more to get a picture of what’s changed in the meantime, and now I can make fascinating observations like:

Day with the most signups: April 28, 2011, with 304 signups. However, only 2 of those are still active, so lots of people who flamed out (see below) or left is less interesting than looking at the number of signups who actually stuck around for a certain amount of time, such as 60 days. Top 10 days for that:

```auto

(n = num signups, a = num still active, p = percent still active)
date n a p
2003-01-07 34 1 3
2002-03-14 35 4 11
2003-01-08 37 3 8
2003-01-09 38 1 3
2003-01-10 38 5 13
2002-03-13 39 6 15
1999-03-14 43 5 12
1999-03-11 49 7 14
2002-03-12 58 8 14
2002-03-11 107 27 25

```

The date with the highest number of now-banned users is, unsurprisingly, April 28, 2011 (232 banned users). The next highest is Jan 4, 2011, with 83 banned users.

The oldest banned account is Markxxx, banned after 4465 days.

I don’t have time to do more slicing and dicing at the moment, but if you have questions that can be answered by knowing everyone’s post count, total number of posts, signup date and last activity date, shoot them my way. I can also make the data available if anyone else wants to nerd out or draw graphs. One interesting graph I’ve thought of would be a line showing signups per day, with a series of lines below that indicating “stayed for a week”, “stayed for a month”, “stayed for 90 days”, etc.

Oh, one more pair of stats since it’s easy to calculate:

```auto

Top "posts per day"
11.28 Mangetout Guest
11.45 Der Trihs Member
12.17 BigT Guest
12.48 Really Not All That Bright Guest
12.95 gonzomax BANNED
13.01 John Mace Guest
15.44 Marley23 Administerminator
15.79 BrainGlutton Guest
16.91 CitizenPained Guest
17.59 Diogenes the Cynic BANNED

Top "total posts"
38830 Really Not All That Bright Guest
39401 Liberal Guest
41227 Chronos Charter Member
41805 Johnny L.A. Charter Member
41860 Guinastasia Member
42608 John Mace Guest
43518 Mangetout Guest
50390 BrainGlutton Guest
54218 Marley23 Administerminator
58797 Diogenes the Cynic BANNED

```

---

<div class="post-metadata">

**Author:** ![Zeldar](https://avatars.discourse-cdn.com/v4/letter/z/b77776/32.png) [@Zeldar](https://boards.straightdope.com/u/Zeldar)\
**Post date:** [November 29, 2011, 4:31pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/71 "2011-11-29T16:31:39Z")

</div>

You da man, **ntucker**! Thanks for accepting the challenge and producing some outstanding trivia.

---

<div class="post-metadata">

**Author:** ![TubaDiva](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/tubadiva/32/507_2.png) [@TubaDiva](https://boards.straightdope.com/u/TubaDiva)\
**Post date:** [November 29, 2011, 4:36pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/72 "2011-11-29T16:36:22Z")

</div>

> [@Panurge](#):
>
> I would think that the number of users who joined on the particular dates and the number of users who are still active would be relevant. More relevant than the info for the users who posted here, at least.
> 
> If your sample gets large enough the figures I mentioned could help you find out a: the rate of new members to the boards over timeb, and b: what our percentage of staying (active) users are.
> 
> I still think the admins ought to pull this info directly from the database, though.

As a general rule management does not release data. But it looks like y’all are getting more than enough to chew over with what you’re doing here in the thread anyway. Carry on.

---

<div class="post-metadata">

**Author:** ![Darth\_Panda](https://avatars.discourse-cdn.com/v4/letter/d/ee7513/32.png) [@Darth\_Panda](https://boards.straightdope.com/u/Darth_Panda)\
**Post date:** [November 29, 2011, 5:04pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/73 "2011-11-29T17:04:59Z")

</div>

> [@ntucker](#):
>
> Day with the most signups: April 28, 2011, with 304 signups.
> 
> …
> 
> The date with the highest number of now-banned users is, unsurprisingly, April 28, 2011 (232 banned users).

I have to assume that’s because it was exactly 222 years to the day since the mutiny on the _Bounty_.

---

<div class="post-metadata">

**Author:** ![Moonlitherial](https://avatars.discourse-cdn.com/v4/letter/m/4bbf92/32.png) [@Moonlitherial](https://boards.straightdope.com/u/Moonlitherial)\
**Post date:** [November 29, 2011, 6:19pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/74 "2011-11-29T18:19:35Z")

</div>

> [@Darth\_Panda](#):
>
> Sweet, I don’t have to do anything. Thanks.

Happy to help my join date brother.

---

<div class="post-metadata">

**Author:** ![Ceejaytee](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/ceejaytee/32/2956_2.png) [@Ceejaytee](https://boards.straightdope.com/u/Ceejaytee)\
**Post date:** [November 29, 2011, 7:27pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/75 "2011-11-29T19:27:29Z")

</div>

About a million people joined on the same day as me (4/26/2000). Most of them quit the Dope 2 days later. Only 4 are still active, including the first person to join that day: pkbites.

After that we have:

FrEEzErMoNkEy2 Last Activity: 04-28-2000 07:07 PM  
InsanityIncarnate Last Activity: 03-05-2004 12:37 AM  
ajs42 Last Activity: 04-28-2000 07:07 PM  
Apologist BANNED Last Activity: 04-28-2000 07:07 PM  
skingraftat75mph Last Activity: 04-28-2000 07:07 PM  
GarrettTaylor Last Activity: 04-28-2000 07:07 PM  
LadyJanie Last Activity: 04-28-2000 07:07 PM  
ej8 Last Activity: 04-28-2000 07:07 PM  
redheadedokie Last Activity: 04-28-2000 07:07 PM  
Queensryche Last Activity: 04-28-2000 07:07 PM  
Procrutes Last Activity: 07-06-2000 07:22 PM  
belltower Last Activity: 04-28-2000 07:07 PM  
BELASCO Last Activity: 05-11-2000 12:00 AM  
Wendy C. Brooks Last Activity: 04-28-2000 07:07 PM  
Ceejaytee (me; #6004) Last Activity: Today 02:15 PM (still active)  
Phrogge Last Activity: 05-23-2009 02:37 AM  
tchietao Last Activity: 04-28-2000 07:07 PM  
Emustrangler Last Activity: 12-05-2001 08:47 PM  
kRaZycHeeZ Last Activity: 04-28-2000 07:07 PM  
teela brown Last Activity: 11-27-2011 05:05 PM (still active)  
JavaMaven1 Last Activity: 03-08-2009 01:19 PM  
dazed Last Activity: 10-01-2001 06:13 PM  
Marlitharn Last Activity: Today 01:23 PM (still active)  
godfork Last Activity: 05-24-2000 11:13 AM  
StupidName Last Activity: 04-28-2000 07:07 PM  
John Larrabee Last Activity: 04-28-2000 07:07 PM  
mattmanz\_da\_man Last Activity: 05-01-2000 11:56 PM  
Maharet676 Last Activity: 04-28-2000 07:07 PM  
Bloodshedder Last Activity: 03-11-2001 03:58 PM  
abcent Last Activity: 04-28-2000 07:07 PM  
Nachomama Last Activity: 05-24-2000 10:28 PM  
farley BANNED Last Activity: 04-28-2000 07:07 PM  
hazcon Last Activity: 04-28-2000 07:07 PM

---

<div class="post-metadata">

**Author:** ![spinky](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@spinky](https://boards.straightdope.com/u/spinky)\
**Post date:** [November 29, 2011, 10:35pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/76 "2011-11-29T22:35:28Z")

</div>

[Here](http://sdmbexample.nfshost.com/profiles.csv) is a dump of the full data in CSV format if anyone wants it, and [here](http://sdmbexample.nfshost.com/bydate.csv) it is tallied into buckets by date, showing for each day: number of signups, number that stayed for at least 5 days, 30 days, 60 days, 180 days, and the number that are still active. Should make a pretty graph if someone wants to give it a whirl.

---

<div class="post-metadata">

**Author:** ![Zeldar](https://avatars.discourse-cdn.com/v4/letter/z/b77776/32.png) [@Zeldar](https://boards.straightdope.com/u/Zeldar)\
**Post date:** [November 29, 2011, 11:48pm UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/77 "2011-11-29T23:48:54Z")

</div>

> [@AuntiePam](#):
>
> My number is 2058 (forgot the join date already, sometime in 1999). I went up to #2100 and found only one active member – Johnny Angel, who’s posted recently.
> 
> **Dorfmont** joined at the same time and was active in June this year, but has made only 11 posts since 1999. 11 posts in 12 years.
> 
> **The Ryan** was banned in 2004 after 3759 posts. I vaguely remember him.
> 
> **Globetrotter** was last active in June 2010, with 1169 total posts.
> 
> ETA: Everyone else who joined that day made just one or two posts, some none.

**AuntiePam** , I took the liberty of looking at your Join Date and the others who joined then.

Here’s a copy of what I found:

========================================

#34 Yesterday, 07:51 PM  
AuntiePam (14 joined)  
My number is 2058  
Join Date: 08-05-1999  
[http://boards.straightdope.com/sdmb/member.php?u=2058](http://boards.straightdope.com/sdmb/member.php)

[http://boards.straightdope.com/sdmb/member.php?u=2047](http://boards.straightdope.com/sdmb/member.php)  
**Outlaw** - Last Activity: 04-28-2000 06:05 PM  
Join Date: 08-05-1999

[http://boards.straightdope.com/sdmb/member.php?u=2060](http://boards.straightdope.com/sdmb/member.php)  
**mikan** - Last Activity: 01-25-2003 09:36 PM  
Join Date: 08-05-1999

========================================

I did this lookup so I could have your data in a new sort I’m working on, which will have everybody’s “total joined” from most to least. Once we determine what the “average day’s” signup rate is we can see where everybody stands relative to that.

**ntucker** ’s data answers so many of the basic questions I have had that there are only a few gee-whiz numbers I’m still curious about.

If anybody else has some burning questions about “active users” or related issues, please speak up. I have faith that **ntucker** can answer them, or make a Grade-A try at it.

---

<div class="post-metadata">

**Author:** ![Lord\_Mondegreen](https://avatars.discourse-cdn.com/v4/letter/l/91b2a8/32.png) [@Lord\_Mondegreen](https://boards.straightdope.com/u/Lord_Mondegreen)\
**Post date:** [November 30, 2011, 12:00am UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/78 "2011-11-30T00:00:07Z")

</div>

On my join date, which was 03-05-2004 in my time zone:

[ul]  
[li]34 joined[/li][li]20 with no posts (including one Banned with no posts)[/li][li]8 with 1, 2 or 3 posts[/li][li]1 with 6 posts[/li][li]1 with 17 posts[/li][li]1 with 124 posts[/li][li]1 with 180 posts[/li][li]1 (me) with 693 posts, not including this one[/li][/ul]

The only one other than me who could remotely be said to be active is the one with 17 posts, whose last activity date was in March this year.

So, 34 joined, one or two active.

---

<div class="post-metadata">

**Author:** ![Starving\_Artist](https://avatars.discourse-cdn.com/v4/letter/s/aeb1de/32.png) [@Starving\_Artist](https://boards.straightdope.com/u/Starving_Artist)\
**Post date:** [November 30, 2011, 2:53am UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/79 "2011-11-30T02:53:41Z")

</div>

> [@ntucker](#):
>
> [Here](http://sdmbexample.nfshost.com/profiles.csv) is a dump of the full data in CSV format if anyone wants it, and [here](http://sdmbexample.nfshost.com/bydate.csv) it is tallied into buckets by date, showing for each day: number of signups, number that stayed for at least 5 days, 30 days, 60 days, 180 days, and the number that are still active. Should make a pretty graph if someone wants to give it a whirl.

There seems to be an error somewhere. I’m on my iPod and can’t get the first link to open but the total signup count for my join date of 12-27-03 is off. The bucket list (heh) shows 30 signups that day but the actual count is 36. I’m not sure about the totals in the other columns because I didn’t compile the same info. Just thought I’d mention it in case there’s a bug throwing throwing off your totals.

---

<div class="post-metadata">

**Author:** ![spinky](https://avatars.discourse-cdn.com/v4/letter/s/59ef9b/32.png) [@spinky](https://boards.straightdope.com/u/spinky)\
**Post date:** [November 30, 2011, 4:04am UTC](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133/80 "2011-11-30T04:04:18Z")

</div>

> [@Starving\_Artist](#):
>
> There seems to be an error somewhere. I’m on my iPod and can’t get the first link to open but the total signup count for my join date of 12-27-03 is off. The bucket list (heh) shows 30 signups that day but the actual count is 36. I’m not sure about the totals in the other columns because I didn’t compile the same info. Just thought I’d mention it in case there’s a bug throwing throwing off your totals.

My guess is this is a timezone difference. To simplify things, my numbers were gathered in my own timezone (PST), which can make the day buckets slightly different than yours. I just checked the data and it looks right: userid 42767 was the last one registered on 12/26/03 and 42798 was the first one registered on 12/28/03. The 30 in between were all registered on 12/27.

[Previous page](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133.md?page=3)

[Next page](https://boards.straightdope.com/t/another-look-at-active-users-at-sdmb/604133.md?page=5)
