upload image

Database errors project (15 May 2016)

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

Related post.

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

Contents

News

Added 408 Multiple marriages on same day, 409 Marriage to duplicate person

  • 408 Multiple marriages on same day: This person married to two partners on the same day.
  • 409 Marriage to duplicate person: This person is married twice to a person with same name.
Error Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-Now Now-9999
408 Multiple marriages on same day 10234 293 40 1686 3043 4789 383
409 Marriage to duplicate person 31870 4119 411 4269 8046 13421 1602 2

Added 604, 634 & 664 Too short location

Short locations are not allowed, since they can be ambiguous. Also people from other parts of the world don't understand them. For now MinLength is 4 with exceptions like USA, UK. American states should be at least in form PA, USA which is longer than 4 letters.

Error Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-Now Now-9999
604 Birth location too short 16791 1974 131 1006 2646 9284 1750
634 Death location too short 18242 1109 313 1121 2762 11516 1421
664 Marriage location too short 3246 228 30 379 680 1653 276

Updated 602, 632 & 662

Added checking of yes * and y *.

Error Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-Now Now-9999
602 Y birth location 3 3
632 Y death location 6736 80 48 140 663 5715 90
662 Y marriage location 7 1 2 4

Description of errors

I finished short description for all errors. You can see it on the project page.

Temporary hidden errors

I added the system similar to false errors, that hide an error for a month.

If you encounter an error, that you cannot fix and you posted a message to profile manager or you proposed a merge, you can click a link on the right to tell the system to ignore this error for a month. If profile manager will correct the error, it will no longer exist, otherwise error will reappear after 31 days so other actions can be taken. Error will be hidden at latest on next recalculation (on monday).

Added 109 Profile should be open (birth date), 110 Profile should be open (death date)

Here are profiles, that should be open, since birth / death date is older than 200 years or date is wrong.

Error Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-Now Now-9999
109 Profile should be open (birth date) 11667 7 411 199 3611 7439
110 Profile should be open (death date) 1516 713 11 72 154 317 247 2

Added 107 Full name in UPPERCASE, 108 Full name in lowercase

Here are profiles, that have whole full name in uppercase or lowercase.

Error Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-Now Now-9999
107 Full name in UPPERCASE 3153 1987 4 66 79 390 610 17
108 Full name in lowercase 3207 2900 3 3 14 49 231 7

Template to put link to errors on profile pages

There is also a template {{db_errors}} to put on profile and have link to errors for that profile and connected ones. Check documentation for this template.

  • {{db_errors}} ==> Generates a link that generates a report of current Wikiprofile 5 generations. This form can be used only in biography, not in comments.
  • {{db_errors|10}} ==> Same as 1 but 10 generations. This form can be used only in biography, not in comments.
  • {{db_errors|10|Sälgö-2}} ==> Same as 2 but starts with Wikiprofile Sälgö-2. This form can be used in comments, freespace pages and everywhere else on WikiTree.
  • {{db_errors|Generations=10|WikiTreeID=Sälgö-3}} ==> This form can be used in comments, freespace pages and everywhere else on WikiTree.
  • {{db_errors|10|Sälgö-1|Y}} ==> Third parameter adds more help text. This form can be used in comments, freespace pages and everywhere else on WikiTree.

Errors on multiple pages

Errors are now split on multiple pages by 5000 errors. At the top after caption is previous / next navigation.

Errors

Analysis was done on data from May 15th 2016.

