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

363 rows where council_area = "Birmingham", disposal = "NFA" and offence = "Misc - Non Traffic Offences" 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 7

offence 1

  • Misc - Non Traffic Offences · 363 ✖

disposal 1

  • NFA · 363 ✖

council_area 1

  • Birmingham · 363 ✖
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
7451 op-snap---monthly-publication-february-2026.pdf   198 2026-02 Car   multiple   Misc - Non Traffic Offences None Willes Road Willes Road Birmingham Birmingham NFA Misc Inc Crimes   52.4964973 -1.9367016
7516 op-snap---monthly-publication-february-2026.pdf   263 2026-02 Pedestrian Scania Lorry Yellow Misc - Non Traffic Offences None Avenue Road Avenue Road Birmingham Birmingham NFA No Offence   52.4941712 -1.8795158
7565 op-snap---monthly-publication-february-2026.pdf   312 2026-02 Pedestrian Volkswagen Polo Silver Misc - Non Traffic Offences None Hamlet Road Hamlet Road Birmingham Birmingham NFA No Independent Evidence Available   52.4315327 -1.8421334
7584 op-snap---monthly-publication-february-2026.pdf   331 2026-02 Other Nissan Xtrail Orange Misc - Non Traffic Offences None Unett Street Unett Street Birmingham Birmingham NFA No Offence   52.4921149 -1.9071925
7605 op-snap---monthly-publication-february-2026.pdf   352 2026-02 Car Mini Cooper Grey Misc - Non Traffic Offences None Harborne Lane Harborne Lane Birmingham Birmingham NFA No Offence   52.4468464 -1.9454816
7686 op-snap---monthly-publication-february-2026.pdf   433 2026-02 Pedestrian Toyota CHR White Misc - Non Traffic Offences None Robin Hood Lane Robin Hood Lane Birmingham Birmingham NFA No Offence   52.4221526 -1.8425617
7880 op-snap---monthly-publication-february-2026.pdf   627 2026-02 Other Skoda Kodiaq White Misc - Non Traffic Offences None Welhead Road Welhead Road Birmingham Birmingham NFA No Offence      
7881 op-snap---monthly-publication-february-2026.pdf   628 2026-02 Other   multiple   Misc - Non Traffic Offences None Perry Barr Village Perry Barr Village Birmingham Birmingham NFA No Offence   52.5243314 -1.8819868
7999 op-snap---monthly-publication-february-2026.pdf   746 2026-02 Pedestrian Vauxhall Mokka Blue Misc - Non Traffic Offences None Bristol Road Bristol Road Birmingham Birmingham NFA No Independent Evidence Available   52.4543565 -1.9114004
8136 op-snap---monthly-publication-february-2026.pdf   883 2026-02 Car Nissan Juke Red Misc - Non Traffic Offences None St Marys Row Street Marys Row Birmingham Birmingham NFA Not in Public Interest      
8183 op-snap---monthly-publication-february-2026.pdf   930 2026-02 Car       Misc - Non Traffic Offences None Vicarage Road Vicarage Road Birmingham Birmingham NFA No Offence   52.470423 -1.9304786
8356 op-snap---monthly-publication-february-2026.pdf   1103 2026-02 Other Ford Fiesta Blue Misc - Non Traffic Offences None Star City Star City Birmingham Birmingham NFA No Offence   52.5054363 -1.8556273
8409 op-snap---monthly-publication-february-2026.pdf   1156 2026-02 Pedestrian Toyota Rav 4 Green Misc - Non Traffic Offences No Insurance Woodstock Road Woodstock Road Birmingham Birmingham NFA Not in Public Interest   52.4486205 -1.8740822
8559 op-snap---monthly-publication-february-2026.pdf   1306 2026-02 Car Seat Leon Black Misc - Non Traffic Offences None Bristol Road Bristol Road Birmingham Birmingham NFA No VRM   52.4543565 -1.9114004
8630 op-snap---monthly-publication-february-2026.pdf   1377 2026-02 Car Vauxhall insignia Grey Misc - Non Traffic Offences None granthan road Granthan Road Birmingham Birmingham NFA Misc Inc Crimes      
8647 op-snap---monthly-publication-february-2026.pdf   1394 2026-02 Car Audi   Black Misc - Non Traffic Offences None washwood heath road Washwood Heath Road Birmingham Birmingham NFA Misc Inc Crimes   52.4929304 -1.8229092
8715 op-snap---monthly-publication-february-2026.pdf   1462 2026-02 Pedestrian Lamborghini urus Black Misc - Non Traffic Offences None rockingham gardens Rockingham Gardens Birmingham Birmingham NFA Misc Inc Crimes   52.5690681 -1.8271174
8793 op-snap---monthly-publication-february-2026.pdf   1540 2026-02 Car       Misc - Non Traffic Offences None np Np Birmingham Birmingham NFA Misc Inc Crimes      
8846 op-snap---monthly-publication-february-2026.pdf   1593 2026-02 Car Mercedes-Benz slk White Misc - Non Traffic Offences None lower queen street Lower Queen Street Birmingham Birmingham NFA Misc Inc Crimes   52.5603978 -1.8227403
8847 op-snap---monthly-publication-february-2026.pdf   1594 2026-02 Car Nissan qashqai Grey Misc - Non Traffic Offences None lower queen street Lower Queen Street Birmingham Birmingham NFA Misc Inc Crimes   52.5603978 -1.8227403
8851 op-snap---monthly-publication-february-2026.pdf   1598 2026-02 Pedestrian Vauxhall corsa Grey Misc - Non Traffic Offences None birmingham road Birmingham Road Birmingham Birmingham NFA Misc Inc Crimes   52.5505398 -1.8252993
8857 op-snap---monthly-publication-february-2026.pdf   1604 2026-02 Pedal Bike Volkswagen caddy Black Misc - Non Traffic Offences None black haynes road Black Haynes Road Birmingham Birmingham NFA Misc Inc Crimes   52.4260755 -1.9679443
8862 op-snap---monthly-publication-february-2026.pdf   1609 2026-02 Pedestrian Volkswagen passat Silver Misc - Non Traffic Offences None holly lane Holly Lane Birmingham Birmingham NFA Misc Inc Crimes   52.5236889 -1.8253311
10586 op-snap---monthly-publication-january-2026.pdf   47 2026-01 Pedestrian Audi r8 Black Misc - Non Traffic Offences None bishopsgate street Bishopsgate Street Birmingham Birmingham NFA Misc Inc Crimes   52.473986 -1.9147087
10589 op-snap---monthly-publication-january-2026.pdf   50 2026-01 Van Ford transit White Misc - Non Traffic Offences None m42 NB airport m42 Northbound airport Birmingham Birmingham NFA Misc Inc Crimes      
10591 op-snap---monthly-publication-january-2026.pdf   52 2026-01 Pedestrian       Misc - Non Traffic Offences None aldre drive Aldre Drive Birmingham Birmingham NFA Misc Inc Crimes      
10592 op-snap---monthly-publication-january-2026.pdf   53 2026-01 Pedestrian Toyota rav4 Green Misc - Non Traffic Offences None woodstock road Woodstock Road Birmingham Birmingham NFA No Offence   52.4486205 -1.8740822
10595 op-snap---monthly-publication-january-2026.pdf   56 2026-01 Pedal Bike Hyundai i10 Grey Misc - Non Traffic Offences None lower essex street Lower Essex Street Birmingham Birmingham NFA No Offence   52.4716178 -1.8954045
10616 op-snap---monthly-publication-january-2026.pdf   77 2026-01 Pedestrian Volkswagen polo Blue Misc - Non Traffic Offences None homelea road Homelea Road Birmingham Birmingham NFA No Offence   52.4711252 -1.8149195
10620 op-snap---monthly-publication-january-2026.pdf   81 2026-01 Pedestrian Other smart car Black Misc - Non Traffic Offences None woodstock road Woodstock Road Birmingham Birmingham NFA No Offence   52.4486205 -1.8740822
10622 op-snap---monthly-publication-january-2026.pdf   83 2026-01 Pedestrian Seat leon Grey Misc - Non Traffic Offences None woodstock road Woodstock Road Birmingham Birmingham NFA No Offence   52.4486205 -1.8740822
10626 op-snap---monthly-publication-january-2026.pdf   87 2026-01 Car Volkswagen golf Grey Misc - Non Traffic Offences None cox street Cox Street Birmingham Birmingham NFA No Independent Evidence Available   52.4864073 -1.905273
10627 op-snap---monthly-publication-january-2026.pdf   88 2026-01 Car Audi a4 Grey Misc - Non Traffic Offences None M6 SB J9 M6 Southbound J9 Birmingham Birmingham NFA Misc Inc Crimes   52.676119 -2.0858425
10849 op-snap---monthly-publication-january-2026.pdf   310 2026-01 Other   Unknown VRM   Misc - Non Traffic Offences None Kingstanding Circle Kingstanding Circle Birmingham Birmingham NFA No VRM   52.5536651 -1.8826944
10981 op-snap---monthly-publication-january-2026.pdf   442 2026-01 Pedestrian Vauxhall Viva Red Misc - Non Traffic Offences None Fontley Close Fontley Close Birmingham Birmingham NFA No Offence   52.4760797 -1.7952034
11257 op-snap---monthly-publication-january-2026.pdf   718 2026-01 Pedestrian Ford Focus Blue Misc - Non Traffic Offences None Freer Road Freer Road Birmingham Birmingham NFA No Offence   52.5074462 -1.8979307
11263 op-snap---monthly-publication-january-2026.pdf   724 2026-01 Pedestrian BMW 1 series Black Misc - Non Traffic Offences None Freer Road Freer Road Birmingham Birmingham NFA No Offence   52.5074462 -1.8979307
11296 op-snap---monthly-publication-january-2026.pdf   757 2026-01 Pedestrian BMW 116d White Misc - Non Traffic Offences None Maitland Road Maitland Road Birmingham Birmingham NFA No Offence   52.4868494 -1.8448776
11449 op-snap---monthly-publication-january-2026.pdf   910 2026-01 Pedestrian Peugeot 208 Pink Misc - Non Traffic Offences None Bells Lane Bells Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4053419 -1.8944602
11603 op-snap---monthly-publication-january-2026.pdf   1064 2026-01 Car Vauxhall Mokka Brown Misc - Non Traffic Offences None Friary Road / Oxhill Road junction Friary Road / Oxhill Road junction Birmingham Birmingham NFA No Offence   52.5162814 -1.9395798
11713 op-snap---monthly-publication-january-2026.pdf   1174 2026-01 Car Volkswagen Golf Grey Misc - Non Traffic Offences None Edgbaston Park Road Edgbaston Park Road Birmingham Birmingham NFA No Offence   52.4580375 -1.9261777
11902 op-snap---monthly-publication-january-2026.pdf   1363 2026-01 Other Ford Transit Grey Misc - Non Traffic Offences None ladywood Ladywood Birmingham Birmingham NFA Misc Inc Crimes   52.4774932 -1.9233654
11930 op-snap---monthly-publication-january-2026.pdf   1391 2026-01 Pedestrian       Misc - Non Traffic Offences None cambridge crescent Cambridge Crescent Birmingham Birmingham NFA Misc Inc Crimes   52.4652475 -1.9056734
11941 op-snap---monthly-publication-january-2026.pdf   1402 2026-01 Car Ford focus Grey Misc - Non Traffic Offences None eddish road Eddish Road Birmingham Birmingham NFA Misc Inc Crimes   52.4833672 -1.7871439
11947 op-snap---monthly-publication-january-2026.pdf   1408 2026-01 Pedestrian       Misc - Non Traffic Offences None Regent Place Regent Place Birmingham Birmingham NFA No VRM   52.4860376 -1.9095854
3901 op-snap---monthly-publication-december-2025.pdf   29 2025-12 Pedestrian Renault Scenic Blue Misc - Non Traffic Offences None Barton Drive Barton Drive Birmingham Birmingham NFA No Independent Evidence Available      
3970 op-snap---monthly-publication-december-2025.pdf   98 2025-12 Pedestrian Nissan qashqai White Misc - Non Traffic Offences None chilcote close Chilcote Close Birmingham Birmingham NFA Misc Inc Crimes   52.4167178 -1.8457291
3971 op-snap---monthly-publication-december-2025.pdf   99 2025-12 Pedestrian Land Rover discovery White Misc - Non Traffic Offences None chilcote close Chilcote Close Birmingham Birmingham NFA Misc Inc Crimes   52.4167178 -1.8457291
4178 op-snap---monthly-publication-december-2025.pdf   306 2025-12 Other Ford focus Black Misc - Non Traffic Offences None Arundel Road Arundel Road Birmingham Birmingham NFA No Offence   52.4032204 -1.8821733
4257 op-snap---monthly-publication-december-2025.pdf   385 2025-12 Pedestrian Vauxhall corsa Black Misc - Non Traffic Offences None fox hollies road Fox Hollies Road Birmingham Birmingham NFA Misc Inc Crimes   52.5517052 -1.7825505
4259 op-snap---monthly-publication-december-2025.pdf   387 2025-12 Pedestrian Skoda octavia Black Misc - Non Traffic Offences None cardigan street Cardigan Street Birmingham Birmingham NFA Misc Inc Crimes   52.4849063 -1.8846609
4260 op-snap---monthly-publication-december-2025.pdf   388 2025-12 Pedestrian Honda jazz Silver Misc - Non Traffic Offences None cardigan street Cardigan Street Birmingham Birmingham NFA Misc Inc Crimes   52.4849063 -1.8846609
4298 op-snap---monthly-publication-december-2025.pdf   426 2025-12 Pedestrian Other HGV White Misc - Non Traffic Offences None northfield road Northfield Road Birmingham Birmingham NFA Misc Inc Crimes   52.4167654 -1.9411244
4437 op-snap---monthly-publication-december-2025.pdf   565 2025-12 Other Volkswagen     Misc - Non Traffic Offences None edmund road Edmund Road Birmingham Birmingham NFA Misc Inc Crimes   52.4876113 -1.8542201
4439 op-snap---monthly-publication-december-2025.pdf   567 2025-12 Pedestrian BMW   Red Misc - Non Traffic Offences None cambridge road Cambridge Road Birmingham Birmingham NFA Misc Inc Crimes   52.4368662 -1.8846451
4440 op-snap---monthly-publication-december-2025.pdf   568 2025-12 Pedestrian Audi a4 White Misc - Non Traffic Offences None chilcote close Chilcote Close Birmingham Birmingham NFA Misc Inc Crimes   52.4167178 -1.8457291
4445 op-snap---monthly-publication-december-2025.pdf   573 2025-12 Pedestrian Citroen ds3 White Misc - Non Traffic Offences None allens croft road Allens Croft Road Birmingham Birmingham NFA Misc Inc Crimes   52.4242527 -1.910803
4462 op-snap---monthly-publication-december-2025.pdf   590 2025-12 Pedestrian Mg ZS Blue Misc - Non Traffic Offences None Teazel Avenue Teazel Avenue Birmingham Birmingham NFA No Offence   52.4247795 -1.9433534
4483 op-snap---monthly-publication-december-2025.pdf   611 2025-12 Car Volkswagen Tiguan Grey Misc - Non Traffic Offences None A45 A45 Birmingham Birmingham NFA No Independent Evidence Available      
4491 op-snap---monthly-publication-december-2025.pdf   619 2025-12 Pedestrian Volkswagen troc White Misc - Non Traffic Offences None antrobus road Antrobus Road Birmingham Birmingham NFA Misc Inc Crimes   52.5457851 -1.8457052
4510 op-snap---monthly-publication-december-2025.pdf   638 2025-12 Pedestrian Vauxhall mokka Gold Misc - Non Traffic Offences None antrobus road Antrobus Road Birmingham Birmingham NFA Misc Inc Crimes   52.5457851 -1.8457052
4512 op-snap---monthly-publication-december-2025.pdf   640 2025-12 Pedestrian BMW 3 series Black Misc - Non Traffic Offences None whittington oval Whittington Oval Birmingham Birmingham NFA Misc Inc Crimes   52.4800782 -1.7942034
4536 op-snap---monthly-publication-december-2025.pdf   664 2025-12 Other Peugeot 208 White Misc - Non Traffic Offences None Merlin Grove Merlin Grove Birmingham Birmingham NFA No Offence   52.4578935 -1.7820619
4558 op-snap---monthly-publication-december-2025.pdf   686 2025-12 Pedestrian       Misc - Non Traffic Offences None np Np Birmingham Birmingham NFA Misc Inc Crimes      
4559 op-snap---monthly-publication-december-2025.pdf   687 2025-12 Pedestrian       Misc - Non Traffic Offences None np Np Birmingham Birmingham NFA Misc Inc Crimes      
4563 op-snap---monthly-publication-december-2025.pdf   691 2025-12 Pedestrian Volkswagen van Black Misc - Non Traffic Offences None vicaridge road Vicaridge Road Birmingham Birmingham NFA Misc Inc Crimes      
4564 op-snap---monthly-publication-december-2025.pdf   692 2025-12 Pedestrian       Misc - Non Traffic Offences None UK Uk Birmingham Birmingham NFA Misc Inc Crimes   52.45124 -1.937937
4594 op-snap---monthly-publication-december-2025.pdf   722 2025-12 Car       Misc - Non Traffic Offences None startford road Stratford Road Birmingham Birmingham NFA Misc Inc Crimes   52.4203897 -1.8338574
4596 op-snap---monthly-publication-december-2025.pdf   724 2025-12 Car Volvo xc90 Grey Misc - Non Traffic Offences None birchfield road Birchfield Road Birmingham Birmingham NFA Misc Inc Crimes   52.5170745 -1.9012542
4612 op-snap---monthly-publication-december-2025.pdf   740 2025-12 Pedestrian Toyota corolla White Misc - Non Traffic Offences None clarence road Clarence Road Birmingham Birmingham NFA Misc Inc Crimes   52.5940902 -1.843503
4652 op-snap---monthly-publication-december-2025.pdf   780 2025-12 Pedestrian Vauxhall astra Blue Misc - Non Traffic Offences None richard atreet Richard Atreet Birmingham Birmingham NFA Misc Inc Crimes      
4683 op-snap---monthly-publication-december-2025.pdf   811 2025-12 Car Volkswagen Polo Black Misc - Non Traffic Offences None Garretts Green Lane Garretts Green Lane Birmingham Birmingham NFA No Offence   52.4675802 -1.7905748
4684 op-snap---monthly-publication-december-2025.pdf   812 2025-12 Pedestrian Mercedes-Benz A Class Grey Misc - Non Traffic Offences None Eddish Road Eddish Road Birmingham Birmingham NFA No Offence   52.4833672 -1.7871439
4732 op-snap---monthly-publication-december-2025.pdf   860 2025-12 Pedestrian   Daimler White Misc - Non Traffic Offences None Elmdon Road Elmdon Road Birmingham Birmingham NFA No Offence   52.4418657 -1.9240253
4733 op-snap---monthly-publication-december-2025.pdf   861 2025-12 Pedestrian Volkswagen   Black Misc - Non Traffic Offences None Elmdon Road Elmdon Road Birmingham Birmingham NFA No Offence   52.4418657 -1.9240253
4768 op-snap---monthly-publication-december-2025.pdf   896 2025-12 Car Volkswagen TAIGO Green Misc - Non Traffic Offences None sainsburys castle vale Sainsburys Castle Vale Birmingham Birmingham NFA No Independent Evidence Available   52.5168269 -1.7940387
4785 op-snap---monthly-publication-december-2025.pdf   913 2025-12 Pedestrian Toyota Prius White Misc - Non Traffic Offences None St Mary's Row, Moseley Street Mary's Row, Moseley Birmingham Birmingham NFA Misc Inc Crimes      
4817 op-snap---monthly-publication-december-2025.pdf   945 2025-12 Pedal Bike Ford Focus Black Misc - Non Traffic Offences Driving without Due Care and M Atatsesnhtoiounse Lane, Kings Norton M Atatsesnhtoiounse Lane, Kings Norton Birmingham Birmingham NFA Misc Inc Crimes      
4823 op-snap---monthly-publication-december-2025.pdf   951 2025-12 Car Hyundai Ioniq Black Misc - Non Traffic Offences None Alridge Road Aldridge Road Birmingham Birmingham NFA No Offence   52.5368764 -1.8976461
4824 op-snap---monthly-publication-december-2025.pdf   952 2025-12 Car Vauxhall Vivaro Blue Misc - Non Traffic Offences None Startford Road Stratford Road Birmingham Birmingham NFA No VRM   52.4203897 -1.8338574
4893 op-snap---monthly-publication-december-2025.pdf   1021 2025-12 Car Seat Leon Black Misc - Non Traffic Offences none A4040 Island Road Island Road Birmingham Birmingham NFA Misc Inc Crimes   52.5095686 -1.9544485
4945 op-snap---monthly-publication-december-2025.pdf   1073 2025-12 Pedestrian Ford transit White Misc - Non Traffic Offences None outmore road Outmore Road Birmingham Birmingham NFA Misc Inc Crimes   52.4767211 -1.7814678
4953 op-snap---monthly-publication-december-2025.pdf   1081 2025-12 Pedestrian Seat Leon Black Misc - Non Traffic Offences None wyrley road Wyrley Road Birmingham Birmingham NFA Misc Inc Crimes   52.5172973 -1.8785949
4971 op-snap---monthly-publication-december-2025.pdf   1099 2025-12 Pedestrian Renault captur Black Misc - Non Traffic Offences None petersfield road Petersfield Road Birmingham Birmingham NFA Misc Inc Crimes   52.4307 -1.8494663
4972 op-snap---monthly-publication-december-2025.pdf   1100 2025-12 Pedal Bike Kia picanto White Misc - Non Traffic Offences None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
4973 op-snap---monthly-publication-december-2025.pdf   1101 2025-12 Pedal Bike Seat leon Black Misc - Non Traffic Offences None bradford street Bradford Street Birmingham Birmingham NFA Misc Inc Crimes   52.4708802 -1.8792135
5022 op-snap---monthly-publication-december-2025.pdf   1150 2025-12 Pedestrian BMW 520D Black Misc - Non Traffic Offences None robin hall lane Robin Hall Lane Birmingham Birmingham NFA Misc Inc Crimes   52.4227193 -1.8439628
5023 op-snap---monthly-publication-december-2025.pdf   1151 2025-12 Pedestrian Vauxhall grandland White Misc - Non Traffic Offences None robin hood lane Robin Hood Lane Birmingham Birmingham NFA Misc Inc Crimes   52.4221526 -1.8425617
5024 op-snap---monthly-publication-december-2025.pdf   1152 2025-12 Pedestrian Mercedes-Benz cls350 White Misc - Non Traffic Offences None sheldon Sheldon Birmingham Birmingham NFA Misc Inc Crimes   52.4533229 -1.778016
5105 op-snap---monthly-publication-december-2025.pdf   1233 2025-12 Pedestrian Fiat 500 White Misc - Non Traffic Offences None Dallington Road Dallington Road Birmingham Birmingham NFA No Independent Evidence Available      
5133 op-snap---monthly-publication-december-2025.pdf   1261 2025-12 Pedestrian BMW 3 Series Blue Misc - Non Traffic Offences None Salisbury Road Salisbury Road Birmingham Birmingham NFA No Independent Evidence Available   52.4943878 -1.8504211
20500 op-snap---monthly-publication-november-2025.pdf   42 2025-11 Car Mercedes-Benz Vito Black Misc - Non Traffic Offences None Bordesley Circus Bordesley Circus Birmingham Birmingham NFA No Offence   52.4728608 -1.8754722
20656 op-snap---monthly-publication-november-2025.pdf   198 2025-11 Lorry       Misc - Non Traffic Offences None M6 M6 Birmingham Birmingham NFA Misc Inc Crimes      
20727 op-snap---monthly-publication-november-2025.pdf   269 2025-11 Car Vauxhall Insignia Brown Misc - Non Traffic Offences None Richmond Road Richmond Road Birmingham Birmingham NFA No Offence   52.566947 -1.8291809
20853 op-snap---monthly-publication-november-2025.pdf   395 2025-11 Car BMW X5 Grey Misc - Non Traffic Offences None Spitfire Island Spitfire Island Birmingham Birmingham NFA No Offence   52.5138106 -1.797297
20862 op-snap---monthly-publication-november-2025.pdf   404 2025-11 Car Ford cmax Black Misc - Non Traffic Offences None gilpin close Gilpin Close Birmingham Birmingham NFA Misc Inc Crimes   52.4990396 -1.8229018
20987 op-snap---monthly-publication-november-2025.pdf   529 2025-11 Pedestrian Honda frv Grey Misc - Non Traffic Offences None Longbridge Longbridge Birmingham Birmingham NFA Misc Inc Crimes   52.3940521 -1.9807506
20989 op-snap---monthly-publication-november-2025.pdf   531 2025-11 Pedestrian Volkswagen golf Black Misc - Non Traffic Offences None alderbrook road Alderbrook Road Birmingham Birmingham NFA Misc Inc Crimes      
20997 op-snap---monthly-publication-november-2025.pdf   539 2025-11 Car Audi a7 Black Misc - Non Traffic Offences None salford circus Salford Circus Birmingham Birmingham NFA Misc Inc Crimes   52.5095071 -1.8593732
21047 op-snap---monthly-publication-november-2025.pdf   589 2025-11 Pedestrian       Misc - Non Traffic Offences None goodyear road Goodyear Road Birmingham Birmingham NFA No Independent Evidence Available      

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