Name: Barcelona Data Sets
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

Barcelona Data Sets

Context

Data sets from the Open Data BCN portal, the Ajuntament de Barcelona's open data service.

Open Data BCN, a project that was born in 2010, implementing the portal in 2011, has evolved and is now part of the Barcelona Ciutat Digital strategy, fostering a pluralistic digital economy and developing a new model of urban innovation based on the transformation and digital innovation of the public sector and the implication among companies, administrations, the academic world, organizations, communities and people, with a clear public and citizen leadership.

You can check out more information about this amazing project in the following links:

Content

Demography

births.csv. Births by nationalities and by neighbourhoods of the city of Barcelona (2013-2017).
deaths.csv. Deaths by quinquennial ages and by neighbourhoods of the city of Barcelona (2015-2017).
population.csv. Population by neighbourhood, by quinquennial ages and by genre of the city of Barcelona (2013-2017). Reading registers of inhabitants.
unemployment.csv. Registered unemployement by neighbourhood and genre in the city of Barcelona (2013-2017).
immigrants_by_nationality.csv. Immigrants by nationality and by neighbourhoods of the city of Barcelona (2015-2017).
immigrants_emigrants_by_age.csv. Immigrants and emigrants by quinquennial ages and by neighbourhood of the city of Barcelona (2015-2017).
immigrants_emigrants_by_destination.csv. Immigrants and emigrants by place of origin and destination, respectively (2017).
immigrants_emigrants_by_destination2.csv. Immigrants and emigrants by place of origin and destination, respectively, and by neighbourhoods of the city of Barcelona (2017).
immigrants_emigrants_by_sex.csv. Immigrants and emigrants by sex by neighbourhoods of the city of Barcelona (2013-2017).
most_frequent_baby_names.csv. 25 Most common baby names in Barcelona, disaggregated by sex. Years 1996-2016.
most_frequent_names.csv. 50 Most common names of the inhabitants of Barcelona, disaggregated by decade of birth and sex.
life_expectancy.csv. Life expectancy in men and women of the city of Barcelona (2006-2013).

Accidents

accidents_2017.csv. List of accidents handled by the local police in the city of Barcelona. Incorporates the number of injuries by severity, the number of vehicles and the point of impact.

Environment

air_quality_Nov2017.csv. Air quality information of the city of Barcelona. Mesure data are showed of O3 (tropospheric Ozone), NO2 (Nitrogen dioxide), PM10 (Suspended particles).
air_stations_Nov2017.csv. Air quality measure stations of the city of Barcelona. Main characteristics of each one are detailed.

Transport

bus_stops.csv. Bus stops, day bus stops, night bus stops, airport bus stops of the city of Barcelona.
transports.csv. Public transports (underground, Renfe, FGC, funicular, cable car, tramcar, etc) of the city of Barcelona.

Acknowledgements

Open Data BCN

Barcelona City Council

Barcelona Digital City

Inspiration

Exploratory data analysis

Tables

Accidents 2017

@kaggle.xvivancos_barcelona_data_sets.accidents_2017

329.45 KB
10339 rows
15 columns


CREATE TABLE accidents_2017 (
  "id" VARCHAR,
  "district_name" VARCHAR,
  "neighborhood_name" VARCHAR,
  "street" VARCHAR,
  "weekday" VARCHAR,
  "month" VARCHAR,
  "day" BIGINT,
  "hour" BIGINT,
  "part_of_the_day" VARCHAR,
  "mild_injuries" BIGINT,
  "serious_injuries" BIGINT,
  "victims" BIGINT,
  "vehicles_involved" BIGINT,
  "longitude" DOUBLE,
  "latitude" DOUBLE
);

Air Quality Nov2017

@kaggle.xvivancos_barcelona_data_sets.air_quality_nov2017

42.16 KB
5744 rows
15 columns


CREATE TABLE air_quality_nov2017 (
  "station" VARCHAR,
  "air_quality" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "o3_hour" VARCHAR,
  "o3_quality" VARCHAR,
  "o3_value" DOUBLE,
  "no2_hour" VARCHAR,
  "no2_quality" VARCHAR,
  "no2_value" DOUBLE,
  "pm10_hour" VARCHAR,
  "pm10_quality" VARCHAR,
  "pm10_value" DOUBLE,
  "generated" VARCHAR,
  "date_time" BIGINT
);

Air Stations Nov2017

@kaggle.xvivancos_barcelona_data_sets.air_stations_nov2017

5.89 KB
8 rows
6 columns


CREATE TABLE air_stations_nov2017 (
  "station" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "ubication" VARCHAR,
  "district_name" VARCHAR,
  "neighborhood_name" VARCHAR
);

Births

@kaggle.xvivancos_barcelona_data_sets.births

9.7 KB
734 rows
7 columns


