Database errors project (February 19th 2017)

Date: 19 Feb 2017 to 26 Feb 2017
Location: Worldwide
Surname/tag: data_doctors

Analysis was done on data from February 19th 2017.

Related post.

Here are pages of errors lists with basic person data and links to WikiTree.

Contents 1 News 1.1 Added possibility to see 1st generation tree according to dates for some errors 1.2 Added magic word IsInWikiData in search definition 1.3 Finished full support for Managers 2 Previous news 2.1 Updated a few Separators errors 2.2 AutoCorrect implemented 2.3 New error 566 Wikidata - Possible mother 2.4 New error 565 Wikidata - Possible duplicate by mother 2.5 New error 564 Wikidata - Possible father 2.6 New error 563 Wikidata - Possible duplicate by father 2.7 New error 570-590 FindAGrave errors 2.8 New error 418 Partner is also a sibling 2.9 New error 113 Duplicate in relatives 3 Errors 4 Changes since previous update

News

Added possibility to see 1st generation tree according to dates for some errors

Added possibility to see 1st generation tree according to dates for errors, that are relates to dates or relations. In Info column, there is a link Tree, that shows the tree. Errors with this link are 101, 102, 103, 104, 105, 111, 112, 113, 201, 202, 205, 206, 207, 208, 209, 210, 211, 301, 305, 306, 307, 308, 309, 310, 311, 401, 404, 405, 406, 407, 408, 409, 410, 411, 412, 413, 414, 415, 416, 417, 418, 911, 912. It may help understand relatives of a person. Those trees are all for profiles with errors, so they may look strange.

Example: https://plus.wikitree.com/findtree.htm?userid=3540972

Added magic word IsInWikiData in search definition

I added special magic word to search definition, so you can search for all profiles, that are in WikiData connected to WikiTree. you can combine that word with name, location, category or template. It its accessible on WikiTree+ in Group Search / All Wikitree,

Finished full support for Managers

Finished use of Manager table in error report. Now all managed profiles are shown for specific user. Before only first manager was checked. So you will have a few more errors on your managed lists. Also Search for profiles supports all managers. Prepared lists will be updated on next update.

Previous news

Updated a few Separators errors

I added ? and numbers to errors, since you can't save profile with number in these fields.

AutoCorrect implemented

Latest addition to correcting errors. With changes to MergeEdit page (WikitreeX) https://www.wikitree.com/g2g/347756/improvements-merge-edit-page-importing-information-wikitree we are now able to automate corections, where I will see it useful.

