ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Total dates1292
Every other dates after that came from @KIU publications, memorials, "tombstones" or Russian media
2
I took the entire list of officers from KIU (including reserve and retired officers)
3
I filtered out everything that was between brackets "()" and the remaining names if the brackets were in the middle
4
Step: 1
I searched (VLOOKUP) the resulting name in 666_mancer's list and output the DoD
5
785
6
2
I searched (query with operator "contains" of) the remainder inside a list of 600+ tweets from @KIU I managed to scrape
7
71
8
3
I searched (query with operator "contains" of) the remaining names in the list of 666_mancer's names
9
39
10
4
I searched the remaining names on Twitter, one by one, and took note of the DoD when available in either the tweet, replies or source of info provided
11
(a lot of names didn't produce a Tweet from KIU)
116
12
5
I truncated the remaining names to only the first 2 names and redid the manual search
13
(there were still over 80 names that didn't produce a tweet from KIU)
48
14
6
I truncated the remaining names to only the first name and redid the manual search
15
0
16
7
I substituted all latin characters to cyrillic characters and redid the manual search
17
1
18
8Other haphazard search
19
I don't know why, but sometimes Twitter won't find a tweet even if the spelling is identical
15
20
9
Rearranged first and last name and searched identical results on timenote.info
21
248
22
10However, not all dates on timenote.info can be trusted
23
Sometimes the date displayed is after a known funeral, but most cases are of death within just a few days of the funeral OR the date is the same as the date of announcement that the officer died
-78
24
If there's no supporting evidence that the death occured on the same date as the announcement it's removed
25
If there's almost no information about the death circumstances or the deceased and it's dated within 2 days of the publication, the DoD is removed. Exception: if the DoD is in February or March and within 1 day of date of publication, the DoD is kept because the odds of being in the wrong week are a lot smaller than other time periods.
26
If the listed DoD is within 5 days of the funeral, it's removed unless there's supporting evidence.
27
11
Remaining names as of Nov 21 - somehow filtered them when making a list of searches to do
28
34
29
12Set date manually when only the month was available
30
1
31
That leaves 218 officers with nothing more than a publication of death notice or funeral notice (DoP)
32
Of which, 50 have NO KNOWN PUBLICATION. None of them have the latin-character(s) issue.
33
34
This process took over 72 hours to complete and new officers were added to KIU's list.
35
Browsing the tweet history to recover names and additional info.
36
Step 1.
Go through the list of tweets and search the name on the list used
37
12
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100