home / opsnap

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

137 rows where disposal = "Education", offence = "Driving without Due Care and Attention" and vehicle_make = "BMW" 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

month 14

  • 2025-06 20
  • 2026-02 17
  • 2026-01 15
  • 2025-08 13
  • 2025-09 12
  • 2025-07 11
  • 2025-11 11
  • 2025-10 10
  • 2025-05 8
  • 2025-03 7
  • 2025-12 5
  • 2025-01 3
  • 2025-02 3
  • 2025-04 2

council_area 9

  • Birmingham 70
  • Solihull 17
  • Coventry 10
  • Sandwell 10
  • Walsall 9
  • Dudley 8
  • Wolverhampton 7
  • Sutton Coldfield 5
  • Halesowen 1

reporter_transport_mode 6

  • Car 95
  • Pedal Bike 34
  • Other 5
  • Lorry 1
  • Pedestrian 1
  • Van 1

vehicle_make 1

  • BMW · 137 ✖

offence 1

  • Driving without Due Care and Attention · 137 ✖

disposal 1

  • Education · 137 ✖
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
7305 op-snap---monthly-publication-february-2026.pdf   52 2026-02 Pedal Bike BMW   Black Driving without Due Care and Attention None Queensbridge Road Queensbridge Road Birmingham Birmingham Education N/A   52.4415108 -1.8971434
7312 op-snap---monthly-publication-february-2026.pdf   59 2026-02 Pedal Bike BMW 218i Blue Driving without Due Care and Attention None Bird Street at White Street Bird Street at White Street Coventry Coventry Education N/A   52.4124171 -1.5065021
7497 op-snap---monthly-publication-february-2026.pdf   244 2026-02 Car BMW X1 Blue Driving without Due Care and Attention None Torcross Avenue Torcross Avenue Coventry Coventry Education N/A   52.4218194 -1.46546
7710 op-snap---monthly-publication-february-2026.pdf   457 2026-02 Car BMW X3 M Grey Driving without Due Care and Attention None Heath Way Heath Way Birmingham Birmingham Education N/A   52.4963549 -1.7806171
7882 op-snap---monthly-publication-february-2026.pdf   629 2026-02 Car BMW 318D Black Driving without Due Care and Attention None London Road London Road Coventry Coventry Education N/A   52.3916468 -1.4925995
7934 op-snap---monthly-publication-february-2026.pdf   681 2026-02 Pedal Bike BMW   Orange Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
7938 op-snap---monthly-publication-february-2026.pdf   685 2026-02 Pedal Bike BMW   Grey Driving without Due Care and Attention None Back Lane Coventry Back Lane Coventry Coventry Coventry Education N/A   52.3796433 -1.5600371
8073 op-snap---monthly-publication-february-2026.pdf   820 2026-02 Car BMW 4 series Grey Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Education N/A   52.5517052 -1.7825505
8074 op-snap---monthly-publication-february-2026.pdf   821 2026-02 Car BMW 4 series Grey Driving without Due Care and Attention None Fox Hollies Road Fox Hollies Road Birmingham Birmingham Education N/A   52.5517052 -1.7825505
8098 op-snap---monthly-publication-february-2026.pdf   845 2026-02 Car BMW 520.. White Driving without Due Care and Attention None Heartlands Parkway Heartlands Parkway Birmingham Birmingham Education N/A   52.5038363 -1.8432663
8112 op-snap---monthly-publication-february-2026.pdf   859 2026-02 Car BMW 320d Blue Driving without Due Care and Attention None Hockley Circus Hockley Circus Birmingham Birmingham Education N/A   52.4952382 -1.9146705
8334 op-snap---monthly-publication-february-2026.pdf   1081 2026-02 Pedestrian BMW X4 Black Driving without Due Care and Attention None Sherborne Street Sherborne Street Birmingham Birmingham Education N/A   52.4762433 -1.9176665
8421 op-snap---monthly-publication-february-2026.pdf   1168 2026-02 Car BMW 330.. Black Driving without Due Care and Attention None A34 Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
8439 op-snap---monthly-publication-february-2026.pdf   1186 2026-02 Car BMW X5 White Driving without Due Care and Attention None M5 M5 Sandwell Sandwell Education N/A      
8469 op-snap---monthly-publication-february-2026.pdf   1216 2026-02 Car BMW 320D Black Driving without Due Care and Attention None Leamore Lane Leamore Lane Walsall Walsall Education N/A   52.6056653 -2.0050776
8599 op-snap---monthly-publication-february-2026.pdf   1346 2026-02 Car BMW 435D Black Driving without Due Care and Attention None Lower Queen Lower Queen Sutton Coldfield Sutton Coldfield Education N/A   52.560777 -1.8219813
8612 op-snap---monthly-publication-february-2026.pdf   1359 2026-02 Pedal Bike BMW 118d Silver Driving without Due Care and Attention None Aston Webb Boulevard Aston Webb Boulevard Birmingham Birmingham Education N/A   52.4468506 -1.9395619
10640 op-snap---monthly-publication-january-2026.pdf   101 2026-01 Other BMW 3 series blue Driving without Due Care and Attention None Star City car park Star City car park Birmingham Birmingham Education N/A      
10641 op-snap---monthly-publication-january-2026.pdf   102 2026-01 Other BMW 3 series black Driving without Due Care and Attention None Star City car park Star City car park Birmingham Birmingham Education N/A      
10939 op-snap---monthly-publication-january-2026.pdf   400 2026-01 Car BMW 320d Black Driving without Due Care and Attention None M5 SB J1-2 M5 Southbound J1-2 Sandwell Sandwell Education N/A      
10977 op-snap---monthly-publication-january-2026.pdf   438 2026-01 Pedal Bike BMW 330 E Black Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
10999 op-snap---monthly-publication-january-2026.pdf   460 2026-01 Car BMW 1 Series Grey Driving without Due Care and Attention None Blossomfield Road Blossomfield Road Solihull Solihull Education N/A   52.4144779 -1.7848758
11011 op-snap---monthly-publication-january-2026.pdf   472 2026-01 Car BMW 1 Series Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
11091 op-snap---monthly-publication-january-2026.pdf   552 2026-01 Pedal Bike BMW z4 Red Driving without Due Care and Attention None Pershore Road South Pershore Road South Birmingham Birmingham Education N/A   52.4150779 -1.930901
11172 op-snap---monthly-publication-january-2026.pdf   633 2026-01 Car BMW X1 White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
11281 op-snap---monthly-publication-january-2026.pdf   742 2026-01 Pedal Bike BMW 320D White Driving without Due Care and Attention None Wrentham Street Wrentham Street Birmingham Birmingham Education N/A   52.4708757 -1.8966158
11518 op-snap---monthly-publication-january-2026.pdf   979 2026-01 Car BMW 320d Blue Driving without Due Care and Attention None Stockfield Road Stockfield Road Birmingham Birmingham Education N/A   52.4519414 -1.831688
11604 op-snap---monthly-publication-january-2026.pdf   1065 2026-01 Car BMW 420d Black Driving without Due Care and Attention None Gilbertson Avenue Gilbertson Avenue Birmingham Birmingham Education N/A      
11641 op-snap---monthly-publication-january-2026.pdf   1102 2026-01 Car BMW X3 Black Driving without Due Care and Attention None Strourbridge Ring Road Strourbridge Ring Road Dudley Dudley Education N/A      
11843 op-snap---monthly-publication-january-2026.pdf   1304 2026-01 Car BMW M340 White Driving without Due Care and Attention None Dayus Square Dayus Square Birmingham Birmingham Education N/A   52.4846586 -1.9140974
11895 op-snap---monthly-publication-january-2026.pdf   1356 2026-01 Car BMW 118i White Driving without Due Care and Attention None Farquhar Road Farquhar Road Birmingham Birmingham Education N/A   52.4561477 -1.931477
11923 op-snap---monthly-publication-january-2026.pdf   1384 2026-01 Car BMW 118i Grey Driving without Due Care and Attention None Galton Road Galton Road Sandwell Sandwell Education N/A   52.4700791 -1.9751575
4182 op-snap---monthly-publication-december-2025.pdf   310 2025-12 Car BMW 316 Black Driving without Due Care and Attention None Chester Road at Kingsbury Road Chester Road at Kingsbury Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
4430 op-snap---monthly-publication-december-2025.pdf   558 2025-12 Car BMW 1 Series Black Driving without Due Care and Attention None Wednesfield Road Wednesfield Road Wolverhampton Wolverhampton Education N/A   52.5885601 -2.122003
4693 op-snap---monthly-publication-december-2025.pdf   821 2025-12 Car BMW E220 Black Driving without Due Care and Attention None Queslett Road Queslett Road Birmingham Birmingham Education N/A   52.5458699 -1.9304484
4816 op-snap---monthly-publication-december-2025.pdf   944 2025-12 Pedal Bike BMW IX Grey Driving without Due Care and Attention None Whitefields Road Whitefields Road Solihull Solihull Education N/A   52.4060267 -1.7849657
4984 op-snap---monthly-publication-december-2025.pdf   1112 2025-12 Car BMW X5 Blue Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
20540 op-snap---monthly-publication-november-2025.pdf   82 2025-11 Car BMW 750E Grey Driving without Due Care and Attention None Edgbaston Road Edgbaston Road Birmingham Birmingham Education N/A   52.4552785 -1.906384
20640 op-snap---monthly-publication-november-2025.pdf   182 2025-11 Car BMW 440.. Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
20641 op-snap---monthly-publication-november-2025.pdf   183 2025-11 Car BMW 320.. Grey Driving without Due Care and Attention Use vehicle on a road without valid test certificate High Street Sedgley High Street Sedgley Dudley Dudley Education N/A   52.543975 -2.122501
20790 op-snap---monthly-publication-november-2025.pdf   332 2025-11 Pedal Bike BMW 520D Grey Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
20824 op-snap---monthly-publication-november-2025.pdf   366 2025-11 Car BMW 520I Black Driving without Due Care and Attention None M42 Juncution 5 M42 Juncution 5 Solihull Solihull Education N/A      
21032 op-snap---monthly-publication-november-2025.pdf   574 2025-11 Car BMW 435D Blue Driving without Due Care and Attention None Kingston Road Kingston Road Birmingham Birmingham Education N/A   52.4747333 -1.8728345
21411 op-snap---monthly-publication-november-2025.pdf   953 2025-11 Pedal Bike BMW 320D Black Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham Education N/A   52.4422505 -1.8539684
21459 op-snap---monthly-publication-november-2025.pdf   1001 2025-11 Pedal Bike BMW 1 series black Driving without Due Care and Attention None Dalmuir Road, Longbridge Dalmuir Road, Longbridge Birmingham Birmingham Education N/A   52.3921725 -1.9876776
21713 op-snap---monthly-publication-november-2025.pdf   1255 2025-11 Car BMW 520D Grey Driving without Due Care and Attention None M6 South M6 South Birmingham Birmingham Education N/A   52.4031308 -2.0142003
21719 op-snap---monthly-publication-november-2025.pdf   1261 2025-11 Pedal Bike BMW 320i White Driving without Due Care and Attention None Bristol Road, Birmingham Bristol Road, Birmingham Birmingham Birmingham Education N/A   52.4543565 -1.9114004
21959 op-snap---monthly-publication-november-2025.pdf   1501 2025-11 Pedal Bike BMW X4 Blue Driving without Due Care and Attention None Stratford Road towards Shirley Stratford Road towards Shirley Birmingham Birmingham Education N/A      
22237 op-snap---monthly-publication-october-2025.pdf   187 2025-10 Pedal Bike BMW 320.. Black Driving without Due Care and Attention None Longford Road Longford Road Birmingham Birmingham Education N/A   52.5524121 -1.8764968
22413 op-snap---monthly-publication-october-2025.pdf   363 2025-10 Car BMW 330.. Blue Driving without Due Care and Attention None Birches Barn Road Birches Barn Road Wolverhampton Wolverhampton Education N/A   52.5716962 -2.1462935
22619 op-snap---monthly-publication-october-2025.pdf   569 2025-10 Lorry BMW 420D Grey Driving without Due Care and Attention None M42 Motorway M42 Motorway Birmingham Birmingham Education N/A   52.490826 -1.8882034
22649 op-snap---monthly-publication-october-2025.pdf   599 2025-10 Car BMW   White Driving without Due Care and Attention None Coventry town centre Coventry town centre Coventry Coventry Education N/A      
22716 op-snap---monthly-publication-october-2025.pdf   666 2025-10 Car BMW 1 series Grey Driving without Due Care and Attention None Broadwell Road, Oldbury Broadwell Road, Oldbury Sandwell Sandwell Education N/A   52.5080794 -2.0125585
22771 op-snap---monthly-publication-october-2025.pdf   721 2025-10 Car BMW   Silver Driving without Due Care and Attention None M6 M6 Birmingham Birmingham Education N/A      
22781 op-snap---monthly-publication-october-2025.pdf   731 2025-10 Pedal Bike BMW 218I Grey Driving without Due Care and Attention None Highlands Road Highlands Road Solihull Solihull Education N/A   52.3909869 -1.8032499
22798 op-snap---monthly-publication-october-2025.pdf   748 2025-10 Car BMW X3 Grey Driving without Due Care and Attention None Belgrave Middleway Belgrave Middleway Birmingham Birmingham Education N/A   52.4668753 -1.8996143
22939 op-snap---monthly-publication-october-2025.pdf   889 2025-10 Pedal Bike BMW X2` Blue Driving without Due Care and Attention None St Nicholas St Street Nicholas Street Coventry Coventry Education N/A   52.4133001 -1.5126792
23072 op-snap---monthly-publication-october-2025.pdf   1022 2025-10 Car BMW 5 series Black Driving without Due Care and Attention None M6 Motorway, Southbound near Great barr M6 Motorway, Southbound near Great barr Birmingham Birmingham Education N/A      
23898 op-snap---monthly-publication-september-2025.pdf   117 2025-09 Car BMW 3 series Black Driving without Due Care and Attention None Aldridge Road Aldridge Road Birmingham Birmingham Education N/A   52.5368764 -1.8976461
23976 op-snap---monthly-publication-september-2025.pdf   195 2025-09 Car BMW 320.. White Driving without Due Care and Attention None A38 Aston Expressway Aston Expressway Birmingham Birmingham Education N/A   52.493793 -1.8881773
24010 op-snap---monthly-publication-september-2025.pdf   229 2025-09 Pedal Bike BMW 118 Black Driving without Due Care and Attention None Wylde Green Road Wylde Green Road Sutton Coldfield Sutton Coldfield Education N/A   52.546976 -1.8098124
24015 op-snap---monthly-publication-september-2025.pdf   234 2025-09 Pedal Bike BMW 120d White Driving without Due Care and Attention None Walsall Road Walsall Road Walsall Walsall Education N/A   52.6166864 -1.9660822
24054 op-snap---monthly-publication-september-2025.pdf   273 2025-09 Car BMW S1000RR White Driving without Due Care and Attention None Sundial Lane Sundial Lane Birmingham Birmingham Education N/A   52.5471217 -1.9336068
24198 op-snap---monthly-publication-september-2025.pdf   417 2025-09 Pedal Bike BMW 2 series Grey Driving without Due Care and Attention No vehicle excise licence Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Education N/A   52.5940902 -1.843503
24261 op-snap---monthly-publication-september-2025.pdf   480 2025-09 Car BMW 1 Series Black Driving without Due Care and Attention None Waterfront Way Waterfront Way Dudley Dudley Education N/A   52.4879006 -2.1188734
24334 op-snap---monthly-publication-september-2025.pdf   553 2025-09 Car BMW   White Driving without Due Care and Attention None A491 High Street High Street Dudley Dudley Education N/A   52.4779764 -2.1598371
24469 op-snap---monthly-publication-september-2025.pdf   688 2025-09 Car BMW X3 Black Driving without Due Care and Attention None M42 junction 6 M42 junction 6 Solihull Solihull Education N/A      
24596 op-snap---monthly-publication-september-2025.pdf   815 2025-09 Pedal Bike BMW 3 Series White Driving without Due Care and Attention None Chester Road North Chester Road North Walsall Walsall Education N/A   52.654063 -1.9460461
24652 op-snap---monthly-publication-september-2025.pdf   871 2025-09 Car BMW 520.. Silver Driving without Due Care and Attention None Tyburn Road Roundabout Tyburn Road Roundabout Birmingham Birmingham Education N/A      
24748 op-snap---monthly-publication-september-2025.pdf   967 2025-09 Pedal Bike BMW X4 Grey Driving without Due Care and Attention Use vehicle on a road without valid test certificate Springfield Road Moseley Springfield Road Moseley Birmingham Birmingham Education N/A      
2025 op-snap---monthly-publication-august-2025.pdf   0 2025-08 Car BMW 120M White Driving without Due Care and Attention None Dudley Road Dudley Road Birmingham Birmingham Education N/A   52.4865107 -1.9386263
2127 op-snap---monthly-publication-august-2025.pdf   102 2025-08 Pedal Bike BMW 530D Silver Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
2129 op-snap---monthly-publication-august-2025.pdf   104 2025-08 Car BMW 330 Black Driving without Due Care and Attention None The Broadway The Broadway Walsall Walsall Education N/A   52.6090076 -2.0515573
2186 op-snap---monthly-publication-august-2025.pdf   161 2025-08 Car BMW 118i Grey Driving without Due Care and Attention None Cole Hall Road Cole Hall Road Birmingham Birmingham Education N/A   52.4968357 -1.7908553
2468 op-snap---monthly-publication-august-2025.pdf   443 2025-08 Car BMW 320 Grey Driving without Due Care and Attention None Neachells Lane Neachells Lane Wolverhampton Wolverhampton Education N/A   52.597459 -2.0791894
2615 op-snap---monthly-publication-august-2025.pdf   590 2025-08 Pedal Bike BMW 120D Black Driving without Due Care and Attention None Rayner Road Rayner Road Wolverhampton Wolverhampton Education N/A      
2674 op-snap---monthly-publication-august-2025.pdf   649 2025-08 Car BMW 118.. Grey Driving without Due Care and Attention None Egghill Lane Egghill Lane Birmingham Birmingham Education N/A   52.4093768 -1.9976236
2726 op-snap---monthly-publication-august-2025.pdf   701 2025-08 Car BMW X5 Silver Driving without Due Care and Attention None Holford Drive Holford Drive Birmingham Birmingham Education N/A   52.5216608 -1.8903521
2882 op-snap---monthly-publication-august-2025.pdf   857 2025-08 Car BMW M4 Blue Driving without Due Care and Attention None Wednesbury Road Wednesbury Road Walsall Walsall Education N/A   52.5738499 -1.9961575
2883 op-snap---monthly-publication-august-2025.pdf   858 2025-08 Car BMW 318 Blue Driving without Due Care and Attention None Brettle Lane Brettle Lane Dudley Dudley Education N/A      
2977 op-snap---monthly-publication-august-2025.pdf   952 2025-08 Car BMW 3 Series Grey Driving without Due Care and Attention None City Road City Road Birmingham Birmingham Education N/A   52.4763176 -1.9584897
3082 op-snap---monthly-publication-august-2025.pdf   1057 2025-08 Car BMW 320 Black Driving without Due Care and Attention None Gerrards Street, Lozells Gerrards Street, Lozells Birmingham Birmingham Education N/A      
3096 op-snap---monthly-publication-august-2025.pdf   1071 2025-08 Car BMW 3 Silver Driving without Due Care and Attention None Streetsbrook Road Streetsbrook Road Solihull Solihull Education N/A   52.4223176 -1.8253145
12087 op-snap---monthly-publication-july-2025.pdf   139 2025-07 Pedal Bike BMW 116.. White Driving without Due Care and Attention None Bearwood Road Bearwood Road Sandwell Sandwell Education N/A   52.4725977 -1.9684448
12180 op-snap---monthly-publication-july-2025.pdf   232 2025-07 Car BMW 320d Blue Driving without Due Care and Attention None Slaters Lane Slaters Lane Walsall Walsall Education N/A   52.5719978 -2.0041926
12203 op-snap---monthly-publication-july-2025.pdf   255 2025-07 Car BMW X Drive Blue Driving without Due Care and Attention None Brassington Avenue Brassington Avenue Sutton Coldfield Sutton Coldfield Education N/A   52.5637812 -1.823481
12312 op-snap---monthly-publication-july-2025.pdf   364 2025-07 Car BMW X1.. White Driving without Due Care and Attention None M5 Junction 1 Island M5 Junction 1 Island Wolverhampton Wolverhampton Education N/A      
12322 op-snap---monthly-publication-july-2025.pdf   374 2025-07 Car BMW 220.. Black Driving without Due Care and Attention None Stubbers Green Road Stubbers Green Road Walsall Walsall Education N/A   52.6118163 -1.9350405
12455 op-snap---monthly-publication-july-2025.pdf   507 2025-07 Car BMW   White Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
12496 op-snap---monthly-publication-july-2025.pdf   548 2025-07 Other BMW M3 Blue Driving without Due Care and Attention None Main Car Park, Waterfront Main Car Park, Waterfront Sandwell Sandwell Education N/A      
12527 op-snap---monthly-publication-july-2025.pdf   579 2025-07 Car BMW M3 Blue Driving without Due Care and Attention None St Bernards Street Bernards Solihull Solihull Education N/A      
13111 op-snap---monthly-publication-july-2025.pdf   1163 2025-07 Car BMW 218 Blue Driving without Due Care and Attention None Beake Avenue Beake Avenue Coventry Coventry Education N/A   52.4388246 -1.5229308
13162 op-snap---monthly-publication-july-2025.pdf   1214 2025-07 Other BMW 335D White Driving without Due Care and Attention None Waterfront main car park Waterfront main car park Dudley Dudley Education N/A      
13241 op-snap---monthly-publication-july-2025.pdf   1293 2025-07 Car BMW X4 White Driving without Due Care and Attention None Thimblemill Road Thimblemill Road Sandwell Sandwell Education N/A   52.4801354 -1.9749821
14089 op-snap---monthly-publication-june-2025.pdf   18 2025-06 Car BMW 218I Grey Driving without Due Care and Attention None M42 Junction with M6 M42 Junction with M6 Birmingham Birmingham Education N/A      
14147 op-snap---monthly-publication-june-2025.pdf   76 2025-06 Pedal Bike BMW IX8 White Driving without Due Care and Attention None Clarence Road Clarence Road Sutton Coldfield Sutton Coldfield Education N/A   52.5940902 -1.843503
14149 op-snap---monthly-publication-june-2025.pdf   78 2025-06 Car BMW 320D Black Driving without Due Care and Attention None Bordsley Circus Bordsley Circus Birmingham Birmingham Education N/A      
14179 op-snap---monthly-publication-june-2025.pdf   108 2025-06 Pedal Bike BMW X5 Silver Driving without Due Care and Attention None Danford Lane Danford Lane Solihull Solihull Education N/A   52.4092804 -1.8056214
14215 op-snap---monthly-publication-june-2025.pdf   144 2025-06 Car BMW 125 D. Grey Driving without Due Care and Attention None Church Avenue Amblecotte Church Avenue Amblecotte Dudley Dudley Education N/A      
14385 op-snap---monthly-publication-june-2025.pdf   314 2025-06 Car BMW 330 Grey Driving without Due Care and Attention None Montague St Montague Street Birmingham Birmingham Education N/A   52.4816806 -1.8788939

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