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

797 rows where vehicle_make = "Seat" 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 8

vehicle_make 1

  • Seat · 797 ✖
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
8871 op-snap---monthly-publication-february-2026.pdf   1618 2026-02 Pedal Bike Seat altea Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None gordon road Gordon Road Coventry Coventry Warning Letter N/A      
8814 op-snap---monthly-publication-february-2026.pdf   1561 2026-02 Pedal Bike Seat Leon Grey Driving without Due Care and Attention None Far Gosford Street Far Gosford Street Coventry Coventry Education N/A   52.4071231 -1.4985178
8739 op-snap---monthly-publication-february-2026.pdf   1486 2026-02 Car Seat Ateca Silver Driving without Due Care and Attention None A45 A45 Coventry Coventry Court N/A      
8727 op-snap---monthly-publication-february-2026.pdf   1474 2026-02 Car Seat ateca Blue Stop a vehicle within pelican pedestrian crossing limits None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
8688 op-snap---monthly-publication-february-2026.pdf   1435 2026-02 Car Seat Ibiza Red Driving without Due Care and Attention None Upton Road Upton Road Birmingham Birmingham Fixed Penalty N/A   52.4773477 -1.8187617
8664 op-snap---monthly-publication-february-2026.pdf   1411 2026-02 Car Seat Ibiza Blue Driving without Due Care and Attention None M6 Motorway M6 Motorway Birmingham Birmingham NFA No Independent Evidence Available   52.5327447 -1.899844
8576 op-snap---monthly-publication-february-2026.pdf   1323 2026-02 Other Seat Leon White Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen t None Stone Street/ Tower Street Stone Street/ Tower Street Dudley Dudley Fixed Penalty N/A   52.5104511 -2.0836025
8559 op-snap---monthly-publication-february-2026.pdf   1306 2026-02 Car Seat Leon Black Misc - Non Traffic Offences None Bristol Road Bristol Road Birmingham Birmingham NFA No VRM   52.4543565 -1.9114004
8540 op-snap---monthly-publication-february-2026.pdf   1287 2026-02 Car Seat Ibiza Grey Driving without Due Care and Attention None Longfellow Road Longfellow Road Coventry Coventry Fixed Penalty N/A   52.4102345 -1.4609881
8484 op-snap---monthly-publication-february-2026.pdf   1231 2026-02 Other Seat Ibiza White Driving without Due Care and Attention None Waterfront Main Car Park Waterfront Main Car Park Dudley Dudley Warning Letter N/A      
8418 op-snap---monthly-publication-february-2026.pdf   1165 2026-02 Car Seat Ibiza Red Driving without Due Care and Attention None Lady Byron Lane Lady Byron Lane Solihull Solihull Fixed Penalty N/A   52.4026126 -1.7503668
8411 op-snap---monthly-publication-february-2026.pdf   1158 2026-02 Car Seat Ibiza Black Contravening a Red Traffic Light None Dartmouth Circus Roundabout Dartmouth Circus Roundabout Birmingham Birmingham Education N/A      
8410 op-snap---monthly-publication-february-2026.pdf   1157 2026-02 Car Seat Leon White Driving without Due Care and Attention None Rowleys Green Roundabout at Jummy Hill Way Rowleys Green Roundabout at Jummy Hill Way Coventry Coventry RTC - Actioned N/A   52.4486967 -1.4991069
8394 op-snap---monthly-publication-february-2026.pdf   1141 2026-02 Car Seat Ibiza Black Driving without Due Care and Attention None Vicarage Road Vicarage Road Birmingham Birmingham Warning Letter N/A   52.470423 -1.9304786
8382 op-snap---monthly-publication-february-2026.pdf   1129 2026-02 Car Seat Ibiza Orange Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
8343 op-snap---monthly-publication-february-2026.pdf   1090 2026-02 Car Seat Ibiza White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Not in Public Interest   52.4203897 -1.8338574
8339 op-snap---monthly-publication-february-2026.pdf   1086 2026-02 Car Seat Leon Blue Driving without Due Care and Attention None Broad lane Broad lane Coventry Coventry Education N/A   52.4074716 -1.5620671
8271 op-snap---monthly-publication-february-2026.pdf   1018 2026-02 Car Seat Ateca White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
8260 op-snap---monthly-publication-february-2026.pdf   1007 2026-02 Car Seat Leon Black Drive on hard shoulder None M6 Jct 8 M6 Junction 8 Walsall Walsall Education N/A   52.6760749 -2.0862582
8242 op-snap---monthly-publication-february-2026.pdf   989 2026-02 Pedestrian Seat Leon Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Bedford Road Bedford Road Birmingham Birmingham Fixed Penalty N/A   52.4718425 -1.8774188
8237 op-snap---monthly-publication-february-2026.pdf   984 2026-02 Car Seat Arona Blue Contravening a Red Traffic Light None Darthmouth Circus Darthmouth Circus Birmingham Birmingham Education N/A      
8193 op-snap---monthly-publication-february-2026.pdf   940 2026-02 Pedestrian Seat Ibiza Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Regent Place Regent Place Birmingham Birmingham Fixed Penalty N/A   52.4860376 -1.9095854
8166 op-snap---monthly-publication-february-2026.pdf   913 2026-02 Car Seat   Blue Driving without Due Care and Attention None M40 M40 Out of Force Area Out of Force Area NFA Out of Force      
8106 op-snap---monthly-publication-february-2026.pdf   853 2026-02 Car Seat Leon White Using a Mobile Phone Whilst Driving No vehicle excise licence Wobaston Road Wobaston Road Wolverhampton Wolverhampton Fixed Penalty N/A   52.628768 -2.1306154
8052 op-snap---monthly-publication-february-2026.pdf   799 2026-02 Car Seat Altea Silver Use vehicle on a road without valid test certificate None Trench Lock, Telford Trench Lock, Telford Out of Force Area Out of Force Area NFA Out of Force      
8035 op-snap---monthly-publication-february-2026.pdf   782 2026-02 Pedestrian Seat   Silver Driving without Due Care and Attention None Brownshore Lane Brownshore Lane Out of Force Area Out of Force Area NFA Out of Force      
8033 op-snap---monthly-publication-february-2026.pdf   780 2026-02 Car Seat Leon Grey Driving without Due Care and Attention None Rounds Green Road Rounds Green Road Sandwell Sandwell Fixed Penalty N/A   52.5020873 -2.0262185
7989 op-snap---monthly-publication-february-2026.pdf   736 2026-02 Pedestrian Seat Leon Orange Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Oswalds Road Street Oswalds Road Birmingham Birmingham NFA No Offence      
7985 op-snap---monthly-publication-february-2026.pdf   732 2026-02 Car Seat Cupra Grey Contravening a Red Traffic Light None Stoney Lane Stoney Lane Birmingham Birmingham Fixed Penalty N/A   52.4745488 -1.8065911
7965 op-snap---monthly-publication-february-2026.pdf   712 2026-02 Pedestrian Seat Exteo Black Cause vehicle to be left in a dangerous position None Institute Road Institute Road Birmingham Birmingham Education N/A   52.4334781 -1.8892337
7872 op-snap---monthly-publication-february-2026.pdf   619 2026-02 Car Seat Ibiza White Contravening a Red Traffic Light None Brettle Lane, Brierley Hill Brettle Lane, Brierley Hill Dudley Dudley Education N/A      
7867 op-snap---monthly-publication-february-2026.pdf   614 2026-02 Car Seat Ibiza Black Cause vehicle to be left in a dangerous position None Hilton Road Hilton Road Out of Force Area Out of Force Area NFA Out of Force   52.5609419 -2.1099418
7857 op-snap---monthly-publication-february-2026.pdf   604 2026-02 Pedal Bike Seat Ibiza Grey Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Warning Letter N/A   52.4103629 -1.5441218
7856 op-snap---monthly-publication-february-2026.pdf   603 2026-02 Pedal Bike Seat Leon Grey Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Fixed Penalty N/A   52.4221152 -1.4959475
7854 op-snap---monthly-publication-february-2026.pdf   601 2026-02 Pedal Bike Seat Leon Black Contravene Lane Closure Red X None Longmore Street Longmore Street Birmingham Birmingham NFA No Independent Evidence Available   52.464484 -1.8923374
7830 op-snap---monthly-publication-february-2026.pdf   577 2026-02 Car Seat Leon Grey Contravening a Red Traffic Light None Coventry Eastern Bypass Coventry Eastern Bypass Coventry Coventry Education N/A   52.3793117 -1.4625379
7823 op-snap---monthly-publication-february-2026.pdf   570 2026-02 Pedestrian Seat Ibiza Grey Stop a vehicle within pelican pedestrian crossing limits None Poplar Road Poplar Road Birmingham Birmingham Education N/A   52.436035 -1.891685
7779 op-snap---monthly-publication-february-2026.pdf   526 2026-02 Car Seat Ibiza Red Driving without Due Care and Attention None Curzon Circle Curzon Circle Birmingham Birmingham Warning Letter N/A   52.4834655 -1.8801763
7712 op-snap---monthly-publication-february-2026.pdf   459 2026-02 Pedestrian Seat   Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kings Heath Kings Heath Birmingham Birmingham Warning Letter N/A   52.4388601 -1.8936667
7702 op-snap---monthly-publication-february-2026.pdf   449 2026-02 Car Seat Alhambra Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Cambridge Crescent Cambridge Crescent Birmingham Birmingham Warning Letter N/A   52.4652475 -1.9056734
7632 op-snap---monthly-publication-february-2026.pdf   379 2026-02 Pedal Bike Seat Leon Silver Driving without Due Care and Attention None Woodstock Road Woodstock Road Coventry Coventry NFA No Independent Evidence Available   52.3919059 -1.5026146
7593 op-snap---monthly-publication-february-2026.pdf   340 2026-02 Car Seat Ibiza Grey Driving without Due Care and Attention None Walford Road Walford Road Birmingham Birmingham Court N/A   52.4594072 -1.8658859
7575 op-snap---monthly-publication-february-2026.pdf   322 2026-02 Other Seat Alteca Grey Driving without Due Care and Attention None Orphange Road / Chester Road Orphange Road / Chester Road Birmingham Birmingham Education N/A      
7564 op-snap---monthly-publication-february-2026.pdf   311 2026-02 Pedal Bike Seat Leon Grey 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
7563 op-snap---monthly-publication-february-2026.pdf   310 2026-02 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Bradford Street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
7553 op-snap---monthly-publication-february-2026.pdf   300 2026-02 Pedal Bike Seat Leon Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Braford Street Braford Street Birmingham Birmingham Warning Letter N/A      
7545 op-snap---monthly-publication-february-2026.pdf   292 2026-02 Pedal Bike Seat Leon Grey 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
7533 op-snap---monthly-publication-february-2026.pdf   280 2026-02 Car Seat Ateca Grey Contravening a Red Traffic Light None Lode Lane Lode Lane Solihull Solihull Fixed Penalty N/A   52.4149064 -1.7832364
7505 op-snap---monthly-publication-february-2026.pdf   252 2026-02 Car Seat Cupra Grey Driving without Due Care and Attention None Sand Pits Sand Pits Birmingham Birmingham Education N/A      
7487 op-snap---monthly-publication-february-2026.pdf   234 2026-02 Car Seat mii Red Stop a vehicle within pelican pedestrian crossing limits None Hollyfield Road Hollyfield Road Sutton Coldfield Sutton Coldfield Education N/A   52.5620486 -1.8030784
7382 op-snap---monthly-publication-february-2026.pdf   129 2026-02 Pedal Bike Seat Arona Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lordswood Road Lordswood Road Birmingham Birmingham Warning Letter N/A   52.4591339 -1.9601054
7346 op-snap---monthly-publication-february-2026.pdf   93 2026-02 Car Seat Ibiza Grey Driving without Due Care and Attention None witton road Witton Road Birmingham Birmingham Warning Letter N/A   52.513336 -1.8833226
11946 op-snap---monthly-publication-january-2026.pdf   1407 2026-01 Car Seat leon White Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
11936 op-snap---monthly-publication-january-2026.pdf   1397 2026-01 Car Seat Ibiza Beige Driving without Due Care and Attention None Birmingham Road Birmingham Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5361464 -1.8270283
11929 op-snap---monthly-publication-january-2026.pdf   1390 2026-01 Pedestrian Seat Ateca Black Cause vehicle to be left in a dangerous position None Birmingham Road Birmingham Road Birmingham Birmingham Warning Letter N/A   52.5505398 -1.8252993
11919 op-snap---monthly-publication-january-2026.pdf   1380 2026-01 Pedestrian Seat Ateca Grey Using a Mobile Phone Whilst Driving None Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A   52.4726661 -1.8769032
11788 op-snap---monthly-publication-january-2026.pdf   1249 2026-01 Car Seat Ibiza Red Using a Mobile Phone Whilst Driving None Birmingham Road Birmingham Road Birmingham Birmingham Fixed Penalty N/A   52.5505398 -1.8252993
11732 op-snap---monthly-publication-january-2026.pdf   1193 2026-01 Car Seat . Green Using a Mobile Phone Whilst Driving None Stratford Upon Avon Stratford Upon Avon Out of Force Area Out of Force Area NFA Out of Force   52.3499075 -1.7812051
11710 op-snap---monthly-publication-january-2026.pdf   1171 2026-01 Car Seat Ibiza Black Driving without Due Care and Attention None Edgbaston Park Road Edgbaston Park Road Birmingham Birmingham Education N/A   52.4580375 -1.9261777
11658 op-snap---monthly-publication-january-2026.pdf   1119 2026-01 Car Seat Ibiza White Driving without Due Care and Attention None Landor Street Landor Street Birmingham Birmingham NFA No VRM   52.4822898 -1.8707686
11632 op-snap---monthly-publication-january-2026.pdf   1093 2026-01 Pedestrian Seat Arona Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Dewsbury Avenue Dewsbury Avenue Coventry Coventry NFA No Independent Evidence Available   52.3848122 -1.5204351
11585 op-snap---monthly-publication-january-2026.pdf   1046 2026-01 Car Seat Altea Silver Driving without Due Care and Attention None Wainbody Avenue Wainbody Avenue Coventry Coventry NFA No Independent Evidence Available   52.3849692 -1.5311416
11567 op-snap---monthly-publication-january-2026.pdf   1028 2026-01 Car Seat Arona Grey Stop a vehicle within pelican pedestrian crossing limits None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
11566 op-snap---monthly-publication-january-2026.pdf   1027 2026-01 Car Seat Arona White Stop a vehicle within pelican pedestrian crossing limits None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
11504 op-snap---monthly-publication-january-2026.pdf   965 2026-01 Car Seat leon White Driving without Reasonable Consideration No Insurance Wrens Nest Road Wrens Nest Road Dudley Dudley Court N/A   52.5253252 -2.0995407
11389 op-snap---monthly-publication-january-2026.pdf   850 2026-01 Car Seat Cupra 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
11336 op-snap---monthly-publication-january-2026.pdf   797 2026-01 Pedal Bike Seat Leon White Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
11328 op-snap---monthly-publication-january-2026.pdf   789 2026-01 Car Seat Leon Blue Driving without Due Care and Attention None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Education N/A   52.4134557 -1.4442138
11326 op-snap---monthly-publication-january-2026.pdf   787 2026-01 Car Seat Leon Black Stop a vehicle within pelican pedestrian crossing limits None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226
11267 op-snap---monthly-publication-january-2026.pdf   728 2026-01 Car Seat Leon Silver Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
11239 op-snap---monthly-publication-january-2026.pdf   700 2026-01 Car Seat Ibiza White Driving without Due Care and Attention None M6 Jct 5 M6 Junction 5 Sutton Coldfield Sutton Coldfield Education N/A   52.676119 -2.0858425
11093 op-snap---monthly-publication-january-2026.pdf   554 2026-01 Pedestrian Seat alhambra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Green Lane North Green Lane North Coventry Coventry Warning Letter N/A      
11031 op-snap---monthly-publication-january-2026.pdf   492 2026-01 Car Seat Ibiza Red Misc - Non Traffic Offences None Bromford Lane Bromford Lane Birmingham Birmingham Other Action Taken N/A   52.5083238 -1.8332287
10997 op-snap---monthly-publication-january-2026.pdf   458 2026-01 Car Seat Leon Black Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
10903 op-snap---monthly-publication-january-2026.pdf   364 2026-01 Car Seat Ibiza Black Driving without Due Care and Attention None Five ways roundabout Five ways roundabout Birmingham Birmingham Warning Letter N/A      
10882 op-snap---monthly-publication-january-2026.pdf   343 2026-01 Car Seat Alhambra Blue Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
10857 op-snap---monthly-publication-january-2026.pdf   318 2026-01 Car Seat Alhambra White Stop a vehicle within pelican pedestrian crossing limits None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
10846 op-snap---monthly-publication-january-2026.pdf   307 2026-01 Pedal Bike Seat Leon White Driving without Due Care and Attention None Lawley Middleway Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10835 op-snap---monthly-publication-january-2026.pdf   296 2026-01 Pedestrian Seat Ibiza Yellow Cause vehicle to be left in a dangerous position None Wootton Road Wootton Road Birmingham Birmingham Education N/A   52.3905192 -1.968829
10751 op-snap---monthly-publication-january-2026.pdf   212 2026-01 Pedestrian Seat Ateca Grey Cause vehicle to be left in a dangerous position None Queslett Road East Queslett Road East Birmingham Birmingham Education N/A   52.5632702 -1.8893754
10750 op-snap---monthly-publication-january-2026.pdf   211 2026-01 Car Seat Ibiza White Contravening a Red Traffic Light None Heath Way Heath Way Birmingham Birmingham Education N/A   52.4963549 -1.7806171
10721 op-snap---monthly-publication-january-2026.pdf   182 2026-01 Car Seat Leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Zoar Street Zoar Street Wolverhampton Wolverhampton NFA No Offence   52.5807478 -2.1383109
10649 op-snap---monthly-publication-january-2026.pdf   110 2026-01 Car Seat Leon White Contravening a Red Traffic Light None Bromford Road Bromford Road Birmingham Birmingham Fixed Penalty N/A   52.503036 -1.8289972
10622 op-snap---monthly-publication-january-2026.pdf   83 2026-01 Pedestrian Seat leon Grey Misc - Non Traffic Offences None woodstock road Woodstock Road Birmingham Birmingham NFA No Offence   52.4486205 -1.8740822
10603 op-snap---monthly-publication-january-2026.pdf   64 2026-01 Car Seat Leon Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
10569 op-snap---monthly-publication-january-2026.pdf   30 2026-01 Other Seat Ibiza Red Driving without Due Care and Attention None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
5173 op-snap---monthly-publication-december-2025.pdf   1301 2025-12 Car Seat Leon Grey Cause vehicle to be left in a dangerous position None Stoney Stanton Rd Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
5165 op-snap---monthly-publication-december-2025.pdf   1293 2025-12 Car Seat Ibiza White Driving without Due Care and Attention None Stratford Road Stratford Road Out of Force Area Out of Force Area NFA Out of Force   52.4532265 -1.8659356
5164 op-snap---monthly-publication-december-2025.pdf   1292 2025-12 Car Seat Leon White Driving without Due Care and Attention None Careless Green Careless Green Halesowen Halesowen NFA No Offence   52.4510855 -2.1073525
5102 op-snap---monthly-publication-december-2025.pdf   1230 2025-12 Car Seat leon White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Eddish Road Eddish Road Birmingham Birmingham Warning Letter N/A   52.4833672 -1.7871439
4994 op-snap---monthly-publication-december-2025.pdf   1122 2025-12 Pedestrian Seat leon Blue Cause vehicle to be left in a dangerous position None kingstanding road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
4986 op-snap---monthly-publication-december-2025.pdf   1114 2025-12 Car Seat Alhambra Black Driving without Due Care and Attention None Sherwood Road Sherwood Road Out of Force Area Out of Force Area NFA Out of Force   52.4293332 -1.8478596
4973 op-snap---monthly-publication-december-2025.pdf   1101 2025-12 Pedal Bike Seat leon Black Misc - Non Traffic Offences None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
4953 op-snap---monthly-publication-december-2025.pdf   1081 2025-12 Pedestrian Seat Leon Black Misc - Non Traffic Offences None wyrley road Wyrley Road Birmingham Birmingham NFA Misc Inc Crimes   52.5172973 -1.8785949
4893 op-snap---monthly-publication-december-2025.pdf   1021 2025-12 Car Seat Leon Black Misc - Non Traffic Offences none A4040 Island Road Island Road Birmingham Birmingham NFA Misc Inc Crimes   52.5095686 -1.9544485
4826 op-snap---monthly-publication-december-2025.pdf   954 2025-12 Car Seat MII Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
4821 op-snap---monthly-publication-december-2025.pdf   949 2025-12 Car Seat Ibiza Grey Driving without Due Care and Attention None St Chads Queensway Street Chads Queensway Birmingham Birmingham NFA No Offence      
4801 op-snap---monthly-publication-december-2025.pdf   929 2025-12 Car Seat CUPRA Grey Driving without Due Care and Attention None Cinder bank at Simms Cinder bank at Simms Dudley Dudley NFA Outside of 14 Days NIP   52.4951209 -2.0924902
4796 op-snap---monthly-publication-december-2025.pdf   924 2025-12 Car Seat Leon Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Church Road Church Road Sandwell Sandwell Warning Letter N/A   52.4857168 -1.9703938
4761 op-snap---monthly-publication-december-2025.pdf   889 2025-12 Car Seat Toledo Blue Contravening a Red Traffic Light None A4123 Black Country New Road Black Country New Road Dudley Dudley Education 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);