upload image

Database errors project (May 21st 2017)

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

Related post.

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

Contents

News

Previous news

New link to error report

Chris added new link to errors on profiles, that user maneges. It is located in My wikitree menu, fifth item Error report. This is most useful link to see errors on your profiles.

Statistics of Lists By

On WikiTree+ I added statistics on total number of error for each group, that I prepare specialised lists for. They have only one value for now, but trends will be visible in time.

Location Find and Replace

I changed the function, so it compares end of location text with Find text. And it replaces only the found part. Before whole text had to match.

When making a change, I also added reformatting of the string. I remove all double spaces, all spaces before each comma and dot, and add single space after each comma and dot. Exception is dot and comma together ".,", where I don't add space between them.

I also removed the Maximum number of profiles.

For those who missed initial announcement, here is the old news: 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]

Prepared error lists By...

I made error lists we used during Clean-A-Thon as part of weekly update. Here is central navigation page for prepared error lists: Space:DBE_Errors_By. I will add all lists here.

I prepared errors for all US states and some countries, that were used during CAT. Also for some projects are prepared lists. I am still not sure about naming project pages. US states will be named with 2 letter code. DBE_ErrorList_XX You can put any table on any page you want like {{:DBE_ErrorList_ME}}. It will be updated automatically on all pages where this is used. For other countries 3 letter code is used. For projects, I didn't decide jet.

There may also be some errors shown, that don't belong to that country. If you find a few of them, let me know, so I can try to find the pattern and improve error selection. I didn't check the lists. It is a lot of them. I know that West Virginia errors are shown also in Virginia error report. For other I don't know.

Errors

Analysis was done on data from May 21st 2017.

