9 - 14 MARCH 2018 SLOTHICORN UPVOTE ANALYSIS

Slothicorn is a community to support Dedicated, Talented, and Driven Artists.

Slothicorn wants to encourage and promote the creation of Crypto-Currency themed currency, and Creative Commons Art, but Slothicorn is no longer exclusive to that category.

Slothicorn has received funds through the @stellabelle delegate.

The purpose of this analysis is to monitor the weekly activity of @slothicorn in terms of voting. It's also to analyze posts made to the slothicorn category on Blockchain STEEM.

This analysis will be conducted on a weekly basis so that trends can form and growth is measured.

The Data

Using Lynqpad, I have connected to the SteemSQL database (paid subscription service and managed by @arcange). and my thanks to @paulag for giving me guidance and @ghulammujtaba who have supported me to write this analysis report. You can find the full query at the end of this post.

The Analysis

9 - 14 March 2018 @slothicorn Votes Analysis

---

The above visualizations show a vote for @slothicorn on 9 - 14 March, 2018.

On the second week of March 2018 @slothicorn voted 127 times for 127 Authors. The average voting is SBD $ 4,15 . The payment provided by the slothicorn is SBD $ 527,67 We can also see from above that the average voting weight used by @slothicorn is 0.53% and the amount the average vote given per day is 21.

Account that received the highest number of upvotes from @slothicorn

---

