Steem First 100 users

in steem •  4 months ago

Based on the below post I set out to see if ned's id was 497 in fact. While I was at it I also thought of getting some details about the first 100 accounts on Steemit. While most of them seem to be dormant there are some trivia here in the list.

Screen Shot 2018-06-07 at 10.57.27 AM.png

There were some inconsistencies and it was right pointed out by @blockchainstudio I have corrected those and posted the updated version below. If you would like to take a look at the top 500 users details copy the list of users from the bottom of this post and paste in the link provided.

The list was created with SteemSQL and the helper tool I had created https://nkgokul.github.io/steem-tutorials/SteemProfiles.html I will be working on adding more details like SP and account balances. If you are a steem developer and would like to contribute please feel free to send a pull request or fork off.

(miners) userid:0

(null) userid:1

(temp) userid:2

(initminer) userid:3

(admin) userid:4

(dark) userid:5

(nxt1) userid:6

(dantheman) userid:10

(nxt) userid:7

(nxt2) userid:8

(administrator) userid:9

(any) userid:11

(nxt3) userid:12

(cloop1) userid:13

(dantheman5) userid:14

(nxt4) userid:15

(thisisnice) userid:16

(moderator) userid:17

(dantheman1) userid:18

(cloop2) userid:19

(dantheman6) userid:20

(thisisnice0) userid:21

(root) userid:22

(steem) userid:23

(nxt5) userid:24

(dantheman7) userid:25

(dantheman2) userid:26

(nxt6) userid:27

(steemit) userid:28

(thisisnice2) userid:29

(dantheman8) userid:30

(dantheman3) userid:31

(cloop3) userid:32

(thisisnice3) userid:33

(nxt7) userid:34

(steemit1) userid:35

(thisisnice4) userid:36

(nxt8) userid:37

(dantheman4) userid:38

(steemit10) userid:39

(nxt9) userid:40

(dantheman9) userid:41

(thisisnice5) userid:42

(steemit11) userid:43

(steemit12) userid:44

(thisisnice6) userid:45

(steemit13) userid:46

(steemit15) userid:47

(steemit16) userid:48

(thisisnice7) userid:49

(steemit17) userid:50

(thisisnice8) userid:51

(steemit18) userid:52

(steemit19) userid:53

(thisisnice9) userid:54

(steemit2) userid:55

(steemit20) userid:56

(steemit21) userid:57

(steemit22) userid:58

(steemit23) userid:59

(steemit25) userid:60

(steemit26) userid:61

(steemit27) userid:62

(steemit28) userid:63

(steemit29) userid:64

(steemit3) userid:65

(steemit30) userid:66

(steemit31) userid:67

(steemit32) userid:68

(arsahk) userid:69

(steemit33) userid:70

(steemit35) userid:71

(steemit36) userid:72

(steemit37) userid:73

(steemit38) userid:74

(steemit39) userid:75

(steemit4) userid:76

(steemit40) userid:77

(steemit41) userid:78

(steemit42) userid:79

(steemit43) userid:80

(bavak) userid:81

(steemit45) userid:82

(steemit46) userid:83

(steemit47) userid:84

(steemit48) userid:85

(steemit49) userid:86

(steemit5) userid:87

(steemit50) userid:88

(steemit51) userid:89

(mn12defgj1) userid:90

(bavihm) userid:91

(mr11acdee) userid:92

(steemit52) userid:93

(mr11acdee1) userid:94

(chana) userid:95

(steemit53) userid:96

(brayden) userid:97

(steemit55) userid:98

(hunter) userid:99

Here are the account names of top 500 users. Copy paste the whole of it and paste it in https://nkgokul.github.io/steem-tutorials/SteemProfiles.html if you want to know more details.

