Voting habits of the top 200 Whales - SteemitSQL Analysis by paulag

steemit · @paulag · Jul 31 '17

$60.67

Voting habits of the top 200 Whales - SteemitSQL Analysis

<html>
<p>Recently I was asked by @bisade on Discord</p>
<p><em>'Is it possible to get data on how active whales are in voting and commenting on the Steemit platform?'</em></p>
<p>So lets dive into the details of how and what I have found out</p>
<p>First of all I got a list of Whales from https://steemwhales.com. &nbsp;I have use Power BI to connect to the website and pull down the table. &nbsp;For the sample data I have taken the first 200 whales.</p>
<p>Next I used Power BI to connect to SteemitSQL where I pulled down the data from TXVotes and Comment. &nbsp;</p>
<p>Due to the large amounts of data and the limitations of PowerBI Desktop I have only taken data for the last two week for votes, and three weeks for comments. (I have taken the extra week for comments because of the 7 day pay out thingy…)</p>
<p>Next I merge these TX Votes and Comment tables together using the permalink as the common field of data. &nbsp;This data is probably already merge in one of the tables, but look I am new here so I took the difficult route to get there lol…. If there is a table, please do tell me….</p>
<h2>So what have I found out about the voting habits of whales?</h2>
<p>From 15 July to 30 July @21:00 gmt there were in total 5,423,382 votes made on the platform. &nbsp;These votes were made for both Posts and Comments on Posts. &nbsp;These votes were made up from 52,750 distinct voters on 37,579 different Authors posts.</p>
<p>On Average over the time period taken (15 days) each voter voted 6.85 times per day.</p>
<p>Filtering this down to the top 200 whales.</p>
<p>141,439 votes were made by 124 whales. &nbsp;That makes up 2% of the votes by less than .25% of the number of Voters. Averaging out at 76 votes each per day, which is well above the average. &nbsp;These votes were spread across 11,376 different authors.</p>
<p>Here is the top 15 of the top 200 whales for number of votes given</p>
<p>https://steemitimages.com/DQmeY246GJZY5t9tKodyuA5N1Gpmg39nPxDG2siWRpLBqN3/1a.png</p>
<h2>Self-Voting</h2>
<p>Out of the votes made by Whales, I looked at how many of these votes were self-votes. &nbsp;A whales vote is worth quite a lot, especially if there are in the top 200 whales. &nbsp;</p>
<p>49 Whales did not self-vote at all. 57 Whales self-voted between 1-20 times. In total there were 1863 self-votes made by whales, thats only 1.3% of all votes made by the 200 top whales. Here is a table with the top 15 from the top 20 whales guilty of self-voting.</p>
<p>https://steemitimages.com/DQmarGQfz6A5TYmfbWssZ69zbLK4MviYvekWeMQP2JZMYHG/1b.png</p>
<h2>Voting for Other Whales</h2>
<p>A lot of minnows are under the impression that Whales just vote for whales. &nbsp;Well my analysis tells a different story. &nbsp;Only 2.25% of votes made by the top 200 whales are for other Whales also in the top 200.</p>
<p>This tables shows the whales with the largest % of votes that went to other whales included in this analysis</p>
<p>https://steemitimages.com/DQmRb9U3hzWbjnEb36ZcudhGrbdrzNrS1UjWwdA2DhPumCN/1c.png</p>
<h2>What do Whales like to vote for and when?</h2>
<p>In total the top 200 whales voted on 17330 tag. &nbsp;Some are obviously way more popular than others. &nbsp;Have a look at the graph below for more details.</p>
<p>https://steemitimages.com/DQmbw9iYxU2sGebJUJdKU7NaESnB7rqQAb9etbeLdVXHu6R/1d.png</p>
<p>Comparing this to overall</p>
<p>https://steemitimages.com/DQmSx7hwEYW4Abai82WacoMMDhLtEvAav3NqpH4AZAzh7Mw/1e.png</p>
<p>To my surprise the weekend are the most popular times for whale voting</p>
<p>https://steemitimages.com/DQmSPFFu8r1GsZp3vMXiZXXyQt1jwxM8mMPALaYv5swL3UF/1f.png&nbsp;</p>
<p>Whereas overall on Steemit the most popular day is actually Saturday</p>
<p>https://steemitimages.com/DQmTHPgXcJUhX7Ze3ABmaBavzEPZnaB7DUMxqy2z3gC7zm2/1g.png</p>
<p>And the most popular voting times are 5am and 13pm</p>
<p>https://steemitimages.com/DQmXHrcWwx2RKRvyygLkmf78UmwzshqLnxb9x4XA11UZA5H/1h.png</p>
<p>Whereas overall the most popular time is 5pm</p>
<p>https://steemitimages.com/DQmNVSNzhzWC4pBYFqm8Gv2EWiy9Gv8Wcvc7QnSTbAoYTPR/1i.png</p>
<p>Finally I looked to see if whales tend to post more on Posts or Comments.</p>
<p>Of the 141,439 votes made by these whales, 118,688 were votes made directly on blog posts. That's 84%. &nbsp;The rest (16%) of the votes were made on comments on posts.</p>
<p>Unfortunately I am not able to embed a Power BI interactive dashboard into Steemit. &nbsp;But with the dashboard I have created I can drill down to each Whale and see exactly who and when their votes went to. &nbsp;In fact the data would allow me predict who the whales might vote for so I can vote just before them…..&nbsp;</p>
<p>https://steemitimages.com/DQmXuZrDWs48PoLP2wa2XdQNB4bcuSFRXC7qywAeyn26bZd/1j.png</p>
<p>For example I have selected Honeybeee in the table of data and all other reports have updated. &nbsp;I can see that Honeybeee only votes on posts, not comments and 243 votes were on 25 Authors, @barrydutton, @papa-pepper and so on……..</p>
<p>Each one of the visualization, when clicked will drill down to the other charts, so I could also select an Author and see which whales votes for them.</p>
<p>This is a really awesome dashboard that gives me real actionable insights….If you want a copy, well we can swap. I will give you a copy for Steem?????</p>
<p>And this is only the Voting habits’……we will look at commenting in a different post!</p>
<p>If you liked this post and found it of use, I hope that you will resteem, Vote up and Comment....</p>
</html>

👍 ausbitbank, nanzo-scoop, demotruk, lukestokes, stellabelle, jaki01, furion, minnowbooster, timcliff, krnel, randowhale, br-real, joythewanderer, igster, geofftk, decayinjack, okkiedot, flipstar, kenny-crane, aggroed, celebr1ty, minnowsupport, benjiberigan, jessamynorchard, leoplaw, msp-lovebot, reisman, meesterboom, steevc, gric, tumutanzi, joeyrocketfilms, arturomdg, jameshsmitharts, greyman, ender, datageek, remlaps, sreepyeldarb, farmstead, makshay5, sourcebird, abh12345, rt395, freebornsociety, anomadsoul, stackin, rawbinhutt, stephmckenzie, benchi, bisade, world-travel-pro, hypexals-spiral, larryphang, necrophagist, globaldoodlegems, patelincho, the-traveller, ammonite, marcelli, stortebeker, paulag, cosimo, skririm, and 187 others

