<center>https://cdn.steemitimages.com/DQmXAevND4Wcy89BfHkdzDXTiUaCEnCJL55hCuW9Wh4Rzt9/sw-logo.png</center>
https://steemitimages.com/DQmXA9RBqr2qRTbWpcnvGDv38v9v6gak6WotkLMMUZxeERk/hr_thin.png

I'm in the process of adding a new tool to <a href="https://steemworld.org">SteemWorld</a> that will give us an overview of all Steem accounts with many different filtering and sorting capabilities.

The tool will offer predefined sets of data like:

- top/flop accounts by vesting shares (SP)
- top/flop accounts by STEEM/SBD balance
- top/flop accounts by reputation
- top/flop accounts by earned author/curation rewards
- biggest active Powerdowns
- newest/oldest Steem accounts
- and more...

It will also be possible to search for specific criteria.
For example, one can search for accounts:

- where `recovery_account` = `abc`
- where `proxy` = `abc`
- where `mined` = `1`
- and more...

---

In regards to keeping the database updated in real-time I'm still in the planning stage and maybe I will build an own plugin for `steemd` for this. As I already parse each block for other tools on SteemWorld, I might implement it in the existing parsing routines. I will see what's the best solution in my case and keep you updated.

For now I created a test (SQLite) db that contains all the data I need (updated last night) with simple indices (no multi column indices for now, just one for each column in the table). If you are a developer or statistics guy and you want to play around with the data, you can download the (xz compressed) database here:

https://steemworld.org/dl/steem_accounts.sqlite3.xz
( 96.6 MB compressed / 586.0 MB uncompressed )

---

The `accounts` table currently contains the following columns:

- `id`
- `name`
- `recovery_account`
- `proxy`
- `created`
- `last_account_recovery`
- `last_account_update`
- `last_owner_update`
- `last_post`
- `last_root_post`
- `last_vote_time`
- `next_vesting_withdrawal`
- `balance`
- `sbd_balance`
- `reward_steem_balance`
- `reward_sbd_balance`
- `reward_vesting_balance`
- `reward_vesting_steem`
- `savings_balance`
- `savings_sbd_balance`
- `vesting_shares`
- `delegated_vesting_shares`
- `received_vesting_shares`
- `to_withdraw`
- `withdrawn`
- `vesting_withdraw_rate`
- `curation_rewards`
- `posting_rewards`
- `reputation`
- `pending_claimed_accounts`
- `post_count`
- `savings_withdraw_requests`
- `withdraw_routes`
- `can_vote`
- `mined`

---

If you are on Linux, you can just install 'DB Browser for SQLite' (open source) and jump directly into the db explorer simply by double-clicking the file (after decompressing it from `steem_accounts.sqlite3.xz` to `steem_accounts.sqlite3` of course).

As @amico stated, the <a href="https://sqlitebrowser.org/dl/">SQLite DB Browser</a> is also available for Windows and MacOS ;)

<strong>Have fun and Steem on!</strong>

https://steemitimages.com/DQmXA9RBqr2qRTbWpcnvGDv38v9v6gak6WotkLMMUZxeERk/hr_thin.png

If you like what I do and you want me to be your Steem witness,
please vote for @steemchiller on <a href="https://steemit.com/~witnesses">steemit.com/~witnesses</a> or <a href="https://steemworld.org/witnesses">steemworld.org/witnesses</a>.

https://steemitimages.com/DQmXA9RBqr2qRTbWpcnvGDv38v9v6gak6WotkLMMUZxeERk/hr_thin.png
https://steemitimages.com/DQmarYCHGSBms38CSwf8Be3n56RN16nz8MS6MTSV2jX3TfT/chiller-footer-sh-400x90.png