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

85 rows where council_area = "Out of Force Area", month = "2025-03" 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, nfa_rationale, latitude, longitude

vehicle_make 26

  • Ford 9
  • Volkswagen 9
  • BMW 6
  • Mercedes-Benz 6
  • Nissan 6
  • Audi 5
  • Vauxhall 5
  • Daf 4
  • Honda 4
  • Land Rover 3
  • Peugeot 3
  • Volvo 3
  • Fiat 2
  • Mini 2
  • Skoda 2
  • Toyota 2
  • Citroen 1
  • Dacia 1
  • Isuzu 1
  • Jaguar 1
  • Kia 1
  • Lexus 1
  • Mg 1
  • Mitsubishi 1
  • Porsche 1
  • Seat 1

offence 15

  • Driving without Due Care and Attention 44
  • Contravening a Red Traffic Light 14
  • Driving without Reasonable Consideration 10
  • Using a Mobile Phone Whilst Driving 4
  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 3
  • Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway 1
  • Drive on hard shoulder 1
  • Driving a vehicle wholly or partly on a footpath 1
  • Fail to display rear VRM plate 1
  • Misc - Non Traffic Offences 1
  • Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD 1
  • Motor vehicle fail to comply with solid white line road markings 1
  • No Seat Belt 1
  • Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger 1
  • Vehicle overtake within crossing limits 1

disposal 2

  • NFA 84
  • Warning Letter 1

reporter_transport_mode 1

  • Car · 85 ✖

month 1

  • 2025-03 · 85 ✖

