upload image

Database errors project (February 5th 2017)

Privacy Level: Open (White)
Date: 5 Feb 2017 to 12 Feb 2017
Location: Worldwidemap
Surname/tag: data_doctors
Profile manager: Aleš Trtnik private message [send private message]
This page has been accessed 810 times.

Categories: DD Suggestions.

This page is part of the Data Doctors Project.
Latest report: February 17th 2019 and the Spreadsheet.
Custom reports by: Suggestion lists, Unsourced lists, Unconnected lists.
See WikiTree+ for custom reports and statistics.
Data Doctors Challenge: Names_VIII .
Category suggestion report: Latest report

Analysis was done on data from February 5th 2017.

Related post.

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

Contents

News

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.

2301706 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
566 Wikidata - Possible mother 230 9 83 63 30 39 6 220 230

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.

This is the first relation checked from wikidata. I will add also others if this shows useful.

2301706 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
565 Wikidata - Possible duplicate by mother 138 7 53 37 31 8 2 132 138

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.

2301706 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
564 Wikidata - Possible father 261 9 77 67 40 53 15 246 261

Update to 901, 902

Info column: Size of biography.

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.

This is the first relation checked from wikidata. I will add also others if this shows useful.

2301077 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
563 Wikidata - Possible duplicate by father 138 14 46 33 19 17 9 129 138

Updated error 418 Partner is also a sibling

Removed duplicates from this error, so each marriage is reported only once.

Previous news

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.

Error list size

I reduced page size of error lists. Now it lists 1000 errors per page instead of 2000. This way pages will load faster.

Errors

Analysis was done on data from February 5th 2017.

