Migration From Mexico To USA Data

Migration information from 2000

@kaggle.arturogranados_migration_from_mexico_to_usa_data

Table List

1 table(148.23 KB)

Migration Intensity Index

@kaggle.arturogranados_migration_from_mexico_to_usa_data.migration_intensity_index

148.23 KB
2443 rows
10 columns

fe_id FE ID	mun_id MUN ID	mun_name MUN NAME	tot_huo TOT HUO	hou_rem HOU REM	hou_rem_last_5_years HOU REM LAST 5 YEARS	hou_cir HOU CIR	hou_ret HOU RET	iim_2000 IIM 2000	gim_2000 GIM 2000
1	1	Aguascalientes	147269	4.238502332	3.873863474	1.533248681	1.043668389	-0.186801089	Low
1	2	Asientos	7010	15.9914408	15.36376605	6.119828816	2.068473609	1.495801512	High
1	3	Calvillo	10746	16.49916248	18.65810534	11.94863205	5.527638191	2.903187006	Very high
1	4	Cosío	2668	8.695652174	8.508245877	3.785607196	1.011994003	0.452551219	Medium
1	5	Jesús María	12692	8.974156949	10.06145604	1.772770249	1.221241727	0.338265401	Medium
1	6	Pabellón De Arteaga	6794	13.9387695	9.214012364	3.488372093	1.898734177	0.808897741	High
1	7	Rincón De Romos	8191	7.996581614	10.38945184	4.663655231	2.771334391	0.900715515	High
1	8	San José De Gracia	1534	13.62451108	11.99478488	3.389830508	2.998696219	1.092001836	High
1	9	Tepezalá	3354	18.48539058	23.04710793	3.100775194	1.37149672	1.480294203	High
1	10	Llano, El	3000	11.26666667	16.8	11.83333333	1.133333333	1.86668334	High


CREATE TABLE migration_intensity_index (
  "fe_id" BIGINT,
  "mun_id" BIGINT,
  "mun_name" VARCHAR,
  "tot_huo" BIGINT,
  "hou_rem" DOUBLE,
  "hou_rem_last_5_years" DOUBLE,
  "hou_cir" DOUBLE,
  "hou_ret" DOUBLE,
  "iim_2000" DOUBLE,
  "gim_2000" VARCHAR
);