In this post I will show what are the most popular URL's, Websites and Social Profiles on Steemit by analyzing the Steem blockchain with Python. I have made the code open source here https://github.com/codewithcheese/steem-mentions. I wanted to include the data but after processing every URL on the blockchain it comes to 2GB, which is too large for GitHub. Look at the methodology section below for how to generate the data on your own machines.
Why is this useful?
When Smart Media Tokens were announced I thought "Who will be the early adopters? What publishers might adopt SMT's?". To start answering that question I wanted to see what websites and social profiles Steemian's interacted with. By looking at the top URL's, websites and social media profiles we can gain some insight into the Steem communities reach on the Internet.
Utopian + Steem is awesome for open source
I am writing this as a Contributor Report on Utopian.io. Utopian is an amazing project by fellow Steemian @elear. A Steem platform site that focuses on rewarding open source contribution. Check out @elear's post to see how Steem + Open Source using Utopian.io has the power to change the world for good. @elear/utopian-the-begin-of-a-new-shared-meritocratic-economy
Results
I am going to jump right into the results for those of you not interested in the technical details. If you want to know how I did it you can scroll down to the The methodology section below.
The results are in 3 sections. URL's results for individual URLs, Websites result for mentioned Domains and Social Media results for Twitter, Facebook and of course Steemit.
URL's
Top 50 mentioned URL by number of authors
Here are the top 50 URL's mentioned in posts ordered by the number of individual authors. As you can see nearly every URL is Steem or Crypto related. I was surprised by this, I thought we would see a little more variety. This may be explained by the early days of Steem attracting mostly Crypto interested authors. Share your thoughts in the comments.
| url | num_authors |
|---|---|
| coinmarketcap.com/ | 543 |
| steemit.com/~witnesses | 438 |
| www.steemit.com/~witnesses | 373 |
| steemit.com | 346 |
| pixabay.com | 256 |
| pixabay.com/ | 256 |
| steem.io/SteemWhitePaper.pdf | 255 |
| bittrex.com/ | 247 |
| vimeo.com | 244 |
| steemit.com/images/steemit-share.png | 224 |
| steemit.com/ | 220 |
| coinmarketcap.com | 216 |
| poloniex.com/ | 196 |
| steemitimages.com/DQma5mbjPtLaw2HYWdyUogvU1KH6CbUR9peeoWdB35PCBhk/steemit-share.png | 196 |
| steemitimages.com/DQmRhDtjokAZnGKi4QwheqksKTFo6m4fsjMYsNNrsitC1xk/DQmRhDtjokAZnGKi4QwheqksKTFo6m4fsjMYsNNrsitC1xk.gif | 183 |
| steemd.com/ | 179 |
| coinmarketcap.com/ | 174 |
| coinmarketcap.com/currencies/steem/ | 173 |
| steemit.chat | 173 |
| www.myetherwallet.com/ | 171 |
| i.imgur.com/YSt1Mis.gif | 168 |
| steemtools.com/ | 166 |
| twitter.com/bobbyclee/status/865851769116475392 | 158 |
| blocktrades.us/ | 156 |
| poloniex.com | 149 |
| bittrex.com | 145 |
| www.exodus.io/ | 144 |
| steemd.com | 137 |
| www.bitcoincash.org/ | 133 |
| eos.io/ | 132 |
| www.genesis-mining.com | 132 |
| bitcoin.org/bitcoin.pdf | 128 |
| www.genesis-mining.com/ | 128 |
| discord.gg/HYj4yvw | 119 |
| www.ethereum.org/ | 118 |
| steem.io/ | 116 |
| www.steemnow.com/ | 115 |
| steemit.chat/home | 114 |
| steemvoter.com/ | 114 |
| steemit.chat/ | 112 |
| streemian.com/ | 112 |
| steemnow.com/ | 109 |
| steemd.com/distribution | 109 |
| dtube.video/ | 108 |
| steemd.com/witnesses | 107 |
| golem.network/ | 106 |
| www.coinbase.com/ | 105 |
| sia.tech/ | 103 |
| steemstats.com | 103 |
| www.bitfinex.com/ | 102 |
Top 50 with highest average vote
Here are the top 50 URL's with the highest average vote mentioned by at least 10 authors. This is my attempt to find some of the URL's that might not be the most popular but that Steemit users like the most.
| url | avg_votes |
|---|---|
| discord.gg/S37bYma | 901.145455 |
| www.steemvoter.com | 768.897887 |
| www.peerhub.com/ | 682.867521 |
| steemit.com/witness/@teamsteem/what-are-steem-witnesses-and-why-you-should-support-them | 658.971429 |
| steemit.com/buildteam/@buildteam/launching-the-buildteam-token | 630.166667 |
| steemit.com/witness-category/@reggaemuffin/witness-reggaemuffin | 543.111111 |
| steemit.com/minnowbooster/@minnowbooster/introducing-minnowbooster-beta | 532.238095 |
| steemit.com/almost-famous/@teamsteem/hello-steemit-coinmaketcap-com-introduced-me | 523.034483 |
| steemit.chat/channel/curie | 516.731034 |
| steemit.com/steemit/@donkeypong/announcing-project-curie-bringing-rewards-and-recognition-to-steemit-s-undiscovered-and-emerging-authors | 502.166667 |
| markdownpad.com/ | 499.853659 |
| www.minnowbooster.net/delegate | 491.642857 |
| steemit.com/promoting-steem/@teamsteem/creating-the-world-we-long-for | 489.310345 |
| steemit.com/contest/@papa-pepper/bonus-round-of-the-wild-and-strange-contest-250-steem-payout-an-attempt-to-boost-moral-and-increase-community-fun-and | 459.416667 |
| www.minnowbooster.net/market | 424.880000 |
| steemit.com/steemit/@the-alien/announcement-jumpstarting-new-tags-rewarding-comments-boosting-engagement-and-going-viral | 398.882353 |
| steemd.com/@minnowbooster | 378.571429 |
| steemit.com/translation/@papa-pepper/operation-translation-now-under-construction-what-it-is-and-how-you-can-help | 377.394762 |
| steemit.com/minnowbooster/@minnowbooster/6rt2mn-introducing-minnowbooster-beta | 348.588235 |
| steemit.com/eos/@eosio/eos-io-technical-white-paper | 336.333333 |
| steemit.com/esteem/@good-karma/esteem-spotlight-top-users-and-giveaway-2-2017623t85513623z | 336.058824 |
| steemit.com/@thecryptofiend | 331.455621 |
| steemdb.com/witnesses | 325.403846 |
|
320.378378 |
| steemit.com/~witnesses | 320.137500 |
| esteem.ws | 308.361111 |
| www.mumble.com/mumble-download.php | 307.166667 |
| steemit.com/steem/@steemitblog/consensus-reached-for-hardfork-17-18-the-new-features-are-yours-on-thursday-march-30th-at-11am-est | 301.357143 |
| steemfest.com | 297.600000 |
| steemit.com/@ericvancewalton | 296.666667 |
| creativecommons.org/publicdomain/zero/1.0/deed.en | 272.393443 |
| steemit.com/steemfest/@stellabelle/win-a-trip-to-steemfest-submit-a-3-minute-video | 263.720000 |
| steemit.com/steemit/@donkeypong/announcing-steem-guild-a-second-stage-project-to-continue-supporting-good-authors-after-project-curie | 262.241176 |
| itunes.apple.com/WebObjects/MZStore.woa/wa/viewSoftware?id=1141397898&mt=8 | 260.970588 |
|
260.800000 |
| steemit.com/dpos/@dantheman/dpos-consensus-algorithm-this-missing-white-paper | 260.777778 |
| bitcoinwisdom.com/markets/bitfinex/btcusd | 257.769231 |
| steemit.com/steemprentice/@sykochica/steemprentice-steemit-mentoring-group-launch-announcement | 256.072464 |
|
255.111111 |
| steemit.com/steemit/@firepower/successful-2-india-steemit-accelerator-and-steem-cryptocurrency-meetup-2017-at-robert-bosch-india-hq | 251.631579 |
| steemvoter.com | 246.266234 |
| t.me/Peerplays | 243.250000 |
| steemit.com/steem/@steemitblog/important-notification | 242.750000 |
| ipfs.io | 240.266667 |
| steemit.com/steem/@dantheman/building-long-term-value-from-your-blog | 238.272727 |
| steemit.com/@furion | 236.222222 |
| creativecommons.org/licenses/by-sa/3.0 | 235.071429 |
| steemitimages.com/DQmRHxe6LLLr1qMi84PxNTB2AHuVk51csUmGTfDoevD7sPP/image.png | 234.545455 |
| www.steemithelp.net | 233.685358 |
| steemit.com/@steemship | 233.052632 |
Top 20 URL's by highest average payout
Here are the top 20 URL's mentioned in posts with the highest average payout by at least 10 different authors. This is attempt to find some of the most valued websites by the Steem community. However I think this list is skewed by some URL's that whales regularly include in their posts.
| url | total_payout |
|---|---|
| www.steemit.com/@steemdrive | 37585.703 |
| github.com/xeroc/piston | 47905.119 |
| www.bravenewcoin.com/steem | 23633.304 |
| www.blocktrades.us | 21939.083 |
| www.expanse.tech | 20865.044 |
|
19667.129 |
| anarchapulco.com | 25368.469 |
| steemit.com/books/@federicopistono/hi-steem-community-i-am-the-author-of-robots-will-steal-your-job-but-thats | 18287.280 |
| i.imgur.com/hX8LV01.png | 15688.495 |
| steemit.com/steemit/@teamsteem/a-bit-about-steemit | 13278.872 |
| steemit.com/steem/@jesta/building-a-high-availability-steemd-node-for-web-apis | 10862.894 |
| steemit.com/introduceyourself/@teamsteem/make-more-steem-verify-your-introduction-posts | 13178.835 |
| steemit.com/joy/@teamsteem/steem-the-most-enjoyable-governance-tool-ever-devised | 14184.357 |
| dollarvigilante.com | 14616.087 |
| beta.chainbb.com/chainbb/@jesta/chainbbcom-a-blockchain-forum-platform-for-steem | 9659.715 |
| steemit.com/money/@teamsteem/money-are-tokens-of-influence-with-the-purpose-of-facilitating-bliss | 9615.526 |
| www.amazon.com/Steemit-101-Discover-Social-Content-ebook/dp/B01HC47NLU | 40082.394 |
| i.imgur.com/do6Qt9I.png | 16052.166 |
| steemit.com/science/@timsaid/myth-or-fact-20-a-penny-dropped-off-the-empire-state-building-kills-you | 10215.198 |
| steemit.com/christmas/@timsaid/myth-or-fact-13-does-santa-claus-exist | 10215.198 |
Websites
OK, we just looked at individual URL's now lets look at domains. I will only include websites sorted by number of authors. Sorting websites by average vote or other metrics did not yield very different resuls since the results are dominated by the image sites and large websites that every one mentions. I think it would be interesting to remove the largest websites but Ill have to leave that for another day.
Top 50 websites by number of authors
Here are the top 50 websites by number of mentions by unique authors. As you can see image sites and popular social networks are commonly linked to.
| domain | num_authors |
|---|---|
| steemitimages.com | 68390 |
| youtube.com | 30941 |
| steemit.com | 20290 |
| youtu.be | 16894 |
| imgur.com | 9854 |
| facebook.com | 9818 |
| wikipedia.org | 8166 |
| esteem.ws | 7583 |
| twitter.com | 7297 |
| wordpress.com | 6612 |
| postimg.org | 6122 |
| pixabay.com | 6102 |
| blogspot.com | 6020 |
| google.com | 5963 |
| imgsafe.org | 5864 |
| fbcdn.net | 5064 |
| dtube.video | 4241 |
| ipfs.io | 4208 |
| wikimedia.org | 4190 |
| pinimg.com | 4161 |
| instagram.com | 3785 |
| github.com | 3597 |
| ytimg.com | 3534 |
| giphy.com | 3513 |
| medium.com | 3120 |
| goo.gl | 3070 |
| amazonaws.com | 3023 |
| twimg.com | 3013 |
| wp.com | 2836 |
| coindesk.com | 2794 |
| coinmarketcap.com | 2765 |
| reddit.com | 2733 |
| cointelegraph.com | 2556 |
| tumblr.com | 2521 |
| bitcointalk.org | 2362 |
| amazon.com | 2251 |
| steemimg.com | 2245 |
| soundcloud.com | 2229 |
| ipfsstore.it | 2096 |
| bitcoin.com | 1956 |
| vimeo.com | 1848 |
| tinypic.com | 1842 |
| googleusercontent.com | 1789 |
| staticflickr.com | 1738 |
| cloudfront.net | 1723 |
| bit.ly | 1708 |
| businessinsider.com | 1671 |
| theguardian.com | 1631 |
| dailymail.co.uk | 1605 |
| cryptocoinsnews.com | 1549 |
Most mentioned statuses by unique authors
Here we have the most mentioned twitter statuses by number of authors. Im suprised at how little overlap there is. This might require more preprocessing to match similar statuses. Bobby Lee's Twitter competition to list STEEEM on BTCC saw huge support.
| url | num_authors |
|---|---|
| twitter.com/bobbyclee/status/865851769116475392 | 158 |
| twitter.com/bobbyclee/status/864155469899644928 | 60 |
| twitter.com/bobbyclee/status/862908660707540992 | 18 |
| twitter.com/realDonaldTrump/status/881503147168071680 | 16 |
| twitter.com/VitalikButerin/status/879127496024772610 | 11 |
| twitter.com/YourBTCC/status/908285586368167936 | 11 |
| twitter.com/IamNomad/status/908831764457672709 | 9 |
| twitter.com/officialmcafee/status/887012614131372032 | 9 |
| mobile.twitter.com/bobbyclee/status/865851769116475392 | 8 |
| twitter.com/agurevich23/status/907692985424371712 | 7 |
| twitter.com/bobbyclee/status/865851769116475392 | 6 |
| twitter.com/luluyilun/status/906163511658557440 | 6 |
| twitter.com/avsa/status/755144980008697857 | 6 |
| twitter.com/kyletorpey/status/890253492190945285 | 5 |
| twitter.com/officialmcafee/status/887024683379544065 | 5 |
| twitter.com/btcecom/status/889918430228492289 | 5 |
| twitter.com/wikileaks/status/829693251133272064 | 5 |
| twitter.com/naval/status/877467629308395521 | 5 |
| twitter.com/wikileaks/status/829324362943696896 | 5 |
| twitter.com/realdonaldtrump/status/881503147168071680 | 5 |
| twitter.com/maxkeiser/status/754110399666987009 | 5 |
| twitter.com/SatoshiLite/status/911328252928643072 | 5 |
| twitter.com/ArcadeCityHall/status/754784578489896960 | 5 |
| twitter.com/CNBCFastMoney/status/908089342605889536 | 5 |
| twitter.com/bobbyclee/status/865851769116475392 | 5 |
| twitter.com/hitbtc/status/872800553432219649 | 5 |
| twitter.com/SatoshiLite/status/873343321296429056 | 5 |
| twitter.com/JUN_Omise/status/902844287557148673 | 5 |
| twitter.com/JoshuaBaer/status/754036505203453952 | 4 |
| twitter.com/pbartstephens/status/907727923536265216 | 4 |
| twitter.com/huobicom/status/868442008402014208 | 4 |
| twitter.com/VitalikButerin/status/879127496024772610/photo/1 | 4 |
| twitter.com/hitbtc/status/903223626887032832 | 4 |
| twitter.com/ViaBTC/status/888813075368886272 | 4 |
| twitter.com/wikileaks/status/827828627488268290 | 4 |
| twitter.com/john_lam/status/888442492051259392 | 4 |
| twitter.com/inthepixels/status/888876843176271872 | 4 |
| twitter.com/CharlieShrem/status/890254097009565697 | 4 |
| twitter.com/SiaTechHQ/status/877172219679563778 | 4 |
| twitter.com/ArcadeCityHall/status/754059398335631361 | 4 |
| twitter.com/etherdelta/status/906027544696168449 | 4 |
| twitter.com/omise_go/status/897472052457684993 | 4 |
| twitter.com/maraoz/status/887755889897295872 | 4 |
| twitter.com/wikileaks/status/828889235994324992 | 4 |
| twitter.com/i/web/status/864155469899644928 | 4 |
| twitter.com/KimDotcom/status/865987139166552064 | 4 |
| twitter.com/bobbyclee/status/864155469899644928 | 4 |
| twitter.com/bobbyclee/status/865851769116475392 | 4 |
| twitter.com/JulianAssange/status/882430554544713728 | 3 |
| twitter.com/FloydMayweather/status/875104754334023680 | 3 |
Most mentioned Twitter accounts
Here we have the most mentioned twitter accounts order by number of unique authors. This is a great list to see who Steemians follow on twitter. However, it is domainated by those interested in Crypto. I would like to see this list narrowed for some other tags.
| url | num_authors |
|---|---|
| twitter.com/blocklancer | 35 |
| twitter.com/CCS_Crystal | 35 |
| twitter.com/cosscrypto | 30 |
| twitter.com/SatoshiLite | 23 |
| twitter.com/ | 22 |
| twitter.com/bitquence | 22 |
| twitter.com/aantonop | 21 |
| twitter.com/ToneVays | 20 |
| twitter.com/atlantio | 20 |
| twitter.com/ex_scudo | 20 |
| twitter.com/steemit | 20 |
| twitter.com/insurextech | 19 |
| twitter.com/UTRUST_Official | 19 |
| twitter.com/domraider | 18 |
| twitter.com/BitJob_Team | 17 |
| twitter.com/changefinance | 17 |
| twitter.com/iconominet | 16 |
| twitter.com/joinindorse | 16 |
| www.twitter.com/theswarmfund | 16 |
| www.twitter.com/Centra_Card | 15 |
| twitter.com/VitalikButerin | 15 |
| twitter.com/reality_clash | 15 |
| twitter.com/amandab_johnson | 15 |
| twitter.com/Nimfamoney | 15 |
| twitter.com/beone_co | 14 |
| twitter.com/Centra_Card | 14 |
| twitter.com/IMMLA_io | 14 |
| twitter.com/fundyourselfnow | 13 |
| twitter.com/rogerkver | 13 |
| twitter.com/GenesisMining | 13 |
| twitter.com/PowerLedger_io | 12 |
| twitter.com/wcxofficial | 12 |
| twitter.com/CarTaxi_24 | 12 |
| twitter.com/MadBitcoins | 12 |
| twitter.com/TaaSfund | 12 |
| twitter.com/sonmdevelopment | 12 |
| twitter.com/coindashio | 12 |
| twitter.com/on_place | 12 |
| twitter.com/easymineio | 12 |
| twitter.com/realDonaldTrump | 12 |
| twitter.com/KICKICOplatform | 12 |
| twitter.com/LunyrInc | 11 |
| twitter.com/minexcoin | 11 |
| twitter.com/OAX_Foundation | 11 |
| twitter.com/STeX_Exchange | 11 |
| twitter.com/bowheadhealth | 10 |
| twitter.com/rivetzcorp | 10 |
| twitter.com/bobbyclee | 10 |
| twitter.com/PolybiusBank | 10 |
| twitter.com/eos_io | 10 |
Steemit.com
Most mentioned URL's
Here are the top 50 most mentioned Steemit.com URL's ordered by number of unique authors
| url | num_authors |
|---|---|
| steemit.com/~witnesses | 438 |
| www.steemit.com/~witnesses | 373 |
| steemit.com | 346 |
| steemit.com/images/steemit-share.png | 224 |
| steemit.com/ | 220 |
| steemit.com/video/@heimindanger/introducing-dtube-a-decentralized-video-platform-using-steem-and-ipfs | 101 |
| steemit.com/images/steemit-share.png | 91 |
| steemit.com/faq.html | 88 |
| steemit.com | 86 |
| img1.steemit.com/0x0/i.imgsafe.org/b87bb98157.gif | 83 |
| steemit.com/@luzcypher | 79 |
| steemit.com/tags | 77 |
| steemit.com/welcome | 77 |
| steemit.com/market | 72 |
| steemit.com/colorchallenge/@kalemandra/new-colorchallenge-for-all-steemians | 63 |
| steemit.com/steem/@ned/announcing-smart-media-tokens-smts | 63 |
| steemit.com/@dollarvigilante | 56 |
| steemit.com/monomad/@brumest/monomad-photographic-contest-2nd-week-topic | 55 |
| steemit.com/@cervantes | 55 |
| www.steemit.com/~witnesses | 54 |
| steemit.com/trending/steemit | 54 |
| steemit.com/ | 51 |
| steemit.com/blog/@darthnava/fellow-steemers-i-need-help-as-my-mri-results-are-not-encouraging | 49 |
| steemit.com/steemfest/@roelandp/save-the-date-steemfest-2017-creamy-and-delicious-1-2-3-4-5-november-lisbon | 48 |
| steemit.com/monomad/@brumest/monomad-photographic-contest-week-6-topic-flowers | 47 |
| steemit.com/monomad/@brumest/monomad-photographic-contest-week-3-topic-silhouettes | 47 |
| steemit.com/monomad/@brumest/monomad-photographic-contest-week-8-topic-buildings | 46 |
| steemit.com/@jerrybanfield | 45 |
| steemit.com/steemit/@donkeypong/still-confused-by-steem-steem-dollars-and-steem-power-the-power-plant-analogy | 45 |
| steemit.com/trending/photography | 44 |
| steemit.com/bwphotocontest/@daveks/b-and-w-photo-contest-new-theme-announcement-plants | 44 |
| steemit.com/@minnowsupport | 44 |
| steemit.com/steemit-guides/@pfunk/a-full-steemit-user-s-guide-to-steem-witnesses | 44 |
| steemit.com/ | 44 |
| steemit.com/cn/@htliao/anime-character-drawing-challenge-or-50-sbd-prize-pool-or-50-sbd | 43 |
| steemit.com/minnowbooster/@minnowbooster/introducing-minnowbooster-beta | 43 |
| steemit.com/steem/@dan/steemit-s-evil-plan-for-cryptocurrency-world-domination | 42 |
| steemit.com/monomad/@brumest/monomad-photographic-contest-week-4-topic-abstract-please-read-the-rules | 42 |
| steemit.com/introduceyourself/@dantheman/daniel-larimer--co-founder-of-bitshares-steemit | 42 |
| steemit.com/memechallenge/@fibra59/meme-challenge-33-winners-of-32-doubled-reward-pool-for-33 | 41 |
| steemit.com/minnowsupportproject/@minnowsupport/minnow-support-project-problem-statement-vision-statement-mission-statement-and-plan-to-help-you-grow-from-minnow-to-whale-with | 41 |
| steemit.com/monomad/@brumest/monomad-photographic-contest | 41 |
| steemit.com/@ned | 40 |
| steemit.com/pick_account | 40 |
| steemit.com/spanish/@don.quijote/concurso-de-nanocuentos-don-quijote- | 40 |
| steemit.com/steemit/@noisy/we-just-hacked-11-accounts-on-steemit-1158-sbd-and-8250-steem-is-under-our-control-but-we-are-good-guys-so | 38 |
| steemit.com/created | 37 |
| steemit.com/beauty/@guerrint/the-first-steemit-makeup-turtorial-bringing-youtubers-to-steemit | 36 |
| steemit.com/bwphotocontest/@daveks/b-and-w-photo-contest-new-theme-announcement-food | 35 |
| steemit.com/trending/steem | 35 |
Most mentioned accounts
Here are the top 50 most mention Steemit.com accounts ordered by number of unique authors.
| url | num_authors |
|---|---|
| steemit.com/@luzcypher | 79 |
| steemit.com/@ned | 74 |
| steemit.com/@jerrybanfield | 67 |
| steemit.com/@papa-pepper | 60 |
| steemit.com/@dollarvigilante | 56 |
| steemit.com/@cervantes | 55 |
| steemit.com/@dan | 51 |
| steemit.com/@dantheman | 50 |
| steemit.com/@minnowsupport | 44 |
| steemit.com/@eosio | 30 |
| steemit.com/@randowhale | 28 |
| steemit.com/@stellabelle | 28 |
| steemit.com/@cheetah | 26 |
| steemit.com/@eeks | 25 |
| steemit.com/@officialfuzzy | 24 |
| steemit.com/@craig-grant | 23 |
| steemit.com/@good-karma | 23 |
| steemit.com/@steemitblog | 22 |
| steemit.com/@steemitmarket | 21 |
| steemit.com/@steemvoter | 20 |
| steemit.com/@trevonjb | 20 |
| steemit.com/@kalemandra | 20 |
| steemit.com/@jesta | 20 |
| steemit.com/@crypt0 | 20 |
| steemit.com/@roelandp | 20 |
| steemit.com/@steemsports | 19 |
| steemit.com/@sweetsssj | 19 |
| steemit.com/@blocktrades | 19 |
| steemit.com/@steemfest | 18 |
| steemit.com/@minnowbooster | 18 |
| steemit.com/@stellabelle | 18 |
| steemit.com/@donkeypong | 18 |
| steemit.com/@ausbitbank | 18 |
| steemit.com/@pfunk | 17 |
| steemit.com/@poloniex/transfers | 17 |
| steemit.com/@berniesanders | 16 |
| steemit.com/@curie | 16 |
| steemit.com/@fyrstikken | 16 |
| steemit.com/@booster | 16 |
| steemit.com/@jesta | 16 |
| steemit.com/@officialfuzzy | 15 |
| steemit.com/@heiditravels | 15 |
| steemit.com/@lukewearechange | 15 |
| steemit.com/@corbettreport | 15 |
Most mentioned Facebook URL's
Here we have the top 50 Facebook URL's order by number of unique authors
| url | num_authors |
|---|---|
| facebook.com/steemitmarket | 62 |
| www.facebook.com/ | 58 |
| www.facebook.com/CCSer/ | 33 |
| www.facebook.com/cosscrypto/ | 26 |
| www.facebook.com/blocklancer | 26 |
| www.facebook.com/groups/ICoLR/ | 19 |
| www.facebook.com/utrust.io/ | 18 |
| www.facebook.com/steemit/ | 17 |
| www.facebook.com/InsureX-1467549329975479 | 17 |
| www.facebook.com/rsrc.php/v3/y4/r/-PAXP-deijE.gif | 17 |
| www.facebook.com/Mandarin.exchange | 14 |
| www.facebook.com/beoneco/ | 14 |
| www.facebook.com/nimfamoney | 14 |
| www.facebook.com/exscudo | 13 |
| www.facebook.com/bitJobmarket/ | 13 |
| www.facebook.com/TrueFlip.io/ | 13 |
| www.facebook.com/fundyourselfnow/ | 13 |
| www.facebook.com/exscudo/ | 13 |
| www.facebook.com/CentraCard | 13 |
| www.facebook.com/groups/steemitnow/ | 12 |
| www.facebook.com/icoShowcase/ | 11 |
| www.facebook.com/bitquence/ | 11 |
| www.facebook.com/dentcoin | 11 |
| facebook.com/atlantplatform/ | 11 |
| www.facebook.com/kickicoplatform | 10 |
| www.facebook.com/bowheadhealth | 10 |
| www.facebook.com/taasfund | 10 |
| www.facebook.com/MinervaToken/ | 10 |
| www.facebook.com/groups/cryptocurrencycollectorsclub/ | 9 |
| www.facebook.com/PayPiePlatform | 9 |
| www.facebook.com/Anarchast/?f... | 9 |
| www.facebook.com/gilgames.platform | 9 |
| www.facebook.com/bitquence | 9 |
| www.facebook.com/Domraider-1432606216988548/ | 9 |
| www.facebook.com/groups/welovesteemit/ | 9 |
| www.facebook.com/Monaco-Card-1355426087883151/ | 8 |
| www.facebook.com/iconomi.net/ | 8 |
| facebook.com/LukeWeAreChange | 8 |
| www.facebook.com/iDiceIO/ | 8 |
| www.facebook.com/vibehubvr/ | 8 |
| www.facebook.com/relestio | 8 |
| www.facebook.com/minexcoin | 8 |
| www.facebook.com/crowdindicator | 8 |
| www.facebook.com/bitclave | 8 |
| m.facebook.com/MAGOS.io/ | 8 |
| www.facebook.com/coindash.io/ | 8 |
| www.facebook.com/immlaio/ | 7 |
Top 50 Facebook user names
Here we have the top 50 Facebook user names order by number of unique authors.
| url | num_authors |
|---|---|
| facebook.com/steemitmarket | 62 |
| www.facebook.com/blocklancer | 26 |
| www.facebook.com/InsureX-1467549329975479 | 17 |
| www.facebook.com/Mandarin.exchange | 14 |
| www.facebook.com/nimfamoney | 14 |
| www.facebook.com/exscudo | 13 |
| www.facebook.com/CentraCard | 13 |
| www.facebook.com/dentcoin | 11 |
| www.facebook.com/taasfund | 10 |
| www.facebook.com/bowheadhealth | 10 |
| www.facebook.com/kickicoplatform | 10 |
| www.facebook.com/gilgames.platform | 9 |
| www.facebook.com/PayPiePlatform | 9 |
| www.facebook.com/bitquence | 9 |
| www.facebook.com/bitclave | 8 |
| www.facebook.com/crowdindicator | 8 |
| www.facebook.com/minexcoin | 8 |
| facebook.com/LukeWeAreChange | 8 |
| www.facebook.com/relestio | 8 |
| www.facebook.com/lbryio | 7 |
| www.facebook.com/AlexanderEme... | 7 |
| www.facebook.com/powerledger | 7 |
| facebook.com/dentcoin | 7 |
| facebook.com/exscudo | 7 |
| www.facebook.com/Zappl-1564113593599270 | 7 |
| www.facebook.com/Rivetz-1409224065995167 | 6 |
| www.facebook.com/PawnHero.ph | 6 |
| www.facebook.com/RTnews | 6 |
| www.facebook.com/risevisionteam | 6 |
| www.facebook.com/steemit | 6 |
| www.facebook.com/iconomi.net | 6 |
| facebook.com/xfcfootballcoin | 6 |
| www.facebook.com/EgaasProject | 6 |
| www.facebook.com/joinindorse | 6 |
| www.facebook.com/orocrypt | 6 |
| www.facebook.com/vivacoin | 5 |
| www.facebook.com/profile.php?... | 5 |
| www.facebook.com/TED | 5 |
| www.facebook.com/steemitbc | 5 |
| facebook.com/RealityClash | 5 |
| www.facebook.com/Easymine.io | 5 |
| www.facebook.com/craig.freedom | 5 |
| facebook.com/TheTrendsCommunity | 5 |
| facebook.com/lewis.hilsenteger | 5 |
| work-12050764.facebook.com/ | 5 |
| facebook.com/dashingamandabjoh... | 5 |
| www.facebook.com/arkecosystem | 5 |
| www.facebook.com/propyinc | 5 |
| www.facebook.com/EventChain | 5 |
The methodology
One great thing about the Steem blockchain is all the data is easily and publicly available. However, there are many ways to access that data and some work better for me than others. My approach was to process blockchain and in order to create two CSV's one for URL's and one for authors. I then analyzed the CSV's using Jupyter Notebooks and Pandas.
The URL's CSV contains the URL from every post along values such as author, votes, payout. The authors CSV contains account data from every post author such as balances and reputation. This way I could join the URL's and Account data to be able to analyze URL's based on reputation.
Iterating blocks with Steem-Python
build_urls_from_steemd.py
My first attempt was to use the Steem python client https://github.com/steemit/steem-python and to iterate through every block. This turned out to be extremely slow. It appears you have to request one block at a time, even though there are methods that allow you to request a range of blocks they are simple requesting individual blocks behind the scenes. My connection here is 100Mb's so i'm not really sure why it was so slow. Can any one comment a faster way to iterate through the blocks?
Enter SteemData.com
build_urls_from_mondodb.py
After realizing that my method for iterating through the blocks was too slow. I thought about using SteemData.com by @furion. SteemData allows one to access blockchain data via MongoDB, MySQL and WebAPI. I noticed the MongoDB has a collection Posts which contains every post. Perfect. All I needed to do then was iterate through every post, extract the URL's using a simple regex and then create a CSV, one line for each URL along with relevant values from the post.
Author data
url_authors_from_mongodb.py
Once I had the URL data, I could now build the Authors CSV by iterating each unique author in the URL's CSV and requesting the username from Accounts collection in MongoDB. This gave me the reputation values, and the current Steem/SBD/SP balances.
Time to analyze
Most mentioned websites.ipynb
With the data at hand I fired up Jupyter Notebook. Jupyter Notebook is a tool for doing literal programming loved by data scientists. It allows you to mix markdown and code while maintaining the program state as you write block by block. This allows for easy experimentation with datasets. Pandas is a fantastic python library for working with structured dataset such as CSV or Excel. It makes it really easy to load up a CSV and start slicing and dicing to produce to results you are looking for.
Have a look at the notebook file GitHub to see how I got these results. GitHub displays them almost exactly as they appear when working on them.
I start out by loading up the CSV's into a Pandas DataFrame's and then join the datasets using pd.merge to create a new url_with_author_data DataFrame. I then wrote a function to group that DataFrame allow with aggregations which provide the stats num_authors total_reputation avg_reputation total_votes avg_votes. Now I can group the data by URL's and domains and sort by one of the metrics to get the results you see in the tables above.
What's next?
Trends what has become more or less popular over time.
Tags most popular sites in different categories (tags)
Monthly Show what new websites have become popular for the current month.
Have your say Let me know in the comments what you would like to see next!
I'm an Australian entrepreneur currently in South Korea. I frequently travel between Australia, Bali, South East Asia and South Korea. I focus mainly on software based businesses and am excited by how social and business model innovation, blockchain tech and artificial intelligence are changing the world.
You can keep updated with what i am working on by following me on Steemit @codewithcheese