A look at the data behind the seemingly increasing number of flags/down-votes that are been distributed on the Steem Blockchain over the past 6 months.

**Are the number of flags rising?**

Who are the top 'distributors'?

Who is on the receiving end?

------------------------------------

![t2.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1512036963/asazcnjez99pzpbfeapb.png)

---------------------------------------

### A brief introduction to Flagging
### 
Flags, or down-votes are a method to reduce the rewards on a post and or make the post less visible on the Steemit user interface.

This can be for a number of reasons including a disagreement on the rewards payout, which may be due to plagiarism or spam.  Additional flags may be given due to general disagreement on what is being said, or a general dislike to the user making the comments.

With up-votes, we have down-votes.  Voting power is used either way, and the user flagging is entitled to do as they wish. 

By the way, did you know that if you 'change' a vote, for example, you have voted on a post with 10% but you really like the post and want to give a 100% up-vote, you will receive 0 curation rewards for this new vote, and these rewards will be split between the other curators? If not, you do now :)

-------------------------------

### Flagging - A six month high level data review
### 

Data in this section has been captured from the 1st June 2017 through to the present day (30th November 2017).

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1512040210/ynumnuaxwed0wyb0o46g.png)

We can see that prior to the end of July, flagging activity was relatively low and steady day-to-day.  This could be due to the increasing user count and the introduction of more accounts used to combat spam and reward pool abuse.  

The above chart in numbers:

![6months.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1512040662/sgkd2wv8sc4z0xtqrapv.png)

---------------
<br>

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1512040954/xtvr5vh2qavfczpjmwca.png)

![av.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1512041082/agbr9pc44mwvcni27udu.png)

The average number of down-votes each day rose from June into July, and was almost 5 fold June's average in August.  Since then, the daily average has dropped each consecutive month.

------------------------------
<br>

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1512040973/yzilmgtmsuxwxzrrhv93.png)

![totals.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1512041100/oytgknanqxknqpq42zhu.png)

As you would expect from the average totals, the 'busiest' month was August which totaled 50,000 more flags than June and July combined!  Since then, the monthly totals have again fallen month by month.

-----------------------------
### Who's flagging?
### 

I feel it important to say here that Flags do serve a purpose, and that it is the free-will of the use to both the 'up' and 'down' vote for content they agree/like and disagree/dislike.

Top 20 Flagging accounts over the last 6 months

In the left-hand table below, all users. 

Excluded In the right-hand table, a short list of known (to me) 'services' in place to combat spam and reward pool abuse. ( @blacklist-a, @cheetah, @steemcleaners, @sadkitten, @steemservices, @smackdown.kitty, @mack-bot, @spaminator, @adm)  * This list is certainly open to interpretation! 

![voters.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1512041875/djde8l8aguwb53whsx3q.png)

Firstly, it's good to see such accounts like  @blacklist-a, @cheetah, @steemcleaners, @sadkitten on the left side list above - this is what I hoped to see.

The list on the right shows up some accounts we may know of, including a couple 'old' accounts with a good 'reputation'.

Is this list how you expected it to look?

------------------------
### Who's being flagged?
### 

No-one likes a down-vote, but you if you blog and comment multiple time a day and like to share your mind, then it is likely, in time, you may be on the receiving end.  His is a list of the top 20 most flagged accounts. 

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1512043308/uyjdl0ut8wpbcuma7cuz.png)

I am surprised to see @zappl at the top of the list, but am not sure if this is the official account or not.

There are also many accounts I recognize on the list above - perhaps they are being flagged in retaliation by accounts that have received a 'valid' down-vote.

Running a check to see if any particular accounts were taking a dislike to @zappl, I found that the account had received down-votes from over 1050 different accounts, with over 1000 of these voting to the negative over 10 times each.

This is interesting to me, and what's also interesting is that @zappl still has a reputation of 65.  Clearly these accounts are no match to the power of the up-votes the account is receiving.

------------------------------
### Summary
### 

Despite recent press, down-vote numbers in November are no match to months of July and August.

Since the beginning of June, there have been over half a million down-votes issued.  This should make most users feel quite pleased with occasional flag they have received!

-------------------------------

## Tools used to gather this data and compile report
##

The data is sourced from SteemSQL - A [publicly available SQL database](https://steemit.com/steemit/@arcange/steemsql-com-a-public-sql-server-database-with-all-steemit-blockchain-data) with all the blockchain data held within (Data is normally 1/2 hours delayed from live)

The SQL queries to extra to the data have been produced in both SQL Server Personal Edition and LINQPAD 5.

The charts used to present the data were produced using MS Excel.

A selection of SQL Scripts used

![image.png](https://res.cloudinary.com/hpiynhbhq/image/upload/v1512045536/xx4il9ss5ifukn5txxcd.png)

----------------------------------------------

<sub>This data was compiled on the 30th November at 10:00 am CET</sub>

<sub>I am part of a Steemit Business Intelligence community. We all post under the tag #bisteemit. If you have analysis you would like to be carried out on utopian-io/Steem data, please do contact me or any of the #bisteemit team and we will do our best to help you.</sub>

---------------------
<br>

I'd like to end this piece of analysis with something a bit lighter relating to 'Flagging'. 3 minutes of Eddie Izzard.

> No flag no Country, you cant have one!
<br>

https://www.youtube.com/watch?v=UTduy7Qkvk8

<br>
---------------------
<br>

I hope you found this analysis interesting.

Thanks

Asher @abh12345

<br /><hr/><em>Posted on <a href="https://utopian.io/utopian-io/@abh12345/steem-smack-down-analysis-do-you-have-a-flag">Utopian.io -  Rewarding Open Source Contributors</a></em><hr/>