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

85 rows where month = "2025-11", offence = "Driving without Due Care and Attention" and reporter_transport_mode = "Pedal Bike" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, council_area_raw, nfa_rationale

vehicle_make 29

  • Ford 11
  • Mercedes-Benz 8
  • BMW 7
  • Peugeot 7
  • Toyota 6
  • Vauxhall 5
  • Volkswagen 5
  • Honda 3
  • Kia 3
  • Land Rover 3
  • Nissan 3
  • Audi 2
  • Byd 2
  • London Taxi 2
  • Skoda 2
  • Volvo 2
  • Citroen 1
  • Dacia 1
  • Fiat 1
  • Hyundai 1
  • Jaguar 1
  • Lexus 1
  • Mazda 1
  • Mg 1
  • Mini 1
  • Porsche 1
  • Renault 1
  • Seat 1
  • Suzuki 1

council_area 9

  • Birmingham 47
  • Coventry 15
  • Out of Force Area 7
  • Solihull 7
  • Dudley 3
  • Walsall 2
  • Wolverhampton 2
  • Halesowen 1
  • Sutton Coldfield 1

disposal 6

  • Education 43
  • NFA 17
  • Warning Letter 14
  • Court 7
  • Fixed Penalty 3
  • Other Action Taken 1

reporter_transport_mode 1

  • Pedal Bike · 85 ✖

offence 1

  • Driving without Due Care and Attention · 85 ✖

