Database errors project (May 14th 2017)

Profile

Images

Date: 14 May 2017 to 21 May 2017
Location: Worldwide

Surname/tag: data_doctors

Profile manager: Aleš Trtnik

[send private message]

This page has been accessed 902 times.

This page is part of the Data Doctors Project.

Latest report: April 21st 2024.

Data Doctors Challenge: Connect-a-Thon_Cleanup_II 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 May 14th 2017.

News

Previous news

New link to error report

Chris added new link to errors on profiles, that user maneges. It is located in My wikitree menu, fifth item Error report. This is most useful link to see errors on your profiles.

Statistics of Lists By

On WikiTree+ I added statistics on total number of error for each group, that I prepare specialised lists for. They have only one value for now, but trends will be visible in time.

Location Find and Replace

I changed the function, so it compares end of location text with Find text. And it replaces only the found part. Before whole text had to match.

When making a change, I also added reformatting of the string. I remove all double spaces, all spaces before each comma and dot, and add single space after each comma and dot. Exception is dot and comma together ".,", where I don't add space between them.

I also removed the Maximum number of profiles.

For those who missed initial announcement, here is the old news: I added new possibility to replace one text in location into another. It uses Automatically suggested corrections. It is available on Wikitree+ in Search section Replace Location item.

Example to change Virginia, British Colonial America to Virginia Colony. [1]

Prepared error lists By...

I made error lists we used during Clean-A-Thon as part of weekly update. Here is central navigation page for prepared error lists: Space:DBE_Errors_By. I will add all lists here.

I prepared errors for all US states and some countries, that were used during CAT. Also for some projects are prepared lists. I am still not sure about naming project pages. US states will be named with 2 letter code. DBE_ErrorList_XX You can put any table on any page you want like {{:DBE_ErrorList_ME}}. It will be updated automatically on all pages where this is used. For other countries 3 letter code is used. For projects, I didn't decide jet.

There may also be some errors shown, that don't belong to that country. If you find a few of them, let me know, so I can try to find the pattern and improve error selection. I didn't check the lists. It is a lot of them. I know that West Virginia errors are shown also in Virginia error report. For other I don't know.

Public profiles opened

As some of you already noticed, 600000 public profiiles were opened last week. That enables you to correct many errors, that coulcn't be corrected before.

Find And Replace

I added new possibility to replace one text in location into another. It uses Automatically suggested corrections. It is available on Wikitree+ in Search section Replace Location item.

Example to change Virginia, British Colonial America to Virginia Colony. [2]

Errors

Analysis was done on data from May 14th 2017.

