Criminal Justice Information database, where the missing data can be found


Following yesterday’s article on the cosy relationship between the police and Scottish Government, who are alarming a remarkably wide range of society, a flurry of information has been passed back to me, including the following notes on the Integration of Scottish Criminal Justice Information Systems (ISCJIS) database.  The First Minister has stonewalled requests to breakdown religiously aggravated crime, claiming the Crown Office have destroyed their records, but my source suggests the information is available for analysis in the ISCJIS database.  I’m told:

“The material stored (in the ISCJIS database) ranges from simple conviction records, to DNA, and social status. The data is used primarily for presenting Criminal History in court cases, and in identifying suspects in criminal investigations. It is also used of course to measure the social impact of changes in Legislation and Enforcement Policy, as evidenced by the current furore. It will also be used to predict the impact of such changes, particularly as regards Equality and Diversity impacts, which is a statutory requirement of any proposed Legislation.  You see, the ‘missing’ data is actually necessary in predicting the impact on Equality of the Offensive Behaviour Bill.”

“Essentially, if you want to know how many Section 74 Breach of the Peace convictions (Aggravation for Religious Prejudice) or even charges, there were at a given point in time in a given court, you simply search on the Breach of the Peace Conviction Code and add the modifier code ‘P’ indicating Religious Aggravation. All such offences are then returned, with full access (rights permitted) to the Reports and Case Notes.”

To assist the First Minister, below is information on what the enquiry form he has to complete looks like.  This is a link to the operation manual and if he’s really stuck he can call the helpdesk on 0141-585 – 8333.

We can only speculate why the authorities are so reluctant to disclose information on, on a subject so close to their hearts.

Quick shout for the John Thomson Memorial Fund, which is benefiting from the sale of 60″ posters for the recent stage play, check them out on ebay.

DEFINITION: The code for a crime or offence that adds to the Offence Code by highlighting particular circumstances relating to the specific incident as opposed to the actual charge.
DATA ITEMS: Crime/Offence Aggravator.
PERMISSIBLE CHARACTER SET: Code field – Alpha or Zero.
RANGES/VALUES: The code field is 1 character long and consists of an alpha code, which identifies the Aggravation to the offence committed. It is possible that a charge can have a combination of up to 6 aggravations. An aggravation description may be held in a text field within individual systems and will be an automatic expansion of the Offence Aggravation code into text to specify the nature of the Aggravation.
PRIMARY OWNERSHIP: ISCJIS – maintained by Crown Office.
CODES: Over page:-
CODE Aggravation Inactive indicator
Anticipated activation date

0 No Aggravation
A Anti Social Behaviour
B Offending whilst on Bail
C Cancelled
D Domestic Abuse
E Disability
F Football
G Football Banning Order
H Harassment
I Harassment Order
J Connected to Serious Crime Y October 2010
K Offence against a child
OFFENCE MODIFIER DEFINITION: The code for a crime or offence which provides additional information for the specific incident as opposed to the actual charge.
PERMISSIBLE CHARACTER SET: Code field. Alpha, numeric.
RANGES/VALUES: The code field is 4 characters long and consists of an alphanumeric code, which identifies additional elements of the charge. The code will consist of an alphabetic character followed by 3 numeric characters. If no modifier exists, 4 0’s (zeroes) characters will be transferred. An Offence Modifier description may be held in a text field within individual systems and will be an automatic expansion of the Offence Modifier code into text to specify the nature of the Offence Modifier.
PRIMARY OWNERSHIP: ISCJIS maintained by Crown Office
CODES:- See offence modifier codes. The current
definitions are:-
A For Class A Drugs
B For Class B Drugs
C For Class C Drugs
W For Weapons
L Breach of undertaking
Y October 2010
N Sexual Orientation
O Sex Offenders Order
P Religious
R Racial
S Sexual
Q Transgender

Read CQN Magazine for free online here. Subscriptions to the online copy are discretionary but you can contribute here. Old-school hard copies are available here from Magcloud.

[calameo code=000390171e35a62410844 lang=en page=10 hidelinks=1 width=100% height=500]
Click Here for Comments >

