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

486 rows where month = "2025-08", 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: vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make >30

reporter_transport_mode 1

  • Car · 486 ✖

offence 1

  • Driving without Due Care and Attention · 486 ✖

month 1

  • 2025-08 · 486 ✖
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
2025 op-snap---monthly-publication-august-2025.pdf   0 2025-08 Car BMW 120M White Driving without Due Care and Attention None Dudley Road Dudley Road Birmingham Birmingham Education N/A   52.4865107 -1.9386263
2032 op-snap---monthly-publication-august-2025.pdf   7 2025-08 Car BMW 525I Grey Driving without Due Care and Attention None Richmond Hill Road Richmond Hill Road Birmingham Birmingham Fixed Penalty N/A   52.4607238 -1.935227
2037 op-snap---monthly-publication-august-2025.pdf   12 2025-08 Car Cupra Ateca Grey Driving without Due Care and Attention None Sedgley Road Sedgley Road Sandwell Sandwell Warning Letter N/A   52.5219813 -2.0581691
2039 op-snap---monthly-publication-august-2025.pdf   14 2025-08 Car Skoda Suberb Black Driving without Due Care and Attention None Jayshaw Avenue Jayshaw Avenue Birmingham Birmingham Education N/A      
2041 op-snap---monthly-publication-august-2025.pdf   16 2025-08 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Hamstead Road Hamstead Road Birmingham Birmingham NFA Not in Public Interest   52.505832 -1.92002
2042 op-snap---monthly-publication-august-2025.pdf   17 2025-08 Car Ford Fiesta Silver Driving without Due Care and Attention None Walsall Road Walsall Road Walsall Walsall NFA No Offence   52.6166864 -1.9660822
2044 op-snap---monthly-publication-august-2025.pdf   19 2025-08 Car Ford Mondeo Black Driving without Due Care and Attention None Foleshill Road Foleshill Road Coventry Coventry Court N/A   52.4274335 -1.5002381
2049 op-snap---monthly-publication-august-2025.pdf   24 2025-08 Car Seat Leon White Driving without Due Care and Attention None Swanshurst Lane Swanshurst Lane Birmingham Birmingham Education N/A   52.4337146 -1.8634884
2054 op-snap---monthly-publication-august-2025.pdf   29 2025-08 Car Ford Puma Grey Driving without Due Care and Attention None Dudley Road Dudley Road Dudley Dudley Education N/A   52.4881161 -2.1199108
2056 op-snap---monthly-publication-august-2025.pdf   31 2025-08 Car BMW X3 Black Driving without Due Care and Attention None A38 A38 Birmingham Birmingham Warning Letter N/A      
2058 op-snap---monthly-publication-august-2025.pdf   33 2025-08 Car Ford Fiesta Grey Driving without Due Care and Attention None Blake Street Blake Street Sutton Coldfield Sutton Coldfield Education N/A   52.6043776 -1.8446597
2061 op-snap---monthly-publication-august-2025.pdf   36 2025-08 Car   Subaru Grey Driving without Due Care and Attention None Meeting House Lane Meeting House Lane Coventry Coventry NFA No Offence      
2064 op-snap---monthly-publication-august-2025.pdf   39 2025-08 Car Volvo XC40 Black Driving without Due Care and Attention None Wellington Road Wellington Road Birmingham Birmingham Education N/A   52.5133725 -1.9193405
2065 op-snap---monthly-publication-august-2025.pdf   40 2025-08 Car Ford C Maxx White Driving without Due Care and Attention None A5127 A5127 Birmingham Birmingham Education N/A      
2074 op-snap---monthly-publication-august-2025.pdf   49 2025-08 Car Fiat Scudo Grey Driving without Due Care and Attention None Bunbury Road Bunbury Road Birmingham Birmingham Warning Letter N/A   52.4142089 -1.9587147
2075 op-snap---monthly-publication-august-2025.pdf   50 2025-08 Car Volkswagen Golf Grey Driving without Due Care and Attention None Green Lane Small Heath Green Lane Small Heath Birmingham Birmingham Fixed Penalty N/A   52.4733613 -1.8591116
2076 op-snap---monthly-publication-august-2025.pdf   51 2025-08 Car Vauxhall Zafira Silver Driving without Due Care and Attention None Bromford Lane / Heartlands Parkway Bromford Lane / Heartlands Parkway Birmingham Birmingham Court N/A   52.5083238 -1.8332287
2078 op-snap---monthly-publication-august-2025.pdf   53 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None Jimmy Hill Way Jimmy Hill Way Coventry Coventry NFA No Offence   52.4214017 -1.4870278
2085 op-snap---monthly-publication-august-2025.pdf   60 2025-08 Car Vauxhall Corsa White Driving without Due Care and Attention None Charnwood Close Charnwood Close Birmingham Birmingham NFA No Offence   52.4095185 -2.0031237
2088 op-snap---monthly-publication-august-2025.pdf   63 2025-08 Car Tesla Model 3 White Driving without Due Care and Attention None Butts Road Butts Road Coventry Coventry Warning Letter N/A   52.4073149 -1.5250454
2095 op-snap---monthly-publication-august-2025.pdf   70 2025-08 Car Skoda Rapid Grey Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham NFA No Independent Evidence Available   52.4470686 -1.8880749
2097 op-snap---monthly-publication-august-2025.pdf   72 2025-08 Car Audi   Grey Driving without Due Care and Attention None Sky Blue Way Sky Blue Way Coventry Coventry NFA Not in Public Interest   52.4085943 -1.4943275
2098 op-snap---monthly-publication-august-2025.pdf   73 2025-08 Car Audi A3 White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
2099 op-snap---monthly-publication-august-2025.pdf   74 2025-08 Car Hyundai I30 Red Driving without Due Care and Attention None Shenstone Road Shenstone Road Birmingham Birmingham Warning Letter N/A   52.4011594 -1.879934
2101 op-snap---monthly-publication-august-2025.pdf   76 2025-08 Car Mercedes-Benz   Black Driving without Due Care and Attention None A425 Southam Southam Out of Force Are Out of Force Area NFA Out of Force      
2102 op-snap---monthly-publication-august-2025.pdf   77 2025-08 Car BMW 320.. Blue Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley Warning Letter N/A   52.5047428 -2.0823754
2103 op-snap---monthly-publication-august-2025.pdf   78 2025-08 Car Ford Mondeo Blue Driving without Due Care and Attention None A5 Telford Telford Out of Force Are Out of Force Area NFA Out of Force   52.4979333 -1.9664857
2105 op-snap---monthly-publication-august-2025.pdf   80 2025-08 Car Honda Civic Blue Driving without Due Care and Attention No Insurance Billesley Lane Billesley Lane Birmingham Birmingham Fixed Penalty N/A   52.4344402 -1.8845368
2106 op-snap---monthly-publication-august-2025.pdf   81 2025-08 Car   Polestar Silver Driving without Due Care and Attention No Insurance A52 Bottesford Bottesford Out of Force Are Out of Force Area NFA Out of Force      
2110 op-snap---monthly-publication-august-2025.pdf   85 2025-08 Car Seat Tarraco Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Sandwell Sandwell Education N/A   52.5461417 -1.9334193
2113 op-snap---monthly-publication-august-2025.pdf   88 2025-08 Car Vauxhall Astra Black Driving without Due Care and Attention None Quinton Road Quinton Road Birmingham Birmingham NFA No Offence   52.447826 -1.9574468
2115 op-snap---monthly-publication-august-2025.pdf   90 2025-08 Car Peugeot   White Driving without Due Care and Attention None M42 M42 Out of Force Are Out of Force Area NFA Out of Force      
2118 op-snap---monthly-publication-august-2025.pdf   93 2025-08 Car Lexus CT Black Driving without Due Care and Attention None     Coventry Coventry Education N/A      
2120 op-snap---monthly-publication-august-2025.pdf   95 2025-08 Car BMW 320d Black Driving without Due Care and Attention None Merry Hill Merry Hill Dudley Dudley NFA No Independent Evidence Available   52.4817646 -2.1113435
2121 op-snap---monthly-publication-august-2025.pdf   96 2025-08 Car Ford Transit Black Driving without Due Care and Attention None Illshaw Heath Road Illshaw Heath Road Solihull Solihull NFA No Offence   52.3735755 -1.8129528
2124 op-snap---monthly-publication-august-2025.pdf   99 2025-08 Car Mercedes-Benz   White Driving without Due Care and Attention None Horseshoes Lane Horseshoes Lane Solihull Solihull NFA No VRM      
2125 op-snap---monthly-publication-august-2025.pdf   100 2025-08 Car Ford Fiesta Blue Driving without Due Care and Attention None Bromsgrove Road (Studley) Bromsgrove Road (Studley) Out of Force Are Out of Force Area NFA Out of Force      
2126 op-snap---monthly-publication-august-2025.pdf   101 2025-08 Car Hyundai I30 White Driving without Due Care and Attention None Upper Church Road Upper Church Road Walsall Walsall Education N/A      
2129 op-snap---monthly-publication-august-2025.pdf   104 2025-08 Car BMW 330 Black Driving without Due Care and Attention None The Broadway The Broadway Walsall Walsall Education N/A   52.6090076 -2.0515573
2130 op-snap---monthly-publication-august-2025.pdf   105 2025-08 Car Mercedes-Benz AMG White Driving without Due Care and Attention None The Broadway The Broadway Walsall Walsall Education N/A   52.6090076 -2.0515573
2131 op-snap---monthly-publication-august-2025.pdf   106 2025-08 Car Mercedes-Benz N/K Silver Driving without Due Care and Attention None B4121 Barnes Hill Barnes Hill Birmingham Birmingham NFA No VRM   52.4401325 -1.9785938
2134 op-snap---monthly-publication-august-2025.pdf   109 2025-08 Car Dacia Stepway Grey Driving without Due Care and Attention None Daventry Road Daventry Road Out of Force Are Out of Force Area NFA Out of Force      
2142 op-snap---monthly-publication-august-2025.pdf   117 2025-08 Car Audi Q5 Grey Driving without Due Care and Attention None Shutt Lane Shutt Lane Solihull Solihull NFA No Offence   52.367795 -1.8250635
2145 op-snap---monthly-publication-august-2025.pdf   120 2025-08 Car Mercedes-Benz Vito Grey Driving without Due Care and Attention None M42 NB J7 M42 Northbound J7 Birmingham Birmingham NFA Outside of 14 DAYS Late Submission      
2147 op-snap---monthly-publication-august-2025.pdf   122 2025-08 Car Mercedes-Benz GLA Black Driving without Due Care and Attention None Battery Way Battery Way Birmingham Birmingham Education N/A   52.4493988 -1.8476406
2148 op-snap---monthly-publication-august-2025.pdf   123 2025-08 Car Volkswagen Polo Black Driving without Due Care and Attention None Bloxwich Road Bloxwich Road Walsall Walsall NFA No VRM   52.6099132 -1.9970978
2149 op-snap---monthly-publication-august-2025.pdf   124 2025-08 Car   Motorbike Black Driving without Due Care and Attention None Kingswinford High Street Kingswinford High Street Dudley Dudley NFA No VRM   52.4972711 -2.1679401
2150 op-snap---monthly-publication-august-2025.pdf   125 2025-08 Car Mercedes-Benz AMG C Black Driving without Due Care and Attention None M6 (T2 Toll) M6 (T2 Toll) Birmingham Birmingham NFA No Independent Evidence Available      
2151 op-snap---monthly-publication-august-2025.pdf   126 2025-08 Car Audi S3 Grey Driving without Due Care and Attention None M6 (T2 Toll) M6 (T2 Toll) Birmingham Birmingham NFA No Independent Evidence Available      
2153 op-snap---monthly-publication-august-2025.pdf   128 2025-08 Car Hyundai I10 Red Driving without Due Care and Attention None Bickenhill Lane Bickenhill Lane Birmingham Birmingham NFA Not in Public Interest      
2160 op-snap---monthly-publication-august-2025.pdf   135 2025-08 Car Ford Transit Grey Driving without Due Care and Attention None Bromsgrove Bromsgrove Out of Force Are Out of Force Area NFA Out of Force   52.4728322 -1.897536
2162 op-snap---monthly-publication-august-2025.pdf   137 2025-08 Car Volkswagen Golf Blue Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5292752 -1.7618805
2164 op-snap---monthly-publication-august-2025.pdf   139 2025-08 Car Mg 4SE Grey Driving without Due Care and Attention None Queensway Queensway Birmingham Birmingham NFA No Offence   52.4856447 -1.8972389
2166 op-snap---monthly-publication-august-2025.pdf   141 2025-08 Car Mazda 2.. Blue Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
2169 op-snap---monthly-publication-august-2025.pdf   144 2025-08 Car Honda CRV Black Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham NFA No Independent Evidence Available   52.4668753 -1.8996143
2173 op-snap---monthly-publication-august-2025.pdf   148 2025-08 Car Seat Leon Black Driving without Due Care and Attention None Himley Road Himley Road Dudley Dudley Court N/A   52.5142667 -2.1304764
2174 op-snap---monthly-publication-august-2025.pdf   149 2025-08 Car Audi A4 Black Driving without Due Care and Attention None Monmouth Drive Monmouth Drive Sutton Coldfield Sutton Coldfield NFA No Offence   52.5575249 -1.8640053
2175 op-snap---monthly-publication-august-2025.pdf   150 2025-08 Car Vauxhall Insignia Silver Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Dudley Dudley Fixed Penalty N/A   52.5478387 -2.0943116
2176 op-snap---monthly-publication-august-2025.pdf   151 2025-08 Car Mercedes-Benz A220 White Driving without Due Care and Attention None M5 J2 NB M5 J2 Northbound Sandwell Sandwell NFA Outside of 14 Days NIP   52.4945433 -2.0190848
2177 op-snap---monthly-publication-august-2025.pdf   152 2025-08 Car Toyota Prius White Driving without Due Care and Attention None Raynor Road Raynor Road Wolverhampton Wolverhampton NFA No Offence   52.6043868 -2.1046385
2178 op-snap---monthly-publication-august-2025.pdf   153 2025-08 Car Mercedes-Benz benz Silver Driving without Due Care and Attention None Raynor Road Raynor Road Wolverhampton Wolverhampton NFA No Offence   52.6043868 -2.1046385
2179 op-snap---monthly-publication-august-2025.pdf   154 2025-08 Car Mercedes-Benz A Class White Driving without Due Care and Attention None Ringway, Whitefriars Ringway, Whitefriars Coventry Coventry NFA Not in Public Interest      
2181 op-snap---monthly-publication-august-2025.pdf   156 2025-08 Car Honda   Black Driving without Due Care and Attention None M6 M6 Birmingham Birmingham NFA Not in Public Interest      
2182 op-snap---monthly-publication-august-2025.pdf   157 2025-08 Car Audi RS3 Grey Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham NFA No VRM   52.4622646 -1.8599985
2183 op-snap---monthly-publication-august-2025.pdf   158 2025-08 Car Volkswagen Passat Black Driving without Due Care and Attention None City Road City Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4763176 -1.9584897
2185 op-snap---monthly-publication-august-2025.pdf   160 2025-08 Car Ford Puma White Driving without Due Care and Attention None A41 A41 Sandwell Sandwell Warning Letter N/A      
2186 op-snap---monthly-publication-august-2025.pdf   161 2025-08 Car BMW 118i Grey Driving without Due Care and Attention None Cole Hall Road Cole Hall Road Birmingham Birmingham Education N/A   52.4968357 -1.7908553
2188 op-snap---monthly-publication-august-2025.pdf   163 2025-08 Car Tesla   Grey Driving without Due Care and Attention None Newbold Road Newbold Road Out of Force Are Out of Force Area NFA Out of Force      
2190 op-snap---monthly-publication-august-2025.pdf   165 2025-08 Car Ford Fiesta Red Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Warning Letter N/A   52.4555288 -1.8613929
2195 op-snap---monthly-publication-august-2025.pdf   170 2025-08 Car Volkswagen Golf Grey Driving without Due Care and Attention None Churchbridge Churchbridge Sandwell Sandwell Warning Letter N/A   52.4938109 -2.0217545
2197 op-snap---monthly-publication-august-2025.pdf   172 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None Waverly Road Waverly Road Birmingham Birmingham NFA Misc Inc Crimes      
2205 op-snap---monthly-publication-august-2025.pdf   180 2025-08 Car Porsche Cayenne Black Driving without Due Care and Attention None New Hampton Road East New Hampton Road East Wolverhampton Wolverhampton Warning Letter N/A   52.5920541 -2.1374052
2209 op-snap---monthly-publication-august-2025.pdf   184 2025-08 Car   Saab Silver Driving without Due Care and Attention None Dunchurch Dunchurch Out of Force Are Out of Force Area NFA Out of Force      
2211 op-snap---monthly-publication-august-2025.pdf   186 2025-08 Car Ford Transit White Driving without Due Care and Attention None Aston Road Aston Road Birmingham Birmingham Warning Letter N/A   52.4929386 -1.888744
2212 op-snap---monthly-publication-august-2025.pdf   187 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention No Insurance Barrs Road Cradley Heath Barrs Road Cradley Heath Sandwell Sandwell Education N/A   52.4682935 -2.0660364
2213 op-snap---monthly-publication-august-2025.pdf   188 2025-08 Car Mercedes-Benz CLA 220 White Driving without Due Care and Attention None Darlaston Road Darlaston Road Walsall Walsall NFA Not in Public Interest   52.5635181 -2.0322876
2214 op-snap---monthly-publication-august-2025.pdf   189 2025-08 Car BMW 118d White Driving without Due Care and Attention None M6 South M6 South Coventry Coventry Fixed Penalty N/A   52.4146643 -1.5694761
2215 op-snap---monthly-publication-august-2025.pdf   190 2025-08 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Hatherton Street Hatherton Street Walsall Walsall Education N/A   52.5880551 -1.9796606
2216 op-snap---monthly-publication-august-2025.pdf   191 2025-08 Car Mercedes-Benz B Class Blue Driving without Due Care and Attention None Grove Lane Grove Lane Sandwell Sandwell Warning Letter N/A   52.4882564 -1.949089
2218 op-snap---monthly-publication-august-2025.pdf   193 2025-08 Car Vauxhall Insignia Black Driving without Due Care and Attention No Insurance Pensnett Drive Pensnett Drive Wolverhampton Wolverhampton NFA No Independent Evidence Available      
2219 op-snap---monthly-publication-august-2025.pdf   194 2025-08 Car Volkswagen Touran Blue Driving without Due Care and Attention None Bordsley Middleway Bordsley Middleway Birmingham Birmingham Warning Letter N/A      
2220 op-snap---monthly-publication-august-2025.pdf   195 2025-08 Car Vauxhall Corsa Blue Driving without Due Care and Attention None Keresley Road Keresley Road Coventry Coventry Warning Letter N/A   52.4331176 -1.5314475
2222 op-snap---monthly-publication-august-2025.pdf   197 2025-08 Car Mercedes-Benz A180 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA Not in Public Interest   52.4203897 -1.8338574
2228 op-snap---monthly-publication-august-2025.pdf   203 2025-08 Car Mercedes-Benz CLC180 Silver Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
2233 op-snap---monthly-publication-august-2025.pdf   208 2025-08 Car Vauxhall Agila Red Driving without Due Care and Attention None Gosford Street Gosford Street Coventry Coventry Education N/A   52.4068712 -1.4994695
2235 op-snap---monthly-publication-august-2025.pdf   210 2025-08 Car Toyota Aygo White Driving without Due Care and Attention Use vehicle on a road without valid test certificate A4040 A4040 Birmingham Birmingham Education N/A      
2237 op-snap---monthly-publication-august-2025.pdf   212 2025-08 Car BMW 530.. White Driving without Due Care and Attention None Childs Way Milton Keynes Childs Way Milton Keynes Out of Force Are Out of Force Area NFA Out of Force      
2240 op-snap---monthly-publication-august-2025.pdf   215 2025-08 Car Ford Fiesta White Driving without Due Care and Attention None Robin Hood Island Robin Hood Island Birmingham Birmingham Warning Letter N/A   52.4220705 -1.8372335
2242 op-snap---monthly-publication-august-2025.pdf   217 2025-08 Car Volkswagen Golf Red Driving without Due Care and Attention None Puma Way Puma Way Coventry Coventry Education N/A   52.401984 -1.5046079
2243 op-snap---monthly-publication-august-2025.pdf   218 2025-08 Car Land Rover Land Rover Grey Driving without Due Care and Attention None M40 M40 Out of Force Are Out of Force Area NFA Out of Force      
2244 op-snap---monthly-publication-august-2025.pdf   219 2025-08 Car BMW X5 Black Driving without Due Care and Attention None M4/m42 M4/m42 Out of Force Are Out of Force Area NFA Out of Force      
2246 op-snap---monthly-publication-august-2025.pdf   221 2025-08 Car Hyundai   Grey Driving without Due Care and Attention None Redhill, Telford Redhill, Telford Out of Force Are Out of Force Area NFA Out of Force      
2247 op-snap---monthly-publication-august-2025.pdf   222 2025-08 Car Toyota Corolla White Driving without Due Care and Attention None Dads Lane Dads Lane Birmingham Birmingham Education N/A   52.4375913 -1.9068522
2248 op-snap---monthly-publication-august-2025.pdf   223 2025-08 Car Land Rover Discovery Black Driving without Due Care and Attention None M40 towards Jct 15 M40 towards Junction 15 Out of Force Are Out of Force Area NFA Out of Force      
2249 op-snap---monthly-publication-august-2025.pdf   224 2025-08 Car Ford Focus Grey Driving without Due Care and Attention None A452 A452 Out of Force Are Out of Force Area NFA Out of Force      
2250 op-snap---monthly-publication-august-2025.pdf   225 2025-08 Car Audi Q2 Black Driving without Due Care and Attention None A34 A34 Birmingham Birmingham RTC - Actioned N/A      
2255 op-snap---monthly-publication-august-2025.pdf   230 2025-08 Car Ford   Grey Driving without Due Care and Attention None A45 A45 Coventry Coventry NFA Not in Public Interest      
2256 op-snap---monthly-publication-august-2025.pdf   231 2025-08 Car Volkswagen Golf Black Driving without Due Care and Attention None M42 M42 Birmingham Birmingham NFA No VRM      
2259 op-snap---monthly-publication-august-2025.pdf   234 2025-08 Car Scania   White Driving without Due Care and Attention None M42 NB J9 M42 Northbound J9 Out of Force Are Out of Force Area NFA Out of Force      
2260 op-snap---monthly-publication-august-2025.pdf   235 2025-08 Car   Triumph Black Driving without Due Care and Attention None Thornhill Road Thornhill Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5690586 -1.8794686

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