data-science icon indicating copy to clipboard operation
data-science copied to clipboard

Published 20 hours ago • verified publisher icon hackforla

City of Los Angeles Arrests

Open akhaleghi opened this issue 1 year ago • 14 comments

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

  • [x] Find available data sources and add to Resources section
  • [x] #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)
  • [x] 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 avatar Aug 23 '23 01:08 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 avatar Aug 29 '23 17:08 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.

akhaleghi avatar Sep 05 '23 16:09 akhaleghi

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 Androidhttps://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)

@Lalla22https://github.com/Lalla22 @Jonathanyunhttps://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 GitHubhttps://github.com/hackforla/data-science/issues/180#issuecomment-1706902827, or unsubscribehttps://github.com/notifications/unsubscribe-auth/ALHZPKV2GKVFZXUZXCDTRJ3XY5EJDANCNFSM6AAAAAA32XD6AE. You are receiving this because you were mentioned.Message ID: @.***>

Lalla22 avatar Sep 05 '23 16:09 Lalla22

Arrest and Crime Data from: 2010 - 2019

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

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

Lalla22 avatar Sep 06 '23 02:09 Lalla22

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

akhaleghi avatar Sep 07 '23 16:09 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 avatar Sep 19 '23 02:09 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 avatar Sep 20 '23 20:09 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 avatar Jan 09 '24 01:01 akhaleghi

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

akhaleghi avatar Feb 12 '24 23:02 akhaleghi

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

dolla24 avatar Feb 13 '24 00:02 dolla24

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

Lalla22 avatar Feb 18 '24 05:02 Lalla22

@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.

akhaleghi avatar Aug 20 '24 00:08 akhaleghi

@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.

ZeelDesai00 avatar Aug 20 '24 02:08 ZeelDesai00

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 https://github.com/hackforla/data-science/issues/180#issuecomment-2297726079, or unsubscribe https://github.com/notifications/unsubscribe-auth/BKK5YPIEPRSRBLO2O63XCLDZSKCH7AVCNFSM6AAAAAA32XD6AGVHI2DSMVQWIX3LMV43OSLTON2WKQ3PNVWWK3TUHMZDEOJXG4ZDMMBXHE . You are receiving this because you were mentioned.Message ID: @.***>

jefryk18 avatar Aug 20 '24 03:08 jefryk18