reports

Each row is one public submission to Operation Snap. Includes the offence, vehicle details, location, and outcome.

Disposal outcomes: Education (driver awareness course), Warning Letter, Fixed Penalty (fine), Court (prosecution), NFA (no further action).

Data license: ODbL · Data source: West Midlands Police

id
{'label': 'ID'}
source_file
{'label': 'Source PDF'}
source_page
{'label': 'Page'}
source_row
{'label': 'Row'}
month
{'label': 'Month'}
reporter_transport_mode
{'label': 'Reporter'}
vehicle_make
{'label': 'Make'}
vehicle_model
{'label': 'Model'}
vehicle_colour
{'label': 'Colour'}
offence
{'label': 'Offence'}
second_offence
{'label': 'Second offence'}
offence_location_raw
{'label': 'Location (raw)'}
offence_location
{'label': 'Location'}
council_area_raw
{'label': 'Council (raw)'}
council_area
{'label': 'Council area'}
disposal
{'label': 'Outcome'}
nfa_rationale
{'label': 'NFA reason'}
witness_contacted
{'label': 'Witness contacted'}
latitude
{'label': 'Lat'}
longitude
{'label': 'Lng'}

115 rows where council_area = "Out of Force Area", month = "2025-10" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale, latitude, longitude

disposal 2

reporter_transport_mode 1

  • Car · 115 ✖

month 1

  • 2025-10 · 115 ✖

council_area 1

  • Out of Force Area · 115 ✖