council_area 1

  • Out of Force Area · 85 ✖
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
16274 op-snap---monthly-publication-march-2025.pdf   31 2025-03 Car Skoda Fabia Silver Driving without Due Care and Attention None Market Rasen, near Lincoln Market Rasen, near Lincoln Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16307 op-snap---monthly-publication-march-2025.pdf   64 2025-03 Car Volkswagen Golf White Driving without Reasonable Consideration None M42 Junction 2 M42 Junction 2 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4945433 -2.0190848
16309 op-snap---monthly-publication-march-2025.pdf   66 2025-03 Car Honda CRV Black Driving without Due Care and Attention None Alvechurch Highway, Bromsgrove Alvechurch Highway, Bromsgrove Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16310 op-snap---monthly-publication-march-2025.pdf   67 2025-03 Car Fiat 500 Black Driving without Due Care and Attention None Roughill Drive Roughill Drive Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16330 op-snap---monthly-publication-march-2025.pdf   87 2025-03 Car Audi Q2 Blue Contravening a Red Traffic Light None Slade Road Slade Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.5245181 -1.8591675
16350 op-snap---monthly-publication-march-2025.pdf   107 2025-03 Car Ford Transit White Using a Mobile Phone Whilst Driving None Mappleborough Green Mappleborough Green Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.402696 -1.8478197
16367 op-snap---monthly-publication-march-2025.pdf   124 2025-03 Car Nissan Micra Grey Contravening a Red Traffic Light None Stourton on Staffs Police Stourton on Staffs Police Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16368 op-snap---monthly-publication-march-2025.pdf   125 2025-03 Car Mg ZS White Contravening a Red Traffic Light None Stourton on Staffs Police Stourton on Staffs Police Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16369 op-snap---monthly-publication-march-2025.pdf   126 2025-03 Car Vauxhall Corsa Black Contravening a Red Traffic Light None Stourton on Staffs Police Stourton on Staffs Police Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16418 op-snap---monthly-publication-march-2025.pdf   175 2025-03 Car Audi S8 White Driving without Due Care and Attention No Insurance Kite Hardwick, Warwickshire Kite Hardwick, Warwickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16482 op-snap---monthly-publication-march-2025.pdf   239 2025-03 Car Volkswagen Passat Grey Driving without Due Care and Attention None a5 A5 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16508 op-snap---monthly-publication-march-2025.pdf   265 2025-03 Car Nissan Micra Black Vehicle overtake within crossing limits None Watton Lane, Waterorton Watton Lane, Waterorton Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16572 op-snap---monthly-publication-march-2025.pdf   329 2025-03 Car Daf Truck White Misc - Non Traffic Offences None A5 Cannock Cannock Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16576 op-snap---monthly-publication-march-2025.pdf   333 2025-03 Car BMW 520D Black Driving without Due Care and Attention None B4086 Warickshire Warickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16583 op-snap---monthly-publication-march-2025.pdf   340 2025-03 Car Citroen Berlingo White Using a Mobile Phone Whilst Driving None M5 Northbound towards Bromsgrove? M5 Northbound towards Bromsgrove? Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16603 op-snap---monthly-publication-march-2025.pdf   360 2025-03 Car Ford Focus Grey Driving without Due Care and Attention None Shrewsbury area Shrewsbury area Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16639 op-snap---monthly-publication-march-2025.pdf   396 2025-03 Car Kia Sportage Brown Driving without Due Care and Attention None Hortonwood Road Telford Hortonwood Road Telford Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16640 op-snap---monthly-publication-march-2025.pdf   397 2025-03 Car Seat Ateca White Driving without Reasonable Consideration None Watling Street, Atherstone Watling Street, Atherstone Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16664 op-snap---monthly-publication-march-2025.pdf   421 2025-03 Car Mini Cooper Grey Contravening a Red Traffic Light None Fernhill Heath Fernhill Heath Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16703 op-snap---monthly-publication-march-2025.pdf   460 2025-03 Car Ford Transit White Driving without Due Care and Attention None B4380 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.6195535 -2.0193824
16723 op-snap---monthly-publication-march-2025.pdf   480 2025-03 Car Porsche Cayenne Silver Driving without Due Care and Attention None A51 Little Haywood, Staffs Little Haywood, Staffs Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16730 op-snap---monthly-publication-march-2025.pdf   487 2025-03 Car BMW R1200RT Red Driving without Due Care and Attention None A525 Whitchurch, Staffs. Whitchurch, Staffs Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16731 op-snap---monthly-publication-march-2025.pdf   488 2025-03 Car Daf Tractor White Driving without Due Care and Attention None Wolverhampton Road, Kidderminstrer Wolverhampton Road, Kidderminstrer Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16747 op-snap---monthly-publication-march-2025.pdf   504 2025-03 Car Mercedes-Benz AMG A35 Grey Driving without Due Care and Attention None Cheltenham Road Cheltenham Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16759 op-snap---monthly-publication-march-2025.pdf   516 2025-03 Car Daf Artic White Driving without Due Care and Attention None A45, London Road, Stretton on Dunsmore A45, London Road, Stretton on Dunsmore Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16812 op-snap---monthly-publication-march-2025.pdf   569 2025-03 Car Ford Transit White Fail to display rear VRM plate None M6 Junction 2 M6 Junction 2 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.676119 -2.0858425
16819 op-snap---monthly-publication-march-2025.pdf   576 2025-03 Car Land Rover Discovery White Contravening a Red Traffic Light None A449 Towards Stafford Towards Stafford Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16823 op-snap---monthly-publication-march-2025.pdf   580 2025-03 Car BMW 3 series Black Using a Mobile Phone Whilst Driving None Astwood Bank, Worcester Astwood Bank, Worcester Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16861 op-snap---monthly-publication-march-2025.pdf   618 2025-03 Car Isuzu D-MAX Orange Drive on hard shoulder None M18 M18 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16881 op-snap---monthly-publication-march-2025.pdf   638 2025-03 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Green Street Green Street Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4737217 -1.8844945
16930 op-snap---monthly-publication-march-2025.pdf   687 2025-03 Car Vauxhall Movano White Use on a road a motor vehicle / trailer in such a condition it caused / was likley to cause danger None A520 Weston Road Meir Stoke on Trent Weston Road Meir Stoke on Trent Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16947 op-snap---monthly-publication-march-2025.pdf   704 2025-03 Car Honda ncs 50 Grey Contravening a Red Traffic Light None Old Birmingham Road Old Birmingham Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.5226944 -2.0765801
16949 op-snap---monthly-publication-march-2025.pdf   706 2025-03 Car Mini   White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Basin Road, Worcester Basin Road, Worcester Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
16958 op-snap---monthly-publication-march-2025.pdf   715 2025-03 Car Audi UK   Driving without Due Care and Attention None A5 Shrewsbury Shrewsbury Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.6195535 -2.0193824
17007 op-snap---monthly-publication-march-2025.pdf   764 2025-03 Car Honda Jazz Black Driving without Due Care and Attention None A441 Warwick Highway Warwick Highway Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17009 op-snap---monthly-publication-march-2025.pdf   766 2025-03 Car   Ssangyong Red Driving without Due Care and Attention None Dunstable Dunstable Out of Force Area Out of Force Area NFA Out of Force      
17021 op-snap---monthly-publication-march-2025.pdf   778 2025-03 Car Skoda Octivia Silver No Seat Belt None Furnace End Furnace End Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4585095 -2.0531143
17047 op-snap---monthly-publication-march-2025.pdf   804 2025-03 Car Ford fOCUS Blue Driving without Due Care and Attention None M1 Notts M1 Notts Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17060 op-snap---monthly-publication-march-2025.pdf   817 2025-03 Car Mercedes-Benz Benz White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Old Smithfield (Bridgnorth) Old Smithfield (Bridgnorth) Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17093 op-snap---monthly-publication-march-2025.pdf   850 2025-03 Car Ford C Max Blue Driving without Reasonable Consideration None Campden Road (Stratford) Campden Road (Stratford) Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17152 op-snap---monthly-publication-march-2025.pdf   909 2025-03 Car Ford Fiesta Black Driving without Due Care and Attention None Harvington Harvington Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.5428258 -1.7945489
17180 op-snap---monthly-publication-march-2025.pdf   937 2025-03 Car Nissan Qashqai Blue Contravening a Red Traffic Light None A456 Hagley Road (West Mercia) Hagley Road (West Mercia) Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17183 op-snap---monthly-publication-march-2025.pdf   940 2025-03 Car Vauxhall Corsa Black Contravening a Red Traffic Light None Snowford Hill Road Snowford Hill Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17208 op-snap---monthly-publication-march-2025.pdf   965 2025-03 Car Mercedes-Benz C63 Silver Driving without Due Care and Attention None M62 Pontefract M62 Pontefract Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17225 op-snap---monthly-publication-march-2025.pdf   982 2025-03 Car Land Rover Range Rover Grey Driving without Due Care and Attention None Rampart Way Telford Rampart Way Telford Out of Force Area Out of Force Area Warning Letter N/A Yes - Via Email    
17358 op-snap---monthly-publication-march-2025.pdf   1115 2025-03 Car BMW 530e Black Contravening a Red Traffic Light None no location provided No Location Provided Out of Force Area Out of Force Area NFA No Independent Evidence Available Yes - Via Email    
17372 op-snap---monthly-publication-march-2025.pdf   1129 2025-03 Car Volvo   Grey Driving without Due Care and Attention None A491 Stourbridge Road Stourbridge Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.501035 -2.107981
17415 op-snap---monthly-publication-march-2025.pdf   1172 2025-03 Car BMW 1 series Grey Driving without Due Care and Attention None M4 motorway M4 motorway Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17490 op-snap---monthly-publication-march-2025.pdf   1247 2025-03 Car Toyota Aygo Red Driving without Due Care and Attention None Bassetts Pole Island (Warwickshire Police) Bassetts Pole Island (Warwickshire Police) Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17576 op-snap---monthly-publication-march-2025.pdf   1333 2025-03 Car Volkswagen Golf Grey Driving without Due Care and Attention None M5 Southbound, nr Jn5 (West Mercia Police) M5 Southbound, nr Jn5 (West Mercia Police) Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17604 op-snap---monthly-publication-march-2025.pdf   1361 2025-03 Car Volkswagen golf Black Driving without Due Care and Attention None M6 J3 NB M6 J3 Northbound Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17607 op-snap---monthly-publication-march-2025.pdf   1364 2025-03 Car Volkswagen Golf Blue Driving without Due Care and Attention None Out of force Out of force Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17615 op-snap---monthly-publication-march-2025.pdf   1372 2025-03 Car Volvo XC90 Black Driving without Due Care and Attention None M1 J15 M1 J15 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17646 op-snap---monthly-publication-march-2025.pdf   1403 2025-03 Car Nissan Qashqai Grey Contravening a Red Traffic Light None Warwick New Road Warwick New Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17659 op-snap---monthly-publication-march-2025.pdf   1416 2025-03 Car Audi TT White Driving without Due Care and Attention None M40 SB M40 Southbound Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17682 op-snap---monthly-publication-march-2025.pdf   1439 2025-03 Car Mercedes-Benz C200 Silver Driving without Due Care and Attention None Nantwich Road, Cheshire Nantwich Road, Cheshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17730 op-snap---monthly-publication-march-2025.pdf   1487 2025-03 Car   BMW   Driving without Due Care and Attention None Melton Mowbray Melton Mowbray Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17739 op-snap---monthly-publication-march-2025.pdf   1496 2025-03 Car Volkswagen Golf Black Driving without Due Care and Attention None Rugby Rugby Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.5458823 -1.7949266
17779 op-snap---monthly-publication-march-2025.pdf   1536 2025-03 Car Fiat PUNTO Grey Using a Mobile Phone Whilst Driving None A435 Alcester Road Alcester Road Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17794 op-snap---monthly-publication-march-2025.pdf   1551 2025-03 Car   Ssangyong Red Contravening a Red Traffic Light None M42 Junction 11 M42 Junction 11 Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17821 op-snap---monthly-publication-march-2025.pdf   1578 2025-03 Car Toyota Prius White Driving without Reasonable Consideration None M42 Jn8-8a M42 Jn8-8a Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17870 op-snap---monthly-publication-march-2025.pdf   1627 2025-03 Car Lexus 250h Grey Driving without Due Care and Attention None Brookhouse Lane Brookhouse Lane Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17874 op-snap---monthly-publication-march-2025.pdf   1631 2025-03 Car   motorbike Black Driving without Due Care and Attention No Insurance Wythall Wythall Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4428011 -2.057048
17900 op-snap---monthly-publication-march-2025.pdf   1657 2025-03 Car Peugeot 2008.. Orange Driving without Due Care and Attention None A460 (Watling Street adjacent to M6 Toll A460 (Watling Street adjacent to M6 Toll Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17934 op-snap---monthly-publication-march-2025.pdf   1691 2025-03 Car BMW 2 Series Blue Driving without Reasonable Consideration None Evesham Evesham Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.3837388 -1.5529669
17939 op-snap---monthly-publication-march-2025.pdf   1696 2025-03 Car Nissan Note Silver Motor vehicle fail to comply with a non endorsable traffic sign - detected by means other than ACD None Albert Street Newcatsle Under Lyme Albert Street Newcatsle Under Lyme Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17947 op-snap---monthly-publication-march-2025.pdf   1704 2025-03 Car Volkswagen Passat Grey Driving without Due Care and Attention None Chertsey, London Chertsey, London Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
17966 op-snap---monthly-publication-march-2025.pdf   1723 2025-03 Car Honda Civic Black Driving without Due Care and Attention None A428 Northampton Northampton Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18021 op-snap---monthly-publication-march-2025.pdf   1778 2025-03 Car Mitsubishi L200 Black Driving without Due Care and Attention None Kemerton Road, near Cheltenham Kemerton Road, near Cheltenham Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18032 op-snap---monthly-publication-march-2025.pdf   1789 2025-03 Car Jaguar iPace Black Driving without Reasonable Consideration None M42 (N/B) Jn9, Warwickshire M42 (Northbound) Jn9, Warwickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18058 op-snap---monthly-publication-march-2025.pdf   1815 2025-03 Car Volkswagen Crafter White Driving without Due Care and Attention None Out of force Out of force Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18069 op-snap---monthly-publication-march-2025.pdf   1826 2025-03 Car Ford Ranger White Drive / stop / cause to remain at rest a motor vehicle drawing a trailer in offside lane of a motorway None M6 motorway near Corley Services M6 motorway near Corley Services Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18070 op-snap---monthly-publication-march-2025.pdf   1827 2025-03 Car Volkswagen Caddy Grey Motor vehicle fail to comply with solid white line road markings None M6 motorway at junction with M42 motorway M6 motorway at junction with M42 motorway Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18088 op-snap---monthly-publication-march-2025.pdf   1845 2025-03 Car Vauxhall Corsa Black Driving a vehicle wholly or partly on a footpath None Broad Street, Bromsgrove Broad Street, Bromsgrove Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18135 op-snap---monthly-publication-march-2025.pdf   1892 2025-03 Car Mercedes-Benz A Brown Contravening a Red Traffic Light None Tollbar end - warwickshire Tollbar end - warwickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18157 op-snap---monthly-publication-march-2025.pdf   1914 2025-03 Car Audi A4 Black Driving without Due Care and Attention None Off force Off force Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18175 op-snap---monthly-publication-march-2025.pdf   1932 2025-03 Car Peugeot 207 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area No Insurance Cranage crescent Cranage crescent Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18183 op-snap---monthly-publication-march-2025.pdf   1940 2025-03 Car Nissan QASHQUI Grey Driving without Reasonable Consideration None B4380 SHREWSBURY B4380 Shrewsbury Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18185 op-snap---monthly-publication-march-2025.pdf   1942 2025-03 Car Ford KUGA Grey Driving without Reasonable Consideration None B4380 SHREWSBURY B4380 Shrewsbury Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18222 op-snap---monthly-publication-march-2025.pdf   1979 2025-03 Car Dacia   Grey Driving without Reasonable Consideration None Tolladine Road Worcester Tolladine Road Worcester Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18225 op-snap---monthly-publication-march-2025.pdf   1982 2025-03 Car Daf HGV White Driving without Reasonable Consideration None A42 Warwickshire Warwickshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email 52.4318492 -1.7319529
18403 op-snap---monthly-publication-march-2025.pdf   2160 2025-03 Car Volvo XC90 Gold Driving without Due Care and Attention None Gibraltar Lane Gibraltar Lane Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18439 op-snap---monthly-publication-march-2025.pdf   2196 2025-03 Car Peugeot 308 White Driving without Due Care and Attention None Out of force Out of force Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18571 op-snap---monthly-publication-march-2025.pdf   2328 2025-03 Car Land Rover Evoque Grey Contravening a Red Traffic Light None Watling Street Telford Watling Street Telford Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    
18631 op-snap---monthly-publication-march-2025.pdf   2388 2025-03 Car Vauxhall Combo Red Driving without Due Care and Attention None A51 Staffordshire Staffordshire Out of Force Area Out of Force Area NFA Out of Force Yes - Via Email    

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