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

141 rows where month = "2025-07" and offence = "Driving without Reasonable Consideration" 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

reporter_transport_mode 5

disposal 5

offence 1

  • Driving without Reasonable Consideration · 141 ✖

month 1

  • 2025-07 · 141 ✖
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
11953 op-snap---monthly-publication-july-2025.pdf   5 2025-07 Car Ford Fiesta Orange Driving without Reasonable Consideration None Oldbury Ring Way Oldbury Ring Way Sandwell Sandwell NFA Outside of 14 Days NIP      
11962 op-snap---monthly-publication-july-2025.pdf   14 2025-07 Car Nissan Micra Red Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4470686 -1.8880749
11977 op-snap---monthly-publication-july-2025.pdf   29 2025-07 Car Volkswagen PX15PHF White Driving without Reasonable Consideration None Parkfields Road Parkfields Road Wolverhampton Wolverhampton NFA Outside of 14 DAYS Late Submission      
11985 op-snap---monthly-publication-july-2025.pdf   37 2025-07 Pedal Bike Honda Insight Silver Driving without Reasonable Consideration None Parsonage Street, West Bromwich Parsonage Street, West Bromwich Sandwell Sandwell Warning Letter N/A   52.5306821 -1.9875151
11989 op-snap---monthly-publication-july-2025.pdf   41 2025-07 Car Volkswagen Caddy White Driving without Reasonable Consideration None Grange Road, Coventry Grange Road, Coventry Coventry Coventry Warning Letter N/A   52.4521035 -1.4777638
12004 op-snap---monthly-publication-july-2025.pdf   56 2025-07 Pedal Bike Kia Sportage Grey Driving without Reasonable Consideration None Ridgacre Road Ridgacre Road Birmingham Birmingham Education N/A   52.4593367 -2.0000298
12062 op-snap---monthly-publication-july-2025.pdf   114 2025-07 Car Byd Seal Blue Driving without Reasonable Consideration None Kenilworth Road Kenilworth Road Out of Force Area Out of Force Area NFA Out of Force   52.5124557 -1.8917609
12065 op-snap---monthly-publication-july-2025.pdf   117 2025-07 Car BMW 330E Grey Driving without Reasonable Consideration None M42 Junction 3 West Mercia M42 Junction 3 West Mercia Out of Force Area Out of Force Area NFA Out of Force   52.4846642 -1.9297585
12085 op-snap---monthly-publication-july-2025.pdf   137 2025-07 Car Honda jazz Blue Driving without Reasonable Consideration None Shenley Fields Road Shenley Fields Road Birmingham Birmingham NFA No Offence   52.4373076 -1.9543847
12100 op-snap---monthly-publication-july-2025.pdf   152 2025-07 Pedal Bike Skoda Kamiq White Driving without Reasonable Consideration None A38 Tyburn Road Tyburn Road Birmingham Birmingham Court N/A   52.5113867 -1.8337258
12120 op-snap---monthly-publication-july-2025.pdf   172 2025-07 Pedestrian Cupra Ateca Grey Driving without Reasonable Consideration None M6 South Birmingham M6 South Birmingham Birmingham Birmingham Fixed Penalty N/A   52.4031308 -2.0142003
12143 op-snap---monthly-publication-july-2025.pdf   195 2025-07 Car Skoda Octavia Black Driving without Reasonable Consideration None A444 Jimmy Hill Way Jimmy Hill Way Coventry Coventry Warning Letter N/A   52.4214017 -1.4870278
12148 op-snap---monthly-publication-july-2025.pdf   200 2025-07 Car Ford Fiesta Yellow Driving without Reasonable Consideration None Queen Elizabeth Hospital Queen Elizabeth Hospital Birmingham Birmingham NFA Outside of 14 Days NIP   52.4517147 -1.9423655
12162 op-snap---monthly-publication-july-2025.pdf   214 2025-07 Car Mercedes-Benz Sprinter White Driving without Reasonable Consideration None M6 Southbound approaching Jn6 M6 Southbound approaching Jn6 Birmingham Birmingham Warning Letter N/A      
12168 op-snap---monthly-publication-july-2025.pdf   220 2025-07 Pedal Bike Tesla Model 3 White Driving without Reasonable Consideration None Corporation Street Corporation Street Coventry Coventry Education N/A   52.4086244 -1.515132
12199 op-snap---monthly-publication-july-2025.pdf   251 2025-07 Car Toyota Police car White Driving without Reasonable Consideration None Anderton Park Road Anderton Park Road Birmingham Birmingham NFA No Offence   52.4481342 -1.8776139
12234 op-snap---monthly-publication-july-2025.pdf   286 2025-07 Car BMW X4 Grey Driving without Reasonable Consideration None Little Bromwich Road Little Bromwich Road Birmingham Birmingham Education N/A   52.4777017 -1.8246255
12287 op-snap---monthly-publication-july-2025.pdf   339 2025-07 Pedal Bike Volvo V40 Blue Driving without Reasonable Consideration None 6 ways roundabout 6 Ways Roundabout Birmingham Birmingham Warning Letter N/A      
12304 op-snap---monthly-publication-july-2025.pdf   356 2025-07 Car Ford Mondeo Black Driving without Reasonable Consideration None Coventry Coventry Birmingham Birmingham NFA No Offence   52.4527138 -1.7656635
12356 op-snap---monthly-publication-july-2025.pdf   408 2025-07 Pedal Bike BMW 3 series White Driving without Reasonable Consideration No Insurance Butts Road Butts Road Walsall Walsall Fixed Penalty N/A   52.592263 -1.9743536
12370 op-snap---monthly-publication-july-2025.pdf   422 2025-07 Pedal Bike Ford Fiesta Blue Driving without Reasonable Consideration None Friday Lane Friday Lane Solihull Solihull Education N/A   52.4142542 -1.7217662
12371 op-snap---monthly-publication-july-2025.pdf   423 2025-07 Car Toyota Auris White Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Warning Letter N/A   52.4134557 -1.4442138
12394 op-snap---monthly-publication-july-2025.pdf   446 2025-07 Car Toyota Auris Silver Driving without Reasonable Consideration None Walsall Rd Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
12395 op-snap---monthly-publication-july-2025.pdf   447 2025-07 Car Seat Arona Blue Driving without Reasonable Consideration None M5 Junction 1 M5 Junction 1 Sandwell Sandwell Education N/A      
12500 op-snap---monthly-publication-july-2025.pdf   552 2025-07 Car Toyota Yaris Silver Driving without Reasonable Consideration None Ulverley Green Road, Olton Ulverley Green Road, Olton Solihull Solihull NFA No VRM   52.4374545 -1.803861
12508 op-snap---monthly-publication-july-2025.pdf   560 2025-07 Car Volkswagen Polo Grey Driving without Reasonable Consideration None Lichfield Road Lichfield Road Birmingham Birmingham Court N/A   52.5012458 -1.8780942
12545 op-snap---monthly-publication-july-2025.pdf   597 2025-07 Car Citroen relay White Driving without Reasonable Consideration None Stonehouse Lane Stonehouse Lane Birmingham Birmingham Education N/A   52.4440435 -1.9818872
12567 op-snap---monthly-publication-july-2025.pdf   619 2025-07 Pedal Bike Honda Jazz Green Driving without Reasonable Consideration None Saltway Saltway Out of Force Area Out of Force Area NFA Out of Force      
12568 op-snap---monthly-publication-july-2025.pdf   620 2025-07 Pedal Bike BMW 5 Series Black Driving without Reasonable Consideration None Redcap Heath Road Red Cap Heath Road Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP      
12573 op-snap---monthly-publication-july-2025.pdf   625 2025-07 Car Mg 3 series Silver Driving without Reasonable Consideration None Bickenhill Interchange Bickenhill Interchange Solihull Solihull Fixed Penalty N/A   52.4457674 -1.7082354
12574 op-snap---monthly-publication-july-2025.pdf   626 2025-07 Car Volkswagen Golf White Driving without Reasonable Consideration None A45 Coventry Road, Small Heath Coventry Road, Small Heath Birmingham Birmingham Education N/A   52.4650893 -1.8425008
12576 op-snap---monthly-publication-july-2025.pdf   628 2025-07 Car Ford Transit Red Driving without Reasonable Consideration None Cotterills Lane Cotterills Lane Birmingham Birmingham Warning Letter N/A   52.4884297 -1.817811
12584 op-snap---monthly-publication-july-2025.pdf   636 2025-07 Car Vauxhall Astra Grey Driving without Reasonable Consideration None Moseley Avenue Moseley Avenue Coventry Coventry Warning Letter N/A   52.417344 -1.5264979
12588 op-snap---monthly-publication-july-2025.pdf   640 2025-07 Car BMW 4 series Black Driving without Reasonable Consideration None Chelmsley Wood Chelmsley Wood Birmingham Birmingham NFA No Offence      
12592 op-snap---monthly-publication-july-2025.pdf   644 2025-07 Car BMW 520.. Grey Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
12597 op-snap---monthly-publication-july-2025.pdf   649 2025-07 Pedal Bike Ford   Grey Driving without Reasonable Consideration None Camp Hill Camp Hill Dudley Dudley Education N/A   52.475022 -2.1566273
12611 op-snap---monthly-publication-july-2025.pdf   663 2025-07 Car Volkswagen Golf White Driving without Reasonable Consideration None Birchfield Road Birchfield Road Birmingham Birmingham NFA No Offence   52.5170745 -1.9012542
12612 op-snap---monthly-publication-july-2025.pdf   664 2025-07 Car Seat Leon Silver Driving without Reasonable Consideration Use vehicle on a road without Bvairlcidh ftieesldt cReoratifdicate Bvairlcidh ftieesldt c Reoratifdicate Birmingham Birmingham NFA No Offence      
12649 op-snap---monthly-publication-july-2025.pdf   701 2025-07 Pedal Bike Citroen C3 White Driving without Reasonable Consideration None Witton Road Witton Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.513336 -1.8833226
12650 op-snap---monthly-publication-july-2025.pdf   702 2025-07 Pedal Bike Hyundai   Red Driving without Reasonable Consideration None Wellington Road Wellington Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5133725 -1.9193405
12651 op-snap---monthly-publication-july-2025.pdf   703 2025-07 Pedal Bike Seat Leon Green Driving without Reasonable Consideration None Wellinngton Road Wellinngton Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12652 op-snap---monthly-publication-july-2025.pdf   704 2025-07 Pedal Bike Nissan Qashqai Black Driving without Reasonable Consideration None Witton Road Witton Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.513336 -1.8833226
12653 op-snap---monthly-publication-july-2025.pdf   705 2025-07 Pedal Bike Skoda C3 Blue Driving without Reasonable Consideration None City Road City Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4763176 -1.9584897
12656 op-snap---monthly-publication-july-2025.pdf   708 2025-07 Car Hyundai i30 Grey Driving without Reasonable Consideration None Chester Road Chester Road Walsall Walsall NFA Outside of 14 Days NIP   52.5692139 -1.8799672
12687 op-snap---monthly-publication-july-2025.pdf   739 2025-07 Pedal Bike BMW 330E White Driving without Reasonable Consideration None A38 Tyburn Road Tyburn Road Birmingham Birmingham Warning Letter N/A   52.5113867 -1.8337258
12688 op-snap---monthly-publication-july-2025.pdf   740 2025-07 Car BMW 118 Black Driving without Reasonable Consideration None A514 Bedford Bedford Out of Force Area Out of Force Area NFA Out of Force      
12709 op-snap---monthly-publication-july-2025.pdf   761 2025-07 Car Yamaha MT Grey Driving without Reasonable Consideration None Warstone Road Warstone Road Wolverhampton Wolverhampton Education N/A      
12750 op-snap---monthly-publication-july-2025.pdf   802 2025-07 Car Ford Transit White Driving without Reasonable Consideration None A4100 A4100 Dudley Dudley Education N/A      
12752 op-snap---monthly-publication-july-2025.pdf   804 2025-07 Car Ford Focus Grey Driving without Reasonable Consideration None Coventry Street, Kidderminster Coventry Street, Kidderminster Out of Force Area Out of Force Area NFA Out of Force      
12772 op-snap---monthly-publication-july-2025.pdf   824 2025-07 Car Audi Q7 Black Driving without Reasonable Consideration None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
12802 op-snap---monthly-publication-july-2025.pdf   854 2025-07 Car Toyota Prius Silver Driving without Reasonable Consideration None Lobe Lane Lobe Lane Solihull Solihull NFA No Offence      
12804 op-snap---monthly-publication-july-2025.pdf   856 2025-07 Car Toyota Prius Silver Driving without Reasonable Consideration None Lode Lane Lode Lane Solihull Solihull NFA No Offence   52.4149064 -1.7832364
12832 op-snap---monthly-publication-july-2025.pdf   884 2025-07 Car Hyundai ioniq White Driving without Reasonable Consideration None M5 West Brom M5 West Brom Sandwell Sandwell NFA Outside of 14 Days NIP      
12851 op-snap---monthly-publication-july-2025.pdf   903 2025-07 Car Nissan Qashqai Red Driving without Reasonable Consideration None Alcester Road South Alcester Road South Birmingham Birmingham Education N/A   52.4170522 -1.8906187
12858 op-snap---monthly-publication-july-2025.pdf   910 2025-07 Car Vauxhall Corsa White Driving without Reasonable Consideration None Biddling Lane Biddling Lane Wolverhampton Wolverhampton NFA No Independent Evidence Available      
12861 op-snap---monthly-publication-july-2025.pdf   913 2025-07 Car Mazda   Black Driving without Reasonable Consideration None Clifford Street , Newton Clifford Street , Newton Birmingham Birmingham NFA Outside of 14 Days NIP      
12866 op-snap---monthly-publication-july-2025.pdf   918 2025-07 Car Audi Estima Silver Driving without Reasonable Consideration None Somerville Road Somerville Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5555545 -1.8329387
12868 op-snap---monthly-publication-july-2025.pdf   920 2025-07 Car Volkswagen Polo White Driving without Reasonable Consideration None Kings Road , Tyseley ,Birmingham Kings Road , Tyseley , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4572996 -1.8391692
12869 op-snap---monthly-publication-july-2025.pdf   921 2025-07 Pedestrian BMW 420 White Driving without Reasonable Consideration None     Birmingham Birmingham NFA Outside of 14 Days NIP      
12870 op-snap---monthly-publication-july-2025.pdf   922 2025-07 Pedestrian Audi   Grey Driving without Reasonable Consideration None York Road , Birmingham York Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5231321 -1.8415573
12871 op-snap---monthly-publication-july-2025.pdf   923 2025-07 Pedestrian Toyota Yaris Black Driving without Reasonable Consideration None Bradford Road , Birmingham Bradford Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5024148 -1.7961753
12886 op-snap---monthly-publication-july-2025.pdf   938 2025-07 Car Audi A4 Black Driving without Reasonable Consideration None     Birmingham Birmingham NFA Outside of 14 Days NIP      
12887 op-snap---monthly-publication-july-2025.pdf   939 2025-07 Car Audi A5 Red Driving without Reasonable Consideration None M40 Southbound M40 Southbound Out of Force Area Out of Force Area NFA Outside of 14 Days NIP      
12888 op-snap---monthly-publication-july-2025.pdf   940 2025-07 Car Scania   White Driving without Reasonable Consideration None M6 Northbound M6 Northbound Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4316701 -2.0178238
12889 op-snap---monthly-publication-july-2025.pdf   941 2025-07 Car BMW   Red Driving without Reasonable Consideration None York Road , Birmingham York Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5231321 -1.8415573
12890 op-snap---monthly-publication-july-2025.pdf   942 2025-07 Car Vauxhall Mokka Grey Driving without Reasonable Consideration None A4040 , Birmingham A4040 , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5150323 -1.9007149
12891 op-snap---monthly-publication-july-2025.pdf   943 2025-07 Car Audi   Black Driving without Reasonable Consideration None Warwick Road , Birmingham Warwick Road , Birmingham Birmingham Birmingham NFA Out of Force   52.551985 -1.860445
12892 op-snap---monthly-publication-july-2025.pdf   944 2025-07 Car Volvo   Black Driving without Reasonable Consideration None M6 Northbound M6 Northbound Birmingham Birmingham NFA Outside of 14 Days NIP      
12893 op-snap---monthly-publication-july-2025.pdf   945 2025-07 Car Vauxhall   Silver Driving without Reasonable Consideration None M5 Northbound M5 Northbound Birmingham Birmingham NFA Outside of 14 Days NIP      
12894 op-snap---monthly-publication-july-2025.pdf   946 2025-07 Car BMW   White Driving without Reasonable Consideration None M42 close to Junction 8 M42 close to Junction 8 Birmingham Birmingham NFA Outside of 14 Days NIP      
12895 op-snap---monthly-publication-july-2025.pdf   947 2025-07 Car Renault clio Red Driving without Reasonable Consideration None Walsall Road , West Bromwich Walsall Road , West Bromwich Sandwell Sandwell NFA Outside of 14 Days NIP   52.5366137 -1.9867997
12896 op-snap---monthly-publication-july-2025.pdf   948 2025-07 Pedestrian Ford Fiesta Black Driving without Reasonable Consideration None Level Street , Merry Hill Level Street , Merry Hill Dudley Dudley NFA Outside of 14 Days NIP      
12898 op-snap---monthly-publication-july-2025.pdf   950 2025-07 Car Mercedes-Benz sprinter Orange Driving without Reasonable Consideration None Caynton Road Caynton Road Out of Force Area Out of Force Area NFA Out of Force      
12905 op-snap---monthly-publication-july-2025.pdf   957 2025-07 Car   Contera MDI Red Driving without Reasonable Consideration None A46 Evesham Evesham Out of Force Area Out of Force Area NFA Out of Force   52.3837388 -1.5529669
12907 op-snap---monthly-publication-july-2025.pdf   959 2025-07 Car Land Rover Evoque Black Driving without Reasonable Consideration None Stafford Road Stafford Road Wolverhampton Wolverhampton NFA No Offence   52.6291998 -2.126312
12916 op-snap---monthly-publication-july-2025.pdf   968 2025-07 Car Land Rover Discovery Red Driving without Reasonable Consideration None Melrose Avenue , Sutton Melrose Avenue , Sutton Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP   52.5511462 -1.8479052
12917 op-snap---monthly-publication-july-2025.pdf   969 2025-07 Car Land Rover   Black Driving without Reasonable Consideration None M5 North M5 North Birmingham Birmingham NFA Outside of 14 Days NIP   52.5151103 -1.8501538
12918 op-snap---monthly-publication-july-2025.pdf   970 2025-07 Car Ford Transit Blue Driving without Reasonable Consideration None     Birmingham Birmingham NFA Outside of 14 Days NIP      
12919 op-snap---monthly-publication-july-2025.pdf   971 2025-07 Car Vauxhall Insignia Blue Driving without Reasonable Consideration None Eastern Green Road , Coventry Eastern Green Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4131188 -1.5784769
12922 op-snap---monthly-publication-july-2025.pdf   974 2025-07 Car Honda   Silver Driving without Reasonable Consideration None Third Avenue , Pensnett Third Avenue , Pensnett Dudley Dudley NFA Out of Force   52.5046812 -2.1550209
12923 op-snap---monthly-publication-july-2025.pdf   975 2025-07 Car Toyota   Grey Driving without Reasonable Consideration None Dudley Road , A4101 , Kingswinford Dudley Road , A4101 , Kingswinford Dudley Dudley NFA Outside of 14 Days NIP   52.5003036 -2.1593541
12924 op-snap---monthly-publication-july-2025.pdf   976 2025-07 Car Skoda Fabia Black Driving without Reasonable Consideration None Cole Hall Lane , Birmingham Cole Hall Lane , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4877244 -1.787883
12925 op-snap---monthly-publication-july-2025.pdf   977 2025-07 Car Vauxhall Corsa Red Driving without Reasonable Consideration None Stourbridge Road , Colley Gate Stourbridge Road , Colley Gate Dudley Dudley NFA Outside of 14 Days NIP      
12926 op-snap---monthly-publication-july-2025.pdf   978 2025-07 Pedestrian Ford Transit Silver Driving without Reasonable Consideration None Cole Hall Lane , Kitts Green Cole Hall Lane , Kitts Green Birmingham Birmingham NFA Outside of 14 Days NIP   52.4877244 -1.787883
12937 op-snap---monthly-publication-july-2025.pdf   989 2025-07 Car Mg ZS Silver Driving without Reasonable Consideration None Kyotts Lake Road Kyotts Lake Road Birmingham Birmingham Warning Letter N/A   52.4655028 -1.8755351
12938 op-snap---monthly-publication-july-2025.pdf   990 2025-07 Car Volvo Lorry White Driving without Reasonable Consideration None Cornetts End lane Cornetts End lane Coventry Coventry Court N/A      
12950 op-snap---monthly-publication-july-2025.pdf   1002 2025-07 Other Volkswagen Bora Black Driving without Reasonable Consideration None M54 M54 Out of Force Area Out of Force Area NFA Out of Force      
12953 op-snap---monthly-publication-july-2025.pdf   1005 2025-07 Car Ford Focus White Driving without Reasonable Consideration None Westcote Avenue , twoartds Frankley Westcote Avenue , twoartds Frankley OGuret eonf Force Area Oguret Eonf Force Area NFA Outside of 14 Days NIP      
12954 op-snap---monthly-publication-july-2025.pdf   1006 2025-07 Car BMW   White Driving without Reasonable Consideration None Birmingham Road , Stratford Birmingham Road , Stratford Out of Force Area Out of Force Area NFA Outside of 14 Days NIP   52.4496153 -1.8646204
12957 op-snap---monthly-publication-july-2025.pdf   1009 2025-07 Car Audi A8 Black Driving without Reasonable Consideration None Stratford Road , Birmingham Stratford Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4447583 -1.8592059
12960 op-snap---monthly-publication-july-2025.pdf   1012 2025-07 Car BMW   Silver Driving without Reasonable Consideration None Mini Roundabout , Bacchus Road Mini Roundabout , Bacchus Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12961 op-snap---monthly-publication-july-2025.pdf   1013 2025-07 Car BMW 530d M Sport Black Driving without Reasonable Consideration None Star City , Birmingham Star City , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5054363 -1.8556273
12962 op-snap---monthly-publication-july-2025.pdf   1014 2025-07 Pedestrian Audi   Blue Driving without Reasonable Consideration None Newton Middleway , Birmingham Newton Middleway , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
12965 op-snap---monthly-publication-july-2025.pdf   1017 2025-07 Pedestrian Toyota Yaris Grey Driving without Reasonable Consideration None Paradise Street , Birmingham Paradise Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4790667 -1.9039768
12967 op-snap---monthly-publication-july-2025.pdf   1019 2025-07 Car BMW X5 White Driving without Reasonable Consideration None Wolverhampton - Heading towards ST Wolverhampton - Heading towards ST Bafifromrdin gRhoaamd Bafifromrdin Grhoaamd NFA Outside of 14 Days NIP      
12969 op-snap---monthly-publication-july-2025.pdf   1021 2025-07 Other Volkswagen Golf White Driving without Reasonable Consideration No Insurance Prince of Wales Road , Coventry Prince of Wales Road , Coventry Coventry Coventry NFA Outside of 14 Days NIP   52.4103298 -1.5412458
12972 op-snap---monthly-publication-july-2025.pdf   1024 2025-07 Pedal Bike Ford   Red Driving without Reasonable Consideration None Gibbins Road , Selly Oak , Birmingha Gibbins Road , Selly Oak , Birmingha mSolihull Msolihull NFA Outside of 14 Days NIP      
12973 op-snap---monthly-publication-july-2025.pdf   1025 2025-07 Pedal Bike Peugeot   Grey Driving without Reasonable Consideration None Gibbins Road , Selly Oak , Birmingha Gibbins Road , Selly Oak , Birmingha mBirmingham Mbirmingham NFA Outside of 14 DAYS Late Submission      
12979 op-snap---monthly-publication-july-2025.pdf   1031 2025-07 Car BMW x1 Black Driving without Reasonable Consideration None M6 J13 M6 J13 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
12986 op-snap---monthly-publication-july-2025.pdf   1038 2025-07 Car Yamaha   Blue Driving without Reasonable Consideration None Chester Road North , Birmingham Chester Road North , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5666061 -1.879083

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