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

458 rows where council_area = "Birmingham", offence = "Driving without Reasonable Consideration" and reporter_transport_mode = "Car" 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 1

  • Car · 458 ✖

offence 1

  • Driving without Reasonable Consideration · 458 ✖

council_area 1

  • Birmingham · 458 ✖
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
7529 op-snap---monthly-publication-february-2026.pdf   276 2026-02 Car BMW 320 White Driving without Reasonable Consideration None Small Heath Bridge Small Heath Bridge Birmingham Birmingham Fixed Penalty N/A   52.4675008 -1.8693303
7958 op-snap---monthly-publication-february-2026.pdf   705 2026-02 Car Mercedes-Benz EAQ 350 Grey Driving without Reasonable Consideration None Five ways Five ways Birmingham Birmingham Warning Letter N/A   52.4710941 -1.9130708
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
8804 op-snap---monthly-publication-february-2026.pdf   1551 2026-02 Car Ford transit Black Driving without Reasonable Consideration None A45 Heartlands parkway Heartlands parkway Birmingham Birmingham Warning Letter N/A   52.5038363 -1.8432663
4619 op-snap---monthly-publication-december-2025.pdf   747 2025-12 Car Volkswagen Passat Grey Driving without Reasonable Consideration None M6 NB 4-5 M6 Northbound 4-5 Birmingham Birmingham Education N/A      
20481 op-snap---monthly-publication-november-2025.pdf   23 2025-11 Car Skoda Kodiaq Black Driving without Reasonable Consideration None Lawley Middleway Lawley Middleway Birmingham Birmingham Warning Letter N/A   52.4801772 -1.8769185
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
20695 op-snap---monthly-publication-november-2025.pdf   237 2025-11 Car Renault Clio Silver Driving without Reasonable Consideration None Bromford Lane Bromford Lane Birmingham Birmingham Education N/A   52.5083238 -1.8332287
22365 op-snap---monthly-publication-october-2025.pdf   315 2025-10 Car Peugeot 107 Black Driving without Reasonable Consideration None Heeley Road Heeley Road Birmingham Birmingham Court N/A   52.4401847 -1.9331572
22762 op-snap---monthly-publication-october-2025.pdf   712 2025-10 Car BMW 330 Black Driving without Reasonable Consideration None Grove Lane Grove Lane Birmingham Birmingham Warning Letter N/A   52.5055208 -1.9328067
22793 op-snap---monthly-publication-october-2025.pdf   743 2025-10 Car BMW 530 Black Driving without Reasonable Consideration None Grove Lane Grove Lane Birmingham Birmingham Education N/A   52.5055208 -1.9328067
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
24062 op-snap---monthly-publication-september-2025.pdf   281 2025-09 Car Nissan Qashqai Black Driving without Reasonable Consideration None Clifford Street, Newtown Clifford Street, Newtown Birmingham Birmingham Warning Letter N/A   52.4989738 -1.9005402
24063 op-snap---monthly-publication-september-2025.pdf   282 2025-09 Car Mercedes-Benz B180 Blue Driving without Reasonable Consideration None A38 Minworth Island Minworth Island Birmingham Birmingham Education N/A   52.5316279 -1.7762358
24167 op-snap---monthly-publication-september-2025.pdf   386 2025-09 Car Honda civic White Driving without Reasonable Consideration None M5 J3 M5 J3 Birmingham Birmingham Education N/A   52.4846642 -1.9297585
24205 op-snap---monthly-publication-september-2025.pdf   424 2025-09 Car Scania HGV white Driving without Reasonable Consideration None Tyburn House Island Tyburn House Island Birmingham Birmingham Warning Letter N/A   52.5194011 -1.8008643
24255 op-snap---monthly-publication-september-2025.pdf   474 2025-09 Car Lexus RX400 Blue Driving without Reasonable Consideration None Alum Rock Road Alum Rock Road Birmingham Birmingham Education N/A   52.4883936 -1.8310056
24300 op-snap---monthly-publication-september-2025.pdf   519 2025-09 Car Kia sportage Silver Driving without Reasonable Consideration None Cateswell Road Cateswell Road Birmingham Birmingham Education N/A   52.4387009 -1.8454267
24320 op-snap---monthly-publication-september-2025.pdf   539 2025-09 Car Ford Transit White Driving without Reasonable Consideration None Gravelly Hil Gravelly Hil Birmingham Birmingham Warning Letter N/A      
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
24336 op-snap---monthly-publication-september-2025.pdf   555 2025-09 Car Audi S3 Black Driving without Reasonable Consideration None Meadway Meadway Birmingham Birmingham Warning Letter N/A   52.4783348 -1.8007708
24376 op-snap---monthly-publication-september-2025.pdf   595 2025-09 Car Volkswagen crafter White Driving without Reasonable Consideration No Insurance College Road College Road Birmingham Birmingham Court N/A   52.5151832 -1.9361664
24692 op-snap---monthly-publication-september-2025.pdf   911 2025-09 Car Vauxhall Grandland Black Driving without Reasonable Consideration None Robin Hood Island Robin Hood Island Birmingham Birmingham Warning Letter N/A   52.4220705 -1.8372335
24813 op-snap---monthly-publication-september-2025.pdf   1032 2025-09 Car Nissan NOTE Black Driving without Reasonable Consideration None Yardley wood Road Yardley wood Road Birmingham Birmingham Fixed Penalty N/A   52.4103191 -1.8670224
24869 op-snap---monthly-publication-september-2025.pdf   1088 2025-09 Car Hyundai Kona Grey Driving without Reasonable Consideration None A45 A45 Birmingham Birmingham Warning Letter N/A      
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
2055 op-snap---monthly-publication-august-2025.pdf   30 2025-08 Car Ford Fiesta Grey Driving without Reasonable Consideration None Friston Av Friston Avenue Birmingham Birmingham Warning Letter N/A   52.4744592 -1.9198786
2143 op-snap---monthly-publication-august-2025.pdf   118 2025-08 Car Honda civic Silver Driving without Reasonable Consideration No Insurance Haslucks Green Road Haslucks Green Road Birmingham Birmingham Court N/A      
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
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
2432 op-snap---monthly-publication-august-2025.pdf   407 2025-08 Car Nissan X-Trail Silver Driving without Reasonable Consideration None A45 Coventry Road Coventry Road Birmingham Birmingham Warning Letter N/A   52.4726661 -1.8769032
2513 op-snap---monthly-publication-august-2025.pdf   488 2025-08 Car Toyota Corolla Grey Driving without Reasonable Consideration None Hamstead Hill Hamstead Hill Birmingham Birmingham Warning Letter N/A   52.5274116 -1.9287273
2556 op-snap---monthly-publication-august-2025.pdf   531 2025-08 Car Ford Kuga Blue Driving without Reasonable Consideration None Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
2699 op-snap---monthly-publication-august-2025.pdf   674 2025-08 Car Mg Exclusive White Driving without Reasonable Consideration None Icknield Street Icknield Street Birmingham Birmingham Education N/A   52.5709191 -1.8759339
2799 op-snap---monthly-publication-august-2025.pdf   774 2025-08 Car Citroen Dispatch White Driving without Reasonable Consideration None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Education N/A   52.5517052 -1.7825505
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
2919 op-snap---monthly-publication-august-2025.pdf   894 2025-08 Car Volkswagen Touran Black Driving without Reasonable Consideration None Battery Way Battery Way Birmingham Birmingham Warning Letter N/A   52.4493988 -1.8476406
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
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
3199 op-snap---monthly-publication-august-2025.pdf   1174 2025-08 Car Audi A3 White Driving without Reasonable Consideration None Chester Road, New Oscott Chester Road, New Oscott Birmingham Birmingham Warning Letter N/A   52.5459731 -1.8568254
3201 op-snap---monthly-publication-august-2025.pdf   1176 2025-08 Car Ford puma White Driving without Reasonable Consideration None Walsall Road Walsall Road Birmingham Birmingham Education N/A   52.5919543 -1.8517118
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
12162 op-snap---monthly-publication-july-2025.pdf   214 2025-07 Car Mercedes-Benz Sprinter White Driving without Reasonable Consideration None M6 Southbound approaching Jn6 M6 Southbound approaching Jn6 Birmingham Birmingham Warning Letter N/A      
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
12234 op-snap---monthly-publication-july-2025.pdf   286 2025-07 Car BMW X4 Grey Driving without Reasonable Consideration None Little Bromwich Road Little Bromwich Road Birmingham Birmingham Education N/A   52.4777017 -1.8246255
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
12394 op-snap---monthly-publication-july-2025.pdf   446 2025-07 Car Toyota Auris Silver Driving without Reasonable Consideration None Walsall Rd Walsall Road Birmingham Birmingham Warning Letter N/A   52.5919543 -1.8517118
12508 op-snap---monthly-publication-july-2025.pdf   560 2025-07 Car Volkswagen Polo Grey Driving without Reasonable Consideration None Lichfield Road Lichfield Road Birmingham Birmingham Court N/A   52.5012458 -1.8780942
12545 op-snap---monthly-publication-july-2025.pdf   597 2025-07 Car Citroen relay White Driving without Reasonable Consideration None Stonehouse Lane Stonehouse Lane Birmingham Birmingham Education N/A   52.4440435 -1.9818872
12574 op-snap---monthly-publication-july-2025.pdf   626 2025-07 Car Volkswagen Golf White Driving without Reasonable Consideration None A45 Coventry Road, Small Heath Coventry Road, Small Heath Birmingham Birmingham Education N/A   52.4650893 -1.8425008
12576 op-snap---monthly-publication-july-2025.pdf   628 2025-07 Car Ford Transit Red Driving without Reasonable Consideration None Cotterills Lane Cotterills Lane Birmingham Birmingham Warning Letter N/A   52.4884297 -1.817811
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      
12592 op-snap---monthly-publication-july-2025.pdf   644 2025-07 Car BMW 520.. Grey Driving without Reasonable Consideration None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
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      
12772 op-snap---monthly-publication-july-2025.pdf   824 2025-07 Car Audi Q7 Black Driving without Reasonable Consideration None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
12851 op-snap---monthly-publication-july-2025.pdf   903 2025-07 Car Nissan Qashqai Red Driving without Reasonable Consideration None Alcester Road South Alcester Road South Birmingham Birmingham Education N/A   52.4170522 -1.8906187
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
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
12937 op-snap---monthly-publication-july-2025.pdf   989 2025-07 Car Mg ZS Silver Driving without Reasonable Consideration None Kyotts Lake Road Kyotts Lake Road Birmingham Birmingham Warning Letter N/A   52.4655028 -1.8755351
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
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
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
14148 op-snap---monthly-publication-june-2025.pdf   77 2025-06 Car Mg three Black Driving without Reasonable Consideration None Avenue Road Avenue Road Birmingham Birmingham Warning Letter N/A   52.4941712 -1.8795158
14227 op-snap---monthly-publication-june-2025.pdf   156 2025-06 Car Peugeot 207 Blue Driving without Reasonable Consideration None Coleshill Road Coleshill Road Birmingham Birmingham Education N/A   52.4967329 -1.8097462

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