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

441 rows where vehicle_make = "Kia" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

offence >30

month 14

reporter_transport_mode 9

vehicle_make 1

  • Kia · 441 ✖
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
8861 op-snap---monthly-publication-february-2026.pdf   1608 2026-02 Pedestrian Kia ceed Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
8833 op-snap---monthly-publication-february-2026.pdf   1580 2026-02 Pedestrian Kia ev6 Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None station approach Station Approach Birmingham Birmingham Warning Letter N/A   52.6036307 -1.8446735
8832 op-snap---monthly-publication-february-2026.pdf   1579 2026-02 Pedestrian Kia sportage Green Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None drapers field Drapers Field Birmingham Birmingham Warning Letter N/A      
8730 op-snap---monthly-publication-february-2026.pdf   1477 2026-02 Pedestrian Kia sorento Grey Misc - Non Traffic Offences None broadmeadow Broadmeadow Walsall Walsall Warning Letter N/A   52.6100022 -1.9177041
8686 op-snap---monthly-publication-february-2026.pdf   1433 2026-02 Car Kia Niro Grey Contravening a Red Traffic Light None Lichfield Road Lichfield Road Birmingham Birmingham Education N/A   52.5012458 -1.8780942
8665 op-snap---monthly-publication-february-2026.pdf   1412 2026-02 Pedal Bike Kia Sportage Black Using a Mobile Phone Whilst Driving None Lyon Queensway Lyon Queensway Birmingham Birmingham Fixed Penalty N/A   52.4785129 -1.9047486
8662 op-snap---monthly-publication-february-2026.pdf   1409 2026-02 Car Kia   Silver Driving without Due Care and Attention None A4440 A4440 Out of Force Area Out of Force Area NFA Out of Force      
8545 op-snap---monthly-publication-february-2026.pdf   1292 2026-02 Car Kia   Red Using a Mobile Phone Whilst Driving None Burton Upon Trent Burton Upon Trent Out of Force Area Out of Force Area NFA Out of Force      
8398 op-snap---monthly-publication-february-2026.pdf   1145 2026-02 Car Kia Niro Grey Contravening a Red Traffic Light None Parkfield Road Parkfield Road Wolverhampton Wolverhampton Education N/A   52.567016 -2.1208485
8378 op-snap---monthly-publication-february-2026.pdf   1125 2026-02 Pedal Bike Kia Sportage Orange Driving without Due Care and Attention None Love Lane Love Lane Dudley Dudley Education N/A   52.448434 -2.1478173
8347 op-snap---monthly-publication-february-2026.pdf   1094 2026-02 Pedestrian Kia Ceed 2 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Drapers Fields Drapers Fields Coventry Coventry Fixed Penalty N/A   52.4144091 -1.5109203
8345 op-snap---monthly-publication-february-2026.pdf   1092 2026-02 Other Kia Sportage Grey Driving a vehicle wholly or partly on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham Other Action Taken N/A   52.5521118 -1.8845138
8244 op-snap---monthly-publication-february-2026.pdf   991 2026-02 Pedestrian Kia Ceed Silver Stop a vehicle within pelican pedestrian crossing limits None St Marys Row Street Marys Row Birmingham Birmingham Education N/A      
8221 op-snap---monthly-publication-february-2026.pdf   968 2026-02 Other Kia Sportage Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kingstanding Road Kingstanding Road Birmingham Birmingham NFA Not in Public Interest   52.5521118 -1.8845138
8212 op-snap---monthly-publication-february-2026.pdf   959 2026-02 Pedestrian Kia Picanto Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Maitland Road Maitland Road Birmingham Birmingham Fixed Penalty N/A   52.4868494 -1.8448776
8169 op-snap---monthly-publication-february-2026.pdf   916 2026-02 Car Kia Stonic Grey Stop a vehicle within pelican pedestrian crossing limits None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
8011 op-snap---monthly-publication-february-2026.pdf   758 2026-02 Car Kia Ceed Grey Contravening a Red Traffic Light None A38 Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
7896 op-snap---monthly-publication-february-2026.pdf   643 2026-02 Other Kia Sportage Black Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham Education N/A   52.5265939 -1.8509884
7890 op-snap---monthly-publication-february-2026.pdf   637 2026-02 Pedestrian Kia Sportage Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Randle Drive Randle Drive Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5920822 -1.8190013
7841 op-snap---monthly-publication-february-2026.pdf   588 2026-02 Pedal Bike Kia Sport White Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
7836 op-snap---monthly-publication-february-2026.pdf   583 2026-02 Car Kia Picanto Blue Driving without Due Care and Attention None Windsor to Watford Windsor to Watford Out of Force Area Out of Force Area NFA Out of Force      
7723 op-snap---monthly-publication-february-2026.pdf   470 2026-02 Car Kia EV3 Green Driving without Due Care and Attention None Tanworth Lane Tanworth Lane Solihull Solihull Education N/A   52.4014694 -1.8220541
7716 op-snap---monthly-publication-february-2026.pdf   463 2026-02 Motorbike Kia Ceed Red Driving without Due Care and Attention None Quarry Bank HS Quarry Bank HS Dudley Dudley Court N/A   52.4733135 -2.1014635
7700 op-snap---monthly-publication-february-2026.pdf   447 2026-02 Pedal Bike Kia Niro White Driving without Due Care and Attention None Bloomfield Road, Earlsdon Bloomfield Road, Earlsdon Coventry Coventry Education N/A      
7697 op-snap---monthly-publication-february-2026.pdf   444 2026-02 Pedal Bike Kia Sportage Silver Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Coventry Coventry Warning Letter N/A   52.4041117 -1.5595662
7670 op-snap---monthly-publication-february-2026.pdf   417 2026-02 Car Kia Sportage Black Stop a vehicle within pelican pedestrian crossing limits None Sharman's Cross Road Sharman's Cross Road Solihull Solihull Warning Letter N/A      
7622 op-snap---monthly-publication-february-2026.pdf   369 2026-02 Car Kia Sportage Brown Driving without Due Care and Attention None M42 Jct 11 Roundabout M42 Junction 11 Roundabout Out of Force Area Out of Force Area NFA Out of Force      
7579 op-snap---monthly-publication-february-2026.pdf   326 2026-02 Car Kia Xceed Grey Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Dudley Dudley Education N/A   52.5478387 -2.0943116
7570 op-snap---monthly-publication-february-2026.pdf   317 2026-02 Pedestrian Kia Sportage Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
7562 op-snap---monthly-publication-february-2026.pdf   309 2026-02 Pedal Bike Kia Ceed Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA No Independent Evidence Available   52.4708802 -1.8792135
7544 op-snap---monthly-publication-february-2026.pdf   291 2026-02 Pedal Bike Kia Ceed Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
7512 op-snap---monthly-publication-february-2026.pdf   259 2026-02 Pedestrian Kia Niro White Stop a vehicle on pedestrian crossing None Coventry Road Coventry Road Coventry Coventry NFA Not in Public Interest   52.4111289 -1.5094345
7470 op-snap---monthly-publication-february-2026.pdf   217 2026-02 Pedal Bike Kia Rio Blue Driving without Due Care and Attention None Ansty Road Ansty Road Coventry Coventry Education N/A   52.4205675 -1.4520187
7397 op-snap---monthly-publication-february-2026.pdf   144 2026-02 Car Kia Stonic Red Driving without Reasonable Consideration None Telford Town Centre Telford Town Centre Out of Force Area Out of Force Area NFA Out of Force      
7328 op-snap---monthly-publication-february-2026.pdf   75 2026-02 Bus Kia Niro Red Using a Mobile Phone Whilst Driving None Lichfield Street Lichfield Street Metropolitan Borough of Walsall Walsall Fixed Penalty N/A   52.5882772 -1.9761264
7322 op-snap---monthly-publication-february-2026.pdf   69 2026-02 Car Kia Rio White Driving without Due Care and Attention None A16 Kirton Kirton Out of Force Area Out of Force Area NFA Out of Force      
7315 op-snap---monthly-publication-february-2026.pdf   62 2026-02 Other Kia Sportage White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Glenville Drive Glenville Drive Birmingham Birmingham Fixed Penalty N/A   52.5265939 -1.8509884
7314 op-snap---monthly-publication-february-2026.pdf   61 2026-02 Car Kia Ceed Silver Using a Mobile Phone Whilst Driving None Moorfield Road Moorfield Road Out of Force Area Out of Force Area NFA Out of Force   52.4981538 -1.7875516
7288 op-snap---monthly-publication-february-2026.pdf   35 2026-02 Pedestrian Kia Sportage Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bournville Lane Bournville Lane Birmingham Birmingham Warning Letter N/A   52.4271614 -1.9302862
7287 op-snap---monthly-publication-february-2026.pdf   34 2026-02 Pedestrian Kia Sportage Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bournville Lane Bournville Lane Birmingham Birmingham Warning Letter N/A   52.4271614 -1.9302862
11926 op-snap---monthly-publication-january-2026.pdf   1387 2026-01 Pedestrian Kia   Silver Cause vehicle to be left in a dangerous position None berwood road Berwood Road Sandwell Sandwell Warning Letter N/A      
11868 op-snap---monthly-publication-january-2026.pdf   1329 2026-01 Pedal Bike Kia Stonic White Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
11840 op-snap---monthly-publication-january-2026.pdf   1301 2026-01 Pedestrian Kia Sportage Black Driving without Due Care and Attention No Insurance Floodgate Street Floodgate Street Birmingham Birmingham NFA Misc Inc Crimes   52.4752856 -1.8858047
11808 op-snap---monthly-publication-january-2026.pdf   1269 2026-01 Other Kia Ceed Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dudley Road Dudley Road Birmingham Birmingham Warning Letter N/A   52.4865107 -1.9386263
11789 op-snap---monthly-publication-january-2026.pdf   1250 2026-01 Car Kia picanto White Drive a vehicle other than on the carriageway of a motorway None Dartmouth Circus to A38 Dartmouth Circus to A38 Birmingham Birmingham Education N/A      
11767 op-snap---monthly-publication-january-2026.pdf   1228 2026-01 Van Kia Sportage Green Driving without Due Care and Attention None Shirley Road Shirley Road Birmingham Birmingham Court N/A   52.4198291 -1.9241732
11728 op-snap---monthly-publication-january-2026.pdf   1189 2026-01 Car Kia Sedona Black Driving without Due Care and Attention No Insurance Cannock Road Cannock Road Wolverhampton Wolverhampton Court N/A   52.6083917 -2.1033365
11723 op-snap---monthly-publication-january-2026.pdf   1184 2026-01 Pedestrian Kia Sportage Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kingstanding Road Kingstanding Road Birmingham Birmingham Fixed Penalty N/A   52.5521118 -1.8845138
11609 op-snap---monthly-publication-january-2026.pdf   1070 2026-01 Car Kia Picanto Silver Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
11568 op-snap---monthly-publication-january-2026.pdf   1029 2026-01 Car Kia Ceed Black Stop a vehicle within pelican pedestrian crossing limits None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
11552 op-snap---monthly-publication-january-2026.pdf   1013 2026-01 Pedal Bike Kia Sportage Grey Driving without Due Care and Attention None Black Haynes Road Black Haynes Road Birmingham Birmingham Warning Letter N/A   52.4260755 -1.9679443
11539 op-snap---monthly-publication-january-2026.pdf   1000 2026-01 Car Kia Ceed Red Driving without Due Care and Attention None Fletchamstead Highway Fletchamstead Highway Coventry Coventry Education N/A   52.396476 -1.5561348
11529 op-snap---monthly-publication-january-2026.pdf   990 2026-01 Car Kia Sportage Blue Driving without Due Care and Attention None Solihull Bypass Solihull Bypass Solihull Solihull NFA No Offence   52.4207529 -1.7757467
11461 op-snap---monthly-publication-january-2026.pdf   922 2026-01 Car Kia Xceed Black Driving without Due Care and Attention None Lowr Queen Street Lowr Queen Street Sutton Coldfield Sutton Coldfield Education N/A      
11457 op-snap---monthly-publication-january-2026.pdf   918 2026-01 Car Kia Stonic Grey Driving without Due Care and Attention None Dennis Road Dennis Road Birmingham Birmingham Education N/A   52.4524736 -1.8748228
11441 op-snap---monthly-publication-january-2026.pdf   902 2026-01 Other Kia Picanto Silver Offence to be added None Waterfront Carpark 7 Waterfront Carpark 7 Dudley Dudley NFA No Independent Evidence Available      
11417 op-snap---monthly-publication-january-2026.pdf   878 2026-01 Car Kia   Black Driving without Due Care and Attention None Monmouth Drive Monmouth Drive Sutton Coldfield Sutton Coldfield RTC - Actioned N/A   52.5575249 -1.8640053
11402 op-snap---monthly-publication-january-2026.pdf   863 2026-01 Pedal Bike Kia Sportage Black Driving without Due Care and Attention None Park Road Park Road Birmingham Birmingham Warning Letter N/A   52.5641687 -1.8272087
11400 op-snap---monthly-publication-january-2026.pdf   861 2026-01 Pedestrian Kia Picanto Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Woodstock Road Woodstock Road Birmingham Birmingham Warning Letter N/A   52.4486205 -1.8740822
11360 op-snap---monthly-publication-january-2026.pdf   821 2026-01 Pedestrian Kia Nero Grey Stop a vehicle within pelican pedestrian crossing limits None Regent Road Tividale Regent Road Tividale Dudley Dudley Education N/A   52.5106406 -2.0559963
11353 op-snap---monthly-publication-january-2026.pdf   814 2026-01 Car Kia Niro Grey Using a Mobile Phone Whilst Driving None Enfield, London Enfield, London Out of Force Area Out of Force Area NFA Out of Force      
11337 op-snap---monthly-publication-january-2026.pdf   798 2026-01 Other Kia Sportage Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kingstanding Road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
11313 op-snap---monthly-publication-january-2026.pdf   774 2026-01 Car Kia Soul Black Driving without Due Care and Attention None Bills Lane Bills Lane Birmingham Birmingham NFA Misc Inc Crimes      
11270 op-snap---monthly-publication-january-2026.pdf   731 2026-01 Car Kia Niro Grey Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
11238 op-snap---monthly-publication-january-2026.pdf   699 2026-01 Pedestrian Kia Picanto Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bells Lane Bells Lane Birmingham Birmingham Fixed Penalty N/A   52.4053419 -1.8944602
11148 op-snap---monthly-publication-january-2026.pdf   609 2026-01 Pedestrian Kia Venga Red Cause vehicle to be left in a dangerous position None Regent Road Regent Road Sandwell Sandwell Education N/A   52.5106406 -2.0559963
11089 op-snap---monthly-publication-january-2026.pdf   550 2026-01 Other Kia Sportage Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kingstanding Road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
11034 op-snap---monthly-publication-january-2026.pdf   495 2026-01 Car Kia EV - 9 Blue Using a Mobile Phone Whilst Driving None M6 South M6 South Metropolitan Borough of Walsall Walsall Other Action Taken N/A   52.6170728 -2.030393
11030 op-snap---monthly-publication-january-2026.pdf   491 2026-01 Car Kia Sportage Black Driving without Due Care and Attention None Hollywell Road Hollywell Road Birmingham Birmingham NFA No Independent Evidence Available   52.4594803 -1.7866201
10969 op-snap---monthly-publication-january-2026.pdf   430 2026-01 Car Kia Sportage white Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10842 op-snap---monthly-publication-january-2026.pdf   303 2026-01 Car Kia Niro White Cause vehicle to be left in a dangerous position None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Fixed Penalty N/A   52.4929304 -1.8229092
10797 op-snap---monthly-publication-january-2026.pdf   258 2026-01 Car Kia Picanto Blue Driving without Due Care and Attention None A380 Malvern Link Malvern Link Out of Force Area Out of Force Area NFA Out of Force      
10772 op-snap---monthly-publication-january-2026.pdf   233 2026-01 Pedestrian Kia Niro Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Elms Rd Elms Road Birmingham Birmingham Warning Letter N/A   52.5560676 -1.8234017
10714 op-snap---monthly-publication-january-2026.pdf   175 2026-01 Pedestrian Kia Niro Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Ellesmere Road Ellesmere Road Birmingham Birmingham NFA No Offence   52.4881533 -1.8553625
10650 op-snap---monthly-publication-january-2026.pdf   111 2026-01 Car Kia Sportage Black Driving without Due Care and Attention None A5 Oswestry Oswestry Out of Force Area Out of Force Area NFA Out of Force      
10555 op-snap---monthly-publication-january-2026.pdf   16 2026-01 Car Kia Sportage Silver Contravene Lane Closure Red X None M6 M6 Birmingham Birmingham NFA No Independent Evidence Available      
5156 op-snap---monthly-publication-december-2025.pdf   1284 2025-12 Car Kia Niro White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wolverhampton Street Wolverhampton Street Walsall Walsall Warning Letter N/A   52.5674241 -2.0426354
5149 op-snap---monthly-publication-december-2025.pdf   1277 2025-12 Pedestrian Kia Picanto White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Priory Road Priory Road Solihull Solihull Warning Letter N/A   52.4080373 -1.8511521
5137 op-snap---monthly-publication-december-2025.pdf   1265 2025-12 Car Kia Nero Black Driving without Due Care and Attention None A444 A444 Coventry Coventry NFA Not in Public Interest      
5099 op-snap---monthly-publication-december-2025.pdf   1227 2025-12 Pedal Bike Kia Picanto White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bradford Street Bradford Street Birmingham Birmingham NFA No Independent Evidence Available   52.4708802 -1.8792135
5084 op-snap---monthly-publication-december-2025.pdf   1212 2025-12 Car Kia Ceed White Misc - Non Traffic Offences None Island Road Island Road Birmingham Birmingham Warning Letter N/A   52.5095686 -1.9544485
5002 op-snap---monthly-publication-december-2025.pdf   1130 2025-12 Pedal Bike Kia Sportage White Contravening a Red Traffic Light None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter N/A   52.4221152 -1.4959475
4972 op-snap---monthly-publication-december-2025.pdf   1100 2025-12 Pedal Bike Kia picanto White Misc - Non Traffic Offences None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
4956 op-snap---monthly-publication-december-2025.pdf   1084 2025-12 Pedal Bike Kia picanto White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
4929 op-snap---monthly-publication-december-2025.pdf   1057 2025-12 Pedal Bike Kia Picanto Silver Driving without Due Care and Attention None Russell Road / Edgbaston Road Russell Road / Edgbaston Road Birmingham Birmingham Education N/A   52.4398245 -1.8469786
4904 op-snap---monthly-publication-december-2025.pdf   1032 2025-12 Car Kia Sportage White Contravening a Red Traffic Light None Jimmy Hill Way Jimmy Hill Way Coventry Coventry NFA No VRM   52.4214017 -1.4870278
4867 op-snap---monthly-publication-december-2025.pdf   995 2025-12 Car Kia EV9 Black Driving without Due Care and Attention None Navigation Roundabout A41 Navigation Roundabout A41 Sandwell Sandwell Fixed Penalty N/A   52.5318418 -2.0304157
4800 op-snap---monthly-publication-december-2025.pdf   928 2025-12 Car Kia Sportage Blue Driving without Due Care and Attention None M6 M6 Walsall Walsall Warning Letter N/A      
4762 op-snap---monthly-publication-december-2025.pdf   890 2025-12 Pedal Bike Kia Carens Silver Driving without Due Care and Attention None Camp Hill Middleway Camp Hill Middleway Birmingham Birmingham Education N/A   52.468339 -1.8796724
4677 op-snap---monthly-publication-december-2025.pdf   805 2025-12 Car Kia Ceed Black Using a Mobile Phone Whilst Driving None M6 M6 Walsall Walsall Fixed Penalty N/A      
4617 op-snap---monthly-publication-december-2025.pdf   745 2025-12 Car Kia carens Silver Stop a vehicle within pelican pedestrian crossing limits None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
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
4574 op-snap---monthly-publication-december-2025.pdf   702 2025-12 Car Kia Stinger Grey Use a vehicle / cycle on a road and contravene a local traffic order other than parking None High St, Aston High Street, Aston Birmingham Birmingham NFA Not in Public Interest   52.4973154 -1.8956143
4556 op-snap---monthly-publication-december-2025.pdf   684 2025-12 Pedal Bike Kia Proceed White Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4514 op-snap---monthly-publication-december-2025.pdf   642 2025-12 Car Kia rio Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None silvertrees road Silvertrees Road Dudley Dudley Warning Letter N/A   52.5263871 -2.0677928
4448 op-snap---monthly-publication-december-2025.pdf   576 2025-12 Car Kia Ceed Red Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
4419 op-snap---monthly-publication-december-2025.pdf   547 2025-12 Car Kia Niro Red Cause vehicle to be left in a dangerous position None Opposite Withymoor School Gayfi Opposite Withymoor School Gayfi eDldu dAlveey Brierley Hill Edldu Dalveey Brierley Hill Warning Letter N/A      
4375 op-snap---monthly-publication-december-2025.pdf   503 2025-12 Pedal Bike Kia Ceed Red Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4343 op-snap---monthly-publication-december-2025.pdf   471 2025-12 Car Kia Rio Silver Driving without Due Care and Attention None Holyhead Road Holyhead Road Coventry Coventry Education N/A   52.418488 -1.5472387
4339 op-snap---monthly-publication-december-2025.pdf   467 2025-12 Car Kia sportag White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None haslucks green road Haslucks Green Road Birmingham Birmingham Warning Letter N/A      

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