Stats project all

Appears in the following schemas:

• sf0103
• sf1104
• sf1204
• sf0205
• sf0305
• sf0405
• sf0505
• sf0605
• sf0705
• sf0805
• sf0905
• sf1005
• sf1105
• sf1205
• sf0106
• sf0206
• sf0306
• sf0406
• sf0506
• sf0606
• sf0706
• sf0806
• sf0906
• sf1006
• sf1106
• sf1206
• sf0107
• sf0207
• sf0307
• sf0407
• sf0507
• sf0607
• sf0707
• sf0807
• sf0907
• sf1007
• sf1107
• sf1207
• sf0108
• sf0208
• sf0308
• sf0408
• sf0508
• sf0608
• sf0708
• sf0808
• sf0908
• sf1008
• sf1108
• sf1208
• sf0109
• sf0209
• sf0309
• sf0409
• sf0509
• sf0609
• sf0709
• sf0809
• sf0909
• sf1009
• sf1109
• sf1209
• sf0110
• sf0210
• sf0310
• sf0410
• sf0510
• sf0610
• sf0710
• sf0810
• sf0910
• sf1010
• sf1110
• sf1210
• sf0111
• sf0211
• sf0311
• sf0411
• sf0511
• sf0611
• sf0711
• sf0811
• sf0911
• sf1011
• sf1111
• sf1211
• sf0112
• sf0212
• sf0312
• sf0412
• sf0512
• sf0612
• sf0712
• sf0812
• sf0912
• sf1012
• sf1112
• sf1212
• sf0113
• sf0213
• sf0813
• sf0913
• sf1013
• sf1113
• sf1213
• sf0114
• sf0214
• sf0314
• sf0514
• sf0614
• sf0714
• sf0814
• sf0914

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