`post_id`	8,842,555
`author`	paulag
`permlink`	voting-habits-of-the-top-200-whales-steemitsql-analysis
`category`	steemit
`json_metadata`	"{"format": "html", "links": ["https://steemwhales.com"], "app": "steemit/0.1", "tags": ["steemit", "analytics", "stats", "upvote"], "users": ["bisade", "barrydutton", "papa-pepper"], "image": ["https://steemitimages.com/DQmeY246GJZY5t9tKodyuA5N1Gpmg39nPxDG2siWRpLBqN3/1a.png"]}"
`created`	2017-07-31 20:37:33
`last_update`	2017-07-31 20:37:33
`depth`	0
`children`	123
`net_rshares`	14,971,072,278,711
`last_payout`	2017-08-07 20:37:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	50.795 SBD
`curator_payout_value`	9.878 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	5,519
`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`	0
`author_curate_reward`	""

properties (23)vote details (251)

voter	rshares	pct
pheonike	2,850,469,487	1%
fractalnode	0	100%
germanaure	395,084,952	1%
teamsteem	0	1%
nanzo-scoop	2,150,827,126,548	40%
stellabelle	1,156,134,590,892	100%
kenny-crane	87,218,492,071	20%
lukestokes	1,891,680,931,606	100%
michaellamden68	957,013,547	1%
elyaque	7,506,828,160	0.1%
endaksi1	150,629,381	1%
okkiedot	96,491,886,664	100%
furion	824,887,174,464	100%
ausbitbank	2,238,881,194,527	21%
cloh76	211,796,499	0.2%
edrivegom	266,455,304	0.1%
diana.catherine	422,761,715	0.1%
igster	152,562,104,370	100%
meesterboom	46,225,640,115	10%
raymondspeaks	854,594,130	1%
shla-rafia	0	100%
demotruk	1,972,646,691,315	100%
benjiberigan	48,964,175,530	100%
ask-not-please	5,089,955,660	100%
mitchmahoney	2,030,549,366	100%
joythewanderer	155,171,134,677	100%
celebr1ty	60,989,937,937	23%
remlaps	20,741,151,078	50%
timcliff	424,817,964,497	38%
cryptoninja	673,598,720	100%
stephen.king989	1,084,461,247	0.2%
efrageek	63,782,047	0.1%
mindfreak	2,406,635,716	1%
steevc	45,169,877,774	17%
tumutanzi	30,269,574,534	70%
tjtrusty	97,645,276	1%
krnel	290,967,663,967	25%
stephmckenzie	11,229,532,024	25%
aggroed	62,742,305,430	100%
leoplaw	48,188,949,899	100%
ender	21,645,736,524	100%
patelincho	9,250,044,381	10%
abh12345	12,078,998,650	35%
jhermanbeans	399,634,922	0.1%
worldtraveler	137,702,394	0.2%
timbot606	2,237,859,942	25%
luismy	100,587,852	0.1%
jaki01	864,853,595,886	50%
br-real	233,210,746,042	100%
jessamynorchard	48,676,103,065	98%
missk	3,187,334,058	100%
starrkravenmaf	227,109,022	0.3%
steemprentice	1,280,075,059	0.1%
reisman	46,633,045,633	100%
dammylohar	60,081,316	1%
didideras	993,775,411	100%
lastminuteman	3,162,714,785	0.3%
komersreal	1,246,541,655	100%
digitalfirehose	5,875,888,997	100%
loreennaa	166,585,300	0.1%
elgeko	1,716,362,151	0.2%
ogochukwu	834,282,384	0.1%
shaunmza	5,159,867,450	10%
gunsmithing	7,672,575,973	34%
pomperipossa	314,697,402	0.1%
aaronmda	4,903,818,735	100%
adam.angel	2,157,239,837	100%
hypexals-spiral	10,344,237,082	100%
samuelpaddy	196,905,634	100%
decayinjack	123,943,222,860	100%
sixexgames	54,942,369	1%
banjo	270,955,216	1%
gric	31,839,524,557	100%
borislavzlatanov	7,273,356,230	100%
freebornsociety	11,733,846,076	100%
singa	90,028,314	0.1%
numpypython	106,786,229	0.1%
necrophagist	10,058,771,567	100%
detlev	143,511,353	0.1%
jameshsmitharts	27,003,311,969	100%
skririm	8,267,191,184	100%
ienrikex	69,814,234	0.1%
miniature-tiger	2,515,348,553	100%
aarellanes	256,822,160	0.1%
anomadsoul	11,450,394,101	41%
outerground	103,564,733	1%
santanero714	137,568,060	100%
jhagi.bhai	83,702,933	0.2%
bdmomuae	5,536,558,346	100%
yummymummy	53,311,017	0.1%
passteque	621,340,000	100%
gindor	393,974,053	0.2%
suzique	2,215,946,518	100%
nicholevargas	1,655,046,075	100%
thorleyjo	315,175,678	100%
hulabugger	613,636,929	100%
abcdoctor	87,631,412	1%
grider123	1,534,684,290	100%
mtgmisfit	6,510,900,460	100%
whatamidoing	114,971,322	0.1%
shawnfishbit	616,688,731	0.1%
emble	67,938,533	3%
stackin	11,449,010,642	1%
nomad88	7,715,748,461	100%
omwith	8,122,747,277	20%
tomekkk	5,811,140,692	100%
world-travel-pro	10,640,865,421	100%
rt395	12,044,683,363	100%
greyman	21,837,320,803	100%
timbalabuch	100,986,992	1%
gohba.handcrafts	216,507,779	0.1%
jotmax	66,574,856	1%
qwasert	108,252,009	0.2%
reedus	2,739,745,236	100%
primal-buddhist	1,841,699,905	100%
the-traveller	9,202,557,318	100%
taica	138,823,033	0.1%
guiltyparties	1,399,417,853	100%
flipstar	94,304,503,452	15%
rycharde	197,885,746	0.2%
pusteblume	212,242,991	1%
marcelli	8,666,800,353	100%
themerrylotus	254,749,400	100%
cryptohustler	180,982,957	1%
phoblographer	4,830,017,435	100%
raizen	243,173,289	1%
davidthelad	2,995,403,076	100%
drwom	78,257,078	0.1%
droucil	998,944,933	2%
knowledge1	4,825,968,680	100%
stellawatson	219,504,612	100%
stortebeker	8,573,732,647	100%
randowhale	266,297,183,295	2.7%
minnowsupport	51,925,928,880	1%
badastroza	340,830,612	0.1%
steeminator3000	184,271,518	100%
burnedpixel	152,290,429	0.2%
raymeela89	2,594,533,057	100%
andrewgenaille	101,442,189	0.2%
ammonite	9,121,533,128	74.59%
globaldoodlegems	9,334,852,175	100%
hooplevonwinkle	2,930,461,728	100%
n1kofi	248,645,518	1%
vigux	2,779,874,296	100%
cryptofrygirl	1,609,414,164	100%
rawbinhutt	11,382,268,697	100%
pennsif	5,503,703,370	25%
gokulnk	0	0%
stella87s	70,905,621	1%
paulag	8,427,308,622	100%
gregario	419,392,975	5.17%
prowebwriter	1,217,167,180	100%
sylviategan	1,591,195,921	100%
iaso	2,672,073,219	100%
myday	137,564,190	0.1%
markfitzgerald	124,983,089	1%
bragih	1,989,817,175	100%
bisade	10,805,580,769	100%
kramarenko	91,375,155	100%
davidwilliams	5,320,746,081	100%
farmstead	17,609,730,516	100%
stresskiller	4,876,906,415	100%
makshay5	12,910,103,284	100%
whd	6,484,204,465	100%
melodysellshomes	1,219,146,832	100%
lanadancer	963,995,042	100%
joeyrocketfilms	29,007,394,471	100%
diabolika	204,375,156	1%
androsform	5,382,586,408	100%
nesbitt	77,144,399	1%
ackhoo	2,844,342,046	100%
benchi	10,896,687,442	100%
darkprism	734,675,762	100%
bluchr	185,627,162	0.2%
talltim	1,477,745,865	100%
glex	79,326,597	0.1%
thechange	4,545,033,510	100%
steemreports	2,925,486,278	100%
yardieonwallst	1,215,656,052	100%
ariane	3,230,190,570	100%
jeffrey24864	508,006,400	100%
smackit	1,207,113,728	100%
kerlund74	594,504,096	100%
minnowbooster	500,252,512,426	7%
thephotoguide	3,814,039,959	100%
arturomdg	28,681,908,779	100%
eyegasm	220,055,891	1%
dernan	1,163,380,778	100%
sourcebird	12,536,840,066	100%
geofftk	147,423,666,206	100%
achraf7b	1,028,417,130	100%
msp-lovebot	47,313,282,616	10%
steemitbc	5,414,175,636	100%
katsics	1,630,004,588	100%
steemulator	1,244,753,350	100%
paulie2coins	551,807,964	100%
iamrifk	152,517,210	100%
beansmo	4,829,693,476	100%
jayjayjeffery	2,091,830,483	100%
upgoat	1,400,126,930	7%
resheep	737,081,183	7%
steembd	362,419,200	100%
datageek	20,883,218,224	100%
nickwalshblog	261,153,020	100%
pijushmitra	1,641,604,665	100%
idakwo1	1,253,695,077	100%
steemitri	6,410,732,587	100%
technoshout	400,043,737	100%
jakemore	1,160,679,731	100%
msp-shanehug	7,702,947,262	10%
geek4geek	494,190,373	100%
investingpennies	1,234,372,827	1%
sreepyeldarb	18,230,473,747	100%
evgenya86	142,782,534	100%
rina.tours.world	1,637,520,957	100%
cosimo	8,310,629,481	100%
eatriderepeat	1,003,982,847	100%
amade	0	100%
hassenmzali	1,081,830,121	100%
eternalsunshine	0	100%
fuchsia.ink	1,160,669,273	100%
nabilamk	1,162,569,282	100%
jjb777	424,709,979	100%
bescouted	1,388,305,905	100%
spezi	1,349,837,821	100%
jcramos	328,051,100	100%
dunsky	754,868,304	100%
vinniethriver	0	100%
sdibot	120,806,622	1%
eleon88	203,115,875	100%
rerycore	391,201,494	100%
revo	544,084,501	100%
davidpercival	829,867,854	100%
braxton101	446,851,899	100%
larryphang	10,084,865,913	100%
bigdave2250	978,536,683	100%
nikhilr	548,275,200	100%
obawisewest	52,891,966	100%
mohamadshwa5	81,245,764	100%
thatwilldopig	81,245,758	100%
imloo	783,440,820	100%
ethper	470,064,339	100%
djneontiger	291,174,400	100%
bokseur	684,784,965	100%
cryptomam	1,160,652,339	100%
waffledough	0	100%
hato	1,143,241,026	100%
tonygreene113	0	100%
mikebluehair42	0	100%
arsen131976	0	100%
dirtweasel	0	100%

