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

811 rows where disposal = "NFA" and offence = "Driving without Reasonable Consideration" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale

vehicle_make >30

reporter_transport_mode 9

offence 1

  • Driving without Reasonable Consideration · 811 ✖

disposal 1

  • NFA · 811 ✖
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
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      
7412 op-snap---monthly-publication-february-2026.pdf   159 2026-02 Car Peugeot 208 Grey Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
7964 op-snap---monthly-publication-february-2026.pdf   711 2026-02 Car Audi A3 Red Driving without Reasonable Consideration None Queslett Road / Kings Road Queslett Road / Kings Road Birmingham Birmingham NFA No Offence   52.5461661 -1.9204363
8522 op-snap---monthly-publication-february-2026.pdf   1269 2026-02 Horse Rider Porsche Boxter Red Driving without Reasonable Consideration None Worcester Lane Worcester Lane Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5908671 -1.8140277
8763 op-snap---monthly-publication-february-2026.pdf   1510 2026-02 Car Tesla model 3 Grey Driving without Reasonable Consideration None Jn3 M42, West Mercia Jn3 M42, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
8771 op-snap---monthly-publication-february-2026.pdf   1518 2026-02 Car Toyota Prius White Driving without Reasonable Consideration None Newton Road Great Barr Newton Road Great Barr Birmingham Birmingham NFA No Independent Evidence Available   52.5429259 -1.9534939
11515 op-snap---monthly-publication-january-2026.pdf   976 2026-01 Lorry Volkswagen Tiguan Grey Driving without Reasonable Consideration None M1 J24 - Leicester M1 J24 - Leicester Out of Force Area Out of Force Area NFA Out of Force      
4724 op-snap---monthly-publication-december-2025.pdf   852 2025-12 Car Nissan Qashqai White Driving without Reasonable Consideration None Stafford Rd Stafford Road Wolverhampton Wolverhampton NFA No Offence   52.6291998 -2.126312
20489 op-snap---monthly-publication-november-2025.pdf   31 2025-11 Car Jaecoo Delux Black Driving without Reasonable Consideration None M42 Solihull M42 Solihull Birmingham Birmingham NFA No Offence   52.4711059 -1.8461809
21240 op-snap---monthly-publication-november-2025.pdf   782 2025-11 Car Hyundai i30 blue Driving without Reasonable Consideration None M5 Northbound, West Mercia M5 Northbound, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
22065 op-snap---monthly-publication-october-2025.pdf   15 2025-10 Pedal Bike Audi   Black Driving without Reasonable Consideration None Castle Road Castle Road Out of Force Area Out of Force Area NFA Out of Force   52.4358056 -1.9593904
22095 op-snap---monthly-publication-october-2025.pdf   45 2025-10 Pedal Bike Volkswagen ID Yellow Driving without Reasonable Consideration None Weoley Park Weoley Park Birmingham Birmingham NFA No Offence   52.4353726 -1.9460178
22111 op-snap---monthly-publication-october-2025.pdf   61 2025-10 Pedal Bike Citroen   Silver Driving without Reasonable Consideration None Earlsdon Ave Earlsdon Ave Coventry Coventry NFA No Independent Evidence Available   52.4047134 -1.5351834
22190 op-snap---monthly-publication-october-2025.pdf   140 2025-10 Pedal Bike Mercedes-Benz   White Driving without Reasonable Consideration None Cornets End Lane Cornets End Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4269547 -1.6668911
22193 op-snap---monthly-publication-october-2025.pdf   143 2025-10 Pedal Bike Audi A3 Grey Driving without Reasonable Consideration None Broad Lane Broad Lane Coventry Coventry NFA Outside of 14 Days NIP   52.4074716 -1.5620671
22795 op-snap---monthly-publication-october-2025.pdf   745 2025-10 Motorbike Audi S4 Blue Driving without Reasonable Consideration None Astwood Bank Astwood Bank Out of Force Area Out of Force Area NFA Out of Force      
22985 op-snap---monthly-publication-october-2025.pdf   935 2025-10 Horse Rider BMW 225xe Blue Driving without Reasonable Consideration None Withybrook Road, Bedworth Withybrook Road, Bedworth Out of Force Area Out of Force Area NFA Out of Force      
23321 op-snap---monthly-publication-october-2025.pdf   1271 2025-10 Car Daf Tipper White Driving without Reasonable Consideration None Nuneaton Nuneaton Out of Force Area Out of Force Area NFA Out of Force   52.4014214 -1.5189806
23790 op-snap---monthly-publication-september-2025.pdf   9 2025-09 Car Volkswagen Crafter Grey Driving without Reasonable Consideration None St Peters Driv, Worcester Street Peters Driv, Worcester Out of Force Area Out of Force Area NFA Out of Force      
23832 op-snap---monthly-publication-september-2025.pdf   51 2025-09 Pedal Bike Chevrolet Matiz Orange Driving without Reasonable Consideration None Cheveral Avenue Cheveral Avenue Coventry Coventry NFA No Offence   52.4257402 -1.5185037
23865 op-snap---monthly-publication-september-2025.pdf   84 2025-09 Car Audi A3 Black Driving without Reasonable Consideration None M6 J12 M6 J12 Out of Force Area Out of Force Area NFA Out of Force   52.6760749 -2.0862582
23884 op-snap---monthly-publication-september-2025.pdf   103 2025-09 Car   Polestar Black Driving without Reasonable Consideration None Bickenhill Lane Bickenhill Lane Solihull Solihull NFA No Offence   52.4490463 -1.7296897
23909 op-snap---monthly-publication-september-2025.pdf   128 2025-09 Pedal Bike Skoda Rapid Grey Driving without Reasonable Consideration None New Street New Street Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4791344 -1.8986915
23979 op-snap---monthly-publication-september-2025.pdf   198 2025-09 Car Toyota Yaris Black Driving without Reasonable Consideration None Coventry Road, Small Heath Coventry Road, Small Heath Birmingham Birmingham NFA No Offence   52.4650893 -1.8425008
24075 op-snap---monthly-publication-september-2025.pdf   294 2025-09 Car Land Rover Range Black Driving without Reasonable Consideration None Hereford Ring Road Hereford Ring Road Out of Force Area Out of Force Area NFA Out of Force      
24203 op-snap---monthly-publication-september-2025.pdf   422 2025-09 Car Peugeot 208 Grey Driving without Reasonable Consideration None M1 J21 - Leicester M1 J21 - Leicester Out of Force Area Out of Force Area NFA Out of Force      
24289 op-snap---monthly-publication-september-2025.pdf   508 2025-09 Pedal Bike Volvo V40 Blue Driving without Reasonable Consideration None Henwick Road Henwick Road Out of Force Area Out of Force Area NFA Out of Force      
24330 op-snap---monthly-publication-september-2025.pdf   549 2025-09 Car Volkswagen Crafter White Driving without Reasonable Consideration None Black Country New Road Black Country New Road Sandwell Sandwell NFA No Offence   52.5527191 -2.0312967
24332 op-snap---monthly-publication-september-2025.pdf   551 2025-09 Car Mercedes-Benz Smart Car Black Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
24509 op-snap---monthly-publication-september-2025.pdf   728 2025-09 Car Daf Trucks White Driving without Reasonable Consideration None M42 J9 M42 J9 Out of Force Area Out of Force Area NFA Out of Force   52.3601724 -1.8062199
24578 op-snap---monthly-publication-september-2025.pdf   797 2025-09 Pedal Bike Peugeot 308 Silver Driving without Reasonable Consideration None Marston Lane Marston Lane Out of Force Area Out of Force Area NFA Out of Force   52.4670062 -1.7548427
24879 op-snap---monthly-publication-september-2025.pdf   1098 2025-09 Car Peugeot Expert White Driving without Reasonable Consideration None Monument Road Monument Road Birmingham Birmingham NFA No Offence   52.4731312 -1.930947
2199 op-snap---monthly-publication-august-2025.pdf   174 2025-08 Lorry Renault   Silver Driving without Reasonable Consideration None Gloucester Road Gloucester Road Out of Force Are Out of Force Area NFA Out of Force      
2269 op-snap---monthly-publication-august-2025.pdf   244 2025-08 Pedal Bike Land Rover Land Rover Grey Driving without Reasonable Consideration None A456 Manor Way Manor Way Dudley Dudley NFA No Offence   52.4493861 -2.0168307
2275 op-snap---monthly-publication-august-2025.pdf   250 2025-08 Car Toyota Prius Silver Driving without Reasonable Consideration None Alum Rock Road Alum Rock Road Birmingham Birmingham NFA No Offence   52.4883936 -1.8310056
2303 op-snap---monthly-publication-august-2025.pdf   278 2025-08 Pedal Bike Volkswagen UP White Driving without Reasonable Consideration None Yardley Wood Road Yardley Wood Road Birmingham Birmingham NFA No Offence   52.4103191 -1.8670224
2311 op-snap---monthly-publication-august-2025.pdf   286 2025-08 Pedal Bike   Bus Blue Driving without Reasonable Consideration None Church Hill Way, Redditch Church Hill Way, Redditch Out of Force Are Out of Force Area NFA Out of Force      
2312 op-snap---monthly-publication-august-2025.pdf   287 2025-08 Car Ford kuga Grey Driving without Reasonable Consideration None M6 J10 M6 J10 Walsall Walsall NFA No Independent Evidence Available   52.676119 -2.0858425
2364 op-snap---monthly-publication-august-2025.pdf   339 2025-08 Other Fiat Fiorino White Driving without Reasonable Consideration None Northwood (Shrewsbury) Northwood (Shrewsbury) Out of Force Are Out of Force Area NFA Out of Force      
2388 op-snap---monthly-publication-august-2025.pdf   363 2025-08 Car Volkswagen Golf Grey Driving without Reasonable Consideration None Heybarnes Road Heybarnes Road Birmingham Birmingham NFA No Independent Evidence Available   52.4677423 -1.8351236
2550 op-snap---monthly-publication-august-2025.pdf   525 2025-08 Car Audi A1 Grey Driving without Reasonable Consideration None Woodgreen Drive (Worcester) Woodgreen Drive (Worcester) Out of Force Are Out of Force Area NFA Out of Force      
2576 op-snap---monthly-publication-august-2025.pdf   551 2025-08 Pedal Bike Suzuki   Yellow Driving without Reasonable Consideration None Llley Lane Llley Lane Out of Force Are Out of Force Area NFA Out of Force      
2797 op-snap---monthly-publication-august-2025.pdf   772 2025-08 Pedal Bike Toyota Prius Silver Driving without Reasonable Consideration None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham NFA No Independent Evidence Available   52.4094108 -1.9930633
2810 op-snap---monthly-publication-august-2025.pdf   785 2025-08 Car Vauxhall Corsa Silver Driving without Reasonable Consideration None Chapel Ash Island Chapel Ash Island Wolverhampton Wolverhampton NFA No Offence   52.5847884 -2.1341887
2816 op-snap---monthly-publication-august-2025.pdf   791 2025-08 Car Audi A5 Black Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.5919543 -1.8517118
2826 op-snap---monthly-publication-august-2025.pdf   801 2025-08 Car Audi A3 Grey Driving without Reasonable Consideration None Mere Green Road Mere Green Road Sutton Coldfield Sutton Coldfield NFA No Independent Evidence Available   52.5874888 -1.8297106
2827 op-snap---monthly-publication-august-2025.pdf   802 2025-08 Car Renault   White Driving without Reasonable Consideration None A447 Ashby Road Ashby Road Out of Force Are Out of Force Area NFA Out of Force      
2914 op-snap---monthly-publication-august-2025.pdf   889 2025-08 Car Kia   Grey Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham NFA No Offence   52.4543565 -1.9114004
2933 op-snap---monthly-publication-august-2025.pdf   908 2025-08 Car Audi Q3 Blue Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
2996 op-snap---monthly-publication-august-2025.pdf   971 2025-08 Pedal Bike BMW 118 Black Driving without Reasonable Consideration No Insurance Holders Lane Holders Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4446701 -1.9056872
3153 op-snap---monthly-publication-august-2025.pdf   1128 2025-08 Car Citroen Relay Grey Driving without Reasonable Consideration None Coleshill Road Coleshill Road Birmingham Birmingham NFA No Offence   52.4967329 -1.8097462
3196 op-snap---monthly-publication-august-2025.pdf   1171 2025-08 Car Vauxhall Adam Red Driving without Reasonable Consideration None M42 Jn 10, Warwickshire M42 Junction 10, Warwickshire Out of Force Are Out of Force Area NFA Out of Force      
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      
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
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
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
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
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
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      
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      
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
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      
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      
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      
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

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