2119662 Errors	Total	0000-0000	0001-1499	1500-1699	1700-1799	1800-1899	1900-1999	2000-9999	Open	New
101 Birth in future	6							6	2	2
102 Death in future	68						61	7	3	2
103 Death before birth	7055		5	280	931	4028	1762	49	5727	10
104 Too old	7332		234	1249	2397	3319	129	4	7033	24
105 Duplicate sibling	259			27	33	87	112		179	55
106 Duplicates between global tree and unconnected	786			77	264	310	135		650	99
109 Profile should be open (birth date)	754		2	18	432	302				11
110 Profile should be open (death date)	264			8	32	44	179	1		2
111 Died too young to be parent	421		27	55	37	171	127	4	363	2
112 Person is Father and mother	585	71	1	2	57	340	114		350	12
113 Duplicate in relatives	1069	245	107	33	139	458	87		697	69
114 Still living status and entered death date	1774	157		2	10	342	1257	6	104	31
115 Still living status and entered death location	194	12			12	72	98		64	17
201 Father is self	80	57				16	7		7
202 Parents are same	61	4			9	24	24		17	8
203 Father is Female	3999	546	1	82	406	2443	521		3197	52
204 Father has no Gender	485	396			1	76	12		50	14
205 Father is too young or not born	34647		1745	3470	7246	16704	5418	64	31237	114
206 Father is too old	3875		356	924	1510	1080	5		3798	11
207 Father is also a child	150	66	12	5	4	49	14		66	5
208 Father is also a spouse	26	8			2	14	2		14	5
209 Father is also a sibling	1311	246	85	66	118	629	167		877	24
210 Father was dead before birth	33899	1422	2359	6098	9946	13429	645		33413	144
211 Duplicate sibling by father	354		1	78	89	114	72		275	32
212 Profile should be open (Child birth date)	2764	2764								12
301 Mother is self	1					1
303 Mother is Male	4168	449	13	137	454	2647	468		3259	106
304 Mother has no Gender	504	443			4	45	12		30	14
305 Mother too young or not born	44687		2196	4662	10393	21433	5938	65	40675	153
306 Mother is too old	3169		230	687	1175	1073	4		3082	5
307 Mother is also a child	5		1			2	2		1	1
308 Mother is also a spouse	281	63	39	6	39	125	9		189	21
309 Mother is also a sibling	120	15	1	4	13	68	19		79	2
310 Mother was dead before birth	38214	1775	1671	6915	12085	15110	657	1	37795	176
311 Duplicate sibling by mother	195		5	45	28	68	49		161	15
312 Profile should be open (Child birth date)	2139	2139								6
402 Unknown gender of spouse	637	481			3	132	21		76	23
403 Single sex marriage	1055	211	8	23	47	641	125		660	69
404 Marriage before birth	6770		164	652	1600	3600	754		6163	38
405 Married too old	1508		24	171	493	820			1493	7
406 Marriage after death	9064	307	268	1250	2343	4608	288		8921	41
407 Lived too long after marriage	183	3	11	29	59	66	15		143	3
408 Multiple marriages on same day	3371	311	2	342	913	1703	100		3085	76
409 Marriage to duplicate person	10933	2230	83	872	2422	4946	380		9025	277
410 Marriage in future	1					1
412 Marriage End before marriage	82			1	7	71	3		67	4
413 Marriage too long	1					1			1	1
414 Marriage End before birth	88			6	5	57	20		58	5
415 Marriage End too old	27				14	13			27	2
416 Marriage End after death	3914	66	119	584	909	1974	262		3802	48
417 Lived too long after marriage End	3				2	1			3	3
418 Partner is also a sibling	411	26	30	47	108	190	10		381	8
501 Wrong gender (male)	3092	1014	3	62	377	1106	526	4	1417	84
502 Missing gender (male)	17808	10971	1		7	2508	4305	16	1443	92
503 Probably wrong gender (male)	4836	1111	29	349	574	1968	794	11	3334	82
504 Missing gender (probably male)	8906	6086			1	687	2101	31	440	63
505 Wrong gender (female)	3966	938	3	78	332	2053	560	2	2381	59
506 Missing gender (female)	14369	9344		1	5	2322	2688	9	1344	78
507 Probably wrong gender (female)	4110	709	17	153	545	1963	722	1	2860	62
508 Missing gender (probably female)	7673	5571	4		8	364	1712	14	101	56
509 Missing gender	36320	27054	18	235	742	4091	4134	46	8921	166
510 Unique name without gender	8682	3971	9	56	199	2291	2115	41	3554	42
511 Unique names (spelling)	263511	46924	7250	11848	20041	100591	75167	1690	170875	1789
551 Wikidata - Missing gender	33					1	32
552 Wikidata - Different gender	8				1	2	5		3	2
553 Wikidata - Empty birth date	139	139							121	4
554 Wikidata - Imprecise birth date	630		129	171	170	126	34		595	13
555 Wikidata - Different birth date	3781		1755	880	471	512	162	1	3739	29
556 Wikidata - Empty death date	195	46	55	27	28	13	25	1	160	4
557 Wikidata - Imprecise death date	864	26	262	210	200	123	43		828	9
558 Wikidata - Different death date	3998	57	2358	696	359	433	95		3976	23
559 Wikidata - Missing birth location	1453	35	253	403	306	365	91		1400	24
561 Wikidata - Missing death location	1916	56	434	411	380	503	132		1859	16
563 Wikidata - Possible duplicate by father	55	8	27	5	5	5	5		49	2
564 Wikidata - Possible father	140	6	76	11	11	23	13		129	2
565 Wikidata - Possible duplicate by mother	61	6	46	3	4		2		60	1
566 Wikidata - Possible mother	102	7	77	6	1	4	7		96	2
568 Wikidata - Unconnected branches to global tree	4794	56	52	185	420	1842	2234	5	3654	35
569 Wikidata - Unconnected orphans to global tree	5504	23	56	117	509	2393	2404	2	4119	16
571 FindAGrave - Link without Grave ID	53796	588	2	649	5516	32574	14464	3	43222	257
572 FindAGrave - Linked grave not matching profile	22302	1932	5	747	3847	12808	2962	1	20431	201
573 FindAGrave - Empty birth date	722	722							569	12
574 FindAGrave - Imprecise birth date	9934			186	1168	7152	1428		9594	106
575 FindAGrave - Different birth date	22390		60	1308	4162	14656	2204		21484	372
576 FindAGrave - Empty death date	4698	244		76	592	3514	272		4347	73
577 FindAGrave - Imprecise death date	10465	108	4	211	1463	6808	1871		10040	132
578 FindAGrave - Different death date	12150	80	29	955	2751	6900	1435		11791	200
579 FindAGrave - Missing birth location	14983	313	2	203	1911	9026	3528		14241	212
581 FindAGrave - Missing death location	19085	293	6	229	2045	12116	4396		18084	243
585 FindAGrave - Multiple profiles link to same grave ID	1416	13		91	430	770	112		1345	47
586 FindAGrave - Link to merged Grave ID	148	5		1	29	72	41		81	1
587 FindAGrave - Link to nonexisting Grave ID	391	21		60	186	82	41	1	322	3
601 Wrong word in birth location	5470	406			523	3502	1039		4329	27
603 USA too early in birth location	199100			37030	162070				199100	1278
604 Birth location too short	6445	797	1	757	934	3280	676		4619	45
605 Number in birth location	381	301				59	21		40	10
607 Misspelled word in birth location	6162	131	3	551	1795	3245	437		5611	75
608 Misspelled country in birth location	13376	284	1	453	2294	8929	1415		11768	232
609 Wrong character in birth location	3680	176	1	437	1457	1542	67		3509	2
610 Birth location in uppercase	21024	181	182	1044	2653	14355	2609		19671	80
611 Birth location in lowercase	32686	796	126	819	5749	19723	5471	2	26909	199
631 Wrong word in death location	15542	340		3	1492	11097	2610		14058	70
632 Y death location	500	13				481	6		263	5
633 USA too early in death location	63427	630	7	40910	21832	46	2		63421	279
634 Death location too short	7466	633	125	634	1149	4035	890		6049	36
635 Number in death location	288	66			3	181	38		110	8
636 Bogus death location	43				19	24			43	2
637 Misspelled word in death location	813	20		199	134	297	163		463	24
638 Misspelled country in death location	6429	247	22	248	518	4040	1354		5423	163
639 Wrong character in death location	2501	221	2	548	967	689	74		2410	4
640 Death location in uppercase	12856	214	3	437	1347	8721	2134		11724	27
641 Death location in lowercase	19928	716		255	2618	11942	4395	2	15814	92
661 Wrong word in marriage location	1117	38			186	684	209		979	3
663 USA too early in marriage location	21443	253		7033	14144	13			21442	177
664 Marriage location too short	2296	158	3	291	506	1214	124		1928	15
665 Number in marriage location	73	40				22	11		3	1
667 Misspelled word in marriage location	76	3		4	6	53	10		19	14
668 Misspelled country in marriage location	294	27	3	15	25	175	49		109	46
669 Wrong character in marriage location	791	40		257	356	135	3		781	8
670 Marriage location in uppercase	4074	96	54	188	577	2741	418		3863	8
671 Marriage location in lowercase	6082	201	6	204	1196	3873	602		5041	14
711 Separators in Prefix	806	72	3	8	19	327	375	2	350	7
712 Number in Prefix	515	40		3	3	297	172		282	8
713 Suffix in Prefix	2363	257	27	39	97	784	1153	6	1017	48
714 Wrong word in Prefix	458	97	1		4	105	243	8	111	5
721 Separators in First Name	49374	11557	222	1823	1316	28398	6058		35473	335
722 Number in First Name	72	68				4			4
723 Prefix in First Name	20512	5349	1948	2154	3133	7007	919	2	16756	93
724 Wrong word in First Name	7517	1886	76	357	669	2952	1575	2	6144	38
725 Wrong character in First Name	301	131	5	68	61	29	7		250
731 Separators in Preferred Name	16797	3283	71	53	29	1743	11534	84	577	67
732 Number in Preferred Name	28	22					6
733 Prefix in Preferred Name	6403	1557	189	9	16	381	4190	61	572	45
734 Wrong word in Preferred Name	1819	528	3	13	19	134	1107	15	166	1
735 Wrong character in Preferred Name	617	172	5	76	63	36	259	6	262
741 Separators in Middle Name	1313	91	2	54	86	817	263		1055	21
742 Number in Middle Name	8					2	6
743 Prefix in Middle Name	3077	145	36	55	276	1865	700		2819	37
744 Wrong word in Middle Name	800	95		23	120	439	122	1	711	4
745 Wrong character in Middle Name	2	1					1		1
751 Separators in Nicknames	2322	125	315	20	135	1328	398	1	2140	37
752 Number in Nicknames	48	2				46			37
753 Prefix in Nicknames	2906	248	716	168	513	842	419		2747	30
754 Wrong word in Nicknames	882	75	54	11	49	495	198		797	6
755 Wrong character in Nicknames	1			1					1
761 Separators in Suffix	4977	701	35	7	674	2186	1368	6	2972	16
762 Number in Suffix	1335	281	12	104	373	356	208	1	961	53
763 Prefix in Suffix	8309	824	45	314	787	1920	4397	22	2922	48
764 Wrong word in Suffix	1070	58		14	82	464	445	7	488	3
765 Wrong character in Suffix	29	3		1		24	1		25
771 Separators in Last Name at Birth	5154	1026	74	712	1198	1436	702	6	3718	12
772 Number in Last Name at Birth	11	11
773 Prefix in Last Name at Birth	10	3			1		6		1
774 Wrong word in Last Name at Birth	9	4		5					9
775 Wrong character in Last Name at Birth	1944	399	16	309	499	358	362	1	1408	3
781 Separators in Current Last Name	2591	538	62	217	207	755	812		1406	22
783 Prefix in Current Last Name	2						2
784 Wrong word in Current Last Name	187	25	30	67	34	16	15		176
785 Wrong character in Current Last Name	1510	369	19	93	361	315	352	1	984	3
791 Separators in Last Name Other	2749	141	191	204	535	561	1116	1	1404	29
792 Number in Last Name Other	13	4				2	7		3	3
794 Wrong word in Last Name Other	280	51	1	51	22	27	126	2	107	2
795 Wrong character in Last Name Other	9						9
801 Big profile	375	3			50	174	148		280
802 Empty profile	80897	35292	903	6	5086	28276	11258	76	48812	348
803 Almost empty profile	26761	5369	733	1144	3583	10998	4897	37	20993	192
811 Uncleaned profile after merge	191062	12585	6291	24240	39253	79523	29093	77	153263	1196
821 Headings starts with blank	230	16		6	17	88	103		60	44
822 Heading doesn't end with =	12036	118	1	303	2070	7169	2370	5	10368	147
823 Heading doesn't start with =	8131	451	3	362	910	5073	1327	5	6711	57
824 Heading different number of =	1652	47		148	331	763	361	2	1201	54
825 Use separator line ----	1310	9		49	254	918	80		1152	8
831 Multiple duplicated lines	36060	584	227	1412	2996	25700	5141		30672	76
835 Local file reference	60128	4290	79	1203	6075	34215	14240	26	44434	663
841 Template doesn't start with double {	43	3	1			12	27		2	3
842 Template doesn't end with double }	23					6	17		1
843 Missing template (spelling)	721	41	1	66	109	323	181		523	38
844 Out of use template	58	5					53
851 GEDCOM uncleaned Interpret date	72025	33075	308	2999	7861	22879	4897	6	46004	212
852 GEDCOM uncleaned Parse Lastname	9692	4183	160	827	1319	2737	465	1	6789	16
901 Unconnected empty public profiles	27156	27156								34
902 Unconnected empty open profiles	17938	17938							17938	35
911 Swedish patronym DOTTER for male	1					1			1
912 Swedish patronym SSON for female	513			1	37	475			513	6

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.

News on Database errors project (May 14th 2017) May 15, 2017.

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: 5

Leave a message for others who see this profile.

Paula (Round) Dea

667 done - found 1 aged over 150 years to request opening for next week.

posted May 17, 2017 by Paula (Round) Dea

Aleš Trtnik

It might be hidden by status (False error, Merge, corrected)

posted May 17, 2017 by Aleš Trtnik

Mark Dorney

There are now only nine 103 errors for Australia!

All were double commented as of last week, will wait until next week before private messaging.

(Report states eight, but there are definitely still nine, not sure why its not showing up.)

With the other 100s for Australia, now mostly just waiting for merges to go through and actions on comments. Next weeks report will give a clearer picture.

Now moving on to 203 and 205.

posted May 17, 2017 by Mark Dorney