User:Pathoschild/2008 crosswiki babelboxes

This page examines the standard levels used crosswiki. This is based on an exclusive query that matches the vast majority of language templates without matching userboxes, to mitigate the need for manual filtering.

The percentages estimate the percentage of languages with that level, based on the assumption that the level with the highest number of languages supporting it includes all languages.

MetaWiki

Standardized, all languages use N and 1–3.

Wikipedia

Top 10

The average level coverage for the top 10 Wikipedias (de, en, es, fr, it, ja, nl, pl, pt, sv):

lvl	histogram	%
N	******************	93.1%
0	******	29.1%
1	******************	94.5%
2	*****************	83.9%
3	*****************	82.9%
4	********	38.3%
5	*	7.4%
6		1%
7		—

de/German

lvl	histogram	count	%
N	***************	152	87%
0		2	1%
1	*****************	174	100%
2	****************	157	90%
3	***************	154	89%
4	*************	125	72%
5		0	—
6		0	—
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^User_[a-z][a-z][a-z]?(-N)?$' LIMIT 5000;

en/English

lvl	histogram	count	%
N	******************************************	415	100%
0	***************	153	37%
1	******************************	297	72%
2	***************************	272	66%
3	****************************	278	67%
4	***********************	230	55%
5	******	60	14%
6		2	—
7		1	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^User_[a-z][a-z]?[a-z](-N)?$' LIMIT 5000;

es/Spanish

lvl	histogram	count	%
N	********	83	98%
0	*	6	7%
1	*********	85	100%
2	********	80	94%
3	********	81	95%
4	****	43	51%
5	*	8	9%
6		0	—
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^·Usuarios_por_idioma_\\([a-z][a-z][a-z]?(-N)?\\)$' LIMIT 5000;

fr/French

lvl	histogram	count	%
N	******************	182	100%
0	*****************	174	96%
1	*****************	168	92%
2	***************	154	85%
3	***************	152	84%
4	***********	111	61%
5	*	14	8%
6		0	—
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^Utilisateur_[a-z][a-z]?[a-z](-N)?$' LIMIT 5000;

it/Italian

lvl	histogram	count	%
N	**********	98	81%
0	**	18	15%
1	************	121	100%
2	**********	104	86%
3	**********	98	81%
4	****	39	32%
5		1	1%
6		1	1%
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^User_[a-z][a-z][a-z]?(-N)?$' LIMIT 5000;

ja/Japanese

lvl	histogram	count	%
N	*********	94	85%
0	***	27	24%
1	***********	111	100%
2	**********	100	90%
3	**********	100	90%
4	**	19	17%
5		0	—
6		0	—
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^User_[a-z][a-z][a-z]?(-N)?$' LIMIT 5000;

ms/Malay

lvl	histogram	count	%
N	***	27	100%
0	**	22	81%
1	**	24	89%
2	**	19	70%
3	**	16	59%
4	*	14	52%
5	*	6	22%
6		0	—
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^Pengguna_[a-z][a-z][a-z]?(-N)?$' LIMIT 5000;

nl/Dutch

lvl	histogram	count	%
N	*******	70	84%
0	*	12	14%
1	********	83	100%
2	*******	67	81%
3	******	61	73%
4	***	32	39%
5		2	2%
6		0	—
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^Gebruiker_[a-z][a-z][a-z]?(-N)?$' LIMIT 5000;

pl/Polish

lvl	histogram	count	%
N	*********	89	100%
0		2	2%
1	********	77	87%
2	********	76	85%
3	********	76	85%
4	**	21	24%
5		0	—
6		0	—
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^User_[a-z][a-z][a-z]?(-N)?$' LIMIT 5000;

pt/Portuguese

lvl	histogram	count	%
N	********	82	96%
0		1	1%
1	*********	85	100%
2	********	80	94%
3	********	80	94%
4		0	—
5		0	—
6		0	—
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^User_[a-z][a-z][a-z]?(-N)?$';

sv/Swedish

lvl	histogram	count	%
N	*******	68	100%
0	**	16	24%
1	******	64	94%
2	*****	46	68%
3	*****	48	71%
4	**	22	32%
5		1	1%
6		1	1%
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^Användare_[a-z][a-z][a-z]?(-N)?$';

th/Thai

lvl	histogram	count	%
N	***	25	51%
0	*	6	12%
1	*****	49	100%
2	***	26	53%
3	**	19	39%
4	*	5	10%
5		0	—
6		0	—
7		0	—

SELECT COUNT(*) FROM page WHERE page_namespace=10 AND page_is_redirect=0 AND page_title REGEXP '^User_[a-z][a-z][a-z]?(-N)?$' LIMIT 5000;