SQL_and_BigQuery_day1.ipynb

{"cells":[{"metadata":{},"cell_type":"markdown","source":"**[SQL Micro-Course Home Page](https://www.kaggle.com/learn/intro-to-sql)**\n\n---\n"},{"metadata":{},"cell_type":"markdown","source":"# Introduction\n\nThe first test of your new data exploration skills uses data describing crime in the city of Chicago.\n\nBefore you get started, run the following cell. It sets up the automated feedback system to review your answers."},{"metadata":{"trusted":true},"cell_type":"code","source":"# Set up feedack system\nfrom learntools.core import binder\nbinder.bind(globals())\nfrom learntools.sql.ex1 import *\nprint(\"Setup Complete\")","execution_count":1,"outputs":[{"output_type":"stream","text":"Using Kaggle's public dataset BigQuery integration.\nSetup Complete\n","name":"stdout"}]},{"metadata":{},"cell_type":"markdown","source":"Use the next code cell to fetch the dataset."},{"metadata":{"trusted":true},"cell_type":"code","source":"from google.cloud import bigquery\n\n# Create a \"Client\" object\nclient = bigquery.Client()\n\n# Construct a reference to the \"chicago_crime\" dataset\ndataset_ref = client.dataset(\"chicago_crime\", project=\"bigquery-public-data\")\n\n# API request - fetch the dataset\ndataset = client.get_dataset(dataset_ref)","execution_count":2,"outputs":[{"output_type":"stream","text":"Using Kaggle's public dataset BigQuery integration.\n","name":"stdout"}]},{"metadata":{},"cell_type":"markdown","source":"# Exercises\n\n### 1) Count tables in the dataset\n\nHow many tables are in the Chicago Crime dataset?"},{"metadata":{"trusted":true},"cell_type":"code","source":"# Write the code you need here to figure out the answer\ntables = list(client.list_tables(dataset))\ncount=0\nfor table in tables:\n    count+=1\n    print(table.table_id)\nprint(\"Number of tables: \"+str(count))","execution_count":3,"outputs":[{"output_type":"stream","text":"crime\nNumber of tables: 1\n","name":"stdout"}]},{"metadata":{"trusted":true},"cell_type":"code","source":"num_tables = count  # Store the answer as num_tables and then run this cell\n\nq_1.check()","execution_count":4,"outputs":[{"output_type":"display_data","data":{"text/plain":"<IPython.core.display.Javascript object>","application/javascript":"parent.postMessage({\"jupyterEvent\": \"custom.exercise_interaction\", \"data\": {\"outcomeType\": 1, \"valueTowardsCompletion\": 0.3333333333333333, \"interactionType\": 1, \"questionType\": 1, \"learnTutorialId\": 169, \"questionId\": \"1_CountTables\", \"learnToolsVersion\": \"0.3.1\", \"failureMessage\": \"\", \"exceptionClass\": \"\", \"trace\": \"\"}}, \"*\")"},"metadata":{}},{"output_type":"display_data","data":{"text/plain":"Correct","text/markdown":"<span style=\"color:#33cc33\">Correct</span>"},"metadata":{}}]},{"metadata":{},"cell_type":"markdown","source":"For a hint or the solution, uncomment the appropriate line below."},{"metadata":{"trusted":true},"cell_type":"code","source":"#q_1.hint()\n#q_1.solution()","execution_count":5,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"### 2) Explore the table schema\n\nHow many columns in the `crime` table have `TIMESTAMP` data?"},{"metadata":{"trusted":true},"cell_type":"code","source":"table_ref=dataset_ref.table(\"crime\")\ntable = client.get_table(table_ref)","execution_count":6,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"#table.schema","execution_count":9,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"#table.full_table_id","execution_count":10,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"\nschema_list=str(table.schema).split('SchemaField')\ncount=0\nfor el in schema_list:\n    if \"TIMESTAMP\" in el:\n        print(el)\n        count+=1\n\n# Write the code to figure out the answer","execution_count":11,"outputs":[{"output_type":"stream","text":"('date', 'TIMESTAMP', 'NULLABLE', 'Date when the incident occurred. this is sometimes a best estimate.', ()), \n('updated_on', 'TIMESTAMP', 'NULLABLE', 'Date and time the record was last updated.', ()), \n","name":"stdout"}]},{"metadata":{"trusted":true},"cell_type":"code","source":"client.list_rows(table,max_results=5).to_dataframe()","execution_count":12,"outputs":[{"output_type":"execute_result","execution_count":12,"data":{"text/plain":"   unique_key              ...                                     location\n0    11748878              ...                (41.988630807, -87.812829371)\n1    11743522              ...                (41.720384131, -87.538913442)\n2    11732912              ...                (41.976837868, -87.813193881)\n3    11727498              ...                (41.731285254, -87.597118182)\n4    11703749              ...                (41.806562372, -87.633298918)\n\n[5 rows x 22 columns]","text/html":"<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>unique_key</th>\n      <th>case_number</th>\n      <th>date</th>\n      <th>block</th>\n      <th>iucr</th>\n      <th>primary_type</th>\n      <th>description</th>\n      <th>location_description</th>\n      <th>arrest</th>\n      <th>domestic</th>\n      <th>beat</th>\n      <th>district</th>\n      <th>ward</th>\n      <th>community_area</th>\n      <th>fbi_code</th>\n      <th>x_coordinate</th>\n      <th>y_coordinate</th>\n      <th>year</th>\n      <th>updated_on</th>\n      <th>latitude</th>\n      <th>longitude</th>\n      <th>location</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>11748878</td>\n      <td>JC338140</td>\n      <td>2019-07-07 02:19:00+00:00</td>\n      <td>074XX W TALCOTT AVE</td>\n      <td>0520</td>\n      <td>ASSAULT</td>\n      <td>AGGRAVATED:KNIFE/CUTTING INSTR</td>\n      <td>HOSPITAL BUILDING/GROUNDS</td>\n      <td>False</td>\n      <td>False</td>\n      <td>1612</td>\n      <td>16</td>\n      <td>41</td>\n      <td>10</td>\n      <td>04A</td>\n      <td>1125755.0</td>\n      <td>1938877.0</td>\n      <td>2019</td>\n      <td>2019-07-19 16:09:50+00:00</td>\n      <td>41.988631</td>\n      <td>-87.812829</td>\n      <td>(41.988630807, -87.812829371)</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>11743522</td>\n      <td>JC331531</td>\n      <td>2019-07-02 12:00:00+00:00</td>\n      <td>096XX S AVENUE N</td>\n      <td>1153</td>\n      <td>DECEPTIVE PRACTICE</td>\n      <td>FINANCIAL IDENTITY THEFT OVER $ 300</td>\n      <td>OTHER</td>\n      <td>False</td>\n      <td>False</td>\n      <td>432</td>\n      <td>4</td>\n      <td>10</td>\n      <td>52</td>\n      <td>11</td>\n      <td>1201127.0</td>\n      <td>1841700.0</td>\n      <td>2019</td>\n      <td>2019-07-19 16:09:50+00:00</td>\n      <td>41.720384</td>\n      <td>-87.538913</td>\n      <td>(41.720384131, -87.538913442)</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>11732912</td>\n      <td>JC317309</td>\n      <td>2019-06-22 15:30:00+00:00</td>\n      <td>053XX N OSCEOLA AVE</td>\n      <td>0650</td>\n      <td>BURGLARY</td>\n      <td>HOME INVASION</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>False</td>\n      <td>1613</td>\n      <td>16</td>\n      <td>41</td>\n      <td>10</td>\n      <td>05</td>\n      <td>1125682.0</td>\n      <td>1934579.0</td>\n      <td>2019</td>\n      <td>2019-07-03 16:05:01+00:00</td>\n      <td>41.976838</td>\n      <td>-87.813194</td>\n      <td>(41.976837868, -87.813193881)</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>11727498</td>\n      <td>JC308462</td>\n      <td>2019-06-16 03:45:00+00:00</td>\n      <td>011XX E 90TH ST</td>\n      <td>0530</td>\n      <td>ASSAULT</td>\n      <td>AGGRAVATED: OTHER DANG WEAPON</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>True</td>\n      <td>413</td>\n      <td>4</td>\n      <td>8</td>\n      <td>47</td>\n      <td>04A</td>\n      <td>1185203.0</td>\n      <td>1845531.0</td>\n      <td>2019</td>\n      <td>2019-06-30 15:56:27+00:00</td>\n      <td>41.731285</td>\n      <td>-87.597118</td>\n      <td>(41.731285254, -87.597118182)</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>11703749</td>\n      <td>JC283177</td>\n      <td>2019-05-29 11:34:00+00:00</td>\n      <td>048XX S PRINCETON AVE</td>\n      <td>3731</td>\n      <td>INTERFERENCE WITH PUBLIC OFFICER</td>\n      <td>OBSTRUCTING IDENTIFICATION</td>\n      <td>STREET</td>\n      <td>True</td>\n      <td>False</td>\n      <td>935</td>\n      <td>9</td>\n      <td>3</td>\n      <td>37</td>\n      <td>24</td>\n      <td>1175104.0</td>\n      <td>1872879.0</td>\n      <td>2019</td>\n      <td>2019-06-30 15:56:27+00:00</td>\n      <td>41.806562</td>\n      <td>-87.633299</td>\n      <td>(41.806562372, -87.633298918)</td>\n    </tr>\n  </tbody>\n</table>\n</div>"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"num_timestamp_fields = count # Put your answer here\n\nq_2.check()","execution_count":13,"outputs":[{"output_type":"display_data","data":{"text/plain":"<IPython.core.display.Javascript object>","application/javascript":"parent.postMessage({\"jupyterEvent\": \"custom.exercise_interaction\", \"data\": {\"outcomeType\": 1, \"valueTowardsCompletion\": 0.3333333333333333, \"interactionType\": 1, \"questionType\": 1, \"learnTutorialId\": 169, \"questionId\": \"2_CountTimestampFields\", \"learnToolsVersion\": \"0.3.1\", \"failureMessage\": \"\", \"exceptionClass\": \"\", \"trace\": \"\"}}, \"*\")"},"metadata":{}},{"output_type":"display_data","data":{"text/plain":"Correct","text/markdown":"<span style=\"color:#33cc33\">Correct</span>"},"metadata":{}}]},{"metadata":{},"cell_type":"markdown","source":"For a hint or the solution, uncomment the appropriate line below."},{"metadata":{"trusted":true},"cell_type":"code","source":"#q_2.hint()\n#q_2.solution()","execution_count":14,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"### 3) Create a crime map\n\nIf you wanted to create a map with a dot at the location of each crime, what are the names of the two fields you likely need to pull out of the `crime` table to plot the crimes on a map?"},{"metadata":{"trusted":true},"cell_type":"code","source":"# Write the code here to explore the data so you can find the answer\n#table.schema\n\n\nschema_list=str(table.schema).split('SchemaField')\ncount=0\nfor el in schema_list:\n    if \"location\" in el:\n        print(el)\n        count+=1","execution_count":15,"outputs":[{"output_type":"stream","text":"('location_description', 'STRING', 'NULLABLE', 'Description of the location where the incident occurred.', ()), \n('x_coordinate', 'FLOAT', 'NULLABLE', 'The x coordinate of the location where the incident occurred in State Plane Illinois East NAD 1983 projection. This location is shifted from the actual location for partial redaction but falls on the same block.', ()), \n('y_coordinate', 'FLOAT', 'NULLABLE', 'The y coordinate of the location where the incident occurred in State Plane Illinois East NAD 1983 projection. This location is shifted from the actual location for partial redaction but falls on the same block.', ()), \n('latitude', 'FLOAT', 'NULLABLE', 'The latitude of the location where the incident occurred. This location is shifted from the actual location for partial redaction but falls on the same block.', ()), \n('longitude', 'FLOAT', 'NULLABLE', 'The longitude of the location where the incident occurred. This location is shifted from the actual location for partial redaction but falls on the same block.', ()), \n('location', 'STRING', 'NULLABLE', 'The location where the incident occurred in a format that allows for creation of maps and other geographic operations on this data portal. This location is shifted from the actual location for partial redaction but falls on the same block.', ())]\n","name":"stdout"}]},{"metadata":{"trusted":true},"cell_type":"code","source":"fields_for_plotting = ['latitude', 'longitude'] # Put your answers here\n\nq_3.check()","execution_count":16,"outputs":[{"output_type":"display_data","data":{"text/plain":"<IPython.core.display.Javascript object>","application/javascript":"parent.postMessage({\"jupyterEvent\": \"custom.exercise_interaction\", \"data\": {\"outcomeType\": 1, \"valueTowardsCompletion\": 0.3333333333333333, \"interactionType\": 1, \"questionType\": 2, \"learnTutorialId\": 169, \"questionId\": \"3_IdentifyFieldsForPlotting\", \"learnToolsVersion\": \"0.3.1\", \"failureMessage\": \"\", \"exceptionClass\": \"\", \"trace\": \"\"}}, \"*\")"},"metadata":{}},{"output_type":"display_data","data":{"text/plain":"Correct","text/markdown":"<span style=\"color:#33cc33\">Correct</span>"},"metadata":{}}]},{"metadata":{},"cell_type":"markdown","source":"For a hint or the solution, uncomment the appropriate line below."},{"metadata":{"trusted":true},"cell_type":"code","source":"q_3.hint()\n#q_3.solution()","execution_count":17,"outputs":[{"output_type":"display_data","data":{"text/plain":"<IPython.core.display.Javascript object>","application/javascript":"parent.postMessage({\"jupyterEvent\": \"custom.exercise_interaction\", \"data\": {\"interactionType\": 2, \"questionType\": 2, \"learnTutorialId\": 169, \"questionId\": \"3_IdentifyFieldsForPlotting\", \"learnToolsVersion\": \"0.3.1\", \"valueTowardsCompletion\": 0.0, \"failureMessage\": \"\", \"exceptionClass\": \"\", \"trace\": \"\", \"outcomeType\": 4}}, \"*\")"},"metadata":{}},{"output_type":"display_data","data":{"text/plain":"Hint: Look at the table schema.  There are a couple options, but two of the fields are things commonly used to plot on maps. Both are `'FLOAT'` types. Use quotes around the field names in your answer.","text/markdown":"<span style=\"color:#3366cc\">Hint:</span> Look at the table schema.  There are a couple options, but two of the fields are things commonly used to plot on maps. Both are `'FLOAT'` types. Use quotes around the field names in your answer."},"metadata":{}}]},{"metadata":{},"cell_type":"markdown","source":"Thinking about the question above, there are a few columns that appear to have geographic data. Look at a few values (with the `list_rows()` command) to see if you can determine their relationship.  Two columns will still be hard to interpret. But it should be obvious how the `location` column relates to `latitude` and `longitude`."},{"metadata":{"trusted":true},"cell_type":"code","source":"# Scratch space for your code\ntable.schema","execution_count":18,"outputs":[{"output_type":"execute_result","execution_count":18,"data":{"text/plain":"[SchemaField('unique_key', 'INTEGER', 'REQUIRED', 'Unique identifier for the record.', ()),\n SchemaField('case_number', 'STRING', 'NULLABLE', 'The Chicago Police Department RD Number (Records Division Number), which is unique to the incident.', ()),\n SchemaField('date', 'TIMESTAMP', 'NULLABLE', 'Date when the incident occurred. this is sometimes a best estimate.', ()),\n SchemaField('block', 'STRING', 'NULLABLE', 'The partially redacted address where the incident occurred, placing it on the same block as the actual address.', ()),\n SchemaField('iucr', 'STRING', 'NULLABLE', 'The Illinois Unifrom Crime Reporting code. This is directly linked to the Primary Type and Description. See the list of IUCR codes at https://data.cityofchicago.org/d/c7ck-438e.', ()),\n SchemaField('primary_type', 'STRING', 'NULLABLE', 'The primary description of the IUCR code.', ()),\n SchemaField('description', 'STRING', 'NULLABLE', 'The secondary description of the IUCR code, a subcategory of the primary description.', ()),\n SchemaField('location_description', 'STRING', 'NULLABLE', 'Description of the location where the incident occurred.', ()),\n SchemaField('arrest', 'BOOLEAN', 'NULLABLE', 'Indicates whether an arrest was made.', ()),\n SchemaField('domestic', 'BOOLEAN', 'NULLABLE', 'Indicates whether the incident was domestic-related as defined by the Illinois Domestic Violence Act.', ()),\n SchemaField('beat', 'INTEGER', 'NULLABLE', 'Indicates the beat where the incident occurred. A beat is the smallest police geographic area – each beat has a dedicated police beat car. Three to five beats make up a police sector, and three sectors make up a police district. The Chicago Police Department has 22 police districts. See the beats at https://data.cityofchicago.org/d/aerh-rz74.', ()),\n SchemaField('district', 'INTEGER', 'NULLABLE', 'Indicates the police district where the incident occurred. See the districts at https://data.cityofchicago.org/d/fthy-xz3r.', ()),\n SchemaField('ward', 'INTEGER', 'NULLABLE', 'The ward (City Council district) where the incident occurred. See the wards at https://data.cityofchicago.org/d/sp34-6z76.', ()),\n SchemaField('community_area', 'INTEGER', 'NULLABLE', 'Indicates the community area where the incident occurred. Chicago has 77 community areas. See the community areas at https://data.cityofchicago.org/d/cauq-8yn6.', ()),\n SchemaField('fbi_code', 'STRING', 'NULLABLE', \"Indicates the crime classification as outlined in the FBI's National Incident-Based Reporting System (NIBRS). See the Chicago Police Department listing of these classifications at http://gis.chicagopolice.org/clearmap_crime_sums/crime_types.html.\", ()),\n SchemaField('x_coordinate', 'FLOAT', 'NULLABLE', 'The x coordinate of the location where the incident occurred in State Plane Illinois East NAD 1983 projection. This location is shifted from the actual location for partial redaction but falls on the same block.', ()),\n SchemaField('y_coordinate', 'FLOAT', 'NULLABLE', 'The y coordinate of the location where the incident occurred in State Plane Illinois East NAD 1983 projection. This location is shifted from the actual location for partial redaction but falls on the same block.', ()),\n SchemaField('year', 'INTEGER', 'NULLABLE', 'Year the incident occurred.', ()),\n SchemaField('updated_on', 'TIMESTAMP', 'NULLABLE', 'Date and time the record was last updated.', ()),\n SchemaField('latitude', 'FLOAT', 'NULLABLE', 'The latitude of the location where the incident occurred. This location is shifted from the actual location for partial redaction but falls on the same block.', ()),\n SchemaField('longitude', 'FLOAT', 'NULLABLE', 'The longitude of the location where the incident occurred. This location is shifted from the actual location for partial redaction but falls on the same block.', ()),\n SchemaField('location', 'STRING', 'NULLABLE', 'The location where the incident occurred in a format that allows for creation of maps and other geographic operations on this data portal. This location is shifted from the actual location for partial redaction but falls on the same block.', ())]"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"# Keep going\n\nYou've looked at the schema, but you haven't yet done anything exciting with the data itself. Things get more interesting when you get to the data, so keep going to **[write your first SQL query](https://www.kaggle.com/dansbecker/select-from-where).**"},{"metadata":{"trusted":true},"cell_type":"code","source":"query = \"\"\"\n        SELECT *\n        FROM `bigquery-public-data.chicago_crime.crime`\n        WHERE primary_type = 'OTHER OFFENSE'\n        \"\"\"\n","execution_count":22,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"query_job = client.query(query)","execution_count":23,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"query_job.to_dataframe()","execution_count":24,"outputs":[{"output_type":"execute_result","execution_count":24,"data":{"text/plain":"        unique_key              ...                                     location\n0         11621752              ...                (41.725333082, -87.560788034)\n1         11537831              ...                (41.698422453, -87.696407536)\n2         11451616              ...                (41.816321863, -87.631189677)\n3         11271128              ...                (41.691488355, -87.706039378)\n4         10783424              ...                (41.691208967, -87.536489924)\n5         10747090              ...                (41.705505561, -87.669256116)\n6         10614688              ...                (41.752543758, -87.594298949)\n7         10462274              ...                (41.807582051, -87.714859276)\n8         10549582              ...                (41.715931826, -87.599421473)\n9         10337592              ...                (41.714750553, -87.670571084)\n10        10098277              ...                (41.736125788, -87.588112068)\n11        10018335              ...                (41.756550472, -87.592600053)\n12         9610309              ...                 (41.654238708, -87.59676674)\n13         9526305              ...                (41.716411135, -87.675872347)\n14         9399778              ...                (41.824588446, -87.631326836)\n15         9257801              ...                (41.985597456, -87.779195268)\n16         8999528              ...                (41.728740563, -87.596150779)\n17         8566982              ...                (41.923227755, -87.804395325)\n18         8527827              ...                 (41.69857756, -87.719874148)\n19         8388359              ...                (41.807785411, -87.730398475)\n20         8064567              ...                 (41.81326591, -87.632279516)\n21         7983418              ...                (41.975227612, -87.757002846)\n22         7909773              ...                (41.705677782, -87.600944364)\n23         7849501              ...                (41.742469462, -87.579101665)\n24         7661386              ...                (41.715094689, -87.665546012)\n25         7284204              ...                (41.989368487, -87.748323095)\n26         7173947              ...                 (41.80140784, -87.633171645)\n27         7157616              ...                 (41.806990411, -87.73212985)\n28         7019778              ...                  (41.970201736, -87.7627994)\n29         6994279              ...                (41.744075903, -87.596173259)\n...            ...              ...                                          ...\n430132     4089382              ...                (41.985610724, -87.663307609)\n430133     2731927              ...                (41.987296026, -87.658684774)\n430134    10125915              ...                (41.988719229, -87.668384208)\n430135     4201250              ...                (41.991332957, -87.658255906)\n430136     3524236              ...                (41.985500167, -87.657089031)\n430137     7338235              ...                (41.980694358, -87.655106025)\n430138     8270707              ...                  (41.9949222, -87.671899002)\n430139     8731845              ...                 (41.997085606, -87.65560155)\n430140     9475465              ...                (41.980801586, -87.656535579)\n430141     2370745              ...                                         None\n430142     9702697              ...                (41.976413776, -87.653776017)\n430143     7860141              ...                (41.985444962, -87.668307937)\n430144    11680432              ...                (41.983644767, -87.658899869)\n430145     4561795              ...                (41.993270673, -87.656911137)\n430146     8844954              ...                 (41.990787778, -87.67065803)\n430147     8651462              ...                (41.995520617, -87.662942483)\n430148     7560419              ...                (41.982701983, -87.660042636)\n430149    11448146              ...                 (41.997085606, -87.65560155)\n430150     9384890              ...                (41.985443518, -87.668532319)\n430151     8060658              ...                (41.989559532, -87.674672842)\n430152     8668011              ...                 (41.99358583, -87.663860367)\n430153     8340550              ...                (41.991335662, -87.656850699)\n430154     9012324              ...                 (41.986334537, -87.66602188)\n430155     3315344              ...                (41.986255626, -87.661432329)\n430156     8425555              ...                (41.993946967, -87.660387637)\n430157     4140966              ...                 (41.987970689, -87.65675023)\n430158    10328057              ...                (41.990514817, -87.655399054)\n430159     9807863              ...                (41.977055144, -87.656431821)\n430160     7054126              ...                (41.986186619, -87.656691879)\n430161     3691914              ...                (41.997204204, -87.661773344)\n\n[430162 rows x 22 columns]","text/html":"<div>\n<style scoped>\n    .dataframe tbody tr th:only-of-type {\n        vertical-align: middle;\n    }\n\n    .dataframe tbody tr th {\n        vertical-align: top;\n    }\n\n    .dataframe thead th {\n        text-align: right;\n    }\n</style>\n<table border=\"1\" class=\"dataframe\">\n  <thead>\n    <tr style=\"text-align: right;\">\n      <th></th>\n      <th>unique_key</th>\n      <th>case_number</th>\n      <th>date</th>\n      <th>block</th>\n      <th>iucr</th>\n      <th>primary_type</th>\n      <th>description</th>\n      <th>location_description</th>\n      <th>arrest</th>\n      <th>domestic</th>\n      <th>beat</th>\n      <th>district</th>\n      <th>ward</th>\n      <th>community_area</th>\n      <th>fbi_code</th>\n      <th>x_coordinate</th>\n      <th>y_coordinate</th>\n      <th>year</th>\n      <th>updated_on</th>\n      <th>latitude</th>\n      <th>longitude</th>\n      <th>location</th>\n    </tr>\n  </thead>\n  <tbody>\n    <tr>\n      <th>0</th>\n      <td>11621752</td>\n      <td>JC183956</td>\n      <td>2019-03-11 09:10:00+00:00</td>\n      <td>093XX S COLFAX AVE</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>OTHER</td>\n      <td>False</td>\n      <td>False</td>\n      <td>423</td>\n      <td>4.0</td>\n      <td>7.0</td>\n      <td>48.0</td>\n      <td>26</td>\n      <td>1195139.0</td>\n      <td>1843449.0</td>\n      <td>2019</td>\n      <td>2019-03-18 16:18:01+00:00</td>\n      <td>41.725333</td>\n      <td>-87.560788</td>\n      <td>(41.725333082, -87.560788034)</td>\n    </tr>\n    <tr>\n      <th>1</th>\n      <td>11537831</td>\n      <td>JB556618</td>\n      <td>2018-12-17 08:02:00+00:00</td>\n      <td>107XX S SACRAMENTO AVE</td>\n      <td>4388</td>\n      <td>OTHER OFFENSE</td>\n      <td>VIO BAIL BOND: DOM VIOLENCE</td>\n      <td>RESIDENCE-GARAGE</td>\n      <td>True</td>\n      <td>True</td>\n      <td>2211</td>\n      <td>22.0</td>\n      <td>19.0</td>\n      <td>74.0</td>\n      <td>26</td>\n      <td>1158190.0</td>\n      <td>1833340.0</td>\n      <td>2018</td>\n      <td>2018-12-24 16:07:53+00:00</td>\n      <td>41.698422</td>\n      <td>-87.696408</td>\n      <td>(41.698422453, -87.696407536)</td>\n    </tr>\n    <tr>\n      <th>2</th>\n      <td>11451616</td>\n      <td>JB435676</td>\n      <td>2018-09-14 19:14:00+00:00</td>\n      <td>043XX S WENTWORTH AVE</td>\n      <td>5011</td>\n      <td>OTHER OFFENSE</td>\n      <td>LICENSE VIOLATION</td>\n      <td>GAS STATION</td>\n      <td>False</td>\n      <td>False</td>\n      <td>925</td>\n      <td>9.0</td>\n      <td>3.0</td>\n      <td>37.0</td>\n      <td>26</td>\n      <td>1175650.0</td>\n      <td>1876440.0</td>\n      <td>2018</td>\n      <td>2018-09-26 16:12:46+00:00</td>\n      <td>41.816322</td>\n      <td>-87.631190</td>\n      <td>(41.816321863, -87.631189677)</td>\n    </tr>\n    <tr>\n      <th>3</th>\n      <td>11271128</td>\n      <td>JB205126</td>\n      <td>2018-03-21 19:48:00+00:00</td>\n      <td>034XX W 111TH ST</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>True</td>\n      <td>2211</td>\n      <td>22.0</td>\n      <td>19.0</td>\n      <td>74.0</td>\n      <td>26</td>\n      <td>1155578.0</td>\n      <td>1830794.0</td>\n      <td>2018</td>\n      <td>2018-05-04 15:51:04+00:00</td>\n      <td>41.691488</td>\n      <td>-87.706039</td>\n      <td>(41.691488355, -87.706039378)</td>\n    </tr>\n    <tr>\n      <th>4</th>\n      <td>10783424</td>\n      <td>HZ551122</td>\n      <td>2016-12-13 21:23:00+00:00</td>\n      <td>112XX S AVENUE L</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>True</td>\n      <td>433</td>\n      <td>4.0</td>\n      <td>10.0</td>\n      <td>52.0</td>\n      <td>26</td>\n      <td>1201887.0</td>\n      <td>1831075.0</td>\n      <td>2016</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.691209</td>\n      <td>-87.536490</td>\n      <td>(41.691208967, -87.536489924)</td>\n    </tr>\n    <tr>\n      <th>5</th>\n      <td>10747090</td>\n      <td>HZ508308</td>\n      <td>2016-11-08 13:57:00+00:00</td>\n      <td>103XX S WALDEN PKWY</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2212</td>\n      <td>22.0</td>\n      <td>19.0</td>\n      <td>72.0</td>\n      <td>26</td>\n      <td>1165585.0</td>\n      <td>1835977.0</td>\n      <td>2016</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.705506</td>\n      <td>-87.669256</td>\n      <td>(41.705505561, -87.669256116)</td>\n    </tr>\n    <tr>\n      <th>6</th>\n      <td>10614688</td>\n      <td>HZ367475</td>\n      <td>2016-07-27 00:01:00+00:00</td>\n      <td>078XX S AVALON AVE</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>False</td>\n      <td>411</td>\n      <td>4.0</td>\n      <td>8.0</td>\n      <td>45.0</td>\n      <td>26</td>\n      <td>1185906.0</td>\n      <td>1853284.0</td>\n      <td>2016</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.752544</td>\n      <td>-87.594299</td>\n      <td>(41.752543758, -87.594298949)</td>\n    </tr>\n    <tr>\n      <th>7</th>\n      <td>10462274</td>\n      <td>HZ201217</td>\n      <td>2016-03-25 20:51:00+00:00</td>\n      <td>047XX S ARCHER AVE</td>\n      <td>4625</td>\n      <td>OTHER OFFENSE</td>\n      <td>PAROLE VIOLATION</td>\n      <td>STREET</td>\n      <td>True</td>\n      <td>False</td>\n      <td>821</td>\n      <td>8.0</td>\n      <td>14.0</td>\n      <td>57.0</td>\n      <td>26</td>\n      <td>1152865.0</td>\n      <td>1873080.0</td>\n      <td>2016</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.807582</td>\n      <td>-87.714859</td>\n      <td>(41.807582051, -87.714859276)</td>\n    </tr>\n    <tr>\n      <th>8</th>\n      <td>10549582</td>\n      <td>HZ296078</td>\n      <td>2016-03-01 00:00:00+00:00</td>\n      <td>098XX S ELLIS AVE</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>APARTMENT</td>\n      <td>False</td>\n      <td>True</td>\n      <td>511</td>\n      <td>5.0</td>\n      <td>8.0</td>\n      <td>50.0</td>\n      <td>26</td>\n      <td>1184622.0</td>\n      <td>1839931.0</td>\n      <td>2016</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.715932</td>\n      <td>-87.599421</td>\n      <td>(41.715931826, -87.599421473)</td>\n    </tr>\n    <tr>\n      <th>9</th>\n      <td>10337592</td>\n      <td>HY528675</td>\n      <td>2015-12-07 20:25:00+00:00</td>\n      <td>098XX S WINCHESTER AVE</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>CHURCH/SYNAGOGUE/PLACE OF WORSHIP</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2213</td>\n      <td>22.0</td>\n      <td>19.0</td>\n      <td>72.0</td>\n      <td>26</td>\n      <td>1165200.0</td>\n      <td>1839343.0</td>\n      <td>2015</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.714751</td>\n      <td>-87.670571</td>\n      <td>(41.714750553, -87.670571084)</td>\n    </tr>\n    <tr>\n      <th>10</th>\n      <td>10098277</td>\n      <td>HY286422</td>\n      <td>2015-06-03 15:30:00+00:00</td>\n      <td>087XX S BLACKSTONE AVE</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>True</td>\n      <td>412</td>\n      <td>4.0</td>\n      <td>8.0</td>\n      <td>48.0</td>\n      <td>26</td>\n      <td>1187646.0</td>\n      <td>1847316.0</td>\n      <td>2015</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.736126</td>\n      <td>-87.588112</td>\n      <td>(41.736125788, -87.588112068)</td>\n    </tr>\n    <tr>\n      <th>11</th>\n      <td>10018335</td>\n      <td>HY207476</td>\n      <td>2015-04-02 10:45:00+00:00</td>\n      <td>076XX S SOUTH CHICAGO AVE</td>\n      <td>4625</td>\n      <td>OTHER OFFENSE</td>\n      <td>PAROLE VIOLATION</td>\n      <td>STREET</td>\n      <td>True</td>\n      <td>False</td>\n      <td>411</td>\n      <td>4.0</td>\n      <td>5.0</td>\n      <td>45.0</td>\n      <td>26</td>\n      <td>1186357.0</td>\n      <td>1854748.0</td>\n      <td>2015</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.756550</td>\n      <td>-87.592600</td>\n      <td>(41.756550472, -87.592600053)</td>\n    </tr>\n    <tr>\n      <th>12</th>\n      <td>9610309</td>\n      <td>HX260673</td>\n      <td>2014-05-13 21:53:00+00:00</td>\n      <td>132XX S ELLIS AVE</td>\n      <td>502P</td>\n      <td>OTHER OFFENSE</td>\n      <td>FALSE/STOLEN/ALTERED TRP</td>\n      <td>STREET</td>\n      <td>True</td>\n      <td>False</td>\n      <td>533</td>\n      <td>5.0</td>\n      <td>9.0</td>\n      <td>54.0</td>\n      <td>26</td>\n      <td>1185539.0</td>\n      <td>1817457.0</td>\n      <td>2014</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.654239</td>\n      <td>-87.596767</td>\n      <td>(41.654238708, -87.59676674)</td>\n    </tr>\n    <tr>\n      <th>13</th>\n      <td>9526305</td>\n      <td>HX180654</td>\n      <td>2014-02-07 08:00:00+00:00</td>\n      <td>097XX S HAMILTON AVE</td>\n      <td>5000</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER CRIME AGAINST PERSON</td>\n      <td>OTHER</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2213</td>\n      <td>22.0</td>\n      <td>19.0</td>\n      <td>72.0</td>\n      <td>26</td>\n      <td>1163748.0</td>\n      <td>1839937.0</td>\n      <td>2014</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.716411</td>\n      <td>-87.675872</td>\n      <td>(41.716411135, -87.675872347)</td>\n    </tr>\n    <tr>\n      <th>14</th>\n      <td>9399778</td>\n      <td>HW542499</td>\n      <td>2013-10-16 00:00:00+00:00</td>\n      <td>038XX S WENTWORTH AVE</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>APARTMENT</td>\n      <td>False</td>\n      <td>True</td>\n      <td>915</td>\n      <td>9.0</td>\n      <td>3.0</td>\n      <td>34.0</td>\n      <td>26</td>\n      <td>1175588.0</td>\n      <td>1879452.0</td>\n      <td>2013</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.824588</td>\n      <td>-87.631327</td>\n      <td>(41.824588446, -87.631326836)</td>\n    </tr>\n    <tr>\n      <th>15</th>\n      <td>9257801</td>\n      <td>HW403268</td>\n      <td>2013-08-11 14:53:00+00:00</td>\n      <td>057XX N MC VICKER AVE</td>\n      <td>5000</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER CRIME AGAINST PERSON</td>\n      <td>APARTMENT</td>\n      <td>False</td>\n      <td>False</td>\n      <td>1622</td>\n      <td>16.0</td>\n      <td>45.0</td>\n      <td>10.0</td>\n      <td>26</td>\n      <td>1134906.0</td>\n      <td>1937829.0</td>\n      <td>2013</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.985597</td>\n      <td>-87.779195</td>\n      <td>(41.985597456, -87.779195268)</td>\n    </tr>\n    <tr>\n      <th>16</th>\n      <td>8999528</td>\n      <td>HW146423</td>\n      <td>2013-02-05 19:20:00+00:00</td>\n      <td>091XX S UNIVERSITY AVE</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>SCHOOL, PUBLIC, BUILDING</td>\n      <td>False</td>\n      <td>False</td>\n      <td>413</td>\n      <td>4.0</td>\n      <td>8.0</td>\n      <td>47.0</td>\n      <td>26</td>\n      <td>1185475.0</td>\n      <td>1844606.0</td>\n      <td>2013</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.728741</td>\n      <td>-87.596151</td>\n      <td>(41.728740563, -87.596150779)</td>\n    </tr>\n    <tr>\n      <th>17</th>\n      <td>8566982</td>\n      <td>HV241779</td>\n      <td>2012-04-14 12:15:00+00:00</td>\n      <td>023XX N NEVA AVE</td>\n      <td>5008</td>\n      <td>OTHER OFFENSE</td>\n      <td>FIREARM REGISTRATION VIOLATION</td>\n      <td>OTHER</td>\n      <td>True</td>\n      <td>False</td>\n      <td>2512</td>\n      <td>25.0</td>\n      <td>36.0</td>\n      <td>18.0</td>\n      <td>26</td>\n      <td>1128195.0</td>\n      <td>1915058.0</td>\n      <td>2012</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.923228</td>\n      <td>-87.804395</td>\n      <td>(41.923227755, -87.804395325)</td>\n    </tr>\n    <tr>\n      <th>18</th>\n      <td>8527827</td>\n      <td>HV205113</td>\n      <td>2012-03-15 00:49:00+00:00</td>\n      <td>039XX W 107TH ST</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2211</td>\n      <td>22.0</td>\n      <td>19.0</td>\n      <td>74.0</td>\n      <td>26</td>\n      <td>1151781.0</td>\n      <td>1833350.0</td>\n      <td>2012</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.698578</td>\n      <td>-87.719874</td>\n      <td>(41.69857756, -87.719874148)</td>\n    </tr>\n    <tr>\n      <th>19</th>\n      <td>8388359</td>\n      <td>HT614534</td>\n      <td>2011-12-01 19:00:00+00:00</td>\n      <td>042XX W 47TH ST</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>SCHOOL, PRIVATE, GROUNDS</td>\n      <td>False</td>\n      <td>False</td>\n      <td>815</td>\n      <td>8.0</td>\n      <td>14.0</td>\n      <td>57.0</td>\n      <td>26</td>\n      <td>1148628.0</td>\n      <td>1873124.0</td>\n      <td>2011</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.807785</td>\n      <td>-87.730398</td>\n      <td>(41.807785411, -87.730398475)</td>\n    </tr>\n    <tr>\n      <th>20</th>\n      <td>8064567</td>\n      <td>HT296450</td>\n      <td>2011-05-14 23:23:00+00:00</td>\n      <td>044XX S WELLS ST</td>\n      <td>4650</td>\n      <td>OTHER OFFENSE</td>\n      <td>SEX OFFENDER: FAIL TO REGISTER</td>\n      <td>APARTMENT</td>\n      <td>True</td>\n      <td>False</td>\n      <td>935</td>\n      <td>9.0</td>\n      <td>3.0</td>\n      <td>37.0</td>\n      <td>26</td>\n      <td>1175362.0</td>\n      <td>1875324.0</td>\n      <td>2011</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.813266</td>\n      <td>-87.632280</td>\n      <td>(41.81326591, -87.632279516)</td>\n    </tr>\n    <tr>\n      <th>21</th>\n      <td>7983418</td>\n      <td>HT215346</td>\n      <td>2011-03-22 16:25:00+00:00</td>\n      <td>051XX W FOSTER AVE</td>\n      <td>501A</td>\n      <td>OTHER OFFENSE</td>\n      <td>ANIMAL ABUSE/NEGLECT</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>False</td>\n      <td>1623</td>\n      <td>16.0</td>\n      <td>45.0</td>\n      <td>11.0</td>\n      <td>26</td>\n      <td>1140965.0</td>\n      <td>1934090.0</td>\n      <td>2011</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.975228</td>\n      <td>-87.757003</td>\n      <td>(41.975227612, -87.757002846)</td>\n    </tr>\n    <tr>\n      <th>22</th>\n      <td>7909773</td>\n      <td>HT139388</td>\n      <td>2011-01-27 20:59:00+00:00</td>\n      <td>009XX E 104TH ST</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>APARTMENT</td>\n      <td>False</td>\n      <td>False</td>\n      <td>512</td>\n      <td>5.0</td>\n      <td>9.0</td>\n      <td>50.0</td>\n      <td>26</td>\n      <td>1184238.0</td>\n      <td>1836191.0</td>\n      <td>2011</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.705678</td>\n      <td>-87.600944</td>\n      <td>(41.705677782, -87.600944364)</td>\n    </tr>\n    <tr>\n      <th>23</th>\n      <td>7849501</td>\n      <td>HS662632</td>\n      <td>2010-12-01 15:00:00+00:00</td>\n      <td>018XX E 84TH ST</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>APARTMENT</td>\n      <td>False</td>\n      <td>True</td>\n      <td>412</td>\n      <td>4.0</td>\n      <td>8.0</td>\n      <td>45.0</td>\n      <td>26</td>\n      <td>1190085.0</td>\n      <td>1849649.0</td>\n      <td>2010</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.742469</td>\n      <td>-87.579102</td>\n      <td>(41.742469462, -87.579101665)</td>\n    </tr>\n    <tr>\n      <th>24</th>\n      <td>7661386</td>\n      <td>HS463895</td>\n      <td>2010-08-14 13:53:00+00:00</td>\n      <td>098XX S VANDERPOEL AVE</td>\n      <td>2826</td>\n      <td>OTHER OFFENSE</td>\n      <td>HARASSMENT BY ELECTRONIC MEANS</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2213</td>\n      <td>22.0</td>\n      <td>19.0</td>\n      <td>72.0</td>\n      <td>26</td>\n      <td>1166571.0</td>\n      <td>1839479.0</td>\n      <td>2010</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.715095</td>\n      <td>-87.665546</td>\n      <td>(41.715094689, -87.665546012)</td>\n    </tr>\n    <tr>\n      <th>25</th>\n      <td>7284204</td>\n      <td>HR700473</td>\n      <td>2009-12-21 19:10:00+00:00</td>\n      <td>059XX N CICERO AVE</td>\n      <td>5007</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER WEAPONS VIOLATION</td>\n      <td>STREET</td>\n      <td>True</td>\n      <td>False</td>\n      <td>1711</td>\n      <td>17.0</td>\n      <td>39.0</td>\n      <td>12.0</td>\n      <td>26</td>\n      <td>1143290.0</td>\n      <td>1939259.0</td>\n      <td>2009</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.989368</td>\n      <td>-87.748323</td>\n      <td>(41.989368487, -87.748323095)</td>\n    </tr>\n    <tr>\n      <th>26</th>\n      <td>7173947</td>\n      <td>HR576604</td>\n      <td>2009-10-07 21:00:00+00:00</td>\n      <td>051XX S PRINCETON AVE</td>\n      <td>5007</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER WEAPONS VIOLATION</td>\n      <td>SIDEWALK</td>\n      <td>False</td>\n      <td>False</td>\n      <td>934</td>\n      <td>9.0</td>\n      <td>3.0</td>\n      <td>37.0</td>\n      <td>26</td>\n      <td>1175154.0</td>\n      <td>1871001.0</td>\n      <td>2009</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.801408</td>\n      <td>-87.633172</td>\n      <td>(41.80140784, -87.633171645)</td>\n    </tr>\n    <tr>\n      <th>27</th>\n      <td>7157616</td>\n      <td>HR566464</td>\n      <td>2009-10-01 21:10:00+00:00</td>\n      <td>047XX S KOLIN AVE</td>\n      <td>5007</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER WEAPONS VIOLATION</td>\n      <td>SIDEWALK</td>\n      <td>True</td>\n      <td>False</td>\n      <td>815</td>\n      <td>8.0</td>\n      <td>23.0</td>\n      <td>57.0</td>\n      <td>26</td>\n      <td>1148158.0</td>\n      <td>1872831.0</td>\n      <td>2009</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.806990</td>\n      <td>-87.732130</td>\n      <td>(41.806990411, -87.73212985)</td>\n    </tr>\n    <tr>\n      <th>28</th>\n      <td>7019778</td>\n      <td>HR424019</td>\n      <td>2009-07-11 20:43:00+00:00</td>\n      <td>049XX N MILWAUKEE AVE</td>\n      <td>5007</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER WEAPONS VIOLATION</td>\n      <td>PARKING LOT/GARAGE(NON.RESID.)</td>\n      <td>True</td>\n      <td>False</td>\n      <td>1623</td>\n      <td>16.0</td>\n      <td>45.0</td>\n      <td>11.0</td>\n      <td>26</td>\n      <td>1139401.0</td>\n      <td>1932248.0</td>\n      <td>2009</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.970202</td>\n      <td>-87.762799</td>\n      <td>(41.970201736, -87.7627994)</td>\n    </tr>\n    <tr>\n      <th>29</th>\n      <td>6994279</td>\n      <td>HR400688</td>\n      <td>2009-06-28 20:00:00+00:00</td>\n      <td>011XX E 83RD ST</td>\n      <td>2830</td>\n      <td>OTHER OFFENSE</td>\n      <td>OBSCENE TELEPHONE CALLS</td>\n      <td>RESIDENCE</td>\n      <td>False</td>\n      <td>False</td>\n      <td>412</td>\n      <td>4.0</td>\n      <td>8.0</td>\n      <td>45.0</td>\n      <td>17</td>\n      <td>1185421.0</td>\n      <td>1850194.0</td>\n      <td>2009</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.744076</td>\n      <td>-87.596173</td>\n      <td>(41.744075903, -87.596173259)</td>\n    </tr>\n    <tr>\n      <th>...</th>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n      <td>...</td>\n    </tr>\n    <tr>\n      <th>430132</th>\n      <td>4089382</td>\n      <td>HL427387</td>\n      <td>2005-06-17 12:00:00+00:00</td>\n      <td>057XX N RIDGE AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2013</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1166413.0</td>\n      <td>1938059.0</td>\n      <td>2005</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.985611</td>\n      <td>-87.663308</td>\n      <td>(41.985610724, -87.663307609)</td>\n    </tr>\n    <tr>\n      <th>430133</th>\n      <td>2731927</td>\n      <td>HJ366343</td>\n      <td>2003-05-16 03:30:00+00:00</td>\n      <td>011XX W ARDMORE AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2022</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1167665.0</td>\n      <td>1938683.0</td>\n      <td>2003</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.987296</td>\n      <td>-87.658685</td>\n      <td>(41.987296026, -87.658684774)</td>\n    </tr>\n    <tr>\n      <th>430134</th>\n      <td>10125915</td>\n      <td>HY314237</td>\n      <td>2015-06-22 18:00:00+00:00</td>\n      <td>058XX N RIDGE AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2013</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1165024.0</td>\n      <td>1939181.0</td>\n      <td>2015</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.988719</td>\n      <td>-87.668384</td>\n      <td>(41.988719229, -87.668384208)</td>\n    </tr>\n    <tr>\n      <th>430135</th>\n      <td>4201250</td>\n      <td>HL527594</td>\n      <td>2005-04-28 12:00:00+00:00</td>\n      <td>060XX N WINTHROP AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1167770.0</td>\n      <td>1940155.0</td>\n      <td>2005</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.991333</td>\n      <td>-87.658256</td>\n      <td>(41.991332957, -87.658255906)</td>\n    </tr>\n    <tr>\n      <th>430136</th>\n      <td>3524236</td>\n      <td>HK602559</td>\n      <td>2004-09-04 09:30:00+00:00</td>\n      <td>010XX W HOLLYWOOD AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2022</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168104.0</td>\n      <td>1938032.0</td>\n      <td>2004</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.985500</td>\n      <td>-87.657089</td>\n      <td>(41.985500167, -87.657089031)</td>\n    </tr>\n    <tr>\n      <th>430137</th>\n      <td>7338235</td>\n      <td>HS139968</td>\n      <td>2010-01-27 18:24:27+00:00</td>\n      <td>054XX N SHERIDAN RD</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>True</td>\n      <td>False</td>\n      <td>2023</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168657.0</td>\n      <td>1936285.0</td>\n      <td>2010</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.980694</td>\n      <td>-87.655106</td>\n      <td>(41.980694358, -87.655106025)</td>\n    </tr>\n    <tr>\n      <th>430138</th>\n      <td>8270707</td>\n      <td>HT504467</td>\n      <td>2011-09-15 16:00:00+00:00</td>\n      <td>062XX N PAULINA ST</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>True</td>\n      <td>False</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>40.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1164051.0</td>\n      <td>1941434.0</td>\n      <td>2011</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.994922</td>\n      <td>-87.671899</td>\n      <td>(41.9949222, -87.671899002)</td>\n    </tr>\n    <tr>\n      <th>430139</th>\n      <td>8731845</td>\n      <td>HV408075</td>\n      <td>2012-07-30 16:00:00+00:00</td>\n      <td>063XX N SHERIDAN RD</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>RESIDENCE-GARAGE</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>49.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168475.0</td>\n      <td>1942257.0</td>\n      <td>2012</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.997086</td>\n      <td>-87.655602</td>\n      <td>(41.997085606, -87.65560155)</td>\n    </tr>\n    <tr>\n      <th>430140</th>\n      <td>9475465</td>\n      <td>HX128960</td>\n      <td>2014-01-26 09:30:00+00:00</td>\n      <td>054XX N KENMORE AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>True</td>\n      <td>False</td>\n      <td>2023</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168268.0</td>\n      <td>1936321.0</td>\n      <td>2014</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.980802</td>\n      <td>-87.656536</td>\n      <td>(41.980801586, -87.656535579)</td>\n    </tr>\n    <tr>\n      <th>430141</th>\n      <td>2370745</td>\n      <td>HH676705</td>\n      <td>2002-09-27 18:00:00+00:00</td>\n      <td>061XX N CLARK ST</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>OTHER</td>\n      <td>True</td>\n      <td>False</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>40.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>2002</td>\n      <td>2015-08-17 15:03:40+00:00</td>\n      <td>NaN</td>\n      <td>NaN</td>\n      <td>None</td>\n    </tr>\n    <tr>\n      <th>430142</th>\n      <td>9702697</td>\n      <td>HX349522</td>\n      <td>2014-07-17 21:33:00+00:00</td>\n      <td>009XX W FOSTER AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2023</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1169031.0</td>\n      <td>1934728.0</td>\n      <td>2014</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.976414</td>\n      <td>-87.653776</td>\n      <td>(41.976413776, -87.653776017)</td>\n    </tr>\n    <tr>\n      <th>430143</th>\n      <td>7860141</td>\n      <td>HS669397</td>\n      <td>2010-12-01 09:00:00+00:00</td>\n      <td>015XX W HOLLYWOOD AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>OTHER</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2013</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1165054.0</td>\n      <td>1937988.0</td>\n      <td>2010</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.985445</td>\n      <td>-87.668308</td>\n      <td>(41.985444962, -87.668307937)</td>\n    </tr>\n    <tr>\n      <th>430144</th>\n      <td>11680432</td>\n      <td>JC254908</td>\n      <td>2019-05-08 12:38:00+00:00</td>\n      <td>011XX W BRYN MAWR AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>True</td>\n      <td>False</td>\n      <td>2023</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1167617.0</td>\n      <td>1937352.0</td>\n      <td>2019</td>\n      <td>2019-05-15 16:22:34+00:00</td>\n      <td>41.983645</td>\n      <td>-87.658900</td>\n      <td>(41.983644767, -87.658899869)</td>\n    </tr>\n    <tr>\n      <th>430145</th>\n      <td>4561795</td>\n      <td>HM151945</td>\n      <td>2006-01-20 16:00:00+00:00</td>\n      <td>061XX N KENMORE AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>True</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168130.0</td>\n      <td>1940864.0</td>\n      <td>2006</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.993271</td>\n      <td>-87.656911</td>\n      <td>(41.993270673, -87.656911137)</td>\n    </tr>\n    <tr>\n      <th>430146</th>\n      <td>8844954</td>\n      <td>HV518514</td>\n      <td>2012-10-14 03:00:00+00:00</td>\n      <td>016XX W PETERSON AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>True</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>40.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1164400.0</td>\n      <td>1939930.0</td>\n      <td>2012</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.990788</td>\n      <td>-87.670658</td>\n      <td>(41.990787778, -87.67065803)</td>\n    </tr>\n    <tr>\n      <th>430147</th>\n      <td>8651462</td>\n      <td>HV326829</td>\n      <td>2012-06-09 14:30:00+00:00</td>\n      <td>062XX N LAKEWOOD AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>True</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1166484.0</td>\n      <td>1941671.0</td>\n      <td>2012</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.995521</td>\n      <td>-87.662942</td>\n      <td>(41.995520617, -87.662942483)</td>\n    </tr>\n    <tr>\n      <th>430148</th>\n      <td>7560419</td>\n      <td>HS359475</td>\n      <td>2010-06-14 12:00:00+00:00</td>\n      <td>055XX N BROADWAY</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>PARKING LOT/GARAGE(NON.RESID.)</td>\n      <td>False</td>\n      <td>True</td>\n      <td>2023</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1167309.0</td>\n      <td>1937006.0</td>\n      <td>2010</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.982702</td>\n      <td>-87.660043</td>\n      <td>(41.982701983, -87.660042636)</td>\n    </tr>\n    <tr>\n      <th>430149</th>\n      <td>11448146</td>\n      <td>JB437957</td>\n      <td>2018-09-15 12:00:00+00:00</td>\n      <td>063XX N SHERIDAN RD</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>RESIDENCE-GARAGE</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>49.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168475.0</td>\n      <td>1942257.0</td>\n      <td>2018</td>\n      <td>2018-09-22 16:01:14+00:00</td>\n      <td>41.997086</td>\n      <td>-87.655602</td>\n      <td>(41.997085606, -87.65560155)</td>\n    </tr>\n    <tr>\n      <th>430150</th>\n      <td>9384890</td>\n      <td>HW528364</td>\n      <td>2013-11-09 09:00:00+00:00</td>\n      <td>015XX W HOLLYWOOD AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2013</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1164993.0</td>\n      <td>1937987.0</td>\n      <td>2013</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.985444</td>\n      <td>-87.668532</td>\n      <td>(41.985443518, -87.668532319)</td>\n    </tr>\n    <tr>\n      <th>430151</th>\n      <td>8060658</td>\n      <td>HT288558</td>\n      <td>2011-05-10 09:45:00+00:00</td>\n      <td>059XX N RAVENSWOOD AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>PARKING LOT/GARAGE(NON.RESID.)</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2012</td>\n      <td>20.0</td>\n      <td>40.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1163312.0</td>\n      <td>1939474.0</td>\n      <td>2011</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.989560</td>\n      <td>-87.674673</td>\n      <td>(41.989559532, -87.674672842)</td>\n    </tr>\n    <tr>\n      <th>430152</th>\n      <td>8668011</td>\n      <td>HV343348</td>\n      <td>2012-06-16 01:00:00+00:00</td>\n      <td>013XX W HOOD AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1166240.0</td>\n      <td>1940964.0</td>\n      <td>2012</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.993586</td>\n      <td>-87.663860</td>\n      <td>(41.99358583, -87.663860367)</td>\n    </tr>\n    <tr>\n      <th>430153</th>\n      <td>8340550</td>\n      <td>HT574200</td>\n      <td>2011-10-31 13:00:00+00:00</td>\n      <td>060XX N KENMORE AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168152.0</td>\n      <td>1940159.0</td>\n      <td>2011</td>\n      <td>2016-02-04 06:33:39+00:00</td>\n      <td>41.991336</td>\n      <td>-87.656851</td>\n      <td>(41.991335662, -87.656850699)</td>\n    </tr>\n    <tr>\n      <th>430154</th>\n      <td>9012324</td>\n      <td>HW159845</td>\n      <td>2013-02-17 11:30:00+00:00</td>\n      <td>014XX W EDGEWATER AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2013</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1165673.0</td>\n      <td>1938317.0</td>\n      <td>2013</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.986335</td>\n      <td>-87.666022</td>\n      <td>(41.986334537, -87.66602188)</td>\n    </tr>\n    <tr>\n      <th>430155</th>\n      <td>3315344</td>\n      <td>HK352979</td>\n      <td>2004-05-04 09:00:00+00:00</td>\n      <td>057XX N MAGNOLIA AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>ALLEY</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2013</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1166921.0</td>\n      <td>1938298.0</td>\n      <td>2004</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.986256</td>\n      <td>-87.661432</td>\n      <td>(41.986255626, -87.661432329)</td>\n    </tr>\n    <tr>\n      <th>430156</th>\n      <td>8425555</td>\n      <td>HV104215</td>\n      <td>2012-01-01 02:00:00+00:00</td>\n      <td>061XX N BROADWAY</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>OTHER</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1167183.0</td>\n      <td>1941103.0</td>\n      <td>2012</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.993947</td>\n      <td>-87.660388</td>\n      <td>(41.993946967, -87.660387637)</td>\n    </tr>\n    <tr>\n      <th>430157</th>\n      <td>4140966</td>\n      <td>HL461743</td>\n      <td>2005-07-03 17:00:00+00:00</td>\n      <td>058XX N KENMORE AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2022</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168189.0</td>\n      <td>1938933.0</td>\n      <td>2005</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.987971</td>\n      <td>-87.656750</td>\n      <td>(41.987970689, -87.65675023)</td>\n    </tr>\n    <tr>\n      <th>430158</th>\n      <td>10328057</td>\n      <td>HY519026</td>\n      <td>2015-11-29 21:03:00+00:00</td>\n      <td>059XX N SHERIDAN RD</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168549.0</td>\n      <td>1939863.0</td>\n      <td>2015</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.990515</td>\n      <td>-87.655399</td>\n      <td>(41.990514817, -87.655399054)</td>\n    </tr>\n    <tr>\n      <th>430159</th>\n      <td>9807863</td>\n      <td>HX456794</td>\n      <td>2014-10-04 15:51:00+00:00</td>\n      <td>052XX N KENMORE AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>CHA PARKING LOT/GROUNDS</td>\n      <td>False</td>\n      <td>True</td>\n      <td>2023</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168307.0</td>\n      <td>1934956.0</td>\n      <td>2014</td>\n      <td>2018-02-10 15:50:01+00:00</td>\n      <td>41.977055</td>\n      <td>-87.656432</td>\n      <td>(41.977055144, -87.656431821)</td>\n    </tr>\n    <tr>\n      <th>430160</th>\n      <td>7054126</td>\n      <td>HR460104</td>\n      <td>2009-07-31 20:30:00+00:00</td>\n      <td>057XX N KENMORE AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>True</td>\n      <td>2022</td>\n      <td>20.0</td>\n      <td>48.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1168210.0</td>\n      <td>1938283.0</td>\n      <td>2009</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.986187</td>\n      <td>-87.656692</td>\n      <td>(41.986186619, -87.656691879)</td>\n    </tr>\n    <tr>\n      <th>430161</th>\n      <td>3691914</td>\n      <td>HK796362</td>\n      <td>2004-12-08 02:40:00+00:00</td>\n      <td>063XX N MAGNOLIA AVE</td>\n      <td>5002</td>\n      <td>OTHER OFFENSE</td>\n      <td>OTHER VEHICLE OFFENSE</td>\n      <td>STREET</td>\n      <td>False</td>\n      <td>False</td>\n      <td>2433</td>\n      <td>24.0</td>\n      <td>40.0</td>\n      <td>77.0</td>\n      <td>26</td>\n      <td>1166797.0</td>\n      <td>1942287.0</td>\n      <td>2004</td>\n      <td>2018-02-28 15:56:25+00:00</td>\n      <td>41.997204</td>\n      <td>-87.661773</td>\n      <td>(41.997204204, -87.661773344)</td>\n    </tr>\n  </tbody>\n</table>\n<p>430162 rows × 22 columns</p>\n</div>"},"metadata":{}}]},{"metadata":{"trusted":true},"cell_type":"code","source":"","execution_count":null,"outputs":[]},{"metadata":{"trusted":true},"cell_type":"code","source":"","execution_count":null,"outputs":[]},{"metadata":{},"cell_type":"markdown","source":"---\n**[SQL Micro-Course Home Page](https://www.kaggle.com/learn/intro-to-sql)**\n\n"}],"metadata":{"kernelspec":{"display_name":"Python 3","language":"python","name":"python3"},"language_info":{"codemirror_mode":{"name":"ipython","version":3},"file_extension":".py","mimetype":"text/x-python","name":"python","nbconvert_exporter":"python","pygments_lexer":"ipython3","version":"3.6.5"}},"nbformat":4,"nbformat_minor":1}