In [5]:
import pandas as pd
In [45]:
crime_d = pd.read_csv(open('./crime_data.csv'), quotechar='"', skipinitialspace=True, header=1)
crime_d
Out[45]:
Year and Month
ANZSOC Division
ANZSOC Subdivision
ANZSOC Group
Age Group (5yr band)
Sex
Police District
Police Area
Outcome of Investigation (5)
Location
Victimisations
0
2017/02
Acts Intended to Cause Injury
Assault
Common Assault
25 - 29 years inclusive
Female
Southern
Otago Coastal Area
Court action
Not Applicable
1
1
2017/02
Acts Intended to Cause Injury
Assault
Common Assault
10 - 14 years inclusive
Female
Central
Taranaki Area
Investigation continuing
Not Applicable
2
2
2017/02
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
65 - 69 years inclusive
Male
Counties/Manukau
Counties Manukau South Area
Investigation continuing
Not Applicable
1
3
2017/02
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
45 - 49 years inclusive
Female
Wellington
Kapiti-Mana Area
Investigation pending
Not Applicable
1
4
2017/02
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Theft of Motor Vehicle Parts or Contents
15 - 19 years inclusive
Male
Counties/Manukau
Counties Manukau East Area
Investigation pending
Not Applicable
1
5
2017/02
Theft and Related Offences
Theft (Except Motor Vehicles)
Theft (Except Motor Vehicles), N.E.C.
50 - 54 years inclusive
Female
Tasman
Marlborough Area
Investigation pending
Not Applicable
1
6
2017/02
Theft and Related Offences
Theft (Except Motor Vehicles)
Theft (Except Motor Vehicles), N.E.C.
70 - 74 years inclusive
Female
Wellington
Hutt Valley Area
Investigation pending
Not Applicable
1
7
2017/02
Sexual Assault and Related Offences
Sexual Assault
Aggravated Sexual Assault
10 - 14 years inclusive
Female
Wellington
Hutt Valley Area
Court action
Not Applicable
1
8
2017/02
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
50 - 54 years inclusive
Male
Tasman
West Coast Area
Investigation continuing
Not Applicable
1
9
2017/02
Acts Intended to Cause Injury
Assault
Common Assault
45 - 49 years inclusive
Female
Counties/Manukau
Counties Manukau West Area
Investigation continuing
Not Applicable
2
10
2017/02
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
45 - 49 years inclusive
Female
Wellington
Wellington Area
Investigation continuing
Not Applicable
2
11
2017/02
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
50 - 54 years inclusive
Male
Counties/Manukau
Counties Manukau East Area
Investigation continuing
Not Applicable
2
12
2017/02
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
15 - 19 years inclusive
Male
Wellington
Kapiti-Mana Area
Investigation pending
Not Applicable
1
13
2017/02
Robbery, Extortion and Related Offences
Robbery
Aggravated Robbery
Not Specified
Not Stated
Wellington
Wellington Area
Investigation continuing
Not Applicable
1
14
2017/02
Acts Intended to Cause Injury
Assault
Common Assault
20 - 24 years inclusive
Male
Wellington
Kapiti-Mana Area
Investigation pending
Not Applicable
2
15
2017/02
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
35 - 39 years inclusive
Male
Bay Of Plenty
Taupo Area
Investigation continuing
Not Applicable
2
16
2017/02
Acts Intended to Cause Injury
Assault
Common Assault
15 - 19 years inclusive
Male
Northland
Whangarei Area
No offender proceeded against
Not Applicable
1
17
2017/02
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Theft of Motor Vehicle Parts or Contents
20 - 24 years inclusive
Male
Tasman
Nelson Bays Area
Investigation pending
Not Applicable
1
18
2017/02
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
80 years or over
Female
Wellington
Hutt Valley Area
Court action
Not Applicable
1
19
2017/02
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
20 - 24 years inclusive
Female
Counties/Manukau
Counties Manukau East Area
No offender proceeded against
Not Applicable
2
20
2017/02
Theft and Related Offences
Theft (Except Motor Vehicles)
Theft (Except Motor Vehicles), N.E.C.
45 - 49 years inclusive
Female
Auckland City
Auckland Central Area
Investigation continuing
Not Applicable
1
21
2017/02
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
45 - 49 years inclusive
Female
Counties/Manukau
Counties Manukau West Area
Court action
Not Applicable
1
22
2017/02
Acts Intended to Cause Injury
Assault
Common Assault
45 - 49 years inclusive
Male
Southern
Southland Area
Investigation pending
Not Applicable
1
23
2017/02
Theft and Related Offences
Theft (Except Motor Vehicles)
Theft (Except Motor Vehicles), N.E.C.
30 - 34 years inclusive
Female
Eastern
Hawkes Bay Area
Investigation continuing
Not Applicable
2
24
2017/02
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Theft of Motor Vehicle Parts or Contents
50 - 54 years inclusive
Female
Auckland City
Auckland East Area
Investigation continuing
Not Applicable
2
25
2017/02
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
30 - 34 years inclusive
Male
Canterbury
Canterbury Metro Area
Court action
Not Applicable
1
26
2017/02
Theft and Related Offences
Theft (Except Motor Vehicles)
Theft (Except Motor Vehicles), N.E.C.
40 - 44 years inclusive
Male
Counties/Manukau
Counties Manukau West Area
Investigation continuing
Not Applicable
1
27
2017/02
Theft and Related Offences
Illegal Use of Property (Except Motor Vehicles)
Illegal Use of Property (Except Motor Vehicles)
40 - 44 years inclusive
Male
Canterbury
Canterbury Metro Area
Investigation pending
Not Applicable
3
28
2017/02
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
10 - 14 years inclusive
Male
Bay Of Plenty
Western Bay Of Plenty Area
Investigation continuing
Not Applicable
1
29
2017/02
Acts Intended to Cause Injury
Assault
Common Assault
15 - 19 years inclusive
Male
Waitemata
North Shore Area
Investigation continuing
Not Applicable
5
...
...
...
...
...
...
...
...
...
...
...
...
28691
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Female
Counties/Manukau
Counties Manukau Central Area
Non-court action, n.f.d.
Not Applicable
1
28692
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
0 - 4 years inclusive
Female
Counties/Manukau
Counties Manukau Central Area
Investigation continuing
Not Applicable
1
28693
2017/05
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
Not Specified
Not Stated
Wellington
Hutt Valley Area
No crime
Not Applicable
3
28694
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Female
Central
Whanganui Area
Investigation continuing
Not Applicable
1
28695
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Male
Central
Taranaki Area
Investigation pending
Not Applicable
1
28696
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
0 - 4 years inclusive
Male
Central
Taranaki Area
Investigation continuing
Not Applicable
1
28697
2017/05
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
Not Specified
Not Stated
Wellington
Kapiti-Mana Area
Investigation continuing
Not Applicable
2
28698
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Female
Central
Taranaki Area
Investigation pending
Not Applicable
1
28699
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Male
Central
Manawatu Area
Investigation continuing
Not Applicable
1
28700
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
0 - 4 years inclusive
Male
Central
Manawatu Area
Court action
Not Applicable
1
28701
2017/05
Theft and Related Offences
Theft (Except Motor Vehicles)
Theft (Except Motor Vehicles), N.E.C.
Not Specified
Not Stated
Wellington
Kapiti-Mana Area
Investigation pending
Not Applicable
1
28702
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Female
Canterbury
Canterbury Metro Area
Investigation pending
Not Applicable
1
28703
2017/05
Sexual Assault and Related Offences
Sexual Assault
Aggravated Sexual Assault
0 - 4 years inclusive
Female
Bay Of Plenty
Western Bay Of Plenty Area
Investigation continuing
Not Applicable
2
28704
2017/05
Sexual Assault and Related Offences
Sexual Assault
Aggravated Sexual Assault
0 - 4 years inclusive
Female
Bay Of Plenty
Eastern Bay Of Plenty Area
Investigation continuing
Not Applicable
1
28705
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Male
Bay Of Plenty
Western Bay Of Plenty Area
Investigation pending
Not Applicable
2
28706
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
0 - 4 years inclusive
Female
Bay Of Plenty
Western Bay Of Plenty Area
Investigation pending
Not Applicable
2
28707
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
0 - 4 years inclusive
Male
Bay Of Plenty
Taupo Area
Investigation continuing
Not Applicable
1
28708
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Male
Bay Of Plenty
Taupo Area
Investigation continuing
Not Applicable
1
28709
2017/05
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
Not Specified
Not Stated
Wellington
Wellington Area
Court action
Not Applicable
1
28710
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Male
Bay Of Plenty
Rotorua Area
Investigation pending
Not Applicable
1
28711
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
0 - 4 years inclusive
Male
Bay Of Plenty
Rotorua Area
Investigation continuing
Not Applicable
1
28712
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
0 - 4 years inclusive
Male
Bay Of Plenty
Rotorua Area
Court action
Not Applicable
2
28713
2017/05
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Illegal Use of a Motor Vehicle
Not Specified
Not Stated
Wellington
Wellington Area
Investigation pending
Not Applicable
8
28714
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
0 - 4 years inclusive
Female
Bay Of Plenty
Rotorua Area
Court action
Not Applicable
2
28715
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Male
Bay Of Plenty
Eastern Bay Of Plenty Area
Investigation continuing
Not Applicable
1
28716
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Resulting in Injury
0 - 4 years inclusive
Female
Bay Of Plenty
Eastern Bay Of Plenty Area
Investigation continuing
Not Applicable
1
28717
2017/05
Theft and Related Offences
Motor Vehicle Theft and Related Offences
Theft of Motor Vehicle Parts or Contents
Not Specified
Not Stated
Wellington
Wellington Area
No crime
Not Applicable
1
28718
2017/05
Sexual Assault and Related Offences
Sexual Assault
Aggravated Sexual Assault
0 - 4 years inclusive
Female
Auckland City
Auckland West Area
Investigation continuing
Not Applicable
1
28719
2017/05
Sexual Assault and Related Offences
Sexual Assault
Aggravated Sexual Assault
0 - 4 years inclusive
Male
Auckland City
Auckland East Area
Investigation continuing
Not Applicable
1
28720
2017/05
Acts Intended to Cause Injury
Assault
Serious Assault Not Resulting in Injury
0 - 4 years inclusive
Female
Auckland City
Auckland West Area
Court action
Not Applicable
1
28721 rows × 11 columns
In [46]:
d2 = crime_d.groupby(['Police Area', 'ANZSOC Subdivision'])
d2.Victimisations.count()
Out[46]:
Police Area ANZSOC Subdivision
Auckland Central Area Abduction and Kidnapping 3
Assault 288
Blackmail and Extortion 4
Illegal Use of Property (Except Motor Vehicles) 85
Motor Vehicle Theft and Related Offences 267
Robbery 38
Sexual Assault 61
Theft (Except Motor Vehicles) 274
Auckland East Area Abduction and Kidnapping 4
Assault 257
Blackmail and Extortion 8
Illegal Use of Property (Except Motor Vehicles) 56
Motor Vehicle Theft and Related Offences 369
Robbery 51
Sexual Assault 44
Theft (Except Motor Vehicles) 241
Auckland Motorways Area Motor Vehicle Theft and Related Offences 2
Robbery 1
Theft (Except Motor Vehicles) 1
Auckland West Area Abduction and Kidnapping 6
Assault 241
Blackmail and Extortion 7
Illegal Use of Property (Except Motor Vehicles) 33
Motor Vehicle Theft and Related Offences 339
Robbery 46
Sexual Assault 52
Theft (Except Motor Vehicles) 204
Canterbury Metro Area Abduction and Kidnapping 11
Assault 542
Blackmail and Extortion 8
...
West Coast Area Abduction and Kidnapping 1
Assault 97
Illegal Use of Property (Except Motor Vehicles) 3
Motor Vehicle Theft and Related Offences 64
Robbery 1
Sexual Assault 15
Theft (Except Motor Vehicles) 62
Western Bay Of Plenty Area Abduction and Kidnapping 3
Assault 333
Blackmail and Extortion 1
Illegal Use of Property (Except Motor Vehicles) 50
Motor Vehicle Theft and Related Offences 272
Robbery 23
Sexual Assault 58
Theft (Except Motor Vehicles) 226
Whanganui Area Abduction and Kidnapping 2
Assault 214
Blackmail and Extortion 1
Illegal Use of Property (Except Motor Vehicles) 24
Motor Vehicle Theft and Related Offences 134
Robbery 12
Sexual Assault 24
Theft (Except Motor Vehicles) 129
Whangarei Area Abduction and Kidnapping 6
Assault 251
Illegal Use of Property (Except Motor Vehicles) 13
Motor Vehicle Theft and Related Offences 254
Robbery 40
Sexual Assault 36
Theft (Except Motor Vehicles) 167
Name: Victimisations, Length: 275, dtype: int64
In [47]:
# Find all the crimetypes
for key in d2.Victimisations.count().items():
print(key)
(('Auckland Central Area', 'Abduction and Kidnapping'), 3)
(('Auckland Central Area', 'Assault'), 288)
(('Auckland Central Area', 'Blackmail and Extortion'), 4)
(('Auckland Central Area', 'Illegal Use of Property (Except Motor Vehicles)'), 85)
(('Auckland Central Area', 'Motor Vehicle Theft and Related Offences'), 267)
(('Auckland Central Area', 'Robbery'), 38)
(('Auckland Central Area', 'Sexual Assault'), 61)
(('Auckland Central Area', 'Theft (Except Motor Vehicles)'), 274)
(('Auckland East Area', 'Abduction and Kidnapping'), 4)
(('Auckland East Area', 'Assault'), 257)
(('Auckland East Area', 'Blackmail and Extortion'), 8)
(('Auckland East Area', 'Illegal Use of Property (Except Motor Vehicles)'), 56)
(('Auckland East Area', 'Motor Vehicle Theft and Related Offences'), 369)
(('Auckland East Area', 'Robbery'), 51)
(('Auckland East Area', 'Sexual Assault'), 44)
(('Auckland East Area', 'Theft (Except Motor Vehicles)'), 241)
(('Auckland Motorways Area', 'Motor Vehicle Theft and Related Offences'), 2)
(('Auckland Motorways Area', 'Robbery'), 1)
(('Auckland Motorways Area', 'Theft (Except Motor Vehicles)'), 1)
(('Auckland West Area', 'Abduction and Kidnapping'), 6)
(('Auckland West Area', 'Assault'), 241)
(('Auckland West Area', 'Blackmail and Extortion'), 7)
(('Auckland West Area', 'Illegal Use of Property (Except Motor Vehicles)'), 33)
(('Auckland West Area', 'Motor Vehicle Theft and Related Offences'), 339)
(('Auckland West Area', 'Robbery'), 46)
(('Auckland West Area', 'Sexual Assault'), 52)
(('Auckland West Area', 'Theft (Except Motor Vehicles)'), 204)
(('Canterbury Metro Area', 'Abduction and Kidnapping'), 11)
(('Canterbury Metro Area', 'Assault'), 542)
(('Canterbury Metro Area', 'Blackmail and Extortion'), 8)
(('Canterbury Metro Area', 'Illegal Use of Property (Except Motor Vehicles)'), 99)
(('Canterbury Metro Area', 'Motor Vehicle Theft and Related Offences'), 466)
(('Canterbury Metro Area', 'Robbery'), 75)
(('Canterbury Metro Area', 'Sexual Assault'), 105)
(('Canterbury Metro Area', 'Theft (Except Motor Vehicles)'), 333)
(('Counties Manukau Central Area', 'Abduction and Kidnapping'), 6)
(('Counties Manukau Central Area', 'Assault'), 416)
(('Counties Manukau Central Area', 'Blackmail and Extortion'), 1)
(('Counties Manukau Central Area', 'Illegal Use of Property (Except Motor Vehicles)'), 13)
(('Counties Manukau Central Area', 'Motor Vehicle Theft and Related Offences'), 310)
(('Counties Manukau Central Area', 'Robbery'), 61)
(('Counties Manukau Central Area', 'Sexual Assault'), 38)
(('Counties Manukau Central Area', 'Theft (Except Motor Vehicles)'), 176)
(('Counties Manukau East Area', 'Abduction and Kidnapping'), 1)
(('Counties Manukau East Area', 'Assault'), 380)
(('Counties Manukau East Area', 'Blackmail and Extortion'), 5)
(('Counties Manukau East Area', 'Illegal Use of Property (Except Motor Vehicles)'), 21)
(('Counties Manukau East Area', 'Motor Vehicle Theft and Related Offences'), 292)
(('Counties Manukau East Area', 'Robbery'), 34)
(('Counties Manukau East Area', 'Sexual Assault'), 33)
(('Counties Manukau East Area', 'Theft (Except Motor Vehicles)'), 163)
(('Counties Manukau South Area', 'Abduction and Kidnapping'), 6)
(('Counties Manukau South Area', 'Assault'), 333)
(('Counties Manukau South Area', 'Illegal Use of Property (Except Motor Vehicles)'), 14)
(('Counties Manukau South Area', 'Motor Vehicle Theft and Related Offences'), 312)
(('Counties Manukau South Area', 'Robbery'), 35)
(('Counties Manukau South Area', 'Sexual Assault'), 40)
(('Counties Manukau South Area', 'Theft (Except Motor Vehicles)'), 191)
(('Counties Manukau West Area', 'Abduction and Kidnapping'), 6)
(('Counties Manukau West Area', 'Assault'), 497)
(('Counties Manukau West Area', 'Blackmail and Extortion'), 2)
(('Counties Manukau West Area', 'Illegal Use of Property (Except Motor Vehicles)'), 18)
(('Counties Manukau West Area', 'Motor Vehicle Theft and Related Offences'), 344)
(('Counties Manukau West Area', 'Robbery'), 84)
(('Counties Manukau West Area', 'Sexual Assault'), 39)
(('Counties Manukau West Area', 'Theft (Except Motor Vehicles)'), 224)
(('Eastern Bay Of Plenty Area', 'Abduction and Kidnapping'), 1)
(('Eastern Bay Of Plenty Area', 'Assault'), 173)
(('Eastern Bay Of Plenty Area', 'Illegal Use of Property (Except Motor Vehicles)'), 21)
(('Eastern Bay Of Plenty Area', 'Motor Vehicle Theft and Related Offences'), 127)
(('Eastern Bay Of Plenty Area', 'Robbery'), 8)
(('Eastern Bay Of Plenty Area', 'Sexual Assault'), 20)
(('Eastern Bay Of Plenty Area', 'Theft (Except Motor Vehicles)'), 105)
(('Far North Area', 'Abduction and Kidnapping'), 11)
(('Far North Area', 'Assault'), 200)
(('Far North Area', 'Blackmail and Extortion'), 1)
(('Far North Area', 'Illegal Use of Property (Except Motor Vehicles)'), 11)
(('Far North Area', 'Motor Vehicle Theft and Related Offences'), 206)
(('Far North Area', 'Robbery'), 15)
(('Far North Area', 'Sexual Assault'), 26)
(('Far North Area', 'Theft (Except Motor Vehicles)'), 139)
(('Hamilton City Area', 'Abduction and Kidnapping'), 5)
(('Hamilton City Area', 'Assault'), 490)
(('Hamilton City Area', 'Blackmail and Extortion'), 7)
(('Hamilton City Area', 'Illegal Use of Property (Except Motor Vehicles)'), 90)
(('Hamilton City Area', 'Motor Vehicle Theft and Related Offences'), 347)
(('Hamilton City Area', 'Robbery'), 53)
(('Hamilton City Area', 'Sexual Assault'), 75)
(('Hamilton City Area', 'Theft (Except Motor Vehicles)'), 233)
(('Hawkes Bay Area', 'Abduction and Kidnapping'), 5)
(('Hawkes Bay Area', 'Assault'), 484)
(('Hawkes Bay Area', 'Blackmail and Extortion'), 2)
(('Hawkes Bay Area', 'Illegal Use of Property (Except Motor Vehicles)'), 65)
(('Hawkes Bay Area', 'Motor Vehicle Theft and Related Offences'), 347)
(('Hawkes Bay Area', 'Robbery'), 26)
(('Hawkes Bay Area', 'Sexual Assault'), 74)
(('Hawkes Bay Area', 'Theft (Except Motor Vehicles)'), 269)
(('Hutt Valley Area', 'Abduction and Kidnapping'), 3)
(('Hutt Valley Area', 'Assault'), 365)
(('Hutt Valley Area', 'Illegal Use of Property (Except Motor Vehicles)'), 23)
(('Hutt Valley Area', 'Motor Vehicle Theft and Related Offences'), 300)
(('Hutt Valley Area', 'Robbery'), 10)
(('Hutt Valley Area', 'Sexual Assault'), 42)
(('Hutt Valley Area', 'Theft (Except Motor Vehicles)'), 199)
(('Kapiti-Mana Area', 'Abduction and Kidnapping'), 5)
(('Kapiti-Mana Area', 'Assault'), 319)
(('Kapiti-Mana Area', 'Blackmail and Extortion'), 2)
(('Kapiti-Mana Area', 'Illegal Use of Property (Except Motor Vehicles)'), 13)
(('Kapiti-Mana Area', 'Motor Vehicle Theft and Related Offences'), 224)
(('Kapiti-Mana Area', 'Robbery'), 13)
(('Kapiti-Mana Area', 'Sexual Assault'), 38)
(('Kapiti-Mana Area', 'Theft (Except Motor Vehicles)'), 144)
(('Manawatu Area', 'Abduction and Kidnapping'), 3)
(('Manawatu Area', 'Assault'), 385)
(('Manawatu Area', 'Blackmail and Extortion'), 5)
(('Manawatu Area', 'Illegal Use of Property (Except Motor Vehicles)'), 53)
(('Manawatu Area', 'Motor Vehicle Theft and Related Offences'), 361)
(('Manawatu Area', 'Robbery'), 32)
(('Manawatu Area', 'Sexual Assault'), 73)
(('Manawatu Area', 'Theft (Except Motor Vehicles)'), 232)
(('Marlborough Area', 'Abduction and Kidnapping'), 2)
(('Marlborough Area', 'Assault'), 152)
(('Marlborough Area', 'Illegal Use of Property (Except Motor Vehicles)'), 11)
(('Marlborough Area', 'Motor Vehicle Theft and Related Offences'), 68)
(('Marlborough Area', 'Robbery'), 6)
(('Marlborough Area', 'Sexual Assault'), 18)
(('Marlborough Area', 'Theft (Except Motor Vehicles)'), 96)
(('Mid / South Canterbury Area', 'Assault'), 180)
(('Mid / South Canterbury Area', 'Blackmail and Extortion'), 1)
(('Mid / South Canterbury Area', 'Illegal Use of Property (Except Motor Vehicles)'), 6)
(('Mid / South Canterbury Area', 'Motor Vehicle Theft and Related Offences'), 106)
(('Mid / South Canterbury Area', 'Robbery'), 7)
(('Mid / South Canterbury Area', 'Sexual Assault'), 27)
(('Mid / South Canterbury Area', 'Theft (Except Motor Vehicles)'), 135)
(('Nelson Bays Area', 'Abduction and Kidnapping'), 4)
(('Nelson Bays Area', 'Assault'), 286)
(('Nelson Bays Area', 'Illegal Use of Property (Except Motor Vehicles)'), 49)
(('Nelson Bays Area', 'Motor Vehicle Theft and Related Offences'), 167)
(('Nelson Bays Area', 'Robbery'), 20)
(('Nelson Bays Area', 'Sexual Assault'), 46)
(('Nelson Bays Area', 'Theft (Except Motor Vehicles)'), 150)
(('North Shore Area', 'Abduction and Kidnapping'), 4)
(('North Shore Area', 'Assault'), 264)
(('North Shore Area', 'Blackmail and Extortion'), 6)
(('North Shore Area', 'Illegal Use of Property (Except Motor Vehicles)'), 20)
(('North Shore Area', 'Motor Vehicle Theft and Related Offences'), 278)
(('North Shore Area', 'Robbery'), 23)
(('North Shore Area', 'Sexual Assault'), 41)
(('North Shore Area', 'Theft (Except Motor Vehicles)'), 177)
(('Otago Coastal Area', 'Abduction and Kidnapping'), 3)
(('Otago Coastal Area', 'Assault'), 342)
(('Otago Coastal Area', 'Blackmail and Extortion'), 2)
(('Otago Coastal Area', 'Illegal Use of Property (Except Motor Vehicles)'), 17)
(('Otago Coastal Area', 'Motor Vehicle Theft and Related Offences'), 196)
(('Otago Coastal Area', 'Robbery'), 16)
(('Otago Coastal Area', 'Sexual Assault'), 61)
(('Otago Coastal Area', 'Theft (Except Motor Vehicles)'), 176)
(('Otago Lakes Central Area', 'Assault'), 85)
(('Otago Lakes Central Area', 'Illegal Use of Property (Except Motor Vehicles)'), 4)
(('Otago Lakes Central Area', 'Motor Vehicle Theft and Related Offences'), 43)
(('Otago Lakes Central Area', 'Sexual Assault'), 18)
(('Otago Lakes Central Area', 'Theft (Except Motor Vehicles)'), 90)
(('Rodney Area', 'Abduction and Kidnapping'), 3)
(('Rodney Area', 'Assault'), 127)
(('Rodney Area', 'Blackmail and Extortion'), 1)
(('Rodney Area', 'Illegal Use of Property (Except Motor Vehicles)'), 6)
(('Rodney Area', 'Motor Vehicle Theft and Related Offences'), 186)
(('Rodney Area', 'Robbery'), 11)
(('Rodney Area', 'Sexual Assault'), 21)
(('Rodney Area', 'Theft (Except Motor Vehicles)'), 135)
(('Rotorua Area', 'Abduction and Kidnapping'), 4)
(('Rotorua Area', 'Assault'), 292)
(('Rotorua Area', 'Blackmail and Extortion'), 1)
(('Rotorua Area', 'Illegal Use of Property (Except Motor Vehicles)'), 20)
(('Rotorua Area', 'Motor Vehicle Theft and Related Offences'), 279)
(('Rotorua Area', 'Robbery'), 25)
(('Rotorua Area', 'Sexual Assault'), 37)
(('Rotorua Area', 'Theft (Except Motor Vehicles)'), 200)
(('Southland Area', 'Abduction and Kidnapping'), 3)
(('Southland Area', 'Assault'), 210)
(('Southland Area', 'Blackmail and Extortion'), 2)
(('Southland Area', 'Illegal Use of Property (Except Motor Vehicles)'), 19)
(('Southland Area', 'Motor Vehicle Theft and Related Offences'), 110)
(('Southland Area', 'Robbery'), 5)
(('Southland Area', 'Sexual Assault'), 29)
(('Southland Area', 'Theft (Except Motor Vehicles)'), 148)
(('Tairawhiti Area', 'Abduction and Kidnapping'), 1)
(('Tairawhiti Area', 'Assault'), 341)
(('Tairawhiti Area', 'Illegal Use of Property (Except Motor Vehicles)'), 44)
(('Tairawhiti Area', 'Motor Vehicle Theft and Related Offences'), 178)
(('Tairawhiti Area', 'Robbery'), 14)
(('Tairawhiti Area', 'Sexual Assault'), 27)
(('Tairawhiti Area', 'Theft (Except Motor Vehicles)'), 144)
(('Taranaki Area', 'Abduction and Kidnapping'), 2)
(('Taranaki Area', 'Assault'), 333)
(('Taranaki Area', 'Illegal Use of Property (Except Motor Vehicles)'), 14)
(('Taranaki Area', 'Motor Vehicle Theft and Related Offences'), 167)
(('Taranaki Area', 'Robbery'), 3)
(('Taranaki Area', 'Sexual Assault'), 43)
(('Taranaki Area', 'Theft (Except Motor Vehicles)'), 158)
(('Taupo Area', 'Abduction and Kidnapping'), 4)
(('Taupo Area', 'Assault'), 205)
(('Taupo Area', 'Illegal Use of Property (Except Motor Vehicles)'), 9)
(('Taupo Area', 'Motor Vehicle Theft and Related Offences'), 140)
(('Taupo Area', 'Robbery'), 15)
(('Taupo Area', 'Sexual Assault'), 28)
(('Taupo Area', 'Theft (Except Motor Vehicles)'), 146)
(('Waikato East Area', 'Assault'), 204)
(('Waikato East Area', 'Blackmail and Extortion'), 1)
(('Waikato East Area', 'Illegal Use of Property (Except Motor Vehicles)'), 24)
(('Waikato East Area', 'Motor Vehicle Theft and Related Offences'), 183)
(('Waikato East Area', 'Robbery'), 9)
(('Waikato East Area', 'Sexual Assault'), 34)
(('Waikato East Area', 'Theft (Except Motor Vehicles)'), 145)
(('Waikato West Area', 'Abduction and Kidnapping'), 3)
(('Waikato West Area', 'Assault'), 251)
(('Waikato West Area', 'Blackmail and Extortion'), 1)
(('Waikato West Area', 'Illegal Use of Property (Except Motor Vehicles)'), 7)
(('Waikato West Area', 'Motor Vehicle Theft and Related Offences'), 175)
(('Waikato West Area', 'Robbery'), 18)
(('Waikato West Area', 'Sexual Assault'), 40)
(('Waikato West Area', 'Theft (Except Motor Vehicles)'), 131)
(('Wairarapa Area', 'Abduction and Kidnapping'), 1)
(('Wairarapa Area', 'Assault'), 159)
(('Wairarapa Area', 'Illegal Use of Property (Except Motor Vehicles)'), 10)
(('Wairarapa Area', 'Motor Vehicle Theft and Related Offences'), 126)
(('Wairarapa Area', 'Robbery'), 2)
(('Wairarapa Area', 'Sexual Assault'), 16)
(('Wairarapa Area', 'Theft (Except Motor Vehicles)'), 68)
(('Waitakere Area', 'Abduction and Kidnapping'), 4)
(('Waitakere Area', 'Assault'), 353)
(('Waitakere Area', 'Blackmail and Extortion'), 3)
(('Waitakere Area', 'Illegal Use of Property (Except Motor Vehicles)'), 26)
(('Waitakere Area', 'Motor Vehicle Theft and Related Offences'), 356)
(('Waitakere Area', 'Robbery'), 61)
(('Waitakere Area', 'Sexual Assault'), 44)
(('Waitakere Area', 'Theft (Except Motor Vehicles)'), 246)
(('Wellington Area', 'Abduction and Kidnapping'), 1)
(('Wellington Area', 'Assault'), 386)
(('Wellington Area', 'Blackmail and Extortion'), 3)
(('Wellington Area', 'Illegal Use of Property (Except Motor Vehicles)'), 57)
(('Wellington Area', 'Motor Vehicle Theft and Related Offences'), 298)
(('Wellington Area', 'Robbery'), 12)
(('Wellington Area', 'Sexual Assault'), 54)
(('Wellington Area', 'Theft (Except Motor Vehicles)'), 204)
(('West Coast Area', 'Abduction and Kidnapping'), 1)
(('West Coast Area', 'Assault'), 97)
(('West Coast Area', 'Illegal Use of Property (Except Motor Vehicles)'), 3)
(('West Coast Area', 'Motor Vehicle Theft and Related Offences'), 64)
(('West Coast Area', 'Robbery'), 1)
(('West Coast Area', 'Sexual Assault'), 15)
(('West Coast Area', 'Theft (Except Motor Vehicles)'), 62)
(('Western Bay Of Plenty Area', 'Abduction and Kidnapping'), 3)
(('Western Bay Of Plenty Area', 'Assault'), 333)
(('Western Bay Of Plenty Area', 'Blackmail and Extortion'), 1)
(('Western Bay Of Plenty Area', 'Illegal Use of Property (Except Motor Vehicles)'), 50)
(('Western Bay Of Plenty Area', 'Motor Vehicle Theft and Related Offences'), 272)
(('Western Bay Of Plenty Area', 'Robbery'), 23)
(('Western Bay Of Plenty Area', 'Sexual Assault'), 58)
(('Western Bay Of Plenty Area', 'Theft (Except Motor Vehicles)'), 226)
(('Whanganui Area', 'Abduction and Kidnapping'), 2)
(('Whanganui Area', 'Assault'), 214)
(('Whanganui Area', 'Blackmail and Extortion'), 1)
(('Whanganui Area', 'Illegal Use of Property (Except Motor Vehicles)'), 24)
(('Whanganui Area', 'Motor Vehicle Theft and Related Offences'), 134)
(('Whanganui Area', 'Robbery'), 12)
(('Whanganui Area', 'Sexual Assault'), 24)
(('Whanganui Area', 'Theft (Except Motor Vehicles)'), 129)
(('Whangarei Area', 'Abduction and Kidnapping'), 6)
(('Whangarei Area', 'Assault'), 251)
(('Whangarei Area', 'Illegal Use of Property (Except Motor Vehicles)'), 13)
(('Whangarei Area', 'Motor Vehicle Theft and Related Offences'), 254)
(('Whangarei Area', 'Robbery'), 40)
(('Whangarei Area', 'Sexual Assault'), 36)
(('Whangarei Area', 'Theft (Except Motor Vehicles)'), 167)
In [49]:
set(crime_d['Police Area'].values)
Out[49]:
{'Auckland Central Area',
'Auckland East Area',
'Auckland Motorways Area',
'Auckland West Area',
'Canterbury Metro Area',
'Counties Manukau Central Area',
'Counties Manukau East Area',
'Counties Manukau South Area',
'Counties Manukau West Area',
'Eastern Bay Of Plenty Area',
'Far North Area',
'Hamilton City Area',
'Hawkes Bay Area',
'Hutt Valley Area',
'Kapiti-Mana Area',
'Manawatu Area',
'Marlborough Area',
'Mid / South Canterbury Area',
'Nelson Bays Area',
'North Shore Area',
'Otago Coastal Area',
'Otago Lakes Central Area',
'Rodney Area',
'Rotorua Area',
'Southland Area',
'Tairawhiti Area',
'Taranaki Area',
'Taupo Area',
'Waikato East Area',
'Waikato West Area',
'Wairarapa Area',
'Waitakere Area',
'Wellington Area',
'West Coast Area',
'Western Bay Of Plenty Area',
'Whanganui Area',
'Whangarei Area'}
Content source: agronauts/crimesweeper
Similar notebooks: