Pipal password analysis of the Rockyou-75 password leak

Pipal analysis of the Rockyou 75k passwords, the passwords were unique'd before running, hence the lack of reuse in the top 10.

Some observations:

Look at the popular years, says a lot about the age of users.

February is a pretty unpopular month and Friday is a popular day

If you used the top 4 hashcat masks you'd crack over 50% of the passwords

nicole and pink are interesting base words.

love, angel, sexy and password in the top 4 places seems reasonable.

Top 10 passwords
123456 = 2 (0.0%)
12345 = 2 (0.0%)
123456789 = 2 (0.0%)
password = 2 (0.0%)
iloveyou = 2 (0.0%)
princess = 2 (0.0%)
1234567 = 2 (0.0%)
12345678 = 2 (0.0%)
abc123 = 2 (0.0%)
nicole = 2 (0.0%)

Top 10 base words
love = 167 (0.28%)
angel = 106 (0.18%)
sexy = 87 (0.15%)
password = 85 (0.14%)
princess = 77 (0.13%)
baby = 72 (0.12%)
monkey = 72 (0.12%)
nicole = 70 (0.12%)
pink = 69 (0.12%)
soccer = 67 (0.11%)

Total entries = 59184
Total unique entries = 59184

Password length (length ordered)
2 = 4 (0.01%)
3 = 15 (0.03%)
4 = 236 (0.4%)
5 = 3192 (5.39%)
6 = 23757 (40.14%)
7 = 12023 (20.31%)
8 = 10572 (17.86%)
9 = 5050 (8.53%)
10 = 2871 (4.85%)
11 = 846 (1.43%)
12 = 335 (0.57%)
13 = 169 (0.29%)
14 = 65 (0.11%)
15 = 33 (0.06%)
16 = 17 (0.03%)
17 = 5 (0.01%)
18 = 6 (0.01%)
20 = 3 (0.01%)
26 = 3 (0.01%)
39 = 2 (0.0%)


Password length (count ordered)
6 = 23757 (40.14%)
7 = 12023 (20.31%)
8 = 10572 (17.86%)
9 = 5050 (8.53%)
5 = 3192 (5.39%)
10 = 2871 (4.85%)
11 = 846 (1.43%)
12 = 335 (0.57%)
4 = 236 (0.4%)
13 = 169 (0.29%)
14 = 65 (0.11%)
15 = 33 (0.06%)
16 = 17 (0.03%)
3 = 15 (0.03%)
18 = 6 (0.01%)
17 = 5 (0.01%)
2 = 4 (0.01%)
26 = 3 (0.01%)
20 = 3 (0.01%)
39 = 2 (0.0%)

      |
      |
      |
      |
      |
      |
      |
      ||
      |||
      |||
      |||
      |||
      ||||
     |||||
     ||||||
||||||||||||||||||||||||||||||||||||||||
0000000000111111111122222222223333333333
0123456789012345678901234567890123456789

One to six characters = 54398
One to eight characters = 99584
More than eight characters = 18784

Only lowercase alpha = 59608
Only uppercase alpha = 2476
Only alpha = 63168
Only numeric = 20746

First capital last symbol = 4
First capital last number = 346

Months
january = 34
february = 6
march = 44
april = 58
may = 89
june = 56
july = 42
august = 49
september = 33
october = 36
november = 35
december = 34

Days
monday = 2
tuesday = 1
wednesday = 2
thursday = 1
friday = 4
saturday = 2
sunday = 2

Months (Abreviated)
jan = 154
feb = 12
mar = 995
apr = 79
may = 89
jun = 127
jul = 106
aug = 73
sept = 58
oct = 49
nov = 57
dec = 47

Days (Abreviated)
mon = 531
tues = 1
wed = 11
thurs = 2
fri = 94
sat = 31
sun = 124


