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.

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 ;