PDA

View Full Version : FTDNA Project numbers



MitchellSince1893
12-31-2017, 07:20 PM
On 31 Dec 2017 FTDNA R1b Project membership #s
R1b: 16052
L21: 6436 +73 since 4 Dec
U106: 4149
R P312 and Subclades: 3589
U152: 2131 4 Dec EDIT: 2136 +26 since 4 Dec
DF27: 2038 +29 since 4 Dec
DF19: 310
L131: L238
DF99: 96

Will be interesting to see what it looks like 31 Dec 2018

Feel free to add any others

rms2
12-31-2017, 07:34 PM
The S1194 (DF100) Project: 81 members

The R1b Basal Subclades (R1b-M343 xP312xU106) Project: 1990 members

And of course, the most important project -

The R1b-41-1123 Project: 34 members :beerchug:

GarethH
12-31-2017, 09:03 PM
R-SRY2627/Z198 Project - 490 members of whom 459 have STR results and 162 have Big Y.

MitchellSince1893
12-31-2017, 09:09 PM
I guess this is the day to join the U152 group. I've got 5 new members since I started this post today.

Dewsloth
12-31-2017, 09:19 PM
Just fyi, of the 310 DF19 members, over 220 have done Big Y.
I think one of the two admins is STILL waiting for his "new" Big Y result...

MitchellSince1893
01-01-2018, 05:12 PM
On 1 Jan 2018 FTDNA Haplogroup R Project membership #s

R _R1b ALL Subclades 16055
R1a Project 7305
R L21 and Subclades 6438
R1a & all subclades 4185
R U106 (R1b-U106) 4157
R P312 and Subclades 3592
R1b French 2352
R U152 and Subclades 2136
R-M222 and Subclades 2073
R DF27 and Subclades 2040
R1b Basal Subclades 1991
R1b-L1335 1214
R L513 and Subclades 1206
R DF21 and Subclades 1128
R1b1a2 Iberian 1036
R-Arabia 942
R1b-CTS4466 Plus 827
R Z253 818
R Z255 and Subclades 711
R-Z18_Subgroups 660
R1b-U198 528
R SRY2627/Z198/L176 491
R2-M124-WTY 403
R-L226 398
R-17-14-10 374
R-L21WTY 369
R-DF49 and Subclades 367
R-DF41/R-CTS2501 & S 330
R DF19 and Subclades 312
R-FGC20747 277
R Z251 and Subclades 251
R2 241
R-L1/S26 Y-DNA Haplogroup 231
R1b-Three Kingdoms W 228
R FGC5494 Subclades 222
R1b-DF63 211
R-S1051 193
R1a* 173
R1b-CTS3386 148
R-P314 Haplogroup 140
R FGC13899 139
R1a-L260 134
R1b-L238 131
R* (M173- M343-) 117
R FGC11134 & Subclad 116
R-U152-FGC22501 103
R DF99 and Subclades 96
R-ZZ10 and Misc Subclades 74
R1b-BY250-Northern Germanic 74
R-CTS1751 67
R1b-P89.2 65
R1a_WTY 64
R FGC43417 57
R-FGC20980 - Jewish 55
R-L21 MacWho 52
R-L617 49
R S1026 & Subclades 48
R-M153 The Basque Ma 47
R1a - Z2123 and Subclades 36
R1b-41-1123 34
R-Y19847: Merging Paper Trail 32
R1b-FGC14605 Jewish 32
R Z209 and Subclades 27
R-Z16500 & Subclades 25
R-L1069 25
R1b-PF1169 24
R-BY2606 21
R-BY595 20
R-L554 18
R1a-YP728 & Subclades 17
R-U106xL48WTY 15
R1a-YP1137 & Subclades 14
R-U152+L2+BY3485+ 13
R1a-Y11268 & Subclades 13
R1a1a1h 13
R-A7297 10
R-Z56 and Subclades 8
R-L196 8
R1b-L1314 8
R1a-CTS4648 & Subclades 8
R1b1a 455-8 5
R1a-YP613 & Subclades 5

