Viewing a response to: @paulag/how-to-get-a-post-on-steemit-trending-what-the-data-tells-us
Nice work! What is TxVotes?
| post_id | 9,456,935 |
|---|---|
| author | gregario |
| permlink | re-paulag-how-to-get-a-post-on-steemit-trending-what-the-data-tells-us-20170807t112543688z |
| category | steemit |
| json_metadata | "{"app": "steemit/0.1", "tags": ["steemit"]}" |
| created | 2017-08-07 11:24:45 |
| last_update | 2017-08-07 11:24:45 |
| depth | 1 |
| children | 1 |
| net_rshares | 0 |
| last_payout | 2017-08-14 11:24: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 | 27 |
| author_reputation | 2,754,228,703,338 |
| root_title | "How to get a post on Steemit Trending - What the data tells us" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |
txvotes is a table in the sql database
| post_id | 9,478,390 |
|---|---|
| author | paulag |
| permlink | re-gregario-re-paulag-how-to-get-a-post-on-steemit-trending-what-the-data-tells-us-20170807t155210535z |
| category | steemit |
| json_metadata | "{"app": "steemit/0.1", "tags": ["steemit"]}" |
| created | 2017-08-07 15:52:09 |
| last_update | 2017-08-07 15:52:09 |
| depth | 2 |
| children | 0 |
| net_rshares | 235,521,017 |
| last_payout | 2017-08-14 15:52:09 |
| 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 | 38 |
| author_reputation | 224,445,607,823,384 |
| root_title | "How to get a post on Steemit Trending - What the data tells us" |
| beneficiaries | [] |
| max_accepted_payout | 1,000,000.000 SBD |
| percent_steem_dollars | 10,000 |
| author_curate_reward | "" |
| voter | weight | wgt% | rshares | pct | time |
|---|---|---|---|---|---|
| gregario | 0 | 235,521,017 | 3.13% |