upload image

Database errors project (March 12th 2017)

Privacy Level: Open (White)
Date: 12 Mar 2017 to 19 Mar 2017
Location: Worldwidemap
Surname/tag: data_doctors
This page has been accessed 695 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 March 12th 2017.

Related post.

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

Contents

News

Error Status

I added Error Status that replaces Temp Hide and False Error.

It enables tracking of error status for the duration of error existence. You can set 4 possible statuses.

  • Not corrected Which you don't need to set, since it is default.
  • Corrected (hide until next recheck) If you corrected the error, it can be hidden until next errors recalculation. It error is indeed corrected, it will not reappear and if it wasn't it will reappear after next dump.
  • False error (hide forever) If it is False error, select this option and error will not be displayed. If you set this by mistake, You can add another status Not Corrected and error will reappear.
  • Manager notified (hide for 30 days) If you posted a message to the manager or proposed the merge, you can hide the error for 30 days. Then it will reappear if it was not corrected.

You can also enter your WikitreeID, so you can track your changes. Probably also Top DD list will be created.

You can also enter Comment for the status for other DD to see.

Status list is displayed with each error in all error lists.

Try it out and if something is unclear or doesn't work as expected, let me know.

Previous news

New errors 114 Still living status and entered death date And 115 Still living status and entered death location

In the spirit of Living+1 rule, we must get living parameter to order. Here are first two errors for this. This profiles have Still living selected and death date or death location entered.

Display only one error type

On Wikitree+ when searching for errors, you can limit display of errors to a single error type.

I also added automatic exclusion of common errors in case a lot of errors needs to display thus reducing table size and speed. Example http://wikitree.sdms.si/function/WTWebUser/errors.htm?WikiTreeID=WikiTree-45&ErrorID=0

Help files

Finally added all missing help pages. If some DataDoctor wants to spellcheck them or extend existing help pages, I will be very happy. Just let me know, so I can add you in the trusted list.

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.

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.

Example: http://wikitree.sdms.si/findtree.htm?userid=3540972

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,

Errors

Analysis was done on data from March 12th 2017.

