Hello community! Since Dev Community has an API, and it is not restricted in use, I was curious to see how the site felt at all. I calculated some statistics, which I want to share with you.
Data processing
Let's start small, from the article/latest endpoint I collected 497039 articles. Some of them were broken, I deleted them all where id, slug, path, published_at is null, leaving 497001. Very cool! Almost half a million! Surprisingly, all is well, but there will be some anomalies, about which follow.
Date related statistics
The data is current as of April 25, 2023 12:00 PM.
The copywrite states that it is effective as of 2016, but the API has returned several articles from 1970, 2001 and 2004, 2014, I will consider all articles hereafter.
Let's see how many articles were published in each year.
Articles per year
The data is sorted by articles count descending.
| Year | Articles Count |
|---|---|
| 2020 | 121944 |
| 2022 | 121291 |
| 2021 | 119619 |
| 2019 | 57923 |
| 2023 | 46241 |
| 2018 | 19578 |
| 2017 | 9032 |
| 2016 | 659 |
| 2015 | 309 |
| 2014 | 151 |
| 2013 | 141 |
| 2011 | 35 |
| 2012 | 34 |
| 2010 | 33 |
| 2009 | 5 |
| 2001 | 2 |
| 1970 | 2 |
| 2004 | 1 |
| 2000 | 1 |
As you can see, it turned out to be the most popular years. The community has shown great growth over the years!
Number of articles per day
We see good growth from 2017 to 2019 and just a monster jump from 2019 to 2021.
If you look in more detail, from the end of 2022 the number of articles per day begins to grow again.
Articles per year
The share of articles by year looks like this, dominated by 2020, 2021, 2022.
If you prefer a histogram, then please
Articles per month
Number of articles by month for each year. 2023 has every chance of breaking the record!
Next, it was interesting to assess which months saw the most activity.
| Month | Count |
|---|---|
| March | 48658 |
| January | 48565 |
| April | 44862 |
| February | 42934 |
| December | 42016 |
| October | 40147 |
| November | 39586 |
| August | 39242 |
| July | 38678 |
| September | 37851 |
| May | 37665 |
| June | 36797 |
March, January, April and February. Now you know which month has the most competition)
Articles per weekday
The number by day of the week turned out to be almost in the original order, wow) Monday is a hard day - you need to handle the most articles.
Table variant
| Weekday | Count |
|---|---|
| Monday | 82978 |
| Tuesday | 79608 |
| Wednesday | 77961 |
| Thursday | 76446 |
| Friday | 71795 |
| Sunday | 56069 |
| Saturday | 52144 |
Tags
Total number of used tags is 1381472 and 54657 (3.96%) of them are unique.
I'll leave the table so you can quickly go to the page.
Authors
It's time to congratulate the most active authors. 16 most active ones.
Authors with most articles
Some stats
| **** | Count |
|---|---|
| count | 110533.0 |
| mean | 4.496403788913718 |
| std | 15.862431807521824 |
| min | 1.0 |
| 10% | 1.0 |
| 25% | 1.0 |
| 50% | 1.0 |
| 75% | 3.0 |
| 90% | 9.0 |
| 95% | 16.0 |
| 99% | 48.0 |
| max | 1577.0 |
There are 110533 authors and each author has written an average of 4 articles. However, a large spread, of course, against 1577 ;) Only a quarter of the authors wrote at least 3 articles. To be in the top 5% (Or write more articles than 95% of the authors) of authors by number of articles, you need to write at least 16, and to be in the top 1% already 48.
Most Discussed
There's a monopoly of @thepracticaldev and @ben, so if you take the unique ones, you get the following.
Here top 32 articles by comments count.
Top 16 authors by comments count
By the way, there are 921071 comments in total. Top 4096 authors by comments you can find on Google Sheets.
- Published version: https://docs.google.com/spreadsheets/d/e/2PACX-1vQATeCfUyIlbFeY35Xnv1pqRDOJsYNmQoVSbuxdBj005av7XVtUS0VaUMF78iuCAnlsZYhBcVfROX_f/pubhtml?gid=1707627826&single=true
- Sheet version: https://docs.google.com/spreadsheets/d/1sLIWVI8CnJytm8yG0D250PkuymDqd4b9xQ0QPaUelbI/edit?usp=sharing
Summary
If you have read to this point, then you at least enjoyed it) I would like to make a site that will track these statistics constantly, add a little more parameters and design the leaderboards.
Top comments (0)