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 council_area = "Dudley" and month = "2026-02" sorted by month descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: vehicle_colour, second_offence, nfa_rationale

vehicle_make 25

  • Volkswagen 13
  • Vauxhall 11
  • Ford 10
  • Audi 6
  • BMW 5
  • Mercedes-Benz 5
  • Toyota 5
  • Jaguar 3
  • Kia 3
  • Nissan 3
  • Seat 3
  • Citroen 2
  • Mitsubishi 2
  • Alfa Romeo 1
  • Fiat 1
  • Hyundai 1
  • Land Rover 1
  • Man 1
  • Mazda 1
  • Mg 1
  • Mini 1
  • Peugeot 1
  • Renault 1
  • Skoda 1
  • Yamaha 1

offence 12

  • Driving without Due Care and Attention 50
  • Contravening a Red Traffic Light 9
  • Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area 6
  • Misc - Non Traffic Offences 5
  • Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen 4
  • Using a Mobile Phone Whilst Driving 3
  • Cause vehicle to be left in a dangerous position 2
  • Stop a vehicle within pelican pedestrian crossing limits 2
  • Driving without Reasonable Consideration 1
  • Duplicate Submission 1
  • Use a motor vehicle / trailer in a condition likely to cause danger of injury 1
  • VRM fails to conform to Regulations 1

disposal 7

  • Education 26
  • NFA 22
  • Warning Letter 16
  • Fixed Penalty 12
  • Court 4
  • Other Action Taken 3
  • RTC - Actioned 2

reporter_transport_mode 5

  • Car 47
  • Other 26
  • Pedal Bike 6
  • Pedestrian 5
  • Motorbike 1

month 1

  • 2026-02 · 85 ✖

council_area 1

  • Dudley · 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
