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

442 rows where council_area = "Birmingham", disposal = "NFA" and month = "2025-07" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

reporter_transport_mode 6

month 1

  • 2025-07 · 442 ✖

disposal 1

  • NFA · 442 ✖

council_area 1

  • Birmingham · 442 ✖
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
11948 op-snap---monthly-publication-july-2025.pdf   0 2025-07 Car Ford Focus Silver Driving without Due Care and Attention None Russell Road Russell Road Birmingham Birmingham NFA No Offence   52.4398245 -1.8469786
11954 op-snap---monthly-publication-july-2025.pdf   6 2025-07 Car Nissan NP Black Contravening a Red Traffic Light None Nechells Parkway Nechells Parkway Birmingham Birmingham NFA No VRM   52.4922722 -1.8711754
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
11963 op-snap---monthly-publication-july-2025.pdf   15 2025-07 Car Kia   Black Contravening a Red Traffic Light None Ladypool Road Ladypool Road Birmingham Birmingham NFA No Independent Evidence Available   52.4520441 -1.8787544
11964 op-snap---monthly-publication-july-2025.pdf   16 2025-07 Car Peugeot   White Contravening a Red Traffic Light None Stoney Lane Stoney Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4745488 -1.8065911
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
11967 op-snap---monthly-publication-july-2025.pdf   19 2025-07 Pedestrian Seat Leon Blue Driving without Due Care and Attention None Heath Road South Heath Road South Birmingham Birmingham NFA No VRM   52.415858 -1.9632649
11969 op-snap---monthly-publication-july-2025.pdf   21 2025-07 Car Skoda Kamiq White Contravening a Red Traffic Light None Robin Hood Lane Robin Hood Lane Birmingham Birmingham NFA No Offence   52.4221526 -1.8425617
11972 op-snap---monthly-publication-july-2025.pdf   24 2025-07 Car Volkswagen   Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Independent Evidence Available   52.4203897 -1.8338574
11987 op-snap---monthly-publication-july-2025.pdf   39 2025-07 Car Ford Focus Black Driving without Due Care and Attention None Hagley Road Hagley Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.471632 -1.9456776
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
11995 op-snap---monthly-publication-july-2025.pdf   47 2025-07 Car Mercedes-Benz   Grey Driving without Due Care and Attention None Rocky Lane Rocky Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.5285859 -1.9100513
11996 op-snap---monthly-publication-july-2025.pdf   48 2025-07 Car Seat   Red Driving without Due Care and Attention None Rabone Lane Rabone Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4998908 -1.952631
11998 op-snap---monthly-publication-july-2025.pdf   50 2025-07 Car Peugeot 308 White Contravening a Red Traffic Light None Crocketts Lane Crocketts Lane Birmingham Birmingham NFA No Independent Evidence Available      
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
12027 op-snap---monthly-publication-july-2025.pdf   79 2025-07 Car Audi A6 Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4203897 -1.8338574
12039 op-snap---monthly-publication-july-2025.pdf   91 2025-07 Motorbike Vauxhall Corsa Grey Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5919543 -1.8517118
12046 op-snap---monthly-publication-july-2025.pdf   98 2025-07 Car Volkswagen Golf Blue Contravening a Red Traffic Light None Newtown Middleway Newtown Middleway Birmingham Birmingham NFA No Independent Evidence Available   52.4922617 -1.8912734
12052 op-snap---monthly-publication-july-2025.pdf   104 2025-07 Car Volkswagen Golf R Black Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4282602 -1.9861769
12053 op-snap---monthly-publication-july-2025.pdf   105 2025-07 Car Audi RS3 Blue Driving without Due Care and Attention None Genners Lane Genners Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4282602 -1.9861769
12061 op-snap---monthly-publication-july-2025.pdf   113 2025-07 Car Alfa Romeo Polo Black Driving without Due Care and Attention None Montague Street Montague Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4816806 -1.8788939
12063 op-snap---monthly-publication-july-2025.pdf   115 2025-07 Pedestrian Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham NFA No Independent Evidence Available   52.5359496 -1.8324115
12066 op-snap---monthly-publication-july-2025.pdf   118 2025-07 Car   Corsa Grey Contravening a Red Traffic Light None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
12068 op-snap---monthly-publication-july-2025.pdf   120 2025-07 Car Mercedes-Benz E220 Black Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Edward Road Edward Road Birmingham Birmingham NFA No Independent Evidence Available   52.4580901 -1.894458
12072 op-snap---monthly-publication-july-2025.pdf   124 2025-07 Car Volvo V40.. Grey Driving without Due Care and Attention None East Midway East Midway Birmingham Birmingham 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
12075 op-snap---monthly-publication-july-2025.pdf   127 2025-07 Other Hyundai Tucson White Cause vehicle to be left in a dangerous position None Institute Road Institute Road Birmingham Birmingham NFA No Offence   52.4334781 -1.8892337
12076 op-snap---monthly-publication-july-2025.pdf   128 2025-07 Other Mercedes-Benz C class Blue Driving without Due Care and Attention None Star City Star City Birmingham Birmingham NFA Not in Public Interest   52.5054363 -1.8556273
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
12091 op-snap---monthly-publication-july-2025.pdf   143 2025-07 Car Mg ZS Black Driving without Due Care and Attention None A4540 Bordesley Middleway Bordesley Middleway Birmingham Birmingham NFA Outside of 14 Days NIP   52.4704236 -1.8769606
12096 op-snap---monthly-publication-july-2025.pdf   148 2025-07 Car Vauxhall Insignia Red Driving without Due Care and Attention None M6 Motorway M6 Motorway Birmingham Birmingham NFA Outside of 14 Days NIP   52.5327447 -1.899844
12099 op-snap---monthly-publication-july-2025.pdf   151 2025-07 Pedestrian Nissan Juke Red Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham NFA No Independent Evidence Available   52.4622646 -1.8599985
12108 op-snap---monthly-publication-july-2025.pdf   160 2025-07 Car Seat Leon Black Contravening a Red Traffic Light None Shenley Fields Road Shenley Fields Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4373076 -1.9543847
12109 op-snap---monthly-publication-july-2025.pdf   161 2025-07 Car Ford Fiesta Blue Contravening a Red Traffic Light None East meadway East meadway Birmingham Birmingham NFA No Independent Evidence Available   52.4813031 -1.7670825
12116 op-snap---monthly-publication-july-2025.pdf   168 2025-07 Car Ford Ranger White Driving without Due Care and Attention None Tile Hill Lane Tile Hill Lane Birmingham Birmingham NFA Outside of 14 Days NIP      
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
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
12149 op-snap---monthly-publication-july-2025.pdf   201 2025-07 Other   NP   Misc - Non Traffic Offences No Insurance Unknown   Birmingham Birmingham NFA No Independent Evidence Available      
12155 op-snap---monthly-publication-july-2025.pdf   207 2025-07 Car Porsche   Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
12163 op-snap---monthly-publication-july-2025.pdf   215 2025-07 Car Volkswagen Golf Grey Contravening a Red Traffic Light None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
12165 op-snap---monthly-publication-july-2025.pdf   217 2025-07 Other BMW 3 series Black Misc - Non Traffic Offences None A38 A38 Birmingham Birmingham NFA No Independent Evidence Available      
12173 op-snap---monthly-publication-july-2025.pdf   225 2025-07 Car Mercedes-Benz Vito White Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.5083238 -1.8332287
12186 op-snap---monthly-publication-july-2025.pdf   238 2025-07 Car Volkswagen Polo Blue Contravene Lane Closure Red X None Morris Road Morris Road Birmingham Birmingham NFA No Offence   52.4953902 -1.8236361
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
12201 op-snap---monthly-publication-july-2025.pdf   253 2025-07 Car Peugeot 206 Grey Driving without Due Care and Attention No Insurance Barn Lane Barn Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4307492 -1.8828708
12202 op-snap---monthly-publication-july-2025.pdf   254 2025-07 Pedestrian Skoda   Black Contravening a Red Traffic Light None Edgbaston Road Edgbaston Road Birmingham Birmingham NFA No Independent Evidence Available   52.4552785 -1.906384
12205 op-snap---monthly-publication-july-2025.pdf   257 2025-07 Pedestrian Toyota Corolla White Using a Mobile Phone Whilst Driving None Stephenson Street Stephenson Street Birmingham Birmingham NFA No Independent Evidence Available   52.4787219 -1.9004997
12237 op-snap---monthly-publication-july-2025.pdf   289 2025-07 Car Nissan   Black Contravening a Red Traffic Light None Clarence Road Clarence Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5940902 -1.843503
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
12247 op-snap---monthly-publication-july-2025.pdf   299 2025-07 Car Audi A5 Black Contravening a Red Traffic Light None Newport Road Newport Road Birmingham Birmingham NFA No Independent Evidence Available   52.5027779 -1.7982159
12250 op-snap---monthly-publication-july-2025.pdf   302 2025-07 Car Audi A4 Grey Driving without Due Care and Attention None Collector Road Collector Road Birmingham Birmingham NFA No VRM   52.5139393 -1.7600186
12255 op-snap---monthly-publication-july-2025.pdf   307 2025-07 Pedestrian Audi A6 White Using a Mobile Phone Whilst Driving None Cartland Road Cartland Road Birmingham Birmingham NFA No Independent Evidence Available   52.4298554 -1.9086629
12260 op-snap---monthly-publication-july-2025.pdf   312 2025-07 Car Toyota Estima Black Driving without Due Care and Attention None M6 Motorway M6 Motorway Birmingham Birmingham NFA Outside of 14 Days NIP   52.5327447 -1.899844
12262 op-snap---monthly-publication-july-2025.pdf   314 2025-07 Car Toyota Corolla Grey Driving without Due Care and Attention None Bishopgate Street Bishopgate Street Birmingham Birmingham NFA No Offence      
12264 op-snap---monthly-publication-july-2025.pdf   316 2025-07 Car Peugeot 308 Silver Driving without Due Care and Attention None Five Ways Island Five Ways Island Birmingham Birmingham NFA Outside of 14 Days NIP      
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
12272 op-snap---monthly-publication-july-2025.pdf   324 2025-07 Pedestrian Honda FSH125 White Using a Mobile Phone Whilst Driving None Moore Streer Moore Streer Birmingham Birmingham NFA No Offence      
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      
12280 op-snap---monthly-publication-july-2025.pdf   332 2025-07 Car Ford Puma Blue Contravening a Red Traffic Light None Wake Green Road Wake Green Road Birmingham Birmingham NFA No Offence   52.4437078 -1.8783408
12285 op-snap---monthly-publication-july-2025.pdf   337 2025-07 Car Jaguar I Pace Grey Contravening a Red Traffic Light None Robin Hood Island Robin Hood Island Birmingham Birmingham NFA No Offence   52.4220705 -1.8372335
12288 op-snap---monthly-publication-july-2025.pdf   340 2025-07 Car Ford Fiesta Red Contravening a Red Traffic Light None Ladypool Road Ladypool Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4520441 -1.8787544
12290 op-snap---monthly-publication-july-2025.pdf   342 2025-07 Car BMW X5 Black Driving without Due Care and Attention None Lancaster Street Lancaster Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4888759 -1.8941126
12291 op-snap---monthly-publication-july-2025.pdf   343 2025-07 Car Citroen C4 Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5919543 -1.8517118
12293 op-snap---monthly-publication-july-2025.pdf   345 2025-07 Car Mercedes-Benz GLE Black Driving without Due Care and Attention None Dyas Road, Kingstanding Dyas Road, Kingstanding Birmingham Birmingham NFA Outside of 14 Days NIP   52.5440194 -1.892884
12294 op-snap---monthly-publication-july-2025.pdf   346 2025-07 Car Toyota Verso Black Driving without Due Care and Attention None Newbury Roaad Newbury Roaad Birmingham Birmingham NFA Outside of 14 Days NIP      
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
12313 op-snap---monthly-publication-july-2025.pdf   365 2025-07 Car Volkswagen Craftor White Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5292752 -1.7618805
12319 op-snap---monthly-publication-july-2025.pdf   371 2025-07 Car Seat Leon Black Driving without Due Care and Attention None Billesley Lane Billesley Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4344402 -1.8845368
12320 op-snap---monthly-publication-july-2025.pdf   372 2025-07 Car Nissan Juke White Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4203897 -1.8338574
12321 op-snap---monthly-publication-july-2025.pdf   373 2025-07 Car Seat Ibiza Gold Contravening a Red Traffic Light None Yardley Wood Road Yardley Wood Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4103191 -1.8670224
12323 op-snap---monthly-publication-july-2025.pdf   375 2025-07 Car BMW 220D Black Driving without Due Care and Attention None Gloucester WAY Gloucester WAY Birmingham Birmingham NFA No Offence      
12324 op-snap---monthly-publication-july-2025.pdf   376 2025-07 Car Volkswagen   Grey Driving without Due Care and Attention None M6 Motorway M6 Motorway Birmingham Birmingham NFA No Independent Evidence Available   52.5327447 -1.899844
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      
12328 op-snap---monthly-publication-july-2025.pdf   380 2025-07 Car Citroen DS3 Red Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4726661 -1.8769032
12331 op-snap---monthly-publication-july-2025.pdf   383 2025-07 Car Mercedes-Benz GLC 300 Grey Driving without Due Care and Attention None Graveley Hill Graveley Hill Birmingham Birmingham NFA Outside of 14 Days NIP      
12333 op-snap---monthly-publication-july-2025.pdf   385 2025-07 Car Renault   White Using a Mobile Phone Whilst Driving None Burman Road Burman Road Birmingham Birmingham NFA No Independent Evidence Available      
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
12363 op-snap---monthly-publication-july-2025.pdf   415 2025-07 Pedestrian Toyota Prius White Contravening a Red Traffic Light None Bordsley Green Road Bordsley Green Road Birmingham Birmingham NFA No Offence      
12373 op-snap---monthly-publication-july-2025.pdf   425 2025-07 Car Jaguar XF Black Driving without Due Care and Attention None Salisbury Road Salisbury Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4943878 -1.8504211
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
12384 op-snap---monthly-publication-july-2025.pdf   436 2025-07 Car Ford Mondeo Black Contravening a Red Traffic Light No Insurance Wake Green Road Wake Green Road Birmingham Birmingham NFA No Independent Evidence Available   52.4437078 -1.8783408
12387 op-snap---monthly-publication-july-2025.pdf   439 2025-07 Car BMW X5 Black Contravening a Red Traffic Light None Spring Road Spring Road Birmingham Birmingham NFA No VRM   52.444262 -1.8362585
12389 op-snap---monthly-publication-july-2025.pdf   441 2025-07 Car Peugeot 5008 Grey Contravening a Red Traffic Light None Reddings Lane Reddings Lane Birmingham Birmingham NFA No Offence   52.4506039 -1.8463952
12411 op-snap---monthly-publication-july-2025.pdf   463 2025-07 Pedestrian Honda Jazz Brown Contravening a Red Traffic Light None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
12426 op-snap---monthly-publication-july-2025.pdf   478 2025-07 Car Volkswagen Golf Silver Contravening a Red Traffic Light None A452 A452 Birmingham Birmingham NFA Outside of 14 Days NIP      
12427 op-snap---monthly-publication-july-2025.pdf   479 2025-07 Car BMW 3 series Purple Driving without Due Care and Attention None M6 Southbound M6 Southbound Birmingham Birmingham NFA Outside of 14 Days NIP      
12429 op-snap---monthly-publication-july-2025.pdf   481 2025-07 Car BMW 1 series Black Driving without Due Care and Attention None M6 Southbound M6 Southbound Birmingham Birmingham NFA Outside of 14 Days NIP      
12434 op-snap---monthly-publication-july-2025.pdf   486 2025-07 Other Nissan Qashqai Grey Driving without Due Care and Attention None UK Uk Birmingham Birmingham NFA No Independent Evidence Available   52.45124 -1.937937
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
12437 op-snap---monthly-publication-july-2025.pdf   489 2025-07 Car Skoda Enyaq Black Driving without Due Care and Attention None Kings Road Kings Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5531351 -1.8852761
12440 op-snap---monthly-publication-july-2025.pdf   492 2025-07 Car Vauxhall Corsa Grey Using a Mobile Phone Whilst Driving None Yardley Wood Road Yardley Wood Road Birmingham Birmingham NFA No Independent Evidence Available   52.4103191 -1.8670224

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