@bisade · Jul 31 '17 (edited)

Didn't expect you to reply with a whole post haha, but fantastic work nonetheless. Really helps me better understand the steemit platform.

Thanks, @paulag!

👍 minnowpond

`post_id`	8,843,228
`author`	bisade
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t204728793z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["paulag"], "tags": ["steemit"]}"
`created`	2017-07-31 20:47:30
`last_update`	2017-07-31 20:53:00
`depth`	1
`children`	1
`net_rshares`	941,345,828
`last_payout`	2017-08-07 20:47:30
`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`	156
`author_reputation`	1,843,128,249,425
`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
minnowpond	0 B		941,345,828	1%

@paulag · Jul 31 '17

$0.02

I also have a post coming for you with data on how whales tend to comment......ask and you shall receive....lol you will probably never ask me a 'quick question' again....

👍 mtgmisfit

`post_id`	8,844,658
`author`	paulag
`permlink`	re-bisade-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t210817084z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:08:18
`last_update`	2017-07-31 21:08:18
`depth`	2
`children`	0
`net_rshares`	6,355,879,020
`last_payout`	2017-08-07 21:08:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.019 SBD
`curator_payout_value`	0.005 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	171
`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
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
mtgmisfit	0 B		6,355,879,020	100%

@spezi · Jul 31 '17

Thank you for your work, very interesting. :)

properties (22)

`post_id`	8,843,287
`author`	spezi
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t204820374z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 20:48:21
`last_update`	2017-07-31 20:48:21
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2017-08-07 20:48:21
`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`	45
`author_reputation`	55,661,583,277
`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

@paulag · Jul 31 '17

you are welcome

properties (22)

`post_id`	8,844,473
`author`	paulag
`permlink`	re-spezi-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t210557246z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:05:57
`last_update`	2017-07-31 21:05:57
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:05:57
`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`	15
`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

@steemitri · Jul 31 '17

Great stats... thanks a lot!
Useful to understand (or trying to) Steemit.
Big hug
Steemitri The Mannequin

properties (22)

`post_id`	8,843,338
`author`	steemitri
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t204913031z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 20:49:15
`last_update`	2017-07-31 20:49:15
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2017-08-07 20:49:15
`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`	105
`author_reputation`	25,968,355,293,329
`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

@paulag · Jul 31 '17

awe thanks for the hug.  Hugs rock.  Glad you liked the post

properties (22)

`post_id`	8,844,577
`author`	paulag
`permlink`	re-steemitri-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t210719475z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:07:18
`last_update`	2017-07-31 21:07:18
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:07:18
`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`	60
`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

@leoplaw · Jul 31 '17

@paulag, **WOW!** You have really done your homework with the data. It indeed does tell a very different story to what rumour, theory and expectation that is the mainstay for the minnows of this network. This is one of the things I love about Steemit. If you want to take the time and effort, you find out for certain what is fact or fiction.
Upvoted!

👍 missk

`post_id`	8,844,020
`author`	leoplaw
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t210221983z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["paulag"], "tags": ["steemit"]}"
`created`	2017-07-31 20:59:36
`last_update`	2017-07-31 20:59:36
`depth`	1
`children`	3
`net_rshares`	3,134,505,317
`last_payout`	2017-08-07 20:59: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`	351
`author_reputation`	55,804,171,747,699
`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
missk	0 B		3,134,505,317	100%

@paulag · Jul 31 '17

blockchain hides no secrets.....all you need is good tools.  i know no programming for analysis, I just have a good self service business intelligence system.....Power BI rocks

👍 leoplaw

`post_id`	8,844,769
`author`	paulag
`permlink`	re-leoplaw-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t210950401z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:09:51
`last_update`	2017-07-31 21:09:51
`depth`	2
`children`	2
`net_rshares`	4,793,665,173
`last_payout`	2017-08-07 21:09:51
`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`	176
`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
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
leoplaw	0 B		4,793,665,173	10%

@leoplaw · Jul 31 '17

I'm not familiar with Power BI. If I made the time, I could figure out how to pull the information out, filter and sort it. I used be a web programmer. 

But now, I'd rather devote the time and energy to my career of painting. Besides, there are wonderful stats geeks such as you to do the number crunching. Hence why I am following you. ;-)

properties (22)

`post_id`	8,847,144
`author`	leoplaw
`permlink`	re-paulag-re-leoplaw-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t214629842z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:43:45
`last_update`	2017-07-31 21:43:45
`depth`	3
`children`	1
`net_rshares`	0
`last_payout`	2017-08-07 21:43: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`	341
`author_reputation`	55,804,171,747,699
`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

1 reply

@abh12345 · Jul 31 '17

Another top statistical post! How much we talking for a copy of your dashboard?

properties (22)

`post_id`	8,844,208
`author`	abh12345
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t210209717z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:02:09
`last_update`	2017-07-31 21:02:09
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2017-08-07 21:02: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`	79
`author_reputation`	590,352,098,179,351
`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

@paulag · Jul 31 '17

I am open to offers......

properties (22)

`post_id`	8,844,518
`author`	paulag
`permlink`	re-abh12345-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t210629973z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:06:30
`last_update`	2017-07-31 21:06:30
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:06:30
`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`	25
`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

