DD_Challenge_D-Day.png

DD Challenge Independence

Privacy Level: Public (Green)
Date: 3 Jul 2017 to 10 Jul 2017
Location: [unknown]
Surnames/tags: data_doctors challenges
This page has been accessed 440 times.

Categories: DD Challenges.

This page is part of the Data Doctors Project.
Latest report: December 2nd 2018 and the Spreadsheet.
Custom reports by: Suggestion lists, Unsourced lists, Unconnected lists.
See WikiTree+ for custom reports and statistics.
Data Doctors Challenge: Location IX .


This week's Data Doctors Challenge theme: Independence

For details on how the Data Doctors Challenge works, see the Challenge page.

Contents

Top 10

For more stats see:

By User
By Error
By User and Error
By User and by Day.htm
By Error and by Day.htm
By Hour

Errors List

Canada Day

Error report for Canada. There were 12144 errors on 2017-07-02.

Condition to prepare list (SQL is If ([User].[Birth Date num] In 17670701..18670701) And ([User].[Death Date num] In 18670701..19670701) Then Result = (([User].[Birth Country] = 'Canada') Or ([User].[Death Country] = 'Canada')) EndIf).

12144 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
104 Too old 94 30 64 94 1
105 Duplicate sibling 6 6 6 1
106 Duplicates between global tree and unconnected 11 3 8 11
112 Person is Father and mother 3 3 3
113 Duplicate in relatives 9 9 9 2
202 Parents are same 2 2 2 2
203 Father is Female 57 10 47 57
205 Father is too young or not born 256 22 234 256 2
206 Father is too old 39 3 36 39
209 Father is also a sibling 11 11 11
210 Father was dead before birth 270 9 261 270
211 Duplicate sibling by father 3 3 3
303 Mother is Male 71 11 60 71
305 Mother too young or not born 346 29 317 345 3
306 Mother is too old 30 1 29 30
308 Mother is also a spouse 2 2 2
310 Mother was dead before birth 243 4 239 243 2
311 Duplicate sibling by mother 2 1 1 2
403 Single sex marriage 4 1 3 4
404 Marriage before birth 63 1 62 63
405 Married too old 24 1 23 24
406 Marriage after death 80 4 76 80
407 Lived too long after marriage 3 1 2 3
408 Multiple marriages on same day 70 5 65 69 3
409 Marriage to duplicate person 134 8 126 134 6
414 Marriage End before birth 1 1 1
416 Marriage End after death 66 4 62 66
418 Partner is also a sibling 2 2 2
502 Missing gender (male) 2 2 1
503 Probably wrong gender (male) 2 2 2
505 Wrong gender (female) 2 1 1 2
506 Missing gender (female) 1 1
507 Probably wrong gender (female) 5 5 5
509 Missing gender 2 2 2
510 Unique name without gender 1 1 1
511 Unique names (spelling) 1680 81 1599 1678 25
554 Wikidata - Imprecise birth date 4 4 4
555 Wikidata - Different birth date 22 2 20 22 1
558 Wikidata - Different death date 17 2 15 16
559 Wikidata - Missing birth location 1 1 1
561 Wikidata - Missing death location 3 3 3
565 Wikidata - Possible duplicate by mother 1 1 1
568 Wikidata - Unconnected branches to global tree 108 5 103 108 2
569 Wikidata - Unconnected orphans to global tree 78 2 76 78
571 FindAGrave - Link without Grave ID 405 14 391 404 11
572 FindAGrave - Linked grave not matching profile 274 14 260 274 1
574 FindAGrave - Imprecise birth date 146 7 139 145 2
575 FindAGrave - Different birth date 415 22 393 415 4
577 FindAGrave - Imprecise death date 127 6 121 127 4
578 FindAGrave - Different death date 162 18 144 162 3
579 FindAGrave - Missing birth location 55 1 54 55 2
581 FindAGrave - Missing death location 117 4 113 117
585 FindAGrave - Multiple profiles link to same grave ID 16 1 15 16 2
587 FindAGrave - Link to nonexisting Grave ID 3 1 2 3 2
603 USA too early in birth location 15 15 15
607 Misspelled word in birth location 12 12 11 1
608 Misspelled country in birth location 1 1 1
611 Birth location in lowercase 80 8 72 80 1
634 Death location too short 34 34 34 1
640 Death location in uppercase 1 1 1
641 Death location in lowercase 124 9 115 124 1
661 Wrong word in marriage location 15 2 13 15
664 Marriage location too short 18 18 18
669 Wrong character in marriage location 1 1 1
670 Marriage location in uppercase 12 12 12 1
671 Marriage location in lowercase 51 3 48 51
711 Separators in Prefix 12 12 12
713 Suffix in Prefix 17 17 17
714 Wrong word in Prefix 1 1 1
721 Separators in First Name 497 497 495 6
723 Prefix in First Name 150 11 139 150 1
724 Wrong word in First Name 9 9 9
731 Separators in Preferred Name 1 1 1
733 Prefix in Preferred Name 4 4 4
734 Wrong word in Preferred Name 1 1 1
741 Separators in Middle Name 3 3 2
743 Prefix in Middle Name 15 15 14
744 Wrong word in Middle Name 10 10 10
751 Separators in Nicknames 41 1 40 41 1
753 Prefix in Nicknames 26 3 23 26
754 Wrong word in Nicknames 5 5 5
761 Separators in Suffix 21 3 18 21
763 Prefix in Suffix 53 4 49 53
771 Separators in Last Name at Birth 18 2 16 18
775 Wrong character in Last Name at Birth 2 1 1 2
781 Separators in Current Last Name 9 9 9
791 Separators in Last Name Other 15 7 8 15 1
794 Wrong word in Last Name Other 1 1 1
802 Empty profile 803 47 756 800 1
803 Almost empty profile 199 13 186 199 1
811 Uncleaned profile after merge 2302 180 2122 2298 19
822 Heading doesn't end with = 194 9 185 194
823 Heading doesn't start with = 63 3 60 62
824 Heading different number of = 10 2 8 10
825 Use separator line ---- 12 12 12
831 Multiple duplicated lines 845 23 822 842 7
835 Local file reference 649 33 616 647 4
847 Born after template time frame 1 1 1
851 GEDCOM uncleaned Interpret date 211 13 198 211 2
852 GEDCOM uncleaned Parse Lastname 28 28 28
912 Swedish patronym SSON for female 1 1 1