no	author	Post	average wieght	vote value (SBD)
1	irwanumpal	www.steemit.com/@irwanumpal/3-8-march-2018-slothicorn-analysis	100%	8,88
2	khansa	www.steemit.com/@khansa/the-cryptocurrency-coloring-alphabet-part-iii-h-i-j-and-k-artwork-by-khansa	100%	8,81
3	grandenchilada	www.steemit.com/@grandenchilada/cryptokitties-collect-cryptoart	100%	8,70
4	alexandravart	www.steemit.com/@alexandravart/my-contribution-in-global-collage-swim-in-steem-p	100%	8,61
5	abs-pointilisim	www.steemit.com/@abs-pointilisim/my-drawing-tools-my-art-tools-and-i-made-some-art	100%	8,58
6	playitforward	www.steemit.com/@playitforward/5qozqy-global-collage-a-steemit-arts-community-collage-powered-by-steem-with-slothicorn	100%	8,57
7	stellabelle	www.steemit.com/@stellabelle/eos-art-slay-the-demons	100%	8,53
8	irwanumpal	www.steemit.com/@irwanumpal/top-30-writer-listings-in-slothicorn-based-on-pending-payout-value	100%	8,53
9	justatouchfey	www.steemit.com/@justatouchfey/global-collage-unfortunately-i-cannot-swim	100%	8,38
10	bym	www.steemit.com/@bym/slothicorn-3d-slothicorn-bee-movie	100%	8,35
11	adelepazani	www.steemit.com/@adelepazani/i-want-to-introduce-myself-to-slothicorn-community	100%	8,30
12	wanaf	www.steemit.com/@wanaf/dancing-slothicorn-thriller-version	100%	8,26
13	juliakponsford	www.steemit.com/@juliakponsford/eos-gems-original-eos-art-that-s-creative-commons-and-free-to-use	100%	8,16
14	adelepazani	www.steemit.com/@adelepazani/my-new-illustration-circles-collection-pan-on-paper-with-steps	100%	8,12
15	alexandravart	www.steemit.com/@alexandravart/steemit-and-dada-crypto-art	100%	8,03
16	ishanvirtue	www.steemit.com/@ishanvirtue/my-contribution-for-global-collage-crypto-withdrawl-of-my-leprechaun	100%	7,87
17	khansa	www.steemit.com/@khansa/meditation-for-eos-energy-cryptoart	100%	7,78
18	elohprojects	www.steemit.com/@elohprojects/10-unbelievable-artists-you-ve-never-heard-of-part-6	100%	7,66
19	pbock	www.steemit.com/@pbock/the-slothicorn-bust-brought-to-you-by-the-myminifactory-wonderland-community	100%	7,61
20	bym	www.steemit.com/@bym/slothicorn-3d-3ds-max-cup-modeling	100%	7,51
21	alexandravart	www.steemit.com/@alexandravart/epic-dada	100%	7,38
22	rocksg	www.steemit.com/@rocksg/fractal-arts-designed-for-creative-commons-license-4-0	100%	7,37
23	alexandravart	www.steemit.com/@alexandravart/word-from-minnow-crypto-artist-to-crypto-whales-cryptoart-and-cryptofashion	100%	7,19
24	adelepazani	www.steemit.com/@adelepazani/original-watercolor-painting-steem-girl-with-steps	100%	7,19
25	wearecodex	www.steemit.com/@wearecodex/the-minnow-avatar-generator-for-steemians-is-ready	100%	7,11
26	drawingly	www.steemit.com/@drawingly/more-art-kidney-news	100%	6,97
27	ccommons.art	www.steemit.com/@ccommons.art/wall-of-fame-nr-14	80%	6,55
28	flaviorizzo	www.steemit.com/@flaviorizzo/how-crypto-s-home-could-be-ethereum-eng-ita	100%	6,48
29	matytan	www.steemit.com/@matytan/steemi-steemme-we-are-swellow-starring-at-steemit-garden-d	80%	6,29
30	evalina	www.steemit.com/@evalina/hey-slothicornians-i-m-evalina-here-to-introduce-myself	15%	6,29
31	tonie	www.steemit.com/@tonie/my-introductory-post-in-slothicorn	80%	6,20
32	inquiringtimes	www.steemit.com/@inquiringtimes/crypto-needs-art-artists-need-crypto	73%	6,02
33	inquiringtimes	www.steemit.com/@inquiringtimes/the-birth-of-crypto-art-meet-rare-pepe	73%	5,94
34	bennettitalia	www.steemit.com/@bennettitalia/dear-slothicorn-an-introduction-to-some-of-the-work-i-ve-posted-to-steemit-so-far-and-to-me-as-a-creative-also-why-i-think-your	70%	5,87
35	alexandravart	www.steemit.com/@alexandravart/cryptoart-submitted-for-sxsw-decentralized-art-show-austin	76%	5,81
36	fabiyamada	www.steemit.com/@fabiyamada/steem-003-blockchain-crypto-art	80%	5,80
37	mrblinddraw	www.steemit.com/@mrblinddraw/one-of-my-first-instagram-commissions	80%	5,70
38	mimulusamsterdam	www.steemit.com/@mimulusamsterdam/international-women-s-day	70%	5,61
39	aalagenesis	www.steemit.com/@aalagenesis/my-first-leonid-afremov-style-painting	80%	5,59
40	gristleneck	www.steemit.com/@gristleneckgoldilocks-zone	70%	5,57
41	zpzn	www.steemit.com/@zpzn/my-paintings-4	70%	5,50
42	bym	www.steemit.com/@bym/slothicorn-3d-slothicorn-cube-version-cube-world	70%	5,47
43	grandenchilada	www.steemit.com/@grandenchilada/dada-and-the-art-of-tech	70%	5,47
44	wanaf	www.steemit.com/@wanaf/eos-the-meditating-man	80%	5,32
45	trishy	www.steemit.com/@trishy/we-miss-you-lee-min-ho-digital-art-with-step-by-step-procedures	70%	5,32
46	donnadavisart	www.steemit.com/@donnadavisart/my-cafe-drawing-inspired-by-my-witch-free-write	70%	5,20
47	journeyu	www.steemit.com/@journeyu/my-15-daily-draw-don-t-lose-color	65%	5,20
48	debart	www.steemit.com/@debart/my-dali-inspired-artwork-for-ethereum-lights	69%	5,04
49	adelepazani	www.steemit.com/@adelepazani/my-new-drawing-of-a-deer	63%	4,90
50	shortcut	www.steemit.com/@shortcut/new-blockchain-based-art-collaboration-website	59%	4,72
51	gametokenstech	www.steemit.com/@gametokenstech/march-6th-misc-crypto-game-news-new-cryptopets-art-decentraland-updates-new-book-of-orbs-web-app-and-more	50%	4,33
52	trishy	www.steemit.com/@trishy/a-simple-vector-digital-art-with-step-by-step-procedures	60%	4,33
53	kalemandra	www.steemit.com/@kalemandra/kalemandra-s-souldoodle-mandalas-honeycomb-variations	49%	4,30
54	adelepazani	www.steemit.com/@adelepazani/colourpencil-mood-original-illustration	49%	4,16
55	aboutart	www.steemit.com/@aboutart/my-favorite-animes-from-the-90-s-step-by-step-process	50%	4,05
56	grandenchilada	www.steemit.com/@grandenchilada/welcome-to-dada-steemit	50%	3,99
57	benitez	www.steemit.com/@benitez/art-explosion-week-30-time	50%	3,69
58	jepoyasinas	www.steemit.com/@jepoyasinas/3d-artwork-pokemons	40%	3,56
59	bryanlornemez	www.steemit.com/@bryanlornemez/my-bob-marley-painting-and-my-favorite-quotes-and-songs-of-him	40%	3,53
60	mimulusamsterdam	www.steemit.com/@mimulusamsterdam/sneak-peak-taste-of-what-s-to-come	40%	3,41
61	federacion45	www.steemit.com/@federacion45/cryptoart-creativecommons-24	46%	3,38
62	mimulusamsterdam	www.steemit.com/@mimulusamsterdam/today-s-drawing-mega-monster-and-mother	40%	3,37
63	matytan	www.steemit.com/@matytan/happy-women-s-day	40%	3,37
64	pollocyber	www.steemit.com/@pollocyber/knowing-the-community-and-introducing-myself-to-slothicorn-by-pollocyber	40%	3,35
65	debart	www.steemit.com/@debart/in-the-eye-of-crypto-the-artwork	40%	3,24
66	aalagenesis	www.steemit.com/@aalagenesis/a-man-in-a-dream-a-digital-illustration	40%	3,18
67	shopia421	www.steemit.com/@shopia421/hello-dear-i-m-here-to-introduce-myself-on-steemit-and-slothicorn-community-steem-on	40%	3,10
68	pbock	www.steemit.com/@pbock/making-the-steemmakers-cube	40%	3,06
69	debart	www.steemit.com/@debart/neo-glow-an-artwork-that-tells-a-crypto-story	40%	3,05
70	mandelsage	www.steemit.com/@mandelsage/my-slothicorn-introduction-my-history-with-art	40%	3,00
71	zpzn	www.steemit.com/@zpzn/painting	40%	3,00
72	ivanusaur	www.steemit.com/@ivanusaur/7mujwf-i-made-a-pokemon-in-honor-of-slothicorn	40%	2,98
73	gristleneck	www.steemit.com/@gristleneck/pablo-picasso-probably-hates-this-painting	41%	2,91
74	elvizakiyah	www.steemit.com/@elvizakiyah/my-art-4-lady-sloth-on-the-greatness-of-reds	38%	2,82
75	matytan	www.steemit.com/@matytan/dada-second-day-d	32%	2,79
76	ccommons.art	www.steemit.com/@ccommons.art/wall-of-fame-nr-13	40%	2,75
77	justatouchfey	www.steemit.com/@justatouchfey/a-little-moon-mixed-media-collage-work	38%	2,73
78	mfestra	www.steemit.com/@mfestra/welcome-to-cryptoland-my-new-world-is-borning-bienvenidos-a-mi-nuevo-mundo-cryptolandia-spa-en	40%	2,71
79	debart	www.steemit.com/@debart/qr-whale-art-just-this-powerful-animal-in-the-sky-crypto-art	40%	2,71
80	aalagenesis	www.steemit.com/@aalagenesis/international-women-s-day-appreciation-post	40%	2,65
81	flatearth101	www.steemit.com/@flatearth101/the-cryptocurrency-coloring-alphabet-slothicorn-project-f-ia-for-fomo	33%	2,64
82	greatestbastard	www.steemit.com/@greatestbastard/introducing-myself-to-slothicorn	30%	2,60
83	fabiyamada	www.steemit.com/@fabiyamada/steem-logo-03-trust-crypto-art	30%	2,56
84	inksanity	www.steemit.com/@inksanity/shooting-star-inksanity-helen-bird-art	30%	2,55
85	inksanity	www.steemit.com/@inksanity	30%	2,55
86	benitez	www.steemit.com/@benitez/drawing-28-or-spamming	30%	2,51
87	netya	www.steemit.com/@netya/flower-woman	30%	2,50
88	flatearth101	www.steemit.com/@flatearth101/the-cryptocurrency-coloring-alphabet-slothicorn-project-g-for-genesis-block	30%	2,50
89	cinderz	www.steemit.com/@cinderz/my-third-traditional-drawing	30%	2,46
90	animery	www.steemit.com/@animery/i-introduce-myself-to-you-slothicorn	30%	2,46
91	matytan	www.steemit.com/@matytan/3rd-day-in-dada-3	30%	2,42
92	daltono	www.steemit.com/@daltono/warning-this-gif-by-daltono-is-aweo	30%	2,41
93	inksanity	www.steemit.com/@inksanity/coronal-mass-ejection-inksanity-helen-bird-art	30%	2,32
94	inksanity	www.steemit.com/@inksanity/grounded-inksanity-helen-bird-art	30%	2,28
95	aboutart	www.steemit.com/@aboutart/artwork-harmony	30%	2,24
96	inksanity	www.steemit.com/@inksanity/sagittarius-a-inksanity-helen-bird-art	30%	2,18
97	knightofzero	www.steemit.com/@knightofzero/my-sketch-1	30%	2,14
98	mfestra	www.steemit.com/@mfestra/art-contest-9-i-love-the-80-s	25%	2,09
99	novalbarosa	www.steemit.com/@novalbarosa/admire-eos	26%	2,07
100	mrblinddraw	www.steemit.com/@mrblinddraw/portrait-of-pashieey-s-selfie-by-mrblinddraw	27%	1,97
101	adelepazani	www.steemit.com/@adelepazani/original-drawing-by-pencil-good-start-for-breaking-unnecessary-thoughts	27%	1,95
102	edpico	www.steemit.com/@edpico/can-i-be-a-slothicornian-please-my-introduction	25%	1,87
103	desireemolina14	www.steemit.com/@desireemolina14/i-introduce-myself-to-you-slothicorn-me-presento-a-slothicorn	25%	1,87
104	daltono	www.steemit.com/@daltono/flower-shower-gif-by--daltono-1520581941-485892	25%	1,87
105	oscargabat	www.steemit.com/@oscargabat/my-artwork-international-women-s-day	20%	1,83
106	jepoyasinas	www.steemit.com/@jepoyasinas/art-junkrat-of-overwatch	20%	1,79
107	ghulammujtaba	www.steemit.com/@ghulammujtaba/nihnbp8a	29%	1,75
108	paskadom	www.steemit.com/@paskadom/daily-drawing-japan-comic-e3891e5800ba3	20%	1,73
109	phantum04	www.steemit.com/@phantum04/slothicorn-doodle	20%	1,71
110	marxause	www.steemit.com/@marxause/daily-steem-cartoon-42-steemit-movement-9ecb5bb712979	20%	1,69
111	nikema	www.steemit.com/@nikema/hello-slothicorn-my-introduction	20%	1,64
112	inksanity	www.steemit.com/@inksanity/bowling-in-space-inksanity-helen-bird-art	20%	1,50
113	ariyanaa	www.steemit.com/@ariyanaa/hello-dear-slothicorn-today-i-have-submitted-my-pencil-sketch-01-love-bird-couple	20%	1,46
114	inksanity	www.steemit.com/@inksanity/the-key-to-life-inksanity-helen-bird-art	20%	1,46
115	bryanlornemez	www.steemit.com/@bryanlornemez/drawing-of-myself-my-brother-my-cousin-and-my-two-friends	15%	1,37
116	anonimous	www.steemit.com/@anonimous/drawitbetter-contest-17-drawing-of-the-amazing-world-of-gumball-with-progress-steps	15%	1,32
117	andrewjohntamban	www.steemit.com/@andrewjohntamban/plant-for-a-future-a-project-for-slothicorn	15%	1,25
118	marxause	www.steemit.com/@marxause/daily-steem-cartoon-41-naiklah-naik-dd6fe8cb45c21	15%	1,24
119	zpzn	www.steemit.com/@zpzn/my-paintings-3	15%	1,14
120	daltono	www.steemit.com/@daltono/rising-reflections-gif-by--daltono-1520409433-812897	14%	1,02
121	daltono	www.steemit.com/@daltono/sipping-in-hyperspace-gif-by-daltono	13%	0,97
122	adelepazani	www.steemit.com/@adelepazani/drawing-by-pen-on-paper-original-illustration-circles-collection	13%	0,93
123	slothicorn	www.steemit.com/@slothicorn/2a5a24c0-258c-11e8-a005-7320c34677de	11%	0,91
124	rudikhairi	www.steemit.com/@rudikhairi/the-first-painting-was-destroyed	10%	0,90
125	rayne122	www.steemit.com/@rayne122/my-arts-another-sketch-of-mine-the-clown-joker	10%	0,87
126	jepoyasinas	www.steemit.com/@jepoyasinas/art-portrait-using-colored-pencil	5%	0,37
127	bryanlornemez	www.steemit.com/@bryanlornemez/to-all-the-girls-that-i-do-in-lab-before	30%	0,00

