[OC] DHS/ICE intentionally hiding locations of recruitment campaigns. EXPLODE(col) comes in clutch.

Analysis: ICE/DHS intentionally hiding locations recruitment campaigns. EXPLODE(col) the goat 💪

Spent hours figuring out how to extract which cities exactly ICE/DHS are currently targeting. TLDR: government positions will usually post a position PER location they are targeting. however, their positions for “Homeland Defender (Immigration Service Officer)” and “Immigration Judge” have the locations intentionally folded into a list.

explode(job_location) was really clutch here.

link to my analysis, I am neither affiliated with the open job data pool or ICE/DHS. Just an independent analyst trying to make a difference.