Barcelona Data Sets

year Year	district_code District Code	district_name District Name	neighborhood_code Neighborhood Code	neighborhood_name Neighborhood Name	gender Gender	immigrants Immigrants	emigrants Emigrants
2017	1	Ciutat Vella	1	el Raval	Male	3063	1195
2017	1	Ciutat Vella	2	el Barri Gòtic	Male	1499	427
2017	1	Ciutat Vella	3	la Barceloneta	Male	910	361
2017	1	Ciutat Vella	4	Sant Pere, Santa Caterina i la Ribera	Male	1438	502
2017	2	Eixample	5	el Fort Pienc	Male	1082	495
2017	2	Eixample	6	la Sagrada Família	Male	1693	796
2017	2	Eixample	7	la Dreta de l'Eixample	Male	1543	666
2017	2	Eixample	8	l'Antiga Esquerra de l'Eixample	Male	1693	702
2017	2	Eixample	9	la Nova Esquerra de l'Eixample	Male	1927	925
2017	2	Eixample	10	Sant Antoni	Male	1253	632


CREATE TABLE immigrants_emigrants_by_sex (
  "year" BIGINT,
  "district_code" BIGINT,
  "district_name" VARCHAR,
  "neighborhood_code" BIGINT,
  "neighborhood_name" VARCHAR,
  "gender" VARCHAR,
  "immigrants" BIGINT,
  "emigrants" BIGINT
);