Mikewww
01-02-2018, 04:23 AM
Here is the penetration of Y111 in these two large subclade projects of R1b-P312:

DF27: 52.3%
L21: 55.8%

How does U152 compare with that? or U106?

I was honestly surprised that DFY27 has made this much progress. They can not be underestimated. They also have 41.8% Big Y penetration.

Wing Genealogist
01-02-2018, 12:35 PM
U106 currently has 47.5% of its members (4157) having Y111 STR results. This does not include the folks who are still pending Y111 results. In addition, we have 33.2% of members with current Big Y results (not including pending results). We also have 77 kits without any STR results (mostly Genographic Project results, but may also include autosomal results where the individual has tested U106+ via other testing companies).

Checking the pending results, I counted 155 pending Y111 STR tests and 130 pending Big Y tests. This would raise the percentages to: 51.3% 111 STRs & 36.3% Big Y.

Mikewww
01-02-2018, 08:03 PM
U106 currently has 47.5% of its members (4157) having Y111 STR results. This does not include the folks who are still pending Y111 results. In addition, we have 33.2% of members with current Big Y results (not including pending results). We also have 77 kits without any STR results (mostly Genographic Project results, but may also include autosomal results where the individual has tested U106+ via other testing companies).

Checking the pending results, I counted 155 pending Y111 STR tests and 130 pending Big Y tests. This would raise the percentages to: 51.3% 111 STRs & 36.3% Big Y.

Thank you, very impressive. I haven't tried to count pending tests for L21 and DF27 but these three big subclades (including U106) of L151 are quite active. I hope U152 is coming along.

MitchellSince1893
01-05-2018, 04:26 PM
I posted this elsewhere but just to consolidate it here:

As of today U152 project has 2144 members of which 595 (536 completed, 55 batched, 4 ordered) are BigY tested (27.8%)


We have 845 members (768 completed, 73 batched, 4 ordered) who have ordered 111 test (39.4%),1524 with 67 markers (71.1%), 1924 with 37 markers (89.7%), 1961 with 25 markers (91.5%) 2056 with 12 markers (95.9%), and 88 members without any STR results.

Another 138 BigY orders don't have a 111 test completed/batched/or ordered. Once these are added 45.8% of all members will have 111 marker results (47.8% of all STR results).

MitchellSince1893
02-02-2018, 03:05 AM
On 1 Jan 2018 FTDNA Haplogroup R Project membership #s

R _R1b ALL Subclades 16055
R1a Project 7305
R L21 and Subclades 6438
R1a & all subclades 4185
R U106 (R1b-U106) 4157
R P312 and Subclades 3592
R1b French 2352
R U152 and Subclades 2136
R-M222 and Subclades 2073
R DF27 and Subclades 2040
R1b Basal Subclades 1991
R1b-L1335 1214
R L513 and Subclades 1206
R DF21 and Subclades 1128
R1b1a2 Iberian 1036
R-Arabia 942
R1b-CTS4466 Plus 827
R Z253 818
R Z255 and Subclades 711
R-Z18_Subgroups 660
R1b-U198 528
R SRY2627/Z198/L176 491
R2-M124-WTY 403
R-L226 398
R-17-14-10 374
R-L21WTY 369
R-DF49 and Subclades 367
R-DF41/R-CTS2501 & S 330
R DF19 and Subclades 312
R-FGC20747 277
R Z251 and Subclades 251
R2 241
R-L1/S26 Y-DNA Haplogroup 231
R1b-Three Kingdoms W 228
R FGC5494 Subclades 222
R1b-DF63 211
R-S1051 193
R1a* 173
R1b-CTS3386 148
R-P314 Haplogroup 140
R FGC13899 139
R1a-L260 134
R1b-L238 131
R* (M173- M343-) 117
R FGC11134 & Subclad 116
R-U152-FGC22501 103
R DF99 and Subclades 96
R-ZZ10 and Misc Subclades 74
R1b-BY250-Northern Germanic 74
R-CTS1751 67
R1b-P89.2 65
R1a_WTY 64
R FGC43417 57
R-FGC20980 - Jewish 55
R-L21 MacWho 52
R-L617 49
R S1026 & Subclades 48
R-M153 The Basque Ma 47
R1a - Z2123 and Subclades 36
R1b-41-1123 34
R-Y19847: Merging Paper Trail 32
R1b-FGC14605 Jewish 32
R Z209 and Subclades 27
R-Z16500 & Subclades 25
R-L1069 25
R1b-PF1169 24
R-BY2606 21
R-BY595 20
R-L554 18
R1a-YP728 & Subclades 17
R-U106xL48WTY 15
R1a-YP1137 & Subclades 14
R-U152+L2+BY3485+ 13
R1a-Y11268 & Subclades 13
R1a1a1h 13
R-A7297 10
R-Z56 and Subclades 8
R-L196 8
R1b-L1314 8
R1a-CTS4648 & Subclades 8
R1b1a 455-8 5
R1a-YP613 & Subclades 5

