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

112 rows where disposal = "NFA", month = "2025-07" and reporter_transport_mode = "Pedal Bike" 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 1

  • Pedal Bike · 112 ✖

month 1

  • 2025-07 · 112 ✖

disposal 1

  • NFA · 112 ✖
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
11965 op-snap---monthly-publication-july-2025.pdf   17 2025-07 Pedal Bike Mazda Three Black Using a Mobile Phone Whilst Driving None Sherlock Street Sherlock Street Birmingham Birmingham NFA No Independent Evidence Available   52.4702385 -1.895011
11986 op-snap---monthly-publication-july-2025.pdf   38 2025-07 Pedal Bike Ford Fiesta Brown Contravening a Red Traffic Light None Broomfield Road Broomfield Road Coventry Coventry NFA No Offence   52.4034143 -1.5300449
11992 op-snap---monthly-publication-july-2025.pdf   44 2025-07 Pedal Bike Kia Rio Silver Driving without Due Care and Attention None A38 Tyburn Road Tyburn Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5113867 -1.8337258
12005 op-snap---monthly-publication-july-2025.pdf   57 2025-07 Pedal Bike Ford Transit White Contravening a Red Traffic Light None Harborne Road Harborne Road Birmingham Birmingham NFA No Independent Evidence Available   52.4718503 -1.9195423
12006 op-snap---monthly-publication-july-2025.pdf   58 2025-07 Pedal Bike Peugeot 308 Grey Contravening a Red Traffic Light None Beauty Bank Beauty Bank Sandwell Sandwell NFA No Offence   52.4707042 -2.0596027
12038 op-snap---monthly-publication-july-2025.pdf   90 2025-07 Pedal Bike Ford Transit White Driving without Due Care and Attention None Olton Road Olton Road Solihull Solihull NFA Outside of 14 Days NIP   52.4193964 -1.8252207
12040 op-snap---monthly-publication-july-2025.pdf   92 2025-07 Pedal Bike BMW 520.. Black Driving without Due Care and Attention None St Bernards Road Street Bernards Road Solihull Solihull NFA Outside of 14 Days NIP      
12073 op-snap---monthly-publication-july-2025.pdf   125 2025-07 Pedal Bike Vauxhall astra Red Driving without Due Care and Attention None Forest Road Forest Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4467275 -1.8804014
12118 op-snap---monthly-publication-july-2025.pdf   170 2025-07 Pedal Bike Mercedes-Benz Sprinter White Using a Mobile Phone Whilst Driving None Newhall Street Newhall Street Birmingham Birmingham NFA No Independent Evidence Available   52.4830482 -1.905069
12125 op-snap---monthly-publication-july-2025.pdf   177 2025-07 Pedal Bike Audi Q5 Blue Driving without Due Care and Attention None Bookvale Road Bookvale Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12126 op-snap---monthly-publication-july-2025.pdf   178 2025-07 Pedal Bike Citroen C3 Blue Driving without Due Care and Attention None City Road City Road Birmingham Birmingham NFA No Offence   52.4763176 -1.9584897
12130 op-snap---monthly-publication-july-2025.pdf   182 2025-07 Pedal Bike Skoda   Black Driving without Due Care and Attention None Witton Road, Witton Lane Witton Road, Witton Lane Birmingham Birmingham NFA No VRM      
12132 op-snap---monthly-publication-july-2025.pdf   184 2025-07 Pedal Bike Daf   White Driving without Due Care and Attention None Gooch st at Bissell St Gooch st at Bissell Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4696234 -1.8952392
12133 op-snap---monthly-publication-july-2025.pdf   185 2025-07 Pedal Bike Volvo Bus Red Driving without Due Care and Attention None Moorend Avenue Moorend Avenue Birmingham Birmingham NFA No Offence      
12138 op-snap---monthly-publication-july-2025.pdf   190 2025-07 Pedal Bike Ford Fiesta Black Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham NFA No Independent Evidence Available   52.5359496 -1.8324115
12195 op-snap---monthly-publication-july-2025.pdf   247 2025-07 Pedal Bike Mini cooper Blue Driving without Due Care and Attention None Bewdley Bewdley Out of Force Area Out of Force Area NFA Out of Force   52.4330724 -1.9181313
12241 op-snap---monthly-publication-july-2025.pdf   293 2025-07 Pedal Bike Vauxhall Meriva White Driving without Due Care and Attention None Linden Road Linden Road Solihull Solihull NFA Outside of 14 Days NIP      
12242 op-snap---monthly-publication-july-2025.pdf   294 2025-07 Pedal Bike Vauxhall Corsa Grey Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4390303 -1.9512931
12244 op-snap---monthly-publication-july-2025.pdf   296 2025-07 Pedal Bike Hyundai I10 Red Driving without Due Care and Attention None Shenley Hill Shenley Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.4267534 -1.9790765
12245 op-snap---monthly-publication-july-2025.pdf   297 2025-07 Pedal Bike Volkswagen Passat Blue Driving without Due Care and Attention None Alwold Road Alwold Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4436471 -1.9604594
12266 op-snap---monthly-publication-july-2025.pdf   318 2025-07 Pedal Bike BMW X6 Grey Contravening a Red Traffic Light None New John Street New John Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4920451 -1.8920402
12273 op-snap---monthly-publication-july-2025.pdf   325 2025-07 Pedal Bike Ford Transit White Driving without Due Care and Attention None Haxelhurst Road Haxelhurst Road Birmingham Birmingham NFA No Offence      
12327 op-snap---monthly-publication-july-2025.pdf   379 2025-07 Pedal Bike Ford Fiesta Blue Driving without Due Care and Attention None Hazelhurts Road Hazelhurts Road Birmingham Birmingham NFA Not in Public Interest      
12350 op-snap---monthly-publication-july-2025.pdf   402 2025-07 Pedal Bike Mitsubishi Colt Black Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham NFA No Independent Evidence Available   52.4943878 -1.8504211
12353 op-snap---monthly-publication-july-2025.pdf   405 2025-07 Pedal Bike Audi A6... Black Driving without Due Care and Attention None Butts Road Butts Road Walsall Walsall NFA Not in Public Interest   52.592263 -1.9743536
12374 op-snap---monthly-publication-july-2025.pdf   426 2025-07 Pedal Bike Audi A3 White Using a Mobile Phone Whilst Driving None Warwick Road Warwick Road Birmingham Birmingham NFA No Independent Evidence Available   52.4555288 -1.8613929
12376 op-snap---monthly-publication-july-2025.pdf   428 2025-07 Pedal Bike Ford Fiesta ST Red Using a Mobile Phone Whilst Driving None Moor Green Lane Moor Green Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4374665 -1.9119895
12417 op-snap---monthly-publication-july-2025.pdf   469 2025-07 Pedal Bike Renault Captur Silver Driving without Due Care and Attention None Upper Hill Street Upper Hill Street Coventry Coventry NFA No Offence   52.4106808 -1.5185684
12420 op-snap---monthly-publication-july-2025.pdf   472 2025-07 Pedal Bike Land Rover Discovery Silver Driving without Due Care and Attention None Bridgenorth Road Bridgenorth Road Out of Force Area Out of Force Area NFA Out of Force      
12422 op-snap---monthly-publication-july-2025.pdf   474 2025-07 Pedal Bike Mazda 6... Red Driving without Due Care and Attention None Melrose Avenue Melrose Avenue Sutton Coldfield Sutton Coldfield NFA No Offence   52.5511462 -1.8479052
12423 op-snap---monthly-publication-july-2025.pdf   475 2025-07 Pedal Bike Ford fiesta Silver Dangerous Driving None Worcester, West Mercia Force area Worcester, West Mercia Force area Out of Force Area Out of Force Area NFA Out of Force      
12435 op-snap---monthly-publication-july-2025.pdf   487 2025-07 Pedal Bike Ford Transit Red Using a Mobile Phone Whilst Driving None Pineapple Road Pineapple Road Birmingham Birmingham NFA No Independent Evidence Available   52.4303068 -1.9077938
12457 op-snap---monthly-publication-july-2025.pdf   509 2025-07 Pedal Bike BMW M135i Grey Driving without Due Care and Attention None Shilton Lane Shilton Lane Coventry Coventry NFA Outside of 14 Days NIP   52.4425711 -1.4532921
12485 op-snap---monthly-publication-july-2025.pdf   537 2025-07 Pedal Bike Vauxhall Zafira Silver Driving without Due Care and Attention None Thruxton, Herefordshire Thruxton, Herefordshire Out of Force Area Out of Force Area NFA Out of Force      
12502 op-snap---monthly-publication-july-2025.pdf   554 2025-07 Pedal Bike Porsche 911 turbo Silver Contravening a Red Traffic Light None Upper Sutton St Junction Upper Sutton Street Junction Birmingham Birmingham NFA No Independent Evidence Available      
12504 op-snap---monthly-publication-july-2025.pdf   556 2025-07 Pedal Bike Nissan Micra Black Driving without Due Care and Attention None Talbot Street, Hockley Talbot Street, Hockley Birmingham Birmingham NFA No Independent Evidence Available   52.4956227 -1.9324692
12507 op-snap---monthly-publication-july-2025.pdf   559 2025-07 Pedal Bike Audi Q4 Black Contravening a Red Traffic Light None Ashleigh Road Ashleigh Road Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.4177582 -1.7873644
12513 op-snap---monthly-publication-july-2025.pdf   565 2025-07 Pedal Bike BMW X3 Blue Driving without Due Care and Attention None Norton Rd Stourbridge Norton Road Stourbridge Metropolitan Borough of Dudley Metropolitan Borough Of Dudley NFA No Offence   52.4388442 -2.1645703
12561 op-snap---monthly-publication-july-2025.pdf   613 2025-07 Pedal Bike Fiat 500 Black Misc - Non Traffic Offences None Heath Road Heath Road Birmingham Birmingham NFA No Offence   52.4220874 -1.9409615
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      
12585 op-snap---monthly-publication-july-2025.pdf   637 2025-07 Pedal Bike Citroen C3 Black Misc - Non Traffic Offences None Abercorn Road Abercorn Road Coventry Coventry NFA No Offence   52.4069184 -1.5387034
12610 op-snap---monthly-publication-july-2025.pdf   662 2025-07 Pedal Bike Land Rover Freelander Black Driving without Due Care and Attention None Robin Hood Island Robin Hood Island Birmingham Birmingham NFA No Offence   52.4220705 -1.8372335
12624 op-snap---monthly-publication-july-2025.pdf   676 2025-07 Pedal Bike Skoda Fabia Grey Driving without Due Care and Attention None Merritts Hill Merritts Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.424853 -1.9814275
12630 op-snap---monthly-publication-july-2025.pdf   682 2025-07 Pedal Bike Volvo Aggregate Truck White Contravening a Red Traffic Light None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
12639 op-snap---monthly-publication-july-2025.pdf   691 2025-07 Pedal Bike Mercedes-Benz E class Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12641 op-snap---monthly-publication-july-2025.pdf   693 2025-07 Pedal Bike Volkswagen Polo Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12642 op-snap---monthly-publication-july-2025.pdf   694 2025-07 Pedal Bike Seat Leon Purple Using a Mobile Phone Whilst Driving None Genners Lane Genners Lane Birmingham Birmingham NFA No Offence   52.4282602 -1.9861769
12646 op-snap---monthly-publication-july-2025.pdf   698 2025-07 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None Norman Place Road Norman Place Road Coventry Coventry NFA No Offence   52.4285935 -1.5370895
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
12695 op-snap---monthly-publication-july-2025.pdf   747 2025-07 Pedal Bike Mazda model 6 White Contravening a Red Traffic Light None Fletchamstead Highway Fletchamstead Highway Coventry Coventry NFA No Offence   52.396476 -1.5561348
12697 op-snap---monthly-publication-july-2025.pdf   749 2025-07 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Valley Road, Earlswood Valley Road, Earlswood Out of Force Area Out of Force Area NFA Out of Force      
12700 op-snap---monthly-publication-july-2025.pdf   752 2025-07 Pedal Bike Jaguar XF Silver Misc - Non Traffic Offences None Albany Road Albany Road Coventry Coventry NFA No Independent Evidence Available   52.4006218 -1.5284125
12706 op-snap---monthly-publication-july-2025.pdf   758 2025-07 Pedal Bike Peugeot 208 White Contravening a Red Traffic Light None Fletchamstead Highway Fletchamstead Highway Coventry Coventry NFA No Independent Evidence Available   52.396476 -1.5561348
12719 op-snap---monthly-publication-july-2025.pdf   771 2025-07 Pedal Bike BMW   Black Driving without Due Care and Attention None Packwood Road Packwood Road Solihull Solihull NFA No Offence   52.3617789 -1.7409895
12730 op-snap---monthly-publication-july-2025.pdf   782 2025-07 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Close Pass Close Pass Dudley Dudley NFA Outside of 14 Days NIP      
12758 op-snap---monthly-publication-july-2025.pdf   810 2025-07 Pedal Bike Mini Mini Black Using a Mobile Phone Whilst Driving None Belbroughton Road Belbroughton Road Out of Force Area Out of Force Area NFA Out of Force   52.4413333 -2.0647198
12759 op-snap---monthly-publication-july-2025.pdf   811 2025-07 Pedal Bike   Van White Using a Mobile Phone Whilst Driving None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
12760 op-snap---monthly-publication-july-2025.pdf   812 2025-07 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12761 op-snap---monthly-publication-july-2025.pdf   813 2025-07 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None Northfiled Road Northfiled Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12762 op-snap---monthly-publication-july-2025.pdf   814 2025-07 Pedal Bike Volkswagen Passatt Blue Driving without Due Care and Attention None Lordswood Road Lordswood Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4591339 -1.9601054
12763 op-snap---monthly-publication-july-2025.pdf   815 2025-07 Pedal Bike Vauxhall Corsa Red Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12764 op-snap---monthly-publication-july-2025.pdf   816 2025-07 Pedal Bike Iveco Daily White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12765 op-snap---monthly-publication-july-2025.pdf   817 2025-07 Pedal Bike Mercedes-Benz GLC 220 Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
12767 op-snap---monthly-publication-july-2025.pdf   819 2025-07 Pedal Bike Mg zs Yellow Driving without Due Care and Attention None Lordswood roundabout Lordswood roundabout Birmingham Birmingham NFA Outside of 14 Days NIP      
12768 op-snap---monthly-publication-july-2025.pdf   820 2025-07 Pedal Bike   Perodua Black Driving without Due Care and Attention None The Barley lea The Barley lea Coventry Coventry NFA Outside of 14 Days NIP   52.3952661 -1.4705187
12775 op-snap---monthly-publication-july-2025.pdf   827 2025-07 Pedal Bike Renault   Blue Driving without Due Care and Attention None Gravelly Lane Gravelly Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.534608 -1.8379769
12808 op-snap---monthly-publication-july-2025.pdf   860 2025-07 Pedal Bike BMW X5.. Black Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA No Independent Evidence Available   52.4552785 -1.906384
12912 op-snap---monthly-publication-july-2025.pdf   964 2025-07 Pedal Bike BMW 116 Silver Driving without Due Care and Attention None Highfield Road Highfield Road Wolverhampton Wolverhampton NFA No Offence   52.5570756 -2.073188
12914 op-snap---monthly-publication-july-2025.pdf   966 2025-07 Pedal Bike Ford Transit Silver Driving without Due Care and Attention None Willenhall Road Willenhall Road Wolverhampton Wolverhampton NFA Outside of 14 Days NIP   52.5836778 -2.0894997
12942 op-snap---monthly-publication-july-2025.pdf   994 2025-07 Pedal Bike Porsche Cayenne Black Using a Mobile Phone Whilst Driving None Ancester Road Alcester Road Birmingham Birmingham NFA No Independent Evidence Available   52.4470686 -1.8880749
12949 op-snap---monthly-publication-july-2025.pdf   1001 2025-07 Pedal Bike BMW 335.. Blue Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham NFA No Offence   52.4390303 -1.9512931
12951 op-snap---monthly-publication-july-2025.pdf   1003 2025-07 Pedal Bike Mercedes-Benz E220 Grey Driving without Due Care and Attention None Chester Road, Streetly Chester Road, Streetly Sutton Coldfield Sutton Coldfield NFA Outside of 14 Days NIP      
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      
12983 op-snap---monthly-publication-july-2025.pdf   1035 2025-07 Pedal Bike Toyota Aygo Red Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5359496 -1.8324115
13015 op-snap---monthly-publication-july-2025.pdf   1067 2025-07 Pedal Bike Ford Independance Blue Driving without Reasonable Consideration None Friar Park Road , Wednesbury Friar Park Road , Wednesbury Sandwell Sandwell NFA Outside of 14 Days NIP   52.5538676 -1.9965667
13047 op-snap---monthly-publication-july-2025.pdf   1099 2025-07 Pedal Bike Land Rover Range Rover Grey Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4415108 -1.8971434
13057 op-snap---monthly-publication-july-2025.pdf   1109 2025-07 Pedal Bike Toyota Hi Lux Grey Cause vehicle to be left in a dangerous position None A38 Tyburn Road , Birmingham Tyburn Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5227071 -1.8071946
13066 op-snap---monthly-publication-july-2025.pdf   1118 2025-07 Pedal Bike Toyota Prius Silver Driving without Due Care and Attention None War Lane, harborne War Lane, harborne Birmingham Birmingham NFA Outside of 14 Days NIP   52.4569552 -1.9616483
13067 op-snap---monthly-publication-july-2025.pdf   1119 2025-07 Pedal Bike Ford Fiesta White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13068 op-snap---monthly-publication-july-2025.pdf   1120 2025-07 Pedal Bike Ford Fiesta White Using a Mobile Phone Whilst Driving None Northfield Road Northfield Road Birmingham Birmingham NFA No Offence   52.4167654 -1.9411244
13069 op-snap---monthly-publication-july-2025.pdf   1121 2025-07 Pedal Bike Audi Q6 Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13070 op-snap---monthly-publication-july-2025.pdf   1122 2025-07 Pedal Bike Volkswagen Polo White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13071 op-snap---monthly-publication-july-2025.pdf   1123 2025-07 Pedal Bike Mini Cooper Green Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13072 op-snap---monthly-publication-july-2025.pdf   1124 2025-07 Pedal Bike Toyota Corolla Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4167654 -1.9411244
13074 op-snap---monthly-publication-july-2025.pdf   1126 2025-07 Pedal Bike Ford Fusion Black Driving without Due Care and Attention None Stonehouse Hill Stonehouse Hill Birmingham Birmingham NFA Outside of 14 Days NIP   52.4448348 -1.9713792
13075 op-snap---monthly-publication-july-2025.pdf   1127 2025-07 Pedal Bike     Blue Driving without Due Care and Attention None War Lane Harbourne War Lane Harbourne Birmingham Birmingham NFA Outside of 14 Days NIP      
13076 op-snap---monthly-publication-july-2025.pdf   1128 2025-07 Pedal Bike Volkswagen Tiguan Blue Driving without Due Care and Attention None Alwood Road Alwood Road Birmingham Birmingham NFA Outside of 14 Days NIP      
13077 op-snap---monthly-publication-july-2025.pdf   1129 2025-07 Pedal Bike Seat Ibiza White Driving without Due Care and Attention None Alwood Road Alwood Road Birmingham Birmingham NFA No Offence      
13078 op-snap---monthly-publication-july-2025.pdf   1130 2025-07 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham NFA No Offence   52.4468506 -1.9395619
13079 op-snap---monthly-publication-july-2025.pdf   1131 2025-07 Pedal Bike Peugeot Expert White Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham NFA No Offence   52.4167654 -1.9411244
13088 op-snap---monthly-publication-july-2025.pdf   1140 2025-07 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None Toll End Road Tipton Toll End Road Tipton Sandwell Sandwell NFA No Offence   52.5404048 -2.0400078
13091 op-snap---monthly-publication-july-2025.pdf   1143 2025-07 Pedal Bike Toyota Prius Silver Cause vehicle to be left in a dangerous position None A452 Chester Road , Chemsley Wood Chester Road , Chemsley Wood Birmingham Birmingham NFA Outside of 14 Days NIP      
13103 op-snap---monthly-publication-july-2025.pdf   1155 2025-07 Pedal Bike Land Rover Defender Green Driving without Due Care and Attention None Killhorse Lane (Ludlow) Killhorse Lane (Ludlow) Out of Force Area Out of Force Area NFA Out of Force      
13127 op-snap---monthly-publication-july-2025.pdf   1179 2025-07 Pedal Bike BMW   White Driving without Reasonable Consideration None Junction of Colmore Crescent and Dy Junction of Colmore Crescent and Dy oBtti rRmoinagdh ,a Bmirmingham Obtti Rrmoinagdh ,A Bmirmingham NFA Outside of 14 Days NIP      

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