2301473 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
101 Birth in future 2 2 1
102 Death in future 72 1 66 5 1 1
103 Death before birth 10046 19 442 1146 4850 3534 55 7489 3
104 Too old 7662 280 1341 2491 3408 138 4 7048 31
105 Duplicate sibling 379 26 52 156 145 202 46
106 Duplicates between global tree and unconnected 870 113 280 356 121 688 120
109 Profile should be open (birth date) 12466 10 14 586 11856 99
110 Profile should be open (death date) 633 108 2 27 267 227 2 10
111 Died too young to be parent 470 36 57 51 186 134 6 363 1
112 Person is Father and mother 635 89 8 11 80 333 114 296 4
113 Duplicate in relatives 1190 270 129 62 144 485 100 618 45
201 Father is self 86 57 22 7 1
202 Parents are same 72 9 1 30 32 17 3
203 Father is Female 4469 657 23 149 678 2451 511 3217 49
204 Father has no Gender 538 405 114 19 14 3
205 Father is too young or not born 36862 1864 3737 7536 17248 6411 66 31114 97
206 Father is too old 5018 384 1088 1851 1690 5 4708 9
207 Father is also a child 160 58 15 3 13 60 11 57 2
208 Father is also a spouse 31 4 3 1 3 20 10
209 Father is also a sibling 1450 275 97 99 115 704 160 841 17
210 Father was dead before birth 36409 1545 2488 6626 10673 14363 714 33519 140
211 Duplicate sibling by father 604 2 94 126 325 57 328 11
212 Profile should be open (Child birth date) 2859 2859 15
301 Mother is self 1 1
303 Mother is Male 4743 535 49 210 776 2676 497 3320 59
304 Mother has no Gender 521 439 65 17 8 1
305 Mother too young or not born 47171 2319 4993 10848 21932 7011 68 40404 167
306 Mother is too old 4126 269 800 1443 1611 3 3830 5
307 Mother is also a child 7 1 3 2 1 4
308 Mother is also a spouse 295 65 46 14 37 121 12 152 17
309 Mother is also a sibling 123 23 1 1 6 73 19 49
310 Mother was dead before birth 40894 1845 1794 7601 12860 16064 729 1 37779 169
311 Duplicate sibling by mother 334 5 55 41 177 56 148 22
312 Profile should be open (Child birth date) 2276 2276 26
401 Spouse is self 1 1 1 1
402 Unknown gender of spouse 677 478 1 171 27 17 8
403 Single sex marriage 868 229 14 27 28 487 83 250 63
404 Marriage before birth 7811 181 727 1723 3914 1265 1 6599 21
405 Married too old 1883 39 256 566 1022 1695 9
406 Marriage after death 10050 313 313 1433 2566 5077 348 8933 48
407 Lived too long after marriage 259 8 10 38 80 100 23 176 2
408 Multiple marriages on same day 3603 343 5 386 985 1756 128 3012 75
409 Marriage to duplicate person 11376 2519 98 1017 2415 4960 367 8720 241
410 Marriage in future 5 5
412 Marriage End before marriage 138 1 5 21 99 12 99 2
413 Marriage too long 6 2 4 5
414 Marriage End before birth 221 2 7 22 98 92 162 5
415 Married End too old 106 2 6 28 70 94 3
416 Marriage End after death 4012 73 123 578 936 2013 289 3695 43
417 Lived too long after marriage End 21 1 3 9 8 18 2
418 Partner is also a sibling 533 39 36 65 128 245 20 456 6
501 Wrong gender (male) 3891 940 11 49 489 2005 393 4 1940 45
502 Missing gender (male) 17439 10585 8 2667 4165 14 35 63
503 Probably wrong gender (male) 5041 1252 43 447 599 2030 663 7 3222 52
504 Missing gender (probably male) 8821 5856 1 2 754 2175 33 119 64
505 Wrong gender (female) 5141 1042 2 79 393 3118 504 3 2908 46
506 Missing gender (female) 14136 8988 3 2506 2629 10 15 65
507 Probably wrong gender (female) 4618 739 19 185 573 2040 1061 1 3098 62
508 Missing gender (probably female) 7968 5443 5 4 744 1760 12 256 49
509 Missing gender 35906 25956 18 253 773 4323 4538 45 8354 177
510 Unique name without gender 10835 4005 10 62 219 3713 2778 48 4990 16
511 Unique names (spelling) 265618 48672 7698 12572 20321 100764 73983 1608 159424 2138
551 Wikidata - Missing gender 36 1 35
552 Wikidata - Different gender 8 1 1 2 4 4 3
553 Wikidata - Empty birth date 212 212 194 1
554 Wikidata - Imprecise birth date 622 129 196 182 89 26 553 39
555 Wikidata - Different birth date 3737 1765 893 426 494 159 3666 76
556 Wikidata - Empty death date 225 70 64 31 28 8 24 190 2
557 Wikidata - Imprecise death date 855 31 259 240 199 87 39 784 42
558 Wikidata - Different death date 3930 74 2348 685 334 408 81 3887 79
559 Wikidata - Missing birth location 1483 51 251 442 318 361 60 1391 43
561 Wikidata - Missing death location 1931 80 427 452 382 478 112 1842 49
568 Wikidata - Unconnected branches to global tree 4537 67 54 176 418 1718 2099 5 3349 128
569 Wikidata - Unconnected orphans to global tree 5456 27 51 122 522 2374 2359 1 4041 55
571 FindAGrave - Link without Grave ID 53907 660 25 795 5748 32665 14011 3 40137 571
586 FindAGrave - Link to merged Grave ID 746 19 1 54 138 393 141 634 5
587 FindAGrave - Link to nonexisting Grave ID 1080 25 1 89 232 536 196 1 902 20
601 Wrong word in birth location 6762 444 63 886 4222 1147 5037 78
604 Birth location too short 7054 913 41 863 981 3602 654 3888 29
605 Number in birth location 500 309 1 170 20 6 6
606 Bogus birth location 2 2
607 Misspelled word in birth location 8411 139 140 1200 2623 3768 541 7110 51
608 Misspelled country in birth location 17838 322 179 885 3183 11025 2244 14590 169
609 Wrong character in birth location 4909 244 690 2116 1731 128 4051
610 Birth location in uppercase 26657 198 553 1328 4147 17221 3210 23729 73
611 Birth location in lowercase 38497 997 208 936 7221 22981 6152 2 28066 89
631 Wrong word in death location 17783 361 4 1999 12654 2765 14945 182
632 Y death location 1080 14 992 74
634 Death location too short 8005 657 130 686 1205 4426 901 4808 41
635 Number in death location 327 69 1 2 215 40 12 6
636 Bogus death location 336 4 167 164 1 305 1
637 Misspelled word in death location 1813 28 1 216 158 1073 337 1128 17
638 Misspelled country in death location 9270 296 84 335 1405 5478 1672 7294 79
639 Wrong character in death location 3383 363 813 1346 740 121 3049
640 Death location in uppercase 16875 378 195 583 2438 10660 2621 14776 22
641 Death location in lowercase 23546 687 99 310 3670 13759 5019 2 16820 74
661 Wrong word in marriage location 1293 36 1 10 249 753 244 1017 3
664 Marriage location too short 2340 181 3 299 504 1234 119 1699 12
665 Number in marriage location 94 50 34 10 2 2
667 Misspelled word in marriage location 212 4 4 19 173 12 36 20
668 Misspelled country in marriage location 669 47 17 26 84 433 62 222 43
669 Wrong character in marriage location 914 47 296 432 137 2 861
670 Marriage location in uppercase 5280 122 136 245 885 3395 497 4802 7
671 Marriage location in lowercase 7279 239 30 255 1685 4404 666 5281 21
711 Separators in Prefix 889 76 9 13 24 396 370 1 330 3
712 Number in Prefix 853 39 9 1 648 156 624 6
713 Suffix in Prefix 2102 235 16 23 82 741 1001 4 808 29
714 Wrong word in Prefix 514 99 1 3 5 148 234 24 53 4
721 Separators in First Name 48377 7943 233 1926 5570 26932 5773 32336 143
722 Number in First Name 75 68 7
723 Prefix in First Name 22890 5769 2088 2521 3811 7072 1627 2 17795 81
724 Wrong word in First Name 7684 1945 77 389 801 2967 1504 1 5381 21
725 Wrong character in First Name 1100 256 7 294 367 159 17 1030
731 Separators in Preferred Name 15260 2481 74 75 105 1806 10642 77 771 24
732 Number in Preferred Name 38 31 1 6
733 Prefix in Preferred Name 7096 1527 212 206 254 780 4053 64 1410 28
734 Wrong word in Preferred Name 1825 547 3 15 13 122 1107 18 149 9
735 Wrong character in Preferred Name 1394 285 6 294 368 166 271 4 1031
741 Separators in Middle Name 1340 93 1 60 99 820 267 983 8
742 Number in Middle Name 9 2 7
743 Prefix in Middle Name 2948 146 36 58 275 1871 562 2532 34
744 Wrong word in Middle Name 874 113 3 24 135 466 132 1 738 5
745 Wrong character in Middle Name 8 4 4 8
751 Separators in Nicknames 2748 123 335 302 342 1282 363 1 2429 16
752 Number in Nicknames 49 2 1 46 1
753 Prefix in Nicknames 3268 288 860 474 525 741 380 3050 31
754 Wrong word in Nicknames 1010 78 60 75 96 516 185 870 11
755 Wrong character in Nicknames 7 2 5 7
761 Separators in Suffix 7422 1180 171 899 1476 2322 1366 8 5034 15
762 Number in Suffix 1438 282 125 366 464 200 1 1024 4
763 Prefix in Suffix 8800 981 183 440 925 2049 4203 19 3286 37
764 Wrong word in Suffix 1274 85 119 135 487 441 7 635 7
765 Wrong character in Suffix 28 3 24 1
771 Separators in Last Name at Birth 5393 1063 77 899 1279 1400 667 8 3513 4
772 Number in Last Name at Birth 11 11
773 Prefix in Last Name at Birth 15 6 1 2 6 4
774 Wrong word in Last Name at Birth 10 4 5 1 10
775 Wrong character in Last Name at Birth 2190 449 19 448 558 360 354 2 1502 3
781 Separators in Current Last Name 1670 465 13 12 24 114 1034 8 107 2
782 Number in Current Last Name 11 11
783 Prefix in Current Last Name 14 5 1 8
784 Wrong word in Current Last Name 221 28 31 88 38 20 16 210 1
785 Wrong character in Current Last Name 1978 425 16 320 500 349 366 2 1282 3
791 Separators in Last Name Other 3814 208 196 453 596 1184 1176 1 2388 17
792 Number in Last Name Other 10 3 1 6 1
793 Prefix in Last Name Other 1 1 1 1
794 Wrong word in Last Name Other 473 69 22 73 63 122 122 2 302 5
795 Wrong character in Last Name Other 22 2 4 2 14 14 1
801 Big profile 378 3 53 151 171 295
802 Empty profile 85965 36467 1049 1656 6201 29185 11334 73 44399 194
803 Almost empty profile 26310 5339 746 1279 3648 10456 4806 36 19142 152
811 Uncleaned profile after merge 194909 13225 7331 26784 40905 78879 27656 129 142583 887
821 Headings starts with blank 266 14 10 14 136 92 44 38
822 Heading doesn't end with = 12961 356 670 1451 2193 6360 1928 3 11066 134
823 Heading doesn't start with = 10083 551 104 502 1188 6245 1489 4 7798 82
824 Heading different number of = 2943 46 99 304 575 1476 443 2363 74
825 Use separator line ---- 1620 30 8 95 328 1074 85 1326 9
831 Multiple duplicated lines 36259 608 235 1505 3075 25676 5160 24134 70
835 Local file reference 56949 4448 89 1371 5924 31721 13354 42 36879 1134
841 Template doesn't start with double { 154 7 2 26 11 82 26 84 13
842 Template doesn't end with double } 220 2 54 126 38 196 7
843 Missing template (spelling) 2550 69 21 175 514 1133 622 16 1644 16
844 Out of use template 95 13 82 1
901 Unconnected empty public profiles 32377 32377 9
902 Unconnected empty open profiles 18634 18634 18634 67
911 Swedish patronym DOTTER for male 1 1 1 1
912 Swedish patronym SSON for female 688 1 4 11 193 479 574 15

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.







