Burglaries
Freedom of Information (FOI) Act request ref: 23/0915
Version Date: 14/08/2023
The Performance Analysis Department have provided the following information:
I am writing to you under the Freedom of Information Act 2000 to request the following information. Please may you provide me with:
An Excel spreadsheet that provides an hourly breakdown, of the occurrence of burglaries in your jurisdiction. I would like a column in 1-hour intervals over a 24-hour period and another column with the number of burglaries that occurred within that one-hour timeframe. This will be from the period 01/01/2022 – 31/12/2022 or the latest 365-day period.
|
Timeslots (hour) |
Dwelling Burglaries |
|
00-01 |
43 |
|
01-02 |
42 |
|
02-03 |
35 |
|
03-04 |
32 |
|
04-05 |
23 |
|
05-06 |
39 |
|
06-07 |
50 |
|
07-08 |
131 |
|
08-09 |
188 |
|
09-10 |
172 |
|
10-11 |
207 |
|
11-12 |
207 |
|
12-13 |
179 |
|
13-14 |
200 |
|
14-15 |
217 |
|
15-16 |
198 |
|
16-17 |
149 |
|
17-18 |
119 |
|
19-20 |
207 |
|
20-21 |
99 |
|
21-22 |
105 |
|
22-23 |
106 |
|
23-00 |
72 |
|
Total |
2820 |
An Excel Spreadsheet that provides a daily breakdown of the occurrence of burglaries in your jurisdiction. I would like the first column to be the first date of that week, whilst columns 2 – 8 will have the frequency of burglaries for that day of the week. The rows will be in weekly intervals and the columns will be broken down by day of the week (Monday, Tuesday etc.) Can this also from the period 01/01/2022 – 31/12/2022 or the latest 365-day period.
|
Date (2022) |
Dwelling Burglaries |
|
01-Jan |
9 |
|
02-Jan |
3 |
|
03-Jan |
9 |
|
04-Jan |
10 |
|
05-Jan |
10 |
|
06-Jan |
17 |
|
07-Jan |
11 |
|
08-Jan |
3 |
|
09-Jan |
8 |
|
10-Jan |
8 |
|
11-Jan |
7 |
|
12-Jan |
4 |
|
13-Jan |
7 |
|
14-Jan |
10 |
|
15-Jan |
6 |
|
16-Jan |
7 |
|
17-Jan |
3 |
|
18-Jan |
2 |
|
19-Jan |
8 |
|
20-Jan |
7 |
|
21-Jan |
5 |
|
22-Jan |
7 |
|
23-Jan |
3 |
|
24-Jan |
7 |
|
25-Jan |
5 |
|
26-Jan |
6 |
|
27-Jan |
10 |
|
28-Jan |
6 |
|
29-Jan |
4 |
|
30-Jan |
4 |
|
31-Jan |
8 |
|
01-Feb |
9 |
|
02-Feb |
8 |
|
03-Feb |
4 |
|
04-Feb |
8 |
|
05-Feb |
4 |
|
06-Feb |
3 |
|
07-Feb |
9 |
|
08-Feb |
10 |
|
09-Feb |
8 |
|
10-Feb |
6 |
|
11-Feb |
10 |
|
12-Feb |
2 |
|
13-Feb |
7 |
|
14-Feb |
7 |
|
15-Feb |
4 |
|
16-Feb |
9 |
|
17-Feb |
7 |
|
18-Feb |
8 |
|
19-Feb |
6 |
|
20-Feb |
5 |
|
21-Feb |
5 |
|
22-Feb |
8 |
|
23-Feb |
11 |
|
24-Feb |
5 |
|
25-Feb |
6 |
|
26-Feb |
7 |
|
27-Feb |
6 |
|
28-Feb |
7 |
|
01-Mar |
12 |
|
02-Mar |
8 |
|
03-Mar |
7 |
|
04-Mar |
5 |
|
05-Mar |
5 |
|
06-Mar |
4 |
|
07-Mar |
11 |
|
08-Mar |
9 |
|
09-Mar |
6 |
|
10-Mar |
10 |
|
11-Mar |
5 |
|
12-Mar |
8 |
|
13-Mar |
7 |
|
14-Mar |
5 |
|
15-Mar |
6 |
|
16-Mar |
15 |
|
17-Mar |
11 |
|
18-Mar |
12 |
|
19-Mar |
3 |
|
20-Mar |
12 |
|
21-Mar |
8 |
|
22-Mar |
12 |
|
23-Mar |
8 |
|
24-Mar |
6 |
|
25-Mar |
7 |
|
26-Mar |
5 |
|
27-Mar |
13 |
|
28-Mar |
10 |
|
29-Mar |
8 |
|
30-Mar |
13 |
|
31-Mar |
16 |
|
01-Apr |
1 |
|
02-Apr |
7 |
|
03-Apr |
7 |
|
04-Apr |
8 |
|
05-Apr |
5 |
|
06-Apr |
6 |
|
07-Apr |
7 |
|
08-Apr |
9 |
|
09-Apr |
6 |
|
10-Apr |
7 |
|
11-Apr |
6 |
|
12-Apr |
5 |
|
13-Apr |
3 |
|
14-Apr |
17 |
|
15-Apr |
12 |
|
16-Apr |
9 |
|
17-Apr |
7 |
|
18-Apr |
6 |
|
19-Apr |
14 |
|
20-Apr |
8 |
|
21-Apr |
9 |
|
22-Apr |
15 |
|
23-Apr |
9 |
|
24-Apr |
8 |
|
25-Apr |
6 |
|
26-Apr |
9 |
|
27-Apr |
11 |
|
28-Apr |
11 |
|
29-Apr |
11 |
|
30-Apr |
13 |
|
01-May |
4 |
|
02-May |
2 |
|
03-May |
13 |
|
04-May |
18 |
|
05-May |
11 |
|
06-May |
10 |
|
07-May |
6 |
|
08-May |
5 |
|
09-May |
4 |
|
10-May |
6 |
|
11-May |
11 |
|
12-May |
10 |
|
13-May |
4 |
|
14-May |
9 |
|
15-May |
14 |
|
16-May |
8 |
|
17-May |
11 |
|
18-May |
11 |
|
19-May |
10 |
|
20-May |
5 |
|
21-May |
5 |
|
22-May |
6 |
|
23-May |
6 |
|
24-May |
12 |
|
25-May |
9 |
|
26-May |
7 |
|
27-May |
2 |
|
28-May |
11 |
|
29-May |
6 |
|
30-May |
4 |
|
31-May |
11 |
|
01-Jun |
11 |
|
02-Jun |
7 |
|
03-Jun |
5 |
|
04-Jun |
5 |
|
05-Jun |
4 |
|
06-Jun |
6 |
|
07-Jun |
8 |
|
08-Jun |
10 |
|
09-Jun |
9 |
|
10-Jun |
6 |
|
11-Jun |
4 |
|
12-Jun |
5 |
|
13-Jun |
5 |
|
14-Jun |
10 |
|
15-Jun |
10 |
|
16-Jun |
3 |
|
17-Jun |
14 |
|
18-Jun |
6 |
|
19-Jun |
6 |
|
20-Jun |
4 |
|
21-Jun |
9 |
|
22-Jun |
10 |
|
23-Jun |
12 |
|
24-Jun |
15 |
|
25-Jun |
12 |
|
26-Jun |
3 |
|
27-Jun |
6 |
|
28-Jun |
3 |
|
29-Jun |
6 |
|
30-Jun |
10 |
|
01-Jul |
10 |
|
02-Jul |
11 |
|
03-Jul |
8 |
|
04-Jul |
14 |
|
05-Jul |
10 |
|
06-Jul |
8 |
|
07-Jul |
11 |
|
08-Jul |
9 |
|
09-Jul |
8 |
|
10-Jul |
5 |
|
11-Jul |
5 |
|
12-Jul |
9 |
|
13-Jul |
11 |
|
14-Jul |
9 |
|
15-Jul |
3 |
|
16-Jul |
7 |
|
17-Jul |
6 |
|
18-Jul |
10 |
|
19-Jul |
10 |
|
20-Jul |
6 |
|
21-Jul |
5 |
|
22-Jul |
3 |
|
23-Jul |
5 |
|
24-Jul |
5 |
|
25-Jul |
7 |
|
26-Jul |
8 |
|
27-Jul |
8 |
|
28-Jul |
7 |
|
29-Jul |
11 |
|
30-Jul |
5 |
|
31-Jul |
8 |
|
01-Aug |
3 |
|
02-Aug |
8 |
|
03-Aug |
9 |
|
04-Aug |
6 |
|
05-Aug |
5 |
|
06-Aug |
4 |
|
07-Aug |
5 |
|
08-Aug |
2 |
|
09-Aug |
8 |
|
10-Aug |
7 |
|
11-Aug |
7 |
|
12-Aug |
8 |
|
13-Aug |
9 |
|
14-Aug |
7 |
|
15-Aug |
8 |
|
16-Aug |
12 |
|
17-Aug |
4 |
|
18-Aug |
12 |
|
19-Aug |
5 |
|
20-Aug |
4 |
|
21-Aug |
7 |
|
22-Aug |
5 |
|
23-Aug |
6 |
|
24-Aug |
6 |
|
25-Aug |
11 |
|
26-Aug |
7 |
|
27-Aug |
6 |
|
28-Aug |
6 |
|
29-Aug |
6 |
|
30-Aug |
11 |
|
31-Aug |
7 |
|
01-Sep |
6 |
|
02-Sep |
5 |
|
03-Sep |
7 |
|
04-Sep |
11 |
|
05-Sep |
6 |
|
06-Sep |
10 |
|
07-Sep |
8 |
|
08-Sep |
4 |
|
09-Sep |
12 |
|
10-Sep |
4 |
|
11-Sep |
6 |
|
12-Sep |
9 |
|
13-Sep |
10 |
|
14-Sep |
7 |
|
15-Sep |
6 |
|
16-Sep |
2 |
|
17-Sep |
4 |
|
18-Sep |
9 |
|
19-Sep |
9 |
|
20-Sep |
7 |
|
21-Sep |
5 |
|
22-Sep |
7 |
|
23-Sep |
8 |
|
24-Sep |
6 |
|
25-Sep |
8 |
|
26-Sep |
6 |
|
27-Sep |
4 |
|
28-Sep |
8 |
|
29-Sep |
5 |
|
30-Sep |
7 |
|
01-Oct |
7 |
|
02-Oct |
4 |
|
03-Oct |
6 |
|
04-Oct |
10 |
|
05-Oct |
14 |
|
06-Oct |
2 |
|
07-Oct |
9 |
|
08-Oct |
15 |
|
09-Oct |
7 |
|
10-Oct |
5 |
|
11-Oct |
2 |
|
12-Oct |
6 |
|
13-Oct |
11 |
|
14-Oct |
11 |
|
15-Oct |
15 |
|
16-Oct |
7 |
|
17-Oct |
4 |
|
18-Oct |
3 |
|
19-Oct |
7 |
|
20-Oct |
5 |
|
21-Oct |
7 |
|
22-Oct |
13 |
|
23-Oct |
9 |
|
24-Oct |
12 |
|
25-Oct |
19 |
|
26-Oct |
6 |
|
27-Oct |
5 |
|
28-Oct |
9 |
|
29-Oct |
15 |
|
30-Oct |
8 |
|
31-Oct |
3 |
|
01-Nov |
3 |
|
02-Nov |
11 |
|
03-Nov |
5 |
|
04-Nov |
13 |
|
05-Nov |
7 |
|
06-Nov |
7 |
|
07-Nov |
10 |
|
08-Nov |
21 |
|
09-Nov |
14 |
|
10-Nov |
10 |
|
11-Nov |
6 |
|
12-Nov |
9 |
|
13-Nov |
7 |
|
14-Nov |
6 |
|
15-Nov |
8 |
|
16-Nov |
11 |
|
17-Nov |
12 |
|
18-Nov |
7 |
|
19-Nov |
11 |
|
20-Nov |
11 |
|
21-Nov |
10 |
|
22-Nov |
3 |
|
23-Nov |
4 |
|
24-Nov |
7 |
|
25-Nov |
9 |
|
26-Nov |
8 |
|
27-Nov |
10 |
|
28-Nov |
9 |
|
29-Nov |
9 |
|
30-Nov |
10 |
|
01-Dec |
8 |
|
02-Dec |
7 |
|
03-Dec |
8 |
|
04-Dec |
8 |
|
05-Dec |
7 |
|
06-Dec |
7 |
|
07-Dec |
12 |
|
08-Dec |
7 |
|
09-Dec |
4 |
|
10-Dec |
8 |
|
11-Dec |
5 |
|
12-Dec |
8 |
|
13-Dec |
4 |
|
14-Dec |
9 |
|
15-Dec |
6 |
|
16-Dec |
4 |
|
17-Dec |
9 |
|
18-Dec |
8 |
|
19-Dec |
9 |
|
20-Dec |
12 |
|
21-Dec |
7 |
|
22-Dec |
13 |
|
23-Dec |
10 |
|
24-Dec |
4 |
|
25-Dec |
5 |
|
26-Dec |
11 |
|
27-Dec |
10 |
|
28-Dec |
6 |
|
29-Dec |
9 |
|
30-Dec |
11 |
|
31-Dec |
4 |
|
Grand Total |
2820 |