Refugees In The United States, 2006-2015
Where do most people granted refugee or asylum status come from?
@kaggle.dhs_refugee_report
Where do most people granted refugee or asylum status come from?
@kaggle.dhs_refugee_report
CREATE TABLE affirmative_asylum (
"continent_country_of_nationality" VARCHAR,
"n_2006" VARCHAR -- 2006,
"n_2007" VARCHAR -- 2007,
"n_2008" VARCHAR -- 2008,
"n_2009" VARCHAR -- 2009,
"n_2010" VARCHAR -- 2010,
"n_2011" VARCHAR -- 2011,
"n_2012" VARCHAR -- 2012,
"n_2013" VARCHAR -- 2013,
"n_2014" VARCHAR -- 2014,
"n_2015" VARCHAR -- 2015
);
CREATE TABLE asylum_statistics (
"sex_age_marital_status" VARCHAR,
"applicants" VARCHAR,
"spouses" VARCHAR,
"children" VARCHAR,
"all_asylum_recipients" BIGINT
);
CREATE TABLE defensive_asylum (
"continent_country_of_nationality" VARCHAR,
"n_2006" VARCHAR -- 2006,
"n_2007" VARCHAR -- 2007,
"n_2008" VARCHAR -- 2008,
"n_2009" VARCHAR -- 2009,
"n_2010" VARCHAR -- 2010,
"n_2011" VARCHAR -- 2011,
"n_2012" VARCHAR -- 2012,
"n_2013" VARCHAR -- 2013,
"n_2014" VARCHAR -- 2014,
"n_2015" VARCHAR -- 2015
);
CREATE TABLE refugee_statistics (
"sex_age_marital_status" VARCHAR,
"applicants" VARCHAR,
"spouses" VARCHAR,
"children" VARCHAR,
"all_refugees" BIGINT
);
CREATE TABLE refugee_status (
"continent_country_of_nationality" VARCHAR,
"n_2006" VARCHAR -- 2006,
"n_2007" VARCHAR -- 2007,
"n_2008" VARCHAR -- 2008,
"n_2009" VARCHAR -- 2009,
"n_2010" VARCHAR -- 2010,
"n_2011" VARCHAR -- 2011,
"n_2012" VARCHAR -- 2012,
"n_2013" VARCHAR -- 2013,
"n_2014" VARCHAR -- 2014,
"n_2015" VARCHAR -- 2015
);
Anyone who has the link will be able to view this.