month 1

  • 2025-11 · 85 ✖
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
20464 op-snap---monthly-publication-november-2025.pdf   6 2025-11 Pedal Bike Vauxhall Astra Red Driving without Due Care and Attention None Upper Clifton Road Upper Clifton Road Sutton Coldfield Sutton Coldfield Education N/A   52.5664481 -1.8270564
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
20488 op-snap---monthly-publication-november-2025.pdf   30 2025-11 Pedal Bike London Taxi taxi Black Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
20492 op-snap---monthly-publication-november-2025.pdf   34 2025-11 Pedal Bike Byd Bus Grey Driving without Due Care and Attention None Hale Street Hale Street Coventry Coventry NFA No Offence      
20517 op-snap---monthly-publication-november-2025.pdf   59 2025-11 Pedal Bike Kia Ceed Brown Driving without Due Care and Attention None A444 Jimmy Hill Way Jimmy Hill Way Coventry Coventry Education N/A   52.4214017 -1.4870278
20520 op-snap---monthly-publication-november-2025.pdf   62 2025-11 Pedal Bike Jaguar XF Black Driving without Due Care and Attention No Insurance Stretton Sugwas (Hereford) Stretton Sugwas (Hereford) Out of Force Area Out of Force Area NFA Out of Force      
20534 op-snap---monthly-publication-november-2025.pdf   76 2025-11 Pedal Bike Mercedes-Benz Sprinter White Driving without Due Care and Attention None Longdales Road Longdales Road Birmingham Birmingham Warning Letter N/A   52.3947881 -1.9285109
20561 op-snap---monthly-publication-november-2025.pdf   103 2025-11 Pedal Bike Toyota Yaris Red Driving without Due Care and Attention None Witherford Way Witherford Way Birmingham Birmingham Warning Letter N/A   52.4346604 -1.9538812
20609 op-snap---monthly-publication-november-2025.pdf   151 2025-11 Pedal Bike Citroen Berlingo Silver Driving without Due Care and Attention None Solihull Lane Solihull Lane Birmingham Birmingham Education N/A   52.4230862 -1.8347873
20610 op-snap---monthly-publication-november-2025.pdf   152 2025-11 Pedal Bike Land Rover Discovery Grey Driving without Due Care and Attention None St Bernards Road Street Bernards Road Solihull Solihull Education N/A      
20614 op-snap---monthly-publication-november-2025.pdf   156 2025-11 Pedal Bike Ford Focus White Driving without Due Care and Attention None Counden Wedge Drive Counden Wedge Drive Coventry Coventry Education N/A      
20621 op-snap---monthly-publication-november-2025.pdf   163 2025-11 Pedal Bike Kia Picanto Silver Driving without Due Care and Attention None Widney Manor Road Widney Manor Road Solihull Solihull Education N/A   52.3902967 -1.7659209
20663 op-snap---monthly-publication-november-2025.pdf   205 2025-11 Pedal Bike Mercedes-Benz Tractor White Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Warning Letter N/A   52.5359496 -1.8324115
20665 op-snap---monthly-publication-november-2025.pdf   207 2025-11 Pedal Bike Peugeot 308 Active Black Driving without Due Care and Attention None Blackwood Road Blackwood Road Birmingham Birmingham Warning Letter N/A   52.5529452 -1.909824
20700 op-snap---monthly-publication-november-2025.pdf   242 2025-11 Pedal Bike Mercedes-Benz C180 Grey Driving without Due Care and Attention None Chester Road Chester Road Birmingham Birmingham Education N/A   52.5359496 -1.8324115
20703 op-snap---monthly-publication-november-2025.pdf   245 2025-11 Pedal Bike BMW 330E Black Driving without Due Care and Attention Drive otherwise than in accordance with a licence Foleshill Road Foleshill Road Coventry Coventry Court N/A   52.4274335 -1.5002381
20722 op-snap---monthly-publication-november-2025.pdf   264 2025-11 Pedal Bike Mg HS Red Driving without Due Care and Attention None Kenilworth Road Kenilworth Road Solihull Solihull NFA No Independent Evidence Available   52.4322443 -1.6746508
20724 op-snap---monthly-publication-november-2025.pdf   266 2025-11 Pedal Bike Volkswagen Golf Blue Driving without Due Care and Attention None Blackhalve Lane Blackhalve Lane Out of Force Area Out of Force Area NFA Out of Force   52.6139368 -2.0960778
20725 op-snap---monthly-publication-november-2025.pdf   267 2025-11 Pedal Bike Dacia Sandero Blue Driving without Due Care and Attention None Teddesley Road (Staffs) Teddesley Road (Staffs) Out of Force Area Out of Force Area NFA Out of Force      
20743 op-snap---monthly-publication-november-2025.pdf   285 2025-11 Pedal Bike Toyota Auris Blue Driving without Due Care and Attention None Lucknow Road Lucknow Road Wolverhampton Wolverhampton Fixed Penalty N/A      
20750 op-snap---monthly-publication-november-2025.pdf   292 2025-11 Pedal Bike Mercedes-Benz Sprinter Silver Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
20751 op-snap---monthly-publication-november-2025.pdf   293 2025-11 Pedal Bike Volkswagen Golf Black Driving without Due Care and Attention None Robin Hood Lane Robin Hood Lane Birmingham Birmingham Education N/A   52.4221526 -1.8425617
20759 op-snap---monthly-publication-november-2025.pdf   301 2025-11 Pedal Bike Ford Fiesta Red Driving without Due Care and Attention None Wretham Street Wretham Street Birmingham Birmingham Education N/A      
20761 op-snap---monthly-publication-november-2025.pdf   303 2025-11 Pedal Bike Vauxhall Corsa White Driving without Due Care and Attention None Umberslade Road Umberslade Road Birmingham Birmingham Education N/A   52.4304526 -1.9216716
20762 op-snap---monthly-publication-november-2025.pdf   304 2025-11 Pedal Bike Kia Niro Grey Driving without Due Care and Attention None Moat Road Moat Road Walsall Walsall Education N/A   52.5848413 -1.9996882
20765 op-snap---monthly-publication-november-2025.pdf   307 2025-11 Pedal Bike Peugeot 3008 GT Brown Driving without Due Care and Attention None Widney Road Widney Road Solihull Solihull Warning Letter N/A   52.3795667 -1.7478958
20784 op-snap---monthly-publication-november-2025.pdf   326 2025-11 Pedal Bike Mazda 6 SE Silver Driving without Due Care and Attention None Black Haynes Road Black Haynes Road Birmingham Birmingham Warning Letter N/A   52.4260755 -1.9679443
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
20791 op-snap---monthly-publication-november-2025.pdf   333 2025-11 Pedal Bike Peugeot 208GT Yellow Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
20792 op-snap---monthly-publication-november-2025.pdf   334 2025-11 Pedal Bike Suzuki Swift Silver Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
20839 op-snap---monthly-publication-november-2025.pdf   381 2025-11 Pedal Bike Mercedes-Benz S350 Black Driving without Due Care and Attention None Highfield Road Highfield Road Birmingham Birmingham Education N/A   52.4216321 -1.855984
20854 op-snap---monthly-publication-november-2025.pdf   396 2025-11 Pedal Bike Mercedes-Benz A200 White Driving without Due Care and Attention None Bradford Street Bradford Street Birmingham Birmingham Warning Letter N/A   52.4708802 -1.8792135
20860 op-snap---monthly-publication-november-2025.pdf   402 2025-11 Pedal Bike Ford Transit White Driving without Due Care and Attention None Coleshill Heath Road Coleshill Heath Road Solihull Solihull Education N/A   52.4667242 -1.7283592
20968 op-snap---monthly-publication-november-2025.pdf   510 2025-11 Pedal Bike Mini One White Driving without Due Care and Attention None Ledbury, West Mercia Ledbury, West Mercia Out of Force Area Out of Force Area NFA Out of Force      
21064 op-snap---monthly-publication-november-2025.pdf   606 2025-11 Pedal Bike Renault Trafic White Driving without Due Care and Attention None Tennal Lane Tennal Lane Birmingham Birmingham Fixed Penalty N/A   52.4577809 -1.9796585
21084 op-snap---monthly-publication-november-2025.pdf   626 2025-11 Pedal Bike Honda HR-V Grey Driving without Due Care and Attention None Spiceland Road, Northfield Spiceland Road, Northfield Birmingham Birmingham Education N/A   52.4240276 -1.9735466
21236 op-snap---monthly-publication-november-2025.pdf   778 2025-11 Pedal Bike Ford Transit White Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Education N/A   52.4094108 -1.9930633
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
21239 op-snap---monthly-publication-november-2025.pdf   781 2025-11 Pedal Bike Land Rover Discovery Black Driving without Due Care and Attention None Frankley Beeches Road Frankley Beeches Road Birmingham Birmingham Warning Letter N/A   52.4094108 -1.9930633
21241 op-snap---monthly-publication-november-2025.pdf   783 2025-11 Pedal Bike Fiat 500 White Driving without Due Care and Attention None Bristol Road Bristol Road Birmingham Birmingham Warning Letter N/A   52.4543565 -1.9114004
21242 op-snap---monthly-publication-november-2025.pdf   784 2025-11 Pedal Bike Toyota Yaris Black Driving without Due Care and Attention None Ashleigh Road Ashleigh Road Birmingham Birmingham Warning Letter N/A   52.5124638 -1.9824678
21298 op-snap---monthly-publication-november-2025.pdf   840 2025-11 Pedal Bike Peugeot 2008 Grey Driving without Due Care and Attention None Rochester Road Rochester Road Coventry Coventry NFA No Offence   52.3974085 -1.5422796
21388 op-snap---monthly-publication-november-2025.pdf   930 2025-11 Pedal Bike Byd Temsa Coach White Driving without Due Care and Attention None Lawrence Sanders Road Lawrence Sanders Road Coventry Coventry NFA No Offence      
21389 op-snap---monthly-publication-november-2025.pdf   931 2025-11 Pedal Bike Volkswagen Scirocco Red Driving without Due Care and Attention None Linthouse Lane Linthouse Lane Wolverhampton Wolverhampton Education N/A   52.6118187 -2.0810618
21405 op-snap---monthly-publication-november-2025.pdf   947 2025-11 Pedal Bike Ford Ranger Orange Driving without Due Care and Attention None A456 Manor Way Manor Way Halesowen Halesowen Education N/A   52.5203602 -1.824434
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
21413 op-snap---monthly-publication-november-2025.pdf   955 2025-11 Pedal Bike Nissan Juke Black Driving without Due Care and Attention None Witton Road Witton Road Birmingham Birmingham Education N/A   52.513336 -1.8833226
21414 op-snap---monthly-publication-november-2025.pdf   956 2025-11 Pedal Bike Ford Transit White Driving without Due Care and Attention None Witton Road Witton Road Birmingham Birmingham NFA No Independent Evidence Available   52.513336 -1.8833226
21458 op-snap---monthly-publication-november-2025.pdf   1000 2025-11 Pedal Bike Ford Transit Black Driving without Due Care and Attention None Leighswood Road Leighswood Road Walsall Walsall Education N/A   52.6071662 -1.9231466
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
21467 op-snap---monthly-publication-november-2025.pdf   1009 2025-11 Pedal Bike Mercedes-Benz Citan grey Driving without Due Care and Attention None South Road, B4186, Stourbridge South Road, B4186, Stourbridge Dudley Dudley Education N/A   52.45108 -2.1531606
21471 op-snap---monthly-publication-november-2025.pdf   1013 2025-11 Pedal Bike Ford Focus Silver Driving without Due Care and Attention None Stoney Stanton Road Stoney Stanton Road Coventry Coventry Education N/A   52.4221152 -1.4959475
21488 op-snap---monthly-publication-november-2025.pdf   1030 2025-11 Pedal Bike Land Rover Discovery Silver Driving without Due Care and Attention None Ballsall St Ballsall Street Solihull Solihull Warning Letter N/A      
21494 op-snap---monthly-publication-november-2025.pdf   1036 2025-11 Pedal Bike Peugeot Expert White Driving without Due Care and Attention None Albany Road Albany Road Coventry Coventry Court N/A   52.4006218 -1.5284125
21516 op-snap---monthly-publication-november-2025.pdf   1058 2025-11 Pedal Bike Hyundai i10 Black Driving without Due Care and Attention Use vehicle on a road without valid test certificate Camp Hill Road Camp Hill Road Birmingham Birmingham Court N/A   52.4306415 -1.9041558
21517 op-snap---monthly-publication-november-2025.pdf   1059 2025-11 Pedal Bike Nissan Qashqai Blue Driving without Due Care and Attention None Camp Hill Road Camp Hill Road Birmingham Birmingham Fixed Penalty N/A   52.4306415 -1.9041558
21545 op-snap---monthly-publication-november-2025.pdf   1087 2025-11 Pedal Bike Ford Mondeo Black Driving without Due Care and Attention None School Road, Kings Heath School Road, Kings Heath Birmingham Birmingham Education N/A   52.4384417 -1.8875299
21546 op-snap---monthly-publication-november-2025.pdf   1088 2025-11 Pedal Bike Mercedes-Benz GLE Blue Driving without Due Care and Attention None Church Road, Edgbaston Church Road, Edgbaston Birmingham Birmingham Warning Letter N/A   52.46114 -1.9180882
21551 op-snap---monthly-publication-november-2025.pdf   1093 2025-11 Pedal Bike London Taxi Taxi Black Driving without Due Care and Attention None Croft Road Croft Road Coventry Coventry Education N/A   52.4064698 -1.5167474
21558 op-snap---monthly-publication-november-2025.pdf   1100 2025-11 Pedal Bike Nissan Micra Blue Driving without Due Care and Attention None Sarehole Road Sarehole Road Birmingham Birmingham Education N/A   52.4422505 -1.8539684
21560 op-snap---monthly-publication-november-2025.pdf   1102 2025-11 Pedal Bike Ford Transit White Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Court N/A   52.4203897 -1.8338574
21562 op-snap---monthly-publication-november-2025.pdf   1104 2025-11 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention None Stratford Road Stratford Road Birmingham Birmingham Education N/A   52.4203897 -1.8338574
21563 op-snap---monthly-publication-november-2025.pdf   1105 2025-11 Pedal Bike Vauxhall Corsa Black Driving without Due Care and Attention No Insurance Leach Green Lane Leach Green Lane Birmingham Birmingham Court N/A   52.392246 -2.0101736
21568 op-snap---monthly-publication-november-2025.pdf   1110 2025-11 Pedal Bike Seat Leon White Driving without Due Care and Attention None Frederick Street Frederick Street Birmingham Birmingham NFA No Offence   52.4863384 -1.9123011
21575 op-snap---monthly-publication-november-2025.pdf   1117 2025-11 Pedal Bike Volkswagen   Grey Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA Not in Public Interest   52.4103629 -1.5441218
21629 op-snap---monthly-publication-november-2025.pdf   1171 2025-11 Pedal Bike Ford Fiesta White Driving without Due Care and Attention None Holly Hill Road Holly Hill Road Birmingham Birmingham Education N/A   52.408161 -2.008839
21669 op-snap---monthly-publication-november-2025.pdf   1211 2025-11 Pedal Bike Honda Civic White Driving without Due Care and Attention None B4100 Banbury Road, Ashbourne Hill, Warwick Banbury Road, Ashbourne Hill, Warwick Out of Force Area Out of Force Area NFA Out of Force      
21684 op-snap---monthly-publication-november-2025.pdf   1226 2025-11 Pedal Bike Vauxhall Corsa Yellow Driving without Due Care and Attention None Gibbins Road Gibbins Road Birmingham Birmingham NFA No Offence   52.4390303 -1.9512931
21685 op-snap---monthly-publication-november-2025.pdf   1227 2025-11 Pedal Bike Peugeot 208 Grey Driving without Due Care and Attention None The Broadway, Stourbridge The Broadway, Stourbridge Dudley Dudley Education N/A   52.4411413 -2.1695219
21707 op-snap---monthly-publication-november-2025.pdf   1249 2025-11 Pedal Bike Volvo V70 Black Driving without Due Care and Attention None Brook Lane, Kings Heath, Birmingham Brook Lane, Kings Heath, Birmingham Birmingham Birmingham Education N/A   52.4312019 -1.8761389
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
21756 op-snap---monthly-publication-november-2025.pdf   1298 2025-11 Pedal Bike Toyota Yaris Black Driving without Due Care and Attention None A38 A38 Birmingham Birmingham Education N/A      
21757 op-snap---monthly-publication-november-2025.pdf   1299 2025-11 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Hill Street Hill Street Birmingham Birmingham Court N/A   52.4777765 -1.901321
21758 op-snap---monthly-publication-november-2025.pdf   1300 2025-11 Pedal Bike Volvo XC60 White Driving without Due Care and Attention None Westwood Av Westwood Avenue Dudley Dudley Other Action Taken No Independent Evidence Available   52.4475776 -2.1663873
21829 op-snap---monthly-publication-november-2025.pdf   1371 2025-11 Pedal Bike BMW X1 Grey Driving without Due Care and Attention None Upper Astrop Road, Astrop Upper Astrop Road, Astrop Out of Force Area Out of Force Area NFA Out of Force      
21835 op-snap---monthly-publication-november-2025.pdf   1377 2025-11 Pedal Bike Honda   Silver Driving without Due Care and Attention None Stourport Road Stourport Road Out of Force Area Out of Force Area NFA Out of Force      
21878 op-snap---monthly-publication-november-2025.pdf   1420 2025-11 Pedal Bike Porsche Cayenne Grey Driving without Due Care and Attention None Pershore Road Pershore Road Birmingham Birmingham Education N/A   52.4308271 -1.920078
21903 op-snap---monthly-publication-november-2025.pdf   1445 2025-11 Pedal Bike Skoda Octavia Red Driving without Due Care and Attention None Straoud Road Straoud Road Solihull Solihull Warning Letter N/A      
21930 op-snap---monthly-publication-november-2025.pdf   1472 2025-11 Pedal Bike Skoda Octavia White Driving without Due Care and Attention None Tyburn Road Tyburn Road Birmingham Birmingham Education N/A   52.5113867 -1.8337258
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      
21960 op-snap---monthly-publication-november-2025.pdf   1502 2025-11 Pedal Bike Lexus   White Driving without Due Care and Attention None Sir Herbert Austin Way Sir Herbert Austin Way Birmingham Birmingham NFA No VRM   52.4132666 -1.9735631
21967 op-snap---monthly-publication-november-2025.pdf   1509 2025-11 Pedal Bike   Levc White Driving without Due Care and Attention None Allesley Old Road Allesley Old Road Coventry Coventry NFA No Offence   52.4103629 -1.5441218
21968 op-snap---monthly-publication-november-2025.pdf   1510 2025-11 Pedal Bike Toyota Prius White Driving without Due Care and Attention None Swanawell Street Swanawell Street Coventry Coventry Warning Letter N/A      
21982 op-snap---monthly-publication-november-2025.pdf   1524 2025-11 Pedal Bike Volkswagen Caddy Red Driving without Due Care and Attention None Bridle Brook Lane Bridle Brook Lane Coventry Coventry Education N/A   52.4475078 -1.5736787
22044 op-snap---monthly-publication-november-2025.pdf   1586 2025-11 Pedal Bike Peugeot 308 Grey Driving without Due Care and Attention None Dutton Road Dutton Road Coventry Coventry Court N/A   52.4447067 -1.458495

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