Skip to content

amawest/criminal-expungement-data-analysis

Repository files navigation

Criminal Expungement: Racial Disparity

By Amanda West, Shannon Paylor, and Gaurav Anand @University of Virginia 2021.

Table of Contents

  1. Questions of Interest
  2. Link Dump
  3. Circuit 2019 Results
    1. Question 1
    2. Question 2
    3. Question 3
    4. Question 4
    5. Question 5
    6. Question 6
    7. Question 7
  4. District 2019 Results
    1. Question 1
    2. Question 2
    3. Question 3
    4. Question 4
    5. Question 5
    6. Question 6
    7. Question 7

Questions of Interest

  1. Find from the census the total population of Virginia by racial group and see if racial groups in the court data are over/under represented
  2. Create a map of racial disparity by area, and we can show changes in that map over time
  3. What criminal charges produce the worst racial disparities?
  4. Count the number of black people charged with felonies vs. white people charge with misdemeanors for the same offense by year
  5. Count the number of black people convicted of felonies vs. white people convicted of misdemeanors (or not convicted at all) for the same offense by year
  6. What are the most common offenses in the VA court system
  7. Make a bar plot of the 20 most frequent codes

Link Dump


Circuit 2019 Data

Question 1a

Find from the census the total population of Virginia by racial group and see if racial groups in the court data are over/under represented

Question 2a

Create a map of racial disparity by area, and we can show changes in that map over time

Question 3a

What criminal charges produce the worst racial disparities?

Question 4a

Count the number of black people charged with felonies vs. white people charge with misdemeanors for the same offense by year

Question 5a

Count the number of black people convicted of felonies vs. white people convicted of misdemeanors (or not convicted at all) for the same offense by year

Question 6a

What are the most common offenses in the VA court system

Question 7a

Make a bar plot of the 20 most frequent codes


District 2019 Data

Question 1b

Find from the census the total population of Virginia by racial group and see if racial groups in the court data are over/under represented

Question 2b

Create a map of racial disparity by area, and we can show changes in that map over time

Question 3b

What criminal charges produce the worst racial disparities?

Question 4b

Count the number of black people charged with felonies vs. white people charge with misdemeanors for the same offense by year

Question 5b

Count the number of black people convicted of felonies vs. white people convicted of misdemeanors (or not convicted at all) for the same offense by year

Question 6b

What are the most common offenses in the VA court system

Question 7b

Make a bar plot of the 20 most frequent codes

About

Employed big data tools (PySpark) and data visualization (Tableau) to perform an analysis for the Legal Aid Justice Center in Charlottesville, VA

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published