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

367 rows where disposal = "Warning Letter" and offence = "Driving without Reasonable Consideration" 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, nfa_rationale

vehicle_make >30

  • Ford 59
  • Volkswagen 46
  • Audi 28
  • Mercedes-Benz 26
  • BMW 25
  • Vauxhall 25
  • Toyota 19
  • Nissan 16
  • Peugeot 12
  • Renault 12
  • Seat 10
  • Citroen 9
  • Honda 8
  • Hyundai 8
  • Volvo 8
  • Kia 5
  • Land Rover 5
  • Lexus 4
  • Mini 4
  • Porsche 4
  • Skoda 4
  • Daf 3
  • Fiat 3
  • Jaguar 3
  • Chevrolet 2
  • Mazda 2
  • Mg 2
  • Yamaha 2
  • Alfa Romeo 1
  • Byd 1
  • …

council_area 14

  • Birmingham 211
  • Coventry 56
  • Solihull 25
  • Dudley 22
  • Walsall 12
  • Wolverhampton 12
  • Sandwell 10
  • Sutton Coldfield 8
  • Metropolitan Borough 6
  • Edr Uwditlhe Ystaffs Police 1
  • Halesowen 1
  • Metropolitan Boroug 1
  • Metropolitan Borough Of Dudley 1
  • Out of Force Area 1

month 13

  • 2025-03 106
  • 2025-02 60
  • 2025-01 49
  • 2025-06 45
  • 2025-04 32
  • 2025-08 19
  • 2025-05 18
  • 2025-09 18
  • 2025-07 12
  • 2025-10 3
  • 2025-11 2
  • 2026-02 2
  • 2026-01 1

reporter_transport_mode 8

  • Car 222
  • Pedal Bike 125
  • Pedestrian 10
  • Other 4
  • Lorry 2
  • Motorbike 2
  • Bus 1
  • Van 1

offence 1

  • Driving without Reasonable Consideration · 367 ✖

