upload image

Database errors project (April 9th 2017)

Privacy Level: Open (White)
Date: 9 Apr 2017 to 16 Apr 2017
Location: Worldwidemap
Surname/tag: data_doctors
This page has been accessed 559 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 April 9th 2017.

Related post.

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

Contents

News

Minor adjustments to FindAGrave Errors

I adjusted the errors a bit, to reduce the false error count.

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)

Help updated

Updated Help pages 1-699

Previous news

Cosmetic changes

Added direct jump to History of the profile in all reports. It is Link H under wikitreeID.

With error 572, I list all linked memorials, so it is obvious who the links are for. Example: http://wikitree.sdms.si/function/WTStatus/Status.htm?ErrID=572&UserID1=15535724&UserID2=0

Added new errors 851 GEDCOM uncleaned Interpret date and 852 GEDCOM uncleaned Parse Lastname

This are dates and lastnames, That gedcom import didn't use in profile data. They should be done manually, but never were. Actually some were, but this line remained in the Biography.

Republished 6x3 errors USA too early in location

Now that FamilySearch locations are implemented, I can republish this errors. If you think I could add automatically suggested corrections, let me know. I can work on that.

Changed 575 - FindAGrave - Different birth date and 578 - FindAGrave - Different death date

Adding 1 month buffer between dates. So only dates that are more then 1 month different gets reported. That decreased the number of errors for one third.

FindAGrave Changes

  • Renamed error 572 to FindAGrave - Linked grave not matching profile
  • Removed private profiles from 572 error. Dates are not precise.
  • According to error report there is 3112 new errors this week. Last week it was 2795 new errors. I think this is due to a lot of changes in FAG links this week.
  • 575.786 profiles have link to FindAGrave. 54.155 of them have no link to actual memorial. The others link to 511.354 memorials on FindAGrave. This week it was 7.761 new memorials linked. Last week it was 5561.
  • Total number of FindAGrave errors is 220606. In last month there were cca 2000 new errors on links to FindAGrave. This week we are around 0. That shows, 5000 were addressed this week and 3000 were new. In time also linking practice will change, so number of new errors each week will decrease.
  • Here are report of all statuses entered last week. According to them, we have 50:50 ratio of errors vs false errors.

Conclusion: The most problematic errors are:

  • 572 - FindAGrave - Linked grave not matching profile. From comments in status and G2G discussion, I think you didn't understand what this error even means. I changed the name of this error. Maybe this will help. I also removed 1600 errors reported on private profiles, since they were not linked due to approximate date. Another possibility to address this problem would be by using a changed FindAGrave template, where you could specify, that one link is for the profile and others are for relatives. That way the correct link to FindAGrave would be matched.
  • 575 - FindAGrave - Different birth date and 578 - FindAGrave - Different death date.

This were problematic due to the number of errors. I see the solution in adding some buffer between dates. Maybe 1 month and report only differences, that are bigger than 1 month. That would decrease the number of errors for one third.

Errors 608 and 638 have automatically suggested changes

Activated change button for US states as they joined USA. It is new so be alert for bugs.

Wrote Help for Status page

Setting status of the error is described on Error status Help page

Added suggestions for status

Added suggestions for statuses based on existing entries. Suggestions will be updated based on the number of entries. 10 most common suggestions are shown for each error/status pair.

Errors

Analysis was done on data from April 2nd 2017.

