Steem First 100 users
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.
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.
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
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 ;@gokulnk You have earned a random upvote from @botreporter & @bycoleman because this post did not use any bidbots.
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.