2310916 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 72 1 66 5 1
103 Death before birth 8876 13 401 1098 4777 2534 53 6382 7
104 Too old 7604 255 1327 2470 3412 136 4 7003 27
105 Duplicate sibling 259 1 25 36 76 121 145 33
106 Duplicates between global tree and unconnected 872 111 285 349 127 680 102
109 Profile should be open (birth date) 12648 15 11 854 11768 417
110 Profile should be open (death date) 701 115 2 90 269 223 2 84
111 Died too young to be parent 465 36 55 49 186 134 5 359
112 Person is Father and mother 624 84 9 10 81 335 105 301 5
113 Duplicate in relatives 1080 261 122 45 127 444 81 529 38
114 Still living status and entered death date 2585 196 7 40 132 735 1469 6 843 39
115 Still living status and entered death location 625 19 4 22 84 297 199 448 17
201 Father is self 87 57 1 22 7 2 1
202 Parents are same 52 4 25 23 5 1
203 Father is Female 4622 632 23 145 689 2608 525 3390 34
204 Father has no Gender 486 391 81 14 3 2
205 Father is too young or not born 35904 1812 3664 7468 17131 5763 66 30312 171
206 Father is too old 4516 374 1068 1754 1315 5 4226 10
207 Father is also a child 169 63 13 4 17 60 12 67 18
208 Father is also a spouse 30 6 3 2 19 9 3
209 Father is also a sibling 1405 262 92 89 118 687 157 816 13
210 Father was dead before birth 35618 1508 2453 6504 10428 14044 681 32808 154
211 Duplicate sibling by father 494 2 91 116 220 65 363 40
212 Profile should be open (Child birth date) 2842 2842 14
301 Mother is self 1 1
303 Mother is Male 4783 535 47 196 773 2762 470 3413 32
304 Mother has no Gender 519 440 1 63 15 7 7
305 Mother too young or not born 46252 2286 4923 10689 21871 6416 67 39663 207
306 Mother is too old 3707 257 774 1391 1282 3 3426 12
307 Mother is also a child 6 1 1 3 1 3
308 Mother is also a spouse 260 66 44 11 30 99 10 118 20
309 Mother is also a sibling 126 22 1 2 6 73 22 49 3
310 Mother was dead before birth 40088 1828 1757 7353 12640 15805 704 1 37075 230
311 Duplicate sibling by mother 172 4 47 32 53 36 124 17
312 Profile should be open (Child birth date) 2274 2274 14
402 Unknown gender of spouse 661 471 165 25 15 6
403 Single sex marriage 903 218 14 24 30 493 124 303 13
404 Marriage before birth 7356 180 706 1686 3835 948 1 6210 27
405 Married too old 1849 35 250 552 1012 1666 6
406 Marriage after death 9905 314 312 1395 2512 5048 324 8804 56
407 Lived too long after marriage 244 7 11 38 75 96 17 166 3
408 Multiple marriages on same day 3589 349 2 383 973 1763 119 3023 82
409 Marriage to duplicate person 11312 2429 94 986 2464 4961 378 8774 279
410 Marriage in future 5 5
412 Marriage End before marriage 122 5 17 93 7 85 3
413 Marriage too long 2 1 1 1 1
414 Marriage End before birth 118 1 6 4 65 42 66 1
415 Marriage End too old 53 6 26 21 48 4
416 Marriage End after death 4001 70 124 580 939 2006 282 3696 54
417 Lived too long after marriage End 2 2
418 Partner is also a sibling 452 30 34 48 116 214 10 393 5
501 Wrong gender (male) 4189 1063 10 77 505 2042 488 4 2106 72
502 Missing gender (male) 17608 10757 1 4 2631 4200 15 48 98
503 Probably wrong gender (male) 4964 1135 42 437 601 2042 700 7 3241 55
504 Missing gender (probably male) 8833 5894 1 4 740 2161 33 166 52
505 Wrong gender (female) 4491 963 2 78 311 2636 499 2 2287 54
506 Missing gender (female) 14238 9141 2 2446 2639 10 25 99
507 Probably wrong gender (female) 4214 727 19 175 582 2026 684 1 2736 45
508 Missing gender (probably female) 7922 5474 5 3 678 1750 12 199 63
509 Missing gender 36317 26513 18 253 782 4146 4561 44 8274 267
510 Unique name without gender 9912 3996 10 60 213 2848 2737 48 4132 35
511 Unique names (spelling) 266493 47965 7571 12523 20473 101929 74391 1641 161826 1738
551 Wikidata - Missing gender 35 1 34
552 Wikidata - Different gender 8 2 2 1 3 5 1
553 Wikidata - Empty birth date 197 197 179 1
554 Wikidata - Imprecise birth date 653 134 195 194 103 27 588 3
555 Wikidata - Different birth date 3792 1755 913 457 506 160 1 3716 17
556 Wikidata - Empty death date 223 66 63 30 30 10 23 1 188 1
557 Wikidata - Imprecise death date 905 31 266 242 220 110 36 837 7
558 Wikidata - Different death date 4001 63 2350 707 363 427 91 3956 10
559 Wikidata - Missing birth location 1501 50 249 442 331 360 69 1413 6
561 Wikidata - Missing death location 1961 76 429 448 398 491 119 1875 8
563 Wikidata - Possible duplicate by father 80 10 22 14 13 14 7 72 1
564 Wikidata - Possible father 242 7 81 55 31 52 16 227 5
565 Wikidata - Possible duplicate by mother 111 6 51 26 20 8 106 8
566 Wikidata - Possible mother 184 8 86 41 19 24 6 175 2
568 Wikidata - Unconnected branches to global tree 4686 63 52 177 427 1787 2175 5 3475 35
569 Wikidata - Unconnected orphans to global tree 5501 27 53 122 523 2402 2372 2 4096 7
571 FindAGrave - Link without Grave ID 53420 648 26 725 5586 32389 14043 3 40021 203
586 FindAGrave - Link to merged Grave ID 640 6 125 374 134 1 537 8
587 FindAGrave - Link to nonexisting Grave ID 1017 24 1 76 211 513 191 1 841 3
601 Wrong word in birth location 6630 423 48 788 4226 1145 4943 88
604 Birth location too short 7121 914 41 857 990 3647 672 4001 78
605 Number in birth location 490 310 2 158 20 22 6
606 Bogus birth location 4 1 3 4
607 Misspelled word in birth location 7614 134 137 1099 2192 3558 494 6359 83
608 Misspelled country in birth location 15921 304 173 624 2616 10559 1645 12775 190
609 Wrong character in birth location 4388 190 2 620 1837 1660 79 3525 16
610 Birth location in uppercase 25421 200 551 1298 3950 16296 3126 22542 66
611 Birth location in lowercase 38153 953 207 927 7016 22912 6136 2 27819 99
631 Wrong word in death location 17782 353 16 1960 12693 2760 15012 145
632 Y death location 766 14 7 730 15 78 77
634 Death location too short 7928 659 128 691 1213 4350 887 4967 137
635 Number in death location 320 69 2 210 39 21 7
636 Bogus death location 340 4 1 6 161 167 1 314
637 Misspelled word in death location 1293 29 205 146 720 193 629 64
638 Misspelled country in death location 7608 286 81 299 517 4939 1486 5715 89
639 Wrong character in death location 2888 230 4 724 1155 690 85 2552 6
640 Death location in uppercase 15829 371 193 561 2258 9888 2558 13754 20
641 Death location in lowercase 23339 701 97 303 3562 13665 5009 2 16686 94
661 Wrong word in marriage location 1300 36 1 9 245 763 246 1030 6
664 Marriage location too short 2334 172 3 295 501 1241 122 1707 10
665 Number in marriage location 90 49 31 10 2 1
666 Bogus marriage location 1 1 1
667 Misspelled word in marriage location 182 4 2 4 163 9 15 15
668 Misspelled country in marriage location 513 27 4 7 25 396 54 95 35
669 Wrong character in marriage location 830 37 279 380 132 2 778 3
670 Marriage location in uppercase 4910 112 135 237 840 3108 478 4444 8
671 Marriage location in lowercase 7206 234 29 250 1616 4412 665 5226 23
711 Separators in Prefix 897 77 9 13 10 404 382 2 327 6
712 Number in Prefix 863 40 9 3 648 163 627 2
713 Suffix in Prefix 2210 255 37 31 61 771 1051 4 866 27
714 Wrong word in Prefix 526 100 1 2 5 156 239 23 69 2
721 Separators in First Name 54498 12158 244 2052 5285 28681 6078 34882 221
722 Number in First Name 73 68 5
723 Prefix in First Name 22350 5611 2051 2419 3567 7057 1643 2 17366 55
724 Wrong word in First Name 7708 1940 76 383 786 2976 1546 1 5442 20
725 Wrong character in First Name 650 156 5 205 177 84 23 565 1
731 Separators in Preferred Name 16865 3300 78 79 125 1895 11303 85 827 46
732 Number in Preferred Name 29 23 6
733 Prefix in Preferred Name 7142 1549 209 197 246 771 4106 64 1377 28
734 Wrong word in Preferred Name 1826 539 3 15 14 122 1115 18 148 6
735 Wrong character in Preferred Name 962 190 5 205 178 91 289 4 569 1
741 Separators in Middle Name 1353 92 1 60 96 823 281 998 13
742 Number in Middle Name 8 2 6
743 Prefix in Middle Name 3012 143 36 56 279 1922 576 2611 29
744 Wrong word in Middle Name 869 112 3 20 130 467 136 1 736 10
745 Wrong character in Middle Name 7 2 2 1 1 1 6
751 Separators in Nicknames 2763 125 330 299 341 1290 377 1 2450 27
752 Number in Nicknames 51 2 1 47 1 3 2
753 Prefix in Nicknames 3038 237 678 464 520 745 394 2822 21
754 Wrong word in Nicknames 1021 81 57 70 96 528 189 879 4
755 Wrong character in Nicknames 3 3 3
761 Separators in Suffix 7208 1150 164 775 1411 2323 1378 7 4814 21
762 Number in Suffix 1485 280 140 385 478 201 1 1073 34
763 Prefix in Suffix 8671 928 147 377 901 2018 4279 21 3107 45
764 Wrong word in Suffix 1206 78 71 129 482 439 7 562 10
765 Wrong character in Suffix 30 3 1 25 1 2
771 Separators in Last Name at Birth 5311 1044 77 847 1247 1413 675 8 3430 17
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 10 4 5 1 10
775 Wrong character in Last Name at Birth 2153 437 22 401 538 370 383 2 1412 7
781 Separators in Current Last Name 3047 670 56 243 366 918 794 1698 18
783 Prefix in Current Last Name 11 3 8
784 Wrong word in Current Last Name 212 27 30 83 38 18 16 201
785 Wrong character in Current Last Name 1798 403 19 207 441 336 390 2 1050 7
791 Separators in Last Name Other 3881 210 191 457 603 1218 1201 1 2434 30
792 Number in Last Name Other 12 4 1 7 1
794 Wrong word in Last Name Other 478 70 20 76 66 119 125 2 301 3
795 Wrong character in Last Name Other 30 7 4 18 1 15
801 Big profile 311 3 50 136 122 235
802 Empty profile 85846 36860 1035 1635 5779 29161 11302 74 45044 233
803 Almost empty profile 26430 5386 747 1271 3653 10553 4783 37 19305 136
811 Uncleaned profile after merge 195393 13193 7102 26118 40559 79911 28374 136 142610 922
821 Headings starts with blank 273 14 12 13 135 99 55 56
822 Heading doesn't end with = 11784 115 35 1273 2111 6286 1960 4 9836 157
823 Heading doesn't start with = 9827 530 99 468 1150 6089 1487 4 7613 68
824 Heading different number of = 2740 48 7 281 532 1442 430 2177 45
825 Use separator line ---- 1588 31 7 93 326 1059 72 1295 9
831 Multiple duplicated lines 36268 609 232 1478 3069 25738 5142 25968 94
835 Local file reference 58111 4431 87 1341 5987 32667 13556 42 38612 535
841 Template doesn't start with double { 132 6 9 11 10 70 26 63 13
842 Template doesn't end with double } 66 1 3 2 35 25 40 15
843 Missing template (spelling) 2453 68 23 162 480 1069 635 16 1528 48
844 Out of use template 79 8 71
901 Unconnected empty public profiles 29975 29975 8
902 Unconnected empty open profiles 18777 18777 18777 71
911 Swedish patronym DOTTER for male 1 1 1 1
912 Swedish patronym SSON for female 614 4 139 471 508 10

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.







Collaboration

On 15 Mar 2017 at 20:57 GMT Emma (McBeth) MacBeath M.Ed MSM wrote:

Still chipping away at error 721 1700-1799

On 14 Mar 2017 at 08:11 GMT Paula (Round) Dea wrote:

667 - new done

Also have become a lot more focused with my change notes this year, below is an example of what I use, it's handy cause can just type the error number to get the right note and it's promoting people's running their own error reports.

DB error 667 corrected spelling in location fields - http://wikitree.sdms.si/default.htm

Also have run my own error report, on the tree and managed by options up to 25 generations, only 1 on the managed by for a unconnected notable record I'm working on. I try to run this weekly as Ales' new errors sometimes creep in ;)

On 14 Mar 2017 at 00:56 GMT Marty (Lenover) Acks wrote:

204, 304, 502, 506 All Open are done

631 New Done (all with someone else?) 638 New - in process

On 13 Mar 2017 at 17:37 GMT Isabelle Rassinot wrote:

Working on errors 564 and 566 this week - very good hints for Connectors and EuroAristo projects there.

On 13 Mar 2017 at 17:15 GMT Aaron Gullison wrote:

working on error 843 etc