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'}

129 rows where council_area = "Out of Force Area", disposal = "NFA" and month = "2025-12" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

reporter_transport_mode 9

month 1

  • 2025-12 · 129 ✖

disposal 1

  • NFA · 129 ✖

council_area 1

  • Out of Force Area · 129 ✖
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
3872 op-snap---monthly-publication-december-2025.pdf   0 2025-12 Car Mitsubishi   Silver Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger None A366 A366 Out of Force Area Out of Force Area NFA Out of Force      
3873 op-snap---monthly-publication-december-2025.pdf   1 2025-12 Car Skoda Octavia Grey Contravening a Red Traffic Light None M42 Jct 10 M42 Junction 10 Out of Force Area Out of Force Area NFA Out of Force      
3900 op-snap---monthly-publication-december-2025.pdf   28 2025-12 Car Fiat 500 White Misc - Non Traffic Offences None M5, worcestershire M5, worcestershire Out of Force Area Out of Force Area NFA No VRM   52.432364 -2.0176127
3946 op-snap---monthly-publication-december-2025.pdf   74 2025-12 Pedestrian       Misc - Non Traffic Offences None Himley Road Himley Road Out of Force Area Out of Force Area NFA Out of Force   52.5130072 -2.09584
3982 op-snap---monthly-publication-december-2025.pdf   110 2025-12 Car Byd Seal Black Driving without Due Care and Attention None Claredon Road Watford Claredon Road Watford Out of Force Area Out of Force Area NFA Out of Force      
3994 op-snap---monthly-publication-december-2025.pdf   122 2025-12 Pedal Bike Kia Sportage Blue Driving without Due Care and Attention None Cressage Cressage Out of Force Area Out of Force Area NFA Out of Force   52.40435 -1.9677367
3995 op-snap---monthly-publication-december-2025.pdf   123 2025-12 Pedal Bike Volkswagen   Red Driving without Due Care and Attention None Atcham Atcham Out of Force Area Out of Force Area NFA Out of Force      
3999 op-snap---monthly-publication-december-2025.pdf   127 2025-12 Car   Bentley Grey Using a Mobile Phone Whilst Driving None M42 West Mercia M42 West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4040 op-snap---monthly-publication-december-2025.pdf   168 2025-12 Car BMW X1 White Driving without Due Care and Attention None A46 A46 Out of Force Area Out of Force Area NFA Out of Force      
4048 op-snap---monthly-publication-december-2025.pdf   176 2025-12 Car Nissan Qashqai Red Driving without Due Care and Attention None Lytton Way, Stevenage Lytton Way, Stevenage Out of Force Area Out of Force Area NFA Out of Force      
4052 op-snap---monthly-publication-december-2025.pdf   180 2025-12 Car Vauxhall   Black Driving without Due Care and Attention None Whitecross Road Whitecross Road Out of Force Area Out of Force Area NFA Out of Force      
4055 op-snap---monthly-publication-december-2025.pdf   183 2025-12 Pedestrian Ford   Yellow Using a Mobile Phone Whilst Driving None Mallards Close Mallards Close Out of Force Area Out of Force Area NFA Out of Force      
4057 op-snap---monthly-publication-december-2025.pdf   185 2025-12 Car Scania HGV White Driving without Due Care and Attention None M6 Jn11 M6 Jn11 Out of Force Area Out of Force Area NFA Out of Force   52.5145911 -1.8679162
4059 op-snap---monthly-publication-december-2025.pdf   187 2025-12 Car Vauxhall Vivaro Grey Using a Mobile Phone Whilst Driving None M1 / M45 Watford Gap M1 / M45 Watford Gap Out of Force Area Out of Force Area NFA Out of Force      
4066 op-snap---monthly-publication-december-2025.pdf   194 2025-12 Car Mercedes-Benz E220 black Driving without Due Care and Attention None Warwick Bypass Warwick Bypass Out of Force Area Out of Force Area NFA Out of Force   52.4020704 -1.7491448
4074 op-snap---monthly-publication-december-2025.pdf   202 2025-12 Car Seat Ibiza Red Driving without Due Care and Attention None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
4078 op-snap---monthly-publication-december-2025.pdf   206 2025-12 Car BMW 320 Black Driving without Due Care and Attention None M1 M1 Out of Force Area Out of Force Area NFA Out of Force      
4080 op-snap---monthly-publication-december-2025.pdf   208 2025-12 Pedal Bike BMW   White Driving without Due Care and Attention None B5063 West Mercia West Mercia Out of Force Area Out of Force Area NFA Out of Force   52.5827653 -2.0983246
4081 op-snap---monthly-publication-december-2025.pdf   209 2025-12 car Vauxhall Mokka Grey Driving without Due Care and Attention None Stratford Road, Warwick Stratford Road, Warwick Out of Force Area Out of Force Area NFA Out of Force   52.4571106 -1.8678213
4082 op-snap---monthly-publication-december-2025.pdf   210 2025-12 Pedal Bike BMW   White Driving without Due Care and Attention None B5063 West Mercia West Mercia Out of Force Area Out of Force Area NFA Duplicate Submission   52.5827653 -2.0983246
4083 op-snap---monthly-publication-december-2025.pdf   211 2025-12 Car Scania   White Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway None M42 M42 Out of Force Area Out of Force Area NFA Out of Force      
4085 op-snap---monthly-publication-december-2025.pdf   213 2025-12 Car Mercedes-Benz   Black Driving without Due Care and Attention None M25 M25 Out of Force Area Out of Force Area NFA Out of Force      
4091 op-snap---monthly-publication-december-2025.pdf   219 2025-12 Car Mini Cooper Red Driving without Due Care and Attention None Stourbridge Road West Mercia Stourbridge Road West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4100 op-snap---monthly-publication-december-2025.pdf   228 2025-12 Car Land Rover Discovery Grey Driving without Due Care and Attention None Heathcote Lane Heathcote Lane Out of Force Area Out of Force Area NFA Out of Force      
4148 op-snap---monthly-publication-december-2025.pdf   276 2025-12 Car Volkswagen   Silver Driving without Due Care and Attention None Kings Acre Road Kings Acre Road Out of Force Area Out of Force Area NFA Out of Force      
4149 op-snap---monthly-publication-december-2025.pdf   277 2025-12 Pedestrian Honda Motorbike NSS Blue Drive / Ride / Lead an animal on a footpath None Whitington Whitington Out of Force Area Out of Force Area NFA Out of Force      
4192 op-snap---monthly-publication-december-2025.pdf   320 2025-12 Other Daf Lorry Black Using a Mobile Phone Whilst Driving No Insurance Motorway unknown Motorway unknown Out of Force Area Out of Force Area NFA No Independent Evidence Available      
4197 op-snap---monthly-publication-december-2025.pdf   325 2025-12 Car Suzuki Swift Black Driving without Due Care and Attention None A519 A519 Out of Force Area Out of Force Area NFA Out of Force      
4202 op-snap---monthly-publication-december-2025.pdf   330 2025-12 Car Nissan Qashqai White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Heronswood Road Heronswood Road Out of Force Area Out of Force Area NFA Out of Force   52.3873141 -2.0016866
4203 op-snap---monthly-publication-december-2025.pdf   331 2025-12 Car Ford Transit White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Heronswood Road Heronswood Road Out of Force Area Out of Force Area NFA Out of Force   52.3873141 -2.0016866
4204 op-snap---monthly-publication-december-2025.pdf   332 2025-12 Car BMW 1 Series Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Heronswood Road Heronswood Road Out of Force Area Out of Force Area NFA Out of Force   52.3873141 -2.0016866
4205 op-snap---monthly-publication-december-2025.pdf   333 2025-12 Car Nissan Juke Yellow Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Heronswood Road Heronswood Road Out of Force Area Out of Force Area NFA Out of Force   52.3873141 -2.0016866
4214 op-snap---monthly-publication-december-2025.pdf   342 2025-12 Pedestrian BMW 3 Series Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Caroline Close Caroline Close Out of Force Area Out of Force Area NFA Out of Force   52.5172414 -1.9775684
4287 op-snap---monthly-publication-december-2025.pdf   415 2025-12 Car BMW 520.. Grey Driving without Due Care and Attention None Houlton Way Houlton Way Out of Force Area Out of Force Area NFA Out of Force      
4311 op-snap---monthly-publication-december-2025.pdf   439 2025-12 Pedal Bike Ford Fiesta Red Driving without Due Care and Attention None Hereford Road Shrewsbury Hereford Road Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
4390 op-snap---monthly-publication-december-2025.pdf   518 2025-12 car Mercedes-Benz   Black Contravening a Red Traffic Light None Manchester Manchester Out of Force Area Out of Force Area NFA Out of Force   52.4908553 -1.8943638
4405 op-snap---monthly-publication-december-2025.pdf   533 2025-12 Car Toyota C-HR Silver Driving without Due Care and Attention None Telford, off M54 jn 4 Telford, off M54 jn 4 Out of Force Area Out of Force Area NFA Out of Force      
4412 op-snap---monthly-publication-december-2025.pdf   540 2025-12 Car Honda CR-V Black Using a Mobile Phone Whilst Driving No Insurance Battlefield Road Battlefield Road Out of Force Area Out of Force Area NFA Out of Force      
4417 op-snap---monthly-publication-december-2025.pdf   545 2025-12 Horse Rider Volkswagen Amarok Black Driving without Due Care and Attention None Green Street, Worcestershire Green Street, Worcestershire Out of Force Area Out of Force Area NFA Out of Force      
4436 op-snap---monthly-publication-december-2025.pdf   564 2025-12 Car Daf   White Contravening a Red Traffic Light None A44 Pershore Pershore Out of Force Area Out of Force Area NFA Out of Force      
4450 op-snap---monthly-publication-december-2025.pdf   578 2025-12 Car BMW Mini Black Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Long Street, Atherstone Long Street, Atherstone Out of Force Area Out of Force Area NFA Out of Force      
4452 op-snap---monthly-publication-december-2025.pdf   580 2025-12 Car Skoda Kodiaq Grey Driving without Due Care and Attention None Festival Way, Stoke Festival Way, Stoke Out of Force Area Out of Force Area NFA Out of Force      
4461 op-snap---monthly-publication-december-2025.pdf   589 2025-12 Car Mercedes-Benz   White Misc - Non Traffic Offences None OOF- Shrewsbury OOF- Shrewsbury Out of Force Area Out of Force Area NFA Out of Force      
4473 op-snap---monthly-publication-december-2025.pdf   601 2025-12 Car Hyundai Tucson Black Driving without Due Care and Attention None Robin Hood Way, Nottingham Robin Hood Way, Nottingham Out of Force Area Out of Force Area NFA Out of Force      
4481 op-snap---monthly-publication-december-2025.pdf   609 2025-12 Car Toyota Corolla Blue Misc - Non Traffic Offences None M5 West Mercia M5 West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4494 op-snap---monthly-publication-december-2025.pdf   622 2025-12 Car Renault Master White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None OOF Worcester OOF Worcester Out of Force Area Out of Force Area NFA Out of Force      
4495 op-snap---monthly-publication-december-2025.pdf   623 2025-12 Car Fiat   Grey Misc - Non Traffic Offences None OOF Warwickshire OOF Warwickshire Out of Force Area Out of Force Area NFA Out of Force      
4509 op-snap---monthly-publication-december-2025.pdf   637 2025-12 Car Vauxhall corsa Grey Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
4520 op-snap---monthly-publication-december-2025.pdf   648 2025-12 Car BMW 520 Grey Driving without Due Care and Attention None M1 J23 M1 J23 Out of Force Area Out of Force Area NFA Out of Force      
4521 op-snap---monthly-publication-december-2025.pdf   649 2025-12 Car     White Driving without Due Care and Attention None Albrighton Albrighton Out of Force Area Out of Force Area NFA Out of Force   52.4450589 -2.0668857
4532 op-snap---monthly-publication-december-2025.pdf   660 2025-12 Car Audi A6.. White Contravening a Red Traffic Light None M42 Jct 3 M42 Junction 3 Out of Force Area Out of Force Area NFA Out of Force      
4534 op-snap---monthly-publication-december-2025.pdf   662 2025-12 Car Vauxhall Corsa Blue Misc - Non Traffic Offences None Lickey Lane West Mercia Lickey Lane West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4535 op-snap---monthly-publication-december-2025.pdf   663 2025-12 Car BMW 120 Grey Driving without Due Care and Attention None Sanley Park Road, Croydon Sanley Park Road, Croydon Out of Force Area Out of Force Area NFA Out of Force      
4567 op-snap---monthly-publication-december-2025.pdf   695 2025-12 Car Tesla Model Y Grey Contravening a Red Traffic Light None M5 Jn 6. West Mercia M5 Junction 6. West Mercia Out of Force Area Out of Force Area NFA Out of Force      
4580 op-snap---monthly-publication-december-2025.pdf   708 2025-12 Car Kia XCeed Black Driving without Due Care and Attention None A53 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force   52.6195535 -2.0193824
4602 op-snap---monthly-publication-december-2025.pdf   730 2025-12 Pedestrian Renault Clio Black Driving without Due Care and Attention None Shrewsbury Road Shrewsbury Road Out of Force Area Out of Force Area NFA Out of Force      
4605 op-snap---monthly-publication-december-2025.pdf   733 2025-12 Car Vauxhall Insignia Silver Driving without Due Care and Attention None Smith Street Smith Street Out of Force Area Out of Force Area NFA Out of Force   52.4915488 -1.9079339
4628 op-snap---monthly-publication-december-2025.pdf   756 2025-12 Car Renault Captur Black Using a Mobile Phone Whilst Driving None M5 Southbound, jn 6 to 7 M5 Southbound, jn 6 to 7 Out of Force Area Out of Force Area NFA Out of Force      
4631 op-snap---monthly-publication-december-2025.pdf   759 2025-12 Car Skoda Fabia White Driving without Due Care and Attention None M40 M40 Out of Force Area Out of Force Area NFA Out of Force      
4635 op-snap---monthly-publication-december-2025.pdf   763 2025-12 Car Land Rover Freelander Gold Driving without Due Care and Attention None Qeensway Telford Qeensway Telford Out of Force Area Out of Force Area NFA Out of Force      
4643 op-snap---monthly-publication-december-2025.pdf   771 2025-12 Car Audi   Black Driving without Due Care and Attention None Marlborough Way Marlborough Way Out of Force Area Out of Force Area NFA Out of Force      
4660 op-snap---monthly-publication-december-2025.pdf   788 2025-12 Car Renault Arkana Grey Driving without Due Care and Attention None A5 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force   52.6195535 -2.0193824
4661 op-snap---monthly-publication-december-2025.pdf   789 2025-12 Car   HGV Red Driving without Due Care and Attention None Womborne Womborne Out of Force Area Out of Force Area NFA No VRM      
4669 op-snap---monthly-publication-december-2025.pdf   797 2025-12 Pedestrian BMW 1 Series Silver Misc - Non Traffic Offences None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
4670 op-snap---monthly-publication-december-2025.pdf   798 2025-12 Pedestrian BMW 3 Series Black Misc - Non Traffic Offences None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
4671 op-snap---monthly-publication-december-2025.pdf   799 2025-12 Pedestrian Audi A4 Grey Misc - Non Traffic Offences None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
4678 op-snap---monthly-publication-december-2025.pdf   806 2025-12 Car Hyundai I10 White Driving without Due Care and Attention None Regents Park Road Bromsgrove Regents Park Road Bromsgrove Out of Force Area Out of Force Area NFA Out of Force      
4685 op-snap---monthly-publication-december-2025.pdf   813 2025-12 Pedestrian Tesla Model 3 Black Misc - Non Traffic Offences None Centurion Drive Worcester Centurion Drive Worcester Out of Force Area Out of Force Area NFA Out of Force      
4714 op-snap---monthly-publication-december-2025.pdf   842 2025-12 Car BMW 840i Red Misc - Non Traffic Offences None B6049 Hope, Sheffield Hope, Sheffield Out of Force Area Out of Force Area NFA Out of Force      
4722 op-snap---monthly-publication-december-2025.pdf   850 2025-12 Lorry Ford Transit Grey Driving without Due Care and Attention None M54 j4 M54 j4 Out of Force Area Out of Force Area NFA Out of Force      
4755 op-snap---monthly-publication-december-2025.pdf   883 2025-12 Car Audi A1 Black Driving without Due Care and Attention None Tamworth Tamworth Out of Force Area Out of Force Area NFA Out of Force   52.5724303 -1.8191247
4759 op-snap---monthly-publication-december-2025.pdf   887 2025-12 Car Toyota Prius Silver Driving without Due Care and Attention None Chester Road Chester Road Out of Force Area Out of Force Area NFA Out of Force   52.5359496 -1.8324115
4764 op-snap---monthly-publication-december-2025.pdf   892 2025-12 Car   np White Driving without Due Care and Attention None M1 M1 Out of Force Area Out of Force Area NFA Out of Force      
4782 op-snap---monthly-publication-december-2025.pdf   910 2025-12 Car BMW X1 Black Driving without Due Care and Attention None Worcester Worcester Out of Force Area Out of Force Area NFA Out of Force   52.3101165 -2.0442678
4784 op-snap---monthly-publication-december-2025.pdf   912 2025-12 Car Yamaha MT125 Grey Driving without Due Care and Attention None Cannock Road, Burntwood, Staffs Cannock Road, Burntwood, Staffs Out of Force Area Out of Force Area NFA Out of Force      
4790 op-snap---monthly-publication-december-2025.pdf   918 2025-12 Car   Motorbike Black Contravening a Red Traffic Light None School Road, Nuneaton School Road, Nuneaton Out of Force Area Out of Force Area NFA Out of Force      
4797 op-snap---monthly-publication-december-2025.pdf   925 2025-12 Car Toyota Corolla Grey Using a Mobile Phone Whilst Driving None M40 near Banbury M40 near Banbury Out of Force Area Out of Force Area NFA Out of Force      
4804 op-snap---monthly-publication-december-2025.pdf   932 2025-12 Car Vauxhall Mokka Silver Driving without Due Care and Attention None Mallard Hill Mallard Hill Out of Force Area Out of Force Area NFA Out of Force   52.4655481 -2.127581
4805 op-snap---monthly-publication-december-2025.pdf   933 2025-12 Car Audi A1 Black Driving without Due Care and Attention None Tamworth Tamworth Out of Force Area Out of Force Area NFA Out of Force   52.5724303 -1.8191247
4809 op-snap---monthly-publication-december-2025.pdf   937 2025-12 Van Peugeot 308 Silver Driving without Due Care and Attention None off force Off Force Out of Force Area Out of Force Area NFA Out of Force      
4822 op-snap---monthly-publication-december-2025.pdf   950 2025-12 Car   Ford White Using a Mobile Phone Whilst Driving Driving without Due Care and M At2t5ention M At2t5ention Out of Force Area Out of Force Area NFA Out of Force      
4829 op-snap---monthly-publication-december-2025.pdf   957 2025-12 Car Citroen   White Driving without Due Care and Attention None Somewhere in Newark? Somewhere in Newark? Out of Force Area Out of Force Area NFA Out of Force      
4836 op-snap---monthly-publication-december-2025.pdf   964 2025-12 Car Land Rover Sport Blue Using a Mobile Phone Whilst Driving No Insurance M42, nothing more specific M42, nothing more specific Out of Force Area Out of Force Area NFA Out of Force      
4837 op-snap---monthly-publication-december-2025.pdf   965 2025-12 Car Volkswagen   Red Using a Mobile Phone Whilst Driving None Warrington Warrington Out of Force Area Out of Force Area NFA Out of Force   52.5389668 -1.856967
4844 op-snap---monthly-publication-december-2025.pdf   972 2025-12 Car   Scooter Grey Misc - Non Traffic Offences None Hereford Hereford Out of Force Area Out of Force Area NFA Out of Force   52.4047807 -2.0101216
4849 op-snap---monthly-publication-december-2025.pdf   977 2025-12 Car Ford Fiesta Red Driving without Due Care and Attention None Ring Road, Kidderminster Ring Road, Kidderminster Out of Force Area Out of Force Area NFA Out of Force      
4850 op-snap---monthly-publication-december-2025.pdf   978 2025-12 Car Volkswagen Golf Blue Driving without Due Care and Attention None Lichfield Road, Coleshill Lichfield Road, Coleshill Out of Force Area Out of Force Area NFA Out of Force      
4851 op-snap---monthly-publication-december-2025.pdf   979 2025-12 Car Ford Fiesta White Driving without Due Care and Attention None Ledbury Ledbury Out of Force Area Out of Force Area NFA Out of Force   52.5415939 -1.7925369
4853 op-snap---monthly-publication-december-2025.pdf   981 2025-12 Car Land Rover Defender Grey Driving without Due Care and Attention VRM fails to conform to Regu Mlat5io jn4s Mlat5io jn4s Out of Force Area Out of Force Area NFA Out of Force      
4856 op-snap---monthly-publication-december-2025.pdf   984 2025-12 Car Audi A4 Black Driving without Due Care and Attention None M5 Worcester M5 Worcester Out of Force Area Out of Force Area NFA Out of Force   52.5908671 -1.8140277
4863 op-snap---monthly-publication-december-2025.pdf   991 2025-12 Car Mercedes-Benz   Silver Driving without Due Care and Attention None Out of force Out of force Out of Force Area Out of Force Area NFA Out of Force      
4870 op-snap---monthly-publication-december-2025.pdf   998 2025-12 Car Land Rover defender Grey Driving without Due Care and Attention None Warwick Warwick Out of Force Area Out of Force Area NFA Out of Force   52.3813073 -1.5639569
4883 op-snap---monthly-publication-december-2025.pdf   1011 2025-12 Car Volkswagen Crafter white Using a Mobile Phone Whilst Driving None M5 jn4-jn5 M5 jn4-jn5 Out of Force Area Out of Force Area NFA Out of Force      
4884 op-snap---monthly-publication-december-2025.pdf   1012 2025-12 Lorry Ford Connect White Driving without Due Care and Attention None Carrington Lane, Manchester Carrington Lane, Manchester Out of Force Area Out of Force Area NFA Out of Force      
4885 op-snap---monthly-publication-december-2025.pdf   1013 2025-12 Car Toyota Auris Black Using a Mobile Phone Whilst Driving None A6 in Leicester A6 in Leicester Out of Force Area Out of Force Area NFA Out of Force      
4888 op-snap---monthly-publication-december-2025.pdf   1016 2025-12 Bus Ford Fiesta Orange Driving without Due Care and Attention None Motorway near Manchester Motorway near Manchester Out of Force Area Out of Force Area NFA Out of Force      
4892 op-snap---monthly-publication-december-2025.pdf   1020 2025-12 Car Ford Transit White Driving without Due Care and Attention None St George's Road, Telford Street George's Road, Telford Out of Force Area Out of Force Area NFA Out of Force      
4897 op-snap---monthly-publication-december-2025.pdf   1025 2025-12 Car Mercedes-Benz V-class Silver Driving without Due Care and Attention None Pye Green Road, Cannock Pye Green Road, Cannock Out of Force Area Out of Force Area NFA Out of Force      
4901 op-snap---monthly-publication-december-2025.pdf   1029 2025-12 Car Renault Kangoo White Driving without Due Care and Attention None M1 Luton M1 Luton Out of Force Area Out of Force Area NFA Out of Force   52.4460842 -1.9286676
4907 op-snap---monthly-publication-december-2025.pdf   1035 2025-12 Car BMW X3 Blue Driving without Due Care and Attention None A46 in Nottinghamshire A46 in Nottinghamshire Out of Force Area Out of Force Area NFA Out of Force      

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);