Includes years
1975 = 6
1976 = 6
1977 = 8
1978 = 8
1979 = 12
1980 = 27
1981 = 23
1982 = 36
1983 = 36
1984 = 50
1985 = 61
1986 = 65
1987 = 88
1988 = 80
1989 = 116
1990 = 112
1991 = 109
1992 = 95
1993 = 72
1994 = 63
1995 = 49
1996 = 16
1997 = 5
1998 = 2
1999 = 3
2000 = 14
2001 = 15
2002 = 19
2003 = 23
2004 = 26
2005 = 38
2006 = 53
2007 = 51
2008 = 40
2009 = 18
2010 = 43
2011 = 17
2012 = 18
2013 = 3
2017 = 2
2018 = 22
2019 = 31
2020 = 20

Years (Top 10)
1989 = 116
1990 = 112
1991 = 109
1992 = 95
1987 = 88
1988 = 80
1993 = 72
1986 = 65
1994 = 63
1985 = 61

Single digit on the end = 7367
Two digits on the end = 6464
Three digits on the end = 1504


Last number
0 = 1569
1 = 6802
2 = 3006
3 = 3614
4 = 1962
5 = 2041
6 = 1954
7 = 1985
8 = 1606
9 = 1543

 |
 |
 |
 |
 |
 |
 |
 | |
 |||
 |||
 |||
 |||||||
||||||||||
||||||||||
||||||||||
||||||||||
0123456789

Last digit
1 = 6802
3 = 3614
2 = 3006
5 = 2041
7 = 1985
4 = 1962
6 = 1954
8 = 1606
0 = 1569
9 = 1543

Last 2 digits (Top 10)
23 = 1463
12 = 795
89 = 717
88 = 699
90 = 689
06 = 642
87 = 631
91 = 628
07 = 580
92 = 579


Last 3 digits (Top 10)
123 = 1183
101 = 139
990 = 133
989 = 127
991 = 114
987 = 112
992 = 102
234 = 100
988 = 99
789 = 89

Last 4 digits (Top 10)
1234 = 96
1990 = 92
1989 = 83
1991 = 77
1992 = 66
1987 = 62
1988 = 57
3456 = 52
1993 = 47
2345 = 43

Last 5 digits (Top 10)
23456 = 46
12345 = 41
21990 = 18
56789 = 17
01990 = 16
54321 = 15
00000 = 14
01992 = 14
21992 = 13
21987 = 13

Character sets
loweralpha: 29804 (50.36%)
loweralphanum: 16332 (27.60%)
numeric: 10373 (17.53%)
upperalpha: 1238 (2.09%)
mixedalpha: 542 (0.92%)
loweralphaspecial: 354 (0.60%)
upperalphanum: 262 (0.44%)
mixedalphanum: 102 (0.17%)
loweralphaspecialnum: 62 (0.10%)
special: 21 (0.04%)
specialnum: 9 (0.02%)
mixedalphaspecialnum: 8 (0.01%)
mixedalphaspecial: 2 (0.00%)
upperalphaspecial: 2 (0.00%)

Character set ordering
allstring: 31584 (53.37%)
stringdigit: 15625 (26.40%)
alldigit: 10373 (17.53%)
digitstring: 541 (0.91%)
stringdigitstring: 395 (0.67%)
stringspecial: 280 (0.47%)
othermask: 251 (0.42%)
stringspecialstring: 66 (0.11%)
stringspecialdigit: 31 (0.05%)
allspecial: 21 (0.04%)
digitstringdigit: 11 (0.02%)
specialstringspecial: 4 (0.01%)
specialstring: 2 (0.00%)

Hashcat masks (Top 10)
?l?l?l?l?l?l: 9539 (16.12%)
?d?d?d?d?d?d: 9374 (15.84%)
?l?l?l?l?l?l?l: 6345 (10.72%)
?l?l?l?l?l?l?l?l: 5297 (8.95%)
?l?l?l?l?l?l?l?l?l: 2848 (4.81%)
?l?l?l?l?l: 2785 (4.71%)
?l?l?l?l?l?l?d: 2302 (3.89%)
?l?l?l?l?l?l?d?d: 1892 (3.20%)
?l?l?l?l?l?d: 1846 (3.12%)
?l?l?l?l?l?d?d: 1795 (3.03%)