
I added a small but useful feature to our collection of infographics about the U.S.-Mexico border and migration, hosted at our Border Oversight website.
Now, it’s not just a pretty image of a chart: if you want the actual numbers, many pages now have a little link you can click to view the underlying data as a plain-HTML table. That table easily copies-and-pastes into any spreadsheet.
A few weeks ago U.S. Customs and Border Protection started sharing its migration data, going back to fiscal year 2020, as a downloadable dataset. The “data table” pages here query that dataset in an instant and save me an incredible amount of time building these graphics. And now, any time CBP uploads new data, I can grab it, upload it to the Border Oversight server, and all these little “data table” pages will update automatically.