Table prepared at 05.07.2017 12:53:47 (Slovenian time).


US Independence

Error report for US Independence. There were 164184 errors on 2017-07-02.

Condition to prepare list (SQL is If ([User].[Birth Date num] In 16760704..17760704) And ([User].[Death Date num] In 17760704..18760704) Then Result = (([User].[Birth Country] = 'United states') Or ([User].[Death Country] = 'United states')) EndIf).

164184 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
104 Too old 825 125 700 825 5
105 Duplicate sibling 14 14 14 3
106 Duplicates between global tree and unconnected 117 117 117 15
109 Profile should be open (birth date) 1 1
111 Died too young to be parent 1 1 1
112 Person is Father and mother 8 8 8
113 Duplicate in relatives 19 19 19 7
203 Father is Female 39 39 39
205 Father is too young or not born 1661 22 1639 1661 6
206 Father is too old 423 13 410 423
207 Father is also a child 1 1 1
209 Father is also a sibling 35 2 33 35 6
210 Father was dead before birth 2067 12 2055 2067 15
211 Duplicate sibling by father 9 9 9 3
303 Mother is Male 69 1 68 69
304 Mother has no Gender 3 3 3 1
305 Mother too young or not born 2234 15 2219 2234 19
306 Mother is too old 230 2 228 230
308 Mother is also a spouse 8 8 8 4
309 Mother is also a sibling 1 1 1
310 Mother was dead before birth 2279 2 2277 2279 13
311 Duplicate sibling by mother 2 2 2
403 Single sex marriage 10 10 10 1
404 Marriage before birth 340 4 336 340 3
405 Married too old 128 128 128 1
406 Marriage after death 440 440 440 4
407 Lived too long after marriage 5 5 5
408 Multiple marriages on same day 240 2 238 240 10
409 Marriage to duplicate person 767 23 744 767 33
416 Marriage End after death 191 1 190 191 1
418 Partner is also a sibling 28 1 27 28
501 Wrong gender (male) 17 17 17 4
503 Probably wrong gender (male) 60 1 59 60 1
505 Wrong gender (female) 38 38 38 2
506 Missing gender (female) 1 1 1 1
507 Probably wrong gender (female) 67 1 66 67 2
508 Missing gender (probably female) 1 1 1
509 Missing gender 11 11 11 1
510 Unique name without gender 6 6 6
511 Unique names (spelling) 2482 31 2451 2482 22
554 Wikidata - Imprecise birth date 23 23 23 1
555 Wikidata - Different birth date 150 3 147 150 2
557 Wikidata - Imprecise death date 23 23 23
558 Wikidata - Different death date 120 2 118 120 1
559 Wikidata - Missing birth location 12 12 12
561 Wikidata - Missing death location 19 19 19
563 Wikidata - Possible duplicate by father 2 2 2
564 Wikidata - Possible father 2 1 1 2
565 Wikidata - Possible duplicate by mother 1 1 1
568 Wikidata - Unconnected branches to global tree 71 71 71
569 Wikidata - Unconnected orphans to global tree 173 173 173
571 FindAGrave - Link without Grave ID 2329 21 2308 2329 9
572 FindAGrave - Linked grave not matching profile 1117 14 1103 1117 10
574 FindAGrave - Imprecise birth date 469 8 461 469 10
575 FindAGrave - Different birth date 2199 36 2163 2199 52
577 FindAGrave - Imprecise death date 639 2 637 639 10
578 FindAGrave - Different death date 1411 26 1385 1411 30
579 FindAGrave - Missing birth location 452 3 449 452 8
581 FindAGrave - Missing death location 329 7 322 329 4
585 FindAGrave - Multiple profiles link to same grave ID 227 227 227 7
586 FindAGrave - Link to merged Grave ID 16 16 16 1
587 FindAGrave - Link to nonexisting Grave ID 102 2 100 102 1
603 USA too early in birth location 106822 1233 105589 106822 671
604 Birth location too short 34 1 33 34
607 Misspelled word in birth location 415 1 414 415 11
608 Misspelled country in birth location 460 2 458 460 10
610 Birth location in uppercase 2 2 2
611 Birth location in lowercase 476 476 476
634 Death location too short 36 36 36
636 Bogus death location 4 4 4 4
637 Misspelled word in death location 4 4 4 2
638 Misspelled country in death location 127 3 124 127
640 Death location in uppercase 178 178 178 2
641 Death location in lowercase 429 1 428 429
661 Wrong word in marriage location 39 39 39 1
663 USA too early in marriage location 9202 229 8973 9202 45
664 Marriage location too short 29 29 29 3
667 Misspelled word in marriage location 2 2 2 1
670 Marriage location in uppercase 64 64 64 2
671 Marriage location in lowercase 158 4 154 158
711 Separators in Prefix 6 6 6
713 Suffix in Prefix 32 32 32 1
714 Wrong word in Prefix 1 1 1 1
721 Separators in First Name 10 10 10
723 Prefix in First Name 968 11 957 968 11
724 Wrong word in First Name 25 25 25
733 Prefix in Preferred Name 7 7 7
734 Wrong word in Preferred Name 2 2 2
741 Separators in Middle Name 11 11 11
743 Prefix in Middle Name 68 68 68 2
744 Wrong word in Middle Name 21 21 21
751 Separators in Nicknames 22 22 22 4
753 Prefix in Nicknames 186 1 185 186 2
754 Wrong word in Nicknames 12 12 12
761 Separators in Suffix 129 1 128 129 1
762 Number in Suffix 49 49 49
763 Prefix in Suffix 223 1 222 223 1
764 Wrong word in Suffix 17 17 17
771 Separators in Last Name at Birth 52 2 50 52
775 Wrong character in Last Name at Birth 2 2 2
781 Separators in Current Last Name 23 23 23 2
785 Wrong character in Current Last Name 2 2 2
791 Separators in Last Name Other 101 3 98 101 2
794 Wrong word in Last Name Other 2 2 2
801 Big profile 5 5 5
802 Empty profile 305 305 305 1
803 Almost empty profile 589 7 582 589 2
811 Uncleaned profile after merge 13743 280 13463 13743 124
821 Headings starts with blank 4 4 4
822 Heading doesn't end with = 462 1 461 462
823 Heading doesn't start with = 229 1 228 229 5
824 Heading different number of = 60 2 58 60 5
825 Use separator line ---- 93 1 92 93 1
831 Multiple duplicated lines 922 13 909 922 8
835 Local file reference 1498 10 1488 1498 12
842 Template doesn't end with double } 1 1 1 1
843 Missing template (spelling) 11 11 11 1
846 Died before template time frame 5 5 5 1
851 GEDCOM uncleaned Interpret date 845 12 833 845 4
852 GEDCOM uncleaned Parse Lastname 196 1 195 196