The 1 Feb 2018 numbers

Project Members
R _R1b ALL Subclades 16343
R1a Project 7417
R L21 and Subclades 6543
R U106 (R1b-U106) 4250
R1a & all subclades 4208
R P312 and Subclades 3659
R1b French 2353
R U152 and Subclades 2185
R DF27 and Subclades 2098
R-M222 and Subclades 2089
R1b Basal Subclades 1996
R1b-L1335 1241
R L513 and Subclades 1223
R DF21 and Subclades 1140
R1b1a2 Iberian 1051
R-Arabia 953
R1b-CTS4466 Plus 831
R Z253 825
R Z255 and Subclades 718
R-Z18_Subgroups 666
R1b-U198 541
R SRY2627/Z198/L176 496
R2-M124-WTY 423
R-L226 421
R-17-14-10 378
R-DF49 and Subclades 373
R-L21WTY 370
R-DF41/R-CTS2501 & S 333
R DF19 and Subclades 320
R-FGC20747 284
R Z251 and Subclades 254
R2 244
R-L1/S26 Y-DNA Haplogroup 231
R1b-Three Kingdoms W 229
R FGC5494 Subclades 228
R1b-DF63 218
R-S1051 195
R1a* 173
R1b-CTS3386 151
R-P314 Haplogroup 149
R FGC13899 141
R1a-L260 141
R1b-L238 136
R FGC11134 & Subclad 124
R* (M173- M343-) 120
R-U152-FGC22501 106
R DF99 and Subclades 104
R-ZZ10 and Misc Subclades 96
R FGC43417 88
R1b-BY250-Northern Germanic 76
R-CTS1751 72
R1b-P89.2 67
R1a_WTY 63
R-FGC20980 - Jewish 55
R-L21 MacWho 52
R-L617 51
R S1026 & Subclades 49
R1a-YP1137 & Subclades 48
R-M153 The Basque Ma 47
R1a - Z2123 and Subclades 37
R-Y19847: Merging Paper Trail 36
R1b-41-1123 34
R1b-FGC14605 Jewish 34
R Z209 and Subclades 28
R-L1069 26
R-Z16500 & Subclades 25
R-BY2606 21
R1b-PF1169 20
R-BY595 20
R-L554 18
R1a-YP728 & Subclades 17
R-U106xL48WTY 15
R1a1a1h 13
R-U152+L2+BY3485+ 13
R1a-Y11268 & Subclades 12
R-A7297 10
R1b-L1314 8
R-L196 8
R-Z56 and Subclades 8
R1a-CTS4648 & Subclades 7
R1b1a 455-8 5
R1a-YP613 & Subclades 4

MitchellSince1893
02-02-2018, 03:22 AM
Here is the growth rate from 1 Jan 2018 to 1 Feb 2018 of the R haplogroup projects with at least 100 members. Projects with ~2000 or more project members in bold.

