Barcelona Data Sets

id Id	district_name District Name	neighborhood_name Neighborhood Name	street Street	weekday Weekday	month Month	day Day	hour Hour	part_of_the_day Part Of The Day	mild_injuries Mild Injuries	victims Victims	vehicles_involved Vehicles Involved	longitude Longitude	latitude Latitude
2017S008429	Unknown	Unknown	Número 27	Friday	October	13	8	Morning	2	2	2	2.12562442	41.34004482
2017S007316	Unknown	Unknown	Número 3 Zona Franca / Número 50 Zona Franca	Friday	September	1	13	Morning	2	2	2	2.12045245	41.33942606
2017S010210	Unknown	Unknown	Litoral (Besòs)	Friday	December	8	21	Afternoon	5	5	2	2.1673561	41.3608855
2017S006364	Unknown	Unknown	Número 3 Zona Franca	Friday	July	21	2	Night	1	1	2	2.12452894	41.33766786
2017S004615	Sant Martí	el Camp de l'Arpa del Clot	Las Navas de Tolosa	Thursday	May	25	14	Afternoon	1	1	3	2.185272	41.416365
2017S007775	Sant Martí	el Camp de l'Arpa del Clot	Indústria / Trinxant	Wednesday	September	20	12	Morning	1	1	2	2.183245	41.416336
2017S004484	Sant Martí	el Camp de l'Arpa del Clot	Trinxant / Indústria	Saturday	May	20	21	Afternoon	1	1	2	2.183245	41.416336
2017S010680	Sant Martí	el Camp de l'Arpa del Clot	Indústria	Tuesday	December	26	20	Afternoon	2	2	1	2.183561	41.416372
2017S005152	Sant Martí	el Camp de l'Arpa del Clot	Indústria	Monday	June	12	15	Afternoon	1	1	1	2.184059	41.416763
2017S003932	Sant Martí	el Camp de l'Arpa del Clot	Maragall	Wednesday	May	3	20	Afternoon	1	1	1	2.181225	41.413958


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