Database errors project (February 26th 2017)

Date: 26 Feb 2017 to 5 Mar 2017
Location: Worldwide

Surname/tag: data_doctors

Profile manager: Aleš Trtnik

[send private message]

This page has been accessed 1,060 times.

This page is part of the Data Doctors Project.

Latest report: January 12th 2025.

Data Doctors Challenge: Add_Existing_Connections_XXIV 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 February 26th 2017.

News

Updated tree display

Years scale on left and right is now showing actual years.

Birth and death years on the person didn't display correctly on years before 1000.

Added magic words 0cen, 1cen, ... 20cen, 21cen IsInWikiData in search definition

I added special magic words to search definition, so you can search for profiles with birth in any century. 0cen is for profiles with unknown birth date. If any of relatives has birth date set, estimation is made for birth date, so even profiles without dates are in apropriate century. You can combine that word with name, location, category or template. It its accessible on WikiTree+ in Group Search / All Wikitree,

Added possibility to see 1st generation tree according to dates for all errors and in search results

Added possibility to see 1st generation tree according to dates. Next to Wikitree link is a link Tree, that shows the tree. It may help understand relatives of a person.

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

Previous news

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.

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 26th 2017.

2306883 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	73					1	67	5	2	2
103 Death before birth	9096		13	410	1113	4808	2698	54	6585	9
104 Too old	7612		260	1327	2479	3404	138	4	7012	31
105 Duplicate sibling	277			28	41	87	121		157	42
106 Duplicates between global tree and unconnected	845		1	115	268	338	123		651	114
109 Profile should be open (birth date)	12284		11	7	557	11709				92
110 Profile should be open (death date)	616	107			20	264	223	2		5
111 Died too young to be parent	467		36	56	50	186	134	5	361	2
112 Person is Father and mother	632	87	8	10	84	336	107		308	7
113 Duplicate in relatives	1088	262	125	44	122	451	84		536	47
201 Father is self	86	57				22	7		1	1
202 Parents are same	53	5				24	24		5
203 Father is Female	4606	646	23	159	687	2580	511		3372	22
204 Father has no Gender	505	403				85	17		16	10
205 Father is too young or not born	36113		1843	3726	7500	17149	5829	66	30499	131
206 Father is too old	4623		382	1062	1777	1397	5		4330	12
207 Father is also a child	160	54	14	2	17	62	11		66	4
208 Father is also a spouse	28	4	3		1	20			7	1
209 Father is also a sibling	1421	271	95	88	114	698	155		830	49
210 Father was dead before birth	35806	1525	2471	6510	10509	14107	684		32991	145
211 Duplicate sibling by father	469		2	93	125	189	60		343	37
212 Profile should be open (Child birth date)	2833	2833								9
301 Mother is self	1					1
303 Mother is Male	4801	541	46	210	780	2745	479		3421	26
304 Mother has no Gender	522	439				66	17		9	10
305 Mother too young or not born	46502		2302	4976	10792	21881	6483	68	39898	187
306 Mother is too old	3808		263	783	1412	1347	3		3525	9
307 Mother is also a child	6	1			1	3	1		3	1
308 Mother is also a spouse	256	62	45	9	29	102	9		120	18
309 Mother is also a sibling	124	23	1	2	6	73	19		50	2
310 Mother was dead before birth	40216	1827	1775	7414	12667	15826	706	1	37190	185
311 Duplicate sibling by mother	173		4	46	33	56	34		126	20
312 Profile should be open (Child birth date)	2259	2259								12
402 Unknown gender of spouse	678	474				175	29		31	24
403 Single sex marriage	841	225	13	24	29	474	76		243	26
404 Marriage before birth	7457		180	710	1709	3853	1004	1	6298	25
405 Married too old	1874		40	255	557	1022			1690	7
406 Marriage after death	9939	310	313	1408	2526	5059	323		8830	49
407 Lived too long after marriage	250	8	10	38	76	98	20		170	3
408 Multiple marriages on same day	3587	345	3	376	985	1753	125		3018	110
409 Marriage to duplicate person	11292	2466	95	978	2435	4952	366		8731	279
410 Marriage in future	5					5
412 Marriage End before marriage	128			5	18	97	8		89	6
413 Marriage too long	2					2			1
414 Marriage End before birth	135		1	6	8	69	51		81	6
415 Marriage End too old	60			4	22	34			55	1
416 Marriage End after death	3985	70	121	576	937	2004	277		3679	39
417 Lived too long after marriage End	6					4	2		3	3
418 Partner is also a sibling	471	30	35	47	118	230	11		400	2
501 Wrong gender (male)	4158	1069	11	77	511	2012	474	4	2060	283
502 Missing gender (male)	17582	10719		1	1	2648	4198	15	76	189
503 Probably wrong gender (male)	4913	1128	43	436	595	2032	672	7	3212	76
504 Missing gender (probably male)	8779	5838		1	3	743	2161	33	162	67
505 Wrong gender (female)	4625	1023	2	79	343	2686	490	2	2432	42
506 Missing gender (female)	14184	9069			4	2472	2629	10	49	83
507 Probably wrong gender (female)	4639	730	19	180	582	2057	1070	1	3150	40
508 Missing gender (probably female)	7910	5448	5		4	683	1758	12	204	59
509 Missing gender	36045	26279	18	252	776	4133	4543	44	8231	221
510 Unique name without gender	10526	3994	10	59	216	3461	2738	48	4741	32
511 Unique names (spelling)	265165	48097	7587	12466	20281	101144	73970	1620	160523	1599
551 Wikidata - Missing gender	35					1	34
552 Wikidata - Different gender	5		1			1	3		2	1
553 Wikidata - Empty birth date	199	199							182	1
554 Wikidata - Imprecise birth date	650		133	196	192	101	28		583	12
555 Wikidata - Different birth date	3797		1764	906	454	512	161		3721	33
556 Wikidata - Empty death date	220	65	61	32	29	10	23		187	4
557 Wikidata - Imprecise death date	902	33	264	240	220	105	40		832	15
558 Wikidata - Different death date	4008	64	2360	699	362	431	92		3963	36
559 Wikidata - Missing birth location	1507	48	250	439	336	368	66		1415	29
561 Wikidata - Missing death location	1973	76	431	449	403	493	121		1884	38
563 Wikidata - Possible duplicate by father	82	10	21	12	17	15	7		75	4
564 Wikidata - Possible father	250	7	79	60	33	55	16		236	6
565 Wikidata - Possible duplicate by mother	108	6	50	22	22	8			104
566 Wikidata - Possible mother	200	10	84	49	22	28	7		191	3
568 Wikidata - Unconnected branches to global tree	4690	64	51	178	427	1789	2176	5	3481	83
569 Wikidata - Unconnected orphans to global tree	5515	27	53	121	527	2410	2376	1	4108	42
571 FindAGrave - Link without Grave ID	53223	654	26	746	5550	32295	13949	3	39932	238
586 FindAGrave - Link to merged Grave ID	698	17	1	47	128	371	134		596	6
587 FindAGrave - Link to nonexisting Grave ID	1029	24	1	83	214	517	189	1	852	5
601 Wrong word in birth location	6542	443	1	44	761	4157	1136		4854	41
604 Birth location too short	7014	909	41	853	965	3584	662		3878	65
605 Number in birth location	482	307				155	20		11	4
607 Misspelled word in birth location	7939	137	140	1159	2448	3570	485		6675	93
608 Misspelled country in birth location	16453	315	176	856	2864	10611	1631		13262	157
609 Wrong character in birth location	5216	290	2	660	2277	1901	86		4282
610 Birth location in uppercase	25999	201	551	1310	3974	16809	3154		23114	92
611 Birth location in lowercase	38230	953	208	914	7102	22958	6093	2	27872	91
631 Wrong word in death location	17711	363		9	1957	12622	2760		14930	119
632 Y death location	1026	14				900	112		337	5
634 Death location too short	7927	652	128	685	1200	4350	912		4961	70
635 Number in death location	313	70		1	1	202	39		14	11
636 Bogus death location	318	4		2	152	159	1		289
637 Misspelled word in death location	1750	28	1	215	158	1024	324		1076	44
638 Misspelled country in death location	8110	293	84	324	519	5296	1594		6187	107
639 Wrong character in death location	3370	260	4	787	1395	829	95		2986
640 Death location in uppercase	16383	375	194	568	2294	10358	2594		14307	46
641 Death location in lowercase	23352	691	98	301	3587	13700	4973	2	16689	84
661 Wrong word in marriage location	1292	36	1	9	244	756	246		1018	5
664 Marriage location too short	2329	172	3	296	501	1236	121		1700	25
665 Number in marriage location	90	49				31	10		1	1
667 Misspelled word in marriage location	189	4		2	8	166	9		19	15
668 Misspelled country in marriage location	555	31	4	9	34	415	62		121	45
669 Wrong character in marriage location	959	64		283	432	176	4		882
670 Marriage location in uppercase	5146	114	135	239	855	3312	491		4680	14
671 Marriage location in lowercase	7228	236	29	253	1636	4412	662		5245	28
711 Separators in Prefix	887	77	9	13	10	401	375	2	322	6
712 Number in Prefix	858	39		9	3	648	159		627	3
713 Suffix in Prefix	2103	241	16	24	42	753	1023	4	792	33
714 Wrong word in Prefix	525	100	1	2	5	155	239	23	68	6
721 Separators in First Name	55170	12217	244	2100	5913	28650	6046		35477	248
722 Number in First Name	74	68				6
723 Prefix in First Name	22634	5705	2059	2454	3671	7103	1640	2	17620	74
724 Wrong word in First Name	7719	1943	76	384	800	2977	1538	1	5451	33
725 Wrong character in First Name	925	202	5	245	303	142	28		824	37
731 Separators in Preferred Name	16891	3336	78	81	127	1891	11294	84	834	59
732 Number in Preferred Name	38	31				1	6
733 Prefix in Preferred Name	7133	1540	210	198	252	775	4094	64	1391	37
734 Wrong word in Preferred Name	1835	551	3	15	14	122	1112	18	146	13
735 Wrong character in Preferred Name	1274	245	5	245	304	151	320	4	827	37
741 Separators in Middle Name	1342	94	1	62	96	816	273		986	11
742 Number in Middle Name	8					2	6
743 Prefix in Middle Name	2991	145	36	57	279	1907	567		2588	29
744 Wrong word in Middle Name	870	112	3	23	135	463	133	1	736	3
745 Wrong character in Middle Name	11	3	2	1	2	3			11
751 Separators in Nicknames	2752	123	327	293	346	1287	375	1	2438	25
752 Number in Nicknames	49	2			1	46			1
753 Prefix in Nicknames	3251	281	846	475	521	743	385		3036	26
754 Wrong word in Nicknames	1014	80	57	72	97	523	185		875	6
755 Wrong character in Nicknames	4		4						4
761 Separators in Suffix	7223	1154	162	788	1440	2305	1366	8	4835	17
762 Number in Suffix	1419	281		133	339	464	201	1	1006	16
763 Prefix in Suffix	8642	933	146	389	911	2014	4229	20	3121	41
764 Wrong word in Suffix	1198	78		75	127	476	435	7	556	2
765 Wrong character in Suffix	28	3				24	1
771 Separators in Last Name at Birth	5306	1043	77	852	1251	1401	674	8	3421	9
772 Number in Last Name at Birth	11	11
773 Prefix in Last Name at Birth	11	4			1		6		1
774 Wrong word in Last Name at Birth	10	4		5		1			10
775 Wrong character in Last Name at Birth	2233	465	22	407	547	389	400	3	1450	2
781 Separators in Current Last Name	1741	510	13	12	22	115	1061	8	106	7
782 Number in Current Last Name	11	11
783 Prefix in Current Last Name	12	4					8
784 Wrong word in Current Last Name	212	27	30	83	38	18	16		201
785 Wrong character in Current Last Name	1897	429	19	224	459	355	408	3	1108	3
791 Separators in Last Name Other	3849	209	194	459	600	1195	1191	1	2411	26
792 Number in Last Name Other	11	3				1	7		1
794 Wrong word in Last Name Other	477	70	20	76	66	119	124	2	303	3
795 Wrong character in Last Name Other	41	1	2	8	4	7	18	1	26
801 Big profile	319	3			50	137	129		243
802 Empty profile	86038	36675	1034	1633	6101	29198	11324	73	45129	256
803 Almost empty profile	26271	5363	746	1261	3614	10487	4763	37	19129	140
811 Uncleaned profile after merge	195458	13206	7252	26356	40710	79763	28038	133	142863	1247
821 Headings starts with blank	254	13	1	3	11	128	98		36	38
822 Heading doesn't end with =	12751	352	655	1401	2125	6277	1937	4	10824	165
823 Heading doesn't start with =	9869	543	103	479	1162	6114	1464	4	7674	75
824 Heading different number of =	2765	48	4	298	549	1443	423		2204	45
825 Use separator line ----	1600	30	7	92	329	1070	72		1307	17
831 Multiple duplicated lines	36247	608	234	1495	3065	25701	5144		25802	79
835 Local file reference	57812	4441	88	1354	6027	32369	13491	42	38276	538
841 Template doesn't start with double {	147	5	9	11	13	81	28		76	8
842 Template doesn't end with double }	63				5	40	18		39	12
843 Missing template (spelling)	2437	69	20	163	472	1071	626	16	1527	32
844 Out of use template	81	8					73
901 Unconnected empty public profiles	30943	30943								28
902 Unconnected empty open profiles	18704	18704							18704	65
911 Swedish patronym DOTTER for male	1				1				1
912 Swedish patronym SSON for female	656	1	4	8	161	482			546	12

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.

News on Database errors project (February 26th 2017) Feb 28, 2017.

Images: 1

1 generation tree.

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.)

Comments: 10

Leave a message for others who see this profile.

Aleš Trtnik

Joyce, I fixed it.

posted Mar 04, 2017 by Aleš Trtnik

Joyce (Wolfe) Reinig

I placed a name in the wrong place and now I can't find how to get rid of it. I listed Maggie (Bastasch) Bastasch #2) as mother of Michael Reinig. She should be wife. How do I correct this? Thanks. J Reinig (Wolfe # 2456)

posted Mar 04, 2017 by Joyce (Wolfe) Reinig