Border Crossing Data Instructions
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:
- Click on the Filter Icon – a filter menu will then appear on the right side of the screen.
- Click on Sort & Roll-Up
- Select Roll-Ups & Drill-Downs
- For all of the columns that you want in the output, select in “Group By.”
- Select Date in “Group By,” then you will see a new drop down menu “Based On” – select year in that menu.
- Under “Roll-Up,” select Value, then you will see a new drop down menu “Function” – select “Sum” in that menu
- 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.