Dataset: New York City Crimes

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.8 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

46.71 MB
1048575 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

16.66 KB
6 rows
22 columns


CREATE TABLE population_by_borough_nyc (
  "age_group" VARCHAR,
  "borough" VARCHAR,
  "n_1950" BIGINT,
  "n_1950_boro_share_of_nyc_total" VARCHAR,
  "n_1960" BIGINT,
  "n_1960_boro_share_of_nyc_total" VARCHAR,
  "n_1970" BIGINT,
  "n_1970_boro_share_of_nyc_total" VARCHAR,
  "n_1980" BIGINT,
  "n_1980_boro_share_of_nyc_total" VARCHAR,
  "n_1990" BIGINT,
  "n_1990_boro_share_of_nyc_total" VARCHAR,
  "n_2000" BIGINT,
  "n_2000_boro_share_of_nyc_total" VARCHAR,
  "n_2010" BIGINT,
  "n_2010_boro_share_of_nyc_total" VARCHAR,
  "n_2020" BIGINT,
  "n_2020_boro_share_of_nyc_total" VARCHAR,
  "n_2030" BIGINT,
  "n_2030_boro_share_of_nyc_total" VARCHAR,
  "n_2040" BIGINT,
  "n_2040_boro_share_of_nyc_total" VARCHAR
);