@miners,@null,@temp,@initminer,@admin,@dark,@nxt1,@dantheman,@nxt,@nxt2,@administrator,@any,@nxt3,@cloop1,@dantheman5,@nxt4,@thisisnice,@moderator,@dantheman1,@cloop2,@dantheman6,@thisisnice0,@root,@steem,@nxt5,@dantheman7,@dantheman2,@nxt6,@steemit,@thisisnice2,@dantheman8,@dantheman3,@cloop3,@thisisnice3,@nxt7,@steemit1,@thisisnice4,@nxt8,@dantheman4,@steemit10,@nxt9,@dantheman9,@thisisnice5,@steemit11,@steemit12,@thisisnice6,@steemit13,@steemit15,@steemit16,@thisisnice7,@steemit17,@thisisnice8,@steemit18,@steemit19,@thisisnice9,@steemit2,@steemit20,@steemit21,@steemit22,@steemit23,@steemit25,@steemit26,@steemit27,@steemit28,@steemit29,@steemit3,@steemit30,@steemit31,@steemit32,@arsahk,@steemit33,@steemit35,@steemit36,@steemit37,@steemit38,@steemit39,@steemit4,@steemit40,@steemit41,@steemit42,@steemit43,@bavak,@steemit45,@steemit46,@steemit47,@steemit48,@steemit49,@steemit5,@steemit50,@steemit51,@mn12defgj1,@bavihm,@mr11acdee,@steemit52,@mr11acdee1,@chana,@steemit53,@brayden,@steemit55,@hunter,@danea,@steemit56,@mottler,@darah,@erath,@steemit60,@steemit61,@mottler4,@dantheman21,@steemit57,@steemit58,@steemit59,@steemit6,@mottler1,@steemit62,@fminerten,@steemit63,@steemit65,@mottler2,@steemit66,@faddy,@steemit67,@steemit68,@steemit69,@steemit7,@steemit70,@steemit71,@steemit72,@steemit73,@steemit75,@steemit76,@steemit77,@steemit78,@fminerten1,@batel,@fminerten2,@fminerten3,@fminerten4,@batel1,@faddy3,@fminerten5,@panadacoin,@fminerten6,@fminerten8,@batel2,@batel3,@nextgen11,@nextgen10,@nextgen1,@nxt10,@nextgen12,@nextgen6,@nextgen2,@steemthebest,@dantheman10,@erihn,@nextgen13,@nextgen7,@nextgen3,@biggest,@brown,@france,@itsascam,@james,@diego,@analisa,@anastacia,@nextgen16,@hiva,@aftergut,@fmooo,@mottler3,@drsteem,@abdul,@teem,@ashleigh,@donkeyman1,@hiva1,@aguilar,@arroyo,@back,@jones,@azeroth,@augusta,@scam,@mary,@franz,@bitcointalker,@blackrock,@essence,@barrie,@chen,@bendixen,@thomass,@aeon,@monero,@function,@structure,@benita,@yomamasofat,@kkk,@bess,@lll,@blanche,@style,@dantheman11,@cherly,@claudine,@mmm,@nnn,@lee,@nextgencrypto9,@adrian,@dantheman12,@dantheman13,@steempty,@steempty1,@lin,@italy,@anna,@emily,@galel,@dantheman22,@norway,@scamcoin,@gamath,@steempty2,@steempty3,@scamconfirmed,@hannah,@smooth,@steempty4,@jenn,@bottai,@brownrigg,@bucci,@alice,@bob,@figaro,@aaa,@starky,@user,@sminer1,@sminer10,@sminer11,@sminer12,@madison,@sminer13,@sminer15,@sminer16,@sminer17,@sminer18,@sminer19,@sminer2,@sminer20,@sminer21,@sminer22,@sminer23,@sminer25,@sminer26,@sminer27,@sminer28,@sminer29,@sminer3,@sminer30,@sminer31,@sminer32,@sminer33,@sminer35,@sminer36,@sminer37,@sminer38,@sminer39,@sminer4,@sminer40,@sminer41,@sminer42,@sminer43,@sminer45,@sminer46,@sminer47,@sminer48,@sminer49,@sminer5,@sminer50,@sminer51,@sminer52,@sminer53,@sminer55,@sminer56,@sminer57,@sminer58,@sminer59,@sminer6,@sminer60,@sminer61,@sminer62,@sminer63,@sminer65,@sminer66,@sminer67,@sminer68,@sminer69,@gifthana,@graavor,@sminer7,@sminer70,@sminer71,@sminer72,@sminer73,@sminer75,@sminer76,@sminer77,@sminer78,@fff,@anonymous,@ggg,@sminer79,@sminer8,@rainman,@bbb,@jamgotin,@ashley,@brianna,@hailey,@sminer80,@sminer81,@sminer82,@sminer83,@sminer85,@lessys,@colorblue,@charlesmanson,@jacktheripper,@rainmac,@jeffreydahmer,@berniesanders,@americanpegasus,@jasmine,@penambang,@binaryfate,@lisp,@kevphanis,@debruyne,@canadiancruz,@arctic,@earth,@bach,@atlantic,@dnaleor,@edison,@sminer86,@sminer87,@sminer88,@sminer89,@sminer9,@mars,@sminer90,@bearface,@cleta,@berkah,@rainman2,@nxtgencrpto11,@alvaro,@hello,@hanyuu,@rainman3,@mastersmaster,@kevtorin,@nxtgencrpto1,@nxtgencrpto12,@cucistim,@nxtgencrpto10,@tyler,@summon,@summon1,@natsu,@mottler-5,@mottler-6,@mottler7,@unix,@charleskoch,@luigi,@lxteem,@kalimdor,@nxtgencrpto2,@kidrock,@nerivyre,@lightfoot,@node1,@node2,@star,@fluffypony,@fluffyponyza,@summon10,@janaraeh,@kayana,@nxtgencrpto16,@nxtgencrpto17,@kriborin,@imaginary,@rainman1,@panword,@nxtgencrpto13,@summon2,@schmarn,@summon3,@majorminer,@schmarn1,@summon11,@schmarn2,@rainmac1,@cloop4,@summon12,@solaris,@summon13,@google,@summon4,@node3,@cloop5,@donalddrumpf,@ccc,@jesus,@motu,@schmarn3,@kotori,@summon5,@summon6,@world,@murdock3,@eclipse,@murdock4,@murdock5,@rainman4,@nxtgencrpto6,@nxtgencrpto7,@blocktrades,@btsnow,@schuh,@usd,@fabian,@bitshares,@fabi,@org,@info,@com,@news,@murdock6,@checkbook,@bytemaster,@fattire,@skywalker,@bitcoin2016,@slack,@simpson,@eclipse1,@lockheed,@testdrive,@totem,@mn12defgj2,@proskynneo,@alphabet,@hopeless,@excalibur,@firstclass,@microsoft,@university,@kevlar,@weather,@fantasy,@neonminer,@enable,@blackjack,@eternity,@rainman5,@murdock13,@wpcteem,@neogen1,@btc,@alpha,@murdock10,@murdock1,@jamesbond,@goldbug,@emf,@sex,@sexy,@ben,@michaela,@michaelb,@vala,@valb,@dan,@ned,@jamesc,@freedom,@bitcoin,@hermes,@murdock11,@terra

Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!
Sort Order:  

