08 May Work Book
Dates for data anaylasis and 500 word story-
8rd April –
found my data set and began analysing
I chose this data set as it had a huge amount of information that could be interpreted and manipulated in different ways, along with providing a large range of stories to write based on the data.
I found my data set through moodle, the data set is based on crime in the UK from 2006-2017.
I chose this data set as it had a huge amount of information that could be interpreted and manipulated in different ways, along with providing a large range of stories to write based on the data.
One way i am going to interpret my data is to use the filtering tools/pivot tables to narrow down crime to london alone and look at the data between 2007-2017 (10 year period).
provisional headline – crime in london is on the increase/decrease (depending on what i find from the data)
10th April –
found the total crime for each year in all of the UK, found the total crime for each year in london and compared the 2 agaisnt eachother.
Changed my analysing range from 2007-17 to 2006-16 to keep the 10 year stretch due to the 2017 set having less data and unfinished data that only stretched halway through the year
Again changed my data range from 2006-16 to 2007-16 due to the same data issue as the 2017 data had
found that last two years (2015 and 2016) in a lot of sets show spike/increase against the decrease that has been seen in previous years
Found the highest and lowest types of crime in each year in london from 2007-2016
14th April –
analysed specific types of crime in london and found the totals for each year
Found that total crime in the UK has been increasing since 2007
Compared to london crime which total crime has been decreasing, used this anaylasis to begin creating my title and stand first.
17th April –
made comparisons between the different types of crime in london and made comparisons to see if there was any trends or relation.
found a graph from the metropolitan police showing a decrease in stop and searches starting in 2014
linked this to the increase of weapon related crimes increasing in 2015 and 16
20th April –
found that the majority highest year of crime for each of the types of crime in london i chose were 2007
ruled out any crime catagories that didnt have sufficient data or that didnt show an interesting pattern that i could use to create my story, in the London crime types over the years.
22nd April –
started writing my story to go with the data but struggled to choose the best angle to go with on my story, settled on the title, ‘Crime in london goes down as crime in the UK begins to increase’
28th of April –
encountered difficulty in trying to link the correlation between the number of random stop and search’s going down and the number of ‘posessing a wepon’ crimes going up, in a none biased way whilst also making clear that it is a contorversial topic
Looked for any specific events that would explain higher than normal numbers in each crime section, eg. london riots.
30th April –
Some of the issues i came across were finding a quote from a relevant expert/person as it was a very police based topic that i chose and getting a reply from the police press office took a long time and multiple messages.
contacted the press department at met police asking for a quote on the matter of stop and searched going down and wepon related crime increasing.
included data from a met police report and an article in the guardian about crime in 2018 to back up my point about an increase in weapon crime against decrease of stop and searches
I also struggled to get a quote relating to stop and search as i had made a connection between that and the increase in knife crime so needed to have a professional opinion in order to use it in my story
Information that I found from the data –
England
Total crime for England –increasing from 2014
2007 – 21025549
2008 – 19449338
2009 – 18359035
2010 – 16989262
2011 – 16932850
2012 – 16985977
2013 – 16128272
2014 – 16312580
2015 – 17165981
2016 – 18555965
LONDON
Total crimes over the years in London
2007 – 31739
2008 – 29729
2009 – 27699
2010 – 25482
2011 – 25884
2012 – 23254
2013 – 21972
2014 – 21488
2015 – 21245
2016 – 21124
‘Possession of weapons’ total over years
2007 – 309
2008 – 187
2009 – 160
2010 – 179
2011 – 138
2012 – 12
2013 – 92
2014 – 99
2015 – 109
2016 – 155
Total bycicle crime –goes up then down, highest in 2011
2006 – 336
2007 – 1185
2008 – 1305
2009 – 1551
2010 – 1726
2011 – 1740
2012 – 1514
2013 – 1282
2014 – 1494
2015 – 1311
2016 – 1265
drug offences – fairly consistent from 2007-2011, big dip in 2012, on the decrease from then on, DO A LINE GRAPH IN INFOGRAPHIC TO SHOW THIS (500 WORD STORY – NOT ALL CRIME IS ON THE INCREASE HOWEVER WITH SOME SERIOUSLY IMPACTING CRIMES HAVING BEEN ON THE DECREASE SINCE 2010 HIGHEST IN 2007
2006 –1023
2007 – 3198
2008 – 3062
2009 – 3116
2010 – 3162
2011 – 3048
2012 – 2397
2013 – 1888
2014 – 1759
2015 – 1617
2016 – 1491
Miscilaneous crimes against society – NO REAL PATTERN SO DON’T INCLUDE IN INFOGRAPHIC/STORY UNLESS NESSICARY HIGHEST IN 2007
2006 – 460
2007 – 1338
2008 – 1249
2009 – 961
2010 – 935
2011 – 1164
2012 – 683
2013 – 720
2014 – 816
2015 – 678
2016 – 711
non-domestic burglary – OVERALL DECREASE SPEAK ABOUT THE 2 OUTLIER SPIKES HIGHEST IN 2007
2006 – 341
2007 – 1436
2008 – 1341
2009 – 1200
2010 – 1096
2011 – 975
2012 – 1174
2013 – 1188
2014 – 941
2015 – 863
2016 – 871
possession of wepons offences – ON A DECREASE UNTIL 2015, SPIKE IN 2016, HIGHEST IN 2007, MENTION 2018 INCREASED KNIFE AND GUN CRIME 36 DEATHS IN FIRST QUARTER OF THE YEAR
2006 – 117
2007 – 309
2008 – 187
2009 – 160
2010 – 179
2011 – 138
2012 – 127
2013 – 92
2014 – 99
2015 – 109
2016 – 155
public order offences – LOOK UP WHAT THIS MEANS, DECREASING UNTIL 2015 THEN INCREASING WITH A LARGE SPIKE DIFFERENCE OVER 2 YEARS HIGHEST IN 2007
2006 – 314
2007 – 1280
2008 – 911
2009 – 781
2010 – 760
2011 – 824
2012 – 729
2013 – 737
2014 – 681
2015 –917
2016 – 1031
robbery – ON A GRADUAL DECREASE WITH A FEW SPIKES, SEE IF ANY OTHER CRIMES HAVE SPIKE IN 2013, LINK TO OTHER CRIMES GOING DOWN, E.G DRUGS GO DOWN SO DO ROBERRYS ECT. DO LINE GRAPH SHOWING CORELATION BETWEEN THE TWO. HIGHEST 2008
2006 – 39
2007 – 166
2008 – 225
2009 – 170
2010 – 164
2011 – 173
2012 – 185
2013 – 195
2014 – 187
2015 – 155
2016 – 150
sexual offences – ON THE INCREASE FROM 2013 MAY BE BECAUSE MORE PEOPLE ARE COMING FORWARD IN RECENT YEARS. HIGHEST IN 2016
2006 – 51
2007 – 170
2008 – 180
2009 – 134
2010 – 158
2011 – 146
2012 –138
2013 – 191
2014 – 239
2015 – 299
2016 – 332
violence with injury – BEEN ON THE INCREASE FROM 2007-2016 HIGHEST YEAR 2016 DIPPED FOR A FEW YEARS BUT INCREASED OVER REST
2006 – 261
2007 – 1255
2008 – 1335
2009 – 1375
2010 – 1054
2011 – 1163
2012 – 1083
2013 – 1196
2014 – 1364
2015 – 1484
2016 – 1555
violence without injury – CRIME INCREASED FROM 2014-2016 HIGHEST YEAR 2016.
2006 – 328
2007 – 1402
2008 – 1297
2009 – 1141
2010 – 1057
2011 – 928
2012 – 1109
2013 – 919
2014 – 1129
2015 – 1532
2016 – 1793
Shoplifting – ON THE DECREASE SINCE 2008 STARTS INCREASING IN 2014-2016 HIGHEST YEAR 2009
2006 – 737
2007 – 3201
2008 – 3519
2009 – 3513
2010 – 3227
2011 – 3196
2012 – 2686
2013 – 2358
2014 – 2389
2015 – 2548
2016 – 2663
Stabbings in London are at their highest in six years – https://www.theguardian.com/commentisfree/2018/apr/23/violent-murder-london-youth-rate-community-strategy
the total number of London murders, even excluding victims of terrorism, has risen by 38% since 2014 – https://www.thetimes.co.uk/article/london-murder-rate-beats-new-york-as-stabbings-surge-f59w0xqs0
Fatal stabbings in England and Wales are at their highest levels since 2011 – http://www.bbc.co.uk/news/uk-43603080
used canvas to create image a
link to the report where you found the stats (sources)
link sources on the infographic