upload image

Database errors project (February 12th 2017)

Privacy Level: Open (White)
Date: 12 Feb 2017 to 19 Feb 2017
Location: Worldwidemap
Surname/tag: data_doctors
Profile manager: Aleš Trtnik private message [send private message]
This page has been accessed 865 times.
This page is part of the Data Doctors Project.
 
Latest report: May 26th 2024.
Data Doctors Challenge: Orphaned_Profiles_XLVI 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 12th 2017.

Related post.

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

Contents

News

Updated a few Separators errors

I added ? and numbers to errors, since you can't save profile with number in these fields.


2307880 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
721 Separators in First Name 55516 12299 247 2155 6162 28644 6009 35622 7439
731 Separators in Preferred Name 16849 3346 78 82 124 1860 11275 84 830 1630
741 Separators in Middle Name 1334 95 1 60 97 814 267 975 13
781 Separators in Current Last Name 1734 509 12 11 23 114 1057 8 105 68

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

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.

Update to 901, 902

Info column: Size of biography.

Updated error 418 Partner is also a sibling

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

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.

2299050 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 74 1 68 5 3 3
103 Death before birth 9795 17 439 1140 4841 3304 54 7251 15
104 Too old 7657 280 1340 2487 3407 139 4 7049 34
105 Duplicate sibling 267 18 38 87 124 140 29
106 Duplicates between global tree and unconnected 837 110 276 340 111 662 87
109 Profile should be open (birth date) 12413 9 8 570 11826 94
110 Profile should be open (death date) 645 133 18 266 226 2 29
111 Died too young to be parent 467 36 56 51 184 134 6 360
112 Person is Father and mother 639 88 8 10 80 339 114 301 16
113 Duplicate in relatives 1169 271 127 54 139 481 97 598 38
201 Father is self 85 57 21 7
202 Parents are same 66 9 25 32 11
203 Father is Female 4545 657 23 146 678 2529 512 3302 115
204 Father has no Gender 516 398 99 19 27
205 Father is too young or not born 36662 1857 3750 7519 17231 6239 66 30962 151
206 Father is too old 4874 384 1075 1815 1594 6 4567 11
207 Father is also a child 160 59 15 3 13 60 10 59 1
208 Father is also a spouse 31 6 3 1 21 9 3
209 Father is also a sibling 1430 268 96 90 118 699 159 828 10
210 Father was dead before birth 36179 1533 2479 6558 10616 14283 710 33316 113
211 Duplicate sibling by father 599 2 96 129 314 58 350 46
212 Profile should be open (Child birth date) 2920 2920 83
301 Mother is self 1 1
303 Mother is Male 4801 537 47 200 770 2751 496 3387 116
304 Mother has no Gender 514 438 59 17 1 1
305 Mother too young or not born 47059 2318 4988 10855 21965 6865 68 40339 210
306 Mother is too old 4012 268 792 1428 1521 3 3718 4
307 Mother is also a child 7 1 3 2 1 4
308 Mother is also a spouse 293 65 45 11 38 124 10 150 15
309 Mother is also a sibling 123 23 1 1 6 73 19 49
310 Mother was dead before birth 40714 1850 1782 7535 12826 15996 724 1 37631 205
311 Duplicate sibling by mother 326 4 47 43 175 57 148 18
312 Profile should be open (Child birth date) 2416 2416 131
402 Unknown gender of spouse 672 475 172 25 22 11
403 Single sex marriage 837 226 13 24 26 475 73 226 32
404 Marriage before birth 7692 183 725 1717 3893 1173 1 6511 30
405 Married too old 1862 39 253 556 1014 1674 5
406 Marriage after death 9986 311 313 1421 2545 5056 340 8874 34
407 Lived too long after marriage 257 8 10 40 80 99 20 177 4
408 Multiple marriages on same day 3578 342 4 375 980 1755 122 3002 75
409 Marriage to duplicate person 11308 2484 97 980 2438 4948 361 8689 237
410 Marriage in future 5 5
411 Marriage End in future 1 1 1 1
412 Marriage End before marriage 134 1 5 20 99 9 96 3
413 Marriage too long 6 2 4 5
414 Marriage End before birth 153 1 6 10 77 59 99 3
415 Marriage End too old 69 6 23 40 64 5
416 Marriage End after death 3967 71 121 569 941 1987 278 3658 50
417 Lived too long after marriage End 12 1 9 2 9 2
418 Partner is also a sibling 506 33 35 61 127 239 11 433 3
501 Wrong gender (male) 3857 942 10 56 499 1954 392 4 1906 67
502 Missing gender (male) 17482 10613 8 2668 4179 14 54 63
503 Probably wrong gender (male) 5060 1251 43 445 601 2030 683 7 3237 67
504 Missing gender (probably male) 8835 5869 1 3 755 2174 33 132 51
505 Wrong gender (female) 4832 1040 2 82 363 2852 490 3 2610 50
506 Missing gender (female) 14170 9020 3 2503 2634 10 28 69
507 Probably wrong gender (female) 4651 739 19 186 576 2065 1065 1 3137 52
508 Missing gender (probably female) 7915 5417 5 3 726 1752 12 244 50
509 Missing gender 35838 26097 18 251 773 4107 4547 45 8158 180
510 Unique name without gender 10679 4005 10 62 219 3571 2764 48 4846 21
511 Unique names (spelling) 265305 48373 7638 12586 20314 100834 73951 1609 159797 1663
551 Wikidata - Missing gender 35 1 34
552 Wikidata - Different gender 4 2 2 1
553 Wikidata - Empty birth date 209 209 191
554 Wikidata - Imprecise birth date 638 131 194 191 95 27 570 5
555 Wikidata - Different birth date 3818 1780 905 453 517 163 3743 19
556 Wikidata - Empty death date 225 66 65 32 28 10 24 191 2
557 Wikidata - Imprecise death date 888 32 262 240 218 97 39 817 10
558 Wikidata - Different death date 4004 74 2359 691 360 431 89 3960 14
559 Wikidata - Missing birth location 1506 49 254 433 332 372 66 1414 49
561 Wikidata - Missing death location 1929 78 427 438 385 489 112 1840 2
563 Wikidata - Possible duplicate by father 146 14 52 34 19 18 9 137 6
564 Wikidata - Possible father 264 9 78 65 40 56 16 250 2
565 Wikidata - Possible duplicate by mother 145 17 53 38 23 9 5 126 4
566 Wikidata - Possible mother 233 11 84 62 30 39 7 221
568 Wikidata - Unconnected branches to global tree 4617 68 53 180 416 1760 2135 5 3421 25
569 Wikidata - Unconnected orphans to global tree 5492 27 51 123 528 2393 2369 1 4079 11
571 FindAGrave - Link without Grave ID 53648 653 26 772 5639 32497 14058 3 39887 341
586 FindAGrave - Link to merged Grave ID 717 17 1 48 135 379 137 612 1
587 FindAGrave - Link to nonexisting Grave ID 1063 25 1 87 226 530 193 1 885 6
601 Wrong word in birth location 6622 443 39 823 4176 1141 4899 49
604 Birth location too short 7062 917 41 866 986 3596 656 3891 100
605 Number in birth location 507 314 1 172 20 15 8
607 Misspelled word in birth location 8119 137 140 1184 2464 3651 543 6830 54
608 Misspelled country in birth location 17229 320 176 870 2873 10795 2195 13991 161
609 Wrong character in birth location 4738 195 675 2027 1719 122 3880 5
610 Birth location in uppercase 26438 199 553 1320 4075 17083 3208 23496 59
611 Birth location in lowercase 38369 959 208 925 7188 22964 6123 2 27972 100
631 Wrong word in death location 17721 361 5 1976 12624 2755 14899 100
632 Y death location 1179 14 1033 132 489 99
634 Death location too short 8078 660 130 687 1207 4452 942 5083 149
635 Number in death location 340 71 1 5 221 42 25 13
636 Bogus death location 335 4 166 164 1 304 2
637 Misspelled word in death location 1817 28 1 212 155 1084 337 1137 32
638 Misspelled country in death location 8578 293 83 332 753 5458 1659 6621 83
639 Wrong character in death location 3189 282 1 804 1264 726 112 2855 5
640 Death location in uppercase 16680 379 195 577 2388 10517 2624 14567 24
641 Death location in lowercase 23472 688 99 308 3649 13723 5003 2 16761 70
661 Wrong word in marriage location 1294 36 1 10 248 754 245 1018 8
664 Marriage location too short 2335 180 3 299 509 1224 120 1698 20
665 Number in marriage location 94 49 1 33 11 3 2
667 Misspelled word in marriage location 196 3 2 6 172 13 26 16
668 Misspelled country in marriage location 670 46 17 22 80 442 63 229 25
669 Wrong character in marriage location 913 47 296 431 137 2 860 2
670 Marriage location in uppercase 5199 122 135 241 875 3332 494 4710 4
671 Marriage location in lowercase 7254 237 30 255 1668 4399 665 5256 20
711 Separators in Prefix 895 75 9 14 24 398 374 1 334 6
712 Number in Prefix 854 39 9 1 648 157 624 1
713 Suffix in Prefix 2120 234 16 24 85 746 1011 4 826 24
714 Wrong word in Prefix 518 99 1 2 5 152 236 23 61 7
721 Separators in First Name 48298 7914 231 1900 5540 26937 5776 32442 216
722 Number in First Name 75 68 7
723 Prefix in First Name 22796 5755 2079 2488 3770 7070 1632 2 17738 70
724 Wrong word in First Name 7702 1947 77 386 802 2973 1516 1 5425 46
725 Wrong character in First Name 1048 234 7 285 351 153 18 978 3
731 Separators in Preferred Name 15307 2483 77 77 105 1793 10695 77 772 88
732 Number in Preferred Name 38 31 1 6
733 Prefix in Preferred Name 7115 1532 212 203 254 778 4072 64 1408 40
734 Wrong word in Preferred Name 1824 548 3 15 13 122 1105 18 148 6
735 Wrong character in Preferred Name 1342 263 6 285 352 160 272 4 979 3
741 Separators in Middle Name 1331 93 1 60 97 813 267 974 10
742 Number in Middle Name 9 2 7
743 Prefix in Middle Name 2972 146 36 59 276 1888 567 2569 33
744 Wrong word in Middle Name 869 112 3 24 134 462 133 1 734 2
745 Wrong character in Middle Name 8 4 4 8
751 Separators in Nicknames 2737 121 330 299 343 1278 365 1 2423 20
752 Number in Nicknames 49 2 1 46 1
753 Prefix in Nicknames 3247 282 844 477 522 742 380 3030 16
754 Wrong word in Nicknames 1011 78 60 74 96 517 186 870 7
755 Wrong character in Nicknames 7 2 5 7
761 Separators in Suffix 7291 1158 167 833 1460 2305 1360 8 4907 14
762 Number in Suffix 1430 282 130 366 450 201 1 1016 5
763 Prefix in Suffix 8754 977 182 431 922 2018 4205 19 3257 56
764 Wrong word in Suffix 1230 79 98 133 478 435 7 590 3
765 Wrong character in Suffix 28 3 24 1
771 Separators in Last Name at Birth 5392 1062 77 898 1278 1400 669 8 3511 6
772 Number in Last Name at Birth 11 11
773 Prefix in Last Name at Birth 14 6 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 2184 446 19 448 558 361 350 2 1497 1
781 Separators in Current Last Name 1673 467 12 11 23 114 1038 8 105 6
782 Number in Current Last Name 11 11
783 Prefix in Current Last Name 13 5 8
784 Wrong word in Current Last Name 214 27 30 83 38 20 16 203
785 Wrong character in Current Last Name 1871 380 16 302 464 345 362 2 1176 1
791 Separators in Last Name Other 3835 209 195 457 606 1185 1182 1 2402 27
792 Number in Last Name Other 9 3 6
793 Prefix in Last Name Other 1 1 1
794 Wrong word in Last Name Other 469 69 22 72 63 119 122 2 298 2
795 Wrong character in Last Name Other 22 2 4 2 14 14
801 Big profile 350 3 53 141 153 273 3
802 Empty profile 85992 36497 1048 1650 6182 29215 11327 73 44821 214
803 Almost empty profile 26299 5348 748 1272 3625 10476 4793 37 19140 110
811 Uncleaned profile after merge 195103 13212 7291 26596 40872 79200 27803 129 142710 1315
821 Headings starts with blank 283 12 1 14 15 146 95 60 49
822 Heading doesn't end with = 12838 356 665 1423 2160 6300 1930 4 10931 149
823 Heading doesn't start with = 9953 544 103 490 1176 6157 1479 4 7675 88
824 Heading different number of = 2895 47 100 303 557 1457 431 2329 65
825 Use separator line ---- 1616 30 8 89 325 1079 85 1322 10
831 Multiple duplicated lines 36250 609 235 1500 3071 25672 5163 24420 71
835 Local file reference 57046 4442 89 1365 5946 31817 13345 42 37027 315
841 Template doesn't start with double { 173 7 9 27 15 88 27 102 23
842 Template doesn't end with double } 178 3 48 98 29 153 17
843 Missing template (spelling) 2583 69 20 184 520 1151 623 16 1675 66
844 Out of use template 85 11 74
901 Unconnected empty public profiles 32055 32055 14
902 Unconnected empty open profiles 18627 18627 18627 55
911 Swedish patronym DOTTER for male 1 1 1
912 Swedish patronym SSON for female 681 1 4 11 186 479 567 17

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.





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

Leave a message for others who see this profile.
There are no comments yet.
Login to post a comment.
Ellis-6095 Dawn Ellis
632...in progress
posted by Dawn Ellis
Mullins-2069 Jayme (Mullins) Arrington
Working on 607, new and 1800-1899
posted by Jayme (Mullins) Arrington
Pieterse-13 Esmé (Pieterse) van der Westhuizen
Error 211 - 1799 to 1999 - DONE - Proposed clear duplicates
posted by Esmé (Pieterse) van der Westhuizen
Pieterse-13 Esmé (Pieterse) van der Westhuizen
Error 211 - 1799 to 1999 - DONE - Proposed clear duplicates
posted by Esmé (Pieterse) van der Westhuizen
Paula (Round) Dea
667 - new (16) done and also since my pm's to profile managers a couple of the green 667's have dropped off. I was hoping this would also clear some of the green's in the biggest category but that section doesn't seem to have moved :(
posted by Paula (Round) Dea
Pieterse-13 Esmé (Pieterse) van der Westhuizen
Error 106 - 1799 to 1999 - DONE - Proposed all clear duplicates
posted by Esmé (Pieterse) van der Westhuizen
McBeth-165 Emma (McBeth) MacBeath M.Ed MSM
Error 721 1700-1799
posted by Emma (McBeth) MacBeath M.Ed MSM
Pieterse-13 Esmé (Pieterse) van der Westhuizen
Error 105 - 1799 to 1999 - DONE
posted by Esmé (Pieterse) van der Westhuizen

Categories: DD Suggestions