2b:null 2c:["$","title",null,{"children":"Iowa Prison Statistics | Jose Jimenez | Observable"}] 31:T4b5,facilities = d3.tsvParse(`Abbreviation Institution Name Address City State Zip Location NCCF North Central Correctional Facility 313 Lanedale Rockwell City Iowa 50579 POINT (-94.61175148399997 42.39377433900004) ISP Iowa State Penitentiary 3 John Bennett Drive Fort Madison Iowa 52627 POINT (-91.29724202899996 40.63333761800005) FDCF Fort Dodge Correctional Facility 1550 L Street Fort Dodge Iowa 50501 POINT (-94.19206133899996 42.48595626700006) NCF Newton Correctional Facility 307 S. 60th Avenue W. Newton Iowa 50208 POINT (-93.05793043699998 41.630172704000074) ASP Anamosa State Penitentiary 406 North High Street Anamosa Iowa 52205 POINT (-91.28931848699995 42.111149666000074) ICIW Iowa Correctional Institution for Women 300 Elm Avenue, SW Mitchellville Iowa 50169 POINT (-93.36299704799995 41.66286063500007) IMCC Iowa Medical and Classification Center 2700 Coral Ridge Ave Coralville Iowa 52241 POINT (-91.60800095599997 41.71519157400006) CCF Clarinda Correctional Facility 2000 N. 16th Street Clarinda Iowa 51632 POINT (-95.03792059599994 40.748100390000054) MPCF Mt. Pleasant Correctional Facility 1200 East Washington Mt. Pleasant Iowa 52641 POINT (-91.53654676599996 40.96377196600002) `)32:T12eb,rollup = { let totals = {} let years_added = [] filtered_incarcerations.forEach(row => { let key = row.calendar_year let last_year = current_record_date.getFullYear() if (row.date_of_release) { last_year = (new Date(row.date_of_release)).getFullYear() } let current_year = key for (current_year = current_year; current_year <= last_year; current_year ++) { if (!years_added.includes(current_year)) { years_added.push(current_year) totals[current_year] = { black_incarcerated: [], black_incarcerated_count: 0, black_population: 0, black_incarceration_lengths: [], white_incarcerated: [], white_incarcerated_count: 0, white_population: 0, white_incarceration_lengths: [] } } } //add person to each year they were incarcerated for this record current_year = key for (current_year = current_year; current_year <= last_year; current_year ++) { if (row.race_ethnicity.toLowerCase() == corrections_black.toLowerCase()) { if (!totals[current_year].black_incarcerated.includes(row.offender_number)) { totals[current_year].black_incarcerated.push(row.offender_number) } } if (row.race_ethnicity.toLowerCase() == corrections_white.toLowerCase()) { if (!totals[current_year].white_incarcerated.includes(row.offender_number)) { totals[current_year].white_incarcerated.push(row.offender_number) } } } if (row.race_ethnicity.toLowerCase() == corrections_black.toLowerCase()) { totals[key].black_incarceration_lengths.push(row.months_served) } if (row.race_ethnicity.toLowerCase() == corrections_white.toLowerCase()) { totals[key].white_incarceration_lengths.push(row.months_served) } }) filtered_demographics.forEach(row=> { let key = row.calendar_year if (totals[key]) { if (row['variable_description'] === demo_black) { totals[key].black_population = parseInt(row.value) } if (row['variable_description'] === demo_white) { totals[key].white_population = parseInt(row.value) } } }) let totals_array = [] Object.keys(totals).forEach(key => { let delete_keys = [ 'black_incarcerated_count', 'white_incarcerated_count', 'black_population', 'white_population', 'black_incarcerated', 'white_incarcerated', 'black_percent_display', 'black_percent', 'white_percent_display', 'white_percent', 'white_incarceration_lengths', 'white_average_length', 'black_average_length', 'black_incarceration_lengths', ] if (true || totals[key].white_population > 0) { totals[key].black_incarcerated_count = totals[key].black_incarcerated.length totals[key].white_incarcerated_count = totals[key].white_incarcerated.length let black_population = totals[key].black_population let black_incarcerated = totals[key].black_incarcerated_count let black_percent_display = Math.floor(black_incarcerated / black_population * 10000) / 10000 let white_population = totals[key].white_population let white_incarcerated = totals[key].white_incarcerated_count let white_percent_display = Math.floor(white_incarcerated / white_population * 10000) / 10000 totals[key].black_percent_display = black_percent_display totals[key].black_percent = black_percent_display * 100 totals[key].black_average_length = d3.mean(totals[key].black_incarceration_lengths) totals[key].white_percent_display = white_percent_display totals[key].white_percent = white_percent_display * 100 totals[key].white_average_length = d3.mean(totals[key].white_incarceration_lengths) let whites = Object.assign({race: 'White', calendar_year: key},totals[key]) let blacks = Object.assign({},whites) blacks.race = 'Black' //move some stuff around whites.population = whites.white_population whites.incarcerated = whites.white_incarcerated_count whites.percent_display = whites.white_percent_display whites.percent = whites.white_percent whites.incarceration_length = Math.round(whites.white_average_length * 100) / 100 blacks.population = blacks.black_population blacks.incarcerated = blacks.black_incarcerated_count blacks.percent_display = blacks.black_percent_display blacks.percent = blacks.black_percent blacks.incarceration_length = Math.round(blacks.black_average_length * 100) / 100 delete_keys.forEach(attribute => { delete(whites[attribute]) delete(blacks[attribute]) }) totals_array.push(whites) totals_array.push(blacks) } }) return totals_array }33:[] 2f:{"id":"c73f9bb4c911bae1","slug":"iowa-prison-statistics","title":"Iowa Prison Statistics","thumbnail":"d1b95c38de3fa435ccd23bbcd6697750d76cf29fed784729114dce3c44256d9b","access_level":"public","create_time":"$D2020-06-10T19:04:49.886Z","update_time":"$D2021-04-15T14:22:36.033Z","view_time":null,"first_public_time":"$D2020-06-10T22:55:41.525Z","fork":false,"stars":0,"starred":false,"owner":{"type":"team","id":"11eff763c21b0530","login":"jjimenez","name":"Jose Jimenez","avatar_url":"https://avatars-next.observableusercontent.com/5d28ac3054c420a200dcd8a0bd3367e2263d2f168c4aa5eaa0c89640622d6088","tier":"starter_2024"},"version":1177,"publish_version":1177,"role":null,"authored":false,"authors":[{"type":"individual","id":"214adfe1a708eb31","login":"jjimenez","name":"Jose Jimenez","avatar_url":"https://avatars-next.observableusercontent.com/5d28ac3054c420a200dcd8a0bd3367e2263d2f168c4aa5eaa0c89640622d6088","tier":null}],"members":[{"type":"individual","id":"214adfe1a708eb31","login":"jjimenez","name":"Jose Jimenez","avatar_url":"https://avatars-next.observableusercontent.com/5d28ac3054c420a200dcd8a0bd3367e2263d2f168c4aa5eaa0c89640622d6088","tier":null,"role":"editor"}],"comments":[],"custom_thumbnail":false,"trashed":false,"subscribed":null,"forks":0,"collection":{"id":"dadf1970703a73a7","slug":"racial-awareness-2020","title":"Racial Awareness 2020","owner":{"id":"11eff763c21b0530","login":"jjimenez","name":"Jose Jimenez"}},"type":"notebook","body":{"title":"Iowa Prison Statistics","cells":[{"id":0,"value":"md`# Iowa Prison Statistics`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":553,"value":"md`Today I participated in #ShutDownAcademia and I spent most of my day watching lectures, reading articles, and picking out a book to read next. \n\n(I think I'm going with [How to be an Anti-Racist by Ibram X. Kendi](https://www.events.sankofa.com/blank-2/how-to-be-an-antiracist-hardcover))\n\nI spent a few hours working learning more about disporportionate impacts of incarceration as a follow up to yesterday's work on [Iowa Police Spending](https://observablehq.com/@jjimenez/spending-by-iowa-cities-police-vs-other-services). \n\nThe data is from [data.iowa.gov](https://data.iowa.gov) where you can find additional visualizations. See the references section for more links.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":351,"value":"md`## Who is incarcerated in Iowa?\n\nMy first question related to the Iowa correctional system is __Who is incarcerated?__ \nHere I split out the data by Race / Ethnicity as available in data from data.iowa.gov. \n\nThe calendar year refers to the year the incarceration started.\n\nSee the references section for a link to the data source.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":24,"value":"generate_bar_plot().render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":355,"value":"md`There are ${unique_institutions.length} Correctional Institutions in Iowa. You can select which ones to include in the analysis.`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":150,"value":"viewof facilities_selected = checkbox({\n title: \"Facilities\",\n description: \"Please select the facilities to include\",\n options: unique_institutions,\n value: unique_institutions\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":360,"value":"md`My next question of the data was __How does this compare to the relative population of that Race / Ethnicity in Iowa?__\n\nI found demographic information on data.iowa.gov also.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":365,"value":"md`\nHere, in each year, I've counted the number of individuals incarcerated each year, rather than counting multiple incarcerations of the same individual in the same year more than once. \n\nI haven't analyzed situations where the same individual has been incarcerated more than once in the same year.\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":408,"value":"md`## Incarceration as a percent of total population by Race / Ethnicity`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":753,"value":"summary_plot('percent', 'Percent of Population Incarcerated', 'percent_display','.2%', rollup.filter(row => row.percent != Infinity)).encode(\n vl.tooltip([\n {field: 'race', type: 'Nominal', title: 'Race / Ethnicity'},\n {field: 'population', type: 'Quantitative', format: ','},\n {field: 'incarcerated', type: 'Quantitative', title: 'Number incarcerated', format: ','},\n {field: 'percent_display', type: 'Quantitative', title: 'Percent of Population Incarcerated', format: '.2%'}\n ])\n).render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":405,"value":"md`The next question I asked was __How long are different races incarcerated?__`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":412,"value":"md`## Length of Incarceration by Race / Ethnicity`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":402,"value":"summary_plot('incarceration_length', 'Average (mean) incarceration length in Months', 'incarceration_length',',', rollup.filter(row => row.calendar_year >= first_year)).render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":436,"value":"md`Looking at this data made me a bit suspicious, so I looked closer at the source data. Every record in the raw data has a release date. __*The original data seems to only include records for incarcerations where the individual has already been released!*__ \n\nI had to go looking for people who are currently incarcerated. Check the box below \n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":684,"value":"viewof include_current_incarcerations = checkbox({\n title: \"Include current incarcerations?\",\n options: [{ value: \"yes\", label: \"Yes\" }],\n description: 'Current incarcerations are counted as having a length based on the data provided in the \"months served\" field of the data.'\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":961,"value":"md`Incarcerations included: ${d3.format(',.10d')(filtered_incarcerations.length)} based on raw data for: ${d3.format(',.10d')(raw_data_to_use.length)} (${d3.format(',.10d')(filtered_out.length)} filtered out)`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":676,"value":"md`\nI next wondered __What does this look like for various types of offenses?__ So I added these filters.\n` ","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":428,"value":"viewof offense_types_selected = checkbox({\n title: \"Offense Types\",\n description: \"Please select the offense types to include\",\n options: unique_offense_types,\n value: unique_offense_types\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":452,"value":"viewof offense_subtypes_selected = checkbox({\n title: \"Offense Sub Types\",\n description: \"Please select the offense sub types to include\",\n options: humanized_subtypes,\n value: humanized_subtypes\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":799,"value":"md`## Table Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":802,"value":"table(\n table_data,\n {\n columns: {\n percent_display: {\n title: 'Percent',\n formatter(val, i) {\n return d3.format('.2%')(val);\n }\n },\n calendar_year: {\n title: 'Year'\n },\n incarceration_length: {\n title: 'Incarceration Length',\n formatter(val,i) {\n return d3.format('0.2f')(val);\n }\n }\n }\n }\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1093,"value":"md`## More Detail`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":818,"value":"viewof selected_year = select({\n title: \"Selected Year\",\n description: \"Please pick a year to drill into.\",\n options: years,\n value: 2016\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":910,"value":"generate_boxplot().render()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":89,"value":"md`## References, Data Processing, Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":93,"value":"md`### References`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":96,"value":"html`\n

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":625,"value":"md`## Updates`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":626,"value":"html`\n

June 12, 2020 8:03pm: Updated to use months of incarceration from raw data (should have looked closer at it); Add ability to include currently incarcerated individuals
August 18th, 2020 9:44 am: Added current incarcerations; started Detail section
April 15th, 2021 9:22 am: Updated to match data source changes

\n`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":167,"value":"md`### Institution Addresses`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":152,"value":"table(Object.values(institution_addresses))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":72,"value":"md`### Raw Data`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":2,"value":"raw_data = fetch(`https://data.iowa.gov/resource/w4ib-vabz.json?$where=admission_date >= \"${first_year}-01-01T00:00:00.000\"&$limit=500000`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1154,"value":"raw_facilities = make_unique(raw_data, 'institution_name').sort()","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":1165,"value":"facility_code_map = (\n {\n \"Anamosa State Penitentiary\": \"ASP\",\n \"Fort Dodge Correctional Facility\": \"FDCF\",\n \"Iowa Correctional Institution for Women\": \"ICIW\",\n \"Iowa Medical & Classification Center\": \"IMCC\",\n \"Iowa State Penitentiary\": \"ISP\",\n \"Mount Pleasant Correctional Facility\": \"MPCF\",\n \"Newton Correctional Facility\": \"NCF\",\n \"North Central Correctional Facility\": \"NCCF\",\n \"Clarinda Correctional Facility\" : \"CCF\"\n }\n)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":99,"value":"$31","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":171,"value":"raw_demographics = fetch(`https://data.iowa.gov/resource/eg2q-6umu.json?$where=type = \"state\" and variable_description != 'Total' and date > '${first_year}-01-01T00:00:00.000'&$limit=500000`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":589,"value":"raw_current = fetch(`https://data.iowa.gov/resource/xbcv-c6t2.json?$limit=500000`).then(response => response.json())","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":107,"value":"md`## Data Processing`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":598,"value":"mapped_current = {\n const remove_keys = [\"prison_start_date\", \"prison_admit_type\", \"supervising_intitution\", \"supervision_status\", \"education_category\", \"education\", \"age\", \"record_date\"]\n let mapped = []\n raw_current.forEach(row => {\n let new_row = Object.assign({},row)\n new_row.record_id= 'C'+row.record_id\n new_row.admission_date = row.prison_start_date\n new_row.fiscal_year_admitted= get_fiscal_year(new Date(row.prison_start_date))\n new_row.admission_type = row.prison_admit_type\n new_row.institution_name= institution_address_by_code[facility_code_map[row.supervising_intitution]]['Institution Name']\n new_row.age_at_admission= age_at_admission(parseFloat(row.age),parseFloat(row.months_served))\n new_row.date_of_release = null\n remove_keys.forEach(key => delete(new_row[key]))\n mapped.push(new_row)\n })\n return mapped\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":709,"value":"current_record_date = new Date(make_unique(raw_current,'record_date')[0])","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":741,"value":"data_people = make_unique(raw_data, 'offender_number')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":744,"value":"current_people = make_unique(mapped_current, 'offender_number')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":749,"value":"current_people.filter(row => !data_people.includes(row))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":214,"value":"filtered_incarcerations = raw_data_to_use.filter(row => \n (facilities_selected.includes(row.institution_name) \n || facilities_selected.includes(facility_map[row.institution_name]))\n && offense_types_selected.includes(row.offense_type)\n && (offense_subtypes_selected.includes(row.offense_subtype) \n || (typeof row.offense_subtype === 'undefined' && offense_subtypes_selected.includes('[blank]')))\n ).map(row => {\n let copy = Object.assign({},row)\n copy.months_served = parseFloat(copy.months_served)\n copy.calendar_year = (new Date(row.admission_date)).getFullYear()\n return copy\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":979,"value":"filtered_out = {\n let filtered_offenders = filtered_incarcerations.map(row => row.offender_number)\n let raw_offenders = raw_data_to_use.map(row => row.offender_number)\n let missing_offenders = raw_offenders.filter(row => !filtered_offenders.includes(row))\n return raw_data_to_use.filter(row => missing_offenders.includes(row.offender_number)) \n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":670,"value":"raw_data_to_use = {\n let data = raw_data\n if (include_current_incarcerations === 'yes') {\n data = [...raw_data, ...mapped_current]\n }\n return data\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":420,"value":"unique_offense_types = [...make_unique(raw_data, 'offense_type'),'None']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":423,"value":"unique_offense_subtypes = [...make_unique(raw_data, 'offense_subtype','offense_type', offense_types_selected),'None']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":457,"value":"humanized_subtypes = {\n let copy = [...unique_offense_subtypes]\n copy.splice(copy.indexOf(undefined),1,'[blank]')\n return copy\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":112,"value":"unique_institutions = make_unique(raw_data_to_use, 'institution_name').filter(row => !Object.keys(facility_map).includes(row))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":129,"value":"institution_addresses = {\n let addresses = {}\n facilities.forEach(facility => {\n let key = facility['Institution Name']\n if (facility_map[key]) {\n key = facility_map[key]\n }\n addresses[key] = Object.assign(facility)\n delete(addresses[key].Location)\n })\n return addresses\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":593,"value":"institution_address_by_code = {\n let map = {}\n Object.keys(institution_addresses).forEach(inst => {\n let row = institution_addresses[inst]\n let key = row.Abbreviation\n map[key] = row\n })\n return map\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":122,"value":"facility_names = make_unique(facilities,'Institution Name')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":126,"value":"facility_map = ({\n \"Mt. Pleasant Correctional Facility\": \"Mount Pleasant Correctional Facility\",\n \"Iowa Medical and Classification Center\": \"Iowa Medical & Classification Center\",\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":249,"value":"unique_race = make_unique(filtered_incarcerations, 'race_ethnicity')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":191,"value":"unique_demo_ethnicities = make_unique(raw_demographics, 'variable_description')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":194,"value":"unique_demo_dates = make_unique(raw_demographics, 'date')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":202,"value":"demo_black = \"Black or African American Alone\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":205,"value":"corrections_black = \"Black\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":207,"value":"corrections_white = \"White\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":208,"value":"demo_white = \"White Alone\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":259,"value":"filtered_demographics = raw_demographics.filter(row => row.variable_description === demo_white || row.variable_description === demo_black).map(row => {\n let copy = Object.assign({},row)\n copy.calendar_year = (new Date(row.date)).getFullYear()\n return copy\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":222,"value":"$32","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":813,"value":"years = make_unique(rollup,'calendar_year').filter(row => row >= first_year).map(yr => parseInt(yr))","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":855,"value":"one_year = filtered_incarcerations.filter(row => \n row.calendar_year === parseInt(selected_year)\n && ([corrections_black, corrections_white].includes(row.race_ethnicity))\n )","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":950,"value":"table_data = rollup.filter(row => row.calendar_year >= first_year && row.percent_display != Infinity).map(row => {\n let clone = Object.assign({},row)\n delete clone.percent\n return clone\n})","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":74,"value":"md`### Utility Functions`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":113,"value":"make_unique = (data, attribute, parent_attribute, values) => {\n let selected_data = data\n if (typeof(parent_attribute) != 'undefined' && typeof(values) != 'undefined') {\n selected_data = data.filter(row => values.includes(row[parent_attribute]))\n } \n \n return [...(new Set(selected_data.map(row => row[attribute])))].sort()\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":58,"value":"first_year = (new Date).getFullYear() - 8","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":477,"value":"bar_scheme = 'tableau10'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":17,"value":"generate_bar_plot = () => { \n const chart = vl.markBar({filled: true})\n .width((width - 250))\n .height(250)\n .data(filtered_incarcerations.filter(row => row.calendar_year >= first_year))\n .encode(\n vl.x().fieldN('calendar_year').axis({title: 'Calendar Year Incarcerated'}),\n vl.y({sort: 'ascending'}).aggregate('count').axis({title: 'Count of Incarcerations'}),\n vl.color().fieldN('race_ethnicity').scale({scheme: bar_scheme}).legend({title: 'Race / Ethnicity'}),\n vl.tooltip([\n {field: 'race_ethnicity', type: 'Nominal', title: 'Race / Ethnicity'},\n {aggregate: 'count', type: 'Quantitative', title: 'Count', format: ','}\n ])\n );\n \n return chart;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":898,"value":"detail_width = (width - 150) / (offense_types_selected.length === 1 ? offense_subtypes_selected.length : offense_types_selected.length)","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":923,"value":"boxplot_columns = offense_types_selected.length > 1 ? ['offense_type', 'Offense Type'] : ['offense_subtype', 'Offense Subtype']","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":907,"value":"generate_boxplot = () => {\n const boxplot = vl.markBoxplot()\n .width(detail_width)\n .height(450)\n .data(one_year)\n .encode(\n vl.column({title: boxplot_columns[1]}).fieldN(boxplot_columns[0]),\n vl.x().fieldN('race_ethnicity').axis({title: 'Race / Ethnicity'}),\n vl.y().fieldQ('months_served').axis({title: 'Months Served'}),\n vl.color().fieldN('race_ethnicity').legend({title: 'Race / Ethnicity'})\n );\n return boxplot;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":299,"value":"summary_plot = (field, legend, tooltip_field, format_string, data) => { \n const chart = vl.markBar({filled: true})\n .width(((width / (unique_demo_dates.length + 8) )))\n .height(250)\n .data(data)\n .encode(\n vl.column().fieldN('calendar_year'),\n vl.x().fieldN('race').axis({title: 'Race'}),\n vl.y().fieldQ(field).axis({title: legend}),\n vl.color().fieldN('race').scale({scheme: 'blues'}).legend({title: 'Race / Ethnicity'}),\n vl.tooltip([\n {field: 'race', type: 'Nominal', title: 'Race / Ethnicity'},\n {field: tooltip_field, type: 'Quantitative', title: legend, format: format_string}\n ])\n );\n \n return chart;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":374,"value":"monthDiff = (d1, d2) => {\n var months;\n months = (d2.getFullYear() - d1.getFullYear()) * 12;\n months -= d1.getMonth();\n months += d2.getMonth();\n return months <= 0 ? 0 : months;\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":599,"value":"get_fiscal_year = (for_date) => {\n let year = for_date.getFullYear()\n let month = for_date.getMonth()\n if (month > 5) {\n year = year +1\n }\n return year\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":632,"value":"age_at_admission = (age, months_served) => {\n let years_served = months_served / 12.0\n return age - years_served\n}","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":83,"value":"md`### Imports`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":12,"value":"import {vl} from '@jjimenez/ui-salary-data-using-data-iowa-gov-api'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":141,"value":"import {table} from '@tmcw/tables'","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":144,"value":"import {checkbox} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":810,"value":"import {select} from \"@jashkenas/inputs\"","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":103,"value":"md`### Requires`","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"},{"id":101,"value":"d3 = require('d3@5')","pinned":false,"hidden":false,"mode":"ojs","author":"$undefined","summary":"$undefined"}],"files":"$W33","stdlib":"1","titling":"auto"}} 30:"$2f:body"