1418430 Errors Total 0000-0000 0001-1499 1500-1699 1700-1799 1800-1899 1900-1999 2000-Now Now-9999
101 Birth in future 308 308
102 Death in future 331 3 71 232 5 20
103 Death before birth 13080 132 472 1276 5979 5010 134 77
104 Too old 7001 473 1260 2110 2984 167 4 3
105 Duplicate sibling 3607 12 198 600 1986 811
106 Duplicates between global tree and unconnected 3245 24 402 963 1564 292
201 Father is self 121 59 10 3 35 14
202 Parents are same 193 17 1 17 16 111 31
203 Father is Female 6257 857 40 279 1173 3481 426 1
204 Father has no Gender 1175 461 8 2 667 37
205 Father is too young or not born 48694 2356 5368 10123 21156 9571 87 33
206 Father is too old 6928 614 1550 2475 2255 34
207 Father is also a child 393 84 28 37 97 125 21 1
208 Father is also a spouse 232 14 6 12 43 143 14
209 Father is also a sibling 3236 387 116 307 771 1362 293
301 Mother is self 5 5
303 Mother is Male 7880 757 16 394 1341 4812 560
304 Mother has no Gender 1715 839 12 12 777 75
305 Mother too young or not born 65535 2904 7174 14317 27587 13421 95 37
306 Mother is too old 5783 446 1212 1966 2125 34
307 Mother is also a child 13 2 1 1 2 4 3
308 Mother is also a spouse 1516 135 61 218 437 606 59
309 Mother is also a sibling 362 54 7 13 64 182 40 2
310 Mother was dead before birth 31153 1518 1212 6071 9415 12143 792 2
401 Spouse is self 3 2 1
402 Unknown gender of spouse 2386 701 10 50 18 1300 307
403 Single sex marriage 3998 391 39 259 230 2509 570
404 Marriage before birth 10634 215 922 2265 5084 2099 25 24
405 Married too old 2847 143 449 780 1468 7
406 Marriage after death 12556 528 361 1927 3016 6085 639
407 Death too old after Marriage 1769 57 17 204 405 856 222 3 5
501 Wrong male gender 9064 1484 145 705 1403 4081 1243 3
502 Missing male gender 75402 37571 69 1617 5930 21243 8941 31
503 Probably wrong male gender 6237 1344 91 547 722 2269 1253 9 2
504 Probably missing male gender 36129 24361 51 199 914 5462 5101 41
505 Wrong female gender 10479 1671 41 558 1449 5371 1387 2
506 Missing female gender 60682 28863 70 1150 4680 19227 6673 18 1
507 Probably wrong female gender 5389 900 23 246 739 2394 1084 3
508 Probably missing female gender 29462 20317 17 176 647 4429 3854 20 2
509 Missing gender 95747 78896 51 449 1498 8054 6745 52 2
510 Unique name without gender 23654 10726 57 199 726 7182 4695 69
511 Unique first name (spelling) 346225 75065 5229 11252 21767 118435 112107 2354 16
512 Separators in first name 68716 11690 371 2573 6834 31237 15968 42 1
601 Unknown birth location 9366 1733 24 361 1381 4392 1471 3 1
603 USA too early in birth location 216951 80 50404 166467
631 Unknown death location 16505 1466 60 795 2667 9180 2336 1
632 Y death location 6478 72 48 137 629 5546 46
633 USA too early in death location 80529 1056 46 55403 23897 88 39
661 Unknown marriage location 1346 71 3 68 237 735 232
663 USA too early in marriage location 26039 361 5 10046 15578 43 6
901 Unconnected empty public profiles 35418 35418
902 Unconnected empty open profiles 17172 17172

Changes since previous update

Explanation of error changes:

  • Increase in persons profiles was 0.20% so all errors should increase for that amount. that is 3231 errors.
  • and there are 2922 fewer errors

So in 4 days 6153 errors were corrected by my estimation.

Note: Usually with one correction you can correct multiple errors, because errors repeat in different groups.

