Ok, so I finally finished putting the incident dates on here, I would like to thank @life-in-present-tense for getting all the dates, it was incredibly helpful, and saved me so much time.
(This took me way, way longer to finish than it should have. I actually put all the dates in a while ago, but to make the sheet in chronological order I had to move each row manually and I ended up getting busy and not having the energy or motivation to finish it so I’m sorry about that.)
To recap, here’s all the information on the sheet:
- Episode Number
- Episode Length (for multiple statements in one episode the statement length is in parentheses. [ I’m not quite finished with them yet])
- Episode Name
- Read by / Taken by
- Case File Number
- Statement Giver
- (Date of) Statement Given
- Regarding… (summary)
- (Date when it was) Committed to tape
- (List of) Speaking Characters
- Incident Date
Along with the information, there are multiple sheets:
- Episode Order
- Alphabetical Order
- Alphabetical Order without (most) “The"s and "A"s
- Chronological Order by Statement Given Date
- Chronological Order by Incident Date (For ones that have no date, I placed it based off of when the statement was given, so the incident was some point before then.)
- Statement Filters (Read by / Taken by - Jonathan Sims, Elias Bouchard, Gertrude Robinson, Basira Hussain, Martin Blackwood, Melanie King, Timothy Stoker, and Live Statements)
- Speaking Characters Filters (Literally every character that spoke in more than one (1) episode, and One Time Characters)
For the filter sheets I’m not sure how well it works on mobile, but it definitely works on a laptop.
(EDIT: The Statement filter page is not completely working, Episode 200 is on every filter, I will try to fix that later)
For the Incident dates, I changed the format a bit from what was written, to see what Life-In-Present-Tense wrote originally, go Here.
For the the sheet, I placed them based of the earliest date. (I.e 2003-2009 would be in the "2003” section)