R DF99 and Subclades 8.33%
R FGC11134 & Subclad 6.90%
R-P314 Haplogroup 6.43%
R-L226 5.78%
R1a-L260 5.22%
R2-M124-WTY 4.96%
R1b-L238 3.82%
R1b-DF63 3.32%
R-U152-FGC22501 2.91%
R DF27 and Subclades 2.84%
R FGC5494 Subclades 2.70%
R DF19 and Subclades 2.56%
R* (M173- M343-) 2.56%
R-FGC20747 2.53%
R1b-U198 2.46%
R U152 and Subclades 2.29%
R U106 (R1b-U106) 2.24%
R1b-L1335 2.22%
R1b-CTS3386 2.03%
R P312 and Subclades 1.87%
R _R1b ALL Subclades 1.79%
R-DF49 and Subclades 1.63%
R L21 and Subclades 1.63%
R1a Project 1.53%
R1b1a2 Iberian 1.45%
R FGC13899 1.44%
R L513 and Subclades 1.41%
R2 1.24%
R Z251 and Subclades 1.20%
R-Arabia 1.17%
R-17-14-10 1.07%
R DF21 and Subclades 1.06%
R-S1051 1.04%
R SRY2627/Z198/L176 1.02%
R Z255 and Subclades 0.98%
R-Z18_Subgroups 0.91%
R-DF41/R-CTS2501 & S 0.91%
R Z253 0.86%
R-M222 and Subclades 0.77%
R1a & all subclades 0.55%
R1b-CTS4466 Plus 0.48%
R1b-Three Kingdoms W 0.44%
R-L21WTY 0.27%
R1b Basal Subclades 0.25%
R1b French 0.04%
R-L1/S26 Y-DNA Haplogroup 0.00%
R1a* 0.00%

RobertCasey
02-02-2018, 03:52 PM
Mitchell - since you are having so much fun summarizing haplogroup R, here are two files that you should enjoying playing around with:

http://www.rcasey.net/DNA/Temp/HG_R_Master_20170630A.xlsx

http://www.rcasey.net/DNA/Temp/Haplogroup_R_20180125B.xlsx

Here are some facts associated with these two files:

1) the first files is 67 or higher markers (but 68 to 111 markers are not included) - 54,100.
2) the second file is 37 only markers - 45,400 (this is a new file).
3) these pulls are from 5,200 projects (biased to European and R1b).
4) the last pull was in May, 2017.
5) the haplogroups are from the YSTR report and are only entered once when the tester reaches 37 or 67 markers.
6) the 37 marker file does not have derived fields that manually have to be added - just raw FTDNA data.

On other sidenote, I have been using the FTDNA matching system as a L226 admin to find matches. I have already
increased the size of L226 by 15 % - the vast majority are private (project only) privacy settings. I am not nearly
complete with this data mining and fully expect that 20 to 30 % of testers are defaulting to private and are
not available in public projects. Based on this discovery, the current count is around 125,000 testers at 37
markers or higher for R1b. Then add another 20 % for projects that still have either the YSTR or YSNP report
private to their project - 150,000 is probably more realistic due to privacy settings. Then you need to add
testers that have never joined any projects and can not be found. And for each pull, I add 250 to 500 new
projects which always adds another one percent for each pull. So the above summaries are probably missing
50 % of haplogroup R testers and the percentage continues to grow with FTDNA's default for all new YSTR
testers is private.

Everyone should really lobby for projects to change their report settings to public (Anyone) and if you notice
that individuals show up in the project that you belong to - but do not show in the public version, lobby them
to update their privacy settings to public. By the end of 2018, over 50 % of all R1b testers will not be accesssible
to the general public.

My automated extraction program is now down again due to some change in my network or FTDNA servers. Does anyone know
of any new changes since May that FTDNA has implemented ? I also have not updated the code for the new YSNP format that only shows the first 25 testers. The error checking routines indicate that it is some kind of connection issue. The hppts check
still passes and that was a bear to update around two years ago. Also, my friendly local IP provider (now Spectrum) altered my
DNS servers around three years to add their advertising - I had to hard code known DNS servers for that network issue.

MitchellSince1893
03-03-2018, 03:06 AM
2 March 2018 numbers

