Missing Migrants Project
Data recorded between January 2014 and December 2021
@kaggle.snocco_missing_migrants_project
Data recorded between January 2014 and December 2021
@kaggle.snocco_missing_migrants_project
CREATE TABLE missingmigrants_global_2019_12_31_correct (
"web_id" BIGINT,
"region_of_incident" VARCHAR,
"reported_date" VARCHAR,
"reported_year" BIGINT,
"reported_month" VARCHAR,
"number_dead" DOUBLE,
"minimum_estimated_number_of_missing" DOUBLE,
"total_dead_and_missing" BIGINT,
"number_of_survivors" DOUBLE,
"number_of_females" DOUBLE,
"number_of_males" DOUBLE,
"number_of_children" DOUBLE,
"cause_of_death" VARCHAR,
"location_description" VARCHAR,
"information_source" VARCHAR,
"location_coordinates" VARCHAR,
"migration_route" VARCHAR,
"url" VARCHAR,
"unsd_geographical_grouping" VARCHAR,
"source_quality" BIGINT
);
CREATE TABLE mm_14_21 (
"unnamed_0" BIGINT,
"main_id" VARCHAR,
"incident_id" VARCHAR,
"region" VARCHAR,
"incident_date" VARCHAR,
"year" BIGINT,
"reported_month" VARCHAR,
"number_dead" DOUBLE,
"minimum_estimated_number_of_missing" DOUBLE,
"total_number_of_dead_and_missing" BIGINT,
"number_of_survivors" DOUBLE,
"number_of_females" DOUBLE,
"number_of_males" DOUBLE,
"number_of_children" DOUBLE,
"cause_of_death" VARCHAR,
"location_of_death" VARCHAR,
"information_source" VARCHAR,
"coordinates" VARCHAR,
"migrantion_route" VARCHAR,
"url" VARCHAR,
"unsd_geographical_grouping" VARCHAR,
"source_quality" DOUBLE
);
Anyone who has the link will be able to view this.