7257 op-snap---monthly-publication-february-2026.pdf   4 2026-02 Car Mazda CX30 Grey Driving without Due Care and Attention None High Street, Quarry Bank High Street, Quarry Bank Dudley Dudley Education N/A   52.4576453 -2.1150716
7258 op-snap---monthly-publication-february-2026.pdf   5 2026-02 Car Mercedes-Benz Sprinter White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Delph Road, Delph Road Dudley Dudley NFA No Independent Evidence Available   52.4754271 -2.1310168
7304 op-snap---monthly-publication-february-2026.pdf   51 2026-02 Car     White Contravening a Red Traffic Light None High Street Wordesley High Street Wordesley Dudley Dudley NFA No Independent Evidence Available      
7350 op-snap---monthly-publication-february-2026.pdf   97 2026-02 Pedestrian Mercedes-Benz Sprinter Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Gayfield Avenue Gayfield Avenue Dudley Dudley Fixed Penalty N/A   52.4693896 -2.1251602
7371 op-snap---monthly-publication-february-2026.pdf   118 2026-02 Car Land Rover Evoque Beige Contravening a Red Traffic Light None Venture Way Venture Way Dudley Dudley Education N/A   52.4836603 -2.1189326
7372 op-snap---monthly-publication-february-2026.pdf   119 2026-02 Car Vauxhall corsa Red Driving without Due Care and Attention None High Street High Street Dudley Dudley NFA No Offence   52.4779764 -2.1598371
7413 op-snap---monthly-publication-february-2026.pdf   160 2026-02 Car Ford Kuga Green Driving without Due Care and Attention None Tipton Street Tipton Street Dudley Dudley RTC - Actioned N/A   52.5387558 -2.1179869
7418 op-snap---monthly-publication-february-2026.pdf   165 2026-02 Car Toyota Prius Silver Driving without Due Care and Attention None Venture Way Venture Way Dudley Dudley Warning Letter N/A   52.4836603 -2.1189326
7431 op-snap---monthly-publication-february-2026.pdf   178 2026-02 Pedestrian Audi A4 White Cause vehicle to be left in a dangerous position None Gayfield Av Gayfield Avenue Dudley Dudley Education N/A   52.4693896 -2.1251602
7437 op-snap---monthly-publication-february-2026.pdf   184 2026-02 Pedestrian Vauxhall Vivaro White Stop a vehicle within pelican pedestrian crossing limits None Mill Street Mill Street Dudley Dudley Education N/A   52.4779239 -2.1561956
7515 op-snap---monthly-publication-february-2026.pdf   262 2026-02 Car Mercedes-Benz C 220 White Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Springfield Road Halesowen Springfield Road Halesowen Dudley Dudley NFA No Offence   52.4664617 -2.0319975
7517 op-snap---monthly-publication-february-2026.pdf   264 2026-02 Pedal Bike Jaguar i-Pace Black Driving without Due Care and Attention None South Road, Stourbridge South Road, Stourbridge Dudley Dudley Education N/A   52.4530371 -2.1660216
7579 op-snap---monthly-publication-february-2026.pdf   326 2026-02 Car Kia Xceed Grey Driving without Due Care and Attention None Birmingham New Road Birmingham New Road Dudley Dudley Education N/A   52.5478387 -2.0943116
7592 op-snap---monthly-publication-february-2026.pdf   339 2026-02 Other Mitsubishi Shogun Black Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen t None Norwood Road Norwood Road Dudley Dudley Fixed Penalty N/A   52.4831397 -2.1309273
7614 op-snap---monthly-publication-february-2026.pdf   361 2026-02 Car Mg HS Red Driving without Due Care and Attention None Dudley Road Dudley Road Dudley Dudley Warning Letter N/A   52.4881161 -2.1199108
7615 op-snap---monthly-publication-february-2026.pdf   362 2026-02 Car Vauxhall Astra Black Contravening a Red Traffic Light None A491 A491 Dudley Dudley Warning Letter N/A      
7617 op-snap---monthly-publication-february-2026.pdf   364 2026-02 Car Ford Transit White Driving without Due Care and Attention None The Embankment The Embankment Dudley Dudley NFA No Offence   52.4826167 -2.1144546
7618 op-snap---monthly-publication-february-2026.pdf   365 2026-02 Car Man TGE White Driving without Due Care and Attention None The Embankment The Embankment Dudley Dudley NFA No Offence   52.4826167 -2.1144546
7626 op-snap---monthly-publication-february-2026.pdf   373 2026-02 Other Alfa Romeo Giulietta Blue Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
7630 op-snap---monthly-publication-february-2026.pdf   377 2026-02 Car Mitsubishi Outlander Black Contravening a Red Traffic Light None Stourbridge Road Stourbridge Road Dudley Dudley Warning Letter N/A   52.5002997 -2.1081386
7646 op-snap---monthly-publication-february-2026.pdf   393 2026-02 Other Vauxhall Corsa Brown Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley NFA Not in Public Interest   52.4874281 -2.1117204
7656 op-snap---monthly-publication-february-2026.pdf   403 2026-02 Other Mini Cooper Silver Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Other Action Taken N/A   52.4874281 -2.1117204
7663 op-snap---monthly-publication-february-2026.pdf   410 2026-02 Other Vauxhall Corsa Grey Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley NFA No Offence   52.4874281 -2.1117204
7666 op-snap---monthly-publication-february-2026.pdf   413 2026-02 Other Volkswagen Polo Grey Driving without Due Care and Attention None Waterfront Waterfront Dudley Dudley Warning Letter N/A   52.4874281 -2.1117204
7676 op-snap---monthly-publication-february-2026.pdf   423 2026-02 Car Vauxhall Insignia Grey Using a Mobile Phone Whilst Driving None Embankment Merry Hill Embankment Merry Hill Dudley Dudley Fixed Penalty N/A   52.4814094 -2.1134278
7678 op-snap---monthly-publication-february-2026.pdf   425 2026-02 Other Jaguar XE Red Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Fixed Penalty N/A   52.4831397 -2.1309273
7716 op-snap---monthly-publication-february-2026.pdf   463 2026-02 Motorbike Kia Ceed Red Driving without Due Care and Attention None Quarry Bank HS Quarry Bank HS Dudley Dudley Court N/A   52.4733135 -2.1014635
7717 op-snap---monthly-publication-february-2026.pdf   464 2026-02 Car Citroen C4 Blue Driving without Due Care and Attention None Oakham Road Oakham Road Dudley Dudley NFA No Offence   52.5030757 -2.0663819
7732 op-snap---monthly-publication-february-2026.pdf   479 2026-02 Car Toyota Yaris Blue Driving without Due Care and Attention No Insurance Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley NFA No Independent Evidence Available   52.4590366 -2.1465735
7733 op-snap---monthly-publication-february-2026.pdf   480 2026-02 Other Ford Focus Silver Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen t None Norwood Road Norwood Road Dudley Dudley Fixed Penalty N/A   52.4831397 -2.1309273
7734 op-snap---monthly-publication-february-2026.pdf   481 2026-02 Car Vauxhall Meriva Black Contravening a Red Traffic Light None High Street, Wordsley High Street, Wordsley Dudley Dudley Education N/A   52.4778645 -2.1594686
7735 op-snap---monthly-publication-february-2026.pdf   482 2026-02 Car Ford Mondeo Grey Contravening a Red Traffic Light None High Street, Wordsley High Street, Wordsley Dudley Dudley Education N/A   52.4778645 -2.1594686
7739 op-snap---monthly-publication-february-2026.pdf   486 2026-02 Other BMW 318d Grey Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen t None Norwood Road Norwood Road Dudley Dudley NFA No Independent Evidence Available   52.4831397 -2.1309273
7742 op-snap---monthly-publication-february-2026.pdf   489 2026-02 Car Vauxhall Corsa Orange Driving without Due Care and Attention None High Street, Stourbridge High Street, Stourbridge Dudley Dudley Warning Letter N/A   52.4570763 -2.1136199
7752 op-snap---monthly-publication-february-2026.pdf   499 2026-02 Car Volkswagen V40.. Blue Driving without Due Care and Attention None Chadd Road Coseley Chadd Road Coseley Dudley Dudley Other Action Taken N/A      
7802 op-snap---monthly-publication-february-2026.pdf   549 2026-02 Pedestrian Audi A4 Grey Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Kingswood Road Kingswood Road Dudley Dudley Warning Letter N/A   52.4876186 -2.175395
7806 op-snap---monthly-publication-february-2026.pdf   553 2026-02 Pedestrian Mercedes-Benz CLA White Cause vehicle to be left in a dangerous position None Butchers Lane Butchers Lane Dudley Dudley Education N/A   52.4636446 -2.0823797
7827 op-snap---monthly-publication-february-2026.pdf   574 2026-02 Car Skoda Kodiaq Grey Driving without Due Care and Attention None High Street High Street Dudley Dudley NFA Not in Public Interest   52.4779764 -2.1598371
7872 op-snap---monthly-publication-february-2026.pdf   619 2026-02 Car Seat Ibiza White Contravening a Red Traffic Light None Brettle Lane, Brierley Hill Brettle Lane, Brierley Hill Dudley Dudley Education N/A      
7936 op-snap---monthly-publication-february-2026.pdf   683 2026-02 Other Volkswagen Golf Blue Duplicate Submission None Waterfront main car park Waterfront main car park Dudley Dudley Warning Letter N/A      
7972 op-snap---monthly-publication-february-2026.pdf   719 2026-02 Car Toyota Prius Silver Driving without Due Care and Attention None Scotts Green Island Scotts Green Island Dudley Dudley Fixed Penalty N/A   52.5029355 -2.1051117
8061 op-snap---monthly-publication-february-2026.pdf   808 2026-02 Car Volkswagen Golf Silver Contravening a Red Traffic Light None Stourbridge Ring Road Stourbridge Ring Road Dudley Dudley Fixed Penalty N/A   52.4590366 -2.1465735
8081 op-snap---monthly-publication-february-2026.pdf   828 2026-02 Pedal Bike Vauxhall Vicaro silver Driving without Due Care and Attention none A491 Hagley Road Hagley Road Dudley Dudley Education N/A   52.4514139 -2.1423625
8084 op-snap---monthly-publication-february-2026.pdf   831 2026-02 Pedal Bike Ford KA White Driving without Due Care and Attention None Heath Lane towards Norton Heath Lane towards Norton Dudley Dudley Education N/A      
8099 op-snap---monthly-publication-february-2026.pdf   846 2026-02 Other Vauxhall Corsa White Misc - Non Traffic Offences None Standhill Road Kingswinford Standhill Road Kingswinford Dudley Dudley RTC - Actioned N/A      
8194 op-snap---monthly-publication-february-2026.pdf   941 2026-02 Car Toyota C-HR Blue Driving without Due Care and Attention None Birmingham Street Birmingham Street Dudley Dudley Education N/A   52.5122152 -2.0791208
8214 op-snap---monthly-publication-february-2026.pdf   961 2026-02 Car Ford Fiesta Blue Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Silverthorne Lane Silverthorne Lane Dudley Dudley NFA No Offence      
8215 op-snap---monthly-publication-february-2026.pdf   962 2026-02 Car BMW X1 Black Cause unnecessary obstruction by motor vehicle / trailer outside of the Greater London area None Silverthorne Lane Silverthorne Lane Dudley Dudley Fixed Penalty N/A      
8225 op-snap---monthly-publication-february-2026.pdf   972 2026-02 Car Volkswagen Crafter White Stop a vehicle within pelican pedestrian crossing limits None Brettle Lane Brettle Lane Dudley Dudley Education N/A      
8240 op-snap---monthly-publication-february-2026.pdf   987 2026-02 Car Vauxhall Vivaro Grey Driving without Due Care and Attention None Dudley Port Road, Tipton Dudley Port Road, Tipton Dudley Dudley Education N/A   52.5320271 -2.0666926
8241 op-snap---monthly-publication-february-2026.pdf   988 2026-02 Car Citroen Dispatch Grey Driving without Due Care and Attention None Dudley Port Road, Tipton Dudley Port Road, Tipton Dudley Dudley Education N/A   52.5320271 -2.0666926
8258 op-snap---monthly-publication-february-2026.pdf   1005 2026-02 Car Peugeot Expert Grey Driving without Due Care and Attention None Himley Road Himley Road Dudley Dudley Education N/A   52.5142667 -2.1304764
8261 op-snap---monthly-publication-february-2026.pdf   1008 2026-02 Pedal Bike Mercedes-Benz Benz White Driving without Due Care and Attention None Hagley Road Hagley Road Dudley Dudley Education N/A   52.4514139 -2.1423625
8269 op-snap---monthly-publication-february-2026.pdf   1016 2026-02 Car Ford Transit Blue Driving without Due Care and Attention No Insurance Halesowen Road Netherton Halesowen Road Netherton Dudley Dudley Court N/A   52.4904317 -2.0833451
8273 op-snap---monthly-publication-february-2026.pdf   1020 2026-02 Car Ford Mondeo White Misc - Non Traffic Offences None Manor Way Halesowen Manor Way Halesowen Dudley Dudley NFA Not in Public Interest   52.443598 -2.0464887
8352 op-snap---monthly-publication-february-2026.pdf   1099 2026-02 Other Fiat 500 White Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A      
8378 op-snap---monthly-publication-february-2026.pdf   1125 2026-02 Pedal Bike Kia Sportage Orange Driving without Due Care and Attention None Love Lane Love Lane Dudley Dudley Education N/A   52.448434 -2.1478173
8390 op-snap---monthly-publication-february-2026.pdf   1137 2026-02 Other Audi A3 Silver Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A      
8417 op-snap---monthly-publication-february-2026.pdf   1164 2026-02 Car Volkswagen Passat Green Driving without Due Care and Attention No Insurance The Inhedge, The Inhedge Dudley Dudley Fixed Penalty N/A   52.5099671 -2.0871664
8446 op-snap---monthly-publication-february-2026.pdf   1193 2026-02 Other Yamaha FZS 600 Blue Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Warning Letter N/A      
8448 op-snap---monthly-publication-february-2026.pdf   1195 2026-02 Other Audi A3 Black Use a motor vehicle / trailer in a condition likely to cause danger of injury None Waterfront Car Park Waterfront Car Park Dudley Dudley Fixed Penalty N/A      
8458 op-snap---monthly-publication-february-2026.pdf   1205 2026-02 Car BMW 5 series White Using a Mobile Phone Whilst Driving None Kidderminster Road Kidderminster Road Dudley Dudley NFA No Independent Evidence Available   52.5000055 -2.1844503
8467 op-snap---monthly-publication-february-2026.pdf   1214 2026-02 Car Volkswagen Golf Blue Using a Mobile Phone Whilst Driving None Wollescote Road Wollescote Road Dudley Dudley NFA No Independent Evidence Available   52.4471527 -2.1236271
8470 op-snap---monthly-publication-february-2026.pdf   1217 2026-02 Car Volkswagen Golf White Driving without Due Care and Attention None Highbridge Road Netherton Highbridge Road Netherton Dudley Dudley Other Action Taken N/A   52.485907 -2.0953009
8479 op-snap---monthly-publication-february-2026.pdf   1226 2026-02 Car BMW 330D White Contravening a Red Traffic Light None Bunns Lane Bunns Lane Dudley Dudley Education N/A   52.5111371 -2.0643295
8483 op-snap---monthly-publication-february-2026.pdf   1230 2026-02 Other Volkswagen Lupo Green Driving without Due Care and Attention None Waterfront main car park Waterfront main car park Dudley Dudley Warning Letter N/A      
8484 op-snap---monthly-publication-february-2026.pdf   1231 2026-02 Other Seat Ibiza White Driving without Due Care and Attention None Waterfront Main Car Park Waterfront Main Car Park Dudley Dudley Warning Letter N/A      
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
8488 op-snap---monthly-publication-february-2026.pdf   1235 2026-02 Other Nissan Qashqai Blue Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
8498 op-snap---monthly-publication-february-2026.pdf   1245 2026-02 Pedal Bike Jaguar XF White Driving without Reasonable Consideration None The Broadway The Broadway Dudley Dudley Education N/A   52.515445 -2.0885791
8503 op-snap---monthly-publication-february-2026.pdf   1250 2026-02 Other BMW 335d Black Driving without Due Care and Attention No Insurance Showcase Cinema Showcase Cinema Dudley Dudley Court N/A   52.5169253 -2.070981
8504 op-snap---monthly-publication-february-2026.pdf   1251 2026-02 Car Audi A3 White Misc - Non Traffic Offences None Pembridge Close Pembridge Close Dudley Dudley NFA No Offence   52.4755298 -2.1067444
8520 op-snap---monthly-publication-february-2026.pdf   1267 2026-02 Car Renault Kadjar Grey Driving without Due Care and Attention None Cinder Bank Island Cinder Bank Island Dudley Dudley NFA Outside of 14 Days NIP   52.5004694 -2.0904035
8576 op-snap---monthly-publication-february-2026.pdf   1323 2026-02 Other Seat Leon White Motor vehicle fail to comply with endorsable section 36 traffic sign -other than manned or automatic equipmen t None Stone Street/ Tower Street Stone Street/ Tower Street Dudley Dudley Fixed Penalty N/A   52.5104511 -2.0836025
8593 op-snap---monthly-publication-february-2026.pdf   1340 2026-02 Other Nissan Navara Black Driving without Due Care and Attention None Norwood Road Norwood Road Dudley Dudley Education N/A   52.4831397 -2.1309273
8642 op-snap---monthly-publication-february-2026.pdf   1389 2026-02 Car Volkswagen polo Blue Misc - Non Traffic Offences None netherton Netherton Dudley Dudley NFA Misc Inc Crimes   52.4914577 -2.0831125
8658 op-snap---monthly-publication-february-2026.pdf   1405 2026-02 Other Ford Fiesta Black Driving without Due Care and Attention None Waterfront Car Park Waterfront Car Park Dudley Dudley Education N/A      
8682 op-snap---monthly-publication-february-2026.pdf   1429 2026-02 Car Nissan Qashqai Grey Driving without Due Care and Attention None The Broadway Stourbridge The Broadway Stourbridge Dudley Dudley Warning Letter N/A   52.4411413 -2.1695219
8702 op-snap---monthly-publication-february-2026.pdf   1449 2026-02 Car Volkswagen Golf White Driving without Due Care and Attention None Highbridge Road Highbridge Road Dudley Dudley Court N/A   52.485907 -2.0953009
8736 op-snap---monthly-publication-february-2026.pdf   1483 2026-02 Other   Proton Blue Driving without Due Care and Attention None Gervase Drive Gervase Drive Dudley Dudley Warning Letter N/A   52.5169749 -2.0827363
8737 op-snap---monthly-publication-february-2026.pdf   1484 2026-02 Other Volkswagen Taigo Black Driving without Due Care and Attention None Gervase Drive Gervase Drive Dudley Dudley Warning Letter N/A   52.5169749 -2.0827363
8761 op-snap---monthly-publication-february-2026.pdf   1508 2026-02 Car Hyundai Ioniq Black Driving without Due Care and Attention None Stafford Street Stafford Street Dudley Dudley NFA No Offence   52.5095163 -2.0898951
8781 op-snap---monthly-publication-february-2026.pdf   1528 2026-02 Other Ford Fiesta Black Misc - Non Traffic Offences None Waterfrotn car park Waterfrotn car park Dudley Dudley NFA No Offence      
8783 op-snap---monthly-publication-february-2026.pdf   1530 2026-02 Car Toyota Rav 4 Silver Driving without Due Care and Attention None Duncan Edwards Way Duncan Edwards Way Dudley Dudley NFA No Independent Evidence Available   52.5047428 -2.0823754
8786 op-snap---monthly-publication-february-2026.pdf   1533 2026-02 Car Volkswagen Transporter White VRM fails to conform to Regulations None Huntingtree Road Huntingtree Road Dudley Dudley Fixed Penalty N/A   52.4484682 -2.0689885

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