Name: Illegal Immigrants Arrested By US Border Patrol
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Illegal Immigrants Arrested By US Border Patrol

Content

This report provides statistics for the number of illegal immigrants arrested or apprehended by the border patrol in each division (or sector) of the United States borders with Canada, Mexico, and Caribbean islands; this data is a partial measure of the flow of people illegally entering the United States.

Acknowledgements

Data was compiled and published by the US Border Patrol on the Customs and Border Protection webpage.

Tables

Arrests

@kaggle.cbp_illegal_immigrants.arrests

35.54 kB
25 rows
37 columns

CREATE TABLE arrests (
  "border" VARCHAR,
  "sector" VARCHAR,
  "state_territory" VARCHAR,
  "n_2000_all_illegal_immigrants" BIGINT  -- 2000 (All Illegal Immigrants),
  "n_2000_mexicans_only" BIGINT  -- 2000 (Mexicans Only),
  "n_2001_all_illegal_immigrants" BIGINT  -- 2001 (All Illegal Immigrants),
  "n_2001_mexicans_only" BIGINT  -- 2001 (Mexicans Only),
  "n_2002_all_illegal_immigrants" BIGINT  -- 2002 (All Illegal Immigrants),
  "n_2002_mexicans_only" BIGINT  -- 2002 (Mexicans Only),
  "n_2003_all_illegal_immigrants" BIGINT  -- 2003 (All Illegal Immigrants),
  "n_2003_mexicans_only" BIGINT  -- 2003 (Mexicans Only),
  "n_2004_all_illegal_immigrants" BIGINT  -- 2004 (All Illegal Immigrants),
  "n_2004_mexicans_only" BIGINT  -- 2004 (Mexicans Only),
  "n_2005_all_illegal_immigrants" BIGINT  -- 2005 (All Illegal Immigrants),
  "n_2005_mexicans_only" BIGINT  -- 2005 (Mexicans Only),
  "n_2006_all_illegal_immigrants" DOUBLE  -- 2006 (All Illegal Immigrants),
  "n_2006_mexicans_only" DOUBLE  -- 2006 (Mexicans Only),
  "n_2007_all_illegal_immigrants" DOUBLE  -- 2007 (All Illegal Immigrants),
  "n_2007_mexicans_only" DOUBLE  -- 2007 (Mexicans Only),
  "n_2008_all_illegal_immigrants" DOUBLE  -- 2008 (All Illegal Immigrants),
  "n_2008_mexicans_only" DOUBLE  -- 2008 (Mexicans Only),
  "n_2009_all_illegal_immigrants" DOUBLE  -- 2009 (All Illegal Immigrants),
  "n_2009_mexicans_only" DOUBLE  -- 2009 (Mexicans Only),
  "n_2010_all_illegal_immigrants" DOUBLE  -- 2010 (All Illegal Immigrants),
  "n_2010_mexicans_only" DOUBLE  -- 2010 (Mexicans Only),
  "n_2011_all_illegal_immigrants" DOUBLE  -- 2011 (All Illegal Immigrants),
  "n_2011_mexicans_only" DOUBLE  -- 2011 (Mexicans Only),
  "n_2012_all_illegal_immigrants" DOUBLE  -- 2012 (All Illegal Immigrants),
  "n_2012_mexicans_only" DOUBLE  -- 2012 (Mexicans Only),
  "n_2013_all_illegal_immigrants" DOUBLE  -- 2013 (All Illegal Immigrants),
  "n_2013_mexicans_only" DOUBLE  -- 2013 (Mexicans Only),
  "n_2014_all_illegal_immigrants" DOUBLE  -- 2014 (All Illegal Immigrants),
  "n_2014_mexicans_only" DOUBLE  -- 2014 (Mexicans Only),
  "n_2015_all_illegal_immigrants" DOUBLE  -- 2015 (All Illegal Immigrants),
  "n_2015_mexicans_only" DOUBLE  -- 2015 (Mexicans Only),
  "n_2016_all_illegal_immigrants" DOUBLE  -- 2016 (All Illegal Immigrants),
  "n_2016_mexicans_only" DOUBLE  -- 2016 (Mexicans Only)
);