Dataset: Crime Incident Reports, Boston, MA

About this Dataset

Crime Incident Reports, Boston, MA

Context

I am completely new to data science. As part of my learning exercises, I wanted to pick a data set that was fulsome, timely, at least somewhat relevant to my interests, etc. I am hoping this data set is that data set.

Content

This data set represents Boston Crime Incident Reports for the years beginning in 2015 through to the present. This is directly sourced from, and has been prepared by, the Boston Police Department. The original data set (which should be identical, as of the time of this writing, to what is contained in this data set) is available here.

Acknowledgements

Thank you to the Boston Police Department and the City of Boston for continuing to be on the forefront of civic transparency. It is just a small part of why I will always live here.

Inspiration

I realize that most of the information I think I 'believe' is, at best, informed by second-hand sources, which are themselves likely of questionable origin, potentially rife with bias, etc. I am hoping I can learn enough to be able to answer some of the hard questions.

Tables

Tmpkrh6apk1

@kaggle.zer0state_crime_incident_reports_august_2015_to_date.tmpkrh6apk1

11.81 MB
426820 rows
17 columns


CREATE TABLE tmpkrh6apk1 (
  "incident_number" VARCHAR,
  "offense_code" BIGINT,
  "offense_code_group" VARCHAR,
  "offense_description" VARCHAR,
  "district" VARCHAR,
  "reporting_area" VARCHAR,
  "shooting" VARCHAR,
  "occurred_on_date" TIMESTAMP,
  "year" BIGINT,
  "month" BIGINT,
  "day_of_week" VARCHAR,
  "hour" BIGINT,
  "ucr_part" VARCHAR,
  "street" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "location" VARCHAR
);