STAT380 - Project 1 (guided)

STAT380 Data Products Development

Author

YOUR NAME HERE

Published

6/16/25

Code
# install the packages below if not installed yet
library(tidyverse)
library(leaflet)
library(stringr)
library(sf) 
library(here)
library(widgetframe)
library(googleVis)

# set options to display googleVis plots
op <- options(gvis.plot.tag = 'chart')

Note: If you qmd file submission renders you will receive total of (5 points Extra Credit)

Directions: Complete the two (2) tasks below. Code chunks are included but you can add additional as needed using Ctrl+ Alt + I key combination.

Project 1 (Total 50 pts):

Task 1: Crime Data from the City of Chicago in 2017

This dataset reflects reported incidents of crime (with the exception of murders where data exists for each victim) that occurred in the City of Chicago from 2001 to present, minus the most recent seven days. Data is extracted from the Chicago Police Department’s CLEAR (Citizen Law Enforcement Analysis and Reporting) system. In order to protect the privacy of crime victims, addresses are shown at the block level only and specific locations are not identified. Should you have questions about this dataset, you may contact the Research & Development Division of the Chicago Police Department at 312.745.6071 or RandD@chicagopolice.org.

Link to the data: [https://data.cityofchicago.org/Public-Safety/Crimes-2017/d62x-nvdr]

A bit of data preparation

Note: I have placed my data file in a subfolder in the working directory called data. Adjust the path in the read.csv()` function when you read your data file that is provided in the project item.

You can also read it directly from the https location, code commented in the chunk below but it is not practical to knit your document and read the file from the web every time!

Code
# create data.frame reading the data from the web with read.csv() function, user HEADER=true as columns carry the name of the variables
crimes <- read.csv("C:/Users/dasha/Downloads/Crimes-2017.csv", header = TRUE) 
dim(crimes)
[1] 268221     30
Code
# Uncomment the line below if you want to read the file from the web
crimes<- read.csv("https://data.cityofchicago.org/api/views/d62x-nvdr/rows.csv?accessType=DOWNLOAD", header = TRUE)

# have a look at the data
glimpse(crimes)
Rows: 269,273
Columns: 22
$ ID                   <int> 11192233, 11196379, 11192540, 11192254, 11192239,…
$ Case.Number          <chr> "JB100016", "JB105867", "JB100551", "JB100003", "…
$ Date                 <chr> "12/31/2017 11:58:00 PM", "12/31/2017 11:50:00 PM…
$ Block                <chr> "046XX N ST LOUIS AVE", "024XX N LAKE SHORE DR NB…
$ IUCR                 <chr> "0630", "0460", "0890", "041A", "1320", "1811", "…
$ Primary.Type         <chr> "BURGLARY", "BATTERY", "THEFT", "BATTERY", "CRIMI…
$ Description          <chr> "ATTEMPT FORCIBLE ENTRY", "SIMPLE", "FROM BUILDIN…
$ Location.Description <chr> "APARTMENT", "MOVIE HOUSE/THEATER", "HOTEL/MOTEL"…
$ Arrest               <chr> "false", "false", "false", "false", "false", "tru…
$ Domestic             <chr> "false", "false", "false", "true", "true", "false…
$ Beat                 <int> 1723, 1935, 1833, 522, 1235, 1633, 1712, 513, 183…
$ District             <int> 17, 19, 18, 5, 12, 16, 17, 5, 18, 22, 22, 8, 5, 1…
$ Ward                 <int> 33, 43, 42, 34, 25, 38, 39, 34, 42, 21, 21, 13, 9…
$ Community.Area       <int> 14, 7, 8, 53, 31, 15, 14, 49, 8, 73, 71, 65, 50, …
$ FBI.Code             <chr> "05", "08B", "06", "04B", "14", "18", "14", "26",…
$ X.Coordinate         <int> 1152214, 1175293, 1177508, 1178329, 1173432, 1139…
$ Y.Coordinate         <int> 1930694, 1916610, 1905401, 1828012, 1891037, 1925…
$ Year                 <int> 2017, 2017, 2017, 2017, 2017, 2017, 2017, 2017, 2…
$ Updated.On           <chr> "05/04/2018 03:51:04 PM", "05/04/2018 03:51:04 PM…
$ Latitude             <dbl> 41.96569, 41.92656, 41.89575, 41.68337, 41.85643,…
$ Longitude            <dbl> -87.71573, -87.63129, -87.62350, -87.62283, -87.6…
$ Location             <chr> "POINT (-87.715726125 41.965693651)", "POINT (-87…

a) (10 pts) Describe the data, how many observations on how many variables. Can you see variables that carry the geographic pieces of information, what are their names?

YOUR DESCRIPTION/ANSWER HERE:

Rubric:

  • Codes run for reading the data 2 pts

  • State correct number of observation 3 pts

  • State correct number of variables 3 pts

  • Name the variables pertaining to the geographic location 2 pts

b) (10 pts) Use the Chicago crimes data to draw a map of the city identifying the location of each reported kidnapping.

  • Filter the data to extract records for which the Primary.Type == “KIDNAPPING”.

Write YOUR CODE in the chunk below:

Code
crimes <- read.csv("C:/Users/dasha/Downloads/Crimes-2017.csv", header = TRUE) 
dim(crimes)
[1] 268221     30
Code
glimpse(crimes)
Rows: 268,221
Columns: 30
$ ID                         <int> 11192233, 11196379, 11192540, 11192254, 111…
$ Case.Number                <chr> "JB100016", "JB105867", "JB100551", "JB1000…
$ Date                       <chr> "12/31/2017 11:58:00 PM", "12/31/2017 11:50…
$ Block                      <chr> "046XX N ST LOUIS AVE", "024XX N LAKE SHORE…
$ IUCR                       <chr> "0630", "0460", "0890", "041A", "1320", "18…
$ Primary.Type               <chr> "BURGLARY", "BATTERY", "THEFT", "BATTERY", …
$ Description                <chr> "ATTEMPT FORCIBLE ENTRY", "SIMPLE", "FROM B…
$ Location.Description       <chr> "APARTMENT", "MOVIE HOUSE/THEATER", "HOTEL/…
$ Arrest                     <chr> "false", "false", "false", "false", "false"…
$ Domestic                   <chr> "false", "false", "false", "true", "true", …
$ Beat                       <int> 1723, 1935, 1833, 522, 1235, 1633, 1712, 51…
$ District                   <int> 17, 19, 18, 5, 12, 16, 17, 5, 8, 18, 22, 22…
$ Ward                       <int> 33, 43, 42, 34, 25, 38, 39, 34, 13, 42, 21,…
$ Community.Area             <int> 14, 7, 8, 53, 31, 15, 14, 49, 65, 8, 71, 73…
$ FBI.Code                   <chr> "05", "08B", "06", "04B", "14", "18", "14",…
$ X.Coordinate               <int> 1152214, 1175293, 1177508, 1178329, 1173432…
$ Y.Coordinate               <int> 1930694, 1916610, 1905401, 1828012, 1891037…
$ Year                       <int> 2017, 2017, 2017, 2017, 2017, 2017, 2017, 2…
$ Updated.On                 <chr> "05/04/2018 03:51:04 PM", "05/04/2018 03:51…
$ Latitude                   <dbl> 41.96569, 41.92656, 41.89575, 41.68337, 41.…
$ Longitude                  <dbl> -87.71573, -87.63129, -87.62350, -87.62283,…
$ Location                   <chr> "(41.965693651, -87.715726125)", "(41.92655…
$ Historical.Wards.2003.2015 <int> 2, 51, 22, 30, 8, 25, 28, 45, 23, 22, 18, 1…
$ Zip.Codes                  <int> 21849, 4449, 21182, 21861, 21194, 22618, 21…
$ Community.Areas            <int> 14, 68, 37, 50, 33, 15, 14, 45, 63, 37, 70,…
$ Census.Tracts              <int> 24, 101, 158, 255, 126, 231, 120, 524, 317,…
$ Wards                      <int> 20, 34, 11, 43, 26, 19, 12, 22, 15, 36, 13,…
$ Boundaries...ZIP.Codes     <int> 20, 16, 6, 19, 40, 21, 20, 19, 58, 55, 59, …
$ Police.Districts           <int> 1, 5, 14, 10, 15, 12, 1, 10, 13, 14, 9, 9, …
$ Police.Beats               <int> 9, 178, 71, 219, 158, 26, 48, 260, 209, 73,…
Code
 #There are 268221 observations and 30 variables.

 #X.Coordinate
 #Y.Coordinate
 #Longitude
 #Latitude
 #Location

crimes %>% filter(Primary.Type == "KIDNAPPING") %>% leaflet() %>% addTiles() %>% addMarkers()
Assuming "Longitude" and "Latitude" are longitude and latitude, respectively
Code
crimes %>% filter(Primary.Type == "KIDNAPPING")
          ID Case.Number                   Date
1   11191817    JA568856 12/31/2017 10:00:00 AM
2   11187306    JA562217 12/24/2017 08:30:00 PM
3   11185493    JA559802 12/22/2017 06:00:00 PM
4   11186099    JA560677 12/22/2017 05:30:00 PM
5   11179753    JA552013 12/16/2017 07:50:00 PM
6   11179252    JA551320 12/14/2017 11:00:00 PM
7   11177769    JA549299 12/14/2017 04:20:00 PM
8   11176273    JA547192 12/13/2017 07:15:00 AM
9   11175971    JA546617 12/12/2017 03:15:00 PM
10  11175439    JA546070 12/11/2017 03:50:00 PM
11  11177029    JA548121 12/10/2017 05:00:00 PM
12  11169391    JA538057 12/05/2017 04:00:00 PM
13  11168141    JA536324 12/04/2017 02:15:00 PM
14  11171967    JA541214 12/04/2017 08:20:00 AM
15  11181234    JA553899 12/03/2017 12:00:00 AM
16  11166306    JA533953 12/02/2017 04:00:00 PM
17  11165100    JA532201 11/29/2017 06:00:00 PM
18  11164950    JA532129 11/29/2017 05:00:00 PM
19  11161305    JA527345 11/27/2017 04:49:00 PM
20  11160838    JA526847 11/27/2017 06:50:00 AM
21  11159817    JA525745 11/26/2017 12:00:00 PM
22  11154311    JA517956 11/19/2017 12:00:00 PM
23  11152483    JA515997 11/17/2017 04:48:00 PM
24  11152454    JA515935 11/17/2017 04:30:00 PM
25  11151819    JA515006 11/17/2017 07:40:00 AM
26  11151256    JA514372 11/16/2017 04:20:00 PM
27  11151331    JA514406 11/16/2017 03:00:00 PM
28  11151952    JA515061 11/16/2017 02:50:00 PM
29  11151074    JA514011 11/16/2017 08:30:00 AM
30  11147094    JA508981 11/12/2017 12:05:00 PM
31  11144848    JA505561 11/08/2017 03:30:00 PM
32  11143396    JA503577 11/07/2017 03:25:00 PM
33  11134446    JA492179 10/30/2017 03:15:00 PM
34  11134333    JA491707 10/30/2017 11:15:00 AM
35  11132545    JA489625 10/28/2017 02:00:00 PM
36  11124957    JA479660 10/21/2017 02:49:00 AM
37  11122309    JA476256 10/17/2017 07:39:00 PM
38  11121309    JA474768 10/17/2017 02:30:00 PM
39  11118991    JA471904 10/15/2017 10:00:00 AM
40  11116436    JA468476 10/12/2017 07:00:00 AM
41  11112391    JA463123 10/08/2017 10:00:00 AM
42  11105590    JA454487 10/01/2017 07:59:00 PM
43  11105604    JA454497 10/01/2017 07:40:00 PM
44  11102318    JA450208 09/28/2017 01:20:00 PM
45  11098373    JA445158 09/24/2017 06:00:00 PM
46  11097474    JA444069 09/23/2017 09:50:00 PM
47  11097018    JA443261 09/23/2017 10:00:00 AM
48  11097154    JA443672 09/22/2017 02:00:00 AM
49  11094290    JA439700 09/20/2017 07:07:00 AM
50  11093383    JA438790 09/20/2017 06:50:00 AM
51  11093578    JA438962 09/17/2017 09:00:00 AM
52  11088245    JA432141 09/15/2017 07:20:00 AM
53  11086760    JA430052 09/13/2017 03:00:00 PM
54  11085744    JA428880 09/12/2017 07:00:00 PM
55  11083604    JA426530 09/10/2017 11:00:00 PM
56  11083215    JA425760 09/10/2017 09:55:00 AM
57  11081984    JA424106 09/08/2017 07:00:00 PM
58  11082022    JA423202 09/08/2017 09:24:00 AM
59  11081334    JA423419 09/08/2017 08:10:00 AM
60  11080583    JA422763 09/07/2017 04:30:00 PM
61  11080404    JA422538 09/07/2017 04:25:00 PM
62  11076504    JA417552 09/03/2017 05:41:00 PM
63  11080038    JA421858 09/03/2017 05:00:00 PM
64  11076159    JA417122 09/03/2017 11:30:00 AM
65  11078954    JA420798 09/02/2017 06:53:00 PM
66  11072177    JA411969 08/29/2017 04:45:00 PM
67  11078464    JA420057 08/29/2017 09:30:00 AM
68  11069196    JA408253 08/25/2017 06:00:00 PM
69  11067505    JA406091 08/25/2017 05:50:00 PM
70  11066375    JA404857 08/24/2017 07:05:00 PM
71  11064800    JA403192 08/23/2017 03:28:00 PM
72  11063245    JA401153 08/20/2017 10:30:00 PM
73  11060364    JA396755 08/18/2017 04:30:00 PM
74  11053424    JA390032 08/13/2017 07:00:00 PM
75  11052640    JA388999 08/13/2017 02:00:00 AM
76  11055934    JA388950 08/13/2017 12:20:00 AM
77  11048645    JA384059 08/09/2017 01:25:00 PM
78  11054078    JA390210 08/05/2017 12:30:00 PM
79  11039837    JA371700 07/31/2017 06:30:00 PM
80  11039638    JA374006 07/30/2017 06:00:00 PM
81  11036887    JA369673 07/29/2017 09:30:00 PM
82  11032907    JA365692 07/27/2017 12:30:00 PM
83  11054016    JA390548 07/26/2017 12:00:00 AM
84  11033255    JA366174 07/25/2017 02:00:00 AM
85  11036336    JA369958 07/24/2017 07:00:00 PM
86  11030475    JA362734 07/24/2017 12:00:00 PM
87  11023860    JA354300 07/19/2017 09:40:00 AM
88  11022837    JA353813 07/18/2017 07:45:00 PM
89  11022123    JA352906 07/18/2017 10:31:00 AM
90  11022025    JA352895 07/18/2017 09:00:00 AM
91  11019933    JA350647 07/16/2017 06:00:00 PM
92  11021251    JA352158 07/16/2017 04:45:00 PM
93  11018968    JA349422 07/15/2017 03:00:00 PM
94  11018453    JA348650 07/15/2017 04:30:00 AM
95  11015598    JA345513 07/12/2017 07:10:00 PM
96  11010361    JA339621 07/07/2017 02:00:00 AM
97  11015845    JA337743 07/06/2017 09:00:00 PM
98  11005848    JA334408 07/04/2017 07:30:00 PM
99  11006095    JA334314 07/04/2017 05:00:00 PM
100 11002622    JA330418 07/01/2017 03:31:00 PM
101 11004659    JA333150 07/01/2017 06:00:00 AM
102 10999458    JA326760 06/28/2017 05:55:00 PM
103 11006892    JA335473 06/26/2017 06:00:00 PM
104 10994443    JA321756 06/25/2017 09:22:00 AM
105 11039715    JA373808 06/24/2017 02:30:00 AM
106 10993052    JA319877 06/23/2017 02:00:00 PM
107 10990703    JA317463 06/22/2017 02:25:00 AM
108 10984380    JA309928 06/16/2017 04:40:00 PM
109 10984334    JA309785 06/16/2017 03:20:00 PM
110 10986081    JA310713 06/16/2017 08:00:00 AM
111 10981943    JA307276 06/12/2017 03:00:00 PM
112 10976534    JA301389 06/10/2017 08:30:00 PM
113 10974245    JA298380 06/08/2017 06:00:00 PM
114 10972829    JA296617 06/07/2017 12:56:00 PM
115 10971735    JA295698 06/06/2017 08:05:00 PM
116 10970236    JA294119 06/05/2017 05:30:00 PM
117 10965557    JA288172 06/01/2017 02:45:00 PM
118 10963194    JA285907 05/30/2017 07:00:00 PM
119 10962696    JA285363 05/30/2017 09:28:00 AM
120 10962831    JA285503 05/29/2017 12:30:00 PM
121 10958582    JA279807 05/26/2017 08:00:00 AM
122 11043366    JA376940 05/23/2017 09:00:00 PM
123 10954442    JA274691 05/22/2017 03:10:00 PM
124 10953817    JA274124 05/22/2017 07:35:00 AM
125 10952948    JA272310 05/20/2017 06:50:00 PM
126 10950619    JA269911 05/18/2017 09:02:00 PM
127 10950276    JA269838 05/18/2017 08:54:00 PM
128 10947877    JA267176 05/17/2017 08:30:00 AM
129 10944086    JA262778 05/13/2017 09:50:00 PM
130 10960581    JA282544 05/13/2017 03:23:00 AM
131 10939288    JA256694 05/05/2017 03:00:00 PM
132 10935366    JA251404 05/05/2017 09:00:00 AM
133 10934913    JA251186 05/05/2017 12:15:00 AM
134 10934306    JA250323 05/04/2017 07:30:00 AM
135 10933147    JA249142 05/03/2017 09:45:00 AM
136 10931080    JA246101 05/01/2017 09:20:00 AM
137 10926047    JA240291 04/26/2017 09:00:00 AM
138 10922116    JA236144 04/23/2017 03:35:00 PM
139 10920608    JA233998 04/21/2017 06:30:00 PM
140 10920094    JA233201 04/21/2017 08:45:00 AM
141 10919917    JA233208 04/21/2017 07:25:00 AM
142 10919107    JA232256 04/20/2017 01:30:00 PM
143 10917872    JA231168 04/19/2017 04:00:00 PM
144 10913683    JA226994 04/16/2017 10:00:00 AM
145 10913684    JA227023 04/16/2017 10:00:00 AM
146 10919659    JA225602 04/14/2017 05:00:00 PM
147 10909159    JA220852 04/11/2017 01:15:00 PM
148 10906230    JA218796 04/09/2017 05:00:00 PM
149 10903192    JA214893 04/06/2017 02:00:00 PM
150 10901179    JA212918 04/04/2017 09:45:00 PM
151 10898689    JA210389 04/02/2017 06:30:00 PM
152 10896804    JA207746 03/31/2017 03:15:00 PM
153 10896143    JA207016 03/31/2017 07:50:00 AM
154 10895416    JA205803 03/30/2017 09:15:00 AM
155 10896201    JA203355 03/28/2017 07:40:00 AM
156 10893087    JA203667 03/28/2017 07:30:00 AM
157 10889972    JA200503 03/25/2017 12:00:00 PM
158 10889371    JA199613 03/25/2017 12:01:00 AM
159 10916257    JA229783 03/23/2017 02:00:00 PM
160 10887345    JA197097 03/23/2017 07:50:00 AM
161 10893212    JA203741 03/22/2017 03:00:00 PM
162 10888307    JA197343 03/22/2017 01:48:00 PM
163 10892151    JA202891 03/21/2017 03:30:00 PM
164 10888187    JA198146 03/19/2017 03:30:00 PM
165 10882526    JA192175 03/18/2017 06:00:00 PM
166 10882011    JA191518 03/18/2017 12:39:00 PM
167 10876731    JA184575 03/12/2017 02:15:00 PM
168 10874976    JA183196 03/09/2017 10:00:00 AM
169 10871680    JA179379 03/08/2017 10:00:00 AM
170 10865414    JA171752 02/28/2017 04:00:00 PM
171 10863952    JA170026 02/28/2017 12:30:00 PM
172 10861536    JA167676 02/26/2017 11:00:00 AM
173 10855626    JA160868 02/20/2017 02:10:00 PM
174 10852742    JA157076 02/17/2017 11:20:00 AM
175 10853867    JA156319 02/16/2017 04:00:00 PM
176 10850741    JA154560 02/15/2017 08:45:00 AM
177 10849060    JA153226 02/14/2017 10:00:00 AM
178 10847486    JA151327 02/11/2017 04:30:00 PM
179 10844172    JA147158 02/09/2017 08:17:00 AM
180 10842361    JA145410 02/07/2017 02:39:00 PM
181 10840856    JA144134 02/06/2017 06:00:00 PM
182 10844998    JA147363 02/02/2017 12:00:00 PM
183 10834515    JA136380 01/30/2017 07:00:00 PM
184 10832634    JA134344 01/29/2017 03:00:00 PM
185 10834347    JA135537 01/25/2017 03:00:00 PM
186 10809318    JA108652 01/06/2017 08:00:00 PM
187 10813045    JA111784 01/06/2017 07:00:00 PM
188 10809202    JA108392 01/06/2017 01:00:00 PM
189 10808481    JA107454 01/02/2017 02:40:00 PM
190 10801512    JA100509 01/01/2017 10:00:00 AM
                                  Block IUCR Primary.Type
1                 092XX S WENTWORTH AVE 4255   KIDNAPPING
2                    005XX W EUGENIE ST 4255   KIDNAPPING
3                    050XX S KEELER AVE 4255   KIDNAPPING
4                    001XX E JACKSON DR 4255   KIDNAPPING
5                      095XX S YALE AVE 4220   KIDNAPPING
6                    076XX S HALSTED ST 4230   KIDNAPPING
7                       016XX E 71ST ST 1792   KIDNAPPING
8                   012XX S ASHLAND AVE 1792   KIDNAPPING
9                    119XX S NORMAL AVE 1792   KIDNAPPING
10                   003XX N WHIPPLE ST 1792   KIDNAPPING
11                 063XX S WOODLAWN AVE 4210   KIDNAPPING
12                     036XX W 116TH PL 4255   KIDNAPPING
13               052XX N RUTHERFORD AVE 1792   KIDNAPPING
14                    073XX S MORGAN ST 1792   KIDNAPPING
15                  057XX S EMERALD AVE 4230   KIDNAPPING
16                   071XX N HARLEM AVE 1792   KIDNAPPING
17                 052XX W FERDINAND ST 4230   KIDNAPPING
18                 009XX N LAWNDALE AVE 4255   KIDNAPPING
19               052XX S WINCHESTER AVE 1792   KIDNAPPING
20                 010XX W MONTROSE AVE 1792   KIDNAPPING
21                     101XX S AVENUE L 4255   KIDNAPPING
22            034XX S COTTAGE GROVE AVE 4255   KIDNAPPING
23                      037XX W 83RD ST 4230   KIDNAPPING
24                  053XX S PRAIRIE AVE 1792   KIDNAPPING
25                   063XX S HALSTED ST 1792   KIDNAPPING
26                006XX W GARFIELD BLVD 1792   KIDNAPPING
27                      030XX W 39TH PL 1792   KIDNAPPING
28                    030XX N LAMON AVE 4230   KIDNAPPING
29                     008XX W 103RD ST 4230   KIDNAPPING
30                 057XX S MICHIGAN AVE 4230   KIDNAPPING
31                021XX W GRANVILLE AVE 1792   KIDNAPPING
32                     007XX E 103RD ST 1792   KIDNAPPING
33                 047XX W MARQUETTE RD 1792   KIDNAPPING
34                 052XX W AUGUSTA BLVD 1792   KIDNAPPING
35                  069XX S MERRILL AVE 1792   KIDNAPPING
36                      002XX E ERIE ST 4230   KIDNAPPING
37                   016XX S KEELER AVE 1792   KIDNAPPING
38                  056XX S ROCKWELL ST 1792   KIDNAPPING
39                      004XX W 95TH ST 4255   KIDNAPPING
40                     055XX S STATE ST 1792   KIDNAPPING
41                      017XX E 79TH ST 4255   KIDNAPPING
42                      010XX W 18TH ST 4210   KIDNAPPING
43                      002XX W 19TH ST 4230   KIDNAPPING
44           056XX W EISENHOWER EXPY IB 4230   KIDNAPPING
45                066XX S WENTWORTH AVE 4255   KIDNAPPING
46                 026XX W PETERSON AVE 4230   KIDNAPPING
47                     113XX S AVENUE J 4255   KIDNAPPING
48               048XX W WELLINGTON AVE 4240   KIDNAPPING
49                  065XX S MINERVA AVE 1792   KIDNAPPING
50                    037XX W ARGYLE ST 1792   KIDNAPPING
51                      034XX W 38TH PL 4230   KIDNAPPING
52                   067XX S PULASKI RD 1792   KIDNAPPING
53                 006XX S MICHIGAN AVE 4210   KIDNAPPING
54                     007XX E 111TH ST 4255   KIDNAPPING
55                    056XX W GRAND AVE 4210   KIDNAPPING
56                 043XX W FORD CITY DR 4230   KIDNAPPING
57                  013XX N WESTERN AVE 4255   KIDNAPPING
58                    038XX S GILES AVE 4230   KIDNAPPING
59                   055XX S HALSTED ST 1792   KIDNAPPING
60                   048XX W ADDISON ST 1792   KIDNAPPING
61                    070XX W HAYES AVE 1792   KIDNAPPING
62                   052XX N HARLEM AVE 4255   KIDNAPPING
63                  043XX S ROCKWELL ST 4255   KIDNAPPING
64                 063XX N ARTESIAN AVE 4230   KIDNAPPING
65  064XX S DR MARTIN LUTHER KING JR DR 4210   KIDNAPPING
66                 005XX N LAWNDALE AVE 1792   KIDNAPPING
67                0000X W WASHINGTON ST 4255   KIDNAPPING
68               086XX W SUMMERDALE AVE 1792   KIDNAPPING
69                   096XX S HALSTED ST 4255   KIDNAPPING
70            105XX S COTTAGE GROVE AVE 1792   KIDNAPPING
71                 043XX W VAN BUREN ST 4230   KIDNAPPING
72                  069XX S CALUMET AVE 4230   KIDNAPPING
73                      107XX S TROY ST 4255   KIDNAPPING
74                   073XX N PAULINA ST 4230   KIDNAPPING
75                 053XX S LOCKWOOD AVE 4230   KIDNAPPING
76                  056XX S ASHLAND AVE 4210   KIDNAPPING
77                  051XX N WESTERN AVE 4230   KIDNAPPING
78                    077XX S MORGAN ST 4255   KIDNAPPING
79                     100XX W OHARE ST 1792   KIDNAPPING
80                      032XX W 51ST ST 4255   KIDNAPPING
81                   0000X N WABASH AVE 4210   KIDNAPPING
82                 028XX S RIDGEWAY AVE 1792   KIDNAPPING
83                   032XX W MADISON ST 4255   KIDNAPPING
84                      026XX W 12TH PL 4230   KIDNAPPING
85                     014XX W 119TH ST 4255   KIDNAPPING
86                      039XX W POLK ST 4230   KIDNAPPING
87                      021XX W 59TH ST 1792   KIDNAPPING
88                      006XX W 24TH PL 1792   KIDNAPPING
89                   006XX N CICERO AVE 4255   KIDNAPPING
90                051XX N MC VICKER AVE 4255   KIDNAPPING
91                026XX N MC VICKER AVE 4255   KIDNAPPING
92                   018XX N ORCHARD ST 1792   KIDNAPPING
93                 049XX W CORNELIA AVE 4255   KIDNAPPING
94             081XX S STONY ISLAND AVE 4210   KIDNAPPING
95                013XX W FULLERTON AVE 1792   KIDNAPPING
96                  048XX W BELMONT AVE 4210   KIDNAPPING
97                 083XX S MARYLAND AVE 4230   KIDNAPPING
98                016XX N LAKE SHORE DR 4230   KIDNAPPING
99              101XX S ST LAWRENCE AVE 4230   KIDNAPPING
100                  076XX S COLFAX AVE 4255   KIDNAPPING
101                   048XX W ARGYLE ST 4210   KIDNAPPING
102                     042XX W 16TH ST 4255   KIDNAPPING
103                    002XX W 106TH PL 4255   KIDNAPPING
104                  075XX S COLFAX AVE 4255   KIDNAPPING
105                 040XX S RICHMOND ST 4210   KIDNAPPING
106                    046XX W ADAMS ST 4220   KIDNAPPING
107                     006XX W 31ST ST 4210   KIDNAPPING
108                011XX S HAMILTON AVE 4230   KIDNAPPING
109                   066XX N DAMEN AVE 1792   KIDNAPPING
110                 080XX S LANGLEY AVE 4255   KIDNAPPING
111                     017XX W 73RD ST 1792   KIDNAPPING
112                    028XX W 111TH ST 1792   KIDNAPPING
113              056XX N CHRISTIANA AVE 1792   KIDNAPPING
114                   020XX N DAMEN AVE 1792   KIDNAPPING
115           082XX S COTTAGE GROVE AVE 1792   KIDNAPPING
116                  042XX N CICERO AVE 1792   KIDNAPPING
117              083XX S COMMERCIAL AVE 4210   KIDNAPPING
118                   012XX S HOMAN AVE 1792   KIDNAPPING
119                005XX N LAWNDALE AVE 4230   KIDNAPPING
120                    003XX W 109TH PL 4230   KIDNAPPING
121                 041XX N RICHMOND ST 1792   KIDNAPPING
122                  077XX S YATES BLVD 4230   KIDNAPPING
123                     025XX W 59TH ST 1792   KIDNAPPING
124                040XX W JACKSON BLVD 1792   KIDNAPPING
125                068XX W HIGHLAND AVE 4230   KIDNAPPING
126                   048XX S ELLIS AVE 1792   KIDNAPPING
127               018XX W GARFIELD BLVD 4220   KIDNAPPING
128                076XX S EXCHANGE AVE 1792   KIDNAPPING
129                    007XX N LONG AVE 1792   KIDNAPPING
130                    096XX S GREEN ST 4230   KIDNAPPING
131                 114XX S STEWART AVE 4255   KIDNAPPING
132                 009XX N LARRABEE ST 4210   KIDNAPPING
133                  099XX S PAXTON AVE 4210   KIDNAPPING
134                  004XX N CICERO AVE 1792   KIDNAPPING
135                 102XX S INDIANA AVE 1792   KIDNAPPING
136              063XX S UNIVERSITY AVE 1792   KIDNAPPING
137                  132XX S BURLEY AVE 4220   KIDNAPPING
138                053XX W JACKSON BLVD 1792   KIDNAPPING
139                     010XX W 75TH ST 1792   KIDNAPPING
140                   037XX N ODELL AVE 4230   KIDNAPPING
141                   051XX N DAMEN AVE 4210   KIDNAPPING
142             048XX W SHAKESPEARE AVE 1792   KIDNAPPING
143                092XX S ELIZABETH ST 1792   KIDNAPPING
144                 100XX S CRANDON AVE 4255   KIDNAPPING
145               130XX S BALTIMORE AVE 4255   KIDNAPPING
146                    007XX W SCOTT ST 4230   KIDNAPPING
147                088XX S JEFFERY BLVD 4255   KIDNAPPING
148                089XX S MUSKEGON AVE 1792   KIDNAPPING
149                   031XX N MASON AVE 4255   KIDNAPPING
150                  055XX W GLADYS AVE 4230   KIDNAPPING
151                  060XX S HARPER AVE 4255   KIDNAPPING
152                     011XX E 46TH ST 4255   KIDNAPPING
153                   051XX W PALMER ST 1792   KIDNAPPING
154                     040XX W 68TH ST 4230   KIDNAPPING
155                 124XX S STEWART AVE 1792   KIDNAPPING
156              009XX W WRIGHTWOOD AVE 1792   KIDNAPPING
157                      078XX S MAY ST 4240   KIDNAPPING
158                  091XX S HALSTED ST 4210   KIDNAPPING
159                 060XX S CALUMET AVE 1792   KIDNAPPING
160                 075XX N ASHLAND AVE 1792   KIDNAPPING
161                  034XX N LOWELL AVE 1792   KIDNAPPING
162                  085XX S BURLEY AVE 4230   KIDNAPPING
163                 047XX S KOSTNER AVE 1792   KIDNAPPING
164                     007XX W 26TH ST 1792   KIDNAPPING
165                     043XX W 76TH ST 4220   KIDNAPPING
166                  060XX S TALMAN AVE 1792   KIDNAPPING
167                  031XX W MEDILL AVE 4230   KIDNAPPING
168                107XX S TORRENCE AVE 4255   KIDNAPPING
169                   079XX S ESSEX AVE 4255   KIDNAPPING
170               110XX S VINCENNES AVE 4255   KIDNAPPING
171               002XX W EVERGREEN AVE 1792   KIDNAPPING
172                  100XX S OAKLEY AVE 4255   KIDNAPPING
173                0000X N KILBOURN AVE 1792   KIDNAPPING
174                  052XX S SAWYER AVE 1792   KIDNAPPING
175                  067XX W HURLBUT ST 1792   KIDNAPPING
176                109XX S EBERHART AVE 1792   KIDNAPPING
177                    035XX W 116TH PL 4255   KIDNAPPING
178                  010XX N KARLOV AVE 4255   KIDNAPPING
179                114XX S MICHIGAN AVE 1792   KIDNAPPING
180                     014XX W 77TH ST 4220   KIDNAPPING
181                  042XX W MADISON ST 4210   KIDNAPPING
182                 069XX S STEWART AVE 4210   KIDNAPPING
183               015XX W FULLERTON AVE 1792   KIDNAPPING
184             048XX S SPRINGFIELD AVE 4255   KIDNAPPING
185                042XX S BERKELEY AVE 1792   KIDNAPPING
186                     003XX W 64TH ST 4255   KIDNAPPING
187                     013XX W 76TH ST 4220   KIDNAPPING
188                 035XX W FLOURNOY ST 4210   KIDNAPPING
189                 046XX W MAYPOLE AVE 4240   KIDNAPPING
190               130XX S BALTIMORE AVE 4255   KIDNAPPING
                      Description                       Location.Description
1   UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
2   UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
3   UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
4   UNLAWFUL INTERFERE/VISITATION                                     STREET
5                      AGGRAVATED                                  RESIDENCE
6              UNLAWFUL RESTRAINT                                  APARTMENT
7        CHILD ABDUCTION/STRANGER                                   SIDEWALK
8        CHILD ABDUCTION/STRANGER                                   SIDEWALK
9        CHILD ABDUCTION/STRANGER                                     STREET
10       CHILD ABDUCTION/STRANGER                                     STREET
11                     KIDNAPPING                                      OTHER
12  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
13       CHILD ABDUCTION/STRANGER                    SCHOOL, PUBLIC, GROUNDS
14       CHILD ABDUCTION/STRANGER                                   SIDEWALK
15             UNLAWFUL RESTRAINT                                  RESIDENCE
16       CHILD ABDUCTION/STRANGER                                   SIDEWALK
17             UNLAWFUL RESTRAINT                                  RESIDENCE
18  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
19       CHILD ABDUCTION/STRANGER                                   SIDEWALK
20       CHILD ABDUCTION/STRANGER                                   SIDEWALK
21  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
22  UNLAWFUL INTERFERE/VISITATION                    RESIDENCE PORCH/HALLWAY
23             UNLAWFUL RESTRAINT                                  RESIDENCE
24       CHILD ABDUCTION/STRANGER                                     STREET
25       CHILD ABDUCTION/STRANGER                                     STREET
26       CHILD ABDUCTION/STRANGER                               CTA BUS STOP
27       CHILD ABDUCTION/STRANGER                    SCHOOL, PUBLIC, GROUNDS
28             UNLAWFUL RESTRAINT                    SCHOOL, PUBLIC, GROUNDS
29             UNLAWFUL RESTRAINT               NURSING HOME/RETIREMENT HOME
30             UNLAWFUL RESTRAINT                                     STREET
31       CHILD ABDUCTION/STRANGER                                   SIDEWALK
32       CHILD ABDUCTION/STRANGER                    SCHOOL, PUBLIC, GROUNDS
33       CHILD ABDUCTION/STRANGER                                     STREET
34       CHILD ABDUCTION/STRANGER                    SCHOOL, PUBLIC, GROUNDS
35       CHILD ABDUCTION/STRANGER                                     STREET
36             UNLAWFUL RESTRAINT                                    TAXICAB
37       CHILD ABDUCTION/STRANGER                                   SIDEWALK
38       CHILD ABDUCTION/STRANGER                    SCHOOL, PUBLIC, GROUNDS
39  UNLAWFUL INTERFERE/VISITATION                                     STREET
40       CHILD ABDUCTION/STRANGER                                     STREET
41  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
42                     KIDNAPPING                                   SIDEWALK
43             UNLAWFUL RESTRAINT                                   SIDEWALK
44             UNLAWFUL RESTRAINT                                  CTA TRAIN
45  UNLAWFUL INTERFERE/VISITATION                                GAS STATION
46             UNLAWFUL RESTRAINT                     VEHICLE NON-COMMERCIAL
47  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
48             FORCIBLE DETENTION                                     STREET
49       CHILD ABDUCTION/STRANGER                                     STREET
50       CHILD ABDUCTION/STRANGER                                     STREET
51             UNLAWFUL RESTRAINT                                  RESIDENCE
52       CHILD ABDUCTION/STRANGER                                     STREET
53                     KIDNAPPING                                   SIDEWALK
54  UNLAWFUL INTERFERE/VISITATION            POLICE FACILITY/VEH PARKING LOT
55                     KIDNAPPING                                  RESIDENCE
56             UNLAWFUL RESTRAINT              RESIDENTIAL YARD (FRONT/BACK)
57  UNLAWFUL INTERFERE/VISITATION                                  APARTMENT
58             UNLAWFUL RESTRAINT                                  RESIDENCE
59       CHILD ABDUCTION/STRANGER                                     STREET
60       CHILD ABDUCTION/STRANGER                               CTA BUS STOP
61       CHILD ABDUCTION/STRANGER                                   SIDEWALK
62  UNLAWFUL INTERFERE/VISITATION             PARKING LOT/GARAGE(NON.RESID.)
63  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
64             UNLAWFUL RESTRAINT                                  APARTMENT
65                     KIDNAPPING                                     STREET
66       CHILD ABDUCTION/STRANGER                                     STREET
67  UNLAWFUL INTERFERE/VISITATION               GOVERNMENT BUILDING/PROPERTY
68       CHILD ABDUCTION/STRANGER                                   SIDEWALK
69  UNLAWFUL INTERFERE/VISITATION                            DAY CARE CENTER
70       CHILD ABDUCTION/STRANGER                                     STREET
71             UNLAWFUL RESTRAINT                                  RESIDENCE
72             UNLAWFUL RESTRAINT                                      OTHER
73  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
74             UNLAWFUL RESTRAINT                                  APARTMENT
75             UNLAWFUL RESTRAINT                                  RESIDENCE
76                     KIDNAPPING                                     STREET
77             UNLAWFUL RESTRAINT                         SMALL RETAIL STORE
78  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
79       CHILD ABDUCTION/STRANGER AIRPORT TERMINAL LOWER LEVEL - SECURE AREA
80  UNLAWFUL INTERFERE/VISITATION                                      OTHER
81                     KIDNAPPING                     VEHICLE NON-COMMERCIAL
82       CHILD ABDUCTION/STRANGER                                     STREET
83  UNLAWFUL INTERFERE/VISITATION                                      OTHER
84             UNLAWFUL RESTRAINT                                      OTHER
85  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
86             UNLAWFUL RESTRAINT                                  RESIDENCE
87       CHILD ABDUCTION/STRANGER                                     STREET
88       CHILD ABDUCTION/STRANGER                                     STREET
89  UNLAWFUL INTERFERE/VISITATION                                  APARTMENT
90  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
91  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
92       CHILD ABDUCTION/STRANGER                                   SIDEWALK
93  UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
94                     KIDNAPPING                                HOTEL/MOTEL
95       CHILD ABDUCTION/STRANGER                                     STREET
96                     KIDNAPPING                                      ALLEY
97             UNLAWFUL RESTRAINT                                  APARTMENT
98             UNLAWFUL RESTRAINT                         VEHICLE-COMMERCIAL
99             UNLAWFUL RESTRAINT                                     STREET
100 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
101                    KIDNAPPING                           RESIDENCE-GARAGE
102 UNLAWFUL INTERFERE/VISITATION                            DAY CARE CENTER
103 UNLAWFUL INTERFERE/VISITATION                            DAY CARE CENTER
104 UNLAWFUL INTERFERE/VISITATION                                  APARTMENT
105                    KIDNAPPING                                  RESIDENCE
106                    AGGRAVATED                                  RESIDENCE
107                    KIDNAPPING                                   SIDEWALK
108            UNLAWFUL RESTRAINT                     VEHICLE NON-COMMERCIAL
109      CHILD ABDUCTION/STRANGER                                     STREET
110 UNLAWFUL INTERFERE/VISITATION                                  APARTMENT
111      CHILD ABDUCTION/STRANGER                              PARK PROPERTY
112      CHILD ABDUCTION/STRANGER                                     STREET
113      CHILD ABDUCTION/STRANGER                                     STREET
114      CHILD ABDUCTION/STRANGER                                     STREET
115      CHILD ABDUCTION/STRANGER                                     STREET
116      CHILD ABDUCTION/STRANGER                                   SIDEWALK
117                    KIDNAPPING                    SCHOOL, PUBLIC, GROUNDS
118      CHILD ABDUCTION/STRANGER                                     STREET
119            UNLAWFUL RESTRAINT                                     STREET
120            UNLAWFUL RESTRAINT                                     STREET
121      CHILD ABDUCTION/STRANGER                                   SIDEWALK
122            UNLAWFUL RESTRAINT                                  APARTMENT
123      CHILD ABDUCTION/STRANGER                                   SIDEWALK
124      CHILD ABDUCTION/STRANGER                                   SIDEWALK
125            UNLAWFUL RESTRAINT                                     STREET
126      CHILD ABDUCTION/STRANGER                                   SIDEWALK
127                    AGGRAVATED                                  RESIDENCE
128      CHILD ABDUCTION/STRANGER                                   SIDEWALK
129      CHILD ABDUCTION/STRANGER                                   SIDEWALK
130            UNLAWFUL RESTRAINT                                  RESIDENCE
131 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
132                    KIDNAPPING                                     STREET
133                    KIDNAPPING                                     STREET
134      CHILD ABDUCTION/STRANGER                                   SIDEWALK
135      CHILD ABDUCTION/STRANGER                                   SIDEWALK
136      CHILD ABDUCTION/STRANGER                                   SIDEWALK
137                    AGGRAVATED                     VEHICLE NON-COMMERCIAL
138      CHILD ABDUCTION/STRANGER                                   SIDEWALK
139      CHILD ABDUCTION/STRANGER                                   SIDEWALK
140            UNLAWFUL RESTRAINT                                  RESIDENCE
141                    KIDNAPPING                                   SIDEWALK
142      CHILD ABDUCTION/STRANGER                    SCHOOL, PUBLIC, GROUNDS
143      CHILD ABDUCTION/STRANGER                                     STREET
144 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
145 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
146            UNLAWFUL RESTRAINT                                  APARTMENT
147 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
148      CHILD ABDUCTION/STRANGER                              PARK PROPERTY
149 UNLAWFUL INTERFERE/VISITATION                  SCHOOL, PRIVATE, BUILDING
150            UNLAWFUL RESTRAINT                                     STREET
151 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
152 UNLAWFUL INTERFERE/VISITATION                   SCHOOL, PUBLIC, BUILDING
153      CHILD ABDUCTION/STRANGER                                     STREET
154            UNLAWFUL RESTRAINT                                     STREET
155      CHILD ABDUCTION/STRANGER                                      ALLEY
156      CHILD ABDUCTION/STRANGER                                   SIDEWALK
157            FORCIBLE DETENTION                                  RESIDENCE
158                    KIDNAPPING                                     STREET
159      CHILD ABDUCTION/STRANGER                                  RESIDENCE
160      CHILD ABDUCTION/STRANGER                                     STREET
161      CHILD ABDUCTION/STRANGER                                   SIDEWALK
162            UNLAWFUL RESTRAINT                     VEHICLE NON-COMMERCIAL
163      CHILD ABDUCTION/STRANGER                                   SIDEWALK
164      CHILD ABDUCTION/STRANGER                                  APARTMENT
165                    AGGRAVATED                                  APARTMENT
166      CHILD ABDUCTION/STRANGER                                     STREET
167            UNLAWFUL RESTRAINT                     VEHICLE NON-COMMERCIAL
168 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
169 UNLAWFUL INTERFERE/VISITATION                                  APARTMENT
170 UNLAWFUL INTERFERE/VISITATION                            DAY CARE CENTER
171      CHILD ABDUCTION/STRANGER                    SCHOOL, PUBLIC, GROUNDS
172 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
173      CHILD ABDUCTION/STRANGER                                GAS STATION
174      CHILD ABDUCTION/STRANGER                    SCHOOL, PUBLIC, GROUNDS
175      CHILD ABDUCTION/STRANGER                                     STREET
176      CHILD ABDUCTION/STRANGER                                   SIDEWALK
177 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
178 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
179      CHILD ABDUCTION/STRANGER             PARKING LOT/GARAGE(NON.RESID.)
180                    AGGRAVATED                                  APARTMENT
181                    KIDNAPPING                                      ALLEY
182                    KIDNAPPING                   SCHOOL, PUBLIC, BUILDING
183      CHILD ABDUCTION/STRANGER             PARKING LOT/GARAGE(NON.RESID.)
184 UNLAWFUL INTERFERE/VISITATION                                   SIDEWALK
185      CHILD ABDUCTION/STRANGER                                     STREET
186 UNLAWFUL INTERFERE/VISITATION                  HOSPITAL BUILDING/GROUNDS
187                    AGGRAVATED                                  RESIDENCE
188                    KIDNAPPING                                  RESIDENCE
189            FORCIBLE DETENTION                                      OTHER
190 UNLAWFUL INTERFERE/VISITATION                                  RESIDENCE
    Arrest Domestic Beat District Ward Community.Area FBI.Code X.Coordinate
1    false     true  634        6   21             49       26      1176570
2    false     true 1813       18   43              7       26      1172414
3    false    false  815        8   23             57       26      1149214
4    false     true  114        1   42             32       26      1177602
5    false    false  511        5   21             49       26      1176294
6    false    false  621        6   17             71       26      1172288
7    false    false  324        3    8             43       20      1188593
8    false    false 1233       12    2             28       20      1165924
9    false    false  524        5   34             53       20      1175112
10   false    false 1222       12   27             27       20      1155946
11   false    false  314        3   20             42       26      1185302
12   false     true 2211       22   19             74       26      1154208
13   false    false 1613       16   41             10       20      1130594
14   false    false  733        7   17             68       20      1170912
15   false    false  711        7   20             68       26      1172284
16   false    false 1611       16   41              9       20      1127387
17   false    false 1523       15   28             25       26      1141315
18   false     true 1112       11   27             23       26      1151544
19    true    false  932        9   16             61       20      1164239
20   false    false 1915       19   46              3       20      1168522
21   false     true  432        4   10             52       26      1201820
22   false    false  211        2    4             35       26      1181143
23   false    false  834        8   18             70       26      1152813
24   false    false  231        2    3             40       20      1178945
25   false    false  723        7   20             68       20      1172055
26   false    false  935        9    3             61       20      1172961
27   false    false  921        9   14             58       20      1156780
28   false    false 2521       25   31             19       26      1143180
29   false    false 2232       22   34             73       26      1172339
30   false    false  232        2   20             40       26      1178135
31   false    false 2413       24   40              2       20      1161118
32   false    false  511        5    8             50       20      1183035
33   false    false  833        8   13             65       20      1146112
34   false    false 1524       15   37             25       20      1141375
35   false    false  331        3    5             43       20      1191740
36    true    false 1834       18   42              8       26      1178056
37   false    false 1012       10   24             29       20      1148654
38   false    false  824        8   16             63       20      1160001
39   false    false 2223       22   21             73       26      1175263
40   false    false  225        2    3             40       20      1177219
41   false    false  414        4    8             43       26      1189428
42   false    false 1235       12   25             31       26      1169628
43   false    false  914        9   25             34       26      1175135
44   false    false 1513       15   29             25       26      1139000
45   false     true  722        7    6             69       26      1176103
46   false    false 2011       20   40              2       26      1157828
47   false    false  433        4   10             52       26      1202553
48   false    false 2521       25   31             19       26      1143518
49   false    false  321        3   20             42       20      1185008
50    true    false 1712       17   39             14       20      1150399
51   false     true  911        9   12             58       26      1154137
52   false    false  833        8   13             65       20      1150857
53   false    false  123        1    2             32       26      1177375
54   false     true  531        5    9             50       26      1183356
55   false    false 2515       25   29             19       26      1138435
56   false    false  833        8   13             65       26      1148765
57   false    false 1423       14   26             24       26      1160167
58   false    false  212        2    3             35       26      1178891
59   false    false  712        7   20             68       20      1171913
60    true    false 1634       16   38             15       20      1143542
61   false    false 1611       16   41             10       20      1128215
62   false     true 1613       16   41             10       26      1127351
63   false     true  922        9   12             58       26      1159760
64    true    false 2413       24   50              2       26      1158835
65   false    false  312        3   20             69       26      1180029
66   false    false 1122       11   27             23       20      1151627
67   false    false  111        1   42             32       26      1175800
68   false    false 1614       16   41             76       20      1117722
69   false     true 2223       22   21             73       26      1172676
70   false    false  512        5    9             50       20      1182480
71   false    false 1131       11   24             26       26      1147578
72   false    false  322        3    6             69       26      1179684
73   false     true 2211       22   19             74       26      1157239
74   false     true 2423       24   49              1       26      1163855
75    true    false  814        8   23             56       26      1141930
76   false     true  713        7   16             67       26      1166638
77   false    false 2031       20   47              4       26      1159420
78   false     true  612        6   17             71       26      1170986
79   false    false 1651       16   41             76       20      1100658
80   false    false  822        8   14             63       26      1155696
81   false    false  112        1   42             32       26      1176805
82   false    false 1031       10   22             30       20      1151831
83   false    false 1123       11   28             27       26      1154889
84   false     true 1023       10   28             29       26      1158799
85   false    false  524        5   34             53       26      1168970
86   false     true 1132       11   24             26       26      1150230
87   false    false  715        7   15             67       20      1163192
88   false    false  914        9   11             60       20      1172347
89   false     true 1111       11   28             25       26      1144247
90   false     true 1622       16   45             11       26      1134871
91   false     true 2512       25   29             19       26      1135618
92   false    false 1813       18   43              7       20      1171324
93   false    false 1634       16   38             15       26      1142772
94   false    false  411        4    8             45       26      1188340
95   false    false 1811       18   32              7       20      1167026
96   false    false 1634       16   30             15       26      1143608
97   false     true  632        6    8             44       26      1183343
98    true    false 1814       18   43              7       26      1176670
99   false     true  511        5    9             49       26      1182025
100  false    false  421        4    7             43       26      1194849
101  false     true 1623       16   45             12       26      1143264
102  false     true 1012       10   24             29       26      1148464
103  false     true  512        5   34             49       26      1176439
104  false     true  421        4    7             43       26      1194834
105   true    false  921        9   14             58       26      1157344
106  false     true 1113       11   28             25       26      1145521
107  false    false  914        9   11             60       26      1172334
108  false    false 1225       12    2             28       26      1162124
109  false    false 2412       24   50              2       20      1161753
110  false     true  631        6    6             44       26      1182289
111  false    false  735        7   17             67       20      1165833
112  false    false 2212       22   19             75       20      1159343
113  false    false 1711       17   39             13       20      1153032
114  false    false 1432       14   32             22       20      1162691
115  false    false  631        6    6             44       20      1182992
116   true    false 1624       16   45             15       20      1143599
117  false     true  423        4   10             46       26      1197543
118  false    false 1021       10   24             29       20      1153890
119  false    false 1122       11   27             23       26      1151627
120   true     true  513        5   34             49       26      1176031
121  false    false 1724       17   33             16       20      1155974
122  false     true  421        4    7             43       26      1193541
123  false    false  824        8   16             66       20      1160580
124  false    false 1115       11   28             26       20      1149605
125  false    false 1611       16   41             10       26      1129867
126  false    false  222        2    4             39       26      1183731
127  false    false  715        7   15             67       26      1164853
128  false    false  421        4    7             43       20      1195776
129  false    false 1524       15   37             25       20      1140181
130  false    false 2223       22   21             73       26      1172348
131  false     true  522        5   34             49       26      1175671
132  false    false 1822       18   27              8       26      1172179
133  false    false  431        4    7             51       26      1192810
134  false     true 1532       15   28             25       20      1144284
135  false    false  511        5    9             49       20      1179387
136  false    false  314        3   20             42       20      1184967
137  false    false  433        4   10             55       26      1199760
138  false    false 1522       15   29             25       20      1140894
139  false    false  612        6   17             68       20      1170862
140   true     true 1631       16   36             17       26      1126418
141   true    false 2032       20   47              4       26      1162074
142  false    false 2522       25   31             19       20      1143713
143   true    false 2222       22   21             73       20      1169618
144  false     true  431        4    7             51       26      1193487
145  false     true  433        4   10             55       26      1199090
146  false     true 1822       18   27              8       26      1171017
147  false     true  412        4    8             48       26      1191052
148   true    false  423        4    7             46       20      1196565
149  false     true 2514       25   30             19       26      1136171
150  false     true 1522       15   29             25       26      1139735
151  false     true  314        3    5             42       26      1187484
152  false    false  222        2    4             39       26      1184584
153  false    false 2522       25   31             19       20      1141946
154  false    false  833        8   13             65       26      1150790
155  false    false  523        5   34             53       20      1175879
156  false    false 1935       19   43              7       20      1169757
157   true     true  612        6   17             71       26      1170011
158  false    false 2223       22   21             73       26      1172579
159  false    false  311        3   20             40       20      1179514
160  false    false 2422       24   49              1       20      1164140
161   true    false 1731       17   30             16       20      1146775
162  false    false  424        4   10             46       26      1199294
163  false    false  815        8   14             57       26      1147822
164  false    false  914        9   11             60       20      1171863
165  false    false  833        8   13             65       26      1148571
166   true    false  825        8   15             66       20      1159741
167  false     true 1414       14   26             22       26      1154872
168  false    false  434        4   10             51       26      1195554
169  false     true  422        4    7             46       26      1194234
170  false    false 2234       22   34             75       26      1167332
171  false    false 1821       18   43              8       20      1174261
172  false     true 2213       22   19             72       26      1162813
173  false    false 1113       11   28             26       20      1146387
174  false    false  822        8   14             63       20      1155602
175  false    false 1612       16   41             10       20      1130626
176  false    false  513        5    9             49       20      1181515
177  false     true 2211       22   19             74       26      1154843
178  false     true 1111       11   37             23       26      1148861
179  false    false  531        5    9             49       20      1178868
180  false    false  612        6   17             71       26      1168051
181  false    false 1115       11   28             26       26      1148125
182  false     true  732        7    6             68       26      1174821
183  false    false 1811       18   32              7       20      1165679
184  false     true  821        8   14             57       26      1151187
185  false    false  214        2    4             36       26      1183973
186  false     true  722        7   20             68       26      1175050
187  false     true  612        6   17             71       26      1168761
188  false     true 1133       11   24             27       26      1152869
189  false    false 1113       11   28             25       26      1145306
190  false    false  433        4   10             55       26      1199090
    Y.Coordinate Year             Updated.On Latitude Longitude
1        1843765 2017 05/04/2018 03:51:04 PM 41.72664 -87.62880
2        1911584 2017 05/04/2018 03:51:04 PM 41.91283 -87.64202
3        1870933 2017 05/04/2018 03:51:04 PM 41.80176 -87.72831
4        1899040 2017 05/04/2018 03:51:04 PM 41.87829 -87.62334
5        1841607 2017 05/04/2018 03:51:04 PM 41.72072 -87.62987
6        1854297 2017 05/04/2018 03:51:04 PM 41.75563 -87.64417
7        1858210 2017 05/04/2018 03:51:04 PM 41.76600 -87.58430
8        1894331 2017 02/10/2018 03:50:01 PM 41.86563 -87.66636
9        1825824 2017 02/10/2018 03:50:01 PM 41.67744 -87.63467
10       1902038 2017 02/10/2018 03:50:01 PM 41.88698 -87.70278
11       1863367 2017 02/10/2018 03:50:01 PM 41.78023 -87.59620
12       1827094 2017 02/10/2018 03:50:01 PM 41.68136 -87.71115
13       1934426 2017 02/10/2018 03:50:01 PM 41.97633 -87.79513
14       1856254 2017 02/10/2018 03:50:01 PM 41.76103 -87.64916
15       1866763 2017 12/21/2017 03:46:09 PM 41.78984 -87.64382
16       1947120 2017 02/10/2018 03:50:01 PM 42.01122 -87.80664
17       1902645 2017 02/10/2018 03:50:01 PM 41.88893 -87.75649
18       1906052 2017 02/10/2018 03:50:01 PM 41.89809 -87.71884
19       1870007 2017 02/05/2019 04:09:13 PM 41.79892 -87.67323
20       1929384 2017 02/10/2018 03:50:01 PM 41.96176 -87.65580
21       1838313 2017 02/10/2018 03:50:01 PM 41.71107 -87.53649
22       1882133 2017 02/10/2018 03:50:01 PM 41.83182 -87.61086
23       1849282 2017 02/10/2018 03:50:01 PM 41.74228 -87.71568
24       1869772 2017 02/10/2018 03:50:01 PM 41.79795 -87.61931
25       1862918 2017 02/10/2018 03:50:01 PM 41.77930 -87.64477
26       1868419 2017 02/10/2018 03:50:01 PM 41.79437 -87.64129
27       1878278 2017 02/10/2018 03:50:01 PM 41.82177 -87.70036
28       1919701 2017 02/10/2018 03:50:01 PM 41.93570 -87.74922
29       1836539 2017 02/10/2018 03:50:01 PM 41.70690 -87.64451
30       1867064 2017 02/10/2018 03:50:01 PM 41.79054 -87.62236
31       1941154 2017 02/10/2018 03:50:01 PM 41.99422 -87.68270
32       1836831 2017 02/10/2018 03:50:01 PM 41.70746 -87.60533
33       1859760 2017 02/10/2018 03:50:01 PM 41.77116 -87.73996
34       1906162 2017 02/10/2018 03:50:01 PM 41.89858 -87.75619
35       1859472 2017 02/10/2018 03:50:01 PM 41.76938 -87.57272
36       1904830 2017 02/10/2018 03:50:01 PM 41.89417 -87.62150
37       1891548 2017 02/10/2018 03:50:01 PM 41.85834 -87.72983
38       1867170 2017 02/10/2018 03:50:01 PM 41.79122 -87.68885
39       1841915 2017 02/10/2018 03:50:01 PM 41.72159 -87.63364
40       1868295 2017 02/10/2018 03:50:01 PM 41.79394 -87.62568
41       1852948 2017 02/10/2018 03:50:01 PM 41.75154 -87.58140
42       1891581 2017 02/10/2018 03:50:01 PM 41.85800 -87.65284
43       1891121 2017 02/10/2018 03:50:01 PM 41.85662 -87.63264
44       1896075 2017 02/10/2018 03:50:01 PM 41.87095 -87.76516
45       1860852 2017 02/10/2018 03:50:01 PM 41.77354 -87.63000
46       1939764 2017 02/10/2018 03:50:01 PM 41.99047 -87.69484
47       1830349 2017 02/10/2018 03:50:01 PM 41.68920 -87.53408
48       1919508 2017 02/10/2018 03:50:01 PM 41.93517 -87.74798
49       1861908 2017 02/10/2018 03:50:01 PM 41.77623 -87.59732
50       1932961 2017 02/10/2018 03:50:01 PM 41.97195 -87.72234
51       1878859 2017 02/10/2018 03:50:01 PM 41.82342 -87.71004
52       1859788 2017 02/10/2018 03:50:01 PM 41.77115 -87.72257
53       1897517 2017 02/10/2018 03:50:01 PM 41.87412 -87.62422
54       1831503 2017 02/10/2018 03:50:01 PM 41.69283 -87.60432
55       1913561 2017 02/10/2018 03:50:01 PM 41.91894 -87.76681
56       1853235 2017 02/10/2018 03:50:01 PM 41.75320 -87.73041
57       1908797 2017 02/10/2018 03:50:01 PM 41.90545 -87.68709
58       1879603 2017 02/10/2018 03:50:01 PM 41.82493 -87.61920
59       1868122 2017 02/10/2018 03:50:01 PM 41.79358 -87.64514
60       1923497 2017 02/10/2018 03:50:01 PM 41.94611 -87.74779
61       1943024 2017 02/10/2018 03:50:01 PM 41.99997 -87.80369
62       1933838 2017 02/10/2018 03:50:01 PM 41.97478 -87.80707
63       1875699 2017 02/10/2018 03:50:01 PM 41.81463 -87.68950
64       1942022 2017 02/10/2018 03:50:01 PM 41.99664 -87.69107
65       1862350 2017 02/10/2018 03:50:01 PM 41.77756 -87.61556
66       1903245 2017 02/10/2018 03:50:01 PM 41.89038 -87.71861
67       1900817 2017 02/10/2018 03:50:01 PM 41.88321 -87.62991
68       1934238 2017 02/10/2018 03:50:01 PM 41.97603 -87.84247
69       1840935 2017 02/10/2018 03:50:01 PM 41.71896 -87.64314
70       1835392 2017 02/10/2018 03:50:01 PM 41.70353 -87.60741
71       1897671 2017 02/10/2018 03:50:01 PM 41.87517 -87.73362
72       1858861 2017 02/10/2018 03:50:01 PM 41.76799 -87.61693
73       1833332 2017 02/10/2018 03:50:01 PM 41.69842 -87.69989
74       1948448 2017 02/10/2018 03:50:01 PM 42.01417 -87.67242
75       1868851 2017 02/10/2018 03:50:01 PM 41.79619 -87.75507
76       1867218 2017 02/10/2018 03:50:01 PM 41.79121 -87.66451
77       1934274 2017 02/10/2018 03:50:01 PM 41.97537 -87.68913
78       1853480 2017 02/10/2018 03:50:01 PM 41.75342 -87.64897
79       1934241 2017 02/10/2018 03:50:01 PM 41.97629 -87.90523
80       1870633 2017 02/10/2018 03:50:01 PM 41.80081 -87.70454
81       1900551 2017 02/10/2018 03:50:01 PM 41.88246 -87.62622
82       1884961 2017 02/10/2018 03:50:01 PM 41.84021 -87.71834
83       1899837 2017 02/10/2018 03:50:01 PM 41.88097 -87.70672
84       1894289 2017 02/10/2018 03:50:01 PM 41.86566 -87.69251
85       1825835 2017 02/10/2018 03:50:01 PM 41.67760 -87.65715
86       1896076 2017 02/10/2018 03:50:01 PM 41.87074 -87.72393
87       1865506 2017 02/10/2018 03:50:01 PM 41.78659 -87.67719
88       1887995 2017 02/10/2018 03:50:01 PM 41.84810 -87.64297
89       1903738 2017 02/10/2018 03:50:01 PM 41.89188 -87.74570
90       1933695 2017 02/10/2018 03:50:01 PM 41.97425 -87.77942
91       1916870 2017 02/10/2018 03:50:01 PM 41.92807 -87.77708
92       1912456 2017 02/10/2018 03:50:01 PM 41.91525 -87.64600
93       1922815 2017 02/10/2018 03:50:01 PM 41.94425 -87.75064
94       1851428 2017 02/10/2018 03:50:01 PM 41.74739 -87.58544
95       1916064 2017 02/10/2018 03:50:01 PM 41.92524 -87.66169
96       1920839 2017 02/10/2018 03:50:01 PM 41.93882 -87.74762
97       1849872 2017 02/10/2018 03:50:01 PM 41.74324 -87.60380
98       1911085 2017 02/10/2018 03:50:01 PM 41.91137 -87.62640
99       1838042 2017 02/10/2018 03:50:01 PM 41.71081 -87.60899
100      1854859 2017 02/10/2018 03:50:01 PM 41.75665 -87.56148
101      1932809 2017 02/10/2018 03:50:01 PM 41.97167 -87.74858
102      1891710 2017 02/10/2018 03:50:01 PM 41.85879 -87.73052
103      1834315 2017 02/10/2018 03:50:01 PM 41.70071 -87.62956
104      1855484 2017 02/10/2018 03:50:01 PM 41.75837 -87.56151
105      1877525 2017 02/10/2018 03:50:01 PM 41.81969 -87.69831
106      1898723 2017 02/10/2018 03:50:01 PM 41.87809 -87.74115
107      1884344 2017 02/10/2018 03:50:01 PM 41.83808 -87.64312
108      1894911 2017 02/10/2018 03:50:01 PM 41.86730 -87.68029
109      1944078 2017 02/10/2018 03:50:01 PM 42.00223 -87.68028
110      1851927 2017 02/10/2018 03:50:01 PM 41.74890 -87.60760
111      1856285 2017 02/10/2018 03:50:01 PM 41.76123 -87.66777
112      1830888 2017 02/10/2018 03:50:01 PM 41.69167 -87.69225
113      1937180 2017 02/10/2018 03:50:01 PM 41.98348 -87.71255
114      1913885 2017 02/10/2018 03:50:01 PM 41.91936 -87.67768
115      1850539 2017 02/10/2018 03:50:01 PM 41.74508 -87.60506
116      1928074 2017 02/10/2018 03:50:01 PM 41.95867 -87.74747
117      1850210 2017 02/10/2018 03:50:01 PM 41.74383 -87.55176
118      1894398 2017 02/10/2018 03:50:01 PM 41.86606 -87.71053
119      1903273 2017 02/10/2018 03:50:01 PM 41.89046 -87.71861
120      1832313 2017 02/10/2018 03:50:01 PM 41.69522 -87.63111
121      1927424 2017 02/10/2018 03:50:01 PM 41.95665 -87.70199
122      1854158 2017 02/10/2018 03:50:01 PM 41.75476 -87.56629
123      1865460 2017 02/10/2018 03:50:01 PM 41.78652 -87.68677
124      1898383 2017 02/10/2018 03:50:01 PM 41.87708 -87.72616
125      1941566 2017 02/10/2018 03:50:01 PM 41.99594 -87.79764
126      1873124 2017 04/29/2019 04:10:02 PM 41.80704 -87.60165
127      1868068 2017 02/10/2018 03:50:01 PM 41.79358 -87.67103
128      1855003 2017 02/10/2018 03:50:01 PM 41.75702 -87.55807
129      1904482 2017 02/10/2018 03:50:01 PM 41.89399 -87.76061
130      1840729 2017 02/10/2018 03:50:01 PM 41.71840 -87.64435
131      1829122 2017 02/10/2018 03:50:01 PM 41.68648 -87.63253
132      1906516 2017 02/10/2018 03:50:01 PM 41.89893 -87.64304
133      1839598 2017 02/10/2018 03:50:01 PM 41.71482 -87.56944
134      1902665 2017 02/10/2018 03:50:01 PM 41.88893 -87.74559
135      1837217 2017 02/10/2018 03:50:01 PM 41.70861 -87.61868
136      1862938 2017 02/10/2018 03:50:01 PM 41.77906 -87.59744
137      1817775 2017 02/10/2018 03:50:01 PM 41.65477 -87.54472
138      1898154 2017 02/10/2018 03:50:01 PM 41.87662 -87.75815
139      1855025 2017 02/10/2018 03:50:01 PM 41.75766 -87.64938
140      1923823 2017 02/10/2018 03:50:01 PM 41.94731 -87.81073
141      1934195 2017 02/10/2018 03:50:01 PM 41.97510 -87.67937
142      1913857 2017 02/10/2018 03:50:01 PM 41.91966 -87.74741
143      1843419 2017 02/10/2018 03:50:01 PM 41.72584 -87.65427
144      1838773 2017 02/10/2018 03:50:01 PM 41.71254 -87.56699
145      1819006 2017 02/10/2018 03:50:01 PM 41.65816 -87.54713
146      1908713 2017 02/10/2018 03:50:01 PM 41.90498 -87.64724
147      1846705 2017 02/10/2018 03:50:01 PM 41.73437 -87.57565
148      1846235 2017 02/10/2018 03:50:01 PM 41.73294 -87.55547
149      1920264 2017 02/10/2018 03:50:01 PM 41.93737 -87.77496
150      1897798 2017 02/10/2018 03:50:01 PM 41.87566 -87.76241
151      1865036 2017 02/10/2018 03:50:01 PM 41.78475 -87.58814
152      1874737 2017 02/10/2018 03:50:01 PM 41.81144 -87.59847
153      1914147 2017 02/10/2018 03:50:01 PM 41.92048 -87.75389
154      1859206 2017 02/10/2018 03:50:01 PM 41.76955 -87.72283
155      1822479 2017 02/10/2018 03:50:01 PM 41.66824 -87.63196
156      1917470 2017 02/10/2018 03:50:01 PM 41.92904 -87.65161
157      1852871 2017 02/10/2018 03:50:01 PM 41.75177 -87.65256
158      1844343 2017 02/10/2018 03:50:01 PM 41.72831 -87.64340
159      1865056 2017 02/10/2018 03:50:01 PM 41.78500 -87.61736
160      1949959 2017 02/10/2018 03:50:01 PM 42.01831 -87.67133
161      1922562 2017 02/10/2018 03:50:01 PM 41.94348 -87.73593
162      1848986 2017 02/10/2018 03:50:01 PM 41.74042 -87.54538
163      1872938 2017 04/21/2019 04:00:07 PM 41.80729 -87.73336
164      1886987 2017 02/10/2018 03:50:01 PM 41.84535 -87.64477
165      1853884 2017 02/10/2018 03:50:01 PM 41.75499 -87.73110
166      1864605 2017 02/10/2018 03:50:01 PM 41.78419 -87.68987
167      1915433 2017 02/10/2018 03:50:01 PM 41.92376 -87.70636
168      1834384 2017 02/10/2018 03:50:01 PM 41.70045 -87.55957
169      1852798 2017 02/10/2018 03:50:01 PM 41.75101 -87.56380
170      1831292 2017 02/10/2018 03:50:01 PM 41.69261 -87.66299
171      1909359 2017 02/10/2018 03:50:01 PM 41.90668 -87.63530
172      1838041 2017 02/10/2018 03:50:01 PM 41.71123 -87.67935
173      1899777 2017 02/10/2018 03:50:01 PM 41.88097 -87.73794
174      1869634 2017 02/10/2018 03:50:01 PM 41.79807 -87.70491
175      1937587 2017 02/10/2018 03:50:01 PM 41.98501 -87.79494
176      1832590 2017 02/10/2018 03:50:01 PM 41.69586 -87.61103
177      1827111 2017 02/21/2017 04:01:48 PM 41.68140 -87.70883
178      1906687 2017 02/10/2018 03:50:01 PM 41.89988 -87.72868
179      1828958 2017 02/16/2017 03:49:36 PM 41.68595 -87.62083
180      1853686 2017 02/14/2017 03:55:11 PM 41.75405 -87.65972
181      1899675 2017 02/14/2017 03:49:42 PM 41.88065 -87.73156
182      1859021 2017 02/14/2017 03:49:42 PM 41.76854 -87.63475
183      1916028 2017 02/14/2017 03:49:42 PM 41.92517 -87.66664
184      1872153 2017 02/14/2017 03:49:42 PM 41.80507 -87.72104
185      1877024 2017 04/11/2019 03:59:23 PM 41.81773 -87.60064
186      1862506 2017 02/14/2017 03:49:42 PM 41.77810 -87.63381
187      1854390 2017 02/10/2018 03:50:01 PM 41.75597 -87.65710
188      1896803 2017 02/14/2017 03:49:42 PM 41.87268 -87.71422
189      1901054 2017 02/14/2017 03:49:42 PM 41.88449 -87.74188
190      1819006 2017 02/14/2017 03:49:42 PM 41.65816 -87.54713
                         Location Historical.Wards.2003.2015 Zip.Codes
1     (41.7266374, -87.628796799)                         18     21554
2   (41.912831524, -87.642021866)                         51     21190
3   (41.801761681, -87.728305724)                         35     22248
4   (41.878293868, -87.623343983)                         22     14912
5   (41.720721754, -87.629872409)                         18     21861
6   (41.755633717, -87.644173224)                         17     21554
7   (41.765997381, -87.584295185)                         32     22538
8   (41.865629068, -87.666357104)                         48     14920
9   (41.677437288, -87.634670739)                         45     21861
10  (41.886984743, -87.702779083)                         41     21184
11  (41.780226662, -87.596195666)                         53     22260
12  (41.681362096, -87.711152992)                         33      4447
13  (41.976334757, -87.795133485)                         34      4448
14  (41.761034113, -87.649158884)                         17     21559
15  (41.789841984, -87.643821613)                         53     21559
16  (42.011222985, -87.806640059)                         NA      4456
17  (41.888932876, -87.756493754)                         11     22216
18  (41.898087191, -87.718838969)                         41      4299
19  (41.798917189, -87.673228979)                         19     14924
20   (41.96176074, -87.655803219)                         37     21186
21   (41.71107236, -87.536490035)                         47     21202
22  (41.831818944, -87.610864733)                          1     21194
23   (41.742277646, -87.71567689)                          6      4300
24  (41.797949772, -87.619306201)                         12     21192
25  (41.779295906, -87.644774188)                         53     21559
26    (41.7943713, -87.641290381)                         12     21559
27  (41.821767828, -87.700359595)                         49     22248
28  (41.935701767, -87.749218092)                          7     22618
29  (41.706902188, -87.644507138)                         45     22212
30  (41.790537186, -87.622358716)                         53     22260
31   (41.99421553, -87.682695783)                         42      4450
32  (41.707462015, -87.605329791)                         30     21861
33    (41.7711605, -87.739964917)                         23      4300
34  (41.898582838, -87.756186528)                          4      4299
35  (41.769384626, -87.572719632)                         32     22538
36  (41.894171604, -87.621500665)                         22     21182
37  (41.858342872, -87.729828364)                         36     21569
38  (41.791220341, -87.688848758)                         19     21867
39  (41.721590004, -87.633639541)                         18     21861
40  (41.793935909, -87.625680278)                         53     21559
41      (41.751538, -87.58140325)                          9     22538
42  (41.858003073, -87.652839615)                          8     14920
43  (41.856619252, -87.632639494)                          8     21194
44  (41.870946327, -87.765155189)                         52     22216
45   (41.773536673, -87.62999581)                         31     21559
46   (41.990469268, -87.69483597)                         42      4450
47   (41.689199826, -87.53407636)                         47     21202
48   (41.93516583, -87.747980746)                          7     22618
49  (41.776229949, -87.597319284)                         53     22260
50  (41.971950157, -87.722340107)                         28     21849
51  (41.823415189, -87.710040147)                         29     22248
52  (41.771146186, -87.722570475)                         23     21867
53  (41.874119819, -87.624223667)                         48     14913
54   (41.692833841, -87.60431945)                         30     21861
55   (41.91894033, -87.766805639)                         52     22615
56   (41.753204151, -87.73040747)                         23      4300
57  (41.905445844, -87.687091426)                         24     21560
58  (41.824928104, -87.619204642)                         12      4301
59  (41.793579386, -87.645142068)                         53     21559
60  (41.946111569, -87.747792408)                         25     22618
61   (41.99996918, -87.803686675)                         34     22243
62  (41.974776514, -87.807072848)                         34      4448
63  (41.814629974, -87.689498196)                         29     22248
64  (41.996644646, -87.691069707)                         42      4450
65  (41.777558327, -87.615558249)                         53     22260
66  (41.890382869, -87.718607982)                         41     21572
67  (41.883210775, -87.629906972)                         22     14310
68  (41.976031021, -87.842474207)                         34      4448
69  (41.718958052, -87.643144011)                         18     21861
70  (41.703526071, -87.607406613)                         30     21861
71  (41.875165815, -87.733620994)                         36     21572
72  (41.767992049, -87.616929557)                         31     22260
73  (41.698419746, -87.699889876)                         33      4447
74  (42.014172932, -87.672420812)                          3     21853
75   (41.79618592, -87.755070795)                         35     22268
76   (41.79121295, -87.664510866)                         19     22257
77  (41.975371754, -87.689132117)                         46     21849
78  (41.753420285, -87.648968547)                         17     21554
79  (41.976290414, -87.905227221)                         34     16197
80  (41.800810775, -87.704541522)                         49     22248
81  (41.882458192, -87.626224643)                         22     14310
82  (41.840205468, -87.718339822)                         14     21569
83  (41.880966228, -87.706719713)                         11     21572
84  (41.865662741, -87.692514518)                         11     14920
85  (41.677601943, -87.657152075)                         45     22212
86  (41.870737693, -87.723925411)                         36     21572
87  (41.786587871, -87.677194557)                         44     22257
88  (41.848103237, -87.642965111)                         26     21194
89  (41.891877604, -87.745698694)                         11     22216
90  (41.974254011, -87.779422321)                         20     21869
91  (41.928071207, -87.777076907)                         52     22615
92  (41.915248376, -87.646000557)                         51     21190
93  (41.944254497, -87.750639748)                         25     22618
94  (41.747393001, -87.585438607)                          9     21202
95   (41.92524237, -87.661687058)                         16     21190
96  (41.938816534, -87.747616569)                          7     22618
97  (41.743240897, -87.603797174)                          9     21546
98  (41.911367051, -87.626401638)                         51     14926
99  (41.710808526, -87.608991091)                         30     21861
100 (41.756650207, -87.561475423)                         43     22538
101 (41.971669694, -87.748580687)                         20     21869
102 (41.858791083, -87.730521617)                         36     21569
103 (41.700708236, -87.629559608)                         45     21861
104 (41.758365623, -87.561509844)                         43     22538
105 (41.819690081, -87.698310944)                         49     22248
106 (41.878091821, -87.741146903)                         11     22216
107 (41.838084873, -87.643120505)                         26     21194
108  (41.86730081, -87.680290889)                         48     21184
109 (42.002225812, -87.680277948)                         42     22528
110  (41.748904498, -87.60759554)                         31     21546
111 (41.761228524, -87.667772896)                         17     22257
112 (41.691670242, -87.692252608)                         33      4447
113 (41.983475399, -87.712545676)                         28      4450
114 (41.919355122, -87.677677065)                         16     22535
115 (41.745079376, -87.605062559)                          9     21546
116 (41.958670188, -87.747467886)                         20     22618
117 (41.743826264, -87.551757398)                         47     21202
118  (41.86606099, -87.710532902)                         36     21569
119 (41.890459704, -87.718607245)                         41     21572
120 (41.695223594, -87.631113315)                         45     21861
121  (41.95664537, -87.701989912)                          2     21538
122 (41.754758711, -87.566291811)                         43     22538
123  (41.786515941, -87.68677283)                         19     21867
124 (41.877080518, -87.726160106)                         11     21572
125 (41.995940096, -87.797642784)                         34     22243
126 (41.807037492, -87.601650683)                          1     21192
127 (41.793583375, -87.671032081)                         44     22257
128  (41.75702248, -87.558073456)                         43     22538
129 (41.893994673, -87.760613271)                          4     22216
130 (41.718399968, -87.644351403)                         18     22212
131 (41.686475055, -87.632526437)                         45     21861
132 (41.898929854, -87.643035021)                         41     14926
133   (41.7148226, -87.569444242)                         43     21202
134   (41.888932471, -87.7455898)                         11     22216
135 (41.708605106, -87.618676996)                         30     21861
136 (41.779057322, -87.597437273)                         53     22260
137 (41.654766107, -87.544722501)                         47     22250
138  (41.876616762, -87.75815039)                         52     22216
139 (41.757662671, -87.649377949)                         17     21554
140 (41.947309904, -87.810728474)                         39     22254
141 (41.975099794, -87.679374655)                         13     21849
142  (41.919655269, -87.74740602)                          7     22615
143  (41.725841244, -87.65427269)                         18     21554
144 (41.712542208, -87.566991711)                         43     21202
145 (41.658160906, -87.547132912)                         47     22250
146 (41.904984127, -87.647238431)                         41     14926
147 (41.734367539, -87.575653596)                          9     21202
148 (41.732942865, -87.555472437)                         NA     21202
149 (41.937374854, -87.774963576)                         27     22254
150 (41.875661086, -87.762414626)                         52     22216
151 (41.784754925, -87.588143196)                         32     22260
152 (41.811443713, -87.598471599)                          1      4301
153 (41.920484006, -87.753891124)                          4     22615
154  (41.769550388, -87.72283122)                         23     21867
155 (41.668240975, -87.631962944)                         45     21861
156 (41.929041364, -87.651611069)                         51     21190
157  (41.751770335, -87.65255922)                         17     21554
158  (41.72831222, -87.643399249)                         18     21554
159 (41.784995638, -87.617363627)                         53     22260
160 (42.018313098, -87.671329134)                          3     21853
161 (41.943484629, -87.735932805)                         27     22618
162 (41.740423699, -87.545382804)                         47     21202
163 (41.807290478, -87.733359471)                         35     22248
164 (41.845347864, -87.644771063)                         26     21194
165 (41.754988848, -87.731101768)                         23      4300
166 (41.784186975, -87.689872518)                         44     21867
167 (41.923763406, -87.706363595)                         10     22535
168 (41.700447629, -87.559566304)                         47     21202
169 (41.751009781, -87.563796798)                         43     21202
170 (41.692612004, -87.662992277)                         45     22212
171 (41.906684967, -87.635303024)                         51     14926
172 (41.711227737, -87.679349571)                         33     22212
173  (41.88096768, -87.737940272)                         11     21572
174 (41.798071266, -87.704913039)                         49     22248
175  (41.985008293, -87.79494274)                         34     22243
176 (41.695859276, -87.611026263)                         30     21861
177  (41.68139614, -87.708828073)                         33      4447
178 (41.899882008, -87.728677033)                          4      4299
179 (41.685953051, -87.620827806)                         30     21861
180 (41.754049139, -87.659718334)                         17     21554
181 (41.880654516, -87.731561021)                         11     21572
182 (41.768540876, -87.634749833)                         31     21559
183 (41.925172429, -87.666637578)                         16     21190
184   (41.8050712, -87.721038004)                         49     22248
185 (41.817733722, -87.600641158)                          1      4301
186 (41.778098999, -87.633806535)                         53     21559
187  (41.755965725, -87.65709614)                         17     21554
188  (41.87268084, -87.714217417)                         36     21572
189  (41.88449243, -87.741877356)                         11     22216
190 (41.658160906, -87.547132912)                         47     22250
    Community.Areas Census.Tracts Wards Boundaries...ZIP.Codes Police.Districts
1                45           187    13                     59               20
2                68           272    34                     16               14
3                54           697     8                     56               13
4                38           367    36                     29               22
5                45           568    13                     19               10
6                70           572    31                     59               20
7                39           452    33                     24               18
8                29            96    23                     43               15
9                50            60    22                     19               10
10               28            50    46                     28               15
11                9            27     4                     60               18
12               73           264    42                     33                9
13               36           699    29                     31               12
14               66           512    31                     11               17
15               66           113     4                     11               17
16               NA            NA    NA                     NA               NA
17               26           673    45                     32               25
18               24           456    46                      5               16
19               59           767     2                     37               23
20               31           577    39                     53                5
21               49           528    47                     25               19
22                1           581    10                     40               24
23               69           199    30                      8               13
24                7           401     9                     10               24
25               66           435     4                     11               17
26               59            84     4                     37               23
27               55           196     1                     56               23
28               19           355    17                     21                6
29               72           594    22                     13                9
30                7           403     4                     60               24
31               20            53    27                     50               11
32               47           254    43                     19               10
33               63           318    15                     58               13
34               26           562    45                      5               25
35               39           152    33                     24               18
36               37           158    36                      6               14
37               30           753    14                     57               21
38               61           112     3                     58               13
39               72           631    13                     19                9
40                7           403     4                     60               24
41               42           507    35                     25               19
42               33           228    26                     43               15
43               35             3    26                     40               23
44               26            61     7                     32               25
45               66           435    32                     11               17
46               20            31    24                     50               11
47               49           552    47                     25               19
48               19           355    17                     21                6
49                9            27     4                     60               18
50               14           127    38                     20                1
51               55           612     1                     56               23
52               63           318    15                     58               13
53               38           368    36                     35               22
54               47           601    43                     19               10
55               19            57     7                      2                6
56               69           571    30                      8               13
57               25           302    41                      4                7
58                1           222     9                     36               24
59               66           113     4                     11               17
60               15           115    17                     21               12
61               36           657    29                     17               12
62               36           735    29                     31               12
63               55           641     3                     56               23
64               20            31    27                     50               11
65                9           332     4                     60               18
66               24           584    46                     30               16
67               38            92    36                     41               22
68               75             8    29                     31               12
69               72           593    13                     19                9
70               45           236    43                     19               10
71               27           717    23                     30               16
72               67           514    32                     60               18
73               73           256    42                     33                9
74               10           489     5                      9               11
75               53           607     6                      7               13
76               65           384     2                     23               17
77                6            28    24                     20                2
78               70           572    31                     59               20
79               75           668    29                     38               12
80               61           776     8                     56               13
81               38           580    36                     41               22
82               32           234    28                     57               21
83               28            39    23                     30               16
84               30            16    23                     43               21
85               50           642    22                     13               10
86               27           702    14                     30               16
87               65           274     3                     23               17
88               58            59    48                     40               23
89               26           695    23                     32               25
90               11           779    50                     48               12
91               19            78    21                      2                6
92               68           273    34                     16               14
93               15           115    17                     21               12
94               41           431    35                     25               19
95               68           210    11                     16               14
96               19           355    17                     21                6
97               40           141    35                     61               20
98               37           271    34                     16               14
99               45           570    43                     19               10
100              39           245    37                     24               19
101              12           746    50                     48               12
102              30           761    14                     57               21
103              45           524    22                     19               10
104              39           245    37                     24               19
105              55           196     1                     56               23
106              26            69    23                     32               16
107              58           688    48                     40               23
108              29             5    46                     28               15
109              20           320    27                     12               11
110              40            11    32                     61               20
111              65           433    31                     23               17
112              74           334    42                     33                9
113              13           799    38                     50                1
114              23           209    40                     16                7
115              40           141    35                     61               20
116              15           139    50                     21                1
117              42           506    37                     25               19
118              30            34    14                     57               21
119              24           584    46                     30               16
120              45           524    22                     19               10
121              16           116    20                     39                1
122              39           420    37                     24               19
123              64           112     2                     58               13
124              27           675    23                     30               16
125              36           657    29                     17               12
126               5           461    10                     10               24
127              65           345     3                     23               17
128              39           245    37                     24               19
129              26           673    45                     32               25
130              72           592    13                     13                9
131              45           486    22                     19                9
132              37           108    46                     54               14
133              48           252    37                     25               19
134              26           695    23                     32               16
135              45           570    43                     19               10
136               9            27     4                     60               18
137              52           787    47                     26               19
138              26            68     7                     32               25
139              70           572    31                     59               20
140              17           392    19                     52               12
141               6           106    24                     15                2
142              19           306    44                      2                6
143              72           195    13                     59                9
144              48           252    37                     25               19
145              52           787    47                     26               19
146              37           108    46                     54               14
147              44           473    35                     25               19
148              42           175    47                     25               19
149              19            82    21                     52                6
150              26            68     7                     32               25
151               9           469    33                     60               18
152               5           395    10                     36               24
153              19           306    44                      2                6
154              63           318    15                     58               13
155              50             7    22                     19               10
156              68           769    34                     16                5
157              70           487    31                     59               20
158              72           631    13                     59                9
159               7           404     4                     60               18
160              10           489     5                      9               11
161              16           328    21                     21                1
162              42           506    47                     25               19
163              54           697     8                     56               13
164              58            59    48                     40               23
165              63           318    30                      8               13
166              64           111     2                     58               13
167              23           371    40                      1                7
168              48           174    47                     25               19
169              42           478    37                     25               19
170              74           380    22                     13                9
171              37           290    46                     54               14
172              71           629    42                     13                9
173              27           732    23                     30               16
174              61           776     8                     56               13
175              36           733    29                     17               12
176              45           237    43                     19               10
177              73           264    42                     33                9
178              24            99    45                      5               16
179              45           253    43                     19               10
180              70           557    31                     59               20
181              27           717    23                     30               16
182              66           479    32                     11               17
183              68           770    40                     16                5
184              54           698     8                     56               13
185               2           220    10                     36               24
186              66           435     4                     11               17
187              70           572    31                     59               20
188              28           685    14                     30               16
189              26           696    23                     32               16
190              52           787    47                     26               19
    Police.Beats
1            242
2            189
3            105
4             87
5            250
6            229
7            212
8            150
9            267
10            77
11           273
12           254
13            49
14           215
15           135
16            NA
17            84
18            66
19           128
20             5
21           247
22           169
23           232
24           125
25           202
26           117
27           110
28           176
29           253
30           268
31            52
32           256
33           209
34            67
35           262
36            74
37           109
38           269
39           243
40           111
41           222
42           158
43           157
44            99
45           201
46            52
47           259
48           176
49           206
50            48
51            96
52           209
53            87
54           265
55           133
56           232
57           200
58           101
59           261
60            26
61            34
62            49
63           115
64            52
65           277
66            82
67            93
68            44
69           243
70           256
71           143
72           211
73           254
74            37
75           112
76           266
77            61
78           230
79            24
80           103
81            93
82           167
83            86
84           151
85           220
86           142
87           270
88           157
89            81
90            43
91           183
92           189
93            26
94           224
95           186
96           176
97           241
98           134
99           250
100          225
101           58
102          109
103          256
104          225
105          110
106           90
107          157
108          139
109           46
110          235
111            7
112          257
113           53
114          180
115          235
116           11
117          239
118          153
119           82
120          260
121           13
122          225
123          269
124          100
125           34
126          113
127          270
128          225
129           67
130          243
131          258
132          199
133          249
134           68
135          250
136          273
137          259
138           97
139          230
140           29
141           59
142          188
143          244
144          249
145          259
146          199
147          240
148          238
149          177
150           97
151          273
152          113
153          188
154          209
155          218
156          178
157          230
158          243
159          251
160           32
161           25
162          239
163          105
164          157
165          209
166          274
167          182
168          255
169          234
170          263
171          198
172          252
173           90
174          129
175           45
176          260
177          254
178           68
179          265
180          230
181          100
182          214
183          173
184          103
185          104
186          201
187          230
188          141
189           90
190          259
  • How many kidnappings records are in the data?

We see the data has 190 kidnapping reports.

  • Create Leaflet map to visualize the kidnapping data.

Write YOUR CODE in the chunk below:

Code
crimes %>% filter(Primary.Type == "KIDNAPPING") %>% leaflet() %>% addTiles() %>% addMarkers()
Assuming "Longitude" and "Latitude" are longitude and latitude, respectively

Leaflet’s interactivity allow us to cluster markers at varying levels of detail.

  • Use the clusterOptions argument to addMarkers() to cluster the data on the map.

Write YOUR CODE in the chunk below:

Code
crimes %>% filter(Primary.Type == "KIDNAPPING") %>% leaflet() %>% addTiles() %>% addMarkers(clusterOptions = addMarkers)
Assuming "Longitude" and "Latitude" are longitude and latitude, respectively
Code
#south
  • By looking at the clusters, where do you see more kidnapping crimes north or south?

Rubric:

  • Codes filtering the data works 2 pts

  • Map is produced 3 pts

  • Map with Clusters is produced 3 pts

  • Correct statement where more kidnapping crimes occurred 2 pts

c) (10 pts) You remember from week 1 we can make some information to appear when we click on the point using the popup= option, e.g. popup = ~Date:

Code
crimes %>% filter(Primary.Type == "KIDNAPPING") %>% leaflet() %>% addTiles() %>% addMarkers(popup = ~Date)
Assuming "Longitude" and "Latitude" are longitude and latitude, respectively
  • Select data for one of the following type of crimes ARSON or SEX OFFENSE.

  • Create map that incorporates cluster markers using the clusterOptions argument to addMarkers().

Hint: Use summary(crimes$Primary.Type) to see the type of crimes. The variable is Primary Type of the crime. (code is commented below, uncomment to run)

Write YOUR CODE in the chunk below:

Code
crimes %>% filter(Primary.Type == "ARSON") %>% leaflet() %>% addTiles() %>% addMarkers(clusterOptions = addMarkers)
Assuming "Longitude" and "Latitude" are longitude and latitude, respectively
Code
summary(crimes$Primary.Type == "ARSON" & crimes$Description == "BY FIRE")
   Mode   FALSE    TRUE 
logical  267889     332 
Code
summary(crimes$Primary.Type == "ARSON" & crimes$Description == "BY EXPLOSIVE")
   Mode   FALSE    TRUE 
logical  268218       3 
Code
#332 by fire
#3 by explosive

Rubric:

  • Codes filtering the data works 3 pts

  • Map is produced 3 pts

  • Map with clusterOptions is produced 4 pts

d) (10 pts) How many crimes (observations) of the selected type ? How many have Description “BY FIRE”? How many have Description “BY EXPLOSIVE”

Answer(s): 444 ARSON, 332 BY FIRE, 3 BY EXPLOSIVE

Rubric:

  • State correct number of observation 4 pts

  • State correct number that have the Description “BY FIRE” 3 pts

  • State correct number that have Description “BY EXPLOSIVE” 3 pts

e) (10 pts) For the selected type crime, using the popup option add the Description value to appear on click on a markers on the map.

Hint: Use popup = ~as.charecter(Description)in addMarkers.

Write YOUR CODE in the chunk below:

Code
crimes %>% filter(Primary.Type == "ARSON") %>% leaflet() %>% addTiles() %>% addMarkers(popup = ~as.character(Description))
Assuming "Longitude" and "Latitude" are longitude and latitude, respectively
Code
#crimes %>% filter(Primary.Type == "ARSON") %>% leaflet() %>% addTiles() %>% addMarkers(clusterOptions = addMarkers, popup = ~as.character(Description))

#North is safer
  • From the map and the selected type of crime, can you state which part of the city is safe in a sense less crimes of this type occur?

Rubric:

  • Map is produced with correct data 3 pts

  • Map is produced with correct popup option 3 pts

  • Safer part of the city identified 4 pts

Task 2 Apple Products Data

The Apple data contains sales (in million) and revenues (in billion) about 4 Apple Inc. products, iPhone, iPad, Apple Watch, and Mac from 2017 to 2020. The file apple.Rdata contains data.frame object with 16 observation for 4 variables. Variables are Product, Year, Sales, and Revenue.

a) (10 pts) Load the date from the file using the load() function. How many observation in the data?

Write YOUR CODE in the chunk below:

Code
load(file = "C:/Users/dasha/Downloads/apple (1).Rdata")
#apple <- read.html("C:/Users/dasha/Downloads/apple.Rdata", header = TRUE)

View(apple)

#16 observations, 4 variables

Rubric:

  • Code executes 3 pts
  • The correct data is loaded in R 3 pts
  • Stated correct number of observations 4 pts

b) (10 pts) Filter the data so that iPhone product is excluded. Create new data frame called apple1.

Write YOUR CODE in the chunk below:

Code
apple1 <- apple %>% filter(Product != "iPhone")
View(apple1)
class(apple1)
[1] "data.frame"

Rubric:

  • Code executes 3 pts
  • The correct data is filtered 3 pts
  • The new data is created as data.frame 4 pts

c) (10 pts) Recreate the graph about the Apple Data, shown on the picture file listed in the project, using gvisBubbleChart() function by setting the idvar="Product", xvar="Revenue", colorvar="Year", and sizevar="Sales".

Write YOUR CODE in the chunk below:

Code
plot(gvisBubbleChart(apple1, idvar="Product", xvar="Revenue", colorvar="Year", sizevar="Sales"))

Rubric:

  • Code executes 3 pts
  • The graph about the apple1 data has only some element of the one provided 3 pts
  • The graph about the apple1 data has ALL element of the one provided 4 pts

d) (10 pts) Briefly discuss the pros and cons of the visualization in part c)

Generally data gives people the impression that what they are seeing is the truth, which it is but unfortunately it is only a partial truth. Much data is lost due to failure to report, negligence or any other variable has the potential to muddy the information we are looking at. Though this may be the case, depending on the quantity of data, I believe this is negligible. By using data we can make better decisions in the future based on what we know about the past i.e. the collected data. In the end we may misinterpret or oversimplify but we also have the ability to make better decisions and communicate more effectively such as the story I heard once about how statisticians were unable to do so in the past effectively which lead to catastrophe.

Rubric:

  • At least one relevant pros/cons are discussed 3 pts
  • At least two relevant pros are discussed 4 pts
  • At least two relevant cons are discussed 4 pts

e) (10 pts) Propose better visualization for the Apple Products Data

These apple charts don’t tell us very much information. It lacks essential information for those who would like to focus more on locations that produce the most revenue. Perhaps they would like to close a store because profits aren’t where they should be but using this data we wouldn’t know which locations to start with.