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

106 rows where council_area = "Solihull", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedal Bike" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, nfa_rationale

disposal 5

reporter_transport_mode 1

  • Pedal Bike · 106 ✖

offence 1

  • Driving without Due Care and Attention · 106 ✖

council_area 1

  • Solihull · 106 ✖
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
7701 op-snap---monthly-publication-february-2026.pdf   448 2026-02 Pedal Bike Skoda Fabia Grey Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull Warning Letter N/A   52.4190728 -1.7449943
7783 op-snap---monthly-publication-february-2026.pdf   530 2026-02 Pedal Bike Mercedes-Benz 180 White Driving without Due Care and Attention None Cornetts End Lane Cornetts End Lane Solihull Solihull Education N/A      
7785 op-snap---monthly-publication-february-2026.pdf   532 2026-02 Pedal Bike Vauxhall Astra Silver Driving without Due Care and Attention None High Street, Hampton in Arden High Street, Hampton in Arden Solihull Solihull NFA No Offence   52.4291828 -1.7000245
7933 op-snap---monthly-publication-february-2026.pdf   680 2026-02 Pedal Bike Porsche Cayenne Grey Driving without Due Care and Attention None Streetbrook Road Solihull Streetbrook Road Solihull Solihull Solihull Education N/A      
8025 op-snap---monthly-publication-february-2026.pdf   772 2026-02 Pedal Bike Audi Q2 White Driving without Due Care and Attention None High Street High Street Solihull Solihull Education N/A   52.4064169 -1.8557215
8042 op-snap---monthly-publication-february-2026.pdf   789 2026-02 Pedal Bike Tesla Model S White Driving without Due Care and Attention None Shutt Lane Shutt Lane Solihull Solihull Education N/A   52.367795 -1.8250635
8047 op-snap---monthly-publication-february-2026.pdf   794 2026-02 Pedal Bike Ford Puma Red Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull Education N/A   52.4190728 -1.7449943
8318 op-snap---monthly-publication-february-2026.pdf   1065 2026-02 Pedal Bike Fiat 500 White Driving without Due Care and Attention None Meriden Road Meriden Road Solihull Solihull NFA No Offence   52.4137518 -1.6414448
8350 op-snap---monthly-publication-february-2026.pdf   1097 2026-02 Pedal Bike Vauxhall Astra Grey Driving without Due Care and Attention None Cornets End Lane Cornets End Lane Solihull Solihull Warning Letter N/A   52.4269547 -1.6668911
8383 op-snap---monthly-publication-february-2026.pdf   1130 2026-02 Pedal Bike Volkswagen Beetle Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull NFA No Offence   52.4223176 -1.8253145
8521 op-snap---monthly-publication-february-2026.pdf   1268 2026-02 Pedal Bike Mercedes-Benz Smart Fortwo Blue Driving without Due Care and Attention None Streetbrook Road Streetbrook Road Solihull Solihull NFA Outside of 14 Days NIP      
8558 op-snap---monthly-publication-february-2026.pdf   1305 2026-02 Pedal Bike Ford Cmax Blue Driving without Due Care and Attention None Cranmore Bvd Cranmore Bvd Solihull Solihull Court N/A   52.3947549 -1.8141729
8769 op-snap---monthly-publication-february-2026.pdf   1516 2026-02 Pedal Bike Nissan Qashqai Blue Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull Warning Letter N/A   52.4190728 -1.7449943
8772 op-snap---monthly-publication-february-2026.pdf   1519 2026-02 Pedal Bike Fiat 500.. Black Driving without Due Care and Attention None Solihull Road Solihull Road Solihull Solihull Warning Letter N/A   52.4114159 -1.8197732
10762 op-snap---monthly-publication-january-2026.pdf   223 2026-01 Pedal Bike Ford Transit White Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10977 op-snap---monthly-publication-january-2026.pdf   438 2026-01 Pedal Bike BMW 330 E Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10979 op-snap---monthly-publication-january-2026.pdf   440 2026-01 Pedal Bike Citroen DS3 White Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
11285 op-snap---monthly-publication-january-2026.pdf   746 2026-01 Pedal Bike Volvo V40.. Grey Driving without Due Care and Attention None Cranmore Boulevard Cranmore Boulevard Solihull Solihull Education N/A   52.3947549 -1.8141729
11605 op-snap---monthly-publication-january-2026.pdf   1066 2026-01 Pedal Bike Skoda Superb Black Driving without Due Care and Attention None Kineton Green Road Kineton Green Road Solihull Solihull Education N/A   52.4332233 -1.812229
11636 op-snap---monthly-publication-january-2026.pdf   1097 2026-01 Pedal Bike Mercedes-Benz Tourismo Blue Driving without Due Care and Attention None Warwick Road at Ashleigh Road Warwick Road at Ashleigh Road Solihull Solihull Warning Letter N/A   52.4385199 -1.8069384
11924 op-snap---monthly-publication-january-2026.pdf   1385 2026-01 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None B4102 Solihull Road Solihull Road Solihull Solihull Education N/A   52.4114159 -1.8197732
4138 op-snap---monthly-publication-december-2025.pdf   266 2025-12 Pedal Bike Mitsubishi Outlander Red Driving without Due Care and Attention None Monkspath Hall Rd Monkspath Hall Road Solihull Solihull Fixed Penalty N/A   52.3900358 -1.8026595
4328 op-snap---monthly-publication-december-2025.pdf   456 2025-12 Pedal Bike Iveco Daily White Driving without Due Care and Attention None Lady Byron Lane Lady Byron Lane Solihull Solihull Warning Letter N/A   52.4026126 -1.7503668
4388 op-snap---monthly-publication-december-2025.pdf   516 2025-12 Pedal Bike Nissan Juke Black Driving without Due Care and Attention None Corners End Lane Corners End Lane Solihull Solihull NFA No Offence      
4533 op-snap---monthly-publication-december-2025.pdf   661 2025-12 Pedal Bike Toyota Yaris Grey Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull NFA No Offence   52.4190728 -1.7449943
4584 op-snap---monthly-publication-december-2025.pdf   712 2025-12 Pedal Bike Seat Arona Black Driving without Due Care and Attention None Broad Lane, Balsall Common Broad Lane, Balsall Common Solihull Solihull Education N/A      
4690 op-snap---monthly-publication-december-2025.pdf   818 2025-12 Pedal Bike Jaguar Epace Grey Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Court N/A   52.4092804 -1.8056214
4715 op-snap---monthly-publication-december-2025.pdf   843 2025-12 Pedal Bike Toyota Auris Brown Driving without Due Care and Attention None Ralph Road, Shirley, Solihull Ralph Road, Shirley, Solihull Solihull Solihull Education N/A   52.4156768 -1.8193235
4816 op-snap---monthly-publication-december-2025.pdf   944 2025-12 Pedal Bike BMW IX Grey Driving without Due Care and Attention None Whitefields Road Whitefields Road Solihull Solihull Education N/A   52.4060267 -1.7849657
20610 op-snap---monthly-publication-november-2025.pdf   152 2025-11 Pedal Bike Land Rover Discovery Grey Driving without Due Care and Attention None St Bernards Road Street Bernards Road Solihull Solihull Education N/A      
20621 op-snap---monthly-publication-november-2025.pdf   163 2025-11 Pedal Bike Kia Picanto Silver Driving without Due Care and Attention None Widney Manor Road Widney Manor Road Solihull Solihull Education N/A   52.3902967 -1.7659209
20722 op-snap---monthly-publication-november-2025.pdf   264 2025-11 Pedal Bike Mg HS Red Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Solihull Solihull NFA No Independent Evidence Available   52.4322443 -1.6746508
20765 op-snap---monthly-publication-november-2025.pdf   307 2025-11 Pedal Bike Peugeot 3008 GT Brown Driving without Due Care and Attention None Widney Road Widney Road Solihull Solihull Warning Letter N/A   52.3795667 -1.7478958
20860 op-snap---monthly-publication-november-2025.pdf   402 2025-11 Pedal Bike Ford Transit White Driving without Due Care and Attention None Coleshill Heath Road Coleshill Heath Road Solihull Solihull Education N/A   52.4667242 -1.7283592
21488 op-snap---monthly-publication-november-2025.pdf   1030 2025-11 Pedal Bike Land Rover Discovery Silver Driving without Due Care and Attention None Ballsall St Ballsall Street Solihull Solihull Warning Letter N/A      
21903 op-snap---monthly-publication-november-2025.pdf   1445 2025-11 Pedal Bike Skoda Octavia Red Driving without Due Care and Attention None Straoud Road Straoud Road Solihull Solihull Warning Letter N/A      
22156 op-snap---monthly-publication-october-2025.pdf   106 2025-10 Pedal Bike Land Rover Sport Black Driving without Due Care and Attention None Streetsbrook Road, Shirley Streetsbrook Road, Shirley Solihull Solihull Court N/A   52.4223176 -1.8253145
22195 op-snap---monthly-publication-october-2025.pdf   145 2025-10 Pedal Bike Dennis Alexander White Driving without Due Care and Attention None Sharmans Cross Sharmans Cross Solihull Solihull NFA Outside of 14 Days NIP   52.4151594 -1.8062462
22196 op-snap---monthly-publication-october-2025.pdf   146 2025-10 Pedal Bike Renault Modus Silver Driving without Due Care and Attention None Stroud Road Stroud Road Solihull Solihull NFA Outside of 14 Days NIP   52.4085712 -1.8432138
22286 op-snap---monthly-publication-october-2025.pdf   236 2025-10 Pedal Bike Nissan Qashqai Silver Driving without Due Care and Attention None Friday Lane Friday Lane Solihull Solihull Education N/A   52.4142542 -1.7217662
22336 op-snap---monthly-publication-october-2025.pdf   286 2025-10 Pedal Bike   Bus White Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Solihull Solihull NFA No Offence   52.4144779 -1.7848758
22430 op-snap---monthly-publication-october-2025.pdf   380 2025-10 Pedal Bike Audi Q2 Grey Driving without Due Care and Attention None Wychwood Avenue Wychwood Avenue Solihull Solihull NFA No Independent Evidence Available   52.3973125 -1.7370127
22431 op-snap---monthly-publication-october-2025.pdf   381 2025-10 Pedal Bike Citroen Berlingo White Driving without Due Care and Attention None Balsall Street Balsall Street Solihull Solihull Education N/A   52.3826029 -1.6998649
22595 op-snap---monthly-publication-october-2025.pdf   545 2025-10 Pedal Bike Audi Q3 Silver Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Education N/A   52.4149064 -1.7832364
22598 op-snap---monthly-publication-october-2025.pdf   548 2025-10 Pedal Bike Volkswagen Fox Black Driving without Due Care and Attention None Friday Lane Friday Lane Solihull Solihull Education N/A   52.4142542 -1.7217662
22781 op-snap---monthly-publication-october-2025.pdf   731 2025-10 Pedal Bike BMW 218I Grey Driving without Due Care and Attention None Highlands Road Highlands Road Solihull Solihull Education N/A   52.3909869 -1.8032499
22867 op-snap---monthly-publication-october-2025.pdf   817 2025-10 Pedal Bike Mini Mini Silver Driving without Due Care and Attention None A3400 Stratford Road Stratford Road Solihull Solihull Education N/A   52.4191184 -1.8326637
22922 op-snap---monthly-publication-october-2025.pdf   872 2025-10 Pedal Bike Ford Focus Grey Driving without Due Care and Attention None School Road School Road Solihull Solihull Warning Letter N/A   52.3517888 -1.7783232
23030 op-snap---monthly-publication-october-2025.pdf   980 2025-10 Pedal Bike Porsche Macan Grey Driving without Due Care and Attention None Fridal lane Fridal lane Solihull Solihull NFA No Offence      
23064 op-snap---monthly-publication-october-2025.pdf   1014 2025-10 Pedal Bike Hyundai Tucson Black Driving without Due Care and Attention None Rumbush Lane Rumbush Lane Solihull Solihull Education N/A   52.3807937 -1.8418159
24020 op-snap---monthly-publication-september-2025.pdf   239 2025-09 Pedal Bike Honda Civic Black Driving without Due Care and Attention None Sampson Road Sampson Road Solihull Solihull NFA No Offence      
24105 op-snap---monthly-publication-september-2025.pdf   324 2025-09 Pedal Bike Renault Traffic Black Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Solihull Solihull Education N/A   52.4322443 -1.6746508
24357 op-snap---monthly-publication-september-2025.pdf   576 2025-09 Pedal Bike Ford Fiesta Black Driving without Due Care and Attention None Hob Lane Hob Lane Solihull Solihull Education N/A   52.377539 -1.6201491
24686 op-snap---monthly-publication-september-2025.pdf   905 2025-09 Pedal Bike Audi A1 Green Driving without Due Care and Attention None Marshall Lake Road Marshall Lake Road Solihull Solihull Warning Letter N/A   52.3975426 -1.818252
2284 op-snap---monthly-publication-august-2025.pdf   259 2025-08 Pedal Bike Ford B Max Blue Driving without Due Care and Attention None Station Road Station Road Solihull Solihull Education N/A   52.3927253 -1.6455823
2590 op-snap---monthly-publication-august-2025.pdf   565 2025-08 Pedal Bike Volkswagen Polo Blue Driving without Due Care and Attention None Green Lane Green Lane Solihull Solihull Education N/A   52.5069826 -1.7643766
2641 op-snap---monthly-publication-august-2025.pdf   616 2025-08 Pedal Bike Porsche Cayenne Blue Driving without Due Care and Attention None Kineton Lane Kineton Lane Solihull Solihull Warning Letter N/A   52.3661553 -1.7890942
2648 op-snap---monthly-publication-august-2025.pdf   623 2025-08 Pedal Bike BMW X1 Grey Driving without Due Care and Attention None Manor Road Manor Road Solihull Solihull Warning Letter N/A   52.4193737 -1.7798629
2824 op-snap---monthly-publication-august-2025.pdf   799 2025-08 Pedal Bike Mini Cooper Black Driving without Due Care and Attention None Dovehouse Lane Dovehouse Lane Solihull Solihull Education N/A   52.4319915 -1.7915192
2825 op-snap---monthly-publication-august-2025.pdf   800 2025-08 Pedal Bike Mitsubishi Shogun Black Driving without Due Care and Attention None Dovehouse Lane Dovehouse Lane Solihull Solihull Education N/A   52.4319915 -1.7915192
3147 op-snap---monthly-publication-august-2025.pdf   1122 2025-08 Pedal Bike Audi A4 Blue Driving without Due Care and Attention None Buryfield Road Buryfield Road Solihull Solihull Education N/A   52.4244296 -1.7823135
12010 op-snap---monthly-publication-july-2025.pdf   62 2025-07 Pedal Bike Volvo V40 Blue Driving without Due Care and Attention None Meer End Road Meer End Road Solihull Solihull Education N/A   52.373396 -1.6335409
12038 op-snap---monthly-publication-july-2025.pdf   90 2025-07 Pedal Bike Ford Transit White Driving without Due Care and Attention None Olton Road Olton Road Solihull Solihull NFA Outside of 14 Days NIP   52.4193964 -1.8252207
12040 op-snap---monthly-publication-july-2025.pdf   92 2025-07 Pedal Bike BMW 520.. Black Driving without Due Care and Attention None St Bernards Road Street Bernards Road Solihull Solihull NFA Outside of 14 Days NIP      
12067 op-snap---monthly-publication-july-2025.pdf   119 2025-07 Pedal Bike Toyota Aygo Silver Driving without Due Care and Attention None Bickenhill Road Bickenhill Road Solihull Solihull Court N/A   52.4640893 -1.7362681
12121 op-snap---monthly-publication-july-2025.pdf   173 2025-07 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Dorchester Road Dorchester Road Solihull Solihull Court N/A   52.4157911 -1.7926505
12174 op-snap---monthly-publication-july-2025.pdf   226 2025-07 Pedal Bike Ford B-Max Blue Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
12227 op-snap---monthly-publication-july-2025.pdf   279 2025-07 Pedal Bike Chevrolet Chrysler Black Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Education N/A   52.4092804 -1.8056214
12241 op-snap---monthly-publication-july-2025.pdf   293 2025-07 Pedal Bike Vauxhall Meriva White Driving without Due Care and Attention None Linden Road Linden Road Solihull Solihull NFA Outside of 14 Days NIP      
12462 op-snap---monthly-publication-july-2025.pdf   514 2025-07 Pedal Bike Audi Q3 White Driving without Due Care and Attention None Kenilworth Road Knowle Kenilworth Road Knowle Solihull Solihull Education N/A   52.3877147 -1.732243
12703 op-snap---monthly-publication-july-2025.pdf   755 2025-07 Pedal Bike Fiat 500 Blue Driving without Due Care and Attention None Olton Road Olton Road Solihull Solihull Education N/A   52.4193964 -1.8252207
12719 op-snap---monthly-publication-july-2025.pdf   771 2025-07 Pedal Bike BMW   Black Driving without Due Care and Attention None Packwood Road Packwood Road Solihull Solihull NFA No Offence   52.3617789 -1.7409895
12766 op-snap---monthly-publication-july-2025.pdf   818 2025-07 Pedal Bike Mercedes-Benz CLA Grey Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull Warning Letter N/A   52.4191184 -1.8326637
14179 op-snap---monthly-publication-june-2025.pdf   108 2025-06 Pedal Bike BMW X5 Silver Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Education N/A   52.4092804 -1.8056214
14286 op-snap---monthly-publication-june-2025.pdf   215 2025-06 Pedal Bike Volkswagen Sharan Silver Driving without Due Care and Attention None Old Dickens Heath Road Old Dickens Heath Road Solihull Solihull Warning Letter N/A   52.3864791 -1.8355922
14465 op-snap---monthly-publication-june-2025.pdf   394 2025-06 Pedal Bike BMW 340I Black Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Solihull Solihull Education N/A   52.4144779 -1.7848758
14530 op-snap---monthly-publication-june-2025.pdf   459 2025-06 Pedal Bike BMW M235 White Driving without Due Care and Attention None Norton Lane Norton Lane Solihull Solihull Education N/A   52.3778771 -1.8581547
14574 op-snap---monthly-publication-june-2025.pdf   503 2025-06 Pedal Bike Audi A4 Black Driving without Due Care and Attention None Windward Way Windward Way Solihull Solihull NFA No Offence   52.5023715 -1.7555515
14851 op-snap---monthly-publication-june-2025.pdf   780 2025-06 Pedal Bike Land Rover Defender Black Driving without Due Care and Attention None Spring Hill Spring Hill Solihull Solihull Fixed Penalty N/A      
14880 op-snap---monthly-publication-june-2025.pdf   809 2025-06 Pedal Bike Mercedes-Benz sprint Grey Driving without Due Care and Attention None High Street High Street Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.4064169 -1.8557215
15173 op-snap---monthly-publication-june-2025.pdf   1102 2025-06 Pedal Bike Ford Focus Blue Driving without Due Care and Attention None Barston Lane Barston Lane Solihull Solihull Education N/A   52.4022999 -1.685635
15291 op-snap---monthly-publication-june-2025.pdf   1220 2025-06 Pedal Bike Volvo XC40 Black Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.4190728 -1.7449943
15293 op-snap---monthly-publication-june-2025.pdf   1222 2025-06 Pedal Bike Volvo XC90 Silver Driving without Due Care and Attention None Hampton Lane Hampton Lane Solihull Solihull NFA Outside of 14 DAYS Late Submission   52.4190728 -1.7449943
15526 op-snap---monthly-publication-june-2025.pdf   1455 2025-06 Pedal Bike Ford Transit Grey Driving without Due Care and Attention None Haslucks Green Road Haslucks Green Road Solihull Solihull Education N/A   52.4145149 -1.8301272
15647 op-snap---monthly-publication-june-2025.pdf   1576 2025-06 Pedal Bike Volkswagen Golf Red Driving without Due Care and Attention None Olton Road Olton Road Solihull Solihull Education N/A   52.4193964 -1.8252207
18695 op-snap---monthly-publication-may-2025.pdf   57 2025-05 Pedal Bike Ford Tourneo Silver Driving without Due Care and Attention None Wherretts Well Lane Wherretts Well Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4225399 -1.763283
19031 op-snap---monthly-publication-may-2025.pdf   393 2025-05 Pedal Bike Ford fiesta White Driving without Due Care and Attention None Kiddiminster road Kiddiminster road Solihull Solihull Fixed Penalty N/A      
19253 op-snap---monthly-publication-may-2025.pdf   615 2025-05 Pedal Bike Daf Scania White Driving without Due Care and Attention None Damson Parkway Damson Parkway Solihull Solihull Education N/A   52.437016 -1.7578446
19280 op-snap---monthly-publication-may-2025.pdf   642 2025-05 Pedal Bike Audi A5 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Solihull Solihull NFA No VRM   52.4191184 -1.8326637
19596 op-snap---monthly-publication-may-2025.pdf   958 2025-05 Pedal Bike Land Rover Discovery Grey Driving without Due Care and Attention None Monkspath Road Monkspath Road Solihull Solihull Education N/A   52.3909753 -1.8020771
19612 op-snap---monthly-publication-may-2025.pdf   974 2025-05 Pedal Bike Volvo V70... Green Driving without Due Care and Attention none B4102 Meriden Road Meriden Road Solihull Solihull Education N/A   52.4137518 -1.6414448
19981 op-snap---monthly-publication-may-2025.pdf   1343 2025-05 Pedal Bike Audi S4 Estate Grey Driving without Due Care and Attention None Tile house green lane Tile house green lane Solihull Solihull NFA Outside of 14 Days NIP      
20416 op-snap---monthly-publication-may-2025.pdf   1778 2025-05 Pedal Bike Skoda Karoq Green Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Warning Letter N/A   52.4149064 -1.7832364
20417 op-snap---monthly-publication-may-2025.pdf   1779 2025-05 Pedal Bike Vauxhall Vivaro White Driving without Due Care and Attention None Sharmans Cross Road Sharmans Cross Road Solihull Solihull Warning Letter N/A   52.4167172 -1.7990388
20418 op-snap---monthly-publication-may-2025.pdf   1780 2025-05 Pedal Bike Ford Transit White Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Warning Letter N/A   52.4149064 -1.7832364
20420 op-snap---monthly-publication-may-2025.pdf   1782 2025-05 Pedal Bike Renault Master Orange Driving without Due Care and Attention None Spencers Lane Spencers Lane Solihull Solihull Warning Letter N/A   52.3958008 -1.6161896
1334 op-snap---monthly-publication-april-2025.pdf   1333 2025-04 Pedal Bike Ford Transit White Driving without Due Care and Attention None Approx half way between the Red lion and the junction with Rumbush lane Approx half way between the Red lion and the junction with Rumbush lane Solihull Solihull NFA Outside of 14 Days NIP      
1541 op-snap---monthly-publication-april-2025.pdf   1540 2025-04 Pedal Bike Ford Focus Red Driving without Due Care and Attention None Haslucks green road Haslucks green road Solihull Solihull NFA Outside of 14 Days NIP   52.4145149 -1.8301272
1885 op-snap---monthly-publication-april-2025.pdf   1884 2025-04 Pedal Bike Ford NP Grey Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull NFA Outside of 14 Days NIP   52.4149064 -1.7832364
16467 op-snap---monthly-publication-march-2025.pdf   224 2025-03 Pedal Bike Tesla   Black Driving without Due Care and Attention None Barton Lodge Road Barton Lodge Road Solihull Solihull NFA No Offence Yes - Via Email    

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