API tools faq
paste
Advertisement
westand

Byte changes for WP:MED content during 2013; WikiData adjust

westand
Mar 11th, 2014
5,434
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 23.23 KB | None | 0 0
raw download clone embed print report
  1. FOR EXAMPLE: English medical content grew by a factor of 1.0891 in 2013
  2.  
  3. These numbers account for the impact of the WikiData intra-language link migration!!
  4.  
  5. mysql> SELECT SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE)) as LANG,
  6. -> SUM(bytes_end_2012) AS END_2012_RAW,
  7. -> SUM(wikidata_diff) AS WIKIDATA_IMPACT,
  8. -> SUM(bytes_end_2012)+SUM(wikidata_diff) AS END_2012_ADJ,
  9. -> SUM(bytes_end_2013) as END_2013,
  10. -> (SUM(bytes_end_2013)/(SUM(bytes_end_2012)+SUM(wikidata_diff))) AS GROWTH FROM wp_med_monthly GROUP BY
  11. -> SUBSTRING(PAGE FROM 1 FOR LOCATE(' ',PAGE))
  12. -> ORDER BY (1.0*SUM(bytes_end_2013)/(SUM(bytes_end_2012)+SUM(wikidata_diff))) DESC;
  13.  
  14. +---------------+--------------+-----------------+--------------+-----------+---------+
  15. | LANG | END_2012_RAW | WIKIDATA_IMPACT | END_2012_ADJ | END_2013 | GROWTH |
  16. +---------------+--------------+-----------------+--------------+-----------+---------+
  17. | ce | 6967 | -5738 | 1229 | 99725 | 81.1432 |
  18. | uz | 114961 | -64433 | 50528 | 531958 | 10.5280 |
  19. | pa | 65205 | -33866 | 31339 | 162952 | 5.1997 |
  20. | war | 331011 | -281432 | 49579 | 214669 | 4.3298 |
  21. | pag | 17793 | -16331 | 1462 | 5780 | 3.9535 |
  22. | ceb | 102554 | -48903 | 53651 | 203564 | 3.7942 |
  23. | ba | 120641 | -51846 | 68795 | 221146 | 3.2146 |
  24. | kw | 15008 | -13272 | 1736 | 5379 | 3.0985 |
  25. | sco | 54255 | -38157 | 16098 | 46240 | 2.8724 |
  26. | tt | 262750 | -90147 | 172603 | 462430 | 2.6792 |
  27. | ilo | 91186 | -42388 | 48798 | 118081 | 2.4198 |
  28. | frr | 31600 | -17088 | 14512 | 34447 | 2.3737 |
  29. | pih | 4475 | -4373 | 102 | 239 | 2.3431 |
  30. | ace | 18756 | -13190 | 5566 | 12139 | 2.1809 |
  31. | wo | 5552 | -5198 | 354 | 750 | 2.1186 |
  32. | so | 105456 | -81917 | 23539 | 46558 | 1.9779 |
  33. | mhr | 49065 | -26548 | 22517 | 44329 | 1.9687 |
  34. | hy | 1111385 | -177863 | 933522 | 1731425 | 1.8547 |
  35. | co | 18451 | -11292 | 7159 | 12571 | 1.7560 |
  36. | xh | 3641 | -2941 | 700 | 1205 | 1.7214 |
  37. | be-x-old | 885935 | -325585 | 560350 | 956316 | 1.7066 |
  38. | or | 669414 | -14539 | 654875 | 1090753 | 1.6656 |
  39. | lo | 17215 | -10131 | 7084 | 11593 | 1.6365 |
  40. | be | 1494203 | -484358 | 1009845 | 1652326 | 1.6362 |
  41. | zh-yue | 469959 | -204966 | 264993 | 424161 | 1.6006 |
  42. | tet | 5903 | -5673 | 230 | 358 | 1.5565 |
  43. | bm | 24204 | -20356 | 3848 | 5899 | 1.5330 |
  44. | sa | 232451 | -77633 | 154818 | 229007 | 1.4792 |
  45. | gn | 96888 | -75695 | 21193 | 30425 | 1.4356 |
  46. | gl | 6941075 | -806288 | 6134787 | 8684699 | 1.4156 |
  47. | vep | 30908 | -18658 | 12250 | 16940 | 1.3829 |
  48. | gv | 132856 | -44667 | 88189 | 121122 | 1.3734 |
  49. | haw | 5927 | -5673 | 254 | 346 | 1.3622 |
  50. | ga | 675743 | -282441 | 393302 | 522543 | 1.3286 |
  51. | tk | 230309 | -40491 | 189818 | 250140 | 1.3178 |
  52. | et | 3374860 | -773079 | 2601781 | 3425366 | 1.3165 |
  53. | pnb | 387410 | -191466 | 195944 | 256934 | 1.3113 |
  54. | eml | 10630 | -4665 | 5965 | 7730 | 1.2959 |
  55. | lad | 25896 | -14939 | 10957 | 14173 | 1.2935 |
  56. | ckb | 493361 | -104221 | 389140 | 499209 | 1.2829 |
  57. | sn | 79388 | -55281 | 24107 | 30706 | 1.2737 |
  58. | pms | 105359 | -55280 | 50079 | 63770 | 1.2734 |
  59. | ti | 7683 | -6588 | 1095 | 1387 | 1.2667 |
  60. | diq | 47048 | -35778 | 11270 | 14250 | 1.2644 |
  61. | sh | 4799958 | -647405 | 4152553 | 5204759 | 1.2534 |
  62. | ml | 3921668 | -338677 | 3582991 | 4485948 | 1.2520 |
  63. | jv | 1240051 | -345003 | 895048 | 1117801 | 1.2489 |
  64. | am | 139256 | -50880 | 88376 | 109519 | 1.2392 |
  65. | fo | 154214 | -78732 | 75482 | 93536 | 1.2392 |
  66. | hr | 6505291 | -994698 | 5510593 | 6787446 | 1.2317 |
  67. | hak | 53289 | -43173 | 10116 | 12436 | 1.2293 |
  68. | uk | 14976080 | -1133156 | 13842924 | 16899378 | 1.2208 |
  69. | sl | 6347902 | -891873 | 5456029 | 6633744 | 1.2159 |
  70. | nah | 65607 | -51687 | 13920 | 16903 | 1.2143 |
  71. | vec | 85837 | -46111 | 39726 | 48200 | 1.2133 |
  72. | km | 103359 | -18008 | 85351 | 103097 | 1.2079 |
  73. | ku | 443144 | -223621 | 219523 | 265081 | 1.2075 |
  74. | ar | 23528403 | -1560306 | 21968097 | 26456419 | 1.2043 |
  75. | az | 2063027 | -496875 | 1566152 | 1869185 | 1.1935 |
  76. | wa | 238665 | -107329 | 131336 | 156434 | 1.1911 |
  77. | fa | 12556638 | -247809 | 12308829 | 14647002 | 1.1900 |
  78. | ia | 398365 | -169289 | 229076 | 271487 | 1.1851 |
  79. | ro | 6836050 | -891277 | 5944773 | 7044444 | 1.1850 |
  80. | mk | 4978443 | -412446 | 4565997 | 5282581 | 1.1569 |
  81. | simple | 4623934 | -1029912 | 3594022 | 4146653 | 1.1538 |
  82. | tl | 2250906 | -424211 | 1826695 | 2106901 | 1.1534 |
  83. | zh-classical | 29475 | -19918 | 9557 | 11018 | 1.1529 |
  84. | ik | 8972 | -7978 | 994 | 1144 | 1.1509 |
  85. | bn | 1780657 | -220040 | 1560617 | 1795236 | 1.1503 |
  86. | crh | 6291 | -5672 | 619 | 711 | 1.1486 |
  87. | mr | 1204635 | -220679 | 983956 | 1128630 | 1.1470 |
  88. | tg | 147911 | -74271 | 73640 | 84456 | 1.1469 |
  89. | el | 9912227 | -622559 | 9289668 | 10622610 | 1.1435 |
  90. | chy | 11996 | -9950 | 2046 | 2325 | 1.1364 |
  91. | sm | 2205 | -1793 | 412 | 468 | 1.1359 |
  92. | vi | 7405699 | -731638 | 6674061 | 7538054 | 1.1295 |
  93. | kk | 2825482 | -545590 | 2279892 | 2563088 | 1.1242 |
  94. | da | 5224149 | -1090760 | 4133389 | 4632992 | 1.1209 |
  95. | cv | 210844 | -67030 | 143814 | 160811 | 1.1182 |
  96. | hu | 12585702 | -972051 | 11613651 | 12962443 | 1.1161 |
  97. | zh | 15127046 | -1670262 | 13456784 | 14989334 | 1.1139 |
  98. | sw | 2642485 | -210945 | 2431540 | 2708095 | 1.1137 |
  99. | ms | 3876646 | -549582 | 3327064 | 3704326 | 1.1134 |
  100. | new | 437330 | -91726 | 345604 | 384365 | 1.1122 |
  101. | id | 7273165 | -1068649 | 6204516 | 6889780 | 1.1104 |
  102. | lv | 1914084 | -534636 | 1379448 | 1526413 | 1.1065 |
  103. | la | 1317352 | -501016 | 816336 | 902017 | 1.1050 |
  104. | ru | 44967604 | -1565926 | 43401678 | 47912770 | 1.1039 |
  105. | it | 41458050 | -1814279 | 39643771 | 43681804 | 1.1019 |
  106. | ja | 34353641 | -1858683 | 32494958 | 35740748 | 1.0999 |
  107. | fr | 54439202 | -2340983 | 52098219 | 57166244 | 1.0973 |
  108. | lb | 481629 | -178686 | 302943 | 332145 | 1.0964 |
  109. | pt | 25032002 | -2244068 | 22787934 | 24942527 | 1.0945 |
  110. | lt | 3713736 | -837958 | 2875778 | 3140117 | 1.0919 |
  111. | io | 595698 | -410885 | 184813 | 201770 | 1.0918 |
  112. | bg | 8769712 | -880896 | 7888816 | 8610831 | 1.0915 |
  113. | ko | 6885073 | -1177681 | 5707392 | 6225905 | 1.0908 |
  114. | en | 224463488 | -3093685 | 221369803 | 241092406 | 1.0891 |
  115. | he | 19472216 | -1312763 | 18159453 | 19745052 | 1.0873 |
  116. | eu | 3120989 | -806166 | 2314823 | 2512717 | 1.0855 |
  117. | th | 5694886 | -503547 | 5191339 | 5633837 | 1.0852 |
  118. | eo | 3015054 | -869943 | 2145111 | 2327091 | 1.0848 |
  119. | es | 49857796 | -2391776 | 47466020 | 51432728 | 1.0836 |
  120. | sv | 12682305 | -1883892 | 10798413 | 11700564 | 1.0835 |
  121. | srn | 9791 | -8383 | 1408 | 1524 | 1.0824 |
  122. | cy | 993017 | -376280 | 616737 | 666526 | 1.0807 |
  123. | cs | 12942616 | -1491656 | 11450960 | 12335880 | 1.0773 |
  124. | fi | 11847119 | -1640707 | 10206412 | 10987769 | 1.0766 |
  125. | ay | 70819 | -60438 | 10381 | 11166 | 1.0756 |
  126. | mn | 410425 | -104314 | 306111 | 328497 | 1.0731 |
  127. | gd | 142554 | -99126 | 43428 | 46535 | 1.0715 |
  128. | ab | 11798 | -10507 | 1291 | 1383 | 1.0713 |
  129. | csb | 18004 | -12074 | 5930 | 6352 | 1.0712 |
  130. | ka | 1993782 | -245899 | 1747883 | 1869361 | 1.0695 |
  131. | iu | 29782 | -26718 | 3064 | 3276 | 1.0692 |
  132. | za | 27870 | -25272 | 2598 | 2774 | 1.0677 |
  133. | as | 648722 | -35927 | 612795 | 654267 | 1.0677 |
  134. | pfl | 10824 | -8499 | 2325 | 2476 | 1.0649 |
  135. | se | 19645 | -15733 | 3912 | 4166 | 1.0649 |
  136. | scn | 325323 | -204062 | 121261 | 129081 | 1.0645 |
  137. | de | 64147461 | -2558437 | 61589024 | 65536100 | 1.0641 |
  138. | ln | 166399 | -92644 | 73755 | 78475 | 1.0640 |
  139. | tr | 8378376 | -1249108 | 7129268 | 7582816 | 1.0636 |
  140. | qu | 358714 | -247460 | 111254 | 118295 | 1.0633 |
  141. | lmo | 74680 | -40955 | 33725 | 35799 | 1.0615 |
  142. | no | 9802074 | -1423953 | 8378121 | 8887764 | 1.0608 |
  143. | zh-min-nan | 499128 | -253825 | 245303 | 260162 | 1.0606 |
  144. | ki | 9530 | -7893 | 1637 | 1735 | 1.0599 |
  145. | ve | 3131 | -2795 | 336 | 356 | 1.0595 |
  146. | pl | 28674017 | -2315236 | 26358781 | 27915262 | 1.0590 |
  147. | sr | 15258509 | -1034407 | 14224102 | 15039312 | 1.0573 |
  148. | nl | 19464902 | -2086193 | 17378709 | 18358656 | 1.0564 |
  149. | ta | 8681809 | -320372 | 8361437 | 8822604 | 1.0552 |
  150. | ne | 2194470 | -155865 | 2038605 | 2150749 | 1.0550 |
  151. | hi | 12112630 | -518828 | 11593802 | 12222399 | 1.0542 |
  152. | rue | 97507 | -65000 | 32507 | 34245 | 1.0535 |
  153. | xmf | 41287 | -17879 | 23408 | 24646 | 1.0529 |
  154. | tpi | 2677 | -1905 | 772 | 812 | 1.0518 |
  155. | av | 42467 | -33475 | 8992 | 9431 | 1.0488 |
  156. | yo | 159681 | -92512 | 67169 | 70441 | 1.0487 |
  157. | sk | 4198340 | -803345 | 3394995 | 3557275 | 1.0478 |
  158. | ch | 7601 | -5674 | 1927 | 2019 | 1.0477 |
  159. | xal | 12941 | -11073 | 1868 | 1954 | 1.0460 |
  160. | te | 6806231 | -317710 | 6488521 | 6787225 | 1.0460 |
  161. | lbe | 49094 | -37613 | 11481 | 12000 | 1.0452 |
  162. | pam | 308250 | -68274 | 239976 | 250801 | 1.0451 |
  163. | koi | 10253 | -7469 | 2784 | 2907 | 1.0442 |
  164. | mrj | 13793 | -9487 | 4306 | 4495 | 1.0439 |
  165. | bs | 2621781 | -573202 | 2048579 | 2136781 | 1.0431 |
  166. | lij | 89385 | -40121 | 49264 | 51362 | 1.0426 |
  167. | ie | 16106 | -9771 | 6335 | 6603 | 1.0423 |
  168. | frp | 15064 | -12344 | 2720 | 2832 | 1.0412 |
  169. | an | 432220 | -192975 | 239245 | 249028 | 1.0409 |
  170. | ht | 220265 | -145639 | 74626 | 77623 | 1.0402 |
  171. | kg | 11333 | -9130 | 2203 | 2291 | 1.0399 |
  172. | nn | 1886990 | -508810 | 1378180 | 1432345 | 1.0393 |
  173. | ca | 18360473 | -1677981 | 16682492 | 17315397 | 1.0379 |
  174. | arz | 496845 | -142985 | 353860 | 367231 | 1.0378 |
  175. | is | 1550780 | -478681 | 1072099 | 1111807 | 1.0370 |
  176. | yi | 845068 | -258507 | 586561 | 608096 | 1.0367 |
  177. | sah | 148062 | -71324 | 76738 | 79366 | 1.0342 |
  178. | br | 616680 | -226476 | 390204 | 402942 | 1.0326 |
  179. | bat-smg | 185521 | -120529 | 64992 | 67089 | 1.0323 |
  180. | ext | 54406 | -36771 | 17635 | 18203 | 1.0322 |
  181. | af | 1116140 | -252093 | 864047 | 891315 | 1.0316 |
  182. | nrm | 24077 | -16122 | 7955 | 8204 | 1.0313 |
  183. | kab | 13926 | -8613 | 5313 | 5475 | 1.0305 |
  184. | gan | 68476 | -54017 | 14459 | 14891 | 1.0299 |
  185. | mt | 160566 | -41349 | 119217 | 122693 | 1.0292 |
  186. | ur | 1408771 | -418497 | 990274 | 1019122 | 1.0291 |
  187. | rn | 37165 | -25230 | 11935 | 12265 | 1.0276 |
  188. | arc | 98893 | -75354 | 23539 | 24167 | 1.0267 |
  189. | kaa | 28246 | -19846 | 8400 | 8623 | 1.0265 |
  190. | bcl | 24098 | -16673 | 7425 | 7616 | 1.0257 |
  191. | hif | 108438 | -70311 | 38127 | 39107 | 1.0257 |
  192. | bar | 131589 | -45065 | 86524 | 88717 | 1.0253 |
  193. | mi | 11491 | -7497 | 3994 | 4095 | 1.0253 |
  194. | sc | 26579 | -17691 | 8888 | 9109 | 1.0249 |
  195. | oc | 786561 | -282403 | 504158 | 516193 | 1.0239 |
  196. | pcd | 6789 | -5242 | 1547 | 1583 | 1.0233 |
  197. | kbd | 17361 | -7368 | 9993 | 10222 | 1.0229 |
  198. | li | 144174 | -42241 | 101933 | 104217 | 1.0224 |
  199. | bo | 63475 | -42290 | 21185 | 21658 | 1.0223 |
  200. | os | 43119 | -26964 | 16155 | 16511 | 1.0220 |
  201. | kv | 18060 | -13966 | 4094 | 4181 | 1.0213 |
  202. | fiu-vro | 132021 | -94021 | 38000 | 38769 | 1.0202 |
  203. | szl | 60228 | -36375 | 23853 | 24316 | 1.0194 |
  204. | dsb | 8047 | -5161 | 2886 | 2940 | 1.0187 |
  205. | cu | 2630 | -1718 | 912 | 929 | 1.0186 |
  206. | cdo | 5993 | -4001 | 1992 | 2029 | 1.0186 |
  207. | nds | 1016377 | -129660 | 886717 | 902076 | 1.0173 |
  208. | si | 1588551 | -123088 | 1465463 | 1490740 | 1.0172 |
  209. | vo | 31920 | -15882 | 16038 | 16302 | 1.0165 |
  210. | ig | 9445 | -6204 | 3241 | 3294 | 1.0164 |
  211. | bjn | 92083 | -43960 | 48123 | 48855 | 1.0152 |
  212. | gu | 3350775 | -75003 | 3275772 | 3324668 | 1.0149 |
  213. | mg | 48018 | -24213 | 23805 | 24146 | 1.0143 |
  214. | ug | 73075 | -44891 | 28184 | 28553 | 1.0131 |
  215. | ltg | 4040 | -2938 | 1102 | 1115 | 1.0118 |
  216. | krc | 15215 | -7397 | 7818 | 7910 | 1.0118 |
  217. | om | 33983 | -16873 | 17110 | 17301 | 1.0112 |
  218. | als | 428793 | -82334 | 346459 | 350181 | 1.0107 |
  219. | vls | 71247 | -28291 | 42956 | 43388 | 1.0101 |
  220. | zu | 18024 | -6935 | 11089 | 11199 | 1.0099 |
  221. | udm | 13026 | -10051 | 2975 | 3004 | 1.0097 |
  222. | nov | 36175 | -23300 | 12875 | 12999 | 1.0096 |
  223. | tum | 8917 | -4816 | 4101 | 4139 | 1.0093 |
  224. | hsb | 31287 | -13741 | 17546 | 17697 | 1.0086 |
  225. | ang | 29856 | -18462 | 11394 | 11488 | 1.0082 |
  226. | rw | 62073 | -33088 | 28985 | 29221 | 1.0081 |
  227. | stq | 52129 | -22705 | 29424 | 29636 | 1.0072 |
  228. | pap | 24882 | -10988 | 13894 | 13994 | 1.0072 |
  229. | fur | 47547 | -22578 | 24969 | 25147 | 1.0071 |
  230. | sq | 1675988 | -316178 | 1359810 | 1369080 | 1.0068 |
  231. | map-bms | 31840 | -14369 | 17471 | 17590 | 1.0068 |
  232. | nds-nl | 93602 | -36192 | 57410 | 57715 | 1.0053 |
  233. | my | 1364789 | -86169 | 1278620 | 1284064 | 1.0043 |
  234. | mdf | 12115 | -9151 | 2964 | 2975 | 1.0037 |
  235. | nv | 65012 | -25058 | 39954 | 40099 | 1.0036 |
  236. | kn | 6618786 | -155519 | 6463267 | 6483706 | 1.0032 |
  237. | mzn | 160447 | -45813 | 114634 | 114989 | 1.0031 |
  238. | bpy | 11911 | -4153 | 7758 | 7782 | 1.0031 |
  239. | su | 1294359 | -177221 | 1117138 | 1119375 | 1.0020 |
  240. | dv | 1499466 | -223694 | 1275772 | 1278010 | 1.0018 |
  241. | ps | 756368 | -136288 | 620080 | 621062 | 1.0016 |
  242. | ast | 1136414 | -162827 | 973587 | 974862 | 1.0013 |
  243. | mwl | 246717 | -25243 | 221474 | 221609 | 1.0006 |
  244. | na | 1910 | -1609 | 301 | 301 | 1.0000 |
  245. | nb | 10758 | 0 | 10758 | 10758 | 1.0000 |
  246. | bh | 2317 | -980 | 1337 | 1337 | 1.0000 |
  247. | tn | 3293 | -30 | 3263 | 3263 | 1.0000 |
  248. | roa-rup | 665 | -490 | 175 | 175 | 1.0000 |
  249. | ksh | 74483 | -33074 | 41409 | 41393 | 0.9996 |
  250. | ky | 2436742 | -371443 | 2065299 | 2064051 | 0.9994 |
  251. | to | 5783 | -2774 | 3009 | 3005 | 0.9987 |
  252. | fy | 747778 | -157586 | 590192 | 588282 | 0.9968 |
  253. | wuu | 86827 | -45678 | 41149 | 40728 | 0.9898 |
  254. | ha | 19091 | -9747 | 9344 | 9241 | 0.9890 |
  255. | ks | 4340 | -3888 | 452 | 442 | 0.9779 |
  256. | lez | 28953 | -16271 | 12682 | 12123 | 0.9559 |
  257. | myv | 30710 | -8546 | 22164 | 21141 | 0.9538 |
  258. | roa-tara | 115507 | -1008 | 114499 | 108973 | 0.9517 |
  259. | jbo | 46434 | -25061 | 21373 | 19600 | 0.9170 |
  260. | ny | 482 | -25 | 457 | 412 | 0.9015 |
  261. | nap | 41892 | -14708 | 27184 | 24450 | 0.8994 |
  262. | fj | 875 | -526 | 349 | 310 | 0.8883 |
  263. | zea | 15275 | -10469 | 4806 | 3786 | 0.7878 |
  264. | pdc | 15075 | -10412 | 4663 | 2845 | 0.6101 |
  265. | min | 9330 | -1492 | 7838 | 4040 | 0.5154 |
  266. | glk | 4592 | -5742 | -1150 | 142 | -0.1235 |
  267. | bxr | 0 | -5658 | -5658 | 2187 | -0.3865 |
  268. | kl | 11201 | -14493 | -3292 | 2394 | -0.7272 |
  269. | cbk-zam | 0 | -1980 | -1980 | 1650 | -0.8333 |
  270. | tyv | 0 | -2008 | -2008 | 2622 | -1.3058 |
  271. | got | 0 | 0 | 0 | 0 | NULL |
  272. +---------------+--------------+-----------------+--------------+-----------+---------+
  273. 255 rows in set (0.82 sec)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!