Ok, so "flat" is same as "wide"...
I still think "deep" file is better than "wide", because it is more understable. Maybe during analysis, we will come to "wide" version, but for understanding "deep" is much more clear.
Penalties can include a lot of sanctions (from inprisonement to attendance of special programs within the prison and probation service. Now I want to know what sanction (prison, program 1, program2 etc) that has the best preventive effect. So I want to be able to find out:
Ah, it clears your problem a little.
So, as I am clear, you want to check if person stopped doing selected kind of crime after some of sanction (taken from year of verdict?). And calculate how many crimes same type, he did after each verdict ?
To help you I still need example, please send me a part of your data and a result you want to receive from this part (numbers). Just, select few records and calculate result by hand, so I can imagine the whole process.