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
The purpose of this analysis is to monitor the weekly activity of
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
The Analysis
9 - 14 March 2018
The above visualizations show a vote for
On the second week of March 2018
Account that received the highest number of upvotes from
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 .
100% of payments in this category are from
Welcome to
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
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
@irwanumpal