jenwhitson/sentencing_project

Issues

• Add new dimensions to opafy dimension table.

  #10 opened 3 years ago by jenwhitson
  0

• Review sentencing guidelines on USSC.gov

  #4 opened 3 years ago by jenwhitson
  0

• pull 2015-2019 census data from census reporter

  #7 opened 3 years ago by jenwhitson
  0

• Look at sentencing enhancement categories and calculation categories, then make plan for how to analyze sentencing length using this data.

  #8 opened 3 years ago by jenwhitson
  0

• Determine which districts are in TN and subset opafy tables for districts located in TN

  #5 opened 3 years ago by jenwhitson
  0

• Examine pre-existing statistical dimensions of opafy tables grouped by race

  #6 opened 3 years ago by jenwhitson
  0

• Determine which columns need to be captured and query opafy files in SAS with just these columns. Save as csv's.

  #9 opened 3 years ago by jenwhitson
  0

• Create dimension table for opafy tables and categorize each dimension.

  #1 opened 3 years ago by jenwhitson
  0

• Add additional dimensions noted after review of opafy dimensions table and rerun queries in SAS to add to csv files

  #2 opened 3 years ago by jenwhitson
  0

• Review sentencing table on USSC.gov and take notes

  #3 opened 3 years ago by jenwhitson
  0

• Go through python notebook and export any useful charts

  #31 opened 3 years ago by jenwhitson
  0

• Change savefig settings to 300 dpi instead of 1000.

  #32 opened 3 years ago by jenwhitson
  0

• Make cards for percentage more likely someone is to be sentenced than other groups.

  #33 opened 3 years ago by jenwhitson
  0

• Add talking points to presentation

  #34 opened 3 years ago by jenwhitson
  0

• Add immigration stats to presentation

  #35 opened 3 years ago by jenwhitson
  0

• Calculate average fines by race and crime type.

  #26 opened 3 years ago by jenwhitson
  0

• Explore MNTH and PCNTDEPT to see how they play together and if any info can be gleaned from them. And how they play with RANGEPT.

  #27 opened 3 years ago by jenwhitson
  0

• Make grouped bar chart of percent general pop v. percent prison sentences.

  #28 opened 3 years ago by jenwhitson
  0

• Create categories for sentence lengths (maybe <1 year, 1-3 years, 3-5 years, 5-10 years, 10-20 years, 20+ years) and then create grouped bar chart by race.

  #29 opened 3 years ago by jenwhitson
  0

• Create clipped sentence column that stops at 720

  #30 opened 3 years ago by jenwhitson
  0

• Plot census demos v. prison demos

  #20 opened 3 years ago by jenwhitson
  0

• Look at pretrial detention rates by race/gender

  #21 opened 3 years ago by jenwhitson
  0

• subset totprisn for pleas v. non-pleas

  #22 opened 3 years ago by jenwhitson
  0

• Subset people who served no time and see what we can learn about them.

  #23 opened 3 years ago by jenwhitson
  0

• Find out if we can figure out how many people were arrested and never sentenced.

  #24 opened 3 years ago by jenwhitson
  0

• Find out if this data is only for people charged with federal offenses.

  #25 opened 3 years ago by jenwhitson
  0

• Make histo of age at sentencing

  #15 opened 3 years ago by jenwhitson
  0

• Run value count for MONRACE, MONSEX, and HISPORIG.

  #16 opened 3 years ago by jenwhitson
  0

• Figure out exactly which columns are missing from each year.

  #17 opened 3 years ago by jenwhitson
  0

• Merge 2015-2019 TN tables if possible

  #18 opened 3 years ago by jenwhitson
  0

• Calculate state demographic percentages 2015-2019 using census data.

  #19 opened 3 years ago by jenwhitson
  0

• Brainstorm ways to sanity check existing tables and set tasks for any ways identified.

  #11 opened 3 years ago by jenwhitson
  0

• Look at breakdown of DISPOSIT column grouped by MONRACE, MONSEX, and HISPORIG. This will tell us what percentage of each ethnicity and gender plead vs what percentage go to trial.

  #12 opened 3 years ago by jenwhitson
  0

• Subset longest sentences and explore.

  #14 opened 3 years ago by jenwhitson
  0

• Look at average sentences by crime types

  #13 opened 3 years ago by jenwhitson
  0