CoP: Data Science: City of Los Angeles Arrests

[akhaleghi]

Overview

We want to analyze arrest data for the city of Los Angeles, and incorporate data from other sources, to determine its suitability for further analysis by Hack for LA. More information about the data, from the Controller's office website:

• The LAPD arrest types fall into five categories identified by the LAPD: (1) felony, (2) misdemeanor, (3) infractions, (4) dependent, and (5) other.
• Under California law, a felony is a crime that is punishable with death, by imprisonment in the state prison,
  or . . . by imprisonment in a county jail under [certain provisions]. Every other crime or public offense is a misdemeanor except those offenses that are classified as infractions. Misdemeanors and infractions carry varying degrees of financial and incarceration consequences.
• LAPD makes more arrests for misdemeanor and infraction offenses than for felonies.
  • 2019: 55,954 misdemeanor & infraction arrests vs. 33,663 felony arrests
  • 2020: 34,659 misdemeanor & infraction arrests vs. 31,015 felony arrests
  • 2021: 33,179 misdemeanor & infraction arrests vs. 32,597 felony arrests
  • 2022: 30,431 misdemeanor & infraction arrests vs. 30,378 felony arrests

Action Items

Phase 1

• Find available data sources and add to Resources section
• Create data dictionary (EDA task) #194
• Determine is this is one-time or ongoing project (and assign appropriate label)
• Write one-sheet (see Resources below)
  • Define stakeholder
  • Summarize project, including value add
  • Define project 6 month roadmap
  • Detail history (if any)
• Define tools to be used for analysis and visualization (if applicable)
• Create issues required to fulfill project requirements, including exploratory data analysis, required tasks, and deliverables
  • Perform data cleaning (EDA task)
  • Understand and outline data context

Resources/Instructions

Arrest data for 2022 csv file
Arrest data from the City of Los Angeles
Check #178 for updates on whether a real time source for this data have been found

[akhaleghi]

@Lalla22 @Jonathanyun While we're all working together to find a direction for this new project, I think a good way to start would be for each of you to do one of the following:

1. Find available sources for this data - On the LA Controller's website, there is this map and this map that visualize some of the arrest data. Each of those has a "table" link at the top which navigates to the raw data. We want to document how these two data sources are different and if there is a more direct source of this data (i.e. can we obtain from LAPD)?
2. Conduct exploratory data analysis - Let's start with creating a data dictionary. Read more about that here

[akhaleghi]

@Lalla22 @Jonathanyun There has been no activity in this issue so I am going to return it to the backlog. If you'd like to be assigned to another project please volunteer for one at our next meeting.

[Lalla22]

Hi Abe! Please keep me assigned to this one. I havent commented/notifyed updates yet but before the next meeting I will add them, and share the data I found. Best, Lalla Sankara Get Outlook for Android<https://aka.ms/AAb9ysg>

…

________________________________ From: Abe ***@***.***> Sent: Tuesday, September 5, 2023 9:02:25 AM To: hackforla/data-science ***@***.***> Cc: Lalla Sankara ***@***.***>; Mention ***@***.***> Subject: Re: [hackforla/data-science] City of Los Angeles Arrests (Issue #180) @Lalla22<https://github.com/Lalla22> @Jonathanyun<https://github.com/Jonathanyun> There has been no activity in this issue so I am going to return it to the backlog. If you'd like to be assigned to another project please volunteer for one at our next meeting. — Reply to this email directly, view it on GitHub<#180 (comment)>, or unsubscribe<https://github.com/notifications/unsubscribe-auth/ALHZPKV2GKVFZXUZXCDTRJ3XY5EJDANCNFSM6AAAAAA32XD6AE>. You are receiving this because you were mentioned.Message ID: ***@***.***>

[Lalla22]

Arrest and Crime Data from: 2010 - 2019

arrest-data-from-2010-to-present.csv

crime-data-from-2010-to-present.csv

[akhaleghi]

Thanks for these updates, Lalla! Can you provide a little more information about where you obtained this data?

[akhaleghi]

Bonnie's note: please tread carefully with this data and add disclaimers where necessary (i.e. we don't want to suggest areas are "unsafe"). Also, we should look at what types of crimes are missing from the data and make a note of that (i.e. are white collar crimes included, or only physical/property crimes?). For missing data, is there a source for this?

[akhaleghi]

@Lalla22 @AishwaryaN2203 based on the discussion at our CoP meeting, what we want to do here is look at the data set to determine if it's complete (i.e. does it include all types of crime or just a subset), find out whether there is a single source to obtain data at regular intervals, complete an EDA on the data set, and come up with interesting research questions to run by Karina and/or Sophia. Try to divide the work amongst yourselves how you see fit and please post weekly updates here with a comment about your progress.

[akhaleghi]

Hi @Lalla22 @dolla24 there have been no updates on this issue since September, so I am going to return it to the backlog. Let me know if you'd like to resume working on it and providing weekly updates.

[akhaleghi]

Hi @SaleelChuri @dolla24 are there any updates on the progress of this issue?

[dolla24]

Hi Abe, i have been working on this issue, and can share some updates later this evening.
https://github.com/hackforla/data-science/blob/main/la_crime_analysis/LA%20Crime%20Data%202020-2023.ipynb

[Lalla22]

Status Updates: https://github.com/Lalla22/LA-Crime-and-Arrest-Data-Science-Project-Hack4LA-
Data exploration changes and updates
Working on data dictionary and one sheet project summary

@akhaleghi and @salice I have updates for next meeting

[akhaleghi]

@dolla24 @Lalla22 @SaleelChuri @ZeelDesai00 @jefryk18 We have a lot of people assigned to this issue. Can you please leave a comment if you're actively working on it? Zeel and Jefry, I assume that you two are since you have assigned yourselves to the issue in the past week.

[ZeelDesai00]

@akhaleghi Just to clarify, my assignment to this issue was temporary and was meant to be finalized in today's meeting. I'll update accordingly after the discussion.

[jefryk18]

yeah mine was also temporary ,thought of confirming in this meeting now i am planning to switch to another project

…

On Mon, 19 Aug 2024 at 19:08, Abe ***@***.***> wrote: @dolla24 <https://github.com/dolla24> @Lalla22 <https://github.com/Lalla22> @SaleelChuri <https://github.com/SaleelChuri> @ZeelDesai00 <https://github.com/ZeelDesai00> @jefryk18 <https://github.com/jefryk18> We have a lot of people assigned to this issue. Can you please leave a comment if you're actively working on it? Zeel and Jefry, I assume that you two are since you have assigned yourselves to the issue in the past week. — Reply to this email directly, view it on GitHub <#180 (comment)>, or unsubscribe <https://github.com/notifications/unsubscribe-auth/BKK5YPIEPRSRBLO2O63XCLDZSKCH7AVCNFSM6AAAAAA32XD6AGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOJXG4ZDMMBXHE> . You are receiving this because you were mentioned.Message ID: ***@***.***>

[pranjaliseth]

I am currently exploring more recent datasets for Arrests in LA region.

[ayesha-yu]

Completed data cleaning for Crimes data, currently doing EDA. Will do the same for Arrests data. Using the same datasets used here

[pranjaliseth]

Gathered the datasets and metadata. Completed data cleaning and EDA. Currently exploring trends and more ways to utilize the data.