Table prepared at 05.07.2017 13:02:35 (Slovenian time).


Canada and US Independence

Error report for Canada and US Independence. There were 176307 errors on 2017-07-02.

Condition to prepare list (SQL is If ([User].[Birth Date num] In 16760704..17760704) And ([User].[Death Date num] In 17760704..18760704) Then Result = (([User].[Birth Country] = 'United states') Or ([User].[Death Country] = 'United states')) EndIf If not result then If ([User].[Birth Date num] In 17670701..18670701) And ([User].[Death Date num] In 18670701..19670701) Then Result = (([User].[Birth Country] = 'Canada') Or ([User].[Death Country] = 'Canada')) EndIf EndIf).

176307 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-9999 Open New
104 Too old 919 125 730 64 919 6
105 Duplicate sibling 20 14 6 20 4
106 Duplicates between global tree and unconnected 128 120 8 128 15
109 Profile should be open (birth date) 1 1
111 Died too young to be parent 1 1 1
112 Person is Father and mother 11 8 3 11
113 Duplicate in relatives 28 19 9 28 9
202 Parents are same 2 2 2 2
203 Father is Female 96 49 47 96
205 Father is too young or not born 1917 22 1661 234 1917 8
206 Father is too old 462 13 413 36 462
207 Father is also a child 1 1 1
209 Father is also a sibling 46 2 33 11 46 6
210 Father was dead before birth 2337 12 2064 261 2337 15
211 Duplicate sibling by father 12 9 3 12 3
303 Mother is Male 140 1 79 60 140
304 Mother has no Gender 3 3 3 1
305 Mother too young or not born 2580 15 2248 317 2579 22
306 Mother is too old 260 2 229 29 260
308 Mother is also a spouse 10 8 2 10 4
309 Mother is also a sibling 1 1 1
310 Mother was dead before birth 2522 2 2281 239 2522 15
311 Duplicate sibling by mother 4 3 1 4
403 Single sex marriage 14 11 3 14 1
404 Marriage before birth 403 4 337 62 403 3
405 Married too old 152 129 23 152 1
406 Marriage after death 520 444 76 520 4
407 Lived too long after marriage 8 6 2 8
408 Multiple marriages on same day 310 2 243 65 309 13
409 Marriage to duplicate person 901 23 752 126 901 39
414 Marriage End before birth 1 1 1
416 Marriage End after death 257 1 194 62 257 1
418 Partner is also a sibling 30 1 27 2 30
501 Wrong gender (male) 17 17 17 4
502 Missing gender (male) 2 2 1
503 Probably wrong gender (male) 62 1 59 2 62 1
505 Wrong gender (female) 40 39 1 40 2
506 Missing gender (female) 2 1 1 1 1
507 Probably wrong gender (female) 72 1 66 5 72 2
508 Missing gender (probably female) 1 1 1
509 Missing gender 13 11 2 13 1
510 Unique name without gender 7 6 1 7
511 Unique names (spelling) 4160 31 2532 1597 4158 47
554 Wikidata - Imprecise birth date 27 23 4 27 1
555 Wikidata - Different birth date 172 3 149 20 172 3
557 Wikidata - Imprecise death date 23 23 23
558 Wikidata - Different death date 137 2 120 15 136 1
559 Wikidata - Missing birth location 13 12 1 13
561 Wikidata - Missing death location 22 19 3 22
563 Wikidata - Possible duplicate by father 2 2 2
564 Wikidata - Possible father 2 1 1 2
565 Wikidata - Possible duplicate by mother 2 2 2
568 Wikidata - Unconnected branches to global tree 179 76 103 179 2
569 Wikidata - Unconnected orphans to global tree 251 175 76 251
571 FindAGrave - Link without Grave ID 2734 21 2322 391 2733 20
572 FindAGrave - Linked grave not matching profile 1391 14 1117 260 1391 11
574 FindAGrave - Imprecise birth date 615 8 468 139 614 12
575 FindAGrave - Different birth date 2614 36 2185 393 2614 56
577 FindAGrave - Imprecise death date 766 2 643 121 766 14
578 FindAGrave - Different death date 1573 26 1403 144 1573 33
579 FindAGrave - Missing birth location 507 3 450 54 507 10
581 FindAGrave - Missing death location 446 7 326 113 446 4
585 FindAGrave - Multiple profiles link to same grave ID 243 228 15 243 9
586 FindAGrave - Link to merged Grave ID 16 16 16 1
587 FindAGrave - Link to nonexisting Grave ID 105 2 101 2 105 3
603 USA too early in birth location 106820 1233 105587 106820 671
604 Birth location too short 34 1 33 34
607 Misspelled word in birth location 427 1 414 12 426 12
608 Misspelled country in birth location 461 2 458 1 461 10
610 Birth location in uppercase 2 2 2
611 Birth location in lowercase 556 484 72 556 1
634 Death location too short 70 36 34 70 1
636 Bogus death location 4 4 4 4
637 Misspelled word in death location 4 4 4 2
638 Misspelled country in death location 127 3 124 127
640 Death location in uppercase 179 178 1 179 2
641 Death location in lowercase 553 1 437 115 553 1
661 Wrong word in marriage location 54 41 13 54 1
663 USA too early in marriage location 9202 229 8973 9202 45
664 Marriage location too short 47 29 18 47 3
667 Misspelled word in marriage location 2 2 2 1
669 Wrong character in marriage location 1 1 1
670 Marriage location in uppercase 76 64 12 76 3
671 Marriage location in lowercase 209 4 157 48 209
711 Separators in Prefix 18 6 12 18
713 Suffix in Prefix 49 32 17 49 1
714 Wrong word in Prefix 2 1 1 2 1
721 Separators in First Name 507 10 497 505 6
723 Prefix in First Name 1118 11 968 139 1118 12
724 Wrong word in First Name 34 25 9 34
731 Separators in Preferred Name 1 1 1
733 Prefix in Preferred Name 11 7 4 11
734 Wrong word in Preferred Name 3 2 1 3
741 Separators in Middle Name 14 11 3 13
743 Prefix in Middle Name 83 68 15 82 2
744 Wrong word in Middle Name 31 21 10 31
751 Separators in Nicknames 63 23 40 63 5
753 Prefix in Nicknames 212 1 188 23 212 2
754 Wrong word in Nicknames 17 12 5 17
761 Separators in Suffix 150 1 131 18 150 1
762 Number in Suffix 49 49 49
763 Prefix in Suffix 276 1 226 49 276 1
764 Wrong word in Suffix 17 17 17
771 Separators in Last Name at Birth 70 2 52 16 70
775 Wrong character in Last Name at Birth 4 3 1 4
781 Separators in Current Last Name 32 23 9 32 2
785 Wrong character in Current Last Name 2 2 2
791 Separators in Last Name Other 116 3 105 8 116 3
794 Wrong word in Last Name Other 3 2 1 3
801 Big profile 5 5 5
802 Empty profile 1108 352 756 1105 2
803 Almost empty profile 788 7 595 186 788 3
811 Uncleaned profile after merge 16044 280 13642 2122 16040 143
821 Headings starts with blank 4 4 4
822 Heading doesn't end with = 656 1 470 185 656
823 Heading doesn't start with = 292 1 231 60 291 5
824 Heading different number of = 70 2 60 8 70 5
825 Use separator line ---- 105 1 92 12 105 1
831 Multiple duplicated lines 1766 13 931 822 1763 15
835 Local file reference 2147 10 1521 616 2145 16
842 Template doesn't end with double } 1 1 1 1
843 Missing template (spelling) 11 11 11 1
846 Died before template time frame 5 5 5 1
847 Born after template time frame 1 1 1
851 GEDCOM uncleaned Interpret date 1056 12 846 198 1056 6
852 GEDCOM uncleaned Parse Lastname 224 1 195 28 224
912 Swedish patronym SSON for female 1 1 1

Table prepared at 05.07.2017 13:17:07 (Slovenian time).







Images: 1
Data Doctors: Community Clean-Up
Data Doctors: Community Clean-Up

Collaboration