Stats on Spam

Now I've been collecting spam for a little over a year on spambotlove.com. The purpose of which I do not know, yet. I kind of forgot about the project until just recently, so I started harvesting some stats from the database. Currently we have 729,255 records in the database. That's 3 MB of data.

Month

Spam Submissions

January, 2009

3

February, 2009

1

March, 2009

3

April, 2009

11689

May, 2009

28525

June, 2009

33900

July, 2009

35965

August, 2009

66018

September, 2009

89269

October, 2009

95155

November, 2009

71148

December, 2009

73367

January, 2010

97242

February, 2011

126986

Total

729271

As you can see, the numbers are growing exponentially. I actually find this whole thing really funny. The irony of software sending in vasts amounts of so useless data is really kind of funny.

Hardest working IP addresses

There are 28,942 IP addresses that have submitted spam, so each IP addresses submits around 25 entries each. The most hard-working IP addresses are as follows:

IP

Spam Submissions

69.46.16.14

18022

89.248.168.93

17410

89.248.172.38

15772

66.232.97.145

14782

91.121.221.94

12933

91.121.221.90

12353

67.215.233.50

12269

91.214.47.2

12242

69.46.23.47

11838

95.168.183.203

11473

What's next?

Now I've just got to find out what to do with all that "data". I thought about creating an API for querying the database, but I wouldn't really know what for, except for artistic purposes. Anybody got any ideas. edit: I added the IP address stats