East Lothian Ward Overall Crime Map

Summary Data For East Lothian Local Authority

In the local authority area the total number of recorded crimes in 2024 was 6,910. Excluding Road Traffic crimes from the total, some 5,646 crimes were recorded. See Table 1 (total recorded crime) and Figure 2 (crimes per 1000 population).

There are six council Wards in East Lothian. In 2024 the total number of recorded crimes was 6,910. Excluding Road Traffic crimes from the total some 5,646 crimes were recorded.

Based on total crime rate per 1000 population in each ward, Dunbar and East Linton :: Haddington and Lammermuir :: North Berwick Coastal are in the lowest crime rate band and no wards are in the highest crime rate band. See Table 3 (total recorded crime in each Ward) and Table 4 (recorded crime per 100 population in each Ward).

The map (Figure 1) shows the same information although in this case the Council Wards are compared across the whole of Scotland and split into coloured five bands using the Jenks natural breaks classification method (see methods for more details).

For those wishing further detail summary files and raw data files are available for download see below.

Similar data for each of the Scottish Local Authorities can be found using the Scotland Reported Crime Summary page.

Figure 1: East Lothian Council Wards Crime Map showing crimes per 1000 population in 2024
Recorded crime rates per 1000 population for the whole of Scotland at Local authority Ward level were calculated then ranked into 5 bands see legend; dark green, Band 1 lowest rate per 1000; light green, band 2; light orange, band 3; light purple, band 4; deep purple, band 5 – the highest crime rate per 1000). If you click on the map the crimes per 1000 population for the past five years will be revealed in the pop-up. You can zoom in using the ± navigation aid on the map and drag the map around to centre an area of interest.

<span data-mce-type=”bookmark” style=”display: inline-block; width: 0px; overflow: hidden; line-height: 0;”

The following section contains tables showing the recorded crimes from 2019 to 2024, subdivied by the Crime category (Group_Description).

Table 1: Recorded Crimes By Category

<span data-mce-type=”bookmark” style=”display: inline-block; width: 0px; overflow: hidden; line-height: 0;”

Table 2: Recorded Crimes Per 1000 Popn. By Category

<span data-mce-type=”bookmark” style=”display: inline-block; width: 0px; overflow: hidden; line-height: 0;”

Summary Data For Each Ward In East Lothian Local Authority

The following section contains tables showing the recorded crimes for each ward from year 2019 to 2024, subdivied by the Crime category (Group_Description). Note for mobile users fewer years are displayed due to screen space constraints. All of the data is included in the file download below.

Table 3: Recorded Crimes By Ward All Categories.

<span data-mce-type=”bookmark” style=”display: inline-block; width: 0px; overflow: hidden; line-height: 0;”

Table 4: Recorded Crimes Per 1000 Popn. By Ward All Categories.

<span data-mce-type=”bookmark” style=”display: inline-block; width: 0px; overflow: hidden; line-height: 0;”

Table 5: Recorded Crimes By Ward Split By Category.

<span data-mce-type=”bookmark” style=”display: inline-block; width: 0px; overflow: hidden; line-height: 0;”

Table 6: Recorded Crimes Per 1000 Popn. By Ward and Split By Category.

<span data-mce-type=”bookmark” style=”display: inline-block; width: 0px; overflow: hidden; line-height: 0;”

East Lothian Council Wards Recorded Crime Downloads

Download summary crime data for East Lothian

Data Sources

Scottish Crime Data is available on the police website via https://www.scotland.police.uk/about-us/how-we-do-it/crime-data.

Shapefiles for UK Council Wards (district_borough_unitary_ward_region) is available from https://osdatahub.os.uk/downloads/open/BoundaryLine.

Ward population data was based on https://www.nrscotland.gov.uk/statistics-and-data/statistics/statistics-by-theme/population/population-estimates/2011-based-special-area-population-estimates/electoral-ward-population-estimates.

Jenks natural breaks classification method, is method designed to determine the best arrangement of values to segregate data into different bands. In this case five bands. This is done by seeking to minimize each band’s average deviation from the band mean, while maximizing each class’s deviation from the means of the other bands. The implementation in Python was the jenkspy implementation created by Matthieu Viry

See https://en.wikipedia.org/wiki/Jenks_natural_breaks_optimization.

Methods in Brief

Multiple annual crime data files (provided as fiscal years) were combined and calendar years were allocated to the data.
Population data was added however, as no data was available for 2022, the 2021 data was used for this year and rates per 1000 population calculated. Bands for each Ward were calculated based on the Crime Rate per 1000 and allocated using Jenks natural breaks classification.
Some remapping of wards was carried out since the police data in a few cases did not map precisely to ward codes. E.g. the police data combined Arran and Ardrossan (wards in North Ayrshire LA. Some data is missing from the maps since it was not possible to properly map data for the Hebridean Isles as reported data appeared to be from overlapping wards.
Maps were prepared using Python with Folium and Geopandas modules
Figures, graphs and tables were prepared using Python the Plotly module and Great_Tables module.