I am working on a 550,000-person database published online by the New York Times that shows the placement of Unaccompanied Children across the U.S. by zip code from January 2015 to May 2023.

I am working on the data to disaggregate by zip code, city, and state. The forum helped me yesterday convert the zip code in text data to numeric form. I am now breaking down the data by state. This information could help local school districts and community social services be aware of and plan for how to help these children. They are officially classified as refugees by the Office of Refugee Resettlement in the Department of Health and Human Services.

If anyone is interested in collaborating on how to use Excel to analyze this data, I would be more than willing to discuss the data analysis needs and how you think we could best use Excel to do the analysis. You can connect with me via a private message on this forum or by replying to this post. Thanks.