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

103 rows where council_area = "Birmingham", disposal = "Fixed Penalty" and month = "2025-12" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence

reporter_transport_mode 3

month 1

  • 2025-12 · 103 ✖

disposal 1

  • Fixed Penalty · 103 ✖

council_area 1

  • Birmingham · 103 ✖
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
3890 op-snap---monthly-publication-december-2025.pdf   18 2025-12 Pedestrian Tesla Model Y White Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
3893 op-snap---monthly-publication-december-2025.pdf   21 2025-12 Car Ford puma Grey Using a Mobile Phone Whilst Driving None Sarehole Road Sarehole Road Birmingham Birmingham Fixed Penalty N/A   52.4422505 -1.8539684
3912 op-snap---monthly-publication-december-2025.pdf   40 2025-12 Pedal Bike Audi TT Grey Using a Mobile Phone Whilst Driving None Valentine Road Valentine Road Birmingham Birmingham Fixed Penalty N/A   52.4381959 -1.8907391
3920 op-snap---monthly-publication-december-2025.pdf   48 2025-12 Pedal Bike Audi Q7 White Driving without Due Care and Attention None Yardley Green Lane Yardley Green Lane Birmingham Birmingham Fixed Penalty N/A   52.4551082 -1.8103696
3921 op-snap---monthly-publication-december-2025.pdf   49 2025-12 Car Porsche Cayenne Black Using a Mobile Phone Whilst Driving None Kingstanding Road Kingstanding Road Birmingham Birmingham Fixed Penalty N/A   52.5521118 -1.8845138
3983 op-snap---monthly-publication-december-2025.pdf   111 2025-12 Car Mercedes-Benz A35 White Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Fixed Penalty N/A   52.5113867 -1.8337258
3984 op-snap---monthly-publication-december-2025.pdf   112 2025-12 Pedal Bike Kia Venga Silver Using a Mobile Phone Whilst Driving None Stratford Road towards Shirley Stratford Road towards Shirley Birmingham Birmingham Fixed Penalty N/A      
3988 op-snap---monthly-publication-december-2025.pdf   116 2025-12 Pedal Bike Mercedes-Benz A35 Blue Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4009 op-snap---monthly-publication-december-2025.pdf   137 2025-12 Pedal Bike Volkswagen TRoc Silver Driving without Due Care and Attention none Longmoor Street Longmoor Street Birmingham Birmingham Fixed Penalty N/A      
4010 op-snap---monthly-publication-december-2025.pdf   138 2025-12 Pedal Bike Honda Civic Blue Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408
4012 op-snap---monthly-publication-december-2025.pdf   140 2025-12 Pedal Bike Peugeot 208 Orange Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4015 op-snap---monthly-publication-december-2025.pdf   143 2025-12 Pedal Bike Mini Clubman White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4016 op-snap---monthly-publication-december-2025.pdf   144 2025-12 Pedal Bike BMW i4 Green Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4028 op-snap---monthly-publication-december-2025.pdf   156 2025-12 Car BMW X4 Red Vehicle overtake within crossing limits None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
4044 op-snap---monthly-publication-december-2025.pdf   172 2025-12 Pedal Bike Jaguar F Pace Blue Using a Mobile Phone Whilst Driving None Park Hill Road Park Hill Road Birmingham Birmingham Fixed Penalty N/A   52.4612518 -1.9515542
4045 op-snap---monthly-publication-december-2025.pdf   173 2025-12 Pedal Bike Mercedes-Benz CLA 250 Black Using a Mobile Phone Whilst Driving None Navigation Street Navigation Street Birmingham Birmingham Fixed Penalty N/A   52.4781877 -1.9011642
4047 op-snap---monthly-publication-december-2025.pdf   175 2025-12 Pedal Bike Renault Clio Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
4049 op-snap---monthly-publication-december-2025.pdf   177 2025-12 Pedal Bike Renault   Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4050 op-snap---monthly-publication-december-2025.pdf   178 2025-12 Pedal Bike Nissan Qashqai Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4051 op-snap---monthly-publication-december-2025.pdf   179 2025-12 Pedal Bike Audi Q8 Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4071 op-snap---monthly-publication-december-2025.pdf   199 2025-12 Car Hyundai i20 Black Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4072 op-snap---monthly-publication-december-2025.pdf   200 2025-12 Car Mercedes-Benz 220 Black Using a Mobile Phone Whilst Driving None Harbourne High Street Harbourne High Street Birmingham Birmingham Fixed Penalty N/A      
4092 op-snap---monthly-publication-december-2025.pdf   220 2025-12 Car Volkswagen GOLF Red Contravening a Red Traffic Light None Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham Fixed Penalty N/A   52.4861917 -1.8829748
4108 op-snap---monthly-publication-december-2025.pdf   236 2025-12 Car Volvo Coach White Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Fixed Penalty N/A   52.4668753 -1.8996143
4109 op-snap---monthly-publication-december-2025.pdf   237 2025-12 Car Volkswagen Golf Grey Driving without Due Care and Attention None Bentley Lane Bentley Lane Birmingham Birmingham Fixed Penalty N/A      
4137 op-snap---monthly-publication-december-2025.pdf   265 2025-12 Car Cupra Ateca Grey Driving without Due Care and Attention None Aldridge Road Aldridge Road Birmingham Birmingham Fixed Penalty N/A   52.5368764 -1.8976461
4154 op-snap---monthly-publication-december-2025.pdf   282 2025-12 Pedal Bike BMW X5.. Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4156 op-snap---monthly-publication-december-2025.pdf   284 2025-12 Pedal Bike Vauxhall Mokka Black Using a Mobile Phone Whilst Driving None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
4157 op-snap---monthly-publication-december-2025.pdf   285 2025-12 Pedal Bike Seat Ibiza Black Contravening a Red Traffic Light None Harborne High Street Harborne High Street Birmingham Birmingham Fixed Penalty N/A   52.459563 -1.946922
4158 op-snap---monthly-publication-december-2025.pdf   286 2025-12 Car Audi A3 Black Contravening a Red Traffic Light None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Fixed Penalty N/A   52.4929304 -1.8229092
4160 op-snap---monthly-publication-december-2025.pdf   288 2025-12 Pedal Bike BMW M4 Blue Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
4162 op-snap---monthly-publication-december-2025.pdf   290 2025-12 Pedal Bike Volkswagen Tiguan Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4163 op-snap---monthly-publication-december-2025.pdf   291 2025-12 Pedal Bike Nissan Juke Black Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4175 op-snap---monthly-publication-december-2025.pdf   303 2025-12 Pedestrian Mazda model 3 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4191 op-snap---monthly-publication-december-2025.pdf   319 2025-12 Car Mercedes-Benz Sprinter White Contravening a Red Traffic Light None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
4196 op-snap---monthly-publication-december-2025.pdf   324 2025-12 Pedal Bike Mercedes-Benz Splinter White Using a Mobile Phone Whilst Driving None Stratford Road Stratford Road Birmingham Birmingham Fixed Penalty N/A   52.4203897 -1.8338574
4249 op-snap---monthly-publication-december-2025.pdf   377 2025-12 Car Skoda Octavia Grey Driving without Due Care and Attention None Tile Cross Road at Cooks Lane Tile Cross Road at Cooks Lane Birmingham Birmingham Fixed Penalty N/A   52.4733145 -1.7662713
4270 op-snap---monthly-publication-december-2025.pdf   398 2025-12 Car Volkswagen Golf White Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Fixed Penalty N/A   52.4103191 -1.8670224
4281 op-snap---monthly-publication-december-2025.pdf   409 2025-12 Pedal Bike Porsche 911.. White Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4282 op-snap---monthly-publication-december-2025.pdf   410 2025-12 Pedal Bike Seat Arona Black Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
4283 op-snap---monthly-publication-december-2025.pdf   411 2025-12 Pedal Bike Mercedes-Benz CLA White Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4284 op-snap---monthly-publication-december-2025.pdf   412 2025-12 Pedal Bike Hyundai Kona Grey Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4290 op-snap---monthly-publication-december-2025.pdf   418 2025-12 Pedal Bike Mitsubishi ASX.. Black Driving without Due Care and Attention None Reservoir Road Reservoir Road Birmingham Birmingham Fixed Penalty N/A   52.5242452 -1.8572541
4291 op-snap---monthly-publication-december-2025.pdf   419 2025-12 Pedal Bike Skoda Superb Grey Driving without Due Care and Attention None Reservoir Road Reservoir Road Birmingham Birmingham Fixed Penalty N/A   52.5242452 -1.8572541
4302 op-snap---monthly-publication-december-2025.pdf   430 2025-12 Pedal Bike Volvo V60 Black Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Fixed Penalty N/A   52.4094108 -1.9930633
4326 op-snap---monthly-publication-december-2025.pdf   454 2025-12 Car Ford Fiesta Silver Using a Mobile Phone Whilst Driving None M6 Motorway M6 Motorway Birmingham Birmingham Fixed Penalty N/A   52.5327447 -1.899844
4344 op-snap---monthly-publication-december-2025.pdf   472 2025-12 Pedestrian Toyota Prius white Using a Mobile Phone Whilst Driving None Green Lane, Small Heath Green Lane, Small Heath Birmingham Birmingham Fixed Penalty N/A   52.4733613 -1.8591116
4345 op-snap---monthly-publication-december-2025.pdf   473 2025-12 Pedal Bike   Bentley Blue Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4346 op-snap---monthly-publication-december-2025.pdf   474 2025-12 Pedestrian Peugeot 2008 Black Using a Mobile Phone Whilst Driving None Green Lane, Small Heath Green Lane, Small Heath Birmingham Birmingham Fixed Penalty N/A   52.4733613 -1.8591116
4347 op-snap---monthly-publication-december-2025.pdf   475 2025-12 Pedal Bike Mercedes-Benz A180.. Black Using a Mobile Phone Whilst Driving None Metchley Lane Harborne Metchley Lane Harborne Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4348 op-snap---monthly-publication-december-2025.pdf   476 2025-12 Pedal Bike Audi Q3 Black Use a motor vehicle / trailer in a condition likely to cause danger of injury None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4350 op-snap---monthly-publication-december-2025.pdf   478 2025-12 Pedal Bike Volkswagen Tiguan Grey Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4352 op-snap---monthly-publication-december-2025.pdf   480 2025-12 Pedal Bike Porsche Taycan Grey Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4353 op-snap---monthly-publication-december-2025.pdf   481 2025-12 Pedal Bike Skoda Octavia Beige Using a Mobile Phone Whilst Driving None Aston Webb Blvd, Selly Oak Aston Webb Boulevard, Selly Oak Birmingham Birmingham Fixed Penalty N/A   52.4443904 -1.9419231
4354 op-snap---monthly-publication-december-2025.pdf   482 2025-12 Pedal Bike Audi E tron Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4356 op-snap---monthly-publication-december-2025.pdf   484 2025-12 Pedal Bike BMW 120d Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4357 op-snap---monthly-publication-december-2025.pdf   485 2025-12 Pedal Bike Volkswagen Caddy Grey Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4358 op-snap---monthly-publication-december-2025.pdf   486 2025-12 Pedal Bike Skoda Kamiq Black Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4359 op-snap---monthly-publication-december-2025.pdf   487 2025-12 Pedal Bike Nissan Qashqai Grey Using a Mobile Phone Whilst Driving None Salisbury Road Salisbury Road Birmingham Birmingham Fixed Penalty N/A   52.4943878 -1.8504211
4374 op-snap---monthly-publication-december-2025.pdf   502 2025-12 Pedal Bike Ford Focus Grey Using a Mobile Phone Whilst Driving None Moseley Road Moseley Road Birmingham Birmingham Fixed Penalty N/A   52.4679402 -1.881408
4375 op-snap---monthly-publication-december-2025.pdf   503 2025-12 Pedal Bike Kia Ceed Red Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4389 op-snap---monthly-publication-december-2025.pdf   517 2025-12 Pedestrian Mini Cooper Black Using a Mobile Phone Whilst Driving None Hagley Road Hagley Road Birmingham Birmingham Fixed Penalty N/A   52.471632 -1.9456776
4392 op-snap---monthly-publication-december-2025.pdf   520 2025-12 Car Peugeot Speedight Green Driving without Due Care and Attention No Insurance Chester Road Chester Road Birmingham Birmingham Fixed Penalty N/A   52.5359496 -1.8324115
4393 op-snap---monthly-publication-december-2025.pdf   521 2025-12 Car Citroen Berlingo Blue Using a Mobile Phone Whilst Driving None Cooks Lane Cooks Lane Birmingham Birmingham Fixed Penalty N/A   52.482758 -1.7603097
4395 op-snap---monthly-publication-december-2025.pdf   523 2025-12 Car Volkswagen Touran Silver Contravening a Red Traffic Light None Highfield Road Highfield Road Birmingham Birmingham Fixed Penalty N/A   52.4216321 -1.855984
4404 op-snap---monthly-publication-december-2025.pdf   532 2025-12 Car Volkswagen Crafter Blue Using a Mobile Phone Whilst Driving none Eddish Road, Kitts Green Eddish Road, Kitts Green Birmingham Birmingham Fixed Penalty N/A   52.4833672 -1.7871439
4423 op-snap---monthly-publication-december-2025.pdf   551 2025-12 Car Volkswagen Scirroco Purple Contravening a Red Traffic Light None Coventry Road Coventry Road Birmingham Birmingham Fixed Penalty N/A   52.4726661 -1.8769032
4441 op-snap---monthly-publication-december-2025.pdf   569 2025-12 Pedestrian Other moped Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None manilla road Manilla Road Birmingham Birmingham Fixed Penalty N/A   52.4376834 -1.9152398
4469 op-snap---monthly-publication-december-2025.pdf   597 2025-12 Car Volkswagen Polo Silver Driving without Due Care and Attention None Forest Road Forest Road Birmingham Birmingham Fixed Penalty N/A   52.4467275 -1.8804014
4474 op-snap---monthly-publication-december-2025.pdf   602 2025-12 Car BMW ! Series Black Driving without Due Care and Attention None Lichfield Road Lichfield Road Birmingham Birmingham Fixed Penalty N/A   52.5012458 -1.8780942
4507 op-snap---monthly-publication-december-2025.pdf   635 2025-12 Car Ford Kuga Blue Motor vehicle fail to accord precedence at a pelican crossing None Churchill Road Churchill Road Birmingham Birmingham Fixed Penalty N/A   52.5529597 -1.8615015
4550 op-snap---monthly-publication-december-2025.pdf   678 2025-12 Pedal Bike Mercedes-Benz SL400 Black Using a Mobile Phone Whilst Driving None Valentine Road Valentine Road Birmingham Birmingham Fixed Penalty N/A   52.4381959 -1.8907391
4554 op-snap---monthly-publication-december-2025.pdf   682 2025-12 Pedal Bike Ford Transit Silver Using a Mobile Phone Whilst Driving None Granville Street Granville Street Birmingham Birmingham Fixed Penalty N/A   52.4762076 -1.9124263
4555 op-snap---monthly-publication-december-2025.pdf   683 2025-12 Pedal Bike Citroen C3.. Orange Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
4556 op-snap---monthly-publication-december-2025.pdf   684 2025-12 Pedal Bike Kia Proceed White Using a Mobile Phone Whilst Driving None Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
4568 op-snap---monthly-publication-december-2025.pdf   696 2025-12 Pedestrian Renault Clio Blue Stop a vehicle within pelican pedestrian crossing limits None Bromford Road, Hodge Hill Bromford Road, Hodge Hill Birmingham Birmingham Fixed Penalty N/A   52.503036 -1.8289972
4571 op-snap---monthly-publication-december-2025.pdf   699 2025-12 Pedal Bike Toyota Yaris Grey Using a Mobile Phone Whilst Driving None Valentine Road Valentine Road Birmingham Birmingham Fixed Penalty N/A   52.4381959 -1.8907391
4575 op-snap---monthly-publication-december-2025.pdf   703 2025-12 Car Toyota Prius Grey Use a vehicle / cycle on a road and contravene a local traffic order other than parking None High St Aston High Street Aston Birmingham Birmingham Fixed Penalty N/A   52.500816 -1.8965601
4646 op-snap---monthly-publication-december-2025.pdf   774 2025-12 Car Land Rover Range Black Drive a vehicle other than on the carriageway of a motorway None M6 j6 M6 j6 Birmingham Birmingham Fixed Penalty N/A   52.676119 -2.0858425
4656 op-snap---monthly-publication-december-2025.pdf   784 2025-12 Pedal Bike Nissan Qashqai Red Using a Mobile Phone Whilst Driving None Augustus Road Augustus Road Birmingham Birmingham Fixed Penalty N/A   52.4695793 -1.9378608
4657 op-snap---monthly-publication-december-2025.pdf   785 2025-12 Pedal Bike BMW 320d White Using a Mobile Phone Whilst Driving None Harborne Road Harborne Road Birmingham Birmingham Fixed Penalty N/A   52.4718503 -1.9195423
4658 op-snap---monthly-publication-december-2025.pdf   786 2025-12 Pedal Bike Citroen C1 Blue Using a Mobile Phone Whilst Driving None Bath Row Bath Row Birmingham Birmingham Fixed Penalty N/A   52.472238 -1.9127983
4659 op-snap---monthly-publication-december-2025.pdf   787 2025-12 Pedal Bike   Smart Silver Using a Mobile Phone Whilst Driving None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Fixed Penalty N/A   52.4468506 -1.9395619
4666 op-snap---monthly-publication-december-2025.pdf   794 2025-12 Car Toyota Prius Silver Contravening a Red Traffic Light None Linden Road Linden Road Birmingham Birmingham Fixed Penalty N/A   52.4263156 -1.9351622
4694 op-snap---monthly-publication-december-2025.pdf   822 2025-12 Pedal Bike Honda CRV Grey Using a Mobile Phone Whilst Driving None Hill Street Hill Street Birmingham Birmingham Fixed Penalty N/A   52.4777765 -1.901321
4695 op-snap---monthly-publication-december-2025.pdf   823 2025-12 Pedal Bike Volkswagen Polo Grey Using a Mobile Phone Whilst Driving None New Fosse Way New Fosse Way Birmingham Birmingham Fixed Penalty N/A   52.4473373 -1.9392405
4721 op-snap---monthly-publication-december-2025.pdf   849 2025-12 Car Tesla Model S Red Driving without Due Care and Attention None Valentine Road Valentine Road Birmingham Birmingham Fixed Penalty N/A   52.4381959 -1.8907391
4726 op-snap---monthly-publication-december-2025.pdf   854 2025-12 Car Seat Leon Grey Contravening a Red Traffic Light None Castle Bromwich Interchange Castle Bromwich Interchange Birmingham Birmingham Fixed Penalty N/A      
4769 op-snap---monthly-publication-december-2025.pdf   897 2025-12 Car Volkswagen Touareg Grey Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham Fixed Penalty N/A   52.4622646 -1.8599985
4811 op-snap---monthly-publication-december-2025.pdf   939 2025-12 Pedal Bike Hyundai i10 White Using a Mobile Phone Whilst Driving None Alcester Road Alcester Road Birmingham Birmingham Fixed Penalty N/A   52.4470686 -1.8880749
4839 op-snap---monthly-publication-december-2025.pdf   967 2025-12 Pedestrian Volkswagen Sharan Red Using a Mobile Phone Whilst Driving None Green lane Green lane Birmingham Birmingham Fixed Penalty N/A   52.4618966 -1.9955421
4843 op-snap---monthly-publication-december-2025.pdf   971 2025-12 Car Nissan Pulsar White Using a Mobile Phone Whilst Driving None Heartlands Parkway Heartlands Parkway Birmingham Birmingham Fixed Penalty N/A   52.5038363 -1.8432663
4858 op-snap---monthly-publication-december-2025.pdf   986 2025-12 Pedestrian BMW M8 Black Using a Mobile Phone Whilst Driving None Regent Place Regent Place Birmingham Birmingham Fixed Penalty N/A   52.4860376 -1.9095854
4860 op-snap---monthly-publication-december-2025.pdf   988 2025-12 Pedal Bike Honda CR-V Silver Using a Mobile Phone Whilst Driving None Navigation Street Navigation Street Birmingham Birmingham Fixed Penalty N/A   52.4781877 -1.9011642
4874 op-snap---monthly-publication-december-2025.pdf   1002 2025-12 Car Renault Captur Black Misc - Non Traffic Offences Use vehicle on a road withou tI lvsaalnidd tReosat dc ertificate t I lvsaalnidd t Reosat dc ertificate Birmingham Birmingham Fixed Penalty N/A      
4876 op-snap---monthly-publication-december-2025.pdf   1004 2025-12 Car Peugeot 107.. Blue Contravening a Red Traffic Light None College Road A453 College Road A453 Birmingham Birmingham Fixed Penalty N/A   52.5464523 -1.8563364
4880 op-snap---monthly-publication-december-2025.pdf   1008 2025-12 Pedal Bike Nissan Juke Blue Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Fixed Penalty N/A   52.4094108 -1.9930633
4889 op-snap---monthly-publication-december-2025.pdf   1017 2025-12 Car Vauxhall Mokka White Vehicle overtake within crossing limits None Aston Webb Boulevard, Selly Oak Aston Webb Boulevard, Selly Oak Birmingham Birmingham Fixed Penalty N/A   52.4443904 -1.9419231
4922 op-snap---monthly-publication-december-2025.pdf   1050 2025-12 Car Citroen Berlingo White Contravening a Red Traffic Light None Tyburn Road Tyburn Road Birmingham Birmingham Fixed Penalty N/A   52.5113867 -1.8337258
4930 op-snap---monthly-publication-december-2025.pdf   1058 2025-12 Car Mini Cooper Silver No Insurance None Pineapple Road, Kings Heath Pineapple Road, Kings Heath Birmingham Birmingham Fixed Penalty N/A   52.4303068 -1.9077938

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