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 (rand
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 |
📤 Share this page
Found this useful? Share it with your network.
Files are hosted on the source repository. Click download to access the full dataset.