2112677 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 66 61 5 1 1
103 Death before birth 6870 3 276 910 3966 1666 49 5550 9
104 Too old 7312 232 1246 2391 3310 129 4 7014 27
105 Duplicate sibling 252 23 31 94 104 175 38
106 Duplicates between global tree and unconnected 798 79 287 300 132 662 99
109 Profile should be open (birth date) 744 1 8 433 302 14
110 Profile should be open (death date) 250 2 26 44 177 1 1
111 Died too young to be parent 418 27 55 37 168 127 4 360
112 Person is Father and mother 556 71 1 3 51 314 116 316 9
113 Duplicate in relatives 1050 242 103 36 144 440 85 682 49
114 Still living status and entered death date 1691 152 1 2 270 1260 6 18 32
115 Still living status and entered death location 138 11 32 95 7 9
201 Father is self 74 57 1 9 7 1 1
202 Parents are same 52 4 4 22 22 8 1
203 Father is Female 3894 546 82 396 2352 518 3092 28
204 Father has no Gender 461 397 12 40 12 26 26
205 Father is too young or not born 34515 1734 3452 7226 16653 5387 63 31107 102
206 Father is too old 3819 352 919 1495 1048 5 3742 14
207 Father is also a child 146 65 12 5 5 45 14 63 2
208 Father is also a spouse 24 7 3 12 2 12 2
209 Father is also a sibling 1304 244 81 71 135 607 166 883 32
210 Father was dead before birth 33726 1420 2344 6059 9905 13350 648 33242 141
211 Duplicate sibling by father 330 79 74 104 73 253 40
212 Profile should be open (Child birth date) 2758 2758 16
301 Mother is self 1 1
303 Mother is Male 4057 444 6 138 434 2563 472 3157 47
304 Mother has no Gender 504 445 17 29 13 29 28
305 Mother too young or not born 44520 2190 4641 10374 21383 5868 64 40521 159
306 Mother is too old 3105 219 680 1162 1040 4 3018 9
307 Mother is also a child 5 1 2 2 1
308 Mother is also a spouse 282 59 37 9 45 123 9 193 19
309 Mother is also a sibling 120 15 1 4 14 67 19 79 1
310 Mother was dead before birth 38080 1762 1658 6821 12123 15058 657 1 37660 232
311 Duplicate sibling by mother 191 4 42 25 71 49 157 11
312 Profile should be open (Child birth date) 2138 2138 14
402 Unknown gender of spouse 661 485 24 128 24 101 52
403 Single sex marriage 1066 210 5 25 46 652 128 670 37
404 Marriage before birth 6696 165 647 1581 3585 718 6097 27
405 Married too old 1495 24 170 486 815 1480 2
406 Marriage after death 9002 302 267 1240 2337 4571 285 8859 41
407 Lived too long after marriage 178 3 11 29 59 62 14 140 3
408 Multiple marriages on same day 3373 311 2 341 922 1694 103 3088 76
409 Marriage to duplicate person 10958 2239 83 878 2429 4949 380 9056 278
410 Marriage in future 1 1
412 Marriage End before marriage 79 6 71 2 63 1
414 Marriage End before birth 87 5 3 59 20 56 4
415 Marriage End too old 25 14 11 25
416 Marriage End after death 3932 66 119 580 920 1985 262 3819 50
417 Lived too long after marriage End 2 2 1 2
418 Partner is also a sibling 407 26 30 47 108 188 8 377 3
501 Wrong gender (male) 3124 1024 2 60 383 1105 546 4 1432 101
502 Missing gender (male) 17844 11009 1 1 22 2470 4324 17 1423 122
503 Probably wrong gender (male) 4812 1103 26 344 573 1957 797 12 3303 62
504 Missing gender (probably male) 8871 6072 3 680 2084 32 435 53
505 Wrong gender (female) 3999 940 3 80 340 2068 566 2 2411 75
506 Missing gender (female) 14412 9372 1 23 2303 2705 8 1342 102
507 Probably wrong gender (female) 4116 702 17 152 547 1965 732 1 2867 39
508 Missing gender (probably female) 7623 5572 3 6 332 1696 14 62 43
509 Missing gender 36427 27159 12 234 748 4097 4131 46 8937 221
510 Unique name without gender 8664 3972 10 56 199 2277 2110 40 3550 43
511 Unique names (spelling) 263960 46917 7260 11828 20086 100846 75326 1697 171319 1675
551 Wikidata - Missing gender 33 1 32
552 Wikidata - Different gender 8 1 2 5 3
553 Wikidata - Empty birth date 139 139 122 1
554 Wikidata - Imprecise birth date 642 128 174 173 131 36 607 16
555 Wikidata - Different birth date 3782 1754 878 474 514 162 3741 26
556 Wikidata - Empty death date 189 45 54 26 28 13 23 157
557 Wikidata - Imprecise death date 871 26 261 211 203 126 44 835 13
558 Wikidata - Different death date 3994 57 2356 694 359 434 94 3974 28
559 Wikidata - Missing birth location 1475 35 257 405 314 372 92 1422 27
561 Wikidata - Missing death location 1923 56 432 413 384 507 131 1866 20
563 Wikidata - Possible duplicate by father 62 9 28 8 6 6 5 56 7
564 Wikidata - Possible father 138 6 74 11 11 24 12 127 2
565 Wikidata - Possible duplicate by mother 67 7 45 3 10 2 66 1
566 Wikidata - Possible mother 108 8 81 6 1 5 7 102 8
568 Wikidata - Unconnected branches to global tree 4818 56 52 190 431 1842 2242 5 3683 45
569 Wikidata - Unconnected orphans to global tree 5505 23 57 117 507 2395 2405 1 4123 20
571 FindAGrave - Link without Grave ID 53987 588 2 648 5500 32722 14524 3 43405 407
572 FindAGrave - Linked grave not matching profile 22312 1930 6 740 3850 12831 2954 1 20443 277
573 FindAGrave - Empty birth date 741 741 584 27
574 FindAGrave - Imprecise birth date 10136 185 1181 7310 1460 9793 287
575 FindAGrave - Different birth date 22471 61 1290 4187 14725 2208 21580 427
576 FindAGrave - Empty death date 4714 250 1 76 590 3522 275 4361 93
577 FindAGrave - Imprecise death date 10628 108 5 213 1477 6931 1894 10199 252
578 FindAGrave - Different death date 12119 79 28 957 2749 6878 1428 11768 218
579 FindAGrave - Missing birth location 15152 320 3 208 1934 9097 3590 14405 340
581 FindAGrave - Missing death location 19323 301 7 234 2080 12255 4446 18314 427
585 FindAGrave - Multiple profiles link to same grave ID 1381 13 90 419 761 98 1312 50
586 FindAGrave - Link to merged Grave ID 163 5 1 25 85 47 95 25
587 FindAGrave - Link to nonexisting Grave ID 455 21 63 196 118 56 1 382 65
601 Wrong word in birth location 5357 406 1 511 3422 1017 4216 26
603 USA too early in birth location 198162 36711 161451 198162 730
604 Birth location too short 6412 767 1 753 942 3274 675 4587 45
605 Number in birth location 353 272 1 60 20 12 11
607 Misspelled word in birth location 6101 128 1 549 1795 3243 385 5549 82
608 Misspelled country in birth location 13082 280 1 443 2211 8745 1402 11485 149
609 Wrong character in birth location 3668 176 1 435 1455 1534 67 3497 11
610 Birth location in uppercase 20552 183 1 1041 2619 14147 2561 19197 89
611 Birth location in lowercase 32573 788 91 813 5711 19710 5458 2 26808 164
631 Wrong word in death location 14790 337 7 1380 10552 2514 13291 48
632 Y death location 500 13 481 6 263
633 USA too early in death location 62938 629 7 40537 21720 43 2 62932 164
634 Death location too short 7487 633 125 633 1154 4050 892 6067 50
635 Number in death location 292 66 5 184 37 116 9
636 Bogus death location 34 18 16 34 1
637 Misspelled word in death location 762 19 192 125 274 152 413 34
638 Misspelled country in death location 6134 240 21 225 513 3811 1324 5131 123
639 Wrong character in death location 2486 221 2 545 964 680 74 2395 5
640 Death location in uppercase 12563 216 2 431 1310 8509 2095 11427 41
641 Death location in lowercase 19833 673 250 2593 11921 4394 2 15729 157
661 Wrong word in marriage location 1097 37 1 184 668 207 960 7
663 USA too early in marriage location 21192 249 6944 13986 13 21191 54
664 Marriage location too short 2293 157 3 289 509 1211 124 1924 15
665 Number in marriage location 72 40 21 11 2 2
667 Misspelled word in marriage location 84 3 5 9 55 12 28 28
668 Misspelled country in marriage location 303 24 3 16 28 183 49 120 41
669 Wrong character in marriage location 799 40 257 355 144 3 789 9
670 Marriage location in uppercase 4039 96 54 188 561 2725 415 3828 11
671 Marriage location in lowercase 6055 200 6 203 1178 3869 599 5018 26
711 Separators in Prefix 805 72 3 8 16 327 377 2 347 3
712 Number in Prefix 515 40 1 3 298 173 281 2
713 Suffix in Prefix 2371 256 27 38 92 790 1162 6 1016 28
714 Wrong word in Prefix 463 97 1 6 105 246 8 113 6
721 Separators in First Name 48837 11534 221 1796 976 28272 6038 34951 200
722 Number in First Name 69 65 4 4
723 Prefix in First Name 20424 5333 1937 2141 3102 6988 921 2 16673 72
724 Wrong word in First Name 7524 1885 76 354 657 2950 1600 2 6150 45
725 Wrong character in First Name 301 131 5 68 61 29 7 250
731 Separators in Preferred Name 16793 3282 70 53 21 1743 11540 84 568 44
732 Number in Preferred Name 28 22 6
733 Prefix in Preferred Name 6413 1565 187 10 16 381 4193 61 579 31
734 Wrong word in Preferred Name 1818 527 3 13 18 135 1107 15 166 6
735 Wrong character in Preferred Name 618 172 5 76 63 36 260 6 262 1
741 Separators in Middle Name 1294 91 2 48 85 806 262 1036 5
742 Number in Middle Name 9 2 7 1
743 Prefix in Middle Name 3077 145 36 58 274 1861 703 2819 30
744 Wrong word in Middle Name 802 96 23 120 439 123 1 713 5
745 Wrong character in Middle Name 2 1 1 1
751 Separators in Nicknames 2350 126 315 20 137 1347 404 1 2167 40
752 Number in Nicknames 49 2 47 38 1
753 Prefix in Nicknames 2920 250 724 170 508 845 423 2762 35
754 Wrong word in Nicknames 890 75 54 14 48 502 197 804 11
755 Wrong character in Nicknames 1 1 1
761 Separators in Suffix 4957 701 34 8 671 2176 1361 6 2955 9
762 Number in Suffix 1310 282 12 98 351 358 208 1 935 10
763 Prefix in Suffix 8316 825 45 308 784 1922 4410 22 2915 56
764 Wrong word in Suffix 1052 58 14 82 453 438 7 471 2
765 Wrong character in Suffix 29 3 1 24 1 25
771 Separators in Last Name at Birth 5170 1027 74 712 1218 1436 697 6 3739 29
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 1932 399 16 309 496 347 364 1 1394 2
781 Separators in Current Last Name 2597 538 60 215 213 754 817 1411 25
783 Prefix in Current Last Name 2 2
784 Wrong word in Current Last Name 184 25 30 67 31 16 15 173
785 Wrong character in Current Last Name 1498 369 19 92 360 304 353 1 971 2
791 Separators in Last Name Other 2767 141 190 204 533 576 1122 1 1417 30
792 Number in Last Name Other 11 4 7 1
794 Wrong word in Last Name Other 278 51 1 52 19 27 126 2 105 2
795 Wrong character in Last Name Other 9 9
801 Big profile 366 3 50 167 146 274
802 Empty profile 81159 35285 905 8 5088 28421 11375 77 49072 524
803 Almost empty profile 26789 5373 743 1142 3585 11013 4896 37 21005 161
811 Uncleaned profile after merge 191246 12584 6259 24099 39262 79752 29211 79 153386 1173
821 Headings starts with blank 216 13 6 17 74 106 48 38
822 Heading doesn't end with = 9763 120 2 308 1695 5518 2115 5 8087 135
823 Heading doesn't start with = 8087 454 5 364 904 5023 1332 5 6706 78
824 Heading different number of = 1274 50 1 86 231 569 335 2 825 77
825 Use separator line ---- 1315 9 50 251 924 81 1157 15
831 Multiple duplicated lines 36043 583 227 1411 2989 25687 5146 30651 76
835 Local file reference 60554 4308 78 1198 6213 34391 14340 26 44799 755
841 Template doesn't start with double { 58 4 1 4 1 16 32 17 16
842 Template doesn't end with double } 40 2 1 1 13 22 1 16 17
843 Missing template (spelling) 863 43 1 69 163 389 198 660 155
844 Out of use template 58 5 53
851 GEDCOM uncleaned Interpret date 72000 33076 306 2985 7864 22877 4886 6 45990 184
852 GEDCOM uncleaned Parse Lastname 9677 4178 160 821 1333 2719 465 1 6774 45
901 Unconnected empty public profiles 27146 27146 4
902 Unconnected empty open profiles 17854 17854 17854 32
911 Swedish patronym DOTTER for male 1 1 1 1
912 Swedish patronym SSON for female 499 1 26 472 499 7

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.







Collaboration

On 30 May 2017 at 04:44 GMT Loretta (Leger) Corbin wrote:

Working on DeCoursey GedCom Errors

On 28 May 2017 at 21:11 GMT Aleš Trtnik wrote:

I am done with Soft hyphen errors.

On 28 May 2017 at 15:58 GMT Paula (Round) Dea wrote:

667 - all that can be cleared

665 - all that can be cleared Aleš are the errors your working on the 669 ones?

On 25 May 2017 at 07:27 GMT Aleš Trtnik wrote:

Working on (Soft hyphen) in UTF errors

On 24 May 2017 at 10:04 GMT Mark Dorney wrote:

103 in Australia down two to seven this week. Five private messages sent. Hopefully will not have to resort to unresponsive manager request.

Getting bogged down in 205s. Some surprisingly thorny problems.

On 22 May 2017 at 22:16 GMT Emma (McBeth) MacBeath M.Ed MSM wrote:

Working on my old friend 721 1700-1799. Down to only 976! Maybe I can wipe that out this week? Then I can move on to the next century.