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

211 rows where council_area = "Birmingham", 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, nfa_rationale

reporter_transport_mode 5

offence 1

  • Driving without Reasonable Consideration · 211 ✖

disposal 1

  • Warning Letter · 211 ✖

council_area 1

  • Birmingham · 211 ✖
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
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
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
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
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
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
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
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
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
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
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      
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
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      
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
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
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      
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      
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      
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
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      
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
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      
15711 op-snap---monthly-publication-june-2025.pdf   1640 2025-06 Car Volkswagen Passat Black Driving without Reasonable Consideration None Granville Street Granville Street Birmingham Birmingham Warning Letter N/A   52.4762076 -1.9124263
18646 op-snap---monthly-publication-may-2025.pdf   8 2025-05 Pedal Bike Ford Puma Blue Driving without Reasonable Consideration None Moor Green Lane Moor Green Lane Birmingham Birmingham Warning Letter N/A   52.4374665 -1.9119895
18968 op-snap---monthly-publication-may-2025.pdf   330 2025-05 Car Citroen C3 Red Driving without Reasonable Consideration None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham Warning Letter N/A      
19028 op-snap---monthly-publication-may-2025.pdf   390 2025-05 Car Renault Captur Grey Driving without Reasonable Consideration None Tyburn House roundabout Tyburn House roundabout Birmingham Birmingham Warning Letter N/A      
19512 op-snap---monthly-publication-may-2025.pdf   874 2025-05 Car Audi RS6 Blue Driving without Reasonable Consideration None Kings Road Kings Road Birmingham Birmingham Warning Letter N/A   52.5531351 -1.8852761
19627 op-snap---monthly-publication-may-2025.pdf   989 2025-05 Car Audi A3 Black Driving without Reasonable Consideration None Eddish Road Eddish Road Birmingham Birmingham Warning Letter N/A   52.4833672 -1.7871439
19689 op-snap---monthly-publication-may-2025.pdf   1051 2025-05 Car Volkswagen Sharan Grey Driving without Reasonable Consideration None A47 Heartlands Parkway Heartlands Parkway Birmingham Birmingham Warning Letter N/A   52.5038363 -1.8432663
83 op-snap---monthly-publication-april-2025.pdf   82 2025-04 Pedal Bike Volkswagen Golf Black Driving without Reasonable Consideration No Insurance Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
88 op-snap---monthly-publication-april-2025.pdf   87 2025-04 Pedal Bike BMW X6 White Driving without Reasonable Consideration None Avenue Road Avenue Road Birmingham Birmingham Warning Letter N/A   52.4941712 -1.8795158
101 op-snap---monthly-publication-april-2025.pdf   100 2025-04 Pedal Bike Volvo V40 Grey Driving without Reasonable Consideration None Bristol Road South Bristol Road South Birmingham Birmingham Warning Letter N/A   52.4119174 -1.9735247
102 op-snap---monthly-publication-april-2025.pdf   101 2025-04 Car BMW 320d White Driving without Reasonable Consideration None Oxhill Road Oxhill Road Birmingham Birmingham Warning Letter N/A   52.513857 -1.9367367
133 op-snap---monthly-publication-april-2025.pdf   132 2025-04 Car Volkswagen Passat Silver Driving without Reasonable Consideration None Avenue Road Avenue Road Birmingham Birmingham Warning Letter N/A   52.4941712 -1.8795158
135 op-snap---monthly-publication-april-2025.pdf   134 2025-04 Car BMW 420D Black Driving without Reasonable Consideration None M6 M6 Birmingham Birmingham Warning Letter N/A      
154 op-snap---monthly-publication-april-2025.pdf   153 2025-04 Pedal Bike Vauxhall Corsa Black Driving without Reasonable Consideration None Oxford Road Oxford Road Birmingham Birmingham Warning Letter N/A   52.4456323 -1.8858352
157 op-snap---monthly-publication-april-2025.pdf   156 2025-04 Pedal Bike   COMPASS Red Driving without Reasonable Consideration None A4030 BEARWOOD ROAD A4030 Bearwood Road Birmingham Birmingham Warning Letter N/A      
254 op-snap---monthly-publication-april-2025.pdf   253 2025-04 Pedal Bike Audi A3 Black Driving without Reasonable Consideration None High St High Street Birmingham Birmingham Warning Letter N/A   52.5254588 -1.8373064
463 op-snap---monthly-publication-april-2025.pdf   462 2025-04 Car Volkswagen Polo Grey Driving without Reasonable Consideration None Stratford Road Stratford Road Birmingham Birmingham Warning Letter N/A   52.4203897 -1.8338574
515 op-snap---monthly-publication-april-2025.pdf   514 2025-04 Car Jaguar E Pace Black Driving without Reasonable Consideration None Fordhouse Road Fordhouse Road Birmingham Birmingham Warning Letter N/A   52.4225474 -1.9212161
524 op-snap---monthly-publication-april-2025.pdf   523 2025-04 Pedal Bike BMW 840D Black Driving without Reasonable Consideration None Raddlebarn Rd Raddlebarn Road Birmingham Birmingham Warning Letter N/A   52.4397168 -1.9260414
542 op-snap---monthly-publication-april-2025.pdf   541 2025-04 Pedal Bike Vauxhall Corsa Red Driving without Reasonable Consideration None A38 Kingsbury Road Kingsbury Road Birmingham Birmingham Warning Letter N/A   52.5292752 -1.7618805
546 op-snap---monthly-publication-april-2025.pdf   545 2025-04 Pedal Bike BMW X1 Brown Driving without Reasonable Consideration None Shenley Lane Shenley Lane Birmingham Birmingham Warning Letter N/A   52.430111 -1.9753703
646 op-snap---monthly-publication-april-2025.pdf   645 2025-04 Car Audi S5 Blue Driving without Reasonable Consideration None Hockley Flyover Hockley Flyover Birmingham Birmingham Warning Letter N/A   52.4972422 -1.9176353
663 op-snap---monthly-publication-april-2025.pdf   662 2025-04 Car Audi A4.. Black Driving without Reasonable Consideration None 6 Ways roundabout Lozells 6 Ways roundabout Lozells Birmingham Birmingham Warning Letter N/A      
677 op-snap---monthly-publication-april-2025.pdf   676 2025-04 Pedestrian Audi Q5 Grey Driving without Reasonable Consideration None Frankley Lane Frankley Lane Birmingham Birmingham Warning Letter N/A   52.4244805 -1.9946147
740 op-snap---monthly-publication-april-2025.pdf   739 2025-04 Car Citroen C1 Grey Driving without Reasonable Consideration None Tessall Lane Tessall Lane Birmingham Birmingham Warning Letter N/A   52.4045186 -1.9891793
757 op-snap---monthly-publication-april-2025.pdf   756 2025-04 Pedal Bike BMW X3 White Driving without Reasonable Consideration None Shannon Road Shannon Road Birmingham Birmingham Warning Letter N/A   52.4008254 -1.9287243
16390 op-snap---monthly-publication-march-2025.pdf   147 2025-03 Pedal Bike Audi A5 Grey Driving without Reasonable Consideration None Icknield Port Road Icknield Port Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4792334 -1.92925
16416 op-snap---monthly-publication-march-2025.pdf   173 2025-03 Pedal Bike Renault Clio Silver Driving without Reasonable Consideration None Newton Road, Scott Arms Newton Road, Scott Arms Birmingham Birmingham Warning Letter N/A Yes - Via Email    
16446 op-snap---monthly-publication-march-2025.pdf   203 2025-03 Pedal Bike Daf Ssmart Silver Driving without Reasonable Consideration None Selly Park Road Selly Park Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4390561 -1.9209229
16568 op-snap---monthly-publication-march-2025.pdf   325 2025-03 Car Hyundai i20 Blue Driving without Reasonable Consideration None Gillott Road Gillott Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4791408 -1.9467501
16579 op-snap---monthly-publication-march-2025.pdf   336 2025-03 Pedal Bike Toyota Yaris Black Driving without Reasonable Consideration None Walsall Wood Road Walsall Wood Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5623476 -1.9436356
16638 op-snap---monthly-publication-march-2025.pdf   395 2025-03 Pedal Bike Ford Transit Grey Driving without Reasonable Consideration None Frogmill Lane Frogmill Lane Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4023807 -2.0047634
16774 op-snap---monthly-publication-march-2025.pdf   531 2025-03 Pedal Bike Nissan NAVARA White Driving without Reasonable Consideration None BRISTOL ROAD Bristol Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4543565 -1.9114004
16804 op-snap---monthly-publication-march-2025.pdf   561 2025-03 Car Mercedes-Benz A CLASS Grey Driving without Reasonable Consideration None BELGRAVE INTERCHANGE Belgrave Interchange Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.466118 -1.8982999
16903 op-snap---monthly-publication-march-2025.pdf   660 2025-03 Pedal Bike Volkswagen Caddy White Driving without Reasonable Consideration None Long Acre Long Acre Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5051253 -1.8646383
16904 op-snap---monthly-publication-march-2025.pdf   661 2025-03 Car Toyota   Purple Driving without Reasonable Consideration None Long Acre Long Acre Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5051253 -1.8646383
16906 op-snap---monthly-publication-march-2025.pdf   663 2025-03 Car Ford Fiesta Black Driving without Reasonable Consideration None Thimble Mill Lane Thimble Mill Lane Birmingham Birmingham Warning Letter Outside of 14 DAYS Late Submission Yes - Via Email 52.4965745 -1.8714709
16911 op-snap---monthly-publication-march-2025.pdf   668 2025-03 Pedestrian Vauxhall Astra Grey Driving without Reasonable Consideration None Long Acre Road Long Acre Road Birmingham Birmingham Warning Letter Outside of 14 Days NIP Yes - Via Email    
16976 op-snap---monthly-publication-march-2025.pdf   733 2025-03 Car Mazda 3 White Driving without Reasonable Consideration None Angesley Avenue Angesley Avenue Birmingham Birmingham Warning Letter N/A Yes - Via Email    
17014 op-snap---monthly-publication-march-2025.pdf   771 2025-03 Pedal Bike Mercedes-Benz Box van White Driving without Reasonable Consideration None Holiday Street Holiday Street Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4757071 -1.8988573
17016 op-snap---monthly-publication-march-2025.pdf   773 2025-03 Pedal Bike Audi A3 Silver Driving without Reasonable Consideration None Hagley Road Hagley Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.471632 -1.9456776
17050 op-snap---monthly-publication-march-2025.pdf   807 2025-03 Pedal Bike Lexus ch200 Black Driving without Reasonable Consideration None Grantham Road Grantham Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4624098 -1.8708709
17239 op-snap---monthly-publication-march-2025.pdf   996 2025-03 Car Seat Ateca White Driving without Reasonable Consideration None Woodburn Road Woodburn Road Birmingham Birmingham Warning Letter N/A Yes - Via Email    
17338 op-snap---monthly-publication-march-2025.pdf   1095 2025-03 Car Ford Focus Silver Driving without Reasonable Consideration None Heartlands Parkway Heartlands Parkway Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.5038363 -1.8432663
17355 op-snap---monthly-publication-march-2025.pdf   1112 2025-03 Pedal Bike Volvo XC40 Blue Driving without Reasonable Consideration None Quinton Rd Quinton Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.447826 -1.9574468
17391 op-snap---monthly-publication-march-2025.pdf   1148 2025-03 Car Mini Cooper Grey Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4470686 -1.8880749
17408 op-snap---monthly-publication-march-2025.pdf   1165 2025-03 Car Citroen C3 Blue Driving without Reasonable Consideration None Islington Middleway Islington Middleway Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4713211 -1.91264
17481 op-snap---monthly-publication-march-2025.pdf   1238 2025-03 Car Ford Transit White Driving without Reasonable Consideration None Lilly Lane A441 Lilly Lane A441 Birmingham Birmingham Warning Letter N/A Yes - Via Email    
17514 op-snap---monthly-publication-march-2025.pdf   1271 2025-03 Pedal Bike Chevrolet Trax White Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.4543565 -1.9114004
17588 op-snap---monthly-publication-march-2025.pdf   1345 2025-03 Lorry Renault Trucks White Driving without Reasonable Consideration None M6 Junction 6-7 Southbound M6 Junction 6-7 Southbound Birmingham Birmingham Warning Letter N/A Yes - Via Email 52.676119 -2.0858425

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