Collaboration

On 14 Feb 2017 at 04:07 GMT Emma (McBeth) MacBeath M.Ed MSM wrote:

Working on Error 723 1700-1799

On 13 Feb 2017 at 20:50 GMT Aleš Trtnik wrote:

Number in location field can be house number, street can have number in name, post code can be entered, so I don't identify any number as an error.

You should ask such questions in G2G, It is easier to reply.

On 13 Feb 2017 at 02:06 GMT Mark Dorney wrote:

There are a bunch of records that have numbers in the place field, yet I can’t find them in the extant queries. They’re all open. Some examples are Riordan-153, Vyner-4, Dark-122.

Am I just looking in the wrong place, or do the queries currently not pick this up?

On 10 Feb 2017 at 20:47 GMT Karen (Kraus) Harbert wrote:

Working on 842 Template doesn't end with double }

On 8 Feb 2017 at 21:24 GMT Paul Gierszewski wrote:

404-418 NEW - messaged, except for 408/409

On 8 Feb 2017 at 09:46 GMT Esmé (Pieterse) van der Westhuizen wrote:

Error 601 - Moving "Wrong word in birth location" into the biography. Only on Orphaned and inactive PM profiles

On 8 Feb 2017 at 08:50 GMT Paula (Round) Dea wrote:

667 new done, and all the pm's is the small number categories received an e-mail last week, fingers crossed a few come on to check there errors :) Hoping it will reduce the big category before i send those messages out.

On 8 Feb 2017 at 08:07 GMT Esmé (Pieterse) van der Westhuizen wrote:

Working on Error 311 - 1700 to 1999. Proposing clear duplicates. - DONE

On 8 Feb 2017 at 07:51 GMT Esmé (Pieterse) van der Westhuizen wrote:

Working on Error 211 - 1700 to 1999. Proposing clear duplicates. - DONE

On 8 Feb 2017 at 04:14 GMT Emma (McBeth) MacBeath M.Ed MSM wrote:

Working on Error 638 1700 to 1799--DONE

( with a few exceptions where I could not make a judgement--not having enough knowledge)

more comments