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

506 rows where disposal = "Court", offence = "Driving without Due Care and Attention" 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 · 506 ✖

offence 1

  • Driving without Due Care and Attention · 506 ✖

disposal 1

  • Court · 506 ✖
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
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
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
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
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
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
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
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
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      
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
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
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      
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
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
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
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
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
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
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      
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
4307 op-snap---monthly-publication-december-2025.pdf   435 2025-12 Car Volkswagen Golf Blue Driving without Due Care and Attention None Longbridge Lane Longbridge Lane Birmingham Birmingham Court N/A   52.3962003 -1.9821252
4351 op-snap---monthly-publication-december-2025.pdf   479 2025-12 Car Volvo V40.. Blue Driving without Due Care and Attention None Greenholm Road Greenholm Road Birmingham Birmingham Court N/A   52.5356973 -1.8929646
4402 op-snap---monthly-publication-december-2025.pdf   530 2025-12 Car Volkswagen Crafter White Driving without Due Care and Attention None Small Heath Highway Small Heath Highway Birmingham Birmingham Court N/A   52.4709298 -1.8722585
4403 op-snap---monthly-publication-december-2025.pdf   531 2025-12 Car Renault Kangoo White Driving without Due Care and Attention None M6 SB 10a-10 M6 Southbound 10a-10 Wolverhampton Wolverhampton Court N/A      
4411 op-snap---monthly-publication-december-2025.pdf   539 2025-12 Car Volkswagen Golf Black Driving without Due Care and Attention No Insurance Sedgley Road Sedgley Road Dudley Dudley Court N/A   52.5329532 -2.0933963
4427 op-snap---monthly-publication-december-2025.pdf   555 2025-12 Car Volkswagen Golf Grey Driving without Due Care and Attention No Insurance Haslucks Green Road, Shirley, Soli Haslucks Green Road, Shirley, Soli hSuolllihull Hsuolllihull Court N/A      
4431 op-snap---monthly-publication-december-2025.pdf   559 2025-12 Car Volkswagen Arteon Blue Driving without Due Care and Attention None Newport Road, Castle Bromwich Newport Road, Castle Bromwich Birmingham Birmingham Court N/A      
4539 op-snap---monthly-publication-december-2025.pdf   667 2025-12 Car   Maserati Blue Driving without Due Care and Attention None A38m A38m Birmingham Birmingham Court N/A      
4560 op-snap---monthly-publication-december-2025.pdf   688 2025-12 Car Mercedes-Benz A45 Silver Driving without Due Care and Attention None warwick road Warwick Road Solihull Solihull Court N/A   52.4428606 -1.812114
4730 op-snap---monthly-publication-december-2025.pdf   858 2025-12 Car Tesla Model Y White Driving without Due Care and Attention None Bunbury Road Bunbury Road Birmingham Birmingham Court N/A   52.4142089 -1.9587147
4826 op-snap---monthly-publication-december-2025.pdf   954 2025-12 Car Seat MII Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
4968 op-snap---monthly-publication-december-2025.pdf   1096 2025-12 Car Vauxhall Insignia Black Driving without Due Care and Attention None Bristol Road South Bristol Road South Birmingham Birmingham Court N/A   52.4119174 -1.9735247
5043 op-snap---monthly-publication-december-2025.pdf   1171 2025-12 Car Mercedes-Benz A160 Grey Driving without Due Care and Attention None Load Lane Load Lane Solihull Solihull Court N/A      
5046 op-snap---monthly-publication-december-2025.pdf   1174 2025-12 Car Mercedes-Benz C220 white Driving without Due Care and Attention None Cattel Road Cattel Road Birmingham Birmingham Court N/A      
5047 op-snap---monthly-publication-december-2025.pdf   1175 2025-12 Car Toyota Aygo Black Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Court N/A   52.4555288 -1.8613929
5058 op-snap---monthly-publication-december-2025.pdf   1186 2025-12 Car Renault Trafic White Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Court N/A   52.5458699 -1.9304484
20473 op-snap---monthly-publication-november-2025.pdf   15 2025-11 Car BMW 116i White Driving without Due Care and Attention No Insurance Coseley Road Island Coseley Road Island Wolverhampton Wolverhampton Court N/A   52.5618304 -2.0826954
20478 op-snap---monthly-publication-november-2025.pdf   20 2025-11 Car Seat Leon Black Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Court N/A      
20506 op-snap---monthly-publication-november-2025.pdf   48 2025-11 Car Volvo Lorry White Driving without Due Care and Attention None M42 Motorway M42 Motorway Birmingham Birmingham Court N/A   52.490826 -1.8882034
20579 op-snap---monthly-publication-november-2025.pdf   121 2025-11 Car Vauxhall Corsa Grey Driving without Due Care and Attention No Insurance Kingsbury Road Kingsbury Road Birmingham Birmingham Court N/A   52.5292752 -1.7618805
20584 op-snap---monthly-publication-november-2025.pdf   126 2025-11 Car Audi A4 White Driving without Due Care and Attention No Insurance Stonehouse Lane Stonehouse Lane Birmingham Birmingham Court N/A   52.4440435 -1.9818872
20611 op-snap---monthly-publication-november-2025.pdf   153 2025-11 Car Ford Focus Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Court N/A   52.4167654 -1.9411244
20619 op-snap---monthly-publication-november-2025.pdf   161 2025-11 Car Vauxhall Crossland Black Driving without Due Care and Attention None Tixall Road Tixall Road Birmingham Birmingham Court N/A   52.4193312 -1.8517995
20624 op-snap---monthly-publication-november-2025.pdf   166 2025-11 Car BMW 3 Series White Driving without Due Care and Attention No Insurance Dudley Port Dudley Port Sandwell Sandwell Court N/A   52.524461 -2.0492538
20627 op-snap---monthly-publication-november-2025.pdf   169 2025-11 Car Nissan Micra Grey Driving without Due Care and Attention None Willenhall Road Willenhall Road Wolverhampton Wolverhampton Court N/A   52.5836778 -2.0894997
20634 op-snap---monthly-publication-november-2025.pdf   176 2025-11 Car Ford Transit White Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Court 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);