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

591 rows where vehicle_make = "Land Rover" 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

  • Land Rover · 591 ✖
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
8876 op-snap---monthly-publication-february-2026.pdf   1623 2026-02 Pedestrian Land Rover Range Rover Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None rotten park road Rotten Park Road Birmingham Birmingham Warning Letter N/A      
8852 op-snap---monthly-publication-february-2026.pdf   1599 2026-02 Car Land Rover defender Black Cause vehicle to be left in a dangerous position none high street, kingswinford High Street, Kingswinford Sandwell Sandwell Warning Letter N/A      
8830 op-snap---monthly-publication-february-2026.pdf   1577 2026-02 Pedestrian Land Rover   Black Fail to display front VRM plate None edgbaston road Edgbaston Road Birmingham Birmingham NFA Misc Inc Crimes   52.4552785 -1.906384
8770 op-snap---monthly-publication-february-2026.pdf   1517 2026-02 Car Land Rover discovery Black Driving a vehicle wholly or partly on a footpath None Hollyfield Road Hollyfield Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5620486 -1.8030784
8729 op-snap---monthly-publication-february-2026.pdf   1476 2026-02 Car Land Rover discovery Black Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
8710 op-snap---monthly-publication-february-2026.pdf   1457 2026-02 Pedestrian Land Rover freelander Silver Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
8660 op-snap---monthly-publication-february-2026.pdf   1407 2026-02 Car Land Rover Evoque White Using a Mobile Phone Whilst Driving None Shard End Crescent Shard End Crescent Birmingham Birmingham NFA No Independent Evidence Available   52.4927744 -1.7781391
8562 op-snap---monthly-publication-february-2026.pdf   1309 2026-02 Car Land Rover Freelander Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
8551 op-snap---monthly-publication-february-2026.pdf   1298 2026-02 Car Land Rover Discovery Black Driving without Due Care and Attention None Summerhill Road, Bilston Summerhill Road, Bilston Wolverhampton Wolverhampton Education N/A      
8423 op-snap---monthly-publication-february-2026.pdf   1170 2026-02 Car Land Rover Velar White Driving without Due Care and Attention None On Warwickshire police On Warwickshire police Out of Force Area Out of Force Area NFA Out of Force      
8420 op-snap---monthly-publication-february-2026.pdf   1167 2026-02 Car Land Rover Sport Black VRM fails to conform to Regulations None Harborne Lane Island Harborne Lane Island Birmingham Birmingham Warning Letter N/A   52.4439777 -1.9418736
8362 op-snap---monthly-publication-february-2026.pdf   1109 2026-02 Car Land Rover Defender Grey Driving without Due Care and Attention None M5 near Glocester M5 near Glocester Out of Force Area Out of Force Area NFA Out of Force      
8324 op-snap---monthly-publication-february-2026.pdf   1071 2026-02 Pedestrian Land Rover Range Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cubley Road Cubley Road Birmingham Birmingham NFA No Offence   52.43878 -1.8509412
8299 op-snap---monthly-publication-february-2026.pdf   1046 2026-02 Pedal Bike Land Rover Evoque Black Driving without Due Care and Attention None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Education N/A   52.5359496 -1.8324115
8259 op-snap---monthly-publication-february-2026.pdf   1006 2026-02 Other Land Rover Range Rover Gold Using a Mobile Phone Whilst Driving None U/K U/K Out of Force Area Out of Force Area NFA No Independent Evidence Available   52.5030589 -2.0265092
8216 op-snap---monthly-publication-february-2026.pdf   963 2026-02 Car Land Rover Range Black Driving without Due Care and Attention None Henley on Thames Henley on Thames Out of Force Area Out of Force Area NFA Out of Force      
8187 op-snap---monthly-publication-february-2026.pdf   934 2026-02 Car Land Rover Autobio Gold Driving without Due Care and Attention None Lower Eggleton, Worcester Lower Eggleton, Worcester Out of Force Area Out of Force Area NFA Out of Force      
8146 op-snap---monthly-publication-february-2026.pdf   893 2026-02 Car Land Rover range Rover Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Hurstcroft Road Hurstcroft Road Birmingham Birmingham Fixed Penalty N/A   52.4830179 -1.783876
8000 op-snap---monthly-publication-february-2026.pdf   747 2026-02 Car Land Rover Range Black Driving without Due Care and Attention None Bridgnorth Road Bridgnorth Road Out of Force Area Out of Force Area NFA Out of Force   52.4758675 -1.7882992
7945 op-snap---monthly-publication-february-2026.pdf   692 2026-02 Pedestrian Land Rover Discovery Silver Stop a vehicle within pelican pedestrian crossing limits None Poplar Road Poplar Road Birmingham Birmingham Education N/A   52.436035 -1.891685
7932 op-snap---monthly-publication-february-2026.pdf   679 2026-02 Car Land Rover Sport Black Driving without Due Care and Attention None Off force Off force Out of Force Area Out of Force Area NFA Out of Force      
7923 op-snap---monthly-publication-february-2026.pdf   670 2026-02 Car Land Rover Discovery Silver Driving without Due Care and Attention None Holt, Worcester to Hallow Holt, Worcester to Hallow Out of Force Area Out of Force Area NFA Out of Force      
7879 op-snap---monthly-publication-february-2026.pdf   626 2026-02 Car Land Rover Evoque Black Driving without Due Care and Attention None Cannock Road Cannock Road Walsall Walsall Court N/A   52.610689 -2.0405006
7860 op-snap---monthly-publication-february-2026.pdf   607 2026-02 Car Land Rover Range White Using a Mobile Phone Whilst Driving None A19 A19 Out of Force Area Out of Force Area NFA Out of Force      
7855 op-snap---monthly-publication-february-2026.pdf   602 2026-02 Car Land Rover Range Rover Blue Contravening a Red Traffic Light None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
7815 op-snap---monthly-publication-february-2026.pdf   562 2026-02 Car Land Rover Evoque White Driving without Due Care and Attention None Yardley Road Yardley Road Birmingham Birmingham Warning Letter N/A   52.4613544 -1.8160137
7805 op-snap---monthly-publication-february-2026.pdf   552 2026-02 Car Land Rover Evoque White Driving without Due Care and Attention None Shirley Road Shirley Road Birmingham Birmingham Court N/A   52.4198291 -1.9241732
7780 op-snap---monthly-publication-february-2026.pdf   527 2026-02 Pedestrian Land Rover Range Rover White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Berwood Road Berwood Road Birmingham Birmingham Warning Letter N/A   52.5342947 -1.8155375
7749 op-snap---monthly-publication-february-2026.pdf   496 2026-02 Pedestrian Land Rover Defender Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Fixed Penalty N/A   52.5940902 -1.843503
7715 op-snap---monthly-publication-february-2026.pdf   462 2026-02 Pedestrian Land Rover Discovery Green Cause vehicle to be left in a dangerous position None Beech Road Beech Road Birmingham Birmingham Education N/A   52.5393906 -1.8446767
7695 op-snap---monthly-publication-february-2026.pdf   442 2026-02 Car Land Rover Evoque Black Driving without Due Care and Attention None M6 SB J19 M6 Southbound J19 Out of Force Area Out of Force Area NFA Out of Force      
7682 op-snap---monthly-publication-february-2026.pdf   429 2026-02 Pedal Bike Land Rover Discovery Brown Driving without Due Care and Attention None Redhill Road Redhill Road Birmingham Birmingham Education N/A   52.4618364 -1.8328803
7585 op-snap---monthly-publication-february-2026.pdf   332 2026-02 Car Land Rover Land Rover Blue Contravening a Red Traffic Light None Tile Hill Lane Tile Hill Lane Coventry Coventry Education N/A   52.4041117 -1.5595662
7548 op-snap---monthly-publication-february-2026.pdf   295 2026-02 Pedal Bike Land Rover Range Rover Black Using a Mobile Phone Whilst Driving No Insurance Five ways Island Five ways Island Birmingham Birmingham Court N/A      
7463 op-snap---monthly-publication-february-2026.pdf   210 2026-02 Pedestrian Land Rover Discovery Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Woodlands Place Woodlands Place Solihull Solihull Fixed Penalty N/A   52.3744455 -1.8001781
7417 op-snap---monthly-publication-february-2026.pdf   164 2026-02 Car Land Rover Range Rover Brown VRM fails to conform to Regulations No Insurance Bristol Road South Bristol Road South Birmingham Birmingham Warning Letter N/A   52.4119174 -1.9735247
7392 op-snap---monthly-publication-february-2026.pdf   139 2026-02 Car Land Rover Range Rover Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Darwin Street Darwin Street Birmingham Birmingham Warning Letter N/A   52.468128 -1.8848315
7375 op-snap---monthly-publication-february-2026.pdf   122 2026-02 Pedestrian Land Rover Evoque Grey Cause vehicle to be left in a dangerous position None Roebuck Lane Roebuck Lane Sandwell Sandwell Education N/A   52.5027291 -1.9781818
7371 op-snap---monthly-publication-february-2026.pdf   118 2026-02 Car Land Rover Evoque Beige Contravening a Red Traffic Light None Venture Way Venture Way Dudley Dudley Education N/A   52.4836603 -2.1189326
7331 op-snap---monthly-publication-february-2026.pdf   78 2026-02 Car Land Rover Discovery White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Burnaby Road Burnaby Road Coventry Coventry Warning Letter N/A   52.4352 -1.5194238
7273 op-snap---monthly-publication-february-2026.pdf   20 2026-02 Car Land Rover Range Rover Black Driving without Due Care and Attention None Footscray Road Footscray Road Out of Force Area Out of Force Area NFA Out of Force      
7264 op-snap---monthly-publication-february-2026.pdf   11 2026-02 Car Land Rover Discovery Blue Offence to be added None M6 M6 Birmingham Birmingham NFA No Independent Evidence Available      
11910 op-snap---monthly-publication-january-2026.pdf   1371 2026-01 Car Land Rover evoque Grey Misc - Non Traffic Offences None plough and harrow road Plough And Harrow Road Halesowen Halesowen NFA Misc Inc Crimes   52.5899123 -1.8057069
11900 op-snap---monthly-publication-january-2026.pdf   1361 2026-01 Car Land Rover Sport Blue Contravening a Red Traffic Light None Stratford Road Stratford Road Solihull Solihull Education N/A   52.4191184 -1.8326637
11899 op-snap---monthly-publication-january-2026.pdf   1360 2026-01 Car Land Rover Evoque White Contravening a Red Traffic Light None Stratford Road Stratford Road Solihull Solihull Education N/A   52.4191184 -1.8326637
11897 op-snap---monthly-publication-january-2026.pdf   1358 2026-01 Car Land Rover Discovery White Driving without Due Care and Attention No Seat Belt A4117 Callow Hill, between Ludlow and Kidderminster Callow Hill, between Ludlow and Kidderminster Out of Force Area Out of Force Area NFA Out of Force      
11892 op-snap---monthly-publication-january-2026.pdf   1353 2026-01 Car Land Rover Range Rover Blue Driving without Due Care and Attention None Stafford Road Stafford Road Wolverhampton Wolverhampton Warning Letter N/A   52.6291998 -2.126312
11884 op-snap---monthly-publication-january-2026.pdf   1345 2026-01 Pedal Bike Land Rover Range Rover Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
11827 op-snap---monthly-publication-january-2026.pdf   1288 2026-01 Car Land Rover Disco White Stop a vehicle within pelican pedestrian crossing limits None Coleshill Road Coleshill Road Birmingham Birmingham Education N/A   52.4967329 -1.8097462
11814 op-snap---monthly-publication-january-2026.pdf   1275 2026-01 Pedestrian Land Rover Discovery Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Bernards Road Street Bernards Road Solihull Solihull Warning Letter N/A      
11793 op-snap---monthly-publication-january-2026.pdf   1254 2026-01 Pedestrian Land Rover Discovery Green Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Beech Road Beech Road Birmingham Birmingham Warning Letter N/A   52.5393906 -1.8446767
11733 op-snap---monthly-publication-january-2026.pdf   1194 2026-01 Car Land Rover Defender Black Using a Mobile Phone Whilst Driving None M3 near Bracknell M3 near Bracknell Out of Force Area Out of Force Area NFA Out of Force      
11700 op-snap---monthly-publication-january-2026.pdf   1161 2026-01 Pedestrian Land Rover Discovery Black Cause vehicle to be left in a dangerous position None Gayfield Avenue Gayfield Avenue Dudley Dudley Education N/A   52.4693896 -2.1251602
11638 op-snap---monthly-publication-january-2026.pdf   1099 2026-01 Car Land Rover Land Rover Red Driving without Due Care and Attention None west mercia West Mercia Out of Force Area Out of Force Area NFA Out of Force   52.5827653 -2.0983246
11588 op-snap---monthly-publication-january-2026.pdf   1049 2026-01 Car Land Rover Defender Black Driving without Due Care and Attention None Stivichall Highway Stivichall Highway Coventry Coventry Education N/A   52.3774003 -1.493293
11548 op-snap---monthly-publication-january-2026.pdf   1009 2026-01 Car Land Rover Evoque White Stop a vehicle within pelican pedestrian crossing limits No Insurance Bearwood Road Bearwood Road Sandwell Sandwell Court N/A   52.4725977 -1.9684448
11538 op-snap---monthly-publication-january-2026.pdf   999 2026-01 Pedestrian Land Rover Land Rover Black Cause vehicle to be left in a dangerous position None Woodbridge Road Woodbridge Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4482076 -1.8864335
11526 op-snap---monthly-publication-january-2026.pdf   987 2026-01 Car Land Rover Range Rover grey Contravening a Red Traffic Light None Union Road Solihull Union Road Solihull Solihull Solihull Fixed Penalty N/A   52.4044229 -1.8141776
11378 op-snap---monthly-publication-january-2026.pdf   839 2026-01 Pedestrian Land Rover Discovery Black Using a Mobile Phone Whilst Driving None Bell Green Road Bell Green Road Coventry Coventry Education N/A   52.4324855 -1.4815548
11362 op-snap---monthly-publication-january-2026.pdf   823 2026-01 Pedestrian Land Rover Land Rover White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Portman Road Portman Road Birmingham Birmingham Warning Letter N/A   52.4306424 -1.8844833
11331 op-snap---monthly-publication-january-2026.pdf   792 2026-01 Car Land Rover Discovery Grey VRM fails to conform to Regulations None Birmingham New Road Birmingham New Road Dudley Dudley Fixed Penalty N/A   52.5478387 -2.0943116
11253 op-snap---monthly-publication-january-2026.pdf   714 2026-01 Pedal Bike Land Rover Sport Black Stop a vehicle on pedestrian crossing None Earlsdon Street Earlsdon Street Coventry Coventry Education N/A   52.3988977 -1.5323674
11211 op-snap---monthly-publication-january-2026.pdf   672 2026-01 Car Land Rover Discovery Red Driving without Due Care and Attention None Binley Road Binley Road Coventry Coventry Education N/A   52.4070602 -1.4732469
11196 op-snap---monthly-publication-january-2026.pdf   657 2026-01 Car Land Rover Evoque Brown Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull NFA No Offence   52.4149064 -1.7832364
11176 op-snap---monthly-publication-january-2026.pdf   637 2026-01 Pedestrian Land Rover Discovery White Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipment None Bradford Place Walsall Bradford Place Walsall Metropolitan Borough of Walsall Walsall Fixed Penalty N/A   52.5831708 -1.9837299
11084 op-snap---monthly-publication-january-2026.pdf   545 2026-01 Car Land Rover Range White Drive a vehicle other than on the carriageway of a motorway None M42 M42 Solihull Solihull NFA No Independent Evidence Available      
11064 op-snap---monthly-publication-january-2026.pdf   525 2026-01 Car Land Rover Range Blue Driving without Due Care and Attention None Charles Road Charles Road Birmingham Birmingham NFA No Independent Evidence Available   52.5094492 -1.9113648
11026 op-snap---monthly-publication-january-2026.pdf   487 2026-01 Other Land Rover Range Rover Black Driving without Due Care and Attention None Castlegate Way Castlegate Way Dudley Dudley Warning Letter N/A   52.5143403 -2.0723636
11025 op-snap---monthly-publication-january-2026.pdf   486 2026-01 Other Land Rover Defender Red Driving without Due Care and Attention None Castlegate Way Castlegate Way Dudley Dudley Warning Letter N/A   52.5143403 -2.0723636
11024 op-snap---monthly-publication-january-2026.pdf   485 2026-01 Other Land Rover Range Rover Green Driving without Due Care and Attention None Castlegate Way Castlegate Way Dudley Dudley Warning Letter N/A   52.5143403 -2.0723636
10908 op-snap---monthly-publication-january-2026.pdf   369 2026-01 Pedestrian Land Rover Evoque Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Morville Street Morville Street Birmingham Birmingham Warning Letter N/A   52.4771765 -1.9197019
10904 op-snap---monthly-publication-january-2026.pdf   365 2026-01 Car Land Rover Land Rover Black Vehicle overtake within crossing limits None Highfield Road Highfield Road Birmingham Birmingham Education N/A   52.4216321 -1.855984
10799 op-snap---monthly-publication-january-2026.pdf   260 2026-01 Car Land Rover Velar Blue Driving without Due Care and Attention None Manor Way Manor Way Halesowen Halesowen Warning Letter N/A   52.5203602 -1.824434
10794 op-snap---monthly-publication-january-2026.pdf   255 2026-01 Pedestrian Land Rover R Rover SPort Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotten Park Rd Rotten Park Road Birmingham Birmingham Warning Letter N/A      
10790 op-snap---monthly-publication-january-2026.pdf   251 2026-01 Car Land Rover Discovery Black Contravening a Red Traffic Light None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA No Independent Evidence Available   52.5047428 -2.0823754
10771 op-snap---monthly-publication-january-2026.pdf   232 2026-01 Other Land Rover Discovery Green Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Chantry Road, Moseley Chantry Road, Moseley Birmingham Birmingham NFA No Independent Evidence Available   52.4496376 -1.8915224
10724 op-snap---monthly-publication-january-2026.pdf   185 2026-01 Pedestrian Land Rover Discovery White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Chilcote Close Chilcote Close Birmingham Birmingham NFA No Independent Evidence Available   52.4167178 -1.8457291
10699 op-snap---monthly-publication-january-2026.pdf   160 2026-01 Car Land Rover Range Grey Stop a vehicle within pelican pedestrian crossing limits None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
10663 op-snap---monthly-publication-january-2026.pdf   124 2026-01 Car Land Rover defender Green Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
10597 op-snap---monthly-publication-january-2026.pdf   58 2026-01 Other Land Rover 414.. Red Driving without Due Care and Attention None Waterfront main car park Waterfront main car park Dudley Dudley Warning Letter N/A      
10573 op-snap---monthly-publication-january-2026.pdf   34 2026-01 Car Land Rover Discovery Grey Using a Mobile Phone Whilst Driving None A48 Gloucester Gloucester Out of Force Area Out of Force Area NFA Out of Force   52.405214 -1.9708282
10559 op-snap---monthly-publication-january-2026.pdf   20 2026-01 Car Land Rover Range White Contravening a Red Traffic Light None Marshall Lake Road Marshall Lake Road Solihull Solihull NFA No Independent Evidence Available   52.3975426 -1.818252
4952 op-snap---monthly-publication-december-2025.pdf   1080 2025-12 Car Land Rover range rover Black Cause vehicle to be left in a dangerous position None Dawson Road Dawson Road Birmingham Birmingham Warning Letter N/A   52.5048623 -1.9349662
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
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      
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      
4646 op-snap---monthly-publication-december-2025.pdf   774 2025-12 Car Land Rover Range Black Drive a vehicle other than on the carriageway of a motorway None M6 j6 M6 j6 Birmingham Birmingham Fixed Penalty N/A   52.676119 -2.0858425
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      
4582 op-snap---monthly-publication-december-2025.pdf   710 2025-12 Car Land Rover Evoque Black Contravening a Red Traffic Light None West Bromwich Interchange West Bromwich Interchange Sandwell Sandwell Warning Letter N/A   52.5109262 -1.9753718
4548 op-snap---monthly-publication-december-2025.pdf   676 2025-12 Car Land Rover Range Rover Sport Grey Contravening a Red Traffic Light None Tipton Road jn with Birmingham N Tipton Road jn with Birmingham N eDwud Rleoyad Edwud Rleoyad Fixed Penalty N/A      
4466 op-snap---monthly-publication-december-2025.pdf   594 2025-12 Car Land Rover Defender Brown Vehicle overtake within crossing limits None Solihull lane Solihull lane Birmingham Birmingham Education N/A   52.4230862 -1.8347873
4464 op-snap---monthly-publication-december-2025.pdf   592 2025-12 Car Land Rover Range Grey Driving without Due Care and Attention No Insurance Garrision Lane Garrision Lane Birmingham Birmingham Other Action Taken Misc Inc Crimes      
4421 op-snap---monthly-publication-december-2025.pdf   549 2025-12 Car Land Rover Evoque Dynamics Black 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      
4383 op-snap---monthly-publication-december-2025.pdf   511 2025-12 Car Land Rover Range Rover Black Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Warning Letter N/A   52.4308271 -1.920078
4299 op-snap---monthly-publication-december-2025.pdf   427 2025-12 Pedestrian Land Rover range rover Black Cause vehicle to be left in a dangerous position None barclay road Barclay Road Birmingham Birmingham NFA Misc Inc Crimes      
4278 op-snap---monthly-publication-december-2025.pdf   406 2025-12 Pedestrian Land Rover range rover Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None barclay road Barclay Road Sandwell Sandwell NFA Misc Inc Crimes   52.4722765 -1.9787531
4256 op-snap---monthly-publication-december-2025.pdf   384 2025-12 Pedestrian Land Rover discovery White Misc - Non Traffic Offences None crankhall lane Crankhall Lane Dudley Dudley NFA Misc Inc Crimes      
4231 op-snap---monthly-publication-december-2025.pdf   359 2025-12 Pedestrian Land Rover Defender Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Avenue Gayfield Avenue Dudley Dudley Warning Letter N/A   52.4693896 -2.1251602
4220 op-snap---monthly-publication-december-2025.pdf   348 2025-12 Pedestrian Land Rover Sport Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Glenville drive Glenville drive Birmingham Birmingham Warning Letter N/A   52.5265939 -1.8509884
4212 op-snap---monthly-publication-december-2025.pdf   340 2025-12 Pedestrian Land Rover Range Rover Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Moseley Old ROad Moseley Old ROad Birmingham Birmingham NFA Duplicate Submission      

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