disposal 1

  • Warning Letter · 367 ✖
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
7958 op-snap---monthly-publication-february-2026.pdf   705 2026-02 Car Mercedes-Benz EAQ 350 Grey Driving without Reasonable Consideration None Five ways Five ways Birmingham Birmingham Warning Letter N/A   52.4710941 -1.9130708
8804 op-snap---monthly-publication-february-2026.pdf   1551 2026-02 Car Ford transit Black Driving without Reasonable Consideration None A45 Heartlands parkway Heartlands parkway Birmingham Birmingham Warning Letter N/A   52.5038363 -1.8432663
11000 op-snap---monthly-publication-january-2026.pdf   461 2026-01 Pedal Bike Volkswagen   Silver Driving without Reasonable Consideration None Queen Victoria Road Queen Victoria Road Coventry Coventry Warning Letter N/A   52.4063195 -1.5157306
20481 op-snap---monthly-publication-november-2025.pdf   23 2025-11 Car Skoda Kodiaq Black Driving without Reasonable Consideration None Lawley Middleway Lawley Middleway Birmingham Birmingham Warning Letter N/A   52.4801772 -1.8769185
22023 op-snap---monthly-publication-november-2025.pdf   1565 2025-11 Car BMW 520 Grey Driving without Reasonable Consideration None A45 A45 Coventry Coventry Warning Letter N/A      
22762 op-snap---monthly-publication-october-2025.pdf   712 2025-10 Car BMW 330 Black Driving without Reasonable Consideration None Grove Lane Grove Lane Birmingham Birmingham Warning Letter N/A   52.5055208 -1.9328067
23299 op-snap---monthly-publication-october-2025.pdf   1249 2025-10 Pedestrian Iveco Daily White Driving without Reasonable Consideration None Cockshed Lane Cockshed Lane Halesowen Halesowen Warning Letter N/A      
23380 op-snap---monthly-publication-october-2025.pdf   1330 2025-10 Pedestrian Ford Transit White Driving without Reasonable Consideration None Cheveral Avenue Cheveral Avenue Coventry Coventry Warning Letter N/A   52.4257402 -1.5185037
23822 op-snap---monthly-publication-september-2025.pdf   41 2025-09 Car Audi A4 White Driving without Reasonable Consideration None a45 A45 Coventry Coventry Warning Letter N/A      
23830 op-snap---monthly-publication-september-2025.pdf   49 2025-09 Pedal Bike Audi A1 Grey Driving without Reasonable Consideration None Corporation Street Corporation Street Coventry Coventry Warning Letter N/A   52.4086244 -1.515132
23933 op-snap---monthly-publication-september-2025.pdf   152 2025-09 Car Volvo S40 Silver Driving without Reasonable Consideration Use vehicle on a road without valid test certificate Hinckley Road Hinckley Road Coventry Coventry Warning Letter N/A   52.435502 -1.4327166
23965 op-snap---monthly-publication-september-2025.pdf   184 2025-09 Pedal Bike Vauxhall Insignia Silver Driving without Reasonable Consideration None Station Road Marston Green Station Road Marston Green Solihull Solihull Warning Letter N/A   52.4667342 -1.747421
24013 op-snap---monthly-publication-september-2025.pdf   232 2025-09 Pedal Bike Peugeot 207 Black Driving without Reasonable Consideration None St Marys Row Street Marys Row Birmingham Birmingham Warning Letter N/A      
24062 op-snap---monthly-publication-september-2025.pdf   281 2025-09 Car Nissan Qashqai Black Driving without Reasonable Consideration None Clifford Street, Newtown Clifford Street, Newtown Birmingham Birmingham Warning Letter N/A   52.4989738 -1.9005402
24190 op-snap---monthly-publication-september-2025.pdf   409 2025-09 Car Kia Ceed White Driving without Reasonable Consideration None Neachells Lane, Neachells Lane Wolverhampton Wolverhampton Warning Letter N/A   52.597459 -2.0791894
24205 op-snap---monthly-publication-september-2025.pdf   424 2025-09 Car Scania HGV white Driving without Reasonable Consideration None Tyburn House Island Tyburn House Island Birmingham Birmingham Warning Letter N/A   52.5194011 -1.8008643
24320 op-snap---monthly-publication-september-2025.pdf   539 2025-09 Car Ford Transit White Driving without Reasonable Consideration None Gravelly Hil Gravelly Hil Birmingham Birmingham Warning Letter N/A      
24336 op-snap---monthly-publication-september-2025.pdf   555 2025-09 Car Audi S3 Black Driving without Reasonable Consideration None Meadway Meadway Birmingham Birmingham Warning Letter N/A   52.4783348 -1.8007708
24688 op-snap---monthly-publication-september-2025.pdf   907 2025-09 Car Ford Fiesta Black Driving without Reasonable Consideration None Birmingham Road Birmingham Road Walsall Walsall Warning Letter N/A   52.5723244 -1.9607214
24692 op-snap---monthly-publication-september-2025.pdf   911 2025-09 Car Vauxhall Grandland Black Driving without Reasonable Consideration None Robin Hood Island Robin Hood Island Birmingham Birmingham Warning Letter N/A   52.4220705 -1.8372335
24727 op-snap---monthly-publication-september-2025.pdf   946 2025-09 Car Ford Transit White Driving without Reasonable Consideration None Bickenhill Lane / Station Link Road Island Bickenhill Lane / Station Link Road Island Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
24728 op-snap---monthly-publication-september-2025.pdf   947 2025-09 Car Volkswagen T-Roc Grey Driving without Reasonable Consideration None Bickenhill Lane / Station Link Road Island Bickenhill Lane / Station Link Road Island Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
24729 op-snap---monthly-publication-september-2025.pdf   948 2025-09 Car Honda Jazz Blue Driving without Reasonable Consideration None Bickenhill Lane / Station Link Road Island Bickenhill Lane / Station Link Road Island Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
24800 op-snap---monthly-publication-september-2025.pdf   1019 2025-09 Pedal Bike Byd Bus Grey Driving without Reasonable Consideration None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Warning Letter n/a   52.4221152 -1.4959475
24869 op-snap---monthly-publication-september-2025.pdf   1088 2025-09 Car Hyundai Kona Grey Driving without Reasonable Consideration None A45 A45 Birmingham Birmingham Warning Letter N/A      
25510 op-snap---monthly-publication-september-2025.pdf   1729 2025-09 Motorbike Yamaha   Grey Driving without Reasonable Consideration None Queensway Tunnel Queensway Tunnel Birmingham Birmingham Warning Letter N/A      
2055 op-snap---monthly-publication-august-2025.pdf   30 2025-08 Car Ford Fiesta Grey Driving without Reasonable Consideration None Friston Av Friston Avenue Birmingham Birmingham Warning Letter N/A   52.4744592 -1.9198786
2393 op-snap---monthly-publication-august-2025.pdf   368 2025-08 Car Kia Sportage Grey Driving without Reasonable Consideration None Wolverhampton Road Wolverhampton Road Dudley Dudley Warning Letter N/A   52.5063917 -2.1711502
2408 op-snap---monthly-publication-august-2025.pdf   383 2025-08 Car Nissan Juke Silver Driving without Reasonable Consideration None M5 Motorway SB M5 Motorway Southbound Sandwell Sandwell Warning Letter N/A      
2432 op-snap---monthly-publication-august-2025.pdf   407 2025-08 Car Nissan X-Trail Silver Driving without Reasonable Consideration None A45 Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
2513 op-snap---monthly-publication-august-2025.pdf   488 2025-08 Car Toyota Corolla Grey Driving without Reasonable Consideration None Hamstead Hill Hamstead Hill Birmingham Birmingham Warning Letter N/A   52.5274116 -1.9287273
2583 op-snap---monthly-publication-august-2025.pdf   558 2025-08 Other Audi A1 Black Driving without Reasonable Consideration None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
2584 op-snap---monthly-publication-august-2025.pdf   559 2025-08 Other Volkswagen Polo Black Driving without Reasonable Consideration None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
2585 op-snap---monthly-publication-august-2025.pdf   560 2025-08 Other Ford Fiesta Black Driving without Reasonable Consideration None Waterfront car park Waterfront car park Dudley Dudley Warning Letter N/A      
2710 op-snap---monthly-publication-august-2025.pdf   685 2025-08 Car Volkswagen Golf Grey Driving without Reasonable Consideration None Jimmy Hill WAY Jimmy Hill WAY Coventry Coventry Warning Letter N/A   52.4214017 -1.4870278
2829 op-snap---monthly-publication-august-2025.pdf   804 2025-08 Car Porsche Cayenne Blue Driving without Reasonable Consideration None Kirby Corner Island Kirby Corner Island Coventry Coventry Warning Letter N/A      
2855 op-snap---monthly-publication-august-2025.pdf   830 2025-08 Car Nissan Primastar Grey Driving without Reasonable Consideration None St Andrews Road Street Andrews Road Dudley Dudley Warning Letter N/A      
2857 op-snap---monthly-publication-august-2025.pdf   832 2025-08 Car Mercedes-Benz A class Silver Driving without Reasonable Consideration None St Andrews Street, Netherton Street Andrews Street, Netherton Dudley Dudley Warning Letter N/A   52.4905847 -2.0868385
2860 op-snap---monthly-publication-august-2025.pdf   835 2025-08 Car Skoda Karoq White Driving without Reasonable Consideration None St Andrews Road Street Andrews Road Dudley Dudley Warning Letter N/A      
2894 op-snap---monthly-publication-august-2025.pdf   869 2025-08 Motorbike Ford Focus Blue Driving without Reasonable Consideration None Sir Robert Peel Junction, Bloxwich Sir Robert Peel Junction, Bloxwich Wolverhampton Wolverhampton Warning Letter N/A      
2919 op-snap---monthly-publication-august-2025.pdf   894 2025-08 Car Volkswagen Touran Black Driving without Reasonable Consideration None Battery Way Battery Way Birmingham Birmingham Warning Letter N/A   52.4493988 -1.8476406
3120 op-snap---monthly-publication-august-2025.pdf   1095 2025-08 Car Ford Fiesta Blue Driving without Reasonable Consideration None Bickenhill Lane Bickenhill Lane Solihull Solihull Warning Letter N/A   52.4490463 -1.7296897
3187 op-snap---monthly-publication-august-2025.pdf   1162 2025-08 Car Peugeot Van White Driving without Reasonable Consideration None Thornhill Road Thornhill Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5690586 -1.8794686
3199 op-snap---monthly-publication-august-2025.pdf   1174 2025-08 Car Audi A3 White Driving without Reasonable Consideration None Chester Road, New Oscott Chester Road, New Oscott Birmingham Birmingham Warning Letter N/A   52.5459731 -1.8568254
3784 op-snap---monthly-publication-august-2025.pdf   1759 2025-08 Car Ford Focus Blue Driving without Reasonable Consideration None Torrington Avenue Torrington Avenue Coventry Coventry Warning Letter N/A   52.3987354 -1.567693
11985 op-snap---monthly-publication-july-2025.pdf   37 2025-07 Pedal Bike Honda Insight Silver Driving without Reasonable Consideration None Parsonage Street, West Bromwich Parsonage Street, West Bromwich Sandwell Sandwell Warning Letter N/A   52.5306821 -1.9875151
11989 op-snap---monthly-publication-july-2025.pdf   41 2025-07 Car Volkswagen Caddy White Driving without Reasonable Consideration None Grange Road, Coventry Grange Road, Coventry Coventry Coventry Warning Letter N/A   52.4521035 -1.4777638
12143 op-snap---monthly-publication-july-2025.pdf   195 2025-07 Car Skoda Octavia Black Driving without Reasonable Consideration None A444 Jimmy Hill Way Jimmy Hill Way Coventry Coventry Warning Letter N/A   52.4214017 -1.4870278
12162 op-snap---monthly-publication-july-2025.pdf   214 2025-07 Car Mercedes-Benz Sprinter White Driving without Reasonable Consideration None M6 Southbound approaching Jn6 M6 Southbound approaching Jn6 Birmingham Birmingham Warning Letter N/A      
12287 op-snap---monthly-publication-july-2025.pdf   339 2025-07 Pedal Bike Volvo V40 Blue Driving without Reasonable Consideration None 6 ways roundabout 6 Ways Roundabout Birmingham Birmingham Warning Letter N/A      
12371 op-snap---monthly-publication-july-2025.pdf   423 2025-07 Car Toyota Auris White Driving without Reasonable Consideration None Clifford Bridge Road Clifford Bridge Road Coventry Coventry Warning Letter N/A   52.4134557 -1.4442138
12394 op-snap---monthly-publication-july-2025.pdf   446 2025-07 Car Toyota Auris Silver Driving without Reasonable Consideration None Walsall Rd Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
12576 op-snap---monthly-publication-july-2025.pdf   628 2025-07 Car Ford Transit Red Driving without Reasonable Consideration None Cotterills Lane Cotterills Lane Birmingham Birmingham Warning Letter N/A   52.4884297 -1.817811
12584 op-snap---monthly-publication-july-2025.pdf   636 2025-07 Car Vauxhall Astra Grey Driving without Reasonable Consideration None Moseley Avenue Moseley Avenue Coventry Coventry Warning Letter N/A   52.417344 -1.5264979
12687 op-snap---monthly-publication-july-2025.pdf   739 2025-07 Pedal Bike BMW 330E White Driving without Reasonable Consideration None A38 Tyburn Road Tyburn Road Birmingham Birmingham Warning Letter N/A   52.5113867 -1.8337258
12937 op-snap---monthly-publication-july-2025.pdf   989 2025-07 Car Mg ZS Silver Driving without Reasonable Consideration None Kyotts Lake Road Kyotts Lake Road Birmingham Birmingham Warning Letter N/A   52.4655028 -1.8755351
14055 op-snap---monthly-publication-july-2025.pdf   2107 2025-07 Pedal Bike Vauxhall Grandland Blue Driving without Reasonable Consideration None Colehill Heath Colehill Heath Birmingham Birmingham Warning Letter N/A      
14097 op-snap---monthly-publication-june-2025.pdf   26 2025-06 Car Ford Transit White Driving without Reasonable Consideration None Bloxwich Lane Bloxwich Lane Walsall Walsall Warning Letter N/A   52.6020474 -2.014682
14148 op-snap---monthly-publication-june-2025.pdf   77 2025-06 Car Mg three Black Driving without Reasonable Consideration None Avenue Road Avenue Road Birmingham Birmingham Warning Letter N/A   52.4941712 -1.8795158
14155 op-snap---monthly-publication-june-2025.pdf   84 2025-06 Car Ford Ranger White Driving without Reasonable Consideration None Smithy Lane Smithy Lane Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5094086 -2.1346957
14157 op-snap---monthly-publication-june-2025.pdf   86 2025-06 Car Vauxhall Corsa White Driving without Reasonable Consideration None Milking Bank Milking Bank Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5182185 -2.1123641
14158 op-snap---monthly-publication-june-2025.pdf   87 2025-06 Car Yamaha ns50 Grey Driving without Reasonable Consideration None A4152 at A452 A4152 at A452 Walsall Walsall Warning Letter N/A   52.5805622 -1.9769245
14223 op-snap---monthly-publication-june-2025.pdf   152 2025-06 Pedestrian Peugeot Partner White Driving without Reasonable Consideration None Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
14263 op-snap---monthly-publication-june-2025.pdf   192 2025-06 Car Toyota Yaris Silver Driving without Reasonable Consideration None Belgrave Road Belgrave Road Birmingham Birmingham Warning Letter N/A   52.4669004 -1.9011385
14284 op-snap---monthly-publication-june-2025.pdf   213 2025-06 Car Ford Ranger White Driving without Reasonable Consideration None Highbridge Road Highbridge Road Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.5472182 -1.8359595
14327 op-snap---monthly-publication-june-2025.pdf   256 2025-06 Car Volvo XC60 Grey Driving without Reasonable Consideration None Spring Lane Spring Lane Birmingham Birmingham Warning Letter N/A   52.5182019 -1.8336169
14338 op-snap---monthly-publication-june-2025.pdf   267 2025-06 Car Ford Puma Blue Driving without Reasonable Consideration None Kingston Road Kingston Road Birmingham Birmingham Warning Letter N/A   52.4747333 -1.8728345
14340 op-snap---monthly-publication-june-2025.pdf   269 2025-06 Car Mercedes-Benz A180 Black Driving without Reasonable Consideration None Kingston Road Kingston Road Birmingham Birmingham Warning Letter N/A   52.4747333 -1.8728345
14341 op-snap---monthly-publication-june-2025.pdf   270 2025-06 Car Audi A3 Green Driving without Reasonable Consideration None Kington Road Kington Road Birmingham Birmingham Warning Letter N/A      
14342 op-snap---monthly-publication-june-2025.pdf   271 2025-06 Car Hyundai I20 Grey Driving without Reasonable Consideration None Kington Road Kington Road Birmingham Birmingham Warning Letter N/A      
14343 op-snap---monthly-publication-june-2025.pdf   272 2025-06 Car Audi Q3 Silver Driving without Reasonable Consideration None Kington Road Kington Road Birmingham Birmingham Warning Letter N/A      
14409 op-snap---monthly-publication-june-2025.pdf   338 2025-06 Car   Scancia White Driving without Reasonable Consideration None Cinder Bank Cinder Bank Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.4951209 -2.0924902
14472 op-snap---monthly-publication-june-2025.pdf   401 2025-06 Car Seat Ateca Grey Driving without Reasonable Consideration None Hawbush Road Hawbush Road Metropolitan Borough Metropolitan Borough Warning Letter N/A   52.6037191 -1.9834465
14481 op-snap---monthly-publication-june-2025.pdf   410 2025-06 Pedal Bike Seat Ibiza Grey Driving without Reasonable Consideration None Wrentham St Wrentham Street Birmingham Birmingham Warning Letter N/A   52.4708757 -1.8966158
14503 op-snap---monthly-publication-june-2025.pdf   432 2025-06 Car Land Rover HSE Black Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A   52.4470686 -1.8880749
14558 op-snap---monthly-publication-june-2025.pdf   487 2025-06 Car Seat Arona Red Driving without Reasonable Consideration None Yorkminster Drive Yorkminster Drive Birmingham Birmingham Warning Letter N/A      
14693 op-snap---monthly-publication-june-2025.pdf   622 2025-06 Car Porsche Panamera Black Driving without Reasonable Consideration None Chester Road Chester Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5359496 -1.8324115
14701 op-snap---monthly-publication-june-2025.pdf   630 2025-06 Pedestrian Jaguar XE Sport Red Driving without Reasonable Consideration None Cotsymore Road Cotsymore Road Sutton Coldfield Sutton Coldfield Warning Letter N/A      
14772 op-snap---monthly-publication-june-2025.pdf   701 2025-06 Car Ford Fiesta Red Driving without Reasonable Consideration None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham Warning Letter N/A      
14794 op-snap---monthly-publication-june-2025.pdf   723 2025-06 Car BMW 535D Grey Driving without Reasonable Consideration None Marshlake Road Marshlake Road Solihull Solihull Warning Letter N/A      
14836 op-snap---monthly-publication-june-2025.pdf   765 2025-06 Car Volkswagen LT35 Red Driving without Reasonable Consideration None Upper Green Upper Green Wolverhampton Wolverhampton Warning Letter N/A   52.5991066 -2.168802
14865 op-snap---monthly-publication-june-2025.pdf   794 2025-06 Car BMW M3 White Driving without Reasonable Consideration None Holly Road Holly Road Birmingham Birmingham Warning Letter N/A   52.473564 -1.94941
15089 op-snap---monthly-publication-june-2025.pdf   1018 2025-06 Car Ford Focus Grey Driving without Reasonable Consideration None Dudley Road East Dudley Road East Sandwell Sandwell Warning Letter N/A   52.5111988 -2.0318469
15101 op-snap---monthly-publication-june-2025.pdf   1030 2025-06 Van BMW 140i blue Driving without Reasonable Consideration None Holbrook Lane Holbrook Lane Coventry Coventry Warning Letter N/A   52.436155 -1.5064002
15121 op-snap---monthly-publication-june-2025.pdf   1050 2025-06 Car Tesla Model Y White Driving without Reasonable Consideration None M6 Jn5 M6 Jn5 Birmingham Birmingham Warning Letter N/A      
15143 op-snap---monthly-publication-june-2025.pdf   1072 2025-06 Car Renault Megane White Driving without Reasonable Consideration None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Warning Letter N/A   52.5940902 -1.843503
15226 op-snap---monthly-publication-june-2025.pdf   1155 2025-06 Car Volkswagen Tiguan White Driving without Reasonable Consideration None Collector Road Collector Road Birmingham Birmingham Warning Letter N/A   52.5139393 -1.7600186
15239 op-snap---monthly-publication-june-2025.pdf   1168 2025-06 Car Land Rover Discovery Beige Driving without Reasonable Consideration None Maypole Island Maypole Island Birmingham Birmingham Warning Letter N/A   52.4047413 -1.8859323
15259 op-snap---monthly-publication-june-2025.pdf   1188 2025-06 Car Citroen C4 Grey Driving without Reasonable Consideration None A452 Collector Road Collector Road Birmingham Birmingham Warning Letter N/A   52.5139393 -1.7600186
15467 op-snap---monthly-publication-june-2025.pdf   1396 2025-06 Car Peugeot 307 Silver Driving without Reasonable Consideration None Holyhead Road Holyhead Road Birmingham Birmingham Warning Letter N/A   52.505233 -1.9446276
15470 op-snap---monthly-publication-june-2025.pdf   1399 2025-06 Car Ford Mondeo Blue Driving without Reasonable Consideration None A452 towards Erdington A452 towards Erdington Birmingham Birmingham Warning Letter N/A      
15471 op-snap---monthly-publication-june-2025.pdf   1400 2025-06 Car Volkswagen Tiguan Silver Driving without Reasonable Consideration None A452 towards Erdington A452 towards Erdington Birmingham Birmingham Warning Letter N/A      
15472 op-snap---monthly-publication-june-2025.pdf   1401 2025-06 Car Renault Scenic Red Driving without Reasonable Consideration None Tyburn House roundabout Tyburn House roundabout Birmingham Birmingham Warning Letter N/A      
15581 op-snap---monthly-publication-june-2025.pdf   1510 2025-06 Car Volkswagen Golf Grey Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
15633 op-snap---monthly-publication-june-2025.pdf   1562 2025-06 Car Nissan Qashqai Black Driving without Reasonable Consideration None Henwood Road Henwood Road Wolverhampton Wolverhampton Warning Letter N/A   52.5930037 -2.1685306
15634 op-snap---monthly-publication-june-2025.pdf   1563 2025-06 Pedal Bike Ford Puma White Driving without Reasonable Consideration None Long Mynd Road Long Mynd Road Birmingham Birmingham Warning Letter N/A   52.4257286 -1.9769008
15637 op-snap---monthly-publication-june-2025.pdf   1566 2025-06 Pedal Bike   WM BUS Red Driving without Reasonable Consideration None Gilson Way Gilson Way Birmingham Birmingham Warning Letter N/A      
15649 op-snap---monthly-publication-june-2025.pdf   1578 2025-06 Car BMW 1 series Grey Driving without Reasonable Consideration None A435 HGigh Street, Kings Heath A435 HGigh Street, Kings Heath Birmingham Birmingham Warning Letter N/A      
15704 op-snap---monthly-publication-june-2025.pdf   1633 2025-06 Car BMW 1 series Grey Driving without Reasonable Consideration None A41 A41 Sandwell Sandwell Warning Letter N/A      
15706 op-snap---monthly-publication-june-2025.pdf   1635 2025-06 Car Volkswagen Passat Grey Driving without Reasonable Consideration None Castlegate Island Castlegate Island Sandwell Sandwell Warning Letter N/A      

Next page

Advanced export

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

CSV options:

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