home / opsnap

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

116 rows where council_area = "Birmingham", disposal = "Education" and month = "2025-09" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence

vehicle_make 23

  • Ford 16
  • Volkswagen 15
  • Mercedes-Benz 11
  • Toyota 10
  • BMW 9
  • Audi 5
  • Seat 5
  • Vauxhall 5
  • Honda 4
  • Hyundai 4
  • Nissan 4
  • Skoda 4
  • Kia 3
  • Land Rover 3
  • Peugeot 3
  • Volvo 3
  • Citroen 2
  • Daf 2
  • Cupra 1
  • Fiat 1
  • Jaguar 1
  • Lexus 1
  • Mitsubishi 1

offence 6

  • Driving without Due Care and Attention 61
  • Contravening a Red Traffic Light 40
  • Driving without Reasonable Consideration 8
  • Drive a vehicle other than on the carriageway of a 4
  • Contravene Lane Closure Red X 2
  • Driving a vehicle wholly or partly on a footpath 1

reporter_transport_mode 3

  • Car 90
  • Pedal Bike 25
  • Other 1

month 1

  • 2025-09 · 116 ✖

disposal 1

  • Education · 116 ✖

council_area 1

  • Birmingham · 116 ✖
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
23784 op-snap---monthly-publication-september-2025.pdf   3 2025-09 Car Cupra Formentor Black Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
23788 op-snap---monthly-publication-september-2025.pdf   7 2025-09 Pedal Bike Mercedes-Benz Sprinter Silver Driving without Due Care and Attention None Moor Green lane Moor Green lane Birmingham Birmingham Education N/A   52.4374665 -1.9119895
23800 op-snap---monthly-publication-september-2025.pdf   19 2025-09 Pedal Bike Ford Fiesta Black Driving without Reasonable Consideration None West Heath Road West Heath Road Birmingham Birmingham Education N/A   52.402785 -1.9620058
23801 op-snap---monthly-publication-september-2025.pdf   20 2025-09 Pedal Bike BMW   Blue Driving without Reasonable Consideration None West Heath Road West Heath Road Birmingham Birmingham Education N/A   52.402785 -1.9620058
23802 op-snap---monthly-publication-september-2025.pdf   21 2025-09 Pedal Bike Kia Sportage Green Driving without Due Care and Attention None Belgrave Road Belgrave Road Birmingham Birmingham Education N/A   52.4669004 -1.9011385
23815 op-snap---monthly-publication-september-2025.pdf   34 2025-09 Car Skoda Octavia Blue Driving without Due Care and Attention None Consitiution Hill Consitiution Hill Birmingham Birmingham Education N/A      
23818 op-snap---monthly-publication-september-2025.pdf   37 2025-09 Car Land Rover Evoque White Contravening a Red Traffic Light None Spitfire Island Spitfire Island Birmingham Birmingham Education N/A   52.5138106 -1.797297
23825 op-snap---monthly-publication-september-2025.pdf   44 2025-09 Car Nissan X Trail Black Contravene Lane Closure Red X None Kings Heath High Street Kings Heath High Street Birmingham Birmingham Education N/A   52.4391028 -1.893289
23847 op-snap---monthly-publication-september-2025.pdf   66 2025-09 Car Nissan Juke Grey Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
23854 op-snap---monthly-publication-september-2025.pdf   73 2025-09 Car Volkswagen Golf Black Contravening a Red Traffic Light None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
23861 op-snap---monthly-publication-september-2025.pdf   80 2025-09 Car Audi SQ5 Black Contravening a Red Traffic Light None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
23889 op-snap---monthly-publication-september-2025.pdf   108 2025-09 Car Mercedes-Benz A35 AMG Yellow Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
23898 op-snap---monthly-publication-september-2025.pdf   117 2025-09 Car BMW 3 series Black Driving without Due Care and Attention None Aldridge Road Aldridge Road Birmingham Birmingham Education N/A   52.5368764 -1.8976461
23910 op-snap---monthly-publication-september-2025.pdf   129 2025-09 Car Mercedes-Benz   Black Contravening a Red Traffic Light None Birmingham Road Birmingham Road Birmingham Birmingham Education N/A   52.5505398 -1.8252993
23932 op-snap---monthly-publication-september-2025.pdf   151 2025-09 Car Audi Q7.. Grey Driving without Due Care and Attention None Spitfire island Spitfire island Birmingham Birmingham Education N/A   52.5138106 -1.797297
23943 op-snap---monthly-publication-september-2025.pdf   162 2025-09 Car Seat Ibiza Black Driving without Due Care and Attention None Yardley Green Road Yardley Green Road Birmingham Birmingham Education N/A   52.4764154 -1.8311418
23948 op-snap---monthly-publication-september-2025.pdf   167 2025-09 Car Land Rover Sport Grey Drive a vehicle other than on the carriageway of a motorway None M6 Motorway, Southbound. Jn 7A M6 Motorway, Southbound. Junction 7A Birmingham Birmingham Education N/A      
23955 op-snap---monthly-publication-september-2025.pdf   174 2025-09 Car Toyota Corolla Black Driving without Due Care and Attention None Warwick Road Acocks Green Warwick Road Acocks Green Birmingham Birmingham Education N/A   52.4468495 -1.8244484
23956 op-snap---monthly-publication-september-2025.pdf   175 2025-09 Car Ford Focus Black Contravening a Red Traffic Light None Wake Green Road Wake Green Road Birmingham Birmingham Education N/A   52.4437078 -1.8783408
23958 op-snap---monthly-publication-september-2025.pdf   177 2025-09 Car Seat Ibiza Grey Driving without Due Care and Attention None A45 Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
23961 op-snap---monthly-publication-september-2025.pdf   180 2025-09 Pedal Bike Peugeot Partner White Driving without Reasonable Consideration None Merritts Hill Merritts Hill Birmingham Birmingham Education N/A   52.424853 -1.9814275
23967 op-snap---monthly-publication-september-2025.pdf   186 2025-09 Car Skoda Kodiaq Silver Contravening a Red Traffic Light None Holloway Head Holloway Head Birmingham Birmingham Education N/A   52.474258 -1.9019723
23969 op-snap---monthly-publication-september-2025.pdf   188 2025-09 Car Nissan Note Orange Contravening a Red Traffic Light None Broad Lane Kings Heath Broad Lane Kings Heath Birmingham Birmingham Education N/A   52.410787 -1.918202
23976 op-snap---monthly-publication-september-2025.pdf   195 2025-09 Car BMW 320.. White Driving without Due Care and Attention None A38 Aston Expressway Aston Expressway Birmingham Birmingham Education N/A   52.493793 -1.8881773
23980 op-snap---monthly-publication-september-2025.pdf   199 2025-09 Car   Polestar Blue Contravening a Red Traffic Light No vehicle excise licence Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A   52.4103191 -1.8670224
23981 op-snap---monthly-publication-september-2025.pdf   200 2025-09 Car   Husqvarna White Driving without Due Care and Attention None Melchett Road Melchett Road Birmingham Birmingham Education N/A   52.413984 -1.9251511
23982 op-snap---monthly-publication-september-2025.pdf   201 2025-09 Pedal Bike Ford Focus Black Driving without Due Care and Attention No vehicle excise licence Holly Lane, Marston Green Holly Lane, Marston Green Birmingham Birmingham Education N/A      
23987 op-snap---monthly-publication-september-2025.pdf   206 2025-09 Car Volvo V90 White Driving without Due Care and Attention None Broadmeadow Lane Broadmeadow Lane Birmingham Birmingham Education N/A      
23998 op-snap---monthly-publication-september-2025.pdf   217 2025-09 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Church Road Edgbaston Church Road Edgbaston Birmingham Birmingham Education N/A   52.46114 -1.9180882
24005 op-snap---monthly-publication-september-2025.pdf   224 2025-09 Car Ford Focus Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
24006 op-snap---monthly-publication-september-2025.pdf   225 2025-09 Car Peugeot 308 Grey Contravening a Red Traffic Light None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
24007 op-snap---monthly-publication-september-2025.pdf   226 2025-09 Car Toyota yaris Red Contravening a Red Traffic Light None Northfied Road Northfied Road Birmingham Birmingham Education N/A      
24023 op-snap---monthly-publication-september-2025.pdf   242 2025-09 Pedal Bike Ford Focus Red Driving without Due Care and Attention None Tixall Road Shirley Tixall Road Shirley Birmingham Birmingham Education N/A      
24037 op-snap---monthly-publication-september-2025.pdf   256 2025-09 Pedal Bike Hyundai Tucson Blue Driving without Due Care and Attention None Chester Road North Chester Road North Birmingham Birmingham Education N/A   52.548449 -1.8594603
24054 op-snap---monthly-publication-september-2025.pdf   273 2025-09 Car BMW S1000RR White Driving without Due Care and Attention None Sundial Lane Sundial Lane Birmingham Birmingham Education N/A   52.5471217 -1.9336068
24063 op-snap---monthly-publication-september-2025.pdf   282 2025-09 Car Mercedes-Benz B180 Blue Driving without Reasonable Consideration None A38 Minworth Island Minworth Island Birmingham Birmingham Education N/A   52.5316279 -1.7762358
24077 op-snap---monthly-publication-september-2025.pdf   296 2025-09 Car Audi SQ5 Silver Contravening a Red Traffic Light None Jenkins Street Jenkins Street Birmingham Birmingham Education N/A   52.4705155 -1.8650312
24087 op-snap---monthly-publication-september-2025.pdf   306 2025-09 Car Citroen C3 Grey Driving without Due Care and Attention None Moorend Avenue Moorend Avenue Birmingham Birmingham Education N/A      
24095 op-snap---monthly-publication-september-2025.pdf   314 2025-09 Car BMW 420d White Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
24109 op-snap---monthly-publication-september-2025.pdf   328 2025-09 Car Kia Sportage Black Driving without Due Care and Attention None Finchley Road Finchley Road Birmingham Birmingham Education N/A   52.5488456 -1.8735092
24121 op-snap---monthly-publication-september-2025.pdf   340 2025-09 Pedal Bike Seat Leon White Driving without Due Care and Attention None Priory Road Priory Road Birmingham Birmingham Education N/A   52.4132696 -1.8555008
24130 op-snap---monthly-publication-september-2025.pdf   349 2025-09 Car Ford Transit Silver Contravening a Red Traffic Light None Chester Road at Jockey Road Chester Road at Jockey Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
24139 op-snap---monthly-publication-september-2025.pdf   358 2025-09 Car Ford Transit Red Driving without Due Care and Attention None Baldwin Lane Baldwin Lane Birmingham Birmingham Education N/A   52.4151192 -1.84291
24143 op-snap---monthly-publication-september-2025.pdf   362 2025-09 Car Ford Transit Grey Contravening a Red Traffic Light None Queslett Road Queslett Road Birmingham Birmingham Education N/A   52.5458699 -1.9304484
24147 op-snap---monthly-publication-september-2025.pdf   366 2025-09 Car Ford focus Silver Contravening a Red Traffic Light None Tessell Lane Tessell Lane Birmingham Birmingham Education N/A      
24156 op-snap---monthly-publication-september-2025.pdf   375 2025-09 Car Seat Alhambra Silver Driving without Due Care and Attention None Monument Road Monument Road Birmingham Birmingham Education N/A   52.4731312 -1.930947
24167 op-snap---monthly-publication-september-2025.pdf   386 2025-09 Car Honda civic White Driving without Reasonable Consideration None M5 J3 M5 J3 Birmingham Birmingham Education N/A   52.4846642 -1.9297585
24199 op-snap---monthly-publication-september-2025.pdf   418 2025-09 Car BMW IX Blue Contravene Lane Closure Red X None A38M A38M Birmingham Birmingham Education N/A      
24213 op-snap---monthly-publication-september-2025.pdf   432 2025-09 Car Mercedes-Benz GLC White Contravening a Red Traffic Light None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
24215 op-snap---monthly-publication-september-2025.pdf   434 2025-09 Car Volkswagen Golf Black Contravening a Red Traffic Light None Queslett Road Queslett Road Birmingham Birmingham Education N/A   52.5458699 -1.9304484
24216 op-snap---monthly-publication-september-2025.pdf   435 2025-09 Car Honda Civic Blue Contravening a Red Traffic Light None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
24226 op-snap---monthly-publication-september-2025.pdf   445 2025-09 Car Mitsubishi Hi-Lux Black Contravening a Red Traffic Light None Minworth Island Minworth Island Birmingham Birmingham Education N/A   52.5316279 -1.7762358
24243 op-snap---monthly-publication-september-2025.pdf   462 2025-09 Car Ford Focus Blue Driving without Due Care and Attention None M6 Jct 6 Southbound M6 Junction 6 Southbound Birmingham Birmingham Education N/A   52.676119 -2.0858425
24245 op-snap---monthly-publication-september-2025.pdf   464 2025-09 Car Toyota Yaris Blue Driving without Due Care and Attention None Preston Road Preston Road Birmingham Birmingham Education N/A   52.4633325 -1.8102488
24246 op-snap---monthly-publication-september-2025.pdf   465 2025-09 Car Volkswagen Golf Black Driving without Due Care and Attention None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
24255 op-snap---monthly-publication-september-2025.pdf   474 2025-09 Car Lexus RX400 Blue Driving without Reasonable Consideration None Alum Rock Road Alum Rock Road Birmingham Birmingham Education N/A   52.4883936 -1.8310056
24256 op-snap---monthly-publication-september-2025.pdf   475 2025-09 Car Volvo XC40 Black Contravening a Red Traffic Light None Turves Green Turves Green Birmingham Birmingham Education N/A   52.4035104 -1.9666324
24282 op-snap---monthly-publication-september-2025.pdf   501 2025-09 Car Volkswagen Polo White Contravening a Red Traffic Light None Walsall Road Perry Barr Walsall Road Perry Barr Birmingham Birmingham Education N/A   52.5219655 -1.9010321
24288 op-snap---monthly-publication-september-2025.pdf   507 2025-09 Car Mercedes-Benz c200 Red Contravening a Red Traffic Light None Cole Hill Lane Cole Hill Lane Birmingham Birmingham Education N/A   52.4951084 -1.7913851
24300 op-snap---monthly-publication-september-2025.pdf   519 2025-09 Car Kia sportage Silver Driving without Reasonable Consideration None Cateswell Road Cateswell Road Birmingham Birmingham Education N/A   52.4387009 -1.8454267
24303 op-snap---monthly-publication-september-2025.pdf   522 2025-09 Car Volkswagen Polo Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
24341 op-snap---monthly-publication-september-2025.pdf   560 2025-09 Pedal Bike Volkswagen Tiguan Grey Driving without Due Care and Attention None Breedon Road Breedon Road Birmingham Birmingham Education N/A   52.4191978 -1.9251219
24343 op-snap---monthly-publication-september-2025.pdf   562 2025-09 Car Mercedes-Benz A Class Red Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
24344 op-snap---monthly-publication-september-2025.pdf   563 2025-09 Car Volkswagen Polo White Drive a vehicle other than on the carriageway of a motorway None M6 Motorway M6 Motorway Birmingham Birmingham Education N/A   52.5327447 -1.899844
24345 op-snap---monthly-publication-september-2025.pdf   564 2025-09 Car Mercedes-Benz   White Drive a vehicle other than on the carriageway of a motorway None M6 Motorway M6 Motorway Birmingham Birmingham Education N/A   52.5327447 -1.899844
24350 op-snap---monthly-publication-september-2025.pdf   569 2025-09 Car Hyundai Tuscon Black Drive a vehicle other than on the carriageway of a motorway None M42 Motorway M42 Motorway Birmingham Birmingham Education N/A   52.490826 -1.8882034
24368 op-snap---monthly-publication-september-2025.pdf   587 2025-09 Car Seat Leon Blue Driving without Due Care and Attention None Clay Lane Clay Lane Birmingham Birmingham Education N/A   52.4509038 -1.8083784
24387 op-snap---monthly-publication-september-2025.pdf   606 2025-09 Pedal Bike Mercedes-Benz EQA Blue Driving without Due Care and Attention None Harborne Road Harborne Road Birmingham Birmingham Education N/A   52.4718503 -1.9195423
24402 op-snap---monthly-publication-september-2025.pdf   621 2025-09 Car Honda civic Black Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham Education N/A      
24403 op-snap---monthly-publication-september-2025.pdf   622 2025-09 Car Vauxhall Zafira Brown Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham Education N/A      
24414 op-snap---monthly-publication-september-2025.pdf   633 2025-09 Car Fiat Lounge 500 Green Contravening a Red Traffic Light None Queensbridge Road, Kings Heath Queensbridge Road, Kings Heath Birmingham Birmingham Education N/A   52.4415108 -1.8971434
24434 op-snap---monthly-publication-september-2025.pdf   653 2025-09 Car Vauxhall Grandland X White Contravening a Red Traffic Light None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
24439 op-snap---monthly-publication-september-2025.pdf   658 2025-09 Car Peugeot 107 Red Contravening a Red Traffic Light None Bristol Street Bristol Street Birmingham Birmingham Education N/A   52.4691145 -1.9003257
24443 op-snap---monthly-publication-september-2025.pdf   662 2025-09 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None George Road George Road Birmingham Birmingham Education N/A   52.5155831 -1.8598862
24457 op-snap---monthly-publication-september-2025.pdf   676 2025-09 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Holly Lane, Marston Green Holly Lane, Marston Green Birmingham Birmingham Education N/A      
24501 op-snap---monthly-publication-september-2025.pdf   720 2025-09 Car Audi Q2 Grey Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
24502 op-snap---monthly-publication-september-2025.pdf   721 2025-09 Car Citroen C1 Red Driving a vehicle wholly or partly on a footpath None South Road, Northfield South Road, Northfield Birmingham Birmingham Education N/A   52.4074768 -1.9720667
24516 op-snap---monthly-publication-september-2025.pdf   735 2025-09 Car Honda   Blue Contravening a Red Traffic Light None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
24531 op-snap---monthly-publication-september-2025.pdf   750 2025-09 Pedal Bike Volkswagen   Black Driving without Due Care and Attention None Warstock Lane Warstock Lane Birmingham Birmingham Education N/A   52.4175988 -1.8774655
24542 op-snap---monthly-publication-september-2025.pdf   761 2025-09 Car Toyota Prius White Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
24548 op-snap---monthly-publication-september-2025.pdf   767 2025-09 Car Mercedes-Benz   White Driving without Due Care and Attention None M6 Motorway M6 Motorway Birmingham Birmingham Education N/A   52.5327447 -1.899844
24580 op-snap---monthly-publication-september-2025.pdf   799 2025-09 Car Volkswagen Transporter Blue Driving without Due Care and Attention None Allard Way Allard Way Birmingham Birmingham Education N/A      
24581 op-snap---monthly-publication-september-2025.pdf   800 2025-09 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Wrentham Street Wrentham Street Birmingham Birmingham Education N/A   52.4708757 -1.8966158
24582 op-snap---monthly-publication-september-2025.pdf   801 2025-09 Car Skoda Fabia Red Driving without Due Care and Attention None Brandwood Road Brandwood Road Birmingham Birmingham Education N/A   52.4139427 -1.9037653
24606 op-snap---monthly-publication-september-2025.pdf   825 2025-09 Car Toyota Yaris Silver Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
24610 op-snap---monthly-publication-september-2025.pdf   829 2025-09 Pedal Bike Daf lorry White Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
24614 op-snap---monthly-publication-september-2025.pdf   833 2025-09 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Bristol Road South Bristol Road South Birmingham Birmingham Education N/A   52.4119174 -1.9735247
24615 op-snap---monthly-publication-september-2025.pdf   834 2025-09 Car Volvo S40 Grey Driving without Due Care and Attention None A38 M A38 M Birmingham Birmingham Education N/A   52.5092312 -1.8706799
24630 op-snap---monthly-publication-september-2025.pdf   849 2025-09 Car Jaguar XF.. Black Contravening a Red Traffic Light None Dartmouth Circus Dartmouth Circus Birmingham Birmingham Education N/A   52.4926487 -1.8879638
24632 op-snap---monthly-publication-september-2025.pdf   851 2025-09 Other Volkswagen Polo Silver Driving without Due Care and Attention None Star City, Nechells Star City, Nechells Birmingham Birmingham Education N/A   52.5054363 -1.8556273
24643 op-snap---monthly-publication-september-2025.pdf   862 2025-09 Car Volkswagen Golf Black Driving without Due Care and Attention None Monyhull Hall Road Monyhull Hall Road Birmingham Birmingham Education N/A   52.4126079 -1.905127
24652 op-snap---monthly-publication-september-2025.pdf   871 2025-09 Car BMW 520.. Silver Driving without Due Care and Attention None Tyburn Road Roundabout Tyburn Road Roundabout Birmingham Birmingham Education N/A      
24663 op-snap---monthly-publication-september-2025.pdf   882 2025-09 Pedal Bike Toyota Avenis Silver Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham Education N/A   52.4422505 -1.8539684
24673 op-snap---monthly-publication-september-2025.pdf   892 2025-09 Pedal Bike Ford Fiesat White Driving without Due Care and Attention None Reservoir Road Reservoir Road Birmingham Birmingham Education N/A   52.5242452 -1.8572541
24703 op-snap---monthly-publication-september-2025.pdf   922 2025-09 Car Daf Truck White Driving without Due Care and Attention None Chester Road (Tyburn House Roundabout) Chester Road (Tyburn House Roundabout) Birmingham Birmingham Education N/A      
24704 op-snap---monthly-publication-september-2025.pdf   923 2025-09 Car Skoda Kodiaq Grey Contravening a Red Traffic Light None Holyhead Road Holyhead Road Birmingham Birmingham Education N/A   52.505233 -1.9446276
24719 op-snap---monthly-publication-september-2025.pdf   938 2025-09 Car Toyota   Silver Driving without Due Care and Attention None Richmond Road Richmond Road Birmingham Birmingham Education N/A   52.566947 -1.8291809
24732 op-snap---monthly-publication-september-2025.pdf   951 2025-09 Car Toyota Yaris Silver Contravening a Red Traffic Light None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
24744 op-snap---monthly-publication-september-2025.pdf   963 2025-09 Car Audi RS Black Driving without Due Care and Attention None St Marys Row Moseley Street Marys Row Moseley Birmingham Birmingham Education N/A      
24748 op-snap---monthly-publication-september-2025.pdf   967 2025-09 Pedal Bike BMW X4 Grey Driving without Due Care and Attention Use vehicle on a road without valid test certificate Springfield Road Moseley Springfield Road Moseley Birmingham Birmingham Education 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);