Module Output
SQL:[IDI_Community].[crim_victimisation_events].[victimisation_events_YYYYMM]
SAS: libname cmve dsn=IDI_community_srvprd schema=crim_victimisation_events; run ;
How to access a code module in the Data Lab:Read here
Purpose
The purpose of this code module is to construct Victimisation events experienced by individuals in New Zealand. These events can be used to produce estimated counts of people who are victimised, the date the victimisation occurred, the date the victimisation was reported to Police, the type of victimisation that occurred, and additional event information.
Key Concepts
Recorded Crime Victim Statistics (RCVS) captures victimisations reported to Police that are within the scope of offences classified as victimisations under the Australian and New Zealand Standard Offence Classification (ANZSOC). RCVS data is based on the equivalent Australian standard managed by National Crime Statistics Unit (NCSU) within the Australian Bureau of Statistics (ABS). Data in the RCVS collections comes from a dynamic operational database and changes as Police continue to add new information to their database.
The pre-count victimisations dataset includes all criminal incidents within the reporting period where the offence type, ANZSOC offence group, is within scope. The post-count victimisation dataset is created from the pre-count table with counting rules applied which restrict the post-count victimisation dataset to only include the most serious victimisation (they are order in a hierarchy) that occurred within each ANZSOC division. If an occurrence occurs where someone was the victim of 3 different offences, 2 within the “Assault” division and a third within the “Robbery” division, pre-count victimisation data will have a record of all three offences as victimisations, post-count will have ■■■■■■■■■ of victimisation – one for the more serious assault offence and one for the robbery offence.
Victimisations are restricted to specific ANZSOC groups within ANZSOC Divisions 01, 02, 03, 05, 06, 07 and 08. Divisions 01-06 are offences against the person, while divisions 07 and 08 are offences against property. See section 3.9 of the RCVS User Guide for details.
Note: Other ANZSOC groups are excluded from RCVS because of difficulties identifying who is a victim and recording them. Some offences do not require a victim to exist and the offender is strictly liable based on their behaviour. E.g. Offensive language or behaviour, Possession and use type offences, Driving while intoxicated.
This victimisation events code module can be supplemented by researchers with additional administrative and survey data available in the IDI for a more complete picture of incidents that indicate that a victimisation occurred.
References & Contacts
- Data and statistics user guides (November 2016), New Zealand Police.
- Recorded Crime - Victims: User Manual v1.2 (November 2016), New Zealand Police. See chapter 2 for definitions if a number of terms used, such as “criminal incident”, “victimisation”, “offence”. It may help if there was a glossary of these terms and definitions in the documents.
- Data Recording and Quality Assurance (August 2015), New Zealand Police. This is a PDF document that explains Data Recording and Quality Assurance for NZ Police data. It includes a process diagram that explains the “milestones” and process of data collecting and is a summary of the Police “Case Management” process for handling all matters reported to or investigated by NZ Police.
- The transformation of NZ Police crime statistics: New measures and trends (February 2016), New Zealand Police. Some suggested background reading about the history of NZ Police victimisation statistics, and why these only go back to July 2014.
- Australian and New Zealand Standard Offence Classification (ANZSOC), 2011, (2 June 2011), Australian Bureau of Statistics.
- 1234.0.55.001 - National Offence Index, 2009, (23 July 2009) Australian Bureau of Statistics.
- Curtis-Ham, S. (2022). Measuring Harm with Crime Harm Indices. In: Bland, M., Ariel, B., Ridgeon, N. (eds) The Crime Analyst’s Companion. Springer, Cham. (Measuring Harm with Crime Harm Indices | SpringerLink)
- National Recording Standard (March 2025), New Zealand Police.
Development team
| Domain | Agency | Person |
|---|---|---|
| Steward | NZ Police | Ryan Maniago |
| Lead SME | NZ Police | Cameron Dewe |
| Peer review of code | MoJ | Jeremy Wilhelm |
| Contributor | MoJ | Andrew Rae |
| Contributor | NZ Police | Paul Warren |
| Module coder | Nicholson Consulting | Tori Van Loenhout |
Module Business Rules
- Victimisation event definition
Victimisation events include all criminal incidents where the offence type, ANZSOC offence group, is within scope of RCVS offences. Included are victimisations where the outcome of investigation concluded ‘No Crime’. - Creating the post count victimisation flag
The [post_count_victimisation] variable is a binary indicator for if the victimisation event offence is included in the post_count_victimisations dataset, published online, that shows only the most serious victimisation offence that occurred within an RCVS offence type (ANZSOC). - Repeat victim
The [repeat_victim] variable is a binary indicator for if the victim (known person or organisation) has been the victim of a victimisation event on more than one occurrence reported to Police since July 2014 when RCVS was instituted. - Victim type
The [victim_type] variable is a classification variable for if the victim is a:
- Premises: The anzsoc offence division is burglary which indicates that a premises is the ‘victim’ recorded,
- Known person: A positive snz_uid present in the IDI spine population or a positive snz_uid and a nia_links_person_org_ind classification of ‘Person’,
- Unknown person: The RCVS person indicator of 1 and a negative snz_uid or an RCVS person indicator of 1 where none of the above rules and allocations took precedence,
- Organisation: A nia_links_person_org_ind classification of 'Organisation or a RCVS person indicator of 0 and an ANZSOC offence division that could indicate a non-person victim - Robbery and Theft,
- Not Elsewhere Classified: Where none of the above rules were satisfied and an allocation of one of those victim-types could not be ascertained.
Open Issues/Comments
- Police started recording victims in detail in 2013. The victimisations datasets cover only reported victimisations starting in July 2014, victimisations reported before this date are not included due to RCVS being a new statistical collection launched in 2014. Post-March 2018 there is a higher level of data quality. Prior to March 2018 it was possible to record “statistical” offences (known as Case Statistics) to compliment the “core” offences recorded in NIA. These offence records were a legacy from the Law Enforcement System and were originally designed to be anonymous to meet the requirements of the privacy legislation of the time. In compiling RCVS data, an attempt has been made to statistically match and reconcile these Case Statistics with the core offences recorded in NIA. Negative values in the data indicate situations where this reconciliation has not been successful.
- There is a high number of records with missing demographic information in victimisations source data due to some victimisation offence types being assigned to organisations or locations rather than people for offenses such as theft or robbery. For burglary, the premises is counted as the victim as burglary targets property rather than people and for simplicity of data collection. In some cases, victims have not been recorded in the source data. These can be recognised in the raw data where the unique person id is negative. This is more prevalent in more recent data as older data has had time for investigations to fill in this knowledge and therefore data gaps.
- While age is not a variable included in this output dataset, victimisations data uses an estimation of age based on date of birth. Police do not always verify the date of birth for victims (where age of victim is not relevant) against an ID. Therefore, researchers using this module should source personal details about victims, such as age, ethnicity, sex/gender, from other data sources in the IDI such as the Census or the personal_details dataset.
- While not included in this code module, the variable Relationship of Offender to Victim is only populated if an offender has been apprehended for the victimising offence - Outcome of Investigation 3xx. Police need to take formal action against the offender concerned for the Relationship of Offender to Victim to be meaningful. The relationship to a suspect is not reported even if known in cases of “family harm”. Futher to this victims may be less likely to co-operate with Police in instances of “family harm” if this would result in Police taking action against an intimate partner or close relative of the victim. Measures of victimisations may under-estimate the degree of “family harm” involved, as a result. Measures of “family harm” that do not depend on relationship between an offender and victim may give higher levels of “family harm” involvement.
- The victimisations data only counts victimsations reported to Police, based on the date on which a report is made to Police. In some instances victimisations can be reported months or years after the victimisation actually occurred. Victims may sometimes also be uncertain of the dates when crimes have occurred, so a date range is provided. New Zealand Crime Victims Surveys conducted by the Ministry of Justice indicate some types of crime are significantly under-reported to Police.
Parameters
The following parameters should be supplied to this module to run it in the database:
- {targetdb}: The SQL database on which the spell datasets are to be created.
- {idicleanversion}: The IDI Clean version that the spell datasets need to be based on.
- {targetschema}: The project schema under the target database into which the spell datasets are to be created.
Dependencies
1. [$(idicleanversion)].[pol_clean].[pre_count_victimisations]
2. [$(idicleanversion)].[pol_clean].[post_count_victimisations]
3. [$(idicleanversion)].[security].[spine_population]
4. [$(idicleanversion)].[pol_clean].[nia_links]
Outputs
{outputs}{targetdb}.{targetschema}.[victimisation_events]
Variable Descriptions
The business key of the output dataset is a unique record per snz_uid, occurrence_id and offence_id.
| Aspect | Column name | Description |
|---|---|---|
| Entity | snz_uid | The unique STATSNZ person identifier for the individual. |
| occurrence_id | The unique occurrence identifier for each occurrence. | |
| offence_id | The unique offence occurrence identifier as there can be multiple offences per occurrence. | |
| snz_idi_address_register_uid | The unique location identifier for each occurrence derived sourced from NIA (the core Police crime recording system) links. | |
| Period | reported_date | The year and month the victimisation was reported to Police. |
| earliest_occurrence_date | The year and month of the earliest possible date the victimisation occurred. | |
| latest_occurrence_date | The year and month of the latest possible date the victimisation occurred. | |
| Event Information | post_count_victimisation | A binary indicator for if the offence is included in the post-count victimisations dataset as the most serious offence in the ANZSOC division for the victim and occurrence. |
| repeat_victim | A binary indicator for if the victim has been repeatedly victimised over multiple occurrences. | |
| occurrence_investigated | A binary indicator for if the occurrence has been investigated by Police. | |
| offence_investigated | A binary indicator for if the offence has been investigated by Police. | |
| anzsoc_offence_division | Anzoc_offence_code at the division classification level. | |
| anzsoc_offence_subdivision | Anzoc_offence_code at the sub-division classification level. | |
| anzsoc_offence_group | Anzoc_offence_code at the group classification level. | |
| offence_code | The offence code. | |
| location_type_code | Location code for occurrence. | |
| location_type_division | Classification type for location of occurrence e.g. Residential, Community etc. | |
| victim_type | Classification type for victim derived from the spine_population, rcvs, and nia links datasets. | |
| meshblock_code | Geographical unit that can be used with concordance table to get all geographical information for victimisation. | |
| crime_harm_index | A measure of relative harm from crime attributed to each offence code. |
Module Version & Change History
| Date | Version | Comments |
|---|---|---|
| March 2025 | Initial | Version based on specifications from Commissioning document. |
Code
:setvar targetdb "{targetdb}"
:setvar targetschema "{targetschema}"
:setvar idicleanversion "{idicleanversion}"
DROP TABLE IF EXISTS #chi_v7_3;
CREATE TABLE #chi_v7_3(
offence_code CHAR(4) NOT NULL
, crime_harm_index DECIMAL(20,10) NOT NULL
PRIMARY KEY CLUSTERED(
offence_code
)
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1111'
, 5337
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1112'
, 5337
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1113'
, 5337
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1116'
, 5337
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1119'
, 5337
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1121'
, 1890.7
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1122'
, 2023.9
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1123'
, 995.11
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1124'
, 1620.6
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1129'
, 1633.92
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1131'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1132'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1133'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1134'
, 1024.16
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1135'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1136'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1137'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1138'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1139'
, 811.41
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1141'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1142'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1143'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1144'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1149'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1151'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1161'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1162'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1169'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1199'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1211'
, 347.125
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1212'
, 263.125
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1219'
, 224
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1221'
, 193.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1229'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1299'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1311'
, 744.24
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1312'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1313'
, 225
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1314'
, 332.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1315'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1316'
, 157.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1317'
, 180
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1318'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1319'
, 210
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1321'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1322'
, 120
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1323'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1329'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1331'
, 180
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1332'
, 253
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1333'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1334'
, 253.125
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1335'
, 253
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1336'
, 452.04
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1339'
, 164.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1341'
, 180
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1342'
, 180
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1343'
, 180
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1344'
, 180
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1345'
, 180
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1349'
, 180
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1361'
, 240
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1411'
, 673.4
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1412'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1413'
, 427.55
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1414'
, 182.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1415'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1416'
, 108.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1417'
, 617.9
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1418'
, 60
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1419'
, 151.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1421'
, 138.6405367
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1422'
, 216.125
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1423'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1424'
, 68.125
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1425'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1426'
, 75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1427'
, 162
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1428'
, 60
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1429'
, 54
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1431'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1432'
, 825.655
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1433'
, 291
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1434'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1435'
, 156.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1436'
, 147
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1437'
, 673.4
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1438'
, 195
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1439'
, 273.875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1461'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1462'
, 24.9375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1463'
, 18.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1464'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1469'
, 18.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1475'
, 75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1479'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1481'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1482'
, 595.18
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1483'
, 199.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1489'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1491'
, 44.4
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1492'
, 25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1493'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1494'
, 30
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1498'
, 60
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1499'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1511'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1512'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1513'
, 30
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1514'
, 74
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1519'
, 39
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1521'
, 55.69491525
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1522'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1523'
, 21.875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1524'
, 23.625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1529'
, 30
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1531'
, 21.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1532'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1533'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1534'
, 10.9375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1539'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1541'
, 82.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1542'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1543'
, 11.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1544'
, 16.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1545'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1549'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1551'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1552'
, 14.875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1553'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1554'
, 6.875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1559'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1561'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1562'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1563'
, 6.625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1564'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1569'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1571'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1572'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1573'
, 13.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1574'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1579'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1581'
, 14.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1582'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1583'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1584'
, 13
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1585'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1586'
, 9.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1587'
, 9.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1588'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1589'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1591'
, 10.625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1592'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1593'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1594'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1599'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1611'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1612'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1613'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1614'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1615'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1616'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1619'
, 5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1621'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1622'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1623'
, 9.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1624'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1629'
, 9
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1631'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1632'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1633'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1634'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1639'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1641'
, 6
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1642'
, 6.96875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1643'
, 5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1644'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1645'
, 12
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1646'
, 9.125
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1647'
, 9.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1648'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1649'
, 5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1651'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1652'
, 5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1653'
, 5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1654'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1659'
, 5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1699'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1741'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1742'
, 75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1743'
, 60
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1744'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1745'
, 60
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1746'
, 60
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1747'
, 84
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1748'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'1749'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2111'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2112'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2113'
, 1674.62
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2114'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2115'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2116'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2119'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2121'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2122'
, 810.3
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2123'
, 810.3
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2129'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2131'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2132'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2139'
, 970.14
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2141'
, 210
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2142'
, 150
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2143'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2144'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2145'
, 342.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2146'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2147'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2148'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2149'
, 128.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2151'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2152'
, 832.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2153'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2154'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2155'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2156'
, 701.335
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2157'
, 1190.66
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2158'
, 1190.66
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2159'
, 965.7
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2161'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2162'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2163'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2164'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2165'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2166'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2167'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2168'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2169'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2171'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2172'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2173'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2179'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2191'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2192'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2193'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2194'
, 810.3
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2195'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2196'
, 1851.76
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2197'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2199'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2231'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2232'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2311'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2312'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2313'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2319'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2322'
, 1024.16
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2324'
, 794.24
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2326'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2327'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2328'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2329'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2359'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2369'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2379'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2389'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2399'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2411'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2412'
, 244.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2413'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2414'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2419'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2421'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2422'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2423'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2424'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2429'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2431'
, 1080.4
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2432'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2433'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2434'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2435'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2439'
, 128.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2441'
, 584.6
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2442'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2443'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2444'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2445'
, 1206.015
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2446'
, 1206.015
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2449'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2451'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2452'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2453'
, 1206.015
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2454'
, 810.3
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2459'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2611'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2612'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2613'
, 30
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2614'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2619'
, 970.14
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2621'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2622'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2623'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2624'
, 383.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2625'
, 1081.36
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2626'
, 240
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2627'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2628'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2629'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2631'
, 210
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2632'
, 150
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2633'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2634'
, 233.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2635'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2636'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2637'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2639'
, 128.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2641'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2642'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2643'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2644'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2645'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2646'
, 1213.6
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2649'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2651'
, 1483.7
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2652'
, 1498.13
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2653'
, 1505.9
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2654'
, 1147.925
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2655'
, 899.1
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2656'
, 911.31
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2657'
, 653.42
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2658'
, 1190.66
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2659'
, 965.7
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2661'
, 810.3
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2662'
, 1080.4
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2663'
, 673.4
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2664'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2665'
, 543.85
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2666'
, 326
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2667'
, 687.09
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2668'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2669'
, 810.3
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2671'
, 1012.875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2672'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2673'
, 693.935
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2674'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2675'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2676'
, 272.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2677'
, 322.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2678'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2679'
, 277.125
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2681'
, 272.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2682'
, 272.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2683'
, 272.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2684'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2685'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2686'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2689'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2691'
, 1851.76
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2692'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2693'
, 899.1
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2694'
, 911.31
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2695'
, 653.42
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2696'
, 543.85
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2697'
, 326
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2698'
, 687.09
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2699'
, 180
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2711'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2712'
, 467.8
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2713'
, 140.875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2714'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2715'
, 128.4
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2716'
, 79.425
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2719'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2731'
, 330
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2732'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2733'
, 169.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2811'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2812'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2813'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2814'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2815'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2816'
, 271.875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2817'
, 210
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2819'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2821'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2822'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2823'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2824'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2825'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2826'
, 268
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2827'
, 355.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2829'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2831'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2832'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2833'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2839'
, 128.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2841'
, 237.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2842'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2843'
, 330
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2844'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2845'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2846'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2847'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2848'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2849'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2851'
, 594.71
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2852'
, 270
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2853'
, 185.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2861'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2862'
, 180
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2863'
, 193.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2864'
, 272.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2869'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2871'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2872'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2873'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2874'
, 629
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2875'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2879'
, 182.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'2951'
, 354.015
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'3834'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'3863'
, 221.375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4111'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4112'
, 60
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4113'
, 60
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4114'
, 265
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4115'
, 73.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4116'
, 10.875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4119'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4121'
, 75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4122'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4123'
, 25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4124'
, 60
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4125'
, 30
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4126'
, 20
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4127'
, 120
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4128'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4129'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4135'
, 90
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4139'
, 109
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4141'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4149'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4151'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4152'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4153'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4154'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4155'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4156'
, 240
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4157'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4158'
, 224.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4159'
, 69
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4199'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4211'
, 18.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4212'
, 10.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4213'
, 11.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4214'
, 10.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4215'
, 16.15625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4219'
, 18.1875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4223'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4229'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4231'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4232'
, 12
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4233'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4239'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4249'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4311'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4312'
, 26
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4313'
, 14.3559322
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4319'
, 30
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4321'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4322'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4323'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4324'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4329'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4331'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4332'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4333'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4334'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4335'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4336'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4337'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4338'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4339'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4341'
, 30
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4342'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4343'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4344'
, 30
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4349'
, 5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4351'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4352'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4353'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4354'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4359'
, 11.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4361'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4362'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4363'
, 7.6875
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4364'
, 14.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4369'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4371'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4372'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4373'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4374'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4375'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4376'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4377'
, 20
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4378'
, 33
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4379'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4384'
, 1080.4
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4385'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4387'
, 11.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4388'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4391'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4392'
, 5.162429379
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4393'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4394'
, 6.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4398'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4399'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4611'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4612'
, 60
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4613'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4614'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4615'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4616'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4619'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4621'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4622'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4623'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4624'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4625'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4626'
, 37.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4629'
, 45
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4711'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4712'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4713'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4719'
, 30
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4721'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4722'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4729'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4731'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4732'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4733'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4734'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4735'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4736'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4737'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4738'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4739'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4741'
, 30
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4742'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4749'
, 14.55
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4751'
, 15
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4752'
, 10
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4759'
, 11.75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4761'
, 14.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4762'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4769'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4771'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4772'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4773'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4774'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4775'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'4779'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'7117'
, 10.4375
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'7543'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8114'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8115'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8116'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8118'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8122'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8125'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8126'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8211'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8213'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8912'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'8914'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A105'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A106'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A108'
, 275.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A111'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A113'
, 75
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A304'
, 300
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A335'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A340'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A407'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A409'
, 449.63
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A410'
, 449.63
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A412'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A433'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A436'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A532'
, 848.78
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A533'
, 848.78
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A605'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A606'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A608'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A611'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A615'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A642'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A645'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A654'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A656'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A658'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A668'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A669'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A671'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A728'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A730'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A732'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A734'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A749'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A858'
, 449.63
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A860'
, 449.63
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A862'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A864'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A866'
, 449.63
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A868'
, 449.63
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'A870'
, 449.63
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'B143'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'B150'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'B155'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'B165'
, 6.25
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'B168'
, 365
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'B169'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'B176'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'B177'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'B179'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D103'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D105'
, 611.24
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D203'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D207'
, 240
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D303'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D362'
, 555.12
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D364'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D366'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D368'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D372'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D374'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D504'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D506'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D508'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D510'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D516'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D517'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D518'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D519'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D521'
, 15.65625
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D524'
, 12.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'D525'
, 51
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'K189'
, 1.059322034
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'K272'
, 7.5
);
INSERT INTO #chi_v7_3(
offence_code
, crime_harm_index
)
VALUES(
'M315'
, 7.5
);
DROP TABLE IF EXISTS #temp_victimisations;
SELECT pre.[snz_uid]
, sp.snz_spine_uid
, pre.[snz_pol_occurrence_uid] AS occurrence_id
, pre.[snz_pol_offence_uid] AS offence_id
, nl.[snz_idi_address_register_uid]
, ISNULL(pst.[pol_pov_reported_date],pre.[pol_prv_reported_date]) AS reported_date
, ISNULL(pst.[pol_pov_earliest_occ_start_date],pre.[pol_prv_earliest_occ_start_date]) AS earliest_occurrence_date
, ISNULL(pst.[pol_pov_latest_poss_occ_date],pre.[pol_prv_latest_poss_occ_date]) AS latest_occurrence_date
, CASE WHEN pst.snz_pol_offence_uid IS NOT NULL THEN 1 ELSE 0 END AS post_count_victimisation
, CASE WHEN rv.snz_uid IS NOT NULL THEN 1 ELSE 0 END AS repeat_victim
, ISNULL(pst.[pol_pov_occurrence_inv_ind],pre.[pol_prv_occurrence_inv_ind]) AS occurrence_investigated
, ISNULL(pst.[pol_pov_offence_inv_ind],pre.[pol_prv_offence_inv_ind]) AS offence_investigated
, ISNULL(pst.[pol_pov_anzsoc_offence_code],pre.[pol_prv_anzsoc_offence_code]) AS anzsoc_offence_code
, ISNULL(pst.[pol_pov_offence_code],pre.[pol_prv_offence_code]) AS offence_code
, ISNULL(pst.[pol_pov_location_code],pre.[pol_prv_location_code]) AS location_type_code
, CASE WHEN ISNULL(LEFT(pst.[pol_pov_location_code],1),LEFT(pre.[pol_prv_location_code],1)) = '1' THEN 'Residential location'
WHEN ISNULL(LEFT(pst.[pol_pov_location_code],1),LEFT(pre.[pol_prv_location_code],1)) = '2' THEN 'Community location'
WHEN ISNULL(LEFT(pst.[pol_pov_location_code],1),LEFT(pre.[pol_prv_location_code],1)) = '3' THEN 'Other location'
WHEN ISNULL(LEFT(pst.[pol_pov_location_code],1),LEFT(pre.[pol_prv_location_code],1)) = '4' THEN 'Unspecified location'
WHEN ISNULL(LEFT(pst.[pol_pov_location_code],1),LEFT(pre.[pol_prv_location_code],1)) = '5' THEN 'NOT applicable'
ELSE ISNULL(LEFT(pst.[pol_pov_location_code],1),LEFT(pre.[pol_prv_location_code],1)) END AS location_type_division
, [nia_links_person_org_ind]
, ISNULL(pst.[snz_person_ind],pre.[snz_person_ind]) AS person_ind
, ISNULL(pst.[pol_pov_meshblock_code],pre.[pol_prv_meshblock_code]) AS meshblock_code
, [crime_harm_index]
INTO #temp_victimisations
FROM [$(idicleanversion)].[pol_clean].[pre_count_victimisations] pre
LEFT JOIN [$(idicleanversion)].[pol_clean].[post_count_victimisations] pst
ON pre.snz_uid = pst.snz_uid
AND pre.snz_pol_occurrence_uid = pst.snz_pol_occurrence_uid
AND pre.snz_pol_offence_uid = pst.snz_pol_offence_uid
AND pre.pol_prv_offence_code = pst.pol_pov_offence_code
AND pre.pol_prv_reported_date = pst.pol_pov_reported_date
LEFT JOIN [$(idicleanversion)].[security].[spine_population] sp
ON pre.snz_uid = sp.snz_spine_uid
LEFT JOIN(
SELECT *
FROM [$(idicleanversion)].[pol_clean].[nia_links]
WHERE snz_idi_address_register_uid IS NOT NULL
)nl
ON pre.snz_uid = nl.snz_uid
AND pre.snz_pol_occurrence_uid = nl.snz_pol_occurrence_uid
AND pre.snz_pol_offence_uid = nl.snz_pol_offence_uid
AND pre.pol_prv_meshblock_code = nl.nia_links_meshblock_code
LEFT JOIN(
SELECT DISTINCT snz_uid
, COUNT(DISTINCT(snz_pol_occurrence_uid)) AS n_occurrences
FROM [$(idicleanversion)].[pol_clean].[post_count_victimisations]
WHERE ■■■■■■■■■■■■
GROUP BY snz_uid
HAVING COUNT(DISTINCT(snz_pol_occurrence_uid)) > 1
)rv
ON pre.snz_uid = rv.snz_uid
LEFT JOIN #chi_v7_3 chi
ON pre.pol_prv_offence_code = chi.offence_code ;
DROP TABLE IF EXISTS [$(targetdb)].[$(targetschema)].[victimisation_events];
SELECT snz_uid
, occurrence_id
, offence_id
, snz_idi_address_register_uid
, reported_date = YEAR(reported_date) * 100 + MONTH(reported_date)
, earliest_occurrence_date = YEAR(earliest_occurrence_date) * 100 + MONTH(earliest_occurrence_date)
, latest_occurrence_date = YEAR(latest_occurrence_date) * 100 + MONTH(latest_occurrence_date)
, post_count_victimisation
, repeat_victim
, occurrence_investigated
, offence_investigated
, LEFT(anzsoc_offence_code,2) AS anzsoc_offence_division
, LEFT(anzsoc_offence_code,3) AS anzsoc_offence_subdivision
, LEFT(anzsoc_offence_code,4) AS anzsoc_offence_group
, offence_code
, location_type_code
, location_type_division
, CASE WHEN LEFT([anzsoc_offence_code],2) = '07' THEN 'Premises'
WHEN [snz_uid] = [snz_spine_uid] AND [snz_uid] >= 0 THEN 'Known Person'
WHEN [nia_links_person_org_ind] = 'P' AND ■■■■■■■■■■■■ THEN 'Known Person'
WHEN [person_ind] = 1 AND [snz_uid] < 0 THEN 'Unknown Person'
WHEN [person_ind] = 1 THEN 'Unknown Person'
WHEN [nia_links_person_org_ind] = 'O' THEN 'Organisation'
WHEN LEFT([anzsoc_offence_code],2) IN ('06','08') AND [person_ind] = 0 THEN 'Organisation'
ELSE 'NOT Elsewhere Classified' END AS [victim_type]
, meshblock_code
, [crime_harm_index]
INTO [$(targetdb)].[$(targetschema)].[victimisation_events]
FROM #temp_victimisations
;