upload image

Database errors project (December 11 2016)

Privacy Level: Open (White)
Date: 11 Dec 2016 to 18 Dec 2016
Location: Worldwidemap
Surname/tag: data_doctors
Profile manager: Aleš Trtnik private message [send private message]
This page has been accessed 983 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 December 11th 2016.

Related post.

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

Contents

News

Added coloring of errors

Red are errors that should be corrected, orange are more like a warning and blue are tree related (unconnected profiles and merging proposals).

Creator field removed

Creator field was removed from database dump, so it was removed also from error reports. Searches by creator are replaced with searches by manager.

Added edit link in compare branches

In compare branches report, I added compare and merge on wikitree links, that goes directly into merge process on wikitree to compares profiles side by side. There is one link in correct direction in case of same LNAB. If LNABs are different, there are two links to choose from.

Examples: [1], [2]

Previous news

Errors

Analysis was done on data from December 11th 2016.

1687431 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-Now Now-9999 Open New
102 Death in future 73 1 67 5 3
103 Death before birth 11313 19 467 1244 5192 4331 60 8653 8
104 Too old 7752 286 1373 2534 3412 143 4 7114 26
105 Duplicate sibling 571 30 48 244 249 366 27
106 Duplicates between global tree and unconnected 788 134 268 279 107 620 47
109 Profile should be open (birth date) 9723 5 13 657 9048 76
110 Profile should be open (death date) 612 85 6 20 269 230 2 6
111 Died too young to be parent 479 35 59 54 185 139 7 367 1
112 Person is Father and mother 618 95 5 9 76 321 112 280 10
201 Father is self 87 57 23 7 1
202 Parents are same 72 9 4 27 32 17 4
203 Father is Female 4496 696 20 150 692 2426 512 3218 23
204 Father has no Gender 543 390 6 130 17 21 26
205 Father is too young or not born 37905 1924 3856 7807 17471 6779 68 31986 122
206 Father is too old 5427 395 1143 2029 1854 6 5105 6
207 Father is also a child 175 72 14 5 14 56 14 62 3
208 Father is also a spouse 29 4 3 1 3 18 10 1
209 Father is also a sibling 1440 278 95 112 104 704 147 822 20
210 Father was dead before birth 37489 1535 2550 6971 10969 14708 756 34472 140
211 Duplicate sibling by father 845 1 101 147 533 63 483 28
212 Profile should be open (Child birth date) 3053 3053 13
303 Mother is Male 4828 563 53 211 823 2678 500 3396 15
304 Mother has no Gender 556 461 9 67 19 10 10
305 Mother too young or not born 48565 2375 5192 11096 22367 7464 71 41607 182
306 Mother is too old 4443 278 855 1562 1744 4 4136 13
307 Mother is also a child 4 1 2 1 2
308 Mother is also a spouse 312 68 48 21 47 119 9 167 15
309 Mother is also a sibling 113 23 1 1 3 65 20 41 3
310 Mother was dead before birth 42310 1875 1825 8082 13284 16465 778 1 39002 149
311 Duplicate sibling by mother 618 7 49 73 385 104 350 8
312 Profile should be open (Child birth date) 2343 2343 6
402 Unknown gender of spouse 706 488 2 184 32 26 17
403 Single sex marriage 783 227 12 25 16 436 67 145 23
404 Marriage before birth 8446 197 764 1824 4091 1569 1 7166 24
405 Married too old 2070 40 278 610 1142 1868 8
406 Marriage after death 10677 332 319 1554 2703 5373 396 9459 26
407 Lived too long after marriage 315 8 10 42 95 135 25 220 3
408 Multiple marriages on same day 3733 392 6 427 1024 1755 129 3083 63
409 Marriage to duplicate person 11717 2713 102 1068 2444 4981 409 8998 205
501 Wrong gender (male) 4003 943 11 49 484 2109 405 2 2026 67
502 Missing gender (male) 50219 41540 5 3218 5438 17 1 1023 224
503 Probably wrong gender (male) 4975 1257 45 445 605 1979 633 11 3126 94
504 Missing gender (probably male) 28059 24392 1 1 804 2819 42 213 442
505 Wrong gender (female) 5580 1118 3 174 420 3303 559 3 3312 112
506 Missing gender (female) 38117 32338 3 2592 3172 12 69 205
507 Probably wrong gender (female) 4710 772 20 191 593 2056 1076 2 3142 40
508 Missing gender (probably female) 24830 21571 4 1 10 994 2233 17 557 171
509 Missing gender 103717 92090 18 311 857 4986 5408 47 9442 563
510 Unique name without gender 20156 11480 10 127 238 4435 3811 55 6544 96
511 Unique names (spelling) 267318 53592 7705 12493 20102 98924 72933 1569 155870 1480
551 Wikidata - Missing gender 37 1 1 35 1
552 Wikidata - Different gender 5 1 4
553 Wikidata - Empty birth date 268 268 249
554 Wikidata - Imprecise birth date 936 130 197 193 329 87 868 2
555 Wikidata - Different birth date 3639 1725 855 410 494 154 1 3566 7
556 Wikidata - Empty death date 318 119 63 34 29 47 26 286 3
557 Wikidata - Imprecise death date 1152 31 261 239 208 330 83 1086 4
558 Wikidata - Different death date 3872 75 2346 645 320 382 104 3831 13
559 Wikidata - Missing birth location 1867 49 242 429 386 578 183 1778 30
561 Wikidata - Missing death location 2322 85 414 436 439 713 235 2236 48
568 Wikidata - Unconnected branches to global tree 4350 149 57 161 416 1645 1918 4 3213 11
569 Wikidata - Unconnected orphans to global tree 5412 30 51 119 539 2395 2277 1 4036 3
601 Wrong word in birth location 6680 491 42 878 4124 1145 4878 39
604 Birth location too short 7329 1027 41 914 989 3689 669 3959 64
605 Number in birth location 541 333 1 1 183 23 33 7
606 Bogus birth location 4 1 3 2
607 Misspelled word in birth location 9229 161 143 1331 2835 4217 542 7886 79
608 Misspelled country in birth location 19441 332 179 1075 3515 11971 2369 16114 122
609 Wrong character in birth location 5057 271 704 2148 1796 138 4182 5
610 Birth location in uppercase 28293 452 581 1370 4397 18050 3443 24272 77
611 Birth location in lowercase 40309 1235 211 1167 7740 23644 6310 2 29790 129
631 Wrong word in death location 18221 476 10 2223 12633 2879 15317 64
632 Y death location 1088 14 1000 74 9
634 Death location too short 8156 687 133 706 1235 4488 907 4852 35
635 Number in death location 326 67 1 3 215 40 5 4
636 Bogus death location 401 5 43 189 162 2 371
637 Misspelled word in death location 2219 44 216 446 1182 331 1505 30
638 Misspelled country in death location 10526 356 88 401 1795 6126 1760 8515 86
639 Wrong character in death location 3518 411 828 1378 780 121 3179 6
640 Death location in uppercase 18209 517 204 635 2666 11371 2816 15624 28
641 Death location in lowercase 26737 1593 101 683 4173 14944 5241 2 19950 100
661 Wrong word in marriage location 1298 37 14 253 750 244 1017 5
664 Marriage location too short 2383 185 1 299 508 1265 125 1684 9
665 Number in marriage location 97 51 1 32 13 3 1
667 Misspelled word in marriage location 609 4 8 180 404 13 413 18
668 Misspelled country in marriage location 1784 72 19 106 397 1046 144 1264 28
669 Wrong character in marriage location 962 59 317 442 142 2 905 2
670 Marriage location in uppercase 5860 139 142 270 983 3784 542 5208 6
671 Marriage location in lowercase 7876 249 34 293 1872 4697 731 5847 21
711 Separators in Prefix 932 80 9 45 36 392 369 1 357 2
712 Number in Prefix 1059 38 9 35 828 149 842 1
713 Suffix in Prefix 2130 248 17 23 64 805 971 2 866 31
714 Wrong word in Prefix 496 99 2 3 4 135 229 24 35 2
721 Separators in First Name 48184 8031 237 2049 5568 26693 5606 31917 304
722 Number in First Name 77 70 7 1
723 Prefix in First Name 23382 6029 2103 2658 3925 7050 1615 2 18201 38
724 Wrong word in First Name 7656 1970 79 406 811 2927 1462 1 5320 25
725 Wrong character in First Name 1184 297 7 316 376 168 20 1061 4
731 Separators in Preferred Name 14899 2489 73 82 106 1815 10265 69 799 40
732 Number in Preferred Name 37 31 1 5
733 Prefix in Preferred Name 7045 1559 215 208 254 782 3966 61 1465 34
734 Wrong word in Preferred Name 1810 545 3 16 13 126 1090 17 160 13
735 Wrong character in Preferred Name 295 31 1 1 1 6 251 4 4
741 Separators in Middle Name 1340 98 1 64 93 816 268 981 9
742 Number in Middle Name 8 2 6
743 Prefix in Middle Name 2912 151 37 63 281 1831 549 2485 27
744 Wrong word in Middle Name 899 115 3 25 137 482 136 1 767 11
745 Wrong character in Middle Name 10 4 4 2 9
751 Separators in Nicknames 2681 121 335 308 333 1241 342 1 2349 12
752 Number in Nicknames 137 4 2 29 102 89
753 Prefix in Nicknames 3186 280 862 460 522 706 356 2967 23
754 Wrong word in Nicknames 1005 82 59 81 95 502 186 860 8
755 Wrong character in Nicknames 7 2 5 7
761 Separators in Suffix 7661 1188 174 974 1621 2334 1362 8 5249 52
762 Number in Suffix 1444 281 128 392 440 202 1 1028 4
763 Prefix in Suffix 8695 975 185 476 953 2027 4063 16 3297 30
764 Wrong word in Suffix 1317 86 3 137 145 491 449 6 677 6
765 Wrong character in Suffix 42 6 1 34 1 3
771 Separators in Last Name at Birth 5464 1087 77 932 1291 1395 674 8 3564 386
772 Number in Last Name at Birth 10 10
773 Prefix in Last Name at Birth 16 6 1 2 1 6 5 2
774 Wrong word in Last Name at Birth 11 4 5 1 1 11
775 Wrong character in Last Name at Birth 2275 483 19 487 564 367 353 2 1567 2
781 Separators in Current Last Name 7012 1495 101 884 1309 1965 1250 8 4320 295
782 Number in Current Last Name 10 10
783 Prefix in Current Last Name 16 6 2 8 2 2
784 Wrong word in Current Last Name 226 28 31 92 38 21 16 215
785 Wrong character in Current Last Name 2054 467 16 341 502 360 366 2 1336 3
791 Separators in Last Name Other 3934 242 198 593 600 1164 1136 1 2539 93
792 Number in Last Name Other 8 3 5
794 Wrong word in Last Name Other 483 71 21 82 60 121 126 2 313 5
795 Wrong character in Last Name Other 22 1 2 3 2 14 14
801 Big profile 245 3 1 11 88 142 162
802 Empty profile 85943 36139 1060 1712 6376 29340 11244 72 43809 305
803 Almost empty profile 26476 5336 760 1318 3674 10578 4776 34 19023 182
811 Uncleaned profile after merge 197659 13511 7459 28923 42460 78347 26833 126 145368 808
821 Headings starts with blank 1086 19 52 44 60 787 124 840 56
822 Heading doesn't end with = 13460 366 688 1623 2424 6479 1877 3 11582 106
823 Heading doesn't start with = 11143 566 118 580 1377 6837 1661 4 8562 49
824 Heading different number of = 3497 46 105 390 729 1709 518 2917 30
825 Use separator line ---- 1758 34 8 109 365 1167 75 1466 7
831 Multiple duplicated lines 36246 616 244 1556 3109 25607 5114 23910 43
901 Unconnected empty public profiles 35323 35323 19
902 Unconnected empty open profiles 18121 18121 18121 94
911 Swedish patronym DOTTER for male 3 3 2
912 Swedish patronym SSON for female 951 5 41 369 536 815 13

Changes since previous update

Detailed statistics are available on http://wikitree.sdms.si/default.htm in Statistics section.







Collaboration

On 16 Dec 2016 at 21:41 GMT B. W. J. Molier wrote:

Great job on the "compare branches"! Hurray for Aleš :)

On 13 Dec 2016 at 16:00 GMT Aleš Trtnik wrote:

Wrong character errors for Prytz-81

On 13 Dec 2016 at 15:15 GMT Sarah (Callis) Rojas wrote:

I've been going through my surname lists; so far Callis & Cleaver and mostly doing merging, spelling errors, gender errors, name field errors and the like.