id source_file source_page source_row month ▲ reporter_transport_mode vehicle_make vehicle_model vehicle_colour offence second_offence offence_location_raw offence_location council_area_raw council_area disposal nfa_rationale witness_contacted latitude longitude
22055 op-snap---monthly-publication-october-2025.pdf   5 2025-10 Car BMW 116d White Driving without Due Care and Attention None B4188 Belbroughton Belbroughton Out of Force Area Out of Force Area NFA Out of Force      
22066 op-snap---monthly-publication-october-2025.pdf   16 2025-10 Car Skoda Octavia Silver Driving without Due Care and Attention None Harmer Hill Harmer Hill Out of Force Area Out of Force Area NFA Out of Force      
22069 op-snap---monthly-publication-october-2025.pdf   19 2025-10 Car Skoda Fabia Red Driving without Due Care and Attention None A642, Wakefield A642, Wakefield Out of Force Area Out of Force Area NFA Out of Force   52.5496838 -1.8385006
22071 op-snap---monthly-publication-october-2025.pdf   21 2025-10 Car Suzuki Swift Red Driving without Due Care and Attention None A5 Oswestry Oswestry Out of Force Area Out of Force Area NFA Out of Force      
22075 op-snap---monthly-publication-october-2025.pdf   25 2025-10 Car BMW   Silver Driving without Due Care and Attention None M54 M54 Out of Force Area Out of Force Area NFA Out of Force      
22078 op-snap---monthly-publication-october-2025.pdf   28 2025-10 Car Kia Sportage Black Contravening a Red Traffic Light None M42 J9 Island M42 J9 Island Out of Force Area Out of Force Area NFA Out of Force   52.3601724 -1.8062199
22107 op-snap---monthly-publication-october-2025.pdf   57 2025-10 Car Volvo XC70 Red Contravening a Red Traffic Light None Bilton Lane, Rugby Bilton Lane, Rugby Out of Force Area Out of Force Area NFA Out of Force      
22127 op-snap---monthly-publication-october-2025.pdf   77 2025-10 Car   Electric Scooter Black Driving without Due Care and Attention None Marshbrook Way Telford (West Mercia) Marshbrook Way Telford (West Mercia) Out of Force Area Out of Force Area NFA Out of Force      
22140 op-snap---monthly-publication-october-2025.pdf   90 2025-10 Car Volkswagen Polo Black Driving without Due Care and Attention None M51 J1-J2 M51 J1-J2 Out of Force Area Out of Force Area NFA Out of Force      
22145 op-snap---monthly-publication-october-2025.pdf   95 2025-10 Car Ford   White Driving without Due Care and Attention None Chesterton Way, Tamworth Chesterton Way, Tamworth Out of Force Area Out of Force Area NFA Out of Force      
22146 op-snap---monthly-publication-october-2025.pdf   96 2025-10 Car Hyundai   Grey Driving without Due Care and Attention None Donnington Wood Way, Telford Donnington Wood Way, Telford Out of Force Area Out of Force Area NFA Out of Force      
22159 op-snap---monthly-publication-october-2025.pdf   109 2025-10 Car Ford Focus Black Driving without Due Care and Attention None B4387 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force   52.6195535 -2.0193824
22192 op-snap---monthly-publication-october-2025.pdf   142 2025-10 Car Mercedes-Benz   White Driving without Due Care and Attention None Green Street Green Street Out of Force Area Out of Force Area NFA Out of Force   52.4737217 -1.8844945
22194 op-snap---monthly-publication-october-2025.pdf   144 2025-10 Car Volkswagen Tiago White Contravening a Red Traffic Light None Welsh Road, Warwickshire Welsh Road, Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
22214 op-snap---monthly-publication-october-2025.pdf   164 2025-10 Car Land Rover Discovery Red Driving without Due Care and Attention None Mill Street, Evesham, Mill Street, Evesham Out of Force Area Out of Force Area NFA Out of Force      
22231 op-snap---monthly-publication-october-2025.pdf   181 2025-10 Car Toyota Auris Silver Driving without Due Care and Attention None Woodrow Drive Woodrow Drive Out of Force Area Out of Force Area NFA Out of Force      
22232 op-snap---monthly-publication-october-2025.pdf   182 2025-10 Car Chevrolet Spark Blue Contravening a Red Traffic Light None Wrockwardine Wood Way, Telford Wrockwardine Wood Way, Telford Out of Force Area Out of Force Area NFA Out of Force      
22234 op-snap---monthly-publication-october-2025.pdf   184 2025-10 Car   Motorcycle Red Contravening a Red Traffic Light None Vale Road Stourport on Severn Vale Road Stourport on Severn Out of Force Area Out of Force Area NFA Out of Force      
22243 op-snap---monthly-publication-october-2025.pdf   193 2025-10 Car Tesla   White Driving without Due Care and Attention None Common Road Common Road Out of Force Area Out of Force Area NFA Out of Force   52.6253951 -1.9696087
22244 op-snap---monthly-publication-october-2025.pdf   194 2025-10 Car Lexus CT200H White Using a Mobile Phone Whilst Driving None UK Uk Out of Force Area Out of Force Area NFA No Independent Evidence Available   52.5019896 -2.0209184
22252 op-snap---monthly-publication-october-2025.pdf   202 2025-10 Car Volvo   Green Driving without Due Care and Attention None A5 A5 Out of Force Area Out of Force Area NFA Out of Force      
22289 op-snap---monthly-publication-october-2025.pdf   239 2025-10 Car Mercedes-Benz GLA Grey Drive on hard shoulder None M42 Motorway, jn9. Warwickshire M42 Motorway, jn9. Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
22296 op-snap---monthly-publication-october-2025.pdf   246 2025-10 Car BMW M140i White Driving without Due Care and Attention None M6 EB J3 M6 Eb J3 Out of Force Area Out of Force Area NFA Out of Force   52.6912652 -2.1043715
22313 op-snap---monthly-publication-october-2025.pdf   263 2025-10 Car Volkswagen Tiguan Grey Driving without Due Care and Attention None M54 WB J6-7 M54 Wb J6-7 Out of Force Area Out of Force Area NFA Out of Force      
22323 op-snap---monthly-publication-october-2025.pdf   273 2025-10 Car Volkswagen Golf White Driving without Due Care and Attention None M42 J10 Tamworth M42 J10 Tamworth Out of Force Area Out of Force Area NFA Out of Force   52.6020492 -1.6329003
22327 op-snap---monthly-publication-october-2025.pdf   277 2025-10 Car Seat Leon White Motor vehicle fail to comply with solid white line road markings None M62 Birstall Slip Road M62 Birstall Slip Road Out of Force Area Out of Force Area NFA Out of Force      
22349 op-snap---monthly-publication-october-2025.pdf   299 2025-10 Car Land Rover Range Rover Gold Driving without Due Care and Attention None M6 Staffs M6 Staffs Out of Force Area Out of Force Area NFA Out of Force   52.6170728 -2.030393
22358 op-snap---monthly-publication-october-2025.pdf   308 2025-10 Car Mercedes-Benz HGV White Driving without Due Care and Attention None M40 NB M40 Northbound Out of Force Area Out of Force Area NFA Out of Force      
22359 op-snap---monthly-publication-october-2025.pdf   309 2025-10 Car Land Rover Vogue Brown Driving without Due Care and Attention None M40 NB M40 Northbound Out of Force Area Out of Force Area NFA Out of Force      
22362 op-snap---monthly-publication-october-2025.pdf   312 2025-10 Car Ford tansit White Driving without Due Care and Attention None M42 Tamworth M42 Tamworth Out of Force Area Out of Force Area NFA Out of Force   52.5751647 -1.8118902
22384 op-snap---monthly-publication-october-2025.pdf   334 2025-10 Car Kia Soul Black Driving without Due Care and Attention None A4440 Grove Way, Worcester Grove Way, Worcester Out of Force Area Out of Force Area NFA Out of Force      
22390 op-snap---monthly-publication-october-2025.pdf   340 2025-10 Car Ford Kuga Silver Contravening a Red Traffic Light None Amington Road Amington Road Out of Force Area Out of Force Area NFA Out of Force   52.4577115 -1.8237002
22407 op-snap---monthly-publication-october-2025.pdf   357 2025-10 Car Nissan Qashqai Black Drive on hard shoulder None M1 Burnley M1 Burnley Out of Force Area Out of Force Area NFA Out of Force      
22414 op-snap---monthly-publication-october-2025.pdf   364 2025-10 Car Peugeot Boxer Grey Driving without Due Care and Attention None Joynes Road, Droitwich Joynes Road, Droitwich Out of Force Area Out of Force Area NFA Out of Force      
22421 op-snap---monthly-publication-october-2025.pdf   371 2025-10 Car Land Rover Range Rover Black Driving without Due Care and Attention None Warwick Highway, Redditch Warwick Highway, Redditch Out of Force Area Out of Force Area NFA Out of Force      
22441 op-snap---monthly-publication-october-2025.pdf   391 2025-10 Car Peugeot 3008GT Red Driving without Due Care and Attention None Bridgenorth Bridgenorth Out of Force Area Out of Force Area NFA Out of Force      
22459 op-snap---monthly-publication-october-2025.pdf   409 2025-10 Car Vauxhall Mokka Brown Driving without Due Care and Attention None Woodgreen Drive Woodgreen Drive Out of Force Area Out of Force Area NFA Out of Force      
22463 op-snap---monthly-publication-october-2025.pdf   413 2025-10 Car Ford Fiesta Blue Using a Mobile Phone Whilst Driving None A1M, Leeds A1M, Leeds Out of Force Area Out of Force Area NFA Out of Force      
22464 op-snap---monthly-publication-october-2025.pdf   414 2025-10 Car Volkswagen Scirrocco Black Driving without Due Care and Attention None A38 Droitwich Road Droitwich Road Out of Force Area Out of Force Area NFA Out of Force      
22473 op-snap---monthly-publication-october-2025.pdf   423 2025-10 Car Renault Master Blue Drive on hard shoulder None A38, Burton on Trent A38, Burton on Trent Out of Force Area Out of Force Area NFA Out of Force      
22474 op-snap---monthly-publication-october-2025.pdf   424 2025-10 Car S Sangyong Rexton Black Drive on hard shoulder None A38, Burton on Trent A38, Burton on Trent Out of Force Area Out of Force Area NFA Out of Force      
22475 op-snap---monthly-publication-october-2025.pdf   425 2025-10 Car Nissan Ariya Grey Drive on hard shoulder None A38, Burton on Trent A38, Burton on Trent Out of Force Area Out of Force Area NFA Out of Force      
22476 op-snap---monthly-publication-october-2025.pdf   426 2025-10 Car Ford Transit White Contravening a Red Traffic Light None A5 J10 M42 Tamworth A5 J10 M42 Tamworth Out of Force Area Out of Force Area NFA Out of Force      
22477 op-snap---monthly-publication-october-2025.pdf   427 2025-10 Car Toyota Pardo Green Driving without Due Care and Attention None Shutford Road, Banbury Shutford Road, Banbury Out of Force Area Out of Force Area NFA Out of Force      
22478 op-snap---monthly-publication-october-2025.pdf   428 2025-10 Car Hyundai Tuscan Black Using a Mobile Phone Whilst Driving None Malvern Road, Worcester Malvern Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
22493 op-snap---monthly-publication-october-2025.pdf   443 2025-10 Car Citroen Berlingo White Driving without Due Care and Attention None M42 J10 NB, Tamworth M42 J10 Northbound, Tamworth Out of Force Area Out of Force Area NFA Out of Force      
22501 op-snap---monthly-publication-october-2025.pdf   451 2025-10 Car BMW X1 Black Driving without Due Care and Attention None M42 J12 M42 J12 Out of Force Area Out of Force Area NFA Out of Force      
22507 op-snap---monthly-publication-october-2025.pdf   457 2025-10 Car Vauxhall van White Contravening a Red Traffic Light None Jn21 of M1, exit for M69 Jn21 of M1, exit for M69 Out of Force Area Out of Force Area NFA Out of Force      
22514 op-snap---monthly-publication-october-2025.pdf   464 2025-10 Car Vauxhall Corsa Grey Using a Mobile Phone Whilst Driving None Chasepool Road Chasepool Road Out of Force Area Out of Force Area NFA Out of Force      
22521 op-snap---monthly-publication-october-2025.pdf   471 2025-10 Car Audi A5 Grey Driving without Due Care and Attention None M40 M40 Out of Force Area Out of Force Area NFA Out of Force      
22523 op-snap---monthly-publication-october-2025.pdf   473 2025-10 Car Jaguar   Red Driving without Due Care and Attention None A16 Holton Le Clay Holton Le Clay Out of Force Area Out of Force Area NFA Out of Force      
22537 op-snap---monthly-publication-october-2025.pdf   487 2025-10 Car Ford Transit White Contravening a Red Traffic Light None Wolverhampton Road, Stafford Wolverhampton Road, Stafford Out of Force Area Out of Force Area NFA Out of Force   52.6022632 -2.1299215
22538 op-snap---monthly-publication-october-2025.pdf   488 2025-10 Car     White Driver not in position to have Proper Control None Station Road, Whitchurch Station Road, Whitchurch Out of Force Area Out of Force Area NFA Out of Force      
22557 op-snap---monthly-publication-october-2025.pdf   507 2025-10 Car Ford Transit Black Driving without Due Care and Attention None Western Road Western Road Out of Force Area Out of Force Area NFA Out of Force   52.4884809 -1.9281157
22565 op-snap---monthly-publication-october-2025.pdf   515 2025-10 Car Volkswagen Caddy Silver Driving without Due Care and Attention None Kidderminster Road Kidderminster Road Out of Force Area Out of Force Area NFA Out of Force   52.4331313 -2.1702262
22577 op-snap---monthly-publication-october-2025.pdf   527 2025-10 Car Vauxhall vivaro White Contravening a Red Traffic Light None J15 M40 J15 M40 Out of Force Area Out of Force Area NFA Out of Force      
22583 op-snap---monthly-publication-october-2025.pdf   533 2025-10 Car Ford Fiesta green Contravening a Red Traffic Light None A444 Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
22587 op-snap---monthly-publication-october-2025.pdf   537 2025-10 Car Toyota Corolla White Driving without Due Care and Attention None Telford Telford Out of Force Area Out of Force Area NFA No Offence   52.4979333 -1.9664857
22588 op-snap---monthly-publication-october-2025.pdf   538 2025-10 Car Ford Fiesta Black Driving without Due Care and Attention None Telford Telford Out of Force Area Out of Force Area NFA Out of Force   52.4979333 -1.9664857
22601 op-snap---monthly-publication-october-2025.pdf   551 2025-10 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None M69 Hinkley M69 Hinkley Out of Force Area Out of Force Area NFA Out of Force      
22620 op-snap---monthly-publication-october-2025.pdf   570 2025-10 Car Ford Transit Silver Driving without Due Care and Attention None M6 South Jct 2 (Warwickshire) M6 South Junction 2 (Warwickshire) Out of Force Area Out of Force Area NFA Out of Force      
22656 op-snap---monthly-publication-october-2025.pdf   606 2025-10 Car Volkswagen Golf Black Driving without Due Care and Attention None Minster on Sea, Sheerness Minster on Sea, Sheerness Out of Force Area Out of Force Area NFA Out of Force      
22697 op-snap---monthly-publication-october-2025.pdf   647 2025-10 Car Volkswagen golf Black Driving without Due Care and Attention None City Walls Road City Walls Road Out of Force Area Out of Force Area NFA Out of Force      
22706 op-snap---monthly-publication-october-2025.pdf   656 2025-10 Car Citroen C4 Blue Driving without Due Care and Attention None M42 on to M5 slip road M42 on to M5 slip road Out of Force Area Out of Force Area NFA Out of Force      
22707 op-snap---monthly-publication-october-2025.pdf   657 2025-10 Car Vauxhall Corsa White Misc - Non Traffic Offences None M6 near Knutsford M6 near Knutsford Out of Force Area Out of Force Area NFA Out of Force      
22711 op-snap---monthly-publication-october-2025.pdf   661 2025-10 Car Mazda 2 Blue Driving without Due Care and Attention None A518 Newport to Humbers Newport to Humbers Out of Force Area Out of Force Area NFA Out of Force      
22717 op-snap---monthly-publication-october-2025.pdf   667 2025-10 Car Toyota Aygo White Driving without Due Care and Attention None M1 SB Tibshelf M1 Southbound Tibshelf Out of Force Area Out of Force Area NFA Out of Force      
22733 op-snap---monthly-publication-october-2025.pdf   683 2025-10 Car Renault Megane Blue Driving without Due Care and Attention None M1 Southbound towards London M1 Southbound towards London Out of Force Area Out of Force Area NFA Out of Force      
22736 op-snap---monthly-publication-october-2025.pdf   686 2025-10 Car BMW 330i Grey Using a Mobile Phone Whilst Driving No vehicle excise licence Barbourne Road, Worcester Barbourne Road, Worcester Out of Force Area Out of Force Area NFA Out of Force      
22743 op-snap---monthly-publication-october-2025.pdf   693 2025-10 Car Volkswagen Polo Silver Using a Mobile Phone Whilst Driving None M61 (Out of Force - Lancashire) M61 (Out of Force - Lancashire) Out of Force Area Out of Force Area NFA Out of Force      
22747 op-snap---monthly-publication-october-2025.pdf   697 2025-10 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Ashby Road Loughbrorough Ashby Road Loughbrorough Out of Force Area Out of Force Area NFA Out of Force      
22748 op-snap---monthly-publication-october-2025.pdf   698 2025-10 Car Vauxhall Corsa Green Contravening a Red Traffic Light None Dark Lane (Staffordshire) Dark Lane (Staffordshire) Out of Force Area Out of Force Area NFA Out of Force      
22768 op-snap---monthly-publication-october-2025.pdf   718 2025-10 Car Toyota Yaris Red Driver not in position to have Proper Control None M66 M66 Out of Force Area Out of Force Area NFA Out of Force      
22769 op-snap---monthly-publication-october-2025.pdf   719 2025-10 Car BMW 330e Black Using a Mobile Phone Whilst Driving None A6046 A6046 Out of Force Area Out of Force Area NFA Out of Force      
22783 op-snap---monthly-publication-october-2025.pdf   733 2025-10 Car Ford Ka Grey Contravening a Red Traffic Light None Davis Road, Evesham Davis Road, Evesham Out of Force Area Out of Force Area NFA Out of Force      
22803 op-snap---monthly-publication-october-2025.pdf   753 2025-10 Car Fiat   Green Driving without Due Care and Attention None Cheadle Road Cheadle Road Out of Force Area Out of Force Area NFA Out of Force   52.4493915 -1.4804335
22826 op-snap---monthly-publication-october-2025.pdf   776 2025-10 Car BMW 118i White Driving without Due Care and Attention None M5 SB 7-8 M5 Southbound 7-8 Out of Force Area Out of Force Area NFA Out of Force      
22827 op-snap---monthly-publication-october-2025.pdf   777 2025-10 Car Renault   Grey Driving without Due Care and Attention None Easmore Road Redditch Easmore Road Redditch Out of Force Area Out of Force Area NFA Out of Force      
22839 op-snap---monthly-publication-october-2025.pdf   789 2025-10 Car Toyota CHR.. Silver Driving without Due Care and Attention None A442 Market Drayton Market Drayton Out of Force Area Out of Force Area NFA Out of Force      
22853 op-snap---monthly-publication-october-2025.pdf   803 2025-10 Car Peugeot 3008 White Driving without Due Care and Attention None M40 M40 Out of Force Area Out of Force Area NFA Out of Force      
22854 op-snap---monthly-publication-october-2025.pdf   804 2025-10 Car Audi A3 Black Misc - Non Traffic Offences None West End Lane, London West End Lane, London Out of Force Area Out of Force Area NFA Out of Force      
22859 op-snap---monthly-publication-october-2025.pdf   809 2025-10 Car Ford Transit White Using a Mobile Phone Whilst Driving None M40 M40 Out of Force Area Out of Force Area NFA Out of Force      
22864 op-snap---monthly-publication-october-2025.pdf   814 2025-10 Car Iveco 75E White Motor vehicle fail to accord precedence at a pelican crossing None Clifton Drive South, Lytham St Annes Clifton Drive South, Lytham Street Annes Out of Force Area Out of Force Area NFA Out of Force      
22877 op-snap---monthly-publication-october-2025.pdf   827 2025-10 Car Mercedes-Benz EQE 350 Blue Driving without Due Care and Attention None B4084 Drakes Broughton Drakes Broughton Out of Force Area Out of Force Area NFA Out of Force      
22915 op-snap---monthly-publication-october-2025.pdf   865 2025-10 Car BMW X1 Grey Driving without Due Care and Attention None A5 Staffs Staffs Out of Force Area Out of Force Area NFA Out of Force      
22917 op-snap---monthly-publication-october-2025.pdf   867 2025-10 Car Volkswagen Polo Silver Using a Mobile Phone Whilst Driving None M6 SB J16 - Stoke M6 Southbound J16 - Stoke Out of Force Area Out of Force Area NFA Out of Force      
22919 op-snap---monthly-publication-october-2025.pdf   869 2025-10 Car   HGV Red Contravening a Red Traffic Light None Drybrook Gloucester Drybrook Gloucester Out of Force Area Out of Force Area NFA Out of Force      
22921 op-snap---monthly-publication-october-2025.pdf   871 2025-10 Car Volkswagen Golf Grey Misc - Non Traffic Offences None Stafford Stafford Out of Force Area Out of Force Area NFA Out of Force   52.6014882 -2.1310443
22925 op-snap---monthly-publication-october-2025.pdf   875 2025-10 Car Mercedes-Benz   Grey Using a Mobile Phone Whilst Driving None Wilnecote Wilnecote Out of Force Area Out of Force Area NFA Out of Force   52.5213778 -1.9046931
22947 op-snap---monthly-publication-october-2025.pdf   897 2025-10 Car BMW 320d Blue Driving without Due Care and Attention None Dawley Road, Derbyshire Dawley Road, Derbyshire Out of Force Area Out of Force Area NFA Out of Force      
22977 op-snap---monthly-publication-october-2025.pdf   927 2025-10 Car Mercedes-Benz A200 White Using a Mobile Phone Whilst Driving None M5 near to Jct 8 North M5 near to Junction 8 North Out of Force Area Out of Force Area NFA Out of Force      
22992 op-snap---monthly-publication-october-2025.pdf   942 2025-10 Car Honda C-HR Grey Driving without Due Care and Attention None M6 SB J15 M6 Southbound J15 Out of Force Area Out of Force Area NFA Out of Force      
22998 op-snap---monthly-publication-october-2025.pdf   948 2025-10 Car Toyota Corolla Silver Driving without Due Care and Attention None Mafeking Road Mafeking Road Out of Force Area Out of Force Area NFA Out of Force   52.500243 -1.9673473
23010 op-snap---monthly-publication-october-2025.pdf   960 2025-10 Car Ford Kuga Grey Driving without Due Care and Attention None A46 Rugby Rugby Out of Force Area Out of Force Area NFA Misc Inc Crimes   52.5458823 -1.7949266
23020 op-snap---monthly-publication-october-2025.pdf   970 2025-10 Car Volkswagen Multivan Black Using a Mobile Phone Whilst Driving None Strawberry Hill, Teddington Strawberry Hill, Teddington Out of Force Area Out of Force Area NFA Out of Force      
23033 op-snap---monthly-publication-october-2025.pdf   983 2025-10 Car Toyota Corolla Silver Driving without Due Care and Attention None M54 Junction 4 M54 Junction 4 Out of Force Area Out of Force Area NFA Out of Force      
23036 op-snap---monthly-publication-october-2025.pdf   986 2025-10 Car BMW   Grey Driving without Due Care and Attention None M42 J2 M42 J2 Out of Force Area Out of Force Area NFA Out of Force   52.4945433 -2.0190848
23037 op-snap---monthly-publication-october-2025.pdf   987 2025-10 Car Ford Fiesta Red Driving without Due Care and Attention None B4455 Fosse Way Fosse Way Out of Force Area Out of Force Area NFA Out of Force      
23038 op-snap---monthly-publication-october-2025.pdf   988 2025-10 Car Mazda 3 White Contravening a Red Traffic Light None Bromsgrove Road Bromsgrove Road Out of Force Area Out of Force Area NFA Out of Force   52.4473174 -2.0452886
23040 op-snap---monthly-publication-october-2025.pdf   990 2025-10 Car   Van White Driving without Due Care and Attention None M5 Bromsgrove M5 Bromsgrove Out of Force Area Out of Force Area NFA Out of Force   52.432364 -2.0176127

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE reports (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            source_file TEXT NOT NULL,
            source_page INTEGER,
            source_row INTEGER,
            month TEXT NOT NULL,
            reporter_transport_mode TEXT,
            vehicle_make TEXT,
            vehicle_model TEXT,
            vehicle_colour TEXT,
            offence TEXT,
            second_offence TEXT,
            offence_location_raw TEXT,
            offence_location TEXT,
            council_area_raw TEXT,
            council_area TEXT,
            disposal TEXT,
            nfa_rationale TEXT,
            witness_contacted TEXT
        , latitude REAL, longitude REAL);
CREATE INDEX idx_month ON reports(month);
CREATE INDEX idx_council_area ON reports(council_area);
CREATE INDEX idx_offence ON reports(offence);
CREATE INDEX idx_disposal ON reports(disposal);
CREATE INDEX idx_location ON reports(offence_location);