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

565 rows where month = "2025-10" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make >30

reporter_transport_mode 8

offence 1

  • Driving without Due Care and Attention · 565 ✖

month 1

  • 2025-10 · 565 ✖
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      
22056 op-snap---monthly-publication-october-2025.pdf   6 2025-10 Car Audi A6 White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Court N/A   52.5359496 -1.8324115
22057 op-snap---monthly-publication-october-2025.pdf   7 2025-10 Car Ford Transit White Driving without Due Care and Attention None Bilston Street Island Bilston Street Island Wolverhampton Wolverhampton Education N/A   52.5834806 -2.1204011
22058 op-snap---monthly-publication-october-2025.pdf   8 2025-10 Car Audi SQ7 Blue Driving without Due Care and Attention None Bilston Street Bilston Street Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.5838892 -2.1231759
22062 op-snap---monthly-publication-october-2025.pdf   12 2025-10 Car Land Rover Defender Black Driving without Due Care and Attention None M6 Motorway M6 Motorway Sandwell Sandwell Court N/A      
22063 op-snap---monthly-publication-october-2025.pdf   13 2025-10 Pedal Bike Volkswagen Up White Driving without Due Care and Attention None Abbey Road Abbey Road Birmingham Birmingham Warning Letter N/A   52.5162302 -1.8593733
22064 op-snap---monthly-publication-october-2025.pdf   14 2025-10 Car Audi A3 White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
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      
22067 op-snap---monthly-publication-october-2025.pdf   17 2025-10 Car Nissan Micra Silver Driving without Due Care and Attention None M6 SB J6 M6 Southbound J6 Birmingham Birmingham NFA No Independent Evidence Available   52.676119 -2.0858425
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      
22072 op-snap---monthly-publication-october-2025.pdf   22 2025-10 Car BMW X5 Black Driving without Due Care and Attention None Styvechale Styvechale Coventry Coventry NFA No Offence   52.3834202 -1.5132278
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      
22079 op-snap---monthly-publication-october-2025.pdf   29 2025-10 Pedal Bike Mercedes-Benz E320 Silver Driving without Due Care and Attention None Valentine Road Valentine Road Birmingham Birmingham Education N/A   52.4381959 -1.8907391
22080 op-snap---monthly-publication-october-2025.pdf   30 2025-10 Car Toyota Aygo White Driving without Due Care and Attention None Haden Circus Haden Circus Birmingham Birmingham Education N/A   52.46284 -1.8867453
22081 op-snap---monthly-publication-october-2025.pdf   31 2025-10 Car Vauxhall Corsa White Driving without Due Care and Attention None Bordesley Green Road Bordesley Green Road Birmingham Birmingham NFA No Independent Evidence Available   52.4804926 -1.8563658
22082 op-snap---monthly-publication-october-2025.pdf   32 2025-10 Car Hyundai I10 Red Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
22083 op-snap---monthly-publication-october-2025.pdf   33 2025-10 Pedal Bike Nissan Note Blue Driving without Due Care and Attention None Inchlaggan Road Inchlaggan Road Wolverhampton Wolverhampton Education N/A   52.6049304 -2.10742
22084 op-snap---monthly-publication-october-2025.pdf   34 2025-10 Pedal Bike Volkswagen Passat Silver Driving without Due Care and Attention None Birchall Street Digbeth Birchall Street Digbeth Birmingham Birmingham Fixed Penalty N/A   52.4723412 -1.8874708
22088 op-snap---monthly-publication-october-2025.pdf   38 2025-10 Other Toyota Yaris Black Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Fixed Penalty N/A   52.4831397 -2.1309273
22090 op-snap---monthly-publication-october-2025.pdf   40 2025-10 Car Mercedes-Benz A180 White Driving without Due Care and Attention None Underhill Lane Bushbury Underhill Lane Bushbury Wolverhampton Wolverhampton Fixed Penalty N/A   52.6233052 -2.1008696
22091 op-snap---monthly-publication-october-2025.pdf   41 2025-10 Car S Sangyong Tivoli White Driving without Due Care and Attention None Lordswood Road, Harborne Lordswood Road, Harborne Birmingham Birmingham Warning Letter N/A   52.4591339 -1.9601054
22092 op-snap---monthly-publication-october-2025.pdf   42 2025-10 Car Mercedes-Benz C220 White Driving without Due Care and Attention None A452, Erdington A452, Erdington Birmingham Birmingham Warning Letter N/A   52.531984 -1.8259343
22093 op-snap---monthly-publication-october-2025.pdf   43 2025-10 Other Mercedes-Benz E220 Grey Driving without Due Care and Attention None Waterfront main Car Park Waterfront main Car Park Dudley Dudley Warning Letter N/A      
22099 op-snap---monthly-publication-october-2025.pdf   49 2025-10 Pedal Bike Ford B Max Black Driving without Due Care and Attention None Umberslade Road Umberslade Road Birmingham Birmingham Education N/A   52.4304526 -1.9216716
22102 op-snap---monthly-publication-october-2025.pdf   52 2025-10 Pedal Bike BMW 435.. Black Driving without Due Care and Attention None Allesley Road Allesley Road Coventry Coventry NFA Outside of 14 Days NIP   52.412663 -1.5443742
22110 op-snap---monthly-publication-october-2025.pdf   60 2025-10 Pedal Bike Volkswagen Transporter Grey Driving without Due Care and Attention None Earlsdon Av Earlsdon Avenue Coventry Coventry Education N/A   52.4047134 -1.5351834
22112 op-snap---monthly-publication-october-2025.pdf   62 2025-10 Pedal Bike Audi Q2 Grey Driving without Due Care and Attention None Five Ways Roundabout Five Ways Roundabout Birmingham Birmingham Education N/A      
22115 op-snap---monthly-publication-october-2025.pdf   65 2025-10 Car Ford Transit Silver Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham NFA No Offence      
22116 op-snap---monthly-publication-october-2025.pdf   66 2025-10 Car Ford Transit Silver Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham NFA No Offence      
22117 op-snap---monthly-publication-october-2025.pdf   67 2025-10 Car Volkswagen Golf Grey Driving without Due Care and Attention None A435 A435 Birmingham Birmingham NFA Outside of 14 Days NIP      
22118 op-snap---monthly-publication-october-2025.pdf   68 2025-10 Car BMW X3 Grey Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham Warning Letter N/A      
22119 op-snap---monthly-publication-october-2025.pdf   69 2025-10 Car Fiat Panda White Driving without Due Care and Attention None Knighton Road Knighton Road Birmingham Birmingham Education N/A   52.5982705 -1.8541228
22121 op-snap---monthly-publication-october-2025.pdf   71 2025-10 Car Hyundai Kona silver Driving without Due Care and Attention None Gravelly Hill Gravelly Hill Birmingham Birmingham Fixed Penalty n/a   52.5153884 -1.8527437
22122 op-snap---monthly-publication-october-2025.pdf   72 2025-10 Pedal Bike Skoda Octavia Silver Driving without Due Care and Attention None Hurst Road Hurst Road Coventry Coventry NFA No Offence   52.4496884 -1.4816181
22123 op-snap---monthly-publication-october-2025.pdf   73 2025-10 Other Vauxhall Corsa Silver Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Fixed Penalty N/A   52.4831397 -2.1309273
22125 op-snap---monthly-publication-october-2025.pdf   75 2025-10 Car Mg HS Silver Driving without Due Care and Attention None Portway Hill Portway Hill Sandwell Sandwell Fixed Penalty N/A   52.4990342 -2.0424359
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      
22128 op-snap---monthly-publication-october-2025.pdf   78 2025-10 Car Vauxhall Combo White Driving without Due Care and Attention None Lozells Road Lozells Road Birmingham Birmingham NFA No Offence   52.502683 -1.9033516
22135 op-snap---monthly-publication-october-2025.pdf   85 2025-10 Car Ford Mondeo Silver Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Court N/A   52.4103191 -1.8670224
22139 op-snap---monthly-publication-october-2025.pdf   89 2025-10 Car Mercedes-Benz A180 Grey Driving without Due Care and Attention None Holyhead Road Holyhead Road Birmingham Birmingham Warning Letter N/A   52.505233 -1.9446276
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      
22142 op-snap---monthly-publication-october-2025.pdf   92 2025-10 Car Audi A6 grey Driving without Due Care and Attention None Lea Road Lea Road Wolverhampton Wolverhampton Warning Letter N/A   52.5780818 -2.135334
22144 op-snap---monthly-publication-october-2025.pdf   94 2025-10 Car Vauxhall Mokka Red Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
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      
22147 op-snap---monthly-publication-october-2025.pdf   97 2025-10 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None A456 Halesowen Halesowen Dudley Dudley Warning Letter N/A   52.4492074 -2.0514646
22154 op-snap---monthly-publication-october-2025.pdf   104 2025-10 Car Land Rover Sport Black Driving without Due Care and Attention None A456 A456 Dudley Dudley Warning Letter N/A      
22156 op-snap---monthly-publication-october-2025.pdf   106 2025-10 Pedal Bike Land Rover Sport Black Driving without Due Care and Attention None Streetsbrook Road, Shirley Streetsbrook Road, Shirley Solihull Solihull Court N/A   52.4223176 -1.8253145
22157 op-snap---monthly-publication-october-2025.pdf   107 2025-10 Pedal Bike Mazda 3 Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Sutton Coldfield Sutton Coldfield NFA No Offence   52.5872149 -1.8300386
22158 op-snap---monthly-publication-october-2025.pdf   108 2025-10 Car Volkswagen Golf Black Driving without Due Care and Attention None Connaught Road Connaught Road Wolverhampton Wolverhampton Education N/A   52.5876226 -2.1426533
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
22160 op-snap---monthly-publication-october-2025.pdf   110 2025-10 Car Isuzu Trucks White Driving without Due Care and Attention None Grange Island Grange Island Dudley Dudley Fixed Penalty N/A      
22161 op-snap---monthly-publication-october-2025.pdf   111 2025-10 Car Mercedes-Benz C300 White Driving without Due Care and Attention None A38 Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
22165 op-snap---monthly-publication-october-2025.pdf   115 2025-10 Car Audi A3 Grey Driving without Due Care and Attention None City Road City Road Birmingham Birmingham Education N/A   52.4763176 -1.9584897
22171 op-snap---monthly-publication-october-2025.pdf   121 2025-10 Pedestrian Yamaha GPD 125 White Driving without Due Care and Attention None Lyon Queensway Lyon Queensway Birmingham Birmingham Education N/A   52.4785129 -1.9047486
22174 op-snap---monthly-publication-october-2025.pdf   124 2025-10 Car Mini Mini Grey Driving without Due Care and Attention None Dudley Road Dudley Road Sandwell Sandwell NFA Outside of 14 DAYS Late Submission   52.4877352 -1.9494469
22175 op-snap---monthly-publication-october-2025.pdf   125 2025-10 Motorbike BMW 330d White Driving without Due Care and Attention None A46 Evesham Evesham Out of Force Area Out of Force Area NFA Out of Force   52.3837388 -1.5529669
22184 op-snap---monthly-publication-october-2025.pdf   134 2025-10 Car Citroen C4 Blue Driving without Due Care and Attention None Essington Road New Invention Essington Road New Invention Wolverhampton Wolverhampton NFA No VRM      
22185 op-snap---monthly-publication-october-2025.pdf   135 2025-10 Car BMW   Black Driving without Due Care and Attention None Church Hill Road Church Hill Road Solihull Solihull Court N/A   52.4078582 -1.7777439
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
22195 op-snap---monthly-publication-october-2025.pdf   145 2025-10 Pedal Bike Dennis Alexander White Driving without Due Care and Attention None Sharmans Cross Sharmans Cross Solihull Solihull NFA Outside of 14 Days NIP   52.4151594 -1.8062462
22196 op-snap---monthly-publication-october-2025.pdf   146 2025-10 Pedal Bike Renault Modus Silver Driving without Due Care and Attention None Stroud Road Stroud Road Solihull Solihull NFA Outside of 14 Days NIP   52.4085712 -1.8432138
22197 op-snap---monthly-publication-october-2025.pdf   147 2025-10 Car Land Rover Land Rover Grey Driving without Due Care and Attention None Old Snow Hill Old Snow Hill Birmingham Birmingham NFA No Offence   52.4858844 -1.9003652
22199 op-snap---monthly-publication-october-2025.pdf   149 2025-10 Car Vauxhall Astra Red Driving without Due Care and Attention None Thorns Road Thorns Road Dudley Dudley Warning Letter N/A   52.4628538 -2.1160108
22200 op-snap---monthly-publication-october-2025.pdf   150 2025-10 Car Ford Focus Blue Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley RTC - Actioned N/A   52.4879006 -2.1188734
22201 op-snap---monthly-publication-october-2025.pdf   151 2025-10 Pedestrian Mazda 2 Black Driving without Due Care and Attention None Lower High Street, Stourbridge Lower High Street, Stourbridge Dudley Dudley Court N/A   52.4586871 -2.1483642
22202 op-snap---monthly-publication-october-2025.pdf   152 2025-10 Other Suzuki   Green Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
22203 op-snap---monthly-publication-october-2025.pdf   153 2025-10 Car Renault Megane White Driving without Due Care and Attention None Black Country Route Black Country Route Wolverhampton Wolverhampton Fixed Penalty N/A   52.5642677 -2.0755469
22204 op-snap---monthly-publication-october-2025.pdf   154 2025-10 Pedal Bike   Bus Grey Driving without Due Care and Attention None White Street White Street Birmingham Birmingham NFA No VRM   52.4555554 -1.8782841
22205 op-snap---monthly-publication-october-2025.pdf   155 2025-10 Other   SMC White Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Court N/A      
22209 op-snap---monthly-publication-october-2025.pdf   159 2025-10 Car Scania   White Driving without Due Care and Attention None M6 Junction 8 M6 Junction 8 Birmingham Birmingham Fixed Penalty N/A   52.6912891 -2.1046372
22210 op-snap---monthly-publication-october-2025.pdf   160 2025-10 Pedestrian   Subara Blue Driving without Due Care and Attention None Tesco Car Park, Stourbridge Tesco Car Park, Stourbridge Dudley Dudley NFA Outside of 14 Days NIP   52.4530893 -2.0628772
22212 op-snap---monthly-publication-october-2025.pdf   162 2025-10 Car Toyota C-HR Black Driving without Due Care and Attention None Radford Road Radford Road Coventry Coventry NFA Outside of 14 Days NIP   52.4235908 -1.5226276
22213 op-snap---monthly-publication-october-2025.pdf   163 2025-10 Car Volkswagen   Grey Driving without Due Care and Attention None Ring Road Ring Road Coventry Coventry NFA Outside of 14 DAYS Late Submission      
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      
22215 op-snap---monthly-publication-october-2025.pdf   165 2025-10 Car BMW 320d Blue Driving without Due Care and Attention None Great Barr St Great Barr Street Birmingham Birmingham Warning Letter N/A   52.4795188 -1.8770102
22218 op-snap---monthly-publication-october-2025.pdf   168 2025-10 Car Ford   Black Driving without Due Care and Attention None A491 High Street Stourbridge High Street Stourbridge Dudley Dudley Court N/A   52.4570763 -2.1136199
22219 op-snap---monthly-publication-october-2025.pdf   169 2025-10 Car Toyota Yaris Grey Driving without Due Care and Attention None A491 High Street Stourbridge High Street Stourbridge Dudley Dudley NFA Not in Public Interest   52.4570763 -2.1136199
22222 op-snap---monthly-publication-october-2025.pdf   172 2025-10 Car Toyota Auris Silver Driving without Due Care and Attention None Wood Green Road Wood Green Road Walsall Walsall NFA No Offence   52.6248989 -1.9343969
22224 op-snap---monthly-publication-october-2025.pdf   174 2025-10 Car BMW   Blue Driving without Due Care and Attention None Upper Eastern Green Lane, Upper Eastern Green Lane Coventry Coventry NFA No VRM   52.4171593 -1.5860076
22228 op-snap---monthly-publication-october-2025.pdf   178 2025-10 Car BMW 320D White Driving without Due Care and Attention None Anderton Road Anderton Road Coventry Coventry NFA Outside of 14 Days NIP   52.4519205 -1.4736655
22229 op-snap---monthly-publication-october-2025.pdf   179 2025-10 Car Volvo V40 Blue Driving without Due Care and Attention None A4540 Monument Road Monument Road Birmingham Birmingham NFA No Offence   52.4731312 -1.930947
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      
22233 op-snap---monthly-publication-october-2025.pdf   183 2025-10 Car Toyota   Black Driving without Due Care and Attention None Broadway West Broadway West Walsall Walsall Education N/A   52.5698309 -1.9942176
22235 op-snap---monthly-publication-october-2025.pdf   185 2025-10 Pedestrian     White Driving without Due Care and Attention None Newtown Newtown Birmingham Birmingham NFA No Independent Evidence Available   52.4978509 -1.8963733
22237 op-snap---monthly-publication-october-2025.pdf   187 2025-10 Pedal Bike BMW 320.. Black Driving without Due Care and Attention None Longford Road Longford Road Birmingham Birmingham Education N/A   52.5524121 -1.8764968
22240 op-snap---monthly-publication-october-2025.pdf   190 2025-10 Car Suzuki Swift White Driving without Due Care and Attention None Boldmere Road Boldmere Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.548309 -1.8411769
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
22246 op-snap---monthly-publication-october-2025.pdf   196 2025-10 Car Nissan Qashqai Silver Driving without Due Care and Attention None Wolverhampton Road East Wolverhampton Road East Dudley Dudley Warning Letter N/A      
22247 op-snap---monthly-publication-october-2025.pdf   197 2025-10 Car Ford Fiesta Blue Driving without Due Care and Attention None Castel Gate Island Castel Gate Island Dudley Dudley Fixed Penalty N/A      
22248 op-snap---monthly-publication-october-2025.pdf   198 2025-10 Car Audi Q4 Blue Driving without Due Care and Attention None Meadway Meadway Birmingham Birmingham Education N/A   52.4783348 -1.8007708
22249 op-snap---monthly-publication-october-2025.pdf   199 2025-10 Car Ford Focus Silver Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
22250 op-snap---monthly-publication-october-2025.pdf   200 2025-10 Car Mercedes-Benz Citan White Driving without Due Care and Attention No Insurance Rotton Park Road Rotton Park Road Birmingham Birmingham Court N/A   52.4851072 -1.9468115
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      
22255 op-snap---monthly-publication-october-2025.pdf   205 2025-10 car Audi A3 White Driving without Due Care and Attention None Three Tuns Island Three Tuns Island Birmingham Birmingham NFA No Offence      
22256 op-snap---monthly-publication-october-2025.pdf   206 2025-10 Car BMW 330 Sport Grey Driving without Due Care and Attention None Stafford Road Stafford Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission   52.6291998 -2.126312
22259 op-snap---monthly-publication-october-2025.pdf   209 2025-10 Car Audi A6 Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
22260 op-snap---monthly-publication-october-2025.pdf   210 2025-10 Car Mercedes-Benz E63 S Black Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham NFA No Independent Evidence Available   52.5517052 -1.7825505
22261 op-snap---monthly-publication-october-2025.pdf   211 2025-10 Car BMW 3 series Grey Driving without Due Care and Attention None Bosworth Road Bosworth Road Birmingham Birmingham NFA No Independent Evidence Available   52.4515515 -1.8074346

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