R _R1b ALL Subclades 16608
R1a Project 7533
R L21 and Subclades 6646
R U106 (R1b-U106) 4325
R1a & all subclades 4246
R P312 and Subclades 3726
R1b French 2354
R U152 and Subclades 2190
R DF27 and Subclades 2149
R-M222 and Subclades 2135
R1b Basal Subclades 2030
R1b-L1335 1252
R L513 and Subclades 1232
R DF21 and Subclades 1157
R1b1a2 Iberian 1072
R-Arabia 961
R Z253 840
R1b-CTS4466 Plus 835
R Z255 and Subclades 723
R-Z18_Subgroups 675
R1b-U198 546
R SRY2627/Z198/L176 500
R-L226 440
R2-M124-WTY 426
R-DF49 and Subclades 385
R-17-14-10 381
R-L21WTY 372
R-DF41/R-CTS2501 & S 337
R DF19 and Subclades 331
R-FGC20747 292
R Z251 and Subclades 260
R2 246
R1b-Three Kingdoms W 233
R-L1/S26 Y-DNA Haplogroup 233
R FGC5494 Subclades 231
R1b-DF63 221
R-S1051 199
R1a* 174
R1b-CTS3386 153
R-P314 Haplogroup 151
R1a-L260 148
R FGC13899 143
R1b-L238 140
R FGC11134 & Subclad 127
R* (M173- M343-) 125
R-ZZ10 and Misc Subclades 114
R DF99 and Subclades 110
R-U152-FGC22501 109
R FGC43417 97
R1b-BY250-Northern Germanic 77
R-CTS1751 72
R1b-P89.2 68
R1a_WTY 63
R-FGC20980 - Jewish 55
R-L21 MacWho 53
R1a-YP1137 & Subclades 51
R-L617 51
R S1026 & Subclades 49
R-M153 The Basque Ma 47
R-Y19847: Merging Paper Trail 37
R1a - Z2123 and Subclades 35
R1b-41-1123 34
R1b-FGC14605 Jewish 33
R Z209 and Subclades 29
R-Z16500 & Subclades 27
R-L1069 26
R-BY2606 21
R1b-PF1169 20
R-BY595 20
R-L554 19
R1a-YP728 & Subclades 18
R-U106xL48WTY 15
R1a-Y11268 & Subclades 14
R1a1a1h 13
R-U152+L2+BY3485+ 13
R-A7297 10
R-Z56 and Subclades 9
R1b-L1314 8
R-L196 8
R1a-CTS4648 & Subclades 7
R1a-YP613 & Subclades 5
R1b1a 455-8 4

RobertCasey
03-03-2018, 06:10 AM
R-L226 has the following distribution of testers:

Total members_____445
Big Y_____________115 - 25.8 %
111______________214 - 48.1 %
67_______________382 - 85.8 %
37_______________434 - 97.5 %

But these number are misleading, as my spreadsheet shows non-project members as well:

Total members_____950
Big Y_____________115 - 12.1 %
111______________259 - 27.2 %
67_______________648 - 68.2 %
37_______________950 - 100 % - do not track 25 or lower

Starting in September, L226 changed their guidelines for joining R-L226 to being confirmed L226 by YSNP testing to being predicted L226 by YSTR signature. Since that time, we have proactively encouraged joining the project and during the last six months have increased the project size by 45 %. This has been done primarily via the FTDNA matching system and sending emails requesting testers to join. Less than five percent have been rejected (L226 is very isolated) and to my big surprise - over half were not in our spreadsheet (privacy setting to private -Project only or no project membership). So for predictable single signature haplogroup projects, you can probably double your project size via the FTDNA matching system as the number of "Project Only" testers (new FTDNA default), no project YSTR report or no major project being joined is extremely large (probably around 50 % of your testers). I still need to contact at least another 100 testers (second or third request for some). Also, as new testers join, new matches show up for these testers which is another surprise.

MitchellSince1893
03-03-2018, 03:58 PM
In February we removed ~35 members who shouldn't have been in the project, so that's why you don't see much growth for U152.

Webb
03-05-2018, 06:05 PM
In February we removed ~35 members who shouldn't have been in the project, so that's why you don't see much growth for U152.

DF27 is gaining on you.;)

MitchellSince1893
03-05-2018, 06:50 PM
DF27 is gaining on you.;)Last summer I thought they would’ve already passed us by now.

