14

After 2018: a year in closing and 2018: a year in spam it seems natural to look at the questions and answers. What trends do we find there?

19

My goal was to compare 2018 to 2017, considering only the sites created before the beginning of 2017, so that year-to-year comparison is meaningful. Deleted posts were included by the query.

Totals

The decline and fall of Stack Exchange.

+-----------+---------+---------+----------+
|           |  2017   |  2018   | % change |
+-----------+---------+---------+----------+
| Questions | 4521708 | 4185084 | -7.44%   |
| Answers   | 5032310 | 4495015 | -10.68%  |
| Posts     | 9554018 | 8680099 | -9.15%   |
+-----------+---------+---------+----------+

Fastest growing sites

By the percentage change of posts. Percentage changes of questions and answers are also included.

Artificial Intelligence and Data Science lead the way.

+------+----------------+-----------+---------+---------+
| Rank |      Site      | Questions | Answers |  Posts  |
+------+----------------+-----------+---------+---------+
|    1 | ai             | 96.66%    | 111.02% | 104.24% |
|    2 | datascience    | 73.31%    | 82.40%  | 77.34%  |
|    3 | space          | 72.60%    | 75.15%  | 74.13%  |
|    4 | puzzling       | 62.63%    | 64.86%  | 64.22%  |
|    5 | retrocomputing | 32.81%    | 49.37%  | 44.63%  |
|    6 | russian        | 51.44%    | 38.75%  | 42.67%  |
|    7 | philosophy     | 19.98%    | 54.76%  | 42.40%  |
|    8 | ethereum       | 40.70%    | 39.66%  | 40.17%  |
|    9 | 3dprinting     | 27.52%    | 34.26%  | 31.70%  |
|   10 | writers        | 9.72%     | 34.22%  | 27.95%  |
+------+----------------+-----------+---------+---------+

Bottom 10

Remember Windows Phone?

+------+------------------+-----------+---------+---------+
| Rank |       Site       | Questions | Answers |  Posts  |
+------+------------------+-----------+---------+---------+
|  150 | patents          | -45.18%   | -25.08% | -35.67% |
|  151 | tor              | -30.88%   | -42.70% | -36.45% |
|  152 | parenting        | -24.79%   | -42.21% | -38.40% |
|  153 | moderators       | -21.74%   | -50.35% | -41.04% |
|  154 | expressionengine | -41.17%   | -41.91% | -41.51% |
|  155 | codegolf         | -44.43%   | -44.46% | -44.46% |
|  156 | freelancing      | -37.07%   | -52.09% | -46.82% |
|  157 | movies           | -51.35%   | -51.13% | -51.23% |
|  158 | esperanto        | -47.06%   | -55.86% | -53.35% |
|  159 | windowsphone     | -63.69%   | -57.12% | -59.52% |
+------+------------------+-----------+---------+---------+

More questions, fewer answers

Questions are up by 5% or more, answers are down by 5% or more.

+-----------+-----------+---------+
|   Site    | Questions | Answers |
+-----------+-----------+---------+
| gardening | 10.66%    | -6.30%  |
| mythology | 13.51%    | -10.34% |
| coffee    | 17.39%    | -12.37% |
+-----------+-----------+---------+

Fewer questions, more answers

Questions are down by 5% or more, answers are up by 5% or more.

(There were 100% fewer total solar eclipses in 2018.)

+-----------+-----------+---------+
|   Site    | Questions | Answers |
+-----------+-----------+---------+
| astronomy | -6.64%    | 6.91%   |
+-----------+-----------+---------+

Stack Overflow

Can’t We All be Reasonable and Speak Spanish?

+------+------------------+-----------+---------+---------+
| Rank |       Site       | Questions | Answers |  Posts  |
+------+------------------+-----------+---------+---------+
|   19 | es.stackoverflow | 21.55%    | 5.97%   | 13.69%  |
|   22 | ja.stackoverflow | 7.94%     | 11.48%  | 9.56%   |
|   31 | ru.stackoverflow | 9.61%     | -1.18%  | 4.47%   |
|   73 | br.stackoverflow | 1.03%     | -12.21% | -5.55%  |
|   91 | stackoverflow    | -8.51%    | -12.06% | -10.37% |
+------+------------------+-----------+---------+---------+

Complete list

