upload image

Database errors project (April 25th 2017)

Privacy Level: Open (White)
Date: 25 Apr 2017 to 30 Apr 2017
Location: Worldwidemap
Surname/tag: data_doctors
This page has been accessed 507 times.

Categories: DD Suggestions.

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

Analysis was done on data from April 25th 2017.

Related post.

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

Contents

News

Clean-A-Thon

This week we have 69304 less errors than last week. Good work.

Detailed statistics are available on Wikitree+ in Statistics section.

Find And Replace

I added new possibility to replace one text in location into another. It uses Automatically suggested corrections. It is available on Wikitree+ in Search section Replace Location item.

Example to change Virginia, British Colonial America to Virginia Colony. [1]

Previous news

Added locked icon for PPP profiles

Example: http://wikitree.sdms.si/function/WTStatus/Status.htm?ErrID=555&UserID1=741&UserID2=692

Monitoring status changes

I have the possibility to see last status changes by anyone.

http://wikitree.sdms.si/function/WTStatusReview/Status.htm

Shows all statuses set in last hour.

you can also add TimeRange parameter to change the period. http://wikitree.sdms.si/function/WTStatusReview/Status.htm?TimeRange=2

Shows all statuses set in last 6 hours. Other values 1-1h, 2-6h, 3-12h, 4-1d, 5-2d, 6-7d. There are additional ranges to use only with other parameters. (7-14d, 8-1m, 9-2m, 10-1y, 11-2y, 12-all)

Errors

Analysis was done on data from April 25th 2017.

