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

125 rows where disposal = "Education", offence = "Driving without Due Care and Attention" and vehicle_make = "Audi" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: source_file, vehicle_colour, council_area_raw, nfa_rationale

month 14

  • 2025-06 17
  • 2025-05 15
  • 2025-07 15
  • 2026-02 14
  • 2025-10 12
  • 2025-08 10
  • 2026-01 10
  • 2025-03 8
  • 2025-11 8
  • 2025-09 6
  • 2025-01 4
  • 2025-12 3
  • 2025-04 2
  • 2025-02 1

council_area 9

  • Birmingham 77
  • Coventry 15
  • Dudley 8
  • Solihull 7
  • Sandwell 6
  • Walsall 6
  • Sutton Coldfield 3
  • Wolverhampton 2
  • Borirt Mrionagdham 1

reporter_transport_mode 5

  • Car 85
  • Pedal Bike 35
  • Other 3
  • Motorbike 1
  • Pedestrian 1

vehicle_make 1

  • Audi · 125 ✖

offence 1

  • Driving without Due Care and Attention · 125 ✖

disposal 1

  • Education · 125 ✖
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
7658 op-snap---monthly-publication-february-2026.pdf   405 2026-02 Car Audi A4 Red Driving without Due Care and Attention None Hustcroft Road Hustcroft Road Birmingham Birmingham Education N/A      
7685 op-snap---monthly-publication-february-2026.pdf   432 2026-02 Car Audi Q2 Blue Driving without Due Care and Attention None Leamore Lane Leamore Lane Walsall Walsall Education N/A   52.6056653 -2.0050776
7862 op-snap---monthly-publication-february-2026.pdf   609 2026-02 Pedal Bike Audi TT Blue Driving without Due Care and Attention None Hagley Road West Hagley Road West Birmingham Birmingham Education N/A   52.4656414 -1.9852276
7943 op-snap---monthly-publication-february-2026.pdf   690 2026-02 Car Audi   Red Driving without Due Care and Attention None West Boulevard West Boulevard Birmingham Birmingham Education N/A   52.4484674 -1.9780395
8025 op-snap---monthly-publication-february-2026.pdf   772 2026-02 Pedal Bike Audi Q2 White Driving without Due Care and Attention None High Street High Street Solihull Solihull Education N/A   52.4064169 -1.8557215
8103 op-snap---monthly-publication-february-2026.pdf   850 2026-02 Pedal Bike Audi Q3 White Driving without Due Care and Attention None Hearsall Lane Hearsall Lane Coventry Coventry Education N/A   52.4064125 -1.5320113
8282 op-snap---monthly-publication-february-2026.pdf   1029 2026-02 Pedal Bike Audi A6 Silver Driving without Due Care and Attention None Kingsbury Road Kingsbury Road Birmingham Birmingham Education N/A   52.5292752 -1.7618805
8487 op-snap---monthly-publication-february-2026.pdf   1234 2026-02 Other Audi A3 Grey Driving without Due Care and Attention None High Street High Street Dudley Dudley Education N/A   52.4779764 -2.1598371
8574 op-snap---monthly-publication-february-2026.pdf   1321 2026-02 Car Audi RS3 Grey Driving without Due Care and Attention None Coventry Road Coventry Road Birmingham Birmingham Education N/A   52.4726661 -1.8769032
8579 op-snap---monthly-publication-february-2026.pdf   1326 2026-02 Pedal Bike Audi A6 Grey Driving without Due Care and Attention None Olton Boulevard East Olton Boulevard East Birmingham Birmingham Education N/A   52.4421599 -1.829532
8615 op-snap---monthly-publication-february-2026.pdf   1362 2026-02 Car Audi RS3 Grey Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
8691 op-snap---monthly-publication-february-2026.pdf   1438 2026-02 Car Audi Q3 White Driving without Due Care and Attention None Dads Lane Dads Lane Birmingham Birmingham Education N/A   52.4375913 -1.9068522
8780 op-snap---monthly-publication-february-2026.pdf   1527 2026-02 Car Audi Q6 White Driving without Due Care and Attention None A454 Black Country Route Black Country Route Walsall Walsall Education N/A   52.5736488 -2.0492151
8787 op-snap---monthly-publication-february-2026.pdf   1534 2026-02 Pedal Bike Audi Q3.. Blue Driving without Due Care and Attention None Wagon Lane Wagon Lane Birmingham Birmingham Education N/A   52.4546868 -1.793848
10584 op-snap---monthly-publication-january-2026.pdf   45 2026-01 Car Audi Q3.. Black Driving without Due Care and Attention None Kitts Green Road Kitts Green Road Birmingham Birmingham Education N/A   52.4815372 -1.7766518
10901 op-snap---monthly-publication-january-2026.pdf   362 2026-01 Car Audi A5 Black Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
10994 op-snap---monthly-publication-january-2026.pdf   455 2026-01 Pedal Bike Audi A3 Blue Driving without Due Care and Attention None Camp Hill Circus Camp Hill Circus Birmingham Birmingham Education N/A   52.4682339 -1.8793662
11244 op-snap---monthly-publication-january-2026.pdf   705 2026-01 Car Audi A3 Black Driving without Due Care and Attention None A4540 Dartmouth Middleway Dartmouth Middleway Birmingham Birmingham Education N/A   52.4861917 -1.8829748
11250 op-snap---monthly-publication-january-2026.pdf   711 2026-01 Car Audi RS3 Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Walsall Walsall Education N/A   52.5723244 -1.9607214
11292 op-snap---monthly-publication-january-2026.pdf   753 2026-01 Car Audi RS 3 Black Driving without Due Care and Attention None Bordesley Green Road Bordesley Green Road Birmingham Birmingham Education N/A   52.4804926 -1.8563658
11305 op-snap---monthly-publication-january-2026.pdf   766 2026-01 Car Audi A4 Black Driving without Due Care and Attention None Bridgnorth Road Bridgnorth Road Birmingham Birmingham Education N/A   52.4758675 -1.7882992
11451 op-snap---monthly-publication-january-2026.pdf   912 2026-01 Pedal Bike Audi A3 Grey Driving without Due Care and Attention None Broad Lane Broad Lane Coventry Coventry Education N/A   52.4074716 -1.5620671
11755 op-snap---monthly-publication-january-2026.pdf   1216 2026-01 Pedestrian Audi Q2 Grey Driving without Due Care and Attention None Cotford Road Cotford Road Birmingham Birmingham Education N/A   52.4062317 -1.8814294
11805 op-snap---monthly-publication-january-2026.pdf   1266 2026-01 Car Audi A3 White Driving without Due Care and Attention None Church Road at Lichfield Road Aston Church Road at Lichfield Road Aston Birmingham Birmingham Education N/A   52.4645103 -1.8152682
4585 op-snap---monthly-publication-december-2025.pdf   713 2025-12 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Broad Lane, Coventry Broad Lane, Coventry Coventry Coventry Education N/A   52.4144409 -1.5990259
4775 op-snap---monthly-publication-december-2025.pdf   903 2025-12 Car Audi A1 White Driving without Due Care and Attention None Vauxhall Road Vauxhall Road Birmingham Birmingham Education N/A   52.4834623 -1.8796522
4925 op-snap---monthly-publication-december-2025.pdf   1053 2025-12 Pedal Bike Audi A3 Blue Driving without Due Care and Attention None Edward Road / Lincoln Street Edward Road / Lincoln Street Birmingham Birmingham Education N/A   52.4580901 -1.894458
20468 op-snap---monthly-publication-november-2025.pdf   10 2025-11 Pedal Bike Audi A3.. White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
20502 op-snap---monthly-publication-november-2025.pdf   44 2025-11 Car Audi A3 Blue Driving without Due Care and Attention None Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
20515 op-snap---monthly-publication-november-2025.pdf   57 2025-11 Other Audi   Black Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
20524 op-snap---monthly-publication-november-2025.pdf   66 2025-11 Car Audi Q3 Grey Driving without Due Care and Attention None Priory Road / Bristol Road Priory Road / Bristol Road Birmingham Birmingham Education N/A   52.4552604 -1.9104552
20626 op-snap---monthly-publication-november-2025.pdf   168 2025-11 Car Audi A4 Black Driving without Due Care and Attention None Coventry Ring Road Coventry Ring Road Coventry Coventry Education N/A      
21237 op-snap---monthly-publication-november-2025.pdf   779 2025-11 Pedal Bike Audi A4 Black Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
21318 op-snap---monthly-publication-november-2025.pdf   860 2025-11 Motorbike Audi A3 Grey Driving without Due Care and Attention None M42 J7 M42 J7 Birmingham Birmingham Education N/A      
21436 op-snap---monthly-publication-november-2025.pdf   978 2025-11 Car Audi A3 Black Driving without Due Care and Attention None Bentley Mill Way Bentley Mill Way Walsall Walsall Education N/A   52.5786876 -2.0165115
22112 op-snap---monthly-publication-october-2025.pdf   62 2025-10 Pedal Bike Audi Q2 Grey Driving without Due Care and Attention None Five Ways Roundabout Five Ways Roundabout Birmingham Birmingham Education N/A      
22165 op-snap---monthly-publication-october-2025.pdf   115 2025-10 Car Audi A3 Grey Driving without Due Care and Attention None City Road City Road Birmingham Birmingham Education N/A   52.4763176 -1.9584897
22248 op-snap---monthly-publication-october-2025.pdf   198 2025-10 Car Audi Q4 Blue Driving without Due Care and Attention None Meadway Meadway Birmingham Birmingham Education N/A   52.4783348 -1.8007708
22265 op-snap---monthly-publication-october-2025.pdf   215 2025-10 Car Audi A3 Grey Driving without Due Care and Attention None Garratts Green Lane Garratts Green Lane Birmingham Birmingham Education N/A      
22504 op-snap---monthly-publication-october-2025.pdf   454 2025-10 Car Audi A4 Black Driving without Due Care and Attention None Fern Road, Erdington Fern Road, Erdington Birmingham Birmingham Education N/A   52.5215217 -1.8359393
22564 op-snap---monthly-publication-october-2025.pdf   514 2025-10 Car Audi Q2 Black Driving without Due Care and Attention None Tyburn Island Tyburn Island Birmingham Birmingham Education N/A   52.5193542 -1.800381
22595 op-snap---monthly-publication-october-2025.pdf   545 2025-10 Pedal Bike Audi Q3 Silver Driving without Due Care and Attention None Lode Lane Lode Lane Solihull Solihull Education N/A   52.4149064 -1.7832364
22705 op-snap---monthly-publication-october-2025.pdf   655 2025-10 Car Audi A3 Red Driving without Due Care and Attention None Damson Parkway Damson Parkway Solihull Solihull Education N/A   52.437016 -1.7578446
22750 op-snap---monthly-publication-october-2025.pdf   700 2025-10 Pedal Bike Audi A7 Black Driving without Due Care and Attention None Wednesfield Way Wednesfield Way Wolverhampton Wolverhampton Education N/A   52.59548 -2.0896906
22817 op-snap---monthly-publication-october-2025.pdf   767 2025-10 Car Audi S3 Grey Driving without Due Care and Attention None Wake Green Road Wake Green Road Birmingham Birmingham Education N/A   52.4437078 -1.8783408
22847 op-snap---monthly-publication-october-2025.pdf   797 2025-10 Pedal Bike Audi   Silver Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
22942 op-snap---monthly-publication-october-2025.pdf   892 2025-10 Car Audi A1 White Driving without Due Care and Attention None Heartlands Parkway Heartlands Parkway Birmingham Birmingham Education N/A   52.5038363 -1.8432663
23932 op-snap---monthly-publication-september-2025.pdf   151 2025-09 Car Audi Q7.. Grey Driving without Due Care and Attention None Spitfire island Spitfire island Birmingham Birmingham Education N/A   52.5138106 -1.797297
24424 op-snap---monthly-publication-september-2025.pdf   643 2025-09 Other Audi A5 Grey Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
24501 op-snap---monthly-publication-september-2025.pdf   720 2025-09 Car Audi Q2 Grey Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
24608 op-snap---monthly-publication-september-2025.pdf   827 2025-09 Pedal Bike Audi A5 Red Driving without Due Care and Attention None Newton Road Newton Road Sandwell Sandwell Education N/A   52.5428224 -1.9569444
24744 op-snap---monthly-publication-september-2025.pdf   963 2025-09 Car Audi RS Black Driving without Due Care and Attention None St Marys Row Moseley Street Marys Row Moseley Birmingham Birmingham Education N/A      
24807 op-snap---monthly-publication-september-2025.pdf   1026 2025-09 Car Audi Q7 Blue Driving without Due Care and Attention None Jimmy Hill Way Jimmy Hill Way Coventry Coventry Education N/A   52.4214017 -1.4870278
2400 op-snap---monthly-publication-august-2025.pdf   375 2025-08 Car Audi TT Grey Driving without Due Care and Attention None Cole Hall Lane Cole Hall Lane Birmingham Birmingham Education N/A   52.4877244 -1.787883
2435 op-snap---monthly-publication-august-2025.pdf   410 2025-08 Car Audi SQ5 White Driving without Due Care and Attention None Daventry Road Daventry Road Coventry Coventry Education N/A   52.3930931 -1.4976428
2532 op-snap---monthly-publication-august-2025.pdf   507 2025-08 Pedal Bike Audi RS5 White Driving without Due Care and Attention None Maryvale Road Maryvale Road Birmingham Birmingham Education N/A      
2671 op-snap---monthly-publication-august-2025.pdf   646 2025-08 Car Audi A4 Blue Driving without Due Care and Attention None Olton Boulevard East Olton Boulevard East Solihull Solihull Education N/A   52.4430078 -1.8124079
2909 op-snap---monthly-publication-august-2025.pdf   884 2025-08 Car Audi Q5 White Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry Education N/A   52.4103629 -1.5441218
2964 op-snap---monthly-publication-august-2025.pdf   939 2025-08 Car Audi Electric Grey Driving without Due Care and Attention None Tamworth Road and Long Lane Tamworth Road and Long Lane Coventry Coventry Education N/A   52.4380313 -1.5339558
3054 op-snap---monthly-publication-august-2025.pdf   1029 2025-08 Car Audi A6 White Driving without Due Care and Attention None Cole Hall Lane Cole Hall Lane Birmingham Birmingham Education N/A   52.4877244 -1.787883
3080 op-snap---monthly-publication-august-2025.pdf   1055 2025-08 Car Audi Q7.. Grey Driving without Due Care and Attention None Birmingham Road Birmingham Road Sutton Coldfield Sutton Coldfield Education N/A   52.5361464 -1.8270283
3147 op-snap---monthly-publication-august-2025.pdf   1122 2025-08 Pedal Bike Audi A4 Blue Driving without Due Care and Attention None Buryfield Road Buryfield Road Solihull Solihull Education N/A   52.4244296 -1.7823135
3197 op-snap---monthly-publication-august-2025.pdf   1172 2025-08 Car Audi A1 Grey Driving without Due Care and Attention None Wall Heath High Street (A449) Wall Heath High Street (A449) Dudley Dudley Education N/A   52.5042414 -2.1793362
11991 op-snap---monthly-publication-july-2025.pdf   43 2025-07 Pedal Bike Audi A3 Silver Driving without Due Care and Attention None Wolverhampton Road Wolverhampton Road Wolverhampton Wolverhampton Education N/A   52.5968709 -2.0954054
12170 op-snap---monthly-publication-july-2025.pdf   222 2025-07 Car Audi A8 Black Driving without Due Care and Attention None Bearwood Road Bearwood Road Birmingham Birmingham Education N/A   52.4762784 -1.9678366
12380 op-snap---monthly-publication-july-2025.pdf   432 2025-07 Pedal Bike Audi A3 Black Driving without Due Care and Attention None Moor Green Lane Moor Green Lane Birmingham Birmingham Education N/A   52.4374665 -1.9119895
12424 op-snap---monthly-publication-july-2025.pdf   476 2025-07 Car Audi SQ5 Black Driving without Due Care and Attention None Vicarage Road Vicarage Road Sandwell Sandwell Education N/A   52.5573855 -2.0133095
12462 op-snap---monthly-publication-july-2025.pdf   514 2025-07 Pedal Bike Audi Q3 White Driving without Due Care and Attention None Kenilworth Road Knowle Kenilworth Road Knowle Solihull Solihull Education N/A   52.3877147 -1.732243
12503 op-snap---monthly-publication-july-2025.pdf   555 2025-07 Car Audi Q5 Grey Driving without Due Care and Attention None M6 Motorway, Southbound, nr Jn4A M6 Motorway, Southbound, nr Jn4A Birmingham Birmingham Education N/A      
12692 op-snap---monthly-publication-july-2025.pdf   744 2025-07 Car Audi SQ5. Black Driving without Due Care and Attention None Tipton Road Tipton Road Dudley Dudley Education N/A   52.5198386 -2.0740876
12694 op-snap---monthly-publication-july-2025.pdf   746 2025-07 Car Audi A4.. Grey Driving without Due Care and Attention None A452 Tyburn House Island Tyburn House Island Birmingham Birmingham Education N/A   52.5194011 -1.8008643
12724 op-snap---monthly-publication-july-2025.pdf   776 2025-07 Pedal Bike Audi A4.. White Driving without Due Care and Attention None Hagley Road (5 ways underpass) Hagley Road (5 ways underpass) Birmingham Birmingham Education N/A      
12725 op-snap---monthly-publication-july-2025.pdf   777 2025-07 Car Audi A1 Red Driving without Due Care and Attention None Bulls Head Lane Bulls Head Lane Coventry Coventry Education N/A   52.4026553 -1.4800859
12810 op-snap---monthly-publication-july-2025.pdf   862 2025-07 Car Audi S4 Grey Driving without Due Care and Attention None A38 A38 Birmingham Birmingham Education N/A      
12814 op-snap---monthly-publication-july-2025.pdf   866 2025-07 Car Audi Q5 Grey Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
12927 op-snap---monthly-publication-july-2025.pdf   979 2025-07 Car Audi S3.. Blue Driving without Due Care and Attention None Coleshill Heath Road Coleshill Heath Road Birmingham Birmingham Education N/A   52.5608671 -1.8128269
13052 op-snap---monthly-publication-july-2025.pdf   1104 2025-07 Car Audi A4 Black Driving without Due Care and Attention None Castle Bromwich Interchange to Newp Castle Bromwich Interchange to Newp Borirt mRionagdham Borirt Mrionagdham Education N/A      
13222 op-snap---monthly-publication-july-2025.pdf   1274 2025-07 Car Audi A3 White Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
14134 op-snap---monthly-publication-june-2025.pdf   63 2025-06 Pedal Bike Audi A1 White Driving without Due Care and Attention None Birmingham Road Birmingham Road Dudley Dudley Education N/A   52.5131355 -2.0651615
14238 op-snap---monthly-publication-june-2025.pdf   167 2025-06 Pedal Bike Audi Q5 Black Driving without Due Care and Attention None Salibsury Road Salibsury Road Birmingham Birmingham Education N/A      
14253 op-snap---monthly-publication-june-2025.pdf   182 2025-06 Car Audi A4 Black Driving without Due Care and Attention None School Road School Road Birmingham Birmingham Education N/A   52.4161736 -1.8619692
14297 op-snap---monthly-publication-june-2025.pdf   226 2025-06 Car Audi A3 Black Driving without Due Care and Attention None KINGSTON ROAD Kingston Road Birmingham Birmingham Education N/A   52.4747333 -1.8728345
14379 op-snap---monthly-publication-june-2025.pdf   308 2025-06 Car Audi A3 Grey Driving without Due Care and Attention None MONTAGUE STREET Montague Street Birmingham Birmingham Education N/A   52.4816806 -1.8788939
14493 op-snap---monthly-publication-june-2025.pdf   422 2025-06 Car Audi A4... Grey Driving without Due Care and Attention None Truemans Heath Lane Truemans Heath Lane Birmingham Birmingham Education N/A      
14506 op-snap---monthly-publication-june-2025.pdf   435 2025-06 Car Audi Q7 Black Driving without Due Care and Attention None Alcester Road Alcester Road Birmingham Birmingham Education N/A   52.4470686 -1.8880749
14533 op-snap---monthly-publication-june-2025.pdf   462 2025-06 Car Audi Q7 Black Driving without Due Care and Attention None Foleshill Road Foleshill Road Coventry Coventry Education N/A   52.4274335 -1.5002381
14698 op-snap---monthly-publication-june-2025.pdf   627 2025-06 Pedal Bike Audi A5 Black Driving without Due Care and Attention None Rochester Road Rochester Road Coventry Coventry Education N/A   52.3974085 -1.5422796
14708 op-snap---monthly-publication-june-2025.pdf   637 2025-06 Pedal Bike Audi Q3.. Black Driving without Due Care and Attention None Bloomfield Road Bloomfield Road Sandwell Sandwell Education N/A   52.5377733 -2.0733724
14854 op-snap---monthly-publication-june-2025.pdf   783 2025-06 Car Audi S4 Blue Driving without Due Care and Attention None Birmingham Road Birmingham Road Sandwell Sandwell Education N/A   52.5461417 -1.9334193
15117 op-snap---monthly-publication-june-2025.pdf   1046 2025-06 Car Audi Q2 Silver Driving without Due Care and Attention None Oxleys Road Oxleys Road Sutton Coldfield Sutton Coldfield Education N/A      
15260 op-snap---monthly-publication-june-2025.pdf   1189 2025-06 Car Audi RS6 Blue Driving without Due Care and Attention None Birchfield Road A34 Birchfield Road A34 Birmingham Birmingham Education N/A   52.5170745 -1.9012542
15276 op-snap---monthly-publication-june-2025.pdf   1205 2025-06 Car Audi A3 Black Driving without Due Care and Attention None Yardley Wood Road Yardley Wood Road Birmingham Birmingham Education N/A   52.4103191 -1.8670224
15563 op-snap---monthly-publication-june-2025.pdf   1492 2025-06 Car Audi A4 Blue Driving without Due Care and Attention None M6 Link with M5 M6 Link with M5 Birmingham Birmingham Education N/A      
15644 op-snap---monthly-publication-june-2025.pdf   1573 2025-06 Car Audi A6 Black Driving without Due Care and Attention None Heartlands Parkway Heartlands Parkway Birmingham Birmingham Education N/A   52.5038363 -1.8432663
15746 op-snap---monthly-publication-june-2025.pdf   1675 2025-06 Car Audi RS3 Grey Driving without Due Care and Attention None Cementery Lane Cementery Lane Dudley Dudley Education N/A      
19097 op-snap---monthly-publication-may-2025.pdf   459 2025-05 Pedal Bike Audi TT Silver Driving without Due Care and Attention None BEDWORTH ROAD Bedworth Road Coventry Coventry Education N/A   52.4554838 -1.4848593
19295 op-snap---monthly-publication-may-2025.pdf   657 2025-05 Car Audi A1 Blue Driving without Due Care and Attention None Kettlehouse Road Kettlehouse Road Birmingham Birmingham Education N/A   52.5546392 -1.8859041
19312 op-snap---monthly-publication-may-2025.pdf   674 2025-05 Car Audi RS 5 Grey Driving without Due Care and Attention None M6 Southbound M6 Southbound Birmingham Birmingham Education N/A      
19387 op-snap---monthly-publication-may-2025.pdf   749 2025-05 Car Audi A5 Grey Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929
19389 op-snap---monthly-publication-may-2025.pdf   751 2025-05 Car Audi A3.. Black Driving without Due Care and Attention None Warwick Road Warwick Road Birmingham Birmingham Education N/A   52.4555288 -1.8613929

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