USA Banner

Official US Government Icon

Official websites use .gov
A .gov website belongs to an official government organization in the United States.

Secure Site Icon

Secure .gov websites use HTTPS
A lock ( ) or https:// means you’ve safely connected to the .gov website. Share sensitive information only on official, secure websites.

U.S. Department of Transportation U.S. Department of Transportation Icon United States Department of Transportation United States Department of Transportation

Border Crossing Data Instructions

Thursday, June 29, 2017

You can make selections such as Year, Month, Measure (i.e. Mode of Transportation), Border, State, and Port by checking desired boxes from each drop down menu and clicking “Apply”.  The data will then appear in a filtered format.

To access Border Crossing data in Socrata format from the new website, you should click on the “Download Data” link.  Then you should follow these steps:

  1. Click on the Filter Icon – a filter menu will then appear on the right side of the screen.
  2. Click on Sort & Roll-Up
  3. Select Roll-Ups & Drill-Downs
  4. For all of the columns that you want in the output, select in “Group By.”
  5. Select Date in “Group By,” then you will see a new drop down menu “Based On” – select year in that menu. 
  6. Under “Roll-Up,” select Value, then you will see a new drop down menu “Function” – select “Sum” in that menu
  7. Optional – you can use the “Sort” function to sort the results that you will see.  For example, you can sort by port name or state name.  Please note that you must spell the port name or state name correctly.

Click “Apply” to get the annual results from your selections.