Global Missing Migrants Dataset

Understanding Missing Migrants and Their Tragic Journeys

@kaggle.nelgiriyewithana_global_missing_migrants_dataset

Table List

1 table(628.66 KB)

Global Missing Migrants Dataset

@kaggle.nelgiriyewithana_global_missing_migrants_dataset.global_missing_migrants_dataset

628.66 KB
13020 rows
19 columns

incident_type Incident Type	incident_year Incident Year	reported_month Reported Month	region_of_origin Region Of Origin	region_of_incident Region Of Incident	country_of_origin Country Of Origin	number_of_dead Number Of Dead	total_number_of_dead_and_missing Total Number Of Dead And Missing	number_of_survivors Number Of Survivors	number_of_females Number Of Females	number_of_males Number Of Males	number_of_children Number Of Children	cause_of_death Cause Of Death	migration_route Migration Route	location_of_death Location Of Death	information_source Information Source	coordinates Coordinates	unsd_geographical_grouping UNSD Geographical Grouping
Incident	2014	January	Central America	North America	Guatemala	1	1			1		Mixed or unknown	US-Mexico border crossing	Pima Country Office of the Medical Examiner jurisdiction, Arizona, USA (see coordinates for exact location)	Pima County Office of the Medical Examiner (PCOME)	31.650259, -110.366453	Northern America
Incident	2014	January	Latin America / Caribbean (P)	North America	Unknown	1	1					Mixed or unknown	US-Mexico border crossing	Pima Country Office of the Medical Examiner jurisdiction, Arizona, USA (see coordinates for exact location)	Pima County Office of the Medical Examiner (PCOME)	31.59713, -111.73756	Northern America
Incident	2014	January	Latin America / Caribbean (P)	North America	Unknown	1	1					Mixed or unknown	US-Mexico border crossing	Pima Country Office of the Medical Examiner jurisdiction, Arizona, USA (see coordinates for exact location)	Pima County Office of the Medical Examiner (PCOME)	31.94026, -113.01125	Northern America
Incident	2014	January	Central America	North America	Mexico	1	1			1		Violence	US-Mexico border crossing	near Douglas, Arizona, USA	Ministry of Foreign Affairs Mexico, Pima County Office of the Medical Examiner (PCOME)	31.506777, -109.315632	Northern America
Incident	2014	January	Northern Africa	Europe	Sudan	1	1	2		1		Harsh environmental conditions / lack of adequate shelter, food, water	nan	Border between Russia and Estonia	EUBusiness (Agence France-Presse)	59.1551, 28	Northern Europe
Incident	2014	January	Latin America / Caribbean (P)	North America	Unknown	1	1					Violence	US-Mexico border crossing	Pima Country Office of the Medical Examiner jurisdiction, Arizona, USA (see coordinates for exact location)	Pima County Office of the Medical Examiner (PCOME)	32.45435, -113.18402	Northern America
Incident	2014	January	Unknown	Mediterranean	Afghanistan,Syrian Arab Republic	12	12		9		3	Drowning	Eastern Mediterranean	Waters near Greece while being towed back to Turkey	European Council on Refugees and Exiles	37.2832, 27	Uncategorized
Incident	2014	January	Latin America / Caribbean (P)	North America	Unknown	1	1					Mixed or unknown	US-Mexico border crossing	Pima Country Office of the Medical Examiner jurisdiction, Arizona, USA (see coordinates for exact location)	Pima County Office of the Medical Examiner (PCOME)	32.478317, -113.182833	Northern America
Incident	2014	January	Latin America / Caribbean (P)	North America	Unknown	1	1					Mixed or unknown	US-Mexico border crossing	Pima Country Office of the Medical Examiner jurisdiction, Arizona, USA (see coordinates for exact location)	Pima County Office of the Medical Examiner (PCOME)	31.81154, -111.01101	Northern America
Incident	2014	January	Latin America / Caribbean (P)	North America	Unknown	1	1					Mixed or unknown	US-Mexico border crossing	Pima Country Office of the Medical Examiner jurisdiction, Arizona, USA (see coordinates for exact location)	Pima County Office of the Medical Examiner (PCOME)	32.174017, -112.174583	Northern America


CREATE TABLE global_missing_migrants_dataset (
  "incident_type" VARCHAR,
  "incident_year" BIGINT,
  "reported_month" VARCHAR,
  "region_of_origin" VARCHAR,
  "region_of_incident" VARCHAR,
  "country_of_origin" VARCHAR,
  "number_of_dead" DOUBLE,
  "minimum_estimated_number_of_missing" BIGINT,
  "total_number_of_dead_and_missing" BIGINT,
  "number_of_survivors" BIGINT,
  "number_of_females" BIGINT,
  "number_of_males" BIGINT,
  "number_of_children" BIGINT,
  "cause_of_death" VARCHAR,
  "migration_route" VARCHAR,
  "location_of_death" VARCHAR,
  "information_source" VARCHAR,
  "coordinates" VARCHAR,
  "unsd_geographical_grouping" VARCHAR
);