Name: New York City Crimes
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

New York City Crimes

Context

With this dataset I hope to raise awareness on the trends in crime.

Content

For NYPD Complaint Data, each row represents a crime. For information on the columns, please see the attached csv, "Crime_Column_Description".
Reported crime go back 5 years but I only attached reported crime from 2014-2015 due to file size. The full report can be found at NYC Open Data (https://data.cityofnewyork.us/Public-Safety/NYPD-Complaint-Data-Historic/qgea-i56i)

Acknowledgements

I would like to thank NYC Open Data for the dataset.

Inspiration

Additional things I would like to better understand:

Differences in crime that exist between the 5 boroughs
A mapping of the crimes per borough
Where do the most dangerous crimes happen and what time?

Tables

Crime Column Description

@kaggle.adamschroeder_crimes_new_york_city.crime_column_description

3.89 kB
23 rows
2 columns

CREATE TABLE crime_column_description (
  "column" VARCHAR,
  "description" VARCHAR
);

Nypd Complaint Data Historic

@kaggle.adamschroeder_crimes_new_york_city.nypd_complaint_data_historic

48.98 MB
1,048,575 rows
24 columns

CREATE TABLE nypd_complaint_data_historic (
  "cmplnt_num" BIGINT,
  "cmplnt_fr_dt" VARCHAR,
  "cmplnt_fr_tm" VARCHAR,
  "cmplnt_to_dt" TIMESTAMP,
  "cmplnt_to_tm" VARCHAR,
  "rpt_dt" TIMESTAMP,
  "ky_cd" BIGINT,
  "ofns_desc" VARCHAR,
  "pd_cd" DOUBLE,
  "pd_desc" VARCHAR,
  "crm_atpt_cptd_cd" VARCHAR,
  "law_cat_cd" VARCHAR,
  "juris_desc" VARCHAR,
  "boro_nm" VARCHAR,
  "addr_pct_cd" DOUBLE,
  "loc_of_occur_desc" VARCHAR,
  "prem_typ_desc" VARCHAR,
  "parks_nm" VARCHAR,
  "hadevelopt" VARCHAR,
  "x_coord_cd" DOUBLE,
  "y_coord_cd" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "lat_lon" VARCHAR
);

Population By Borough Nyc

@kaggle.adamschroeder_crimes_new_york_city.population_by_borough_nyc

17.06 kB
6 rows
22 columns

CREATE TABLE population_by_borough_nyc (
  "age_group" VARCHAR,
  "borough" VARCHAR,
  "n_1950" BIGINT  -- 1950,
  "n_1950_boro_share_of_nyc_total" VARCHAR  -- 1950 - Boro Share Of NYC Total,
  "n_1960" BIGINT  -- 1960,
  "n_1960_boro_share_of_nyc_total" VARCHAR  -- 1960 - Boro Share Of NYC Total,
  "n_1970" BIGINT  -- 1970,
  "n_1970_boro_share_of_nyc_total" VARCHAR  -- 1970 - Boro Share Of NYC Total,
  "n_1980" BIGINT  -- 1980,
  "n_1980_boro_share_of_nyc_total" VARCHAR  -- 1980 - Boro Share Of NYC Total,
  "n_1990" BIGINT  -- 1990,
  "n_1990_boro_share_of_nyc_total" VARCHAR  -- 1990 - Boro Share Of NYC Total,
  "n_2000" BIGINT  -- 2000,
  "n_2000_boro_share_of_nyc_total" VARCHAR  -- 2000 - Boro Share Of NYC Total,
  "n_2010" BIGINT  -- 2010,
  "n_2010_boro_share_of_nyc_total" VARCHAR  -- 2010 - Boro Share Of NYC Total,
  "n_2020" BIGINT  -- 2020,
  "n_2020_boro_share_of_nyc_total" VARCHAR  -- 2020 - Boro Share Of NYC Total,
  "n_2030" BIGINT  -- 2030,
  "n_2030_boro_share_of_nyc_total" VARCHAR  -- 2030 - Boro Share Of NYC Total,
  "n_2040" BIGINT  -- 2040,
  "n_2040_boro_share_of_nyc_total" VARCHAR  -- 2040 - Boro Share Of NYC Total
);