1.5. 11.5. Projected 15.5. Reduction Delta%
Profiles 11184648 11206469 100,20%
Locations 10707022 10732026 100,23%
101 Birth in future 343 312 313 308 5 1,47%
102 Death in future 370 343 344 331 13 3,69%
103 Death before birth 13139 13111 13137 13080 57 0,43%
104 Too old 7021 7036 7050 7001 49 0,69%
105 Duplicate sibling 4711 3892 3900 3607 293 7,50%
106 Duplicates between bigtree and unconnected 3253 3293 3299 3245 54 1,65%
201 Father is self 251 240 240 121 119 49,68%
202 Parents are same 224 221 221 193 28 12,84%
203 Father is Female 6167 6244 6256 6257 -1 -0,01%
204 Father has no Gender 2159 1689 1692 1175 517 30,57%
205 Father is too young or not born 48551 48867 48962 48694 268 0,55%
206 Father is too old 6952 6955 6969 6928 41 0,58%
207 Father is also a child 510 502 503 393 110 21,87%
208 Father is also a spouse 241 234 234 232 2 1,05%
209 Father is also a sibling 3527 3512 3519 3236 283 8,04%
210 Father was dead before birth 32482 32559 32623 32505 118 0,36%
301 Mother is self 10 6 6 5 1 16,83%
303 Mother is Male 8321 7931 7946 7880 66 0,84%
304 Mother has no Gender 2101 1856 1860 1715 145 7,78%
305 Mother too young or not born 65178 65596 65724 65535 189 0,29%
306 Mother is too old 5822 5817 5828 5783 45 0,78%
307 Mother is also a child 35 34 34 13 21 61,84%
308 Mother is also a spouse 1566 1578 1581 1516 65 4,12%
309 Mother is also a sibling 373 364 365 362 3 0,74%
310 Mother was dead before birth 31202 31224 31285 31153 132 0,42%
401 Spouse is self 4 3 3 3 0 0,19%
402 Unknown gender of spouse 2990 2538 2543 2386 157 6,17%
403 Single sex marriage 4671 4001 4009 3998 11 0,27%
404 Marriage before birth 10937 10704 10725 10634 91 0,85%
405 Married too old 2857 2871 2877 2847 30 1,03%
406 Marriage after death 12580 12602 12627 12556 71 0,56%
407 Death too old after Marriage 2027 1818 1822 1769 53 2,88%
501 Wrong male gender 7130 7012 7026 9064 -2038 -29,01%
502 Missing male gender 53397 53276 53380 75402 -22022 -41,26%
503 Probably wrong male gender 8380 8349 8365 6237 2128 25,44%
504 Probably missing male gender 56357 56486 56596 36129 20467 36,16%
505 Wrong female gender 9072 8717 8734 10479 -1745 -19,98%
506 Missing female gender 51058 51119 51219 60682 -9463 -18,48%
507 Probably wrong female gender 7027 6946 6960 5389 1571 22,57%
508 Probably missing female gender 37889 37983 38057 29462 8595 22,58%
509 Missing gender 97415 97714 97905 95747 2158 2,20%
510 Unique name without gender 24792 24854 24902 23654 1248 5,01%
511 Unique name (spelling) 476223 477152 476571 581 0,12%
512 Separators in first name 68680 68814 68716 98 0,14%
601 Unknown birth location 9291 9343 9365 9366 -1 -0,01%
603 USA to early in birth location 217129 217281 217788 216951 837 0,38%
631 Unknown death location 16230 16454 16492 16505 -13 -0,08%
632 Y death location 6542 6534 6549 6478 71 1,09%
633 USA to early in death location 80738 80672 80860 80529 331 0,41%
661 Unknown marriage location 1328 1350 1353 1346 7 0,53%
662 Y marriage location 6 6 6 0 6 100,00%
663 USA to early in marriage location 26103 26113 26174 26039 135 0,52%
901 Unconected empty public profiles 35473 35433 35502 35418 84 0,24%
902 Unconected empty open profiles 17242 17221 17255 17172 83 0,48%
Total 1043174 1585719 1588950 1582797 6153 0,39%




Collaboration

On 22 May 2016 at 16:31 GMT Jayme (Mullins) Arrington wrote:

Working on 408: 0001-1499

On 22 May 2016 at 13:36 GMT Anders Kaas Petersen wrote:

Working on 506: 1800-1899

Page 1

On 21 May 2016 at 06:20 GMT Pierre Goolaerts wrote:

* Done 632 - 1800-1899 till Kilmer-154, mostly privacy 60 ones

On 18 May 2016 at 16:45 GMT Nan Lambert wrote:

Working on 109 -Profile should be Open, 1800-1899.

On 17 May 2016 at 09:57 GMT Aleš Trtnik wrote:

This is an example of template db_errors|10|Sälgö-2|Y in comment

WikiTree Error Report see Data Doctors Project for more info

This profile has been identified to have problem. For more information please see Project:Database_Errors or ask a question at G2G with tag db_errors