About Author

  1. Pages:
  2. 1
  3. 2
  4. 3
  5. 4
  6. 5
  7. 6
  8. 7
  9. 8
  10. 9
  11. ...
  12. 29

  1. I’m awating word from of the Irish clubs for spaces for the game on the 28 December. Originally I didn’t think my chanes were much good. Strangely enough I expect the phone to be ringing quite soon.



    Dilemma is should I still go and bring my own son, given I have taught my young son that being a republican is not a crime.



    Scrap that he’s liable to tell me not to be a hypocrite and for both of us to give it a miss.



    Árd Macha

  2. Headtheball at 15:39



    If the police reported Celtic to UEFA, why then did they not report Rangers when they played Hibs?



    UEFA have no jursidiction over SPL games so wouldn’t even entertain a complaint like this. The SPL should but they would no doubt produce similar findings to what they did with us, i.e. say Rangers have done all they can…



    Another thing, it would probably be the home team targeted not the away team.







    Article 1.



    All human beings are born free and equal in dignity and rights.They are endowed with reason and conscience and should act towards one another in a spirit of brotherhood.



    Article 2.



    Everyone is entitled to all the rights and freedoms set forth in this Declaration, without distinction of any kind, such as race, colour, sex, language, religion, political or other opinion, national or social origin, property, birth or other status. Furthermore, no distinction shall be made on the basis of the political, jurisdictional or international status of the country or territory to which a person belongs, whether it be independent, trust, non-self-governing or under any other limitation of sovereignty.



    Article 4.



    No one shall be held in slavery or servitude; slavery and the slave trade shall be prohibited in all their forms.



    Article 5.



    No one shall be subjected to torture or to cruel, inhuman or degrading treatment or punishment



    Article 6.



    Everyone has the right to recognition everywhere as a person before the law.



    Article 7.



    All are equal before the law and are entitled without any discrimination to equal protection of the law. All are entitled to equal protection against any discrimination in violation of this Declaration and against any incitement to such discrimination.



    The above is directed at 5 groups of people – firstly the Celtic fans who misguidedly think that the action against us is limited to football grounds. It’s not. Ask Rangers fans who have also been targeted. The second group is the “It has no place at Celtic, stop it!” group who would happily see our rights sold down the river to curry favour with people whose only aim is our capitulation. Thirdly it’s directed at UEFA who seem to feel that human rights are nothing more than an impediment to them making money. The fourth group? The MP’s and police who would gladly see us treated unfairly, and who think religious expressionshould be regarded as sectarian gesture. Finally, it’s directed at our board, whose lack of fight and utter capitutlation is as embarassing as it is cowardly.



    Paul67 – your last article was wrong. Confrontation? Where? There was no confrontation. That would require an opposing viewpoint or argument. Celtic happily took the fine. They can now get to work marketing the all new White Celtic strip… they’re just working on the process of bleaching all the green from shirts before going mass market.



    And they wonder why fans are deserting in droves! ha ha… I’ve said it before, but I’ll reitterate. I am an dissatisfied customer. And I won’t be back till Lawwell, Desmond et al are gone.




  4. I am genuinly furious at this whole debacle. The SNP, the board and especialy that spineless piece of crap Eddie Smith a So called Celtic supporter is responsible for tarnishing our good name and draging us down to the level of the Huns. Well done sir you might make Head Billy Boy in Blue for this one.

  5. Lawwell will do anything to get the blame of all things,placed on the Green Brigade.He does not like the banners.


    He is a failure as a CEO.He is a failure of a man.He is a Quisling.Let the people sing.Slan

  6. Good Luck to the boy, but so glad all those rumours over the years linking Celtic to him came to nothing.



    Manchester United and Scotland midfielder Darren Fletcher is taking an extended break from football due to a serious stomach illness.



    A United statement said the 27-year-old is suffering from ulcerative colitis, a chronic inflammatory bowel condition.



    His last game was in the Champions League against Benfica on 22 November, when he scored.



    The club said Fletcher had “accepted medical advice to take an extended break”.



    He is taking that break “in order to afford the best chance possible of achieving full remission once again”.

  7. Mort,



    thanks but that’s even more confusing. It’s ok to chant illicit stuff during an SPL game but not if playing in Europe? Nuts!

  8. Montebalnco



    read RaRaRasputins post at 15:31



    makes perfect sense to me.



    If the board appeal this whole thing drags on until Uefa meet next.



    Meat and drink for the laptop Loyalists, putting their own slant on things.



    For gods sake look at the division amongst the support already, just imagine what a few more days and weeks of phone ins, headline news etc they could conjure up to divide us more!



    Keep our eyes on the prize…



    The league is there for the taking…






    Graffitti on the wall says ‘Oo Ah up the Celts, Oo Ah up the Celts’



    for at least a while!

  9. u17 match v Partick at Lnxtn tonight…


    …postponed due to adverse weather


    ….+80mph winds etc

  10. ASonOfDan



    Worked with a guy from Dalkeith a few years back who is friendly with a relative of Darrens. He said Celtic would enquire about his availability every transfer window. HH

  11. Celtforlife – I’m not averse to an add-on or two, but look out for lurking polis ;)



    South Of Tunis – I agree. Eddie Smith had no mandate nor reason to report Celtic to UEFA. However, once he had, I think UEFA and Celtic have had no choice but to act as they have done.



    Going forward, the support need to find a way to effectively combat the political climate that has allowed the police to act.

  12. Ard Macha






    I fully expect Celtic’s Irish republican links to continue completely unhindered, I also recognise that reference to the Irish Republican Army ( any strand of ) appears to be against the rules of UEFA for which we have incurred the wrath, thanks entirely to Rangers being convicted for sectarianism.



    It’s also appears to be against the wishes of the majority of Celtic fans in this day and age to be glorifying the Ra, and also completely unnecessary when it could be said, that some of the self same Ra is sitting in Government in the North of Ireland, with the British.

  13. South of Tunis



    Whether or not Scottish plod had the authority to report us or not is irrellevant.



    They did, Uefa listened and we were fined.



    End of!



    Our real fight begins with the Scottish Govt and Plod!



    Which I am sure our board will be more than happy to start!



    If anything it offers the club A WAY OUT of this cesspit of a country citing DISCRIMINATION as a reason!

  14. nothing without fans on

    Big Nan at 14:28



    Just received this from the BBC Trust, following my complaint about the evidence from BBC Scotland:



    Sportscene – Scottish Cup Final



    Thank you for your email in response to mine of 25 November in which I provided you with a copy of the BBC Executive’s response to the background and considerations note regarding the consolidated appeal.



    As you are aware, the Editorial Standards Committee met to consider the consolidated appeal on 1 December 2011. In evaluating the evidence and arguments put before them, the Committee took account of the issues raised by some complainants about the admissibility of aspects of the BBC Executive response.



    We expect to be able to write to you with the Committee’s decision by the end of January, at which point we will also respond to you on any individual points you have raised that are relevant to the Committee’s decision.

  15. There are two issues here:


    1. The decision by some Celtic fans to sing songs which reference the IRA (in any of its forms).


    2. The, as far as I know, unprecedented decision of Strathclyde Police to report issue no.1 to UEFA.



    Once these 2 things have happened UEFA were always going to find the club guilty – it is covered by their rules. Once UEFA found the club guilty there is no way the club could be seen to publicly support the singing of these songs, so an appeal was a non-starter.



    As to the rights and wrongs of singing the songs, most people have a strong opinion one way or the other. I would be surprised if anyone has changed their opinion as a result of any of the many songs debates we’ve had on here over the years.

  16. We are now part of the illicit/racist brigade according to UEFA…



    November 21st



    NYON, Switzerland -UEFA has fined Polish club Legia Warsaw E10,000 ($13,500) after fans displayed an “illicit banner” at a Europa League game against Israeli club Hapoel Tel Aviv.



    The green banner spelled out “Jihad Legia” in Arabic-style script across one end of the stadium before the Sept. 29 match.



    UEFA’s disciplinary rules prohibit “political, offensive or provocative” acts at stadiums.



    June 23rd



    Croatia’s football federation has been fined $80,000 (56,000 Cda) for hooliganism from its fans at a European Championship qualifier after having been previously warned by UEFA that the country’s teams face expulsion from international competitions.



    UEFA says Croatia fans were responsible for “crowd disturbances, a pitch invasion, [and] the showing of illicit banners” during a 2-1 win against Georgia on June 3 in Split.



    Media reports say fans chanted fascist slogans and displayed swastikas.

  17. As if we didn’t know it, it’s open day on CELTIC F C .


    When you think about it, one can be offended by any number of things, for example I’m offened by Posh Spice, she really does offend me, but there you go, So, all it needs now is for someone/ police or other to be offend by something at CP says or does and that can be reported – a hiding to nothing if you ask me. Do you really think people will be as zealous at poundland or swinecastle for example?? Don’t think so, do you.


    Leave it to your imagination.




  18. Silver City Neil Lennon on

    Fortunes Favour Mibbes says:


    13 December, 2011 at 15:14



    I detest Flower of Scotland. Personally, if you are determined, I think you should do everything you can to cirumvert the rules. You can’t sing about the IRA so sing “A Nation Once Again.” It might be too political for UEFA so sing the Fields. Be fluid, not rigid. Primarily I care about Celtic. If you can forward your views, without damaging Celtic then I’d leave you to it.

  19. Gordon_J at 15:21



    You’re right: where does this stop?



    There’s plenty of existing legislation setting what’s right or wrong/legal or illegal, but none to tell us what’s ‘offensive’ and what’s not. For goodness’ sake, how many editions of Have I Got News For You would have been aired with such a view of life?



    And while I’m at it, who (and by what authority) decides what’s ‘illicit’?



    Off the top of my head I can think of several crappy fans’ ditties which get my goat and have nothing to do with football, but which it would be ludicrous to try to ban … e.g. ‘Robin Hood Riding Through the Glen’ (as played over the tannoy at City Ground before every home game), ‘I’m forever Blowing Bubbles’ (Upton Park), not to mention ‘Derry’s Walls’ or ‘The Sash’ (Poundland).



    By the same token, I dare say The Celtic Song causes offence to countless of our fellow country men.




  20. Neil canamalar Lennon hunskelper extrordinaire on



    “Which I am sure our board will be more than happy to start!



    If anything it offers the club A WAY OUT of this cesspit of a country citing DISCRIMINATION as a reason!”



    utter tosh, the board are the sole reason we are dealing with this problem now.Their greed has led them to removing the liberty of Celtic supporters on the off chance that appeasement works, they had the chance at the cup final when the bbc labelled us sectarian, our problem is that the board agree with the bbc, that is becoming all too apparent.


    They have sold us down the river, wake up and smell the coffee.

  21. NEIL LENNON celt for life………………..true words except punishment,or else this will go on and on,bringing further bad publicity to the club…keevins jabba pat the pratt will never let loose……..suppose loads of clubs have been fined by eufa,starting now to blow out of proportion………at least it wasnt for racism or sectarinnism….forget it and move on…let the songs get louder at celtic park let the camera rats know theyre not welcome…….hope they dont ban the huddle due to illicit cuddling !!

  22. Silver City Neil Lennon says:


    13 December, 2011 at 16:00



    how about … ooh aah Tiocfaidh ár lá, ooh aah Tiocfaidh ár lá

  23. RaRaRasputin, P8ddy and BlantyreKev.



    All excellent points.


    The next move by the board will HAVE to be the right one.



    It must be unequivocal, referenced and targetting the correct people/organisations.



    It is ok for us, the support to make emotional statements (based on a lack of information), not so the board, in this prolonged attack on our Celtic family.



    We are in a bitter, bitter war against an enemy that holds great sway, over the powers that be, in this bigoted little country of ours.



    For us to turn against the board is one of the main aims of the enemy.



    I cannot understand our board’s apparent lack of response to the many attacks on our family over the past couple of years. Simply have not a clue as I am not party to any facts.



    However I would trust them more than the alternative i.e. the SFA, SNP, Strathclyde Police, the Huns, Laptop Loyal etc etc etc.



    For us to implode, at such an early stage of this particular game of poker, just the Hun are about to throw in their hand, is exactly what the enemy is counting on.




  24. Árd Macha says:


    13 December, 2011 at 15:45



    Has the club has succeeded where Thatcher and co failed, in criminalising republicians.





    In my opinion their (the boards) complicitly has allowed this to happen

  25. Still no word from Lawell, well in that case over too the green brigade.



    What did you sing bhoys that has caused so much trouble?



    By the way how about learning some Jacobite songs, now that would really confuse wee fat eck.

  26. oglach UFB says:


    13 December, 2011 at 16:16



    The board are against republican singing at CP as was Stein, McNeil, the old board and Fergus McCann to name but a few. They see it as being bad for the club.

  27. Silver City Neil Lennon on

    Spearman says:


    13 December, 2011 at 16:08



    Now you are thinking. It only means “Our Day Will Come.” It has a football context as much as YNWA. There is a version of that from the late 80s early 90s.


    “Tiocfaidh, Tiocfaidh, Tiocfaidh ár lá. Our day will come. Our day will come. “Find a Jungleite from that time. He should come up with the tune, bit of a dirge though. Wonder if we’ll be hearing from Amy Winehouse on the PA of any Scottish Stadia this season.

  1. Pages:
  2. 1
  3. 2
  4. 3
  5. 4
  6. 5
  7. 6
  8. 7
  9. 8
  10. 9
  11. ...
  12. 29