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

840 rows where council_area = "Birmingham" and vehicle_make = "Vauxhall" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale, witness_contacted

offence >30

month 14

reporter_transport_mode 7

vehicle_make 1

  • Vauxhall · 840 ✖

council_area 1

  • Birmingham · 840 ✖
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
7260 op-snap---monthly-publication-february-2026.pdf   7 2026-02 Car Vauxhall Astra Grey Contravening a Red Traffic Light None Hamstead Hill Hamstead Hill Birmingham Birmingham Education N/A   52.5274116 -1.9287273
7307 op-snap---monthly-publication-february-2026.pdf   54 2026-02 Pedestrian Vauxhall Vivaro White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Marys Row Street Marys Row Birmingham Birmingham Fixed Penalty N/A      
7316 op-snap---monthly-publication-february-2026.pdf   63 2026-02 Pedestrian Vauxhall Corsa Silver Cause vehicle to be left in a dangerous position None Heeley Road Heeley Road Birmingham Birmingham Education N/A   52.4401847 -1.9331572
7339 op-snap---monthly-publication-february-2026.pdf   86 2026-02 Car Vauxhall Adam Red Stop a vehicle on pedestrian crossing None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
7353 op-snap---monthly-publication-february-2026.pdf   100 2026-02 Pedal Bike Vauxhall Corsa Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
7360 op-snap---monthly-publication-february-2026.pdf   107 2026-02 Pedal Bike Vauxhall Astra Black Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
7446 op-snap---monthly-publication-february-2026.pdf   193 2026-02 Pedestrian Vauxhall Corsa Red Cause vehicle to be left in a dangerous position None Dowar Road / Irvine Road Dowar Road / Irvine Road Birmingham Birmingham Education N/A   52.3932301 -1.9992819
7461 op-snap---monthly-publication-february-2026.pdf   208 2026-02 Car Vauxhall Astra Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Paignton Road Paignton Road Birmingham Birmingham Warning Letter N/A   52.4852515 -1.9481717
7465 op-snap---monthly-publication-february-2026.pdf   212 2026-02 Pedestrian Vauxhall Corsa Grey Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Moor Green Lane Moor Green Lane Birmingham Birmingham Fixed Penalty N/A   52.4374665 -1.9119895
7518 op-snap---monthly-publication-february-2026.pdf   265 2026-02 Pedestrian Vauxhall Crossland Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Rotten Park Road Rotten Park Road Birmingham Birmingham Fixed Penalty N/A      
7527 op-snap---monthly-publication-february-2026.pdf   274 2026-02 Car Vauxhall Zafira Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Holland Street Holland Street Birmingham Birmingham Warning Letter N/A   52.5594346 -1.8239493
7577 op-snap---monthly-publication-february-2026.pdf   324 2026-02 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Bromyard Road Bromyard Road Birmingham Birmingham Education N/A   52.4457403 -1.8536648
7591 op-snap---monthly-publication-february-2026.pdf   338 2026-02 Car Vauxhall Zafira Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Great Charles Street Queensway Great Charles Street Queensway Birmingham Birmingham Fixed Penalty N/A   52.4821283 -1.9037074
7667 op-snap---monthly-publication-february-2026.pdf   414 2026-02 Other Vauxhall Zafira Blue Drive / Ride / Lead an animal on a footpath None Kingstanding Road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
7755 op-snap---monthly-publication-february-2026.pdf   502 2026-02 Car Vauxhall Meriva White Contravening a Red Traffic Light None Hampstead Road at Victorian Way Hampstead Road at Victorian Way Birmingham Birmingham Education N/A   52.3993507 -1.9640409
7840 op-snap---monthly-publication-february-2026.pdf   587 2026-02 Pedestrian Vauxhall Insignia Black Cause vehicle to be left in a dangerous position None Cherry Orchard Road, Handsworth Cherry Orchard Road, Handsworth Birmingham Birmingham Fixed Penalty N/A   52.524872 -1.9253914
7875 op-snap---monthly-publication-february-2026.pdf   622 2026-02 Car Vauxhall Vivaro White Cause vehicle to be left in a dangerous position No Insurance Alum Rock Road, Ward End Alum Rock Road, Ward End Birmingham Birmingham Fixed Penalty N/A   52.4928469 -1.8196362
7885 op-snap---monthly-publication-february-2026.pdf   632 2026-02 Car Vauxhall Corsa Blue Driving without Due Care and Attention None M6 after J4 M6 after J4 Birmingham Birmingham Education N/A      
7893 op-snap---monthly-publication-february-2026.pdf   640 2026-02 Other Vauxhall Zafira Silver Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham Education N/A   52.5265939 -1.8509884
7895 op-snap---monthly-publication-february-2026.pdf   642 2026-02 Other Vauxhall Vivaro Black Cause vehicle to be left in a dangerous position None Glenville Drive Glenville Drive Birmingham Birmingham Education N/A   52.5265939 -1.8509884
7973 op-snap---monthly-publication-february-2026.pdf   720 2026-02 Pedestrian Vauxhall Corsa Grey Cause vehicle to be left in a dangerous position None Institute Road Institute Road Birmingham Birmingham Education N/A   52.4334781 -1.8892337
7977 op-snap---monthly-publication-february-2026.pdf   724 2026-02 Other Vauxhall Astra White Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Glenville Drive Glenville Drive Birmingham Birmingham Fixed Penalty N/A   52.5265939 -1.8509884
7982 op-snap---monthly-publication-february-2026.pdf   729 2026-02 Pedestrian Vauxhall Corsa White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Tixall Road Tixall Road Birmingham Birmingham Fixed Penalty N/A   52.4193312 -1.8517995
7999 op-snap---monthly-publication-february-2026.pdf   746 2026-02 Pedestrian Vauxhall Mokka Blue Misc - Non Traffic Offences None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
8113 op-snap---monthly-publication-february-2026.pdf   860 2026-02 Car Vauxhall Mokka Silver Driving without Due Care and Attention None Foundry Road Foundry Road Birmingham Birmingham Education N/A   52.4939937 -1.9413942
8123 op-snap---monthly-publication-february-2026.pdf   870 2026-02 Lorry Vauxhall Mokka White Driving without Due Care and Attention None M6 Jct 6 North M6 Junction 6 North Birmingham Birmingham Fixed Penalty N/A   52.6760749 -2.0862582
8280 op-snap---monthly-publication-february-2026.pdf   1027 2026-02 Pedestrian Vauxhall Corsa Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wills Street Lozells Wills Street Lozells Birmingham Birmingham NFA No Independent Evidence Available   52.500453 -1.9141126
8281 op-snap---monthly-publication-february-2026.pdf   1028 2026-02 Pedestrian Vauxhall Astra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Wills Street Lozells Wills Street Lozells Birmingham Birmingham NFA No Independent Evidence Available   52.500453 -1.9141126
8315 op-snap---monthly-publication-february-2026.pdf   1062 2026-02 Car Vauxhall Astra Silver Driving without Due Care and Attention None Six Ways Aston Six Ways Aston Birmingham Birmingham Warning Letter N/A   52.502463 -1.8995194
8346 op-snap---monthly-publication-february-2026.pdf   1093 2026-02 Other Vauxhall astra Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None churchill road Churchill Road Birmingham Birmingham Warning Letter N/A   52.5529597 -1.8615015
8424 op-snap---monthly-publication-february-2026.pdf   1171 2026-02 Car Vauxhall corsa Orange Contravening a Red Traffic Light None Cooks Lane Cooks Lane Birmingham Birmingham Education N/A   52.482758 -1.7603097
8462 op-snap---monthly-publication-february-2026.pdf   1209 2026-02 Car Vauxhall Voxxy White Use motor vehicle on a road when television receiving / cinematographic apparatus was visible to the driver None Longbridge Lane Longbridge Lane Birmingham Birmingham Fixed Penalty N/A   52.3962003 -1.9821252
8481 op-snap---monthly-publication-february-2026.pdf   1228 2026-02 Car Vauxhall Astra Black Driving without Due Care and Attention None Lee Bank Middleway Lee Bank Middleway Birmingham Birmingham Warning Letter N/A   52.4677721 -1.9037358
8485 op-snap---monthly-publication-february-2026.pdf   1232 2026-02 Car Vauxhall Insigna White Contravening a Red Traffic Light None Ladypool Road Ladypool Road Birmingham Birmingham Education N/A   52.4520441 -1.8787544
8555 op-snap---monthly-publication-february-2026.pdf   1302 2026-02 Car Vauxhall Vivaro Grey Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Fixed Penalty N/A   52.5083238 -1.8332287
8625 op-snap---monthly-publication-february-2026.pdf   1372 2026-02 Pedestrian Vauxhall corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None fallows road Fallows Road Birmingham Birmingham Warning Letter N/A   52.4613056 -1.8636034
8629 op-snap---monthly-publication-february-2026.pdf   1376 2026-02 Car Vauxhall astra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None lozells road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
8630 op-snap---monthly-publication-february-2026.pdf   1377 2026-02 Car Vauxhall insignia Grey Misc - Non Traffic Offences None granthan road Granthan Road Birmingham Birmingham NFA Misc Inc Crimes      
8637 op-snap---monthly-publication-february-2026.pdf   1384 2026-02 Pedestrian Vauxhall corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None dale close Dale Close Birmingham Birmingham Warning Letter N/A   52.4215728 -1.8433062
8646 op-snap---monthly-publication-february-2026.pdf   1393 2026-02 Car Vauxhall grandland Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None washwood heath road Washwood Heath Road Birmingham Birmingham Warning Letter N/A   52.4929304 -1.8229092
8683 op-snap---monthly-publication-february-2026.pdf   1430 2026-02 Car Vauxhall Corsa Silver Using a Mobile Phone Whilst Driving None Sheepcote Street Sheepcote Street Birmingham Birmingham Warning Letter N/A   52.4770877 -1.9154767
8714 op-snap---monthly-publication-february-2026.pdf   1461 2026-02 Pedestrian Vauxhall vivaro White Stop a vehicle within pelican pedestrian crossing limits None kingstanding road Kingstanding Road Birmingham Birmingham Warning Letter N/A   52.5521118 -1.8845138
8717 op-snap---monthly-publication-february-2026.pdf   1464 2026-02 Pedestrian Vauxhall corsa Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None rockingham gardens Rockingham Gardens Birmingham Birmingham Warning Letter N/A   52.5690681 -1.8271174
8723 op-snap---monthly-publication-february-2026.pdf   1470 2026-02 Pedestrian Vauxhall corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None moor green lane Moor Green Lane Birmingham Birmingham NFA Misc Inc Crimes   52.4374665 -1.9119895
8743 op-snap---monthly-publication-february-2026.pdf   1490 2026-02 Car Vauxhall Corsa Silver Driving without Due Care and Attention No Insurance Woodland Road Woodland Road Birmingham Birmingham Court N/A   52.4108681 -1.9611917
8750 op-snap---monthly-publication-february-2026.pdf   1497 2026-02 Car Vauxhall Vivaro White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Hancock Road Hancock Road Birmingham Birmingham Fixed Penalty N/A   52.4854257 -1.8436094
8834 op-snap---monthly-publication-february-2026.pdf   1581 2026-02 Pedestrian Vauxhall astra Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None willies road Willies Road Birmingham Birmingham Warning Letter N/A      
8851 op-snap---monthly-publication-february-2026.pdf   1598 2026-02 Pedestrian Vauxhall corsa Grey Misc - Non Traffic Offences None birmingham road Birmingham Road Birmingham Birmingham NFA Misc Inc Crimes   52.5505398 -1.8252993
10614 op-snap---monthly-publication-january-2026.pdf   75 2026-01 Pedestrian Vauxhall insgnia black Cause vehicle to be left in a dangerous position None alcester road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
10632 op-snap---monthly-publication-january-2026.pdf   93 2026-01 Other Vauxhall Meriva White Misc - Non Traffic Offences None The Oak Walk The Oak Walk Birmingham Birmingham RTC - Actioned N/A   52.4020485 -1.9696265
10684 op-snap---monthly-publication-january-2026.pdf   145 2026-01 Car Vauxhall Insignia White Stop a vehicle within pelican pedestrian crossing limits None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226
10696 op-snap---monthly-publication-january-2026.pdf   157 2026-01 Car Vauxhall Mokka Black Stop a vehicle on pedestrian crossing None Summer Road at Marsh Lane Summer Road at Marsh Lane Birmingham Birmingham Education N/A   52.5224 -1.8440808
10753 op-snap---monthly-publication-january-2026.pdf   214 2026-01 Other Vauxhall Vivaro Black Using a Mobile Phone Whilst Driving None Fifield Road Fifield Road Birmingham Birmingham NFA No Independent Evidence Available      
10756 op-snap---monthly-publication-january-2026.pdf   217 2026-01 Car Vauxhall Corsa Grey Use a vehicle / cycle on a road and contravene a local traffic order other than parking None Island Road Island Road Birmingham Birmingham Warning Letter N/A   52.5095686 -1.9544485
10827 op-snap---monthly-publication-january-2026.pdf   288 2026-01 Car Vauxhall Antara White Contravening a Red Traffic Light None Middleton Hall Road Middleton Hall Road Birmingham Birmingham NFA No Independent Evidence Available   52.4149989 -1.9345999
10841 op-snap---monthly-publication-january-2026.pdf   302 2026-01 Pedestrian Vauxhall Insignia Silver Use a vehicle / cycle on a road and contravene a local traffic order other than parking none Belgrade Middleway Belgrave Middleway Birmingham Birmingham NFA No Offence   52.4668753 -1.8996143
10919 op-snap---monthly-publication-january-2026.pdf   380 2026-01 Car Vauxhall Zafira Silver Contravening a Red Traffic Light None Hagley Road at Highfield Road Hagley Road at Highfield Road Birmingham Birmingham Warning Letter N/A   52.471836 -1.9401037
10951 op-snap---monthly-publication-january-2026.pdf   412 2026-01 Car Vauxhall Astra Silver Stop a vehicle within pelican pedestrian crossing limits None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
10981 op-snap---monthly-publication-january-2026.pdf   442 2026-01 Pedestrian Vauxhall Viva Red Misc - Non Traffic Offences None Fontley Close Fontley Close Birmingham Birmingham NFA No Offence   52.4760797 -1.7952034
10995 op-snap---monthly-publication-january-2026.pdf   456 2026-01 Pedestrian Vauxhall Astra Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Devonshire Road Devonshire Road Birmingham Birmingham Warning Letter N/A   52.5163419 -1.9288926
11049 op-snap---monthly-publication-january-2026.pdf   510 2026-01 Pedestrian Vauxhall Astra Red Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
11124 op-snap---monthly-publication-january-2026.pdf   585 2026-01 Car Vauxhall Astra Red Contravening a Red Traffic Light No Insurance Tyburn Road Tyburn Road Birmingham Birmingham NFA No Independent Evidence Available   52.5113867 -1.8337258
11135 op-snap---monthly-publication-january-2026.pdf   596 2026-01 Car Vauxhall Corsa White Contravening a Red Traffic Light None Mary Vale Road Mary Vale Road Birmingham Birmingham NFA No Independent Evidence Available   52.425105 -1.9312861
11170 op-snap---monthly-publication-january-2026.pdf   631 2026-01 Car Vauxhall Viva Red Using a Mobile Phone Whilst Driving None Cranmore Road Cranmore Road Birmingham Birmingham Fixed Penalty N/A      
11192 op-snap---monthly-publication-january-2026.pdf   653 2026-01 Car Vauxhall Corsa White Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
11201 op-snap---monthly-publication-january-2026.pdf   662 2026-01 Car Vauxhall Astra White Contravening a Red Traffic Light None Ickneild Street Ickneild Street Birmingham Birmingham Warning Letter N/A   52.3992394 -1.919918
11245 op-snap---monthly-publication-january-2026.pdf   706 2026-01 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Pershore Road South, Kings Norton Pershore Road South, Kings Norton Birmingham Birmingham Education N/A   52.4116071 -1.9297714
11261 op-snap---monthly-publication-january-2026.pdf   722 2026-01 Car Vauxhall Astra Black Driving without Due Care and Attention None Tyburn Island Tyburn Island Birmingham Birmingham NFA No VRM   52.5193542 -1.800381
11268 op-snap---monthly-publication-january-2026.pdf   729 2026-01 Car Vauxhall Insignia Black Stop a vehicle within pelican pedestrian crossing limits None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Education N/A   52.4929304 -1.8229092
11363 op-snap---monthly-publication-january-2026.pdf   824 2026-01 Car Vauxhall Insignia Black Driving without Due Care and Attention Contravening a Red Traffic Light Rotton Park Road Rotton Park Road Birmingham Birmingham Court N/A   52.4851072 -1.9468115
11392 op-snap---monthly-publication-january-2026.pdf   853 2026-01 Car Vauxhall Corsa Blue Driving without Due Care and Attention None Wash Lane Stechford Wash Lane Stechford Birmingham Birmingham Fixed Penalty N/A   52.4742389 -1.8182588
11401 op-snap---monthly-publication-january-2026.pdf   862 2026-01 Car Vauxhall Corsa Grey Contravening a Red Traffic Light None Friary Road Friary Road Birmingham Birmingham Education N/A   52.5162814 -1.9395798
11447 op-snap---monthly-publication-january-2026.pdf   908 2026-01 Pedestrian Vauxhall Mokka White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Worlds End Lane Worlds End Lane Birmingham Birmingham Fixed Penalty N/A   52.4555997 -1.9882443
11458 op-snap---monthly-publication-january-2026.pdf   919 2026-01 Pedestrian Vauxhall Mokka Red Stop a vehicle on pedestrian crossing None Bourneville Lane Bourneville Lane Birmingham Birmingham Education N/A      
11469 op-snap---monthly-publication-january-2026.pdf   930 2026-01 Pedestrian Vauxhall Corsa Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None A435 Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
11493 op-snap---monthly-publication-january-2026.pdf   954 2026-01 Pedestrian Vauxhall Corsa Black Driving without Due Care and Attention None High Street High Street Birmingham Birmingham NFA No Independent Evidence Available   52.5254588 -1.8373064
11550 op-snap---monthly-publication-january-2026.pdf   1011 2026-01 Pedal Bike Vauxhall Corsa Red Driving without Due Care and Attention None Tessall Lane Tessall Lane Birmingham Birmingham Education N/A   52.4045186 -1.9891793
11551 op-snap---monthly-publication-january-2026.pdf   1012 2026-01 Pedal Bike Vauxhall Corsa Black Using a Mobile Phone Whilst Driving None Priory Road Priory Road Birmingham Birmingham Fixed Penalty N/A   52.4132696 -1.8555008
11583 op-snap---monthly-publication-january-2026.pdf   1044 2026-01 Pedal Bike Vauxhall Astra Silver Contravening a Red Traffic Light None High street. Alcester Road High street. Alcester Road Birmingham Birmingham NFA No Offence      
11594 op-snap---monthly-publication-january-2026.pdf   1055 2026-01 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Wychall Road Wychall Road Birmingham Birmingham Education N/A   52.4089092 -1.9498562
11603 op-snap---monthly-publication-january-2026.pdf   1064 2026-01 Car Vauxhall Mokka Brown Misc - Non Traffic Offences None Friary Road / Oxhill Road junction Friary Road / Oxhill Road junction Birmingham Birmingham NFA No Offence   52.5162814 -1.9395798
11628 op-snap---monthly-publication-january-2026.pdf   1089 2026-01 Car Vauxhall Astra White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
11635 op-snap---monthly-publication-january-2026.pdf   1096 2026-01 Car Vauxhall Astra Silver Contravening a Red Traffic Light No Insurance Queslett Road Queslett Road Birmingham Birmingham Court N/A   52.5458699 -1.9304484
11663 op-snap---monthly-publication-january-2026.pdf   1124 2026-01 Car Vauxhall Movano White Driving without Due Care and Attention None A45 A45 Birmingham Birmingham NFA No Offence      
11668 op-snap---monthly-publication-january-2026.pdf   1129 2026-01 Pedestrian Vauxhall Zafira Red Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Startford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
11691 op-snap---monthly-publication-january-2026.pdf   1152 2026-01 Car Vauxhall Movano Black Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
11702 op-snap---monthly-publication-january-2026.pdf   1163 2026-01 Car Vauxhall Astra Black Stop a vehicle within pelican pedestrian crossing limits None Lozells Road Lozells Road Birmingham Birmingham Education N/A   52.502683 -1.9033516
11725 op-snap---monthly-publication-january-2026.pdf   1186 2026-01 Pedestrian Vauxhall Zafira Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Stockwell Road Stockwell Road Birmingham Birmingham NFA No Offence   52.5157939 -1.938322
11737 op-snap---monthly-publication-january-2026.pdf   1198 2026-01 Pedestrian Vauxhall Crossland Red Cause vehicle to be left in a dangerous position None Drayton Road Drayton Road Birmingham Birmingham Education N/A   52.4321165 -1.8902667
11771 op-snap---monthly-publication-january-2026.pdf   1232 2026-01 Pedestrian Vauxhall Vivaro Silver Cause vehicle to be left in a dangerous position None Cherry Orchard Road Cherry Orchard Road Birmingham Birmingham Education N/A   52.5206297 -1.9208426
11881 op-snap---monthly-publication-january-2026.pdf   1342 2026-01 Pedal Bike Vauxhall Astra Silver Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
3875 op-snap---monthly-publication-december-2025.pdf   3 2025-12 Car Vauxhall Astra Grey Driving without Due Care and Attention None Umberslade Road Umberslade Road Birmingham Birmingham NFA No Independent Evidence Available   52.4304526 -1.9216716
3895 op-snap---monthly-publication-december-2025.pdf   23 2025-12 Car Vauxhall Corsa Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3896 op-snap---monthly-publication-december-2025.pdf   24 2025-12 Car Vauxhall Mokka Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Lozells Road Lozells Road Birmingham Birmingham Warning Letter N/A   52.502683 -1.9033516
3919 op-snap---monthly-publication-december-2025.pdf   47 2025-12 Car Vauxhall Astra White Driving without Due Care and Attention None Chruch Lane Chruch Lane Birmingham Birmingham NFA No Offence      
3941 op-snap---monthly-publication-december-2025.pdf   69 2025-12 Pedestrian Vauxhall Vivaro White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Birdwell Croft Birdwell Croft Birmingham Birmingham NFA Misc Inc Crimes   52.425424 -1.8903528
3977 op-snap---monthly-publication-december-2025.pdf   105 2025-12 Car Vauxhall corsa Red Cause vehicle to be left in a dangerous position None washwood hath road Washwood Hath Road Birmingham Birmingham Warning Letter N/A      
4004 op-snap---monthly-publication-december-2025.pdf   132 2025-12 Car Vauxhall Corsa Silver Using a Mobile Phone Whilst Driving None Coles Hill Road Coles Hill Road Birmingham Birmingham NFA No Independent Evidence Available      
4156 op-snap---monthly-publication-december-2025.pdf   284 2025-12 Pedal Bike Vauxhall Mokka Black Using a Mobile Phone Whilst Driving None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
4193 op-snap---monthly-publication-december-2025.pdf   321 2025-12 Pedestrian Vauxhall Meriva Silver Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None St Marks Crescent Street Marks Crescent Birmingham Birmingham Warning Letter N/A      

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

CREATE TABLE reports (
            id INTEGER PRIMARY KEY AUTOINCREMENT,
            source_file TEXT NOT NULL,
            source_page INTEGER,
            source_row INTEGER,
            month TEXT NOT NULL,
            reporter_transport_mode TEXT,
            vehicle_make TEXT,
            vehicle_model TEXT,
            vehicle_colour TEXT,
            offence TEXT,
            second_offence TEXT,
            offence_location_raw TEXT,
            offence_location TEXT,
            council_area_raw TEXT,
            council_area TEXT,
            disposal TEXT,
            nfa_rationale TEXT,
            witness_contacted TEXT
        , latitude REAL, longitude REAL);
CREATE INDEX idx_month ON reports(month);
CREATE INDEX idx_council_area ON reports(council_area);
CREATE INDEX idx_offence ON reports(offence);
CREATE INDEX idx_disposal ON reports(disposal);
CREATE INDEX idx_location ON reports(offence_location);