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

96 rows where council_area = "Solihull" 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, nfa_rationale

vehicle_make 23

  • Ford 17
  • Mercedes-Benz 10
  • Volkswagen 10
  • Audi 7
  • BMW 6
  • Toyota 6
  • Vauxhall 6
  • Nissan 5
  • Land Rover 4
  • Peugeot 3
  • Citroen 2
  • Mini 2
  • Renault 2
  • Seat 2
  • Volvo 2
  • Alfa Romeo 1
  • Daf 1
  • Honda 1
  • Hyundai 1
  • Jaguar 1
  • Kia 1
  • Mg 1
  • Skoda 1

month 10

  • 2025-03 19
  • 2025-04 17
  • 2025-05 14
  • 2025-01 12
  • 2025-09 9
  • 2025-02 8
  • 2025-06 6
  • 2025-07 5
  • 2025-08 5
  • 2025-10 1

reporter_transport_mode 5

  • Pedal Bike 51
  • Car 42
  • Horse Rider 1
  • Motorbike 1
  • car 1

disposal 5

  • NFA 31
  • Education 30
  • Warning Letter 25
  • Court 5
  • Fixed Penalty 5

offence 1

  • Driving without Reasonable Consideration · 96 ✖

council_area 1

  • Solihull · 96 ✖
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
22190 op-snap---monthly-publication-october-2025.pdf   140 2025-10 Pedal Bike Mercedes-Benz   White Driving without Reasonable Consideration None Cornets End Lane Cornets End Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4269547 -1.6668911
23884 op-snap---monthly-publication-september-2025.pdf   103 2025-09 Car   Polestar Black Driving without Reasonable Consideration None Bickenhill Lane Bickenhill Lane Solihull Solihull NFA No Offence   52.4490463 -1.7296897
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
24305 op-snap---monthly-publication-september-2025.pdf   524 2025-09 Pedal Bike Volkswagen Polo Black Driving without Reasonable Consideration None School Road School Road Solihull Solihull Education N/A   52.3517888 -1.7783232
24324 op-snap---monthly-publication-september-2025.pdf   543 2025-09 Car Mercedes-Benz GLC 300 Black Driving without Reasonable Consideration No Insurance Solihull bypass Solihull bypass Solihull Solihull Court N/A   52.4207529 -1.7757467
24696 op-snap---monthly-publication-september-2025.pdf   915 2025-09 Pedal Bike Peugeot 208.. Red Driving without Reasonable Consideration None Tanworth Lane Tanworth Lane Solihull Solihull Education N/A   52.4014694 -1.8220541
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
24815 op-snap---monthly-publication-september-2025.pdf   1034 2025-09 Pedal Bike Land Rover Range Rover White Driving without Reasonable Consideration None Cut Throat Lane Cut Throat Lane Solihull Solihull Court N/A      
2327 op-snap---monthly-publication-august-2025.pdf   302 2025-08 Car Audi S3 Grey Driving without Reasonable Consideration None M242 J5 M242 J5 Solihull Solihull Education N/A      
2378 op-snap---monthly-publication-august-2025.pdf   353 2025-08 Car Ford Transit White Driving without Reasonable Consideration None Station Road, Marston Green Station Road, Marston Green Solihull Solihull Education N/A   52.4667342 -1.747421
2984 op-snap---monthly-publication-august-2025.pdf   959 2025-08 Pedal Bike Nissan Juke Blue Driving without Reasonable Consideration None Warwick Road Warwick Road Solihull Solihull Education N/A   52.4428606 -1.812114
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
3142 op-snap---monthly-publication-august-2025.pdf   1117 2025-08 Pedal Bike Vauxhall Vivaro Grey Driving without Reasonable Consideration None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
12370 op-snap---monthly-publication-july-2025.pdf   422 2025-07 Pedal Bike Ford Fiesta Blue Driving without Reasonable Consideration None Friday Lane Friday Lane Solihull Solihull Education N/A   52.4142542 -1.7217662
12500 op-snap---monthly-publication-july-2025.pdf   552 2025-07 Car Toyota Yaris Silver Driving without Reasonable Consideration None Ulverley Green Road, Olton Ulverley Green Road, Olton Solihull Solihull NFA No VRM   52.4374545 -1.803861
12573 op-snap---monthly-publication-july-2025.pdf   625 2025-07 Car Mg 3 series Silver Driving without Reasonable Consideration None Bickenhill Interchange Bickenhill Interchange Solihull Solihull Fixed Penalty N/A   52.4457674 -1.7082354
12802 op-snap---monthly-publication-july-2025.pdf   854 2025-07 Car Toyota Prius Silver Driving without Reasonable Consideration None Lobe Lane Lobe Lane Solihull Solihull NFA No Offence      
12804 op-snap---monthly-publication-july-2025.pdf   856 2025-07 Car Toyota Prius Silver Driving without Reasonable Consideration None Lode Lane Lode Lane Solihull Solihull NFA No Offence   52.4149064 -1.7832364
14084 op-snap---monthly-publication-june-2025.pdf   13 2025-06 Pedal Bike Audi Q5 Silver Driving without Reasonable Consideration None GRANGE ROAD Grange Road Solihull Solihull NFA No Independent Evidence Available   52.4285724 -1.8019101
14246 op-snap---monthly-publication-june-2025.pdf   175 2025-06 Car Daf HGV Yellow Driving without Reasonable Consideration None M42 M42 Solihull Solihull NFA No Independent Evidence Available      
14362 op-snap---monthly-publication-june-2025.pdf   291 2025-06 Car Mini Cooper Red Driving without Reasonable Consideration None Stratford Road Stratford Road Solihull Solihull Fixed Penalty N/A   52.4191184 -1.8326637
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      
15054 op-snap---monthly-publication-june-2025.pdf   983 2025-06 Pedal Bike Peugeot Partner White Driving without Reasonable Consideration Littering Stratford Road Stratford Road Solihull Solihull Education N/A   52.4191184 -1.8326637
15590 op-snap---monthly-publication-june-2025.pdf   1519 2025-06 Pedal Bike Volvo Coach Grey Driving without Reasonable Consideration None Damson Parkway Damson Parkway Solihull Solihull Education N/A   52.437016 -1.7578446
18693 op-snap---monthly-publication-may-2025.pdf   55 2025-05 Motorbike Toyota Pirus White Driving without Reasonable Consideration None M40 J15-J16 M40 J15-J16 Solihull Solihull NFA Outside of 14 Days NIP      
18700 op-snap---monthly-publication-may-2025.pdf   62 2025-05 Car BMW 318I Black Driving without Reasonable Consideration None Creynolds Lane Creynolds Lane Solihull Solihull NFA Outside of 14 Days NIP   52.3779859 -1.8107431
18760 op-snap---monthly-publication-may-2025.pdf   122 2025-05 Pedal Bike Renault TRAFIC White Driving without Reasonable Consideration None RICHMOND ROAD Richmond Road Solihull Solihull Education N/A   52.4430188 -1.8022218
18885 op-snap---monthly-publication-may-2025.pdf   247 2025-05 Pedal Bike Land Rover Sport Grey Driving without Reasonable Consideration None Lady Byron Lane Lady Byron Lane Solihull Solihull Warning Letter N/A   52.4026126 -1.7503668
18922 op-snap---monthly-publication-may-2025.pdf   284 2025-05 Pedal Bike Mercedes-Benz C220 Black Driving without Reasonable Consideration None Hampton Lane Hampton Lane Solihull Solihull Education N/A   52.4190728 -1.7449943
18954 op-snap---monthly-publication-may-2025.pdf   316 2025-05 Car Ford Ranger Black Driving without Reasonable Consideration None A4141 A4141 Solihull Solihull Warning Letter N/A      
19015 op-snap---monthly-publication-may-2025.pdf   377 2025-05 car Ford Focus Blue Driving without Reasonable Consideration None St. Bernards Road Street. Bernards Road Solihull Solihull Education N/A      
19123 op-snap---monthly-publication-may-2025.pdf   485 2025-05 Pedal Bike Toyota CHR Black Driving without Reasonable Consideration None Dickens Heath Road Dickens Heath Road Solihull Solihull NFA No Offence   52.3875525 -1.8339426
19166 op-snap---monthly-publication-may-2025.pdf   528 2025-05 Pedal Bike Hyundai Tucson Grey Driving without Reasonable Consideration None Balsall Street Balsall Street Solihull Solihull NFA Outside of 14 Days NIP   52.3826029 -1.6998649
19169 op-snap---monthly-publication-may-2025.pdf   531 2025-05 Pedal Bike Ford Fiesta Black Driving without Reasonable Consideration None Station Road Station Road Solihull Solihull NFA Outside of 14 Days NIP   52.3927253 -1.6455823
19181 op-snap---monthly-publication-may-2025.pdf   543 2025-05 Pedal Bike Peugeot 306 Black Driving without Reasonable Consideration None Tanners Lane Tanners Lane Solihull Solihull NFA Outside of 14 Days NIP   52.3999016 -1.6082403
19183 op-snap---monthly-publication-may-2025.pdf   545 2025-05 Pedal Bike Ford pUMA Black Driving without Reasonable Consideration None Tile Hill Lane Tile Hill Lane Solihull Solihull NFA Outside of 14 Days NIP      
19326 op-snap---monthly-publication-may-2025.pdf   688 2025-05 Pedal Bike Mercedes-Benz GLE Grey Driving without Reasonable Consideration None Hampton Road Hampton Road Solihull Solihull Education N/A   52.3985342 -1.7240581
19582 op-snap---monthly-publication-may-2025.pdf   944 2025-05 Car Ford Transit White Driving without Reasonable Consideration None Solihull Lane Solihull Lane Solihull Solihull Warning Letter N/A   52.4548328 -1.7947304
317 op-snap---monthly-publication-april-2025.pdf   316 2025-04 Pedal Bike Nissan van Blue Driving without Reasonable Consideration None School Road School Road Solihull Solihull NFA Outside of 14 Days NIP   52.3517888 -1.7783232
410 op-snap---monthly-publication-april-2025.pdf   409 2025-04 Pedal Bike Mercedes-Benz HGV White Driving without Reasonable Consideration None Cleobury Rd Cleobury Road Solihull Solihull NFA Outside of 14 Days NIP      
562 op-snap---monthly-publication-april-2025.pdf   561 2025-04 Car Mercedes-Benz A Class Red Driving without Reasonable Consideration None M42 M42 Solihull Solihull NFA Outside of 14 Days NIP      
576 op-snap---monthly-publication-april-2025.pdf   575 2025-04 Pedal Bike Land Rover Discovery Grey Driving without Reasonable Consideration None Hazeloak Road Hazeloak Road Solihull Solihull Education N/A   52.4050414 -1.8334531
649 op-snap---monthly-publication-april-2025.pdf   648 2025-04 Pedal Bike Mini Cooper Blue Driving without Reasonable Consideration None Dickens Heath Road Dickens Heath Road Solihull Solihull NFA Outside of 14 Days NIP   52.3875525 -1.8339426
650 op-snap---monthly-publication-april-2025.pdf   649 2025-04 Pedal Bike Renault Clio Red Driving without Reasonable Consideration None Dickens Heath Road Dickens Heath Road Solihull Solihull NFA Outside of 14 Days NIP   52.3875525 -1.8339426
706 op-snap---monthly-publication-april-2025.pdf   705 2025-04 Pedal Bike   Saab 93 Black Driving without Reasonable Consideration None Tile House Green Lane Tile House Green Lane Solihull Solihull Education N/A      
709 op-snap---monthly-publication-april-2025.pdf   708 2025-04 Pedal Bike Ford Transit Blue Driving without Reasonable Consideration None Damson Parkway Damson Parkway Solihull Solihull NFA Outside of 14 Days NIP   52.437016 -1.7578446
947 op-snap---monthly-publication-april-2025.pdf   946 2025-04 Pedal Bike Volkswagen   Blue Driving without Reasonable Consideration None Lugtrout Lane , Solihull Lugtrout Lane , Solihull Solihull Solihull NFA Outside of 14 Days NIP   52.4227108 -1.7443257
993 op-snap---monthly-publication-april-2025.pdf   992 2025-04 Car Audi   Black Driving without Reasonable Consideration None Gate Lane , Dorridge Gate Lane , Dorridge Solihull Solihull NFA Outside of 14 Days NIP   52.3752022 -1.777982
1024 op-snap---monthly-publication-april-2025.pdf   1023 2025-04 Car Volvo Hybird Silver Driving without Reasonable Consideration None Haslucks Green , Solihull Haslucks Green , Solihull Solihull Solihull NFA Outside of 14 Days NIP   52.4052726 -1.8486698
1028 op-snap---monthly-publication-april-2025.pdf   1027 2025-04 Car   Motorbike   Driving without Reasonable Consideration None Olton Road , Solihull Olton Road , Solihull Solihull Solihull NFA Outside of 14 Days NIP   52.4158752 -1.8289351
1353 op-snap---monthly-publication-april-2025.pdf   1352 2025-04 Pedal Bike Volkswagen   Silver Driving without Reasonable Consideration None Oak Tree Lane , Selly Oak Oak Tree Lane , Selly Oak Solihull Solihull NFA Outside of 14 Days NIP      
1561 op-snap---monthly-publication-april-2025.pdf   1560 2025-04 Car Volkswagen NP Silver Driving without Reasonable Consideration None Broad Lane ,Sollihull Broad Lane , Sollihull Solihull Solihull NFA Outside of 14 Days NIP      
1764 op-snap---monthly-publication-april-2025.pdf   1763 2025-04 Pedal Bike Mercedes-Benz Estate Silver Driving without Reasonable Consideration None Kelsey Lane , Solihull Kelsey Lane , Solihull Solihull Solihull NFA Outside of 14 Days NIP   52.3845059 -1.6371483
1821 op-snap---monthly-publication-april-2025.pdf   1820 2025-04 Car Volkswagen Golf White Driving without Reasonable Consideration None Station Road , Dorridge Station Road , Dorridge Solihull Solihull NFA Outside of 14 Days NIP   52.3730675 -1.7534343
1843 op-snap---monthly-publication-april-2025.pdf   1842 2025-04 Car Ford Focus White Driving without Reasonable Consideration None Gospel Lane , Solihull Gospel Lane , Solihull Solihull Solihull NFA Outside of 14 Days NIP   52.4318012 -1.8179833
16357 op-snap---monthly-publication-march-2025.pdf   114 2025-03 Pedal Bike Ford Transit Black Driving without Reasonable Consideration None Barston Lane Barston Lane Solihull Solihull Education N/A Yes - Via Email 52.4022999 -1.685635
16509 op-snap---monthly-publication-march-2025.pdf   266 2025-03 Car Vauxhall Insignia Grey Driving without Reasonable Consideration None North Island North Island Solihull Solihull Warning Letter N/A Yes - Via Email    
16637 op-snap---monthly-publication-march-2025.pdf   394 2025-03 Pedal Bike Mercedes-Benz GLA 220 White Driving without Reasonable Consideration None Dickens Heath Road Dickens Heath Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3875525 -1.8339426
16853 op-snap---monthly-publication-march-2025.pdf   610 2025-03 Pedal Bike   Smart Fourtwo Black Driving without Reasonable Consideration None Damson Parkway Damson Parkway Solihull Solihull Education N/A Yes - Via Email 52.437016 -1.7578446
16856 op-snap---monthly-publication-march-2025.pdf   613 2025-03 Pedal Bike Land Rover Sport Grey Driving without Reasonable Consideration None Damson Parkway Damson Parkway Solihull Solihull Education N/A Yes - Via Email 52.437016 -1.7578446
16858 op-snap---monthly-publication-march-2025.pdf   615 2025-03 Pedal Bike Toyota Corolla White Driving without Reasonable Consideration None Damson Parkway Damson Parkway Solihull Solihull Education N/A Yes - Via Email 52.437016 -1.7578446
16888 op-snap---monthly-publication-march-2025.pdf   645 2025-03 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Friday Lane Friday Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.4142542 -1.7217662
17049 op-snap---monthly-publication-march-2025.pdf   806 2025-03 Pedal Bike Audi A3 Black Driving without Reasonable Consideration None Tixall Road Tixall Road Solihull Solihull Education N/A Yes - Via Email    
17132 op-snap---monthly-publication-march-2025.pdf   889 2025-03 Car Kia Sportage Grey Driving without Reasonable Consideration None Chester Road Chester Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.5021946 -1.7719526
17392 op-snap---monthly-publication-march-2025.pdf   1149 2025-03 Car Ford Kuga Blue Driving without Reasonable Consideration None Monkspath Hall Road Monkspath Hall Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3900358 -1.8026595
17504 op-snap---monthly-publication-march-2025.pdf   1261 2025-03 Pedal Bike Ford Ranger Black Driving without Reasonable Consideration None Warwick Road Warwick Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.4428606 -1.812114
17544 op-snap---monthly-publication-march-2025.pdf   1301 2025-03 Car Nissan Note Black Driving without Reasonable Consideration None Kenilworth Road Kenilworth Road Solihull Solihull Education N/A Yes - Via Email 52.4322443 -1.6746508
17571 op-snap---monthly-publication-march-2025.pdf   1328 2025-03 Pedal Bike BMW X4 Black Driving without Reasonable Consideration None STATION ROAD Station Road Solihull Solihull Education N/A Yes - Via Email 52.3927253 -1.6455823
17672 op-snap---monthly-publication-march-2025.pdf   1429 2025-03 Car Mercedes-Benz GLB220 White Driving without Reasonable Consideration None Windward Way Windward Way Solihull Solihull NFA No Offence Yes - Via Email 52.5023715 -1.7555515
17769 op-snap---monthly-publication-march-2025.pdf   1526 2025-03 Car Audi A3 Grey Driving without Reasonable Consideration None Tanworth Lane B4102 Tanworth Lane B4102 Solihull Solihull Education N/A Yes - Via Email 52.4014694 -1.8220541
18284 op-snap---monthly-publication-march-2025.pdf   2041 2025-03 Car Mercedes-Benz C250 Black Driving without Reasonable Consideration None Dog Kennel Lane Dog Kennel Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.3916957 -1.8169275
18316 op-snap---monthly-publication-march-2025.pdf   2073 2025-03 Pedal Bike Nissan Note White Driving without Reasonable Consideration None Tanworth Lane Tanworth Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.4014694 -1.8220541
18375 op-snap---monthly-publication-march-2025.pdf   2132 2025-03 Car Vauxhall Astra Black Driving without Reasonable Consideration None Lode Lane Lode Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.4149064 -1.7832364
18507 op-snap---monthly-publication-march-2025.pdf   2264 2025-03 Car Alfa Romeo Polestar Blue Driving without Reasonable Consideration None Monkspath Isalnd Monkspath Isalnd Solihull Solihull NFA No Offence Yes - Via Email    
5295 op-snap---monthly-publication-february-2025.pdf   112 2025-02 Pedal Bike Audi A1 Black Driving without Reasonable Consideration None Spring Lane Spring Lane Solihull Solihull Warning Letter N/A Yes - Via Email 52.3492615 -1.7783838
5690 op-snap---monthly-publication-february-2025.pdf   507 2025-02 Pedal Bike Vauxhall Astra Red Driving without Reasonable Consideration None Box Tree Road, Solihul Box Tree Road, Solihul Solihull Solihull Fixed Penalty N/A Yes - Via Email    
6108 op-snap---monthly-publication-february-2025.pdf   925 2025-02 Pedal Bike BMW X5 Green Driving without Reasonable Consideration None Hampton Road Hampton Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3985342 -1.7240581
6325 op-snap---monthly-publication-february-2025.pdf   1142 2025-02 Pedal Bike Ford Transit Blue Driving without Reasonable Consideration None Braggs Farm Lane, Earlswood Braggs Farm Lane, Earlswood Solihull Solihull Fixed Penalty N/A Yes - Via Email    
6602 op-snap---monthly-publication-february-2025.pdf   1419 2025-02 Pedal Bike Ford Transit Grey Driving without Reasonable Consideration None Kineton Lane Kineton Lane Solihull Solihull Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.3661553 -1.7890942
6679 op-snap---monthly-publication-february-2025.pdf   1496 2025-02 Pedal Bike Volkswagen Tiguan Black Driving without Reasonable Consideration None Sampson Road Sampson Road Solihull Solihull Education N/A Yes - Via Email    
6785 op-snap---monthly-publication-february-2025.pdf   1602 2025-02 Pedal Bike Citroen C4 White Driving without Reasonable Consideration None Tile House Lane Tile House Lane Solihull Solihull Education N/A Yes - Via Email    
7184 op-snap---monthly-publication-february-2025.pdf   2001 2025-02 Pedal Bike Vauxhall Astra White Driving without Reasonable Consideration None Stretton Road Stretton Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3968954 -1.8276508
9327 op-snap---monthly-publication-january-2025.pdf   435 2025-01 Car Citroen Berlingo Black Driving without Reasonable Consideration None M42, J4 Island M42, J4 Island Solihull Solihull Warning Letter N/A Yes - Via Email    
9339 op-snap---monthly-publication-january-2025.pdf   447 2025-01 Car BMW I4 M50 Black Driving without Reasonable Consideration None Stratford Road Stratford Road Solihull Solihull Education N/A Yes - Via Email 52.4191184 -1.8326637
9653 op-snap---monthly-publication-january-2025.pdf   761 2025-01 Horse Rider Audi A3 Grey Driving without Reasonable Consideration None Manor Road Manor Road Solihull Solihull Education N/A Yes - Via Email 52.4193737 -1.7798629
9817 op-snap---monthly-publication-january-2025.pdf   925 2025-01 Pedal Bike Volkswagen Caddy Silver Driving without Reasonable Consideration None Kineton Road Kineton Road Solihull Solihull Education N/A Yes - Via Email 52.4332233 -1.812229
10131 op-snap---monthly-publication-january-2025.pdf   1239 2025-01 Pedal Bike BMW 3 series White Driving without Reasonable Consideration None Warwick Road Warwick Road Solihull Solihull Education N/A Yes - Via Email 52.4428606 -1.812114
10163 op-snap---monthly-publication-january-2025.pdf   1271 2025-01 Car Volkswagen Golf Blue Driving without Reasonable Consideration None Bickenhill Parkway Bickenhill Parkway Solihull Solihull Warning Letter N/A Yes - Via Email 52.4613776 -1.7252972
10272 op-snap---monthly-publication-january-2025.pdf   1380 2025-01 Car Jaguar XJR Silver Driving without Reasonable Consideration None Kenilworth Road, Knowle Kenilworth Road, Knowle Solihull Solihull Fixed Penalty N/A Yes - Via Email 52.3823459 -1.7067353
10296 op-snap---monthly-publication-january-2025.pdf   1404 2025-01 Car Nissan Juke Blue Driving without Reasonable Consideration None Highlands Rd Highlands Road Solihull Solihull Warning Letter N/A Yes - Via Email 52.3909869 -1.8032499
10379 op-snap---monthly-publication-january-2025.pdf   1487 2025-01 Car Seat Ibiza Grey Driving without Reasonable Consideration VRM fails to conform to Regulations Widney Lane Widney Lane Solihull Solihull Court N/A Yes - Via Email 52.3975737 -1.7857722
10380 op-snap---monthly-publication-january-2025.pdf   1488 2025-01 Car Seat Leon Black Driving without Reasonable Consideration None Widney Lane Widney Lane Solihull Solihull Court N/A Yes - Via Email 52.3975737 -1.7857722
10381 op-snap---monthly-publication-january-2025.pdf   1489 2025-01 Car Skoda Fabia Grey Driving without Reasonable Consideration VRM fails to conform to Regulations Widney Lane Widney Lane Solihull Solihull Court N/A Yes - Via Email 52.3975737 -1.7857722
10480 op-snap---monthly-publication-january-2025.pdf   1588 2025-01 Pedal Bike Volkswagen Golf Grey Driving without Reasonable Consideration None Highfield Road Highfield Road Solihull Solihull Education N/A Yes - Via Email 52.4200729 -1.8326703

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