crime_uk_street_data

A duckdb data table generated from street level crime data csv data held at data police uk archives.Full dataset from 2010-12 to 2016-04 (at time of publish)Note: - duplicate entries based on "CRIME ID" removed (randomly). - Syntheic "CRIME ID" added entry was recorded without a Crime ID registered. Git Hub repo for script that scrapes and combines data available at GitHub ----------------------------------------------------------------------------------------------Columns anddatatypes in street_data: Column Name Column Type Crime ID VARCHAR Month VARCHAR Reported by VARCHAR Falls within VARCHAR Longitude DOUBLE Latitude DOUBLE LSOA code VARCHAR LSOA name VARCHAR Crime type VARCHAR Last outcome category VARCHAR Context VARCHAR