Conclusion

Slothicorn is an amazing project, receiving 1492 posts in the second week of March and casting votes for them. This means that almost 1 in 11 posts created will be selected by . @slothicorn averages 21 times a day in the first week of March.

100% of payments in this category are from @slothicorn. This is rather high and coupled with a lower than average pay as compared to the total writing on blockchain steemit. slothicorn needs to reduce post dependence on sounds from @slothicorn and also increase the average post payments.

Welcome to @slothicorn - I wish you success in this project. I will prepare this report every week to track the progress of the project.

Do you have any questions or questions about the above data? If so, please leave a comment below.

The SQL Queries

The SQL query used to collect data for votes made by @slothicorn was:

 SELECT *
 FROM Txvotes (NOLOCK)
 WHERE [voter] in ('slothicorn')
  AND CONVERT (DATE, timestamp) BETWEEN '2018-03-09' AND '2018-03-014'

The query used to collect data for posts made to the category / tag slothicorn on steemit was:

 SELECT
 author,
  json_metadata,
 permlink,
 total_payout_value,
  pending_payout_value,
  net_votes,
 created,
children,
Category,
Depth
  FROM comments (NOLOCK)
  where CONVERT (DATE, created) BETWEEN '2018-03-09' AND '2018-03-14'
  and json_metadata like ('% "slothicorn"%')

The Current vote worth for slothicorn has been taken from https://steemworld.org/@slothicorn at 15th March 2018 .

I am part of a Blockchain Business Intelligence community. We all post under the tag #BlockchainBI. If you have an analysis you would like carried out on Steemit or Blockchain data, please do contact me or any of the#BlockchainBI team and we will do our best to help you...

You can find #BlockchainBI on discord https://discordapp.com/invite/JN7Yv7j

My Best REGARD @irwanumpal