Database errors project (October 23 2016)

Profile

Images

Date: 23 Oct 2016 to 30 Oct 2016
Location: Worldwide

Surname/tag: data_doctors

Profile manager: Aleš Trtnik

[send private message]

This page has been accessed 1,208 times.

This page is part of the Data Doctors Project.

Latest report: May 12th 2024.

Data Doctors Challenge: Add_Existing_Connections_XIX and

Custom reports by: Suggestion lists, Unsourced lists, Unconnected lists.

See

for custom reports and statistics and our Video Collection.

Latest ProjectBox Report: Project Report

Latest Categories Report: Categories Suggestions Report

Analysis was done on data from October 23rd 2016.

News

New Error 831 831 Multiple duplicated lines

This error is added if whole line is repeated in biography. Line must be at least 40 letters long to be checked. Number of all repeated lines must be more than 10 to be an error. There are also some texts I excluded from checking (Lines beginning with :: Place:, :: Relationship to, Detail:(No detail, and Citation provides evidence for). I can add more if you think it is needed. In future we might make this rules more strict.

I excluded profiles with error 811.

Errors	Total	0000-0000	0001-1499	1500-1699	1700-1799	1800-1899	1900-1999	2000-Now	Now-9999	Open	New
831 Multiple duplicated lines	72235	1354	559	2969	7000	50707	9646			47561	72235

Updated 6x1 Wrong word in x location

I added Unicode errors for few Norwegian places (H2land, S2r, S2rum, Str2m, Tr2gstad), also added Age, Aged, Alive, HTTP and HTTPS as forbidden words. Unknown is also still checked with spelling variations. If you notice any other wrong words in Location field, let me know.

Errors	Total	0000-0000	0001-1499	1500-1699	1700-1799	1800-1899	1900-1999	Open	New
601 Wrong word in birth location	8011	923	3	171	1248	4470	1196	6083	809
631 Wrong word in death location	20617	807	2	211	3356	13217	3024	17621	7367
661 Wrong word in marriage location	1433	45		45	309	770	264	1134	273

Updated 6x5 Number in x location

I corrected algorithm to ignore some separators so also dates (01/02/2000, 01-10-2011) are added to error.

Errors	Total	0000-0000	1500-1699	1700-1799	1800-1899	1900-1999	Open	New
605 Number in birth location	598	364	2	11	196	25	61	68
635 Number in death location	361	75	4	6	235	41	32	30
665 Number in marriage location	110	52	1	4	41	12	14	98

Updated 104 Too old

I changed maximum allowed age from 115 to 110 years. I also automatically exclude profiles, that are in Centenarians or Supercentenarians category. So don't use False error. Add appropriate category. I will probably remove False error in the future. I will also lover the age to 100 in the future.

Errors	Total	0000-0000	0001-1499	1500-1699	1700-1799	1800-1899	1900-1999	2000-Now	Now-9999	Open	New
104 Too old	8043		294	1417	2640	3540	148	4		7384	2547

New 6x8 Misspelled country

I am checking for spelling of list of known countries. Country is entered as last word or words in location field. I prepared a list back in april, to identify location to a country. There are local and english version of a country. I added also some common variations like USA, United stated, United states of America, I also added some cities or regions without the country like Amsterdam, Derbyshire, Connecticut. When correcting those, you can of course also add the country. Some disambiguous misspelling will have two errors Like austraia could be Australia or Austria. List contains cca 450 names. If you find any errors in report, let me know. I expect there are some. I didn't expect that many errors, but here they are.

Errors	Total	0000-0000	0001-1499	1500-1699	1700-1799	1800-1899	1900-1999	2000-Now	Open	New
608 Misspelled country in birth location	28543	603	184	1703	5426	17245	3381	1	24220	28543
638 Misspelled country in death location	17746	524	118	1015	3189	10049	2851		14949	17746
668 Misspelled country in marriage location	5474	177	20	345	1364	3123	445		4749	5474

Previous news

Errors

Analysis was done on data from October 23rd 2016.

1444083 Errors	Total	0000-0000	0001-1499	1500-1699	1700-1799	1800-1899	1900-1999	2000-Now	Now-9999	Open	New
101 Birth in future	83								83
102 Death in future	75					7	64	4		2
103 Death before birth	12092		19	514	1328	5667	4491	73		9358	4
104 Too old	5518		223	972	1760	2507	52	4		5069	17
105 Duplicate sibling	601			25	69	255	252			396	45
106 Duplicates between global tree and unconnected	791		2	140	243	298	108			629	100
107 Full name in UPPERCASE	1751	860		4	1	324	545	17		30	1
108 Full name in lowercase	2740	2467			4	40	222	7		2	1
109 Profile should be open (birth date)	13320		4	4	1646	11666					95
110 Profile should be open (death date)	904	229		1	70	369	233	2			7
111 Died too young to be parent	486		35	58	56	191	138	8		370	2
112 Person is Father and mother	642	96	6	9	77	335	119			303	6
201 Father is self	92	57				24	11			2	2
202 Parents are same	79	9			11	26	33			23	2
203 Father is Female	4450	682	21	162	739	2335	511			3128	107
204 Father has no Gender	557	399			4	137	17			16	16
205 Father is too young or not born	39062		1926	4038	8191	17843	6973	77	14	32909	135
206 Father is too old	5662		408	1205	2110	1933	6			5326	12
207 Father is also a child	169	65	14	6	14	54	16			60	9
208 Father is also a spouse	29	4	3	1	3	18				12
209 Father is also a sibling	1443	281	96	127	87	706	146			816	36
210 Father was dead before birth	38657	1580	2554	7267	11367	15118	771			35516	152
211 Duplicate sibling by father	1460		2	130	352	856	120			1050	36
212 Profile should be open (Child birth date)	4266	4266									30
303 Mother is Male	5005	601	55	225	886	2736	502			3535	85
304 Mother has no Gender	604	486				98	20			34	20
305 Mother too young or not born	50088		2407	5446	11586	22923	7649	76	1	42876	183
306 Mother is too old	4639		282	908	1635	1808	6			4317	7
307 Mother is also a child	3					1	2
308 Mother is also a spouse	291	66	47	20	39	109	10			145	16
309 Mother is also a sibling	108	22	1	1	3	65	16			38
310 Mother was dead before birth	43384	1943	1852	8454	13564	16793	777	1		39923	222
311 Duplicate sibling by mother	410		4	36	74	239	57			265	10
312 Profile should be open (Child birth date)	3847	3847									19
401 Spouse is self	2	1				1
402 Unknown gender of spouse	708	489				191	28			13	6
403 Single sex marriage	1210	245	13	27	29	814	82			564	58
404 Marriage before birth	8866		198	808	1918	4293	1648	1		7545	37
405 Married too old	2167		54	300	633	1180				1954	9
406 Marriage after death	11346	473	332	1689	2818	5619	415			10058	46
407 Lived too long after marriage	424	10	11	61	122	191	29			326	3
408 Multiple marriages on same day	3924	421	6	488	1065	1814	130			3251	81
409 Marriage to duplicate person	12313	2967	106	1194	2501	5114	431			9449	218
501 Wrong gender (male)	4423	938	13	52	572	2388	458	2		2452	84
502 Missing gender (male)	55929	40524		1	21	8221	7144	17	1	7791	372
503 Probably wrong gender (male)	5009	1276	45	473	597	2024	584	10		3147	105
504 Missing gender (probably male)	28894	24681		1	100	1197	2873	42		910	312
505 Wrong gender (female)	6320	1165	3	172	411	3865	701	3		4055	53
506 Missing gender (female)	41462	31232		1	9	4518	5690	12		4495	361
507 Probably wrong gender (female)	4784	792	20	200	641	2049	1080	2		3196	67
508 Missing gender (probably female)	26587	21458	4	16	301	2553	2235	20		2659	259
509 Missing gender	100820	88403	18	328	1055	5504	5465	47		10240	871
510 Unique name without gender	20745	11186	11	131	323	5004	4032	58		7384	106
511 Unique names (spelling)	259395	48475	7662	12308	19959	98086	71391	1513	1	149204	1571
551 Wikidata - Missing gender	45	1				6	37	1
552 Wikidata - Different gender	8				2	2	4			3	1
553 Wikidata - Empty birth date	248	248								228	25
554 Wikidata - Imprecise birth date	3917		136	206	202	381	2965	27		924	51
555 Wikidata - Different birth date	3385		1675	760	366	442	141	1		3319	75
556 Wikidata - Empty death date	300	111	56	28	24	47	34			259	24
557 Wikidata - Imprecise death date	1315	34	257	227	218	379	200			1115	26
558 Wikidata - Different death date	3745	73	2275	579	312	406	100			3698	66
559 Wikidata - Missing birth location	1488	36	188	346	316	461	141			1430	2
561 Wikidata - Missing death location	2301	77	411	424	438	711	240			2213	11
601 Unknown birth location	7236	872			1058	4142	1164			5475	34
604 Birth location too short	7307	1068	42	907	1032	3619	639			3843	86
605 Number in birth location	539	343			6	171	19			23	9
606 Bogus birth location	5				1	4				2
607 Misspelled word in birth location	11013	188	212	1771	3375	4854	613			9534	116
631 Unknown death location	13327	612		1	2140	8805	1769			11640	77
632 Y death location	1092	24				993	75
634 Death location too short	8158	700	134	715	1258	4461	890			4789	48
635 Number in death location	341	68		4	6	226	37			23	10
636 Bogus death location	615	4	6	224	243	137	1			589
637 Misspelled word in death location	5373	135	136	854	1346	2274	628			4575	48
661 Unknown marriage location	1167	34		1	241	634	257			925	6
664 Marriage location too short	2440	189	1	305	524	1311	110			1714	11
665 Number in marriage location	13	1			1	9	2			3	2
667 Misspelled word in marriage location	1362	5		81	607	652	17			1147	18
711 Separators in Prefix	1044	82	9	73	34	479	366	1		461	10
712 Number in Prefix	1105	38		11	81	831	144			893	2
713 Suffix in Prefix	2546	313	45	38	400	829	919	2		1323	63
714 Wrong word in Prefix	924	235	3	6	59	308	289	24		449	1
721 Separators in First Name	48894	8031	239	2102	5660	27309	5553			32481	113
722 Number in First Name	92	83	2			7				16
723 Prefix in First Name	23780	6091	2130	2768	4042	7114	1633	2		18473	46
724 Wrong word in First Name	7714	2001	79	409	830	2946	1448	1		5339	17
731 Separators in Preferred Name	14666	2377	74	74	104	1784	10186	67		694	358
732 Number in Preferred Name	37	30				1	6
733 Prefix in Preferred Name	7039	1557	221	214	267	794	3925	61		1479	372
734 Wrong word in Preferred Name	1797	547	6	17	16	122	1073	16		160	10
741 Separators in Middle Name	1325	101	1	65	95	800	263			970	9
742 Number in Middle Name	9					2	7
743 Prefix in Middle Name	2906	155	39	67	277	1828	540			2463	42
744 Wrong word in Middle Name	858	112	3	22	133	466	121	1		726	4
751 Separators in Nicknames	2614	108	323	293	326	1229	334	1		2273	29
752 Number in Nicknames	144	4		2	35	103				93
753 Prefix in Nicknames	3186	285	868	463	534	705	331			2970	29
754 Wrong word in Nicknames	1015	80	65	90	94	512	174			871	19
761 Separators in Suffix	7724	1195	179	981	1672	2343	1346	8		5264	28
762 Number in Suffix	1446	283		125	396	445	196	1		1025	8
763 Prefix in Suffix	8700	969	187	489	993	2046	4000	16		3366	90
764 Wrong word in Suffix	1311	85	3	142	147	482	446	6		665	7
771 Separators in Last Name at Birth	4856	837	78	812	1179	1345	597	8		3219	6
772 Number in Last Name at Birth	10	10
773 Prefix in Last Name at Birth	15	5		2	2		6			4
774 Wrong word in Last Name at Birth	13	6		5	1	1				13
781 Separators in Current Last Name	6505	1255	112	838	1236	1892	1164	8		4094	19
782 Number in Current Last Name	10	10
783 Prefix in Current Last Name	14	5				1	8
784 Wrong word in Current Last Name	272	38	44	105	40	28	17			261	4
791 Separators in Last Name Other	4714	259	196	897	1059	1164	1136	2	1	3198	31
792 Number in Last Name Other	9	3				1	5			1	1
794 Wrong word in Last Name Other	501	76	25	90	65	122	121	2		334	5
801 Big profile	281	3			11	126	141			198
802 Empty profile	84276	34784	1057	1755	6423	29179	11006	72		41349
803 Almost empty profile	15804	3406	638	743	1907	6137	2960	13		10785
811 Uncleaned profile after merge	193988	13318	7392	29478	42505	76159	25013	123		143092
821 Headings starts with blank	2678	31	52	315	556	1442	282			2429
901 Unconnected empty public profiles	35607	35607									35
902 Unconnected empty open profiles	17991	17991								17991	104
911 Swedish patronym DOTTER for male	9			1	2	6				6
912 Swedish patronym SSON for female	1026	1	20	92	589	324				947	7

Changes since previous update

Detailed statistics are available on https://plus.wikitree.com/default.htm in Statistics section.

News on Database errors project (23 October 2016) Oct 24, 2016.

Collaboration

Login to edit this profile and add images.
Private Messages: Send a private message to the Profile Manager. (Best when privacy is an issue.)
Public Comments: Login to post. (Best for messages specifically directed to those editing this profile. Limit 20 per day.)