upload image

Database errors project (March 19th 2017)

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

Related post.

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

Contents

News

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

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

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 19th 2017.

2306776 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
101 Birth in future 4 4 2
102 Death in future 73 1 67 5 1 1
103 Death before birth 8766 13 398 1089 4755 2458 53 6280 10
104 Too old 7607 254 1319 2466 3427 137 4 7008 37
105 Duplicate sibling 271 1 24 33 86 127 154 40
106 Duplicates between global tree and unconnected 906 90 260 425 131 715 141
109 Profile should be open (birth date) 12655 15 12 869 11759 103
110 Profile should be open (death date) 698 113 3 90 268 222 2 1
111 Died too young to be parent 466 36 55 49 187 134 5 360 1
112 Person is Father and mother 615 83 6 5 78 338 105 297 2
113 Duplicate in relatives 1067 255 122 46 111 450 83 517 33
114 Still living status and entered death date 2086 154 7 1 19 493 1407 5 331 26
115 Still living status and entered death location 341 10 4 28 170 129 165 7
201 Father is self 87 57 22 8 3 1
202 Parents are same 52 4 25 23 5 1
203 Father is Female 4626 630 22 143 686 2616 529 3390 26
204 Father has no Gender 485 391 80 14 2 2
205 Father is too young or not born 35852 1809 3627 7475 17146 5729 66 30280 158
206 Father is too old 4470 374 1066 1750 1275 5 4183 11
207 Father is also a child 161 70 14 2 6 56 13 52 13
208 Father is also a spouse 31 5 3 3 20 11 2
209 Father is also a sibling 1379 262 92 82 107 678 158 797 8
210 Father was dead before birth 35552 1506 2451 6481 10420 14004 690 32779 141
211 Duplicate sibling by father 488 2 86 117 220 63 358 31
212 Profile should be open (Child birth date) 2820 2820 14
301 Mother is self 1 1
303 Mother is Male 4761 524 45 189 769 2764 470 3412 19
304 Mother has no Gender 521 442 5 60 14 15 9
305 Mother too young or not born 46144 2279 4873 10659 21889 6377 67 39574 190
306 Mother is too old 3680 258 778 1387 1254 3 3404 13
307 Mother is also a child 5 1 3 1 2
308 Mother is also a spouse 257 61 44 11 29 102 10 122 10
309 Mother is also a sibling 128 23 1 2 6 74 22 50 3
310 Mother was dead before birth 40011 1828 1752 7351 12606 15768 705 1 37012 170
311 Duplicate sibling by mother 185 4 49 35 59 38 135 16
312 Profile should be open (Child birth date) 2270 2270 12
402 Unknown gender of spouse 665 473 1 168 23 23 13
403 Single sex marriage 914 218 13 23 31 503 126 312 17
404 Marriage before birth 7302 180 699 1682 3818 922 1 6161 26
405 Married too old 1838 35 249 548 1006 1663 6
406 Marriage after death 9864 312 310 1383 2506 5027 326 8772 32
407 Lived too long after marriage 243 7 11 38 74 96 17 166 3
408 Multiple marriages on same day 3587 343 2 380 978 1772 112 3021 80
409 Marriage to duplicate person 11307 2421 92 972 2463 4979 380 8769 277
410 Marriage in future 4 4
412 Marriage End before marriage 122 5 17 92 8 86 1
413 Marriage too long 1 1
414 Marriage End before birth 117 1 7 4 64 41 66 1
415 Marriage End too old 53 4 28 21 48 2
416 Marriage End after death 3992 69 125 583 938 1999 278 3687 38
417 Lived too long after marriage End 2 2
418 Partner is also a sibling 448 30 34 47 115 213 9 389 2
501 Wrong gender (male) 4208 1066 10 67 507 2057 497 4 2124 70
502 Missing gender (male) 17642 10761 11 2633 4222 15 56 108
503 Probably wrong gender (male) 4969 1127 42 438 600 2044 711 7 3249 59
504 Missing gender (probably male) 8772 5889 1 4 742 2104 32 103 72
505 Wrong gender (female) 4504 964 2 84 310 2638 504 2 2302 66
506 Missing gender (female) 14282 9173 8 2443 2648 10 34 91
507 Probably wrong gender (female) 4209 722 19 172 576 2031 688 1 2739 46
508 Missing gender (probably female) 7845 5418 5 4 670 1736 12 182 56
509 Missing gender 36531 26712 18 252 781 4137 4587 44 8280 340
510 Unique name without gender 9769 3991 10 59 211 2723 2727 48 4000 29
511 Unique names (spelling) 263033 47663 7405 12292 20150 99791 74080 1652 159208 2469
551 Wikidata - Missing gender 35 1 34
552 Wikidata - Different gender 7 1 1 2 3 4
553 Wikidata - Empty birth date 174 174 156
554 Wikidata - Imprecise birth date 644 134 190 189 102 29 579 7
555 Wikidata - Different birth date 3798 1759 914 458 505 162 3724 27
556 Wikidata - Empty death date 212 57 63 30 29 10 23 178
557 Wikidata - Imprecise death date 899 31 267 235 217 111 38 831 10
558 Wikidata - Different death date 4011 62 2354 709 364 430 92 3965 20
559 Wikidata - Missing birth location 1481 40 251 430 323 359 78 1392 16
561 Wikidata - Missing death location 1942 66 431 436 395 490 124 1855 13
563 Wikidata - Possible duplicate by father 58 9 23 5 8 6 7 49 4
564 Wikidata - Possible father 167 6 80 26 14 29 12 153 3
565 Wikidata - Possible duplicate by mother 76 7 51 6 10 2 76 7
566 Wikidata - Possible mother 135 8 85 26 3 9 4 125 2
568 Wikidata - Unconnected branches to global tree 4686 60 52 179 419 1791 2180 5 3481 52
569 Wikidata - Unconnected orphans to global tree 5523 25 54 122 521 2405 2395 1 4116 36
571 FindAGrave - Link without Grave ID 53610 648 26 716 5579 32530 14108 3 40183 366
586 FindAGrave - Link to merged Grave ID 638 6 123 373 135 1 535 3
587 FindAGrave - Link to nonexisting Grave ID 1007 22 1 75 209 507 192 1 830 3
601 Wrong word in birth location 6666 408 51 796 4245 1166 4980 115
604 Birth location too short 7037 846 41 858 979 3640 673 3918 44
605 Number in birth location 478 304 152 22 9 9
606 Bogus birth location 2 2 2
607 Misspelled word in birth location 7582 136 138 1092 2166 3560 490 6329 57
608 Misspelled country in birth location 15846 304 171 622 2592 10511 1646 12714 149
609 Wrong character in birth location 4287 190 2 529 1831 1658 77 3424
610 Birth location in uppercase 25044 200 551 1251 3945 15983 3114 22169 40
611 Birth location in lowercase 38075 949 207 922 6958 22880 6157 2 27752 76
631 Wrong word in death location 17810 345 15 1987 12693 2770 15042 144
632 Y death location 766 14 7 730 15 78
634 Death location too short 7931 644 128 690 1214 4360 895 5066 59
635 Number in death location 308 68 2 198 40 9 9
636 Bogus death location 325 4 3 150 167 1 300
637 Misspelled word in death location 1254 26 209 134 701 184 591 28
638 Misspelled country in death location 7467 283 81 291 519 4831 1462 5577 102
639 Wrong character in death location 2799 230 4 645 1148 689 83 2463
640 Death location in uppercase 15729 372 193 550 2262 9795 2557 13657 42
641 Death location in lowercase 23297 702 97 301 3515 13659 5021 2 16650 75
661 Wrong word in marriage location 1303 37 1 9 247 762 247 1033 4
664 Marriage location too short 2338 172 3 295 506 1240 122 1714 14
665 Number in marriage location 93 49 1 33 10 5 5
666 Bogus marriage location 1 1 1
667 Misspelled word in marriage location 187 3 3 9 161 11 20 20
668 Misspelled country in marriage location 539 27 4 8 30 411 59 121 36
669 Wrong character in marriage location 827 36 276 381 132 2 775
670 Marriage location in uppercase 4903 112 135 231 841 3106 478 4438 15
671 Marriage location in lowercase 7216 232 29 249 1616 4422 668 5240 32
711 Separators in Prefix 899 76 9 12 13 405 382 2 330 5
712 Number in Prefix 864 40 9 3 648 164 627 1
713 Suffix in Prefix 2240 254 37 34 65 782 1064 4 884 35
714 Wrong word in Prefix 530 100 1 2 5 156 243 23 73 4
721 Separators in First Name 54098 12115 243 2017 4941 28695 6087 34526 172
722 Number in First Name 73 68 5
723 Prefix in First Name 22274 5592 2051 2375 3541 7068 1645 2 17312 69
724 Wrong word in First Name 7712 1934 76 376 779 2990 1556 1 5452 31
725 Wrong character in First Name 524 154 5 128 163 55 19 442
731 Separators in Preferred Name 16865 3303 78 76 123 1892 11308 85 822 33
732 Number in Preferred Name 29 23 6
733 Prefix in Preferred Name 7154 1552 209 195 243 776 4115 64 1372 35
734 Wrong word in Preferred Name 1824 539 3 16 15 122 1111 18 149 3
735 Wrong character in Preferred Name 833 188 5 128 163 60 285 4 443
741 Separators in Middle Name 1351 92 1 59 95 826 278 996 6
742 Number in Middle Name 8 2 6
743 Prefix in Middle Name 3029 144 36 54 278 1934 583 2628 28
744 Wrong word in Middle Name 878 114 3 20 131 470 139 1 745 12
745 Wrong character in Middle Name 7 2 2 1 1 1 6
751 Separators in Nicknames 2785 125 330 299 348 1299 383 1 2472 40
752 Number in Nicknames 59 2 1 54 2 11 9
753 Prefix in Nicknames 3057 238 680 471 523 747 398 2842 35
754 Wrong word in Nicknames 1031 80 57 69 102 532 191 889 13
761 Separators in Suffix 7173 1150 165 748 1390 2325 1388 7 4772 33
762 Number in Suffix 1522 281 141 419 479 201 1 1111 59
763 Prefix in Suffix 8693 927 148 373 907 2023 4294 21 3116 52
764 Wrong word in Suffix 1219 79 67 127 497 442 7 566 20
765 Wrong character in Suffix 30 3 1 25 1 2
771 Separators in Last Name at Birth 5298 1046 77 831 1243 1415 678 8 3414 10
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 2127 434 16 392 530 370 383 2 1388
781 Separators in Current Last Name 3026 667 57 238 348 917 799 1673 14
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 1765 401 19 187 430 336 390 2 1019
791 Separators in Last Name Other 3878 211 191 457 597 1215 1206 1 2427 23
792 Number in Last Name Other 12 4 1 7 1
794 Wrong word in Last Name Other 477 70 20 74 67 119 125 2 300 2
795 Wrong character in Last Name Other 30 7 4 18 1 15
801 Big profile 308 3 50 136 119 232
802 Empty profile 85876 36900 1032 1630 5767 29152 11321 74 45058 229
803 Almost empty profile 26626 5413 747 1269 3696 10654 4810 37 19466 319
811 Uncleaned profile after merge 195149 13168 7023 25937 40487 79914 28483 137 142588 963
821 Headings starts with blank 260 14 7 9 128 102 39 39
822 Heading doesn't end with = 11697 115 38 1259 2082 6230 1968 5 9738 155
823 Heading doesn't start with = 9802 529 99 462 1133 6079 1496 4 7776 83
824 Heading different number of = 2709 47 7 273 530 1422 430 2141 50
825 Use separator line ---- 1596 31 8 93 326 1064 74 1301 27
831 Multiple duplicated lines 36266 609 232 1471 3068 25741 5145 26803 60
835 Local file reference 58505 4425 87 1332 5974 32953 13692 42 38978 670
841 Template doesn't start with double { 109 5 2 10 10 56 26 40 7
842 Template doesn't end with double } 75 1 3 7 32 32 50 24
843 Missing template (spelling) 2379 67 22 149 461 1041 623 16 1475 11
844 Out of use template 81 7 74 3
901 Unconnected empty public profiles 29039 29039 10
902 Unconnected empty open profiles 18760 18760 18760 49
912 Swedish patronym SSON for female 604 3 127 474 498 9

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.







Collaboration

On 21 Mar 2017 at 21:58 GMT Emma (McBeth) MacBeath M.Ed MSM wrote:

Still chipping away at 721 1700-1799

On 21 Mar 2017 at 21:09 GMT Paula (Round) Dea wrote:

667 New done

On 21 Mar 2017 at 09:33 GMT Esmé (Pieterse) van der Westhuizen wrote:

Working Error 106 - 1700 to 1999

On 21 Mar 2017 at 09:32 GMT Esmé (Pieterse) van der Westhuizen wrote:

Error 105 - 1700 to 1999 - Done, Proposed all new merges

On 21 Mar 2017 at 07:36 GMT Eva Ekeblad wrote:

As usual working on error 912. (No 911s at present). I always take a look at the new pre-1800 errors first when a new report is in. The status button is going to be very useful in the long run.

In the short run it does compete with the spreadsheet we have kept since this error was instituted. This error is slow to work, because it usually involves a change of LNAB, for which we need to be allowed onto the trusted-list.

On 21 Mar 2017 at 00:29 GMT Graeme Olney wrote:

as per every week - I'm working on all error types related to New Zealand