Bitcoin Forum

Other => Beginners & Help => Topic started by: kiko on June 19, 2011, 10:56:18 PM



Title: Universities on mtgox - from the dumped DB
Post by: kiko on June 19, 2011, 10:56:18 PM
In the spirit of making lemonade when given lemons, I was interested to see from the how many students were using the mtgox site from .edu email addresses.

Here are the results. (I have trimmed all those with only 1 user for brevity).  Clearly if you're into bitcoin MIT  is the place to be!

sed -n '/\<[[:alnum:]]*\.edu/p' mtgox_accounts.csv | sed 's/.*\<\([[:alnum:]]*\)\.edu.*/\1/' | sort | uniq -c | sort -nr | sed '/\<1 [[:alnum:]]/,$d'
     19 mit
      9 umich
      8 purdue
      7 vic
      7 usf
      7 ucla
      7 cornell
      6 ncsu
      6 asu
      5 ufl
      5 obu
      5 berkeley
      4 wesleyan
      4 vt
      4 virginia
      4 usc
      4 syr
      4 stanford
      3 wpi
      3 udo
      3 uark
      3 selu
      3 osu
      3 muohio
      3 lynchburg
      3 indiana
      3 illinois
      3 georgetown
      3 drexel
      3 cmu
      3 case
      2 yale
      2 wisc
      2 uwm
      2 uw
      2 upenn
      2 umn
      2 uidaho
      2 ucr
      2 ucdavis
      2 uc
      2 ua
      2 ttu
      2 slu
      2 rit
      2 psu
      2 orst
      2 nmu
      2 neu
      2 monash
      2 hrbeu
      2 hawaii
      2 grinnell
      2 gatech
      2 fiu
      2 columbia
      2 colorado
      2 carthage
      2 caltech
      2 buffalo
      2 alaska


Title: Re: Universities on mtgox - from the dumped DB
Post by: BitcoinPorn on June 19, 2011, 11:06:21 PM
More stats, this is neat!


Title: Re: Universities on mtgox - from the dumped DB
Post by: kiko on June 19, 2011, 11:21:54 PM
...and from the UK.

No shows from Oxford and Cambridge! I guess you don't need Bitcoins if you already have a Swiss bank account ;)

I laughed at the 2 from SOAS, they have no computer science courses but do have a reputation as an easy place to get weed.


sed -n '/\<[[:alnum:]]*\.ac\.uk/p' mtgox_accounts.csv | sed 's/.*\<\([[:alnum:]]*\)\.ac\.uk.*/\1/' | sort | uniq -c | sort -nr | sed '/\<1 [[:alnum:]]/,$d'
      3 kent
      2 soas
      2 imperial