Crimes in the UK Data Attributes - Rostlab/DM_CS_WS_2016-17 GitHub Wiki
Crimes in the UK - Data Attributes
General
| attribute name | source | description |
|---|---|---|
| id | generated | Technical ID for a crime |
Data from data.police.uk
| attribute name | source | description |
|---|---|---|
| crime_id | *outcomes.csv, *streets.csv | Every row in the outcome csv files has a crime_id. It is used to join streets with outcome. |
| month | *streets.csv | year and month |
| reported_by | *streets.csv | Name of a police force |
| falls_within | *streets.csv | Name of a police force, is always the same like reported_by. |
| longitude | *streets.csv | Anonymized coordinates |
| latitude | *streets.csv | Anonymized coordinates |
| location | *streets.csv | Description of the location, such as "On or near Westfield Close" |
| lsoa_code | *streets.csv | Lower Layer Super Output Areas |
| lsoa_name | *streets.csv | Lower Layer Super Output Areas |
| crime_type | *streets.csv | |
| last_outcome_category | *streets.csv | |
| suspect_identified | *streets.csv | |
| context | *streets.csv | |
| county | *streets.csv | Wrong term. Will be removed in the future. |
| outcome_type | *outcomes.csv | |
| suspect_identified_outcome | *outcomes.csv | |
| number_ss | calculated using *stop-and_search.csv | https://github.com/Rostlab/DM_CS_WS_2016-17/wiki/Week-02-%28W47-Nov23%29-Crimes-in-the-UK#computing-number-of-stop-and-searches-and-points-of-interest-surrounding-crimes |
| number_ss_person_searches | calculated using *stop-and_search.csv | |
| number_ss_vehicle_searches | calculated using *stop-and_search.csv | |
| number_ss_asian_searches | calculated using *stop-and_search.csv | |
| number_ss_black_searches | calculated using *stop-and_search.csv | |
| number_ss_white_searches | calculated using *stop-and_search.csv | |
| number_ss_outcome_suspect_arrested | calculated using *stop-and_search.csv | |
| number_ss_outcome_article_found | calculated using *stop-and_search.csv | |
| number_ss_outcome_offender_given_drugs_possession_warning | calculated using *stop-and_search.csv | |
| number_ss_outcome_offender_cautioned | calculated using *stop-and_search.csv | |
| number_ss_outcome_suspect_summonsed_to_court | calculated using *stop-and_search.csv | |
| number_ss_outcome_nothing_found | calculated using *stop-and_search.csv | |
| number_ss_outcome_offender_given_penalty_notice | calculated using *stop-and_search.csv | |
| number_ss_outcome_local_resolution | calculated using *stop-and_search.csv | |
| number_ss_age_under_10 | calculated using *stop-and_search.csv | |
| number_ss_age_10_17 | calculated using *stop-and_search.csv | |
| number_ss_age_18_24 | calculated using *stop-and_search.csv | |
| number_ss_age_25_34 | calculated using *stop-and_search.csv | |
| number_ss_age_over_34 | calculated using *stop-and_search.csv | |
| number_ss_object_controlled_drugs | calculated using *stop-and_search.csv | |
| number_ss_object_criminal_demage_articles | calculated using *stop-and_search.csv | |
| number_ss_object_stolen_goods | calculated using *stop-and_search.csv | |
| number_ss_object_weapons | calculated using *stop-and_search.csv | |
| number_ss_object_firearms | calculated using *stop-and_search.csv | |
| number_ss_object_evidence | calculated using *stop-and_search.csv |
Uses Data from PocketGPSWorld.com
Description: https://github.com/Rostlab/DM_CS_WS_2016-17/wiki/Week-02-%28W47-Nov23%29-Crimes-in-the-UK#use-of-points-of-interest
| attribute name | source | description |
|---|---|---|
| number_poi | calculated using PocketGPSWorld.com | |
| number_poi_community | calculated using PocketGPSWorld.com | |
| number_poi_food_and_drink | calculated using PocketGPSWorld.com | |
| number_poi_fuel | calculated using PocketGPSWorld.com | |
| number_poi_atm | calculated using PocketGPSWorld.com | |
| number_poi_transport | calculated using PocketGPSWorld.com | |
| number_poi_motorcycle_dealership | calculated using PocketGPSWorld.com | |
| number_poi_wifi_hotspot | calculated using PocketGPSWorld.com | |
| number_poi_shopping_supermarkets | calculated using PocketGPSWorld.com | |
| number_poi_special_interest | calculated using PocketGPSWorld.com | |
| number_poi_shopping_others | calculated using PocketGPSWorld.com | |
| number_poi_banks | calculated using PocketGPSWorld.com | |
| number_poi_sports_center | calculated using PocketGPSWorld.com | |
| number_poi_car_dealership | calculated using PocketGPSWorld.com | |
| number_poi_commercial_site | calculated using PocketGPSWorld.com | |
| number_poi_association | calculated using PocketGPSWorld.com | |
| number_poi_car_parts_supplier | calculated using PocketGPSWorld.com | |
| number_poi_builder_and_diy_supplies | calculated using PocketGPSWorld.com | |
| number_poi_accommodation | calculated using PocketGPSWorld.com | |
| number_poi_attraction | calculated using PocketGPSWorld.com | |
| number_poi_pharmacy | calculated using PocketGPSWorld.com | |
| number_poi_healthcare | calculated using PocketGPSWorld.com | |
| number_poi_landmark | calculated using PocketGPSWorld.com | |
| number_poi_public_service_buildings | calculated using PocketGPSWorld.com | |
| number_poi_shopping_consumer_electrics | calculated using PocketGPSWorld.com | |
| number_poi_entertainment | calculated using PocketGPSWorld.com | |
| number_poi_car_servicing | calculated using PocketGPSWorld.com | |
| number_poi_building_society | calculated using PocketGPSWorld.com | |
| number_poi_bookshop | calculated using PocketGPSWorld.com | |
| number_poi_truck_dealership | calculated using PocketGPSWorld.com | |
| number_poi_holiday_park | calculated using PocketGPSWorld.com | |
| number_poi_government_agency | calculated using PocketGPSWorld.com | |
| number_poi_vehicle_hire | calculated using PocketGPSWorld.com | |
| number_poi_car_auction | calculated using PocketGPSWorld.com | |
| number_poi_caravan_dealership | calculated using PocketGPSWorld.com | |
| number_poi_courier | calculated using PocketGPSWorld.com | |
| number_poi_estate_agent | calculated using PocketGPSWorld.com |
Data from National Statistics Postcode Lookup UK
Description: https://github.com/Rostlab/DM_CS_WS_2016-17/wiki/Week-03-(W48-Nov30)-Crimes-in-the-UK#geographical-inspection
| attribute name | source | description |
|---|---|---|
| post_code | Postcode Statistics | |
| region_code | Postcode Statistics | |
| region_name | Postcode Statistics | |
| msoa_code | Postcode Statistics | |
| msoa_name | Postcode Statistics | |
| local_authority_code | Postcode Statistics | |
| local_authority_name | Postcode Statistics |
Calculated
| attribute name | source | description |
|---|---|---|
| number_crimes_in_pca | The number of crimes in the same postcode area | |
| number_crimes_in_pca_other_crime | The number of crimes with the crime type "possession of weapons" in the same postcode area | |
| number_crimes_in_pca_possession_of_weapons | ||
| number_crimes_in_pca_criminal_damage_and_arson | ||
| number_crimes_in_pca_shoplifting | ||
| number_crimes_in_pca_robbery | ||
| number_crimes_in_pca_burglary | ||
| number_crimes_in_pca_public_disorder_and_weapons | ||
| number_crimes_in_pca_drugs | ||
| number_crimes_in_pca_other_theft | ||
| number_crimes_in_pca_violent_crime | ||
| number_crimes_in_pca_public_order | ||
| number_crimes_in_pca_violence_and_sexual_offences | ||
| number_crimes_in_pca_vehicle_crime | ||
| number_crimes_in_pca_bicycle_theft | ||
| number_crimes_in_pca_theft_from_the_person | ||
| number_crimes_in_pca_anti_social_behaviour |
Data from Census 2011 - Granularity: Local Authority
| attribute name | source | description |
|---|---|---|
| General | ||
| la_total | Table KS101EW | Number of persons (total) |
| la_males | Table KS101EW | Number of persons |
| la_females | Table KS101EW | Number of persons |
| la_household | Table KS101EW | Lives in a household - number of persons |
| la_communal | Table KS101EW | Lives in a communal establishment - number of persons |
| la_schoolchild | Table KS101EW | Schoolchild or full-time student aged 4 and over at their non term-time address - number of persons |
| la_hectares | Table KS101EW | Number hectares |
| la_density | Table KS101EW | Number of persons per hectare |
| ages - number persons | ||
| la_age_0_4 | Table KS102EW | |
| la_age_5_7 | Table KS102EW | |
| la_age_8_9 | Table KS102EW | |
| la_age_10_14 | Table KS102EW | |
| la_age_15 | Table KS102EW | |
| la_age_16_17 | Table KS102EW | |
| la_age_18_19 | Table KS102EW | |
| la_age_20_24 | Table KS102EW | |
| la_age_25_29 | Table KS102EW | |
| la_age_30_44 | Table KS102EW | |
| la_age_45_59 | Table KS102EW | |
| la_age_60_64 | Table KS102EW | |
| la_age_65_74 | Table KS102EW | |
| la_age_75_84 | Table KS102EW | |
| la_age_85_89 | Table KS102EW | |
| la_age_90_over | Table KS102EW | |
| la_age_mean | Table KS102EW | |
| la_age_median | Table KS102EW | |
| Living Arrangements - number persons | ||
| la_la_cmarried | Table KS104EW | Living in a couple: Married or in a registered same-sex civil partnership |
| la_la_ccohabiting | Table KS104EW | Living in a couple: Cohabiting |
| la_la_nsingle | Table KS104EW | Not living in a couple: Single (never married or never registered a same-sex civil partnership) |
| la_la_nmarried | Table KS104EW | Not living in a couple: Married or in a registered same-sex civil partnership |
| la_la_nseparated | Table KS104EW | Not living in a couple: Separated (but still legally married or still legally in a same-sex civil partnership) |
| la_la_ndivorced | Table KS104EW | Not living in a couple: Divorced or formerly in a same-sex civil partnership which is now legally dissolved |
| la_la_nwidowed | Table KS104EW | Not living in a couple: Widowed or surviving partner from a same-sex civil partnership |
| Ethnic Group - number persons | ||
| la_eth_wenglish | Table KS201EW | White: English/Welsh/Scottish/Northern Irish/British |
| la_eth_wirish | Table KS201EW | White: Irish |
| la_eth_wgypsy | Table KS201EW | White: Gypsy or Irish Traveller |
| la_eth_wother | Table KS201EW | White: Other White |
| la_eth_mwbc | Table KS201EW | Mixed/multiple ethnic group: White and Black Caribbean |
| la_eth_mwba | Table KS201EW | Mixed/multiple ethnic group: White and Black African |
| la_eth_mwa | Table KS201EW | Mixed/multiple ethnic group: White and Asian |
| la_eth_mother | Table KS201EW | Mixed/multiple ethnic group: Other Mixed |
| la_eth_aindian | Table KS201EW | Asian/Asian British: Indian |
| la_eth_apakistani | Table KS201EW | Asian/Asian British: Pakistani |
| la_eth_abangladeshi | Table KS201EW | Asian/Asian British: Bangladeshi |
| la_eth_achinese | Table KS201EW | Asian/Asian British: Chinese |
| la_eth_aother | Table KS201EW | Asian/Asian British: Other Asian |
| la_eth_bafrican | Table KS201EW | Black/African/Caribbean/Black British: African |
| la_eth_bcaribbean | Table KS201EW | Black/African/Caribbean/Black British: Caribbean |
| la_eth_bother | Table KS201EW | Black/African/Caribbean/Black British: Other Black |
| la_eth_oarab | Table KS201EW | Other ethnic group: Arab |
| la_eth_oother | Table KS201EW | Other ethnic group: Any other ethnic group |
| household languages - number households | ||
| la_hlang_all | KS206EW | All people aged 16 and over in household have English as a main language (English or Welsh in Wales) |
| la_hlang_some | KS206EW | At least one but not all people aged 16 and over in household have English as a main language (English or Welsh in Wales) |
| la_hlang_young | KS206EW | No people aged 16 and over in household but at least one person aged 3 to 15 has English as a main language (English or Welsh in Wales) |
| la_hlang_none | KS206EW | No people in household have English as a main language (English or Welsh in Wales) |
| religion - number persons | ||
| la_rel_christian | KS209EW | |
| la_rel_buddhist | KS209EW | |
| la_rel_hindu | KS209EW | |
| la_rel_jewish | KS209EW | |
| la_rel_muslim | KS209EW | |
| la_rel_slikh | KS209EW | |
| la_rel_other | KS209EW | |
| la_rel_none | KS209EW | |
| la_rel_notstated | KS209EW | |
| Number cars in household - number household | ||
| la_car_0 | KS404EW | |
| la_car_1 | KS404EW | |
| la_car_2 | KS404EW | |
| la_car_3 | KS404EW | |
| la_car_3_more | KS404EW | |
| Qualifications and students - number persons | ||
| la_qual_no | KS501EW | No qualifications |
| la_qual_l1 | KS501EW | Highest level of qualification: Level 1 qualifications |
| la_qual_l2 | KS501EW | Highest level of qualification: Level 2 qualifications |
| la_qual_appr | KS501EW | Highest level of qualification: Apprenticeship |
| la_qual_l3 | KS501EW | Highest level of qualification: Level 3 qualifications |
| la_qual_l4_above | KS501EW | Highest level of qualification: Level 4 qualifications and above |
| la_qual_other | KS501EW | Highest level of qualification: Other qualifications |
| la_qual_school_16_17 | KS501EW | Schoolchildren and full-time students: Age 16 to 17 |
| la_qual_school_18_over | KS501EW | Schoolchildren and full-time students: Age 18 and over |
| la_qual_student_employed | KS501EW | Full-time students: Age 18 to 74: Economically active: In employment |
| la_qual_student_unemployed | KS501EW | Full-time students: Age 18 to 74: Economically active: Unemployed |
| la_qual_student_inactive | KS501EW | Full-time students: Age 18 to 74: Economically inactive |
| occupation - number persons | ||
| la_occ_managers | KS5608EW | 1. Managers, directors and senior officials |
| la_occ_professional | KS5608EW | 2. Professional occupations |
| la_occ_associate | KS5608EW | 3. Associate professional and technical occupations |
| la_occ_administrative | KS5608EW | 4. Administrative and secretarial occupations |
| la_occ_skilled | KS5608EW | 5. Skilled trades occupations |
| la_occ_caring | KS5608EW | 6. Caring, leisure and other service occupations |
| la_occ_sales | KS5608EW | 7. Sales and customer service occupations |
| la_occ_processop | KS5608EW | 8. Process, plant and machine operatives |
| la_occ_elementary | KS5608EW | 9. Elementary occupations |
| Length of residence in UK (caution: values from 2011!) - number persons | ||
| la_lengthres_999 | QS803EW | Born in the UK |
| la_lengthres_less_2 | QS803EW | Resident in UK: Less than 2 years |
| la_lengthres_2_5 | QS803EW | Resident in UK: 2 years or more but less than 5 years |
| la_lengthres_5_10 | QS803EW | Resident in UK: 5 years or more but less than 10 years |
| la_lengthres_10_more | QS803EW | Resident in UK: 10 years or more |