2226355 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
101 Birth in future 5 5 1
102 Death in future 69 64 5
103 Death before birth 8286 15 386 1062 4663 2107 53 5828 10
104 Too old 7564 250 1296 2458 3420 136 4 6973 29
105 Duplicate sibling 240 26 28 73 113 127 39
106 Duplicates between global tree and unconnected 832 94 263 340 135 651 86
109 Profile should be open (birth date) 12388 15 29 593 11751 119
110 Profile should be open (death date) 645 117 12 32 261 221 2 10
111 Died too young to be parent 459 34 56 48 186 130 5 355 4
112 Person is Father and mother 629 83 5 4 77 355 105 312 12
113 Duplicate in relatives 1074 257 118 34 117 465 83 526 38
114 Still living status and entered death date 1813 157 3 2 7 399 1240 5 85 22
115 Still living status and entered death location 216 11 1 1 10 95 98 42 9
201 Father is self 87 57 22 8 3
202 Parents are same 51 4 24 23 4
203 Father is Female 4535 621 17 148 651 2571 527 3328 28
204 Father has no Gender 480 393 73 14 2 2
205 Father is too young or not born 35406 1794 3548 7376 17008 5615 65 29860 111
206 Father is too old 4277 371 1033 1713 1155 5 3997 11
207 Father is also a child 156 70 14 2 5 52 13 48
208 Father is also a spouse 28 6 2 1 18 1 7
209 Father is also a sibling 1361 266 90 75 109 657 164 791 23
210 Father was dead before birth 35135 1491 2426 6356 10355 13829 678 32399 169
211 Duplicate sibling by father 385 1 86 83 151 64 273 33
212 Profile should be open (Child birth date) 2858 2858 16
301 Mother is self 1 1
303 Mother is Male 4667 517 45 177 741 2724 463 3349 13
304 Mother has no Gender 507 438 55 14 3 3
305 Mother too young or not born 45598 2262 4793 10559 21736 6181 67 39081 152
306 Mother is too old 3518 250 753 1363 1149 3 3245 11
307 Mother is also a child 5 1 3 1 2
308 Mother is also a spouse 275 65 43 6 33 118 10 134 16
309 Mother is also a sibling 133 23 1 2 14 71 22 56 8
310 Mother was dead before birth 39590 1840 1721 7169 12514 15655 690 1 36611 228
311 Duplicate sibling by mother 159 5 48 29 46 31 122 10
312 Profile should be open (Child birth date) 2288 2288 10
402 Unknown gender of spouse 648 470 1 154 23 14 7
403 Single sex marriage 927 218 13 23 31 514 128 324 12
404 Marriage before birth 7108 177 679 1676 3731 844 1 5985 30
405 Married too old 1582 34 184 515 849 1415 6
406 Marriage after death 9572 310 296 1311 2450 4878 327 8495 52
407 Lived too long after marriage 239 7 11 38 78 88 17 164 7
408 Multiple marriages on same day 3496 322 2 367 952 1755 98 2951 87
409 Marriage to duplicate person 11157 2348 91 940 2442 4971 365 8672 244
410 Marriage in future 3 3
412 Marriage End before marriage 114 3 15 90 6 78 2
414 Marriage End before birth 102 1 5 5 68 23 51 6
415 Marriage End too old 41 2 20 19 38
416 Marriage End after death 4000 70 126 596 939 1990 279 3698 62
417 Lived too long after marriage End 4 4 2 2
418 Partner is also a sibling 433 30 32 47 110 205 9 375 2
501 Wrong gender (male) 4288 1056 66 521 2116 525 4 2199 68
502 Missing gender (male) 17667 10812 1 2595 4245 14 53 69
503 Probably wrong gender (male) 4967 1122 41 412 597 2062 726 7 3245 58
504 Missing gender (probably male) 8776 5917 1 6 704 2115 33 86 47
505 Wrong gender (female) 4569 963 3 79 329 2669 524 2 2374 69
506 Missing gender (female) 14327 9258 1 5 2400 2653 10 34 92
507 Probably wrong gender (female) 4187 713 19 155 570 2025 704 1 2718 35
508 Missing gender (probably female) 7748 5399 5 3 617 1712 12 118 43
509 Missing gender 36463 26947 18 250 765 4115 4324 44 8006 184
510 Unique name without gender 9614 3979 9 59 211 2636 2672 48 3868 21
511 Unique names (spelling) 263846 47463 7387 12234 20155 100322 74618 1667 160401 1678
551 Wikidata - Missing gender 34 1 33
552 Wikidata - Different gender 6 2 1 3 3 1
553 Wikidata - Empty birth date 145 145 127 1
554 Wikidata - Imprecise birth date 643 132 192 178 111 30 579 12
555 Wikidata - Different birth date 3790 1758 915 460 497 160 3720 31
556 Wikidata - Empty death date 205 46 62 30 28 14 25 170 6
557 Wikidata - Imprecise death date 890 26 268 232 210 114 40 824 10
558 Wikidata - Different death date 3998 59 2359 704 358 424 94 3952 32
559 Wikidata - Missing birth location 1454 35 249 417 315 358 80 1365 18
561 Wikidata - Missing death location 1928 60 434 419 388 500 127 1840 26
563 Wikidata - Possible duplicate by father 64 7 27 6 10 8 6 56 4
564 Wikidata - Possible father 162 7 82 21 13 27 12 148 6
565 Wikidata - Possible duplicate by mother 79 7 52 2 15 3 79 4
566 Wikidata - Possible mother 132 8 83 24 3 9 5 122 1
568 Wikidata - Unconnected branches to global tree 4744 55 52 183 429 1819 2201 5 3543 54
569 Wikidata - Unconnected orphans to global tree 5508 23 54 119 515 2396 2400 1 4105 18
571 FindAGrave - Link without Grave ID 54393 646 22 690 5625 32961 14446 3 40586 388
572 FindAGrave - Linked grave not matching profile 25736 2022 11 851 4323 14909 3620 22769 1934
573 FindAGrave - Empty birth date 763 763 597 2
574 FindAGrave - Imprecise birth date 9989 207 1157 7156 1469 9372 123
575 FindAGrave - Different birth date 29255 57 1621 5344 19462 2770 1 27042 332
576 FindAGrave - Empty death date 5173 282 6 82 598 3596 609 4645 59
577 FindAGrave - Imprecise death date 10424 109 4 221 1467 6772 1851 9753 142
578 FindAGrave - Different death date 13610 80 32 1076 3068 7788 1565 1 12781 164
579 FindAGrave - Missing birth location 14687 325 4 216 1901 8810 3431 13487 146
581 FindAGrave - Missing death location 18955 299 9 254 2083 11939 4371 17327 179
585 FindAGrave - Multiple profiles link to same grave ID 1549 24 105 459 777 184 1411 30
586 FindAGrave - Link to merged Grave ID 610 6 115 357 132 510
587 FindAGrave - Link to nonexisting Grave ID 967 21 68 195 497 185 1 795 4
601 Wrong word in birth location 6701 406 48 833 4225 1189 5017 32
603 USA too early in birth location 218724 2 41976 176746 218724 748
604 Birth location too short 6995 834 39 800 1006 3635 681 3928 29
605 Number in birth location 482 305 1 1 153 22 20 5
607 Misspelled word in birth location 7454 134 122 1057 2118 3536 487 6206 59
608 Misspelled country in birth location 14945 291 17 593 2467 10017 1560 11923 191
609 Wrong character in birth location 3920 185 2 482 1565 1616 70 3338 2
610 Birth location in uppercase 24693 198 547 1219 3873 15772 3084 21846 91
611 Birth location in lowercase 37769 941 203 911 6790 22772 6150 2 27469 58
631 Wrong word in death location 17771 346 15 1977 12657 2776 15006 99
632 Y death location 774 14 6 739 15 88 3
633 USA too early in death location 72907 1075 28 46477 25258 63 6 72890 201
634 Death location too short 7924 639 127 671 1220 4364 903 5075 35
635 Number in death location 322 66 3 11 199 43 27 11
636 Bogus death location 305 1 1 1 147 154 1 281 2
637 Misspelled word in death location 1272 27 215 140 705 185 615 44
638 Misspelled country in death location 7129 262 63 278 528 4602 1396 5281 145
639 Wrong character in death location 2627 228 4 588 1027 703 77 2392
640 Death location in uppercase 15479 323 193 536 2213 9656 2558 13420 61
641 Death location in lowercase 23084 698 96 294 3391 13587 5016 2 16453 66
661 Wrong word in marriage location 1304 37 1 9 249 766 242 1033 7
663 USA too early in marriage location 24951 315 8427 16195 14 24945 110
664 Marriage location too short 2319 165 3 289 503 1236 123 1702 6
665 Number in marriage location 96 49 36 11 7 3
666 Bogus marriage location 1 1 1 1
667 Misspelled word in marriage location 180 3 3 6 158 10 18 13
668 Misspelled country in marriage location 520 32 3 6 25 400 54 106 49
669 Wrong character in marriage location 810 41 270 369 128 2 775 2
670 Marriage location in uppercase 4823 111 135 220 823 3052 482 4360 9
671 Marriage location in lowercase 7081 232 29 242 1540 4366 672 5114 17
711 Separators in Prefix 904 76 9 13 18 405 381 2 335 10
712 Number in Prefix 867 40 9 3 648 167 627
713 Suffix in Prefix 2307 260 35 36 71 805 1096 4 929 29
714 Wrong word in Prefix 539 98 1 3 4 156 254 23 80 9
721 Separators in First Name 53183 11856 241 1937 4312 28698 6139 33710 272
722 Number in First Name 73 68 5
723 Prefix in First Name 22005 5507 2025 2301 3463 7058 1649 2 17074 71
724 Wrong word in First Name 7676 1919 76 374 753 2985 1568 1 5445 24
725 Wrong character in First Name 379 148 5 76 96 40 14 315
731 Separators in Preferred Name 16863 3303 76 77 119 1876 11325 87 811 116
732 Number in Preferred Name 28 22 6
733 Prefix in Preferred Name 7153 1548 208 190 239 778 4122 68 1370 21
734 Wrong word in Preferred Name 1823 528 3 15 19 133 1108 17 152 22
735 Wrong character in Preferred Name 670 181 5 84 98 47 251 4 328 1
741 Separators in Middle Name 1349 92 1 58 92 831 275 992 12
742 Number in Middle Name 8 2 6
743 Prefix in Middle Name 3052 145 36 55 281 1951 584 2650 30
744 Wrong word in Middle Name 886 112 3 23 132 471 144 1 755 11
745 Wrong character in Middle Name 7 2 2 1 1 1 6
751 Separators in Nicknames 2812 124 327 300 341 1327 392 1 2494 18
752 Number in Nicknames 62 2 1 57 2 14
753 Prefix in Nicknames 3063 236 681 464 521 756 405 2850 20
754 Wrong word in Nicknames 1046 80 57 68 102 543 196 904 9
761 Separators in Suffix 7078 1148 164 717 1365 2299 1379 6 4692 8
762 Number in Suffix 1540 287 146 431 474 201 1 1128 6
763 Prefix in Suffix 8702 930 145 363 888 2022 4332 22 3092 48
764 Wrong word in Suffix 1208 79 60 126 491 445 7 558 2
765 Wrong character in Suffix 30 3 1 25 1 2
771 Separators in Last Name at Birth 5140 1040 74 711 1189 1424 695 7 3231 48
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 1948 403 16 323 510 367 327 2 1381
781 Separators in Current Last Name 3058 669 56 223 360 938 812 1692 21
783 Prefix in Current Last Name 2 2
784 Wrong word in Current Last Name 203 27 30 76 38 16 16 192
785 Wrong character in Current Last Name 1551 372 19 129 384 328 317 2 992
791 Separators in Last Name Other 3819 138 191 447 595 1216 1231 1 2345 19
792 Number in Last Name Other 11 4 7
794 Wrong word in Last Name Other 472 68 19 73 65 119 126 2 293 4
795 Wrong character in Last Name Other 9 9
801 Big profile 297 3 51 136 107 221
802 Empty profile 84874 36441 1006 1565 5525 29005 11258 74 44214 252
803 Almost empty profile 26747 5385 743 1202 3672 10810 4897 38 19516 146
811 Uncleaned profile after merge 194588 13134 6756 25424 40317 80092 28727 138 142161 1018
821 Headings starts with blank 260 14 2 6 11 129 98 44 41
822 Heading doesn't end with = 11176 117 40 920 1994 6131 1969 5 9199 160
823 Heading doesn't start with = 9594 520 94 401 1094 6002 1479 4 7560 45
824 Heading different number of = 2510 44 12 237 473 1321 422 1 1939 60
825 Use separator line ---- 1507 9 8 65 319 1030 76 1213 8
831 Multiple duplicated lines 36164 607 231 1450 3042 25710 5124 26773 39
835 Local file reference 59622 4422 85 1303 6075 33675 14020 42 39911 563
841 Template doesn't start with double { 87 7 3 1 4 42 30 19 13
842 Template doesn't end with double } 44 1 2 4 3 14 20 21 14
843 Missing template (spelling) 821 41 23 75 139 356 187 593 16
844 Out of use template 75 7 68
851 GEDCOM uncleaned Interpret date 74135 34117 324 3115 8150 23400 5016 13 41928 169
852 GEDCOM uncleaned Parse Lastname 10186 4317 218 898 1434 2830 488 1 6564 9
901 Unconnected empty public profiles 28805 28805 19
902 Unconnected empty open profiles 18824 18824 18824 57
911 Swedish patronym DOTTER for male 1 1 1 1
912 Swedish patronym SSON for female 570 2 78 490 464 1

Changes since previous update

Detailed statistics are available on Wikitree+ in Statistics section.







Collaboration

On 13 Apr 2017 at 02:53 GMT Emma (McBeth) MacBeath M.Ed MSM wrote:

Still working on error 721 1700-1799