2151175 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
101 Birth in future 4 4
102 Death in future 68 63 5 1 2
103 Death before birth 7670 7 293 978 4366 1974 52 5275 14
104 Too old 7392 239 1269 2403 3346 131 4 6811 53
105 Duplicate sibling 237 19 30 82 106 133 64
106 Duplicates between global tree and unconnected 907 80 270 410 147 727 204
109 Profile should be open (birth date) 11991 3 12 594 11382 134
110 Profile should be open (death date) 586 73 6 33 251 221 2 7
111 Died too young to be parent 425 27 56 37 171 130 4 328 5
112 Person is Father and mother 587 75 1 4 54 347 106 275 29
113 Duplicate in relatives 1056 248 110 34 117 464 83 519 71
114 Still living status and entered death date 1752 157 3 4 336 1247 5 21 35
115 Still living status and entered death location 188 10 1 6 73 98 17 15
201 Father is self 83 58 18 7 1 1
202 Parents are same 53 4 1 24 24 6 5
203 Father is Female 4086 561 87 408 2517 513 2930 275
204 Father has no Gender 472 392 66 14 3 3
205 Father is too young or not born 34889 1753 3477 7285 16804 5506 64 29476 185
206 Father is too old 4000 359 967 1554 1115 5 3729 15
207 Father is also a child 145 69 13 1 3 48 11 42 3
208 Father is also a spouse 29 6 3 18 2 9 5
209 Father is also a sibling 1300 255 86 68 117 612 162 747 44
210 Father was dead before birth 34294 1431 2377 6214 10038 13570 664 31624 201
211 Duplicate sibling by father 435 1 87 97 179 71 325 69
212 Profile should be open (Child birth date) 2826 2826 24
301 Mother is self 1 1
303 Mother is Male 4102 458 13 140 452 2575 464 2824 142
304 Mother has no Gender 506 439 55 12 7 7
305 Mother too young or not born 45081 2216 4692 10438 21566 6103 66 38652 285
306 Mother is too old 3296 237 707 1237 1112 3 3030 9
307 Mother is also a child 5 1 3 1 2
308 Mother is also a spouse 274 65 39 9 35 117 9 137 23
309 Mother is also a sibling 122 16 1 2 11 70 22 55 1
310 Mother was dead before birth 38684 1801 1692 7001 12179 15331 679 1 35814 270
311 Duplicate sibling by mother 198 5 43 32 75 43 157 53
312 Profile should be open (Child birth date) 2263 2263 35
402 Unknown gender of spouse 647 468 158 21 27 19
403 Single sex marriage 1047 217 6 23 43 636 122 452 201
404 Marriage before birth 6912 165 659 1638 3653 796 1 5808 38
405 Married too old 1527 24 171 499 833 1365 9
406 Marriage after death 9250 305 271 1268 2367 4732 307 8216 65
407 Lived too long after marriage 217 5 11 34 69 84 14 144 7
408 Multiple marriages on same day 3412 311 2 345 922 1734 98 2870 111
409 Marriage to duplicate person 11062 2324 87 921 2376 4983 371 8602 433
410 Marriage in future 3 3
412 Marriage End before marriage 93 3 10 74 6 58 2
413 Marriage too long 1 1 1 1
414 Marriage End before birth 89 5 3 59 22 40 1
415 Marriage End too old 37 20 17 34
416 Marriage End after death 3920 64 120 590 918 1968 260 3619 65
417 Lived too long after marriage End 1 1
418 Partner is also a sibling 418 30 31 48 105 196 8 364 7
501 Wrong gender (male) 3681 1011 2 60 431 1668 505 4 1591 92
502 Missing gender (male) 17787 10910 8 2589 4266 14 105 135
503 Probably wrong gender (male) 4818 1114 28 404 570 1959 734 9 3102 97
504 Missing gender (probably male) 8776 5929 2 696 2116 33 82 80
505 Wrong gender (female) 3953 956 2 80 327 2050 536 2 1778 113
506 Missing gender (female) 14368 9302 6 2376 2674 10 54 101
507 Probably wrong gender (female) 4026 713 18 149 536 1926 683 1 2576 67
508 Missing gender (probably female) 7838 5486 4 4 611 1719 14 116 79
509 Missing gender 36313 27041 16 237 747 4093 4135 44 7767 256
510 Unique name without gender 8722 3967 9 56 205 2317 2121 47 2997 34
511 Unique names (spelling) 261334 46884 7193 11719 19862 99529 74467 1680 158659 2384
551 Wikidata - Missing gender 34 1 33
552 Wikidata - Different gender 7 2 1 4 4 1
553 Wikidata - Empty birth date 144 144 126 3
554 Wikidata - Imprecise birth date 643 129 185 173 122 34 578 20
555 Wikidata - Different birth date 3771 1752 895 466 501 157 3703 46
556 Wikidata - Empty death date 194 46 55 28 27 13 25 159 4
557 Wikidata - Imprecise death date 882 24 267 222 204 121 44 815 25
558 Wikidata - Different death date 3994 61 2344 701 358 434 96 3949 52
559 Wikidata - Missing birth location 1444 34 248 412 308 360 82 1356 28
561 Wikidata - Missing death location 1912 56 432 415 377 498 134 1825 38
563 Wikidata - Possible duplicate by father 55 7 28 5 5 5 5 48 3
564 Wikidata - Possible father 147 7 77 13 11 26 13 131 7
565 Wikidata - Possible duplicate by mother 70 7 46 4 9 1 3 69 6
566 Wikidata - Possible mother 108 8 78 6 1 10 5 98 3
568 Wikidata - Unconnected branches to global tree 4775 56 52 181 423 1827 2231 5 3567 76
569 Wikidata - Unconnected orphans to global tree 5504 24 55 123 507 2393 2401 1 4103 22
571 FindAGrave - Link without Grave ID 53667 585 1 669 5521 32461 14428 2 40067 342
572 FindAGrave - Linked grave not matching profile 22259 1924 3 764 3856 12782 2929 1 19532 329
573 FindAGrave - Empty birth date 724 724 555 33
574 FindAGrave - Imprecise birth date 9792 188 1148 7048 1408 9206 208
575 FindAGrave - Different birth date 22133 59 1305 4136 14468 2165 20469 566
576 FindAGrave - Empty death date 4676 241 77 579 3515 264 4161 114
577 FindAGrave - Imprecise death date 10312 107 4 206 1453 6706 1836 9681 212
578 FindAGrave - Different death date 12139 74 29 955 2758 6893 1430 11403 320
579 FindAGrave - Missing birth location 14848 308 2 210 1904 8952 3472 13668 286
581 FindAGrave - Missing death location 18925 290 6 234 2061 11991 4343 17354 370
585 FindAGrave - Multiple profiles link to same grave ID 1536 17 1 95 410 813 200 1392 130
586 FindAGrave - Link to merged Grave ID 197 5 31 109 52 101 6
587 FindAGrave - Link to nonexisting Grave ID 387 21 61 183 82 39 1 262 6
601 Wrong word in birth location 5679 404 6 557 3695 1017 4013 62
603 USA too early in birth location 201911 38163 163748 201911 1032
604 Birth location too short 6531 802 2 767 923 3379 658 3513 50
605 Number in birth location 470 304 146 20 14 10
606 Bogus birth location 1 1 1
607 Misspelled word in birth location 6744 134 947 1893 3338 432 5522 88
608 Misspelled country in birth location 13558 284 1 510 2250 9085 1428 10571 215
609 Wrong character in birth location 3709 176 1 440 1461 1562 69 3266 3
610 Birth location in uppercase 21958 188 240 1062 3021 14714 2733 19169 102
611 Birth location in lowercase 32712 794 128 805 5776 19710 5497 2 22438 108
631 Wrong word in death location 16659 342 5 1657 11988 2667 13943 147
632 Y death location 702 13 683 6 32
633 USA too early in death location 65063 626 12 42147 22220 54 4 65048 213
634 Death location too short 7679 634 127 638 1148 4250 882 4875 57
635 Number in death location 309 67 4 2 197 39 22 8
636 Bogus death location 237 1 108 127 1 213 1
637 Misspelled word in death location 1120 25 215 145 563 172 486 71
638 Misspelled country in death location 6501 247 26 232 499 4173 1324 4696 181
639 Wrong character in death location 2519 222 2 552 975 694 74 2353 4
640 Death location in uppercase 13937 213 68 444 1764 9178 2270 11918 63
641 Death location in lowercase 20021 704 255 2629 12015 4416 2 13416 110
661 Wrong word in marriage location 1141 37 8 196 699 201 875 11
663 USA too early in marriage location 21997 259 7333 14392 13 21991 113
664 Marriage location too short 2293 166 3 291 499 1212 122 1686 31
665 Number in marriage location 93 49 2 30 12 4 4
667 Misspelled word in marriage location 191 3 6 13 158 11 35 31
668 Misspelled country in marriage location 535 30 2 15 32 393 63 133 67
669 Wrong character in marriage location 788 40 257 355 133 3 758 13
670 Marriage location in uppercase 4323 101 56 191 692 2850 433 3880 26
671 Marriage location in lowercase 6114 203 6 208 1188 3900 609 4174 30
711 Separators in Prefix 839 76 3 10 17 357 374 2 271 3
712 Number in Prefix 765 40 7 1 547 170 522 4
713 Suffix in Prefix 2288 264 27 40 79 764 1109 5 900 69
714 Wrong word in Prefix 471 98 1 3 2 104 240 23 11 6
721 Separators in First Name 50208 11634 231 1845 2007 28470 6021 30937 281
722 Number in First Name 73 68 5
723 Prefix in First Name 20660 5415 1973 2187 3179 6995 909 2 15806 89
724 Wrong word in First Name 7514 1907 76 358 681 2953 1538 1 5305 38
725 Wrong character in First Name 317 133 5 73 67 30 9 254
731 Separators in Preferred Name 16785 3304 72 52 28 1746 11491 92 546 191
732 Number in Preferred Name 28 22 6
733 Prefix in Preferred Name 6563 1554 200 7 8 572 4154 68 733 89
734 Wrong word in Preferred Name 1823 529 3 13 19 134 1108 17 145 17
735 Wrong character in Preferred Name 633 174 5 81 69 37 261 6 265
741 Separators in Middle Name 1291 93 1 56 82 803 256 936 20
742 Number in Middle Name 8 2 6
743 Prefix in Middle Name 3053 145 37 58 274 1845 694 2654 163
744 Wrong word in Middle Name 793 95 23 123 438 113 1 666 6
745 Wrong character in Middle Name 3 2 1 2
751 Separators in Nicknames 2279 123 319 15 131 1305 385 1 1968 34
752 Number in Nicknames 50 2 1 46 1 2
753 Prefix in Nicknames 2795 249 710 157 514 765 400 2586 188
754 Wrong word in Nicknames 889 79 54 15 53 494 194 753 27
755 Wrong character in Nicknames 1 1 1 1
761 Separators in Suffix 4966 699 38 6 670 2182 1365 6 2593 36
762 Number in Suffix 1385 279 12 105 360 424 203 2 971 89
763 Prefix in Suffix 8257 821 45 316 778 1918 4356 23 2631 75
764 Wrong word in Suffix 1095 67 15 88 473 445 7 443 16
765 Wrong character in Suffix 29 3 1 24 1 1
771 Separators in Last Name at Birth 5146 1033 74 712 1196 1428 696 7 3239 13
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 9 4 5 9
775 Wrong character in Last Name at Birth 1971 404 16 319 501 370 359 2 1381 35
781 Separators in Current Last Name 2553 542 60 210 202 738 801 1188 32
783 Prefix in Current Last Name 2 2
784 Wrong word in Current Last Name 194 26 30 69 37 16 16 183 1
785 Wrong character in Current Last Name 1535 372 19 99 367 327 349 2 953 35
791 Separators in Last Name Other 2697 141 191 196 531 533 1104 1 1216 39
792 Number in Last Name Other 11 4 1 6 1 1
794 Wrong word in Last Name Other 280 52 56 24 27 119 2 103 2
795 Wrong character in Last Name Other 10 1 9 1
801 Big profile 293 2 50 134 107 217
802 Empty profile 83420 35901 904 1476 5353 28481 11229 76 43313 339
803 Almost empty profile 26670 5374 726 1194 3620 10840 4878 38 19498 396
811 Uncleaned profile after merge 191125 12778 6434 24626 39493 79102 28592 100 139222 1524
821 Headings starts with blank 341 13 3 19 26 176 104 120 118
822 Heading doesn't end with = 9479 114 5 338 1666 5461 1890 5 7476 174
823 Heading doesn't start with = 8231 476 5 365 934 5133 1313 5 6208 113
824 Heading different number of = 1781 46 2 180 356 824 372 1 1214 99
825 Use separator line ---- 1330 9 49 256 941 75 1040 5
831 Multiple duplicated lines 36039 596 231 1427 3006 25664 5115 26724 95
835 Local file reference 59449 4337 80 1224 6039 33730 14000 39 39796 941
841 Template doesn't start with double { 90 7 3 1 6 44 29 23 20
842 Template doesn't end with double } 63 1 3 12 26 21 37 37
843 Missing template (spelling) 792 43 4 73 135 364 173 576 52
844 Out of use template 59 5 54 1
851 GEDCOM uncleaned Interpret date 72679 33316 312 3032 7914 23144 4948 13 40846 219
852 GEDCOM uncleaned Parse Lastname 9811 4193 160 844 1356 2782 475 1 6235 15
901 Unconnected empty public profiles 27544 27544 27
902 Unconnected empty open profiles 17974 17974 17974 127
911 Swedish patronym DOTTER for male 1 1 1 1
912 Swedish patronym SSON for female 540 1 2 58 479 435 12

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.







Collaboration

On 28 Apr 2017 at 06:10 GMT Eva Ekeblad wrote:

912 never ends

On 26 Apr 2017 at 23:50 GMT Emma (McBeth) MacBeath M.Ed MSM wrote:

Still working on Error 721 1700-1799 (at least there is more than 50% gone now!)

On 26 Apr 2017 at 20:17 GMT Graeme Olney wrote:

As always - All Error Codes - New Zealand related