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

378 rows where council_area = "Birmingham", disposal = "NFA" 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

vehicle_make >30

reporter_transport_mode 4

offence 1

  • Driving without Reasonable Consideration · 378 ✖

disposal 1

  • NFA · 378 ✖

council_area 1

  • Birmingham · 378 ✖
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
7412 op-snap---monthly-publication-february-2026.pdf   159 2026-02 Car Peugeot 208 Grey Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
7964 op-snap---monthly-publication-february-2026.pdf   711 2026-02 Car Audi A3 Red Driving without Reasonable Consideration None Queslett Road / Kings Road Queslett Road / Kings Road Birmingham Birmingham NFA No Offence   52.5461661 -1.9204363
8771 op-snap---monthly-publication-february-2026.pdf   1518 2026-02 Car Toyota Prius White Driving without Reasonable Consideration None Newton Road Great Barr Newton Road Great Barr Birmingham Birmingham NFA No Independent Evidence Available   52.5429259 -1.9534939
20489 op-snap---monthly-publication-november-2025.pdf   31 2025-11 Car Jaecoo Delux Black Driving without Reasonable Consideration None M42 Solihull M42 Solihull Birmingham Birmingham NFA No Offence   52.4711059 -1.8461809
22095 op-snap---monthly-publication-october-2025.pdf   45 2025-10 Pedal Bike Volkswagen ID Yellow Driving without Reasonable Consideration None Weoley Park Weoley Park Birmingham Birmingham NFA No Offence   52.4353726 -1.9460178
23909 op-snap---monthly-publication-september-2025.pdf   128 2025-09 Pedal Bike Skoda Rapid Grey Driving without Reasonable Consideration None New Street New Street Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.4791344 -1.8986915
23979 op-snap---monthly-publication-september-2025.pdf   198 2025-09 Car Toyota Yaris Black Driving without Reasonable Consideration None Coventry Road, Small Heath Coventry Road, Small Heath Birmingham Birmingham NFA No Offence   52.4650893 -1.8425008
24332 op-snap---monthly-publication-september-2025.pdf   551 2025-09 Car Mercedes-Benz Smart Car Black Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham NFA No Offence   52.4470686 -1.8880749
24879 op-snap---monthly-publication-september-2025.pdf   1098 2025-09 Car Peugeot Expert White Driving without Reasonable Consideration None Monument Road Monument Road Birmingham Birmingham NFA No Offence   52.4731312 -1.930947
2275 op-snap---monthly-publication-august-2025.pdf   250 2025-08 Car Toyota Prius Silver Driving without Reasonable Consideration None Alum Rock Road Alum Rock Road Birmingham Birmingham NFA No Offence   52.4883936 -1.8310056
2303 op-snap---monthly-publication-august-2025.pdf   278 2025-08 Pedal Bike Volkswagen UP White Driving without Reasonable Consideration None Yardley Wood Road Yardley Wood Road Birmingham Birmingham NFA No Offence   52.4103191 -1.8670224
2388 op-snap---monthly-publication-august-2025.pdf   363 2025-08 Car Volkswagen Golf Grey Driving without Reasonable Consideration None Heybarnes Road Heybarnes Road Birmingham Birmingham NFA No Independent Evidence Available   52.4677423 -1.8351236
2797 op-snap---monthly-publication-august-2025.pdf   772 2025-08 Pedal Bike Toyota Prius Silver Driving without Reasonable Consideration None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham NFA No Independent Evidence Available   52.4094108 -1.9930633
2816 op-snap---monthly-publication-august-2025.pdf   791 2025-08 Car Audi A5 Black Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA Outside of 14 DAYS Late Submission   52.5919543 -1.8517118
2914 op-snap---monthly-publication-august-2025.pdf   889 2025-08 Car Kia   Grey Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham NFA No Offence   52.4543565 -1.9114004
2933 op-snap---monthly-publication-august-2025.pdf   908 2025-08 Car Audi Q3 Blue Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham NFA No Offence   52.5919543 -1.8517118
2996 op-snap---monthly-publication-august-2025.pdf   971 2025-08 Pedal Bike BMW 118 Black Driving without Reasonable Consideration No Insurance Holders Lane Holders Lane Birmingham Birmingham NFA No Independent Evidence Available   52.4446701 -1.9056872
3153 op-snap---monthly-publication-august-2025.pdf   1128 2025-08 Car Citroen Relay Grey Driving without Reasonable Consideration None Coleshill Road Coleshill Road Birmingham Birmingham NFA No Offence   52.4967329 -1.8097462
11962 op-snap---monthly-publication-july-2025.pdf   14 2025-07 Car Nissan Micra Red Driving without Reasonable Consideration None Alcester Road Alcester Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4470686 -1.8880749
12085 op-snap---monthly-publication-july-2025.pdf   137 2025-07 Car Honda jazz Blue Driving without Reasonable Consideration None Shenley Fields Road Shenley Fields Road Birmingham Birmingham NFA No Offence   52.4373076 -1.9543847
12148 op-snap---monthly-publication-july-2025.pdf   200 2025-07 Car Ford Fiesta Yellow Driving without Reasonable Consideration None Queen Elizabeth Hospital Queen Elizabeth Hospital Birmingham Birmingham NFA Outside of 14 Days NIP   52.4517147 -1.9423655
12199 op-snap---monthly-publication-july-2025.pdf   251 2025-07 Car Toyota Police car White Driving without Reasonable Consideration None Anderton Park Road Anderton Park Road Birmingham Birmingham NFA No Offence   52.4481342 -1.8776139
12304 op-snap---monthly-publication-july-2025.pdf   356 2025-07 Car Ford Mondeo Black Driving without Reasonable Consideration None Coventry Coventry Birmingham Birmingham NFA No Offence   52.4527138 -1.7656635
12588 op-snap---monthly-publication-july-2025.pdf   640 2025-07 Car BMW 4 series Black Driving without Reasonable Consideration None Chelmsley Wood Chelmsley Wood Birmingham Birmingham NFA No Offence      
12611 op-snap---monthly-publication-july-2025.pdf   663 2025-07 Car Volkswagen Golf White Driving without Reasonable Consideration None Birchfield Road Birchfield Road Birmingham Birmingham NFA No Offence   52.5170745 -1.9012542
12612 op-snap---monthly-publication-july-2025.pdf   664 2025-07 Car Seat Leon Silver Driving without Reasonable Consideration Use vehicle on a road without Bvairlcidh ftieesldt cReoratifdicate Bvairlcidh ftieesldt c Reoratifdicate Birmingham Birmingham NFA No Offence      
12649 op-snap---monthly-publication-july-2025.pdf   701 2025-07 Pedal Bike Citroen C3 White Driving without Reasonable Consideration None Witton Road Witton Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.513336 -1.8833226
12650 op-snap---monthly-publication-july-2025.pdf   702 2025-07 Pedal Bike Hyundai   Red Driving without Reasonable Consideration None Wellington Road Wellington Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5133725 -1.9193405
12651 op-snap---monthly-publication-july-2025.pdf   703 2025-07 Pedal Bike Seat Leon Green Driving without Reasonable Consideration None Wellinngton Road Wellinngton Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12652 op-snap---monthly-publication-july-2025.pdf   704 2025-07 Pedal Bike Nissan Qashqai Black Driving without Reasonable Consideration None Witton Road Witton Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.513336 -1.8833226
12653 op-snap---monthly-publication-july-2025.pdf   705 2025-07 Pedal Bike Skoda C3 Blue Driving without Reasonable Consideration None City Road City Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4763176 -1.9584897
12861 op-snap---monthly-publication-july-2025.pdf   913 2025-07 Car Mazda   Black Driving without Reasonable Consideration None Clifford Street , Newton Clifford Street , Newton Birmingham Birmingham NFA Outside of 14 Days NIP      
12866 op-snap---monthly-publication-july-2025.pdf   918 2025-07 Car Audi Estima Silver Driving without Reasonable Consideration None Somerville Road Somerville Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5555545 -1.8329387
12868 op-snap---monthly-publication-july-2025.pdf   920 2025-07 Car Volkswagen Polo White Driving without Reasonable Consideration None Kings Road , Tyseley ,Birmingham Kings Road , Tyseley , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4572996 -1.8391692
12869 op-snap---monthly-publication-july-2025.pdf   921 2025-07 Pedestrian BMW 420 White Driving without Reasonable Consideration None     Birmingham Birmingham NFA Outside of 14 Days NIP      
12870 op-snap---monthly-publication-july-2025.pdf   922 2025-07 Pedestrian Audi   Grey Driving without Reasonable Consideration None York Road , Birmingham York Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5231321 -1.8415573
12871 op-snap---monthly-publication-july-2025.pdf   923 2025-07 Pedestrian Toyota Yaris Black Driving without Reasonable Consideration None Bradford Road , Birmingham Bradford Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5024148 -1.7961753
12886 op-snap---monthly-publication-july-2025.pdf   938 2025-07 Car Audi A4 Black Driving without Reasonable Consideration None     Birmingham Birmingham NFA Outside of 14 Days NIP      
12889 op-snap---monthly-publication-july-2025.pdf   941 2025-07 Car BMW   Red Driving without Reasonable Consideration None York Road , Birmingham York Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5231321 -1.8415573
12890 op-snap---monthly-publication-july-2025.pdf   942 2025-07 Car Vauxhall Mokka Grey Driving without Reasonable Consideration None A4040 , Birmingham A4040 , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5150323 -1.9007149
12891 op-snap---monthly-publication-july-2025.pdf   943 2025-07 Car Audi   Black Driving without Reasonable Consideration None Warwick Road , Birmingham Warwick Road , Birmingham Birmingham Birmingham NFA Out of Force   52.551985 -1.860445
12892 op-snap---monthly-publication-july-2025.pdf   944 2025-07 Car Volvo   Black Driving without Reasonable Consideration None M6 Northbound M6 Northbound Birmingham Birmingham NFA Outside of 14 Days NIP      
12893 op-snap---monthly-publication-july-2025.pdf   945 2025-07 Car Vauxhall   Silver Driving without Reasonable Consideration None M5 Northbound M5 Northbound Birmingham Birmingham NFA Outside of 14 Days NIP      
12894 op-snap---monthly-publication-july-2025.pdf   946 2025-07 Car BMW   White Driving without Reasonable Consideration None M42 close to Junction 8 M42 close to Junction 8 Birmingham Birmingham NFA Outside of 14 Days NIP      
12917 op-snap---monthly-publication-july-2025.pdf   969 2025-07 Car Land Rover   Black Driving without Reasonable Consideration None M5 North M5 North Birmingham Birmingham NFA Outside of 14 Days NIP   52.5151103 -1.8501538
12918 op-snap---monthly-publication-july-2025.pdf   970 2025-07 Car Ford Transit Blue Driving without Reasonable Consideration None     Birmingham Birmingham NFA Outside of 14 Days NIP      
12924 op-snap---monthly-publication-july-2025.pdf   976 2025-07 Car Skoda Fabia Black Driving without Reasonable Consideration None Cole Hall Lane , Birmingham Cole Hall Lane , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4877244 -1.787883
12926 op-snap---monthly-publication-july-2025.pdf   978 2025-07 Pedestrian Ford Transit Silver Driving without Reasonable Consideration None Cole Hall Lane , Kitts Green Cole Hall Lane , Kitts Green Birmingham Birmingham NFA Outside of 14 Days NIP   52.4877244 -1.787883
12957 op-snap---monthly-publication-july-2025.pdf   1009 2025-07 Car Audi A8 Black Driving without Reasonable Consideration None Stratford Road , Birmingham Stratford Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4447583 -1.8592059
12960 op-snap---monthly-publication-july-2025.pdf   1012 2025-07 Car BMW   Silver Driving without Reasonable Consideration None Mini Roundabout , Bacchus Road Mini Roundabout , Bacchus Road Birmingham Birmingham NFA Outside of 14 Days NIP      
12961 op-snap---monthly-publication-july-2025.pdf   1013 2025-07 Car BMW 530d M Sport Black Driving without Reasonable Consideration None Star City , Birmingham Star City , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5054363 -1.8556273
12962 op-snap---monthly-publication-july-2025.pdf   1014 2025-07 Pedestrian Audi   Blue Driving without Reasonable Consideration None Newton Middleway , Birmingham Newton Middleway , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
12965 op-snap---monthly-publication-july-2025.pdf   1017 2025-07 Pedestrian Toyota Yaris Grey Driving without Reasonable Consideration None Paradise Street , Birmingham Paradise Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4790667 -1.9039768
12986 op-snap---monthly-publication-july-2025.pdf   1038 2025-07 Car Yamaha   Blue Driving without Reasonable Consideration None Chester Road North , Birmingham Chester Road North , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5666061 -1.879083
12996 op-snap---monthly-publication-july-2025.pdf   1048 2025-07 Car Volkswagen   White Driving without Reasonable Consideration None Umberslade Road , Birmingham Umberslade Road , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.4304526 -1.9216716
13032 op-snap---monthly-publication-july-2025.pdf   1084 2025-07 Car Audi A3 Grey Driving without Reasonable Consideration None Stecthford Lane , Birmingham Stecthford Lane , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
13059 op-snap---monthly-publication-july-2025.pdf   1111 2025-07 Car BMW   White Driving without Reasonable Consideration Contravening a Red Traffic Li gShhtaw Road , A463 g Shhtaw Road , A463 Birmingham Birmingham NFA Outside of 14 Days NIP      
13060 op-snap---monthly-publication-july-2025.pdf   1112 2025-07 Car Mercedes-Benz   Black Driving without Reasonable Consideration None Bromford Lane , Stetchford Bromford Lane , Stetchford Birmingham Birmingham NFA Outside of 14 Days NIP      
13062 op-snap---monthly-publication-july-2025.pdf   1114 2025-07 Car Volkswagen   White Driving without Reasonable Consideration None M42 Southbound M42 Southbound Birmingham Birmingham NFA Outside of 14 Days NIP      
13073 op-snap---monthly-publication-july-2025.pdf   1125 2025-07 Car Kia Cee'd Black Driving without Reasonable Consideration None Fort Parkway Fort Parkway Birmingham Birmingham NFA No Offence   52.50787 -1.8195713
13092 op-snap---monthly-publication-july-2025.pdf   1144 2025-07 Car Vauxhall   Black Driving without Reasonable Consideration None Near Selly Oak , Birmingham Near Selly Oak , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP      
13096 op-snap---monthly-publication-july-2025.pdf   1148 2025-07 Car Volkswagen Polo Black Driving without Reasonable Consideration None SChool Road , Yardley Wood SChool Road , Yardley Wood Birmingham Birmingham NFA Outside of 14 Days NIP   52.4161736 -1.8619692
13125 op-snap---monthly-publication-july-2025.pdf   1177 2025-07 Car   Van Red/White/ Blue Driving without Reasonable Consideration None     Birmingham Birmingham NFA Outside of 14 Days NIP      
13137 op-snap---monthly-publication-july-2025.pdf   1189 2025-07 Car BMW X 5 Black Driving without Reasonable Consideration None Vristol Road Southbound Vristol Road Southbound Birmingham Birmingham NFA Outside of 14 Days NIP      
13138 op-snap---monthly-publication-july-2025.pdf   1190 2025-07 Car Kia   Black Driving without Reasonable Consideration None Umberslade Street , Stirchley Umberslade Street , Stirchley Birmingham Birmingham NFA Outside of 14 Days NIP   52.4300702 -1.9217011
13142 op-snap---monthly-publication-july-2025.pdf   1194 2025-07 Pedal Bike Nissan   Grey Driving without Reasonable Consideration None Coleshill Street , Birmingham Coleshill Street , Birmingham Birmingham Birmingham NFA Outside of 14 Days NIP   52.5628847 -1.8201278
13143 op-snap---monthly-publication-july-2025.pdf   1195 2025-07 Car BMW i4 Saloon White Driving without Reasonable Consideration None Russell Road , Edgbaston Russell Road , Edgbaston Birmingham Birmingham NFA Outside of 14 Days NIP      
13150 op-snap---monthly-publication-july-2025.pdf   1202 2025-07 Car Ford Focus Silver Driving without Reasonable Consideration None Walsall Road , Perry Barr Walsall Road , Perry Barr Birmingham Birmingham NFA Outside of 14 Days NIP   52.5219655 -1.9010321
13178 op-snap---monthly-publication-july-2025.pdf   1230 2025-07 Car Volkswagen   Grey Driving without Reasonable Consideration None Vicarage Road , Moseley Vicarage Road , Moseley Birmingham Birmingham NFA Outside of 14 Days NIP   52.4301512 -1.8996659
13248 op-snap---monthly-publication-july-2025.pdf   1300 2025-07 Car Ford Galaxy Silver Driving without Reasonable Consideration No vehicle excise licence Queslett Road Queslett Road Birmingham Birmingham NFA No Offence   52.5458699 -1.9304484
14130 op-snap---monthly-publication-june-2025.pdf   59 2025-06 Car BMW 3 series Grey Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
14131 op-snap---monthly-publication-june-2025.pdf   60 2025-06 Car Fiat 500 Black Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham NFA No Independent Evidence Available   52.4308271 -1.920078
14135 op-snap---monthly-publication-june-2025.pdf   64 2025-06 Car Audi A4 Grey Driving without Reasonable Consideration None B4101 B4101 Birmingham Birmingham NFA No Offence   52.5079951 -1.9495377
14178 op-snap---monthly-publication-june-2025.pdf   107 2025-06 Pedal Bike Porsche 911 Blue Driving without Reasonable Consideration None Highlands Road Highlands Road Birmingham Birmingham NFA No Offence      
14248 op-snap---monthly-publication-june-2025.pdf   177 2025-06 Car   NP   Driving without Reasonable Consideration None Great Barr Great Barr Birmingham Birmingham NFA No VRM   52.5309945 -1.9288687
14257 op-snap---monthly-publication-june-2025.pdf   186 2025-06 Car Seat Ibiza White Driving without Reasonable Consideration None Mintague St Mintague Street Birmingham Birmingham NFA Not in Public Interest      
14265 op-snap---monthly-publication-june-2025.pdf   194 2025-06 Pedal Bike Hyundai I30.. White Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
14266 op-snap---monthly-publication-june-2025.pdf   195 2025-06 Pedal Bike Volkswagen Transporter White Driving without Reasonable Consideration None Chester Road Chester Road Birmingham Birmingham NFA No Offence   52.5359496 -1.8324115
14329 op-snap---monthly-publication-june-2025.pdf   258 2025-06 Car Volkswagen Touran Grey Driving without Reasonable Consideration None New John Street West New John Street West Birmingham Birmingham NFA Outside of 14 Days NIP   52.4944784 -1.9122329
14330 op-snap---monthly-publication-june-2025.pdf   259 2025-06 Car BMW 3 series Grey Driving without Reasonable Consideration No vehicle excise licence New John Street West New John Street West Birmingham Birmingham NFA Outside of 14 Days NIP   52.4944784 -1.9122329
14378 op-snap---monthly-publication-june-2025.pdf   307 2025-06 Car Toyota Prius White Driving without Reasonable Consideration None Hill Street Hill Street Birmingham Birmingham NFA No Offence   52.4777765 -1.901321
14418 op-snap---monthly-publication-june-2025.pdf   347 2025-06 Car BMW 218I Black Driving without Reasonable Consideration None Kenpas Highway Kenpas Highway Birmingham Birmingham NFA Outside of 14 Days NIP      
14424 op-snap---monthly-publication-june-2025.pdf   353 2025-06 Car Volvo HGV Grey Driving without Reasonable Consideration None Heartlands Parkway Heartlands Parkway Birmingham Birmingham NFA No Independent Evidence Available   52.5038363 -1.8432663
14436 op-snap---monthly-publication-june-2025.pdf   365 2025-06 Car Audi S3 Yellow Driving without Reasonable Consideration None Bath Row Bath Row Birmingham Birmingham NFA No VRM   52.472238 -1.9127983
14452 op-snap---monthly-publication-june-2025.pdf   381 2025-06 Car Ford transit Grey Driving without Reasonable Consideration None Cat Lane Cat Lane Birmingham Birmingham NFA No Independent Evidence Available   52.5000715 -1.7840322
14745 op-snap---monthly-publication-june-2025.pdf   674 2025-06 Car Volkswagen Golf Black Driving without Reasonable Consideration None Tyburn House Roundabout Tyburn House Roundabout Birmingham Birmingham NFA Misc Inc Crimes      
14833 op-snap---monthly-publication-june-2025.pdf   762 2025-06 Car Volkswagen Golf White Driving without Reasonable Consideration None Hodge Hill Hodge Hill Birmingham Birmingham NFA No VRM   52.4981788 -1.8112796
14845 op-snap---monthly-publication-june-2025.pdf   774 2025-06 Car Skoda Rapid Blue Driving without Reasonable Consideration None Bristol Road Bristol Road Birmingham Birmingham NFA No Offence   52.4543565 -1.9114004
15030 op-snap---monthly-publication-june-2025.pdf   959 2025-06 Pedal Bike Vauxhall INSIGNIA Green Driving without Reasonable Consideration None HALLAM STREET Hallam Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4563937 -1.8933429
15087 op-snap---monthly-publication-june-2025.pdf   1016 2025-06 Car Vauxhall Corsa Orange Driving without Reasonable Consideration None Warstock Lane Warstock Lane Birmingham Birmingham NFA Outside of 14 Days NIP   52.4175988 -1.8774655
15185 op-snap---monthly-publication-june-2025.pdf   1114 2025-06 Pedal Bike Volvo BUS RED Driving without Reasonable Consideration None LAWLEY MIDDLEWAY Lawley Middleway Birmingham Birmingham NFA No Offence   52.4801772 -1.8769185
15190 op-snap---monthly-publication-june-2025.pdf   1119 2025-06 Car Kia NIRO Silver Driving without Reasonable Consideration None WHITTAL STREET Whittal Street Birmingham Birmingham NFA No Offence   52.4847569 -1.8962965
15218 op-snap---monthly-publication-june-2025.pdf   1147 2025-06 Car Volkswagen golf Grey Driving without Reasonable Consideration None Woodbridge Road Woodbridge Road Birmingham Birmingham NFA No Offence   52.4482076 -1.8864335
15473 op-snap---monthly-publication-june-2025.pdf   1402 2025-06 Pedal Bike Hyundai I10 White Driving without Reasonable Consideration None Newton Road Newton Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4541102 -1.8710993
15474 op-snap---monthly-publication-june-2025.pdf   1403 2025-06 Pedal Bike Volkswagen Golf White Driving without Reasonable Consideration None Newton Road Newton Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4541102 -1.8710993
15720 op-snap---monthly-publication-june-2025.pdf   1649 2025-06 Car   Mclaren Grey Driving without Reasonable Consideration None M42 M42 Birmingham Birmingham NFA No Independent Evidence Available      
18678 op-snap---monthly-publication-may-2025.pdf   40 2025-05 Pedal Bike Ford Transit White Driving without Reasonable Consideration None Cliff Rock Road Cliff Rock Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.3937169 -2.0011078
18698 op-snap---monthly-publication-may-2025.pdf   60 2025-05 Pedal Bike Audi A6 Black Driving without Reasonable Consideration None Slade Road Slade Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.5894461 -1.8082962
18707 op-snap---monthly-publication-may-2025.pdf   69 2025-05 Pedal Bike BMW 535d Black Driving without Reasonable Consideration None Cambridge Street Cambridge Street Birmingham Birmingham NFA Outside of 14 Days NIP   52.4802932 -1.9079609
18708 op-snap---monthly-publication-may-2025.pdf   70 2025-05 Pedal Bike BMW 430d Grey Driving without Reasonable Consideration None Ridgeacre Road Ridgeacre Road Birmingham Birmingham NFA Outside of 14 Days NIP   52.4620871 -2.0123436

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