@globaldoodlegems · Jul 31 '17

Wow you sure did a lot of research ... Thank you for sharing your insight

properties (22)

`post_id`	8,844,437
`author`	globaldoodlegems
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t210534002z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:05:33
`last_update`	2017-07-31 21:05:33
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2017-08-07 21:05:33
`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`	73
`author_reputation`	3,252,536,824,313
`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

@paulag · Jul 31 '17

I enjoyed the research.  thanks for the comment

properties (22)

`post_id`	8,844,555
`author`	paulag
`permlink`	re-globaldoodlegems-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t210657838z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:06:57
`last_update`	2017-07-31 21:06:57
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:06:57
`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`	47
`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

@thorleyjo · Jul 31 '17

Wow!!!  This is super interesting info!  And useful as well.  As a newbee it gives me a better understanding of things.  I was pretty much on the right track after much research.  But this kind of confirms my theory.  Thanks again! Great post! Upvoted and Resteamed.

👍 leoplaw

`post_id`	8,844,899
`author`	thorleyjo
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t211130743z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:11:30
`last_update`	2017-07-31 21:11:30
`depth`	1
`children`	1
`net_rshares`	4,793,665,173
`last_payout`	2017-08-07 21:11:30
`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`	266
`author_reputation`	3,630,780,547
`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
leoplaw	0 B		4,793,665,173	10%

@paulag · Jul 31 '17

thank you for the vote and the resteem....I love resteems

👍 thorleyjo

`post_id`	8,845,075
`author`	paulag
`permlink`	re-thorleyjo-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t211341163z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:13:42
`last_update`	2017-07-31 21:13:42
`depth`	2
`children`	0
`net_rshares`	327,657,883
`last_payout`	2017-08-07 21:13:42
`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`	57
`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
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
thorleyjo	0 B		327,657,883	100%

@nickwalshblog · Jul 31 '17

good stuff learnt lots

properties (22)

`post_id`	8,845,084
`author`	nickwalshblog
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t211354259z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:13:54
`last_update`	2017-07-31 21:13:54
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:13:54
`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`	22
`author_reputation`	78,825,487,740
`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

@primal-buddhist · Jul 31 '17

<center>HolySmoke!
------  
This was Really Truly a Great post!!  
 it has literally caused me to change my way of thinking.. 
---------
Thank You
------- 
Resteemed.</center>

properties (22)

`post_id`	8,845,135
`author`	primal-buddhist
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t211430331z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:14:30
`last_update`	2017-07-31 21:14:30
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:14:30
`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`	175
`author_reputation`	2,726,186,454,195
`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

@ender · Jul 31 '17

$0.08

This is a really interesting analysis.  I guess my self voting is higher than the whales but the whales do have more inc drive to direct votes to where it will help he platform more. The 16 percent comment vote is also a little higher than I thought it would be.

👍 ender

`post_id`	8,846,025
`author`	ender
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t212745853z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:27:48
`last_update`	2017-07-31 21:27:48
`depth`	1
`children`	0
`net_rshares`	21,197,120,223
`last_payout`	2017-08-07 21:27:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.084 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	262
`author_reputation`	1,102,103,095,546
`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
ender	0 B		21,197,120,223	100%

@rawbinhutt · Jul 31 '17

Great to see an analysis on what big folks here are interested in voting on! Very well made.

I didn't know that there was such a difference between what whales vote on and what everyone generally votes on. Bitcoin vs Photography for example.

Maybe while Steemit have many people interested in crypto, a large amount of smaller users enjoy more traditional life-blog topics, although Bitcoin still makes up 3.3% of these votes as well.

Thanks for this article!

properties (22)

`post_id`	8,846,391
`author`	rawbinhutt
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t213315082z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:33:15
`last_update`	2017-07-31 21:33:15
`depth`	1
`children`	2
`net_rshares`	0
`last_payout`	2017-08-07 21:33:15
`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`	462
`author_reputation`	9,332,543,007,969
`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

@paulag · Jul 31 '17

thank you for the comment.  I am sure that there are so many niches here on steemit that its hard to get to the top.  but having this info really helps.

what I would say to people is that if they think their # needs more exposure then join LFN on discord and find people also liking that topic and work together to grow it...

properties (22)

`post_id`	8,846,798
`author`	paulag
`permlink`	re-rawbinhutt-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t213854372z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:38:54
`last_update`	2017-07-31 21:38:54
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:38:54
`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`	326
`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

@leoplaw · Jul 31 '17

@rawbinhutt yes, @paulag's work is very insightful, some things aren't such big surprises, as crypto dominating. But interests of smaller users might indicated where the network will head if Steemit becomes popular. It would be great if @paula could say do some long term and progressive analysis of voting patterns.

properties (22)

`post_id`	8,847,631
`author`	leoplaw
`permlink`	re-rawbinhutt-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t215325464z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["rawbinhutt", "paulag", "paula"], "tags": ["steemit"]}"
`created`	2017-07-31 21:50:42
`last_update`	2017-07-31 21:50:42
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:50:42
`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`	316
`author_reputation`	55,804,171,747,699
`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

@guiltyparties · Jul 31 '17

That's some really good analytics Paula.  Thanks for running these.

properties (22)

`post_id`	8,846,529
`author`	guiltyparties
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t213521715z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:35:15
`last_update`	2017-07-31 21:35:15
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:35:15
`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`	67
`author_reputation`	113,066,339,794,964
`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

@skririm · Jul 31 '17

$0.42

As I was really busy the whole month of July, I barely looked at my steemit feed... (Holiday, festivals, family, work, ... )... But now I finally took a look and I see this post! I do remember why I followed you in the first place! This is again a great post, with a very interesting topic, you took your time, did your research, and did write a nice text next to the facts and graphics! I love it, it's worth a 100% upvote and a resteem 😉 ! Keep up the good work!

👍 good-karma, skririm, sdibot

properties (23)vote details (3)

voter	rshares	pct
good-karma	101,214,322,063	0.5%
skririm	7,725,106,683	100%
sdibot	60,403,311	0.25%

@paulag · Jul 31 '17

$0.03

awesome feedback, thank you

👍 skririm

`post_id`	8,846,860
`author`	paulag
`permlink`	re-skririm-re-paulag-2017731t233543677z-20170731t213944727z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:39:45
`last_update`	2017-07-31 21:39:45
`depth`	2
`children`	0
`net_rshares`	7,659,996,351
`last_payout`	2017-08-07 21:39:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.024 SBD
`curator_payout_value`	0.006 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	27
`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
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
skririm	0 B		7,659,996,351	100%

@minnowsupport · Jul 31 '17

<p>Congratulations!  This post has been upvoted from the communal account, @minnowsupport, by paulag from the Minnow Support Project.  It's a witness project run by aggroed, ausbitbank, teamsteem, theprophet0, and someguy123.  The goal is to help Steemit grow by supporting Minnows and creating a social network.  Please find us in the <a href="https://discord.gg/HYj4yvw">Peace, Abundance, and Liberty Network (PALnet) Discord Channel</a>.  It's a completely public and open space to all members of the Steemit community who voluntarily choose to be there.</p>

