![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/10\/Screen-Shot-2021-10-24-at-14.55.33-2-1024x989.png?resize=840%2C811&ssl=1\")
<\/figure>\n\n\n\nThe Marshall Project<\/a>, a non-partisan, nonprofit news organization focus their work around the U.S criminal justice system and exposes violations and abuses in the system to influence change. The organization published a news article 500,000 Kids, 30 Million Hours: Trump’s Vast Expansion of Child Detention<\/a>. The analysis confirms that more kids were held for 72 hours or more. For this lab, I was inspired to take the data from this analysis to recreate the charts and explore the data even further. <\/p>\n\n\n\n Through Data is Plural’s full archives<\/a>, I found datasets relatable to my field of interests revolving around U.S-Mexico border and found Child Detention<\/a><\/em> that referenced the project and dataset. The Marshall Project obtained public records from the U.S Customs and Border Protection in October, 2020 for the article mentioned above that both Anna Flagg and Andrew R. Calder\u00f3n worked on. The dataset has 583,808<\/strong> rows\/observations and a total of 11 features\/columns. <\/p>\n\n\n\n The dataset includes the following features: <\/p>\n\n\n I imported my .csv file into OpenRefine to make sure there weren’t any discrepancies within my data. For example, I found that the gender feature had four different labels “F- Female”, “M – Male”, “Female”, and “Male”. I clustered them into “Female” or “Male. There were also “NA” or “Unknown” categories and I was unsure how to interpret this so I removed them from my dataset. I attempted to find the abbreviations of the “border” feature but was not able to successfully to do. Once finished, I saved and exported my updated dataset.<\/p>\n\n\n\n I opened my updated dataset from OpenRefine onto Tableau Public and used The Marshall Project’s analysis report charts as a starting point on where I’d begin my exploration. Tableau Public is a software that makes it easy for the public to create data visualizations. <\/p>\n\n\n\n Using Color Brewer<\/a>, I used a 3 class color palette and implemented this theme onto my visualizations. My questions began with the same investigation focus that The Marshall Project took on. How often did the CBP violate the 72 hour limit imposed by 2008 Trafficking Victims Protection Reauthorization Act and 1977 settlement agreement known as Flores Act and how has that changed over the past couple of years? How many children were kept more than 72 hours? While thinking about this, I was curious to see which countries were among the highest of children seeking U.S asylum? What was the relationship between gender and country of origin? What was the largest age groups that were seeking refuge in the U.S?<\/p>\n\n\n\n As shown below, bar charts and line graphs were the optimal representations to portray the data given. <\/p>\n\n\n\n Similar to the original visualizations from the report, this chart illustrates the amount of children detained by day between Jan 17, 2017 and June 19, 2020. As noted in the graph, the highest peak of children registered into CBP was May 4, 2019. From those children, half spent 72 hours or more in custody. By January 2020, you can see a spiked decrease in children taken to custody. This would have to be explored further to analyze what factors have influenced this to happen. <\/p>\n\n\n\n This side by side bar graph illustrates the amount of hours children were in custody by year in CBP detention centers. The hours are grouped by intervals of 9. I chose 9 because it is easily divisible by 72 and that is an important mark throughout this analysis. I capped the bins to 144 hours, which equates to 3 days. However, I do have to emphasize that the data registers a larger range between 180 and 27,576 (1,149 days) a child has been kept in custody but when implemented to the graph are outliers. We can see a rapid growth of children being detained for more than 72 hours. <\/p>\n\n\n\n The following line graph illustrates the top three countries where children were escaping between 2017 and 2020 by gender. As annotated in the graph, 2019’s second quarter (April-June 30) was the peak where CBP received 21,390 young refugee girls from Hondura’s and 31,161 young male refugees from Guatemala. Since the countries differ and have brought significant numbers of the opposite sex. There is space to do further research on what was occurring in these two countries and how they were affecting the children to flee their country of origin. <\/p>\n\n\n\n The following bar graph displays the total amount of the children’s age groups between 2017 and 2020. If you group 0-5 year old children, it equates to 159,897 not too far from children who are within the age group of 15-18 years old. This begs to ask how many infant caretakers are there in the CBP facility to give adequate support and care for these children while they are in custody. Given the current skills I have developed utilizing Tableau, I was not able to fully replicate the original charts that were used in the report. I found myself gravitating towards geography and gender a lot but couldn’t create a chart that would portray those features strongly so I decided to put that aside from publishing. Throughout the process I discovered new features such as parameters and create a calculated features, hopefully I will implement in later projects. I did duplicate hours in custody<\/em> feature column and created bins for figure 3 above. As I analyzed the visualizations even further, more questions stirred that were outside the magnitude of what I had available to me. <\/p>\n\n\n\n \u201cTrump Detained More Migrant Children At The Border For Far Longer Than We Knew.\u201d The Marshall Project<\/em>, 30 Oct. 2020, https:\/\/www.themarshallproject.org\/2020\/10\/30\/500-000-kids-30-million-hours-trump-s-vast-expansion-of-child-detention<\/a>.<\/p>\n\n\n\n Paz, Rosario, et al. Do My Rights Matter? The Mistreatment Of Unaccompanied Children in CBP Custody<\/em>. Americans for Immigrant Justice, Oct. 2020, p. 74. Zotero<\/em>, https:\/\/aijustice.org\/wp-content\/uploads\/2020\/10\/Do-My-Rights-Matter-The-Mistreatment-of-Unaccompanied-Children-in-CBP-Custody.pdf<\/a>.<\/p>\n\n\n\n <\/p>\n\n\n\n \u201cFamily Separation under the Trump Administration \u2013 a Timeline.\u201d Southern Poverty Law Center<\/em>, https:\/\/www.splcenter.org\/news\/2020\/06\/17\/family-separation-under-trump-administration-timeline<\/a>. Accessed Oct. 2021.<\/p>\n\n\n\n
<\/p>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/10\/Screen-Shot-2021-10-24-at-15.46.35-1-1024x850.png?resize=840%2C697&ssl=1\")
<\/figure>\n<\/div>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/10\/Screen-Shot-2021-10-24-at-15.46.48-1024x732.png?resize=480%2C342&ssl=1\")
<\/figure>\n<\/div>\n<\/div>\n\n\n\nProcess<\/h2>\n\n\n\n
Data<\/h3>\n\n\n\n
\n
Selected tools<\/h3>\n\n\n\n
OpenRefine<\/a><\/h4>\n\n\n\n
Tableau Public<\/a><\/h4>\n\n\n\n
Analysis<\/h3>\n\n\n\n
<\/p>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/10\/Screen-Shot-2021-10-25-at-20.05.56.png?resize=487%2C91&ssl=1\")
<\/figure><\/div>\n\n\n\nResults<\/h3>\n\n\n\n
![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/10\/Children-Detained-in-U.S.-Customs-and-Border-Protection-a-Day-1024x560.png?resize=840%2C459&ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/10\/Hours-children-detained-by-year-1024x467.png?resize=840%2C382&ssl=1\")
<\/figure>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/10\/Sheet-8-1-1024x717.png?resize=840%2C588&ssl=1\")
<\/figure>\n\n\n\n
<\/p>\n\n\n\n![\"\"](\"https:\/\/i0.wp.com\/studentwork.prattsi.org\/infovis\/wp-content\/uploads\/sites\/3\/2021\/10\/Sheet-9-967x1024.png?resize=515%2C545&ssl=1\")
<\/figure><\/div>\n\n\n\n
<\/p>\n\n\n\nReflection<\/h2>\n\n\n\n
Citation<\/h2>\n\n\n\n
Related Articles<\/h2>\n\n\n\n