Baselight
Sign In

Border Crossing Dataset

Border activity between the United States and neighboring countries

@kaggle.sahirmaharajj_border_crossing_dataset

Border Crossing Entry Data
@kaggle.sahirmaharajj_border_crossing_dataset.border_crossing_entry_data

  • 3.45 MB
  • 390305 rows
  • 10 columns
port_name

Port Name

state

State

port_code

Port Code

border

Border

date

Date

measure

Measure

value

Value

latitude

Latitude

longitude

Longitude

point

Point

RomaTexas2310US-Mexico BorderDec 2023Buses4626.404-99.019POINT (-99.018981 26.403928)
Del RioTexas2302US-Mexico BorderDec 2023Trucks655229.327-100.928POINT (-100.927612 29.326784)
Willow CreekMontana3325US-Canada BorderJan 2024Pedestrians249-109.731POINT (-109.731333 48.999972)
WhitlashMontana3321US-Canada BorderJan 2024Personal Vehicles2948.997-111.258POINT (-111.257916 48.99725)
YsletaTexas2401US-Mexico BorderJan 2024Personal Vehicle Passengers52171431.673-106.335POINT (-106.335449846028 31.6731261376859)
WarroadMinnesota3423US-Canada BorderJan 2024Trucks83748.999-95.377POINT (-95.376555 48.999)
WildhorseMontana3323US-Canada BorderJan 2024Trucks2048.999-110.215POINT (-110.215083 48.999361)
WildhorseMontana3323US-Canada BorderJan 2024Personal Vehicle Passengers96548.999-110.215POINT (-110.215083 48.999361)
WesthopeNorth Dakota3419US-Canada BorderJan 2024Truck Containers Loaded10249-101.017POINT (-101.017277 48.999611)
WarroadMinnesota3423US-Canada BorderJan 2024Truck Containers Loaded45948.999-95.377POINT (-95.376555 48.999)

CREATE TABLE border_crossing_entry_data (
  "port_name" VARCHAR,
  "state" VARCHAR,
  "port_code" BIGINT,
  "border" VARCHAR,
  "date" VARCHAR,
  "measure" VARCHAR,
  "value" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "point" VARCHAR
);