<p>If you like what we're doing please upvote this comment so we can continue to build the community account that's supporting all members.</p>

properties (22)

`post_id`	8,846,578
`author`	minnowsupport
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t213609543z
`category`	steemit
`json_metadata`	"{"app": "cosgrove/0.0.1rc3", "tags": ["steemit"]}"
`created`	2017-07-31 21:36:09
`last_update`	2017-07-31 21:36:09
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:36: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`	707
`author_reputation`	104,981,098,086,561
`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

@datageek · Jul 31 '17

$0.03

I am blown away by how sophisticated your skills are. You should adopt me as your protege  :)

👍 igster

`post_id`	8,847,158
`author`	datageek
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t214348904z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 21:43:57
`last_update`	2017-07-31 21:43:57
`depth`	1
`children`	5
`net_rshares`	8,221,909,816
`last_payout`	2017-08-07 21:43:57
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.024 SBD
`curator_payout_value`	0.008 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	93
`author_reputation`	4,489,750,652,323
`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
igster	0 B		8,221,909,816	5%

@paulag · Jul 31 '17

$0.03

adoption granted......we will work on some projects together.  let me start by offering you some training courses (free of course).  i will contact you on discord.  thanks for the extra vote, you rock

👍 igster

`post_id`	8,848,419
`author`	paulag
`permlink`	re-datageek-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t220251582z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 22:02:51
`last_update`	2017-07-31 22:02:51
`depth`	2
`children`	3
`net_rshares`	8,221,909,816
`last_payout`	2017-08-07 22:02:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.024 SBD
`curator_payout_value`	0.008 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	200
`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
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
igster	0 B		8,221,909,816	5%

@jayjayjeffery · Aug 4 '17

How did you learn how to do these analytics @paulag? I just pulled up Power BI to check it out ... is it something you can teach yourself or do you have suggestions about how to pic it up. Do I need to learn how to code and all that techy stuff?

properties (22)

`post_id`	9,198,850
`author`	jayjayjeffery
`permlink`	re-paulag-re-datageek-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170804t143148777z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["paulag"], "tags": ["steemit"]}"
`created`	2017-08-04 14:31:42
`last_update`	2017-08-04 14:31:42
`depth`	3
`children`	2
`net_rshares`	0
`last_payout`	2017-08-11 14:31:42
`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`	245
`author_reputation`	13,558,830,206,659
`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

2 replies

@clumsysilverdad · Jul 31 '17

wow... ask and you shall receive

👍 oddbot

`post_id`	8,850,965
`author`	clumsysilverdad
`permlink`	re-datageek-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t224524957z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 22:45:24
`last_update`	2017-07-31 22:45:24
`depth`	2
`children`	0
`net_rshares`	974,737,711
`last_payout`	2017-08-07 22:45: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`	32
`author_reputation`	24,049,780,175,854
`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
oddbot	0 B		974,737,711	9%

@minnowbooster · Jul 31 '17

@minnowbooster upvoted this post!

![@datageek got you a $1.76 @minnowbooster upgoat, nice!](http://minnowshares.net/upgoat/?user=datageek&receiver=paulag&value=1.76&hash=237)
*@datageek got you a $1.76 @minnowbooster upgoat, nice! (Image: pixabay.com)*
---
[Want a boost? Click here to read more!](https://steemit.com/minnowbooster/@minnowbooster/6rt2mn-introducing-minnowbooster-beta)

properties (22)

`post_id`	8,847,411
`author`	minnowbooster
`permlink`	comment-1501537638292
`category`	steemit
`json_metadata`	{}
`created`	2017-07-31 21:47:18
`last_update`	2017-07-31 21:47:18
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 21:47:18
`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`	351
`author_reputation`	230,261,973,332,657
`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

@thephotoguide · Jul 31 '17

Incredible insight! I wish I knew this before...but I do know and can start taking advantage of my new knowledge. Thanks!!

properties (22)

`post_id`	8,849,313
`author`	thephotoguide
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t221756533z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 22:17:57
`last_update`	2017-07-31 22:17:57
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 22:17:57
`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`	122
`author_reputation`	688,300,013,034
`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

@clumsysilverdad · Jul 31 '17

holy hell... new follower here... amazing post !   ty & gl (-:

properties (22)

`post_id`	8,850,903
`author`	clumsysilverdad
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t224423331z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 22:44:21
`last_update`	2017-07-31 22:44:21
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 22:44:21
`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`	62
`author_reputation`	24,049,780,175,854
`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

@stephmckenzie · Jul 31 '17

What an incredible analysis. Good job. I don't know too many other people who would take the time to do this kind of thing. It's got some great insights in it, too. Thank you, @paulag.

properties (22)

`post_id`	8,852,733
`author`	stephmckenzie
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t231607674z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["paulag"], "tags": ["steemit"]}"
`created`	2017-07-31 23:16:06
`last_update`	2017-07-31 23:16:06
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2017-08-07 23:16:06
`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`	184
`author_reputation`	13,216,337,213,922
`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

@paulag · Aug 1 '17

$0.03

you are most welcome

👍 stephmckenzie

`post_id`	8,935,250
`author`	paulag
`permlink`	re-stephmckenzie-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t185653399z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 18:56:54
`last_update`	2017-08-01 18:56:54
`depth`	2
`children`	0
`net_rshares`	6,752,268,083
`last_payout`	2017-08-08 18:56:54
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.019 SBD
`curator_payout_value`	0.006 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	20
`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
`author_curate_reward`	""

properties (23)vote details (1)

@greyman · Jul 31 '17

This was a fascinating read. I'm surprised at the 16% comment vote - thought it would be less. I usually get tired after the first 10 or so. It's nice to see others actually read the comments. Great post!

properties (22)

@krnel · Aug 1 '17

Thanks for the stats on the whales ;)

properties (22)

@randowhale · Aug 1 '17

This post received a 2.7% upvote from @randowhale thanks to @aaronmda!  For more information, [click here](https://steemit.com/steemit/@randowhale/introducing-randowhale-will-you-get-the-100-vote-give-it-a-shot)!

properties (22)

@dwhntx · Aug 1 '17

Really good info bro and I like how you broke it down. Well done!

properties (22)

@paulag · Aug 1 '17

you are welcome

properties (22)

@dwhntx · Aug 1 '17

And by bro I mean good looking lady...

properties (22)

@pijushmitra · Aug 1 '17

Your have done a very good research to create this post. Upvoted for your hard work.

properties (22)

@paulag · Aug 1 '17

:-)

properties (22)

@paulag · Aug 1 '17

:-)

properties (22)

@joeyrocketfilms · Aug 1 '17

$0.03

Holy crap this is astonishing Paula. I've never seen something like this since I've been here. Sending you a tip right now for all your hard work! Thank you for this awesome contribution to the community 🙏🏼

👍 paulag

properties (23)vote details (1)

@paulag · Aug 1 '17

well now what an honor , thank you very much for the tip

properties (22)

@joeyrocketfilms · Aug 4 '17

$0.02

My pleasure :) Just a small token of appreciation :)

👍 paulag

properties (23)vote details (1)

@ammonite · Aug 1 '17

$0.45

Great info as always Paula. Im glad to see that the Whales for the most part are quite honorable. I do have one question. In the section where you discuss popular voting times are you basing this on UTC or GMT?

