upload image

Database errors project (February 19th 2017)

Privacy Level: Open (White)
Date: 19 Feb 2017 to 26 Feb 2017
Location: Worldwidemap
Surname/tag: data_doctors
Profile manager: Aleš Trtnik private message [send private message]
This page has been accessed 563 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 19th 2017.

Related post.

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

Contents

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







Collaboration

On 27 Feb 2017 at 04:06 GMT Marty (Lenover) Acks wrote:

All Open 632s all done.

On 25 Feb 2017 at 18:01 GMT Aaron Gullison wrote:

Working on error 843

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

Error 211 - 1700 to 1999

On 21 Feb 2017 at 16:38 GMT Aleš Trtnik wrote:

RJ, This links work for me.

Since compare showed two obviously different persons, I checked Wikidata and there was connection error between Wikidata and Wikitree. I corrected it.

There was also an error in 565 and 566 reports. I corrected it.

On 21 Feb 2017 at 12:30 GMT RJ Horace wrote:

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

Error 106 - 1700 to 1999 - DONE Proposed clear duplicates of all new profiles on the list

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

Error 105 - 1700 to 1999 Done - Proposed merges of all new errors

On 21 Feb 2017 at 03:46 GMT Dawn Ellis wrote:

632 continues

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

Still working on Error 721--1700-1799