upload image

Database errors project (May 14th 2017)

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

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

2119662 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
101 Birth in future 6 6 2 2
102 Death in future 68 61 7 3 2
103 Death before birth 7055 5 280 931 4028 1762 49 5727 10
104 Too old 7332 234 1249 2397 3319 129 4 7033 24
105 Duplicate sibling 259 27 33 87 112 179 55
106 Duplicates between global tree and unconnected 786 77 264 310 135 650 99
109 Profile should be open (birth date) 754 2 18 432 302 11
110 Profile should be open (death date) 264 8 32 44 179 1 2
111 Died too young to be parent 421 27 55 37 171 127 4 363 2
112 Person is Father and mother 585 71 1 2 57 340 114 350 12
113 Duplicate in relatives 1069 245 107 33 139 458 87 697 69
114 Still living status and entered death date 1774 157 2 10 342 1257 6 104 31
115 Still living status and entered death location 194 12 12 72 98 64 17
201 Father is self 80 57 16 7 7
202 Parents are same 61 4 9 24 24 17 8
203 Father is Female 3999 546 1 82 406 2443 521 3197 52
204 Father has no Gender 485 396 1 76 12 50 14
205 Father is too young or not born 34647 1745 3470 7246 16704 5418 64 31237 114
206 Father is too old 3875 356 924 1510 1080 5 3798 11
207 Father is also a child 150 66 12 5 4 49 14 66 5
208 Father is also a spouse 26 8 2 14 2 14 5
209 Father is also a sibling 1311 246 85 66 118 629 167 877 24
210 Father was dead before birth 33899 1422 2359 6098 9946 13429 645 33413 144
211 Duplicate sibling by father 354 1 78 89 114 72 275 32
212 Profile should be open (Child birth date) 2764 2764 12
301 Mother is self 1 1
303 Mother is Male 4168 449 13 137 454 2647 468 3259 106
304 Mother has no Gender 504 443 4 45 12 30 14
305 Mother too young or not born 44687 2196 4662 10393 21433 5938 65 40675 153
306 Mother is too old 3169 230 687 1175 1073 4 3082 5
307 Mother is also a child 5 1 2 2 1 1
308 Mother is also a spouse 281 63 39 6 39 125 9 189 21
309 Mother is also a sibling 120 15 1 4 13 68 19 79 2
310 Mother was dead before birth 38214 1775 1671 6915 12085 15110 657 1 37795 176
311 Duplicate sibling by mother 195 5 45 28 68 49 161 15
312 Profile should be open (Child birth date) 2139 2139 6
402 Unknown gender of spouse 637 481 3 132 21 76 23
403 Single sex marriage 1055 211 8 23 47 641 125 660 69
404 Marriage before birth 6770 164 652 1600 3600 754 6163 38
405 Married too old 1508 24 171 493 820 1493 7
406 Marriage after death 9064 307 268 1250 2343 4608 288 8921 41
407 Lived too long after marriage 183 3 11 29 59 66 15 143 3
408 Multiple marriages on same day 3371 311 2 342 913 1703 100 3085 76
409 Marriage to duplicate person 10933 2230 83 872 2422 4946 380 9025 277
410 Marriage in future 1 1
412 Marriage End before marriage 82 1 7 71 3 67 4
413 Marriage too long 1 1 1 1
414 Marriage End before birth 88 6 5 57 20 58 5
415 Marriage End too old 27 14 13 27 2
416 Marriage End after death 3914 66 119 584 909 1974 262 3802 48
417 Lived too long after marriage End 3 2 1 3 3
418 Partner is also a sibling 411 26 30 47 108 190 10 381 8
501 Wrong gender (male) 3092 1014 3 62 377 1106 526 4 1417 84
502 Missing gender (male) 17808 10971 1 7 2508 4305 16 1443 92
503 Probably wrong gender (male) 4836 1111 29 349 574 1968 794 11 3334 82
504 Missing gender (probably male) 8906 6086 1 687 2101 31 440 63
505 Wrong gender (female) 3966 938 3 78 332 2053 560 2 2381 59
506 Missing gender (female) 14369 9344 1 5 2322 2688 9 1344 78
507 Probably wrong gender (female) 4110 709 17 153 545 1963 722 1 2860 62
508 Missing gender (probably female) 7673 5571 4 8 364 1712 14 101 56
509 Missing gender 36320 27054 18 235 742 4091 4134 46 8921 166
510 Unique name without gender 8682 3971 9 56 199 2291 2115 41 3554 42
511 Unique names (spelling) 263511 46924 7250 11848 20041 100591 75167 1690 170875 1789
551 Wikidata - Missing gender 33 1 32
552 Wikidata - Different gender 8 1 2 5 3 2
553 Wikidata - Empty birth date 139 139 121 4
554 Wikidata - Imprecise birth date 630 129 171 170 126 34 595 13
555 Wikidata - Different birth date 3781 1755 880 471 512 162 1 3739 29
556 Wikidata - Empty death date 195 46 55 27 28 13 25 1 160 4
557 Wikidata - Imprecise death date 864 26 262 210 200 123 43 828 9
558 Wikidata - Different death date 3998 57 2358 696 359 433 95 3976 23
559 Wikidata - Missing birth location 1453 35 253 403 306 365 91 1400 24
561 Wikidata - Missing death location 1916 56 434 411 380 503 132 1859 16
563 Wikidata - Possible duplicate by father 55 8 27 5 5 5 5 49 2
564 Wikidata - Possible father 140 6 76 11 11 23 13 129 2
565 Wikidata - Possible duplicate by mother 61 6 46 3 4 2 60 1
566 Wikidata - Possible mother 102 7 77 6 1 4 7 96 2
568 Wikidata - Unconnected branches to global tree 4794 56 52 185 420 1842 2234 5 3654 35
569 Wikidata - Unconnected orphans to global tree 5504 23 56 117 509 2393 2404 2 4119 16
571 FindAGrave - Link without Grave ID 53796 588 2 649 5516 32574 14464 3 43222 257
572 FindAGrave - Linked grave not matching profile 22302 1932 5 747 3847 12808 2962 1 20431 201
573 FindAGrave - Empty birth date 722 722 569 12
574 FindAGrave - Imprecise birth date 9934 186 1168 7152 1428 9594 106
575 FindAGrave - Different birth date 22390 60 1308 4162 14656 2204 21484 372
576 FindAGrave - Empty death date 4698 244 76 592 3514 272 4347 73
577 FindAGrave - Imprecise death date 10465 108 4 211 1463 6808 1871 10040 132
578 FindAGrave - Different death date 12150 80 29 955 2751 6900 1435 11791 200
579 FindAGrave - Missing birth location 14983 313 2 203 1911 9026 3528 14241 212
581 FindAGrave - Missing death location 19085 293 6 229 2045 12116 4396 18084 243
585 FindAGrave - Multiple profiles link to same grave ID 1416 13 91 430 770 112 1345 47
586 FindAGrave - Link to merged Grave ID 148 5 1 29 72 41 81 1
587 FindAGrave - Link to nonexisting Grave ID 391 21 60 186 82 41 1 322 3
601 Wrong word in birth location 5470 406 523 3502 1039 4329 27
603 USA too early in birth location 199100 37030 162070 199100 1278
604 Birth location too short 6445 797 1 757 934 3280 676 4619 45
605 Number in birth location 381 301 59 21 40 10
607 Misspelled word in birth location 6162 131 3 551 1795 3245 437 5611 75
608 Misspelled country in birth location 13376 284 1 453 2294 8929 1415 11768 232
609 Wrong character in birth location 3680 176 1 437 1457 1542 67 3509 2
610 Birth location in uppercase 21024 181 182 1044 2653 14355 2609 19671 80
611 Birth location in lowercase 32686 796 126 819 5749 19723 5471 2 26909 199
631 Wrong word in death location 15542 340 3 1492 11097 2610 14058 70
632 Y death location 500 13 481 6 263 5
633 USA too early in death location 63427 630 7 40910 21832 46 2 63421 279
634 Death location too short 7466 633 125 634 1149 4035 890 6049 36
635 Number in death location 288 66 3 181 38 110 8
636 Bogus death location 43 19 24 43 2
637 Misspelled word in death location 813 20 199 134 297 163 463 24
638 Misspelled country in death location 6429 247 22 248 518 4040 1354 5423 163
639 Wrong character in death location 2501 221 2 548 967 689 74 2410 4
640 Death location in uppercase 12856 214 3 437 1347 8721 2134 11724 27
641 Death location in lowercase 19928 716 255 2618 11942 4395 2 15814 92
661 Wrong word in marriage location 1117 38 186 684 209 979 3
663 USA too early in marriage location 21443 253 7033 14144 13 21442 177
664 Marriage location too short 2296 158 3 291 506 1214 124 1928 15
665 Number in marriage location 73 40 22 11 3 1
667 Misspelled word in marriage location 76 3 4 6 53 10 19 14
668 Misspelled country in marriage location 294 27 3 15 25 175 49 109 46
669 Wrong character in marriage location 791 40 257 356 135 3 781 8
670 Marriage location in uppercase 4074 96 54 188 577 2741 418 3863 8
671 Marriage location in lowercase 6082 201 6 204 1196 3873 602 5041 14
711 Separators in Prefix 806 72 3 8 19 327 375 2 350 7
712 Number in Prefix 515 40 3 3 297 172 282 8
713 Suffix in Prefix 2363 257 27 39 97 784 1153 6 1017 48
714 Wrong word in Prefix 458 97 1 4 105 243 8 111 5
721 Separators in First Name 49374 11557 222 1823 1316 28398 6058 35473 335
722 Number in First Name 72 68 4 4
723 Prefix in First Name 20512 5349 1948 2154 3133 7007 919 2 16756 93
724 Wrong word in First Name 7517 1886 76 357 669 2952 1575 2 6144 38
725 Wrong character in First Name 301 131 5 68 61 29 7 250
731 Separators in Preferred Name 16797 3283 71 53 29 1743 11534 84 577 67
732 Number in Preferred Name 28 22 6
733 Prefix in Preferred Name 6403 1557 189 9 16 381 4190 61 572 45
734 Wrong word in Preferred Name 1819 528 3 13 19 134 1107 15 166 1
735 Wrong character in Preferred Name 617 172 5 76 63 36 259 6 262
741 Separators in Middle Name 1313 91 2 54 86 817 263 1055 21
742 Number in Middle Name 8 2 6
743 Prefix in Middle Name 3077 145 36 55 276 1865 700 2819 37
744 Wrong word in Middle Name 800 95 23 120 439 122 1 711 4
745 Wrong character in Middle Name 2 1 1 1
751 Separators in Nicknames 2322 125 315 20 135 1328 398 1 2140 37
752 Number in Nicknames 48 2 46 37
753 Prefix in Nicknames 2906 248 716 168 513 842 419 2747 30
754 Wrong word in Nicknames 882 75 54 11 49 495 198 797 6
755 Wrong character in Nicknames 1 1 1
761 Separators in Suffix 4977 701 35 7 674 2186 1368 6 2972 16
762 Number in Suffix 1335 281 12 104 373 356 208 1 961 53
763 Prefix in Suffix 8309 824 45 314 787 1920 4397 22 2922 48
764 Wrong word in Suffix 1070 58 14 82 464 445 7 488 3
765 Wrong character in Suffix 29 3 1 24 1 25
771 Separators in Last Name at Birth 5154 1026 74 712 1198 1436 702 6 3718 12
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 1944 399 16 309 499 358 362 1 1408 3
781 Separators in Current Last Name 2591 538 62 217 207 755 812 1406 22
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 1510 369 19 93 361 315 352 1 984 3
791 Separators in Last Name Other 2749 141 191 204 535 561 1116 1 1404 29
792 Number in Last Name Other 13 4 2 7 3 3
794 Wrong word in Last Name Other 280 51 1 51 22 27 126 2 107 2
795 Wrong character in Last Name Other 9 9
801 Big profile 375 3 50 174 148 280
802 Empty profile 80897 35292 903 6 5086 28276 11258 76 48812 348
803 Almost empty profile 26761 5369 733 1144 3583 10998 4897 37 20993 192
811 Uncleaned profile after merge 191062 12585 6291 24240 39253 79523 29093 77 153263 1196
821 Headings starts with blank 230 16 6 17 88 103 60 44
822 Heading doesn't end with = 12036 118 1 303 2070 7169 2370 5 10368 147
823 Heading doesn't start with = 8131 451 3 362 910 5073 1327 5 6711 57
824 Heading different number of = 1652 47 148 331 763 361 2 1201 54
825 Use separator line ---- 1310 9 49 254 918 80 1152 8
831 Multiple duplicated lines 36060 584 227 1412 2996 25700 5141 30672 76
835 Local file reference 60128 4290 79 1203 6075 34215 14240 26 44434 663
841 Template doesn't start with double { 43 3 1 12 27 2 3
842 Template doesn't end with double } 23 6 17 1
843 Missing template (spelling) 721 41 1 66 109 323 181 523 38
844 Out of use template 58 5 53
851 GEDCOM uncleaned Interpret date 72025 33075 308 2999 7861 22879 4897 6 46004 212
852 GEDCOM uncleaned Parse Lastname 9692 4183 160 827 1319 2737 465 1 6789 16
901 Unconnected empty public profiles 27156 27156 34
902 Unconnected empty open profiles 17938 17938 17938 35
911 Swedish patronym DOTTER for male 1 1 1
912 Swedish patronym SSON for female 513 1 37 475 513 6

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.







Collaboration

On 17 May 2017 at 07:31 GMT Paula (Round) Dea wrote:

667 done - found 1 aged over 150 years to request opening for next week.

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

It might be hidden by status (False error, Merge, corrected)

On 17 May 2017 at 01:02 GMT Mark Dorney wrote:

There are now only nine 103 errors for Australia!

All were double commented as of last week, will wait until next week before private messaging.

(Report states eight, but there are definitely still nine, not sure why it’s not showing up.)

With the other 100s for Australia, now mostly just waiting for merges to go through and actions on comments. Next week’s report will give a clearer picture.

Now moving on to 203 and 205.

On 16 May 2017 at 09:12 GMT Graeme Olney wrote:

As per every week - working on all Error codes related to New Zealand (and sometimes Australia, if I feel like being neighborly)

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

Working on my old friend Error 721 1700-1799