Viewing a response to: @paulag/voting-habits-of-the-top-200-whales-steemitsql-analysis
Interesting breakdown @paulag. Forgive the naive question (if it is) but do these patterns also take into account SP delegated by whales or is it strictly straight whale votes?
| post_id | 9,113,923 |
|---|---|
| author | theblindsquirl |
| permlink | re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170803t160945671z |
| category | steemit |
| json_metadata | "{"app": "steemit/0.1", "users": ["paulag"], "tags": ["steemit"]}" |
| created | 2017-08-03 16:09:45 |
| last_update | 2017-08-03 16:09:45 |
| depth | 1 |
| children | 2 |
| net_rshares | 0 |
| last_payout | 2017-08-10 16:09:45 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 SBD |
| curator_payout_value | 0.000 SBD |
| pending_payout_value | 0.000 SBD |
| promoted | 0.000 SBD |
| body_length | 177 |
| author_reputation | 3,640,081,530,758 |
| root_title | "Voting habits of the top 200 Whales - SteemitSQL Analysis" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |
no it does not take into consideration sp delegated.....now that one I must look at....watch this space!
| post_id | 9,129,125 |
|---|---|
| author | paulag |
| permlink | re-theblindsquirl-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170803t192903088z |
| category | steemit |
| json_metadata | "{"app": "steemit/0.1", "tags": ["steemit"]}" |
| created | 2017-08-03 19:29:00 |
| last_update | 2017-08-03 19:29:00 |
| depth | 2 |
| children | 1 |
| net_rshares | 0 |
| last_payout | 2017-08-10 19:29:00 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 SBD |
| curator_payout_value | 0.000 SBD |
| pending_payout_value | 0.000 SBD |
| promoted | 0.000 SBD |
| body_length | 104 |
| author_reputation | 224,445,607,823,384 |
| root_title | "Voting habits of the top 200 Whales - SteemitSQL Analysis" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |
I've got my eyes on you, so to speak. ;-)
| post_id | 9,130,494 |
|---|---|
| author | theblindsquirl |
| permlink | re-paulag-re-theblindsquirl-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170803t194735157z |
| category | steemit |
| json_metadata | "{"app": "steemit/0.1", "tags": ["steemit"]}" |
| created | 2017-08-03 19:47:36 |
| last_update | 2017-08-03 19:47:36 |
| depth | 3 |
| children | 0 |
| net_rshares | 0 |
| last_payout | 2017-08-10 19:47:36 |
| cashout_time | 1969-12-31 23:59:59 |
| total_payout_value | 0.000 SBD |
| curator_payout_value | 0.000 SBD |
| pending_payout_value | 0.000 SBD |
| promoted | 0.000 SBD |
| body_length | 41 |
| author_reputation | 3,640,081,530,758 |
| root_title | "Voting habits of the top 200 Whales - SteemitSQL Analysis" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |