<center>http://i.cubeupload.com/jRKIMn.png</center>

## SteemSQL is a public MS-SQL database with all the blockchain data in it.

#### Previous posts:
* [Introduction post](https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data)
* [SteemSQL  - Update 1](https://steemit.com/steemit/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-1)
* [SteemSQL  - Update  2](https://steemit.com/steemit/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-new-language-detection)
* [SteemSQL - Update 3](https://steemit.com/steemit/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update3)
* [SteemSQL  - Update 4](https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-2)
* [SteemSQL  - Update 5](https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-5)
* [SteemSQL  - Update 6](https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-6)
* [SteemSQL  - Update 7](https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-7)
* [SteemSQL  - Update 8](https://steemit.com/steemsql/@arcange/steemsql-a-public-sql-database-with-all-blockchain-data-update-8)
* [SteemSQL  - Update 9](https://steemit.com/steemsql/@arcange/steemsql-update-9-performances-improvement)
* [SteemSQL  - Update 10](https://steemit.com/steemsql/@arcange/steemsql-update-10)
* [SteemSQL  - Update 11](https://steemit.com/steemsql/@arcange/steemsql-update-11)
* [SteemSQL  - Update 12](https://steemit.com/steemsql/@arcange/steemsql-update-12-about-locks-and-performances)
* [SteemSQL  - Update 13](https://steemit.com/steemsql/@arcange/steemsql-update-13-virtual-operations-available)

### What's new

A new **`Witnesses`** table has been added to the database.

The `Witnesses` table is a non-transactional table which contains a list of all witnesses and related information.  The table content is updated every witness round (i.e. every 63 seconds as there are 21 witnesses producing a block every 3 seconds in each round) 

This table will allow my friend @drakos to directly grab all data required for his [witness page](https://steemian.info/witnesses) from SteemSQL. I guess many other SteemSQL’s users will find useful to have the information about witnesses at hand rather than to crawl the blockchain to get it.

### Witnesses table description

The table contains the following columns:

|Name|Description|
|-|-|
|name|Account name of the witness|
|votes_count|Number of votes the witness received|
|url|The URL of the witness presentation post|
|votes|Total amount of VEST from voters|
|total_missed|Number of blocks missed|
|last_aslot|This value indicate when the witness was last scheduled for block production|
|last_confirmed_block_num|Block number of the last block signed by the witness|
|signing_key|Current signing key use by the Witness. A value of `STM1111111111111111111111111111111114T1Anm` means the witness has been deactivated and will no more be scheduled for block production|
|account_creation_fee|Proposed cost for the creation of a new account|
|account_creation_fee_symbol|STEEM|
|maximum_block_size|Proposed maximum block size. The greater, the more information and transactions the blockchain can store in each block|
|sbd_interest_rate|Proposed interest rate to rewards users holding SBD|
|sbd_exchange_rate_base|Proposed cost in SBD to buy 1 STEEM|
|sbd_exchange_rate_base_symbol|SBD|
|sbd_exchange_rate_quote| Proposed value for the ratio between SBD and STEEM for rewards|
|sbd_exchange_rate_quote_symbol|STEEM|
|last_sbd_exchange_update|Last time the witness updated its pricefeed|
|running_version|Current version of the witness node|
|hardfork_version_vote|Current version of the hardfork supported by the witness|
|hardfork_time_vote|Time of vote from the witness for the latest supported hardfork|


Here an updated diagram of the database:


![](http://i.cubeupload.com/EgwjPQ.jpg)


Visit [SteemSQL.com website](http://steemsql.com) for more information.

Thanks for reading.

---
<center>[![](/http://i.cubeupload.com/ICGF9m.png)](http://steemitboard.com/@arcange)</center>
###### <center>_footer created with **[steemitboard](steemitboard.com)** - click any award to see my board of honor_</center>

### <center>Support me and my work as a witness by voting for me  [here!](https://steemit.com/~witnesses)</center>
<center>[![](http://i.cubeupload.com/OOGrbS.png)](https://steemit.com/~witnesses)</center><center>**You can also [vote for my witness with SteemConnect](https://v2.steemconnect.com/sign/account-witness-vote?witness=arcange&approve=1)**</center>