CREATE TABLE births (
  "year" BIGINT,
  "district_code" BIGINT,
  "district_name" VARCHAR,
  "neighborhood_code" BIGINT,
  "neighborhood_name" VARCHAR,
  "gender" VARCHAR,
  "number" BIGINT
);

Bus Stops

@kaggle.xvivancos_barcelona_data_sets.bus_stops

68.21 KB
3162 rows
7 columns


CREATE TABLE bus_stops (
  "code" VARCHAR,
  "transport" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "bus_stop" VARCHAR,
  "district_name" VARCHAR,
  "neighborhood_name" VARCHAR
);

Deaths

@kaggle.xvivancos_barcelona_data_sets.deaths

12.66 KB
4599 rows
7 columns


CREATE TABLE deaths (
  "year" BIGINT,
  "district_code" BIGINT,
  "district_name" VARCHAR,
  "neighborhood_code" BIGINT,
  "neighborhood_name" VARCHAR,
  "age" VARCHAR,
  "number" BIGINT
);

Immigrants By Nationality

@kaggle.xvivancos_barcelona_data_sets.immigrants_by_nationality

38.76 KB
35224 rows
7 columns


CREATE TABLE immigrants_by_nationality (
  "year" BIGINT,
  "district_code" BIGINT,
  "district_name" VARCHAR,
  "neighborhood_code" BIGINT,
  "neighborhood_name" VARCHAR,
  "nationality" VARCHAR,
  "number" BIGINT
);

Immigrants Emigrants By Age

@kaggle.xvivancos_barcelona_data_sets.immigrants_emigrants_by_age

21.34 KB
4662 rows
8 columns


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

Immigrants Emigrants By Destination

@kaggle.xvivancos_barcelona_data_sets.immigrants_emigrants_by_destination

3.42 KB
40 rows
3 columns


CREATE TABLE immigrants_emigrants_by_destination (
  "from" VARCHAR,
  "to" VARCHAR,
  "weight" BIGINT
);

Immigrants Emigrants By Destination2

@kaggle.xvivancos_barcelona_data_sets.immigrants_emigrants_by_destination2

4.78 KB
400 rows
3 columns


CREATE TABLE immigrants_emigrants_by_destination2 (
  "from" VARCHAR,
  "to" VARCHAR,
  "weight" BIGINT
);

Immigrants Emigrants By Sex

@kaggle.xvivancos_barcelona_data_sets.immigrants_emigrants_by_sex

14.33 KB
730 rows
8 columns


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
);

Life Expectancy

@kaggle.xvivancos_barcelona_data_sets.life_expectancy

9.15 KB
146 rows
7 columns


CREATE TABLE life_expectancy (
  "neighborhood" VARCHAR,
  "n_2006_2010" DOUBLE,
  "n_2007_2011" DOUBLE,
  "n_2008_2012" DOUBLE,
  "n_2009_2013" DOUBLE,
  "n_2010_2014" DOUBLE,
  "gender" VARCHAR
);

Most Frequent Baby Names

@kaggle.xvivancos_barcelona_data_sets.most_frequent_baby_names

7.57 KB
1050 rows
5 columns


CREATE TABLE most_frequent_baby_names (
  "order" BIGINT,
  "name" VARCHAR,
  "gender" VARCHAR,
  "year" BIGINT,
  "frequency" BIGINT
);

Most Frequent Names

@kaggle.xvivancos_barcelona_data_sets.most_frequent_names

11.88 KB
1100 rows
5 columns


CREATE TABLE most_frequent_names (
  "order" BIGINT,
  "name" VARCHAR,
  "gender" VARCHAR,
  "decade" VARCHAR,
  "frequency" BIGINT
);

Population

@kaggle.xvivancos_barcelona_data_sets.population

106.3 KB
70080 rows
8 columns


CREATE TABLE population (
  "year" BIGINT,
  "district_code" BIGINT,
  "district_name" VARCHAR,
  "neighborhood_code" BIGINT,
  "neighborhood_name" VARCHAR,
  "gender" VARCHAR,
  "age" VARCHAR,
  "number" BIGINT
);

Transports

@kaggle.xvivancos_barcelona_data_sets.transports

28.63 KB
651 rows
7 columns


CREATE TABLE transports (
  "code" VARCHAR,
  "transport" VARCHAR,
  "longitude" DOUBLE,
  "latitude" DOUBLE,
  "station" VARCHAR,
  "district_name" VARCHAR,
  "neighborhood_name" VARCHAR
);

Unemployment

@kaggle.xvivancos_barcelona_data_sets.unemployment

37.2 KB
14208 rows
9 columns


CREATE TABLE unemployment (
  "year" BIGINT,
  "month" VARCHAR,
  "district_code" BIGINT,
  "district_name" VARCHAR,
  "neighborhood_code" BIGINT,
  "neighborhood_name" VARCHAR,
  "gender" VARCHAR,
  "demand_occupation" VARCHAR,
  "number" BIGINT
);