{ "cells": [ { "cell_type": "markdown", "metadata": {}, "source": [ "# Pittsburgh Juvenile Arrests Data Analysis" ] }, { "cell_type": "markdown", "metadata": {}, "source": [ "## Importing libraries and initializing settings" ] }, { "cell_type": "code", "execution_count": 1, "metadata": { "collapsed": false }, "outputs": [ { "data": { "text/html": [ "" ], "text/vnd.plotly.v1+html": [ "" ] }, "metadata": {}, "output_type": "display_data" } ], "source": [ "import pandas as pd # pandas is a library for data manipulation and analysis\n", "pd.options.mode.chained_assignment = None # This will turn off an annoying warning\n", "\n", "import plotly # plotly is a library for interactive data visualization\n", "import plotly.graph_objs as go # this let's me make graphs with plotly more easily\n", "plotly.offline.init_notebook_mode() # this let's the graphs appear offline in the jupyter notebook" ] }, { "cell_type": "code", "execution_count": 2, "metadata": { "collapsed": false }, "outputs": [ { "name": "stdout", "output_type": "stream", "text": [ "(21311, 17)\n" ] }, { "data": { "text/html": [ "
\n", " | _id | \n", "PK | \n", "CCR | \n", "AGE | \n", "GENDER | \n", "RACE | \n", "ARRESTTIME | \n", "ARRESTLOCATION | \n", "OFFENSES | \n", "INCIDENTLOCATION | \n", "INCIDENTNEIGHBORHOOD | \n", "INCIDENTZONE | \n", "INCIDENTTRACT | \n", "COUNCIL_DISTRICT | \n", "PUBLIC_WORKS_DIVISION | \n", "X | \n", "Y | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
0 | \n", "5403 | \n", "1981357 | \n", "17024448 | \n", "26.0 | \n", "M | \n", "W | \n", "2017-02-09T01:04:00 | \n", "20 Block Bailey AV Pittsburgh, PA 15211 | \n", "5505 Public Drunkenness / 5503(a)(4) DISORDERL... | \n", "20 Block Bailey AV Pittsburgh, PA 15211 | \n", "Mount Washington | \n", "3 | \n", "1807.0 | \n", "3.0 | \n", "5.0 | \n", "-80.004461 | \n", "40.427049 | \n", "
1 | \n", "5404 | \n", "1981358 | \n", "17021346 | \n", "31.0 | \n", "F | \n", "W | \n", "2017-02-04T01:30:00 | \n", "N CHARLES ST & PERRYSVILLE AV Pittsburgh, PA 1... | \n", "3925 Receiving Stolen Property. / 1543 Driving... | \n", "N CHARLES ST & PERRYSVILLE AV Pittsburgh, PA 1... | \n", "Perry South | \n", "1 | \n", "2615.0 | \n", "6.0 | \n", "1.0 | \n", "-80.008598 | \n", "40.471006 | \n", "
2 | \n", "5405 | \n", "1981359 | \n", "17021351 | \n", "22.0 | \n", "M | \n", "B | \n", "2017-02-04T01:51:00 | \n", "2200 Block Somers DR Pittsburgh, PA 15219 | \n", "13(a)(16) Possession of Controlled Substance /... | \n", "2200 Block Somers DR Pittsburgh, PA 15219 | \n", "Bedford Dwellings | \n", "2 | \n", "509.0 | \n", "6.0 | \n", "3.0 | \n", "-79.975687 | \n", "40.449422 | \n", "
3 | \n", "10102 | \n", "1987251 | \n", "17120778 | \n", "33.0 | \n", "F | \n", "B | \n", "2017-06-29T20:04:00 | \n", "1400 Block 5th AV Pittsburgh, PA 15219 | \n", "13(a)(16) Possession of Controlled Substance /... | \n", "1400 Block 5th AV Pittsburgh, PA 15219 | \n", "Bluff | \n", "2 | \n", "103.0 | \n", "6.0 | \n", "3.0 | \n", "-79.986310 | \n", "40.438370 | \n", "
4 | \n", "10103 | \n", "1987255 | \n", "16164667 | \n", "25.0 | \n", "M | \n", "B | \n", "2017-07-02T02:00:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "3921 Theft by Unlawful Taking or Disposition. | \n", "20 Block Stanwix ST Pittsburgh, PA 15222 | \n", "Central Business District | \n", "2 | \n", "201.0 | \n", "6.0 | \n", "6.0 | \n", "-80.005178 | \n", "40.438667 | \n", "
\n", " | _id | \n", "PK | \n", "CCR | \n", "AGE | \n", "GENDER | \n", "RACE | \n", "ARRESTTIME | \n", "ARRESTLOCATION | \n", "OFFENSES | \n", "INCIDENTLOCATION | \n", "INCIDENTNEIGHBORHOOD | \n", "INCIDENTZONE | \n", "INCIDENTTRACT | \n", "COUNCIL_DISTRICT | \n", "PUBLIC_WORKS_DIVISION | \n", "X | \n", "Y | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
11894 | \n", "17346 | \n", "1996555 | \n", "5247781 | \n", "10.0 | \n", "M | \n", "B | \n", "2005-12-21T09:00:00 | \n", "40 Block COWAN ST PITTSBURGH, PA 15211 | \n", "912 Possession of Weapon on School Property. | \n", "40 Block COWAN ST PITTSBURGH, PA 15211 | \n", "NaN | \n", "3 | \n", "NaN | \n", "2.0 | \n", "5.0 | \n", "-80.010184 | \n", "40.427336 | \n", "
175 | \n", "16946 | \n", "1995957 | \n", "6216056 | \n", "29.0 | \n", "M | \n", "B | \n", "2006-11-02T09:00:00 | \n", "900 Block second AV Pittsburgh, PA 15219 | \n", "3921 Theft by Unlawful Taking or Disposition. ... | \n", "900 Block CRESSWELL ST PITTSBURGH, PA | \n", "NaN | \n", "3 | \n", "NaN | \n", "3.0 | \n", "3.0 | \n", "-79.976204 | \n", "40.408768 | \n", "
13644 | \n", "9504 | \n", "1986575 | \n", "7034314 | \n", "21.0 | \n", "F | \n", "B | \n", "2007-02-21T13:30:00 | \n", "100 Block Rhine PL Pittsburgh, PA 15212 | \n", "2701 Simple Assault. | \n", "100 Block RHINE PL PITTSBURGH, PA 15212 | \n", "Spring Hill-City View | \n", "1 | \n", "2620.0 | \n", "1.0 | \n", "1.0 | \n", "-79.994099 | \n", "40.466786 | \n", "
571 | \n", "10289 | \n", "1987517 | \n", "7102272 | \n", "40.0 | \n", "M | \n", "B | \n", "2007-05-22T16:42:00 | \n", "Tioga ST & Rosedale ST Pittsburgh, PA 15208 | \n", "13(a)(16) Possession of Controlled Substance /... | \n", "TIOGA ST & ROSEDALE ST PITTSBURGH, PA 15208 | \n", "Homewood South | \n", "5 | \n", "1303.0 | \n", "9.0 | \n", "2.0 | \n", "-79.886833 | \n", "40.450037 | \n", "
2663 | \n", "7666 | \n", "1984153 | \n", "8234583 | \n", "14.0 | \n", "F | \n", "B | \n", "2008-10-04T12:25:00 | \n", "200 Block Greenfield AV Pittsburgh, PA 15207 | \n", "2701 Simple Assault. | \n", "200 Block GREENFIELD AV PITTSBURGH, PA | \n", "Greenfield | \n", "4 | \n", "1516.0 | \n", "5.0 | \n", "3.0 | \n", "-79.949808 | \n", "40.425719 | \n", "
6060 | \n", "8981 | \n", "1985946 | \n", "11003677 | \n", "16.0 | \n", "M | \n", "B | \n", "2011-01-07T13:00:00 | \n", "3300 Block CENTRE AV PITTSBURGH, PA 15219 | \n", "2701(a)(1) Simple Assault - Intent., Know., Re... | \n", "500 Block N Highland AV Pittsburgh, PA 15206 | \n", "East Liberty | \n", "5 | \n", "1113.0 | \n", "8.0 | \n", "2.0 | \n", "-79.924961 | \n", "40.453011 | \n", "
17190 | \n", "19721 | \n", "1999542 | \n", "11115122 | \n", "22.0 | \n", "M | \n", "W | \n", "2011-06-23T02:30:00 | \n", "E Carson ST & S 22nd ST Pittsburgh, PA 15203 | \n", "4903 False Swearing. / 5505 Public Drunkenness... | \n", "E Carson ST & S 22nd ST Pittsburgh, PA 15203 | \n", "South Side Flats | \n", "3 | \n", "1702.0 | \n", "3.0 | \n", "3.0 | \n", "-79.974639 | \n", "40.428413 | \n", "
7695 | \n", "21261 | \n", "2001455 | \n", "12192736 | \n", "17.0 | \n", "M | \n", "B | \n", "2012-10-03T13:48:00 | \n", "600 Block 1st AV Pittsburgh, PA 15219 | \n", "2702 Aggravated Assault. | \n", "200 Block S Negley AV Pittsburgh, PA 15206 | \n", "East Liberty | \n", "5 | \n", "1115.0 | \n", "NaN | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "
16996 | \n", "20991 | \n", "2001135 | \n", "13004163 | \n", "17.0 | \n", "M | \n", "W | \n", "2013-02-27T01:21:00 | \n", "800 Block E Warrington AV Pittsburgh, PA 15210 | \n", "2711 Domestic Violence / 2701(a)(1) Simple Ass... | \n", "300 Block Merrimac ST Pittsburgh, PA 15211 | \n", "Mount Washington | \n", "3 | \n", "1903.0 | \n", "2.0 | \n", "5.0 | \n", "-80.013919 | \n", "40.431633 | \n", "
11973 | \n", "20297 | \n", "2000316 | \n", "14025127 | \n", "24.0 | \n", "M | \n", "B | \n", "2014-02-09T01:22:00 | \n", "2200 Block E Carson ST Pittsburgh, PA 15203 | \n", "2702 Aggravated Assault. / 5104 Resisting Arre... | \n", "2200 Block E Carson ST Pittsburgh, PA 15203 | \n", "South Side Flats | \n", "3 | \n", "1609.0 | \n", "3.0 | \n", "3.0 | \n", "-79.974454 | \n", "40.428227 | \n", "
9640 | \n", "17847 | \n", "1997180 | \n", "14086284 | \n", "27.0 | \n", "F | \n", "W | \n", "2014-05-10T04:05:00 | \n", "4000 Block Cabinet WY Pittsburgh, PA 15224 | \n", "2701 Simple Assault. / 5503(a)(3) DISORDERLY C... | \n", "4000 Block Cabinet WY Pittsburgh, PA 15224 | \n", "Bloomfield | \n", "5 | \n", "903.0 | \n", "7.0 | \n", "2.0 | \n", "-79.957555 | \n", "40.463864 | \n", "
5883 | \n", "12186 | \n", "1989823 | \n", "14204457 | \n", "23.0 | \n", "M | \n", "W | \n", "2014-10-13T03:47:00 | \n", "Copperfield AV & Mt Joseph ST Pittsburgh, PA 1... | \n", "2706 Terroristic Threats. / 5104 Resisting Arr... | \n", "Copperfield AV & Mt Joseph ST Pittsburgh, PA 1... | \n", "Carrick | \n", "3 | \n", "2901.0 | \n", "4.0 | \n", "3.0 | \n", "-79.989725 | \n", "40.395400 | \n", "
18311 | \n", "4620 | \n", "1980392 | \n", "14227728 | \n", "20.0 | \n", "F | \n", "B | \n", "2014-11-16T03:42:00 | \n", "3200 Block Middletown RD Pittsburgh, PA 15204 | \n", "903 Criminal Conspiracy. / 2702 Aggravated Ass... | \n", "3200 Block Middletown RD Pittsburgh, PA 15204 | \n", "Windgap | \n", "6 | \n", "2807.0 | \n", "2.0 | \n", "5.0 | \n", "-80.066741 | \n", "40.450950 | \n", "
18312 | \n", "4621 | \n", "1980393 | \n", "14227728 | \n", "30.0 | \n", "M | \n", "B | \n", "2014-11-16T03:42:00 | \n", "3200 Block Middletown RD Pittsburgh, PA 15204 | \n", "903 Criminal Conspiracy. / 2702 Aggravated Ass... | \n", "3200 Block Middletown RD Pittsburgh, PA 15204 | \n", "Windgap | \n", "6 | \n", "2807.0 | \n", "2.0 | \n", "5.0 | \n", "-80.066741 | \n", "40.450950 | \n", "
2762 | \n", "4619 | \n", "1980391 | \n", "14227728 | \n", "27.0 | \n", "F | \n", "B | \n", "2014-11-16T03:42:00 | \n", "3200 Block Middletown RD Pittsburgh, PA 15204 | \n", "903 Criminal Conspiracy. / 2702 Aggravated Ass... | \n", "3200 Block Middletown RD Pittsburgh, PA 15204 | \n", "Windgap | \n", "6 | \n", "2807.0 | \n", "2.0 | \n", "5.0 | \n", "-80.066741 | \n", "40.450950 | \n", "
11576 | \n", "18991 | \n", "1998615 | \n", "14179431 | \n", "33.0 | \n", "F | \n", "B | \n", "2015-02-19T14:00:00 | \n", "200 Block Allegheny River BL Pittsburgh, PA 15147 | \n", "2709(a)(1) Harassment by Physical Contact, or ... | \n", "5300 Block Broad ST Pittsburgh, PA 15224 | \n", "Garfield | \n", "5 | \n", "1017.0 | \n", "9.0 | \n", "2.0 | \n", "-79.938203 | \n", "40.465812 | \n", "
10251 | \n", "633 | \n", "1975435 | \n", "15095591 | \n", "25.0 | \n", "M | \n", "B | \n", "2015-05-29T07:55:00 | \n", "Gladys AV & Crane AV Pittsburgh, PA 15216 | \n", "3111 Obedience to Traffic-Control Devices. / 3... | \n", "Gladys AV & Crane AV Pittsburgh, PA 15216 | \n", "Beechview | \n", "6 | \n", "1916.0 | \n", "4.0 | \n", "5.0 | \n", "-80.024245 | \n", "40.416917 | \n", "
11802 | \n", "15467 | \n", "1994019 | \n", "15120242 | \n", "16.0 | \n", "M | \n", "B | \n", "2015-07-02T19:19:00 | \n", "600 Block 1st AV Pittsburgh, PA 15219 | \n", "2701 Simple Assault. | \n", "400 Block N Taylor AV Pittsburgh, PA 15212 | \n", "Central North Side | \n", "1 | \n", "2206.0 | \n", "1.0 | \n", "1.0 | \n", "-80.011298 | \n", "40.456933 | \n", "
2622 | \n", "3706 | \n", "1979277 | \n", "15204846 | \n", "22.0 | \n", "M | \n", "W | \n", "2015-11-04T19:45:00 | \n", "600 Block 1st AV Pittsburgh, PA 15219 | \n", "6310.1 Selling Liquor to Minors / 601.04 (c) (... | \n", "3800 Block Bates ST Pittsburgh, PA 15213 | \n", "Central Oakland | \n", "4 | \n", "406.0 | \n", "3.0 | \n", "3.0 | \n", "-79.953347 | \n", "40.438601 | \n", "
2680 | \n", "3707 | \n", "1979278 | \n", "15204846 | \n", "21.0 | \n", "M | \n", "W | \n", "2015-11-04T19:45:00 | \n", "600 Block 1st AV Pittsburgh, PA 15219 | \n", "6310.1 Selling Liquor to Minors / 601.04 (c) (... | \n", "3800 Block Bates ST Pittsburgh, PA 15213 | \n", "Central Oakland | \n", "4 | \n", "406.0 | \n", "3.0 | \n", "3.0 | \n", "-79.953347 | \n", "40.438601 | \n", "
14592 | \n", "4672 | \n", "1980444 | \n", "16024425 | \n", "24.0 | \n", "F | \n", "B | \n", "2016-02-12T21:00:00 | \n", "600 Block First AV Pittsburgh, PA 15219 | \n", "2701(a)(1) Simple Assault - Intent., Know., Re... | \n", "1100 Block McKinney LANE Pittsburgh, PA 15205 | \n", "Ridgemont | \n", "6 | \n", "2016.0 | \n", "2.0 | \n", "5.0 | \n", "-80.035034 | \n", "40.423529 | \n", "
17650 | \n", "632 | \n", "1975385 | \n", "16029218 | \n", "31.0 | \n", "M | \n", "W | \n", "2016-02-17T15:25:00 | \n", "800 Block Concord ST Pittsburgh, PA 15212 | \n", "13(a)(16) Possession of Controlled Substance /... | \n", "800 Block Concord ST Pittsburgh, PA 15212 | \n", "East Allegheny | \n", "1 | \n", "2304.0 | \n", "1.0 | \n", "1.0 | \n", "-79.997924 | \n", "40.457564 | \n", "
5272 | \n", "3338 | \n", "1978790 | \n", "16004552 | \n", "31.0 | \n", "F | \n", "O | \n", "2016-03-03T09:45:00 | \n", "600 Block 1st AV Pittsburgh, PA 15219 | \n", "9015 Failure To Appear/Arrest on Attachment Order | \n", "600 Block Liberty AV Pittsburgh, PA 15222 | \n", "Central Business District | \n", "2 | \n", "201.0 | \n", "6.0 | \n", "6.0 | \n", "-80.001620 | \n", "40.441773 | \n", "
20536 | \n", "1245 | \n", "1976029 | \n", "16060056 | \n", "22.0 | \n", "M | \n", "W | \n", "2016-04-04T00:45:00 | \n", "S 15th ST & E Carson ST Pittsburgh, PA 15203 | \n", "2702 Aggravated Assault. / 2706 Terroristic Th... | \n", "S 15th ST & E Carson ST Pittsburgh, PA 15203 | \n", "South Side Flats | \n", "3 | \n", "1702.0 | \n", "3.0 | \n", "3.0 | \n", "-79.983425 | \n", "40.428815 | \n", "
12247 | \n", "4666 | \n", "1980438 | \n", "16062908 | \n", "36.0 | \n", "M | \n", "W | \n", "2016-04-08T02:34:00 | \n", "Boyd ST & Diamond ST Pittsburgh, PA 15219 | \n", "13(a)(32) Paraphernalia - Use or Possession | \n", "Boyd ST & Diamond ST Pittsburgh, PA 15219 | \n", "Bluff | \n", "2 | \n", "103.0 | \n", "6.0 | \n", "6.0 | \n", "-79.993293 | \n", "40.438656 | \n", "
18572 | \n", "4664 | \n", "1980436 | \n", "16054146 | \n", "60.0 | \n", "M | \n", "W | \n", "2016-04-10T09:00:00 | \n", "600 Block 1st AV Pittsburgh, PA 15219 | \n", "5104 Resisting Arrest or Other Law Enforcement... | \n", "Forbes AV & Armstrong TUN Pittsburgh, PA 15219 | \n", "Bluff | \n", "2 | \n", "103.0 | \n", "6.0 | \n", "6.0 | \n", "-79.992052 | \n", "40.437971 | \n", "
18585 | \n", "4665 | \n", "1980437 | \n", "16058996 | \n", "54.0 | \n", "M | \n", "B | \n", "2016-04-12T01:30:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "2705 Recklessy Endangering Another Person. / 2... | \n", "1600 Block Forbes AV Pittsburgh, PA 15219 | \n", "Bluff | \n", "2 | \n", "103.0 | \n", "6.0 | \n", "3.0 | \n", "-79.983870 | \n", "40.437377 | \n", "
15079 | \n", "4667 | \n", "1980439 | \n", "16061851 | \n", "20.0 | \n", "M | \n", "B | \n", "2016-04-12T19:55:00 | \n", "600 Block First AV Pittsburgh, PA 15219 | \n", "3924 Theft of Property Lost, Mislaid or Delive... | \n", "400 Block Wood ST Pittsburgh, PA 15219 | \n", "Central Business District | \n", "2 | \n", "201.0 | \n", "6.0 | \n", "6.0 | \n", "-80.001223 | \n", "40.439375 | \n", "
12248 | \n", "4670 | \n", "1980442 | \n", "16066821 | \n", "31.0 | \n", "M | \n", "W | \n", "2016-04-13T20:00:00 | \n", "1000 Block Fort Duquesne BL Pittsburgh, PA 15222 | \n", "2702 Aggravated Assault. / 5104 Resisting Arre... | \n", "1000 Block Fort Duquesne BL Pittsburgh, PA 15222 | \n", "Central Business District | \n", "2 | \n", "201.0 | \n", "6.0 | \n", "6.0 | \n", "-79.995245 | \n", "40.445511 | \n", "
14454 | \n", "4668 | \n", "1980440 | \n", "16066821 | \n", "29.0 | \n", "M | \n", "W | \n", "2016-04-13T20:00:00 | \n", "1000 Block Fort Duquesne BL Pittsburgh, PA 15222 | \n", "2702 Aggravated Assault. / 5104 Resisting Arre... | \n", "1000 Block Fort Duquesne BL Pittsburgh, PA 15222 | \n", "Central Business District | \n", "2 | \n", "201.0 | \n", "6.0 | \n", "6.0 | \n", "-79.995245 | \n", "40.445511 | \n", "
... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "... | \n", "
10606 | \n", "21074 | \n", "2001239 | \n", "17249529 | \n", "46.0 | \n", "M | \n", "B | \n", "2018-06-12T07:03:00 | \n", "1600 Block Penn AV Pittsburgh, PA 15222 | \n", "5101 Obstructing Admin. of Law / 5105 Hinderi... | \n", "1600 Block Penn AV Pittsburgh, PA 15222 | \n", "Strip District | \n", "2 | \n", "203.0 | \n", "7.0 | \n", "6.0 | \n", "-79.987472 | \n", "40.448835 | \n", "
15643 | \n", "21077 | \n", "2001242 | \n", "18035414 | \n", "49.0 | \n", "M | \n", "W | \n", "2018-06-12T07:30:00 | \n", "400 Block JANICE DR Pittsburgh, PA 15235 | \n", "3502 Burglary. / 3921 Theft by Unlawful Taking... | \n", "1700 Block Jancey ST Pittsburgh, PA 15206 | \n", "Morningside | \n", "5 | \n", "1014.0 | \n", "7.0 | \n", "2.0 | \n", "-79.927590 | \n", "40.484790 | \n", "
17208 | \n", "21081 | \n", "2001246 | \n", "18076507 | \n", "49.0 | \n", "M | \n", "W | \n", "2018-06-12T07:30:00 | \n", "400 Block JANICE DR Pittsburgh, PA 15235 | \n", "3502 Burglary. / 3921 Theft by Unlawful Taking... | \n", "1700 Block Jancey ST Pittsburgh, PA 15206 | \n", "Morningside | \n", "5 | \n", "1014.0 | \n", "7.0 | \n", "2.0 | \n", "-79.927590 | \n", "40.484790 | \n", "
15677 | \n", "21085 | \n", "2001250 | \n", "18085255 | \n", "49.0 | \n", "M | \n", "W | \n", "2018-06-12T07:30:00 | \n", "400 Block JANICE DR Pittsburgh, PA 15235 | \n", "3921 Theft by Unlawful Taking or Disposition. ... | \n", "1500 Block Hawthorne ST Pittsburgh, PA 15201 | \n", "Stanton Heights | \n", "5 | \n", "1018.0 | \n", "7.0 | \n", "2.0 | \n", "-79.934272 | \n", "40.484916 | \n", "
7000 | \n", "21080 | \n", "2001245 | \n", "18047226 | \n", "21.0 | \n", "M | \n", "B | \n", "2018-06-12T10:20:00 | \n", "600 Block 1ST AV Pittsburgh, PA 15219 | \n", "9015 Failure To Appear/Arrest on Attachment Order | \n", "200 Block Fifth AV Pittsburgh, PA 15222 | \n", "Central Business District | \n", "2 | \n", "201.0 | \n", "6.0 | \n", "6.0 | \n", "-80.002077 | \n", "40.441236 | \n", "
1983 | \n", "21082 | \n", "2001247 | \n", "18078665 | \n", "34.0 | \n", "F | \n", "W | \n", "2018-06-12T11:10:00 | \n", "1400 Block prospect RD Pittsburgh, PA 15227 | \n", "3921 Theft by Unlawful Taking or Disposition. ... | \n", "100 Block N Bellefield AV Pittsburgh, PA 15213 | \n", "North Oakland | \n", "4 | \n", "404.0 | \n", "8.0 | \n", "3.0 | \n", "-79.951835 | \n", "40.447152 | \n", "
15942 | \n", "21160 | \n", "2001341 | \n", "18106111 | \n", "66.0 | \n", "M | \n", "B | \n", "2018-06-12T11:15:00 | \n", "900 Block 2ND AV Pittsburgh, PA 15219 | \n", "13(a)(16) Possession of Controlled Substance /... | \n", "1500 Block Monterey ST Pittsburgh, PA 15212 | \n", "Central North Side | \n", "1 | \n", "2503.0 | \n", "6.0 | \n", "1.0 | \n", "-80.013412 | \n", "40.457302 | \n", "
15734 | \n", "21099 | \n", "2001264 | \n", "18101188 | \n", "50.0 | \n", "F | \n", "B | \n", "2018-06-12T11:45:00 | \n", "600 Block 1st AV Pittsburgh, PA 15219 | \n", "2701 Simple Assault. | \n", "4800 Block Friendship AV Pittsburgh, PA 15224 | \n", "Bloomfield | \n", "5 | \n", "809.0 | \n", "7.0 | \n", "2.0 | \n", "-79.946263 | \n", "40.462132 | \n", "
15720 | \n", "21095 | \n", "2001260 | \n", "18099412 | \n", "38.0 | \n", "M | \n", "B | \n", "2018-06-12T14:05:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "3925 Receiving Stolen Property. / 6105(a)(1) P... | \n", "60 Block E Amanda AV Pittsburgh, PA 15210 | \n", "Knoxville | \n", "3 | \n", "3001.0 | \n", "3.0 | \n", "5.0 | \n", "-79.988121 | \n", "40.419383 | \n", "
18349 | \n", "21073 | \n", "2001238 | \n", "17144182 | \n", "37.0 | \n", "M | \n", "W | \n", "2018-06-12T16:45:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "2706 Terroristic Threats. / 2718(a)(1) Strangu... | \n", "300 Block Aidyl AV Pittsburgh, PA 15226 | \n", "Brookline | \n", "6 | \n", "1919.0 | \n", "4.0 | \n", "5.0 | \n", "-80.027560 | \n", "40.395325 | \n", "
17026 | \n", "21076 | \n", "2001241 | \n", "18023748 | \n", "27.0 | \n", "M | \n", "W | \n", "2018-06-12T17:52:00 | \n", "Olympia ST & Piermont ST Pittsburgh, PA 15211 | \n", "3921(a) Theft by Unlawful Taking or Dispositio... | \n", "5700 Block Beacon ST Pittsburgh, PA 15217 | \n", "Squirrel Hill South | \n", "4 | \n", "1413.0 | \n", "5.0 | \n", "3.0 | \n", "-79.924713 | \n", "40.434526 | \n", "
4561 | \n", "21075 | \n", "2001240 | \n", "18016037 | \n", "27.0 | \n", "M | \n", "W | \n", "2018-06-12T17:52:00 | \n", "Olympia ST & Piermont ST Pittsburgh, PA 15211 | \n", "2706 Terroristic Threats. | \n", "5700 Block Beacon ST Pittsburgh, PA 15217 | \n", "Squirrel Hill South | \n", "4 | \n", "1413.0 | \n", "5.0 | \n", "3.0 | \n", "-79.924713 | \n", "40.434526 | \n", "
7062 | \n", "21098 | \n", "2001263 | \n", "18100310 | \n", "54.0 | \n", "M | \n", "B | \n", "2018-06-12T19:30:00 | \n", "Forbes AV & Stanwinx ST Pittsburgh, PA 15222 | \n", "3701 Robbery. | \n", "500 Block Francis ST Pittsburgh, PA 15219 | \n", "Middle Hill | \n", "2 | \n", "501.0 | \n", "6.0 | \n", "3.0 | \n", "-79.967494 | \n", "40.447140 | \n", "
17044 | \n", "21097 | \n", "2001262 | \n", "18100059 | \n", "54.0 | \n", "M | \n", "B | \n", "2018-06-12T19:30:00 | \n", "Forbes AV & Stanwix ST Pittsburgh, PA 15222 | \n", "2701 Simple Assault. / 3701 Robbery. | \n", "4000 Block Brighton RD Pittsburgh, PA 15212 | \n", "Brighton Heights | \n", "1 | \n", "2701.0 | \n", "1.0 | \n", "1.0 | \n", "-80.040852 | \n", "40.487917 | \n", "
17027 | \n", "21078 | \n", "2001243 | \n", "18044785 | \n", "42.0 | \n", "F | \n", "W | \n", "2018-06-12T20:11:00 | \n", "E Elizabeth ST & Gertrude ST Pittsburgh, PA 15207 | \n", "9015 Failure To Appear/Arrest on Attachment Order | \n", "2nd AV & Mansion ST Pittsburgh, PA 15207 | \n", "Hazelwood | \n", "4 | \n", "1515.0 | \n", "5.0 | \n", "3.0 | \n", "-79.942313 | \n", "40.403720 | \n", "
17250 | \n", "21087 | \n", "2001252 | \n", "18090363 | \n", "23.0 | \n", "M | \n", "B | \n", "2018-06-12T22:47:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "9015 Failure To Appear/Arrest on Attachment Order | \n", "3400 Block Gass AV Pittsburgh, PA 15212 | \n", "Brighton Heights | \n", "1 | \n", "2703.0 | \n", "1.0 | \n", "1.0 | \n", "-80.034672 | \n", "40.477074 | \n", "
15702 | \n", "21086 | \n", "2001251 | \n", "18086148 | \n", "25.0 | \n", "F | \n", "W | \n", "2018-06-13T02:06:00 | \n", "600 Block 1st AV Pittsburgh, PA 15219 | \n", "5104 Resisting Arrest or Other Law Enforcement... | \n", "4000 Block Butler ST Pittsburgh, PA 15201 | \n", "Central Lawrenceville | \n", "2 | \n", "902.0 | \n", "7.0 | \n", "2.0 | \n", "-79.961681 | \n", "40.468701 | \n", "
2466 | \n", "21111 | \n", "2001276 | \n", "18102216 | \n", "28.0 | \n", "M | \n", "B | \n", "2018-06-13T08:25:00 | \n", "600 Block 1ST AV Pittsburgh, PA 15219 | \n", "2706 Terroristic Threats. / 2709(a) Harassment. | \n", "300 Block Beltzhoover AV Pittsburgh, PA 15210 | \n", "Beltzhoover | \n", "3 | \n", "1809.0 | \n", "3.0 | \n", "5.0 | \n", "-79.997515 | \n", "40.419880 | \n", "
15645 | \n", "21083 | \n", "2001248 | \n", "18080966 | \n", "30.0 | \n", "M | \n", "W | \n", "2018-06-13T09:00:00 | \n", "Zone 2 | \n", "3127 Indecent Exposure. | \n", "Zone 2 | \n", "NaN | \n", "2 | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "NaN | \n", "
15759 | \n", "21106 | \n", "2001271 | \n", "18046664 | \n", "22.0 | \n", "M | \n", "B | \n", "2018-06-13T11:45:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "1543 Driving While Operating Privilege is Susp... | \n", "1300 Block Silverton AV Pittsburgh, PA 15206 | \n", "Lincoln-Lemington-Belmar | \n", "5 | \n", "1202.0 | \n", "NaN | \n", "NaN | \n", "0.000000 | \n", "0.000000 | \n", "
10656 | \n", "21107 | \n", "2001272 | \n", "18058660 | \n", "40.0 | \n", "M | \n", "U | \n", "2018-06-13T13:10:00 | \n", "600 Block 1ST AV Pittsburgh, PA 15219 | \n", "3926(a)(1) Theft of Services; Cable, Gas, Taxi... | \n", "500 Block N Craig ST Pittsburgh, PA 15213 | \n", "North Oakland | \n", "4 | \n", "507.0 | \n", "6.0 | \n", "3.0 | \n", "-79.954405 | \n", "40.456098 | \n", "
15764 | \n", "21105 | \n", "2001270 | \n", "17234757 | \n", "20.0 | \n", "M | \n", "B | \n", "2018-06-13T16:40:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "9015 Failure To Appear/Arrest on Attachment Order | \n", "100 Block N Negley AV Pittsburgh, PA 15206 | \n", "Garfield | \n", "5 | \n", "1114.0 | \n", "7.0 | \n", "2.0 | \n", "-79.924731 | \n", "40.474284 | \n", "
15649 | \n", "21084 | \n", "2001249 | \n", "18083529 | \n", "18.0 | \n", "M | \n", "B | \n", "2018-06-13T19:10:00 | \n", "600 Block First AV Pittsburgh, PA 15219 | \n", "9015 Failure To Appear/Arrest on Attachment Order | \n", "100 Block Rhine PL Pittsburgh, PA 15212 | \n", "Spring Hill-City View | \n", "1 | \n", "2620.0 | \n", "1.0 | \n", "1.0 | \n", "-79.992042 | \n", "40.465360 | \n", "
15719 | \n", "21092 | \n", "2001257 | \n", "18095330 | \n", "25.0 | \n", "M | \n", "B | \n", "2018-06-13T19:29:00 | \n", "700 Block Grand AV Wilkinsburgh, PA 15221 | \n", "13(a)(32) Paraphernalia - Use or Possession / ... | \n", "1400 Block Washington BL Pittsburgh, PA 15206 | \n", "Highland Park | \n", "5 | \n", "1106.0 | \n", "9.0 | \n", "2.0 | \n", "-79.908608 | \n", "40.470381 | \n", "
15714 | \n", "21091 | \n", "2001256 | \n", "18095330 | \n", "56.0 | \n", "M | \n", "B | \n", "2018-06-13T19:29:00 | \n", "Bennett ST & Tokay ST Pittsburgh, PA 15221 | \n", "6105(a)(1) Persons not to possess, use, manufa... | \n", "1400 Block Washington BL Pittsburgh, PA 15206 | \n", "Highland Park | \n", "5 | \n", "1106.0 | \n", "9.0 | \n", "2.0 | \n", "-79.908608 | \n", "40.470381 | \n", "
7379 | \n", "21177 | \n", "2001358 | \n", "18106641 | \n", "31.0 | \n", "M | \n", "B | \n", "2018-06-13T19:56:00 | \n", "600 Block 1st AV Pittsburgh, PA 15219 | \n", "2705 Recklessy Endangering Another Person. / 1... | \n", "300 Block 5th AV Pittsburgh, PA 15222 | \n", "Central Business District | \n", "2 | \n", "201.0 | \n", "6.0 | \n", "6.0 | \n", "-80.000290 | \n", "40.440526 | \n", "
2403 | \n", "21104 | \n", "2001269 | \n", "17166975 | \n", "38.0 | \n", "F | \n", "W | \n", "2018-06-13T22:20:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "9015 Failure To Appear/Arrest on Attachment Order | \n", "200 Block S Winebiddle ST Pittsburgh, PA 15224 | \n", "Bloomfield | \n", "5 | \n", "809.0 | \n", "7.0 | \n", "2.0 | \n", "-79.943252 | \n", "40.464531 | \n", "
15765 | \n", "21108 | \n", "2001273 | \n", "18065533 | \n", "24.0 | \n", "F | \n", "B | \n", "2018-06-13T23:00:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "2701 Simple Assault. / 3502 Burglary. / 3921 T... | \n", "7400 Block Monticello ST Pittsburgh, PA 15208 | \n", "Homewood North | \n", "5 | \n", "1302.0 | \n", "9.0 | \n", "2.0 | \n", "-79.891016 | \n", "40.458322 | \n", "
10657 | \n", "21109 | \n", "2001274 | \n", "18074479 | \n", "60.0 | \n", "M | \n", "B | \n", "2018-06-14T02:19:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "9015 Failure To Appear/Arrest on Attachment Order | \n", "1400 Block Adams ST Pittsburgh, PA 15233 | \n", "Manchester | \n", "1 | \n", "2107.0 | \n", "6.0 | \n", "1.0 | \n", "-80.027999 | \n", "40.458723 | \n", "
15776 | \n", "21110 | \n", "2001275 | \n", "18074777 | \n", "46.0 | \n", "F | \n", "B | \n", "2018-06-14T02:50:00 | \n", "900 Block 2nd AV Pittsburgh, PA 15219 | \n", "2701 Simple Assault. / 2706 Terroristic Threats. | \n", "2500 Block Brighton RD Pittsburgh, PA 15212 | \n", "Marshall-Shadeland | \n", "1 | \n", "2704.0 | \n", "6.0 | \n", "1.0 | \n", "-80.024794 | \n", "40.467289 | \n", "
21104 rows × 17 columns
\n", "\n", " | _id | \n", "PK | \n", "CCR | \n", "AGE | \n", "GENDER | \n", "RACE | \n", "ARRESTTIME | \n", "ARRESTLOCATION | \n", "OFFENSES | \n", "INCIDENTLOCATION | \n", "... | \n", "COUNCIL_DISTRICT | \n", "PUBLIC_WORKS_DIVISION | \n", "X | \n", "Y | \n", "Year | \n", "Month | \n", "Race_Full | \n", "Gender_Full | \n", "Date | \n", "Time | \n", "
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
38 | \n", "3547 | \n", "1979079 | \n", "16150139 | \n", "17 | \n", "M | \n", "B | \n", "2016-12-20T13:40:00 | \n", "900 Block 2ND AV Pittsburgh, PA 15219 | \n", "903 Criminal Conspiracy. / 3701 Robbery. | \n", "100 Block N St Clair ST Pittsburgh, PA 15206 | \n", "... | \n", "9.0 | \n", "2.0 | \n", "-79.927465 | \n", "40.464938 | \n", "2016 | \n", "12 | \n", "Black | \n", "Male | \n", "2016-12-20 | \n", "13:40:00 | \n", "
44 | \n", "8402 | \n", "1985164 | \n", "17076778 | \n", "12 | \n", "M | \n", "B | \n", "2017-05-02T11:45:00 | \n", "600 Block 1ST AV PITTSBURGH, PA 15219 | \n", "2705 Recklessy Endangering Another Person. / 2... | \n", "600 Block FILBERT ST PITTSBURGH, PA 15232 | \n", "... | \n", "8.0 | \n", "2.0 | \n", "-79.934186 | \n", "40.453219 | \n", "2017 | \n", "5 | \n", "Black | \n", "Male | \n", "2017-05-02 | \n", "11:45:00 | \n", "
55 | \n", "11794 | \n", "1989328 | \n", "17151293 | \n", "14 | \n", "F | \n", "B | \n", "2017-08-10T21:00:00 | \n", "700 Block Chautauqua ST Pittsburgh, PA 15214 | \n", "2701 Simple Assault. | \n", "700 Block Chautauqua CT Pittsburgh, PA 15214 | \n", "... | \n", "6.0 | \n", "1.0 | \n", "-80.017851 | \n", "40.463887 | \n", "2017 | \n", "8 | \n", "Black | \n", "Female | \n", "2017-08-10 | \n", "21:00:00 | \n", "
76 | \n", "15544 | \n", "1994111 | \n", "17207824 | \n", "17 | \n", "F | \n", "B | \n", "2017-12-05T09:00:00 | \n", "600 Block 1ST AV PITTSBURGH, PA 15219 | \n", "2701 Simple Assault. / 5503(a)(4) DISORDERLY C... | \n", "1100 Block N MURTLAND ST PITTSBURGH, PA 15208 | \n", "... | \n", "9.0 | \n", "2.0 | \n", "-79.900142 | \n", "40.460411 | \n", "2017 | \n", "12 | \n", "Black | \n", "Female | \n", "2017-12-05 | \n", "09:00:00 | \n", "
117 | \n", "6809 | \n", "1983081 | \n", "17033703 | \n", "12 | \n", "F | \n", "B | \n", "2017-03-13T14:15:00 | \n", "600 Block 1ST AV PITTSBURGH, PA 15219 | \n", "13(a)(31) Marijuana: Possession Small Amount | \n", "3500 Block FLEMING AV PITTSBURGH, PA 15212 | \n", "... | \n", "1.0 | \n", "1.0 | \n", "-80.038475 | \n", "40.478588 | \n", "2017 | \n", "3 | \n", "Black | \n", "Female | \n", "2017-03-13 | \n", "14:15:00 | \n", "
5 rows × 23 columns
\n", "