MitchellSince1893
05-02-2018, 01:10 AM
1 May update with percentage of change since 1 Jan 2018

https://i.pinimg.com/originals/0e/df/7f/0edf7ffef83741380d5e9b14aa8eceec.png

rms2
05-05-2018, 12:10 AM
Once again you left out the monumentally important R1b-41-1123 Project (https://www.familytreedna.com/groups/r1b-41-1123/about/project-statistics), which has 34 members.

It's the quality, not the quantity, or as they say in Quantico, Virginia, whatever.

(I think they say, "It's the Quantico, not the Qualico", but that's not very helpful.)

MitchellSince1893
05-05-2018, 12:39 AM
Once again you left out the monumentally important R1b-41-1123 Project (https://www.familytreedna.com/groups/r1b-41-1123/about/project-statistics), which has 34 members.

It's the quality, not the quantity, or as they say in Quantico, Virginia, whatever.

(I think they say, "It's the Quantico, not the Qualico", but that's not very helpful.)

I cut it off at 100, so when you hit that benchmark...

MitchellSince1893
06-02-2018, 03:23 AM
Jan to Jun 2018 numbers and percentage of change.
https://i.pinimg.com/originals/5a/4a/ed/5a4aed8df580c19ca2c8e042d818c2b9.png

Dewsloth
06-02-2018, 05:52 AM
Jan to Jun 2018 numbers and percentage of change.
https://i.pinimg.com/originals/5a/4a/ed/5a4aed8df580c19ca2c8e042d818c2b9.png

Something is wrong. Maybe it's a change in the privacy defaults, but DF19 continues to grow. It now has 343 members as of this week, despite what the above says. Perhaps the other "declining" groups are experiencing something similar.


edit: Or perhaps it's just a typo and the value for the R Z251 cell beneath (also 269) was accidentally used instead of 343?

Dewsloth
06-05-2018, 06:29 PM
Something is wrong. Maybe it's a change in the privacy defaults, but DF19 continues to grow. It now has 343 members as of this week, despite what the above says. Perhaps the other "declining" groups are experiencing something similar.


edit: Or perhaps it's just a typo and the value for the R Z251 cell beneath (also 269) was accidentally used instead of 343?

Make that 345. :)

MitchellSince1893
07-01-2018, 09:11 PM
1 Jul 2018 FTDNA Y-dna haplogroup project numbers and percentage of change over the last 6 months.

https://i.pinimg.com/originals/48/d2/24/48d22437118d400426162d465c524621.png

per the earlier posts, On the previous month I had a typo on the DF19 numbers...should have been ~343 instead of 269.

MitchellSince1893
12-31-2018, 06:17 PM
Changes in R Haplogroup project numbers over the last year, and totals in FTDNA database.

https://i.pinimg.com/originals/99/bb/c1/99bbc174b9ea8fb962b7dfbb41e78c3f.png

Note: Not every member of a project has tested positive for that SNP. Hence you can have more members in a project than actual positive results for that haplogroup/SNP.

Webb
12-31-2018, 08:57 PM
Changes in R Haplogroup project numbers over the last year, and totals in FTDNA database.

https://i.pinimg.com/originals/99/bb/c1/99bbc174b9ea8fb962b7dfbb41e78c3f.png

Note: Not every member of a project has tested positive for that SNP. Hence you can have more members in a project than actual positive results for that haplogroup/SNP.

Hehehehe!!! Now picture Uriah Heep, rubbing his hands together.

MitchellSince1893
12-31-2018, 11:20 PM
Hehehehe!!! Now picture Uriah Heep, rubbing his hands together.

https://cdn.drawception.com/images/panels/2014/5-21/jBgSZhHHKq-1.png

Combined R-Z40481 subclades (DF27: 5922, U152: 5475, DF99: 158, ZZ37_1: 97) are now more numerous in the FTDNA database than all R1a 11749 vs 11664; and are almost as numerous as all of U106: 11749 vs 12475.

L21 still has a big lead on the rest of P312, making up 57.6% of all P312 in the FTDNA database.