+------+--------------------+-----------+---------+---------+
| Rank |        Site        | Questions | Answers |  Posts  |
+------+--------------------+-----------+---------+---------+
|    1 | ai                 | 96.66%    | 111.02% | 104.24% |
|    2 | datascience        | 73.31%    | 82.40%  | 77.34%  |
|    3 | space              | 72.60%    | 75.15%  | 74.13%  |
|    4 | puzzling           | 62.63%    | 64.86%  | 64.22%  |
|    5 | retrocomputing     | 32.81%    | 49.37%  | 44.63%  |
|    6 | russian            | 51.44%    | 38.75%  | 42.67%  |
|    7 | philosophy         | 19.98%    | 54.76%  | 42.40%  |
|    8 | ethereum           | 40.70%    | 39.66%  | 40.17%  |
|    9 | 3dprinting         | 27.52%    | 34.26%  | 31.70%  |
|   10 | writers            | 9.72%     | 34.22%  | 27.95%  |
|   11 | law                | 19.21%    | 29.15%  | 24.32%  |
|   12 | sitecore           | 31.53%    | 9.88%   | 19.41%  |
|   13 | hermeneutics       | 14.15%    | 20.77%  | 19.01%  |
|   14 | italian            | 26.05%    | 11.92%  | 17.66%  |
|   15 | sustainability     | 28.42%    | 12.37%  | 17.44%  |
|   16 | rpg                | 18.72%    | 15.47%  | 16.50%  |
|   17 | cogsci             | 14.63%    | 13.13%  | 13.98%  |
|   18 | reverseengineering | 17.08%    | 10.33%  | 13.80%  |
|   19 | es.stackoverflow   | 21.55%    | 5.97%   | 13.69%  |
|   20 | ham                | 35.47%    | -0.44%  | 10.85%  |
|   21 | earthscience       | 17.78%    | 3.05%   | 9.59%   |
|   22 | ja.stackoverflow   | 7.94%     | 11.48%  | 9.56%   |
|   23 | linguistics        | 7.82%     | 7.55%   | 7.67%   |
|   24 | rus                | 9.01%     | 5.83%   | 6.86%   |
|   25 | blender            | 7.70%     | 4.64%   | 6.35%   |
|   26 | outdoors           | 12.31%    | 3.91%   | 6.11%   |
|   27 | academia           | -2.36%    | 10.40%  | 5.59%   |
|   28 | economics          | 13.95%    | -3.68%  | 5.25%   |
|   29 | music              | 6.01%     | 4.85%   | 5.20%   |
|   30 | aviation           | 4.49%     | 5.28%   | 5.00%   |
|   31 | ru.stackoverflow   | 9.61%     | -1.18%  | 4.47%   |
|   32 | judaism            | 0.82%     | 7.11%   | 4.45%   |
|   33 | matheducators      | 13.38%    | 0.44%   | 3.88%   |
|   34 | bricks             | -0.85%    | 6.40%   | 3.42%   |
|   35 | hinduism           | 10.78%    | -2.27%  | 3.34%   |
|   36 | languagelearning   | 11.27%    | -3.01%  | 3.23%   |
|   37 | garage             | 9.35%     | -1.45%  | 2.84%   |
|   38 | homebrew           | 2.75%     | 2.59%   | 2.64%   |
|   39 | sports             | 0.52%     | 3.29%   | 2.08%   |
|   40 | crypto             | -0.57%    | 3.26%   | 1.30%   |
|   41 | engineering        | -1.57%    | 4.02%   | 1.15%   |
|   42 | bicycles           | -3.81%    | 3.57%   | 1.12%   |
|   43 | ell                | -2.03%    | 2.59%   | 0.68%   |
|   44 | boardgames         | 2.92%     | -1.76%  | -0.05%  |
|   45 | gardening          | 10.66%    | -6.30%  | -0.11%  |
|   46 | astronomy          | -6.64%    | 6.91%   | -0.21%  |
|   47 | genealogy          | 2.40%     | -2.69%  | -0.64%  |
|   48 | dsp                | 1.66%     | -3.56%  | -0.80%  |
|   49 | money              | -2.49%    | 0.20%   | -0.82%  |
|   50 | quant              | 1.12%     | -3.38%  | -0.88%  |
|   51 | worldbuilding      | 3.95%     | -2.35%  | -1.23%  |
|   52 | physics            | -2.52%    | -0.22%  | -1.38%  |
|   53 | mythology          | 13.51%    | -10.34% | -1.59%  |
|   54 | islam              | 2.03%     | -5.41%  | -2.11%  |
|   55 | lifehacks          | 4.23%     | -4.15%  | -2.16%  |
|   56 | electronics        | -0.32%    | -4.17%  | -2.53%  |
|   57 | bitcoin            | -7.27%    | 1.66%   | -2.62%  |
|   58 | travel             | 1.36%     | -5.51%  | -2.70%  |
|   59 | dba                | 1.19%     | -6.11%  | -2.72%  |
|   60 | diy                | 0.73%     | -5.00%  | -2.77%  |
|   61 | unix               | -3.14%    | -2.50%  | -2.79%  |
|   62 | mathoverflow       | -1.79%    | -5.00%  | -3.17%  |
|   63 | tex                | -2.38%    | -4.11%  | -3.30%  |
|   64 | fitness            | -4.69%    | -2.42%  | -3.36%  |
|   65 | vi                 | 0.62%     | -7.03%  | -3.52%  |
|   66 | coffee             | 17.39%    | -12.37% | -3.98%  |
|   67 | french             | -2.16%    | -4.91%  | -4.00%  |
|   68 | gis                | -3.48%    | -5.59%  | -4.45%  |
|   69 | networkengineering | -3.95%    | -5.09%  | -4.46%  |
|   70 | english            | -3.80%    | -5.50%  | -4.79%  |
|   71 | cooking            | 3.49%     | -8.69%  | -5.05%  |
|   72 | pm                 | -8.19%    | -3.51%  | -5.06%  |
|   73 | br.stackoverflow   | 1.03%     | -12.21% | -5.55%  |
|   74 | stats              | -6.47%    | -4.00%  | -5.55%  |
|   75 | cs                 | -4.80%    | -6.93%  | -5.73%  |
|   76 | hsm                | -6.61%    | -5.15%  | -5.78%  |
|   77 | opensource         | -2.08%    | -10.91% | -6.79%  |
|   78 | history            | -1.16%    | -10.06% | -6.87%  |
|   79 | pets               | -0.43%    | -10.64% | -7.00%  |
|   80 | craftcms           | -5.88%    | -8.60%  | -7.26%  |
|   81 | math               | -6.21%    | -8.32%  | -7.36%  |
|   82 | crafts             | -3.99%    | -10.28% | -8.03%  |
|   83 | ubuntu             | -8.99%    | -8.52%  | -8.78%  |
|   84 | webapps            | -6.53%    | -11.21% | -8.94%  |
|   85 | monero             | -0.94%    | -15.97% | -9.28%  |
|   86 | mathematica        | -10.30%   | -8.56%  | -9.38%  |
|   87 | superuser          | -10.18%   | -9.25%  | -9.72%  |
|   88 | anime              | -6.19%    | -12.05% | -9.76%  |
|   89 | buddhism           | -0.08%    | -12.37% | -9.78%  |
|   90 | workplace          | -25.34%   | -2.34%  | -9.95%  |
|   91 | stackoverflow      | -8.51%    | -12.06% | -10.37% |
|   92 | webmasters         | -9.82%    | -12.05% | -10.87% |
|   93 | programmers        | -8.02%    | -13.37% | -11.01% |
|   94 | christianity       | -14.76%   | -9.55%  | -11.38% |
|   95 | expatriates        | -5.06%    | -18.11% | -11.77% |
|   96 | civicrm            | -13.90%   | -10.19% | -11.88% |
|   97 | emacs              | -16.08%   | -8.11%  | -12.22% |
|   98 | photography        | -14.83%   | -10.98% | -12.24% |
|   99 | security           | -11.70%   | -12.79% | -12.30% |
|  100 | musicfans          | -3.50%    | -19.95% | -12.31% |
|  101 | sqa                | -13.70%   | -12.00% | -12.64% |
|  102 | salesforce         | -13.24%   | -12.28% | -12.77% |
|  103 | sound              | -6.86%    | -19.37% | -13.98% |
|  104 | magento            | -13.19%   | -15.10% | -14.13% |
|  105 | avp                | -9.72%    | -18.95% | -14.22% |
|  106 | chess              | -1.13%    | -19.44% | -14.47% |
|  107 | politics           | -20.47%   | -11.66% | -14.62% |
|  108 | softwarerecs       | -11.54%   | -18.39% | -14.66% |
|  109 | chinese            | -9.57%    | -16.94% | -14.80% |
|  110 | health             | -10.88%   | -20.53% | -14.90% |
|  111 | scicomp            | -10.86%   | -20.24% | -15.03% |
|  112 | korean             | -13.64%   | -15.98% | -15.15% |
|  113 | computergraphics   | -9.04%    | -22.27% | -15.39% |
|  114 | cstheory           | -15.65%   | -14.95% | -15.39% |
|  115 | apple              | -21.57%   | -9.58%  | -15.59% |
|  116 | woodworking        | -8.39%    | -19.68% | -15.64% |
|  117 | codereview         | -14.45%   | -18.17% | -16.29% |
|  118 | serverfault        | -14.73%   | -18.34% | -16.44% |
|  119 | wordpress          | -12.49%   | -21.36% | -16.54% |
|  120 | hardwarerecs       | -15.48%   | -19.25% | -16.82% |
|  121 | chemistry          | -13.90%   | -20.74% | -16.88% |
|  122 | scifi              | -19.46%   | -16.03% | -17.27% |
|  123 | german             | -18.90%   | -17.15% | -17.72% |
|  124 | raspberrypi        | -19.78%   | -16.87% | -18.33% |
|  125 | biology            | -16.28%   | -20.92% | -18.48% |
|  126 | arduino            | -10.85%   | -25.35% | -18.73% |
|  127 | latin              | -21.54%   | -16.86% | -18.74% |
|  128 | opendata           | -11.88%   | -26.67% | -19.29% |
|  129 | robotics           | -15.37%   | -23.74% | -19.33% |
|  130 | elementaryos       | -18.38%   | -21.21% | -19.81% |
|  131 | spanish            | -24.09%   | -20.44% | -21.63% |
|  132 | japanese           | -13.07%   | -28.62% | -22.32% |
|  133 | gamedev            | -20.67%   | -25.87% | -23.15% |
|  134 | stackapps          | -30.37%   | -2.88%  | -23.35% |
|  135 | martialarts        | -22.26%   | -24.26% | -23.68% |
|  136 | sharepoint         | -25.44%   | -21.99% | -23.72% |
|  137 | drupal             | -25.29%   | -25.77% | -25.49% |
|  138 | joomla             | -25.39%   | -28.31% | -27.00% |
|  139 | portuguese         | -20.51%   | -30.63% | -27.36% |
|  140 | skeptics           | -28.62%   | -26.60% | -27.48% |
|  141 | poker              | -20.07%   | -31.50% | -28.09% |
|  142 | ux                 | -24.97%   | -30.03% | -28.22% |
|  143 | iot                | -14.76%   | -38.52% | -28.68% |
|  144 | graphicdesign      | -33.96%   | -23.02% | -28.74% |
|  145 | tridion            | -31.35%   | -29.07% | -30.07% |
|  146 | ebooks             | -25.24%   | -34.92% | -30.43% |
|  147 | beer               | -32.29%   | -30.31% | -30.96% |
|  148 | android            | -28.17%   | -35.55% | -31.75% |
|  149 | gaming             | -31.20%   | -33.70% | -32.66% |
|  150 | patents            | -45.18%   | -25.08% | -35.67% |
|  151 | tor                | -30.88%   | -42.70% | -36.45% |
|  152 | parenting          | -24.79%   | -42.21% | -38.40% |
|  153 | moderators         | -21.74%   | -50.35% | -41.04% |
|  154 | expressionengine   | -41.17%   | -41.91% | -41.51% |
|  155 | codegolf           | -44.43%   | -44.46% | -44.46% |
|  156 | freelancing        | -37.07%   | -52.09% | -46.82% |
|  157 | movies             | -51.35%   | -51.13% | -51.23% |
|  158 | esperanto          | -47.06%   | -55.86% | -53.35% |
|  159 | windowsphone       | -63.69%   | -57.12% | -59.52% |
+------+--------------------+-----------+---------+---------+

You must log in to answer this question.

Not the answer you're looking for? Browse other questions tagged .