We will start with UTF errors, since they have clear correction. Later other corrections will be added. So errors 609. 639. 515, 525, 535, 545, 555, 565, 585 and 595 (Marriage location and LNAB are excluded, since automated edits don't work for them) can be corrected by by two clicks. They are also corrected all at once for profile being corrected.

How does process work: After you click Correct button, MergeEdit page opens with prefilled data, that needs to be changed. Those fields are already selected to be used. You must review them, you can also correct any field and bio as you see fit. Description of Edit action is also already filled. When you are satisfied with edits, press Correct button and changes will be saved.

If a profile was already edited since last dump you get red notification box when MergeEdit page opens. Probably autocorrection on the profile was already done or some other edit occurred on the profile. You can continue with the edit, but be extra careful of fields, that you are changing. You can also chose not to correct the profile at this time and do try it again next week with fresh data, if the error still exists.

If no changes were made to the profile Correct button is hidden.

When saving changes, profile is checked for some errors and must be corrected before saving.

For now Autocorrect is enabled only in prepared error lists. Later it will be added also to errors from WikiTree+.

Since this is all new, be alert to any wrong behavior, check profile after edit, change logs for actual changes,...

Also don't be too quick with edits. You can get automatically locked out as a spammer.

New error 566 Wikidata - Possible mother

This possible parent are derived from WikiData data. I am using mother relation from Wikidata and if mother has WikitreeID on wikidata it should be also connected as mother on WikiTree. If it is not, it is reported as this error and they should be connected on WikiTree. There are some exceptions where there is adoption in play or if profiles are not linked correctly to Wikidata.

New error 565 Wikidata - Possible duplicate by mother

This possible duplicates are derived from WikiData data. I am using mother relation from Wikidata and if mother has WikitreeID on wikidata it should be the same as mother on WikiTree. If it is not, it is reported as this error and this mothers are probably duplicated profiles on WikiTree. There are some exceptions where there is adoption in play or if profiles are not linked correctly to Wikidata. It is possible that also relatives are duplicated, so examine also them. In Info column is written WikiTreeID of the child being checked.

New error 564 Wikidata - Possible father

This possible parent are derived from WikiData data. I am using father relation from Wikidata and if father has WikitreeID on wikidata it should be also connected as father on WikiTree. If it is not, it is reported as this error and they should be connected on WikiTree. There are some exceptions where there is adoption in play or if profiles are not linked correctly to Wikidata.

New error 563 Wikidata - Possible duplicate by father

This possible duplicates are derived from WikiData data. I am using father relation from Wikidata and if father has WikitreeID on wikidata it should be the same as father on WikiTree. If it is not, it is reported as this error and this fathers are probably duplicated profiles on WikiTree. There are some exceptions where there is adoption in play or if profiles are not linked correctly to Wikidata. It is possible that also relatives are duplicated, so examine also them. In Info column is written WikiTreeID of the child being checked.

New error 570-590 FindAGrave errors

This is first group of errors connected to FindAGrave linking.

• 571 FindAGrave - Link without Grave ID: Lists all profiles that quote Findagrave, but don't have actual link to the profile on FindAGrave.
• 586 FindAGrave - Link to merged Grave ID: profile on FindAGrave, that is linked to was merged on FindAGrave.
• 587 FindAGrave - Link to non existing Grave ID: profile on FindAGrave, that is linked to doesn't exist.

New error 418 Partner is also a sibling

This error finds all profiles where spouse is also a sibling.

New error 113 Duplicate in relatives

This error finds all profiles where one person appears in 2 or more relations. It analyses parents, children and spouses. In info column there are relations to a duplicate person.

Errors

Analysis was done on data from February 5th 2017.

2305179 Errors	Total	0000-0000	0001-1499	1500-1699	1700-1799	1800-1899	1900-1999	2000-9999	Open	New
101 Birth in future	2							2
102 Death in future	76			1		1	69	5	5	2
103 Death before birth	9541		14	416	1118	4823	3116	54	7012	7
104 Too old	7655		279	1336	2487	3410	139	4	7054	25
105 Duplicate sibling	281			22	36	99	124		157	56
106 Duplicates between global tree and unconnected	818			113	279	313	113		645	84
109 Profile should be open (birth date)	12438		10	7	567	11854				114
110 Profile should be open (death date)	617	105			18	267	225	2		2
111 Died too young to be parent	467		36	56	51	184	134	6	361
112 Person is Father and mother	633	87	8	10	82	337	109		303	8
113 Duplicate in relatives	1107	267	125	50	124	454	87		535	60
201 Father is self	85	57				21	7
202 Parents are same	64	8				29	27		6	6
203 Father is Female	4609	657	23	158	687	2573	511		3360	86
204 Father has no Gender	497	401				80	16		8	4
205 Father is too young or not born	36483		1852	3749	7505	17206	6105	66	30810	138
206 Father is too old	4779		380	1069	1799	1525	6		4476	9
207 Father is also a child	174	65	14	2	17	63	13		67	12
208 Father is also a spouse	27	5	3		1	18			5
209 Father is also a sibling	1389	271	95	91	106	670	156		794	12
210 Father was dead before birth	36025	1535	2479	6538	10563	14208	702		33174	150
211 Duplicate sibling by father	462		2	91	126	187	56		330	25
212 Profile should be open (Child birth date)	2842	2842								6
301 Mother is self	1					1
303 Mother is Male	4817	538	46	212	778	2750	493		3411	42
304 Mother has no Gender	532	455				61	16		19	19
305 Mother too young or not born	46844		2308	4987	10826	21924	6731	68	40153	160
306 Mother is too old	3938		268	788	1425	1454	3		3649	17
307 Mother is also a child	6	1			1	3	1		3	1
308 Mother is also a spouse	260	64	45	11	29	102	9		119	15
309 Mother is also a sibling	123	23	1	1	6	73	19		49
310 Mother was dead before birth	40512	1838	1781	7457	12770	15941	724	1	37447	193
311 Duplicate sibling by mother	245		4	46	39	95	61		136	16
312 Profile should be open (Child birth date)	2260	2260								5
402 Unknown gender of spouse	669	477			2	167	23		19	11
403 Single sex marriage	827	225	13	25	27	466	71		223	23
404 Marriage before birth	7597		183	719	1715	3874	1105	1	6427	30
405 Married too old	1870		39	255	558	1018			1682	17
406 Marriage after death	9955	311	313	1411	2529	5057	334		8841	40
407 Lived too long after marriage	251	8	10	38	78	97	20		171
408 Multiple marriages on same day	3577	343	3	374	990	1743	124		3005	99
409 Marriage to duplicate person	11321	2485	95	971	2451	4937	382		8727	297
410 Marriage in future	5					5
411 Marriage End in future	1					1			1
412 Marriage End before marriage	129	2		5	18	96	8		91	1
413 Marriage too long	3					3			2	1
414 Marriage End before birth	144		1	6	8	75	54		90
415 Marriage End too old	63			4	22	37			58	7
416 Marriage End after death	3979	70	120	573	942	1996	278		3671	48
417 Lived too long after marriage End	11			1		8	2		8	1
418 Partner is also a sibling	487	30	35	56	122	233	11		416	2
501 Wrong gender (male)	3902	943	10	63	500	1973	409	4	1949	68
502 Missing gender (male)	17454	10630			2	2644	4163	15	42	57
503 Probably wrong gender (male)	5065	1246	42	449	602	2029	690	7	3248	44
504 Missing gender (probably male)	8855	5878		1	3	752	2188	33	148	41
505 Wrong gender (female)	4720	1036	2	81	356	2749	494	2	2507	58
506 Missing gender (female)	14189	9040			3	2499	2637	10	51	62
507 Probably wrong gender (female)	4644	735	19	182	583	2056	1068	1	3142	37
508 Missing gender (probably female)	7945	5445	5		3	725	1755	12	229	45
509 Missing gender	35939	26185	18	249	774	4112	4557	44	8186	204
510 Unique name without gender	10614	3998	10	61	217	3525	2755	48	4807	13
511 Unique names (spelling)	265311	48213	7632	12542	20325	101026	73958	1615	160117	1484
551 Wikidata - Missing gender	35					1	34
552 Wikidata - Different gender	7		1			2	4		3	3
553 Wikidata - Empty birth date	206	206							188	1
554 Wikidata - Imprecise birth date	641		132	195	191	96	27		574	7
555 Wikidata - Different birth date	3808		1778	905	451	511	163		3733	21
556 Wikidata - Empty death date	221	65	64	32	28	9	23		187	1
557 Wikidata - Imprecise death date	891	31	264	241	219	98	38		821	8
558 Wikidata - Different death date	4001	72	2363	691	360	425	90		3956	23
559 Wikidata - Missing birth location	1501	48	254	433	332	369	65		1410	9
561 Wikidata - Missing death location	1957	77	432	444	396	491	117		1869	46
563 Wikidata - Possible duplicate by father	129	11	45	31	17	17	8		121	3
564 Wikidata - Possible father	248	9	78	60	32	53	16		234	1
565 Wikidata - Possible duplicate by mother	110	7	50	23	22	8			105
566 Wikidata - Possible mother	202	9	85	50	21	30	7		192	1
568 Wikidata - Unconnected branches to global tree	4619	64	51	178	416	1759	2146	5	3417	29
569 Wikidata - Unconnected orphans to global tree	5484	28	53	120	525	2389	2368	1	4072	7
571 FindAGrave - Link without Grave ID	53231	653	26	756	5586	32290	13917	3	39913	171
586 FindAGrave - Link to merged Grave ID	703	17	1	47	133	368	137		601	2
587 FindAGrave - Link to nonexisting Grave ID	1042	25	1	84	221	522	188	1	864	1
601 Wrong word in birth location	6512	442		42	752	4147	1129		4792	38
602 Y birth location	1	1							1	1
604 Birth location too short	7039	908	41	865	976	3597	652		3887	43
605 Number in birth location	479	304				155	20		4	3
607 Misspelled word in birth location	7891	137	140	1160	2420	3553	481		6619	52
608 Misspelled country in birth location	16473	318	176	862	2845	10657	1615		13267	168
609 Wrong character in birth location	4647	195		645	2014	1699	94		3789
610 Birth location in uppercase	26265	200	551	1316	4025	16986	3187		23328	54
611 Birth location in lowercase	38280	955	208	917	7144	22961	6093	2	27909	102
631 Wrong word in death location	17687	360		5	1951	12619	2752		14869	178
632 Y death location	1166	14				1024	128		477	4
634 Death location too short	8040	658	130	683	1196	4449	924		5059	48
635 Number in death location	313	69			1	205	38		8	7
636 Bogus death location	319	4		2	153	159	1		289	3
637 Misspelled word in death location	1812	28	1	219	149	1080	335		1133	35
638 Misspelled country in death location	8291	294	83	329	511	5452	1622		6355	102
639 Wrong character in death location	3118	281	1	772	1254	717	93		2784
640 Death location in uppercase	16531	379	195	570	2333	10442	2612		14420	20
641 Death location in lowercase	23373	692	99	304	3606	13690	4980	2	16699	79
661 Wrong word in marriage location	1292	36	1	10	245	755	245		1017	3
664 Marriage location too short	2323	177	3	296	503	1225	119		1689	12
665 Number in marriage location	94	49			2	31	12		5	3
667 Misspelled word in marriage location	191	3		1	9	167	11		20	13
668 Misspelled country in marriage location	692	45	17	23	88	449	70		253	35
669 Wrong character in marriage location	913	47		296	431	137	2		860	2
670 Marriage location in uppercase	5172	120	134	240	866	3318	494		4684	6
671 Marriage location in lowercase	7238	237	30	254	1649	4405	663		5252	24
711 Separators in Prefix	886	76	9	13	10	398	378	2	322	7
712 Number in Prefix	855	39		9	3	648	156		626	3
713 Suffix in Prefix	2072	236	16	24	37	742	1013	4	772	16
714 Wrong word in Prefix	521	99	1	2	5	153	238	23	64	3
721 Separators in First Name	55216	12263	246	2124	5937	28636	6010		35365	117
722 Number in First Name	75	68				7
723 Prefix in First Name	22639	5719	2073	2469	3664	7074	1638	2	17591	69
724 Wrong word in First Name	7712	1948	76	383	797	2976	1531	1	5432	36
725 Wrong character in First Name	896	202		222	342	113	17		826
731 Separators in Preferred Name	16885	3337	78	82	124	1884	11296	84	827	70
732 Number in Preferred Name	38	31				1	6
733 Prefix in Preferred Name	7111	1535	212	198	254	773	4075	64	1395	30
734 Wrong word in Preferred Name	1831	552	3	16	14	122	1106	18	150	12
735 Wrong character in Preferred Name	1191	231	1	222	343	120	270	4	829
741 Separators in Middle Name	1340	94	1	60	96	816	273		984	12
742 Number in Middle Name	9					2	7
743 Prefix in Middle Name	2977	147	36	57	279	1892	566		2575	27
744 Wrong word in Middle Name	873	112	3	23	134	465	135	1	738	7
745 Wrong character in Middle Name	8	4	4						8
751 Separators in Nicknames	2743	121	329	295	344	1287	366	1	2430	20
752 Number in Nicknames	50	2			1	47			2	1
753 Prefix in Nicknames	3240	282	846	472	521	737	382		3025	19
754 Wrong word in Nicknames	1016	79	60	73	96	522	186		876	11
755 Wrong character in Nicknames	7	2	5						7
761 Separators in Suffix	7267	1158	167	808	1450	2311	1365	8	4880	27
762 Number in Suffix	1416	282		133	345	454	201	1	1003	11
763 Prefix in Suffix	8785	977	181	433	923	2029	4222	20	3275	55
764 Wrong word in Suffix	1208	78		77	130	481	435	7	568	5
765 Wrong character in Suffix	28	3				24	1
771 Separators in Last Name at Birth	5304	1045	77	854	1253	1396	671	8	3421	7
772 Number in Last Name at Birth	11	11
773 Prefix in Last Name at Birth	13	5		1	1		6		3
774 Wrong word in Last Name at Birth	10	4		5		1			10
775 Wrong character in Last Name at Birth	2032	401	19	387	517	356	350	2	1345	1
781 Separators in Current Last Name	1737	510	12	12	22	114	1059	8	105	8
782 Number in Current Last Name	11	11
783 Prefix in Current Last Name	12	4					8
784 Wrong word in Current Last Name	214	27	30	83	38	20	16		203
785 Wrong character in Current Last Name	1769	379	16	245	444	326	357	2	1075
791 Separators in Last Name Other	3841	209	194	458	604	1187	1188	1	2400	19
792 Number in Last Name Other	11	3				1	7		1	2
794 Wrong word in Last Name Other	475	70	21	74	66	119	123	2	302	8
795 Wrong character in Last Name Other	23	1	2	4		2	14		15
801 Big profile	321	3			50	137	131		245
802 Empty profile	86001	36577	1046	1647	6138	29192	11328	73	44879	222
803 Almost empty profile	26293	5346	746	1272	3610	10492	4790	37	19152	140
811 Uncleaned profile after merge	195470	13198	7271	26491	40863	79613	27903	131	142815	1391
821 Headings starts with blank	251	13	2	5	8	124	99		34	34
822 Heading doesn't end with =	12830	352	656	1417	2155	6300	1946	4	10917	150
823 Heading doesn't start with =	9960	543	103	493	1181	6158	1478	4	7691	109
824 Heading different number of =	2800	45	5	303	558	1458	431		2234	59
825 Use separator line ----	1603	30	7	93	320	1068	85		1309	6
831 Multiple duplicated lines	36240	608	234	1497	3065	25691	5145		24414	60
835 Local file reference	57454	4443	88	1356	6024	32089	13412	42	38101	546
841 Template doesn't start with double {	148	5	9	11	13	84	26		78	6
842 Template doesn't end with double }	111			3	21	67	20		86	14
843 Missing template (spelling)	2496	71	20	178	489	1100	622	16	1588	16
844 Out of use template	81	8					73
901 Unconnected empty public profiles	31190	31190								9
902 Unconnected empty open profiles	18674	18674							18674	89
911 Swedish patronym DOTTER for male	1				1				1
912 Swedish patronym SSON for female	667	1	4	12	173	477			554	7

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.