I think that the data in the OP is completely wrong. The lists are not members that were airdropped merit and have not sent any, but rather members that have given merit and not received any themselves.

I guess you wrote something like this on Piggy’s SQL:

select rank, count(*) nUsers
from UserData u
where (select sum(merit)from MeritData m where m.ToID  = u.UserId)=0
group by Rank

or
select rank, count(*) nUsers
from UserData u
where not exists (select 1 from MeritData m where m.ToID  = u.UserId)
group by rank

Rank   nUsers
Brand new           4
Copper Member   9
Full Member   2424
Hero Member   476
Jr. Member        29
Legendary       224
Member          2811
Newbie              13
Sr. Member     1078


The UserData table has 29039 records, one for each user that has merited or received merit. Therefore, excluding the merited you get the meriters that have not yet been merited…

You cannot know who got an initial amount of sMerit (less of all how much on an individual level), since the formula depends on their activity during the year previous to sMerit System kick-off, and you cannot know this since there is no available full DB snapshot (not just merited) dating one year before and on the date of the merit system kick-off.