Data on Trends in U.S. Border Crossing Entry since 1996

Posted on Oct 21, 2019
The skills the author demoed here can be learned through taking Data Science with Machine Learning bootcamp with NYC Data Science Academy.
Author: Bee Kim


Since the 2016 election, online data shows inland U.S. Border security has been a major subject of debate. The construction of the new border wall has started, and the tension between Mexico and U.S. has intensified along with it. Many people predicted not only a decrease in number of illegal border entry but also a decrease in number of legal border entry which could hurt tourism and discourage the trade across the borders.

Currently at the end of 2019, three years after the 2016 election campaign, what can we learn from the statistics of inland U.S. Border entry? Did the political agenda affect the way people enter our country? I would like to answer these questions through visualizing the findings.


I used the dataset from . This data is originally collected by U.S. Customs and Border Protection (CBP) every quarter. It then gets cleaned, assessed and maintained by the Bureau of Transportation Statistics (BTS). It contains the statistics for inbound crossings at the U.S.-Canada and the U.S.-Mexico border at the port level for every month from the beginning of 1996. 

The original dataset includes 349,000 rows with 7 columns, classified as follows: Port Name, State, Port Code, Border, Date, Measure, Value and Location. Measure refers to the method of transportation used for border entry, which includes 12 different categories: Bus Passengers, Buses, Pedestrians, Personal Vehicle Passengers, Personal Vehicles, Rail Containers Empty, Rail Containers Full, Train Passengers, Trains, Truck Containers Empty, Truck Containers Full, Trucks. The values column includes the total number of crossings. 

It is important to be aware that this dataset doesn't count the number of unique vehicles, passengers or pedestrians but rather the number of crossings. For example, the same truck can go back and forth across the border many times a day and data for each time will be collected. Also this data doesn't include the nationality of the passengers or pedestrians or their reason for crossing the border. 

I used R package dplyr to clean the data. Criteria for Border Name was shortened as Canada and Mexico from U.S-Canada Border and U.S.-Mexico Border, and the Location column was divided into two sections: Longitude and Latitude. Also data from this year was excluded from the analysis as the data is not complete yet and that will not provide a good insight for this project. The exploratory data analysis (EDA) was done mostly using R package ggplot2 and leaflet. I used the ShinyDashboard to show the visualization and as a server to present the findings.

 ShinyApp / Data Analysis

Location of Border Ports

First I wanted to observe the location of border ports and their distribution across the U.S. to see the big picture.


Data on Trends in U.S. Border Crossing Entry since 1996


Data on Trends in U.S. Border Crossing Entry since 1996

There are a total of 116 ports in this dataset. Among those, 89 ports are in Canada Border and 27 ports are in Mexico Border. So there are about 3 times more ports in Canada Border compared to the Mexico Border. 

Data on Trends in U.S. Border Crossing Entry since 1996

However the number of total incoming from 1996 to 2018 showed total opposite as there were about 7 billions of total border crossing at Mexico Border while there were about 2.6 billions of total border crossing at the Canada Border. Even though there were more ports available in the northern border of U.S., there were fewer people coming in. 

Methods of Border Entry

Now moving on, I wanted to find out the methods of border entry and how it looks different between Canada border and Mexico border. 

Overall, most of the border entry was done in personal vehicles. Here, the Personal Vehicles column shows the numbers of personal cars entering the border, and the Personal Vehicle Passengers shows the number of people that were in the Personal Vehicles. The next highest value was surprisingly Pedestrians. Bus Passengers and Trucks follow that method. 

When the measure was compared between two borders, I could see a difference where the Mexico Border has a significant number of pedestrians whereas the Canada Border does not.

When I looked into the number of entries in different states, I could find a similar trend from the number of entries by two different Borders. More entries occur at the southern U.S. border, especially in Texas, California and Arizona. At the northern U.S. border, the large number of border entry was from New York and Michigan. 

Most of the southern states had a similar trend of entry transportation as Texas, as is shown on the left graph above: mostly containing the Personal Vehicle and Pedestrians.  For the northern states, it looked similar to the New York, as is shown on the right graph above. This indicates that the northern and southern borders differ a lot in terms of number of people walking into our country. 


Two exceptions to the statement were Alaska and Ohio. Alaska had more significant number of Bus Passengers and Train Passengers suggesting that most of the people coming into the U.S. from the Alaska border ports are travelers. Ohio, the state with the lowest number of border entry, was reported with only one method of transportation: Personal Vehicles. 

Change in Number of Trucks Entering

When I looked into the change in number of truck entering the U.S. at Canada and Mexico Borders, I saw some patterns. First, both the Canadian and Mexican sides had a sudden drop of number, as occurred in the year 2009. That was the year of global financial crisis. Trucks can be used for in-land trades and it is obvious from the graph above that the economy has a big impact on the border entry. Second, I was able to see the increase in the number of trucks entering at the Mexican border, possibly suggesting a better state of trade between the U.S. and Mexico. 

Pedestrians and Personal Vehicle Passengers

As I wanted to see the impact of the 2016 election to the local , I looked at the number of Pedestrians and Personal Vehicle Passengers over the years. Though it might have been expected that building the border wall would discourage the number of legal border entry in U.S.-Mexico border, the statistics show the increase in border entry. 

