upload image

Database errors project (February 26th 2017)

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

Categories: DD Suggestions.

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

Analysis was done on data from February 26th 2017.

Related post.

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

Contents

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: http://wikitree.sdms.si/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.







Images: 1
1 generation tree.
1 generation tree.

Collaboration

On 4 Mar 2017 at 21:57 GMT Aleš Trtnik wrote:

Joyce, I fixed it.

On 4 Mar 2017 at 21:37 GMT Joyce (Wolfe) Reinig wrote:

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)

On 1 Mar 2017 at 14:02 GMT Esmé (Pieterse) van der Westhuizen wrote:

Working Error 211 - 1700 to 1999

On 28 Feb 2017 at 20:39 GMT Emma (McBeth) MacBeath M.Ed MSM wrote:

Still working on error 721 1700-1799

On 28 Feb 2017 at 13:22 GMT Carol (Winton) Keeling wrote:

New errors for 668 done, will continue working on these, as well as 637 and 638.

On 28 Feb 2017 at 09:00 GMT Paula (Round) Dea wrote:

667 - new done

On 28 Feb 2017 at 08:58 GMT Eva Ekeblad wrote:

Chipping away at 912 (mainly pre-1800, Gunnar is working the 1800s)

On 28 Feb 2017 at 06:59 GMT Esmé (Pieterse) van der Westhuizen wrote:

Error 106 - 1700 to 1999 - DONE - Proposed all new duplicates

On 28 Feb 2017 at 05:31 GMT Esmé (Pieterse) van der Westhuizen wrote:

Error 105 - 1700 to 1999 - DONE Proposed all new duplicates

On 28 Feb 2017 at 01:13 GMT Aaron Gullison wrote:

Still working on error 843