What's your definition of id? I used the id on steemd.com. See https://steemd.com/@ned and my original post https://steemit.com/statistics/@blockchainstudio/real-one-millionth-steemit-user-and-hidden-very-first-user As I replied to your comment, I just didn't include all 100 users although I found them all.

·

One possibility of your result is SQL query doesn't include some artificial users that they probably don't wanna show, which is the same reason why I didn't include them all. For instance, there are many danthemans :) and such things. I actually think that might be one reason why they don't provide API that queries with id number. Anyway, just try steemd.com It's basically Steemit's blockchain.info

·
·

You were right about that. There was an issue in the query. I had a where condition that had excluded the inactive accounts and I mistook the order as id :) I have updated the post now. Thanks for pointing it out.

I am using this query now.
SELECT TOP 500 id,CONCAT('@',name),created FROM [dbo].[Accounts] order by created,id ;

I know one thing the first created account in @null and 3rd id belongs to @initminer .

No idea how to get the first 100 ids though

·

I think this result may be wrong and is actually wrong if we use id from steemd.com as I did. Although I already found first 100 ids, I only posted them selectively for some reasons, please see this: https://steemit.com/statistics/@blockchainstudio/real-one-millionth-steemit-user-and-hidden-very-first-user

·

You are right. I have updated the post with the correct list now. Thanks for pointing out.