The number of incoming buses and bus passengers into the U.S. seem to be decreasing on both Canada and Mexico sides. Usually buses transport tourists, but as other methods of traveling such as flight and train have advanced over the years, use of bus as a method for traveling seems to have declined. 

Pedestrian and Train Passengers

Two methods of transportation used for border entry that look distinctly different were Pedestrian and Train Passengers. As seen in previous graphs, most of the pedestrians are coming into the U.S. from Mexico because it is easier to walk across the border in the southern side of the States. A train is used more often to enter from Canada, and the number of its use has been increasing. This increase in the use of trains can be related to the decreasing use of buses. 

The data shows that there is no distinction in transportation methods used for trade such as Truck, Truck Container Full, Rail Container Full observable according to the month of the year. These seem to have a steady number of incoming from both Mexico and Canada borders, no matter what month it is. This indicates that the business related border entry stays steady in all-year-around. 

However this changes when it comes to the transportation related to traveling such as Personal Vehicle Passengers, Bus Passengers and Train Passengers. Number of border entry in US-Canada increases significantly in summer months, while number of border entry in US-Mexico stays around same all-year-around. As the northern border get a harsh cold winter, it makes sense more people would opt to travel in the summer months. 

Conclusion / Further Research

From the visualization and statistics, the number of border entry depends on the economy and business rather on the political climate. However this dataset itself can't explain the reason behind the change in number of border entry as there are still many factors that need to be considered. For further research, I would like to obtain the data regarding the citizenship of people that enter the U.S. borders as well as their intention or the reason for the entry. This can further support how the economy or tourism affect the trend in the border entry. 

Thank you for reading my findings in U.S. Border Crossing Entry data. If you are interested in looking at the dataset I used, my ShinyApps, and the code, you can follow the links below. 





About Author

Bee Kim

Bee holds a masters degree in Information Systems with concentration in data analysis and is very passionate about storytelling through data. She is skilled in communication and critical thinking, with 5+ years of experience in analyzing and processing...
View all posts by Bee Kim >

Related Articles

Leave a Comment August 28, 2020 [...]just beneath, are various absolutely not related web-sites to ours, having said that, they're surely worth going over[...]
Trends in U.S. Border Crossing Entry since 1996 – Technology Revolution October 22, 2019
[…] October 22, 2019 By Donald Greer [This article was first published on R – NYC Data Science Academy Blog, and kindly contributed to R-bloggers]. (You can report issue about the content on this page […]

View Posts by Categories

Our Recent Popular Posts

View Posts by Tags

#python #trainwithnycdsa 2019 2020 Revenue 3-points agriculture air quality airbnb airline alcohol Alex Baransky algorithm alumni Alumni Interview Alumni Reviews Alumni Spotlight alumni story Alumnus ames dataset ames housing dataset apartment rent API Application artist aws bank loans beautiful soup Best Bootcamp Best Data Science 2019 Best Data Science Bootcamp Best Data Science Bootcamp 2020 Best Ranked Big Data Book Launch Book-Signing bootcamp Bootcamp Alumni Bootcamp Prep boston safety Bundles cake recipe California Cancer Research capstone car price Career Career Day citibike classic cars classpass clustering Coding Course Demo Course Report covid 19 credit credit card crime frequency crops D3.js data data analysis Data Analyst data analytics data for tripadvisor reviews data science Data Science Academy Data Science Bootcamp Data science jobs Data Science Reviews Data Scientist Data Scientist Jobs data visualization database Deep Learning Demo Day Discount disney dplyr drug data e-commerce economy employee employee burnout employer networking environment feature engineering Finance Financial Data Science fitness studio Flask flight delay gbm Get Hired ggplot2 googleVis H20 Hadoop hallmark holiday movie happiness healthcare frauds higgs boson Hiring hiring partner events Hiring Partners hotels housing housing data housing predictions housing price hy-vee Income Industry Experts Injuries Instructor Blog Instructor Interview insurance italki Job Job Placement Jobs Jon Krohn JP Morgan Chase Kaggle Kickstarter las vegas airport lasso regression Lead Data Scienctist Lead Data Scientist leaflet league linear regression Logistic Regression machine learning Maps market matplotlib Medical Research Meet the team meetup methal health miami beach movie music Napoli NBA netflix Networking neural network Neural networks New Courses NHL nlp NYC NYC Data Science nyc data science academy NYC Open Data nyc property NYCDSA NYCDSA Alumni Online Online Bootcamp Online Training Open Data painter pandas Part-time performance phoenix pollutants Portfolio Development precision measurement prediction Prework Programming public safety PwC python Python Data Analysis python machine learning python scrapy python web scraping python webscraping Python Workshop R R Data Analysis R language R Programming R Shiny r studio R Visualization R Workshop R-bloggers random forest Ranking recommendation recommendation system regression Remote remote data science bootcamp Scrapy scrapy visualization seaborn seafood type Selenium sentiment analysis sentiment classification Shiny Shiny Dashboard Spark Special Special Summer Sports statistics streaming Student Interview Student Showcase SVM Switchup Tableau teachers team team performance TensorFlow Testimonial tf-idf Top Data Science Bootcamp Top manufacturing companies Transfers tweets twitter videos visualization wallstreet wallstreetbets web scraping Weekend Course What to expect whiskey whiskeyadvocate wildfire word cloud word2vec XGBoost yelp youtube trending ZORI