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

755 rows where disposal = "Court" and reporter_transport_mode = "Car" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw

vehicle_make >30

month 14

reporter_transport_mode 1

  • Car · 755 ✖

disposal 1

  • Court · 755 ✖
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
7270 op-snap---monthly-publication-february-2026.pdf   17 2026-02 Car Volkswagen Golf Black Driving without Due Care and Attention None Hydes Road Hydes Road Sandwell Sandwell Court N/A   52.5538064 -2.0139199
7340 op-snap---monthly-publication-february-2026.pdf   87 2026-02 Car Volkswagen Golf Grey Contravening a Red Traffic Light None Birchfield Road Oldbury Birchfield Road Oldbury Sandwell Sandwell Court N/A   52.4921923 -2.0324631
7370 op-snap---monthly-publication-february-2026.pdf   117 2026-02 Car Honda Jazz Red Driving without Due Care and Attention None Birchfield Island Olbury Birchfield Island Olbury Sandwell Sandwell Court N/A      
7393 op-snap---monthly-publication-february-2026.pdf   140 2026-02 Car Toyota Auris Grey Driving without Due Care and Attention No Insurance Crampers Field Crampers Field Coventry Coventry Court N/A   52.4176927 -1.5257854
7408 op-snap---monthly-publication-february-2026.pdf   155 2026-02 Car BMW 118I Grey Driving without Due Care and Attention None Hall Green Road Hall Green Road Sandwell Sandwell Court N/A   52.5457385 -1.9935809
7590 op-snap---monthly-publication-february-2026.pdf   337 2026-02 Car Volkswagen Polo White Driving without Due Care and Attention None Cole Bank Road Cole Bank Road Birmingham Birmingham Court N/A   52.4349375 -1.8510007
7593 op-snap---monthly-publication-february-2026.pdf   340 2026-02 Car Seat Ibiza Grey Driving without Due Care and Attention None Walford Road Walford Road Birmingham Birmingham Court N/A   52.4594072 -1.8658859
7627 op-snap---monthly-publication-february-2026.pdf   374 2026-02 Car Citroen C4 White Use a motor vehicle / trailer in a condition likely to cause danger of injury None Walsall Road Walsall Road Sandwell Sandwell Court N/A   52.5439824 -1.9306805
7680 op-snap---monthly-publication-february-2026.pdf   427 2026-02 Car Audi Q5 Grey Contravening a Red Traffic Light None Newbury Lane Newbury Lane Birmingham Birmingham Court N/A      
7799 op-snap---monthly-publication-february-2026.pdf   546 2026-02 Car Mercedes-Benz A Class Black Contravening a Red Traffic Light No Insurance Jockey Road Jockey Road Sutton Coldfield Sutton Coldfield Court N/A   52.5535276 -1.8302584
7805 op-snap---monthly-publication-february-2026.pdf   552 2026-02 Car Land Rover Evoque White Driving without Due Care and Attention None Shirley Road Shirley Road Birmingham Birmingham Court N/A   52.4198291 -1.9241732
7847 op-snap---monthly-publication-february-2026.pdf   594 2026-02 Car Citroen C1 White Driving without Due Care and Attention None B4155 Lichfield Road Lichfield Road Walsall Walsall Court N/A   52.6095168 -2.0493009
7879 op-snap---monthly-publication-february-2026.pdf   626 2026-02 Car Land Rover Evoque Black Driving without Due Care and Attention None Cannock Road Cannock Road Walsall Walsall Court N/A   52.610689 -2.0405006
7929 op-snap---monthly-publication-february-2026.pdf   676 2026-02 Car Volkswagen golf Grey Stop a vehicle within pelican pedestrian crossing limits No vehicle excise licence Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A   52.4929304 -1.8229092
7969 op-snap---monthly-publication-february-2026.pdf   716 2026-02 Car Kawasaki ZX1100 Grey Contravening a Red Traffic Light None A452 Chester Road Chester Road Sutton Coldfield Sutton Coldfield Court N/A   52.5359496 -1.8324115
7994 op-snap---monthly-publication-february-2026.pdf   741 2026-02 Car Toyota Corrolla Black Driving without Due Care and Attention None Halesowen Road Halesowen Road Halesowen Halesowen Court N/A   52.4624413 -2.0175178
8045 op-snap---monthly-publication-february-2026.pdf   792 2026-02 Car Volkswagen Golf White Driving without Due Care and Attention None Battery Way Battery Way Birmingham Birmingham Court N/A   52.4493988 -1.8476406
8062 op-snap---monthly-publication-february-2026.pdf   809 2026-02 Car   Dodge White Contravening a Red Traffic Light VRM fails to conform to Regulations Middle Piece Way Middle Piece Way Wolverhampton Wolverhampton Court N/A      
8065 op-snap---monthly-publication-february-2026.pdf   812 2026-02 Car Volkswagen Golf Grey Driving without Due Care and Attention No Insurance A45 Small Heath Highway Small Heath Highway Birmingham Birmingham Court N/A   52.4709298 -1.8722585
8209 op-snap---monthly-publication-february-2026.pdf   956 2026-02 Car Mercedes-Benz C220 D Black Driving without Due Care and Attention None Lawley MIddleway Lawley MIddleway Birmingham Birmingham Court N/A   52.4801772 -1.8769185
8250 op-snap---monthly-publication-february-2026.pdf   997 2026-02 Car Volkswagen Toureg Black Contravening a Red Traffic Light None Cuckoo Road Cuckoo Road Birmingham Birmingham Court N/A   52.5049023 -1.8603659
8252 op-snap---monthly-publication-february-2026.pdf   999 2026-02 Car BMW S1000 XR Grey Driving without Due Care and Attention Contravening a Red Traffic Light Lichfield Road Lichfield Road Birmingham Birmingham Court N/A   52.5012458 -1.8780942
8264 op-snap---monthly-publication-february-2026.pdf   1011 2026-02 Car Isuzu   Grey Driving without Due Care and Attention Contravening a Red Traffic Light Cannock Road Wolvs Cannock Road Wolvs Wolverhampton Wolverhampton Court N/A      
8269 op-snap---monthly-publication-february-2026.pdf   1016 2026-02 Car Ford Transit Blue Driving without Due Care and Attention No Insurance Halesowen Road Netherton Halesowen Road Netherton Dudley Dudley Court N/A   52.4904317 -2.0833451
8289 op-snap---monthly-publication-february-2026.pdf   1036 2026-02 Car Honda Civic Black Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Court N/A   52.4221526 -1.8425617
8294 op-snap---monthly-publication-february-2026.pdf   1041 2026-02 Car Audi A5 Black Driving without Due Care and Attention No Insurance Coventry Eastern Bypass Coventry Eastern Bypass Coventry Coventry Court N/A   52.3793117 -1.4625379
8333 op-snap---monthly-publication-february-2026.pdf   1080 2026-02 Car Peugeot Partner White Driving without Due Care and Attention No Insurance Cooks Lane Cooks Lane Birmingham Birmingham Court N/A   52.482758 -1.7603097
8360 op-snap---monthly-publication-february-2026.pdf   1107 2026-02 Car Ford Transit Blue Contravening a Red Traffic Light No Insurance Brookvale Road Brookvale Road Birmingham Birmingham Court N/A   52.5219365 -1.8755325
8375 op-snap---monthly-publication-february-2026.pdf   1122 2026-02 Car Ford Fiesta Purple Driving without Due Care and Attention None Newborough Road Newborough Road Solihull Solihull Court N/A   52.4123031 -1.83781
8412 op-snap---monthly-publication-february-2026.pdf   1159 2026-02 Car Volkswagen Golf Black Driving without Due Care and Attention No Insurance Norrington Road Norrington Road Birmingham Birmingham Court N/A   52.4114918 -1.9900683
8419 op-snap---monthly-publication-february-2026.pdf   1166 2026-02 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Suffolk Street Queensway Suffolk Street Queensway Birmingham Birmingham Court N/A   52.4760986 -1.9018641
8429 op-snap---monthly-publication-february-2026.pdf   1176 2026-02 Car Ford Fiesta Silver Driving without Due Care and Attention None Dudley Port at Sedgley Road Dudley Port at Sedgley Road Sandwell Sandwell Court N/A   52.524461 -2.0492538
8443 op-snap---monthly-publication-february-2026.pdf   1190 2026-02 Car Ford Fiesta Silver Contravening a Red Traffic Light Drive otherwise than in accordance with a licence Walsall Road Walsall Road Birmingham Birmingham Court N/A   52.5919543 -1.8517118
8480 op-snap---monthly-publication-february-2026.pdf   1227 2026-02 Car Volkswagen golf Red Driving without Due Care and Attention None Watery Lane Middleway Watery Lane Middleway Birmingham Birmingham Court N/A   52.4752679 -1.8748608
8502 op-snap---monthly-publication-february-2026.pdf   1249 2026-02 Car Ford Transit White Driving without Due Care and Attention None Moor Lane at Brookvale Road (Perry Barr) Moor Lane at Brookvale Road (Perry Barr) Birmingham Birmingham Court N/A   52.5276389 -1.8831953
8516 op-snap---monthly-publication-february-2026.pdf   1263 2026-02 Car BMW 320I Black Driving without Due Care and Attention None Highfield Road Highfield Road Birmingham Birmingham Court N/A   52.4216321 -1.855984
8518 op-snap---monthly-publication-february-2026.pdf   1265 2026-02 Car Honda Civic Silver Driving without Due Care and Attention None Hurst Lane North Hurst Lane North Birmingham Birmingham Court N/A   52.4994582 -1.7644778
8519 op-snap---monthly-publication-february-2026.pdf   1266 2026-02 Car Volkswagen Jetta Grey Driving without Due Care and Attention None Hurst Lane North Hurst Lane North Birmingham Birmingham Court N/A   52.4994582 -1.7644778
8525 op-snap---monthly-publication-february-2026.pdf   1272 2026-02 Car Honda jazz Blue No Insurance Use vehicle on a road without valid test certificate Upper Balsall Heath Road Upper Balsall Heath Road Birmingham Birmingham Court N/A   52.4603726 -1.8856671
8537 op-snap---monthly-publication-february-2026.pdf   1284 2026-02 Car Yamaha   Black Driving without Due Care and Attention None Longmoor at Westwood Sutton Longmoor at Westwood Sutton Sutton Coldfield Sutton Coldfield Court N/A   52.5603693 -1.8619416
8652 op-snap---monthly-publication-february-2026.pdf   1399 2026-02 Car Jaecoo 7 Luxury Black Driving without Due Care and Attention None Solihull Lane Solihull Lane Solihull Solihull Court N/A   52.4548328 -1.7947304
8654 op-snap---monthly-publication-february-2026.pdf   1401 2026-02 Car Volkswagen T Roc Black Driving without Due Care and Attention None Collingwood Drive Collingwood Drive Birmingham Birmingham Court N/A      
8674 op-snap---monthly-publication-february-2026.pdf   1421 2026-02 Car Volkswagen Passat Black Driving without Due Care and Attention No Insurance Walford Road Walford Road Birmingham Birmingham Court N/A   52.4594072 -1.8658859
8689 op-snap---monthly-publication-february-2026.pdf   1436 2026-02 Car BMW X6 White Driving without Due Care and Attention None Birmingham Road (A34) Birmingham Road (A34) Walsall Walsall Court N/A   52.5675147 -1.9513505
8702 op-snap---monthly-publication-february-2026.pdf   1449 2026-02 Car Volkswagen Golf White Driving without Due Care and Attention None Highbridge Road Highbridge Road Dudley Dudley Court N/A   52.485907 -2.0953009
8739 op-snap---monthly-publication-february-2026.pdf   1486 2026-02 Car Seat Ateca Silver Driving without Due Care and Attention None A45 A45 Coventry Coventry Court N/A      
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
8784 op-snap---monthly-publication-february-2026.pdf   1531 2026-02 Car Honda CBR 600 Yellow Driving without Due Care and Attention None Carters Lane Carters Lane Birmingham Birmingham Court N/A   52.4445826 -2.013123
8808 op-snap---monthly-publication-february-2026.pdf   1555 2026-02 Car Jeep Avenger Beige Driving without Due Care and Attention None Tollbar End Roundabout Tollbar End Roundabout Coventry Coventry Court N/A      
8809 op-snap---monthly-publication-february-2026.pdf   1556 2026-02 Car Ford Transit White Driving without Due Care and Attention None Brickhouse Lane Brickhouse Lane Sandwell Sandwell Court N/A   52.5331011 -2.0206711
8810 op-snap---monthly-publication-february-2026.pdf   1557 2026-02 Car Lexus NX450 Black Driving without Due Care and Attention None Chester Road, Castle Bromwich Chester Road, Castle Bromwich Birmingham Birmingham Court N/A      
10541 op-snap---monthly-publication-january-2026.pdf   2 2026-01 Car Audi S3 Black Contravening a Red Traffic Light No Insurance Alum Rock Road Alum Rock Road Birmingham Birmingham Court N/A   52.4883936 -1.8310056
10646 op-snap---monthly-publication-january-2026.pdf   107 2026-01 Car BMW 318D White Driving without Due Care and Attention None Underhill Lane Underhill Lane Wolverhampton Wolverhampton Court N/A   52.6184526 -2.0954562
10657 op-snap---monthly-publication-january-2026.pdf   118 2026-01 Car BMW 318.. Silver Driving without Due Care and Attention No Insurance A41 Birmingham Road Birmingham Road Sandwell Sandwell Court N/A   52.5461417 -1.9334193
10859 op-snap---monthly-publication-january-2026.pdf   320 2026-01 Car Toyota Yaris Green Contravening a Red Traffic Light No Insurance Alcester Road Alcester Road Birmingham Birmingham Court N/A   52.4470686 -1.8880749
10922 op-snap---monthly-publication-january-2026.pdf   383 2026-01 Car Volkswagen Polo White Driving without Due Care and Attention None Olton Boulevard Olton Boulevard Birmingham Birmingham Court N/A   52.443439 -1.8180486
11027 op-snap---monthly-publication-january-2026.pdf   488 2026-01 Car Suzuki GSXS 125 Black Driving without Due Care and Attention Drive otherwise than in accordance with a licence Bristol Road South Bristol Road South Birmingham Birmingham Court N/A   52.4119174 -1.9735247
11050 op-snap---monthly-publication-january-2026.pdf   511 2026-01 Car Toyota Corolla silver Driving without Due Care and Attention None Sutton Road, Erdington Sutton Road, Erdington Birmingham Birmingham Court N/A   52.5339483 -1.8285296
11063 op-snap---monthly-publication-january-2026.pdf   524 2026-01 Car Peugeot Boxvan White Driving without Due Care and Attention None New Road, Halesowen New Road, Halesowen Dudley Dudley Court N/A   52.4514694 -2.0500697
11111 op-snap---monthly-publication-january-2026.pdf   572 2026-01 Car Mercedes-Benz C250 Black Driving without Due Care and Attention None Lincoln Road, Solihull Lincoln Road, Solihull Solihull Solihull Court N/A   52.4438344 -1.810878
11140 op-snap---monthly-publication-january-2026.pdf   601 2026-01 Car Volkswagen Transporter Grey Driving without Due Care and Attention   Coleshill Heath Road Coleshill Heath Road Solihull Solihull Court N/A   52.4667242 -1.7283592
11142 op-snap---monthly-publication-january-2026.pdf   603 2026-01 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Minworth Island Minworth Island Sutton Coldfield Sutton Coldfield Court N/A   52.5310982 -1.7747583
11145 op-snap---monthly-publication-january-2026.pdf   606 2026-01 Car BMW M3 White Driving without Due Care and Attention Contravening a Red Traffic Light Linden Rd Linden Road Birmingham Birmingham Court N/A   52.4263156 -1.9351622
11164 op-snap---monthly-publication-january-2026.pdf   625 2026-01 Car Toyota Prius White Driving without Due Care and Attention Driving without Due Care and Attention Five Ways Roundabout, Birmingham Five Ways Roundabout, Birmingham Birmingham Birmingham Court N/A      
11199 op-snap---monthly-publication-january-2026.pdf   660 2026-01 Car Volkswagen T-Roc Blue Contravening a Red Traffic Light None Reddings Lane Tysley Reddings Lane Tysley Birmingham Birmingham Court N/A      
11205 op-snap---monthly-publication-january-2026.pdf   666 2026-01 Car Toyota Aygo Black Driving without Due Care and Attention None Warwick Road Warwick Road Solihull Solihull Court N/A   52.4428606 -1.812114
11206 op-snap---monthly-publication-january-2026.pdf   667 2026-01 Car Audi A5 Grey Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham Court N/A   52.4622646 -1.8599985
11208 op-snap---monthly-publication-january-2026.pdf   669 2026-01 Car Nissan Qashqai Black Driving without Due Care and Attention None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A   52.4929304 -1.8229092
11321 op-snap---monthly-publication-january-2026.pdf   782 2026-01 Car Renault Captur Black Driving without Due Care and Attention Use vehicle on a road without valid test certificate Grosvenor Road Grosvenor Road Birmingham Birmingham Court N/A   52.4613204 -1.9681665
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
11382 op-snap---monthly-publication-january-2026.pdf   843 2026-01 Car Chysler   Black Driving without Due Care and Attention None Warwick Road at Stockfield Road Warwick Road at Stockfield Road Birmingham Birmingham Court N/A   52.551985 -1.860445
11396 op-snap---monthly-publication-january-2026.pdf   857 2026-01 Car BMW M4 Red Driving without Due Care and Attention No Insurance Holiday Street Holiday Street Birmingham Birmingham Court N/A   52.4757071 -1.8988573
11397 op-snap---monthly-publication-january-2026.pdf   858 2026-01 Car Skoda Octavia Blue Contravening a Red Traffic Light No Insurance Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
11478 op-snap---monthly-publication-january-2026.pdf   939 2026-01 Car Vauxhall Astra Blue Contravening a Red Traffic Light None Downing Street Downing Street Sandwell Sandwell Court N/A   52.5015329 -1.9556094
11504 op-snap---monthly-publication-january-2026.pdf   965 2026-01 Car Seat leon White Driving without Reasonable Consideration No Insurance Wrens Nest Road Wrens Nest Road Dudley Dudley Court N/A   52.5253252 -2.0995407
11537 op-snap---monthly-publication-january-2026.pdf   998 2026-01 Car Audi S3 Grey Driving without Due Care and Attention None Wobaston Road Wobaston Road Wolverhampton Wolverhampton Court N/A   52.628768 -2.1306154
11548 op-snap---monthly-publication-january-2026.pdf   1009 2026-01 Car Land Rover Evoque White Stop a vehicle within pelican pedestrian crossing limits No Insurance Bearwood Road Bearwood Road Sandwell Sandwell Court N/A   52.4725977 -1.9684448
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
11642 op-snap---monthly-publication-january-2026.pdf   1103 2026-01 Car Volkswagen Scirroco Blue Contravening a Red Traffic Light None Great Charles Street Great Charles Street Birmingham Birmingham Court N/A   52.4837518 -1.901874
11647 op-snap---monthly-publication-january-2026.pdf   1108 2026-01 Car BMW 430.. Black Driving without Due Care and Attention None Gulson Road Gulson Road Coventry Coventry Court N/A   52.4076795 -1.4911676
11680 op-snap---monthly-publication-january-2026.pdf   1141 2026-01 Car BMW M135i Black Driving without Due Care and Attention No Insurance Cox Street Cox Street Coventry Coventry Court N/A   52.4092228 -1.5034119
11688 op-snap---monthly-publication-january-2026.pdf   1149 2026-01 Car Vauxhall MOKKA Black Driving without Due Care and Attention None Lodge Lane Lodge Lane Dudley Dudley Court N/A   52.4953929 -2.1814598
11689 op-snap---monthly-publication-january-2026.pdf   1150 2026-01 Car Audi A3.. Grey Driving a vehicle wholly or partly on a footpath None Granville Street Granville Street Birmingham Birmingham Court N/A   52.4762076 -1.9124263
11728 op-snap---monthly-publication-january-2026.pdf   1189 2026-01 Car Kia Sedona Black Driving without Due Care and Attention No Insurance Cannock Road Cannock Road Wolverhampton Wolverhampton Court N/A   52.6083917 -2.1033365
11754 op-snap---monthly-publication-january-2026.pdf   1215 2026-01 Car Hyundai Bayon Grey Driving without Due Care and Attention None Clay Lane Clay Lane Birmingham Birmingham Court N/A   52.4509038 -1.8083784
11778 op-snap---monthly-publication-january-2026.pdf   1239 2026-01 Car Volkswagen Golf Black Using a Mobile Phone Whilst Driving No Insurance Old Croft Lane Old Croft Lane Birmingham Birmingham Court N/A   52.496737 -1.7773905
11806 op-snap---monthly-publication-january-2026.pdf   1267 2026-01 Car Audi A3 Black Driving without Due Care and Attention None Cole Bank Rd, Sarehole Mill Cole Bank Road, Sarehole Mill Birmingham Birmingham Court N/A      
11836 op-snap---monthly-publication-january-2026.pdf   1297 2026-01 Car Ford Eco Sport Grey Driving without Due Care and Attention None Allens Croft Road Allens Croft Road Birmingham Birmingham Court N/A   52.4242527 -1.910803
11885 op-snap---monthly-publication-january-2026.pdf   1346 2026-01 Car Peugeot 207.. Blue Contravening a Red Traffic Light No Insurance Wolverhampton Road Wolverhampton Road Sandwell Sandwell Court N/A   52.4702299 -1.9948976
3996 op-snap---monthly-publication-december-2025.pdf   124 2025-12 Car Mercedes-Benz AMG Grey Driving without Due Care and Attention No Insurance High Street Kings Heath High Street Kings Heath Birmingham Birmingham Court N/A   52.4375456 -1.8926849
4054 op-snap---monthly-publication-december-2025.pdf   182 2025-12 Car Skoda Octavia Black Contravening a Red Traffic Light None Fenton Street Fenton Street Sandwell Sandwell Court N/A   52.5004036 -1.9790049
4087 op-snap---monthly-publication-december-2025.pdf   215 2025-12 Car Audi A3 White Driving without Due Care and Attention Use vehicle on a road withou tO vladlbidu rtye sRtd certificate t O vladlbidu rtye s Rtd certificate Sandwell Sandwell Court N/A      
4088 op-snap---monthly-publication-december-2025.pdf   216 2025-12 Car Mercedes-Benz c250 Black Driving without Due Care and Attention None Shaftmoor Lane Shaftmoor Lane Birmingham Birmingham Court N/A   52.4418944 -1.8407335
4090 op-snap---monthly-publication-december-2025.pdf   218 2025-12 Car Peugeot 3008.. Grey Driving without Due Care and Attention None Birmingham Fort Parkway Birmingham Fort Parkway Birmingham Birmingham Court N/A   52.5084571 -1.8214016
4107 op-snap---monthly-publication-december-2025.pdf   235 2025-12 Car Toyota Corolla White Driving without Due Care and Attention None London Road London Road Coventry Coventry Court N/A   52.3916468 -1.4925995
4119 op-snap---monthly-publication-december-2025.pdf   247 2025-12 Car Seat Leon Grey Driving without Due Care and Attention None Buckland End Lane Buckland End Lane Birmingham Birmingham Court N/A      
4150 op-snap---monthly-publication-december-2025.pdf   278 2025-12 Car Volkswagen Polo Black Contravening a Red Traffic Light None Park Gate Road Park Gate Road Coventry Coventry Court N/A   52.4538286 -1.7889568
4186 op-snap---monthly-publication-december-2025.pdf   314 2025-12 Car Volvo XC90 Blue Driving without Due Care and Attention No Insurance Richmond Road Richmond Road Birmingham Birmingham Court N/A   52.566947 -1.8291809
4190 op-snap---monthly-publication-december-2025.pdf   318 2025-12 Car Peugeot 208 Black Driving without Due Care and Attention None A38 Aston Expressway Aston Expressway Birmingham Birmingham Court N/A   52.493793 -1.8881773
4303 op-snap---monthly-publication-december-2025.pdf   431 2025-12 Car Toyota Avensis Silver Driving without Due Care and Attention No Insurance Lichefield Road Lichfield Road Walsall Walsall Court N/A   52.6095168 -2.0493009

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