Name: Crime In Los Angeles
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Crime In Los Angeles

This dataset reflects incidents of crime in the City of Los Angeles dating back to 2010. This data is transcribed from original crime reports that are typed on paper and therefore there may be some inaccuracies within the data. Some location fields with missing data are noted as (0°, 0°). Address fields are only provided to the nearest hundred block in order to maintain privacy.

Reporting District Shapefile Attributes

REPDIST, Number, min: 101 max: 2,199 avg: 1,162 count: 1,135

PREC, Number, min: 1 max: 21 avg: 11 count: 1,135

APREC, Text, PACIFIC (74), DEVONSHIRE (70), WEST LOS ANGELES (69), NORTHEAST (64), HOLLENBECK (63), MISSION (62)... (15 more)

BUREAU, Text, VALLEY BUREAU (399), WEST BUREAU (288), CENTRAL BUREAU (267), SOUTH BUREAU (181)

BASICCAR, Text, 8A29 (17), 17A35 (17), 1A1 (15), 17A49 (14), 16A35 (14), 14A73 (14), 19A43 (13), 8A95 (12), 19A7 (12)... (160 more)

TOOLTIP, Text, Bureau: SOUTH BUREAU\nDistrict: 562\nDivision: HARBOR (1)... (1134 more)

OBJECTID

Unique ID

Acknowledgements

This dataset was kindly released by the City of Los Angeles. You can find the original dataset, updated weekly, here.

Inspiration

Some of the MO codes seem unlikely or unrelated to crime. Can you find out what would lead to the use of code 0107 God or 1021 Repair?

Tables

Crime Data 2010–2017

@kaggle.cityofla_crime_in_los_angeles.crime_data_2010_2017

50.76 MB
1584316 rows
26 columns


CREATE TABLE crime_data_2010_2017 (
  "dr_number" BIGINT,
  "date_reported" TIMESTAMP,
  "date_occurred" TIMESTAMP,
  "time_occurred" BIGINT,
  "area_id" BIGINT,
  "area_name" VARCHAR,
  "reporting_district" BIGINT,
  "crime_code" BIGINT,
  "crime_code_description" VARCHAR,
  "mo_codes" VARCHAR,
  "victim_age" DOUBLE,
  "victim_sex" VARCHAR,
  "victim_descent" VARCHAR,
  "premise_code" DOUBLE,
  "premise_description" VARCHAR,
  "weapon_used_code" DOUBLE,
  "weapon_description" VARCHAR,
  "status_code" VARCHAR,
  "status_description" VARCHAR,
  "crime_code_1" DOUBLE,
  "crime_code_2" DOUBLE,
  "crime_code_3" DOUBLE,
  "crime_code_4" DOUBLE,
  "address" VARCHAR,
  "cross_street" VARCHAR,
  "location" VARCHAR
);

Mo Codes

@kaggle.cityofla_crime_in_los_angeles.mo_codes

14.49 KB
532 rows
2 columns


CREATE TABLE mo_codes (
  "mo_code" BIGINT,
  "description" VARCHAR
);