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

337 rows where offence = "Misc - Non Traffic Offences" and reporter_transport_mode = "Pedestrian" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, second_offence, council_area_raw, nfa_rationale

reporter_transport_mode 1

  • Pedestrian · 337 ✖

offence 1

  • Misc - Non Traffic Offences · 337 ✖
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
7324 op-snap---monthly-publication-february-2026.pdf   71 2026-02 Pedestrian Ford Puma Black Misc - Non Traffic Offences None Halord Lane Halord Lane Out of Force Area Out of Force Area NFA Out of Force      
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
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
7955 op-snap---monthly-publication-february-2026.pdf   702 2026-02 Pedestrian Mercedes-Benz E300.. Blue Misc - Non Traffic Offences None Edward Street Edward Street Birmingham Birmingham Warning Letter N/A   52.4816233 -1.9124334
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
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
8610 op-snap---monthly-publication-february-2026.pdf   1357 2026-02 Pedestrian Mg hs Black Misc - Non Traffic Offences None wolverhampton Wolverhampton Wolverhampton Wolverhampton NFA No Offence   52.5879884 -2.120242
8710 op-snap---monthly-publication-february-2026.pdf   1457 2026-02 Pedestrian Land Rover freelander Silver Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Misc Inc Crimes      
8713 op-snap---monthly-publication-february-2026.pdf   1460 2026-02 Pedestrian BMW 320d White Misc - Non Traffic Offences None homer street Homer Street Solihull Solihull NFA Misc Inc Crimes      
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
8730 op-snap---monthly-publication-february-2026.pdf   1477 2026-02 Pedestrian Kia sorento Grey Misc - Non Traffic Offences None broadmeadow Broadmeadow Walsall Walsall Warning Letter N/A   52.6100022 -1.9177041
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
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
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
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
10769 op-snap---monthly-publication-january-2026.pdf   230 2026-01 Pedestrian     Grey Misc - Non Traffic Offences None Camp Lane, Worcester Camp Lane, Worcester Out of Force Area Out of Force Area NFA Out of Force      
10867 op-snap---monthly-publication-january-2026.pdf   328 2026-01 Pedestrian Mercedes-Benz 330 White Misc - Non Traffic Offences None Barclay Road Barclay Road Sandwell Sandwell Warning Letter N/A   52.4722765 -1.9787531
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
11254 op-snap---monthly-publication-january-2026.pdf   715 2026-01 Pedestrian Renault Megane Silver Misc - Non Traffic Offences None Fenton Road Fenton Road Coventry Coventry NFA Misc Inc Crimes   52.4331816 -1.5630141
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
11298 op-snap---monthly-publication-january-2026.pdf   759 2026-01 Pedestrian Renault Megane Silver Misc - Non Traffic Offences None Fenton Road Fenton Road Coventry Coventry NFA No Offence   52.4331816 -1.5630141
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
11692 op-snap---monthly-publication-january-2026.pdf   1153 2026-01 Pedestrian Audi A1 Silver Misc - Non Traffic Offences Use vehicle on a road without valid test certificate Metchley Lane Metchley Lane Birmingham Birmingham Fixed Penalty N/A   52.4552055 -1.9461279
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
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
3899 op-snap---monthly-publication-december-2025.pdf   27 2025-12 Pedestrian Toyota Yaris Silver Misc - Non Traffic Offences None Gibson Drive Gibson Drive Birmingham Birmingham Warning Letter N/A   52.507404 -1.9170214
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      
3946 op-snap---monthly-publication-december-2025.pdf   74 2025-12 Pedestrian       Misc - Non Traffic Offences None Himley Road Himley Road Out of Force Area Out of Force Area NFA Out of Force   52.5130072 -2.09584
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
4254 op-snap---monthly-publication-december-2025.pdf   382 2025-12 Pedestrian Mg hs Blue Misc - Non Traffic Offences None teazel avenue Teazel Avenue Birmingham Birmingham Warning Letter N/A   52.4247795 -1.9433534
4256 op-snap---monthly-publication-december-2025.pdf   384 2025-12 Pedestrian Land Rover discovery White Misc - Non Traffic Offences None crankhall lane Crankhall Lane Dudley Dudley NFA Misc Inc Crimes      
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
4336 op-snap---monthly-publication-december-2025.pdf   464 2025-12 Pedestrian BMW 3 series White Misc - Non Traffic Offences None regent road Regent Road Dudley Dudley NFA Misc Inc Crimes   52.5106406 -2.0559963
4337 op-snap---monthly-publication-december-2025.pdf   465 2025-12 Pedestrian Audi a4 Black Misc - Non Traffic Offences None regendt road Regendt Road Dudley Dudley NFA Misc Inc Crimes      
4438 op-snap---monthly-publication-december-2025.pdf   566 2025-12 Pedestrian Mercedes-Benz a200 Black Misc - Non Traffic Offences None hafley road Hafley Road Dudley Dudley NFA Misc Inc Crimes      
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
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
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
4593 op-snap---monthly-publication-december-2025.pdf   721 2025-12 Pedestrian Vauxhall insignia White Misc - Non Traffic Offences None abbey road Abbey Road Sandwell Sandwell NFA Misc Inc Crimes   52.47753 -1.9774758
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
4651 op-snap---monthly-publication-december-2025.pdf   779 2025-12 Pedestrian Vauxhall corsa Black Misc - Non Traffic Offences None fenton road Fenton Road Coventry Coventry NFA Misc Inc Crimes   52.4331816 -1.5630141
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      
4669 op-snap---monthly-publication-december-2025.pdf   797 2025-12 Pedestrian BMW 1 Series Silver Misc - Non Traffic Offences None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
4670 op-snap---monthly-publication-december-2025.pdf   798 2025-12 Pedestrian BMW 3 Series Black Misc - Non Traffic Offences None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
4671 op-snap---monthly-publication-december-2025.pdf   799 2025-12 Pedestrian Audi A4 Grey Misc - Non Traffic Offences None M6 M6 Out of Force Area Out of Force Area NFA Out of Force      
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
4685 op-snap---monthly-publication-december-2025.pdf   813 2025-12 Pedestrian Tesla Model 3 Black Misc - Non Traffic Offences None Centurion Drive Worcester Centurion Drive Worcester Out of Force Area Out of Force Area NFA Out of Force      
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
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      
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
4955 op-snap---monthly-publication-december-2025.pdf   1083 2025-12 Pedestrian Renault scenic Grey Misc - Non Traffic Offences None flavell avenue Flavell Avenue Wolverhampton Wolverhampton NFA No Offence      
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
5012 op-snap---monthly-publication-december-2025.pdf   1140 2025-12 Pedestrian Ford transit White Misc - Non Traffic Offences None mace street Mace Street Dudley Dudley NFA Misc Inc Crimes      
5021 op-snap---monthly-publication-december-2025.pdf   1149 2025-12 Pedestrian Honda crv Blue Misc - Non Traffic Offences None rowood drive Rowood Drive Solihull Solihull NFA Misc Inc Crimes   52.4285752 -1.7757399
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
5026 op-snap---monthly-publication-december-2025.pdf   1154 2025-12 Pedestrian Volkswagen Up White Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
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
5182 op-snap---monthly-publication-december-2025.pdf   1310 2025-12 Pedestrian Ford focus Blue Misc - Non Traffic Offences None thistley field Thistley Field Coventry Coventry NFA Misc Inc Crimes   52.4271223 -1.5298007
20829 op-snap---monthly-publication-november-2025.pdf   371 2025-11 Pedestrian       Misc - Non Traffic Offences None Leicester Leicester Out of Force Area Out of Force Area NFA Out of Force   52.4145125 -1.5097639
20897 op-snap---monthly-publication-november-2025.pdf   439 2025-11 Pedestrian Audi A3 Grey Misc - Non Traffic Offences None Whittington Oval Whittington Oval Birmingham Birmingham Warning Letter N/A   52.4800782 -1.7942034
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      
20993 op-snap---monthly-publication-november-2025.pdf   535 2025-11 Pedestrian Ford fiesta Blue Misc - Non Traffic Offences None out of force Out Of Force Out of Force Area Out of Force Area NFA Out of Force      
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      
21070 op-snap---monthly-publication-november-2025.pdf   612 2025-11 Pedestrian Skoda   Silver Misc - Non Traffic Offences None lichfield road Lichfield Road Sutton Coldfield Sutton Coldfield NFA Misc Inc Crimes   52.5872149 -1.8300386
21090 op-snap---monthly-publication-november-2025.pdf   632 2025-11 Pedestrian Vauxhall Zafira Silver Misc - Non Traffic Offences None St Elizabeth Rd Street Elizabeth Road Coventry Coventry NFA No Offence      
21208 op-snap---monthly-publication-november-2025.pdf   750 2025-11 Pedestrian BMW 1 Series Grey Misc - Non Traffic Offences None Ramsden Avenue Ramsden Avenue Out of Force Area Out of Force Area NFA Out of Force      
21229 op-snap---monthly-publication-november-2025.pdf   771 2025-11 Pedestrian Ford Mondeo White Misc - Non Traffic Offences Offence to be added Gayfield Av Gayfield Avenue Dudley Dudley NFA No Offence   52.4693896 -2.1251602
21231 op-snap---monthly-publication-november-2025.pdf   773 2025-11 Pedestrian Ford Kuga Grey Misc - Non Traffic Offences None Gayfield Av Gayfield Avenue Dudley Dudley NFA No Offence   52.4693896 -2.1251602
21232 op-snap---monthly-publication-november-2025.pdf   774 2025-11 Pedestrian Vauxhall Agila Silver Misc - Non Traffic Offences None Fenton Road Fenton Road Coventry Coventry NFA No Offence   52.4331816 -1.5630141
21233 op-snap---monthly-publication-november-2025.pdf   775 2025-11 Pedestrian Volkswagen CC Grey Misc - Non Traffic Offences None Fenton Road Fenton Road Coventry Coventry NFA No Offence   52.4331816 -1.5630141
21234 op-snap---monthly-publication-november-2025.pdf   776 2025-11 Pedestrian Honda Civic Black Misc - Non Traffic Offences None Fenton Road Fenton Road Coventry Coventry NFA No Offence   52.4331816 -1.5630141
21278 op-snap---monthly-publication-november-2025.pdf   820 2025-11 Pedestrian Honda civic Blue Misc - Non Traffic Offences None fenton road Fenton Road Coventry Coventry NFA Misc Inc Crimes   52.4331816 -1.5630141
21279 op-snap---monthly-publication-november-2025.pdf   821 2025-11 Pedestrian Renault clio Red Misc - Non Traffic Offences None fenton raod Fenton Raod Coventry Coventry NFA Misc Inc Crimes      
21280 op-snap---monthly-publication-november-2025.pdf   822 2025-11 Pedestrian Skoda fabia Silver Misc - Non Traffic Offences None fenton raod Fenton Raod Coventry Coventry NFA Misc Inc Crimes      
21281 op-snap---monthly-publication-november-2025.pdf   823 2025-11 Pedestrian Honda jazz White Misc - Non Traffic Offences None fenton road Fenton Road Coventry Coventry NFA Misc Inc Crimes   52.4331816 -1.5630141

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