upload image

Database errors project (May 7th 2017)

Privacy Level: Open (White)
Date: 7 May 2017 to 14 May 2017
Location: Worldwidemap
Surname/tag: data_doctors
This page has been accessed 622 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 7th 2017.

Related post.

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

Contents

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.

Previous news

Public profiles opened

As some of you already noticed, 600000 public profiiles were opened last week. That enables you to correct many errors, that coulcn't be corrected before.

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. [2]

Errors

Analysis was done on data from May 7th 2017.

2126842 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 7196 6 284 942 4080 1834 50 5860 7
104 Too old 7376 236 1252 2400 3355 129 4 7074 44
105 Duplicate sibling 255 24 32 86 113 176 51
106 Duplicates between global tree and unconnected 944 86 324 378 156 801 225
109 Profile should be open (birth date) 789 1 17 454 317 23
110 Profile should be open (death date) 279 4 7 37 51 179 1 11
111 Died too young to be parent 424 27 55 37 173 128 4 366 1
112 Person is Father and mother 593 73 1 3 57 345 114 357 13
113 Duplicate in relatives 1078 250 106 42 131 464 85 703 53
114 Still living status and entered death date 1772 156 3 10 338 1259 6 98 30
115 Still living status and entered death location 195 10 1 10 71 103 64 8
201 Father is self 82 58 17 7 9 3
202 Parents are same 56 4 1 6 23 22 11 7
203 Father is Female 4051 559 85 416 2478 513 3249 32
204 Father has no Gender 482 384 1 85 12 58 53
205 Father is too young or not born 34749 1746 3478 7276 16742 5443 64 31325 115
206 Father is too old 3910 356 937 1524 1088 5 3830 8
207 Father is also a child 155 70 13 3 4 52 13 68 3
208 Father is also a spouse 22 7 2 11 2 10 4
209 Father is also a sibling 1337 249 84 67 136 631 170 898 42
210 Father was dead before birth 34057 1441 2363 6143 10003 13457 650 33569 166
211 Duplicate sibling by father 358 1 85 86 113 73 278 44
212 Profile should be open (Child birth date) 2833 2833 20
301 Mother is self 1 1
303 Mother is Male 4152 450 12 139 487 2604 460 3245 97
304 Mother has no Gender 500 438 1 49 12 30 29
305 Mother too young or not born 44862 2203 4674 10426 21483 6012 64 40840 205
306 Mother is too old 3208 230 695 1194 1085 4 3116 10
307 Mother is also a child 6 1 2 3 2
308 Mother is also a spouse 289 68 38 10 40 124 9 193 17
309 Mother is also a sibling 121 15 1 3 13 70 19 80 10
310 Mother was dead before birth 38352 1791 1679 6949 12116 15149 667 1 37928 191
311 Duplicate sibling by mother 196 5 42 25 76 48 161 36
312 Profile should be open (Child birth date) 2230 2230 15
402 Unknown gender of spouse 645 464 3 157 21 99 44
403 Single sex marriage 1066 216 5 26 50 647 122 671 48
404 Marriage before birth 6809 164 650 1612 3611 771 1 6194 23
405 Married too old 1518 24 171 493 830 1503 9
406 Marriage after death 9136 308 269 1259 2357 4644 299 8993 51
407 Lived too long after marriage 188 5 11 30 58 70 14 148 3
408 Multiple marriages on same day 3413 307 2 347 916 1735 106 3130 88
409 Marriage to duplicate person 11025 2230 84 893 2399 5031 388 9109 289
410 Marriage in future 2 2 1
411 Marriage End in future 1 1 1 1
412 Marriage End before marriage 81 7 72 2 66 1
413 Marriage too long 2 1 1 2 2
414 Marriage End before birth 84 5 3 56 20 54
415 Marriage End too old 29 2 14 13 29 4
416 Marriage End after death 3924 65 120 584 916 1977 262 3811 39
418 Partner is also a sibling 413 30 30 47 106 191 9 383 7
501 Wrong gender (male) 3475 1013 3 61 412 1459 523 4 1808 62
502 Missing gender (male) 17794 10947 5 2536 4290 16 1466 118
503 Probably wrong gender (male) 4805 1130 28 399 570 1902 765 11 3284 136
504 Missing gender (probably male) 8902 6129 1 659 2081 32 422 203
505 Wrong gender (female) 3972 942 3 76 329 2068 552 2 2386 54
506 Missing gender (female) 14353 9313 4 2343 2683 10 1362 95
507 Probably wrong gender (female) 3896 680 17 150 538 1827 683 1 2703 63
508 Missing gender (probably female) 7748 5544 4 6 497 1683 14 293 140
509 Missing gender 36403 26987 16 235 754 4170 4194 47 8983 451
510 Unique name without gender 8705 3964 9 56 200 2310 2119 47 3574 40
511 Unique names (spelling) 263000 46964 7248 11783 19994 100317 74989 1705 170251 1656
551 Wikidata - Missing gender 34 1 33
552 Wikidata - Different gender 10 2 2 6 5 1
553 Wikidata - Empty birth date 144 144 126
554 Wikidata - Imprecise birth date 624 129 172 165 124 34 589 1
555 Wikidata - Different birth date 3779 1755 884 470 509 160 1 3736 21
556 Wikidata - Empty death date 192 45 55 26 27 14 24 1 158 1
557 Wikidata - Imprecise death date 864 24 265 212 199 121 43 828
558 Wikidata - Different death date 3993 60 2353 692 357 436 95 3971 13
559 Wikidata - Missing birth location 1456 33 252 408 307 364 92 1404 18
561 Wikidata - Missing death location 1923 55 433 416 378 503 138 1866 13
563 Wikidata - Possible duplicate by father 57 7 27 8 5 5 5 51 3
564 Wikidata - Possible father 150 7 77 13 11 27 15 136 4
565 Wikidata - Possible duplicate by mother 70 7 46 4 10 3 69
566 Wikidata - Possible mother 110 8 79 6 1 10 6 104 1
568 Wikidata - Unconnected branches to global tree 4785 56 52 184 422 1837 2229 5 3648 32
569 Wikidata - Unconnected orphans to global tree 5505 24 56 121 507 2394 2401 2 4117 12
571 FindAGrave - Link without Grave ID 53757 586 2 655 5514 32514 14484 2 43131 190
572 FindAGrave - Linked grave not matching profile 22329 1928 4 753 3843 12851 2949 1 20459 236
573 FindAGrave - Empty birth date 727 727 575 12
574 FindAGrave - Imprecise birth date 9928 186 1160 7143 1439 9585 147
575 FindAGrave - Different birth date 22306 59 1315 4144 14589 2199 21398 350
576 FindAGrave - Empty death date 4718 244 77 592 3528 277 4359 83
577 FindAGrave - Imprecise death date 10441 106 4 214 1458 6792 1867 10014 147
578 FindAGrave - Different death date 12143 78 29 950 2755 6895 1436 11784 149
579 FindAGrave - Missing birth location 14914 312 2 206 1907 8976 3511 14170 179
581 FindAGrave - Missing death location 19060 292 6 236 2060 12078 4388 18056 242
585 FindAGrave - Multiple profiles link to same grave ID 1456 14 91 423 788 140 1379 55
586 FindAGrave - Link to merged Grave ID 209 5 1 42 111 50 141 2
587 FindAGrave - Link to nonexisting Grave ID 394 21 60 186 85 41 1 324 11
601 Wrong word in birth location 5548 404 1 543 3561 1039 4406 100
603 USA too early in birth location 200054 37427 162627 200054 811
604 Birth location too short 6542 800 1 757 938 3376 670 4712 79
605 Number in birth location 466 302 144 20 124 5
606 Bogus birth location 1 1 1 1
607 Misspelled word in birth location 6269 132 3 570 1808 3323 433 5717 73
608 Misspelled country in birth location 13400 285 1 441 2242 9020 1411 11793 160
609 Wrong character in birth location 3695 177 1 437 1461 1550 69 3524 2
610 Birth location in uppercase 21416 188 229 1049 2778 14513 2659 20059 138
611 Birth location in lowercase 32685 794 126 803 5763 19731 5466 2 26908 170
631 Wrong word in death location 15798 342 4 1572 11270 2610 14314 160
632 Y death location 516 13 497 6 278
633 USA too early in death location 63910 626 12 41297 21927 46 2 63904 144
634 Death location too short 7482 633 125 635 1145 4062 882 6063 57
635 Number in death location 291 66 1 189 35 111 2
636 Bogus death location 45 17 28 45 10
637 Misspelled word in death location 1104 24 206 157 538 179 753 36
638 Misspelled country in death location 6535 249 24 224 515 4187 1336 5529 121
639 Wrong character in death location 2511 222 2 551 973 689 74 2420
640 Death location in uppercase 13309 217 67 441 1505 8897 2182 12175 57
641 Death location in lowercase 19979 712 250 2626 11986 4403 2 15868 99
661 Wrong word in marriage location 1128 37 192 690 209 990 24
663 USA too early in marriage location 21628 258 7151 14206 13 21627 81
664 Marriage location too short 2324 166 3 290 508 1229 128 1950 38
665 Number in marriage location 94 49 1 31 13 16 3
667 Misspelled word in marriage location 121 3 3 11 94 10 61 21
668 Misspelled country in marriage location 356 24 3 5 26 249 49 171 42
669 Wrong character in marriage location 787 40 257 356 131 3 777
670 Marriage location in uppercase 4172 101 54 192 617 2779 429 3960 13
671 Marriage location in lowercase 6098 202 6 206 1198 3882 604 5054 21
711 Separators in Prefix 802 73 3 8 18 325 373 2 347 5
712 Number in Prefix 508 41 297 170 277
713 Suffix in Prefix 2331 261 27 37 84 783 1133 6 998 51
714 Wrong word in Prefix 474 97 1 2 4 105 242 23 113 4
721 Separators in First Name 49585 11578 230 1828 1576 28345 6028 35686 148
722 Number in First Name 72 68 4 4
723 Prefix in First Name 20553 5360 1958 2162 3149 6994 928 2 16792 82
724 Wrong word in First Name 7517 1882 76 357 679 2949 1572 2 6144 39
725 Wrong character in First Name 306 134 6 68 62 29 7 255 2
731 Separators in Preferred Name 16821 3300 72 54 31 1750 11522 92 580 55
732 Number in Preferred Name 28 22 6
733 Prefix in Preferred Name 6402 1557 192 7 14 384 4180 68 573 37
734 Wrong word in Preferred Name 1821 528 3 13 19 132 1109 17 164 4
735 Wrong character in Preferred Name 621 175 5 76 64 36 259 6 266 1
741 Separators in Middle Name 1306 93 1 55 84 812 261 1047 14
742 Number in Middle Name 8 2 6
743 Prefix in Middle Name 3062 146 36 55 279 1850 696 2802 35
744 Wrong word in Middle Name 808 95 23 122 444 123 1 718 8
745 Wrong character in Middle Name 3 2 1 2
751 Separators in Nicknames 2295 124 315 16 136 1314 389 1 2114 26
752 Number in Nicknames 49 2 46 1 38
753 Prefix in Nicknames 2897 248 717 168 517 835 412 2739 26
754 Wrong word in Nicknames 893 77 54 12 49 501 200 810 13
755 Wrong character in Nicknames 1 1 1
761 Separators in Suffix 4976 700 37 8 670 2186 1369 6 2972 16
762 Number in Suffix 1373 281 12 104 354 415 205 2 999 17
763 Prefix in Suffix 8293 820 45 311 790 1931 4373 23 2929 47
764 Wrong word in Suffix 1071 58 14 81 465 446 7 488 2
765 Wrong character in Suffix 29 3 1 24 1 25
771 Separators in Last Name at Birth 5150 1028 74 712 1200 1429 700 7 3717 6
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 1952 401 16 310 502 362 359 2 1418
781 Separators in Current Last Name 2580 540 61 212 202 752 813 1397 19
783 Prefix in Current Last Name 2 2
784 Wrong word in Current Last Name 187 25 30 67 34 16 15 176
785 Wrong character in Current Last Name 1524 371 19 94 368 321 349 2 1000
791 Separators in Last Name Other 2737 141 190 201 538 553 1113 1 1389 26
792 Number in Last Name Other 11 4 1 6 1 1
794 Wrong word in Last Name Other 280 51 1 52 21 27 126 2 107 8
795 Wrong character in Last Name Other 9 9
801 Big profile 375 3 50 174 148 280 83
802 Empty profile 81248 35485 902 11 5299 28239 11234 78 49147 234
803 Almost empty profile 26753 5377 725 1150 3593 10957 4914 37 20979 262
811 Uncleaned profile after merge 191205 12598 6350 24371 39423 79405 28970 88 153431 1366
821 Headings starts with blank 376 13 26 41 187 109 204 45
822 Heading doesn't end with = 12321 120 10 294 2166 7330 2396 5 10648 1775
823 Heading doesn't start with = 8202 454 2 370 927 5114 1330 5 6763 58
824 Heading different number of = 1795 46 3 163 380 830 372 1 1347 60
825 Use separator line ---- 1318 9 1 48 253 930 77 1162 2
831 Multiple duplicated lines 36049 586 227 1415 2991 25691 5139 30664 81
835 Local file reference 59579 4306 80 1204 6046 33800 14108 35 43909 507
841 Template doesn't start with double { 82 5 1 1 3 41 31 40 10
842 Template doesn't end with double } 39 1 3 17 18 17 11
843 Missing template (spelling) 750 41 5 53 126 349 176 554 36
844 Out of use template 58 5 53
851 GEDCOM uncleaned Interpret date 72170 33221 309 3024 7883 22844 4881 8 46133 190
852 GEDCOM uncleaned Parse Lastname 9711 4184 161 830 1319 2748 468 1 6806 5
901 Unconnected empty public profiles 27159 27159 9
902 Unconnected empty open profiles 18004 18004 18004 75
911 Swedish patronym DOTTER for male 1 1 1
912 Swedish patronym SSON for female 524 1 45 478 524 8

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.







Collaboration

On 12 May 2017 at 15:40 GMT Isabelle Rassinot wrote:

For those of you going through gender errors: I'm going through error 503 (Probable wrong gender, male) 1500-1699 for French names and find a lot of false errors. For the record, Claude is a fairly common name for women in French. Ambroise, Hilaire, Philippe, Sulpice were all acceptable for girls. Laurence and Valentine are definitely feminine.

On 11 May 2017 at 07:52 GMT Paula (Round) Dea wrote:

667 - all open ones done

665 - all open ones done

On 9 May 2017 at 05:34 GMT Emma (McBeth) MacBeath M.Ed MSM wrote:

Working on Error 721 1700-1799 still because I plan to get the number down to 0 eventually!

On 9 May 2017 at 00:56 GMT Mark Dorney wrote:

All 103 errors for Australia are now either corrected (7), or a comment left for the profile manager (13).