Border Crossing Entry Data Analysis

Examining Cross-Border Travel Patterns and Trends

@kaggle.kirbysasuke_border_crossing_data

Table List

1 table(3.47 MB)

Border Crossing Entry Data

@kaggle.kirbysasuke_border_crossing_data.border_crossing_entry_data

3.47 MB
392560 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
Roma	Texas	2310	US-Mexico Border	Dec 2023	Buses	46	26.404	-99.019	POINT (-99.018981 26.403928)
Del Rio	Texas	2302	US-Mexico Border	Dec 2023	Trucks	6552	29.327	-100.928	POINT (-100.927612 29.326784)
Roma	Texas	2310	US-Mexico Border	Nov 2023	Trucks	3753	26.404	-99.019	POINT (-99.018981 26.403928)
Douglas	Arizona	2601	US-Mexico Border	Oct 2023	Buses	13	31.334	-109.56	POINT (-109.560344 31.334043)
Beecher Falls	Vermont	206	US-Canada Border	Aug 2023	Trucks	422	45.013	-71.505	POINT (-71.505309 45.013411)
Laredo	Texas	2304	US-Mexico Border	Aug 2023	Buses	2843	27.5	-99.507	POINT (-99.507412 27.499561)
Morgan	Montana	3319	US-Canada Border	Aug 2023	Trucks	20	49	-107.832	POINT (-107.831819 48.999829)
Hidalgo	Texas	2305	US-Mexico Border	Aug 2023	Trucks	59677	26.095	-98.271	POINT (-98.271092 26.095032)
Raymond	Montana	3301	US-Canada Border	Jul 2023	Buses	3	48.999	-104.574	POINT (-104.574333 48.999194)
Roma	Texas	2310	US-Mexico Border	Jul 2023	Bus Passengers	949	26.404	-99.019	POINT (-99.018981 26.403928)


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
);