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

191 rows where council_area = "Birmingham", month = "2026-01" and offence = "Driving without Due Care and Attention" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

reporter_transport_mode 7

offence 1

  • Driving without Due Care and Attention · 191 ✖

month 1

  • 2026-01 · 191 ✖

council_area 1

  • Birmingham · 191 ✖
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
10542 op-snap---monthly-publication-january-2026.pdf   3 2026-01 Car Volkswagen Golf Silver Driving without Due Care and Attention None M42 near birmingham airport M42 near birmingham airport Birmingham Birmingham Warning Letter N/A      
10557 op-snap---monthly-publication-january-2026.pdf   18 2026-01 Pedal Bike Toyota Avensis Silver Driving without Due Care and Attention None Robin Hood lane Robin Hood lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
10558 op-snap---monthly-publication-january-2026.pdf   19 2026-01 Pedal Bike Volkswagen Polo Black Driving without Due Care and Attention No vehicle excise licence Brook Lane Brook Lane Birmingham Birmingham Court N/A   52.4297007 -1.8668846
10572 op-snap---monthly-publication-january-2026.pdf   33 2026-01 Car Volkswagen Golf Black Driving without Due Care and Attention No Insurance Unknown   Birmingham Birmingham NFA No Independent Evidence Available      
10574 op-snap---monthly-publication-january-2026.pdf   35 2026-01 Car Audi A1 Black Driving without Due Care and Attention None M5 SB J3 M5 Southbound J3 Birmingham Birmingham NFA No Offence   52.4846642 -1.9297585
10577 op-snap---monthly-publication-january-2026.pdf   38 2026-01 Car Audi A3 Blue Driving without Due Care and Attention None Cuckoo Road Cuckoo Road Birmingham Birmingham Fixed Penalty N/A   52.5049023 -1.8603659
10579 op-snap---monthly-publication-january-2026.pdf   40 2026-01 Pedal Bike Ford Transit Green Driving without Due Care and Attention None Alwood Road Alwood Road Birmingham Birmingham Warning Letter N/A      
10580 op-snap---monthly-publication-january-2026.pdf   41 2026-01 Pedal Bike Honda CR-V Blue Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Warning Letter N/A   52.4167654 -1.9411244
10581 op-snap---monthly-publication-january-2026.pdf   42 2026-01 Pedal Bike   Bus   Driving without Due Care and Attention None War Lane War Lane Birmingham Birmingham Warning Letter N/A   52.4569552 -1.9616483
10584 op-snap---monthly-publication-january-2026.pdf   45 2026-01 Car Audi Q3.. Black Driving without Due Care and Attention None Kitts Green Road Kitts Green Road Birmingham Birmingham Education N/A   52.4815372 -1.7766518
10585 op-snap---monthly-publication-january-2026.pdf   46 2026-01 Car Nissan Micra White Driving without Due Care and Attention No Insurance Kitts Green Road Kitts Green Road Birmingham Birmingham Education N/A   52.4815372 -1.7766518
10587 op-snap---monthly-publication-january-2026.pdf   48 2026-01 Pedestrian Yamaha gpd125 Grey Driving without Due Care and Attention None bishopsgate street Bishopsgate Street Birmingham Birmingham Warning Letter N/A   52.473986 -1.9147087
10600 op-snap---monthly-publication-january-2026.pdf   61 2026-01 Car Volkswagen Golf Black Driving without Due Care and Attention None Swan Island Swan Island Birmingham Birmingham RTC - Actioned N/A   52.4616042 -1.8154705
10603 op-snap---monthly-publication-january-2026.pdf   64 2026-01 Car Seat Leon Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
10605 op-snap---monthly-publication-january-2026.pdf   66 2026-01 Car   Irizar Coach White Driving without Due Care and Attention None St Chads Queensway Street Chads Queensway Birmingham Birmingham Warning Letter N/A      
10628 op-snap---monthly-publication-january-2026.pdf   89 2026-01 Pedal Bike Volkswagen Golf Grey Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Warning Letter N/A   52.4297007 -1.8668846
10629 op-snap---monthly-publication-january-2026.pdf   90 2026-01 Car Mazda 3 TS Black Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4470686 -1.8880749
10637 op-snap---monthly-publication-january-2026.pdf   98 2026-01 Car Ford Ranger White Driving without Due Care and Attention None Collector Road Collector Road Birmingham Birmingham NFA No Offence   52.5139393 -1.7600186
10639 op-snap---monthly-publication-january-2026.pdf   100 2026-01 Car Mitsubishi Outlander Grey Driving without Due Care and Attention None School Road School Road Birmingham Birmingham Education N/A   52.4161736 -1.8619692
10640 op-snap---monthly-publication-january-2026.pdf   101 2026-01 Other BMW 3 series blue Driving without Due Care and Attention None Star City car park Star City car park Birmingham Birmingham Education N/A      
10641 op-snap---monthly-publication-january-2026.pdf   102 2026-01 Other BMW 3 series black Driving without Due Care and Attention None Star City car park Star City car park Birmingham Birmingham Education N/A      
10642 op-snap---monthly-publication-january-2026.pdf   103 2026-01 Car Volkswagen Golf Grey Driving without Due Care and Attention None Wolverhampton Road South Wolverhampton Road South Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.463146 -1.9844677
10648 op-snap---monthly-publication-january-2026.pdf   109 2026-01 Car Nissan Qashqai Black Driving without Due Care and Attention None Wheeler Street Wheeler Street Birmingham Birmingham Education N/A   52.5020639 -1.9026192
10652 op-snap---monthly-publication-january-2026.pdf   113 2026-01 Other Audi A3.. Grey Driving without Due Care and Attention None Star City Car Park Star City Car Park Birmingham Birmingham Warning Letter N/A      
10653 op-snap---monthly-publication-january-2026.pdf   114 2026-01 Pedestrian Hyundai I20 Grey Driving without Due Care and Attention None Sherborne Street Sherborne Street Birmingham Birmingham NFA No Independent Evidence Available   52.4762433 -1.9176665
10655 op-snap---monthly-publication-january-2026.pdf   116 2026-01 Car Toyota Prius Silver Driving without Due Care and Attention None Clay Lane Clay Lane Birmingham Birmingham Education N/A   52.4509038 -1.8083784
10668 op-snap---monthly-publication-january-2026.pdf   129 2026-01 Car Ford Ranger Black Driving without Due Care and Attention None Royal Road Royal Road Birmingham Birmingham NFA No Offence   52.5609478 -1.8170275
10732 op-snap---monthly-publication-january-2026.pdf   193 2026-01 Car Volvo XC90 Black Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham NFA No Offence   52.5517052 -1.7825505
10763 op-snap---monthly-publication-january-2026.pdf   224 2026-01 Car Mercedes-Benz A200 Grey Driving without Due Care and Attention None Lower City Road Lower City Road Birmingham Birmingham Other Action Taken N/A      
10768 op-snap---monthly-publication-january-2026.pdf   229 2026-01 Car BMW X6 White Driving without Due Care and Attention None Green lane Green lane Birmingham Birmingham NFA No Independent Evidence Available   52.4618966 -1.9955421
10804 op-snap---monthly-publication-january-2026.pdf   265 2026-01 Car Toyota Auris Black Driving without Due Care and Attention None Birchfield Road Birchfield Road Birmingham Birmingham Warning Letter N/A   52.5170745 -1.9012542
10807 op-snap---monthly-publication-january-2026.pdf   268 2026-01 Car Volkswagen Tiguan Black Driving without Due Care and Attention None Walsall Road Walsall Road Birmingham Birmingham NFA Not in Public Interest   52.5919543 -1.8517118
10825 op-snap---monthly-publication-january-2026.pdf   286 2026-01 Pedal Bike Mercedes-Benz Sprinter Red Driving without Due Care and Attention None Quinton Island Quinton Island Birmingham Birmingham NFA No Independent Evidence Available   52.4617515 -2.0079008
10828 op-snap---monthly-publication-january-2026.pdf   289 2026-01 Car Mercedes-Benz Sprinter White Driving without Due Care and Attention None Tyburn Road, Gravely Hill Tyburn Road, Gravely Hill Birmingham Birmingham Education N/A      
10836 op-snap---monthly-publication-january-2026.pdf   297 2026-01 Car Tesla Model 3 Grey Driving without Due Care and Attention None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham NFA No Offence   52.4468506 -1.9395619
10845 op-snap---monthly-publication-january-2026.pdf   306 2026-01 Pedal Bike   Irizar Coach Grey Driving without Due Care and Attention None Lawley Middleway, Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10846 op-snap---monthly-publication-january-2026.pdf   307 2026-01 Pedal Bike Seat Leon White Driving without Due Care and Attention None Lawley Middleway Lawley Middleway Birmingham Birmingham Education N/A   52.4801772 -1.8769185
10847 op-snap---monthly-publication-january-2026.pdf   308 2026-01 Other Skoda Kodiaq White Driving without Due Care and Attention None Star City Star City Birmingham Birmingham NFA Misc Inc Crimes   52.5054363 -1.8556273
10862 op-snap---monthly-publication-january-2026.pdf   323 2026-01 Car Mini Cooper Black Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
10865 op-snap---monthly-publication-january-2026.pdf   326 2026-01 Car Ford Focus Blue Driving without Due Care and Attention None M42 M42 Birmingham Birmingham Fixed Penalty N/A      
10901 op-snap---monthly-publication-january-2026.pdf   362 2026-01 Car Audi A5 Black Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
10902 op-snap---monthly-publication-january-2026.pdf   363 2026-01 Car Ford Fiesta Black Driving without Due Care and Attention None Ladywood Middleway Ladywood Middleway Birmingham Birmingham Education N/A   52.473883 -1.9198244
10903 op-snap---monthly-publication-january-2026.pdf   364 2026-01 Car Seat Ibiza Black Driving without Due Care and Attention None Five ways roundabout Five ways roundabout Birmingham Birmingham Warning Letter N/A      
10921 op-snap---monthly-publication-january-2026.pdf   382 2026-01 Car Mercedes-Benz G-Wagon Black Driving without Due Care and Attention None Chester Road North Chester Road North Birmingham Birmingham NFA No Independent Evidence Available   52.548449 -1.8594603
10922 op-snap---monthly-publication-january-2026.pdf   383 2026-01 Car Volkswagen Polo White Driving without Due Care and Attention None Olton Boulevard Olton Boulevard Birmingham Birmingham Court N/A   52.443439 -1.8180486
10931 op-snap---monthly-publication-january-2026.pdf   392 2026-01 car Skoda Fabia Blue Driving without Due Care and Attention None Heathway Road Heathway Road Birmingham Birmingham Fixed Penalty N/A   52.560818 -1.7948304
10941 op-snap---monthly-publication-january-2026.pdf   402 2026-01 Car Mini Mini Black Driving without Due Care and Attention None Western Road Western Road Birmingham Birmingham Education N/A   52.5461182 -1.8340257
10946 op-snap---monthly-publication-january-2026.pdf   407 2026-01 Car Toyota yaris Grey Driving without Due Care and Attention None The Green The Green Birmingham Birmingham Education N/A   52.547254 -1.8143667
10947 op-snap---monthly-publication-january-2026.pdf   408 2026-01 Car Mercedes-Benz G63 Black Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham Warning Letter N/A   52.4622646 -1.8599985
10953 op-snap---monthly-publication-january-2026.pdf   414 2026-01 Car Volkswagen Golf Silver Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
10962 op-snap---monthly-publication-january-2026.pdf   423 2026-01 Car Mg HS White Driving without Due Care and Attention None Edgbaston Park Road Edgbaston Park Road Birmingham Birmingham NFA No Offence   52.4580375 -1.9261777
10984 op-snap---monthly-publication-january-2026.pdf   445 2026-01 Pedal Bike Toyota MPV White Driving without Due Care and Attention None Reservoir Road, Edgbaston Reservoir Road, Edgbaston Birmingham Birmingham Education N/A   52.4771764 -1.93246
10986 op-snap---monthly-publication-january-2026.pdf   447 2026-01 Other Mercedes-Benz A Class Silver Driving without Due Care and Attention None A38 A38 Birmingham Birmingham NFA No Independent Evidence Available      
10988 op-snap---monthly-publication-january-2026.pdf   449 2026-01 Pedestrian Audi A3 Blue Driving without Due Care and Attention None Boleyn Road Boleyn Road Birmingham Birmingham NFA No Offence   52.4030543 -2.0296756
10990 op-snap---monthly-publication-january-2026.pdf   451 2026-01 car Peugeot 107 Black Driving without Due Care and Attention None Tyburn Island, Chester Road Tyburn Island, Chester Road Birmingham Birmingham Education N/A      
10994 op-snap---monthly-publication-january-2026.pdf   455 2026-01 Pedal Bike Audi A3 Blue Driving without Due Care and Attention None Camp Hill Circus Camp Hill Circus Birmingham Birmingham Education N/A   52.4682339 -1.8793662
11008 op-snap---monthly-publication-january-2026.pdf   469 2026-01 Car Nissan Juke Black Driving without Due Care and Attention None Bolton Road at Arthur Street Bolton Road at Arthur Street Birmingham Birmingham Education N/A   52.4667482 -1.8642338
11011 op-snap---monthly-publication-january-2026.pdf   472 2026-01 Car BMW 1 Series Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
11015 op-snap---monthly-publication-january-2026.pdf   476 2026-01 Car BMW M3 Black Driving without Due Care and Attention None Hamstead Road Hamstead Road Birmingham Birmingham NFA No Independent Evidence Available   52.505832 -1.92002
11020 op-snap---monthly-publication-january-2026.pdf   481 2026-01 Car Volkswagen Tiguan Black Driving without Due Care and Attention None A452 Collector Road Collector Road Birmingham Birmingham Fixed Penalty N/A   52.5139393 -1.7600186
11027 op-snap---monthly-publication-january-2026.pdf   488 2026-01 Car Suzuki GSXS 125 Black Driving without Due Care and Attention Drive otherwise than in accordance with a licence Bristol Road South Bristol Road South Birmingham Birmingham Court N/A   52.4119174 -1.9735247
11029 op-snap---monthly-publication-january-2026.pdf   490 2026-01 Car Renault Traffic White Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
11030 op-snap---monthly-publication-january-2026.pdf   491 2026-01 Car Kia Sportage Black Driving without Due Care and Attention None Hollywell Road Hollywell Road Birmingham Birmingham NFA No Independent Evidence Available   52.4594803 -1.7866201
11035 op-snap---monthly-publication-january-2026.pdf   496 2026-01 Other Mercedes-Benz sprinter White Driving without Due Care and Attention None Arden Road Arden Road Birmingham Birmingham Fixed Penalty N/A   52.4515759 -1.8296192
11037 op-snap---monthly-publication-january-2026.pdf   498 2026-01 Car Toyota Corolla Black Driving without Due Care and Attention None Linden Lea junction Linden Lea junction Birmingham Birmingham NFA No Independent Evidence Available      
11040 op-snap---monthly-publication-january-2026.pdf   501 2026-01 Car Fiat Ducato White Driving without Due Care and Attention None Bushwood Road Bushwood Road Birmingham Birmingham RTC - Actioned N/A   52.4369115 -1.9584265
11043 op-snap---monthly-publication-january-2026.pdf   504 2026-01 Pedal Bike Volkswagen Tiguan White Driving without Due Care and Attention None Brook Lane Brook Lane Birmingham Birmingham Education N/A   52.4297007 -1.8668846
11050 op-snap---monthly-publication-january-2026.pdf   511 2026-01 Car Toyota Corolla silver Driving without Due Care and Attention None Sutton Road, Erdington Sutton Road, Erdington Birmingham Birmingham Court N/A   52.5339483 -1.8285296
11064 op-snap---monthly-publication-january-2026.pdf   525 2026-01 Car Land Rover Range Blue Driving without Due Care and Attention None Charles Road Charles Road Birmingham Birmingham NFA No Independent Evidence Available   52.5094492 -1.9113648
11067 op-snap---monthly-publication-january-2026.pdf   528 2026-01 Car Toyota Avensis Blue Driving without Due Care and Attention None Berkeley Road East Berkeley Road East Birmingham Birmingham Education N/A   52.4658801 -1.8290005
11070 op-snap---monthly-publication-january-2026.pdf   531 2026-01 Car Ford Fiesta Blue Driving without Due Care and Attention None Dogpool Lane Dogpool Lane Birmingham Birmingham Education N/A   52.4373055 -1.9126748
11080 op-snap---monthly-publication-january-2026.pdf   541 2026-01 Pedal Bike Honda Jazz Blue Driving without Due Care and Attention None Slade Road, Edgbaston Slade Road, Edgbaston Birmingham Birmingham Education N/A      
11087 op-snap---monthly-publication-january-2026.pdf   548 2026-01 Car Mercedes-Benz C220 Silver Driving without Due Care and Attention None Shirley Road Shirley Road Birmingham Birmingham Education N/A   52.4198291 -1.9241732
11091 op-snap---monthly-publication-january-2026.pdf   552 2026-01 Pedal Bike BMW z4 Red Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
11097 op-snap---monthly-publication-january-2026.pdf   558 2026-01 Pedal Bike Ford Kuga Silver Driving without Due Care and Attention None Eachway Lane Eachway Lane Birmingham Birmingham Education N/A   52.3882492 -2.0091218
11109 op-snap---monthly-publication-january-2026.pdf   570 2026-01 Pedal Bike Lexus UX250 Black Driving without Due Care and Attention None Northfield Road Northfield Road Birmingham Birmingham Education N/A   52.4167654 -1.9411244
11118 op-snap---monthly-publication-january-2026.pdf   579 2026-01 Car Daf Lorry White Driving without Due Care and Attention None M6 exit to A38 M6 exit to A38 Birmingham Birmingham NFA No Independent Evidence Available      
11132 op-snap---monthly-publication-january-2026.pdf   593 2026-01 Pedestrian Peugeot 307.. Silver Driving without Due Care and Attention No Insurance Stonor Road Stonor Road Birmingham Birmingham Court N/A   52.4176973 -1.8351247
11145 op-snap---monthly-publication-january-2026.pdf   606 2026-01 Car BMW M3 White Driving without Due Care and Attention Contravening a Red Traffic Light Linden Rd Linden Road Birmingham Birmingham Court N/A   52.4263156 -1.9351622
11160 op-snap---monthly-publication-january-2026.pdf   621 2026-01 Car BMW 220d White Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Fixed Penalty N/A   52.4656414 -1.9852276
11164 op-snap---monthly-publication-january-2026.pdf   625 2026-01 Car Toyota Prius White Driving without Due Care and Attention Driving without Due Care and Attention Five Ways Roundabout, Birmingham Five Ways Roundabout, Birmingham Birmingham Birmingham Court N/A      
11172 op-snap---monthly-publication-january-2026.pdf   633 2026-01 Car BMW X1 White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
11173 op-snap---monthly-publication-january-2026.pdf   634 2026-01 Car Citroen Dispatch White Driving without Due Care and Attention None Kingstanding Road Kingstanding Road Birmingham Birmingham RTC - Actioned N/A   52.5521118 -1.8845138
11180 op-snap---monthly-publication-january-2026.pdf   641 2026-01 Car Toyota Aygo Purple Driving without Due Care and Attention None Yardley Green Road Yardley Green Road Birmingham Birmingham Fixed Penalty N/A   52.4764154 -1.8311418
11204 op-snap---monthly-publication-january-2026.pdf   665 2026-01 Car Toyota Prius Black Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4726661 -1.8769032
11206 op-snap---monthly-publication-january-2026.pdf   667 2026-01 Car Audi A5 Grey Driving without Due Care and Attention None Golden Hillock Road Golden Hillock Road Birmingham Birmingham Court N/A   52.4622646 -1.8599985
11208 op-snap---monthly-publication-january-2026.pdf   669 2026-01 Car Nissan Qashqai Black Driving without Due Care and Attention None Washwood Heath Road Washwood Heath Road Birmingham Birmingham Court N/A   52.4929304 -1.8229092
11213 op-snap---monthly-publication-january-2026.pdf   674 2026-01 Pedal Bike Mg hatchback White Driving without Due Care and Attention None Lickey Road Lickey Road Birmingham Birmingham NFA No Independent Evidence Available   52.3868298 -2.0003781
11229 op-snap---monthly-publication-january-2026.pdf   690 2026-01 Car Volkswagen Polo Black Driving without Due Care and Attention None Gerrards Street, Lozells Gerrards Street, Lozells Birmingham Birmingham Education N/A      
11232 op-snap---monthly-publication-january-2026.pdf   693 2026-01 Car Volkswagen Tiguan White Driving without Due Care and Attention None Lozells Road Lozells Road Birmingham Birmingham NFA No Offence   52.502683 -1.9033516
11235 op-snap---monthly-publication-january-2026.pdf   696 2026-01 Car Nissan Micra White Driving without Due Care and Attention None Six Ways RA, Aston Six Ways RA, Aston Birmingham Birmingham NFA No Offence      
11244 op-snap---monthly-publication-january-2026.pdf   705 2026-01 Car Audi A3 Black Driving without Due Care and Attention None A4540 Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham Education N/A   52.4861917 -1.8829748
11245 op-snap---monthly-publication-january-2026.pdf   706 2026-01 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Pershore Road South, Kings Norton Pershore Road South, Kings Norton Birmingham Birmingham Education N/A   52.4116071 -1.9297714
11256 op-snap---monthly-publication-january-2026.pdf   717 2026-01 Car Mercedes-Benz CLA200 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham NFA No Offence   52.4203897 -1.8338574
11259 op-snap---monthly-publication-january-2026.pdf   720 2026-01 Car Renault Trafic Silver Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham Warning Letter N/A   52.5194011 -1.8008643
11261 op-snap---monthly-publication-january-2026.pdf   722 2026-01 Car Vauxhall Astra Black Driving without Due Care and Attention None Tyburn Island Tyburn Island Birmingham Birmingham NFA No VRM   52.5193542 -1.800381
11281 op-snap---monthly-publication-january-2026.pdf   742 2026-01 Pedal Bike BMW 320D White Driving without Due Care and Attention None Wrentham Street Wrentham Street Birmingham Birmingham Education N/A   52.4708757 -1.8966158
11283 op-snap---monthly-publication-january-2026.pdf   744 2026-01 Pedal Bike Volkswagen Passat Black Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Education N/A   52.4543565 -1.9114004
11286 op-snap---monthly-publication-january-2026.pdf   747 2026-01 Pedal Bike Volvo XC40 Black Driving without Due Care and Attention None Augustus Road Augustus Road Birmingham Birmingham NFA No Offence   52.4695793 -1.9378608
11291 op-snap---monthly-publication-january-2026.pdf   752 2026-01 Car Toyota C-HR Grey Driving without Due Care and Attention None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658

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