Getting to know the Hive community ... by eroche

View this thread on: hive.blog | peakd.com | ecency.com

hivesql · @eroche · May 28 '21

$48.31

Getting to know the Hive community ...

Wordclouds make Presentations look good, but they dont have much use. Their analytic capability is quite limited. 

This week for the update for Hive Analytics is to add a wordcloud tab for the selected user. 

(Fairly) Instantly browser a users Posting History

@lordbutterfly was top of the trending page just now and I am not familiar with this user so I took a quick look.


![Screenshot from 2021-05-28 22-11-42.png](https://images.hive.blog/DQmRkYvco22hhZxJ8qpEukDGUY2wt4V6BnxbcQbFTQsgnwV/Screenshot%20from%202021-05-28%2022-11-42.png)


Try it out!
https://eroche.shinyapps.io/hiveanalytics/

👍 ocdb, acidyo, ocd, edicted, forykw, demotruk, deathwing, slobberchops, howo, smartsteem, ausbitbank, therealwolf, eroche, ctime, cadawg, richardcrill, deepresearch, steempress, ninnu, betterdev, sn0n, inb4, alphacore, nateaguila, roelandp, louisthomas, eonwarped, hykss.leo, toofasteddie, steemexperience, sbi3, giftgiver, smartmarket, bluerobo, evernoticethat, bdmillergallery, tombstone, hextech, walterjay, stefano.massari, tcpaikano, fiveboringgames, smartvote, oneshot, eastmael, mister-meeseeks, dandays, hivetrending, blue-witness, detlev, photographercr, bananass, hivelist, devann, sanderjansenart, pladozero, nftmart, olumzy, miroslavrc, jlsplatts, hiveonboard, blokz, steemitboard, rishi556, and 108 others

`author`	eroche
`permlink`	getting-to-know-the-hive-community
`category`	hivesql
`json_metadata`	{"tags":["hivesql","blockchain","hive","stats"],"users":["lordbutterfly"],"image":["https://images.hive.blog/DQmRkYvco22hhZxJ8qpEukDGUY2wt4V6BnxbcQbFTQsgnwV/Screenshot%20from%202021-05-28%2022-11-42.png"],"links":["https://eroche.shinyapps.io/hiveanalytics/"],"app":"hiveblog/0.1","format":"markdown"}
`created`	2021-05-28 21:15:00
`last_update`	2021-05-28 21:15:00
`depth`	0
`children`	19
`last_payout`	2021-06-04 21:15:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	24.427 HBD
`curator_payout_value`	23.886 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	598
`author_reputation`	70,759,290,299,941
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,993,258
`net_rshares`	64,187,209,709,514
`author_curate_reward`	""

properties (23)vote details (172)

voter	rshares	pct
tombstone	52,069,659,362	2.4%
acidyo	9,624,898,504,271	100%
mammasitta	10,761,600,113	2%
roelandp	199,097,902,649	5%
ausbitbank	595,594,497,954	50%
demotruk	1,134,874,564,347	100%
fiveboringgames	48,983,104,285	20%
originate	1,098,729,537	17%
steempress	238,150,683,329	20%
richardcrill	300,078,285,041	50%
floweroflife	1,844,283,040	100%
rishi556	12,548,420,168	100%
keuudeip	7,817,723,204	16%
eroche	368,947,880,708	100%
steemfestdreams	2,261,250,996	100%
yadamaniart	6,958,387,922	10%
walterjay	51,339,769,432	6%
seablue	9,220,182,979	100%
rahul.stan	842,352,243	50%
steemitboard	12,867,485,892	3%
sn0n	212,340,016,275	80%
oneshot	45,656,591,876	100%
ganjafarmer	4,235,911,713	5%
louisthomas	187,314,970,557	100%
freebornsociety	2,129,142,224	10%
detlev	32,928,649,457	2%
dickturpin	3,184,375,049	10%
thatsweeneyguy	2,631,987,885	8%
ma1neevent	3,642,874,122	15%
kingkinslow	598,265,593	10%
forykw	2,148,317,396,486	100%
roomservice	4,254,572,835	6%
rt395	1,379,261,043	3%
alphacore	202,926,278,901	20.2%
guchtere	1,437,734,022	8%
toofasteddie	141,258,439,601	29%
dante31	9,349,053,667	10%
howo	645,157,226,569	20%
tokyowomanslife	1,014,056,239	100%
ocd	3,500,932,234,520	20%
macchiata	5,354,520,412	8%
watersnake101	11,263,945,489	50%
kharrazi	273,701,234	20%
redrica	7,698,300,808	8.8%
genesisojeda	732,174,212	10%
evernoticethat	71,398,046,199	100%
floatinglin	4,484,163,843	100%
eastmael	43,825,511,928	100%
blokz	14,571,221,530	50%
therealwolf	403,319,493,697	8%
deathwing	1,122,639,069,957	100%
critic-on	776,120,709	10%
jlsplatts	18,637,038,933	2%
hanggggbeeee	1,635,446,185	10%
dandays	36,826,032,160	4.4%
ashleykalila	1,304,440,288	10%
eonwarped	178,081,433,921	6%
mejustandrew	6,579,936,121	10%
tcpaikano	50,291,983,581	50%
smartsteem	620,939,818,781	8%
elderson	1,323,840,620	2.5%
tomatom	1,666,690,233	10%
r00sj3	753,012,381	10%
iwanderela	1,007,755,365	50%
deepresearch	285,007,579,882	32%
juecoree	4,751,273,452	10%
gabrielatravels	8,965,416,836	4%
smartmarket	78,098,531,004	33.33%
edicted	3,024,220,136,628	50%
ricardo993	1,898,333,569	12%
edprivat	1,197,169,597	2%
warpedpoetic	4,470,190,321	8%
cadawg	323,700,350,704	90%
ajaxalot	4,053,812,097	5%
andimywapblog12	433,827,584	10%
miroslavrc	19,736,363,372	10%
greendo	936,458,428	20%
sanderjansenart	28,590,265,952	20%
obsesija	3,854,147,731	8%
steemexperience	141,189,437,696	50%
getron	784,148,865	10%
oscurity	2,008,242,764	5%
indigoocean	4,184,460,634	10%
sbi3	115,354,223,806	4.64%
slobberchops	1,011,335,074,324	20%
pladozero	27,731,872,475	10%
nateaguila	201,681,262,021	5%
bdmillergallery	69,570,151,781	6%
inb4	209,139,488,457	33.33%
worldwildflora	1,292,639,652	50%
volkiceper	732,292,787	10%
dzoji	4,296,148,089	20%
experienced	1,678,542,152	100%
olumzy	22,392,759,682	6%
ocdb	34,411,869,131,892	16%
marivic10	521,190,734	1.5%
smartvote	48,259,454,989	2.29%
mobi72	4,745,965,618	10%
ummar	3,366,411,771	10%
javyeslava.photo	3,183,734,844	8%
mister-meeseeks	39,883,478,492	50%
athunderstruck	2,476,638,225	10%
stefano.massari	50,532,985,701	47%
devann	29,928,869,987	10%
variedades	2,268,791,726	6.4%
bluerobo	74,541,555,047	100%
suzana72	8,325,887,632	10%
ctime	330,210,902,650	2.5%
steemtelly	6,292,314,139	24.53%
rem-steem	11,644,274,462	10%
abbenay	663,565,393	25%
giftgiver	101,236,124,316	100%
thelogicaldude	12,371,952,261	10%
denizcakmak	1,120,380,559	100%
photographercr	32,323,763,087	20%
squareonefarms	2,226,688,531	10%
epicdice	2,535,788,926	2.4%
yiobri	3,202,675,846	10%
beerlover	2,520,355,639	2%
tinyhousecryptos	515,456,839	5%
iktisat	783,100,480	100%
tomlee	1,408,734,734	10%
athomewithcraig	2,367,383,206	10%
soyunasantacruz	1,787,704,724	10%
sbi-tokens	1,036,313,342	0.94%
bilpcoinbot	1,239,437,446	50%
zeesh	3,357,106,347	10%
efathenub	8,908,930,103	50%
bilpcoinbpc	515,338,817	5%
mengene	1,047,394,206	10%
hive-180164	4,373,338,987	10%
zeusflatsak	1,272,102,529	5%
dpend.active	4,226,949,168	4%
monica-ene	7,070,936,876	5%
fengchao	7,760,584,109	2%
blue-witness	34,850,445,380	100%
hivetrending	36,503,242,418	25%
maitt87	2,858,847,785	10%
gradeon	1,907,462,046	10%
the100	4,527,270,764	20%
hextech	51,558,360,354	100%
hiveonboard	16,770,029,046	6%
hivelist	30,117,078,642	10%
ninnu	232,913,933,397	50%
iameden	986,656,403	10%
fakegod	654,497,291	100%
ghaazi	3,957,646,879	100%
catinthewindow	383,602,593	3.82%
daniky	2,958,834,490	4%
jsalvage	1,422,108,714	10%
mafia.wallet	5,249,720,236	100%
anafae	1,342,151,103	2%
issymarie2	1,820,027,117	10%
nftmart	27,337,683,124	100%
sevenoh-fiveoh	633,512,782	5%
hrcl.art	974,602,699	8%
zoeanavid	709,090,228	10%
dwixer	2,897,801,110	10%
borniet	657,121,621	10%
mecurry	783,085,528	100%
paolazun	971,441,419	10%
kattycrochet	3,347,833,966	8%
betterdev	223,523,119,531	100%
dcrops	11,496,922,111	8%
hykss.leo	166,765,020,098	100%
bananass	31,665,531,444	32.5%
livegaming	302,125,199	100%
thecouncil	2,255,250,819	100%
drricksanchez	1,608,215,906	10%
leveluplifestyle	3,319,192,985	10%
maykk	545,249,946	10%
partiesjohall	3,098,692,925	20%

@antisocialist · May 29 '21 (edited)

It wouldn't let me input a username.
I use brave, if that matters.


![image.png](https://files.peakd.com/file/peakd-hive/antisocialist/EoH58PY827heZ9DzNrH3HgsFmjsHujX5nF3BJ1hJE4s81Z8pi34VdS11h8AjqXXMudn.png)

properties (22)

`author`	antisocialist
`permlink`	re-eroche-qtukop
`category`	hivesql
`json_metadata`	{"tags":["hivesql"],"app":"peakd/2021.05.4"}
`created`	2021-05-29 02:38:48
`last_update`	2021-05-29 02:40:00
`depth`	1
`children`	2
`last_payout`	2021-06-05 02:38:48
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	209
`author_reputation`	222,813,726,274,436
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,997,251
`net_rshares`	0

@rishi556 · May 29 '21

$0.04

You have to type it in in the selected user post history page. Felt weird.

👍 antisocialist

`author`	rishi556
`permlink`	re-antisocialist-qtupbq
`category`	hivesql
`json_metadata`	{"tags":["hivesql"],"app":"peakd/2021.05.4"}
`created`	2021-05-29 04:19:03
`last_update`	2021-05-29 04:19:03
`depth`	2
`children`	1
`last_payout`	2021-06-05 04:19:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.021 HBD
`curator_payout_value`	0.021 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	74
`author_reputation`	111,982,053,527,065
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,998,388
`net_rshares`	106,343,602,592
`author_curate_reward`	""

properties (23)vote details (1)

voter	weight	wgt%	rshares	pct	time
antisocialist	0 B		106,343,602,592	20%

@antisocialist · May 29 '21

Yep, that did it, thanks.

properties (22)

`author`	antisocialist
`permlink`	re-rishi556-qtuqml
`category`	hivesql
`json_metadata`	{"tags":["hivesql"],"app":"peakd/2021.05.4"}
`created`	2021-05-29 04:47:09
`last_update`	2021-05-29 04:47:09
`depth`	3
`children`	0
`last_payout`	2021-06-05 04:47:09
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	25
`author_reputation`	222,813,726,274,436
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,998,705
`net_rshares`	0

@demotruk · May 28 '21

A fair few of these I wasn't expecting

![image.png](https://images.hive.blog/DQmYUyZPKRo2B8iytb4LS6Kx8okrr2rHC4aAphPciBTtD2g/image.png)

properties (22)

`author`	demotruk
`permlink`	qtu5td
`category`	hivesql
`json_metadata`	{"image":["https://images.hive.blog/DQmYUyZPKRo2B8iytb4LS6Kx8okrr2rHC4aAphPciBTtD2g/image.png"],"app":"hiveblog/0.1"}
`created`	2021-05-28 21:17:39
`last_update`	2021-05-28 21:17:39
`depth`	1
`children`	5
`last_payout`	2021-06-04 21:17:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	136
`author_reputation`	268,391,561,444,220
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,993,292
`net_rshares`	0

@eroche · May 28 '21

Any ones in particular. I was digging through your posts and it seems to be matching up. Dbuzz doesnt use tags but other than that it looks good on a post by post basis. Which words dont seem right and I might be able to find the issue.

properties (22)

`author`	eroche
`permlink`	qtu6bh
`category`	hivesql
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2021-05-28 21:28:30
`last_update`	2021-05-28 21:28:30
`depth`	2
`children`	4
`last_payout`	2021-06-04 21:28:30
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	236
`author_reputation`	70,759,290,299,941
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,993,475
`net_rshares`	0

@demotruk · May 29 '21

No, I just mean I haven't used many of them in a long time and thus they weren't what I was expecting to come up since I'd forgotten.

properties (22)

`author`	demotruk
`permlink`	qtuvhs
`category`	hivesql
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2021-05-29 06:32:18
`last_update`	2021-05-29 06:32:18
`depth`	3
`children`	0
`last_payout`	2021-06-05 06:32:18
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	133
`author_reputation`	268,391,561,444,220
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,999,863
`net_rshares`	0

@forykw · May 28 '21

How far on the history this goes? From genesis?

properties (22)

`author`	forykw
`permlink`	re-eroche-2021529t103558732z
`category`	hivesql
`json_metadata`	{"tags":["ecency"],"app":"ecency/3.0.18-mobile","format":"markdown+html"}
`created`	2021-05-28 22:36:00
`last_update`	2021-05-28 22:36:00
`depth`	3
`children`	2
`last_payout`	2021-06-04 22:36:00
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	47
`author_reputation`	71,305,228,064,328
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,994,403
`net_rshares`	0

2 replies

@forykw · May 28 '21

Interesting 🤔... will give it a try soonTM

properties (22)

`author`	forykw
`permlink`	re-eroche-2021529t103437229z
`category`	hivesql
`json_metadata`	{"tags":["hivesql","blockchain","hive","stats"],"app":"ecency/3.0.18-mobile","format":"markdown+html"}
`created`	2021-05-28 22:34:39
`last_update`	2021-05-28 22:34:39
`depth`	1
`children`	5
`last_payout`	2021-06-04 22:34:39
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	42
`author_reputation`	71,305,228,064,328
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,994,389
`net_rshares`	0

@forykw · May 28 '21

$0.18

Typical of what @forkyishere is LOL
![image.png](https://files.peakd.com/file/peakd-hive/forykw/23x1Ytr3Gy92xjbQZrvrpJDkgNUMH11nyyGKZDnEi4AAMYxsuy1V3eTuhgJjdif3vsVcg.png)

👍 eroche, stefano.massari, rishi556

`author`	forykw
`permlink`	re-forykw-qtuasp
`category`	hivesql
`json_metadata`	{"tags":["hivesql"],"app":"peakd/2021.05.4"}
`created`	2021-05-28 23:05:15
`last_update`	2021-05-28 23:05:15
`depth`	2
`children`	4
`last_payout`	2021-06-04 23:05:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.090 HBD
`curator_payout_value`	0.089 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	171
`author_reputation`	71,305,228,064,328
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,994,848
`net_rshares`	425,813,246,345
`author_curate_reward`	""

properties (23)vote details (3)

voter	rshares	pct
rishi556	12,804,718,434	100%
eroche	368,275,022,771	100%
stefano.massari	44,733,505,140	42%

@eroche · May 28 '21

ha ha. Its the only good use I have found for wordclouds

properties (22)

`author`	eroche
`permlink`	qtubs9
`category`	hivesql
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2021-05-28 23:26:33
`last_update`	2021-05-28 23:26:33
`depth`	3
`children`	0
`last_payout`	2021-06-04 23:26:33
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	56
`author_reputation`	70,759,290,299,941
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,995,192
`net_rshares`	0

@rishi556 · May 29 '21

Steem still overpowers for me.

properties (22)

`author`	rishi556
`permlink`	re-forykw-qtupc1
`category`	hivesql
`json_metadata`	{"tags":["hivesql"],"app":"peakd/2021.05.4"}
`created`	2021-05-29 04:19:15
`last_update`	2021-05-29 04:19:15
`depth`	3
`children`	2
`last_payout`	2021-06-05 04:19:15
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	30
`author_reputation`	111,982,053,527,065
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,998,390
`net_rshares`	0

2 replies

@rishi556 · May 29 '21

Only thing I found weird was that I could only change users on one page, would be nice to do it on all.

properties (22)

`author`	rishi556
`permlink`	re-eroche-qtupde
`category`	hivesql
`json_metadata`	{"tags":["hivesql"],"app":"peakd/2021.05.4"}
`created`	2021-05-29 04:20:03
`last_update`	2021-05-29 04:20:03
`depth`	1
`children`	0
`last_payout`	2021-06-05 04:20:03
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	103
`author_reputation`	111,982,053,527,065
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,998,398
`net_rshares`	0

@rishi556 · May 29 '21 (edited)

Think I might have crashed it 😅

Edit: Seems to crash when I try do do it on accounts that post a lot like @acidyo

properties (22)

`author`	rishi556
`permlink`	re-eroche-qtupgf
`category`	hivesql
`json_metadata`	{"tags":["hivesql"],"app":"peakd/2021.05.4"}
`created`	2021-05-29 04:21:51
`last_update`	2021-05-29 04:48:09
`depth`	1
`children`	2
`last_payout`	2021-06-05 04:21:51
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	114
`author_reputation`	111,982,053,527,065
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	103,998,410
`net_rshares`	0

@eroche · May 29 '21

For accounts with lots of posts it takes a while,  but it should get there.  This will put a load on the hivesql db but i can make a fix that samples large accounts rather than getting the full history.  This will be a much better approach

properties (22)

`author`	eroche
`permlink`	qtv05m
`category`	hivesql
`json_metadata`	{"app":"hiveblog/0.1"}
`created`	2021-05-29 08:12:57
`last_update`	2021-05-29 08:12:57
`depth`	2
`children`	1
`last_payout`	2021-06-05 08:12:57
`cashout_time`	1969-12-31 23:59:59
`total_payout_value`	0.000 HBD
`curator_payout_value`	0.000 HBD
`pending_payout_value`	0.000 HBD
`promoted`	0.000 HBD
`body_length`	239
`author_reputation`	70,759,290,299,941
`root_title`	"Getting to know the Hive community ..."
`beneficiaries`	`[]`
`max_accepted_payout`	1,000,000.000 HBD
`percent_hbd`	10,000
`post_id`	104,001,133
`net_rshares`	0

@rishi556 · May 29 '21

Probably. Cool tool regardless, especially since it works on me haha.

properties (22)