RE: Voting habits of the top 200 Whales - SteemitSQL Analysis by necrophagist

steemit · @necrophagist · Aug 2 '17

$0.04

Fantastic information paula, I am looking at learning analytics software such as tableau and mongodb/sql to further my career so this is really fascinating.  When you reference times, are these times in UTC?

👍 necrophagist

`post_id`	9,046,450
`author`	necrophagist
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170802t222810452z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-02 22:28:12
`last_update`	2017-08-02 22:28:12
`depth`	1
`children`	1
`net_rshares`	9,180,040,401
`last_payout`	2017-08-09 22:28:12
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.027 SBD
`curator_payout_value`	0.008 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	207
`author_reputation`	1,959,847,242,549
`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
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
necrophagist	0 B		9,180,040,401	100%

`post_id`	9,179,349
`author`	paulag
`permlink`	re-necrophagist-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170804t094926394z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-04 09:49:24
`last_update`	2017-08-04 09:49:24
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-11 09:49:24
`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`	13
`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