Border Crossing Entry Data

Department of Transportation

@usgov.dot_gov_border_crossing_entry_data_683ae

Table List

1 table(3.58 MB)

Table 1

@usgov.dot_gov_border_crossing_entry_data_683ae.table_1

3.58 MB
400148 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
Jackman	Maine	104	US-Canada Border	Jan 2024	Trucks	6556	45.806	-70.397	POINT (-70.396722 45.805661)
Porthill	Idaho	3308	US-Canada Border	Apr 2024	Trucks	98	49	-116.499	POINT (-116.49925 48.999861)
San Luis	Arizona	2608	US-Mexico Border	Apr 2024	Buses	10	32.485	-114.782	POINT (-114.7822222 32.485)
Willow Creek	Montana	3325	US-Canada Border	Jan 2024	Pedestrians	2	49	-109.731	POINT (-109.731333 48.999972)
Warroad	Minnesota	3423	US-Canada Border	Jan 2024	Personal Vehicle Passengers	9266	48.999	-95.377	POINT (-95.376555 48.999)
Whitlash	Montana	3321	US-Canada Border	Jan 2024	Personal Vehicles	29	48.997	-111.258	POINT (-111.257916 48.99725)
Ysleta	Texas	2401	US-Mexico Border	Jan 2024	Personal Vehicle Passengers	521714	31.673	-106.335	POINT (-106.335449846028 31.6731261376859)
Warroad	Minnesota	3423	US-Canada Border	Jan 2024	Trucks	837	48.999	-95.377	POINT (-95.376555 48.999)
Wildhorse	Montana	3323	US-Canada Border	Jan 2024	Trucks	20	48.999	-110.215	POINT (-110.215083 48.999361)
Wildhorse	Montana	3323	US-Canada Border	Jan 2024	Personal Vehicle Passengers	965	48.999	-110.215	POINT (-110.215083 48.999361)


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