Stats project all

From Open Source Software Research
Jump to: navigation, search

Appears in the following schemas:

Most Recent Description

Table "sf0914.stats_project_all"
Column Type Modifiers
group_id integer
developers integer
group_ranking integer
group_metric double precision
logo_showings integer
downloads integer
site_views integer
subdomain_views integer
page_views integer
msg_posted integer
msg_uniq_auth integer
bugs_opened integer
bugs_closed integer
support_opened integer
support_closed integer
patches_opened integer
patches_closed integer
artifacts_opened integer
artifacts_closed integer
tasks_opened integer
tasks_closed integer
help_requests integer
cvs_checkouts integer
cvs_commits integer
cvs_adds integer
svn_checkouts integer
svn_commits integer
svn_adds integer


Other Information About the Data

It appears that none of this data has been changed since sf0205, except since sf0607 when entries have been removed from this table. This data should not be trusted after February 2005 (and possibly not for that month either). For correct download data (for the past two years or so) you will need to query stats groupid alltime agg. For correct developers data, you will need to query user group. The table stats groupid alltime agg seems not to be accurate since sf0109.

probed by Acapiluppi

Table "sf0112.stats_project_all WHERE 1=1 limit 10"
142 7 643 82.4224560215543 585525 153237 78141 25859 102595 305 6 216 176 23 20 260 206 3 3 1 436 5980 738
129 1 2037 78.7368520424548 559537 3299 55358 1470455 1481782 3837 29 65 26 32 6 1 106 27 3 0 0
120 11 1003 78.9383690220088 135710 206482 2036847 2207199 10 2 16 16 2 2 20 20 38 38 1711 4367 216
119 25 2366 71.7183951329814 1374 16249 41141 422948 460677 8 2 31 26 1 4 1 40 31 26 28 766 1865 204
107 8 5563 50.0795845421445 3734011 6042 47042 388569 431678 254 254 256 255 11 12 303 2053 243
106 1 8384 23.6791209536097 2508 2445 96 504 4 0 0
103 13 277 93.2460775461849 4866585 97134 444396 225906 666941 2 2 1031 821 1 1 354 237 1544 1096 2845 6634 1232
102 4 5115 42.8275822133558 68151 18736 8033 140314 124019 56 3 26 17 1 28 17 66 1666 376
99 2 9218 21.2972533624231 4543 2352 4692 13672 16690 1 1 1 1 2 2 6 0 0
93 2 5792 43.6291171574697 37359 4078 6736 8368 12715 4 4 80 2579 1581