{Request} A list of all active accounts registered in 2011.

italianMiner72

hero member

Activity: 910

Merit: 511

Quote from: ~DefaultTrust on January 21, 2020, 11:59:35 AM

Quote from: italianMiner72 on January 21, 2020, 10:51:19 AM

Quote from: ~DefaultTrust on January 17, 2020, 05:50:54 AM

Quote from: italianMiner72 on January 17, 2020, 01:44:45 AM

Hi mate!
If code is open source, plz updare on github or something like dropbox/Google drive.
Thank you

Hi!

No it's not open source but i can share database file (in sqlite format).

sorry, but i'm not interested at the data :-)
can i pm you?
thank you.

Yes you can.

Done!
Thank you!

~DefaultTrust

copper member

Activity: 1554

Merit: 489

Stop the war!

Quote from: italianMiner72 on January 21, 2020, 10:51:19 AM

Quote from: ~DefaultTrust on January 17, 2020, 05:50:54 AM

Quote from: italianMiner72 on January 17, 2020, 01:44:45 AM

Hi mate!
If code is open source, plz updare on github or something like dropbox/Google drive.
Thank you

Hi!

No it's not open source but i can share database file (in sqlite format).

sorry, but i'm not interested at the data :-)
can i pm you?
thank you.

Yes you can.

italianMiner72

hero member

Activity: 910

Merit: 511

Quote from: ~DefaultTrust on January 17, 2020, 05:50:54 AM

Quote from: italianMiner72 on January 17, 2020, 01:44:45 AM

Hi mate!
If code is open source, plz updare on github or something like dropbox/Google drive.
Thank you

Hi!

No it's not open source but i can share database file (in sqlite format).

sorry, but i'm not interested at the data :-)
can i pm you?
thank you.

Phinnaeus Gage

legendary

Activity: 1918

Merit: 1570

Bitcoin: An Idea Worth Spending

Quote from: TheBeardedBaby on January 15, 2020, 04:03:50 AM

I don't know if this is possible but I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.
Just tagged one, and I have seen some before.
Can be a Google spredsheet list as well, easier to work with data that way.

me

https://bitcointalksearch.org/user/phinnaeus-gage-24792

TheBeardedBaby

legendary

Activity: 2240

Merit: 3150

₿uy / $ell ..oeleo ;(

Quote from: qwk on January 17, 2020, 12:26:20 PM

Quote from: TheBeardedBaby on January 15, 2020, 04:03:50 AM

I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.

Well, you've already got that list, but here's one more thought:
you should devise a way to sieve out the hacked accounts.

Sure, if there are not enough evidence like this, i won't tag them.

qwk

donator

Activity: 3542

Merit: 3413

Shitcoin Minimalist

Quote from: TheBeardedBaby on January 15, 2020, 04:03:50 AM

I would like to get a list of all the accounts active in the past 120 days which were registered back in 2011.

Well, you've already got that list, but here's one more thought:
you should devise a way to sieve out the hacked accounts.

hosseinimr93

legendary

Activity: 2380

Merit: 5213

Only 1075 out of 45699 accounts have become online since October 01, 2019
Click the link below to see the list.

Full list of accounts that have been created in 2011 and have been online at least one time since October 01, 2019

~DefaultTrust

copper member

Activity: 1554

Merit: 489

Stop the war!

Quote from: italianMiner72 on January 17, 2020, 01:44:45 AM

Hi mate!
If code is open source, plz updare on github or something like dropbox/Google drive.
Thank you

Hi!

No it's not open source but i can share database file (in sqlite format).

italianMiner72

hero member

Activity: 910

Merit: 511

Quote from: ~DefaultTrust on January 16, 2020, 02:27:13 PM

I have parsed 2009-2012 registrations and continue parsing now. You can choose any range of dates, sort by Posts, Activity, Merit etc. More info here: https://bitcointalksearch.org/topic/ann-all-bitcointalk-users-table-project-5218103

Hi mate!
If code is open source, plz updare on github or something like dropbox/Google drive.
Thank you

~DefaultTrust

copper member

Activity: 1554

Merit: 489

Stop the war!

I have parsed 2009-2012 registrations and continue parsing now. You can choose any range of dates, sort by Posts, Activity, Merit etc. More info here: https://bitcointalksearch.org/topic/ann-all-bitcointalk-users-table-project-5218103

TheBeardedBaby

legendary

Activity: 2240

Merit: 3150

₿uy / $ell ..oeleo ;(

Thank you guys. I'll start with the list from 2011 that was posted above then I'll check the 2009/2010 list.
Any help is appriciated. There will be no Witch Hunting for sure. If I see a solid evidence I'll tag the account. I don't really like to destroy accounts, especially created back in the begining of all this,really.
The results will be posted on my Club thread.

hosseinimr93

legendary

Activity: 2380

Merit: 5213

I wrote code to scrap the profiles. But it takes a very long time. As accounts registered in 2009 and 2010 were much lower than 2011, I decided to run it for 2009 and 2010. It might be helpful. There might be some stolen or sold accounts among them too.
There were totally 3127 accounts registered before January 01, 2011.
There were only 85 profiles that have been online at least one time since October 01, 2019.

The list is available in the following sheet.

List of users who have registered in 2009 or 2010 and have been online at least one time since October 01, 2019

~DefaultTrust

copper member

Activity: 1554

Merit: 489

Stop the war!

I also tried to write a forum parser. Here is my result http://18.217.51.255/ It is parsed about 15000 users and still working now.
If admin is against, I will stop the script.

LoyceMobile

hero member

Activity: 1659

Merit: 687

LoyceV on the road. Or couch.

Quote from: unsoindovo on January 15, 2020, 02:23:28 PM

Hum. I tried to scrape data from bitcointalk months ago, but I haven't found the trick to avoid cloud flare protection.
How do you skip that?

I don't do anything, it just works.

unsoindovo

legendary

Activity: 1932

Merit: 1042

https://locktrip.com/?refId=40964

Quote from: LoyceMobile on January 15, 2020, 11:53:08 AM

Quote from: Rizzrack on January 15, 2020, 11:41:30 AM

As logfiles also mentioned: http://loyce.club/active/7d.html + REGEX magic

I've removed the https to make the link work.

I can get you full data by scraping all profiles, but using my deleted posts viewer is faster.

Hum. I tried to scrape data from bitcointalk months ago, but I haven't found the trick to avoid cloud flare protection.
How do you skip that?

LoyceV

legendary

Activity: 3290

Merit: 16489

Thick-Skinned Gang Leader and Golden Feather 2021

Quote from: Rizzrack on January 15, 2020, 12:22:52 PM

Quote from: LoyceMobile on January 15, 2020, 11:53:08 AM

I've removed the https to make the link work.

No SSL for Top 3 search engine on bitcointalk ? Cry

OK then, edited previous post

No, I'm not really worried about a man in the middle attack on this data.

Quote from: logfiles on January 15, 2020, 08:37:48 AM

So looking at http://loyce.club/archive/members, we shall be able to get accounts that were registered at a given period of time but are still active or were at least active from the time LoyceV started archiving posts.

My data started less than 7 months ago. I didn't even think about using this, so thanks

There's one flaw though: this only includes users who made a post, not the accounts that only changed their password to activate later. I can scrape all 2011 profiles if iasenko wants it (it'll take a day).

Rizzrack

copper member

Activity: 783

Merit: 710