👍 good-karma, adept, feruz, esteemapp, elgeko, bounties, steempoll, macrophotography, demo, tipping, mysteem, mondeja, sellergenius, sdibot, mindfreak

properties (23)vote details (15)

@paulag · Aug 1 '17

I need to find out what time zone the server is at and I will come back to you on that one......

👍 macrophotography

properties (23)vote details (1)

@wolo · Aug 2 '17 (edited)

$1.28

@ammonite @paulag Pretty sure it is PST.

----
I really loved your analysis - hope you do more in the future.

👍 randowhale, randowhalebonus, thesloth, wolo, randowhaletrail

properties (23)vote details (5)

1 reply

@davidthelad · Aug 3 '17

o yeah please did you find the time zone, I appreciate this your post quite a lot, really helpful, something  different from all the shitposts I've been seeing.

properties (22)

1 reply

@patelincho · Aug 1 '17 (edited)

Intresting but i think you have to aply this to the people on dayli trending hot page . The picture will be much diferent i bet :)

properties (22)

@paulag · Aug 1 '17

The picture sure would be much different.  Give me a few days and I will have something to share with you.  thank you for the comment xx

properties (22)

@donniedeluxe · Aug 1 '17

Hi paula, what's the purple section in the first graph? seems it has no tag

properties (22)

@benchi · Aug 1 '17

Great article! is that 5:00 AM eastern time?

properties (22)

@paulag · Aug 4 '17

UTC time

properties (22)

@stortebeker · Aug 1 '17

Hey @paulag, I really liked your article. So much so, that I included it in my weekly collection of those I want to share with others: https://steemit.com/curating/@stortebeker/look-what-i-found-great-posts-worth-checking-out

properties (22)

@paulag · Aug 1 '17

thanks

properties (22)

@steemreports · Aug 1 '17

$0.05

Thanks for another very useful report!

👍 andybets

properties (23)vote details (1)

@rina.tours.world · Aug 1 '17

Upvoted and following! As a new steemian i was experimenting with tags and this information was very helpful! I was also experimenting with days/ times to post to see how my posts can gain more exposure.

properties (22)

@ackhoo · Aug 2 '17

Great information - many thanks, @paulag !  As my posts are mostly in 'photography' (my chief interest here) - it's interesting to know the whales don't really focus on that (at a low 0.51%), but the rest do (top at 8.75%)!  So, I can add 'life' (5.6%) or 'steemit' (5.4%) to my tag list!  

Also of interest is that I have only seen two whales on my posts before (no wonder I'm slipping through cracks... lol) There's a whole lot of ocean of whales out there who don't see me... sighhh!  But I'm not the kind to go knock on their doors now; I'm more the kind to let Life's experiment take place - see if I get the others' attention naturally...  Upvoting and resteeming!

properties (22)

@steemreports · Aug 2 '17

Hi @paulag, I've noticed there might be a couple of problems with your analysis.

You seem to have used totals over 15 days rather than 14, which means you didn't use the same number of each weekday. I think if you correct this, you'll find it makes quite a difference to your weekday graphs.

It probably affects two days, Saturday and Sunday because you started at 21:00 rather than on a day boundary.

Our provisional graph for votes over days (last 4 weeks) looks like this, which is surprisingly different from yours:
http://www.steemreports.com/vote-days/?mode=stacked

Our times distribution matches pretty well though (again 4 weeks):
http://www.steemreports.com/vote-times/

properties (22)

@themerrylotus · Aug 2 '17

Thank you so much for this information. But, something tells me that you loved every minute of this research. It shows in your post, your zeal for numbers and order.

properties (22)

@paulag · Aug 2 '17

lol I am a bit of a geek

properties (22)

@marcelli · Aug 2 '17

Great post @paula!  I am sure you are helping a lot of people with it, including myself! Cheers

properties (22)

@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

properties (23)vote details (1)

@paulag · Aug 4 '17

yes it is UTC

properties (22)

@farmstead · Aug 3 '17

Really interesting analytics here! I really appreciate the pie-type charts. I got really excited to see that some whales like to vote for Permaculture things! Thanks for sharing!

properties (22)

@paulag · Aug 3 '17

you are most welcome

properties (22)

@stellabelle · Aug 3 '17

upvoted and resteemed. This is really fascinating information. I look forward to more data. Thank you.

properties (22)

@fuchsia.ink · Aug 3 '17

Honestly, this is the first post that I actually wanted to upvote. Great job.

properties (22)

@gokulnk · Aug 3 '17

Great info and good pithy charts. Once observation I had however is that most of the upvotes of goodkarma come from the auto voting of the posts made from esteem app. I don't have any issue with it as it promotes people to use steemit and it is going in the right direction. I just wish they had a desktop app thats all.

👍 gokulnk

properties (23)vote details (1)

@samstickkz · Aug 3 '17

Great information, wow @good-karma over 2000 votes?

properties (22)

@igster · Aug 3 '17

Great work! Always glad to see more data!

properties (22)

@paulag · Aug 3 '17

always happy to work with data

properties (22)

@cryptomam · Aug 3 '17

Great insights @paulag. Thanks and keep up the great work, would love to read more on this in the future.

👍 rockinmama

properties (23)vote details (1)

@paulag · Aug 3 '17

thanks...there is more to come

properties (22)

@theblindsquirl · Aug 3 '17

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?

properties (22)

@paulag · Aug 3 '17

no it does not take into consideration sp delegated.....now that one I must look at....watch this space!

properties (22)

@theblindsquirl · Aug 3 '17

I've got my eyes on you, so to speak. ;-)

properties (22)

@freebornsociety · Aug 3 '17

Thank you, I have been looking for this data for a while,....

properties (22)

@paulag · Aug 3 '17

$0.04

you are most welcome

👍 freebornsociety

properties (23)vote details (1)

@mtgmisfit · Aug 3 '17

That's some serious data analysis! Thanks for putting in the work needed to debunk the "self-voting and friend-voting whales are killing Steemit" rumors.  It's really interesting to see the differences in content categories between whale upvotes and the entire population's voting habits.

properties (22)

@paulag · Aug 3 '17

yes it is nice to see the rumors are not exactly true, however I am doing another analysis at the moment on posts from the trending page that might raise some eyebrows

👍 mtgmisfit

properties (23)vote details (1)

@phibetaiota · Aug 3 '17

Very valuable!  Resharing@phibetaiota
Thank you for the contribution.
![Imgur](http://i.imgur.com/kUqvy1q.png)

properties (22)

@paulag · Aug 3 '17

$0.02

thank you

👍 phibetaiota

properties (23)vote details (1)

@darkerhorse · Aug 3 '17 (edited)

this is some insight  for some needed foresight, how much steem are we talking about ?

properties (22)

@paulag · Aug 3 '17

if you have power bi to use the file, I will take donations....for a copy of the report

properties (22)

@jessamynorchard · Aug 3 '17

This post was featured in Cool Stuff Curation! Thank you for being awesome!
<center>https://steemitimages.com/0x0/https://steemitimages.com/DQmUU1Mt8xoGV3sBKeW1SfUjENa3uGDgrofUxbiAU9suxbz/IMG_1458.JPG</center>
## <center>[Read it here.](https://steemit.com/curation/@jessamynorchard/cool-stuff-curation-cool-steemit-blog-enhancements-and-resources-new-steemian-spotlight)</center>

properties (22)

@paulag · Aug 3 '17

awesome thanks

properties (22)

@sylviategan · Aug 3 '17

This is really interesting! Thanks for putting this together!!

properties (22)

@anomadsoul · Aug 3 '17 (edited)

This is amazing, I used to do a similar analysis on sales every day for almost a year. I get your point of view perfectly, perhaps you could share it with me?? Steem can get me a copy you say? hahahaha

What world time is it? UTC?

Also your post are too useful for not following you, so I corrected that :)

properties (22)

@imloo · Aug 3 '17

follow me !!!<3

👍 imloo

properties (23)vote details (1)

@paulag · Aug 3 '17

did you really say 'follow me' and then vote for your own post???????

properties (22)

@bescouted · Aug 3 '17

You justify your description perfectly. Interesting numbers. Thank you for crunching them down :)

properties (22)

@nabilamk · Aug 3 '17

@paulag thats a hell lot of statsitics....great job!!!

properties (22)

@rerycore · Aug 3 '17

Very good information .., i am new player in steemit .., before i have never heard of whales .., after reading your post, i better understand how to work steemit .., thanks @paulag informations .. my @rerycore like Your post .. I wait for your next post

👍 rerycore

properties (23)vote details (1)

@kubbyelizabeth · Aug 3 '17

Wow, that was a lot of data and you presented it very well. The best piece of information is the tags with the most votes. Helps me rethink how I tag. Thanks for the info

properties (22)

@happyme · Aug 3 '17

When comparing votes for self versus votes for others, is there a way to also see the VP used on those votes?  To know that someone voted 10% of the NUMBER of votes on themselves is very different than knowing that out of 100 votes, 9 were at full power (on themselves) and 91 were at 1% for others. The 2 sets of data paint very opposing pictures, don't they?

properties (22)

@jaki01 · Aug 4 '17

$3.18

Great job - interesting data. :)

👍 davidorcamuriel

properties (23)vote details (1)

@jayjayjeffery · Aug 4 '17

Super awesome you have the knowledge and skills to do something like this. I wouldn't know where to start! And seeing women who know how to do it is even cooler (:
Just curious what time zone are you stating these times in?

properties (22)

@briandenver · Aug 4 '17

I'm in Denver Colorado, the south side of town near Park Meadows Mall. Do you know of any trusted people I could purchase bitcoin from in cash?  I probably only want about $40 worth for now. Still new to the crypto currency game.

properties (22)

@jayjayjeffery · Aug 4 '17

Check out localbitcoins.com they are probably the best place to look. It's pretty hard to find someone who will sell you bitcoin in cash these days (most don't want to sell). And there is also a BitcoinATM somewhere down in Denver. I know there's one in Boulder.

properties (22)

1 reply

@kerlund74 · Aug 4 '17

Interesting analysis and also of great value! I learning some new things each day and I have begun to understand the importance of votes from the whales:-) Thanks a lot!

properties (22)

@paulag · Aug 4 '17

whale votes are very important, not just from a payment point of view but it also seems to have an impact on reputation

properties (22)

@kerlund74 · Aug 4 '17

I have begun to understand that. I'm glad that there are so many people here providing great help and information for me as a newbie:) Thank you!

properties (22)

@hypexals-spiral · Aug 4 '17

Awesome data analysis and interpretation.

Get ahead of them whales!

properties (22)

@technoshout · Aug 5 '17

great information thanks!!!!!!

👍 technoshout

properties (23)vote details (1)

@blessedman939 · Aug 6 '17

I love everything about the post. Reaearch at its finest.

properties (22)

@diabolika · Aug 6 '17 (edited)

@paulag, great analysis

>This is a really awesome dashboard that gives me real actionable insights….If you want a copy, well we can swap. I will give you a copy for Steem?????

How much? 

I used to do data anaysis through excel and sql queries but that was my life in the past. I quit my corporate job to travel and now I'm more into travel blogging and creative writing.

But the data, excel and analysis are still part of me, though I'm not updated anymore. So I would like to have a copy of that dashboard. I'm more into analyzing the data about the travel tag and its trending page (that's my niche). 

I am following you for more data analysis as I might feature you on my future post.

properties (22)

@paulag · Aug 7 '17

Would love to be featured in one of your posts.

Let me see if I can put a dashboard together for you in the next few days focusing on travel....remove all the other noise

properties (22)

@diabolika · Aug 8 '17

Thanks, if you can do that then I will surely feature as soon as you have the data. :)

properties (22)

@rainz1 · Aug 7 '17

Really nice analysis, gives us minnows a lot of information for when to post or what to expect about whales ;)

properties (22)

@paulag · Aug 7 '17

stay tuned for the update

properties (22)

@eternalsunshine · Aug 17 '17

Good synthesis of info. Thanks. 
> Whereas overall the most popular time is 5pm

It is good to know that most votes in Steemit are done at 5pm, but you didn't specify the time zone ? 
You have a worldwide audience with internet now you know.. ;)

properties (22)

@thirdmanh3 · Aug 24 '17

That's how you trim the mass just show them what they desire wealth and royalty as every single person on this planet wish to be rich and financially secured same as today with Bitcoin a punch of numbers too complicated to understand makes you rich I guess we're not the smartest generation ever lived!! @thirdmanh3

properties (22)

@tonygreene113 · Aug 27 '17

awesome work and way to crunch the numbers on the big timers here on steemit. voted and resteemed..

properties (22)

@amade · Aug 29 '17

I have been looking forward for this type of material. Wow you deserve a thumb hand. Awesome, good job, keep it up.

properties (22)

`post_id`	8,852,968
`author`	greyman
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170731t232054882z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-07-31 23:20:54
`last_update`	2017-07-31 23:20:54
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-07 23:20:54
`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`	204
`author_reputation`	27,896,874,942
`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

`post_id`	8,857,747
`author`	krnel
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t004911299z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 00:49:12
`last_update`	2017-08-01 00:49:12
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-08 00:49:12
`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`	37
`author_reputation`	954,992,586,021,436
`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

`post_id`	8,864,751
`author`	randowhale
`permlink`	re-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t024844
`category`	steemit
`json_metadata`	"{"format": "markdown", "app": "randowhale/0.1"}"
`created`	2017-08-01 02:48:45
`last_update`	2017-08-01 02:48:45
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-08 02:48: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`	212
`author_reputation`	47,497,053,264,845
`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

`post_id`	8,864,781
`author`	dwhntx
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t024916545z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 02:49:18
`last_update`	2017-08-01 02:49:18
`depth`	1
`children`	2
`net_rshares`	0
`last_payout`	2017-08-08 02:49:18
`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`	65
`author_reputation`	1,145,219,907,707
`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

`post_id`	8,935,291
`author`	paulag
`permlink`	re-dwhntx-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t185726200z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 18:57:27
`last_update`	2017-08-01 18:57:27
`depth`	2
`children`	1
`net_rshares`	0
`last_payout`	2017-08-08 18:57:27
`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`	15
`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

`post_id`	8,935,867
`author`	dwhntx
`permlink`	re-paulag-re-dwhntx-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t190537833z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 19:05:39
`last_update`	2017-08-01 19:05:39
`depth`	3
`children`	0
`net_rshares`	0
`last_payout`	2017-08-08 19:05:39
`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`	1,145,219,907,707
`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

`post_id`	8,882,853
`author`	pijushmitra
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t080446502z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 08:04:45
`last_update`	2017-08-01 08:04:45
`depth`	1
`children`	2
`net_rshares`	0
`last_payout`	2017-08-08 08:04: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`	84
`author_reputation`	18,150,512,355,968
`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

`post_id`	8,886,017
`author`	paulag
`permlink`	re-pijushmitra-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t090045145z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 09:00:45
`last_update`	2017-08-01 09:00:45
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-08 09:00: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`	3
`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

`post_id`	8,902,815
`author`	paulag
`permlink`	re-pijushmitra-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t125617892z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 12:56:18
`last_update`	2017-08-01 12:56:18
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-08 12:56:18
`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`	3
`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

`post_id`	8,882,908
`author`	joeyrocketfilms
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t080543291z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 08:05:45
`last_update`	2017-08-01 08:05:45
`depth`	1
`children`	2
`net_rshares`	7,375,895,252
`last_payout`	2017-08-08 08:05:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.022 SBD
`curator_payout_value`	0.006 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	206
`author_reputation`	3,285,993,247,600
`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`	""

`post_id`	8,886,211
`author`	paulag
`permlink`	re-joeyrocketfilms-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t090355775z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 09:03:54
`last_update`	2017-08-01 09:03:54
`depth`	2
`children`	1
`net_rshares`	0
`last_payout`	2017-08-08 09:03:54
`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`	56
`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

`post_id`	9,153,596
`author`	joeyrocketfilms
`permlink`	re-paulag-re-joeyrocketfilms-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170804t020808929z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-04 02:08:09
`last_update`	2017-08-04 02:08:09
`depth`	3
`children`	0
`net_rshares`	5,953,270,905
`last_payout`	2017-08-11 02:08:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.016 SBD
`curator_payout_value`	0.005 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	52
`author_reputation`	3,285,993,247,600
`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`	""

voter	rshares	pct
good-karma	101,239,561,440	0.5%
mondeja	153,807,552	0.5%
mysteem	168,214,767	1%
mindfreak	0	0%
demo	324,518,049	1%
feruz	3,041,685,420	1%
adept	5,193,149,587	0.5%
esteemapp	2,930,966,190	1%
sellergenius	99,937,763	0.5%
elgeko	1,716,362,151	0.25%
bounties	344,941,873	1%
steempoll	334,835,401	1%
tipping	304,300,182	1%
macrophotography	332,408,141	100%
sdibot	60,403,311	0.25%

`post_id`	8,902,785
`author`	paulag
`permlink`	re-ammonite-re-paulag-201781t95628193z-20170801t125554081z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 12:55:54
`last_update`	2017-08-01 12:55:54
`depth`	2
`children`	4
`net_rshares`	338,563,847
`last_payout`	2017-08-08 12:55:54
`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`	96
`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
`author_curate_reward`	""

`post_id`	9,022,364
`author`	wolo
`permlink`	re-paulag-re-ammonite-re-paulag-201781t95628193z-20170802t163343829z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["ammonite", "paulag"], "tags": ["steemit"]}"
`created`	2017-08-02 16:33:45
`last_update`	2017-08-02 16:34:09
`depth`	3
`children`	1
`net_rshares`	315,390,000,581
`last_payout`	2017-08-09 16:33:45
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.963 SBD
`curator_payout_value`	0.314 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	109
`author_reputation`	857,695,898,590
`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`	""

voter	rshares	pct
randowhale	266,729,747,284	2.1%
randowhalebonus	41,648,666,094	1%
thesloth	4,232,217,769	1%
randowhaletrail	619,122,534	1%
wolo	2,160,246,900	100%

`post_id`	9,113,702
`author`	davidthelad
`permlink`	re-paulag-re-ammonite-re-paulag-201781t95628193z-20170803t160703445z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-03 16:07:12
`last_update`	2017-08-03 16:07:12
`depth`	3
`children`	1
`net_rshares`	0
`last_payout`	2017-08-10 16:07:12
`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`	160
`author_reputation`	3,043,219,887,107
`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

`post_id`	8,897,150
`author`	patelincho
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t113413999z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 11:45:48
`last_update`	2017-08-01 11:46:12
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2017-08-08 11:45:48
`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`	130
`author_reputation`	52,885,100,418,823
`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

`post_id`	8,902,723
`author`	paulag
`permlink`	re-patelincho-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t125509679z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 12:55:09
`last_update`	2017-08-01 12:55:09
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-08 12:55: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`	136
`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

`post_id`	8,916,651
`author`	donniedeluxe
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t153317195z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 15:33:21
`last_update`	2017-08-01 15:33:21
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-08 15:33:21
`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`	75
`author_reputation`	515,492,347,108
`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

`post_id`	8,920,341
`author`	benchi
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t161323752z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 16:13:27
`last_update`	2017-08-01 16:13:27
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2017-08-08 16:13:27
`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`	44
`author_reputation`	343,206,540,447
`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

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

`post_id`	8,933,946
`author`	stortebeker
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t183844331z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["paulag"], "links": ["https://steemit.com/curating/@stortebeker/look-what-i-found-great-posts-worth-checking-out"], "tags": ["steemit"]}"
`created`	2017-08-01 18:38:45
`last_update`	2017-08-01 18:38:45
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2017-08-08 18:38: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`	225
`author_reputation`	76,442,227,425,259
`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

`post_id`	8,935,183
`author`	paulag
`permlink`	re-stortebeker-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t185553940z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 18:55:54
`last_update`	2017-08-01 18:55:54
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-08 18:55:54
`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`	6
`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

`post_id`	8,945,130
`author`	steemreports
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170801t211831439z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-01 21:18:30
`last_update`	2017-08-01 21:18:30
`depth`	1
`children`	0
`net_rshares`	12,852,398,545
`last_payout`	2017-08-08 21:18:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.050 SBD
`curator_payout_value`	0.000 SBD
`pending_payout_value`	0.000 SBD
`promoted`	0.000 SBD
`body_length`	38
`author_reputation`	26,984,297,179,214
`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`	""

`post_id`	8,990,327
`author`	ackhoo
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170802t093417646z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["paulag"], "tags": ["steemit"]}"
`created`	2017-08-02 09:34:21
`last_update`	2017-08-02 09:34:21
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-09 09:34:21
`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`	671
`author_reputation`	83,389,450,322,515
`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

`post_id`	8,990,390
`author`	steemreports
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170802t093538210z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["paulag"], "links": ["http://www.steemreports.com/vote-days/?mode=stacked", "http://www.steemreports.com/vote-times/"], "tags": ["steemit"]}"
`created`	2017-08-02 09:35:39
`last_update`	2017-08-02 09:35:39
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-09 09:35:39
`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`	682
`author_reputation`	26,984,297,179,214
`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

`post_id`	9,013,565
`author`	themerrylotus
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170802t145347747z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-02 14:53:51
`last_update`	2017-08-02 14:53:51
`depth`	1
`children`	1
`net_rshares`	0
`last_payout`	2017-08-09 14:53:51
`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`	165
`author_reputation`	2,740,171,706,809
`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

`post_id`	9,015,506
`author`	paulag
`permlink`	re-themerrylotus-re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170802t151342684z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "tags": ["steemit"]}"
`created`	2017-08-02 15:13:42
`last_update`	2017-08-02 15:13:42
`depth`	2
`children`	0
`net_rshares`	0
`last_payout`	2017-08-09 15:13:42
`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`	24
`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

`post_id`	9,015,628
`author`	marcelli
`permlink`	re-paulag-voting-habits-of-the-top-200-whales-steemitsql-analysis-20170802t151454356z
`category`	steemit
`json_metadata`	"{"app": "steemit/0.1", "users": ["paula"], "tags": ["steemit"]}"
`created`	2017-08-02 15:14:57
`last_update`	2017-08-02 15:14:57
`depth`	1
`children`	0
`net_rshares`	0
`last_payout`	2017-08-09 15:14:57
`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`	95
`author_reputation`	3,098,211,852,986
`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